Bug #47345 Active-transactions.lua is missing resultset_is_needed = true
Submitted: 16 Sep 2009 2:14 Modified: 7 Dec 2009 9:09
Reporter: Diego Medina Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Proxy: Scripts Severity:S3 (Non-critical)
Version:0.8.0 OS:Any
Assigned to: Jan Kneschke CPU Architecture:Any

[16 Sep 2009 2: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 2009 14: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 2009 15:23] Enterprise Tools JIRA Robot
Diego Medina writes: 
Verified fixed on 0.8.0
[7 Dec 2009 9:09] MC Brown
An entry has been added to the 0.8.0 changelog: 

The supplied script <filename>active-transactions.lua</filename> had not been updated to use the new <literal>resultset_is_needed</literal> flag.