Hello.


Make a bug or feature report at http://bugs.mysql.com.





Josh Trutwin <[EMAIL PROTECTED]> wrote:

> Would it be possible to add:

> 

> ENGINE=MyISAM 

> 

> To all the CREATE TABLE statements in the mysql_fix_privilege_tables

> script?  The server (tested with 5.0.3 and 5.0.4) crashes when

> creating/altering these tables if the following is in /etc/my.cnf: 

> 

> default-table-type=innodb

> 

> I had to drop all the new tables and added ENGINE=MyISAM to the CREATE

> TABLE statements, re-ran the script and it worked fine.

> 

> Here is an example crash report:

> 

> 050422  9:19:43InnoDB: Assertion failure in thread 245771 in file

> ../include/data0type.ic line 466

> InnoDB: Failing assertion: type->len % type->mbmaxlen == 0

> InnoDB: We intentionally generate a memory trap.

> InnoDB: Submit a detailed bug report to http://bugs.mysql.com.

> InnoDB: If you get repeated assertion failures or crashes, even

> InnoDB: immediately after the mysqld startup, there may be

> InnoDB: corruption in the InnoDB tablespace. Please refer to

> InnoDB: http://dev.mysql.com/doc/mysql/en/Forcing_recovery.html

> InnoDB: about forcing recovery.

> 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=8388600

> read_buffer_size=131072

> max_used_connections=1

> max_connections=100

> threads_connected=1

> It is possible that mysqld could use up to 

> key_buffer_size + (read_buffer_size +

> sort_buffer_size)*max_connections = 225791 K

> bytes of memory

> Hope that's ok; if not, decrease some variables in the equation.

> 

> thd=0x8ab7a70

> 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=0xbe5f3938, backtrace may not be correct.

> Stack range sanity check OK, backtrace follows:

> 0x8180bef

> 0xb7e48c85

> 0x8295abc

> 0x829492a

> 0x829286c

> 0x82af069

> 0x82ae30c

> 0x82c5f99

> 0x823754f

> 0x8233119

> 0x8227b3f

> 0x8210552

> 0x823cb76

> 0x823f164

> 0x8196522

> 0x819d604

> 0x8194278

> 0x8193d85

> 0x8193192

> 0xb7e4354e

> 0xb7d71b8a

> New value of fp=(nil) failed sanity check, terminating stack trace!

> Please read http://dev.mysql.com/doc/mysql/en/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 0x8ae2ae0 = ALTER TABLE time_zone

>  MODIFY Use_leap_seconds enum('Y','N') COLLATE utf8_general_ci

> DEFAULT 'N' NOT NULL

> thd->thread_id=6

> The manual page at http://www.mysql.com/doc/en/Crashing.html contains

> information that should help you find out what is causing the crash.

> 

> Number of processes running now: 0

> 

> 

> Josh

> 

> 

> 

> 



-- 
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.NET http://www.ensita.net/
   __  ___     ___ ____  __
  /  |/  /_ __/ __/ __ \/ /    Gleb Paharenko
 / /|_/ / // /\ \/ /_/ / /__   [EMAIL PROTECTED]
/_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.NET
       <___/   www.mysql.com




-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to