Saw this while trying to update the Flatpak to 1.16.0. Tried with a clean data directory by deleting /home/bbhtt/.var/app/net.sourceforge.liferea/. Seems to crash immediately.
flatpak run app/net.sourceforge.liferea/x86_64/master --debug-all
22:05:00 DB : Opening DB file /home/bbhtt/.var/app/net.sourceforge.liferea/data/liferea/liferea.db...
22:05:00 DB : executing SQL: PRAGMA journal_mode=WAL
22:05:00 DB : -> result: 0 (success)
22:05:00 DB : executing SQL: PRAGMA page_size=32768
22:05:00 DB : -> result: 0 (success)
22:05:00 DB : executing SQL: PRAGMA synchronous=NORMAL
22:05:00 DB : -> result: 0 (success)
22:05:00 DB : executing SQL: CREATE TABLE info ( name TEXT, value TEXT, PRIMARY KEY (name) );
22:05:00 DB : -> result: 0 (success)
22:05:00 DB : current DB schema version: -1
22:05:00 DB : No VACUUM as freelist count/page count ratio 0.00 <= 10
22:05:00 DB : executing SQL: CREATE TABLE items ( item_id INTEGER PRIMARY KEY AUTOINCREMENT, parent_item_id INTEGER, node_id TEXT, parent_node_id TEXT, title TEXT, read INTEGER, updated INTEGER, popup INTEGER, markedINTEGER, source TEXT, source_id TEXT, valid_guid INTEGER, description TEXT, date INTEGER, comment_feed_id TEXT, comment INTEGER, PRIMARY KEY (item_id));
22:05:00 DB : -> result: 1 (table "items" has more than one primary key)
22:05:00 DB : executing SQL: CREATE INDEX items_idx ON items (source_id);
22:05:00 DB : -> result: 1 (no such table: main.items)
22:05:00 DB : executing SQL: CREATE INDEX items_idx2 ON items (comment_feed_id);
22:05:00 DB : -> result: 1 (no such table: main.items)
22:05:00 DB : executing SQL: CREATE INDEX items_idx3 ON items (node_id);
22:05:00 DB : -> result: 1 (no such table: main.items)
22:05:00 DB : executing SQL: CREATE INDEX items_idx4 ON items (item_id);
22:05:00 DB : -> result: 1 (no such table: main.items)
22:05:00 DB : executing SQL: CREATE INDEX items_idx5 ON items (parent_item_id);
22:05:00 DB : -> result: 1 (no such table: main.items)
22:05:00 DB : executing SQL: CREATE INDEX items_idx6 ON items (parent_node_id);
22:05:00 DB : -> result: 1 (no such table: main.items)
22:05:00 DB : executing SQL: CREATE TABLE metadata ( item_id INTEGER, nr INTEGER, key TEXT, value TEXT, PRIMARY KEY (item_id, nr));
22:05:00 DB : -> result: 0 (success)
22:05:00 DB : executing SQL: CREATE INDEX metadata_idx ON metadata (item_id);
22:05:00 DB : -> result: 0 (success)
22:05:00 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));
22:05:00 DB : -> result: 0 (success)
22:05:00 DB : executing SQL: CREATE TABLE subscription_metadata ( node_id STRING, nr INTEGER, key TEXT, value TEXT, PRIMARY KEY (node_id, nr));
22:05:00 DB : -> result: 0 (success)
22:05:00 DB : executing SQL: CREATE INDEX subscription_metadata_idx ON subscription_metadata (node_id);
22:05:00 DB : -> result: 0 (success)
22:05:00 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));
22:05:00 DB : -> result: 0 (success)
22:05:00 DB : executing SQL: CREATE TABLE search_folder_items ( node_id STRING, parent_node_id STRING, item_id INTEGER, PRIMARY KEY (node_id, item_id));
22:05:00 DB : -> result: 0 (success)
22:05:00 DB : executing SQL: DROP TRIGGER item_insert;
22:05:00 DB : -> result: 1 (no such trigger: item_insert)
22:05:00 DB : executing SQL: DROP TRIGGER item_update;
22:05:00 DB : -> result: 1 (no such trigger: item_update)
22:05:00 DB : executing SQL: DROP TRIGGER item_removal;
22:05:00 DB : -> result: 1 (no such trigger: item_removal)
22:05:00 DB : executing SQL: DROP TRIGGER subscription_removal;
22:05:00 DB : -> result: 1 (no such trigger: subscription_removal)
22:05:00 DB : Checking for items without a feed list node...
22:05:00 DB : executing SQL: DELETE FROM items WHERE comment = 0 AND node_id NOT IN (SELECT node_id FROM node);
22:05:00 DB : -> result: 1 (no such table: items)
22:05:00 DB : Checking for comments without parent item...
22:05:00 DB : executing SQL: BEGIN; CREATE TEMP TABLE tmp_id ( id ); INSERT INTO tmp_id SELECT item_id FROM items WHERE comment = 1 AND parent_item_id NOT IN (SELECT item_id FROM items WHERE comment = 0); DELETE FROM items WHERE item_id IN (SELECT id FROM tmp_id LIMIT 1000); DROP TABLE tmp_id;END;
22:05:00 DB : -> result: 1 (no such table: items)
22:05:00 DB : Checking for search folder items without a feed list node...
22:05:00 DB : executing SQL: DELETE FROM search_folder_items WHERE parent_node_id NOT IN (SELECT node_id FROM node);
22:05:00 DB : -> result: 0 (success)
22:05:00 DB : Checking for search folder items without a search folder...
22:05:00 DB : executing SQL: DELETE FROM search_folder_items WHERE node_id NOT IN (SELECT node_id FROM node);
22:05:00 DB : -> result: 0 (success)
22:05:00 DB : Checking for search folder with comments...
22:05:00 DB : executing SQL: DELETE FROM search_folder_items WHERE comment = 1;
22:05:00 DB : -> result: 1 (no such column: comment)
22:05:00 DB : Checking for subscription metadata without node...
22:05:00 DB : executing SQL: DELETE FROM subscription_metadata WHERE node_id NOT IN (SELECT node_id FROM node);
22:05:00 DB : -> result: 0 (success)
22:05:00 DB : Removing metadata without item...
22:05:00 DB : executing SQL: DELETE FROM metadata WHERE item_id NOT IN (SELECT item_id FROM items);
22:05:00 DB : -> result: 1 (no such table: items)
22:05:00 DB : DB cleanup finished. Continuing startup.
22:05:00 DB : executing SQL: CREATE TRIGGER item_removal DELETE ON items BEGIN DELETE FROM metadata WHERE item_id = old.item_id; DELETE FROM search_folder_items WHERE item_id = old.item_id; END;
22:05:00 DB : -> result: 1 (no such table: main.items)
22:05:00 DB : executing SQL: CREATE TRIGGER subscription_removal DELETE ON subscription BEGIN DELETE FROM node WHERE node_id = old.node_id; DELETE FROM subscription_metadata WHERE node_id = old.node_id; DELETE FROM search_folder_items WHERE parent_node_id = old.node_id; END;
22:05:00 DB : -> result: 0 (success)
**
ERROR:../db.c:756:db_init: assertion failed: (sqlite3_get_autocommit (db))
Bail out! ERROR:../db.c:756:db_init: assertion failed: (sqlite3_get_autocommit (db))
Saw this while trying to update the Flatpak to 1.16.0. Tried with a clean data directory by deleting
/home/bbhtt/.var/app/net.sourceforge.liferea/. Seems to crash immediately.Version
1.16.0
Problematic Behavior
Steps to Reproduce
Expected Behavior
Starts