Bug #82020 table lost or missing when alter column
| Submitted: | 27 Jun 2016 14:58 | Modified: | 31 Aug 2016 13:29 |
|---|---|---|---|
| Reporter: | Ruidian Ye | Email Updates: | |
| Status: | Can't repeat | Impact on me: | |
| Category: | MySQL Server | Severity: | S1 (Critical) |
| Version: | 5.6.28 | OS: | CentOS (Release: 7.2.1511) |
| Assigned to: | CPU Architecture: | Any | |
| Tags: | table lost, table missing, workbench | ||
[27 Jun 2016 14:58]
Ruidian Ye
[27 Jun 2016 16:51]
Ruidian Ye
I also got the error message from the log file: 2016-06-27 19:55:54 1008 [ERROR] InnoDB: dict_load_foreigns() returned 38 for ALTER TABLE `piao`.`party_relationship` ADD COLUMN `PARTY_NAME_FROM` VARCHAR(100) NULL DEFAULT NULL AFTER `PARTY_ID_TO` 2016-06-27 20:04:57 7fd52cd0d700 InnoDB: Error: in ALTER TABLE `piao`.`party_relationship` InnoDB: has or is referenced in foreign key constraints InnoDB: which are not compatible with the new table definition. 2016-06-27 20:04:57 7fd52cd0d700 InnoDB: Error: in ALTER TABLE `piao`.`party_relationship` InnoDB: has or is referenced in foreign key constraints Since I was using workbench to model, why there is foreign key issue please?
[28 Jun 2016 7:16]
Ruidian Ye
Today after table missing and could not simply create table since foreign key constraint, I drop foreign key constraint. Again, I get some error when trying to create new party_relationship table. And lost Connection when I try to query the table. I will attach log information which said this may be a bug.
[31 Aug 2016 13:29]
MySQL Verification Team
Please provide a repeatable test case otherwise we aren't able to repeat just with your description. Thanks in advance.
Portions of this website are copyright © 2001, 2002 The PHP Group
Page generated in 0.057 sec. using MySQL 8.4.7-u6-cloud
Timestamp references displayed by the system are UTC.
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.