[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 16, 2014, 3:52 a.m.)


Status
------

This change has been marked as submitted.


Review request for Asterisk Developers.


Changes
-------

Committed in revision 416336


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
-----

  /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/20140616/d39bb46c/attachment.html>