Comment 5 for bug 522242

Revision history for this message
Callum Guy (callum-guy) wrote :

I have been trying to get these functions working all week to limited success. I've been starting over with a fresh install of Centos 5.4 i386, MySQL 5.1.45 and also testing with PHP 5.3.2. As suggested i have tried to limit the versions to libmemcached-0.31/libmemcached-devel-0.31/memcached_functions_mysql-0.8 however this only enabled me to create the UDFs but not to use them. Once installed at this version i can get some return from the functions, but simply get disconnected as follows:

mysql> SELECT memc_servers_set('192.168.4.211:11211');
+-----------------------------------------+
| memc_servers_set('192.168.4.211:11211') |
+-----------------------------------------+
| 0 |
+-----------------------------------------+
1 row in set (0.00 sec)

mysql> SELECT memc_set('mykey', 'Getting this with SELECT means all works well');
ERROR 2013 (HY000): Lost connection to MySQL server during query

Oddly enough this error was not consistent and on some occasions i can do the following before it fails:

mysql> SELECT memc_set('mykey', 'Getting this with SELECT means all works well');
+--------------------------------------------------------------------+
| memc_set('mykey', 'Getting this with SELECT means all works well') |
+--------------------------------------------------------------------+
| 20 |
+--------------------------------------------------------------------+
1 row in set (0.00 sec)

mysql> SELECT memc_get('mykey');
+-------------------+
| memc_get('mykey') |
+-------------------+
| NULL |
+-------------------+
1 row in set (0.00 sec)

I have a complete list of the packages installed along the way and the few config steps required to get to this stage if anyone is interested in reviewing the setup. I am really struggling to progress and since updating to UDFs 1.1 and libmemcached 0.38 i am now unable to use the functions at all. Please let me know if there is anything i can try to resolve these issues or provide further debug at this stage. Many thanks