[OpenSIPS-Devel] [ opensips-Feature Requests-3556425 ] cassandra cache logging

SourceForge.net noreply at sourceforge.net
Wed Aug 15 14:13:20 CEST 2012


Feature Requests item #3556425, was opened at 2012-08-11 13:22
Message generated for change (Comment added) made by vladut-paiu
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=1086413&aid=3556425&group_id=232389

Please note that this message will contain a full copy of the comment thread,
including the initial issue submission, for this request,
not just the latest update.
Category: modules
Group: trunk
Status: Closed
Priority: 5
Private: No
Submitted By: Richard Revels (rrevels)
Assigned to: Nobody/Anonymous (nobody)
Summary: cassandra cache logging

Initial Comment:
the cassandra module generates a lot of ERROR messages for a cache_fetch that returns no data.  I do quite a few fetches where I use data if it's present and move along if it's not.  In other words I'm not expecting to get data all the time and these log messages are not desired.  Can this be toned down for fetch operations?



Aug 11 20:15:00 trunking1 /usr/local/sbin/opensips[29903]: ERROR:cachedb_cassandra:cassandra_simple_get: ERROR2: Default TException.
Aug 11 20:15:00 trunking1 /usr/local/sbin/opensips[29903]: ERROR:cachedb_cassandra:cassandra_simple_get: ERROR2: Default TException.
Aug 11 20:15:00 trunking1 /usr/local/sbin/opensips[29903]: ERROR:cachedb_cassandra:cassandra_simple_get: ERROR2: Default TException.
Aug 11 20:15:00 trunking1 /usr/local/sbin/opensips[29903]: ERROR:cachedb_cassandra:cassandra_simple_get: giving up on query
Aug 11 20:15:00 trunking1 /usr/local/sbin/opensips[29903]: ERROR:cachedb_cassandra:cassandra_get: failed to fetch Cassandra value


----------------------------------------------------------------------

>Comment By: Vladut-Stefan Paiu (vladut-paiu)
Date: 2012-08-15 05:13

Message:
Hello,

The Cassandra DB url should be in the following format
        modparam("cachedb_cassandra",
"cachedb_url","cassandra:group1://localhos
t:9061/Keyspace1_Users_Counters");

The database is in the format "Keyspace_ColumnFamily_CounterColumnFamily" ,
because of the fact that you cannot store Counter column in regular column
families.
So to fix that error on your side :
- if you want to use Cassandra Counters in your OpenSIPS - create the
counter family in the cassandra cli and pass it in the cachedb_url at the
end
- if you do not want to use Cassandra Counters - just add '_counters' at
the end . Indeed this should be fixed, and have Cassandra reject Counter
Ops if you do not set the proper URL.

Regards,
Vlad

----------------------------------------------------------------------

Comment By: Nobody/Anonymous (nobody)
Date: 2012-08-15 04:55

Message:
Vlad, 
Greetings!  Thank you for doing that.  Trying not to be too picky or
anything but I'm not sure I like that change.  : >


Aug 15 11:42:22 trunking1 /usr/local/sbin/opensips[14990]:
DBG:cachedb_cassandra:child_init: iterating through conns -
[cassandra:cluster1://X.XX.XX.XX:9160/Registrations_Data]
Aug 15 11:42:22 trunking1 /usr/local/sbin/opensips[14990]:
DBG:core:parse_cachedb_url: parsing
[cassandra:cluster1://X.XX.XX.XX:9160/Registrations_Data]
Aug 15 11:42:22 trunking1 /usr/local/sbin/opensips[14990]:
DBG:core:cachedb_do_init: opening new connection
Aug 15 11:42:22 trunking1 /usr/local/sbin/opensips[14990]:
ERROR:cachedb_cassandra:cassandra_init_connection: invalid database. Should
be 'keyspace_columnfamily_counterfamily'
Aug 15 11:42:22 trunking1 /usr/local/sbin/opensips[14990]:
ERROR:core:cachedb_do_init: failed to open connection

In any case, I'm going to back it out for now.  I had changed the log level
in the code to DBG for a temp fix and am looking at some kind of problem
with dialplan this morning so would prefer not to come back to this just
yet.

----------------------------------------------------------------------

Comment By: Vladut-Stefan Paiu (vladut-paiu)
Date: 2012-08-15 04:25

Message:
Hello Richard,

I have just committed a fix for this in trunk, along with some other
Cassandra improvements.

Regards,
Vlad

----------------------------------------------------------------------

You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=1086413&aid=3556425&group_id=232389



More information about the Devel mailing list