check database
The aox check database performs a variety of expensive sanity checks on the database. It does not change anything.
There is one known old problem. Some old versions of Archiveopteryx would occasionally forget to insert date_fields rows. If your database has any messages affected by this problem, then you will get this error message:
aox: Unexpected rows in the database. Contact info@aox.org. Query: select m.id from messages m left join date_fields df on (m.id=df.message) where df.message is null
The missing rows can usually be generated using this query:
insert into date_fields (message,value) select m.id, trim( both ' ,()abcdefghijklmnopqrstuwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ' from hf.value )::timestamptz from messages m join header_fields hf on (m.id=hf.message and hf.field=17) left join date_fields df on (m.id=df.message) where df.message is null;
The query may fail for messages using the Samoan time zone.
In case of questions, please write to info@aox.org.
Relevant links
- Other aox commands:
anonymise, change address, change password, change username, check config, create alias, create mailbox, create user, create view, delete alias, delete mailbox, delete messages, delete user, flush queue, grant privileges, help, list aliases, list mailboxes, list rights, list users, reparse, restart, retain messages, setacl, show build, show configuration, show counts, show queue, show retention, show schema, show search, show status, start, stop, tune database, undelete, update database, upgrade schema, vacuum
About this page
Last modified: 2010-05-02
Location: aox.org/aox/checkdatabase