Logging: Database Disk Image is Malformed

Question

Hello,

I seem to have an issue with viewing logs:

I am using the default built-in log database:

What is causing this? I am using the latest version of Adaxes.

Answer 1

Hello,

Adaxes uses SQLite as built-in database and it is just a single file. The file name is AdaxesLog.db3 and it is located in folder C:\Program Files\Softerra\Adaxes 3\Service\LogDB by default. The error you are facing is not related to Adaxes itself and just reflects the fact that something corrupted the database file or the drive where it is located. If you have a recent backup of Adaxes, the easiest approach that should probably resolve the issue is to reinstall Addaxes and restore the backup.

Comments

I was able to self-resolve this by stopping the service, dumping the log database file into a SQL File using sqlite3 "Recover" function, then making a new database from that recovered SQL.

From there, I was able to move the new database into the adaxes directory, and name it to AdaxesLog.db3 and Start Adaxes Service Again. All my logs were there including during the time it was malformed.

Of course, ALWAYS backup your log file before running commands on it.

Hope this helps someone in the future with silimar issue: