TRACE: + rule_init TRACE: - rule_init TRACE: + db_init DB: Opening DB file /home/alex/.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 subscription... DB: executing SQL: DELETE FROM itemsets WHERE comment = 0 AND node_id NOT IN (SELECT node_id FROM subscription); DB: -> result: 0 (success) 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) TRACE: - db_init CONF: proxy auto detect is configured CONF: no proxy GNOME of $http_proxy configuration found... CONF: Proxy settings are now NULL:0 NULL:NULL TRACE: + plugin_mgmt_get_init PLUGINS: Scanning for plugins (/usr/lib/liferea): PLUGINS: -> LUA Scripting Support Plugin (libliscrlua.so, type=4) PLUGINS: -> libnotify notification (liblinotiflibnotify.so, type=3) PLUGINS: -> XulRunner Rendering Plugin (liblihtmlx.so, type=0) PLUGINS: using "XulRunner" for HTML rendering... TRACE: + mozembed_init (XPCOM_GLUE)