Cesar, looks like the indexes of some of your tables are corrupt.
Did you upgrade from a version < 4.0.1 to 4.0.1 lately? The sorting order of accent characters changed in October 2001, which might cause the problem. If you run CHECK TABLE on tables docmserv, relmrela, repmkt, what does it print to the the error log mysql.err? You can repair these tables by dump + drop + reimport, but I would like to see first what CHECK TABLE prints. Regards, Heikki Tuuri Innobase Oy ----- Original Message ----- From: ""Cesar Andrade"" <[EMAIL PROTECTED]> Newsgroups: mailing.database.mysql Sent: Tuesday, June 04, 2002 4:36 PM Subject: PLEASE SEE THE MYSQL.ERR FILE ATTACHED > Good Morning, > > Please see into file mysql.err look the InnoDB errors. > > We are working with 4.0.1-alpha-max-nt-log versiσn under operating system > Windows 2000 advance Server. Our database have about 13GB of disk. > > Thank you for your help. > > We are waiting for your solutions or comments. > > > Best regards, > > > AVIATUR TEAM. > > MySql: preparado para conexiones > 020530 17:58:17 MySql: Apagado normal > > 020530 17:58:18 MySql: Forzando a cerrar el thread 1 usuario: 'root' > > MySql: preparado para conexiones > InnoDB: error in sec index entry update in > InnoDB: index AESTADO table estadistica/docmserv > InnoDB: tuple 0: len 2; hex 5045; asc PE;; 1: len 2; hex 4342; asc CB;; 2: > len 16; hex 34393133383430303030343534313534; asc 4913840000454154;; 3: len > 10; hex 20202038333233303738; asc 8323078;; 4: len 3; hex 303530; asc > 050;; 5: len 3; hex 303031; asc 001;; 6: len 2; hex 2031; asc 1;; > InnoDB: record RECORD: info bits 0 0: len 2; hex 5045; asc PE;; 1: len 2; > hex 4342; asc CB;; 2: len 16; hex 34393133363239363030313138303939; asc > 4913629600118099;; 3: len 10; hex 20202039313838343932; asc 9188492;; 4: > len 3; hex 303130; asc 010;; 5: len 3; hex 303031; asc 001;; 6: len 2; hex > 2031; asc 1;; > InnoDB: Make a detailed bug report and send it > InnoDB: to [EMAIL PROTECTED] > TRANSACTION 0 1199700, OS thread id 2792 updating or deleting, active, runs > or sleeps, has 97 lock struct(s), undo log entries 162 > MySQL thread id 9, query id 8416 cluster1 172.30.26.8 root > LOAD DATA LOCAL INFILE "D:/estadistica/planos/DOCMSERV_MYSQL1020.TXT" > REPLACE INTO TABLE DOCMSERV > InnoDB: error in sec index entry update in > InnoDB: index KEY_NITFEC table estadistica/relmrela > InnoDB: tuple 0: len 16; hex 20202020202020202020202020757364; asc > usd;; 1: len 3; hex 8fa4b6; asc ..;; 2: len 2; hex 2031; asc 1;; 3: len 2; > hex 5654; asc VT;; > InnoDB: record RECORD: info bits 0 0: len 16; hex > 20202020202020202020202020555344; asc USD;; 1: len 3; hex > 8fa489; asc .?;; 2: len 2; hex 4731; asc G1;; 3: len 2; hex 5654; asc VT;; > InnoDB: Make a detailed bug report and send it > InnoDB: to [EMAIL PROTECTED] > InnoDB: error in sec index entry update in > InnoDB: index KEY_FECHA table estadistica/relmrela > InnoDB: tuple 0: len 3; hex 8fa4b6; asc ..;; 1: len 16; hex > 20202020202020202020202020757364; asc usd;; 2: len 2; hex 2031; > asc 1;; 3: len 2; hex 5654; asc VT;; > InnoDB: record RECORD: info bits 0 0: len 3; hex 8fa4b6; asc ..;; 1: len > 16; hex 20202020202020202020202020205646; asc VF;; 2: len 2; > hex 4931; asc I1;; 3: len 2; hex 5654; asc VT;; > InnoDB: Make a detailed bug report and send it > InnoDB: to [EMAIL PROTECTED] > InnoDB: error in sec index entry update in > InnoDB: index KEY_TIPFEC table estadistica/relmrela > InnoDB: tuple 0: len 2; hex 5654; asc VT;; 1: len 3; hex 8fa4b6; asc ..;; > 2: len 16; hex 20202020202020202020202020757364; asc usd;; 3: > len 2; hex 2031; asc 1;; > InnoDB: record RECORD: info bits 0 0: len 2; hex 5654; asc VT;; 1: len 3; > hex 8fa4b6; asc ..;; 2: len 16; hex 20202020202020202020202020205646; asc > VF;; 3: len 2; hex 4931; asc I1;; > InnoDB: Make a detailed bug report and send it > InnoDB: to [EMAIL PROTECTED] > TRANSACTION 0 1199812, OS thread id 2792 updating or deleting, active, runs > or sleeps, has 7 lock struct(s), undo log entries 673 > MySQL thread id 9, query id 8596 cluster1 172.30.26.8 root > LOAD DATA LOCAL INFILE "D:/estadistica/planos/RELMRELA_MYSQL.TXT" REPLACE > INTO TABLE RELMRELA > TRANSACTION 0 1199812, OS thread id 2792 updating or deleting, active, runs > or sleeps, has 7 lock struct(s), undo log entries 673 > MySQL thread id 9, query id 8596 cluster1 172.30.26.8 root > LOAD DATA LOCAL INFILE "D:/estadistica/planos/RELMRELA_MYSQL.TXT" REPLACE > INTO TABLE RELMRELA > TRANSACTION 0 1199812, OS thread id 2792 updating or deleting, active, runs > or sleeps, has 7 lock struct(s), undo log entries 673 > MySQL thread id 9, query id 8596 cluster1 172.30.26.8 root > LOAD DATA LOCAL INFILE "D:/estadistica/planos/RELMRELA_MYSQL.TXT" REPLACE > INTO TABLE RELMRELA > InnoDB: error in sec index entry update in > InnoDB: index KEY_NITFEC table estadistica/relmrela > InnoDB: tuple 0: len 16; hex 20202020202020203433303237313436; asc > 43027146;; 1: len 3; hex 8fa48f; asc .;; 2: len 2; hex 4531; asc E1;; 3: > len 2; hex 5654; asc VT;; > InnoDB: record RECORD: info bits 0 0: len 16; hex > 20202020202020203433303237313336; asc 43027136;; 1: len 3; hex > 8fa327; asc .';; 2: len 2; hex 2031; asc 1;; 3: len 2; hex 5654; asc VT;; > InnoDB: Make a detailed bug report and send it > InnoDB: to [EMAIL PROTECTED] > InnoDB: error in sec index entry update in > InnoDB: index KEY_FECHA table estadistica/relmrela > InnoDB: tuple 0: len 3; hex 8fa48f; asc .;; 1: len 16; hex > 20202020202020203433303237313436; asc 43027146;; 2: len 2; hex 4531; > asc E1;; 3: len 2; hex 5654; asc VT;; > InnoDB: record RECORD: info bits 0 0: len 3; hex 8fa48f; asc .;; 1: len > 16; hex 20202020202020203432393737303130; asc 42977010;; 2: len 2; > hex 4531; asc E1;; 3: len 2; hex 5654; asc VT;; > InnoDB: Make a detailed bug report and send it > InnoDB: to [EMAIL PROTECTED] > InnoDB: error in sec index entry update in > InnoDB: index KEY_TIPFEC table estadistica/relmrela > InnoDB: tuple 0: len 2; hex 5654; asc VT;; 1: len 3; hex 8fa48f; asc .;; > 2: len 16; hex 20202020202020203433303237313436; asc 43027146;; 3: > len 2; hex 4531; asc E1;; > InnoDB: record RECORD: info bits 0 0: len 2; hex 5654; asc VT;; 1: len 3; > hex 8fa48f; asc .;; 2: len 16; hex 20202020202020203432393737303130; asc > 42977010;; 3: len 2; hex 4531; asc E1;; > InnoDB: Make a detailed bug report and send it > InnoDB: to [EMAIL PROTECTED] > TRANSACTION 0 1199812, OS thread id 2792 updating or deleting, active, runs > or sleeps, has 1397 lock struct(s), undo log entries 222953 > MySQL thread id 9, query id 8596 cluster1 172.30.26.8 root > LOAD DATA LOCAL INFILE "D:/estadistica/planos/RELMRELA_MYSQL.TXT" REPLACE > INTO TABLE RELMRELA > TRANSACTION 0 1199812, OS thread id 2792 updating or deleting, active, runs > or sleeps, has 1397 lock struct(s), undo log entries 222953 > MySQL thread id 9, query id 8596 cluster1 172.30.26.8 root > LOAD DATA LOCAL INFILE "D:/estadistica/planos/RELMRELA_MYSQL.TXT" REPLACE > INTO TABLE RELMRELA > TRANSACTION 0 1199812, OS thread id 2792 updating or deleting, active, runs > or sleeps, has 1397 lock struct(s), undo log entries 222953 > MySQL thread id 9, query id 8596 cluster1 172.30.26.8 root > LOAD DATA LOCAL INFILE "D:/estadistica/planos/RELMRELA_MYSQL.TXT" REPLACE > INTO TABLE RELMRELA > InnoDB: error in sec index entry update in > InnoDB: index INDEX04 table estadistica/repmtkt > InnoDB: tuple 0: len 6; hex 323030323230; asc 200220;; 1: len 12; hex > 202020203736393738323135; asc 76978215;; 2: len 1; hex 49; asc I;; 3: > len 2; hex 3939; asc 99;; 4: len 1; hex 34; asc 4;; 5: len 15; hex > 202020202033353734333331323939; asc 3574331299;; 6: len 2; hex 4156; > asc AV;; > InnoDB: record RECORD: info bits 0 0: len 6; hex 323030323230; asc 200220;; > 1: len 12; hex 202020203736393737363131; asc 76977611;; 2: len 1; hex > 4e; asc N;; 3: len 2; hex 3939; asc 99;; 4: len 1; hex 34; asc 4;; 5: len > 15; hex 202020202033353830393438323637; asc 3580948267;; 6: len 2; hex > 5658; asc VX;; > InnoDB: Make a detailed bug report and send it > InnoDB: to [EMAIL PROTECTED] > InnoDB: error in sec index entry update in > InnoDB: index INDEX04 table estadistica/repmtkt > InnoDB: tuple 0: len 6; hex 323030323230; asc 200220;; 1: len 12; hex > 202020203736393738323135; asc 76978215;; 2: len 1; hex 49; asc I;; 3: > len 2; hex 3939; asc 99;; 4: len 1; hex 34; asc 4;; 5: len 15; hex > 202020202033353734333331333030; asc 3574331300;; 6: len 2; hex 4156; > asc AV;; > InnoDB: record RECORD: info bits 0 0: len 6; hex 323030323230; asc 200220;; > 1: len 12; hex 202020203736393737363131; asc 76977611;; 2: len 1; hex > 4e; asc N;; 3: len 2; hex 3939; asc 99;; 4: len 1; hex 34; asc 4;; 5: len > 15; hex 202020202033353830393438323637; asc 3580948267;; 6: len 2; hex > 5658; asc VX;; > InnoDB: Make a detailed bug report and send it > InnoDB: to [EMAIL PROTECTED] > TRANSACTION 0 1199934, OS thread id 2792 updating or deleting, active, runs > or sleeps, has 279 lock struct(s), undo log entries 4974 > MySQL thread id 9, query id 8842 cluster1 172.30.26.8 root > LOAD DATA LOCAL INFILE "D:/estadistica/planos/REPMTKT_MYSQL1002.TXT" REPLACE > INTO TABLE REPMTKT > TRANSACTION 0 1199934, OS thread id 2792 updating or deleting, active, runs > or sleeps, has 279 lock struct(s), undo log entries 4975 > MySQL thread id 9, query id 8842 cluster1 172.30.26.8 root > LOAD DATA LOCAL INFILE "D:/estadistica/planos/REPMTKT_MYSQL1002.TXT" REPLACE > INTO TABLE REPMTKT > > > --------------------------------------------------------------------- > 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 > --------------------------------------------------------------------- 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
