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
On Tue, Jun 7, 2011 at 9:10 AM, Tijmen de Mes <[email protected]>wrote: > Hi, > > 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? > > > Best regards, > > -- > Tijmen de Mes > AG Projects > > > Op 6/7/11 4:07 PM, Duane Larson schreef: > > When I execute > update active_sessions set > val='Q0RSYzokdGhpcy0+aW4gPSAnJzsgJHRoaXMtPnB0ID0gYXJyYXkoKTsgJHRoaXMtPnB0WydhdXRoJ10gPSAnMSc7ICR0aGlzLT5wdFsnY2hhbGxlbmdlJ10gPSAnMSc7ICRHTE9CQUxTWydhdXRoJ10gPSBuZXcgQ0RSVG9vbF9BdXRoOyAkR0xPQkFMU1snYXV0aCddLT5hdXRoID0gYXJyYXkoKTsgJEdMT0JBTFNbJ2F1dGgnXS0+YXV0aFsndWlkJ10gPSAnZm9ybSc7ICRHTE9CQUxTWydhdXRoJ10tPmF1dGhbJ3Blcm0nXSA9ICcnOyAkR0xPQkFMU1snYXV0aCddLT5hdXRoWydzb3VyY2UnXSA9ICcnOyAkR0xPQkFMU1snYXV0aCddLT5hdXRoWydleHAnXSA9ICcyMTQ3NDgzNjQ3JzsgJEdMT0JBTFNbJ2F1dGgnXS0+YXV0aFsncmVmcmVzaCddID0gJzIxNDc0ODM2NDcnOyAkR0xPQkFMU1snY2hhbGxlbmdlJ10gPSAnJzsg', > changed='20110606111425', count=count+1 where > sid='99eeb2a6426095d5708d0a5149196bae' and name='CDRc' > > manually it is ok > Query OK, 1 row affected (0.00 sec) > Rows matched: 1 Changed: 1 Warnings: 0 > > This doesn't happen all the time. It appears that something happens after > a while and then I start getting the > MySQL error: 1036 (Table 'active_sessions' is read only) Session halted. > errors. > > I will have to look into this more. If anyone has any ideas let me know. > > > > > > > On Tue, Jun 7, 2011 at 8:10 AM, Tijmen de Mes <[email protected]>wrote: > >> Hi, >> >> It looks like there is something wrong with your database. What happens if >> you execute the active sessions query manually? >> >> Do you have an empty database, or are there valid destinations in ther >> (from the sample data)? >> >> Best regards, >> >> -- >> Tijmen de Mes >> AG Projects >> >> Op 6/6/11 6:37 PM, Duane Larson schreef: >> >> I am having some database errors with a new install of CDRTool. One >> error I keep seeing in my syslog is >> >> 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 >> >> >> 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. >> >> >> 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 >> >> >> MySQL error: 1036 (Table 'active_sessions' is read only) Session halted. >> >> When I look in the syslog I see the following error >> >> Database error: Invalid SQL: update active_sessions set >> val='Q0RSYzokdGhpcy0+aW4gPSAnJzsgJHRoaXMtP >> >> nB0ID0gYXJyYXkoKTsgJHRoaXMtPnB0WydhdXRoJ10gPSAnMSc7ICR0aGlzLT5wdFsnY2hhbGxlbmdlJ10gPSAnMSc7ICRHTE9CQUxTWydhdXRoJ10gPSBuZXcgQ0RSVG9vbF9BdXRoO >> >> yAkR0xPQkFMU1snYXV0aCddLT5hdXRoID0gYXJyYXkoKTsgJEdMT0JBTFNbJ2F1dGgnXS0+YXV0aFsndWlkJ10gPSAnZm9ybSc7ICRHTE9CQUxTWydhdXRoJ10tPmF1dGhbJ3Blcm0nX >> >> SA9ICcnOyAkR0xPQkFMU1snYXV0aCddLT5hdXRoWydzb3VyY2UnXSA9ICcnOyAkR0xPQkFMU1snYXV0aCddLT5hdXRoWydleHAnXSA9ICcyMTQ3NDgzNjQ3JzsgJEdMT0JBTFNbJ2F1d >> GgnXS0+YXV0aFsncmVmcmVzaCddID0gJzIxNDc0ODM2NDcnOyAkR0xPQkFMU1snY2hhbGxlbmdlJ10gPSAnJzsg', >> changed='20110606111425', count=count+1 where sid= >> '99eeb2a6426095d5708d0a5149196bae' and name='CDRc' >> >> >> >> >> If I stop cdrtool and try to restart it I am not able to restart CDRTool >> and see the following error in syslog >> Database error: Invalid SQL: delete from memcache where `key` = >> 'destinations_sip' or `key` = 'destinations' >> >> In order to get CDRTool to start up again I have to stop and restart MySQL >> database. >> >> Any ideas what could be wrong? This is the latest version of CDRTool and >> I am running it on Ubuntu Maverick. >> >> >> >> _______________________________________________ >> Users mailing >> [email protected]http://lists.opensips.org/cgi-bin/mailman/listinfo/users >> >> >> >> _______________________________________________ >> Users mailing list >> [email protected] >> http://lists.opensips.org/cgi-bin/mailman/listinfo/users >> >> > > > -- > -- > *--*--*--*--*--* > Duane > *--*--*--*--*--* > -- > > > _______________________________________________ > Users mailing > [email protected]http://lists.opensips.org/cgi-bin/mailman/listinfo/users > > > > _______________________________________________ > Users mailing list > [email protected] > http://lists.opensips.org/cgi-bin/mailman/listinfo/users > > -- -- *--*--*--*--*--* Duane *--*--*--*--*--* --
_______________________________________________ Users mailing list [email protected] http://lists.opensips.org/cgi-bin/mailman/listinfo/users
