Hi Daniel, just came to my mind: did you run dbmail util on your orginal storage/version? Maybe there is a problem in the dataset that might get fixed this way?
Otherwise I think you have to wait till Paul gets on this topic. Greetings, Daniel Am 22.05.2012 um 15:02 schrieb Daniel Schütze: > Actually it's now gotten to the point where dbmail-util -My doesn’t run for > more than a couple of seconds before I get the errors I'm encountering. I'm > not getting so many core dumps as just simple aborts to the command line: > > May 22 13:56:22 dbm3 dbmail-util[14952]: [0x80220b040] Error:[db] > db_exec(+319): SQLException: Cannot add or update a child row: a > foreign > key constraint fails (`dbmail`.`dbmail_partlists`, CONSTRAINT > `dbmail_partlists_ibfk_1` FOREIGN KEY (`physmessage_id`) REFERENCES > `dbmail_physmessage` (`id`) ON DELETE CASCADE ON UPDATE CASCADE) > May 22 13:56:22 dbm3 dbmail-util[14952]: [0x80220b040] Error:[db] > db_exec(+320): failed query [INSERT INTO dbmail_partlists > (physmessage_id, > is_header, part_key, part_depth, part_order, part_id) VALUES > (657895,1,1,0,0,27)] > migrating physmessage_id: 657895 > failed > > From the messages (phymessage_id) affected it is clear that the frequency is > getting worse and high enough that the conversion exercise now seems futile. > > Clearly I'll need to know/figure out what is causing this to try and > proceed. > > Daniel Schütze > > > _______________________________________________ > DBmail mailing list > DBmail@dbmail.org > http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail _______________________________________________ DBmail mailing list DBmail@dbmail.org http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail
