JON data purge job fails due to ERROR: canceling statement due to statement timeout

Solution Unverified - Updated -

Issue

  • In my PostgresSQL log, I am seeing this:

    ERROR:  canceling statement due to statement timeout
STATEMENT:  delete from RHQ_EVENT where TIMESTAMP<$1

  • The RHQ server log contains:

    ERROR [org.hibernate.util.JDBCExceptionReporter] ERROR: canceling statement due to statement timeout
ERROR [org.rhq.enterprise.server.scheduler.jobs.DataPurgeJob] Failed to purge event data. Cause: javax.ejb.EJBException: javax.persistence.PersistenceException: org.hibernate.exception.GenericJDBCException: could not execute update query
javax.ejb.EJBException: javax.persistence.PersistenceException: org.hibernate.exception.GenericJDBCException: could not execute update query
Caused by: javax.persistence.PersistenceException: org.hibernate.exception.GenericJDBCException: could not execute update query
Caused by: org.hibernate.exception.GenericJDBCException: could not execute update query
Caused by: org.postgresql.util.PSQLException: ERROR: canceling statement due to statement timeout

  • Is it possible that the maintenance on the rhq_event table is timing out?

  • The event data table is not being cleaned/maintained properly
  • Data purge job for events fails due to the query taking too long

Environment

  • Red Hat JBoss Operations Network (ON) 3.1
  • JBoss ON system using PostgreSQL database back-end
  • Data purge job is executed
  • PostgreSQL database server configuration statement_timeout property is set to a non-zero value:
    • set globally in postgresql.conf
    • OR set for the database user

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