[
https://issues.apache.org/jira/browse/HIVE-24489?focusedWorklogId=520377&page=com.atlassian.jira.plugin.system.issuetabpanels:worklog-tabpanel#worklog-520377
]
ASF GitHub Bot logged work on HIVE-24489:
-----------------------------------------
Author: ASF GitHub Bot
Created on: 04/Dec/20 23:52
Start Date: 04/Dec/20 23:52
Worklog Time Spent: 10m
Work Description: jcamachor merged pull request #1745:
URL: https://github.com/apache/hive/pull/1745
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
[email protected]
Issue Time Tracking
-------------------
Worklog Id: (was: 520377)
Time Spent: 20m (was: 10m)
> 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
> 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)
