LinuxQuestions.org
View the Most Wanted LQ Wiki articles.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Server
User Name
Password
Linux - Server This forum is for the discussion of Linux Software used in a server related context.

Notices

Reply
 
LinkBack Search this Thread
Old 06-18-2010, 09:50 PM   #1
edenCC
Member
 
Registered: May 2006
Location: Gz,China
Distribution: RH,FB
Posts: 196
Blog Entries: 1

Rep: Reputation: 32
Strange database issue table doesn't exist [error code: 1146]


Hi, List,
Recently I got a very rare database issue, it says:
  • Error: Couldn't read status information for table clients_copy ()
  • mysqldump: Couldn't execute 'show create table `clients_copy`': Table 'adm_retail.clients_copy' doesn't exist (1146)
  • Error: Couldn't read status information for table dt_mx_emp ()
  • mysqldump: Couldn't execute 'show create table `dt_mx_emp`': Table 'adm_retail.dt_mx_emp' doesn't exist (1146)
  • Error: Couldn't read status information for table materialized_views ()
  • mysqldump: Couldn't execute 'show create table `materialized_views`': Table 'adm_retail.materialized_views' doesn't exist (1146)
  • Error: Couldn't read status information for table adm_data_mo ()
  • mysqldump: Couldn't execute 'show create table `adm_data_mo`': Table 'adm_retail.adm_data_mo' doesn't exist (1146)
  • Error: Couldn't read status information for table temp ()
  • mysqldump: Couldn't execute 'show create table `temp`': Table 'adm_retail.temp' doesn't exist (1146)
  • Error: Couldn't read status information for table area ()
Actually all these tables are existed, but no matter what I did on them like check and repair, mysql says doesn't exist, I've tried the following ways to fix it:
1, restart the database
2, check the myisam table status, all looks fine, but the innodb ones are messing.
3, google around - got no luck

Anyone here can give me a hand please? Appreciated for any input as it's really an urgent issue
 
Old 06-19-2010, 12:27 AM   #2
paulsm4
Guru
 
Registered: Mar 2004
Distribution: SusE 8.2
Posts: 5,863
Blog Entries: 1

Rep: Reputation: Disabled
Q: Can you:

a) log on to "mysql adm_retail"
b) run "show tables;"
... and...
c) do you actually see that tables "clients_copy", "dt_mx_emp", etc all exist, and belong to database "adm_retail"?

If you answer "no" to any of these questions, then that's the problem!

'Hope that helps .. PSM
 
Old 06-20-2010, 12:29 AM   #3
edenCC
Member
 
Registered: May 2006
Location: Gz,China
Distribution: RH,FB
Posts: 196
Blog Entries: 1

Original Poster
Rep: Reputation: 32
Hi,paulsm4,

Yes, they're actually existed.

I'm suspecting there might be something wrong with innodb meta data, but dont know how to check it.
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
can't initialize iptables table `filter': Table does not exist... sodek Linux - Software 3 05-07-2012 02:54 AM
I can't remove mythtv-database. Error code 10. glore2002 Debian 1 10-18-2009 04:24 PM
Strange GCC compile error with C code exvor Programming 16 08-23-2005 06:05 PM
Strange error in C code zaichik Programming 2 02-08-2005 05:21 PM
Strange error reffering partition table and swap Thetargos Linux - General 1 06-19-2003 10:59 AM


All times are GMT -5. The time now is 03:03 AM.

Main Menu
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
identi.ca: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration