Yes, I also recognized that the transaction is not being comitted to the DB.
This is the schema of msgs on my server: show create table msgs; | msgs | CREATE TABLE `msgs` ( `mail_id` varchar(12) NOT NULL default '', `secret_id` varchar(12) default '', `am_id` varchar(20) NOT NULL default '', `time_num` int(10) unsigned NOT NULL default '0', `time_iso` varchar(16) NOT NULL default '', `sid` int(10) unsigned NOT NULL default '0', `policy` varchar(255) default '', `client_addr` varchar(255) default '', `size` int(10) unsigned NOT NULL default '0', `content` char(1) default NULL, `quar_type` char(1) default NULL, `dsn_sent` char(1) default NULL, `spam_level` float default NULL, `message_id` varchar(255) default '', `from_addr` varchar(255) default '', `subject` varchar(255) default '', `host` varchar(255) NOT NULL default '', PRIMARY KEY (`mail_id`), KEY `sid` (`sid`), KEY `msgs_idx_sid` (`sid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 | The only difference is the DEFAULT CHARSET... But I don't think that this could make this difference, am I right? I took all the tables from /usr/share/doc/amavisd-new/README.sql.gz: mysql> show tables; +------------------+ | Tables_in_amavis | +------------------+ | maddr | | mailaddr | | msgrcpt | | msgs | | policy | | quarantine | | users | | wblist | +------------------+ Thanks for helping me to solve this issue. -- Insecure dependency when using sql for Log Reporting https://bugs.launchpad.net/bugs/211915 You received this bug notification because you are a member of Ubuntu Server Team, which is subscribed to amavisd-new in ubuntu. -- Ubuntu-server-bugs mailing list Ubuntu-server-bugs@lists.ubuntu.com Modify settings or unsubscribe at: https://lists.ubuntu.com/mailman/listinfo/ubuntu-server-bugs