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

["Marco Gaido (JIRA)" <ji...@apache.org>]

Marco Gaido created HIVE-13636:
----------------------------------

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