[OpenSIPS-Users] CDRTool - Database error's

[Tijmen de Mes]

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 <tijmen at ag-projects.com 
> <mailto:tijmen at ag-projects.com>> 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
>>     Users at lists.opensips.org  <mailto:Users at lists.opensips.org>
>>     http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>
>
>     _______________________________________________
>     Users mailing list
>     Users at lists.opensips.org <mailto:Users at lists.opensips.org>
>     http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>
>
>
>
> -- 
> --
> *--*--*--*--*--*
> Duane
> *--*--*--*--*--*
> --
>
>
> _______________________________________________
> Users mailing list
> Users at lists.opensips.org
> http://lists.opensips.org/cgi-bin/mailman/listinfo/users

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.opensips.org/pipermail/users/attachments/20110607/9d0543f3/attachment.htm>