ERROR 1025 (HY000): Error on rename of '.\reporting\#sql-a2c_1' to '.\reporting\event' (errno: -1)
Hi,
while running below sql to alter a existing table on a mysql database I'm getting
ERROR 1025 (HY000): Error on rename of '.\reporting\#sql-a2c_1' to '.\reporting\event' (errno: -1)
mysql> ALTER TABLE event PARTITION BY RANGE COLUMNS(time) (
-> PARTITION p1 VALUES LESS THAN ('2013-12-08'),
-> PARTITION p2 VALUES LESS THAN ('2013-12-15'),
-> PARTITION p3 VALUES LESS THAN MAXVALUE );
ERROR 1025 (HY000): Error on rename of '.\reporting\#sql-a2c_1' to '.\reporting\event' (errno: -1)
event table has around 442Millon records, on average of 2.45Million records per day. Below is the show table output
mysql> show create table event;
+-------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Table | Create Table
|
+-------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| event | CREATE TABLE `event` (
`event_key` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`event_id` binary(26) NOT NULL,
`landscape_h` int(10) unsigned NOT NULL,
`model_key` int(10) unsigned NOT NULL DEFAULT '0',
`time` datetime NOT NULL,
`type` int(10) unsigned NOT NULL,
`creator_id` int(10) unsigned NOT NULL,
`event_msg` mediumtext,
`server_precedence` int(10) unsigned DEFAULT '0',
PRIMARY KEY (`event_key`,`time`),
UNIQUE KEY `event_id_model_key_idx` (`event_id`,`model_key`,`time`),
KEY `landscape_idx` (`landscape_h`),
KEY `model_key_idx` (`model_key`),
KEY `time_idx` (`time`),
KEY `landscape_and_time_idx` (`landscape_h`,`time`),
KEY `type_idx` (`type`),
KEY `creator_id_idx` (`creator_id`)
) ENGINE=InnoDB AUTO_INCREMENT=764515132 DEFAULT CHARSET=utf8 MAX_ROWS=1000000000 AVG_ROW_LENGTH=500 |
+-------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
1 row in set (18.23 sec)
Size of the db is 280GB and the free space available on HD is 360GB before query execution & memory 8GB.
I tunned mysql parameters to faster "copy to tmp table" phase
tmp_table_size = 1G
max_heap_table_size = 1G
query executed for 5 days and failed with the error: -1
Any idea what might be the cause, and how to fix it ?