Heikki sent his response to the wrong address... ---------- Forwarded Message ---------- Subject: Re: TEMPORARY + InnoDB + select coun(*) + Bye = mysqld crash Date: 25 Apr 2001 17:18:06 -0000 From: Heikki Tuuri <[EMAIL PROTECTED]> To: [EMAIL PROTECTED] Alex, MySQL obviously tries to drop the table when you exit from the mysql client, since the table is temporary. I have not tested TEMPORARY tables. I just tried on prerelease .38 and it does not work in that version either. I will fix it in .38 if Monty has not yet put out it. Regards, Heikki At 06:40 PM 4/25/01 +0200, you wrote: >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. > > > ------------------------------------------------------- -- MySQL Development Team __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Sasha Pachev <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ /_/ /_/\_, /___/\___\_\___/ Provo, Utah, USA <___/ --------------------------------------------------------------------- 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
