ok, solved.
first, i had to find all the records in messages that did not appear in
messageblks. I used the following command:
select messages.* from messages left join messageblks on
messages.physmessage_id=messageblks.physmessage_id where
messageblks.physmessage_id is null ;
then I had t
Ok, so this morning the server wan't working properly - probably because
the partition that MySQL was on ran out of space. So the netwok admin just
rebooted the box.
After the reboot, and a MySQL table recovery, and a dbmail-maintenance
-cfpd, the system is still not working properly. a 'BYE i
