OK. Database restored from backup. Vacuum and reindex commands completed successfully. GW is working now.

 [:)]

Thank you for your help.

Jyrki

Hi!

Yesterday Graywall started to write error messages in logfile:

! 20101021 000020.121 1739 Error executing SQL statement.
Error [11]: The database disk image is malformed.
"INSERT INTO gray (hash, ip, mfrom, mto, dtunlock, dtexpire, blcount) VALUES(:hash, :ip, :mfrom, :mto, :dt, :dte, 1)": database disk image is malformed
_ 20101021 000020.465 1739 (0)

I think mail messages are coming through now without grayfiltering. There is new error message for almost every new mail.

Is database corrupted, or what is going on? How to fix this?

Server: Windows Server 2003 SP2 with all hotfixes

Mercury/32 4.72.

Graywall version is 1.2.1.122

Regards

Jyrki Aarni.

Oulu, Finland.

This is how to rebuild the database (based on instructions from Lukas Gebauer):

- Stop Mercury, backup database file

- Open a command window and enter this to open Sqlite console:

sqlite3.exe gray.db3

- Then type commands:

Vacuum;

Reindex;

This will read the original database and store data into a new file, repairing most errors.

/Rolf

Thank you for the quick answer. Unfortunately that didn't help:

D:\MERCURY\graywall>sqlite3.exe gray.db3
SQLite version 3.6.13
Enter ".help" for instructions
Enter SQL statements terminated with a ";"
sqlite> vacuum;
SQL error: database disk image is malformed
sqlite> reindex;
SQL error: database disk image is malformed
sqlite>

Regards

Jyrki 

If it's that badly damaged, and you have no backup to revert to, I think you will need to remove the old database file and reinstall Graywall. Check the disk first, though.

/Rolf  

How about:

D:\MERCURY\graywall>sqlite3 gray.db3 .dump > gray.sql

D:\MERCURY\graywall>dir *.sql
 Volume in drive D is New Volume
 Volume Serial Number is C8C6-B349

 Directory of D:\MERCURY\graywall

22.10.2010  14:57         4 548 086 gray.sql
               1 File(s)      4 548 086 bytes
               0 Dir(s)  30 626 250 752 bytes free

D:\MERCURY\graywall>rename gray.db3 gray_old.db3

D:\MERCURY\graywall>sqlite3 gray.db3 < gray.sql

Is this OK?

I ran chkdsk before vacuum and reindex commands. It found five nonindexed files. Is this related to database corruption... I don't know.

Regards.

Jyrki

We don't know either, it could be.

As for recovery of a corrupted database the Sqlite3 site says:

Depending how badly your database is corrupted, you may be able to

recover some of the data by using the CLI to dump the schema and contents

to a file and then recreate. Unfortunately, once humpty-dumpty falls off

the wall, it is generally not possible to put him back together again.

/Rolf