List:General Discussion« Previous MessageNext Message »
From:Michael Widenius Date:October 12 1999 10:07am
Subject:Segmentation fault when OPTIMIZE TABLE
View as plain text  
>>>>> "sawat" == sawat  <sawat@stripped> writes:

>> Description:
sawat>    When I do 'OPTIMIZE TABLE book', the mysqld daemon exits and 
sawat> it reports on the console as following.
sawat> -=*****=-
sawat>   bin/safe_mysqld: line 149:   603 Segmentation fault      nohup $ledir/mysqld
> --basedir=$MY_BASEDIR_VERSION --datadir=$DATADIR --skip-locking >>$err_log
> 2>&1
sawat> mysqld daemon ended
sawat> -=*****=-
sawat>      It's also core-dumped when I try to use 'isamchk -v -o book'.
sawat> -=*****=-
sawat> - recovering ISAM-table 'book.ISM'
sawat> Data records: 306
sawat> Segmentation fault (core dumped)
sawat> -=*****=-

sawat>    I have also tested on the mysqld precompiled version 3.22.25 
sawat> (mysql-3.22.25-pc-linux-gnu-i686.tar.gz) but can't produce them there.

Hi!

Thanks for the table dump!

Fix:

(/my/monty/sql-3.22) diff -c /my/monty/master/mysql-3.22.26a/sql/sql_parse.cc .
*** /my/monty/master/mysql-3.22.26a/sql/sql_parse.cc    Mon Aug 30 04:15:31 1999
--- ./sql_parse.cc      Tue Oct 12 13:02:26 1999
***************
*** 778,783 ****
--- 778,784 ----
      lex->col_list.empty();
      lex->drop_list.empty();
      lex->alter_list.empty();
+     lex->password=0;
      res= mysql_alter_table(thd, NullS, NullS, tables, lex->create_list,
                           lex->key_list, lex->drop_list, lex->alter_list,
                           0,DUP_ERROR);

Could you test if the above works for you (it did for me)

Regards,
Monty
Thread
Segmentation fault when OPTIMIZE TABLEsawat8 Oct
  • Segmentation fault when OPTIMIZE TABLEMichael Widenius12 Oct