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

[14 Feb 2006 23:01] Peter Gulutzan
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
[15 Feb 2006 0:21] MySQL Verification Team
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>
[15 Mar 2006 17:22] Bugs System
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
[16 Mar 2006 10:50] Bugs System
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
[16 Mar 2006 22:15] Konstantin Osipov
Fixed in 5.1.8
[17 Mar 2006 8:26] Jon Stephens
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.