Hi everyone.
I have problem with starting UrBackupWinServer service on server 1.4.7. It just hangs. We have 200 clients. I found that database backup_server.db is making problems, so I’ve tried to repair it with repair_database.bat, but it didnt help. If i copy over a clean database it’s all OK, but then there is no old backups, and it is a quite problem to make all over full backups for all workstations because of slow links in our branch offices. It all started after recalculating statistics when it just crushed.
I hope somebody can help…
2015-08-14 09:01:04: ERROR: Error preparing Query [CREATE TABLE settings_db.settings (key TEXT,value TEXT , clientid INTEGER);]: table settings already exists
2015-08-14 09:01:04: ERROR: Error preparing Query [CREATE TABLE settings_db.si_users(id INTEGER PRIMARY KEY,name TEXT,password_md5 TEXT,salt TEXT,report_mail TEXT,report_loglevel INTEGER,report_sendonly INTEGER);]: table si_users already exists
2015-08-14 09:01:04: ERROR: Error preparing Query [CREATE TABLE settings_db.si_permissions(clientid INTEGER REFERENCES si_users(id) ON DELETE CASCADE,t_right TEXT,t_domain TEXT);]: table si_permissions already exists
2015-08-14 09:01:04: WARNING: Upgrading database to version 16
2015-08-14 09:01:04: ERROR: Error preparing Query [CREATE TABLE settings_db.extra_clients ( id INTEGER PRIMARY KEY, hostname TEXT, lastip INTEGER)]: table extra_clients already exists
2015-08-14 09:01:04: WARNING: Upgrading database to version 17
2015-08-14 09:01:04: WARNING: Upgrading database to version 18
2015-08-14 09:01:04: WARNING: Upgrading database to version 19
2015-08-14 09:01:04: WARNING: Upgrading database to version 20
2015-08-14 09:01:04: ERROR: Error preparing Query [CREATE TABLE settings_db.automatic_archival ( id INTEGER PRIMARY KEY, next_archival INTEGER, interval INTEGER, interval_unit TEXT, length INTEGER, length_unit TEXT, backup_types INTEGER, clientid INTEGER)]: table automatic_archival already exists
2015-08-14 09:01:04: WARNING: Upgrading database to version 21
2015-08-14 09:01:04: ERROR: Error preparing Query [ALTER TABLE settings_db.automatic_archival ADD archive_window TEXT]: duplicate column name: archive_window
2015-08-14 09:01:04: WARNING: Upgrading database to version 22
2015-08-14 09:01:04: WARNING: Upgrading database to version 23
2015-08-14 09:01:04: WARNING: Upgrading database to version 24
2015-08-14 09:01:04: WARNING: Upgrading database to version 25
2015-08-14 09:01:04: WARNING: Upgrading database to version 26
2015-08-14 09:01:04: WARNING: Upgrading database to version 27
2015-08-14 09:01:04: WARNING: Upgrading database to version 28
2015-08-14 09:01:04: ERROR: Error preparing Query [CREATE INDEX settings_db.settings_idx ON settings (key, clientid)]: index settings_idx already exists
2015-08-14 09:01:04: ERROR: Error preparing Query [CREATE INDEX settings_db.si_users_idx ON si_users (name)]: index si_users_idx already exists
2015-08-14 09:01:04: ERROR: Error preparing Query [CREATE INDEX settings_db.si_permissions_idx ON si_permissions (clientid, t_domain)]: index si_permissions_idx already exists
2015-08-14 09:01:04: WARNING: Upgrading database to version 29
2015-08-14 09:01:04: WARNING: Upgrading database to version 30
2015-08-14 09:01:04: ERROR: Error preparing Query [CREATE TABLE settings_db.login_access_log (id INTEGER PRIMARY KEY,logintime DATE DEFAULT CURRENT_TIMESTAMP,username TEXT,ip TEXT,method INTEGER)]: table login_access_log already exists
2015-08-14 09:01:04: WARNING: Upgrading database to version 31
2015-08-14 09:01:04: ERROR: Error preparing Query [CREATE TABLE settings_db.old_backupfolders (id INTEGER PRIMARY KEY,backupfolder TEXT UNIQUE)]: table old_backupfolders already exists
2015-08-14 09:01:04: WARNING: Upgrading database to version 32
2015-08-14 09:01:04: WARNING: Upgrading database to version 33
2015-08-14 09:01:04: WARNING: Upgrading database to version 34
2015-08-14 09:01:04: WARNING: Upgrading database to version 35
2015-08-14 09:01:04: WARNING: Done.
2015-08-14 09:04:53: ERROR: Error preparing Query [PRAGMA synchronous=NORMAL]: database disk image is malformed
2015-08-14 09:04:53: ERROR: Error preparing Query [PRAGMA synchronous=NORMAL]: database disk image is malformed
2015-08-14 09:04:53: ERROR: Error in CQuery::Execute - database disk image is malformed Stmt: [ATTACH DATABASE ‘urbackup/backup_server_settings.db’ AS settings_db]
2015-08-14 09:04:53: ERROR: SQL: database disk image is malformed Stmt: [ATTACH DATABASE ‘urbackup/backup_server_settings.db’ AS settings_db]
2015-08-14 09:04:53: ERROR: Error preparing Query [SELECT tvalue FROM misc WHERE tkey=‘db_version’]: database disk image is malformed
2015-08-14 09:04:53: ERROR: Error preparing Query [SELECT tvalue FROM misc WHERE tkey=‘db_version’]: database disk image is malformed
2015-08-14 09:04:53: ERROR: Error preparing Query [PRAGMA journal_mode=WAL]: database disk image is malformed
2015-08-14 09:04:53: ERROR: Error preparing Query [CREATE INDEX IF NOT EXISTS files_idx ON files (shahash, filesize, clientid)]: database disk image is malformed
2015-08-14 09:04:53: ERROR: Error preparing Query [CREATE INDEX IF NOT EXISTS files_did_count ON files (did_count)]: database disk image is malformed
2015-08-14 09:04:53: ERROR: Error preparing Query [CREATE INDEX IF NOT EXISTS files_backupid ON files (backupid)]: database disk image is malformed
2015-08-14 09:04:53: ERROR: Error preparing Query [SELECT value FROM settings_db.settings WHERE key=? AND clientid=0]: database disk image is malformed
2015-08-14 09:04:53: ERROR: Error preparing Query [UPDATE misc SET tvalue=? WHERE tkey=‘files_cache’]: database disk image is malformed
2015-08-14 09:04:53: ERROR: Error preparing Query [SELECT linkname, linktarget FROM directory_link_journal]: database disk image is malformed
2015-08-14 09:04:53: ERROR: Fatal exception (APPLICATION CRASHED). Crash dump written to “C:\Users\urbackup\AppData\Local\Temp\UrBackup\v0.25.1-20150814-090453-1800-984.dmp”
2015-08-14 09:05:27: ERROR: Error preparing Query [PRAGMA synchronous=NORMAL]: database disk image is malformed
2015-08-14 09:05:27: ERROR: Error in CQuery::Execute - database disk image is malformed Stmt: [ATTACH DATABASE ‘urbackup/backup_server_settings.db’ AS settings_db]
2015-08-14 09:05:27: ERROR: SQL: database disk image is malformed Stmt: [ATTACH DATABASE ‘urbackup/backup_server_settings.db’ AS settings_db]
2015-08-14 09:05:28: ERROR: Error preparing Query [SELECT count() AS c FROM settings_db.si_users]: database disk image is malformed
2015-08-14 09:05:28: ERROR: Error preparing Query [INSERT INTO settings_db.login_access_log (username, ip, method) VALUES (?, ?, ?)]: database disk image is malformed
2015-08-14 09:05:28: ERROR: Fatal exception (APPLICATION CRASHED). Crash dump written to “C:\Users\urbackup\AppData\Local\Temp\UrBackup\v0.25.1-20150814-090528-1800-1300.dmp”
2015-08-14 09:05:36: ERROR: Error preparing Query [PRAGMA synchronous=NORMAL]: database disk image is malformed
2015-08-14 09:05:36: ERROR: Error preparing Query [PRAGMA synchronous=NORMAL]: database disk image is malformed
2015-08-14 09:05:36: ERROR: Error in CQuery::Execute - database disk image is malformed Stmt: [ATTACH DATABASE ‘urbackup/backup_server_settings.db’ AS settings_db]
2015-08-14 09:05:36: ERROR: SQL: database disk image is malformed Stmt: [ATTACH DATABASE ‘urbackup/backup_server_settings.db’ AS settings_db]
2015-08-14 09:05:36: ERROR: Error preparing Query [SELECT tvalue FROM misc WHERE tkey=‘db_version’]: database disk image is malformed
2015-08-14 09:05:36: ERROR: Error preparing Query [SELECT tvalue FROM misc WHERE tkey=‘db_version’]: database disk image is malformed
2015-08-14 09:05:36: ERROR: Error preparing Query [PRAGMA journal_mode=WAL]: database disk image is malformed
2015-08-14 09:05:36: ERROR: Error preparing Query [CREATE INDEX IF NOT EXISTS files_idx ON files (shahash, filesize, clientid)]: database disk image is malformed
2015-08-14 09:05:36: ERROR: Error preparing Query [CREATE INDEX IF NOT EXISTS files_did_count ON files (did_count)]: database disk image is malformed
2015-08-14 09:05:36: ERROR: Error preparing Query [CREATE INDEX IF NOT EXISTS files_backupid ON files (backupid)]: database disk image is malformed
2015-08-14 09:05:36: ERROR: Error preparing Query [SELECT value FROM settings_db.settings WHERE key=? AND clientid=0]: database disk image is malformed
2015-08-14 09:05:36: ERROR: Error preparing Query [UPDATE misc SET tvalue=? WHERE tkey=‘files_cache’]: database disk image is malformed
2015-08-14 09:05:36: ERROR: Error preparing Query [SELECT linkname, linktarget FROM directory_link_journal]: database disk image is malformed
2015-08-14 09:05:36: ERROR: Fatal exception (APPLICATION CRASHED). Crash dump written to “C:\Users\urbackup\AppData\Local\Temp\UrBackup\v0.25.1-20150814-090536-648-2304.dmp”
2015-08-14 09:05:39: ERROR: Error preparing Query [PRAGMA synchronous=NORMAL]: database disk image is malformed
2015-08-14 09:05:39: ERROR: Error in CQuery::Execute - database disk image is malformed Stmt: [ATTACH DATABASE ‘urbackup/backup_server_settings.db’ AS settings_db]
2015-08-14 09:05:39: ERROR: SQL: database disk image is malformed Stmt: [ATTACH DATABASE ‘urbackup/backup_server_settings.db’ AS settings_db]
2015-08-14 09:05:39: ERROR: Error preparing Query [SELECT count() AS c FROM settings_db.si_users]: database disk image is malformed
2015-08-14 09:05:39: ERROR: Error preparing Query [INSERT INTO settings_db.login_access_log (username, ip, method) VALUES (?, ?, ?)]: database disk image is malformed
2015-08-14 09:05:39: ERROR: Fatal exception (APPLICATION CRASHED). Crash dump written to “C:\Users\urbackup\AppData\Local\Temp\UrBackup\v0.25.1-20150814-090539-648-1932.dmp”