[Plugin] MPSync - MediaPortal multi-seat Synchronization (4 Viewers)

[ajs]

The client computer has broken database this series, not all series have a full description, brought down statuses, etc.

 

[lulsam]

Hi m3rcury,
just a question that maybe be stupid (or answered in any other side). Being a process plugin, it should run while MePo is running, right? But at startup, later, or when?

In my installation it seems to work, but I have to use the manual update...... maybe I have to invest more time to investigate.

BTW, very interesting plugin to cover what in my opinion is a big hole in MePo 1, hopefully it will be solved in MePo 2 with a true media server, not only a tvserver, but until then, your plugin is a must.

Cheers

lulsam, MPSync plugins will start executing immediately and thereafter depending on the value you set up in the Advanced Settings tab.

What you can do to check if plugin is working correctly, delete the mpsync.log, check that in MediaPortal Configuration, MPSync is enabled and launch MediaPortal. After a couple of seconds, you can check that mpsync.log has been created and it contains activity.

Ok, it seems that most sync issues have gone with 1.0.0.4 version (still need further testing). just one question and a request:

Q: How the sync works? I mean, when one sync has finished and suceed (or not) and the plugin is configured to sync the databases each 10 secs (for instance): does it run the full sync again or does it check something (a table) to see if it is required a full sync? The reason of this question is to understand how much time could be a good option for the "synchronize every" parameter=> maybe 1 second is a nonsense and 1 minute is good enough. What is your opinion about that?
Req: Would you please consider to include support for mylirics database in the next release? I think there are a lot of people using such plugin

Regards

 

[m3rcury]

Ok, it seems that most sync issues have gone with 1.0.0.4 version (still need further testing). just one question and a request:

Q: How the sync works? I mean, when one sync has finished and suceed (or not) and the plugin is configured to sync the databases each 10 secs (for instance): does it run the full sync again or does it check something (a table) to see if it is required a full sync? The reason of this question is to understand how much time could be a good option for the "synchronize every" parameter=> maybe 1 second is a nonsense and 1 minute is good enough. What is your opinion about that?
Req: Would you please consider to include support for mylirics database in the next release? I think there are a lot of people using such plugin

Regards

lulsam, in order not to be too invasive on other plugin databases, the synch works by first checking database date stamp and compare against last execution. If it is more recent, then it goes into the the tables within the databases and compares these between source and target, doing what is necessary to get them in synch. The time interval is a choice one needs to make to have all clients synchronized. It could be that one does not need synchronization too frequent, hence chooses say every 1hr or maybe one wants client updated immediately and chooses 30 sec. I believe that less that 30 sec is an overkill as most probably the whole process would not have finished one synch in that time period. Obviously this depends on the number of databases and their size.

Regarding mylirics database, what do you mean by "to include support". Synchronization is not database specific and can work with any database, so as long as database is in the right folder, it should synchronize like the others.

 

[lulsam]

lulsam, in order not to be too invasive on other plugin databases, the synch works by first checking database date stamp and compare against last execution. If it is more recent, then it goes into the the tables within the databases and compares these between source and target, doing what is necessary to get them in synch. The time interval is a choice one needs to make to have all clients synchronized. It could be that one does not need synchronization too frequent, hence chooses say every 1hr or maybe one wants client updated immediately and chooses 30 sec. I believe that less that 30 sec is an overkill as most probably the whole process would not have finished one synch in that time period. Obviously this depends on the number of databases and their size.

Regarding mylirics database, what do you mean by "to include support". Synchronization is not database specific and can work with any database, so as long as database is in the right folder, it should synchronize like the others

.

Thanks, it seems to me that 30 secs to 1 minute should be more than enough. Regarding the mylirics db, maybe it doesn't not appear in the databases box as one available to be sync'ed because of its extension (db instead of db3). This makes me wonder if it is just a matter of filtering to include it in the databases to be sync'ed or the extension indicates a different database format and requires much more job to support it

 

[m3rcury]

lulsam, in order not to be too invasive on other plugin databases, the synch works by first checking database date stamp and compare against last execution. If it is more recent, then it goes into the the tables within the databases and compares these between source and target, doing what is necessary to get them in synch. The time interval is a choice one needs to make to have all clients synchronized. It could be that one does not need synchronization too frequent, hence chooses say every 1hr or maybe one wants client updated immediately and chooses 30 sec. I believe that less that 30 sec is an overkill as most probably the whole process would not have finished one synch in that time period. Obviously this depends on the number of databases and their size.

Regarding mylirics database, what do you mean by "to include support". Synchronization is not database specific and can work with any database, so as long as database is in the right folder, it should synchronize like the others

.

Thanks, it seems to me that 30 secs to 1 minute should be more than enough. Regarding the mylirics db, maybe it doesn't not appear in the databases box as one available to be sync'ed because of its extension (db instead of db3). This makes me wonder if it is just a matter of filtering to include it in the databases to be sync'ed or the extension indicates a different database format and requires much more job to support it

lulsam, if it is not huge, can you attach database here or else PM me and I'll provide you with my email.

 

[lulsam]

I sent an MP with the DBs.

Thanks in advance

 

[CGT]

Hi, I have a general question: Is copying the thumbs/db folders just the same as MPsync does or is there a major difference?

 

[m3rcury]

Hi, I have a general question: Is copying the thumbs/db folders just the same as MPsync does or is there a major difference?

CGT, if you want to copy manually the dbs and thumbs you can. MPSync will do that automatically for you. What it does as well is you can start watching a movie/serie on one client and resume onto another.

 

[ajs]

MPSync dont work:

See the end of this message for details on invoking
just-in-time (JIT) debugging instead of this dialog box.
 
************** Exception Text **************
System.Data.SQLite.SQLiteException: The database disk image is malformed
database disk image is malformed
  at System.Data.SQLite.SQLite3.Prepare(SQLiteConnection cnn, String strSql, SQLiteStatement previous, UInt32 timeoutMS, String& strRemain)
  at System.Data.SQLite.SQLiteCommand.BuildNextCommand()
  at System.Data.SQLite.SQLiteCommand.GetStatement(Int32 index)
  at System.Data.SQLite.SQLiteDataReader.NextResult()
  at System.Data.SQLite.SQLiteDataReader..ctor(SQLiteCommand cmd, CommandBehavior behave)
  at System.Data.SQLite.SQLiteCommand.ExecuteReader(CommandBehavior behavior)
  at System.Data.SQLite.SQLiteCommand.ExecuteNonQuery()
  at System.Data.SQLite.SQLiteConnection.Open()
  at MPSync.MPSync_process.Create_Work_Tables(String path, String database)
  at MPSync.MPSync_process.MPSyncProcess()
  at MPSync.MPSync_settings.b_sync_now_Click(Object sender, EventArgs e)
  at System.Windows.Forms.Control.OnClick(EventArgs e)
  at System.Windows.Forms.Button.OnClick(EventArgs e)
  at System.Windows.Forms.Button.OnMouseUp(MouseEventArgs mevent)
  at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks)
  at System.Windows.Forms.Control.WndProc(Message& m)
  at System.Windows.Forms.ButtonBase.WndProc(Message& m)
  at System.Windows.Forms.Button.WndProc(Message& m)
  at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
  at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
  at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)

02.05.2013 17:22:48 - [INFO] MPSync: process plugin version 1.0.0.4 initialisation with DEBUG.
02.05.2013 17:22:48 - [DEBUG] MPSync: Creating work table mpsync in database MusicDatabaseV12.db3
02.05.2013 17:22:48 - [DEBUG] MPSync: Creating work table mpsync in database MusicDatabaseV12.db3
02.05.2013 17:22:48 - [DEBUG] MPSync: Dropping triggers in database MusicDatabaseV12.db3
02.05.2013 17:22:48 - [DEBUG] MPSync: Creating work table mpsync in database TVSeriesDatabase4.db3
02.05.2013 17:22:48 - [DEBUG] MPSync: Creating work table mpsync in database TVSeriesDatabase4.db3

I check, vacuum, reindex all databases, But it did not help, had to shut down the database synchronization.

 

[m3rcury]

MPSync dont work:

I check, vacuum, reindex all databases, But it did not help, had to shut down the database synchronization.

ajs, didn't give me anything to work with. As far as I remember, last you said, it was working except for TVSeries and Videos, which I will soon release a fix. What changed on your end?