hive-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Ganesha Shreedhara (Jira)" <j...@apache.org>
Subject [jira] [Updated] (HIVE-23756) drop table command fails with MySQLIntegrityConstraintViolationException:
Date Wed, 24 Jun 2020 16:01:00 GMT

     [ https://issues.apache.org/jira/browse/HIVE-23756?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

Ganesha Shreedhara updated HIVE-23756:
--------------------------------------
    Description: 
Drop table command fails intermittently with the following exception.
{code:java}
Caused by: java.sql.BatchUpdateException: Cannot delete or update a parent row: a foreign
key constraint fails ("metastore"."COLUMNS_V2", CONSTRAINT "COLUMNS_V2_FK1" FOREIGN KEY ("CD_ID")
REFERENCES "CDS" ("CD_ID")) App > at com.mysql.jdbc.PreparedStatement.executeBatchSerially(PreparedStatement.java:1815)at
com.mysql.jdbc.PreparedStatement.executeBatch(PreparedStatement.java:1277) Appat org.datanucleus.store.rdbms.ParamLoggingPreparedStatement.executeBatch(ParamLoggingPreparedStatement.java:372)
at org.datanucleus.store.rdbms.SQLController.processConnectionStatement(SQLController.java:628)
at org.datanucleus.store.rdbms.SQLController.getStatementForUpdate(SQLController.java:207)
at org.datanucleus.store.rdbms.SQLController.getStatementForUpdate(SQLController.java:179)
at org.datanucleus.store.rdbms.scostore.JoinMapStore.clearInternal(JoinMapStore.java:901)
... 36 more 
Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Cannot
delete or update a parent row: a foreign key constraint fails ("metastore"."COLUMNS_V2", CONSTRAINT
"COLUMNS_V2_FK1" FOREIGN KEY ("CD_ID") REFERENCES "CDS" ("CD_ID"))
at sun.reflect.GeneratedConstructorAccessor121.newInstance(Unknown Source)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:377)
at com.mysql.jdbc.Util.getInstance(Util.java:360)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:971)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3887)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3823){code}
Although HIVE-19994 resolves this issue, the FK constraint name of COLUMNS_V2 table specified
in package.jdo file is not same as the FK constraint name used while creating COLUMNS_V2 table
([Ref|#L60]]). 

  was:
Drop table command fails intermittently with the following exception.
{code:java}
Caused by: java.sql.BatchUpdateException: Cannot delete or update a parent row: a foreign
key constraint fails ("metastore"."COLUMNS_V2", CONSTRAINT "COLUMNS_V2_FK1" FOREIGN KEY ("CD_ID")
REFERENCES "CDS" ("CD_ID")) App > at com.mysql.jdbc.PreparedStatement.executeBatchSerially(PreparedStatement.java:1815)at
com.mysql.jdbc.PreparedStatement.executeBatch(PreparedStatement.java:1277) Appat org.datanucleus.store.rdbms.ParamLoggingPreparedStatement.executeBatch(ParamLoggingPreparedStatement.java:372)
at org.datanucleus.store.rdbms.SQLController.processConnectionStatement(SQLController.java:628)
at org.datanucleus.store.rdbms.SQLController.getStatementForUpdate(SQLController.java:207)
at org.datanucleus.store.rdbms.SQLController.getStatementForUpdate(SQLController.java:179)
at org.datanucleus.store.rdbms.scostore.JoinMapStore.clearInternal(JoinMapStore.java:901)
... 36 more 
Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Cannot
delete or update a parent row: a foreign key constraint fails ("metastore"."COLUMNS_V2", CONSTRAINT
"COLUMNS_V2_FK1" FOREIGN KEY ("CD_ID") REFERENCES "CDS" ("CD_ID"))
at sun.reflect.GeneratedConstructorAccessor121.newInstance(Unknown Source)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:377)
at com.mysql.jdbc.Util.getInstance(Util.java:360)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:971)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3887)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3823){code}
Although HIVE-19994 resolves this issue, the FK constrain name of COLUMNS_V2 table specified
in package.jdo file is not same as the FK constraint name used while creating COLUMNS_V2 table
([Ref|[https://github.com/apache/hive/blob/master/standalone-metastore/metastore-server/src/main/sql/mysql/hive-schema-3.2.0.mysql.sql#L60]]). 


> drop table command fails with MySQLIntegrityConstraintViolationException:
> -------------------------------------------------------------------------
>
>                 Key: HIVE-23756
>                 URL: https://issues.apache.org/jira/browse/HIVE-23756
>             Project: Hive
>          Issue Type: Bug
>            Reporter: Ganesha Shreedhara
>            Assignee: Ganesha Shreedhara
>            Priority: Major
>         Attachments: HIVE-23756.1.patch
>
>
> Drop table command fails intermittently with the following exception.
> {code:java}
> Caused by: java.sql.BatchUpdateException: Cannot delete or update a parent row: a foreign
key constraint fails ("metastore"."COLUMNS_V2", CONSTRAINT "COLUMNS_V2_FK1" FOREIGN KEY ("CD_ID")
REFERENCES "CDS" ("CD_ID")) App > at com.mysql.jdbc.PreparedStatement.executeBatchSerially(PreparedStatement.java:1815)at
com.mysql.jdbc.PreparedStatement.executeBatch(PreparedStatement.java:1277) Appat org.datanucleus.store.rdbms.ParamLoggingPreparedStatement.executeBatch(ParamLoggingPreparedStatement.java:372)
> at org.datanucleus.store.rdbms.SQLController.processConnectionStatement(SQLController.java:628)
> at org.datanucleus.store.rdbms.SQLController.getStatementForUpdate(SQLController.java:207)
> at org.datanucleus.store.rdbms.SQLController.getStatementForUpdate(SQLController.java:179)
> at org.datanucleus.store.rdbms.scostore.JoinMapStore.clearInternal(JoinMapStore.java:901)
> ... 36 more 
> Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException:
Cannot delete or update a parent row: a foreign key constraint fails ("metastore"."COLUMNS_V2",
CONSTRAINT "COLUMNS_V2_FK1" FOREIGN KEY ("CD_ID") REFERENCES "CDS" ("CD_ID"))
> at sun.reflect.GeneratedConstructorAccessor121.newInstance(Unknown Source)
> at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
> at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
> at com.mysql.jdbc.Util.handleNewInstance(Util.java:377)
> at com.mysql.jdbc.Util.getInstance(Util.java:360)
> at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:971)
> at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3887)
> at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3823){code}
> Although HIVE-19994 resolves this issue, the FK constraint name of COLUMNS_V2 table
specified in package.jdo file is not same as the FK constraint name used while creating COLUMNS_V2
table ([Ref|#L60]]). 



--
This message was sent by Atlassian Jira
(v8.3.4#803005)

Mime
View raw message