Receiving repeated SQL errors Lock request time out period exceeded in JBoss EAP 7
Issue
- Receiving repeated SQL errors.
- We started receiving repeated errors:
16:01:22,067 WARN [org.hibernate.engine.jdbc.spi.SqlExceptionHelper] (Thread-115) SQL Error: 1222, SQLState: S00051
16:01:22,067 ERROR [org.hibernate.engine.jdbc.spi.SqlExceptionHelper] (Thread-115) Lock request time out period exceeded.
16:01:22,067 WARN [org.hibernate.engine.jdbc.spi.SqlExceptionHelper] (Thread-115) SQL Warning Code: 3621, SQLState: S0000
16:01:22,067 WARN [org.hibernate.engine.jdbc.spi.SqlExceptionHelper] (Thread-115) The statement has been terminated.
16:08:58,958 INFO [io.undertow.servlet] (default task-32) User authenticated via the browser's SSO functionality
(xyz\abc.def-ghlijk).
16:09:01,739 INFO [io.undertow.servlet] (default task-1) User is already authenticated (abc.def-ghlijk).
16:09:06,302 INFO [stdout] (default task-62) Branch changed!
16:12:38,008 INFO [io.undertow.servlet] (default task-4) User is already authenticated (abc.def-ghlijk).
16:12:38,805 INFO [io.undertow.servlet] (default task-44) User is already authenticated (abc.def-ghlijk).
16:13:06,134 INFO [xx.yy.zzz.TestServiceImpl] (default task-38) xyz Cluster: Register xxx: /xyz
16:14:22,666 WARN [org.hibernate.engine.jdbc.spi.SqlExceptionHelper] (Thread-115) SQL Error: 1222, SQLState: S00051
16:14:22,666 ERROR [org.hibernate.engine.jdbc.spi.SqlExceptionHelper] (Thread-115) Lock request time out period exceeded.
16:14:22,666 WARN [org.hibernate.engine.jdbc.spi.SqlExceptionHelper] (Thread-115) SQL Warning Code: 3621, SQLState: S0000
16:14:22,666 WARN [org.hibernate.engine.jdbc.spi.SqlExceptionHelper] (Thread-115) The statement has been terminated.
Environment
- Red Hat JBoss Enterprise Application Platform (EAP)
- 7.0.x
Subscriber exclusive content
A Red Hat subscription provides unlimited access to our knowledgebase of over 48,000 articles and solutions.
Welcome! Check out the Getting Started with Red Hat page for quick tours and guides for common tasks.
