[OpenSIPS-Users] CACHEDB_MEMCACHED Module - libmemcached undefined symbol issue

Mon Nov 21 22:44:41 CET 2016

Ok, i figured it out, that the problem relies in port number definition.
I am getting no issues with 11211.

Thanks
Maciej

2016-11-21 22:20 GMT+01:00 Maciej Bylica <mbgatherer at gmail.com>:

> Hi Bogdan,
>
> Thanks for the reply.
>
> It seems it is related to the key, it doesn't matter which query is it.
> First query on the second key does not change anything.
> I've just added additional key 49101112233 and it works (query was fired),
> but 49331112233 does not.
>
> Thanks
> Maciej.
>
>
> 2016-11-21 12:59 GMT+01:00 Bogdan-Andrei Iancu <bogdan at opensips.org>:
>
>> Hi Maciej,
>>
>> Thanks for the detailed report.
>>
>> Do you think the error is related to the key you are trying to fetch or
>> is it related to the simply being the second query you perform ?  What if
>> you perform from the very beginning a a query on the second key ?
>>
>> Regards,
>>
>> Bogdan-Andrei Iancu
>> OpenSIPS Founder and Developerhttp://www.opensips-solutions.com
>>
>> On 18.11.2016 19:53, Maciej Bylica wrote:
>>
>> Hello
>>
>> As i mentioned before memcached is already installed. I am using
>> innodb_memcache.containers to implement memcached as a plugin.
>>
>> netstat -plnt | grep 9999
>>
>> tcp        0      0 127.0.0.1:9999              0.0.0.0:*
>>     LISTEN      18421/mysqld
>>
>>
>> Everything looks fine i have full transparency, data provided by
>> memcached CLI (telnet) are seen inside innodb table and vise versa.
>>
>> I am using the latest 2.2.2 git opensips rel. and memcached module loaded:
>>
>> loadmodule "cachedb_memcached.so"
>>
>> modparam("cachedb_memcached", "cachedb_url","memcached:default:
>> //localhost:9999,127.0.0.1/")
>>
>> The script i am using is just the basic one, without any additional
>> configuration.
>> Inside the script there is following operation provided:
>>
>> cache_fetch("memcached:default","$tU",$avp(i:601));
>>
>> Innodb table contains following data:
>>
>> +-------------+-------------+------+------+------+
>>
>> | id          | num         | c3   | c4   | c5   |
>>
>> +-------------+-------------+------+------+------+
>>
>> | 49121112233 | 49121112233 |    0 |    3 |    0 |
>>
>> | 49221112233 | 49221112233 |    0 |    1 |    0 |
>>
>> | 49221112234 | 49221112234 |    0 |    2 |    0 |
>>
>> +-------------+-------------+------+------+------+
>>
>> Now, i am sending INVITE with tU = 49121112233 and getting proper
>> behavior which means:
>> - no error inside the opensips.log, xlog following cache_fetch returns
>> correct $avp(i:601)
>> - mysqld.log shows
>>
>> <95 get 49121112233
>>
>> >95 sending key 49121112233
>>
>> >95 END
>>
>> but really strange is that calling tU = 49221112233 is causing quite
>> opposite results:
>> - following error is shown
>>
>> DBG:core:cachedb_fetch: from script [memcached] - with grp [default]
>>
>> ERROR:cachedb_memcached:wrap_memcached_get: Failed to get: SYSTEM ERROR
>>
>> - no mysqld debug is produced
>>
>>
>> The last one example(tU = 49221112234)is failing with the same error.
>>
>>
>> Memcached is loaded with all those data
>>
>> Connected to localhost.
>>
>> Escape character is '^]'.
>>
>> get 49221112233
>>
>> VALUE 49221112233 0 11
>>
>> 49221112233
>>
>> END
>>
>> get 49221112234
>>
>> VALUE 49221112234 0 11
>>
>> 49221112234
>>
>> END
>>
>>
>> but because of some reasons memcached module is not utilized.
>> As aforementioned, opensips script does not have any $rU filtering setup,
>> so should query for any data it is asked for.
>> Maybe i am wrong with some of my assumptions or the way memcached is
>> configured, so kindly help me to understand where the problem is located.
>>
>> Thanks
>> Maciej.
>>
>>
>>
>>
>>
>>
>>
>> 2016-11-15 18:09 GMT+01:00 Bogdan-Andrei Iancu <bogdan at opensips.org>:
>>
>>> OK, thank you for the update Maciej,
>>>
>>> Best regards,
>>>
>>> Bogdan-Andrei Iancu
>>> OpenSIPS Founder and Developerhttp://www.opensips-solutions.com
>>>
>>> On 15.11.2016 18:28, Maciej Bylica wrote:
>>>
>>> Hi Bogdan,
>>> Thanks for reply.
>>> Right, Opensips module was not the source of the problem.
>>> I've managed to solve the issue, memcache is working fine.
>>> Thanks
>>> Maciej.
>>> 2016-11-10 12:56 GMT+01:00 Bogdan-Andrei Iancu <bogdan at opensips.org>:
>>>>
>>>> Hi Maciej, As I see, you are manually compiling and installing the
>>>> memcached stuff - any special reason for doing that ? (versus using
>>>> packages) As the problem seems to be in the lib, not in the OpenSIPS
>>>> module. Regards,
>>>>
>>>> Bogdan-Andrei Iancu
>>>> OpenSIPS Founder and Developerhttp://www.opensips-solutions.com
>>>>
>>>> On 09.11.2016 18:41, Maciej Bylica wrote:
>>>>
>>>> Hello I am struggling with memcached installation with the latest git
>>>> opensips 2.2.2 and centos 6.8 Here are version releases i am using:
>>>> libmemcached-1.0.18 (./configure, make && make install) memcached-1.4.33
>>>> (./configure, make && make install) with LD_LIBRARY_PATH=/usr/local/lib:$LD_LIBRARY_PATH
>>>> memcached -d -u nobody -m 1048 -p 9999 127.0.0.1 does not produce any error
>>>> but what is really puzzling me during the opensips start is the error
>>>> below: DBG:core:load_module: loading module /usr/local/lib64/opensips/modules/cachedb_memcached.so
>>>> ERROR:core:sr_load_module: could not open module
>>>> </usr/local/lib64/opensips/modules/cachedb_memcached.so>:
>>>> /usr/local/lib/libmemcached.so.11: undefined symbol: pthread_once Can
>>>> someone please guide me how to put memcached up and running ?
>>>> Opensips is compiled with cachedb_memcached module.
>>>> Thanks in advance.
>>>> Maciej
>>>>
>>>> _______________________________________________
>>>> Users mailing listUsers at lists.opensips.orghttp://lists.opensips.org/cgi-bin/mailman/listinfo/users
>>>>
>>>>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.opensips.org/pipermail/users/attachments/20161121/401388d1/attachment-0001.htm>