Willie, what MySQL version you are running? On what OS?
What does SHOW CREATE TABLE tabdocumentoconsultado; print? Have you used an InnoDB version <= 3.23.43 and stored characters with code > 127 in the table? E.g., accent characters? The ordering of such characters in the latin1 charset changed in 3.23.44. What kind of operations you did to the table? INSERT, UPDATE, DELETE? Can you repeat the corruption starting from a fresh table? You can repair the corruption by dump + DROP + CREATE + import of the table. Regards, Heikki Innobase Oy ................. List: mysql Subject: InnoDB: a detailed bug report From: "Willie D. Leiva" <[EMAIL PROTECTED]> Date: 2002-12-04 9:36:24 MySQL generated the following error messages about a corrupted table: /------------ 021127 15:48:01 InnoDB: Started InnoDB: error in sec index entry update in InnoDB: index umDoc table bdatena/tabdocumentoconsultado InnoDB: tuple 0: len 8; hex 6c616e6472616465; asc landrade;; 1: len 4; hex 8000000b; asc ....;; 2: len 4; hex 80000014; asc ....;; 3: len 8; hex 800012358ca4940c; asc ...5....;; 4: len 1; hex 02; asc .;; 5: len 8; hex 800012358ca4d9c4; asc ...5..Ù.;; 6: len 1; hex 02; asc .;; 7: len 8; hex 800012358ca4d9c4; asc ...5..Ù.;; 8: len 1; hex 01; asc .;; 9: len 4; hex 8000002b; asc ...+;; InnoDB: record RECORD: info bits 0 0: len 8; hex 6c616e6472616465; asc landrade;; 1: len 4; hex 8000000b; asc ....;; 2: len 4; hex 80000014; asc ....;; 3: len 8; hex 800012358ca4940c; asc ...5....;; 4: len 1; hex 02; asc .;; 5: len 8; hex 800012358ca4d9c4; asc ...5..Ù.;; 6: len 1; hex 02; asc .;; 7: len 8; hex 800012358ca49424; asc ...5...$;; 8: len 1; hex 01; asc .;; 9: len 4; hex 8000002b; asc ...+;; TRANSACTION 0 672018, ACTIVE 0 sec, OS thread id 2532 updating or deleting 3 lock struct(s), heap size 320, undo log entries 1 MySQL thread id 75, query id 17086 localhost 127.0.0.1 atena updating UPDATE tabdocumentoconsultado SET EmPausa='N' WHERE IdAprendiz='landrade' AND Tipo='Top' AND codcurso='11' AND IdP='20' --------------------------------------------------------------------- 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
