Rajkumar Singh created HIVE-25172:
-------------------------------------
Summary: HMS Postgres: Lock acquisition is failing because table
name exceeds the char limit of MS table datatype
Key: HIVE-25172
URL: https://issues.apache.org/jira/browse/HIVE-25172
Project: Hive
Issue Type: Bug
Components: Metastore
Affects Versions: 4.0.0
Reporter: Rajkumar Singh
Only affect user running Postgres as HMS backend database
{code:java}
021-05-11 19:49:41,040 ERROR org.apache.thrift.ProcessFunction:
[pool-7-thread-199]: Internal error processing lock
org.apache.hadoop.hive.metastore.api.MetaException: Unable to update
transaction database java.sql.BatchUpdateException: Batch entry 0 INSERT INTO
"TXN_COMPONENTS" ("TC_TXNID", "TC_DATABASE", "TC_TABLE", "TC_PARTITION", "T
C_OPERATION_TYPE", "TC_WRITEID") VALUES (654299, 'default',
'$some_big_table_name_exceeding_the_128_char_limit', NULL, 'i', 3) was aborte
d: ERROR: value too long for type character varying(128) Call getNextException
to see other errors in the batch.
...
Caused by: org.postgresql.util.PSQLException: ERROR: value too long for type
character varying(128)
{code}
it seems we are hitting the table name (TXN_COMPONENTS) char limit here which
is defined as
TC_TABLE TYPE character varying(128);
there is need to increase the limit of char or limit the table name under the
128 chars
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
