xmms2 refuse to start with SQLite Error code 1

Bug #1091139 reported by pype
6
This bug affects 1 person
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/xmms/log.c:49: Initialized logging system :)
>10:23:45 INFO: ../src/xmms/ipc.c:874: IPC listening on 'unix:///tmp/xmms-ipc-martin'.
>10:23:46 INFO: ../src/xmms/main.c:563: Using output plugin: pulse
>10:23:46 ERROR: ../src/xmms/sqlite.c:733: SQLite Error code 1 (SQL logic error or missing database) on query >> 'SELECT id FROM Media WHERE key='status' AND source=1 AND intval IN (0, 4) LIMIT 1'

~/.config/xmms2/medialib.db is present and reported by `file` tool as
> medialib.db: SQLite 3.x database, user version 36

.config/xmms2> xmms2d --version
>XMMS2 version 0.7 DrNo (git commit: 4bd0e653c2fd8b36a5f2ae4203ff0b37b03180f0-dirty)
> 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/xmms/sqlite.c:660: SQLite Error code 1 (SQL logic error o
>r missing database) on query 'INSERT INTO CollectionAttributes VALUES(1, '-1', '
>position')'
>xmms2d.log is huge and contains repeated entries like :
>08:49:28 ERROR: ../src/xmms/sqlite.c:660: SQLite Error code 1 (SQL logic error o
>r missing database) on query 'INSERT INTO CollectionIdlists VALUES(1, 4238, 1739
>)'
>08:49:28 ERROR: ../src/xmms/sqlite.c:660: SQLite Error code 1 (SQL logic error o
>r missing database) on query 'INSERT INTO CollectionIdlists VALUES(1, 4229, 3972
>)'
>...
>08:53:34 ERROR: ../src/xmms/sqlite.c:583: Error in query! "INSERT OR REPLACE INTO Media (id, value, intval, key, >source) VALUES (8129, '44100', 44100, 'samplerate', 7)" (11) - database disk image is malformed
>
medialib.db has grown up to 17GB, which looks excessive to me.

lsb_release -rd
Description: Ubuntu 10.04.4 LTS
Release: 10.04

Revision history for this message
pype (pype-1999-geo) wrote :

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 ?

To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.