thr3ads.net - asterisk users - [asterisk-users] Spontaneous reboot due to MySQL lookups ? [Oct 2018]

If this information is useful, please help other people find it:
Share via:

Jonas Kellens

2018-Oct-04 19:35 UTC

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

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>

Jonathan H

2018-Oct-04 20:01 UTC

head link

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

On Thu, 4 Oct 2018 at 20:36, Jonas Kellens <jonas.kellens at telenet.be>
wrote:
> I stick to 1.8 because it just works.
Well, clearly it doesn't because you're posting here! In a few days
time,
the *8-year-old* Asterisk 1.8 line will be *three years past EOL.*
That means End of Life. Do not use. No more support.

Now, if you were to bring yourself onto the current 13.x LTS (or perhaps
better still wait a few days until the 16.x LTS which will be supported
until 2023), then you might get more answers.
> I had some issues with version 11 and 13 in the past.
Especially if you explain what issues you had with version 13 in the past.
-------------- next part --------------
An HTML attachment was scrubbed...
URL:
<http://lists.digium.com/pipermail/asterisk-users/attachments/20181004/3db797b2/attachment.html>

John Novack

2018-Oct-04 23:25 UTC

head link

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

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/20181004/842db737/attachment.html>

Nasir Iqbal

2018-Oct-05 04:21 UTC

head link

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

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>

Jonas Kellens

2018-Oct-12 08:38 UTC

head link

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

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>

asterisk users - Oct 2018 - Spontaneous reboot due to MySQL lookups ?

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

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

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

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

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