Uploaded image for project: 'Jira Service Management Data Center'
  1. Jira Service Management Data Center
  2. JSDSERVER-4358

When using MySQL database an exception is thrown by mail processor

    XMLWordPrintable

Details

    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

      1. Setup a new JSD 3.2.1 instance and connect to a MySQL database
      2. Setup a new Service Desk project and a new mail channel
      3. 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

          Activity

            People

              mmcmahon Matthew McMahon (Inactive)
              cmao Chen Mao (Inactive)
              Votes:
              3 Vote for this issue
              Watchers:
              8 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Backbone Issue Sync