If a crash occurs in the middle of an ALTER, the files may not get cleaned up.
-Original Message-
From: Reindl Harald [mailto:h.rei...@thelounge.net]
Sent: Thursday, June 20, 2013 12:57 PM
To: mysql@lists.mysql.com
Subject: Re: How can I drop a table that is named “logs/#sql-ib203”
that is what we all know
but how to get rid of them?
but *why* they are not cleaned up?
* the global tablespace knows about them
* nothing is using them really
* so why can mysqld not cleanup this mess?
if you delete them all works fine but each start
the error-log is cluttered
Am 25.06.2013
Hi Frank,
On 20/06/2013 05:00, Franck Dernoncourt wrote:
Hi all,
A table `logs/#sql-ib203` appeared after a MySQL crash due to disk space
shortage while deleting some attributes in a table in the `logs` database
and adding an index.
`USE logs; SHOW TABLES;` does not list the table
Franck,
Am 19.06.2013 21:00, schrieb Franck Dernoncourt:
A table `logs/#sql-ib203` appeared after a MySQL crash
the #sql-ibtableID tables are temporarily created during an
ALTER TABLE operation for recovery purposes. Apparently these
temporary tables might stay in certain circumstances
This may be a naive question, but I'm not sure I can see you've covered
this: Have you tried USE logs before DROP TABLE `#sql-ib203` (without
the logs/ bit)?
/ Carsten
On 19-06-2013 21:00, Franck Dernoncourt wrote:
Hi all,
A table `logs/#sql-ib203` appeared after a MySQL crash due to disk
On Thu, Jun 20, 2013 at 7:13 AM, Denis Jedig d...@syneticon.net wrote:
If you already tried enclosing the table name in backticks (DROP TABLE
`#sql-ib203`) and using the DROP TEMPORARY TABLE syntax without success,
Yep, no success with:
DROP TEMPORARY TABLE `logs/#sql-ib203`;
DROP TEMPORARY
On Thu, Jun 20, 2013 at 3:28 PM, Rick James rja...@yahoo-inc.com wrote:
#sql files are temp tables that vanish when the ALTER (or whatever)
finishes. If you find one sitting around, it sounds like a crash happened
in the middle of the ALTER.
Yes the crash happened during an ALTER: the table
i know what happened but how get rid of these two bullshit files
after *three years* not touched and used by mysqld
Am 20.06.2013 21:28, schrieb Rick James:
#sql files are temp tables that vanish when the ALTER (or whatever) finishes.
If you find one sitting around, it sounds like a crash
#sql files are temp tables that vanish when the ALTER (or whatever) finishes.
If you find one sitting around, it sounds like a crash happened in the middle
of the ALTER.
-Original Message-
From: Reindl Harald [mailto:h.rei...@thelounge.net]
Sent: Wednesday, June 19, 2013 12:19 PM
Hi all,
A table `logs/#sql-ib203` appeared after a MySQL crash due to disk space
shortage while deleting some attributes in a table in the `logs` database
and adding an index.
`USE logs; SHOW TABLES;` does not list the table `logs/#sql-ib203`, but
when trying to `ALTER` the table that was being
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
11 matches
Mail list logo