[asterisk-users] Spontaneous reboot due to MySQL lookups ?
Jonas Kellens
jonas.kellens at telenet.be
Fri Oct 12 03:38:49 CDT 2018
Hello
thank you for your answer.
This does not happen all the time. It happens about once every 4 months.
I just can not pinpoint WHEN exactly it occurs. I just see in the
verbose logfile that it occurs after a MYSQL insert/update/delete statement.
If Asterisk 13 handels MYSQL connections in a better way, then indeed I
should look for upgrade.
Kind regards.
Op 05-10-18 om 01:25 schreef John Novack:
> 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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.digium.com/pipermail/asterisk-users/attachments/20181012/00b57b05/attachment.html>
More information about the asterisk-users
mailing list