On 08/26/2013 07:31 AM, Thomas Raschbacher wrote:
> hi
>
> I got this error:
>
> dbmail-util -M -yv
> Opening connection to database...
> Opening connection to authentication...
> Ok. Connected.
> Migrate legacy 2.2.x messageblks to mimeparts...
> Preparing to migrate up to 10000 physmessages.
> Migrating 10000 physmessages...
> Aug 26 07:25:15 lordvan.com dbmail-util[10294]: [0xa28a10] Error:[db]
> db_exec(+329): SQLException: ERROR: duplicate key value violates unique
> constraint "message_parts"
> DETAIL: Key (physmessage_id, part_key, part_depth,
> part_order)=(26241084, 1, 0, 0) already exists.
>
> Aug 26 07:25:15 lordvan.com dbmail-util[10294]: [0xa28a10] Error:[db]
> db_exec(+330): failed query [INSERT INTO dbmail_partlists
> (physmessage_id, is_header, part_key, part_depth, part_order, part_id)
> VALUES (26241084,1,1,0,0,1056700)]
> Migration complete. Migrated 1 physmessages.
>
> Maintenance done. No errors found.
>
> How do I best go about dealing with this? -- i don't want to go to the
> db and start deleting rows "randomly" .. ;)
No way around that. Apparently message 26241084 got migrated only
partially. Delete the rows involved from mimeparts and partlists.
--
________________________________________________________________
Paul J Stevens pjstevns @ gmail, twitter, skype, linkedin
* Premium Hosting Services and Web Application Consultancy *
www.nfg.nl/[email protected]/+31.85.877.99.97
________________________________________________________________
_______________________________________________
DBmail mailing list
[email protected]
http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail
