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

[Maciej Bylica]

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/73a96da2/attachment.htm>