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, tools, and much more.