List:General Discussion« Previous MessageNext Message »
From:Reindl Harald Date:June 19 2013 7:19pm
Subject:Re: How can I drop a table that
is named “logs/#sql-ib203” and appeare
d after MySQL crash?
View as plain text  

Am 19.06.2013 21:00, schrieb Franck Dernoncourt:
> `USE logs; SHOW TABLES;` does not list the table `logs/#sql-ib203`, but
> when trying to `ALTER` the table that was being changed during the crash
> MySQL complains about the existence of the table `logs/#sql-ib203`:
> 
>> ERROR 1050: Table 'logs/#sql-ib203' already exists
>>
>> SQL Statement:
>>
>> ALTER TABLE `logs`.`srv_logs` DROP COLUMN `filenum` , DROP COLUMN
>> `agent` , DROP COLUMN `ip` , DROP COLUMN `event_source`
> 
> DROP TABLE `logs/#sql-ib203`; does not work, neither do some name variants
> `/#sql-ib203`, `#sql-ib203`, `sql-ib203`. (respectively Error Code: 1051.
> Unknown table 'logs.logs/#sql-ib203',  Error Code: 1051. Unknown table
>
> I use innodb_file_per_table. There was a "mysql_datadir/logs/#sql-ib203.ibd"
> file (or maybe .frm, sorry I forgot) that I deleted.
> 
> Any idea how to get rid of this ghostly table `logs/#sql-ib203`?

interesting question, i have identical crap since 2009 also
after a crash und these "blind table" has the same structure
as a used existing one

if i delete the #-files mysql whines every startup while
they are never used and it is ridiculous that there are
references in the table space to this useless crap and
no mysql version from 5.1.8 to 5.5.32 is fixing this

-rw-rw---- 1 mysql mysql 8,4K 2011-07-24 11:49 #sql2-704-271.frm
-rw-rw---- 1 mysql mysql  64K 2011-07-24 11:49 #sql2-704-271.ibd



Attachment: [application/pgp-signature] OpenPGP digital signature signature.asc
Thread
How can I drop a table that is named “logs/#sql-ib203” and appeared after MySQL crash?Franck Dernoncourt19 Jun
  • Re: How can I drop a table that is named “logs/#sql-ib203” and appeared after MySQL crash?Reindl Harald19 Jun
    • RE: How can I drop a table that is named “logs/#sql-ib203” and appeared after MySQL crash?Rick James20 Jun
      • Re: How can I drop a table that is named “logs/#sql-ib203” and appeared after MySQL crash?Reindl Harald20 Jun
        • RE: How can I drop a table that is named “logs/#sql-ib203” and appeared after MySQL crash?Rick James25 Jun
          • Re: How can I drop a table that is named “logs/#sql-ib203” and appeared after MySQL crash?Reindl Harald25 Jun
      • Re: How can I drop a table that is named “logs/#sql-ib203” and appeared after MySQL crash?Franck Dernoncourt20 Jun
  • Re: How can I drop a table that is named “logs/#sql-ib203” and appeared after MySQL crash?Denis Jedig20 Jun
  • Re: How can I drop a table that is named “logs/#sql-ib203” and appeared after MySQL crash?Carsten Pedersen20 Jun
    • Re: How can I drop a table that is named “logs/#sql-ib203” and appeared after MySQL crash?Franck Dernoncourt20 Jun
  • Re: How can I drop a table that is named “logs/#sql-ib203” and appeared after MySQL crash?Jesper Wisborg Krogh21 Jun