xmms2 refuse to start with SQLite Error code 1

Bug #1091139 reported by pype on 2012-12-17
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
xmms2 (Ubuntu)
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  Edit
Everyone can see this information.

Other bug subscribers