Bug #44111 MySQL-proxy + rw-splitting.lua segmentation fault
Submitted: 6 Apr 2009 12:04 Modified: 6 May 2009 15:31
Reporter: Jan De Poorter Email Updates:
Status: No Feedback Impact on me:
None 
Category:MySQL Proxy: Scripts Severity:S1 (Critical)
Version:0.7.0 OS:Linux (Debian etch)
Assigned to: CPU Architecture:Any
Tags: crash, lua, mysql-proxy, segfault

[6 Apr 2009 12:04] Jan De Poorter
Description:
MySQL Proxy segfaults if you run with the rw-splitting lua script and have a TCP connection that is not from a mysql-client. 

How to repeat:
mysql-proxy --proxy-address=:4040 --proxy-backend-addresses=127.0.0.1:3306 --proxy-read-only-backend-addresses=127.0.0.2:3306 --proxy-lua-script=/usr/share/mysql-proxy/rw-splitting.lua 

in another shell:
telnet 127.0.0.1 4040
detach

Transcript Shell 1:
mysql_test2:~# /usr/sbin/mysql-proxy --proxy-address=:4040 --proxy-backend-addresses=127.0.0.1:3306 --proxy-read-only-backend-addresses=10.1.10.121:3306 --proxy-read-only-backend-addresses=127.?0.0.1 --pid-filproxy-lua-script=/usr/share/mysql-proxy/rw-splitting.lua
2009-04-06 14:03:34: (critical) chassis.c:968: could not raise RLIMIT_NOFILE to 8192, Invalid argument (22). Current limit still 13806746816277906432.

[connect_server] 10.1.10.20:50517
  [1].connected_clients = 0
  [1].pool.cur_idle     = 0
  [1].pool.max_idle     = 8
  [1].pool.min_idle     = 4
  [1].type = 1
  [1].state = 0
  [1] idle-conns below min-idle
[disconnect_client] 10.1.10.20:50517
Segmentation fault

Transcript shell 2:
odd:~  $ telnet 10.1.10.122 4040
Trying 10.1.10.122...
Connected to 10.1.10.122.
Escape character is '^]'.
F
5.0.32-Debian_7etch8-log5TL`""';3
                                 -)$yW)a0h>=W^]
telnet> Connection closed.
[6 Apr 2009 15:20] Sveta Smirnova
Thank you for the report.

You said:

Transcript Shell 1:
mysql_test2:~# /usr/sbin/mysql-proxy --proxy-address=:4040
--proxy-backend-addresses=127.0.0.1:3306
--proxy-read-only-backend-addresses=10.1.10.121:3306
--proxy-read-only-backend-addresses=127.?0.0.1
--pid-filproxy-lua-script=/usr/share/mysql-proxy/rw-splitting.lua
2009-04-06 14:03:34: (critical) chassis.c:968: could not raise RLIMIT_NOFILE to 8192,
Invalid argument (22). Current limit still 13806746816277906432.

This contains error in options "--proxy-read-only-backend-addresses=127.?0.0.1
--pid-filproxy-lua-script" Could you please provide correct command you use?
[6 Apr 2009 15:26] Jan De Poorter
Hmz, seems like an error got inthere. Complete command is:

/usr/sbin/mysql-proxy --proxy-address=:4040 --proxy-backend-addresses=127.0.0.1:3306 --proxy-read-only-backend-addresses=10.1.10.121:3306 --proxy-read-only-backend-addresses=127.0.0.1 --pid-fileroxy-lua-script=/usr/share/mysql-proxy/rw-splitting.lua
[6 Apr 2009 15:31] Sveta Smirnova
Thank you for the feedback.

It still contains typo: --pid-fileroxy-lua-script= Please correct.

Also, please, indicate revision which you use.
[6 May 2009 23:00] Bugs System
No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".