mysql.err file
In the 4.0.10 version I found a new computername.err file instead the old lod named mysql.err . This feature is a new standard or there is a way to continue to named it to mysql.err ? Regards - Massimo Petrini c/o Omt spa Via Ferrero 67/a 10090 Cascine Vica (TO) Tel.+39 011 9505334 Fax +39 011 9575474 E-mail [EMAIL PROTECTED] - 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
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 491384454154;; 3: len 10; hex 20202038333233303738; asc8323078;; 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; asc9188492;; 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
Re: PLEASE SEE THE MYSQL.ERR FILE ATTACHED
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 491384454154;; 3: len 10; hex 20202038333233303738; asc8323078;; 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; asc9188492;; 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
How to flush text to mysql.err file?
When I get a MySQL error, the error message is only partially written to MySQL.Err file (on WIn2k). If I call the MySQL.Err text file up in an editor window, only half of the error message is visible. I tried MySLAdmin flush-logs but that didn't help. How do I get the entire error message displayed? The only way I can do this is to shut down the MySQL server or get more errors until the buffer writes the previous error message. Brent - 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