On Saturday 16 February 2008 2:09:13 am Paul J Stevens wrote: > Bret Baptist wrote: > > On Friday 15 February 2008 2:47:57 am Paul J Stevens wrote: > >> Bret Baptist wrote: > > What does this message mean? Is there anything that > > I can check related to this message to see if there are any issues with > > the migration? > > It's probably not the migration then, but rather an inconsistency in the > database. I can't tell for sure without level5 logs.
Here are the level5 logs from a run: Feb 26 17:01:34 bedlam dbmail/maintenance[25449]: Debug:[sql] dbmysql.c,db_query(+287): query [SELECT messageblk, is_header FROM dbmail_messageblks WHERE physmessage_id = 19037459 ORDER BY messageblk_idnr] Feb 26 17:01:34 bedlam dbmail/maintenance[25449]: Debug:[db] dbmodule.c,db_query(+145): last query took [0] seconds Feb 26 17:01:34 bedlam dbmail/maintenance[25449]: Error:[message] dbmail-message.c,_retrieve(+696): blk error Feb 26 17:01:34 bedlam dbmail/maintenance[25449]: Error:[message] dbmail-message.c,dbmail_message_retrieve(+769): retrieval failed for physid [19037459] Feb 26 17:01:34 bedlam dbmail/maintenance[25449]: Warning:[db] db.c,db_update_rfcsize(+1849): error retrieving physmessage: [19037459] > > Did you test with outlook/tb etc? Does everything look ok from that > perspective? I did a test and was able to connect and retrieve messages from the server. I did a check in the database and noticed that all the messages throwing this error had a messagesize of 0 in the dbmail_physmessage table. Do you know of a bug in dbmail 1.2.12 that would cause it to create a message with no messageblks associated with it? I checked my live dbmail 1.2.12 database and the same message also had a message size of 0 and no messageblks. These are recently received messages too. After I deleted all the messages from dbmail_messages that had a dbmail_physmessage messagesize of 0, and all the physmessages from dbmail_physmessage that had a messagesize of 0, I was able to run the dbmail-util -by without errors. Thanks for your help. -- Bret Baptist Senior Network Administrator [EMAIL PROTECTED] Internet Exposure, Inc. http://www.iexposure.com (612)676-1946 x17 Providing Internet Services since 1995 Web Development ~ Search Engine Marketing ~ Web Analytics Network Security ~ On Demand Tech Support ~ E-Mail Marketing ------------------------------------------ _______________________________________________ DBmail mailing list DBmail@dbmail.org https://mailman.fastxs.nl/mailman/listinfo/dbmail
