Bug#539491: liferea: Fails to start, failure while preparing statement
... Here it goes. Thanks. Since I've put the old directory back into place, even moving liferea.db-journal out of the way doesn't solve the startup issue. In addition to the tarball, please find: - liferea.strace: strace -f with the old directory. - liferea-no-journal.strace: strace -f with the old directory, without the liferea.db-journal file. I've played a bit with it: All I can see is that you somehow managed to get your sqlite db corrupted, and I don't know enough about sqlite to debug this much further. Mraw, KiBi. cu Adrian -- Is there not promise of rain? Ling Tan asked suddenly out of the darkness. There had been need of rain for many days. Only a promise, Lao Er said. Pearl S. Buck - Dragon Seed -- To UNSUBSCRIBE, email to debian-bugs-rc-requ...@lists.debian.org with a subject of unsubscribe. Trouble? Contact listmas...@lists.debian.org
Bug#539491: liferea: Fails to start, failure while preparing statement
Adrian Bunk b...@stusta.de (05/01/2010): All I can see is that you somehow managed to get your sqlite db corrupted, and I don't know enough about sqlite to debug this much further. I guess you can close this bug as it might have just been a glitch at some point that triggered this db issue? Mraw, KiBi. signature.asc Description: Digital signature
Bug#539491: liferea: Fails to start, failure while preparing statement
On Sat, Aug 01, 2009 at 02:38:46PM +0200, Cyril Brulebois wrote: Package: liferea Version: 1.6.0-1 Severity: serious Justification: Renders package unusable Hi, liferea just can't start: | $ liferea | | ** ERROR **: Failure while preparing statement, (error=522, disk I/O error) SQL: SELECT COUNT(*) FROM sqlite_master WHERE type = 'table' AND name = 'info'; | aborting... | zsh: abort liferea Let me know any test I could perform. Two things come into my mind: Does a cat ~/.liferea_1.6/liferea.db /dev/null succeed? Please strace liferea so that it becomes visible what exactly fails (sqlite seems to map a bunch of errors to SQLITE_IOERR). Mraw, KiBi. Thanks Adrian -- Is there not promise of rain? Ling Tan asked suddenly out of the darkness. There had been need of rain for many days. Only a promise, Lao Er said. Pearl S. Buck - Dragon Seed -- To UNSUBSCRIBE, email to debian-bugs-rc-requ...@lists.debian.org with a subject of unsubscribe. Trouble? Contact listmas...@lists.debian.org
Bug#539491: liferea: Fails to start, failure while preparing statement
Adrian Bunk b...@stusta.de (11/08/2009): Let me know any test I could perform. Two things come into my mind: Does a cat ~/.liferea_1.6/liferea.db /dev/null succeed? Yes, so not a disk/FS-related issue (I guess it was your point?). Please strace liferea so that it becomes visible what exactly fails (sqlite seems to map a bunch of errors to SQLITE_IOERR). It looks like it's trying to access liferea.db-journal, and fails from there on. Moving this file away makes it possible to start liferea again. \o/ If you wish I can pass you on: - the whole strace. - the db file (~ 7MB). - the db journal file ( 1MB). Mraw, KiBi. signature.asc Description: Digital signature
Bug#539491: liferea: Fails to start, failure while preparing statement
On Tue, Aug 11, 2009 at 08:32:26PM +0200, Cyril Brulebois wrote: Adrian Bunk b...@stusta.de (11/08/2009): Let me know any test I could perform. Two things come into my mind: Does a cat ~/.liferea_1.6/liferea.db /dev/null succeed? Yes, so not a disk/FS-related issue (I guess it was your point?). Please strace liferea so that it becomes visible what exactly fails (sqlite seems to map a bunch of errors to SQLITE_IOERR). It looks like it's trying to access liferea.db-journal, and fails from there on. What kind of failure exactly? Moving this file away makes it possible to start liferea again. \o/ If you wish I can pass you on: - the whole strace. - the db file (~ 7MB). - the db journal file ( 1MB). You could tar the complete .liferea-1.6 (assuming you don't have any passwords or other confidential information there)? Mraw, KiBi. cu Adrian -- Is there not promise of rain? Ling Tan asked suddenly out of the darkness. There had been need of rain for many days. Only a promise, Lao Er said. Pearl S. Buck - Dragon Seed -- To UNSUBSCRIBE, email to debian-bugs-rc-requ...@lists.debian.org with a subject of unsubscribe. Trouble? Contact listmas...@lists.debian.org
Bug#539491: liferea: Fails to start, failure while preparing statement
Emilio Pozuelo Monfort poch...@gmail.com (01/08/2009): Can you move away (don't delete it, we may need it to further analize the problem) ~/.liferea_1.6 and see if it starts? Aud as requested on IRC, once liferea-dbg installed, running liferea into gdb, and printing a backtrace when the bug occurs: | (gdb) run | Starting program: /usr/bin/liferea | [Thread debugging using libthread_db enabled] | [New Thread 0x7fffe99f1950 (LWP 32734)] | [Thread 0x7fffe99f1950 (LWP 32734) exited] | | ** ERROR **: Failure while preparing statement, (error=522, disk I/O error) SQL: SELECT COUNT(*) FROM sqlite_master WHERE type = 'table' AND name = 'info'; | aborting... | | Program received signal SIGABRT, Aborted. | 0x73602d25 in raise () from /lib/libc.so.6 | (gdb) bt | #0 0x73602d25 in raise () from /lib/libc.so.6 | #1 0x73605de1 in abort () from /lib/libc.so.6 | #2 0x739657ae in g_logv () from /usr/lib/libglib-2.0.so.0 | #3 0x73965833 in g_log () from /usr/lib/libglib-2.0.so.0 | #4 0x00421fd7 in db_prepare_stmt (stmt=value optimized out, sql=0x731ae8 SELECT COUNT(*) FROM sqlite_master WHERE type = 'table' AND name = 'info';) at db.c:55 | #5 0x00422628 in db_table_exists () at db.c:109 | #6 db_get_schema_version () at db.c:136 | #7 0x00422c4f in db_init () at db.c:176 | #8 0x00433ed6 in main (argc=1, argv=0x7fffe728) at main.c:277 Mraw, KiBi. signature.asc Description: Digital signature
Bug#539491: liferea: Fails to start, failure while preparing statement
Package: liferea Version: 1.6.0-1 Severity: serious Justification: Renders package unusable Hi, liferea just can't start: | $ liferea | | ** ERROR **: Failure while preparing statement, (error=522, disk I/O error) SQL: SELECT COUNT(*) FROM sqlite_master WHERE type = 'table' AND name = 'info'; | aborting... | zsh: abort liferea Let me know any test I could perform. Mraw, KiBi. -- System Information: Debian Release: sid APT prefers unstable APT policy: (500, 'unstable'), (500, 'testing') Architecture: amd64 (x86_64) Kernel: Linux 2.6.30-1-amd64 (SMP w/2 CPU cores) Locale: LANG=en_US.UTF-8, LC_CTYPE=en_US.UTF-8 (charmap=UTF-8) Shell: /bin/sh linked to /bin/bash Versions of packages liferea depends on: ii gconf2 2.26.2-3 GNOME configuration database syste ii libatk1.0-0 1.26.0-1 The ATK accessibility toolkit ii libc6 2.9-21 GNU C Library: Shared libraries ii libcairo2 1.8.8-2 The Cairo 2D vector graphics libra ii libdbus-1-3 1.2.16-2 simple interprocess messaging syst ii libdbus-glib-1-20.80-4 simple interprocess messaging syst ii libgconf2-4 2.26.2-3 GNOME configuration database syste ii libglade2-0 1:2.6.4-1library to load .glade files at ru ii libglib2.0-02.20.4-1 The GLib library of C routines ii libgtk2.0-0 2.16.5-1 The GTK+ graphical user interface ii libice6 2:1.0.5-1X11 Inter-Client Exchange library ii liblua5.1-0 5.1.4-3 Simple, extensible, embeddable pro ii libnm-glib0 0.7.1-1 network management framework (GLib ii libnotify1 [libnotify1-gtk2 0.4.5-1 sends desktop notifications to a n ii libpango1.0-0 1.24.5-1 Layout and rendering of internatio ii libsm6 2:1.1.0-2X11 Session Management library ii libsoup2.4-12.27.4-1 an HTTP library implementation in ii libsqlite3-03.6.16-1 SQLite 3 shared library ii libwebkit-1.0-2 1.1.10-2 Web content engine library for Gtk ii libx11-62:1.2.2-1X11 client-side library ii libxml2 2.7.3.dfsg-2 GNOME XML library ii libxslt1.1 1.1.24-2 XSLT processing library - runtime ii liferea-data1.6.0-1 architecture independent data for Versions of packages liferea recommends: ii curl 7.19.5-1 Get a file from an HTTP, HTTPS or ii dbus 1.2.16-2 simple interprocess messaging syst ii dbus-x11 1.2.16-2 simple interprocess messaging syst ii gwget 1.0.1-1GNOME front-end for wget ii wget 1.11.4-4 retrieves files from the web Versions of packages liferea suggests: pn network-manager none (no description available) -- no debconf information -- To UNSUBSCRIBE, email to debian-bugs-rc-requ...@lists.debian.org with a subject of unsubscribe. Trouble? Contact listmas...@lists.debian.org
Bug#539491: liferea: Fails to start, failure while preparing statement
Cyril Brulebois wrote: Package: liferea Version: 1.6.0-1 Severity: serious Justification: Renders package unusable Hi, liferea just can't start: | $ liferea | | ** ERROR **: Failure while preparing statement, (error=522, disk I/O error) SQL: SELECT COUNT(*) FROM sqlite_master WHERE type = 'table' AND name = 'info'; | aborting... | zsh: abort liferea Let me know any test I could perform. Can you move away (don't delete it, we may need it to further analize the problem) ~/.liferea_1.6 and see if it starts? signature.asc Description: OpenPGP digital signature
Bug#539491: liferea: Fails to start, failure while preparing statement
Emilio Pozuelo Monfort poch...@gmail.com (01/08/2009): Let me know any test I could perform. Can you move away (don't delete it, we may need it to further analize the problem) ~/.liferea_1.6 and see if it starts? Did so, it now starts. :) Mraw, KiBi. signature.asc Description: Digital signature
