Hello,
Suddenly backups stopped, it worked fine for at least a year, restarted both server (win) and clients (win), I tried the script to fix the database.
I’ve upgraded both the server and the clients to the latest version, nothing worked.
I also tried to restore database files taken from the backup directory.
I attach the logs:
Server:
2017-05-24 20:17:16: WARNING: SQLite: no such table: misc errorcode: 1
2017-05-24 20:17:16: ERROR: Error preparing Query [SELECT tvalue FROM misc WHERE tkey=‘db_version’]: no such table: misc
2017-05-24 20:17:16: WARNING: SQLite: no such table: misc errorcode: 1
2017-05-24 20:17:16: ERROR: Error preparing Query [SELECT tvalue FROM misc WHERE tkey=‘db_version’]: no such table: misc
2017-05-24 20:17:16: WARNING: SQLite: no such table: misc errorcode: 1
2017-05-24 20:17:16: ERROR: Error preparing Query [SELECT tvalue FROM misc WHERE tkey=?]: no such table: misc
2017-05-24 20:17:16: ERROR: Fatal exception code 3221225477 at address 0x000007FEEE55E49F
2017-05-24 20:17:16: ERROR: Fatal exception (APPLICATION CRASHED). Crash dump written to “C:\Windows\TEMP\UrBackup\v2.0.0-20170524-201716-920-2512.dmp”
2017-05-24 20:58:41: WARNING: SQLite: no such table: misc errorcode: 1
2017-05-24 20:58:41: ERROR: Error preparing Query [SELECT tvalue FROM misc WHERE tkey=‘db_version’]: no such table: misc
2017-05-24 20:58:41: WARNING: SQLite: no such table: misc errorcode: 1
2017-05-24 20:58:41: ERROR: Error preparing Query [SELECT tvalue FROM misc WHERE tkey=‘db_version’]: no such table: misc
2017-05-24 20:58:42: WARNING: SQLite: no such table: misc errorcode: 1
2017-05-24 20:58:42: ERROR: Error preparing Query [SELECT tvalue FROM misc WHERE tkey=?]: no such table: misc
2017-05-24 20:58:42: ERROR: Fatal exception code 3221225477 at address 0x000007FEEE24E49F
2017-05-24 20:58:42: ERROR: Fatal exception (APPLICATION CRASHED). Crash dump written to “C:\Windows\TEMP\UrBackup\v2.0.0-20170524-205842-2320-2428.dmp”
2017-05-24 20:59:53: WARNING: SQLite: no such table: directory_link_journal errorcode: 1
2017-05-24 20:59:53: ERROR: Error preparing Query [SELECT linkname, linktarget FROM directory_link_journal]: no such table: directory_link_journal
2017-05-24 20:59:53: ERROR: Fatal exception code 3221225477 at address 0x000007FEEE57240A
2017-05-24 20:59:53: ERROR: Fatal exception (APPLICATION CRASHED). Crash dump written to “C:\Windows\TEMP\UrBackup\v2.0.0-20170524-205953-2068-556.dmp”
2017-05-24 21:00:40: WARNING: SQLite: no such table: directory_link_journal errorcode: 1
2017-05-24 21:00:40: ERROR: Error preparing Query [SELECT linkname, linktarget FROM directory_link_journal]: no such table: directory_link_journal
2017-05-24 21:00:40: ERROR: Fatal exception code 3221225477 at address 0x000007FEEDB3240A
2017-05-24 21:00:40: ERROR: Fatal exception (APPLICATION CRASHED). Crash dump written to “C:\Windows\TEMP\UrBackup\v2.0.0-20170524-210040-2640-3040.dmp”
2017-05-24 21:00:59: WARNING: Creating file entry index. This might take a while…
2017-05-24 21:00:59: WARNING: SQLite: no such table: files errorcode: 1
2017-05-24 21:00:59: ERROR: Error preparing Query [SELECT COUNT(*) AS c FROM files]: no such table: files
2017-05-24 21:00:59: WARNING: SQLite: no such table: files errorcode: 1
2017-05-24 21:00:59: ERROR: Error preparing Query [SELECT id, shahash, filesize, clientid, next_entry, prev_entry, pointed_to FROM files ORDER BY shahash ASC, filesize ASC, clientid ASC, created DESC]: no such table: files
2017-05-24 21:00:59: ERROR: Fatal exception code 3221225477 at address 0x000007FEEE55B7E8
2017-05-24 21:00:59: ERROR: Fatal exception (APPLICATION CRASHED). Crash dump written to “C:\Windows\TEMP\UrBackup\v2.0.0-20170524-210059-548-2496.dmp”
Client
2017-05-24 21:02:51: Loaded -fileserv- plugin
2017-05-24 21:02:51: Loaded -fsimageplugin- plugin
2017-05-24 21:02:51: Loaded -cryptoplugin- plugin
2017-05-24 21:02:51: SQLite: recovered 725 frames from WAL file C:\Program Files\UrBackup\urbackup\backup_client.db-wal code: 283
2017-05-24 21:02:51: urbackupserver: Server started up successfully!
2017-05-24 21:02:51: FileSrv: Backup privileges set successfully
2017-05-24 21:02:51: FileSrv: Backup privileges set successfully (SE_SECURITY_NAME)
2017-05-24 21:02:51: FileSrv: Backup privileges set successfully (SE_RESTORE_NAME)
2017-05-24 21:02:51: FileSrv: Binding UDP socket at port 35622…
2017-05-24 21:02:51: FileSrv: done.
2017-05-24 21:02:51: FileSrv: Disabling new behavior…
2017-05-24 21:02:51: FileSrv: Servername: -simpesserver-
2017-05-24 21:02:51: Started UrBackupClient Backend…
2017-05-24 21:02:51: FileSrv: Server started up successfully
2017-05-24 21:02:51: FileSrv: UDP Thread startet
2017-05-24 21:02:51: Filesystem. Vol="\?\Volume{dee703aa-62dd-11e4-80b4-806e6f6e6963}" Name="" Type=“ntfs” VPaths=0 Size=366997504
2017-05-24 21:02:51: Bootable flag set for volume
2017-05-24 21:02:51: Found potential candidate: \?\Volume{dee703aa-62dd-11e4-80b4-806e6f6e6963}\ Score: 3
2017-05-24 21:02:51: Filesystem. Vol="\?\Volume{dee703ab-62dd-11e4-80b4-806e6f6e6963}" Name="" Type=“ntfs” VPaths=1 Size=188610506752
2017-05-24 21:02:51: Filesystem is System partition. Skipping…
2017-05-24 21:02:51: Filesystem. Vol="\?\Volume{dee703ac-62dd-11e4-80b4-806e6f6e6963}" Name=“dati” Type=“ntfs” VPaths=1 Size=811190972416
2017-05-24 21:02:51: Bootable flag not set for volume
2017-05-24 21:02:51: Filesystem. Vol="\?\Volume{dee703b3-62dd-11e4-80b4-806e6f6e6963}" Name=“viewpower2.12” Type=“udf” VPaths=1 Size=608356352
2017-05-24 21:02:51: Bootable flag not set for volume
2017-05-24 21:02:51: Selected volume \?\Volume{dee703aa-62dd-11e4-80b4-806e6f6e6963}
2017-05-24 21:02:51: System dir: C:\Windows
2017-05-24 21:02:51: Volpath: \.\C:
2017-05-24 21:02:51: Device is not GPT formatted (0)
2017-05-24 21:02:51: Found no EFI System Partition
2017-05-24 21:02:51: urbackupserver: No available slots… starting new Worker
2017-05-24 21:02:51: ClientService cmd: STATUS#pw=RJieUuQwSh7F53FSsP0TFICbPTT4J6
2017-05-24 21:02:52: Looking for old Sessions… 0 sessions
2017-05-24 21:02:52: Internet mode not enabled
2017-05-24 21:02:52: Final path: F:\Comune
2017-05-24 21:02:52: Final path: F:\Personali
2017-05-24 21:02:52: Final path: F:\scansioni
2017-05-24 21:03:34: ClientService cmd: STATUS DETAIL#pw=RJieUuQwSh7F53FSsP0TFICbPTT4J6
2017-05-24 21:03:35: ClientService cmd: STATUS DETAIL#pw=RJieUuQwSh7F53FSsP0TFICbPTT4J6
2017-05-24 21:03:35: rc=0 hasError=true state=0
2017-05-24 21:03:42: ClientService cmd: STATUS#pw=RJieUuQwSh7F53FSsP0TFICbPTT4J6
2017-05-24 21:03:52: ClientService cmd: GET LOGPOINTS#pw=P0ShUrZq0aYK449AT5XTAKXOIZ5ta0
2017-05-24 21:03:52: rc=0 hasError=true state=0
2017-05-24 21:03:54: ClientService cmd: GET LOGDATA#pw=P0ShUrZq0aYK449AT5XTAKXOIZ5ta0&logid=1216&loglevel=0
2017-05-24 21:03:54: rc=0 hasError=true state=0
2017-05-24 21:03:55: ClientService cmd: GET LOGDATA#pw=P0ShUrZq0aYK449AT5XTAKXOIZ5ta0&logid=1217&loglevel=0
2017-05-24 21:03:55: rc=0 hasError=true state=0
2017-05-24 21:04:33: ClientService cmd: STATUS#pw=RJieUuQwSh7F53FSsP0TFICbPTT4J6
2017-05-24 21:05:24: ClientService cmd: STATUS#pw=RJieUuQwSh7F53FSsP0TFICbPTT4J6