[
https://issues.apache.org/jira/browse/HIVE-24489?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Stamatis Zampetakis updated HIVE-24489:
---------------------------------------
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.
{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}
was:
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
> 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
>
> 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)
