[Freeswitch-users] Does nibble execute sql queries in single transaction ?

Mohd Kamal Mustafa kamal at xoxzo.com
Tue Sep 6 08:50:42 MSD 2016


If not, is there a possibilities of reach condition where updates from
multiple channels override each other. For example, 2 incoming calls
at the same time to 2 different numbers, but owned by single user -
that mean nibble will be updating the same record in database.

I'm planning to add "FOR UPDATE" clause to the custom_sql_lookup:-

SELECT cash AS nibble_balance FROM accounts WHERE
account_code='${nibble_account} FOR UPDATE

But if each query run inside their own transaction, that would be no use.

Thank you.



Join us at ClueCon 2016 Aug 8-12, 2016
More information about the FreeSWITCH-users mailing list