[SR-Users] Documentation "error" acc module 4.1

[Daniel Tryba]

Regarding
http://www.kamailio.org/docs/modules/4.1.x/modules/acc.html#acc.p.db_insert_mode

"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