Regarding
http://www.kamailio.org/docs/modules/4.1.x/modules/acc.html#acc.p.db_insert…
"If set to 1, use INSERT DELAYED to add records to accounting tables when the
DB driver has support for it. If no INSERT DELAYED support is offered by DB
driver, then standard INSERT is used."
With the switch to InnoDB in 4.1 acc is by default no longer a table that
supports INSERT DELAYED. Mysqld generates an error when trying INSERT DELAYED
on a backend that doesn't support this, the driver does support delayed but is
oblivious to this not working on acc:
/usr/sbin/kamailio[19378]: ERROR: db_mysql [km_dbase.c:122]:
db_mysql_submit_query(): driver error on query: DELAYED option not supported
for table 'acc'
/usr/sbin/kamailio[19378]: ERROR: <core> [db_query.c:235]: db_do_insert_cmd():
error while submitting query
/usr/sbin/kamailio[19378]: ERROR: acc [acc.c:504]: acc_db_request(): failed to
insert delayed into database
So beware if you use InnoDB and INSERT DELAYED. Maybe the documentation should
mentioning the fact that the 4.1 defaults don't work for mysql. But people
will figure this out fast when there is no accounting :)
--
POCOS B.V. - Croy 9c - 5653 LC Eindhoven
Telefoon: 040 293 8661 - Fax: 040 293 8658
http://www.pocos.nl/ -
http://www.sipo.nl/
K.v.K. Eindhoven 17097024