| Bug #74085 | CREATE TEMPORARY INNODB TABLE crashes server | ||
|---|---|---|---|
| Submitted: | 25 Sep 2014 18:47 | Modified: | 7 Nov 2014 21:39 |
| Reporter: | Filipe Martins | Email Updates: | |
| Status: | No Feedback | Impact on me: | |
| Category: | MySQL Server | Severity: | S2 (Serious) |
| Version: | 5.6.21 | OS: | Windows (x64) |
| Assigned to: | CPU Architecture: | Any | |
[25 Sep 2014 18:47]
Filipe Martins
[25 Sep 2014 21:30]
MySQL Verification Team
Thank you for the bug report.
Enter password: ******
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 3
Server version: 5.6.21 MySQL Community Server (GPL)
Copyright (c) 2000, 2014, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql> USE d
Database changed
mysql> DELIMITER ##
mysql> CREATE PROCEDURE teste_break_innodb()
-> BEGIN
-> CREATE TEMPORARY TABLE xxx ENGINE=InnoDB SELECT 1;
-> END ##
Query OK, 0 rows affected (0.01 sec)
mysql> CALL teste_break_innodb##
Query OK, 1 row affected (0.23 sec)
Your test case:
END
CALL teste_break_innodb
##
[25 Sep 2014 21:41]
MySQL Verification Team
Forgot to paste:
mysql> DROP PROCEDURE IF EXISTS teste_break_innodb##
Query OK, 0 rows affected (0.00 sec)
mysql> CREATE PROCEDURE teste_break_innodb()
-> BEGIN
-> CREATE TEMPORARY TABLE xxx ENGINE=InnoDB SELECT 1;
-> END
-> CALL teste_break_innodb
-> ##
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to use near 'CALL
teste_break_innodb' at line 5
mysql>
[26 Sep 2014 20:14]
Filipe Martins
@Miguel Solorzano There's an error in my SQL. It should be: DELIMITER ## DROP PROCEDURE IF EXISTS teste_break_innodb; CREATE PROCEDURE teste_break_innodb() BEGIN CREATE TEMPORARY TABLE xxx ENGINE=InnoDB SELECT 1; END; ## CALL teste_break_innodb
[30 Sep 2014 14:05]
MySQL Verification Team
Thank you for the feedback. I couldn't repeat. Is your installation an upgrade or fresh one?.
Enter password: ******
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 5
Server version: 5.6.21-log MySQL Community Server (GPL)
Copyright (c) 2000, 2014, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql> CREATE DATABASE d;
Query OK, 1 row affected (0.00 sec)
mysql> USE d
Database changed
mysql> DELIMITER ##
mysql>
mysql> DROP PROCEDURE IF EXISTS teste_break_innodb;
-> CREATE PROCEDURE teste_break_innodb()
-> BEGIN
->
-> CREATE TEMPORARY TABLE xxx
-> ENGINE=InnoDB
-> SELECT 1;
->
-> END;
-> ##
Query OK, 0 rows affected, 1 warning (0.00 sec)
Query OK, 0 rows affected (0.00 sec)
mysql> CALL teste_break_innodb##
Query OK, 1 row affected (0.17 sec)
[30 Sep 2014 16:38]
Filipe Martins
Miguel, and what about if you try just this: CREATE TEMPORARY TABLE xxx ENGINE=InnoDB SELECT 1; I was using an existing installation when I found the problem and upgraded to 5.6.21 to see if it keep occurring. I tried with a new installation and got the same problem. If you come to wonder about my config, it only has the following idiosyncrasies: sql-mode="ANSI,STRICT_ALL_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION" explicit_defaults_for_timestamp=1 lower_case_table_names=0 I can post the entire file, if needed.
[7 Oct 2014 21:39]
MySQL Verification Team
Please provide your my.ini file and have you tried a fresh install?. Still I can't repeat. Thanks.
[8 Nov 2014 1: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".
