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]
<mailto:[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 list
[email protected] <mailto:[email protected]>
http://lists.opensips.org/cgi-bin/mailman/listinfo/users
_______________________________________________
Users mailing list
[email protected] <mailto:[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
_______________________________________________
Users mailing list
[email protected]
http://lists.opensips.org/cgi-bin/mailman/listinfo/users
