Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

"Didn't find any fields in table" Error

Posted on 2004-11-19
6
Medium Priority
?
737 Views
Last Modified: 2012-06-21
Hi there,

Can anyone help to explain an error message I got when I logged into my MYSQL server.

I received hundreds of messages "Didn't find any fields in table 'tablename'."

Restarting mysql solved this, but I'd really like to know what the problem was.

Can anyone shed any light on this.

Thanks,

John

0
Comment
Question by:jjbarnsley
5 Comments
 
LVL 33

Expert Comment

by:snoyes_jw
ID: 12667453
"This message is issued by the mysql client program when it connects to a database and finds an incorrectly defined table."

Looks like it could have been a corrupt file, but more likely incorrect OS-level file permissions.  Why it worked the second time around I don't know; did you change users?
0
 
LVL 2

Expert Comment

by:kryptic0329
ID: 12691475
Most likely, you had a problem with one of mysql's internet databases, that store program settings and users. (Database mysql)

This file was probably corrupted / missing in the OS, thus causing the message to occur over and over as mysql tried to read its settings.
0
 

Author Comment

by:jjbarnsley
ID: 13054508
The problem was a result of  wait_timeout in my.cnf.   I changed this and resolved immediately resolved the problem without any recurrence.
0
 
LVL 2

Expert Comment

by:kryptic0329
ID: 13174280
Good to hear. MySQL config can be a bugger sometimes. ;D
0
 

Accepted Solution

by:
modulo earned 0 total points
ID: 14248151
PAQed with points refunded (500)

modulo
Community Support Moderator
0

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction This article is intended for those who are new to PHP error handling (https://www.experts-exchange.com/articles/11769/And-by-the-way-I-am-New-to-PHP.html).  It addresses one of the most common problems that plague beginning PHP develop…
Backups and Disaster RecoveryIn this post, we’ll look at strategies for backups and disaster recovery.
In this video, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment. To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…
In this video, Percona Solutions Engineer Barrett Chambers discusses some of the basic syntax differences between MySQL and MongoDB. To learn more check out our webinar on MongoDB administration for MySQL DBA: https://www.percona.com/resources/we…
Suggested Courses
Course of the Month21 days, 4 hours left to enroll

810 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question