Stamatis Zampetakis created HIVE-24489:
------------------------------------------
Summary: TPC-DS dockerized tests fail due to stale entries in
MIN_HISTORY_LEVEL metastore table
Key: HIVE-24489
URL: https://issues.apache.org/jira/browse/HIVE-24489
Project: Hive
Issue Type: Bug
Reporter: Stamatis Zampetakis
Assignee: Stamatis Zampetakis
The failures can be seen here:
[http://ci.hive.apache.org/job/hive-precommit/job/master/373/]
The root cause is stale entries inside {{MIN_HISTORY_LEVEL}} table.
Caused by: MetaException(message:Unable to select from transaction database
org.postgresql.util.PSQLException: ERROR: duplicate key value violates unique
constraint "min_history_level_pkey"
Detail: Key ("MHL_TXNID")=(7858) already exists.
The content of the respective table inside the docker image is shown below.
SELECT * FROM "MIN_HISTORY_LEVEL" ;
MHL_TXNID | MHL_MIN_OPEN_TXNID
-----------+--------------------
6853 | 6687
7480 | 6947
7481 | 6947
6870 | 6687
7858 | 7858
6646 | 5946
7397 | 6947
7399 | 6947
5946 | 5946
6947 | 6947
7769 | 6947
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
