List:General Discussion« Previous MessageNext Message »
From:Suporte Avanutri Date:January 24 2012 2:43pm
Subject:RES: Force drop table
View as plain text  
You can see the error report below:

-------------------------------error file---------------------------------
120124 12:23:07  InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB: buffer...
120124 12:23:07  InnoDB: Starting log scan based on checkpoint at
InnoDB: log sequence number 0 175700625.
InnoDB: Doing recovery: scanned up to log sequence number 0 175700625
120124 12:23:08  InnoDB: Started; log sequence number 0 175700625
120124 12:23:08 [Note] MyAvanutri: ready for connections.
Version: '5.0.26-community'  socket: ''  port: 3366  MySQL Community Edition
(GPL)
120124 12:28:26  InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB: buffer...
120124 12:28:26  InnoDB: Starting log scan based on checkpoint at
InnoDB: log sequence number 0 175700625.
InnoDB: Doing recovery: scanned up to log sequence number 0 175700625
120124 12:28:26  InnoDB: Started; log sequence number 0 175700625
120124 12:28:26 [Note] MyAvanutri: ready for connections.
Version: '5.0.26-community'  socket: ''  port: 3366  MySQL Community Edition
(GPL)
120124 12:29:28  InnoDB: Error: table `avanutri/obras` does not exist in the
InnoDB internal
InnoDB: data dictionary though MySQL is trying to drop it.
InnoDB: Have you copied the .frm file of the table to the
InnoDB: MySQL database directory from another database?
InnoDB: You can look for further help from
InnoDB: http://dev.mysql.com/doc/refman/5.0/en/innodb-troubleshooting.html
120124 12:32:06120124 12:32:06 [ERROR] Cannot find table avanutri/obras from
the internal data dictionary
of InnoDB though the .frm file for the table exists. Maybe you
have deleted and recreated InnoDB data files but have forgotten
to delete the corresponding .frm files of InnoDB tables, or you
have moved .frm files to another database?
See http://dev.mysql.com/doc/refman/5.0/en/innodb-troubleshooting.html
how you can resolve the problem.

120124 12:32:06120124 12:32:06 [ERROR] Cannot find table avanutri/obras from
the internal data dictionary
of InnoDB though the .frm file for the table exists. Maybe you
have deleted and recreated InnoDB data files but have forgotten
to delete the corresponding .frm files of InnoDB tables, or you
have moved .frm files to another database?
See http://dev.mysql.com/doc/refman/5.0/en/innodb-troubleshooting.html
how you can resolve the problem.
---------------------------------------end of error
file----------------------------------------

Despite the error, mysql does shows "obras" as a table in the database. But
when I try to drop it, I receive an ERROR 1051 (42S02): UNKOWN TABLE
"obras".

I've tried mysqldump with "force" option, but it returns "got terror: 1146:
Table "avanutri.obras" doesn't exist when using lock tables".
Then: " couldn't execute 'show create table 'obras': Table 'avanutri.obras'
doesn't exist (1146)"
Then the prompt freezes a while. After a few seconds, mysqld stops itself
and the dump is aborted.


-----Mensagem original-----
De: Shafi AHMED [mailto:shafi.ahmed@stripped] 
Enviada em: terça-feira, 24 de janeiro de 2012 10:52
Para: 'Suporte Avanutri'; mysql@stripped
Assunto: RE: Force drop table

Hi, What is the error associated with pls?

 
Best Rgs,
    Shafi AHMED
    


 
 
-----Original Message-----
From: Suporte Avanutri [mailto:suporte2@stripped]
Sent: Tuesday, January 24, 2012 6:05 PM
To: mysql@stripped
Subject: Force drop table

Hello,

 

I need to drop a table, but mysql cannot do it. I think the database is
corrupt. Is there some way to force the drop?

 

 

Mateus Almeida
Suporte Técnico

Avanutri & Nutrição Serviços e Informática Ltda ME 

CNPJ 07.775.666.0001-60  Insc. Estadual 780.532-67 Rua Maestro Costa Barros,
Nº 39/401

Centro - Três Rios, RJ

CEP 25805-090
Tel./fax: 24 2252-2468 

website:  <http://www.avanutri.com.br/> www.avanutri.com.br 

E-mail e MSN:  <mailto:suporte2@stripped> suporte2@stripped

Skype: suporteavanutri2

 




Get your world in your inbox!

Mail, widgets, documents, spreadsheets, organizer and much more with your
Sifymail WIYI id!
Log on to http://www.sify.com

********** DISCLAIMER **********
Information contained and transmitted by this E-MAIL is proprietary to Sify
Technologies Limited and is intended for use only by the individual or
entity to which it is addressed, and may contain information that is
privileged, confidential or exempt from disclosure under applicable law. If
this is a forwarded message, the content of this E-MAIL may not have been
sent with the authority of the Company. If you are not the intended
recipient, an agent of the intended recipient or a  person responsible for
delivering the information to the named recipient,  you are notified that
any use, distribution, transmission, printing, copying or dissemination of
this information in any way or in any manner is strictly prohibited. If you
have received this communication in error, please delete this mail & notify
us immediately at admin@stripped

Thread
Force drop tableSuporte Avanutri24 Jan
  • RE: Force drop tableShafi AHMED24 Jan
  • RES: Force drop tableSuporte Avanutri24 Jan
    • Re: RES: Force drop tableJohan De Meersman24 Jan
      • RES: RES: Force drop tableSuporte Avanutri24 Jan
        • Re: RES: Force drop tableSuresh Kuna25 Jan
          • RES: RES: Force drop tableSuporte Avanutri25 Jan
            • Re: RES: RES: Force drop tableJohan De Meersman25 Jan
              • RES: RES: RES: Force drop tableSuporte Avanutri26 Jan
                • Re: RES: RES: Force drop tableTodd Lyons26 Jan
                  • Re: RES: RES: Force drop tableJohan De Meersman26 Jan
                    • RES: RES: RES: Force drop tableSuporte Avanutri26 Jan
        • Re: RES: Force drop tableTodd Lyons25 Jan
          • Re: RES: Force drop tableTodd Lyons25 Jan