xmms2 refuse to start with SQLite Error code 1
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
xmms2 (Ubuntu) |
New
|
Undecided
|
Unassigned |
Bug Description
I find myself for the 2nd time unable to launch xmms2d after it has stopped working. Restarting the daemon results in the following messages shown on the command line:
> INFO: ../src/
>10:23:45 INFO: ../src/
>10:23:46 INFO: ../src/
>10:23:46 ERROR: ../src/
~/.config/
> medialib.db: SQLite 3.x database, user version 36
.config/xmms2> xmms2d --version
>XMMS2 version 0.7 DrNo (git commit: 4bd0e653c2fd8b3
> Using glib version 2.24.1 (compiled against 2.23.6)
> Using sqlite version 3006022 (compiled against 3006022)
log file is huge (~1GB) and contain entries such as the following:
>08:49:28 ERROR: ../src/
>r missing database) on query 'INSERT INTO CollectionAttri
>position')'
>xmms2d.log is huge and contains repeated entries like :
>08:49:28 ERROR: ../src/
>r missing database) on query 'INSERT INTO CollectionIdlists VALUES(1, 4238, 1739
>)'
>08:49:28 ERROR: ../src/
>r missing database) on query 'INSERT INTO CollectionIdlists VALUES(1, 4229, 3972
>)'
>...
>08:53:34 ERROR: ../src/
>
medialib.db has grown up to 17GB, which looks excessive to me.
lsb_release -rd
Description: Ubuntu 10.04.4 LTS
Release: 10.04
FYI, once compressed with gzip, medialib.db only needs 23MB of storage. I suspect repeated addition of dummy content in the DB (ie. "file x is missing" or "file y cannot be read because of a missing plug-in). How could I check for that ?