[SR-Users] mariadb and sql_query_async: the db driver module doesn't support async query
Daniel Tryba
d.tryba at pocos.nl
Tue Mar 1 16:02:49 CET 2016
So trying to push some inserts/updates to the background I added:
async_workers=1
and
replaced
sql_xquery("ca", "$var(query)", "ra");
sql_result_free("ra");
with
sql_query_async("ca", "$var(query)");
where: $var(query)="insert into CDR.callogs (accountcode,number) values
('"+$var(accountcode)+"',substring('"+$rU+"',1,4))";
Only to find out that the queries aren't inserted and the log contains:
/usr/sbin/kamailio[24754]: ERROR: sqlops [sql_api.c:429]:
sql_do_query_async(): the db driver module doesn't support async query
The table is an InnoDB some insert delayed should give these kind of
errors, but isn't the point of sql_query_async that it does the plain
normal insert in a background task?
Test machine: kamailio 4.2.5
More information about the sr-users
mailing list