HHH000388: Unsuccessful: create sequence hibernate_sequence while starting BRMS in EAP6

Solution Unverified - Updated -

Environment

  • Red Hat JBoss BRMS
    • 5.3.1
  • Red Hat JBoss Enterprise Application Platform (EAP)
    • 6.x
  • Oracle DB

Issue

  • I found the below ERROR logs when I start BRMS 5.3.1 on top of JBoss EAP 6, I see this error only on 1st boot with clean database. Once tables/sequences are created, the logs will not be raised.
ERROR [org.hibernate.tool.hbm2ddl.SchemaUpdate] (ServerService Thread Pool -- 60) HHH000388: Unsuccessful: create sequence hibernate_sequence
ERROR [org.hibernate.tool.hbm2ddl.SchemaUpdate] (ServerService Thread Pool -- 60) ORA-00955: name is already used by an existing object

Resolution

The error log is ignorable unless you see other ERROR logs.

Root Cause

This error was thrown when business-central-server.war and jbpm-human-task.war were being deployed concurrently. They create different tables but 'hibernate_sequence' is shared. The error message means that one thread (jbpm-human-task.war) found that 'hibernate_sequence' was already created by the other thread. But the sequence will be shared anyway so you can ignore the error. Raising an ERROR level log is not nice but it's difficult to suppress in this case.

Diagnostic Steps

  • Check server.log and Confirm if two threads are executing schema update concurrently, like as:
INFO  [org.hibernate.tool.hbm2ddl.SchemaUpdate] (ServerService Thread Pool -- 67) HHH000396: Updating schema
INFO  [org.hibernate.tool.hbm2ddl.SchemaUpdate] (ServerService Thread Pool -- 60) HHH000396: Updating schema
...

This solution is part of Red Hat’s fast-track publication program, providing a huge library of solutions that Red Hat engineers have created while supporting our customers. To give you the knowledge you need the instant it becomes available, these articles may be presented in a raw and unedited form.

Close

Welcome! Check out the Getting Started with Red Hat page for quick tours and guides for common tasks.