Re: Problems getting mysql-proxy working from SVN trunk.

[Gerry Reno]

Ok, so I try this basically verbatim from the rw tutorial page:

[root@grp-01-60-50 trunk]# export LUA_PATH='lib/?.lua'; ./src/mysql-proxy --daemon --proxy-lua-script=lib/rw-splitting.lua --proxy-address=127.0.0.1:4040 --proxy-backend-addresses=192.168.1.245:3306 --proxy-read-only-backend-addresses=192.168.1.246:3306
[root@grp-01-60-50 trunk]# ps -ef | grep proxy
root 22636 1 0 11:54 ? 00:00:00 /root/build/mysql-proxy/trunk/src/.libs/lt-mysql-proxy --daemon --proxy-lua-script=lib/rw-splitting.lua --proxy-address=127.0.0.1:4040 --proxy-backend-addresses=192.168.1.245:3306 --proxy-read-only-backend-addresses=192.168.1.246:3306

[root@grp-01-60-50 trunk]#
[root@grp-01-60-50 trunk]# mysql -h 127.0.0.1 -P 4040 -u root -p
Enter password:
ERROR 2013 (HY000): Lost connection to MySQL server at 'reading initial communication packet', system error: 0
[root@grp-01-60-50 trunk]#

mysql-proxy segfaults.

UPDATE: here's an strace:
epoll_wait(3, {}, 1023, 1000) = 0
gettimeofday({1208536341, 610780}, NULL) = 0
gettimeofday({1208536341, 611320}, NULL) = 0
gettimeofday({1208536341, 611626}, NULL) = 0
gettimeofday({1208536341, 611925}, NULL) = 0
epoll_wait(3, {{EPOLLIN, {u32=135811920, u64=135811920}}}, 1023, 1000) = 1
gettimeofday({1208536342, 115342}, NULL) = 0
accept(7, {sa_family=AF_INET, sin_port=htons(46134), sin_addr=inet_addr("127.0.0.1")}, [16]) = 8
fcntl64(8, F_SETFL, O_RDWR|O_NONBLOCK) = 0
gettimeofday({1208536342, 117810}, NULL) = 0
stat64("lib/rw-splitting.lua", 0xbfbd1fe8) = -1 ENOENT (No such file or directory)
open("lib/rw-splitting.lua", O_RDONLY|O_LARGEFILE) = -1 ENOENT (No such file or directory)
--- SIGSEGV (Segmentation fault) @ 0 (0) ---
Process 22992 detached



????

Gerry



Edited 1 time(s). Last edit at 04/18/2008 10:34AM by Gerry Reno.