Error Database damage or there is not enough free space

1

Hello All,

for last 2 week, I’m getting this error

“An error occurred while accessing or checking UrBackup’s internal database. This means this database is probably damaged or there is not enough free space. If this error persists, please restore the database (the files backup_server.db, backup_server_files.db, backup_server_links.db, backup_server_link_journal.db and backup_server_settings.db) from a backup. See log file for details.” I tried restoring database but after again I got the same error. I also tried looking here if someone has any solution for this error but no luck :confused:

I have enough space, and I haven’t done anything unusual from the last few months, Urbackup is in windows environment.

What can I try to fix this issue?

Thanks

2

Take a look at the server log file (as the message says). The reason for it should be logged there.

3

Hi @uroni thanks for your input. I tried searching for server log but I can’t see. I have urbackup server installed in windows machine. Could you please advise me how too…?
edit: I have found it urbackup log was in program files.

Many Thanks

4

Hello, @uroni I have found and fixed many errors (like old directors which urbackup couldn’t delete).

I do have few more errors and they are not making sense to me :confused:

2019-09-24 01:37:00: WARNING: SQLite: database corruption at line 64474 of [fb90e7189a] errorcode: 11
2019-09-24 01:37:00: WARNING: SQLite: database corruption at line 64515 of [fb90e7189a] errorcode: 11
2019-09-24 01:37:00: WARNING: SQLite: database corruption at line 64474 of [fb90e7189a] errorcode: 11
2019-09-24 01:37:00: WARNING: SQLite: database corruption at line 64515 of [fb90e7189a] errorcode: 11
2019-09-24 01:37:00: WARNING: SQLite: database corruption at line 64474 of [fb90e7189a] errorcode: 11
2019-09-24 01:37:00: WARNING: SQLite: database corruption at line 64515 of [fb90e7189a] errorcode: 11
2019-09-24 01:37:09: WARNING: SQLite: database corruption at line 64474 of [fb90e7189a] errorcode: 11
2019-09-24 01:37:09: WARNING: SQLite: database corruption at line 64515 of [fb90e7189a] errorcode: 11
2019-09-24 01:37:09: WARNING: SQLite: statement aborts at 20: [PRAGMA quick_check] database disk image is malformed errorcode: 11
2019-09-24 01:37:09: ERROR: SQL: database disk image is malformed Stmt: [PRAGMA quick_check]
2019-09-24 01:37:09: ERROR: Integrity check failed
2019-09-24 01:37:09: ERROR: Database integrity check failed. Skipping Database backup.
2019-09-24 10:05:31: ERROR: Error getting complete file “hmTwUMsTx10Ev1mibucR|.symlink_Pictures/Microsoft team.exe” from COMPUTER19. Errorcode: CANNOT_OPEN_FILE (3)
2019-09-24 10:10:03: WARNING: Restarting shadow copy of C:\ because it was started by this server
2019-09-24 11:02:16: ERROR: Error getting complete file “hmTwUMsTx10Ev1mibucR|Desktop/Warcraft III/w3l.exe” from COMPUTER33. Errorcode: CANNOT_OPEN_FILE (3)
2019-09-24 11:19:55: ERROR: Creating junction failed. Last error=32

How can I repair the database …? I already tried to restore it but no luck. Backup server is running and doing the backups without any issue.

Thank you :slight_smile:

5

Run repair_database.bat. If that doesn’t help, there is nothing more one can do. Either limp along and ignore the error message or start fresh (preferably storing the database on something that does not corrupt itself).

1 Like
6

I just found out about the .recover command of the sqlite3 command line cli ( https://sqlite.org/cli.html#recover_data_from_a_corrupted_database ). I’ll copy that code into repair_database.bat… currently it uses .dump.

1 Like
7

Thank you so much @uroni I did run

repair_database.bat and it did help after that I haven’t received any error.

Thank you