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

Current Customers and Partners

Log in for full access

Log In

New to Red Hat?

Learn more about Red Hat subscriptions

Using a Red Hat product through a public cloud?

How to access this content