Project is springboot + activiti

When class is expected to appoint a task to class committee email reminder
When not add mail task running ok
After adding email module, mail sent, process cannot continue, have a look at the console, errors as follows

 
ErsistenceException: 
# # # Error querying the database. Cause: org. Apache. Ibatis. Executor. ExecutorException: Error preparing statement. The Cause: org. Springframework. Transaction. TransactionTimedOutException: transaction timed out: deadline was Thu Apr 09 11:56:19 CST 2020 
# # # The error may exist in org/activiti/db/mapping/entity/Task. The XML 
# # # The error may involve org. Activiti. Engine. The impl. Persistence. Entity. TaskEntity. SelectTasksByExecutionId 
# # # The error occurred while executing a query 
# # # SQL: select distinct T * from ACT_RU_TASK T where T.E XECUTION_ID_=? 
# # # Cause: org. Apache. Ibatis. Executor. ExecutorException: Error preparing statement. The Cause: org. Springframework. Transaction. TransactionTimedOutException: transaction timed out: deadline was Thu Apr 09 11:56:19 CST 2020 

CodePudding user response:

No man or woman? Big help

CodePudding user response:

Code????????

CodePudding user response:

refer to the second floor weixin_42573980 response:

code??????

Which part of the code should be posted??????

CodePudding user response:

# # # SQL: select distinct T * from ACT_RU_TASK T where T.E XECUTION_ID_=?

This near,,,

CodePudding user response:

You this email task, activiti email service, or the implementation

CodePudding user response:

Error message is to perform a query timeout, the likelihood is table is locked, or have other insert, update the transaction did not submit | rolled back

CodePudding user response:

reference 5 floor dkwuxiang reply:

you this email task, when activiti email service, or since the implementation of

Is the mail task activiti

CodePudding user response:

reference 4 floor weixin_42573980 response:

# # # SQL: select distinct T * from ACT_RU_TASK T where T.E XECUTION_ID_=?

This near,,,

I haven't written the code...