Hide Forgot
Date of First Response: 2008-02-13 13:22:50 project_key: SOA Seeing this exception (server.log attached) - in CR3 with bmp_orchestration2 - with HSQLDB. Steps to recreate: 1) cp jboss-soa-p.4.2.0/jboss-as/tools/resources/jbpm-console-development.war jboss-soa-p.4.2.0/jboss-as/server/all/deploy/jbpm.esb/jbpm-console.war 2) ant deploy 3) ant deployProcess 4) ant startProcess 13:20:51,135 ERROR [JDBCExceptionReporter] Concurrent update in table JBPM_TOKEN: another transaction has updated or deleted the same row [90131-66] 13:20:51,136 ERROR [AbstractFlushingEventListener] Could not synchronize database state with session org.hibernate.exception.GenericJDBCException: could not update: [org.jbpm.graph.exe.Token#1] at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:103) at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:91) at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43) at org.hibernate.persister.entity.AbstractEntityPersister.update(AbstractEntityPersister.java:2425) at org.hibernate.persister.entity.AbstractEntityPersister.updateOrInsert(AbstractEntityPersister.java:2307)
Server log - 'all' server
Attachment: Added: server.log.gz
Link: Added: This issue is related to SOA-409
Link: Added: This issue is related to SOA-410
Attachment: Added: server.log
Seeing the sam errors/warnings with Postgresql (production config)
Attachment: Added: Feb12_embedded_server.log.bz2 Attachment: Added: Feb12_standalone_server.log.bz2
Attachment: Added: Feb12_embedded_all_hsqldb_server.log.bz2 Attachment: Added: Feb12_production_hsqldb_server.log.bz2
I tried this one 100 times with a local mysql instance to avoid network delays and it didn't occur. I tried on 2 CPU dual core AMD system. So it doesn't occur with mysql.
Link: Added: This issue related SOA-415
All tier1 databases tested to not produce any errors in 100 runs. So probably it's hsqldb that doesn't support transactions. Marking as passed in testify.
Link: Removed: This issue is related to SOA-409
With the GA bits - on a multi-processor system - seeing the exception first listed in: http://jira.jboss.com/jira/browse/SOA-417#action_12399166 WARN [org.jboss.soa.esb.listeners.message.ActionProcessingPipeline] Unexpected exception caught while processing the action pipeline And this error: ERROR [org.jboss.resource.adapter.jms.inflow.JmsServerSession] Unexpected error delivering message delegator->JBossMessage[29]:PERSISTENT, deliveryId=7 org.jbpm.JbpmException: couldn't execute org.jboss.soa.esb.services.jbpm.cmd.CallbackCommand@a6cac9 server.log file is attached - this is with an out-of-the-box configuration using hsqldb/h2.
This is similar to the latest attached files to http://jira.jboss.com/jira/browse/SOA-410 in that with the GA bits, the error is now not being seen with postgresql. See attached server.log
Question - is this also a problem with H2 - ala: http://jira.jboss.com/jira/browse/SOA-409#action_12403386
The problem does seem to be specific to an out-of-the box configuration with hsqldb/h2. With postgres as the DB, the problem is not seen. See attached server.log file. So - Alex's comment: http://jira.jboss.com/jira/browse/SOA-417#action_12399441 Is correct - as hsqldb/h2 are not tier1 DBs - but - the error will be seen by customers running the quickstart with the out-of-the box configuration of hsqldb/h2.
Link: Added: This issue is a dependency of SOA-480
Time to close this JIRA - the problem never had any real functional/operational impact. And - with CP02_CR5 - it's not reproducible - see attached server log file.
Link: Added: This issue related SOA-869