Clients don´t get removed

fossy777 · May 15, 2013, 9:38am

Hi Uroni,

Clients I want to remove get not removed while cleanup backup window. For days now the Clients state “This client is going to be removed. Stop removing client. Clients are removed during the cleanup time window, if they are offline.” but still are there, in statistics I see 0 Bytes backup. Bug?

Best regards, Jochen

uroni · May 20, 2013, 1:44pm

Are they offline? If yes I’ll have to investigate. If no – thats unfortunately a limitation currently.

fossy777 · May 21, 2013, 9:36am

Yes they are offline. Need any log file?

luckman212 · May 23, 2013, 11:31pm

I have a similar problem. On a client machine I had uninstalled the UrBackup manually via add/remove programs (she had an old version) and now the Dashboard says “client will be removed” but it does not ever go away. Can it be manually removed somehow?

uroni · May 27, 2013, 9:55pm

I guess you waited one cleanup (see cleanup window)? (The OPs problem was likely cause by a database corruption)

luckman212 · May 27, 2013, 10:07pm

I didn’t want to wait for the cleanup cycle. I was hoping there was a “faster” or immediate way to remove them. In any case, I just cancelled the removal and manually reinstalled the client and it somehow re-linked itself and started working again. So I am ok!

fossy777 · May 29, 2013, 10:32am

I did

uroni · June 2, 2013, 4:23pm

Did “repairing” the database fix your problem?

fossy777 · June 3, 2013, 5:40pm

Nope…

Repair said [quote=""]Stopping UrBackup Server…
2013-06-03 19:11:34: Created new database connection for urbackup/backup_server.db
2013-06-03 19:11:34: Exporting main database…
2013-06-03 19:25:07: Created new database connection for urbackup/backup_server_settings.db
2013-06-03 19:25:07: Exporting settings database…
2013-06-03 19:25:07: Destroying all databases…
2013-06-03 19:25:09: Created new database connection for urbackup/backup_server.db
2013-06-03 19:25:09: Importing main database…
2013-06-03 19:34:13: Created new database connection for urbackup/backup_server_settings.db
2013-06-03 19:34:13: Importing settings database…
2013-06-03 19:34:13: Completed sucessfully.
Starting UrBackup Server…
UrBackup Windows Server wird gestartet…
UrBackup Windows Server wurde erfolgreich gestartet.
[/quote] but after that the web interface only states “loading” and neither login nor summary or anything else comes up. Seems “repair” did completely destroy it instead of what it should do

uroni · June 3, 2013, 6:20pm

I hope you had a backup. Maybe those are undamaged as well?

fossy777 · June 4, 2013, 8:42am

Yes I have, of course. I activated shadow copies for sure. But what about how to go on solving this issue? Removing of the clients also missed, of course.

uroni · June 4, 2013, 8:52pm

I wrote something up: https://urbackup.atlassian.net/wiki/display/US/Troubleshooting+UrBackup+Server+Database

fossy777 · June 5, 2013, 9:02am

Hi Uroni,

strange is, that to be removed clients still get backed up

fossy777 · June 6, 2013, 3:33pm

I did the tips and:

sqlite> PRAGMA journal_mode=delete;
delete
sqlite> PRAGMA integrity_check;
*** in database main ***
Page 15308011: btreeInitPage() returns error code 11
Page 15209718: btreeInitPage() returns error code 11
Page 15217909: btreeInitPage() returns error code 11
Page 15226100: btreeInitPage() returns error code 11
Page 15234291: btreeInitPage() returns error code 11
Page 15242482: btreeInitPage() returns error code 11
Page 15250673: btreeInitPage() returns error code 11
Page 15258864: btreeInitPage() returns error code 11
Page 15267055: btreeInitPage() returns error code 11
Page 15275246: btreeInitPage() returns error code 11
Page 15283437: btreeInitPage() returns error code 11
Page 15291628: btreeInitPage() returns error code 11
Page 15299819: btreeInitPage() returns error code 11
Page 15308010: btreeInitPage() returns error code 11
Page 15316203: btreeInitPage() returns error code 11
Page 15324394: btreeInitPage() returns error code 11
Page 15332585: btreeInitPage() returns error code 11
Page 15340776: btreeInitPage() returns error code 11
Page 15348967: btreeInitPage() returns error code 11
Page 15357158: btreeInitPage() returns error code 11
Page 15365349: btreeInitPage() returns error code 11
Page 15373540: btreeInitPage() returns error code 11
Page 15381731: btreeInitPage() returns error code 11
Page 15389922: btreeInitPage() returns error code 11
Page 15398113: btreeInitPage() returns error code 11
Page 15406304: btreeInitPage() returns error code 11
Page 15414495: btreeInitPage() returns error code 11
Page 15422686: btreeInitPage() returns error code 11
Page 15430877: btreeInitPage() returns error code 11
Page 15439068: btreeInitPage() returns error code 11
Page 15447259: btreeInitPage() returns error code 11
Page 15455450: btreeInitPage() returns error code 11
Page 15463641: btreeInitPage() returns error code 11
Page 15471832: btreeInitPage() returns error code 11
Page 15480023: btreeInitPage() returns error code 11
Page 15488214: btreeInitPage() returns error code 11
Page 15496405: btreeInitPage() returns error code 11
Page 15504596: btreeInitPage() returns error code 11
Page 15512787: btreeInitPage() returns error code 11
Page 15520978: btreeInitPage() returns error code 11
Page 15529169: btreeInitPage() returns error code 11
Page 15537360: btreeInitPage() returns error code 11
Page 15545551: btreeInitPage() returns error code 11
Page 15553742: btreeInitPage() returns error code 11
Page 15561933: btreeInitPage() returns error code 11
Page 15570124: btreeInitPage() returns error code 11
Page 15578315: btreeInitPage() returns error code 11
Page 15586506: btreeInitPage() returns error code 11
Page 15594697: btreeInitPage() returns error code 11
Page 15602888: btreeInitPage() returns error code 11
Page 15611079: btreeInitPage() returns error code 11
Page 15619270: btreeInitPage() returns error code 11
Page 15627461: btreeInitPage() returns error code 11
Page 15635652: btreeInitPage() returns error code 11
Page 15643843: btreeInitPage() returns error code 11
Page 15652034: btreeInitPage() returns error code 11
Page 15660225: btreeInitPage() returns error code 11
Page 15668416: btreeInitPage() returns error code 11
Page 15676607: btreeInitPage() returns error code 11
Page 15684798: btreeInitPage() returns error code 11
Page 15692989: btreeInitPage() returns error code 11
Page 15701180: btreeInitPage() returns error code 11
Page 15709371: btreeInitPage() returns error code 11
Page 15717562: btreeInitPage() returns error code 11
Page 15725753: btreeInitPage() returns error code 11
Page 15733944: btreeInitPage() returns error code 11
Page 15742135: btreeInitPage() returns error code 11
Page 15750326: btreeInitPage() returns error code 11
Page 15758517: btreeInitPage() returns error code 11
Page 15766708: btreeInitPage() returns error code 11
Page 15774899: btreeInitPage() returns error code 11
Page 15783090: btreeInitPage() returns error code 11
Page 15791281: btreeInitPage() returns error code 11
Page 15799472: btreeInitPage() returns error code 11
Page 15807663: btreeInitPage() returns error code 11
Page 15815854: btreeInitPage() returns error code 11
Page 15824045: btreeInitPage() returns error code 11
Page 15832236: btreeInitPage() returns error code 11
Page 15840427: btreeInitPage() returns error code 11
Page 15848618: btreeInitPage() returns error code 11
Page 15856809: btreeInitPage() returns error code 11
Page 15865000: btreeInitPage() returns error code 11
Page 15873191: btreeInitPage() returns error code 11
Page 15881382: btreeInitPage() returns error code 11
Page 15889573: btreeInitPage() returns error code 11
Page 15897764: btreeInitPage() returns error code 11
Page 15905955: btreeInitPage() returns error code 11
Page 15914146: btreeInitPage() returns error code 11
Page 15922337: btreeInitPage() returns error code 11
Page 15930528: btreeInitPage() returns error code 11
Page 15938719: btreeInitPage() returns error code 11
On tree page 10 cell 1: Child page depth differs
Page 15946910: btreeInitPage() returns error code 11
Page 15955101: btreeInitPage() returns error code 11
Page 15963292: btreeInitPage() returns error code 11
Page 15971483: btreeInitPage() returns error code 11
Page 15979674: btreeInitPage() returns error code 11
Page 15987865: btreeInitPage() returns error code 11
Page 15996056: btreeInitPage() returns error code 11
Page 16004247: btreeInitPage() returns error code 11
sqlite> VACUUM;
Error: database disk image is malformed
sqlite>

What to do now?

uroni · June 11, 2013, 8:38pm

If the import/export trick does not work, the only option is to restore from a working backup. See also the posts all over the internet http://www.coderelic.com/2012/08/how-to-fix-corrupt-sqlite3-database/ http://www.monetra.com/faq/support/fix_corrupt_sqlite_database.html . Sorry.

fossy777 · June 12, 2013, 12:17pm

that´s a bit difficult since backing up still worked and now I have a damaged database backups since days or weeks. How can I start up with a new empty database regarding the backups but keep all my settings for clients?

uroni · June 12, 2013, 9:26pm

You could export some of the tables (e.g. the “clients” table via sqlite3 .dump, i.e., .output clients.sql .dump clients). Remove/rename the two databases. Restart the service, to make it recreate new databases. Replace the backup_server_settings.db with the old db and import the exported tables (from the .sql files) from the old backup_server.db.

fossy777 · June 17, 2013, 9:49am

That worked for me for the last activities to get shown. Thank you! We will see if the clients to be removed get removed tonight now.

To complete the procedure (for forum search):

backup clients table

sqlite3 backup_server
sqlite> .mode insert
sqlite> .output clients.sql
sqlite> .dump clients
search&replace “INSERT INTO” with “INSERT OR REPLACE INTO”
delete or rename backup_server.db
backup backup_server_settings.db
start service and stop again to let them both get recreated from scratch
restore backup_server_settings.db (overwrite empty one)
restore clients table

sqlite3 backup_server
sqlite> .mode insert
sqlite> .read clients.sql clients

PS: but now when I want to cleanup database using cleanup.bat I get the following output:

[quote=""]Stopping UrBackup Server…

UrBackup Windows Server wurde erfolgreich beendet.

“Cleanup amount ‘’”
2013-06-17 12:21:47: Shutting down all database instances…
2013-06-17 12:21:47: Destroying all databases…
2013-06-17 12:21:47: Opening urbackup server database…
2013-06-17 12:21:47: ERROR: Error preparing Query [PRAGMA synchronous=NORMAL]: disk I/O error
2013-06-17 12:21:47: ERROR: Error in CQuery::Execute - disk I/O error Stmt: [ATTACH DATABASE ‘urbackup/backup_server_settings.db’ AS settings_db]
2013-06-17 12:21:47: ERROR: SQL: disk I/O error Stmt: [ATTACH DATABASE ‘urbackup/backup_server_settings.db’ AS settings_db]
2013-06-17 12:21:47: Created new database connection for urbackup/backup_server.db
2013-06-17 12:21:47: ERROR: Error preparing Query [SELECT value FROM settings_db.settings WHERE key=?]: disk I/O error
2013-06-17 12:21:47: Testing if backup destination can handle subvolumes and snapshots…
2013-06-17 12:21:56: ERROR: Fatal exception. Crash dump written to “C:\Users\JO3498~1.MUE\AppData\Local\Temp\UrBackup\v0.25.1-20130617-122148-4684-2700.dmp”[/quote]

fossy777 · June 25, 2013, 1:11pm

ignore my last “but” :-) Everyting working fine now, also last activities showing and clients get removed again.