[SR-Users] db_cassandra

David david at styleflare.com
Mon Jan 23 14:16:40 CET 2012 

Still seeing this message.

I have added a domain to cassandra to verify the data is there.

  0(27209) DEBUG: db_cassandra [dbcassa_table.c:461]: found 
dbname=openser, table=version
  0(27209) DEBUG: db_cassandra [dbcassa_base.cpp:350]: query col = 
table_name
  0(27209) DEBUG: db_cassandra [dbcassa_base.cpp:375]: key = domain
  0(27209) DEBUG: db_cassandra [dbcassa_base.cpp:495]: Query col: 
table_version
  0(27209) DEBUG: db_cassandra [dbcassa_base.cpp:497]: get 1 columns
  0(27209) DEBUG: <core> [db_res.c:118]: allocate 48 bytes for result 
set at 0x7f8fbf82c3d8
  0(27209) DEBUG: <core> [db_res.c:155]: allocate 8 bytes for result 
names at 0x7f8fbf82c468
  0(27209) DEBUG: <core> [db_res.c:165]: allocate 4 bytes for result 
types at 0x7f8fbf82c4d0
  0(27209) DEBUG: db_cassandra [dbcassa_table.c:461]: found 
dbname=openser, table=version
  0(27209) DEBUG: db_cassandra [dbcassa_base.cpp:627]: 
RES_NAMES(0x7f8fbf82c538)[0]=[table_version]
  0(27209) DEBUG: <core> [db_res.c:184]: allocate 16 bytes for rows at 
0x7f8fbf82c5a8
  0(27209) DEBUG: <core> [db_row.c:119]: allocate 32 bytes for row 
values at 0x7f8fbf82c618
  0(27209) DEBUG: db_cassandra [dbcassa_base.cpp:683]: Exited with success
  0(27209) DEBUG: <core> [db_res.c:81]: freeing 1 columns
  0(27209) DEBUG: <core> [db_res.c:85]: freeing RES_NAMES[0] at 
0x7f8fbf82c538
  0(27209) DEBUG: <core> [db_res.c:94]: freeing result names at 
0x7f8fbf82c468
  0(27209) DEBUG: <core> [db_res.c:99]: freeing result types at 
0x7f8fbf82c4d0
  0(27209) DEBUG: <core> [db_res.c:54]: freeing 1 rows
  0(27209) DEBUG: <core> [db_row.c:97]: freeing row values at 0x7f8fbf82c618
  0(27209) DEBUG: <core> [db_res.c:62]: freeing rows at 0x7f8fbf82c5a8
  0(27209) DEBUG: <core> [db_res.c:136]: freeing result set at 
0x7f8fbf82c3d8
  0(27209) DEBUG: db_cassandra [dbcassa_base.cpp:570]: query table=domain
  0(27209) DEBUG: db_cassandra [dbcassa_table.c:461]: found 
dbname=openser, table=domain
  0(27209) ERROR: db_cassandra [dbcassa_base.cpp:361]: The key column 
with name [domain] not found in values
  0(27209) DEBUG: db_cassandra [dbcassa_base.cpp:375]: key =
  0(27209) ERROR: db_cassandra [dbcassa_base.cpp:450]: Query not 
supported - key not provided
  0(27209) ERROR: db_cassandra [dbcassa_base.cpp:577]: Failed to query 
Cassandra cluster
  0(27209) ERROR: domain [domain.c:258]: Error while querying database
  0(27209) ERROR: domain [domain_mod.c:219]: Domain table reload failed
  0(27209) DEBUG: <core> [db_pool.c:102]: removing connection from the pool
  0(27209) ERROR: <core> [sr_module.c:939]: init_mod(): Error while 
initializing module domain (/usr/local/lib64/kamailio/modules_k/domain.so)
ERROR: error while initializing modules
  0(27209) DEBUG: tm [t_funcs.c:122]: DEBUG: tm_shutdown : start
  0(27209) DEBUG: tm [t_funcs.c:125]: DEBUG: tm_shutdown : emptying hash 
table
  0(27209) DEBUG: tm [t_funcs.c:127]: DEBUG: tm_shutdown : removing 
semaphores
  0(27209) DEBUG: tm [t_funcs.c:129]: DEBUG: tm_shutdown : destroying 
tmcb lists
  0(27209) DEBUG: tm [t_funcs.c:132]: DEBUG: tm_shutdown : done
  0(27209) DEBUG: <core> [mem/shm_mem.c:242]: shm_mem_destroy
  0(27209) DEBUG: <core> [mem/shm_mem.c:245]: destroying the shared 
memory lock


On 1/23/12 8:08 AM, Anca Vamanu wrote:
> On 01/23/2012 02:58 PM, David wrote:
>> domain(string) last_modified(timestamp)
>> domain
>>
> There is a problem in this schema: last_modified should not be of type 
> timestamp, but int. The type timestamp has a special meaning in 
> cassandra, you should use it only for columns that have the meaning of 
> expires col [1].
> I realise now that maybe I should change the name of this type, 
> because I see it might be confusing.
>
> [1] 
> http://sip-router.org/docbook/sip-router/branch/master/modules/db_cassandra/db_cassandra.html#id2796778
>
> Regards,
> Anca
>
>> On 1/23/12 7:45 AM, Anca Vamanu wrote:
>>> Hi David,
>>>
>>> How does you your table schema file for domain look like?
>>> I will try myself also with domain module when I have some time.
>>>
>>> Regards,
>>> Anca
>>>
>>>
>>> On 01/23/2012 02:23 PM, David wrote:
>>>> I know that it does not claim to support the "domain" module.
>>>>
>>>> I am just posting the output in case there is something I can do to 
>>>> make
>>>> it work.
>>>>
>>>> 0(22484) DEBUG: db_cassandra [dbcassa_base.cpp:570]: query 
>>>> table=domain
>>>>     0(22484) DEBUG: db_cassandra [dbcassa_table.c:461]: found
>>>> dbname=openser, table=domain
>>>>     0(22484) ERROR: db_cassandra [dbcassa_base.cpp:361]: The key 
>>>> column
>>>> with name [domain] not found in values
>>>>     0(22484) DEBUG: db_cassandra [dbcassa_base.cpp:375]: key =
>>>>     0(22484) ERROR: db_cassandra [dbcassa_base.cpp:450]: Query not
>>>> supported - key not provided
>>>>     0(22484) ERROR: db_cassandra [dbcassa_base.cpp:577]: Failed to 
>>>> query
>>>> Cassandra cluster
>>>>     0(22484) ERROR: domain [domain.c:258]: Error while querying 
>>>> database
>>>>     0(22484) ERROR: domain [domain_mod.c:219]: Domain table reload 
>>>> failed
>>>>     0(22484) DEBUG:<core>   [db_pool.c:102]: removing connection from
>>>> the pool
>>>>     0(22484) ERROR:<core>   [sr_module.c:939]: init_mod(): Error while
>>>> initializing module domain
>>>> (/usr/local/lib64/kamailio/modules_k/domain.so)
>>>> ERROR: error while initializing modules
>>>>     0(22484) DEBUG: tm [t_funcs.c:122]: DEBUG: tm_shutdown : start
>>>>     0(22484) DEBUG: tm [t_funcs.c:125]: DEBUG: tm_shutdown : emptying
>>>> hash
>>>> table
>>>>     0(22484) DEBUG: tm [t_funcs.c:127]: DEBUG: tm_shutdown : removing
>>>> semaphores
>>>>     0(22484) DEBUG: tm [t_funcs.c:129]: DEBUG: tm_shutdown : 
>>>> destroying
>>>> tmcb lists
>>>>     0(22484) DEBUG: tm [t_funcs.c:132]: DEBUG: tm_shutdown : done
>>>>     0(22484) DEBUG:<core>   [mem/shm_mem.c:242]: shm_mem_destroy
>>>>     0(22484) DEBUG:<core>   [mem/shm_mem.c:245]: destroying the shared
>>>> memory lock
>>>>
>>>>
>>>>
>>>> On 1/23/12 4:05 AM, Anca Vamanu wrote:
>>>>> Hi David,
>>>>>
>>>>> As mentioned in the documentation[1], the module is compatible with
>>>>> thrift library version 0.6.1.
>>>>>
>>>>> [1]
>>>>> http://sip-router.org/docbook/sip-router/branch/master/modules/db_cassandra/db_cassandra.html 
>>>>>
>>>>>
>>>>>
>>>>>
>>>>> Regards,
>>>>> Anca
>>>>>
>>>>>
>>>>> On 01/22/2012 09:16 AM, David wrote:
>> _______________________________________________
>> SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
>> sr-users at lists.sip-router.org
>> http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users
>>
>
>
> _______________________________________________
> SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
> sr-users at lists.sip-router.org
> http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users

More information about the sr-users mailing list