Any ideas on this at all?
Thanks,
Bret.
On Tuesday 26 February 2008 6:07:22 pm Bret Baptist wrote:
> 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
bbaptist iexposure.com
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
DBmaildbmail.org
htt
ps://mailman.fastxs.nl/mailman/listinfo/dbmail
|
