Bug #47345 Active-transactions.lua is missing resultset_is_needed = true
Submitted: 16 Sep 4:14 Modified: 28 Sep 17:23
Reporter: Diego Medina
Status: Documenting
Category:Proxy: Scripts Severity:S3 (Non-critical)
Version:0.8.0 OS:Any
Assigned to: Jan Kneschke Target Version:

[16 Sep 4:14] Diego Medina
Description:
Line 39 on Active-transactions.lua 

	proxy.queries:append(1, packet)

is missing

{resultset_is_needed = true}

otherwise, you get this error:

 (critical) (read_query_result) [string
"/Applications/mysql/enterprise/mysql-proxy-..."]:54: .resultset.raw isn't available if
'resultset_is_needed ~= true'

Whenever you get an error back from the mysqld server.

How to repeat:
1- Start the proxy like this:

$ ./sbin/mysql-proxy  --proxy-backend-addresses=127.0.0.1:5132  
--proxy-lua-script=./share/doc/mysql-proxy/active-transactions.lua 

2- Send this invalid query:

s;
3- Go to the terminal where you started the proxy and you will see the critical error.
[21 Sep 16:57] Jan Kneschke
revno: 845
committer: jan@mysql.com
branch nick: trunk
timestamp: Mon 2009-09-21 16:54:23 +0200
message:
  added { resultset_is_needed = true } (fixes #47345)
[28 Sep 17:23] Enterprise Tools JIRA Robot
Diego Medina writes: 
Verified fixed on 0.8.0