Urbackup Server doesn't start up after updating to 2.5.25

I updated Urbackup on my linux Mint machine, and it stopped starting up. After removing the database files it’s able to start just fine, but of course I don’t have my backups. Any help? I can provide the logs but I don’t know where to find them

Please read Having problems with UrBackup? Please read before posting to obtain logfiles. Without logfile, we dont see whats going on.

Here’s the log. It seems that the database didn’t update maybe? I’ve used linux mint’s update manager so it might be the issue

2022-08-29 13:37:59: WARNING: SQLite: statement aborts at 3: [DELETE FROM directory_link_journal] attempt to write a readonly database errorcode: 8
2022-08-29 13:38:00: ERROR: Error in CQuery::Execute - attempt to write a readonly database  Stmt: [DELETE FROM directory_link_journal]
2022-08-29 13:38:00: ERROR: SQL: attempt to write a readonly database Stmt: [DELETE FROM directory_link_journal]
2022-08-29 13:38:00: WARNING: SQLite: no such column: value_client in "SELECT value, value_client, use FROM settings_db.settings WHERE clientid=? AND key=?" errorcode: 1
2022-08-29 13:38:00: ERROR: Error preparing Query [SELECT value, value_client, use FROM settings_db.settings WHERE clientid=? AND key=?]: no such column: value_client. Retrying in 1s...
2022-08-29 13:38:00: WARNING: SQLite: no such column: value_client in "SELECT value, value_client, use FROM settings_db.settings WHERE clientid=? AND key=?" errorcode: 1
2022-08-29 13:38:00: ERROR: Error preparing Query [SELECT value, value_client, use FROM settings_db.settings WHERE clientid=? AND key=?]: no such column: value_client. Retrying in 1s...
2022-08-29 13:38:01: WARNING: SQLite: no such column: value_client in "SELECT value, value_client, use FROM settings_db.settings WHERE clientid=? AND key=?" errorcode: 1
2022-08-29 13:38:01: ERROR: Error preparing Query [SELECT value, value_client, use FROM settings_db.settings WHERE clientid=? AND key=?]: no such column: value_client. Retrying in 1s...
2022-08-29 13:38:01: WARNING: SQLite: no such column: value_client in "SELECT value, value_client, use FROM settings_db.settings WHERE clientid=? AND key=?" errorcode: 1
2022-08-29 13:38:01: ERROR: Error preparing Query [SELECT value, value_client, use FROM settings_db.settings WHERE clientid=? AND key=?]: no such column: value_client. Retrying in 1s...
2022-08-29 13:38:02: WARNING: SQLite: no such column: value_client in "SELECT value, value_client, use FROM settings_db.settings WHERE clientid=? AND key=?" errorcode: 1
2022-08-29 13:38:02: ERROR: Error preparing Query [SELECT value, value_client, use FROM settings_db.settings WHERE clientid=? AND key=?]: no such column: value_client. Retrying in 1s...
2022-08-29 13:38:02: WARNING: SQLite: no such column: value_client in "SELECT value, value_client, use FROM settings_db.settings WHERE clientid=? AND key=?" errorcode: 1
2022-08-29 13:38:02: ERROR: Error preparing Query [SELECT value, value_client, use FROM settings_db.settings WHERE clientid=? AND key=?]: no such column: value_client. Retrying in 1s...
2022-08-29 13:38:03: WARNING: SQLite: no such column: value_client in "SELECT value, value_client, use FROM settings_db.settings WHERE clientid=? AND key=?" errorcode: 1
2022-08-29 13:38:03: ERROR: Error preparing Query [SELECT value, value_client, use FROM settings_db.settings WHERE clientid=? AND key=?]: no such column: value_client. Retrying in 1s...
2022-08-29 13:38:03: WARNING: SQLite: no such column: value_client in "SELECT value, value_client, use FROM settings_db.settings WHERE clientid=? AND key=?" errorcode: 1
2022-08-29 13:38:03: ERROR: Error preparing Query [SELECT value, value_client, use FROM settings_db.settings WHERE clientid=? AND key=?]: no such column: value_client. Retrying in 1s...
2022-08-29 13:38:04: WARNING: SQLite: no such column: value_client in "SELECT value, value_client, use FROM settings_db.settings WHERE clientid=? AND key=?" errorcode: 1
2022-08-29 13:38:04: ERROR: Error preparing Query [SELECT value, value_client, use FROM settings_db.settings WHERE clientid=? AND key=?]: no such column: value_client. Retrying in 1s...
2022-08-29 13:38:04: WARNING: SQLite: no such column: value_client in "SELECT value, value_client, use FROM settings_db.settings WHERE clientid=? AND key=?" errorcode: 1
2022-08-29 13:38:04: ERROR: Error preparing Query [SELECT value, value_client, use FROM settings_db.settings WHERE clientid=? AND key=?]: no such column: value_client. Retrying in 1s...
2022-08-29 13:38:05: WARNING: SQLite: no such column: value_client in "SELECT value, value_client, use FROM settings_db.settings WHERE clientid=? AND key=?" errorcode: 1
2022-08-29 13:38:05: ERROR: Error preparing Query [SELECT value, value_client, use FROM settings_db.settings WHERE clientid=? AND key=?]: no such column: value_client

The error says it all: the database appears to be read only.

The database should be located under /var/urbackup. Could you post the result of ls -la /var/urbackup for me? I assume that some process changed the owner and/or properties of the file(s), so that the user „urbackup“ is not longer able to write there.

Here’s the output.

root@Imaginary-Tree:/var/urbackup# ls -la /var/urbackup
total 1984124
drwxr-xr-x  3 urbackup urbackup      4096 Aug 29 13:37 .
drwxr-xr-x 13 root     root          4096 Aug 28 17:08 ..
-rw-r--r--  1 urbackup urbackup        23 Aug 15 17:14 backupfolder
-rwxrwxrwx  1 urbackup urbackup  52428800 Aug 27 01:53 backup_server.db
-rw-r--r--  1 urbackup urbackup     65536 Aug 29 16:30 backup_server.db-shm
-rwxrwxrwx  1 urbackup urbackup  73401952 Aug 27 01:53 backup_server.db-wal
-rwxrwxrwx  1 urbackup urbackup 681574400 Aug 27 01:54 backup_server_files.db
-rwxrwxrwx  1 urbackup urbackup    589824 Aug 29 16:30 backup_server_files.db-shm
-rwxrwxrwx  1 urbackup urbackup 300570512 Aug 27 01:55 backup_server_files.db-wal
-rwxrwxrwx  1 urbackup urbackup  52428800 Aug 27 01:57 backup_server_link_journal.db
-rw-r--r--  1 urbackup urbackup     32768 Aug 29 16:30 backup_server_link_journal.db-shm
-rwxrwxrwx  1 urbackup urbackup  10501912 Aug 29 16:30 backup_server_link_journal.db-wal
-rwxrwxrwx  1 urbackup urbackup  52428800 Aug 27 01:55 backup_server_links.db
-rwxrwxrwx  1 urbackup urbackup    983040 Aug 29 16:30 backup_server_links.db-shm
-rwxrwxrwx  1 urbackup urbackup 734126352 Aug 27 01:56 backup_server_links.db-wal
-rwxrwxrwx  1 urbackup urbackup    102400 Aug 27 01:54 backup_server_settings.db
-rwxrwxrwx  1 urbackup urbackup     32768 Aug 29 16:30 backup_server_settings.db-shm
-rwxrwxrwx  1 urbackup urbackup    885832 Aug 27 01:54 backup_server_settings.db-wal
-rwxrwxrwx  1 urbackup urbackup        23 Aug 27 01:57 clientlist_b_107.ub
-rwxrwxrwx  1 urbackup urbackup   3752224 Aug 27 01:57 clientlist_b_133.ub
-rwxrwxrwx  1 urbackup urbackup         0 Aug 27 01:57 clientlist_b_186.ub
-rwxrwxrwx  1 urbackup urbackup   1419961 Aug 27 01:57 clientlist_b_192.ub
-rwxrwxrwx  1 urbackup urbackup   3165665 Aug 27 01:57 clientlist_b_361.ub
-rwxrwxrwx  1 urbackup urbackup   2278594 Aug 27 01:57 clientlist_b_365.ub
-rw-r--r--  1 urbackup urbackup       162 Nov 19  2012 dataplan_db.txt
drwxr-x---  2 urbackup urbackup      4096 Aug 28 17:09 fileindex
-rwxrwxrwx  1 urbackup urbackup        83 Aug 27 01:57 server_ident_ecdsa409k1.priv
-rwxrwxrwx  1 urbackup urbackup       128 Aug 27 01:57 server_ident_ecdsa409k1.pub
-rwxrwxrwx  1 urbackup urbackup        23 Aug 27 01:57 server_ident.key
-rwxrwxrwx  1 urbackup urbackup       334 Aug 27 01:57 server_ident.priv
-rwxrwxrwx  1 urbackup urbackup       442 Aug 27 01:57 server_ident.pub
-rw-r--r--  1 urbackup urbackup        20 Aug 15 17:14 server_token.key
-rwxr-x---  1 urbackup urbackup        52 Aug 28 17:09 server_version_info.properties
-rwxr-x---  1 urbackup urbackup  35558654 Aug 28 17:09 UrBackupUpdate.exe
-rwxr-x---  1 urbackup urbackup  25304801 Aug 28 17:09 UrBackupUpdateLinux.sh
-rwxr-x---  1 urbackup urbackup       102 Aug 28 17:09 UrBackupUpdateLinux.sig2
-rwxr-x---  1 urbackup urbackup        40 Aug 28 17:09 UrBackupUpdate.sig
-rwxr-x---  1 urbackup urbackup       102 Aug 28 17:09 UrBackupUpdate.sig2
-rw-r--r--  1 urbackup urbackup         3 Aug 15 17:16 version_linux.txt
-rw-r--r--  1 urbackup urbackup         3 Aug 15 17:15 version.txt

This looks good.

Are your sure that some older urbackup instance is not running somehow? Did you simply rebooted your system once? If yes, whats the value for USER= inside /etc/default/urbackupsrv?

I did reboot the machine multiple times for other apps, there’s no other urbackup instance to be found running (systemctl status report it being active (exited), I even cannot access the localhost dashboard, clients don’t find a server), and USER=urbackup

So I’m pretty lost. I’m gonna try copying the server files to a windows machine to see if anything happens.

Interesting.

Maybe @uroni can assist here :confused:

After a bit of messing around on Windows, I found out that if you copy every .db files except the settings, it works again. While I would prefer to recover my settings (for me or any other having the same problem), it’s enough of a temporary fix.

Except settings?

Ok here’s what I done:

  • Installed Urbackupsvr on my windows machine
  • Copied the var/urbackup folder’s content file by file into C:\Program Files\UrBackupServer\urbackup, restarting the application each time
  • Found that backup_server_settings.db makes the server crash upon restart

So for now I’m just going to put a fresh backup_server_settings.db files on my server, reconfigure it, and wait to know if there’s any way to recover the broken backup_server_settings.db

Is there any other error/warning during server start? Could you post a complete startup log?

Could you try to open the settings db with an SQLite DB Manager? I dont get whats wrong with the db :thinking:

Looks like my solution doesn’t work on linux for some reason. So I’m still stuck. Here’s a full log

2022-08-29 22:17:46: Starting HTTP-Server on port 55414
2022-08-29 22:17:46: HTTP: Server started up successfully!
2022-08-29 22:18:03: SQLite: recovered 8156 frames from WAL file /var/urbackup/backup_server.db-wal code: 283
2022-08-29 22:19:04: SQLite: recovered 72954 frames from WAL file /var/urbackup/backup_server_files.db-wal code: 283
2022-08-29 22:19:04: SQLite: recovered 245 frames from WAL file /var/urbackup/backup_server_link_journal.db-wal code: 283
2022-08-29 22:19:52: SQLite: recovered 121131 frames from WAL file /var/urbackup/backup_server_links.db-wal code: 283
2022-08-29 22:19:52: SQLite: recovered 3 frames from WAL file /var/urbackup/backup_server_settings.db-wal code: 283
2022-08-29 22:19:52: WARNING: SQLite: database corruption at line 67286 of [3bfa9cc97d] errorcode: 11
2022-08-29 22:19:52: WARNING: SQLite: database disk image is malformed in "PRAGMA synchronous=NORMAL" errorcode: 11
2022-08-29 22:19:52: ERROR: Error preparing Query [PRAGMA synchronous=NORMAL]: database disk image is malformed. Retrying in 1s...
2022-08-29 22:19:53: WARNING: SQLite: database corruption at line 67286 of [3bfa9cc97d] errorcode: 11
2022-08-29 22:19:53: WARNING: SQLite: database disk image is malformed in "PRAGMA synchronous=NORMAL" errorcode: 11
2022-08-29 22:19:53: ERROR: Error preparing Query [PRAGMA synchronous=NORMAL]: database disk image is malformed. Retrying in 1s...
2022-08-29 22:19:54: WARNING: SQLite: database corruption at line 67286 of [3bfa9cc97d] errorcode: 11
2022-08-29 22:19:54: WARNING: SQLite: database disk image is malformed in "PRAGMA synchronous=NORMAL" errorcode: 11
2022-08-29 22:19:54: ERROR: Error preparing Query [PRAGMA synchronous=NORMAL]: database disk image is malformed. Retrying in 1s...
2022-08-29 22:19:55: WARNING: SQLite: database corruption at line 67286 of [3bfa9cc97d] errorcode: 11
2022-08-29 22:19:55: WARNING: SQLite: database disk image is malformed in "PRAGMA synchronous=NORMAL" errorcode: 11
2022-08-29 22:19:55: ERROR: Error preparing Query [PRAGMA synchronous=NORMAL]: database disk image is malformed. Retrying in 1s...
2022-08-29 22:19:56: WARNING: SQLite: database corruption at line 67286 of [3bfa9cc97d] errorcode: 11
2022-08-29 22:19:56: WARNING: SQLite: database disk image is malformed in "PRAGMA synchronous=NORMAL" errorcode: 11
2022-08-29 22:19:56: ERROR: Error preparing Query [PRAGMA synchronous=NORMAL]: database disk image is malformed. Retrying in 1s...
2022-08-29 22:19:57: WARNING: SQLite: database corruption at line 67286 of [3bfa9cc97d] errorcode: 11
2022-08-29 22:19:57: WARNING: SQLite: database disk image is malformed in "PRAGMA synchronous=NORMAL" errorcode: 11
2022-08-29 22:19:57: ERROR: Error preparing Query [PRAGMA synchronous=NORMAL]: database disk image is malformed
2022-08-29 22:19:57: WARNING: SQLite: database corruption at line 67286 of [3bfa9cc97d] errorcode: 11
2022-08-29 22:19:57: WARNING: SQLite: database disk image is malformed in "PRAGMA cache_size = -2048" errorcode: 11
2022-08-29 22:19:57: ERROR: Error preparing Query [PRAGMA cache_size = -2048]: database disk image is malformed. Retrying in 1s...
2022-08-29 22:19:58: WARNING: SQLite: database corruption at line 67286 of [3bfa9cc97d] errorcode: 11
2022-08-29 22:19:58: WARNING: SQLite: database disk image is malformed in "PRAGMA cache_size = -2048" errorcode: 11
2022-08-29 22:19:58: ERROR: Error preparing Query [PRAGMA cache_size = -2048]: database disk image is malformed. Retrying in 1s...
2022-08-29 22:19:59: WARNING: SQLite: database corruption at line 67286 of [3bfa9cc97d] errorcode: 11
2022-08-29 22:19:59: WARNING: SQLite: database disk image is malformed in "PRAGMA cache_size = -2048" errorcode: 11
2022-08-29 22:19:59: ERROR: Error preparing Query [PRAGMA cache_size = -2048]: database disk image is malformed. Retrying in 1s...
2022-08-29 22:20:00: WARNING: SQLite: database corruption at line 67286 of [3bfa9cc97d] errorcode: 11
2022-08-29 22:20:00: WARNING: SQLite: database disk image is malformed in "PRAGMA cache_size = -2048" errorcode: 11
2022-08-29 22:20:00: ERROR: Error preparing Query [PRAGMA cache_size = -2048]: database disk image is malformed. Retrying in 1s...
2022-08-29 22:20:01: WARNING: SQLite: database corruption at line 67286 of [3bfa9cc97d] errorcode: 11
2022-08-29 22:20:01: WARNING: SQLite: database disk image is malformed in "PRAGMA cache_size = -2048" errorcode: 11
2022-08-29 22:20:01: ERROR: Error preparing Query [PRAGMA cache_size = -2048]: database disk image is malformed. Retrying in 1s...
2022-08-29 22:20:02: WARNING: SQLite: database corruption at line 67286 of [3bfa9cc97d] errorcode: 11
2022-08-29 22:20:02: WARNING: SQLite: database disk image is malformed in "PRAGMA cache_size = -2048" errorcode: 11
2022-08-29 22:20:02: ERROR: Error preparing Query [PRAGMA cache_size = -2048]: database disk image is malformed
2022-08-29 22:20:03: SQLite: recovered 8156 frames from WAL file /var/urbackup/backup_server.db-wal code: 283
2022-08-29 22:20:03: SQLite: recovered 3 frames from WAL file /var/urbackup/backup_server_settings.db-wal code: 283
2022-08-29 22:20:03: WARNING: SQLite: database corruption at line 67286 of [3bfa9cc97d] errorcode: 11
2022-08-29 22:20:03: WARNING: SQLite: statement aborts at 4: [ATTACH DATABASE 'urbackup/backup_server_settings.db' AS settings_db] database disk image is malformed errorcode: 11
2022-08-29 22:20:03: ERROR: Error in CQuery::Execute - database disk image is malformed  Stmt: [ATTACH DATABASE 'urbackup/backup_server_settings.db' AS settings_db]
2022-08-29 22:20:03: ERROR: SQL: database disk image is malformed Stmt: [ATTACH DATABASE 'urbackup/backup_server_settings.db' AS settings_db]
2022-08-29 22:20:03: WARNING: SQLite: unknown database settings_db in "PRAGMA settings_db.synchronous=NORMAL" errorcode: 1
2022-08-29 22:20:03: ERROR: Error preparing Query [PRAGMA settings_db.synchronous=NORMAL]: unknown database settings_db. Retrying in 1s...
2022-08-29 22:20:04: WARNING: SQLite: unknown database settings_db in "PRAGMA settings_db.synchronous=NORMAL" errorcode: 1
2022-08-29 22:20:04: ERROR: Error preparing Query [PRAGMA settings_db.synchronous=NORMAL]: unknown database settings_db. Retrying in 1s...
2022-08-29 22:20:05: WARNING: SQLite: unknown database settings_db in "PRAGMA settings_db.synchronous=NORMAL" errorcode: 1
2022-08-29 22:20:05: ERROR: Error preparing Query [PRAGMA settings_db.synchronous=NORMAL]: unknown database settings_db. Retrying in 1s...
2022-08-29 22:20:06: WARNING: SQLite: unknown database settings_db in "PRAGMA settings_db.synchronous=NORMAL" errorcode: 1
2022-08-29 22:20:06: ERROR: Error preparing Query [PRAGMA settings_db.synchronous=NORMAL]: unknown database settings_db. Retrying in 1s...
2022-08-29 22:20:07: WARNING: SQLite: unknown database settings_db in "PRAGMA settings_db.synchronous=NORMAL" errorcode: 1
2022-08-29 22:20:07: ERROR: Error preparing Query [PRAGMA settings_db.synchronous=NORMAL]: unknown database settings_db. Retrying in 1s...
2022-08-29 22:20:08: WARNING: SQLite: unknown database settings_db in "PRAGMA settings_db.synchronous=NORMAL" errorcode: 1
2022-08-29 22:20:08: ERROR: Error preparing Query [PRAGMA settings_db.synchronous=NORMAL]: unknown database settings_db
2022-08-29 22:20:08: SQLite: recovered 72954 frames from WAL file /var/urbackup/backup_server_files.db-wal code: 283
2022-08-29 22:20:08: SQLite: recovered 121131 frames from WAL file /var/urbackup/backup_server_links.db-wal code: 283
2022-08-29 22:20:08: SQLite: recovered 245 frames from WAL file /var/urbackup/backup_server_link_journal.db-wal code: 283
2022-08-29 22:20:08: WARNING: SQLite: no such table: settings_db.settings in "SELECT value FROM settings_db.settings WHERE key='backupfolder' AND clientid=0" errorcode: 1
2022-08-29 22:20:08: ERROR: Error preparing Query [SELECT value FROM settings_db.settings WHERE key='backupfolder' AND clientid=0]: no such table: settings_db.settings. Retrying in 1s...
2022-08-29 22:20:09: WARNING: SQLite: no such table: settings_db.settings in "SELECT value FROM settings_db.settings WHERE key='backupfolder' AND clientid=0" errorcode: 1
2022-08-29 22:20:09: ERROR: Error preparing Query [SELECT value FROM settings_db.settings WHERE key='backupfolder' AND clientid=0]: no such table: settings_db.settings. Retrying in 1s...
2022-08-29 22:20:10: WARNING: SQLite: no such table: settings_db.settings in "SELECT value FROM settings_db.settings WHERE key='backupfolder' AND clientid=0" errorcode: 1
2022-08-29 22:20:10: ERROR: Error preparing Query [SELECT value FROM settings_db.settings WHERE key='backupfolder' AND clientid=0]: no such table: settings_db.settings. Retrying in 1s...
2022-08-29 22:20:11: WARNING: SQLite: no such table: settings_db.settings in "SELECT value FROM settings_db.settings WHERE key='backupfolder' AND clientid=0" errorcode: 1
2022-08-29 22:20:11: ERROR: Error preparing Query [SELECT value FROM settings_db.settings WHERE key='backupfolder' AND clientid=0]: no such table: settings_db.settings. Retrying in 1s...
2022-08-29 22:20:12: WARNING: SQLite: no such table: settings_db.settings in "SELECT value FROM settings_db.settings WHERE key='backupfolder' AND clientid=0" errorcode: 1
2022-08-29 22:20:12: ERROR: Error preparing Query [SELECT value FROM settings_db.settings WHERE key='backupfolder' AND clientid=0]: no such table: settings_db.settings. Retrying in 1s...
2022-08-29 22:20:13: WARNING: SQLite: no such table: settings_db.settings in "SELECT value FROM settings_db.settings WHERE key='backupfolder' AND clientid=0" errorcode: 1
2022-08-29 22:20:13: ERROR: Error preparing Query [SELECT value FROM settings_db.settings WHERE key='backupfolder' AND clientid=0]: no such table: settings_db.settings
2022-08-29 22:20:13: WARNING: SQLite: no such table: settings_db.settings in "INSERT INTO settings_db.settings (key, value, clientid) VALUES ('backupfolder', ?, 0)" errorcode: 1
2022-08-29 22:20:13: ERROR: Error preparing Query [INSERT INTO settings_db.settings (key, value, clientid) VALUES ('backupfolder', ?, 0)]: no such table: settings_db.settings. Retrying in 1s...
2022-08-29 22:20:14: WARNING: SQLite: no such table: settings_db.settings in "INSERT INTO settings_db.settings (key, value, clientid) VALUES ('backupfolder', ?, 0)" errorcode: 1
2022-08-29 22:20:14: ERROR: Error preparing Query [INSERT INTO settings_db.settings (key, value, clientid) VALUES ('backupfolder', ?, 0)]: no such table: settings_db.settings. Retrying in 1s...
2022-08-29 22:20:15: WARNING: SQLite: no such table: settings_db.settings in "INSERT INTO settings_db.settings (key, value, clientid) VALUES ('backupfolder', ?, 0)" errorcode: 1
2022-08-29 22:20:15: ERROR: Error preparing Query [INSERT INTO settings_db.settings (key, value, clientid) VALUES ('backupfolder', ?, 0)]: no such table: settings_db.settings. Retrying in 1s...
2022-08-29 22:20:16: WARNING: SQLite: no such table: settings_db.settings in "INSERT INTO settings_db.settings (key, value, clientid) VALUES ('backupfolder', ?, 0)" errorcode: 1
2022-08-29 22:20:16: ERROR: Error preparing Query [INSERT INTO settings_db.settings (key, value, clientid) VALUES ('backupfolder', ?, 0)]: no such table: settings_db.settings. Retrying in 1s...
2022-08-29 22:20:17: WARNING: SQLite: no such table: settings_db.settings in "INSERT INTO settings_db.settings (key, value, clientid) VALUES ('backupfolder', ?, 0)" errorcode: 1
2022-08-29 22:20:17: ERROR: Error preparing Query [INSERT INTO settings_db.settings (key, value, clientid) VALUES ('backupfolder', ?, 0)]: no such table: settings_db.settings. Retrying in 1s...
2022-08-29 22:20:18: WARNING: SQLite: no such table: settings_db.settings in "INSERT INTO settings_db.settings (key, value, clientid) VALUES ('backupfolder', ?, 0)" errorcode: 1
2022-08-29 22:20:18: ERROR: Error preparing Query [INSERT INTO settings_db.settings (key, value, clientid) VALUES ('backupfolder', ?, 0)]: no such table: settings_db.settings

As for opening the DB… I can open it but it seems empty

This seem to be different now. The setting database seem to be corrupt. Is this the original file?

I cant assist in this one. Maybe you can restore the database from its backup. Was it enabled? Look at ur backup path, there should be a folder called „urbackup“ with the complete database files in it. You could try to restore it.

Yeah that’s the original file.

I copied the backup DB in the var folder (17:38) and tried it. Then I restarted it after forcing the RW permissions (17:46).

2022-08-30 17:37:02: Starting HTTP-Server on port 55414
2022-08-30 17:37:02: HTTP: Server started up successfully!
2022-08-30 17:37:23: SQLite: recovered 8156 frames from WAL file /var/urbackup/backup_server.db-wal code: 283
2022-08-30 17:38:17: SQLite: recovered 72954 frames from WAL file /var/urbackup/backup_server_files.db-wal code: 283
2022-08-30 17:38:17: SQLite: recovered 243 frames from WAL file /var/urbackup/backup_server_link_journal.db-wal code: 283
2022-08-30 17:38:38: SQLite: recovered 121131 frames from WAL file /var/urbackup/backup_server_links.db-wal code: 283
2022-08-30 17:38:38: SQLite: recovered 33 frames from WAL file /var/urbackup/backup_server_settings.db-wal code: 283
2022-08-30 17:38:38: SQLite: recovered 8156 frames from WAL file /var/urbackup/backup_server.db-wal code: 283
2022-08-30 17:38:38: SQLite: recovered 33 frames from WAL file /var/urbackup/backup_server_settings.db-wal code: 283
2022-08-30 17:38:39: SQLite: recovered 72954 frames from WAL file /var/urbackup/backup_server_files.db-wal code: 283
2022-08-30 17:38:39: SQLite: recovered 121131 frames from WAL file /var/urbackup/backup_server_links.db-wal code: 283
2022-08-30 17:38:39: SQLite: recovered 243 frames from WAL file /var/urbackup/backup_server_link_journal.db-wal code: 283
2022-08-30 17:38:39: ERROR: LMDB: Failed to open LMDB database file (Permission denied)
2022-08-30 17:38:39: ERROR: LMDB error creating env
2022-08-30 17:38:39: ERROR: Could not create or open file entry index. Exiting.
2022-08-30 17:46:34: Starting HTTP-Server on port 55414
2022-08-30 17:46:34: HTTP: Server started up successfully!
2022-08-30 17:46:52: SQLite: recovered 8156 frames from WAL file /var/urbackup/backup_server.db-wal code: 283
2022-08-30 17:47:44: SQLite: recovered 72954 frames from WAL file /var/urbackup/backup_server_files.db-wal code: 283
2022-08-30 17:47:44: SQLite: recovered 243 frames from WAL file /var/urbackup/backup_server_link_journal.db-wal code: 283
2022-08-30 17:48:23: SQLite: recovered 121131 frames from WAL file /var/urbackup/backup_server_links.db-wal code: 283
2022-08-30 17:48:24: SQLite: recovered 33 frames from WAL file /var/urbackup/backup_server_settings.db-wal code: 283
2022-08-30 17:48:24: SQLite: recovered 8156 frames from WAL file /var/urbackup/backup_server.db-wal code: 283
2022-08-30 17:48:24: SQLite: recovered 33 frames from WAL file /var/urbackup/backup_server_settings.db-wal code: 283
2022-08-30 17:48:24: SQLite: recovered 72954 frames from WAL file /var/urbackup/backup_server_files.db-wal code: 283
2022-08-30 17:48:24: SQLite: recovered 121131 frames from WAL file /var/urbackup/backup_server_links.db-wal code: 283
2022-08-30 17:48:24: SQLite: recovered 243 frames from WAL file /var/urbackup/backup_server_link_journal.db-wal code: 283
2022-08-30 17:48:25: Started UrBackup...
2022-08-30 17:48:25: Removing temporary files...
2022-08-30 17:48:25: Recreating temporary folder...
2022-08-30 17:48:25: WARNING: SQLite: no such column: value_client in "SELECT value, value_client, use FROM settings_db.settings WHERE clientid=? AND key=?" errorcode: 1
2022-08-30 17:48:25: ERROR: Error preparing Query [SELECT value, value_client, use FROM settings_db.settings WHERE clientid=? AND key=?]: no such column: value_client. Retrying in 1s...
2022-08-30 17:48:26: WARNING: SQLite: no such column: value_client in "SELECT value, value_client, use FROM settings_db.settings WHERE clientid=? AND key=?" errorcode: 1
2022-08-30 17:48:26: ERROR: Error preparing Query [SELECT value, value_client, use FROM settings_db.settings WHERE clientid=? AND key=?]: no such column: value_client. Retrying in 1s...
2022-08-30 17:48:27: Testing if backup destination can handle subvolumes and snapshots...
2022-08-30 17:48:27: WARNING: SQLite: no such column: value_client in "SELECT value, value_client, use FROM settings_db.settings WHERE clientid=? AND key=?" errorcode: 1
2022-08-30 17:48:27: ERROR: Error preparing Query [SELECT value, value_client, use FROM settings_db.settings WHERE clientid=? AND key=?]: no such column: value_client. Retrying in 1s...
2022-08-30 17:48:28: Backup destination cannot handle subvolumes and snapshots. Snapshots disabled.
2022-08-30 17:48:28: Testing if backup destination can handle filesystem transactions...
2022-08-30 17:48:28: WARNING: SQLite: no such column: value_client in "SELECT value, value_client, use FROM settings_db.settings WHERE clientid=? AND key=?" errorcode: 1
2022-08-30 17:48:28: ERROR: Error preparing Query [SELECT value, value_client, use FROM settings_db.settings WHERE clientid=? AND key=?]: no such column: value_client. Retrying in 1s...
2022-08-30 17:48:28: WARNING: SQLite: no such column: value_client in "SELECT value, value_client, use FROM settings_db.settings WHERE clientid=? AND key=?" errorcode: 1
2022-08-30 17:48:28: ERROR: Error preparing Query [SELECT value, value_client, use FROM settings_db.settings WHERE clientid=? AND key=?]: no such column: value_client. Retrying in 1s...
2022-08-30 17:48:29: WARNING: SQLite: no such column: value_client in "SELECT value, value_client, use FROM settings_db.settings WHERE clientid=? AND key=?" errorcode: 1
2022-08-30 17:48:29: ERROR: Error preparing Query [SELECT value, value_client, use FROM settings_db.settings WHERE clientid=? AND key=?]: no such column: value_client. Retrying in 1s...
2022-08-30 17:48:29: WARNING: SQLite: no such column: value_client in "SELECT value, value_client, use FROM settings_db.settings WHERE clientid=? AND key=?" errorcode: 1
2022-08-30 17:48:29: ERROR: Error preparing Query [SELECT value, value_client, use FROM settings_db.settings WHERE clientid=? AND key=?]: no such column: value_client. Retrying in 1s...
2022-08-30 17:48:30: WARNING: SQLite: no such column: value_client in "SELECT value, value_client, use FROM settings_db.settings WHERE clientid=? AND key=?" errorcode: 1
2022-08-30 17:48:30: ERROR: Error preparing Query [SELECT value, value_client, use FROM settings_db.settings WHERE clientid=? AND key=?]: no such column: value_client. Retrying in 1s...
2022-08-30 17:48:30: WARNING: SQLite: no such column: value_client in "SELECT value, value_client, use FROM settings_db.settings WHERE clientid=? AND key=?" errorcode: 1
2022-08-30 17:48:30: ERROR: Error preparing Query [SELECT value, value_client, use FROM settings_db.settings WHERE clientid=? AND key=?]: no such column: value_client

Note: Those .db files are from before the update. As soon as the update gone through Urbackup stopped working

Oh… Having Urbackup still running during updating might have been the cause of the bug? I didn’t think of stopping it.

Updating urbackup should safely stop/start the service automatically.

Well then no idea what happened then.
But it still doesn’t work. Is there anyway to maybe downgrade urbackup and try updating again? I can’t find a way to download older packages

It should upgrade the database as needed during startup (correct me, if Iam wrong, uroni).

You can grab the backup database again and install the older version from Index of /Server/2.4.15 .