[jira] [Commented] (HIVE-13636) Exception using Postgres as metastore with ACID transanctions enabled

["Rajkumar Singh (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/HIVE-13636?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15345738#comment-15345738 ] 

Rajkumar Singh commented on HIVE-13636:
---------------------------------------

[~mgaido] it seems that there is no issue with hive here, you are using old postgress jdbc3 driver which is throwing AbstractMethodError, could you please update to jdbc4 driver and see if you still face this issue.

> 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)