andrea at brancatelli
Apr 6, 2009, 2:00 AM
Post #5 of 7
(695 views)
Permalink
|
Il giorno dom, 29/03/2009 alle 14.53 +0200, Paul J Stevens ha scritto:
> > 00:00:00' for key 2] [INSERT INTO dbmail_datefield (physmessage_id,
> > datefield) VALUES (467171,'1970-01-01 00:00:00')]
> > How do I fix this? dbmail-util doesn't fix it in any way.
> Remove the entries that are in the way. In the example above:
> delete from dbmail_datefield where physmessage_id=467171;
>
No Paul, sorry, that didn't work:
mysql> delete from dbmail_datefield where physmessage_id=467171;
Query OK, 1 row affected (0.00 sec)
mysql> delete from dbmail_datefield where physmessage_id=270298;
Query OK, 1 row affected (0.00 sec)
mysql> delete from dbmail_datefield where physmessage_id=467170;
Query OK, 1 row affected (0.00 sec)
mysql> delete from dbmail_datefield where physmessage_id=270306;
Query OK, 1 row affected (0.00 sec)
mysql> quit
Bye
[/root[at]mela] #dbmail-util -ay
Repairing DBMAIL messageblocks integrity...
Ok. Found [0] unconnected messageblks.
Repairing DBMAIL physmessage integrity...
Ok. Found [0] unconnected physmessages.
Repairing DBMAIL message integrity...
Ok. Found [0] unconnected messages.
Repairing DBMAIL mailbox integrity...
Ok. Found [0] unconnected mailboxes.
Repairing DBMAIL for NULL messages...
Ok. Found [0] NULL messages.
Checking DBMAIL for NULL physmessages...
Ok. Found [0] physmessages without messageblocks.
Deleting messages with DELETE status...
Ok. [0] messages deleted.
Repairing DBMAIL for rfcsize field...
Ok. Found [0] missing rfcsize values.
Repairing DBMAIL for incorrect is_header flags...
Ok. Found [0] incorrect is_header flags.
Repairing DBMAIL for cached envelopes...
Ok. Found [0] missing envelope values.
Repairing DBMAIL for cached header values...
Ok. Found [4] un-cached physmessages.
.....
Setting DELETE status for deleted messages...
Ok. [0] messages set for deletion.
Re-calculating used quota for all users...
Ok. Used quota updated for all users.
Removing aliases with nonexistent delivery userid's...
Ok. Found [0] dangling aliases.
Vacuuming and optimizing database...
Ok. Database cleaned up.
Maintenance done. Errors were found and fixed.
We suggest running dbmail-util again to confirm that all errors were
repaired.
[/root[at]mela] #dbmail-util -ay
Repairing DBMAIL messageblocks integrity...
Ok. Found [0] unconnected messageblks.
Repairing DBMAIL physmessage integrity...
Ok. Found [0] unconnected physmessages.
Repairing DBMAIL message integrity...
Ok. Found [0] unconnected messages.
Repairing DBMAIL mailbox integrity...
Ok. Found [0] unconnected mailboxes.
Repairing DBMAIL for NULL messages...
Ok. Found [0] NULL messages.
Checking DBMAIL for NULL physmessages...
Ok. Found [0] physmessages without messageblocks.
Deleting messages with DELETE status...
Ok. [0] messages deleted.
Repairing DBMAIL for rfcsize field...
Ok. Found [0] missing rfcsize values.
Repairing DBMAIL for incorrect is_header flags...
Ok. Found [0] incorrect is_header flags.
Repairing DBMAIL for cached envelopes...
Ok. Found [0] missing envelope values.
Repairing DBMAIL for cached header values...
Ok. Found [4] un-cached physmessages.
Apr 06 10:58:14 mela.raged.it dbmail-util[69655]: Error:[sql]
dbmysql.c,db_query(+290): [Duplicate entry '467171-1970-01-01 00:00:00'
for key 2] [INSERT INTO dbmail_datefield (physmessage_id, datefield)
VALUES (467171,'1970-01-01 00:00:00')]
Apr 06 10:58:14 mela.raged.it dbmail-util[69655]: Error:[message]
dbmail-message.c,insert_field_cache(+1105): insert datefield failed
[INSERT INTO dbmail_datefield (physmessage_id, datefield) VALUES
(467171,'1970-01-01 00:00:00')]
..Apr 06 10:58:14 mela.raged.it dbmail-util[69655]: Error:[sql]
dbmysql.c,db_query(+290): [Duplicate entry '467170-1970-01-01 00:00:00'
for key 2] [INSERT INTO dbmail_datefield (physmessage_id, datefield)
VALUES (467170,'1970-01-01 00:00:00')]
Apr 06 10:58:14 mela.raged.it dbmail-util[69655]: Error:[message]
dbmail-message.c,insert_field_cache(+1105): insert datefield failed
[INSERT INTO dbmail_datefield (physmessage_id, datefield) VALUES
(467170,'1970-01-01 00:00:00')]
..Apr 06 10:58:14 mela.raged.it dbmail-util[69655]: Error:[sql]
dbmysql.c,db_query(+290): [Duplicate entry '270306-1970-01-01 00:00:00'
for key 2] [INSERT INTO dbmail_datefield (physmessage_id, datefield)
VALUES (270306,'1970-01-01 00:00:00')]
Apr 06 10:58:14 mela.raged.it dbmail-util[69655]: Error:[message]
dbmail-message.c,insert_field_cache(+1105): insert datefield failed
[INSERT INTO dbmail_datefield (physmessage_id, datefield) VALUES
(270306,'1970-01-01 00:00:00')]
..Apr 06 10:58:14 mela.raged.it dbmail-util[69655]: Error:[sql]
dbmysql.c,db_query(+290): [Duplicate entry '270298-1970-01-01 00:00:00'
for key 2] [INSERT INTO dbmail_datefield (physmessage_id, datefield)
VALUES (270298,'1970-01-01 00:00:00')]
Apr 06 10:58:14 mela.raged.it dbmail-util[69655]: Error:[message]
dbmail-message.c,insert_field_cache(+1105): insert datefield failed
[INSERT INTO dbmail_datefield (physmessage_id, datefield) VALUES
(270298,'1970-01-01 00:00:00')]
..
Setting DELETE status for deleted messages...
Ok. [0] messages set for deletion.
Re-calculating used quota for all users...
Ok. Used quota updated for all users.
Removing aliases with nonexistent delivery userid's...
Ok. Found [0] dangling aliases.
Vacuuming and optimizing database...
Ok. Database cleaned up.
Maintenance done. Errors were found and fixed.
We suggest running dbmail-util again to confirm that all errors were
repaired.
Any other hint? :)
|
stock_smiley-1.png
