<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
</head>
<body text="#000000" bgcolor="#FFFFFF">
<font size="+1">Woefully out of date.<br>
You really need to put your efforts into at least a modest upgrade<br>
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<br>
<br>
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.<br>
<br>
Given that even version 11 is EOL, you really need to put your
efforts into doing the migration rather than tracking this one
down<br>
<br>
JMO<br>
<br>
John Novack<br>
<br>
<br>
</font><br>
<div class="moz-cite-prefix">Jonas Kellens wrote:<br>
</div>
<blockquote type="cite"
cite="mid:bf23646c-cc52-6744-5748-65727405ff57@telenet.be">
<meta http-equiv="content-type" content="text/html; charset=UTF-8">
<font face="Helvetica, Arial, sans-serif"> </font>
<p><font face="Helvetica, Arial, sans-serif">Hello</font></p>
<p><font face="Helvetica, Arial, sans-serif">using Asterisk
1.8.32.<br>
</font></p>
<p><font face="Helvetica, Arial, sans-serif">I notice that there
is a spontaneous reboot of the Asterisk system from time to
time.</font></p>
<p><font face="Helvetica, Arial, sans-serif">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.</font></p>
<p><font face="Helvetica, Arial, sans-serif">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.</font></p>
<p><font face="Helvetica, Arial, sans-serif"><br>
</font></p>
<p><font face="Helvetica, Arial, sans-serif">An idea how to
overcome this problem ? Seems a "performance" issue, no ?!</font></p>
<p><font face="Helvetica, Arial, sans-serif">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) ?<br>
</font></p>
<p><font face="Helvetica, Arial, sans-serif"><br>
</font></p>
<p><font face="Helvetica, Arial, sans-serif">Here are some
examples from the verbose file.</font></p>
<p><font face="Helvetica, Arial, sans-serif"><br>
<br>
[Aug 22 15:19:10] VERBOSE[2977] pbx.c: [Aug 22 15:19:10]
-- Executing [s@sub-GetAlertInfo:3]
MYSQL("SIP/SipAgenT01-0000317d", "Connect connid localhost
myuser mypwd myDB") in new stack<br>
[Aug 22 15:19:10] VERBOSE[2977] pbx.c: [Aug 22 15:19:10]
-- Executing [s@sub-GetAlertInfo:5]
MYSQL("SIP/SipAgenT01-0000317d", "Query resultid 1 SELECT uri,
callinfo FROM distringtone WHERE onoff='1'") in new stack<br>
[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<br>
[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<br>
[Aug 22 15:19:18] VERBOSE[3306] manager.c: [Aug 22 15:19:18]
== Manager registered action DataGet<br>
[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<br>
[Aug 22 15:19:18] VERBOSE[3306] loader.c: [Aug 22 15:19:18]
Asterisk Dynamic Loader Starting:<br>
[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<br>
[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<br>
[Aug 22 15:19:18] VERBOSE[3306] res_config_mysql.c: [Aug 22
15:19:18] == MySQL RealTime driver loaded.<br>
[Aug 22 15:19:18] VERBOSE[3306] loader.c: [Aug 22 15:19:18]
res_config_mysql.so => (MySQL RealTime Configuration
Driver)<br>
</font></p>
<p><font face="Helvetica, Arial, sans-serif"><br>
<br>
[Aug 22 16:23:25] VERBOSE[24283] pbx.c: [Aug 22 16:23:25]
-- Executing [s@sub-GetSipAccountdetails:3]
MYSQL("SIP/SipAgenT01-00004184", "Connect connid localhost
myuser mypwd myDB") in new stack<br>
[Aug 22 16:23:25] VERBOSE[24283] pbx.c: [Aug 22 16:23:25]
-- Executing [s@sub-GetSipAccountdetails:4]
MYSQL("SIP/SipAgenT01-00004184", "Query resultid 1 SELECT
SIPusername, currstatus, available FROM tbl_SIP WHERE
ID="800"") in new stack<br>
[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<br>
[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<br>
[Aug 22 16:23:32] VERBOSE[24309] manager.c: [Aug 22
16:23:32] == Manager registered action DataGet<br>
[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<br>
[Aug 22 16:23:32] VERBOSE[24309] loader.c: [Aug 22 16:23:32]
Asterisk Dynamic Loader Starting:<br>
[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<br>
[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<br>
[Aug 22 16:23:32] VERBOSE[24309] res_config_mysql.c: [Aug 22
16:23:32] == MySQL RealTime driver loaded.<br>
[Aug 22 16:23:32] VERBOSE[24309] loader.c: [Aug 22 16:23:32]
res_config_mysql.so => (MySQL RealTime Configuration
Driver)<br>
<br>
<br>
<br>
[Oct 4 10:11:25] VERBOSE[4944] pbx.c: [Oct 4 10:11:25]
-- Executing [s@sub-settings:16]
MYSQL("SIP/SipAgenT01-000008cb", "Connect connid localhost
myuser mypwd myDB") in new stack<br>
[Oct 4 10:11:25] VERBOSE[4944] pbx.c: [Oct 4 10:11:25]
-- Executing [s@sub-settings:17]
MYSQL("SIP/SipAgenT01-000008cb", "Query resultid 1 SELECT
blockID from DID where DID=987654321") in new stack<br>
[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<br>
[Oct 4 10:11:29] VERBOSE[4961] manager.c: [Oct 4 10:11:29]
== Manager registered action DataGet<br>
[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<br>
[Oct 4 10:11:29] VERBOSE[4961] loader.c: [Oct 4 10:11:29]
Asterisk Dynamic Loader Starting:<br>
[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<br>
[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<br>
[Oct 4 10:11:29] VERBOSE[4961] res_config_mysql.c: [Oct 4
10:11:29] == MySQL RealTime driver loaded.<br>
[Oct 4 10:11:29] VERBOSE[4961] loader.c: [Oct 4 10:11:29]
res_config_mysql.so => (MySQL RealTime Configuration
Driver)<br>
<br>
<br>
</font></p>
<p><font face="Helvetica, Arial, sans-serif"><br>
</font></p>
<p><font face="Helvetica, Arial, sans-serif"><br>
</font></p>
<p><font face="Helvetica, Arial, sans-serif">Kind regards</font></p>
<p><font face="Helvetica, Arial, sans-serif">Jonas.</font></p>
<p><font face="Helvetica, Arial, sans-serif"><br>
</font> </p>
<font face="Helvetica, Arial, sans-serif"> </font> <br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
</blockquote>
<br>
<pre class="moz-signature" cols="10000">--
Dog is my Co-pilot</pre>
</body>
</html>