liferea --debug-db

log (text/plain), 20.31 KB, created by Andrey Vihrov on 2009-11-07 14:27:42 UTC

Liferea encountered an unknown argument: --debug-performance
DB: Opening DB file /home/andrey/.liferea_1.4/liferea.db...
DB: current DB schema version: 7
DB: executing SQL: CREATE TABLE items (   title		TEXT,   read		INTEGER,   new		INTEGER,   updated		INTEGER,   popup		INTEGER,   marked		INTEGER,   source		TEXT,   source_id		TEXT,   valid_guid		INTEGER,   real_source_url	TEXT,   real_source_title	TEXT,   description	TEXT,   date		INTEGER,   comment_feed_id	TEXT,   comment            INTEGER);
DB:  -> result: 1 (table items already exists)
DB: executing SQL: CREATE INDEX items_idx ON items (source_id);
DB:  -> result: 1 (index items_idx already exists)
DB: executing SQL: CREATE INDEX items_idx2 ON items (comment_feed_id);
DB:  -> result: 1 (index items_idx2 already exists)
DB: executing SQL: CREATE TABLE itemsets (   item_id		INTEGER,   parent_item_id     INTEGER,   node_id		TEXT,   parent_node_id     TEXT,   read		INTEGER,   comment            INTEGER,   PRIMARY KEY (item_id, node_id));
DB:  -> result: 1 (table itemsets already exists)
DB: executing SQL: CREATE INDEX itemset_idx  ON itemsets (node_id);
DB:  -> result: 1 (index itemset_idx already exists)
DB: executing SQL: CREATE INDEX itemset_idx2 ON itemsets (item_id);
DB:  -> result: 1 (index itemset_idx2 already exists)
DB: executing SQL: CREATE TABLE metadata (   item_id		INTEGER,   nr              	INTEGER,   key             	TEXT,   value           	TEXT,   PRIMARY KEY (item_id, nr));
DB:  -> result: 1 (table metadata already exists)
DB: executing SQL: CREATE INDEX metadata_idx ON metadata (item_id);
DB:  -> result: 1 (index metadata_idx already exists)
DB: executing SQL: CREATE TABLE subscription (   node_id            STRING,   source             STRING,   orig_source        STRING,   filter_cmd         STRING,   update_interval	INTEGER,   default_interval   INTEGER,   discontinued       INTEGER,   available          INTEGER,   PRIMARY KEY (node_id));
DB:  -> result: 1 (table subscription already exists)
DB: executing SQL: CREATE TABLE update_state (   node_id            STRING,   last_modified      STRING,   etag               STRING,   last_update        INTEGER,   last_favicon_update INTEGER,   PRIMARY KEY (node_id));
DB:  -> result: 1 (table update_state already exists)
DB: executing SQL: CREATE TABLE subscription_metadata (   node_id            STRING,   nr                 INTEGER,   key                TEXT,   value              TEXT,   PRIMARY KEY (node_id, nr));
DB:  -> result: 1 (table subscription_metadata already exists)
DB: executing SQL: CREATE INDEX subscription_metadata_idx ON subscription_metadata (node_id);
DB:  -> result: 1 (index subscription_metadata_idx already exists)
DB: executing SQL: CREATE TABLE node (   node_id		STRING,   parent_id		STRING,   title		STRING,   type		INTEGER,   expanded           INTEGER,   view_mode		INTEGER,   sort_column	INTEGER,   sort_reversed	INTEGER,   PRIMARY KEY (node_id));
DB:  -> result: 1 (table node already exists)
DB: executing SQL: CREATE TABLE view_state (   node_id            STRING,   unread             INTEGER,   count              INTEGER,   PRIMARY KEY (node_id));
DB:  -> result: 1 (table view_state already exists)
DB: table setup took 0,001s
DB: executing SQL: DROP TRIGGER item_insert;
DB:  -> result: 0 (success)
DB: executing SQL: DROP TRIGGER item_update;
DB:  -> result: 0 (success)
DB: executing SQL: DROP TRIGGER item_removal;
DB:  -> result: 0 (success)
DB: executing SQL: DROP TRIGGER subscription_removal;
DB:  -> result: 0 (success)
DB: Checking for items not referenced in table 'itemsets'...
DB: executing SQL: BEGIN;    CREATE TEMP TABLE tmp_id ( id );   INSERT INTO tmp_id SELECT ROWID FROM items WHERE ROWID NOT IN (SELECT item_id FROM itemsets);   DELETE FROM items WHERE ROWID IN (SELECT id FROM tmp_id LIMIT 1000);   DROP TABLE tmp_id;END;
DB:  -> result: 0 (success)
DB: Checking for invalid item ids in table 'itemsets'...
DB: executing SQL: BEGIN;    CREATE TEMP TABLE tmp_id ( id );   INSERT INTO tmp_id SELECT item_id FROM itemsets WHERE item_id NOT IN (SELECT ROWID FROM items);   DELETE FROM itemsets WHERE item_id IN (SELECT id FROM tmp_id LIMIT 1000);   DROP TABLE tmp_id;END;
DB:  -> result: 0 (success)
DB: Checking for items without a feed list node...
DB: executing SQL: DELETE FROM itemsets WHERE comment = 0 AND node_id NOT IN (SELECT node_id FROM node);
DB:  -> result: 0 (success)
DB: Checking for stale views not listed in feed list.
DB: DB cleanup finished. Continuing startup.
DB: executing SQL: CREATE TRIGGER item_insert INSERT ON items BEGIN    UPDATE itemsets SET read = new.read    WHERE item_id = new.ROWID; END;
DB:  -> result: 0 (success)
DB: executing SQL: CREATE TRIGGER item_update UPDATE ON items BEGIN    UPDATE itemsets SET read = new.read    WHERE item_id = new.ROWID; END;
DB:  -> result: 0 (success)
DB: executing SQL: CREATE TRIGGER item_removal DELETE ON itemsets BEGIN    DELETE FROM items WHERE ROWID = old.item_id;    DELETE FROM metadata WHERE item_id = old.item_id; END;
DB:  -> result: 0 (success)
DB: executing SQL: CREATE TRIGGER subscription_removal DELETE ON subscription BEGIN    DELETE FROM node WHERE node_id = old.node_id;    DELETE FROM update_state WHERE node_id = old.node_id;    DELETE FROM subscription_metadata WHERE node_id = old.node_id; END;
DB:  -> result: 0 (success)

(liferea:25393): Gtk-WARNING **: GtkSpinButton: setting an adjustment with non-zero page size is deprecated
DB: Checking for view rrxdjxk (SQL=CREATE VIEW view_rrxdjxk AS SELECT items.ROWID AS item_id,items.read AS item_read FROM items   WHERE (items.read = 0) AND items.comment != 1)
DB: No need to create view rrxdjxk as it already exists.
DB: executing SQL: REPLACE INTO view_state (node_id, unread, count) VALUES ('rrxdjxk',    (SELECT count(*) FROM view_rrxdjxk WHERE item_read = 0),   (SELECT count(*) FROM view_rrxdjxk));
DB:  -> result: 0 (success)
DB: updating node info rrxdjxk (thread 0x1839a30)
DB: subscription_update took 0,079s
DB: loading subscription ywvragm update state (thread=0x1839a30)
DB: updating node info ywvragm (thread 0x1839a30)
DB: subscription_update took 0,099s
DB: loading subscription pogbvpd update state (thread=0x1839a30)
DB: updating node info pogbvpd (thread 0x1839a30)
DB: subscription_update took 0,110s
DB: loading subscription iaxvjuc update state (thread=0x1839a30)
DB: updating node info iaxvjuc (thread 0x1839a30)
DB: subscription_update took 0,168s
DB: loading subscription atdqvby update state (thread=0x1839a30)
DB: updating node info atdqvby (thread 0x1839a30)
DB: subscription_update took 0,111s
DB: loading subscription dxxtnnt update state (thread=0x1839a30)
DB: updating node info dxxtnnt (thread 0x1839a30)
DB: subscription_update took 0,110s
DB: loading subscription wlbdxge update state (thread=0x1839a30)
DB: updating node info wlbdxge (thread 0x1839a30)
DB: subscription_update took 0,110s
DB: loading subscription uetrioa update state (thread=0x1839a30)
DB: updating node info uetrioa (thread 0x1839a30)
DB: subscription_update took 0,154s
DB: loading subscription ooaloje update state (thread=0x1839a30)
DB: updating node info ooaloje (thread 0x1839a30)
DB: subscription_update took 0,099s
DB: loading subscription rqmkrcs update state (thread=0x1839a30)
DB: updating node info rqmkrcs (thread 0x1839a30)
DB: subscription_update took 0,100s
DB: loading subscription murdiyc update state (thread=0x1839a30)
DB: updating node info murdiyc (thread 0x1839a30)
DB: subscription_update took 0,099s
DB: loading subscription ocucvcf update state (thread=0x1839a30)
DB: updating node info ocucvcf (thread 0x1839a30)
DB: subscription_update took 0,098s
DB: loading subscription ulphjkj update state (thread=0x1839a30)
DB: updating node info ulphjkj (thread 0x1839a30)
DB: subscription_update took 0,100s
DB: loading subscription xmbatod update state (thread=0x1839a30)
DB: updating node info xmbatod (thread 0x1839a30)
DB: subscription_update took 0,110s
DB: loading subscription cbaiocf update state (thread=0x1839a30)
DB: updating node info cbaiocf (thread 0x1839a30)
DB: subscription_update took 0,099s
DB: loading subscription fgonlic update state (thread=0x1839a30)
DB: updating node info fgonlic (thread 0x1839a30)
DB: subscription_update took 0,099s
DB: loading subscription vwksddg update state (thread=0x1839a30)
DB: updating node info vwksddg (thread 0x1839a30)
DB: subscription_update took 0,165s
DB: loading subscription kiltnas update state (thread=0x1839a30)
DB: updating node info kiltnas (thread 0x1839a30)
DB: subscription_update took 0,102s
DB: loading subscription nnvsggf update state (thread=0x1839a30)
DB: updating node info nnvsggf (thread 0x1839a30)
DB: subscription_update took 0,110s
DB: loading subscription oxvashn update state (thread=0x1839a30)
DB: updating node info oxvashn (thread 0x1839a30)
DB: subscription_update took 0,121s
DB: loading subscription aatntuu update state (thread=0x1839a30)
DB: updating node info aatntuu (thread 0x1839a30)
DB: subscription_update took 0,154s
DB: loading subscription rtydhvn update state (thread=0x1839a30)
DB: updating node info rtydhvn (thread 0x1839a30)
DB: subscription_update took 0,110s
DB: loading subscription fiwtkhq update state (thread=0x1839a30)
DB: updating node info fiwtkhq (thread 0x1839a30)
DB: subscription_update took 0,099s
DB: loading subscription cfjeqri update state (thread=0x1839a30)
DB: updating node info cfjeqri (thread 0x1839a30)
DB: subscription_update took 0,098s
DB: loading subscription bylsoai update state (thread=0x1839a30)
DB: updating node info bylsoai (thread 0x1839a30)
DB: subscription_update took 0,189s
DB: loading subscription tjnmixg update state (thread=0x1839a30)
DB: updating node info tjnmixg (thread 0x1839a30)
DB: subscription_update took 0,210s
DB: loading subscription fggdlnf update state (thread=0x1839a30)
DB: updating node info fggdlnf (thread 0x1839a30)
DB: subscription_update took 0,099s
DB: loading subscription ivhrbuc update state (thread=0x1839a30)
DB: updating node info ivhrbuc (thread 0x1839a30)
DB: subscription_update took 0,089s
DB: loading subscription nlxdlqe update state (thread=0x1839a30)
DB: updating node info nlxdlqe (thread 0x1839a30)
DB: subscription_update took 0,177s
DB: loading subscription gsdiron update state (thread=0x1839a30)
DB: updating node info gsdiron (thread 0x1839a30)
DB: subscription_update took 0,087s
DB: loading subscription vxjukpc update state (thread=0x1839a30)
DB: updating node info vxjukpc (thread 0x1839a30)
DB: subscription_update took 0,091s
DB: loading subscription wpkvrbn update state (thread=0x1839a30)
DB: updating node info wpkvrbn (thread 0x1839a30)
DB: subscription_update took 0,100s
DB: loading subscription xwtmcxh update state (thread=0x1839a30)
DB: updating node info xwtmcxh (thread 0x1839a30)
DB: subscription_update took 0,144s
DB: loading subscription bkyovhi update state (thread=0x1839a30)
DB: updating node info bkyovhi (thread 0x1839a30)
DB: subscription_update took 0,100s
DB: loading subscription oguqmiu update state (thread=0x1839a30)
DB: updating node info oguqmiu (thread 0x1839a30)
DB: subscription_update took 0,122s
DB: loading subscription ahqtobs update state (thread=0x1839a30)
DB: updating node info ahqtobs (thread 0x1839a30)
DB: subscription_update took 0,098s
DB: loading subscription efvykmc update state (thread=0x1839a30)
DB: updating node info efvykmc (thread 0x1839a30)
DB: subscription_update took 0,190s
DB: loading subscription dlxyviu update state (thread=0x1839a30)
DB: updating node info dlxyviu (thread 0x1839a30)
DB: subscription_update took 0,154s
DB: loading subscription rjoovpv update state (thread=0x1839a30)
DB: updating node info rjoovpv (thread 0x1839a30)
DB: subscription_update took 0,099s
DB: loading subscription vdnsgsl update state (thread=0x1839a30)
DB: updating node info vdnsgsl (thread 0x1839a30)
DB: subscription_update took 0,100s
DB: loading subscription gmwakno update state (thread=0x1839a30)
DB: updating node info gmwakno (thread 0x1839a30)
DB: subscription_update took 0,100s
DB: loading subscription puxivgv update state (thread=0x1839a30)
DB: updating node info puxivgv (thread 0x1839a30)
DB: subscription_update took 0,100s
DB: loading subscription glbjvyw update state (thread=0x1839a30)
DB: updating node info glbjvyw (thread 0x1839a30)
DB: subscription_update took 0,100s
DB: loading subscription saycodv update state (thread=0x1839a30)
DB: updating node info saycodv (thread 0x1839a30)
DB: subscription_update took 0,110s
DB: loading subscription vdyvyha update state (thread=0x1839a30)
DB: updating node info vdyvyha (thread 0x1839a30)
DB: subscription_update took 0,178s
DB: checking for lost subscriptions...
DB: saving subscription ywvragm update state (thread=0x1839a30)
DB: update state save took 0,067s
DB: saving subscription pogbvpd update state (thread=0x1839a30)
DB: update state save took 0,130s
DB: saving subscription iaxvjuc update state (thread=0x1839a30)
DB: update state save took 0,112s
DB: saving subscription atdqvby update state (thread=0x1839a30)
DB: update state save took 0,233s
DB: saving subscription dxxtnnt update state (thread=0x1839a30)
DB: update state save took 0,122s
DB: saving subscription wlbdxge update state (thread=0x1839a30)
DB: update state save took 0,111s
DB: saving subscription uetrioa update state (thread=0x1839a30)
DB: update state save took 0,202s
DB: saving subscription ooaloje update state (thread=0x1839a30)
DB: update state save took 0,132s
DB: saving subscription rqmkrcs update state (thread=0x1839a30)
DB: update state save took 0,100s
DB: saving subscription murdiyc update state (thread=0x1839a30)
DB: update state save took 0,168s
DB: saving subscription ocucvcf update state (thread=0x1839a30)
DB: update state save took 0,120s
DB: saving subscription ulphjkj update state (thread=0x1839a30)
DB: update state save took 0,112s
DB: saving subscription xmbatod update state (thread=0x1839a30)
DB: update state save took 0,134s
DB: saving subscription cbaiocf update state (thread=0x1839a30)
DB: update state save took 0,289s
DB: saving subscription fgonlic update state (thread=0x1839a30)
DB: update state save took 0,122s
DB: saving subscription vwksddg update state (thread=0x1839a30)
DB: update state save took 0,123s
DB: saving subscription kiltnas update state (thread=0x1839a30)
DB: update state save took 0,333s
DB: saving subscription nnvsggf update state (thread=0x1839a30)
DB: update state save took 0,133s
DB: saving subscription oxvashn update state (thread=0x1839a30)
DB: update state save took 0,223s
DB: saving subscription aatntuu update state (thread=0x1839a30)
DB: update state save took 0,111s
DB: saving subscription rtydhvn update state (thread=0x1839a30)
DB: update state save took 0,111s
DB: saving subscription fiwtkhq update state (thread=0x1839a30)
DB: update state save took 0,244s
DB: saving subscription cfjeqri update state (thread=0x1839a30)
DB: update state save took 0,123s
DB: saving subscription bylsoai update state (thread=0x1839a30)
DB: update state save took 0,111s
DB: saving subscription tjnmixg update state (thread=0x1839a30)
DB: update state save took 0,122s
DB: saving subscription fggdlnf update state (thread=0x1839a30)
DB: update state save took 0,133s
DB: saving subscription ivhrbuc update state (thread=0x1839a30)
DB: update state save took 0,147s
DB: saving subscription nlxdlqe update state (thread=0x1839a30)
DB: update state save took 0,110s
DB: saving subscription gsdiron update state (thread=0x1839a30)
DB: update state save took 0,134s
DB: saving subscription vxjukpc update state (thread=0x1839a30)
DB: update state save took 0,166s
DB: saving subscription wpkvrbn update state (thread=0x1839a30)
DB: update state save took 0,112s
DB: saving subscription xwtmcxh update state (thread=0x1839a30)
DB: update state save took 0,122s
DB: saving subscription bkyovhi update state (thread=0x1839a30)
DB: update state save took 0,167s
DB: saving subscription oguqmiu update state (thread=0x1839a30)
DB: update state save took 0,112s
DB: saving subscription ahqtobs update state (thread=0x1839a30)
DB: update state save took 0,100s
DB: saving subscription efvykmc update state (thread=0x1839a30)
DB: update state save took 0,100s
DB: saving subscription dlxyviu update state (thread=0x1839a30)
DB: update state save took 0,344s
DB: saving subscription rjoovpv update state (thread=0x1839a30)
DB: update state save took 0,100s
DB: saving subscription vdnsgsl update state (thread=0x1839a30)
DB: update state save took 0,100s
DB: saving subscription gmwakno update state (thread=0x1839a30)
DB: update state save took 0,101s
DB: saving subscription puxivgv update state (thread=0x1839a30)
DB: update state save took 0,124s
DB: saving subscription glbjvyw update state (thread=0x1839a30)
DB: update state save took 0,122s
DB: saving subscription saycodv update state (thread=0x1839a30)
DB: update state save took 0,134s
DB: saving subscription vdyvyha update state (thread=0x1839a30)
DB: update state save took 0,122s
DB: startup took 14,990s
DB: saving subscription ywvragm update state (thread=0x1839a30)
DB: update state save took 0,094s
DB: loading itemset for node "pogbvpd" (thread=0x1839a30)
DB: loading of itemset finished
DB: loading item 34153 (thread=0x1839a30)
DB: loading item 34410 (thread=0x1839a30)
DB: loading item 34425 (thread=0x1839a30)
DB: loading item 34804 (thread=0x1839a30)
DB: loading item 35012 (thread=0x1839a30)
DB: loading item 35022 (thread=0x1839a30)
DB: loading item 35067 (thread=0x1839a30)
DB: loading item 35144 (thread=0x1839a30)
DB: loading item 35302 (thread=0x1839a30)
DB: loading item 35611 (thread=0x1839a30)
DB: update of item "Jauno biedru seminārs 2009" (id=0, thread=0x1839a30)
DB: new item id=35857 for "Jauno biedru seminārs 2009"
DB: insert into table "itemsets": "Jauno biedru seminārs 2009"
DB: item update took 0,573s
DB: update of item "Foto - FMF SP jauno biedru seminārs 2009" (id=0, thread=0x1839a30)
DB: new item id=35858 for "Foto - FMF SP jauno biedru seminārs 2009"
DB: insert into table "itemsets": "Foto - FMF SP jauno biedru seminārs 2009"
DB: item update took 0,576s
DB: update of item "Apgūsti valodu! -  "Couple learning programme"" (id=0, thread=0x1839a30)
DB: new item id=35859 for "Apgūsti valodu! -  "Couple learning programme""
DB: insert into table "itemsets": "Apgūsti valodu! -  "Couple learning programme""
DB: item update took 1,127s
DB: removing item with id 35857
DB: removing item with id 35858
DB: removing item with id 35859
DB: saving subscription pogbvpd update state (thread=0x1839a30)
DB: update state save took 0,277s
DB: loading itemset for node "iaxvjuc" (thread=0x1839a30)
DB: loading of itemset finished
DB: loading item 21592 (thread=0x1839a30)
DB: loading item 21593 (thread=0x1839a30)
DB: loading item 21594 (thread=0x1839a30)
DB: loading item 21595 (thread=0x1839a30)
DB: loading item 21596 (thread=0x1839a30)
DB: saving subscription iaxvjuc update state (thread=0x1839a30)
DB: update state save took 0,191s
DB: loading view for node "rrxdjxk" (thread=0x1839a30)
DB: loading of view finished

(liferea:25393): GLib-GObject-WARNING **: invalid uninstantiatable type `(null)' in cast to `GtkWidget'

(liferea:25393): Gtk-CRITICAL **: gtk_widget_get_toplevel: assertion `GTK_IS_WIDGET (widget)' failed

(liferea:25393): GLib-GObject-WARNING **: invalid uninstantiatable type `(null)' in cast to `GtkWidget'

(liferea:25393): Gtk-CRITICAL **: gtk_widget_get_toplevel: assertion `GTK_IS_WIDGET (widget)' failed

(liferea:25393): GLib-GObject-WARNING **: invalid uninstantiatable type `(null)' in cast to `GtkWidget'

(liferea:25393): Gtk-CRITICAL **: gtk_widget_get_toplevel: assertion `GTK_IS_WIDGET (widget)' failed

(liferea:25393): GLib-GObject-WARNING **: invalid uninstantiatable type `(null)' in cast to `GtkWidget'

(liferea:25393): Gtk-CRITICAL **: gtk_widget_get_toplevel: assertion `GTK_IS_WIDGET (widget)' failed

(liferea:25393): GLib-GObject-WARNING **: invalid uninstantiatable type `(null)' in cast to `GtkWidget'

(liferea:25393): Gtk-CRITICAL **: gtk_widget_get_toplevel: assertion `GTK_IS_WIDGET (widget)' failed

(liferea:25393): GLib-GObject-WARNING **: invalid uninstantiatable type `(null)' in cast to `GtkWidget'

(liferea:25393): Gtk-CRITICAL **: gtk_widget_get_toplevel: assertion `GTK_IS_WIDGET (widget)' failed

(liferea:25393): GLib-GObject-WARNING **: invalid uninstantiatable type `(null)' in cast to `GtkWidget'

(liferea:25393): GLib-GObject-WARNING **: invalid uninstantiatable type `(null)' in cast to `GtkWidget'

(liferea:25393): Gtk-CRITICAL **: gtk_widget_get_toplevel: assertion `GTK_IS_WIDGET (widget)' failed

(liferea:25393): GLib-GObject-WARNING **: invalid uninstantiatable type `(null)' in cast to `GtkWidget'

(liferea:25393): Gtk-CRITICAL **: gtk_style_detach: assertion `style->attach_count > 0' failed