I found something odd. Below are the last records in dbmail_mailboxes ordered by mailbox_idnr. Each row is right after I've done dbmail-util -ty
5450 5452 5465 5466 5484 5485 5486 5487 5599 5604 5607 5608 5450 5452 5465 5466 5484 5485 5486 5487 5599 5604 5609 5610 5450 5452 5465 5466 5484 5485 5486 5487 5599 5604 5611 5612 5450 5452 5465 5466 5484 5485 5486 5487 5599 5604 5613 5614 I've increased the tracelevel of dbmail-util. When I run dbmail-util -ty it should remove the last two mailboxes. Checking DBMAIL mailbox integrity... Ok. Found [2] unconnected mailboxes. 5614 (removed from dbase) 5613 (removed from dbase) Looks ok. Logfile: Sep 12 10:49:44 NBMS01 dbmail/maintenance[50585]: db.c,db_icheck_mailboxes: found lost mailbox id [5613] Sep 12 10:49:44 NBMS01 dbmail/maintenance[50585]: db.c,db_icheck_mailboxes: found lost mailbox id [5614] Sep 12 10:49:44 NBMS01 dbmail/maintenance[50585]: dbmysql.c,db_query: executing query [DELETE FROM dbmail_mailboxes WHERE mailbox_idnr = '5614'] Sep 12 10:49:45 NBMS01 dbmail/maintenance[50585]: dbmysql.c,db_query: executing query [SELECT message_idnr FROM dbmail_me ssages WHERE mailbox_idnr = '5614'] Sep 12 10:49:45 NBMS01 dbmail/maintenance[50585]: db.c,db_delete_mailbox: mailbox is empty Sep 12 10:49:45 NBMS01 dbmail/maintenance[50585]: dbmysql.c,db_query: executing query [DELETE FROM dbmail_mailboxes WHERE mailbox_idnr = '5613'] Sep 12 10:49:45 NBMS01 dbmail/maintenance[50585]: dbmysql.c,db_query: executing query [SELECT message_idnr FROM dbmail_me ssages WHERE mailbox_idnr = '5613'] Sep 12 10:49:45 NBMS01 dbmail/maintenance[50585]: db.c,db_delete_mailbox: mailbox is empty Looks ok also. Another list of current mailboxes: 5450 5452 5465 5466 5484 5485 5486 5487 5599 5604 5615 5616 Well, that's odd. The records are not deleted, only changed. Can someone explain that?! thanks, Anne > Jorge Bastos wrote: >> run dbmail-util -ay >> twice > > bollocks. > > dbmail-util -ty is just fine for finding and fixing unconnected mailboxes. > > Now, why Anne's installation keep popping up unconnected mailboxes is beyond speculation. It is *not* normal behaviour. > > Anne: I assume you're running myisam tables. Don't. Use innodb tables, and make sure all the foreign key restraints are in place. That way, no such unconnected mailboxes will ever again emerge. > > -- > ________________________________________________________________ Paul Stevens paul at nfg.nl NET FACILITIES GROUP GPG/PGP: 1024D/11F8CD31 The Netherlands________________________________http://www.nfg.nl > _______________________________________________ > Dbmail mailing list > [email protected] > https://mailman.fastxs.nl/mailman/listinfo/dbmail >
