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 
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/urbackupfolder’s content file by file intoC:\Program Files\UrBackupServer\urbackup, restarting the application each time - Found that
backup_server_settings.dbmakes 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 
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 .