How to fix corrupt and Very large Client DB?

client
1

Hi all,
I have a Windows 10 client which is failing to pass the indexing point when performing a backup. The backup_client.db file is 56.9GB. The debug log on the client indicates:

2022-08-01 16:49:19: ERROR: Error in CQuery::Execute - database disk image is malformed  Stmt: [INSERT INTO map_frn (name, pid, pid_high, frn, frn_high, rid) VALUES (?, ?, ?, ?, ?, ? )]
2022-08-01 16:49:19: WARNING: SQLite: database corruption at line 78755 of [fb90e7189a] errorcode: 11
2022-08-01 16:49:19: WARNING: SQLite: statement aborts at 11: [SELECT id FROM map_frn WHERE frn=? AND frn_high=? AND rid=?] database disk image is malformed errorcode: 11
2022-08-01 16:49:19: ERROR: Error: Parent of file Antiphishing.db-shm not found -4

I am running server version 2.4.13 (Windows) and client 2.4.11 (Windows).
How do I repair and reduce the size of the backup_client.db file?

Thanks

2

Perhaps delete the database and then reconfigure e.g. paths to backup (if that is okay)…

3

Hi Uroni,
I was hoping to not reconfigure but it seems to be the easiest solution.
Done.
Thank you.

4

not sure if sql lite is the best choice