Can't write; duplicate key in table '#sql-950b_207'
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
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.