AnsweredAssumed Answered

JDBC commit failed Exception after trying to send notification mails to group of users (more than 100) in a custom workflow serviceTask

Question asked by mtsiak on Dec 2, 2016
Latest reply on Dec 7, 2016 by mtsiak

The service task of our workflow is like:

var mail = actions.create("mail");
mail.parameters.to_many = receivers; // array of more than 100 users

  ...

mail.executeAsynchronously(bpm_package);

The exeption we get every 10 minutes:

2016-12-01 18:13:29,318  ERROR [hibernate.transaction.JDBCTransaction] [mailAsyncAction8] JDBC commit failed

com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Communications link failure during commit(). Transaction resolution unknown.

        at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)

        at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)

        at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)

        at java.lang.reflect.Constructor.newInstance(Constructor.java:408)

        at com.mysql.jdbc.Util.handleNewInstance(Util.java:408)

        at com.mysql.jdbc.Util.getInstance(Util.java:383)

        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1023)

        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:997)

        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:983)

        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:928)

        at com.mysql.jdbc.ConnectionImpl.commit(ConnectionImpl.java:1748)

        at org.apache.commons.dbcp.DelegatingConnection.commit(DelegatingConnection.java:334)

        at org.apache.commons.dbcp.DelegatingConnection.commit(DelegatingConnection.java:334)

        at org.apache.commons.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.commit(PoolingDataSource.java:211)

        at org.hibernate.transaction.JDBCTransaction.commitAndResetAutoCommit(JDBCTransaction.java:139)

        at org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:115)

        at org.springframework.orm.hibernate3.HibernateTransactionManager.doCommit(HibernateTransactionManager.java:657)

        at org.springframework.transaction.support.AbstractPlatformTransactionManager.processCommit(AbstractPlatformTransactionManager.java:755)

        at org.springframework.transaction.support.AbstractPlatformTransactionManager.commit(AbstractPlatformTransactionManager.java:724)

        at org.springframework.transaction.interceptor.TransactionAspectSupport.commitTransactionAfterReturning(TransactionAspectSupport.java:475)

        at org.alfresco.util.transaction.SpringAwareUserTransaction.commit(SpringAwareUserTransaction.java:482)

        at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:479)

        at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:326)

        at org.alfresco.repo.action.AsynchronousActionExecutionQueueImpl$ActionExecutionWrapper$1.doWork(AsynchronousActionExecutionQueueImpl.java:437)

        at org.alfresco.repo.tenant.TenantUtil.runAsWork(TenantUtil.java:119)

        at org.alfresco.repo.tenant.TenantUtil.runAsTenant(TenantUtil.java:88)

        at org.alfresco.repo.tenant.TenantUtil$1.doWork(TenantUtil.java:62)

        at org.alfresco.repo.security.authentication.AuthenticationUtil.runAs(AuthenticationUtil.java:548)

        at org.alfresco.repo.tenant.TenantUtil.runAsUserTenant(TenantUtil.java:58)

        at org.alfresco.repo.action.AsynchronousActionExecutionQueueImpl$ActionExecutionWrapper.run(AsynchronousActionExecutionQueueImpl.java:440)

        at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)

        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)

        at java.lang.Thread.run(Thread.java:745)

Any ideas;

 

Thanks in advance.

Outcomes