Heikki,
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)
mysql> Bye
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
Innobase: Started
/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
signal 11.
Regards,
Alex.
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php