Re: Upgrade from dbmail 1.2.12.1 to 2.2.9

Remove all messages and physmessages with size=0

Those empty message are very likely a side effect of some
bug in 1.2's
insertion code. We've come a very long way since then.

Noone is interested in supporting dbmail 1.2 anymore unless
someone at
IC&S has some compelling business case with one of their
customers
running 1.2.

Bret Baptist wrote:
> 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.
> 
> 
> 

-- 

____________________________________________________________
____
  Paul Stevens                                      paul at
nfg.nl
  NET FACILITIES GROUP                     GPG/PGP:
1024D/11F8CD31
  The Netherlands________________________________http://www.nfg.nl
_______________________________________________
DBmail mailing list
DBmaildbmail.org
htt
ps://mailman.fastxs.nl/mailman/listinfo/dbmail

Re: Upgrade from dbmail 1.2.12.1 to 2.2.9

Thread: Re: Upgrade from dbmail 1.2.12.1 to 2.2.9