[
https://issues.apache.org/jira/browse/HIVE-24489?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Jesus Camacho Rodriguez resolved HIVE-24489.
--------------------------------------------
Fix Version/s: 4.0.0
Resolution: Fixed
Pushed to master, thanks [~zabetak]!
> 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
> Priority: Major
> Labels: pull-request-available
> Fix For: 4.0.0
>
> Time Spent: 20m
> Remaining Estimate: 0h
>
> 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.
> {noformat}
> 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.{noformat}
> The content of the respective table inside the docker image is shown below.
> {noformat}
> 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{noformat}
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
