<html>
<head>
<meta content="text/html; charset=utf-8" http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
<tt>Hi Maciej,<br>
<br>
Thanks for the detailed report.<br>
<br>
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 ?<br>
<br>
Regards,<br>
</tt>
<pre class="moz-signature" cols="72">Bogdan-Andrei Iancu
OpenSIPS Founder and Developer
<a class="moz-txt-link-freetext" href="http://www.opensips-solutions.com">http://www.opensips-solutions.com</a></pre>
<div class="moz-cite-prefix">On 18.11.2016 19:53, Maciej Bylica
wrote:<br>
</div>
<blockquote
cite="mid:CAEj_GphJrdOi-5f+X-FtLT2dG4-+ozg8uqdxuBMAwSU0ktJnSg@mail.gmail.com"
type="cite">
<div dir="ltr">Hello
<div><br>
</div>
<div>As i mentioned before memcached is already installed. I am
using <span
style="color:rgb(0,0,0);font-family:menlo;font-size:11px">innodb_memcache.containers </span>to
implement memcached as a plugin.</div>
<div>
<p
style="margin:0px;font-size:11px;line-height:normal;font-family:menlo;color:rgb(0,0,0)"><span
style="font-variant-ligatures:no-common-ligatures">netstat
-plnt | grep 9999</span></p>
<p
style="margin:0px;font-size:11px;line-height:normal;font-family:menlo;color:rgb(0,0,0)"><span
style="font-variant-ligatures:no-common-ligatures">tcp
0 0 <a moz-do-not-send="true"
href="http://127.0.0.1:9999">127.0.0.1:9999</a>
0.0.0.0:* LISTEN 18421/mysqld </span></p>
<p
style="margin:0px;font-size:11px;line-height:normal;font-family:menlo;color:rgb(0,0,0)"><span
style="font-variant-ligatures:no-common-ligatures"><br>
</span></p>
</div>
<div>Everything looks fine i have full transparency, data
provided by memcached CLI (telnet) are seen inside innodb
table and vise versa. </div>
<div><br>
</div>
<div>I am using the latest 2.2.2 git opensips rel. and memcached
module loaded:</div>
<div>
<p
style="margin:0px;font-size:11px;line-height:normal;font-family:menlo;color:rgb(0,0,0)"><span
style="font-variant-ligatures:no-common-ligatures">loadmodule
"cachedb_memcached.so"</span></p>
<p
style="margin:0px;font-size:11px;line-height:normal;font-family:menlo;color:rgb(0,0,0)"><span
style="font-variant-ligatures:no-common-ligatures">modparam("cachedb_memcached",
"cachedb_url","memcached:default:</span><span
style="font-variant-ligatures:no-common-ligatures;color:rgb(82,48,225)">//localhost:9999,<a
moz-do-not-send="true" href="http://127.0.0.1/">127.0.0.1/</a>")</span></p>
</div>
<div><br>
</div>
<div>The script i am using is just the basic one, without any
additional configuration.<br>
</div>
<div>Inside the script there is following operation provided:</div>
<div>
<p
style="margin:0px;font-size:11px;line-height:normal;font-family:menlo;color:rgb(0,0,0)"><span
style="font-variant-ligatures:no-common-ligatures">cache_fetch("memcached:default","$tU",$avp(i:601))</span><span
style="font-variant-ligatures:no-common-ligatures;color:rgb(82,48,225)">;</span></p>
</div>
<div><br>
</div>
<div>Innodb table contains following data:</div>
<div>
<p
style="margin:0px;font-size:11px;line-height:normal;font-family:menlo;color:rgb(0,0,0)"><span
style="font-variant-ligatures:no-common-ligatures">+-------------+-------------+------+------+------+</span></p>
<p
style="margin:0px;font-size:11px;line-height:normal;font-family:menlo;color:rgb(0,0,0)"><span
style="font-variant-ligatures:no-common-ligatures">| id
| num | c3 | c4 | c5 |</span></p>
<p
style="margin:0px;font-size:11px;line-height:normal;font-family:menlo;color:rgb(0,0,0)"><span
style="font-variant-ligatures:no-common-ligatures">+-------------+-------------+------+------+------+</span></p>
<p
style="margin:0px;font-size:11px;line-height:normal;font-family:menlo;color:rgb(0,0,0)"><span
style="font-variant-ligatures:no-common-ligatures">|
49121112233 | 49121112233 | 0 | 3 | 0 |</span></p>
<p
style="margin:0px;font-size:11px;line-height:normal;font-family:menlo;color:rgb(0,0,0)"><span
style="font-variant-ligatures:no-common-ligatures">|
49221112233 | 49221112233 | 0 | 1 | 0 |</span></p>
<p
style="margin:0px;font-size:11px;line-height:normal;font-family:menlo;color:rgb(0,0,0)"><span
style="font-variant-ligatures:no-common-ligatures">|
49221112234 | 49221112234 | 0 | 2 | 0 |</span></p>
<p
style="margin:0px;font-size:11px;line-height:normal;font-family:menlo;color:rgb(0,0,0)"><span
style="font-variant-ligatures:no-common-ligatures">+-------------+-------------+------+------+------+</span></p>
</div>
<div><br>
</div>
<div>Now, i am sending INVITE with tU = <span
style="color:rgb(0,0,0);font-family:menlo;font-size:11px">49121112233 </span>and
getting proper behavior which means:</div>
<div>- no error inside the opensips.log, xlog following<font
color="#000000" face="menlo"><span style="font-size:11px"> </span></font><span
style="color:rgb(0,0,0);font-family:menlo;font-size:11px">cache_fetch </span>returns
correct <span
style="color:rgb(0,0,0);font-family:menlo;font-size:11px">$avp(i:601)<br>
</span>- mysqld.log shows</div>
<div>
<p
style="margin:0px;font-size:11px;line-height:normal;font-family:menlo;color:rgb(0,0,0)"><span
style="font-variant-ligatures:no-common-ligatures"><95
get 49121112233 </span></p>
<p
style="margin:0px;font-size:11px;line-height:normal;font-family:menlo;color:rgb(0,0,0)"><span
style="font-variant-ligatures:no-common-ligatures">>95
sending key 49121112233</span></p>
<p
style="margin:0px;font-size:11px;line-height:normal;font-family:menlo;color:rgb(0,0,0)"><span
style="font-variant-ligatures:no-common-ligatures">>95
END</span></p>
</div>
<div><br>
</div>
<div>but really strange is that calling tU = <span
style="color:rgb(0,0,0);font-family:menlo;font-size:11px">49221112233 </span>is
causing quite opposite results:</div>
<div><span
style="color:rgb(0,0,0);font-family:menlo;font-size:11px">- </span>following
error is shown</div>
<div>
<p
style="margin:0px;font-size:11px;line-height:normal;font-family:menlo;color:rgb(0,0,0)"><span
style="font-variant-ligatures:no-common-ligatures">DBG:core:cachedb_fetch:
from script [memcached] - with grp [default]</span></p>
</div>
<div>
<p
style="margin:0px;font-size:11px;line-height:normal;font-family:menlo;color:rgb(0,0,0)"><span
style="font-variant-ligatures:no-common-ligatures">ERROR:cachedb_memcached:wrap_memcached_get:
Failed to get: SYSTEM ERROR</span></p>
<p style="margin:0px;line-height:normal"><span
style="color:rgb(0,0,0);font-family:menlo;font-size:11px;font-variant-ligatures:no-common-ligatures">- </span>no
mysqld debug is produced</p>
<p
style="margin:0px;font-size:11px;line-height:normal;font-family:menlo;color:rgb(0,0,0)"><span
style="font-variant-ligatures:no-common-ligatures"><br>
</span></p>
<p style="margin:0px;line-height:normal">The last one example<font
color="#000000" face="menlo"><span style="font-size:11px">(</span></font><span
style="color:rgb(34,34,34);font-family:arial,sans-serif;font-size:small">tU
= </span><font color="#000000" face="menlo"><span
style="font-size:11px">49221112234)</span></font>is
failing with the same error.</p>
<p style="margin:0px;line-height:normal"><br>
</p>
<p style="margin:0px;line-height:normal">Memcached is loaded
with all those data</p>
<p
style="margin:0px;font-size:11px;line-height:normal;font-family:menlo;color:rgb(0,0,0)"><span
style="font-variant-ligatures:no-common-ligatures">Connected
to localhost.</span></p>
<p
style="margin:0px;font-size:11px;line-height:normal;font-family:menlo;color:rgb(0,0,0)"><span
style="font-variant-ligatures:no-common-ligatures">Escape
character is '^]'.</span></p>
<p
style="margin:0px;font-size:11px;line-height:normal;font-family:menlo;color:rgb(0,0,0)"><span
style="font-variant-ligatures:no-common-ligatures">get
49221112233</span></p>
<p
style="margin:0px;font-size:11px;line-height:normal;font-family:menlo;color:rgb(0,0,0)"><span
style="font-variant-ligatures:no-common-ligatures">VALUE
49221112233 0 11</span></p>
<p
style="margin:0px;font-size:11px;line-height:normal;font-family:menlo;color:rgb(0,0,0)"><span
style="font-variant-ligatures:no-common-ligatures">49221112233</span></p>
<p
style="margin:0px;font-size:11px;line-height:normal;font-family:menlo;color:rgb(0,0,0)"><span
style="font-variant-ligatures:no-common-ligatures">END</span></p>
<p
style="margin:0px;font-size:11px;line-height:normal;font-family:menlo;color:rgb(0,0,0)"><span
style="font-variant-ligatures:no-common-ligatures">get
49221112234</span></p>
<p
style="margin:0px;font-size:11px;line-height:normal;font-family:menlo;color:rgb(0,0,0)"><span
style="font-variant-ligatures:no-common-ligatures">VALUE
49221112234 0 11</span></p>
<p
style="margin:0px;font-size:11px;line-height:normal;font-family:menlo;color:rgb(0,0,0)"><span
style="font-variant-ligatures:no-common-ligatures">49221112234</span></p>
<p style="margin:0px;line-height:normal">
</p>
<p
style="margin:0px;font-size:11px;line-height:normal;font-family:menlo;color:rgb(0,0,0)"><span
style="font-variant-ligatures:no-common-ligatures">END</span></p>
<p
style="margin:0px;font-size:11px;line-height:normal;font-family:menlo;color:rgb(0,0,0)"><span
style="font-variant-ligatures:no-common-ligatures"><br>
</span></p>
but because of some reasons memcached module is not utilized.</div>
<div>As aforementioned, opensips script does not have any $rU
filtering setup, so should query for any data it is asked for.</div>
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.
<div><br>
</div>
<div>Thanks</div>
<div>Maciej.<br>
<div><font color="#000000" face="menlo"><span
style="font-size:11px"><br>
</span></font></div>
<div><br>
</div>
<div>
<p
style="margin:0px;font-size:11px;line-height:normal;font-family:menlo;color:rgb(0,0,0)"><br>
</p>
</div>
<div><br>
</div>
<div><br>
</div>
<div><br>
</div>
</div>
</div>
<div class="gmail_extra"><br>
<div class="gmail_quote">2016-11-15 18:09 GMT+01:00
Bogdan-Andrei Iancu <span dir="ltr"><<a
moz-do-not-send="true" href="mailto:bogdan@opensips.org"
target="_blank">bogdan@opensips.org</a>></span>:<br>
<blockquote class="gmail_quote" style="margin:0 0 0
.8ex;border-left:1px #ccc solid;padding-left:1ex">
<div bgcolor="#FFFFFF" text="#000000"> <tt>OK, thank you
for the update Maciej,<br>
<br>
Best regards,<br>
</tt><span class="">
<pre class="m_-6364319733152202643moz-signature" cols="72">Bogdan-Andrei Iancu
OpenSIPS Founder and Developer
<a moz-do-not-send="true" class="m_-6364319733152202643moz-txt-link-freetext" href="http://www.opensips-solutions.com" target="_blank">http://www.opensips-solutions.<wbr>com</a></pre>
</span><div><div class="h5"><div class="m_-6364319733152202643moz-cite-prefix">On 15.11.2016 18:28, Maciej Bylica
wrote:
</div>
<blockquote type="cite">
<div dir="ltr">Hi Bogdan,
<div>
</div>
<div>Thanks for reply.</div>
<div>Right, Opensips module was not the source of the problem.</div>
<div>I've managed to solve the issue, memcache is working fine.</div>
<div>
</div>
<div>Thanks</div>
<div>Maciej.</div>
</div>
<div class="gmail_extra">
<div class="gmail_quote">2016-11-10 12:56 GMT+01:00
Bogdan-Andrei Iancu <span dir="ltr"><<a moz-do-not-send="true" href="mailto:bogdan@opensips.org" target="_blank">bogdan@opensips.org</a>></span>:
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div bgcolor="#FFFFFF" text="#000000"> <tt>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,
</tt>
<pre class="m_-6364319733152202643m_9202004309374905358moz-signature" cols="72">Bogdan-Andrei Iancu
OpenSIPS Founder and Developer
<a moz-do-not-send="true" class="m_-6364319733152202643m_9202004309374905358moz-txt-link-freetext" href="http://www.opensips-solutions.com" target="_blank">http://www.opensips-solutions.<wbr>com</a></pre><div><div class="m_-6364319733152202643h5">
<div class="m_-6364319733152202643m_9202004309374905358moz-cite-prefix">On 09.11.2016 18:41, Maciej Bylica
wrote:
</div>
</div></div><blockquote type="cite"><div><div class="m_-6364319733152202643h5">
<div dir="ltr">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<wbr>:$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/modu<wbr>les/cachedb_memcached.so
ERROR:core:sr_load_module: could not open module
</usr/local/lib64/opensips/mod<wbr>ules/cachedb_memcached.so>:
/usr/local/lib/libmemcached.so<wbr>.11: undefined symbol:
pthread_once
Can someone please guide me how to put memcached up and running
?
<div>Opensips is compiled with cachedb_memcached module.</div>
<div>
</div>
<div>Thanks in advance.</div>
<div>Maciej</div>
</div>
<fieldset class="m_-6364319733152202643m_9202004309374905358mimeAttachmentHeader"></fieldset>
</div></div><pre>______________________________<wbr>_________________
Users mailing list
<a moz-do-not-send="true" class="m_-6364319733152202643m_9202004309374905358moz-txt-link-abbreviated" href="mailto:Users@lists.opensips.org" target="_blank">Users@lists.opensips.org</a>
<a moz-do-not-send="true" class="m_-6364319733152202643m_9202004309374905358moz-txt-link-freetext" href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users" target="_blank">http://lists.opensips.org/cgi-<wbr>bin/mailman/listinfo/users</a>
</pre>
</blockquote>
</div>
</blockquote></div>
</div>
</blockquote>
</div></div></div></blockquote></div>
</div>
</blockquote>
</body></html>