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

About this page

Last modified: 2010-11-19
Location: aox.org/aox/checkdatabase