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 Developer
http://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 <http://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/
<http://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 followingcache_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]
<mailto:[email protected]>>:
OK, thank you for the update Maciej,
Best regards,
Bogdan-Andrei Iancu
OpenSIPS Founder and Developer
http://www.opensips-solutions.com <http://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] <mailto:[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 Developer
http://www.opensips-solutions.com
<http://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 list
[email protected] <mailto:[email protected]>
http://lists.opensips.org/cgi-bin/mailman/listinfo/users
<http://lists.opensips.org/cgi-bin/mailman/listinfo/users>
_______________________________________________
Users mailing list
[email protected]
http://lists.opensips.org/cgi-bin/mailman/listinfo/users
