[
https://issues.apache.org/jira/browse/HIVE-25206?focusedWorklogId=637905&page=com.atlassian.jira.plugin.system.issuetabpanels:worklog-tabpanel#worklog-637905
]
ASF GitHub Bot logged work on HIVE-25206:
-----------------------------------------
Author: ASF GitHub Bot
Created on: 14/Aug/21 00:09
Start Date: 14/Aug/21 00:09
Worklog Time Spent: 10m
Work Description: github-actions[bot] closed pull request #2355:
URL: https://github.com/apache/hive/pull/2355
--
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.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
Issue Time Tracking
-------------------
Worklog Id: (was: 637905)
Time Spent: 0.5h (was: 20m)
> Add primary key for partial metadata script
> -------------------------------------------
>
> Key: HIVE-25206
> URL: https://issues.apache.org/jira/browse/HIVE-25206
> Project: Hive
> Issue Type: Bug
> Components: Standalone Metastore
> Affects Versions: 4.0.0
> Reporter: zhangbutao
> Assignee: zhangbutao
> Priority: Major
> Labels: pull-request-available
> Fix For: 4.0.0
>
> Attachments: HIVE-25206.1.patch
>
> Time Spent: 0.5h
> Remaining Estimate: 0h
>
>
> {code:java}
> standalone-metastore/metastore-server/src/main/sql/mysql/hive-schema-4.0.0.mysql.sql
> {code}
> Some metadata tables in hive-schema-4.0.0.mysql.sql dont't have primary key.
> Eg *TXN_COMPONENTS* and *COMPLETED_TXN_COMPONENTS* . This will cause
> exception when backend mysql set some strict parameters such as '*global
> pxc_strict_mode='ENFORCING*''.
> {code:java}
> Caused by: org.apache.hadoop.hive.metastore.api.MetaException: Unable to
> clean up java.sql.SQLException: Percona-XtraDB-Cluster prohibits use of DML
> command on a table (hive4s.txn_components) without an explicit primary key
> with pxc_strict_mode = ENFORCING or MASTER
> at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1078)
> at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4187)
> at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4119)
> at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2570)
> at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2731)
> at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2814)
> at com.mysql.jdbc.StatementImpl.executeUpdate(StatementImpl.java:1813)
> at com.mysql.jdbc.StatementImpl.executeUpdate(StatementImpl.java:1727)
> at
> org.apache.hive.com.zaxxer.hikari.pool.ProxyStatement.executeUpdate(ProxyStatement.java:117)
> at
> org.apache.hive.com.zaxxer.hikari.pool.HikariProxyStatement.executeUpdate(HikariProxyStatement.java)
> at
> org.apache.hadoop.hive.metastore.txn.TxnHandler.cleanupRecords(TxnHandler.java:3962)
> at
> org.apache.hadoop.hive.metastore.AcidEventListener.onDropDatabase(AcidEventListener.java:58)
> at
> org.apache.hadoop.hive.metastore.MetaStoreListenerNotifier$23.notify(MetaStoreListenerNotifier.java:94)
> at
> org.apache.hadoop.hive.metastore.MetaStoreListenerNotifier.notifyEvent(MetaStoreListenerNotifier.java:305)
> at
> org.apache.hadoop.hive.metastore.HMSHandler.drop_database_core(HMSHandler.java:1893)
> at
> org.apache.hadoop.hive.metastore.HMSHandler.drop_database(HMSHandler.java:1954)
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> at
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
> at
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
> at java.lang.reflect.Method.invoke(Method.java:498)
> at
> org.apache.hadoop.hive.metastore.RetryingHMSHandler.invokeInternal(RetryingHMSHandler.java:147)
> at
> org.apache.hadoop.hive.metastore.RetryingHMSHandler.invoke(RetryingHMSHandler.java:108)
> at com.sun.proxy.$Proxy28.drop_database(Unknown Source)
> at
> org.apache.hadoop.hive.metastore.api.ThriftHiveMetastore$Processor$drop_database.getResult(ThriftHiveMetastore.java:17577)
> at
> org.apache.hadoop.hive.metastore.api.ThriftHiveMetastore$Processor$drop_database.getResult(ThriftHiveMetastore.java:17556)
> at org.apache.thrift.ProcessFunction.process(ProcessFunction.java:38)
> at
> org.apache.hadoop.hive.metastore.TUGIBasedProcessor$1.run(TUGIBasedProcessor.java:111)
> at
> org.apache.hadoop.hive.metastore.TUGIBasedProcessor$1.run(TUGIBasedProcessor.java:107)
> at java.security.AccessController.doPrivileged(Native Method)
> at javax.security.auth.Subject.doAs(Subject.java:422)
> at
> org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1685)
> at
> org.apache.hadoop.hive.metastore.TUGIBasedProcessor.process(TUGIBasedProcessor.java:119)
> at
> org.apache.thrift.server.TThreadPoolServer$WorkerProcess.run(TThreadPoolServer.java:313)
> at
> java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
> at
> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
> at java.lang.Thread.run(Thread.java:745)
> {code}
>
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
