[HIVE-24489] TPC-DS dockerized tests fail due to stale entries in MIN_HISTORY_LEVEL metastore table

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 4.0.0-alpha-1
• Labels: pull-request-available
• Assignee: Stamatis Zampetakis
• Reporter: Stamatis Zampetakis
• Created: 04/Dec/20 17:40
• Updated: 27/Feb/24 22:23
• Resolved: 04/Dec/20 23:53

Description

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

Issue Links

• links to: GitHub Pull Request #1745