Details
-
Bug
-
Resolution: Fixed
-
Low
-
3.2.1
-
Severity 2 - Major
-
9
-
Description
Summary
When JSD is connected to a MySQL database, a SQL exception is thrown every time when JSD mail processor handles a new incoming mail.
Environment
- MySQL 5.6
- driver tested : 5.1.19, 5.1.38, 5.1.39
Steps to Reproduce
- Setup a new JSD 3.2.1 instance and connect to a MySQL database
- Setup a new Service Desk project and a new mail channel
- Send a test email to the mail channel
Expected Results
A new issue is created in Service Desk project without any error
Actual Results
A new issue is created in Service Desk project but the below exception is thrown in the atlassian-jira-incoming-mail.log file:
2016-10-04 23:36:01,459 ERROR [] Caesium-2-1 anonymous MailJobRunner Failed com.atlassian.sal.api.rdbms.RdbmsException: Unable to commit connection at com.atlassian.sal.core.rdbms.DefaultTransactionalExecutor.executeInternal(DefaultTransactionalExecutor.java:97) [?:?] at com.atlassian.sal.core.rdbms.DefaultTransactionalExecutor$1.execute(DefaultTransactionalExecutor.java:45) [?:?] at com.atlassian.sal.jira.rdbms.JiraHostConnectionAccessor.lambda$borrowConnectionAndExecute$0(JiraHostConnectionAccessor.java:62) [?:?] at com.atlassian.jira.database.DatabaseAccessorImpl.executeQuery(DatabaseAccessorImpl.java:67) [classes/:?] at sun.reflect.GeneratedMethodAccessor542.invoke(Unknown Source) [?:?] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) [?:1.8.0_77] at java.lang.reflect.Method.invoke(Method.java:498) [?:1.8.0_77] at com.atlassian.plugin.util.ContextClassLoaderSettingInvocationHandler.invoke(ContextClassLoaderSettingInvocationHandler.java:26) [atlassian-plugins-core-4.1.0.jar:?] at com.sun.proxy.$Proxy551.executeQuery(Unknown Source) [?:?] at sun.reflect.GeneratedMethodAccessor542.invoke(Unknown Source) [?:?] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) [?:1.8.0_77] at java.lang.reflect.Method.invoke(Method.java:498) [?:1.8.0_77] at com.atlassian.plugin.osgi.bridge.external.HostComponentFactoryBean$DynamicServiceInvocationHandler.invoke(HostComponentFactoryBean.java:136) [atlassian-plugins-osgi-bridge-4.1.0.jar:?] at com.sun.proxy.$Proxy551.executeQuery(Unknown Source) [?:?] at com.atlassian.sal.jira.rdbms.JiraHostConnectionAccessor.borrowConnectionAndExecute(JiraHostConnectionAccessor.java:50) [?:?] at com.atlassian.sal.jira.rdbms.JiraHostConnectionAccessor.execute(JiraHostConnectionAccessor.java:35) [?:?] at com.atlassian.sal.core.rdbms.DefaultTransactionalExecutor.execute(DefaultTransactionalExecutor.java:42) [?:?] at com.atlassian.pocketknife.internal.querydsl.DatabaseAccessorImpl.execute(DatabaseAccessorImpl.java:66) [jira-email-processor-plugin-2.2.5_1475616652000.jar:?] at com.atlassian.pocketknife.internal.querydsl.DatabaseAccessorImpl.runInNewTransaction(DatabaseAccessorImpl.java:37) [jira-email-processor-plugin-2.2.5_1475616652000.jar:?] at com.atlassian.jira.internal.mail.processor.feature.processor.MailProcessorWorker.process(MailProcessorWorker.java:74) [jira-email-processor-plugin-2.2.5_1475616652000.jar:?] at com.atlassian.jira.internal.mail.processor.feature.processor.MailProcessorService.run(MailProcessorService.java:36) [jira-email-processor-plugin-2.2.5_1475616652000.jar:?] at com.atlassian.jira.internal.mail.processor.services.MailProcessorExecutor.run(MailProcessorExecutor.java:30) [jira-email-processor-plugin-2.2.5_1475616652000.jar:?] at com.atlassian.jira.internal.mail.processor.services.AbstractMailExecutor.execute(AbstractMailExecutor.java:42) [jira-email-processor-plugin-2.2.5_1475616652000.jar:?] at com.atlassian.jira.internal.mail.processor.services.MailJobRunner.runJob(MailJobRunner.java:35) [jira-email-processor-plugin-2.2.5_1475616652000.jar:?] at com.atlassian.scheduler.core.JobLauncher.runJob(JobLauncher.java:153) [atlassian-scheduler-core-1.7.0.jar:?] at com.atlassian.scheduler.core.JobLauncher.launchAndBuildResponse(JobLauncher.java:118) [atlassian-scheduler-core-1.7.0.jar:?] at com.atlassian.scheduler.core.JobLauncher.launch(JobLauncher.java:97) [atlassian-scheduler-core-1.7.0.jar:?] at com.atlassian.scheduler.caesium.impl.CaesiumSchedulerService.launchJob(CaesiumSchedulerService.java:443) [atlassian-scheduler-caesium-1.3.3.jar:?] at com.atlassian.scheduler.caesium.impl.CaesiumSchedulerService.executeClusteredJob(CaesiumSchedulerService.java:438) [atlassian-scheduler-caesium-1.3.3.jar:?] at com.atlassian.scheduler.caesium.impl.CaesiumSchedulerService.executeClusteredJobWithRecoveryGuard(CaesiumSchedulerService.java:462) [atlassian-scheduler-caesium-1.3.3.jar:?] at com.atlassian.scheduler.caesium.impl.CaesiumSchedulerService.executeQueuedJob(CaesiumSchedulerService.java:390) [atlassian-scheduler-caesium-1.3.3.jar:?] at com.atlassian.scheduler.caesium.impl.CaesiumSchedulerService$1.consume(CaesiumSchedulerService.java:285) [atlassian-scheduler-caesium-1.3.3.jar:?] at com.atlassian.scheduler.caesium.impl.CaesiumSchedulerService$1.consume(CaesiumSchedulerService.java:282) [atlassian-scheduler-caesium-1.3.3.jar:?] at com.atlassian.scheduler.caesium.impl.SchedulerQueueWorker.executeJob(SchedulerQueueWorker.java:65) [atlassian-scheduler-caesium-1.3.3.jar:?] at com.atlassian.scheduler.caesium.impl.SchedulerQueueWorker.executeNextJob(SchedulerQueueWorker.java:59) [atlassian-scheduler-caesium-1.3.3.jar:?] at com.atlassian.scheduler.caesium.impl.SchedulerQueueWorker.run(SchedulerQueueWorker.java:34) [atlassian-scheduler-caesium-1.3.3.jar:?] at java.lang.Thread.run(Thread.java:745) [?:1.8.0_77] Suppressed: java.sql.SQLException: Streaming result set com.mysql.jdbc.RowDataDynamic@5358d7a0 is still active. No statements may be issued when any streaming result sets are open and in use on a given connection. Ensure that you have called .close() on any active streaming result sets before attempting more queries. at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:934) [mysql-connector-java-5.1.19-bin.jar:?] at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:931) [mysql-connector-java-5.1.19-bin.jar:?] at com.mysql.jdbc.MysqlIO.checkForOutstandingStreamingData(MysqlIO.java:3236) [mysql-connector-java-5.1.19-bin.jar:?] at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2399) [mysql-connector-java-5.1.19-bin.jar:?] at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2651) [mysql-connector-java-5.1.19-bin.jar:?] at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2671) [mysql-connector-java-5.1.19-bin.jar:?] at com.mysql.jdbc.ConnectionImpl.rollbackNoChecks(ConnectionImpl.java:4857) [mysql-connector-java-5.1.19-bin.jar:?] at com.mysql.jdbc.ConnectionImpl.rollback(ConnectionImpl.java:4743) [mysql-connector-java-5.1.19-bin.jar:?] at org.apache.commons.dbcp2.DelegatingConnection.rollback(DelegatingConnection.java:488) [commons-dbcp2-2.1.jar:2.1] at org.apache.commons.dbcp2.DelegatingConnection.rollback(DelegatingConnection.java:488) [commons-dbcp2-2.1.jar:2.1] at org.ofbiz.core.entity.jdbc.interceptors.connection.DelegatingConnection.rollback(DelegatingConnection.java:71) [entityengine-1.2.3.jar:?] at com.atlassian.sal.core.rdbms.DefaultTransactionalExecutor.executeInternal(DefaultTransactionalExecutor.java:103) [?:?] ... 36 more Caused by: java.sql.SQLException: Streaming result set com.mysql.jdbc.RowDataDynamic@5358d7a0 is still active. No statements may be issued when any streaming result sets are open and in use on a given connection. Ensure that you have called .close() on any active streaming result sets before attempting more queries. at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:934) [mysql-connector-java-5.1.19-bin.jar:?] at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:931) [mysql-connector-java-5.1.19-bin.jar:?] at com.mysql.jdbc.MysqlIO.checkForOutstandingStreamingData(MysqlIO.java:3236) [mysql-connector-java-5.1.19-bin.jar:?] at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2399) [mysql-connector-java-5.1.19-bin.jar:?] at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2651) [mysql-connector-java-5.1.19-bin.jar:?] at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2671) [mysql-connector-java-5.1.19-bin.jar:?] at com.mysql.jdbc.ConnectionImpl.commit(ConnectionImpl.java:1698) [mysql-connector-java-5.1.19-bin.jar:?] at org.apache.commons.dbcp2.DelegatingConnection.commit(DelegatingConnection.java:364) [commons-dbcp2-2.1.jar:2.1] at org.apache.commons.dbcp2.DelegatingConnection.commit(DelegatingConnection.java:364) [commons-dbcp2-2.1.jar:2.1] at org.ofbiz.core.entity.jdbc.interceptors.connection.DelegatingConnection.commit(DelegatingConnection.java:66) [entityengine-1.2.3.jar:?] at com.atlassian.sal.core.rdbms.DefaultTransactionalExecutor.executeInternal(DefaultTransactionalExecutor.java:94) [?:?] ... 36 more
Or
2016-09-28 15:44:07,205 Caesium-1-3 ERROR anonymous [c.a.jira.database.DatabaseAccessorImpl] Unable to rollback SQL connection. java.sql.SQLException: Streaming result set com.mysql.jdbc.RowDataDynamic@5da316b7 is still active. No statements may be issued when any streaming result sets are open and in use on a given connection. Ensure that you have called .close() on any active streaming result sets before attempting more queries. at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:868) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:864) at com.mysql.jdbc.MysqlIO.checkForOutstandingStreamingData(MysqlIO.java:3207) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2445) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2673) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2545) at com.mysql.jdbc.ConnectionImpl.rollbackNoChecks(ConnectionImpl.java:4698) at com.mysql.jdbc.ConnectionImpl.rollback(ConnectionImpl.java:4590) at org.apache.commons.dbcp2.DelegatingConnection.rollback(DelegatingConnection.java:488) at org.apache.commons.dbcp2.DelegatingConnection.rollback(DelegatingConnection.java:488) at org.ofbiz.core.entity.jdbc.interceptors.connection.DelegatingConnection.rollback(DelegatingConnection.java:71) at com.atlassian.jira.database.DatabaseAccessorImpl.executeQuery(DatabaseAccessorImpl.java:71) ... 2 filtered at java.lang.reflect.Method.invoke(Method.java:498) at com.atlassian.plugin.util.ContextClassLoaderSettingInvocationHandler.invoke(ContextClassLoaderSettingInvocationHandler.java:26) at com.sun.proxy.$Proxy373.executeQuery(Unknown Source) ... 2 filtered at java.lang.reflect.Method.invoke(Method.java:498) at com.atlassian.plugin.osgi.bridge.external.HostComponentFactoryBean$DynamicServiceInvocationHandler.invoke(HostComponentFactoryBean.java:136) at com.sun.proxy.$Proxy373.executeQuery(Unknown Source) at com.atlassian.sal.jira.rdbms.JiraHostConnectionAccessor.borrowConnectionAndExecute(JiraHostConnectionAccessor.java:50) at com.atlassian.sal.jira.rdbms.JiraHostConnectionAccessor.execute(JiraHostConnectionAccessor.java:35) at com.atlassian.sal.core.rdbms.DefaultTransactionalExecutor.execute(DefaultTransactionalExecutor.java:42) at com.atlassian.pocketknife.internal.querydsl.DatabaseAccessorImpl.execute(DatabaseAccessorImpl.java:66) at com.atlassian.pocketknife.internal.querydsl.DatabaseAccessorImpl.runInNewTransaction(DatabaseAccessorImpl.java:37) at com.atlassian.jira.internal.mail.processor.feature.processor.MailProcessorWorker.process(MailProcessorWorker.java:74) at com.atlassian.jira.internal.mail.processor.feature.processor.MailProcessorService.run(MailProcessorService.java:36) at com.atlassian.jira.internal.mail.processor.services.MailProcessorExecutor.run(MailProcessorExecutor.java:30) at com.atlassian.jira.internal.mail.processor.services.AbstractMailExecutor.execute(AbstractMailExecutor.java:42) at com.atlassian.jira.internal.mail.processor.services.MailJobRunner.runJob(MailJobRunner.java:35) at com.atlassian.scheduler.core.JobLauncher.runJob(JobLauncher.java:153) at com.atlassian.scheduler.core.JobLauncher.launchAndBuildResponse(JobLauncher.java:118) at com.atlassian.scheduler.core.JobLauncher.launch(JobLauncher.java:97) at com.atlassian.scheduler.caesium.impl.CaesiumSchedulerService.launchJob(CaesiumSchedulerService.java:443) at com.atlassian.scheduler.caesium.impl.CaesiumSchedulerService.executeClusteredJob(CaesiumSchedulerService.java:438) at com.atlassian.scheduler.caesium.impl.CaesiumSchedulerService.executeClusteredJobWithRecoveryGuard(CaesiumSchedulerService.java:462) at com.atlassian.scheduler.caesium.impl.CaesiumSchedulerService.executeQueuedJob(CaesiumSchedulerService.java:390) at com.atlassian.scheduler.caesium.impl.CaesiumSchedulerService$1.consume(CaesiumSchedulerService.java:285) at com.atlassian.scheduler.caesium.impl.CaesiumSchedulerService$1.consume(CaesiumSchedulerService.java:282) at com.atlassian.scheduler.caesium.impl.SchedulerQueueWorker.executeJob(SchedulerQueueWorker.java:65) at com.atlassian.scheduler.caesium.impl.SchedulerQueueWorker.executeNextJob(SchedulerQueueWorker.java:59) at com.atlassian.scheduler.caesium.impl.SchedulerQueueWorker.run(SchedulerQueueWorker.java:34) at java.lang.Thread.run(Thread.java:745)
Notes
It seems that the above SQL error does not affect the issue creation.
Attachments
Issue Links
- was cloned as
-
TESLA-958 Loading...