Uploaded image for project: 'MidPoint'
  1. MidPoint
  2. MID-4632

Audit cleanup task throws exception: ERROR: relation "ht_m_audit_event" does not exist

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: 3.8
    • Fix Version/s: 3.8
    • Component/s: None
    • Labels:
      None
    • Environment:

      Postgresql: Version: 9.5+173ubuntu0.1

    • Subscription:
      Internal
    • Git Revision:
      git-v3.8devel-1278-g6390c15

      Description

      2018-05-10 15:30:09,472 [] [midPointScheduler_Worker-1] INFO (org.hibernate.dialect.Dialect): HHH000400: Using dia
      lect: com.evolveum.midpoint.repo.sql.util.MidPointPostgreSQLDialect
      2018-05-10 15:30:09,505 [] [midPointScheduler_Worker-1] INFO (com.evolveum.midpoint.repo.sql.SqlAuditServiceImpl):
       Starting audit cleanup, deleting up to Sat Feb 10 15:30:09 CET 2018 (duration '-P3M'), batch size 500.
      2018-05-10 15:30:09,510 [] [midPointScheduler_Worker-1] INFO (com.evolveum.midpoint.repo.sql.SqlAuditServiceImpl):
       Audit cleanup based on age finished; deleted 0 entries in 0 seconds.
      2018-05-10 15:30:09,514 [] [midPointScheduler_Worker-1] ERROR (com.evolveum.midpoint.model.impl.cleanup.CleanUpTaskHandler): Audit cleanup: error executing work
      com.evolveum.midpoint.util.exception.SystemException: error executing work
              at com.evolveum.midpoint.repo.sql.helpers.BaseHelper.handleGeneralRuntimeException(BaseHelper.java:174)
              at com.evolveum.midpoint.repo.sql.SqlAuditServiceImpl.batchDeletionAttempt(SqlAuditServiceImpl.java:540)
              at com.evolveum.midpoint.repo.sql.SqlAuditServiceImpl.cleanupAuditMaxAge(SqlAuditServiceImpl.java:412)
              at com.evolveum.midpoint.repo.sql.SqlAuditServiceImpl.cleanupAudit(SqlAuditServiceImpl.java:368)
              at com.evolveum.midpoint.init.AuditServiceProxy.cleanupAudit(AuditServiceProxy.java:113)
              at com.evolveum.midpoint.model.impl.cleanup.CleanUpTaskHandler.run(CleanUpTaskHandler.java:116)
              at com.evolveum.midpoint.task.quartzimpl.execution.JobExecutor.executePlainTaskHandler(JobExecutor.java:66
      7)
              at com.evolveum.midpoint.task.quartzimpl.execution.JobExecutor.executeHandler(JobExecutor.java:656)
              at com.evolveum.midpoint.task.quartzimpl.execution.JobExecutor.executeRecurrentTask(JobExecutor.java:535)
              at com.evolveum.midpoint.task.quartzimpl.execution.JobExecutor.execute(JobExecutor.java:190)
              at org.quartz.core.JobRunShell.run(JobRunShell.java:202)
              at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:588)
      Caused by: org.hibernate.exception.GenericJDBCException: error executing work
              at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:47)
              at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:111)
              at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:97)
              at org.hibernate.engine.jdbc.internal.JdbcCoordinatorImpl.coordinateWork(JdbcCoordinatorImpl.java:325)
              at org.hibernate.internal.SessionImpl.doWork(SessionImpl.java:2342)
              at org.hibernate.internal.SessionImpl.doWork(SessionImpl.java:2327)
              at com.evolveum.midpoint.repo.sql.SqlAuditServiceImpl.createTemporaryTable(SqlAuditServiceImpl.java:621)
              at com.evolveum.midpoint.repo.sql.SqlAuditServiceImpl.batchDeletionAttempt(SqlAuditServiceImpl.java:503)
              ... 10 common frames omitted
      Caused by: org.postgresql.util.PSQLException: ERROR: current transaction is aborted, commands ignored until end of transaction block
              at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2455)
              at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2155)
              at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:288)
              at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:430)
              at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:356)
              at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:303)
              at org.postgresql.jdbc.PgStatement.executeCachedSql(PgStatement.java:289)
      . . .
      Caused by: org.postgresql.util.PSQLException: ERROR: relation "ht_m_audit_event" does not exist
        Position: 16
              at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2455)
              at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2155)
              at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:288)
              at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:430)
              at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:356)
              at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:303)
              at org.postgresql.jdbc.PgStatement.executeCachedSql(PgStatement.java:289)
              at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:266)
              at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:262)
              at com.zaxxer.hikari.pool.ProxyStatement.execute(ProxyStatement.java:95)
              at com.zaxxer.hikari.pool.HikariProxyStatement.execute(HikariProxyStatement.java)
              at com.evolveum.midpoint.repo.sql.SqlAuditServiceImpl.lambda$createTemporaryTable$2(SqlAuditServiceImpl.java:625)
              ... 18 common frames omitted
      2018-05-10 15:30:09,528 [] [midPointScheduler_Worker-1] INFO (com.evolveum.midpoint.task.quartzimpl.TaskManagerQuartzImpl): Starting cleanup for closed tasks deleting up to Tue Apr 10 15:30:09 CEST 2018 (duration '-P1M').
      2018-05-10 15:30:09,558 [] [midPointScheduler_Worker-1] INFO (com.evolveum.midpoint.task.quartzimpl.TaskManagerQuartzImpl): Task cleanup procedure finished. Successfully deleted 0 tasks; there were problems with deleting 0 tasks.
      2018-05-10 15:30:09,919 [] [midPointScheduler_Worker-2] ERROR (org.hibernate.internal.ExceptionMapperStandardImpl): HHH000346: Error during managed flush [org.hibernate.exception.LockAcquisitionException: could not execute batch]
      2018-05-10 15:31:27,590 [] [http-nio-8080-exec-1] INFO (org.apache.catalina.core.ContainerBase.[Tomcat].[localhost].[/midpoint]): Initializing Spring FrameworkServlet 'dispatcherServlet'
      

        Attachments

          Activity

            People

            Assignee:
            vix Ivan Noris
            Reporter:
            vix Ivan Noris
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved: