Alter table failed because disc is full. How do I delete the temporary table that was being created to reclaim some space?

⇧

⇩

55 views

I was adding a column to a 3.2 GB table and the alter table failed because the disc is full. It looks like the temporary table it created when doing the alter filled up the remaining space left on disc. I know I had at least a few gigs of space left, so I'm wondering how I can delete that temporary table to free up some extra space. I'm on centos.

mysql linux

asked March 9, 2011 3:37 pm CST

makeee

posted via StackOverflow

0 Answers

Be the first to answer this question

Similar discussion threads

How to reclaim space when we delete a huge amount of data
August 25, 2010 09:23:17 AM
Hello, i have a collection to store blob of text (some logs). And we have a cron to delete the oldest entry, but i noticed that the disk usage (du) doesn t go down, and now we are using 98% of the filesystem and repairDatabase() doesn t want to…

Created: (HIVE-1850) alter table set serdeproperties bypasses regexps checks (leaves table in a non-
December 14, 2010 07:19:56 AM
alter table set serdeproperties bypasses regexps checks (leaves table in a non-recoverable state?)

Help needed: Can't drop or alter a table , but can create a new table and run queries
February 2, 2011 01:01:13 PM
Hi All, I can't drop or alter tables, but can create a new one and load data , and run some queries. When I try to alter or drop a table I get : ERROR DataNucleus.Plugin: Bundle "org.eclipse.jdt.core" requires "org.eclipse.core.resources" but…

disable table, alter table, and merge regions
December 1, 2010 01:25:13 AM
We have HBase cluster which was peacefully (acceptable throughput and latencies) serving for about a month (we are using 0.89.20100926 version) This morning we wanted to set TTL to value smaller than default and Mr. Murphy struck. (A) We disabled…

Created: (DERBY-4883) Create a table function which turns an html table into a dbms table
November 2, 2010 04:02:50 PM
Create a table function which turns an html table into a dbms table

Created: (HIVE-1946) support alter table <T> partition <P> concatenate
February 2, 2011 02:08:54 PM
support alter table <T> partition <P> concatenate

Created: (HIVE-1595) job name for alter table <T> archive partition <P> is not correct
August 25, 2010 11:36:41 AM
job name for alter table <T> archive partition <P> is not correct

Created: (HIVE-1795) outputs not correctly populated for alter table
November 16, 2010 04:49:39 PM
outputs not correctly populated for alter table

Created: (HIVE-1934) alter table rename messes the location
January 27, 2011 04:38:29 PM
alter table rename messes the location

Created: (DERBY-5044) ALTER TABLE DROP COLUMN will not detect triggers defined on other with their t
February 15, 2011 05:57:22 PM
ALTER TABLE DROP COLUMN will not detect triggers defined on other with their trigger action using the column being dropped

Created: (DERBY-4984) ALTER TABLE DROP COLUMN may leave triggers invalid even if they are not using
January 25, 2011 04:50:31 PM
ALTER TABLE DROP COLUMN may leave triggers invalid even if they are not using the column getting dropped.

Created: (DERBY-4988) ALTER TABLE DROP COLUMN should make use of information in SYSTRIGGERS to detec
January 28, 2011 01:28:13 AM
ALTER TABLE DROP COLUMN should make use of information in SYSTRIGGERS to detect column used through REFERENCING clause to find trigger dependencies

Created: (DERBY-4943) TRUNCATE TABLE docs should state that it doesn't work for temporary tables
December 10, 2010 10:21:33 AM
TRUNCATE TABLE docs should state that it doesn't work for temporary tables

Created: (DERBY-4735) prepare of an XA read only transaction with a declared global temporary table
July 6, 2010 07:23:49 PM
prepare of an XA read only transaction with a declared global temporary table gets and ASSERT in SANE mode.

Created: (DERBY-4731) XA two phase commit with active GLOBAL TEMPORARY TABLE causes An internal er
July 2, 2010 01:55:49 PM
XA two phase commit with active GLOBAL TEMPORARY TABLE causes An internal error identified by RawStore module

Created: (DERBY-4743) Attempt to access a DECLARE GLOBAL TEMPORARY TABLE after commit in an XA trans
July 13, 2010 09:45:49 PM
Attempt to access a DECLARE GLOBAL TEMPORARY TABLE after commit in an XA transaction in Network server fails.

Reclaim deleted rows space
January 2, 2011 01:26:34 PM
Lets assume I have: * single 100GB SSTable file * min compaction threshold is set to 2 If I delete rows which are located in this file. Is the only way to "clean" the deleted rows is by inserting another 100GB of data or by triggering a painful…

9.1 - rewrite less alter table?
March 5, 2011 05:56:39 AM
hi perhaps I misunderstood something from commits, but I assumed that in 9.1 this operation shouldn't rewrite the table: CREATE TABLE test ( x varchar(16) ); insert into test select i::text from generate_series(1,1000000) i; alter table test alter…

alter table foo set location fails
August 23, 2010 09:26:26 PM
Hi all, I'm looking at http://wiki.apache.org/hadoop/Hive/LanguageManual/DDL, where there's a code example of the following: ALTER TABLE table_name [partitionSpec] SET LOCATION "new location" However, when I try to run it, I get alter table…

Created: (DERBY-5066) full table scan when index is used, taking extremely long time in JDBC
February 23, 2011 09:51:03 PM
full table scan when index is used, taking extremely long time in JDBC

Questions and Answers are licensed under cc-wiki license.

Alter table failed because disc is full. How do I delete the temporary table that was being created to reclaim some space?

0 Answers

Be the first to answer this question

Join with account you already have