Reply to thread

Message

<blockquote data-quote="azimek" data-source="post: 699032" data-attributes="member: 45443">Hi - also I am not a newcomer (using MePo for 4 years now) I am interested in how to setup MePo in multiseat with shared databases the best way!As I am using StreamedMP with Fanart handlers, Moving Pictures, InfoService and so on there is a lot of traffic on the central databases for each Plugin.I have all databases on a network share.mediaportaldirs.xml is changed to use the databeses on this share : &nbsp; &lt;!-- The Path for the databases --&gt;&nbsp; &lt;Dir id = &quot;Database&quot;&gt;&nbsp; &nbsp; &lt;Path&gt;d:\mpsharedfiles\Database\&lt;/Path&gt;&nbsp; &lt;/Dir&gt;&nbsp; &lt;!-- The Path for the Thumbs, like Music Cover Art, TV Logos, etc. --&gt;&nbsp; &lt;Dir id = &quot;Thumbs&quot;&gt;&nbsp; &nbsp; &lt;Path&gt;d:\mpsharedfiles\Thumbs\&lt;/Path&gt;&nbsp; &lt;/Dir&gt;Errors look like this:2011-01-03 21:01:56.386600 [ERROR][DirectoryWorker(8)]: SQLiteClient:&nbsp; cmd:sqlite3_prepare16<img src="data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7" class="smilie smilie--sprite smilie--sprite7" alt=":p" title="Stick Out Tongue&nbsp; &nbsp; :p" loading="lazy" data-shortname=":p" />vm=null err:BUSY detailed:database is locked query<img src="data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7" class="smilie smilie--sprite smilie--sprite5" alt=":confused:" title="Confused&nbsp; &nbsp; :confused:" loading="lazy" data-shortname=":confused:" />ELECT COUNT(Artist) FROM Movie_Fanart WHERE Artist = 'the imaginarium of doctor parnassus' AND SOURCE_IMAGE = 'd:\MPSharedFiles\Thumbs\MovingPictures\Backdrops\FullSize\{The.Imaginarium.of.Doctor.Parnassus} [-2087554304].jpg';Everything works fine so far - but very often when a new instance of MePo is started on one of the clients I get a lock on the databases.SQLITE statements are then created in the local log files of the client.directly when StreamedMP is starting up and it uses MovingPictures too get the info on added movies and so on everything gets really slow, because the database is locked by another client. So this really is my priority 1 problem - locked databases!Do you have a better idea to realize a multiseat setup with shared databases where no locks will occure?Thanx a lotAndré</blockquote>

[QUOTE="azimek, post: 699032, member: 45443"] Hi - also I am not a newcomer (using MePo for 4 years now) I am interested in how to setup MePo in multiseat with shared databases the best way! As I am using StreamedMP with Fanart handlers, Moving Pictures, InfoService and so on there is a lot of traffic on the central databases for each Plugin. I have all databases on a network share. mediaportaldirs.xml is changed to use the databeses on this share :  <Dir id = "Database"> <Path>d:\mpsharedfiles\Database\</Path> </Dir>  <Dir id = "Thumbs"> <Path>d:\mpsharedfiles\Thumbs\</Path> </Dir> Errors look like this: 2011-01-03 21:01:56.386600 [ERROR][DirectoryWorker(8)]: SQLiteClient: cmd:sqlite3_prepare16:pvm=null err:BUSY detailed:database is locked query:SELECT COUNT(Artist) FROM Movie_Fanart WHERE Artist = 'the imaginarium of doctor parnassus' AND SOURCE_IMAGE = 'd:\MPSharedFiles\Thumbs\MovingPictures\Backdrops\FullSize\{The.Imaginarium.of.Doctor.Parnassus} [-2087554304].jpg'; Everything works fine so far - but very often when a new instance of MePo is started on one of the clients I get a lock on the databases. SQLITE statements are then created in the local log files of the client. directly when StreamedMP is starting up and it uses MovingPictures too get the info on added movies and so on everything gets really slow, because the database is locked by another client. So this really is my priority 1 problem - locked databases! Do you have a better idea to realize a multiseat setup with shared databases where no locks will occure? Thanx a lot André [/QUOTE]

Verification