Re: MySQL-Max database recovery crashed - Fixed!

2001-11-03 Thread Michael Widenius
Hi! > "Heikki" == Heikki Tuuri <[EMAIL PROTECTED]> writes: >> I will have to include a warning in the comments section of the MySQL >> documentation to NOT CONVERT MySQL SYSTEM TABLES FROM myISAM TO INNODB TYPE! I have now added a warning about this to the manual. Regards, Monty

Re: MySQL-Max database recovery crashed

2001-11-02 Thread Heikki Tuuri
Jeremy, At 11:37 PM 11/2/01 -0800, you wrote: >On Fri, Nov 02, 2001 at 11:17:37PM +0200, Heikki Tuuri wrote: >> >> I looked now what MySQL does when it calls lock_external at startup: >> it initializes MySQL system tables like 'host' and 'user'. I assume >> you have not converted MySQL system ta

Re: MySQL-Max database recovery crashed

2001-11-02 Thread Jeremy Zawodny
On Fri, Nov 02, 2001 at 11:17:37PM +0200, Heikki Tuuri wrote: > > I looked now what MySQL does when it calls lock_external at startup: > it initializes MySQL system tables like 'host' and 'user'. I assume > you have not converted MySQL system tables to InnoDB format? That is > not allowed. They

Re: MySQL-Max database recovery crashed - Fixed!

2001-11-02 Thread Stephen Lee
> Stephen, > > At 01:37 PM 11/2/01 -0800, you wrote: >>> Stephen, >>> >>> At 12:38 PM 11/2/01 -0800, you wrote: Heikki, Removal of the log= option and even the log-bin statement did not help. I used the latest (2.23.44) RPMs from one of the mysql.com mirrors. I don't think it'

Re: MySQL-Max database recovery crashed

2001-11-02 Thread Heikki Tuuri
Stephen, At 01:37 PM 11/2/01 -0800, you wrote: >> Stephen, >> >> At 12:38 PM 11/2/01 -0800, you wrote: >>>Heikki, >>> >>>Removal of the log= option and even the log-bin statement did not help. >>>I used the latest (2.23.44) RPMs from one of the mysql.com mirrors. I >>>don't think it's a download

Re: MySQL-Max database recovery crashed

2001-11-02 Thread Stephen Lee
> Stephen, > > At 12:38 PM 11/2/01 -0800, you wrote: >>Heikki, >> >>Removal of the log= option and even the log-bin statement did not help. >>I used the latest (2.23.44) RPMs from one of the mysql.com mirrors. I >>don't think it's a download issue because the problem originally >>occured with the

Re: MySQL-Max database recovery crashed

2001-11-02 Thread Heikki Tuuri
Stephen, At 12:38 PM 11/2/01 -0800, you wrote: >Heikki, > >Removal of the log= option and even the log-bin statement did not help. I >used the latest (2.23.44) RPMs from one of the mysql.com mirrors. I don't >think it's a download issue because the problem originally occured with the >2.23.43 dis

Re: MySQL-Max database recovery crashed

2001-11-02 Thread Stephen Lee
Heikki, Removal of the log= option and even the log-bin statement did not help. I used the latest (2.23.44) RPMs from one of the mysql.com mirrors. I don't think it's a download issue because the problem originally occured with the 2.23.43 distribution. The crash occurs within seconds of startin

Re: MySQL-Max database recovery crashed

2001-11-02 Thread Heikki Tuuri
Stephen, I resolved now with the mysql-max-3.23.44...tar.gz distribution. I still do not understand what mysqld is trying to do here. What distribution do you use, or did you compile yourself? 0x807b90f handle_segfault__Fi + 383 0x8253c7a pthread_sighandler + 106 0x80cf21a change_active_index__1

Re: MySQL-Max database recovery crashed

2001-11-02 Thread Stephen Lee
> Stephen, > > I resolved the stack dump based on the 3.23.43 symbols file. I do not > understand what mysqld is trying to do here. Are you sure the stack > dump is from 3.23.43? > > 0x807b90f init_signals__Fv + 71 > 0x8253c7a __tfx + 26 > 0x80cf21a index_prev__11ha_innobasePc + 74 > 0x8078693 mys

Re: MySQL-Max database recovery crashed

2001-11-02 Thread Heikki Tuuri
Stephen, I resolved the stack dump based on the 3.23.43 symbols file. I do not understand what mysqld is trying to do here. Are you sure the stack dump is from 3.23.43? 0x807b90f init_signals__Fv + 71 0x8253c7a __tfx + 26 0x80cf21a index_prev__11ha_innobasePc + 74 0x8078693 mysql_lock_remove__FP