Mark Martinec schrieb: >>> Try removing all FOREIGN KEY constraints, these are not essential. >> Just for the record, here is the complete SQL set for MySQL 5.1: > > Thanks. Does this work now? I have to come back to this.
I'm confronted with these errors: Apr 21 13:52:45 texs099 amavis[19951]: (19951) sql begin transaction Apr 21 13:52:45 texs099 amavis[19951]: (19951) sql: executing clause: INSERT INTO msgrcpt (partition_tag, mail_id, rid, ds, rs, bl, wl, bspam_level, smtp_resp) VALUES (?,?,?,?,?,?,?,?,?) Apr 21 13:52:45 texs099 amavis[19951]: (19951) sql rollback Apr 21 13:52:45 texs099 amavis[19951]: (19951) save_info_final: rollback done Apr 21 13:52:45 texs099 amavis[19951]: (19951) (!)WARN save_info_final: sql exec: err=1062, 23000, DBD::mysql::st execute failed: Duplicate entry '16' for key 'PRIMARY' at (eval 99) line 166, <GEN80> line 34. Apr 21 13:52:45 texs099 amavis[19951]: (19951) sql_storage: retrying on final, 4 attempts remain Apr 21 13:52:46 texs099 amavis[19951]: (19951) sql begin transaction Apr 21 13:52:46 texs099 amavis[19951]: (19951) sql: executing clause: INSERT INTO msgrcpt (partition_tag, mail_id, rid, ds, rs, bl, wl, bspam_level, smtp_resp) VALUES (?,?,?,?,?,?,?,?,?) Apr 21 13:52:46 texs099 amavis[19951]: (19951) sql rollback Apr 21 13:52:46 texs099 amavis[19951]: (19951) save_info_final: rollback done Apr 21 13:52:46 texs099 amavis[19951]: (19951) (!)WARN save_info_final: sql exec: err=1062, 23000, DBD::mysql::st execute failed: Duplicate entry '16' for key 'PRIMARY' at (eval 99) line 166, <GEN80> line 34. Apr 21 13:52:46 texs099 amavis[19951]: (19951) sql_storage: retrying on final, 3 attempts remain Apr 21 13:52:48 texs099 amavis[19951]: (19951) sql begin transaction [...] Apr 21 13:52:52 texs099 amavis[19951]: (19951) (!)WARN save_info_final: sql exec: err=1062, 23000, DBD::mysql::st execute failed: Duplicate entry '16' for key 'PRIMARY' at (eval 99) line 166, <GEN80> line 34. Apr 21 13:52:52 texs099 amavis[19951]: (19951) (!!)ERROR sql_storage: too many retries on storing final, info not saved Where is seams to work fine: Apr 21 13:52:45 texs099 amavis[19951]: (19951) sql begin transaction Apr 21 13:52:45 texs099 amavis[19951]: (19951) sql: executing clause: INSERT INTO msgs (partition_tag, mail_id, secret_id, am_id, time_num, time_iso, sid, policy, client_addr, size, host) VALUES (?,?,?,?,?,?,?,?,?,?,?) Apr 21 13:52:45 texs099 amavis[19951]: (19951) sql commit "16" is the current week of the year. I think "PRIMARY KEY (partition_tag)" in "CREATE TABLE msgrcpt" is not working here. Any hint? Marc ------------------------------------------------------------------------------ _______________________________________________ AMaViS-user mailing list AMaViS-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/amavis-user AMaViS-FAQ:http://www.amavis.org/amavis-faq.php3 AMaViS-HowTos:http://www.amavis.org/howto/
