Mailing-List: contact issues-help@hive.apache.org; run by ezmlm
Precedence: bulk
Reply-To: dev@hive.apache.org
Date: Thu, 8 Oct 2015 19:12:27 +0000 (UTC)
From: "Jesus Camacho Rodriguez (JIRA)" <jira@apache.org>
To: issues@hive.apache.org
Message-ID: <JIRA.12895159.1442851957000.59805.1444331547183@Atlassian.JIRA>
In-Reply-To: <JIRA.12895159.1442851957000@Atlassian.JIRA>
References: <JIRA.12895159.1442851957000@Atlassian.JIRA>
 <JIRA.12895159.1442851957365@arcas>
Subject: [jira] [Updated] (HIVE-11902) Abort txn cleanup thread throws
 SyntaxErrorException
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit


     [ https://issues.apache.org/jira/browse/HIVE-11902?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Jesus Camacho Rodriguez updated HIVE-11902:
-------------------------------------------
    Fix Version/s: 2.0.0

> Abort txn cleanup thread throws SyntaxErrorException
> ----------------------------------------------------
>
>                 Key: HIVE-11902
>                 URL: https://issues.apache.org/jira/browse/HIVE-11902
>             Project: Hive
>          Issue Type: Bug
>          Components: Transactions
>            Reporter: Deepesh Khandelwal
>            Assignee: Deepesh Khandelwal
>             Fix For: 1.3.0, 2.0.0
>
>         Attachments: HIVE-11902.patch
>
>
> When cleaning left over transactions we see the DeadTxnReaper code threw the following exception:
> {noformat}
> 2015-09-21 05:23:38,148 WARN  [DeadTxnReaper-0]: txn.TxnHandler (TxnHandler.java:performTimeOuts(1876)) - Aborting timedout transactions failed due to You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 1(SQLState=42000,ErrorCode=1064)
> com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 1
>         at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
>         at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
>         at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
>         at java.lang.reflect.Constructor.newInstance(Constructor.java:526)
>         at com.mysql.jdbc.Util.handleNewInstance(Util.java:377)
>         at com.mysql.jdbc.Util.getInstance(Util.java:360)
>         at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:978)
>         at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3887)
>         at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3823)
>         at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2435)
>         at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2582)
>         at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2526)
>         at com.mysql.jdbc.StatementImpl.executeUpdate(StatementImpl.java:1618)
>         at com.mysql.jdbc.StatementImpl.executeUpdate(StatementImpl.java:1549)
>         at com.jolbox.bonecp.StatementHandle.executeUpdate(StatementHandle.java:497)
>         at org.apache.hadoop.hive.metastore.txn.TxnHandler.abortTxns(TxnHandler.java:1275)
>         at org.apache.hadoop.hive.metastore.txn.TxnHandler.performTimeOuts(TxnHandler.java:1866)
>         at org.apache.hadoop.hive.ql.txn.AcidHouseKeeperService$TimedoutTxnReaper.run(AcidHouseKeeperService.java:87)
>         at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471)
>         at java.util.concurrent.FutureTask.runAndReset(FutureTask.java:304)
>         at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$301(ScheduledThreadPoolExecutor.java:178)
>         at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:293)
>         at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
>         at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
>         at java.lang.Thread.run(Thread.java:745)
> {noformat}
> The problem here is that the method {{abortTxns(Connection dbConn, List<Long> txnids)}} in metastore/src/java/org/apache/hadoop/hive/metastore/txn/TxnHandler.java creates the following bad query when txnids list is empty.
> {code}
> delete from HIVE_LOCKS where hl_txnid in ();
> {code}


--
This message was sent by Atlassian JIRA
(v6.3.4#6332)