From: Andrew Morgan
Date: November 22 2012 8:07am
Subject: RE: memcached big values save but return empty result
List-Archive: http://lists.mysql.com/cluster/8433
Message-Id: <67eabfde-6ad2-4c1a-923e-bde7d9a9a052@default>
MIME-Version: 1.0
Content-Type: multipart/alternative;
 boundary="__1353571665148136276abhmt105.oracle.com"

--__1353571665148136276abhmt105.oracle.com
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: quoted-printable

Hi Boris,

=20

Could you please try adding '-e "debug=3Dtrue"' when starting memcached in =
order to see if it provides some more useful information?

=20

Regards, Andrew.

=20

From: Boris Timokhin [mailto:mathete.com@stripped]=20
Sent: 20 November 2012 08:43
To: Andrew Morgan
Cc: cluster@stripped
Subject: Re: memcached big values save but return empty result

=20

Hi, Andrew,

=20

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-clus=
ter/scalabale-persistent-ha-nosql-memcache-storage-using-mysql-cluster/ and=
 "Getting started for Linux"





2012/11/20 Andrew Morgan <HYPERLINK "mailto:andrew.morgan@stripped"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 <HYPERLINK "mailto:mathete.com@gma=
il.com"mathete.com@stripped> wrote:

> Hello!
>
> I try set "big" value as memcaced client. I use prefix 'b:' and happy wit=
h
> 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=3D49, part=3D0 and content=3D 'abcdabcda=
bcd...'
> */
>
> 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!

=20

--__1353571665148136276abhmt105.oracle.com--