[
https://issues.apache.org/jira/browse/LENS-1242?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15399366#comment-15399366
]
Hudson commented on LENS-1242:
------------------------------
UNSTABLE: Integrated in Lens-Commit #1310 (See
[https://builds.apache.org/job/Lens-Commit/1310/])
LENS-1242 : Fix JDBCDriver cancel query to call statement.cancel (puneet.gupta:
rev 9b402aee35e52fcf235974429cee760883b42271)
* lens-driver-jdbc/src/test/resources/drivers/jdbc/jdbc1/jdbcdriver-site.xml
* lens-driver-jdbc/src/main/java/org/apache/lens/driver/jdbc/JDBCDriver.java
* src/site/apt/admin/jdbcdriver-config.apt
* lens-driver-jdbc/src/test/java/org/apache/lens/driver/jdbc/TestJdbcDriver.java
*
lens-driver-jdbc/src/main/java/org/apache/lens/driver/jdbc/JDBCDriverConfConstants.java
* lens-driver-jdbc/src/main/resources/jdbcdriver-default.xml
> JDBCDriver cancel query is taking huge time
> -------------------------------------------
>
> Key: LENS-1242
> URL: https://issues.apache.org/jira/browse/LENS-1242
> Project: Apache Lens
> Issue Type: Bug
> Components: driver-jdbc
> Reporter: Amareshwari Sriramadasu
> Assignee: Amareshwari Sriramadasu
> Fix For: 2.6
>
> Attachments: LENS-1242.patch
>
>
> We are seeing Cancel on JDBC is taking huge time in production.
> Here are few logs :
> {noformat}
> 28 Jul 2016 05:54:19 [1113a9e8-86cd-43eb-b5bb-ad718a7e87cd]
> [grizzly-http-server-43] INFO
> org.apache.lens.server.query.QueryExecutionServiceImpl - CancelQuery:
> session:<?xml version="1.0" encoding="UTF-8"
> standalone="yes"?><lensSessionHandle><publicId>617e95ae-397f-46ea-9b20-f472e614d673</publicId><secretId>761a20c0-80b8-4406-a614-b38e21fa5b34</secretId></lensSessionHandle>
> query:18a411f0-b62e-48e9-821c-f34da98fedbc
> 28 Jul 2016 05:54:19 [1113a9e8-86cd-43eb-b5bb-ad718a7e87cd]
> [grizzly-http-server-43] INFO org.apache.hadoop.hive.conf.HiveConf - Using
> the default value passed in for log id: 617e95ae-397f-46ea-9b20-f472e614d673
> 28 Jul 2016 05:54:19 [1113a9e8-86cd-43eb-b5bb-ad718a7e87cd]
> [grizzly-http-server-43] INFO org.apache.hadoop.hive.ql.session.SessionState
> - Updating thread name to 617e95ae-397f-46ea-9b20-f472e614d673
> grizzly-http-server-43
> 28 Jul 2016 05:54:19 [18a411f0-b62e-48e9-821c-f34da98fedbc]
> [617e95ae-397f-46ea-9b20-f472e614d673 grizzly-http-server-43] INFO
> org.apache.lens.server.query.QueryExecutionServiceImpl - Updating status for
> 18a411f0-b62e-48e9-821c-f34da98fedbc
> 28 Jul 2016 05:54:19 [18a411f0-b62e-48e9-821c-f34da98fedbc]
> [617e95ae-397f-46ea-9b20-f472e614d673 grizzly-http-server-43] INFO
> org.apache.lens.server.api.query.QueryContext - Updating status of
> 18a411f0-b62e-48e9-821c-f34da98fedbc from Progress: 0.0
> 28 Jul 2016 05:54:56 [18a411f0-b62e-48e9-821c-f34da98fedbc] [StatusPoller]
> INFO org.apache.lens.server.query.QueryExecutionServiceImpl - Updating
> status for 18a411f0-b62e-48e9-821c-f34da98fedbc
> Progress: 0.0
> Status: RUNNING
> Status Message: 18a411f0-b62e-48e9-821c-f34da98fedbc is running
> Is Result Set Available: false
> to Progress: 0.0
> Status: RUNNING
> Status Message: 18a411f0-b62e-48e9-821c-f34da98fedbc is running
> Is Result Set Available: false
> 28 Jul 2016 06:14:38 [18a411f0-b62e-48e9-821c-f34da98fedbc]
> [617e95ae-397f-46ea-9b20-f472e614d673 grizzly-http-server-43] INFO
> org.apache.lens.driver.jdbc.JDBCDriver - jdbc/prod Cancelled query :
> 18a411f0-b62e-48e9-821c-f34da98fedbc
> 28 Jul 2016 06:14:38 [18a411f0-b62e-48e9-821c-f34da98fedbc]
> [617e95ae-397f-46ea-9b20-f472e614d673 grizzly-http-server-43] INFO
> org.apache.lens.server.query.QueryExecutionServiceImpl - Query
> 18a411f0-b62e-48e9-821c-f34da98fedbc cancelled successfully
> 28 Jul 2016 06:14:38 [18a411f0-b62e-48e9-821c-f34da98fedbc]
> [617e95ae-397f-46ea-9b20-f472e614d673 grizzly-http-server-43] INFO
> org.apache.lens.server.api.query.QueryContext - Updating status of
> 18a411f0-b62e-48e9-821c-f34da98fedbc from Progress: 0.0
> 28 Jul 2016 06:14:38 [18a411f0-b62e-48e9-821c-f34da98fedbc]
> [617e95ae-397f-46ea-9b20-f472e614d673 grizzly-http-server-43] INFO
> org.apache.lens.server.session.LensSessionImpl - Removing
> 18a411f0-b62e-48e9-821c-f34da98fedbc from active queries for session
> 617e95ae-397f-46ea-9b20-f472e614d673
> 28 Jul 2016 06:14:38 [18a411f0-b62e-48e9-821c-f34da98fedbc]
> [617e95ae-397f-46ea-9b20-f472e614d673 grizzly-http-server-43] INFO
> org.apache.hadoop.hive.conf.HiveConf - Using the default value passed in for
> log id: 617e95ae-397f-46ea-9b20-f472e614d673
> 28 Jul 2016 06:14:38 [18a411f0-b62e-48e9-821c-f34da98fedbc]
> [617e95ae-397f-46ea-9b20-f472e614d673 grizzly-http-server-43] INFO
> org.apache.hadoop.hive.ql.session.SessionState - Resetting thread name to
> grizzly-http-server-43
> {noformat}
> It took more than 10 minutes for cancelling from above logs.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
