MySQL Bugs: #17403: Events: packets out of order with show create event

Bug #17403	Events: packets out of order with show create event
Submitted:	14 Feb 2006 23:01	Modified:	17 Mar 2006 8:26
Reporter:	Peter Gulutzan	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Server: Stored Routines	Severity:	S3 (Non-critical)
Version:	5.1.7-beta-debug	OS:	Linux (SUSE 10.0)
Assigned to:	Konstantin Osipov	CPU Architecture:	Any

Description:
I create a trigger which has SHOW CREATE EVENT in it.
I insert, which activates the trigger. The SHOW happens.
I insert again. I get a "Packets out of order" error.

How to repeat:
mysql> create event ek on schedule every 1 year do set @a = 5;
Query OK, 1 row affected (0.00 sec)

mysql> create table tk (s1 int);
Query OK, 0 rows affected (0.01 sec)

mysql> create trigger tk_ai after insert on tk for each row show create event ek;
Query OK, 0 rows affected (0.00 sec)

mysql> insert into tk values (0);
+-------+----------+--------------------------------------------------------------------------------------------------+
| Event | sql_mode | Create Event                                                                                     |
+-------+----------+--------------------------------------------------------------------------------------------------+
| ek    |          | CREATE EVENT `db1`.`ek` ON SCHEDULE EVERY 1 YEAR ON COMPLETION NOT PRESERVE ENABLE DO set @a = 5 |
+-------+----------+--------------------------------------------------------------------------------------------------+
1 row in set (0.00 sec)

mysql> insert into tk values (0);
Packets out of order (Found: 8, expected 1)
ERROR 2013 (HY000): Lost connection to MySQL server during query

Thank you for the bug report.

miguel@hegel:~/dbs/5.1> bin/mysql -uroot
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 1 to server version: 5.1.7-beta-debug

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> create database db3;
Query OK, 1 row affected (0.04 sec)

mysql> use db3
Database changed
mysql> create event ek on schedule every 1 year do set @a = 5;
Query OK, 1 row affected (0.02 sec)

mysql> create table tk (s1 int);
Query OK, 0 rows affected (0.00 sec)

mysql> create trigger tk_ai after insert on tk for each row show create event
    -> ek;
Query OK, 0 rows affected (0.01 sec)

mysql>  insert into tk values (0);
+-------+----------+--------------------------------------------------------------------------------------------------+
| Event | sql_mode | Create Event                                                                                     |
+-------+----------+--------------------------------------------------------------------------------------------------+
| ek    |          | CREATE EVENT `db3`.`ek` ON SCHEDULE EVERY 1 YEAR ON COMPLETION NOT PRESERVE ENABLE DO set @a = 5 |
+-------+----------+--------------------------------------------------------------------------------------------------+
1 row in set (0.01 sec)

mysql>  insert into tk values (0);
Packets out of order (Found: 8, expected 1)
ERROR 2013 (HY000): Lost connection to MySQL server during query
mysql>

A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/3866

A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/3886

Fixed in 5.1.8

Thank you for your bug report. This issue has been committed to our
source repository of that product and will be incorporated into the
next release.

If necessary, you can access the source repository and build the latest
available version, including the bugfix, yourself. More information 
about accessing the source trees is available at
    http://www.mysql.com/doc/en/Installing_source_tree.html

Additional info:

Documented bugfix in 5.1.8 changelog. Closed.