RE: Weird Error message
Rhino, thanks for taking the time to look at this I'm running on Redhat 7.3 on a HP DL380 G3, Mysql 4.0.14 I've noticed it in the mysql.err log. My guess is that it's a query to one of our Search result tables -Original Message- From: Rhino [mailto:[EMAIL PROTECTED] Sent: Thursday, April 01, 2004 1:16 PM To: Jason Chuong; [EMAIL PROTECTED] Subject: Re: Weird Error message It would really help if you could tell us at least which version of MySQL you are using. It might also help to know which OS you are using and what command you issued to get this error message. Rhino - Original Message - From: Jason Chuong [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, April 01, 2004 12:40 PM Subject: Weird Error message Hi All, has anyone seen this error message before 040331 0:26:00 ft_read_next: Got error 127 when reading table ./ 040331 0:26:38 ft_read_next: Got error 127 when reading table ./ 040401 0:23:10 ft_read_first: Got error 127 when reading table ./ 040401 0:23:19 ft_read_next: Got error 127 when reading table ./ 040401 0:23:27 ft_read_next: Got error 127 when reading table ./ 040401 0:25:21 ft_read_next: Got error 127 when reading table ./ 040401 0:27:16 ft_read_next: Got error 127 when reading table ./ I did a check table command and the table came up fine. No clue ??? Thank you for your assistant -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Weird Error message
Hi All, has anyone seen this error message before 040331 0:26:00 ft_read_next: Got error 127 when reading table ./ 040331 0:26:38 ft_read_next: Got error 127 when reading table ./ 040401 0:23:10 ft_read_first: Got error 127 when reading table ./ 040401 0:23:19 ft_read_next: Got error 127 when reading table ./ 040401 0:23:27 ft_read_next: Got error 127 when reading table ./ 040401 0:25:21 ft_read_next: Got error 127 when reading table ./ 040401 0:27:16 ft_read_next: Got error 127 when reading table ./ I did a check table command and the table came up fine. No clue ??? Thank you for your assistant -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Weird Error message
It would really help if you could tell us at least which version of MySQL you are using. It might also help to know which OS you are using and what command you issued to get this error message. Rhino - Original Message - From: Jason Chuong [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, April 01, 2004 12:40 PM Subject: Weird Error message Hi All, has anyone seen this error message before 040331 0:26:00 ft_read_next: Got error 127 when reading table ./ 040331 0:26:38 ft_read_next: Got error 127 when reading table ./ 040401 0:23:10 ft_read_first: Got error 127 when reading table ./ 040401 0:23:19 ft_read_next: Got error 127 when reading table ./ 040401 0:23:27 ft_read_next: Got error 127 when reading table ./ 040401 0:25:21 ft_read_next: Got error 127 when reading table ./ 040401 0:27:16 ft_read_next: Got error 127 when reading table ./ I did a check table command and the table came up fine. No clue ??? Thank you for your assistant -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Weird error message
Hi, I am getting a weird error message in mysql. I am doing this query SELECT t0.sid, t1.stid, t0.clubname, t1.longheadline FROM club t0, story t1 WHERE t0.sid = t1.siteid AND t1.hold='no' AND t0.test = 0 AND t1.synd = '1' AND t0.sport='football' ORDER BY `stid` DESC LIMIT 10; and I am getting this error message ERROR 1030: Got error 28 from table handler I have figured out that it is t0.test that is causeing the problem as when i remove it the query works. This query has been working fine for months and we haven't done anything to the tables used. I have tried explain, check and analyse and everything seems normal. Any clues? Cheers John Wards SportNetwork.net - 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
Re: Weird error message
Yup I used repair table as well. Also I have resarted mysql and that made no difference John - Original Message - From: Karthik [EMAIL PROTECTED] To: John Wards [EMAIL PROTECTED] Sent: Thursday, September 05, 2002 11:11 AM Subject: Re: Weird error message Hi, Try using this command in mysql check table table name if any of them return a error message run repair table table name Karthik. - Original Message - From: John Wards [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, September 05, 2002 3:35 PM Subject: Weird error message Hi, I am getting a weird error message in mysql. I am doing this query SELECT t0.sid, t1.stid, t0.clubname, t1.longheadline FROM club t0, story t1 WHERE t0.sid = t1.siteid AND t1.hold='no' AND t0.test = 0 AND t1.synd = '1' AND t0.sport='football' ORDER BY `stid` DESC LIMIT 10; and I am getting this error message ERROR 1030: Got error 28 from table handler I have figured out that it is t0.test that is causeing the problem as when i remove it the query works. This query has been working fine for months and we haven't done anything to the tables used. I have tried explain, check and analyse and everything seems normal. Any clues? Cheers John Wards SportNetwork.net - 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
Re: Weird error message
John, and I am getting this error message ERROR 1030: Got error 28 from table handler # perror 28 Error code 28: No space left on device Free some disk space! I have figured out that it is t0.test that is causeing the problem as when i remove it the query works. This query has been working fine for months and we haven't done anything to the tables used. I have tried explain, check and analyse and everything seems normal. I guess that when you add the t0.test that it needs to use a temporary table for sorting or something like that - but there's not enough space on your disk. Chris - 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
Re: Weird error message
perror 28 No space left on device. I guess your disk is getting full. John Wards wrote: Hi, I am getting a weird error message in mysql. I am doing this query SELECT t0.sid, t1.stid, t0.clubname, t1.longheadline FROM club t0, story t1 WHERE t0.sid = t1.siteid AND t1.hold='no' AND t0.test = 0 AND t1.synd = '1' AND t0.sport='football' ORDER BY `stid` DESC LIMIT 10; and I am getting this error message ERROR 1030: Got error 28 from table handler I have figured out that it is t0.test that is causeing the problem as when i remove it the query works. This query has been working fine for months and we haven't done anything to the tables used. I have tried explain, check and analyse and everything seems normal. Any clues? Cheers John Wards SportNetwork.net - 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