[
https://issues.apache.org/jira/browse/HIVE-12725?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Eugene Koifman resolved HIVE-12725.
-----------------------------------
Resolution: Fixed
Fix Version/s: 2.1.0
1.3.0
this was fixed in HIVE-11388
> CompactionTxnHandler.findNextToCompact() may produce "Operation not allowed
> after ResultSet closed"
> ---------------------------------------------------------------------------------------------------
>
> Key: HIVE-12725
> URL: https://issues.apache.org/jira/browse/HIVE-12725
> Project: Hive
> Issue Type: Bug
> Components: Transactions
> Affects Versions: 1.3.0, 2.0.0
> Reporter: Eugene Koifman
> Assignee: Eugene Koifman
> Fix For: 1.3.0, 2.1.0
>
>
> {noformat}
> 2015-12-21 22:34:55,427 ERROR txn.CompactionTxnHandler
> (CompactionTxnHandler.java:findNextToCompact(210)) -
> [pre-prod-poc-4.novalocal-41] Unable to select next element for \
> compaction, Operation not allowed after ResultSet closed
> 2015-12-21 22:34:55,431 ERROR compactor.Worker (Worker.java:run(181)) -
> [pre-prod-poc-4.novalocal-41] Caught an exception in the main loop of
> compactor worker pre-prod-poc-\
> 4.novalocal-41, MetaException(message:Unable to connect to transaction
> database java.sql.SQLException: Operation not allowed after ResultSet closed
> at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1073)
> at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:987)
> at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:982)
> at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:927)
> at com.mysql.jdbc.ResultSetImpl.checkClosed(ResultSetImpl.java:794)
> at com.mysql.jdbc.ResultSetImpl.next(ResultSetImpl.java:7139)
> at
> org.apache.hadoop.hive.metastore.txn.CompactionTxnHandler.findNextToCompact(CompactionTxnHandler.java:206)
> at org.apache.hadoop.hive.ql.txn.compactor.Worker.run(Worker.java:81)
> )
> at
> org.apache.hadoop.hive.metastore.txn.CompactionTxnHandler.findNextToCompact(CompactionTxnHandler.java:214)
> at org.apache.hadoop.hive.ql.txn.compactor.Worker.run(Worker.java:81)
> {noformat}
> https://docs.oracle.com/javase/7/docs/api/java/sql/Statement.html
> {noformat}
> int updCount = stmt.executeUpdate(s);
> if(updCount == 1) {
> dbConn.commit();
> return info;
> }
> if(updCount == 0) {
> LOG.debug("Another Worker picked up " + info);
> continue;
> }
> {noformat}
> executeUpdate() closes the RS and if competing Worker "steals" the item then
> updCount == 0 is true...
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
