[HIVE-23866] Create table fail because duplicated Id with one more HMS on MSSQL

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: All Versions
• Component/s: Standalone Metastore
• Assignee: wenjun ma
• Reporter: wenjun ma
• Created: 16/Jul/20 20:42
• Updated: 09/Sep/21 18:05

Description

Condition:

1. Heavy DDL submitted to HS2.

2. Muti HMS

3. MS SQL as backend DB for HMS.

When customer create the table they will get following error:

org.apache.hadoop.hive.metastore.model.MTableColumnPrivilege@ce80aa0" using statement "INSERT INTO TBL_COL_PRIVS (TBL_COLUMN_GRANT_ID,AUTHORIZER,"COLUMN_NAME",CREATE_TIME,GRANT_OPTION,GRANTOR,GRANTOR_TYPE,PRINCIPAL_NAME,PRINCIPAL_TYPE,TBL_COL_PRIV,TBL_ID) VALUES (?,?,?,?,?,?,?,?,?,?,?)" failed : Violation of PRIMARY KEY constraint 'PK_tbl_col_privs_TBL_COLUMN_GRANT_ID'. Cannot insert duplicate key in object 'dbo.TBL_COL_PRIVS'. The duplicate key value is (241408091).

 

After debugging I found It's the issue from DataNucleus I will submitted  PR to DataNucleus to fix this issue.