<div>This is not in production so I don't think I am hitting a maximum connections limit. As for the max_allowed_packet it is set to 16M</div>
<div> </div>
<div><br><br> </div>
<div class="gmail_quote">On Tue, Jun 7, 2011 at 9:10 AM, Tijmen de Mes <span dir="ltr"><<a href="mailto:tijmen@ag-projects.com">tijmen@ag-projects.com</a>></span> wrote:<br>
<blockquote style="BORDER-LEFT: #ccc 1px solid; MARGIN: 0px 0px 0px 0.8ex; PADDING-LEFT: 1ex" class="gmail_quote">
<div text="#000000" bgcolor="#ffffff">Hi,<br><br>OK so there is nothing wrong with the queries. Is it possible you hit a maximum connections limit in mysql? And what is your max allowed packet size?
<div class="im"><br><br>Best regards,<br><br>--<br>Tijmen de Mes<br>AG Projects<br><br><br></div>Op 6/7/11 4:07 PM, Duane Larson schreef:
<div>
<div></div>
<div class="h5">
<blockquote type="cite">
<div>When I execute</div>
<div>update active_sessions set val='Q0RSYzokdGhpcy0+aW4gPSAnJzsgJHRoaXMtPnB0ID0gYXJyYXkoKTsgJHRoaXMtPnB0WydhdXRoJ10gPSAnMSc7ICR0aGlzLT5wdFsnY2hhbGxlbmdlJ10gPSAnMSc7ICRHTE9CQUxTWydhdXRoJ10gPSBuZXcgQ0RSVG9vbF9BdXRoOyAkR0xPQkFMU1snYXV0aCddLT5hdXRoID0gYXJyYXkoKTsgJEdMT0JBTFNbJ2F1dGgnXS0+YXV0aFsndWlkJ10gPSAnZm9ybSc7ICRHTE9CQUxTWydhdXRoJ10tPmF1dGhbJ3Blcm0nXSA9ICcnOyAkR0xPQkFMU1snYXV0aCddLT5hdXRoWydzb3VyY2UnXSA9ICcnOyAkR0xPQkFMU1snYXV0aCddLT5hdXRoWydleHAnXSA9ICcyMTQ3NDgzNjQ3JzsgJEdMT0JBTFNbJ2F1dGgnXS0+YXV0aFsncmVmcmVzaCddID0gJzIxNDc0ODM2NDcnOyAkR0xPQkFMU1snY2hhbGxlbmdlJ10gPSAnJzsg', changed='20110606111425', count=count+1 where sid='99eeb2a6426095d5708d0a5149196bae' and name='CDRc'</div>
<div> </div>
<div>manually it is ok</div>
<div>Query OK, 1 row affected (0.00 sec)<br>Rows matched: 1 Changed: 1 Warnings: 0</div>
<div> </div>
<div>This doesn't happen all the time. It appears that something happens after a while and then I start getting the </div>
<div>MySQL error: 1036 (Table 'active_sessions' is read only) Session halted. </div>
<div>errors.</div>
<div> </div>
<div>I will have to look into this more. If anyone has any ideas let me know.</div>
<div> </div>
<div> </div>
<div> </div>
<div><br><br> </div>
<div class="gmail_quote">On Tue, Jun 7, 2011 at 8:10 AM, Tijmen de Mes <span dir="ltr"><<a href="mailto:tijmen@ag-projects.com" target="_blank">tijmen@ag-projects.com</a>></span> wrote:<br>
<blockquote style="BORDER-LEFT: rgb(204,204,204) 1px solid; MARGIN: 0px 0px 0px 0.8ex; PADDING-LEFT: 1ex" class="gmail_quote">
<div text="#000000" bgcolor="#ffffff">Hi,<br><br>It looks like there is something wrong with your database. What happens if you execute the active sessions query manually?<br><br>Do you have an empty database, or are there valid destinations in ther (from the sample data)?<br>
<br>Best regards,<br><br>--<br>Tijmen de Mes<br>AG Projects<br><br>Op 6/6/11 6:37 PM, Duane Larson schreef:
<blockquote type="cite">
<div>
<div>
<div>I am having some database errors with a new install of CDRTool. One error I keep seeing in my syslog is</div>
<div> </div>
<div>Database error: Invalid SQL: select *, UNIX_TIMESTAMP(AcctStartTime) as timestamp#012 from radacct201105 where (1=1) and Normalized = '0' and AcctStopTime not like '0000-00-00 00:00:00%' order by RadAcctId asc</div>
<div> </div>
<div> </div>
<div>I don't see any issues with this log, but I don't know why it is trying to look for radacct201105. It was never created and the database doesn't exist since this month is 201106.</div>
<div> </div>
<div> </div>
<div>Then I see another issue and this does cause issues with the CDRTool application. With this I am not able to log into the CDRTool and see the following error at the bottom of the login page</div>
<div> </div>
<div> </div>
<div>MySQL error: 1036 (Table 'active_sessions' is read only) Session halted. </div>
<div> </div>
<div>When I look in the syslog I see the following error</div>
<div> </div>
<div>Database error: Invalid SQL: update active_sessions set val='Q0RSYzokdGhpcy0+aW4gPSAnJzsgJHRoaXMtP<br>nB0ID0gYXJyYXkoKTsgJHRoaXMtPnB0WydhdXRoJ10gPSAnMSc7ICR0aGlzLT5wdFsnY2hhbGxlbmdlJ10gPSAnMSc7ICRHTE9CQUxTWydhdXRoJ10gPSBuZXcgQ0RSVG9vbF9BdXRoO<br>
yAkR0xPQkFMU1snYXV0aCddLT5hdXRoID0gYXJyYXkoKTsgJEdMT0JBTFNbJ2F1dGgnXS0+YXV0aFsndWlkJ10gPSAnZm9ybSc7ICRHTE9CQUxTWydhdXRoJ10tPmF1dGhbJ3Blcm0nX<br>SA9ICcnOyAkR0xPQkFMU1snYXV0aCddLT5hdXRoWydzb3VyY2UnXSA9ICcnOyAkR0xPQkFMU1snYXV0aCddLT5hdXRoWydleHAnXSA9ICcyMTQ3NDgzNjQ3JzsgJEdMT0JBTFNbJ2F1d<br>
GgnXS0+YXV0aFsncmVmcmVzaCddID0gJzIxNDc0ODM2NDcnOyAkR0xPQkFMU1snY2hhbGxlbmdlJ10gPSAnJzsg', changed='20110606111425', count=count+1 where sid=<br>'99eeb2a6426095d5708d0a5149196bae' and name='CDRc'</div>
<div> </div>
<div> </div>
<div> </div>
<div> </div>
<div>If I stop cdrtool and try to restart it I am not able to restart CDRTool and see the following error in syslog</div>
<div>Database error: Invalid SQL: delete from memcache where `key` = 'destinations_sip' or `key` = 'destinations'</div>
<div> </div>
<div>In order to get CDRTool to start up again I have to stop and restart MySQL database.</div>
<div> </div>
<div>Any ideas what could be wrong? This is the latest version of CDRTool and I am running it on Ubuntu Maverick.</div>
<div> </div></div></div><pre><fieldset></fieldset>
_______________________________________________
Users mailing list
<a href="mailto:Users@lists.opensips.org" target="_blank">Users@lists.opensips.org</a>
<a href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users" target="_blank">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a>
</pre></blockquote><br></div><br>_______________________________________________<br>Users mailing list<br><a href="mailto:Users@lists.opensips.org" target="_blank">Users@lists.opensips.org</a><br><a href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users" target="_blank">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a><br>
<br></blockquote></div><br><br clear="all"><br>-- <br>--<br>*--*--*--*--*--*<br>Duane<br>*--*--*--*--*--*<br>--<br><pre><fieldset></fieldset>
_______________________________________________
Users mailing list
<a href="mailto:Users@lists.opensips.org" target="_blank">Users@lists.opensips.org</a>
<a href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users" target="_blank">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a>
</pre></blockquote><br></div></div></div><br>_______________________________________________<br>Users mailing list<br><a href="mailto:Users@lists.opensips.org">Users@lists.opensips.org</a><br><a href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users" target="_blank">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a><br>
<br></blockquote></div><br><br clear="all"><br>-- <br>--<br>*--*--*--*--*--*<br>Duane<br>*--*--*--*--*--*<br>--<br>