[asterisk-users] Spontaneous reboot due to MySQL lookups ?

Thu Oct 4 14:35:20 CDT 2018

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

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.digium.com/pipermail/asterisk-users/attachments/20181004/3bfd3409/attachment.html>