You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@oozie.apache.org by "Dénes Bodó (Jira)" <ji...@apache.org> on 2021/06/22 14:48:00 UTC
[jira] [Resolved] (OOZIE-2010) Sqoop + DB2 Connection Close Error
[ https://issues.apache.org/jira/browse/OOZIE-2010?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Dénes Bodó resolved OOZIE-2010.
-------------------------------
Resolution: Cannot Reproduce
This ticket seems abandoned. If you feel that this still an issue in Oozie 5 then please reopen.
> Sqoop + DB2 Connection Close Error
> ----------------------------------
>
> Key: OOZIE-2010
> URL: https://issues.apache.org/jira/browse/OOZIE-2010
> Project: Oozie
> Issue Type: Bug
> Components: action
> Affects Versions: 4.0.1
> Reporter: Ajit Koti
> Priority: Major
>
> Sqoop retrieves the data from DB2 and when Sqoop tries to close the connection, it throws the below warning,
> I am using db2jcc4.jar , sqoop 1.4.2, Will also try with the latest version
> 14/09/15 16:30:39 INFO mapreduce.ImportJobBase: Transferred 24.4863 KB in 14.0591 seconds (1.7417 KB/sec)
> 14/09/15 16:30:39 INFO mapreduce.ImportJobBase: Retrieved 578 records.
> 14/09/15 16:30:39 INFO util.AppendUtils: Appending to directory test
> 14/09/15 16:30:39 INFO util.AppendUtils: Using found partition 36
> 14/09/15 16:30:39 INFO tool.ImportTool: Saving incremental import state to the metastore
> 14/09/15 16:30:39 INFO tool.ImportTool: Updated data for job: db2_test_fetch44
> 14/09/15 16:30:39 WARN tool.BaseSqoopTool: Error while closing connection: com.ibm.db2.jcc.am.SqlException: [jcc][t4][10251][10308][4.14.119] java.sql.Connection.close() requested while a transaction is in progress on the connection.
> The transaction remains active, and the connection cannot be closed. ERRORCODE=-4471, SQLSTATE=null
--
This message was sent by Atlassian Jira
(v8.3.4#803005)