Bug #42636 mysql proxy crash with Segmentation fault when using Lua script
Submitted: 6 Feb 2009 1:39 Modified: 21 Mar 2009 9:16
Reporter: jenny chen Email Updates:
Status: No Feedback Impact on me:
None 
Category:MySQL Proxy: Core Severity:S2 (Serious)
Version:0.7.0 OS:Solaris
Assigned to: CPU Architecture:Any

[6 Feb 2009 1:39] jenny chen
Description:
MySQL proxy core dump with segmentation fault when running a simple query to the World database and use lua script to distribute the query to the two mysql instances

How to repeat:
The proxy src was downloaded at:
https://launchpad.net/mysql-proxy ("trunk" series)
1. Start the mysql proxy using the command:
LUA_PATH="/mysql-proxy/share/mysql-proxy/?.lua"
export LUA_PATH
/mysql-proxy/bin/mysql-proxy --proxy-address=10.2.3.3:3306 --proxy-backend-addresses=10.2.3.3:3307 --proxy-backend-addresses=10.2.3.3:3308 --proxy-lua-script=/mysql-proxy/share/mysql-proxy/sql.lua

2. run mysqlslap to connect the mysql-proxy executing the query to the world database:
mysqlslap --concurrency=10 --host=10.2.3.3 --port=3306 --create-schema=world --query='/*mysql1 */select * FROM City' --password='abc' --number-of-queries=2000

3. the mysql-proxy crash with Segmentation fault. And I'm attaching the stack trace of the proxy during the crash, and the "sql.lua" used in the test
[6 Feb 2009 1:41] jenny chen
stack trace of proxy

Attachment: pstack.core (application/octet-stream, text), 1.83 KiB.

[14 Feb 2009 11:02] Sveta Smirnova
Thank you for the report.

I can not repeat described behavior neither on Solaris 10 nor on OpenSolaris. Please indicate accurate version of Solaris you run and revision of MySQL Proxy bug is repeatable with.
[17 Feb 2009 19:30] jenny chen
The OS version is: Solaris Express Community Edition snv_96 SPARC
[22 Mar 2009 0: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".