2010-08-03, 07:29
Hi,
I have multiple htpcs that can run xbmc. The database resides on a nas (using symlinks for sharing) and all have standardized mounts with the same folder structures (/media/pool0X/X) pointing to nfs shares on the nas and other computers.
I currently have 2 zfs pools (01 and 02) and the rest (03-07) were scattered about on a mythtv box, laptop, etc. I have now consolidated pool03-07 to a new zfs pool on the nas.
Using Sqliteman (main > Tables > path), I tried editing all of the paths (from pool03-07) to now point to only pool03, so that all media played in file mode could be keep its info (bookmarks, etc).
When trying to commit the changes to database, I get the error:
This seems to make sense as the database already contained an entry for /media/pool03/tv and editing /media/pool04/tv to /media/pool03 might create some sort of conflict.
So, my question is, what should I do to fix my database? Or, am I out of luck.
Thanks!
I have multiple htpcs that can run xbmc. The database resides on a nas (using symlinks for sharing) and all have standardized mounts with the same folder structures (/media/pool0X/X) pointing to nfs shares on the nas and other computers.
I currently have 2 zfs pools (01 and 02) and the rest (03-07) were scattered about on a mythtv box, laptop, etc. I have now consolidated pool03-07 to a new zfs pool on the nas.
Using Sqliteman (main > Tables > path), I tried editing all of the paths (from pool03-07) to now point to only pool03, so that all media played in file mode could be keep its info (bookmarks, etc).
When trying to commit the changes to database, I get the error:
Code:
There is a pending transaction in progress. That cannot be committed now.
Error: constraint failed Unable to fetch row
Perform rollback?
This seems to make sense as the database already contained an entry for /media/pool03/tv and editing /media/pool04/tv to /media/pool03 might create some sort of conflict.
So, my question is, what should I do to fix my database? Or, am I out of luck.
Thanks!