Hello ! I recent migrate from 3.23 to 4.0.5 version and in my server , i set the Default table type to InnoDB. it works as well, but my temporary tables crashes mysqlserver on truncate command, the logdump is:
----- start here mysqld got signal 11; This could be because you hit a bug. It is also possible that this binary or one of the libraries it was linked against is corrupt, improperly built, or misconfigured. This error can also be caused by malfunctioning hardware. We will try our best to scrape up some info that will hopefully help diagnose the problem, but since we have already crashed, something is definitely wrong and this may fail. key_buffer_size=67104768 read_buffer_size=1044480 sort_buffer_size=2097144 max_used_connections=3 max_connections=100 threads_connected=3 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_connections = 372331 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. thd=0x86a95f8 Attempting backtrace. You can use the following information to find out where mysqld died. If you see no messages after this, something went terribly wrong... Cannot determine thread, fp=0xbe3fe8d8, backtrace may not be correct. Stack range sanity check OK, backtrace follows: 0x80d5109 0x40034f54 0x819019f 0x8134021 0x812c7cc 0x810e730 0x80e1ed2 0x80e3d45 0x80df438 0x80e5191 0x80de6de 0x400320ba 0x401bad6a New value of fp=(nil) failed sanity check, terminating stack trace! Please read http://www.mysql.com/doc/U/s/Using_stack_trace.html and follow instructions on how to resolve the stack trace. Resolved stack trace is much more helpful in diagnosing the problem, so please do resolve it Trying to get some variables. Some pointers may be invalid and cause the dump to abort... thd->query at 0x8690c18 = truncate table contratante_78B73C2E thd->thread_id=6 Successfully dumped variables, if you ran with --log, take a look at the details of what thread 6 did to cause the crash. In some cases of really bad corruption, the values shown above may be invalid. The manual page at http://www.mysql.com/doc/C/r/Crashing.html contains information that should help you find out what is causing the crash. Number of processes running now: 0 021119 10:04:13 mysqld restarted -------- cut After this the InnoDB restart in recovery mode and mysql running normal. The table contratante_78B73C2E is a temporary table created with InnoDB type. The command used to create contratante_78B73C2E is: create temporary table contratante_78B73C2E select * from other_table Type = InnoDB; My System Is: Debian GNU/Linux 3.0 with kernel 2.4.19 MySQL+InnoDB 4.0.5 ReiserFS Tnks for attenction... sql,query ------------------------------------------------------------------------- ++ Dyego Souza do Carmo ++ Dep. Desenvolvimento ------------------------------------------------------------------------- E S C R I B A I N F O R M A T I C A ------------------------------------------------------------------------- The only stupid question is the unasked one (somewhere in Linux's HowTo) Linux registred user : #230601 -- $ look into "my eyes" look: cannot open my eyes ------------------------------------------------------------------------- Reply: [EMAIL PROTECTED] --------------------------------------------------------------------- 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