[asterisk-dev] [Code Review] 3559: sqlite3: Add ability to automatically retry query to busy database

[Igor Goncharovsky]

-----------------------------------------------------------
This is an automatically generated e-mail. To reply, visit:
https://reviewboard.asterisk.org/r/3559/
-----------------------------------------------------------

(Updated June 11, 2014, 10:56 a.m.)


Review request for Asterisk Developers.


Bugs: ASTERISK-23766
    https://issues.asterisk.org/jira/browse/ASTERISK-23766


Repository: Asterisk


Description
-------

We have faced situation when using CDR and CEL by sqlite3 modules. With system having high load (~100 concurrent calls created by sipp) we found many cdr and cel records missed. There is special finction in sqlite3, that make able to fix this situation - sqlite3_wait_timeout, that also can replace awful code cdr_sqlite3 ad cel_sqlite3 modules. Also this function can be used for aastdb and res_config_sqlite3 to avoid missed writes to sqlite db.


Diffs (updated)
-----

  /trunk/res/res_config_sqlite3.c 414674 
  /trunk/main/db.c 414674 
  /trunk/cel/cel_sqlite3_custom.c 414674 
  /trunk/cdr/cdr_sqlite3_custom.c 414674 

Diff: https://reviewboard.asterisk.org/r/3559/diff/


Testing
-------

Adding sqlite3_wait_timeout already used as patch in AskoziaPBX and show good result.


Thanks,

Igor Goncharovsky

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.digium.com/pipermail/asterisk-dev/attachments/20140611/fc512e05/attachment.html>