[ https://jira.jboss.org/jira/browse/JBPM-1764?page=com.atlassian.jira.plug... ] Alejandro Guizar updated JBPM-1764: ----------------------------------- Summary: Deadlocks make job execution tests fail on Sybase (was: JobExecutorDbTest does not work on Sybase) Issue Type: Task (was: Bug) Environment: Linux Sybase ASE 15.0.2 jTDS 1.2.2 was: Linux Sybase ASE 12.5 jTDS 1.2.2 Description: While running org.jbpm.job.executor.JobExecutorDbTest, the following error prevents job execution threads from completing jobs within the predefined threshold of 1 minute. 2008-09-29 19:03:41,078 WARN [org.hibernate.util.JDBCExceptionReporter] SQL Error: 1205, SQLState: S1000 2008-09-29 19:03:41,078 ERROR [org.hibernate.util.JDBCExceptionReporter] Your server command (family id #0, process id #77) encountered a deadlock situation. Please re-run your command. Other tests that fail due to the same cause are: SubProcessPlusConcurrencyDbTest JBPM1072Test JBPM1755Test JBPM983Test LockingTest JobExecutorCustomizationTest The tests will be excluded until this issue is resolved. The hibernate.order_updates property might help solve the problem. was: While running org.jbpm.job.executor.JobExecutorDbTest, the following error prevents job execution threads from completing jobs within the predefined threshold of 1 minute. 2008-09-29 19:03:41,078 WARN [org.hibernate.util.JDBCExceptionReporter] SQL Error: 1205, SQLState: S1000 2008-09-29 19:03:41,078 ERROR [org.hibernate.util.JDBCExceptionReporter] Your server command (family id #0, process id #77) encountered a deadlock situation. Please re-run your command. The test will be excluded until this issue is resolved. The hibernate.order_updates property might help solve the problem. -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: https://jira.jboss.org/jira/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira

[ https://jira.jboss.org/jira/browse/JBPM-1764?page=com.atlassian.jira.plug... ] Alejandro Guizar commented on JBPM-1764: ---------------------------------------- Further investigation revealed that the tests above can be made to pass if the lock scheme is changed from "allpages" to "datarows" as described in the following page. http://www.jboss.org/community/docs/DOC-11160 -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: https://jira.jboss.org/jira/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira

[ https://jira.jboss.org/jira/browse/JBPM-1764?page=com.atlassian.jira.plug... ] Thomas Diesler updated JBPM-1764: --------------------------------- Assignee: Heiko Braun (was: Alejandro Guizar) Priority: Critical (was: Major) Heiko, could you please work with Alejandro to resolve this? -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: https://jira.jboss.org/jira/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira

[ https://jira.jboss.org/jira/browse/JBPM-1764?page=com.atlassian.jira.plug... ] Heiko Braun resolved JBPM-1764. ------------------------------- Resolution: Done Row level locking configuration works: sp_configure "lock scheme",0,datarows -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: https://jira.jboss.org/jira/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira

[ https://jira.jboss.org/jira/browse/JBPM-1764?page=com.atlassian.jira.plug... ] Heiko Braun resolved JBPM-1764. ------------------------------- Resolution: Done -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: https://jira.jboss.org/jira/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira