MySQL Forums
Forum List  »  Archive Storage Engine

Can't write; duplicate key in table '#sql-950b_207'
Posted by: Fabien CELAIA
Date: March 07, 2017 02:47AM

I'm using MySQL 5.7.17 on RH7

I'm facing any problems converting some innodb tables to archive...

1) duplicate key... without duplicate key

CREATE TABLE `MYTABLE` (
`ID` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
`NAME_FR` varchar(50) DEFAULT NULL,
`NAME_DE` varchar(50) DEFAULT NULL,
`NAME_IT` varchar(50) DEFAULT NULL,
`NAME_EN` varchar(50) DEFAULT NULL,
PRIMARY KEY (`ID`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8;

6 lines without duplicate

ALTER TABLE MYTABLE engine=archive ;

Lookup Error - MySQL Database Error: Can't write; duplicate key in table '#sql-950b_476'

2) I'm creating the same table, without AUTO_INCREMENT

ALTER TABLE MYTABLE engine=archive ;

Lookup Error - MySQL Database Error: Got error -1 from storage engine

Options: ReplyQuote


Subject
Views
Written By
Posted
Can't write; duplicate key in table '#sql-950b_207'
3683
March 07, 2017 02:47AM


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.