memcached service stoped unexpectedly
Posted by:
deepak m
Date: March 27, 2012 10:56PM
hi
i am working with mysql cluster 7.2.4 with memcached 1.6
i started memcached service with ndb-caching option as shown below
memcached -E /usr/local/mysql/lib/ndb_engine.so -e "connectstring=10.12.200.117:1186;role=ndb-caching;debug=true" -vv -c 20 -u root
mysql> SELECT * FROM memcache_server_roles where role_name='ndb-caching';
+-------------+---------+---------+---------------------+
| role_name | role_id | max_tps | update_timestamp |
+-------------+---------+---------+---------------------+
| ndb-caching | 3 | 100000 | 2012-03-21 17:53:45 |
+-------------+---------+---------+---------------------+
with role id 3
mysql> SELECT * FROM key_prefixes where server_role_id=3;
+----------------+------------+------------+---------+-------------+
| server_role_id | key_prefix | cluster_id | policy | container |
+----------------+------------+------------+---------+-------------+
| 3 | b: | 0 | caching | demo_ext |
| 3 | t: | 0 | caching | demo_tabs |
| 3 | | 0 | caching | demo_table |
| 3 | d: | 0 | caching | deepak_new |
| 3 | dee: | 0 | caching | deepak_new1 |
+----------------+------------+------------+---------+-------------+
i just looked into demo_tabs container
mysql> SELECT * FROM containers where name='demo_tabs';
+-----------+-------------+-----------------+-------------+----------------+-------+------------------+------------+--------------------+--------------------+
| name | db_schema | db_table | key_columns | value_columns | flags | increment_column | cas_column | expire_time_column | large_values_table |
+-----------+-------------+-----------------+-------------+----------------+-------+------------------+------------+--------------------+--------------------+
| demo_tabs | ndbmemcache | demo_table_tabs | mkey | val1,val2,val3 | flags | NULL | NULL | expire_time | NULL |
+-----------+-------------+-----------------+-------------+----------------+-------+------------------+------------+--------------------+--------------------+
now i saw the contents in the ndbmemcache.demo_table_tabs table
select * from ndbmemcache.demo_table_tabs;
mysql> select * from ndbmemcache.demo_table_tabs;
+------+--------------+------+------+-------+-------------+
| mkey | val1 | val2 | val3 | flags | expire_time |
+------+--------------+------+------+-------+-------------+
| 2 | abcdefghijlk | NULL | NULL | NULL | NULL |
+------+--------------+------+------+-------+-------------+
i expect for the key t:2 values abcdefghijlk
but this value is not there in cache its there only in database
but still i run get t:2 in telnet the connection closes unexpectedly
like
[root@cent2 ~]# telnet localhost 11211
Trying 127.0.0.1...
Connected to localhost.localdomain (127.0.0.1).
Escape character is '^]'.
get t:2
Connection closed by foreign host.
[root@cent2 ~]#
in memcached service stoped with error message
[root@cent2 ~]#memcached -E /usr/local/mysql/lib/ndb_engine.so -e "connectstring=10.12.200.117:1186;role=ndb-caching;debug=true" -vv -c 20 -u root
..........................
..........................
worker.1 schedule():1.0 placed on send queue.
cl0.conn1.send run_ndb_send_thread():Sent 1.0
cl0.conn1.poll run_ndb_poll_thread(): ** adding 1.0 to wait group **
cl0.conn1.poll run_ndb_poll_thread():Polling 1.0
cl0.conn1.poll callback_main():Success.
cl0.conn1.poll worker_finalize_read():1.0
cl0.conn1.poll --> build_hash_item()
cl0.conn1.poll build_hash_item():nbytes: 21 ncopied: 16
Segmentation fault
[root@cent2 ~]#
can any one tell me why this service closeing unexpectedly
thanks in adv
Deepak M
Subject
Views
Written By
Posted
memcached service stoped unexpectedly
4712
March 27, 2012 10:56PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.