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 Query: select from messages m left join date_fields df on ( where df.message is null

The missing rows can usually be generated using this query:

insert into date_fields (message,value) select, trim( both ' ,()abcdefghijklmnopqrstuwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ' from hf.value )::timestamptz from messages m join header_fields hf on ( and hf.field=17) left join date_fields df on ( where df.message is null;

The query may fail for messages using the Samoan time zone.

In case of questions, please write to

Relevant links

About this page

Last modified: 2010-11-19