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 <[email protected]>: > 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 <[email protected]>: > >> 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 <[email protected]>: >> >>> 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 <[email protected]>: >>>> >>>> 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 >>>> [email protected]http://lists.opensips.org/cgi-bin/mailman/listinfo/users >>>> >>>> >
_______________________________________________ Users mailing list [email protected] http://lists.opensips.org/cgi-bin/mailman/listinfo/users
