Comment 2 for bug 295490

Revision history for this message
Ciso (cisoprogressivo) wrote :

32bit

this is the output:
:~$ liferea --debug-all
TRACE: + rule_init
TRACE: - rule_init
TRACE: + db_init
DB: Opening DB file /home/ciso/.liferea_1.4/liferea.db...
DB: executing SQL: CREATE TABLE info ( name TEXT, value TEXT, PRIMARY KEY (name) );
DB: -> result: 0 (success)
DB: current DB schema version: -1
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: 0 (success)
DB: executing SQL: CREATE INDEX items_idx ON items (source_id);
DB: -> result: 0 (success)
DB: executing SQL: CREATE INDEX items_idx2 ON items (comment_feed_id);
DB: -> result: 0 (success)
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: 0 (success)
DB: executing SQL: CREATE INDEX itemset_idx ON itemsets (node_id);
DB: -> result: 0 (success)
DB: executing SQL: CREATE INDEX itemset_idx2 ON itemsets (item_id);
DB: -> result: 0 (success)
DB: executing SQL: CREATE TABLE metadata ( item_id INTEGER, nr INTEGER, key TEXT, value TEXT, PRIMARY KEY (item_id, nr));
DB: -> result: 0 (success)
DB: executing SQL: CREATE INDEX metadata_idx ON metadata (item_id);
DB: -> result: 0 (success)
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: 0 (success)
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: 0 (success)
DB: executing SQL: CREATE TABLE subscription_metadata ( node_id STRING, nr INTEGER, key TEXT, value TEXT, PRIMARY KEY (node_id, nr));
DB: -> result: 0 (success)
DB: executing SQL: CREATE INDEX subscription_metadata_idx ON subscription_metadata (node_id);
DB: -> result: 0 (success)
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: 0 (success)
DB: executing SQL: CREATE TABLE view_state ( node_id STRING, unread INTEGER, count INTEGER, PRIMARY KEY (node_id));
DB: -> result: 0 (success)
DB: table setup took 0,015s
DB: executing SQL: DROP TRIGGER item_insert;
DB: -> result: 1 (no such trigger: item_insert)
DB: executing SQL: DROP TRIGGER item_update;
DB: -> result: 1 (no such trigger: item_update)
DB: executing SQL: DROP TRIGGER item_removal;
DB: -> result: 1 (no such trigger: item_removal)
DB: executing SQL: DROP TRIGGER subscription_removal;
DB: -> result: 1 (no such trigger: subscription_removal)
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: -> libnotify notification (liblinotiflibnotify.so, type=3)
PLUGINS: -> XulRunner Rendering Plugin (liblihtmlx.so, type=0)
PLUGINS: -> LUA Scripting Support Plugin (libliscrlua.so, type=4)
PLUGINS: using "XulRunner" for HTML rendering...
TRACE: + mozembed_init (XPCOM_GLUE)
Aborted

I have both Firefox 3 and Firefox 3.1 (xulrunner 1.9 and xulrunner 1.9.1). I see it's about xulrunner from this output.