[
https://issues.apache.org/jira/browse/HIVE-13636?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Marco Gaido updated HIVE-13636:
-------------------------------
Description:
We are using Postgres as metastore and we enabled ACID transactions. Once we
have done this, we started facing this error:
{code}
FATAL [DeadTxnReaper-0]: txn.AcidHouseKeeperService
(AcidHouseKeeperService.java:run(92)) - Serious error in DeadTxnReaper-0:
Method org/postgresql/jdbc3/Jdbc3ResultSet.isClosed()Z is abstract
java.lang.AbstractMethodError: Method
org/postgresql/jdbc3/Jdbc3ResultSet.isClosed()Z is abstract
at org.postgresql.jdbc3.Jdbc3ResultSet.isClosed(Jdbc3ResultSet.java)
at
org.apache.hadoop.hive.metastore.txn.TxnHandler.close(TxnHandler.java:934)
at
org.apache.hadoop.hive.metastore.txn.TxnHandler.close(TxnHandler.java:947)
at
org.apache.hadoop.hive.metastore.txn.TxnHandler.performTimeOuts(TxnHandler.java:1933)
at
org.apache.hadoop.hive.ql.txn.AcidHouseKeeperService$TimedoutTxnReaper.run(AcidHouseKeeperService.java:87)
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
at java.util.concurrent.FutureTask.runAndReset(FutureTask.java:308)
at
java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$301(ScheduledThreadPoolExecutor.java:180)
at
java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:294)
at
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
at java.lang.Thread.run(Thread.java:745)
{code}
Looking at the code of the class TxnHandler, in the method close is actually
used the isClosed() method on the ResultSet class, which is not implemented in
Jdbc3ResultSet Postgres driver's class.
was:
We are using Postgres as metastore and we enabled ACID transactions. Once we
have done this, we started facing this error:
<code>FATAL [DeadTxnReaper-0]: txn.AcidHouseKeeperService
(AcidHouseKeeperService.java:run(92)) - Serious error in DeadTxnReaper-0:
Method org/postgresql/jdbc3/Jdbc3ResultSet.isClosed()Z is abstract
java.lang.AbstractMethodError: Method
org/postgresql/jdbc3/Jdbc3ResultSet.isClosed()Z is abstract
at org.postgresql.jdbc3.Jdbc3ResultSet.isClosed(Jdbc3ResultSet.java)
at
org.apache.hadoop.hive.metastore.txn.TxnHandler.close(TxnHandler.java:934)
at
org.apache.hadoop.hive.metastore.txn.TxnHandler.close(TxnHandler.java:947)
at
org.apache.hadoop.hive.metastore.txn.TxnHandler.performTimeOuts(TxnHandler.java:1933)
at
org.apache.hadoop.hive.ql.txn.AcidHouseKeeperService$TimedoutTxnReaper.run(AcidHouseKeeperService.java:87)
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
at java.util.concurrent.FutureTask.runAndReset(FutureTask.java:308)
at
java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$301(ScheduledThreadPoolExecutor.java:180)
at
java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:294)
at
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
at java.lang.Thread.run(Thread.java:745)</code>
Looking at the code of the class TxnHandler, in the method close is actually
used the isClosed() method on the ResultSet class, which is not implemented in
Jdbc3ResultSet Postgres driver's class.
> Exception using Postgres as metastore with ACID transanctions enabled
> ---------------------------------------------------------------------
>
> Key: HIVE-13636
> URL: https://issues.apache.org/jira/browse/HIVE-13636
> Project: Hive
> Issue Type: Bug
> Components: Metastore, Transactions
> Affects Versions: 1.2.1
> Environment: HDP 2.3.2
> Reporter: Marco Gaido
>
> We are using Postgres as metastore and we enabled ACID transactions. Once we
> have done this, we started facing this error:
> {code}
> FATAL [DeadTxnReaper-0]: txn.AcidHouseKeeperService
> (AcidHouseKeeperService.java:run(92)) - Serious error in DeadTxnReaper-0:
> Method org/postgresql/jdbc3/Jdbc3ResultSet.isClosed()Z is abstract
> java.lang.AbstractMethodError: Method
> org/postgresql/jdbc3/Jdbc3ResultSet.isClosed()Z is abstract
> at org.postgresql.jdbc3.Jdbc3ResultSet.isClosed(Jdbc3ResultSet.java)
> at
> org.apache.hadoop.hive.metastore.txn.TxnHandler.close(TxnHandler.java:934)
> at
> org.apache.hadoop.hive.metastore.txn.TxnHandler.close(TxnHandler.java:947)
> at
> org.apache.hadoop.hive.metastore.txn.TxnHandler.performTimeOuts(TxnHandler.java:1933)
> at
> org.apache.hadoop.hive.ql.txn.AcidHouseKeeperService$TimedoutTxnReaper.run(AcidHouseKeeperService.java:87)
> at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
> at java.util.concurrent.FutureTask.runAndReset(FutureTask.java:308)
> at
> java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$301(ScheduledThreadPoolExecutor.java:180)
> at
> java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:294)
> at
> java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
> at
> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
> at java.lang.Thread.run(Thread.java:745)
> {code}
> Looking at the code of the class TxnHandler, in the method close is actually
> used the isClosed() method on the ResultSet class, which is not implemented
> in Jdbc3ResultSet Postgres driver's class.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)