Alex, since you are French, I assume you have accent characters in the strings you have stored into your database.
The ordering of accent characters changed in 3.23.44! You must dump and reimport your tables to 3.23.49 so that the index trees are sorted in the right order. Regards, Heikki Innobase Oy -----Original Message----- From: BAUMEISTER Alexandre <[EMAIL PROTECTED]> To: Heikki Tuuri <[EMAIL PROTECTED]>; Michael Widenius <[EMAIL PROTECTED]> Date: Tuesday, March 19, 2002 12:18 PM Subject: Re: InnoDB: Assertion failure in thread 10 in file btr0btr.c line 574 Bonjour, BA> We have Mysql continually crashing with this assertion failure in BA> InnoDB. I have attached to this email and extract from the error log which starts at the origin of the problem. First lines are : 020318 18:24:42 mysqld started InnoDB: Creating foreign key constraint system tables InnoDB: Foreign key constraint system tables created 020318 18:24:45 InnoDB: Started /usr/local/mysql/libexec/mysqld: ready for connections InnoDB: error in sec index entry update in InnoDB: index log table popup/popup InnoDB: tuple 0: len 20; hex 616e647265747469202020202020202020202020; asc andretti ;; 1: len 6; hex 00000004364d; asc ....6M;; InnoDB: record RECORD: info bits 0 0: len 20; hex 616e6472e9737069202020202020202020202020; asc andr.spi ;; 1: len 6; hex 0000000313f0; asc .. ....;; InnoDB: Make a detailed bug report and send it InnoDB: to [EMAIL PROTECTED] TRANSACTION 0 11033371, OS thread id 46058 updating or deleting, active, runs or sleeps, has 600 lock struct(s), undo log entries 1920 MySQL thread id 437808, query id 1064058 localhost root Sending data replace into popup select '9',p.log,'1' from compte.portefeuilles p, compte.contenus_portefeuilles c InnoDB: error in sec index entry update in InnoDB: index log table popup/popup InnoDB: tuple 0: len 20; hex 70736f7564e92020202020202020202020202020; asc psoud. ;; 1: len 6; hex 00000004aadd; asc ....ª.;; InnoDB: record RECORD: info bits 0 0: len 20; hex 70736f7564652020202020202020202020202020; asc psoude ;; 1: len 6; hex 00000003c357; asc .. ...W;; As you can see, I did an upgrade of Mysql on this server yesterday. From 3.23.41 to 3.23.49 . Please see attached file for complete logs. As this server is no more usable we had to stop it, delete all InnoDB files (data+log). We are currently restarting it and recreating databases. Regards, Alex. --------------------------------------------------------------------- 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