Blocked jobs with stack trace in ACT_RU_JOB

[jaylemur]

Hi

We got some kinds of blocked jobs in Table ACT_RU_JOB :
From TYPE_ "message"
And with the Exception :
### Error querying database.  Cause: java.sql.SQLException: The transaction is no longer active - status: 'Marked rollback. [Reason=weblogic.transaction.internal.TimedOutException: Transaction timed out after 29 seconds
BEA1-7959EDD1F1254D80F400]'. No f…

You can find the linked stack trace from Table ACT_GE_BYTEARRAY in the attached file.

It seems that the error occurs when Activiti makes a request to it's own tables.

What does mean a transaction timeout in this case ?   Is it the Activiti request which lasts over 30 seconds ?
Or it is due to a previous ServiceTask which lasts too long ?

Any hint are welcome.

Thanks in advance.

Cheers,
Patrick Brühlmann

[silvioneto]

Do you have a previous ServiceTask?

If it have changed the database on its own transaction, it may be locking the tables activiti is trying to read. Just a guess…

[jbarrez]

What database are you using? It seems that it doesn't allow a read on itself… which sounds very weird.