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

Reply via email to