I have been having issues with SQLite databases in some servers sporadically. The issues starts with the message in the web interface that says that UrBackup cannot read database.
After this, I always run repair-database command and returns things like this:
2020-02-14 10:57:41: SQLite: recovered 14 frames from WAL file /usr/local/var/urbackup/backup_server_settings.db-wal code: 283
2020-02-14 10:57:41: Exporting database with id 30…
2020-02-14 10:57:49: SQLite: recovered 190063 frames from WAL file /usr/local/var/urbackup/backup_server_files.db-wal code: 283
2020-02-14 10:57:49: Exporting database with id 23…
2020-02-14 10:59:49: WARNING: SQLite: database corruption at line 64011 of [0ee482a1e0] errorcode: 11
2020-02-14 10:59:49: WARNING: SQLite: statement aborts at 2: [SELECT ‘INSERT INTO ’ || ‘“files_incoming_stat”’ || ’ VALUES(’ || quote(“id”) || ‘,’ || quote(“filesize”) || ‘,’ || quote(“clientid”) || ‘,’ || quote(“backupid”) || ‘,’ || quote("existi errorcode: 11
2020-02-14 10:59:49: WARNING: SQLite: database corruption at line 64011 of [0ee482a1e0] errorcode: 11
2020-02-14 10:59:49: WARNING: SQLite: statement aborts at 3: [SELECT ‘INSERT INTO ’ || ‘“files_incoming_stat”’ || ’ VALUES(’ || quote(“id”) || ‘,’ || quote(“filesize”) || ‘,’ || quote(“clientid”) || ‘,’ || quote(“backupid”) || ‘,’ || quote("existi errorcode: 11
2020-02-14 10:59:49: Exporting database with id 24…
2020-02-14 10:59:49: SQLite: recovered 1 frames from WAL file /usr/local/var/urbackup/backup_server_link_journal.db-wal code: 283
All my servers are running in Linux Debian 8 or 9 with Btrfs in root partition and data partition, some of them are Virtual machines, some are phisical servers, some are NAS (i.e. Netgear wich have an embeded Debian 8). I have experienced this class of problems in all of them.
This is the major issue I am having currently with UrBackup, I need to stay very attent to ensure that all servers are working correctly every day.
Many thanks.