Public bug reported:
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
** Affects: xmms2 (Ubuntu)
Importance: Undecided
Status: New
--
You received this bug notification because you are a member of Ubuntu
Bugs, which is subscribed to Ubuntu.
https://bugs.launchpad.net/bugs/1091139
Title:
xmms2 refuse to start with SQLite Error code 1
To manage notifications about this bug go to:
https://bugs.launchpad.net/ubuntu/+source/xmms2/+bug/1091139/+subscriptions
--
ubuntu-bugs mailing list
[email protected]
https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
