List:General Discussion« Previous MessageNext Message »
From:BAUMEISTER Alexandre Date:April 25 2001 4:40pm
Subject:TEMPORARY + InnoDB + select coun(*) + Bye = mysqld crash with signal 11.
View as plain text  

  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.


Possible bug with InnoDB tableTianlin Wang24 Apr
Re:Possible bug with InnoDB tableHeikki Tuuri25 Apr
  • TEMPORARY + InnoDB + select coun(*) + Bye = mysqld crash with signal 11.BAUMEISTER Alexandre25 Apr
Re: TEMPORARY + InnoDB + select coun(*) + Bye = mysqld crashwith signal 11.Heikki Tuuri25 Apr