[asterisk-users] Spontaneous reboot due to MySQL lookups ?
Nasir Iqbal
nasir at ictinnovations.com
Thu Oct 4 23:21:37 CDT 2018
Hi Jonas Kellens,
Like everybody else, I also recommend to upgrade your Asterisk version, and
replace mysql driver with odbc. the one big advantage of odbc driver is its
pooling feature, you can configure odbc to create a reusable pool of active
connections, so Asterisk does't needs to reconnect for each query.
For example with following odbc settings you can achieve 500+ concurrent
channels (approx 2500 queries / minute) without any performance issue.
pooling => yes
limit => 16
pre-connect => yes
Regards
Nasir Iqbal
ICTBroadcast - an Auto Dialer software for ITSP
<https://www.ictbroadcast.com/how-become-internet-telephony-service-provider-itsp-using-ictbroadcast-sp-edition>
SMS, Fax and Voice broadcasting & Inbound / Outbound Campaigns
http://www.ictbroadcast.com/
On Fri, Oct 5, 2018 at 4:26 AM John Novack <jnovack at comcast.net> wrote:
> As others have said, clearly it ISN'T "just working" or you would not have
> posted the question
>
> To state again, I am using Version 13, though a few minor revisions
> behind, with MySql, on CentOS 6 and have no rebooting or other MySql
> related issues
>
> Clearly you need to state in more detail what issues remain, once you
> migrate to AT LEAST 13.xx, and state your OS after becoming current with
> Asterisk, MySql and the OS
>
> I use MySql on every incoming call, and also maintain call detail records
> in MySql for every call, and it just simply works, and has for some time.
>
> Although I may be using it quite differently that you, it simply works.
> Is this a newly developing issue, or has it persisted for some time
> What if any changes have been made to the dialplan etc?
>
> Have you considered a strictly hardware issue? Memory? HD? MB??
>
> The crystal ball is very cloudy on this one!
>
> John Novack
>
>
> Jonas Kellens wrote:
>
> Hello
>
> thank you for your answer.
>
> If I read your (and others) reaction correctly I can conclude that this is
> an Asterisk problem and not a problem of MySQL or dialplan logic ?
>
>
> You should know that the MySQL database is heavily questioned :
>
>
> mysql> show status like '%onn%';
> +--------------------------+--------+
> | Variable_name | Value |
> +--------------------------+--------+
> | Aborted_connects | 469 |
> | Connections | 132762 |
> | Max_used_connections | 8 |
> | Ssl_client_connects | 0 |
> | Ssl_connect_renegotiates | 0 |
> | Ssl_finished_connects | 0 |
> | Threads_connected | 3 |
> +--------------------------+--------+
> 7 rows in set (0.00 sec)
>
>
>
> I stick to 1.8 because it just works. I had some issues with version 11
> and 13 in the past.
>
>
> Regards
>
> Jonas.
>
> Op 04-10-18 om 17:49 schreef John Novack:
>
> Woefully out of date.
> You really need to put your efforts into at least a modest upgrade
> I use version 13 with MySql queries built into the dialplan on CentOs 6
> and have NO such issues, either performance or any restart or reboot. It
> simply works
>
> I never used either 1.6 or 1.8, going from 1.4 to version 11, which did
> require some syntax changes to the dialplan.
>
> Given that even version 11 is EOL, you really need to put your efforts
> into doing the migration rather than tracking this one down
>
> JMO
>
> John Novack
>
>
>
> Jonas Kellens wrote:
>
> Hello
>
> using Asterisk 1.8.32.
>
> I notice that there is a spontaneous reboot of the Asterisk system from
> time to time.
>
> When I look in the logs (verbose file) I noticed that every time this
> occurs it's at a moment that there is a MySQL action, be it a lookup or an
> insert/update/delete.
>
> I must say I do have some MySQL queries that occur in my dialplan when a
> call comes in, to look up different actions to perform on this call.
>
>
> An idea how to overcome this problem ? Seems a "performance" issue, no ?!
>
> Is it better to have these MySQL queries to be done by an external script
> (like a php script that I call with the System()-command or a
> SHELL()-command) ?
>
>
> Here are some examples from the verbose file.
>
>
>
> [Aug 22 15:19:10] VERBOSE[2977] pbx.c: [Aug 22 15:19:10] -- Executing
> [s at sub-GetAlertInfo:3] MYSQL("SIP/SipAgenT01-0000317d", "Connect connid
> localhost myuser mypwd myDB") in new stack
> [Aug 22 15:19:10] VERBOSE[2977] pbx.c: [Aug 22 15:19:10] -- Executing
> [s at sub-GetAlertInfo:5] MYSQL("SIP/SipAgenT01-0000317d", "Query resultid 1
> SELECT uri, callinfo FROM distringtone WHERE onoff='1'") in new stack
> [Aug 22 15:19:18] VERBOSE[3306] config.c: [Aug 22 15:19:18] == Parsing
> '/etc/asterisk/logger.conf': [Aug 22 15:19:18] VERBOSE[3306] config.c: [Aug
> 22 15:19:18] == Found
> [Aug 22 15:19:18] VERBOSE[3306] config.c: [Aug 22 15:19:18] == Parsing
> '/etc/asterisk/asterisk.conf': [Aug 22 15:19:18] VERBOSE[3306] config.c:
> [Aug 22 15:19:18] == Found
> [Aug 22 15:19:18] VERBOSE[3306] manager.c: [Aug 22 15:19:18] == Manager
> registered action DataGet
> [Aug 22 15:19:18] VERBOSE[3306] config.c: [Aug 22 15:19:18] == Parsing
> '/etc/asterisk/codecs.conf': [Aug 22 15:19:18] VERBOSE[3306] config.c: [Aug
> 22 15:19:18] == Found
> [Aug 22 15:19:18] VERBOSE[3306] loader.c: [Aug 22 15:19:18] Asterisk
> Dynamic Loader Starting:
> [Aug 22 15:19:18] VERBOSE[3306] config.c: [Aug 22 15:19:18] == Parsing
> '/etc/asterisk/modules.conf': [Aug 22 15:19:18] VERBOSE[3306] config.c:
> [Aug 22 15:19:18] == Found
> [Aug 22 15:19:18] VERBOSE[3306] config.c: [Aug 22 15:19:18] == Parsing
> '/etc/asterisk/res_config_mysql.conf': [Aug 22 15:19:18] VERBOSE[3306]
> config.c: [Aug 22 15:19:18] == Found
> [Aug 22 15:19:18] VERBOSE[3306] res_config_mysql.c: [Aug 22 15:19:18] ==
> MySQL RealTime driver loaded.
> [Aug 22 15:19:18] VERBOSE[3306] loader.c: [Aug 22 15:19:18]
> res_config_mysql.so => (MySQL RealTime Configuration Driver)
>
>
>
> [Aug 22 16:23:25] VERBOSE[24283] pbx.c: [Aug 22 16:23:25] -- Executing
> [s at sub-GetSipAccountdetails:3] MYSQL("SIP/SipAgenT01-00004184", "Connect
> connid localhost myuser mypwd myDB") in new stack
> [Aug 22 16:23:25] VERBOSE[24283] pbx.c: [Aug 22 16:23:25] -- Executing
> [s at sub-GetSipAccountdetails:4] MYSQL("SIP/SipAgenT01-00004184", "Query
> resultid 1 SELECT SIPusername, currstatus, available FROM tbl_SIP WHERE
> ID="800"") in new stack
> [Aug 22 16:23:32] VERBOSE[24309] config.c: [Aug 22 16:23:32] == Parsing
> '/etc/asterisk/logger.conf': [Aug 22 16:23:32] VERBOSE[24309] config.c:
> [Aug 22 16:23:32] == Found
> [Aug 22 16:23:32] VERBOSE[24309] config.c: [Aug 22 16:23:32] == Parsing
> '/etc/asterisk/asterisk.conf': [Aug 22 16:23:32] VERBOSE[24309] config.c:
> [Aug 22 16:23:32] == Found
> [Aug 22 16:23:32] VERBOSE[24309] manager.c: [Aug 22 16:23:32] == Manager
> registered action DataGet
> [Aug 22 16:23:32] VERBOSE[24309] config.c: [Aug 22 16:23:32] == Parsing
> '/etc/asterisk/codecs.conf': [Aug 22 16:23:32] VERBOSE[24309] config.c:
> [Aug 22 16:23:32] == Found
> [Aug 22 16:23:32] VERBOSE[24309] loader.c: [Aug 22 16:23:32] Asterisk
> Dynamic Loader Starting:
> [Aug 22 16:23:32] VERBOSE[24309] config.c: [Aug 22 16:23:32] == Parsing
> '/etc/asterisk/modules.conf': [Aug 22 16:23:32] VERBOSE[24309] config.c:
> [Aug 22 16:23:32] == Found
> [Aug 22 16:23:32] VERBOSE[24309] config.c: [Aug 22 16:23:32] == Parsing
> '/etc/asterisk/res_config_mysql.conf': [Aug 22 16:23:32] VERBOSE[24309]
> config.c: [Aug 22 16:23:32] == Found
> [Aug 22 16:23:32] VERBOSE[24309] res_config_mysql.c: [Aug 22 16:23:32]
> == MySQL RealTime driver loaded.
> [Aug 22 16:23:32] VERBOSE[24309] loader.c: [Aug 22 16:23:32]
> res_config_mysql.so => (MySQL RealTime Configuration Driver)
>
>
>
> [Oct 4 10:11:25] VERBOSE[4944] pbx.c: [Oct 4 10:11:25] -- Executing
> [s at sub-settings:16] MYSQL("SIP/SipAgenT01-000008cb", "Connect connid
> localhost myuser mypwd myDB") in new stack
> [Oct 4 10:11:25] VERBOSE[4944] pbx.c: [Oct 4 10:11:25] -- Executing
> [s at sub-settings:17] MYSQL("SIP/SipAgenT01-000008cb", "Query resultid 1
> SELECT blockID from DID where DID=987654321") in new stack
> [Oct 4 10:11:29] VERBOSE[4961] config.c: [Oct 4 10:11:29] == Parsing
> '/etc/asterisk/asterisk.conf': [Oct 4 10:11:29] VERBOSE[4961] config.c:
> [Oct 4 10:11:29] == Found
> [Oct 4 10:11:29] VERBOSE[4961] manager.c: [Oct 4 10:11:29] == Manager
> registered action DataGet
> [Oct 4 10:11:29] VERBOSE[4961] config.c: [Oct 4 10:11:29] == Parsing
> '/etc/asterisk/codecs.conf': [Oct 4 10:11:29] VERBOSE[4961] config.c:
> [Oct 4 10:11:29] == Found
> [Oct 4 10:11:29] VERBOSE[4961] loader.c: [Oct 4 10:11:29] Asterisk
> Dynamic Loader Starting:
> [Oct 4 10:11:29] VERBOSE[4961] config.c: [Oct 4 10:11:29] == Parsing
> '/etc/asterisk/modules.conf': [Oct 4 10:11:29] VERBOSE[4961] config.c:
> [Oct 4 10:11:29] == Found
> [Oct 4 10:11:29] VERBOSE[4961] config.c: [Oct 4 10:11:29] == Parsing
> '/etc/asterisk/res_config_mysql.conf': [Oct 4 10:11:29] VERBOSE[4961]
> config.c: [Oct 4 10:11:29] == Found
> [Oct 4 10:11:29] VERBOSE[4961] res_config_mysql.c: [Oct 4 10:11:29] ==
> MySQL RealTime driver loaded.
> [Oct 4 10:11:29] VERBOSE[4961] loader.c: [Oct 4 10:11:29]
> res_config_mysql.so => (MySQL RealTime Configuration Driver)
>
>
>
>
> Kind regards
>
> Jonas.
>
>
>
>
>
> --
>
> Dog is my Co-pilot
>
>
>
>
>
> --
>
> Dog is my Co-pilot
>
> --
> _____________________________________________________________________
> -- Bandwidth and Colocation Provided by http://www.api-digital.com --
>
> Astricon is coming up October 9-11! Signup is available at:
> https://www.asterisk.org/community/astricon-user-conference
>
> Check out the new Asterisk community forum at:
> https://community.asterisk.org/
>
> New to Asterisk? Start here:
> https://wiki.asterisk.org/wiki/display/AST/Getting+Started
>
> asterisk-users mailing list
> To UNSUBSCRIBE or update options visit:
> http://lists.digium.com/mailman/listinfo/asterisk-users
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.digium.com/pipermail/asterisk-users/attachments/20181005/7f34903a/attachment.html>
More information about the asterisk-users
mailing list