The following issue has been RESOLVED. ====================================================================== http://www.dbmail.org/mantis/view.php?id=890 ====================================================================== Reported By: Emilio Gargiulo Assigned To: paul ====================================================================== Project: DBMail Issue ID: 890 Category: Documentation Reproducibility: always Severity: major Priority: normal Status: resolved target: Resolution: fixed Fixed in Version: ====================================================================== Date Submitted: 12-Apr-11 23:32 CEST Last Modified: 13-Apr-11 09:05 CEST ====================================================================== Summary: dbmail-util -M fails if big attachements and mysql and max_allowed_packet = 16M or less Description: command dbmail-util -M fail and leave database dirty if there is one or more messages with big attachements and mysql max_allowed_packet = 16M or less.
After the database remains dirty and in syslog this error messages: Apr 12 11:37:57 miughe dbmail/maintenance[5765]: [0x11e0040] Error:[db] db_exec(+319): SQLException: Duplicate entry '25135-1-0-0' for key 'message_parts' Apr 12 11:37:57 miughe dbmail/maintenance[5765]: [0x11e0040] Error:[db] db_exec(+320): failed query [INSERT INTO dbmail_partlists (physmessage_id, is_header, part_key, part_depth, part_order, part_id) VALUES Apr 12 11:38:25 miughe dbmail/maintenance[5776]: [0x1f67040] Error:[db] db_exec(+319): SQLException: Duplicate entry '25135-1-0-0' for key 'message_parts' Apr 12 11:38:25 miughe dbmail/maintenance[5776]: [0x1f67040] Error:[db] db_exec(+320): failed query [INSERT INTO dbmail_partlists (physmessage_id, is_header, part_key, part_depth, part_order, part_id) VALUES Apr 12 11:45:12 miughe dbmail/imap4d[26773]: [0x779f50] Error:[clientbase] dm_tls_error(+52): Unknown error The workaround is: 1) increase the max_allowed_packet = 1600M and stop & start mysql; 2) delete from dbmail_partlists where physmessage_id=25135; 3) dbmail-util -a -y 4) dbmail-util -M -y ====================================================================== ---------------------------------------------------------------------- (0003173) Emilio Gargiulo (reporter) - 12-Apr-11 23:56 http://www.dbmail.org/mantis/view.php?id=890#c3173 ---------------------------------------------------------------------- This is the syslog messages when generate the error: Apr 11 03:55:58 miughe dbmail/maintenance[13136]: [0x90d040] Error:[message] blob_exists(+166): SQLException: Got a packet bigger than 'max_allowed_packet' bytes Apr 11 03:55:58 miughe dbmail/maintenance[13136]: [0x90d040] Error:[message] blob_insert(+203): SQLException: Got a packet bigger than 'max_allowed_packet' bytes and: Apr 11 03:55:58 miughe dbmail/maintenance[13136]: [0x90d040] Error:[message] blob_exists(+166): SQLException: Got a packet bigger than 'max_allowed_packet' bytes Apr 11 03:55:58 miughe dbmail/maintenance[13136]: [0x90d040] Error:[message] blob_insert(+203): SQLException: Got a packet bigger than 'max_allowed_packet' bytes ---------------------------------------------------------------------- (0003174) paul (administrator) - 13-Apr-11 09:05 http://www.dbmail.org/mantis/view.php?id=890#c3174 ---------------------------------------------------------------------- This is a documentation bug. I've updated the UPGRADING and INSTALL files. Issue History Date Modified Username Field Change ====================================================================== 12-Apr-11 23:32 Emilio GargiuloNew Issue 12-Apr-11 23:56 Emilio GargiuloNote Added: 0003173 13-Apr-11 09:05 paul Note Added: 0003174 13-Apr-11 09:05 paul Assigned To => paul 13-Apr-11 09:05 paul Status new => resolved 13-Apr-11 09:05 paul Resolution open => fixed 13-Apr-11 09:05 paul Category Command-Line programs (dbmail-users, dbmail-util) => Documentation ====================================================================== _______________________________________________ Dbmail-dev mailing list Dbmail-dev@dbmail.org http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail-dev
