From: Boris Timokhin
Date: November 20 2012 8:43am
Subject: Re: memcached big values save but return empty result
List-Archive: http://lists.mysql.com/cluster/8430
Message-Id: <CAEMqxoVKhXEeJBwPRKg16m-Y=GhMPXJ63u7TBeRm3wnHCkoCNg@mail.gmail.com>
MIME-Version: 1.0
Content-Type: multipart/alternative; boundary=bcaec5396d16c012b104cee939f5

--bcaec5396d16c012b104cee939f5
Content-Type: text/plain; charset=ISO-8859-1

Hi, Andrew,

I`m using unpacked mysql-cluster-gpl-7.2.8-linux2.6-i686.tar.gz.
Setup based on your very good article -
http://www.clusterdb.com/mysql-cluster/scalabale-persistent-ha-nosql-memcache-storage-using-mysql-cluster/
and
"Getting started for Linux"



2012/11/20 Andrew Morgan <andrew.morgan@stripped>

> Hi Boris,
>
>  We'll look into this. What versions of MySQL Cluster are you using?
>
> Thanks, Andrew.
>
>
>
>
> On 18 Nov 2012, at 23:41, Boris Timokhin <mathete.com@stripped> wrote:
>
> > Hello!
> >
> > I try set "big" value as memcaced client. I use prefix 'b:' and happy
> with
> > small value. And can save big value and can see its in `external_values`
> > table. But `get my_key` return empty result.
> >
> > My actions:
> > 1. In a begining empty tables:
> >
> > mysql> SELECT * FROM ndbmemcache.demo_table_large;
> > Empty set (0.01 sec)
> >
> > mysql> SELECT * FROM ndbmemcache.external_values;
> > Empty set (0.02 sec)
> >
> > 2. Set small value - 'abcd':
> >
> > In memcached logs:
> > <49 set b:my_key 0 0 4
> > 49: going from conn_parse_cmd to conn_nread
> > 49 - Running task: (conn_nread)
> > 49 - Running task: (conn_nread)
> > Got notify from 49, status 0
> >> 49 STORED
> >
> > Mysql client:
> > mysql> SELECT * FROM ndbmemcache.demo_table_large;
> > +--------+-----------------+--------------+--------+----------+
> > | mkey   | cas_value       | string_value | ext_id | ext_size |
> > +--------+-----------------+--------------+--------+----------+
> > | my_key | 680130351464502 | abcd         |   NULL |     NULL |
> > +--------+-----------------+--------------+--------+----------+
> > 1 row in set (0.01 sec)
> >
> > 3. Set big value - 'abcd' * 1000 (4000 characters ):
> >
> > In memchached logs:
> > <49 set b:my_key 0 0 4000
> > 49: going from conn_parse_cmd to conn_nread
> > 49 - Running task: (conn_nread)
> > 49 - Running task: (conn_nread)
> > Got notify from 49, status 0
> >> 49 STORED
> >
> > Mysql client:
> > mysql> SELECT * FROM ndbmemcache.demo_table_large;
> > +--------+-----------------+--------------+--------+----------+
> > | mkey   | cas_value       | string_value | ext_id | ext_size |
> > +--------+-----------------+--------------+--------+----------+
> > | my_key | 680130351464507 | NULL         |     49 |     4000 |
> > +--------+-----------------+--------------+--------+----------+
> > 1 row in set (0.00 sec)
> >
> > We see correct size and link to external_value
> >
> > mysql> SELECT * FROM ndbmemcache.external_values;
> >
> > /* There are one big row with id=49, part=0 and content=
> 'abcdabcdabcd...'
> > */
> >
> > Perfect! But...
> >
> > 4. $ telnet localhost 11211
> > Trying 127.0.0.1...
> > Connected to localhost.
> > Escape character is '^]'.
> > get b:my_key
> > VALUE b:my_key 0 0
> >
> > END
> >
> > In memcached logs:
> >
> > <47 get b:my_key
> > Got notify from 47, status 0
> > <47 get b:my_key
> >> 47 sending key b:my_key
> >
> >> 47 END
> >
> >
> > It`s bug or I do something wrong?
> >
> > Thank you!
>

--bcaec5396d16c012b104cee939f5--