Fmstrat
Errors using the updated script.
Using the newly updated script I am getting the following errors:
/root/plex-db-sync: line 111: [: too many arguments [Fri Jun 7 07:13:18 EDT 2019] Stopping Plex on Server 1... Done [Fri Jun 7 07:13:20 EDT 2019] Stopping Plex on Server 2... Done [Fri Jun 7 07:13:33 EDT 2019] Checking for changes... Found Error: near line 1: table "metadata_item_settings" already exists Error: near line 1: table "metadata_items" already exists Error: near line 1: table "taggings" already exists Error: near line 1: table "tags" already exists Error: near line 1: no such table: tmpdb.metadata_item_settings1 Error: near line 1: no such table: tmpdb.metadata_item_settings2 [Fri Jun 7 07:13:35 EDT 2019] Processing tags... Error: no such table: taggings1 Error: no such table: taggings1 Error: no such table: taggings2 Error: no such table: taggings2 [Fri Jun 7 07:13:35 EDT 2019] Processing for (0)... [Fri Jun 7 07:13:35 EDT 2019] - Checking records that are in both databases Error: no such table: metadata_item_settings1
Thanks using the fix I don't get the argument error anymore but I am still receiving the other errors. Do you have any idea why its happening? I removed the 1-136 setting server from the log below to shorten it up.
[Sat Jun 8 07:21:54 EDT 2019] Starting. [Sat Jun 8 07:21:59 EDT 2019] Stopping Plex on Server 1... Done [Sat Jun 8 07:22:06 EDT 2019] Stopping Plex on Server 2... Done [Sat Jun 8 07:22:36 EDT 2019] Checking for changes... Found Error: near line 1: table "metadata_item_settings" already exists Error: near line 1: table "metadata_items" already exists Error: near line 1: table "taggings" already exists Error: near line 1: table "tags" already exists Error: near line 1: no such table: tmpdb.metadata_item_settings1 Error: near line 1: no such table: tmpdb.metadata_item_settings2 [Sat Jun 8 07:22:39 EDT 2019] Processing tags... Error: no such table: taggings1 Error: no such table: taggings1 Error: no such table: taggings2 Error: no such table: taggings2 [Sat Jun 8 07:22:40 EDT 2019] Processing for (0)... [Sat Jun 8 07:22:40 EDT 2019] - Checking records that are in both databases Error: no such table: metadata_item_settings1 [Sat Jun 8 07:22:40 EDT 2019] - (0/136) Setting server 2 status for: [Sat Jun 8 07:22:40 EDT 2019] - (135/136) Setting server 2 status for: [Sat Jun 8 07:22:40 EDT 2019] - Checking records missing from server 2 Error: no such table: metadata_item_settings1 [Sat Jun 8 07:22:40 EDT 2019] - (0/136) Setting server 2 status for: [Sat Jun 8 07:22:41 EDT 2019] - (135/136) Setting server 2 status for: [Sat Jun 8 07:22:41 EDT 2019] - Checking records missing from server 1 Error: no such table: metadata_item_settings2
Still receiving some errors, I am using media server V 1.15.8.1198 on Ubuntu if that helps.
[Sun Jun 9 08:00:49 EDT 2019] Starting. [Sun Jun 9 08:00:50 EDT 2019] Stopping Plex on Server 1... Done [Sun Jun 9 08:00:57 EDT 2019] Stopping Plex on Server 2... Done [Sun Jun 9 08:01:20 EDT 2019] Checking for changes... Found Error: near line 1: table "metadata_item_settings" already exists Error: near line 1: table "metadata_items" already exists Error: near line 1: table "taggings" already exists Error: near line 1: table "tags" already exists Error: near line 1: no such table: tmpdb.metadata_item_settings1 Error: near line 1: no such table: tmpdb.metadata_item_settings2 [Sun Jun 9 08:01:22 EDT 2019] Processing tags... Error: no such table: taggings1 Error: no such table: taggings1 Error: no such table: taggings2 Error: no such table: taggings2 [Sun Jun 9 08:01:22 EDT 2019] Processing for (0)... [Sun Jun 9 08:01:22 EDT 2019] - Checking records that are in both databases Error: no such table: metadata_item_settings1
./plex-db-sync --plex-db-1 "/home/databases1/com.plexapp.plugins.library.db" --plex-start-1 "ssh [email protected] service plexmediaserver start" --plex-stop-1 "ssh [email protected] service plexmediaserver stop" --plex-db-2 "/home/database2/com.plexapp.plugins.library.db" --plex-start-2 "ssh [email protected] service plexmediaserver start" --plex-stop-2 "ssh [email protected] service plexmediaserver stop" --debug true [Mon Jun 10 07:15:45 EDT 2019] Starting. [Mon Jun 10 07:15:45 EDT 2019] TMPFOLDER: /tmp/plex-db-sync [Mon Jun 10 07:15:45 EDT 2019] DEBUG: true [Mon Jun 10 07:15:45 EDT 2019] PLEXDB1: /home/databases1/com.plexapp.plugins.library.db [Mon Jun 10 07:15:45 EDT 2019] PLEXDB2: /home/databases2/com.plexapp.plugins.library.db [Mon Jun 10 07:15:45 EDT 2019] PLEXSTART1: ssh [email protected] service plexmediaserver start [Mon Jun 10 07:15:45 EDT 2019] PLEXSTOP1: ssh [email protected] service plexmediaserver stop [Mon Jun 10 07:15:45 EDT 2019] PLEXSTART2: ssh [email protected] service plexmediaserver start [Mon Jun 10 07:15:45 EDT 2019] PLEXSTOP2: ssh [email protected] service plexmediaserver stop [Mon Jun 10 07:15:45 EDT 2019] PLEXF1: /tmp/plex-db-sync/1.sql [Mon Jun 10 07:15:45 EDT 2019] PLEXF2: /tmp/plex-db-sync/2.sql [Mon Jun 10 07:15:45 EDT 2019] TMPDB: /tmp/plex-db-sync/tmp.db [Mon Jun 10 07:15:45 EDT 2019] IGNORE: [Mon Jun 10 07:15:45 EDT 2019] IGNORESTR: [Mon Jun 10 07:15:45 EDT 2019] BACKUP: false [Mon Jun 10 07:15:46 EDT 2019] version db1: 20190403100000 db2: 20190403100000 [Mon Jun 10 07:15:46 EDT 2019] Stopping Plex on Server 1... Done [Mon Jun 10 07:15:50 EDT 2019] Stopping Plex on Server 2... Done [Mon Jun 10 07:16:19 EDT 2019] Checking for changes... [Mon Jun 10 07:16:21 EDT 2019] UP1: 2019-06-10 07:15:46 - UP2: 2019-06-10 07:15:46 [Mon Jun 10 07:16:21 EDT 2019] CH1: 169570936 - CH2: 169165234 Found Error: near line 1: table "metadata_item_settings" already exists Error: near line 1: table "metadata_items" already exists Error: near line 1: table "taggings" already exists Error: near line 1: table "tags" already exists Error: near line 1: no such table: tmpdb.metadata_item_settings1 Error: near line 1: no such table: tmpdb.metadata_item_settings2 [Mon Jun 10 07:16:21 EDT 2019] Processing tags... [Mon Jun 10 07:16:21 EDT 2019] -=-: select distinct t1.* from taggings1 ts1, tags1 t1, metadata_items1 m1 where ts1.tag_id=t1.id and ts1.metadata_item_id=m1.id and t1.tag_type=11 and m1.guid in (select guid from metadata_items2) and t1.tag not in (select tag from tags2); Error: no such table: taggings1 [Mon Jun 10 07:16:21 EDT 2019] -=-: select ts1., t1.tag, m1.guid from taggings1 ts1, tags1 t1, metadata_items1 m1 where ts1.tag_id=t1.id and ts1.metadata_item_id=m1.id and t1.tag_type=11 and m1.guid in (select guid from metadata_items2) and m1.guid not in (select distinct m2.guid from taggings2 ts2, tags2 t2, metadata_items2 m2 where ts2.tag_id=t2.id and ts2.metadata_item_id=m2.id and t2.tag_type=11 and t2.tag=t1.tag); Error: no such table: taggings1 [Mon Jun 10 07:16:21 EDT 2019] -=-: select distinct t2. from taggings2 ts2, tags2 t2, metadata_items2 m2 where ts2.tag_id=t2.id and ts2.metadata_item_id=m2.id and t2.tag_type=11 and m2.guid in (select guid from metadata_items1) and t2.tag not in (select tag from tags1); Error: no such table: taggings2 [Mon Jun 10 07:16:21 EDT 2019] -=-: select ts2.*, t2.tag, m2.guid from taggings2 ts2, tags2 t2, metadata_items2 m2 where ts2.tag_id=t2.id and ts2.metadata_item_id=m2.id and t2.tag_type=11 and m2.guid in (select guid from metadata_items1) and m2.guid not in (select distinct m1.guid from taggings1 ts1, tags1 t1, metadata_items1 m1 where ts1.tag_id=t1.id and ts1.metadata_item_id=m1.id and t1.tag_type=11 and t1.tag=t2.tag); Error: no such table: taggings2 [Mon Jun 10 07:16:21 EDT 2019] -=-: select id, name from accounts where lower(name) not in () order by id; [Mon Jun 10 07:16:21 EDT 2019] -=-: select id, name from accounts where lower(name) not in () order by id; [Mon Jun 10 07:16:22 EDT 2019] Processing for (0)... [Mon Jun 10 07:16:22 EDT 2019] - Checking records that are in both databases [Mon Jun 10 07:16:22 EDT 2019] -=-: select s1.guid, s1.id as id1, s1.updated_at as updated_at1, s1.view_count as view_count1, s1.last_viewed_at as last_viewed_at1, s1.view_offset as view_offset1, s1.changed_at as changed_at1, s2.id as id2, s2.updated_at as updated_at2, s2.view_count as view_count2, s2.last_viewed_at as last_viewed_at2, s2.view_offset as view_offset2, s2.changed_at as changed_at2 from metadata_item_settings1 s1, metadata_item_settings2 s2 where s1.guid=s2.guid and s1.account_id=s2.account_id and s1.account_id=0 and (s1.view_count != s2.view_count or s1.last_viewed_at != s2.last_viewed_at or s1.view_offset != s2.view_offset or s1.changed_at != s2.changed_at); Error: no such table: metadata_item_settings1
sqlite3 version 3.11.0 this is from the debug-verbose script.
[Tue Jun 11 06:49:23 EDT 2019] PLEXF1: /tmp/plex-db-sync/1.sql [Tue Jun 11 06:49:23 EDT 2019] PLEXF2: /tmp/plex-db-sync/2.sql [Tue Jun 11 06:49:23 EDT 2019] TMPDB: /tmp/plex-db-sync/tmp.db [Tue Jun 11 06:49:23 EDT 2019] IGNORE: [Tue Jun 11 06:49:23 EDT 2019] IGNORESTR: [Tue Jun 11 06:49:23 EDT 2019] BACKUP: false [Tue Jun 11 06:49:23 EDT 2019] version db1: 20190403100000 db2: 20190403100000 [Tue Jun 11 06:49:23 EDT 2019] Stopping Plex on Server 1... Done [Tue Jun 11 06:49:23 EDT 2019] Stopping Plex on Server 2... Done [Tue Jun 11 06:49:27 EDT 2019] Checking for changes... [Tue Jun 11 06:49:28 EDT 2019] UP1: 2019-06-11 06:46:43 - UP2: 2019-06-11 03:17:11 Found [Tue Jun 11 06:49:28 EDT 2019] Running createTmpDB [Tue Jun 11 06:49:28 EDT 2019] running CREATE TABLE "metadata_item_settings" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "account_id" integer, "guid" varchar(255), "rating" float, "view_offset" integer, "view_count" integer, "last_viewed_at" datetime, "created_at" datetime, "updated_at" datetime, "skip_count" integer DEFAULT 0, "last_skipped_at" datetime DEFAULT NULL, "changed_at" integer(8) DEFAULT 0, 'extra_data' varchar(255)); in Error: near line 1: table "metadata_item_settings" already exists Error: near line 1: table "metadata_items" already exists Error: near line 1: table "taggings" already exists Error: near line 1: table "tags" already exists Error: near line 1: no such table: tmpdb.metadata_item_settings1 Error: near line 1: no such table: tmpdb.metadata_item_settings2 [Tue Jun 11 06:49:28 EDT 2019] Processing tags... [Tue Jun 11 06:49:28 EDT 2019] -=-: select distinct t1.* from taggings1 ts1, tags1 t1, metadata_items1 m1 where ts1.tag_id=t1.id and ts1.metadata_item_id=m1.id and t1.tag_type=11 and m1.guid in (select guid from metadata_items2) and t1.tag not in (select tag from tags2); Error: no such table: taggings1 [Tue Jun 11 06:49:28 EDT 2019] -=-: select ts1., t1.tag, m1.guid from taggings1 ts1, tags1 t1, metadata_items1 m1 where ts1.tag_id=t1.id and ts1.metadata_item_id=m1.id and t1.tag_type=11 and m1.guid in (select guid from metadata_items2) and m1.guid not in (select distinct m2.guid from taggings2 ts2, tags2 t2, metadata_items2 m2 where ts2.tag_id=t2.id and ts2.metadata_item_id=m2.id and t2.tag_type=11 and t2.tag=t1.tag); Error: no such table: taggings1 [Tue Jun 11 06:49:28 EDT 2019] -=-: select distinct t2. from taggings2 ts2, tags2 t2, metadata_items2 m2 where ts2.tag_id=t2.id and ts2.metadata_item_id=m2.id and t2.tag_type=11 and m2.guid in (select guid from metadata_items1) and t2.tag not in (select tag from tags1); Error: no such table: taggings2 [Tue Jun 11 06:49:28 EDT 2019] -=-: select ts2.*, t2.tag, m2.guid from taggings2 ts2, tags2 t2, metadata_items2 m2 where ts2.tag_id=t2.id and ts2.metadata_item_id=m2.id and t2.tag_type=11 and m2.guid in (select guid from metadata_items1) and m2.guid not in (select distinct m1.guid from taggings1 ts1, tags1 t1, metadata_items1 m1 where ts1.tag_id=t1.id and ts1.metadata_item_id=m1.id and t1.tag_type=11 and t1.tag=t2.tag); Error: no such table: taggings2 [Tue Jun 11 06:49:28 EDT 2019] -=-: select id, name from accounts where lower(name) not in () order by id; [Tue Jun 11 06:49:28 EDT 2019] -=-: select id, name from accounts where lower(name) not in () order by id; [Tue Jun 11 06:49:28 EDT 2019] Processing for (0)... [Tue Jun 11 06:49:28 EDT 2019] - Checking records that are in both databases [Tue Jun 11 06:49:28 EDT 2019] -=-: select s1.guid, s1.id as id1, s1.updated_at as updated_at1, s1.view_count as view_count1, s1.last_viewed_at as last_viewed_at1, s1.view_offset as view_offset1, s1.changed_at as changed_at1, s2.id as id2, s2.updated_at as updated_at2, s2.view_count as view_count2, s2.last_viewed_at as last_viewed_at2, s2.view_offset as view_offset2, s2.changed_at as changed_at2 from metadata_item_settings1 s1, metadata_item_settings2 s2 where s1.guid=s2.guid and s1.account_id=s2.account_id and s1.account_id=0 and (s1.view_count != s2.view_count or s1.last_viewed_at != s2.last_viewed_at or s1.view_offset != s2.view_offset or s1.changed_at != s2.changed_at); Error: no such table: metadata_item_settings1
can you run this command please : echo 'test "value1"'|sed -e 's,test "value1",test "value2",g'
This is the result of that command
test "value2"
BTW I really appreciate you helping me with this, do you have a donation link?
Errors are a bit different this time :)
[Sun Jun 16 05:55:51 EDT 2019] Starting. [Sun Jun 16 05:55:52 EDT 2019] Stopping Plex on Server 1... Done [Sun Jun 16 05:56:05 EDT 2019] Stopping Plex on Server 2... Done [Sun Jun 16 05:56:23 EDT 2019] Checking for changes... Found Error: incomplete SQL: CREATE TABLE "metadata_item_settings1" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "account_id" integer, "guid" varchar(255), "rating" float, "view_offset" integer, "view_count" integer, "last_viewed_at" datetime, "created_at" datetime, "updated_at" datetime, "skip_count" integer DEFAULT 0, "last_skipped_at" datetime DEFAULT NULL, "changed_at" integer(8) DEFAULT 0, 'extra_data' varchar(255)) Error: incomplete SQL: CREATE TABLE "metadata_item_settings2" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "account_id" integer, "guid" varchar(255), "rating" float, "view_offset" integer, "view_count" integer, "last_viewed_at" datetime, "created_at" datetime, "updated_at" datetime, "skip_count" integer DEFAULT 0, "last_skipped_at" datetime DEFAULT NULL, "changed_at" integer(8) DEFAULT 0, 'extra_data' varchar(255)) Error: incomplete SQL: CREATE TABLE "metadata_items1" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "library_section_id" integer, "parent_id" integer, "metadata_type" integer, "guid" varchar(255), "media_item_count" integer, "title" varchar(255), "title_sort" varchar(255) COLLATE NOCASE, "original_title" varchar(255), "studio" varchar(255), "rating" float, "rating_count" integer, "tagline" varchar(255), "summary" text, "trivia" text, "quotes" text, "content_rating" varchar(255), "content_rating_age" integer, "index" integer, "absolute_index" integer, "duration" integer, "user_thumb_url" varchar(255), "user_art_url" varchar(255), "user_banner_url" varchar(255), "user_music_url" varchar(255), "user_fields" varchar(255), "tags_genre" varchar(255), "tags_collection" varchar(255), "tags_director" varchar(255), "tags_writer" varchar(255), "tags_star" varchar(255), "originally_available_at" datetime, "available_at" datetime, "expires_at" datetime, "refreshed_at" datetime, "year" integer, "added_at" datetime, "created_at" datetime, "updated_at" datetime, "deleted_at" datetime, "tags_country" varchar(255), "extra_data" varchar(255), "hash" varchar(255), "audience_rating" float, "changed_at" integer(8) DEFAULT 0, "resources_changed_at" integer(8) DEFAULT 0, 'remote' integer) Error: incomplete SQL: CREATE TABLE "metadata_items2" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "library_section_id" integer, "parent_id" integer, "metadata_type" integer, "guid" varchar(255), "media_item_count" integer, "title" varchar(255), "title_sort" varchar(255) COLLATE NOCASE, "original_title" varchar(255), "studio" varchar(255), "rating" float, "rating_count" integer, "tagline" varchar(255), "summary" text, "trivia" text, "quotes" text, "content_rating" varchar(255), "content_rating_age" integer, "index" integer, "absolute_index" integer, "duration" integer, "user_thumb_url" varchar(255), "user_art_url" varchar(255), "user_banner_url" varchar(255), "user_music_url" varchar(255), "user_fields" varchar(255), "tags_genre" varchar(255), "tags_collection" varchar(255), "tags_director" varchar(255), "tags_writer" varchar(255), "tags_star" varchar(255), "originally_available_at" datetime, "available_at" datetime, "expires_at" datetime, "refreshed_at" datetime, "year" integer, "added_at" datetime, "created_at" datetime, "updated_at" datetime, "deleted_at" datetime, "tags_country" varchar(255), "extra_data" varchar(255), "hash" varchar(255), "audience_rating" float, "changed_at" integer(8) DEFAULT 0, "resources_changed_at" integer(8) DEFAULT 0, 'remote' integer) Error: incomplete SQL: CREATE TABLE "taggings1" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "metadata_item_id" integer, "tag_id" integer, "index" integer, "text" varchar(255), "time_offset" integer, "end_time_offset" integer, "thumb_url" varchar(255), "created_at" datetime, "extra_data" varchar(255)) Error: incomplete SQL: CREATE TABLE "taggings2" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "metadata_item_id" integer, "tag_id" integer, "index" integer, "text" varchar(255), "time_offset" integer, "end_time_offset" integer, "thumb_url" varchar(255), "created_at" datetime, "extra_data" varchar(255)) Error: incomplete SQL: CREATE TABLE "tags1" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "metadata_item_id" integer, "tag" varchar(255) COLLATE NOCASE, "tag_type" integer, "user_thumb_url" varchar(255), "user_art_url" varchar(255), "user_music_url" varchar(255), "created_at" datetime, "updated_at" datetime, "tag_value" integer, 'extra_data' varchar(255), 'key' varchar(255), 'parent_id' integer) Error: incomplete SQL: CREATE TABLE "tags2" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "metadata_item_id" integer, "tag" varchar(255) COLLATE NOCASE, "tag_type" integer, "user_thumb_url" varchar(255), "user_art_url" varchar(255), "user_music_url" varchar(255), "created_at" datetime, "updated_at" datetime, "tag_value" integer, 'extra_data' varchar(255), 'key' varchar(255), 'parent_id' integer) Error: near line 1: no such table: tmpdb.metadata_item_settings1 Error: near line 1: no such table: tmpdb.metadata_item_settings2 [Sun Jun 16 05:56:25 EDT 2019] Processing tags... Error: no such table: taggings1 Error: no such table: taggings1 Error: no such table: taggings2 Error: no such table: taggings2 [Sun Jun 16 05:56:25 EDT 2019] Processing for (0)... [Sun Jun 16 05:56:25 EDT 2019] - Checking records that are in both databases Error: no such table: metadata_item_settings1
Your using an old version of sqlite3 (from 2016). Please try with the lastest version.
OMG that worked!!! I updated to 3.22.0 and it seems to have worked perfectly, I am sorry I thought I was at the latest version I didn't realize I needed to add a new repo to get the newest version of it. Thank you so much for your help I really appreciate it and this script.
BTW can you tell me exactly what command do I use to add the ignore user option? Or is there a way to sync for only 1 user?
not yet but I will try it once I get a chance, I am now getting a plex database not equal error and am not sure how to fix it. Both plex servers are running the same version but I am still getting the error.
version db1: 20190316132700 db2: 20190528190600 Versions of plex databases not equal
Are you sure about running the same version on these plex servers ? maybe you tried a new beta in one of them then revert ?
You can use option --nocomparedb "true" to ignore this verification.
to fix this I had to install one of the servers at a lower version that I had the other server at then upgrade it again to the current version which the other server was at. I think it was because one of the servers skipped an update.
