Receiving repeated SQL errors Lock request time out period exceeded in JBoss EAP 7

Solution Unverified - Updated -

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.

Current Customers and Partners

Log in for full access

Log In