You are viewing a plain text version of this content. The canonical link for it is here.

Posted to notifications@shardingsphere.apache.org by GitBox <gi...@apache.org> on 2019/11/20 09:19:25 UTC

[GitHub] [incubator-shardingsphere] larry0592 opened a new issue #3562: Create a foreign key using ddl，Execute twice

larry0592 opened a new issue #3562: Create a foreign key using ddl，Execute twice
URL: https://github.com/apache/incubator-shardingsphere/issues/3562
 
 
   2019-11-20 17:13:50.349  INFO 17944 --- [           main] ShardingSphere-SQL                       : Actual SQL: ds ::: alter table **_ACT_ID_MEMBERSHIP_** 
   add constraint ACT_FK_MEMB_GROUP 
   foreign key (GROUP_ID_) 
   references act_id_group (ID_)
   2019-11-20 17:13:50.349  INFO 17944 --- [           main] ShardingSphere-SQL                       : Actual SQL: ds ::: alter table **_act_id_membership_** 
   add constraint ACT_FK_MEMB_GROUP 
   foreign key (GROUP_ID_) 
   references ACT_ID_GROUP (ID_)
   2019-11-20 17:13:51.461 ERROR 17944 --- [           main] .d.AbstractSqlScriptBasedDbSchemaManager : problem during schema create, statement alter table ACT_ID_MEMBERSHIP 
   add constraint ACT_FK_MEMB_GROUP 
   foreign key (GROUP_ID_) 
   references ACT_ID_GROUP (ID_)
   
   java.sql.SQLIntegrityConstraintViolationException: Can't write; duplicate key in table '#sql-78c_19a'
   
   

----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
 
For queries about this service, please contact Infrastructure at:
users@infra.apache.org


With regards,
Apache Git Services