Your message dated Tue, 27 Mar 2012 21:49:25 +0000
with message-id <[email protected]>
and subject line Bug#502307: fixed in liferea 1.8.3-0.1
has caused the Debian Bug report #502307,
regarding db cleanup takes ages, and makes liferea startup a PITA
to be marked as done.
This means that you claim that the problem has been dealt with.
If this is not the case it is now your responsibility to reopen the
Bug report if necessary, and/or fix the problem forthwith.
(NB: If you are a system administrator and have no idea what this
message is talking about, this may indicate a serious mail system
misconfiguration somewhere. Please contact [email protected]
immediately.)
--
502307: http://bugs.debian.org/cgi-bin/bugreport.cgi?bug=502307
Debian Bug Tracking System
Contact [email protected] with problems
--- Begin Message ---
Package: liferea
Version: 1.4.18-1
Severity: important
liferea does lots of database initialization while starting up; the
cleanup includes checking for schema version, droping old stuff,
creating new tables and indexes, and droping/creating triggers
the bad part, though, is the 'cleanup' part; it basically does a check
to see if there are dangling item ids, and items without subscription;
in my computer, a quite fast HP notebook, liferea takes 30 seconds to
startup because of these queries it does in its database:
INSERT INTO tmp_id SELECT ROWID FROM items WHERE ROWID NOT IN (SELECT item_id
FROM itemsets)
INSERT INTO tmp_id SELECT item_id FROM itemsets WHERE item_id NOT IN (SELECT
ROWID FROM items)
DELETE FROM itemsets WHERE comment = 0 AND node_id NOT IN (SELECT node_id FROM
subscription)
Most of the time these queries acomplish nothing but slow down
liferea's startup. I believe it would be wise to not execute them on
every startup; I already removed liferea from my GNOME's session
startup, because GNOME was taking ages to become usable.
Notice that a friend of mine did test his setup, which has almost the
same number of items for me on his laptop, and although liferea did
take some time to startup, it was considerably less than it took on my
machine. We tested our disks performance with hdparm (which probably
isn't conclusive, but anyway), and his was quite faster than mine,
specially on cached disk reads.
I'm setting the severity to important because I think this is plain
unnaceptable for such a simple application, specially since what is
being done is not accomplishing anything useful most times.
Thanks,
-- System Information:
Debian Release: lenny/sid
APT prefers unstable
APT policy: (500, 'unstable'), (1, 'experimental')
Architecture: i386 (i686)
Kernel: Linux 2.6.26-1-686 (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.22.0-1 GNOME configuration database syste
ii libatk1.0-0 1.22.0-1 The ATK accessibility toolkit
ii libc6 2.7-15 GNU C Library: Shared libraries
ii libcairo2 1.6.4-6.1 The Cairo 2D vector graphics libra
ii libdbus-glib-1-2 0.76-1 simple interprocess messaging syst
ii libgcc1 1:4.3.2-1 GCC support library
ii libgconf2-4 2.22.0-1 GNOME configuration database syste
ii libgcrypt11 1.4.1-1 LGPL Crypto library - runtime libr
ii libglade2-0 1:2.6.2-1 library to load .glade files at ru
ii libglib2.0-0 2.18.0-1 The GLib library of C routines
ii libgnutls26 2.4.2-1 the GNU TLS library - runtime libr
ii libgtk2.0-0 2.12.11-4 The GTK+ graphical user interface
ii libice6 2:1.0.4-1 X11 Inter-Client Exchange library
ii liblua5.1-0 5.1.3-1 Simple, extensible, embeddable pro
ii libnm-glib0 0.6.6-2 network management framework (GLib
ii libnotify1 [libnotify1 0.4.4-3 sends desktop notifications to a n
ii libpango1.0-0 1.20.5-2 Layout and rendering of internatio
ii libsm6 2:1.0.3-2 X11 Session Management library
ii libsqlite3-0 3.5.9-5 SQLite 3 shared library
ii libstdc++6 4.3.2-1 The GNU Standard C++ Library v3
ii libx11-6 2:1.1.5-2 X11 client-side library
ii libxml2 2.6.32.dfsg-4 GNOME XML library
ii libxslt1.1 1.1.24-2 XSLT processing library - runtime
ii xulrunner-1.9 1.9.0.3-1 XUL + XPCOM application runner
ii zlib1g 1:1.2.3.3.dfsg-12 compression library - runtime
Versions of packages liferea recommends:
ii curl 7.18.2-7 Get a file from an HTTP, HTTPS or
ii dbus 1.2.1-3 simple interprocess messaging syst
ii dbus-x11 1.2.1-3 simple interprocess messaging syst
ii gwget 0.99-3 GNOME front-end for wget
ii wget 1.11.4-2 retrieves files from the web
liferea suggests no packages.
-- no debconf information
--- End Message ---
--- Begin Message ---
Source: liferea
Source-Version: 1.8.3-0.1
We believe that the bug you reported is fixed in the latest version of
liferea, which is due to be installed in the Debian FTP archive:
liferea-data_1.8.3-0.1_all.deb
to main/l/liferea/liferea-data_1.8.3-0.1_all.deb
liferea-dbg_1.8.3-0.1_amd64.deb
to main/l/liferea/liferea-dbg_1.8.3-0.1_amd64.deb
liferea_1.8.3-0.1.debian.tar.gz
to main/l/liferea/liferea_1.8.3-0.1.debian.tar.gz
liferea_1.8.3-0.1.dsc
to main/l/liferea/liferea_1.8.3-0.1.dsc
liferea_1.8.3-0.1_amd64.deb
to main/l/liferea/liferea_1.8.3-0.1_amd64.deb
liferea_1.8.3.orig.tar.gz
to main/l/liferea/liferea_1.8.3.orig.tar.gz
A summary of the changes between this version and the previous one is
attached.
Thank you for reporting the bug, which will now be closed. If you
have further comments please address them to [email protected],
and the maintainer will reopen the bug report if appropriate.
Debian distribution maintenance software
pp.
Moray Allan <[email protected]> (supplier of updated liferea package)
(This message was generated automatically at their request; if you
believe that there is a problem with it please contact the archive
administrators by mailing [email protected])
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
Format: 1.8
Date: Tue, 27 Mar 2012 21:44:42 +0100
Source: liferea
Binary: liferea liferea-data liferea-dbg
Architecture: source all amd64
Version: 1.8.3-0.1
Distribution: unstable
Urgency: low
Maintainer: Luis Rodrigo Gallardo Cruz <[email protected]>
Changed-By: Moray Allan <[email protected]>
Description:
liferea - feed aggregator for GNOME
liferea-data - architecture independent data for liferea
liferea-dbg - liferea debug symbols
Closes: 502307 623619 631778 651913
Changes:
liferea (1.8.3-0.1) unstable; urgency=low
.
[ Bojo42 ]
* Non-maintainer upload.
* New upstream release (Closes: #502307, #623619, #631778, #651913)
* debian/patches:
- drop libnotify0.7 as in upstream
- debian-example-feeds: update, move planets from "News" to "Open Source"
- www-browser: update due to new file location
- libtool-dont-rearange-as-needed: rebase
* debian/control:
- update Standards-Version
- remove obsolete Build-Depends:
- quilt not needed for "3.0 (quilt)" source format
- libnm-glib-dev & libdbus-glib-1-dev: upstream switched to GDBus
- liblua5.1-0-dev: LUA scripting support got dropped
- new Build-Depends on libunique-dev, libjson-glib-dev & dh_autoreconf
- update version dependencies
* debian/rules: run dh_autoreconf & update translations
* debian/liferea.install: nothing to ship from /usr/lib/liferea
.
[ Rodrigo Gallardo ]
* Lintian love:
- debian/control: switch from Conflicts to Breaks
- debian/rules: redo build targets
.
[ Moray Allan ]
* debian/copyright: update to include additional copyright owners.
* debian/patches/www-browser: also set default external browser.
Checksums-Sha1:
0ed75f9a551e2decca057d4bd1ffeb8f05a5a362 1704 liferea_1.8.3-0.1.dsc
70ff90511260cc6616c0f5ec5b74ed9a498307a8 1864315 liferea_1.8.3.orig.tar.gz
299b8a25a8268372ea82e0924592ddc1ea5e13d5 19375 liferea_1.8.3-0.1.debian.tar.gz
d8daaaf9e6981a20b61ef44ed3b609e0a0f389fd 918766 liferea-data_1.8.3-0.1_all.deb
f14ef84523a0cf30c1293e8ca16d808c7f945168 212848 liferea_1.8.3-0.1_amd64.deb
21f9cbe4d038a2de6df46e3ccc207654b0d3000f 579010 liferea-dbg_1.8.3-0.1_amd64.deb
Checksums-Sha256:
6b50c75fe629cefc3d93be07c4dd55d0f22c43de94977fa01cd386dc909c6d6a 1704
liferea_1.8.3-0.1.dsc
b85b1b4d21e5c1a97457c2d7d91bb36273154dcb0037cf526aae637b9b2ce97e 1864315
liferea_1.8.3.orig.tar.gz
31c288c1a8a80828a859ba996c609153b654df7a78d8f3841f5a6f6a8ea87b88 19375
liferea_1.8.3-0.1.debian.tar.gz
e647cadce58b3f60f66c6b31bdc015d211d0f8ef297b8af797b28c2f7c68e25b 918766
liferea-data_1.8.3-0.1_all.deb
7c8ad6689270656012eb7cefa4b20fdc013981d6df7aafe2795cb3bd1107a712 212848
liferea_1.8.3-0.1_amd64.deb
5c09538dc76a2bffbd20919dbc28c39e23934fd246e5400025eef5d4d440eb4c 579010
liferea-dbg_1.8.3-0.1_amd64.deb
Files:
8137b9e30f9f42b487442315e8575f12 1704 web optional liferea_1.8.3-0.1.dsc
afa1b7e4a8d149a470f2053120beacb1 1864315 web optional liferea_1.8.3.orig.tar.gz
782d389ac4970eba6b646d01cbd86a10 19375 web optional
liferea_1.8.3-0.1.debian.tar.gz
e440dc6eb0097ae7acc0dd74afb25ee6 918766 web optional
liferea-data_1.8.3-0.1_all.deb
5c9f500667e16725995922e8a6501408 212848 web optional
liferea_1.8.3-0.1_amd64.deb
617df9c8f0dc385060fbc04e26d3d393 579010 debug extra
liferea-dbg_1.8.3-0.1_amd64.deb
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.12 (GNU/Linux)
iEYEARECAAYFAk9yKTQACgkQ500puCvhbQFCIQCeJ5+zndl87tQN6nMdHL7Wnu5t
VkMAoMtMcAVkeZJOn/nMsZwbhDUvkOnE
=SiaO
-----END PGP SIGNATURE-----
--- End Message ---
