Bug #29524 Run a delete query against a table that causes the error below
Submitted: 3 Jul 2007 16:12 Modified: 9 Aug 2007 11:20
Reporter: Edward McLain Email Updates:
Status: No Feedback Impact on me:
None 
Category:MySQL Proxy: Core Severity:S2 (Serious)
Version:0.5.1 OS:Linux (CentOS 4.5)
Assigned to: Assigned Account CPU Architecture:Any

[3 Jul 2007 16:12] Edward McLain
Description:
Table Structure:
CREATE TABLE `serverStats` (
  `subnet` varchar(11) NOT NULL default '',
  `concount` int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (`subnet`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

MySQL Servers: 5.0.27-max x 2

Startup options: 
/usr/local/sbin/mysql-proxy --proxy-address=0.0.0.0:3306 ( along with 2 --proxy-backend-addresses )

Query:
delete from `serverStats`

Table serverStats is populated beforehand with around 131,000 rows.  The query goes through on the server and records are deleted but mysql-proxy dies with the following error:

file network-mysqld-proto.c: line 99 (network_mysqld_proto_get_int_len): assertion failed: (*_off + size <= packet->len)

I have also seen this same error 1 other time though I cannot re-create the scenario.  This scenario is repeatable.

How to repeat:
Create table, insert mass data, issue a delete from `serverStats`; query.
[9 Jul 2007 11:20] Sveta Smirnova
Thank you for the report.

I can not repeat described behaviour.

Please try with current MySQL 5.0.41 server and say us result.
[9 Aug 2007 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".