VoIP Mailing List Archives
Mailing list archives for the VoIP community |
|
| View previous topic :: View next topic |
| Author |
Message |
viljoens at verishare....
Guest
|
 Posted: Fri Dec 11, 2015 5:59 am Post subject: [asterisk-users] CEL entries over ODBC several hours late (V |
 |
|
Hi Vinicius
Thanks for replying.
| Quote: | Sorry for the probably obvious question, but it's better to cover all
|
bases.
| Quote: | The DBMS is running on the same box as Asterisk is? If that's the case then
|
maybe the DBMS is using too much CPU and starving Asterisk?
I don't think so - I think I have a locking issue in the DB specifically
with my stored procedure -and- Asterisk trying to access the CEL table
simultaneously.
Load averages appear normal even if the DB is running in the background. The
autodestruct problem occurs whenever the CEL table (InnoDB, so should NOT be
locked for inserts while being queried in MySQL "nolock" equivalent, but it
IS) is busy being read by the SP and Asterisk tries to write into it.
This then back-flows to the Asterisk and delays the H extension execution to
such a degree that handsets get locked tight until the CEL table lock held
by the SP is released and Asterisk can write to it again over ODBC.
I understand that CEL logging and call hangup should be an atomic operation
(billing related) from there though the question about why it apparently
(from observed effects) is a synchronous operation - but considering it must
be atomic, it does make sense I suppose to write CELs synchronously with
call teardown.
It just requires that you keep the CEL table in MariaDB (or whatever) in an
"un-locked" state at all times - which makes it pretty hard since to have
any practical use out of the CEL table you should be able to query it
without locking it - which InnoDB in MariaDB is supposd to provide, but
clearly does not in my type of setup here.
Anyway, thanks for the reply.
Regards
Stefan
--
_____________________________________________________________________
-- Bandwidth and Colocation Provided by http://www.api-digital.com --
New to Asterisk? Join us for a live introductory webinar every Thurs:
http://www.asterisk.org/hello
asterisk-users mailing list
To UNSUBSCRIBE or update options visit:
http://lists.digium.com/mailman/listinfo/asterisk-users |
|
| Back to top |
|
 |
vinicius at aittelecom...
Guest
|
| Posted: Fri Dec 11, 2015 6:51 am Post subject: [asterisk-users] CEL entries over ODBC several hours late (V |
|
|
Since the issue seems to be table locking, why not take a shot with PostgreSQL? It's way better and more robust than MySQL/MariaDB.
You should be able to create an additional DSN and output CEL to both PostgreSQL and MariaDB.
2015-12-11 8:59 GMT-02:00 Stefan Viljoen <viljoens@verishare.co.za (viljoens@verishare.co.za)>:
| Quote: | Hi Vinicius
Thanks for replying.
| Quote: | Sorry for the probably obvious question, but it's better to cover all
|
bases.
| Quote: | The DBMS is running on the same box as Asterisk is? If that's the case then
|
maybe the DBMS is using too much CPU and starving Asterisk?
I don't think so - I think I have a locking issue in the DB specifically
with my stored procedure -and- Asterisk trying to access the CEL table
simultaneously.
Load averages appear normal even if the DB is running in the background. The
autodestruct problem occurs whenever the CEL table (InnoDB, so should NOT be
locked for inserts while being queried in MySQL "nolock" equivalent, but it
IS) is busy being read by the SP and Asterisk tries to write into it.
This then back-flows to the Asterisk and delays the H extension execution to
such a degree that handsets get locked tight until the CEL table lock held
by the SP is released and Asterisk can write to it again over ODBC.
I understand that CEL logging and call hangup should be an atomic operation
(billing related) from there though the question about why it apparently
(from observed effects) is a synchronous operation - but considering it must
be atomic, it does make sense I suppose to write CELs synchronously with
call teardown.
It just requires that you keep the CEL table in MariaDB (or whatever) in an
"un-locked" state at all times - which makes it pretty hard since to have
any practical use out of the CEL table you should be able to query it
without locking it - which InnoDB in MariaDB is supposd to provide, but
clearly does not in my type of setup here.
Anyway, thanks for the reply.
Regards
Stefan
--
_____________________________________________________________________
-- Bandwidth and Colocation Provided by http://www.api-digital.com --
New to Asterisk? Join us for a live introductory webinar every Thurs:
http://www.asterisk.org/hello
asterisk-users mailing list
To UNSUBSCRIBE or update options visit:
http://lists.digium.com/mailman/listinfo/asterisk-users
|
|
|
| Back to top |
|
|
|
|
|
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
|
Powered by phpBB © 2001, 2005 phpBB Group
|
Search
