Mysql-3.23.36, Solaris 2.8.
My mysqld crashes when I create a TEMPORARY InnoDB table from the console
if I do a SELECT COUNT(*) before exiting from the console.
No problem with MyISAM tables, no problem with no TEMPORARY table.
mysql> CREATE TEMPORARY TABLE mybuffer ( id int unsigned not null primary key, date
> datetime not null, data text, index id_date (date) ) TYPE=INNOBASE;
Query OK, 0 rows affected (0.04 sec)
mysql> select count(*) from mybuffer;
| count(*) |
| 0 |
1 row in set (0.00 sec)
Then mysql crashes and from the error log :
mysqld got signal 11;
The manual section 'Debugging a MySQL server' tells you how to use a
stack trace and/or the core file to produce a readable backtrace that may
help in finding out why mysqld died.
010425 18:28:29 mysqld restarted
/usr/local/mysql/libexec/mysqld: ready for connections
The signal 11 is received just after the "Bye".
mysqld crashes only if I do a "SELECT count(*) FROM mybuffer" before
exiting from the console (closing the connection).
If I just create the table and exit, no problem. If I create the
table and do for example "desc mybuffer" before exiting, no problem.
But if I create the table, do anything else, then do "SELECT
count(*) FROM mybuffer" before exiting ... mysqld crashes with