MySQL Forums :: Partitioning :: ERROR 1025 (HY000): Error on rename of '.\reporting\#sql-a2c_1' to '.\reporting\event' (errno: -1)


Advanced Search

ERROR 1025 (HY000): Error on rename of '.\reporting\#sql-a2c_1' to '.\reporting\event' (errno: -1)
Posted by: Raghavendra K ()
Date: August 22, 2014 12:37AM

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 ?

Options: ReplyQuote


Subject Views Written By Posted
ERROR 1025 (HY000): Error on rename of '.\reporting\#sql-a2c_1' to '.\reporting\event' (errno: -1) 2996 Raghavendra K 08/22/2014 12:37AM
Re: ERROR 1025 (HY000): Error on rename of '.\reporting\#sql-a2c_1' to '.\reporting\event' (errno: -1) 1140 Rick James 08/24/2014 09:14PM
Re: ERROR 1025 (HY000): Error on rename of '.\reporting\#sql-a2c_1' to '.\reporting\event' (errno: -1) 1136 Raghavendra K 08/25/2014 11:38AM
Re: ERROR 1025 (HY000): Error on rename of '.\reporting\#sql-a2c_1' to '.\reporting\event' (errno: -1) 1139 Rick James 08/26/2014 02:31PM
Re: ERROR 1025 (HY000): Error on rename of '.\reporting\#sql-a2c_1' to '.\reporting\event' (errno: -1) 1006 Raghavendra K 08/30/2014 03:43AM
Re: ERROR 1025 (HY000): Error on rename of '.\reporting\#sql-a2c_1' to '.\reporting\event' (errno: -1) 1128 Rick James 09/01/2014 08:28PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.