Description
I have the following issue with failures on the maintenance job to clean logs on version 4.11:
Deleted 547599 records from grouper_loader_log older than 3 days old. Deleted 2056 records from grouper_change_log_entry older than 3 days old. (1709042438322000). Deleted 16 instrumentation records older than 30 days old. (1706709638429). Deleted 0 instrumentation instances older than 365 days old. Configured to not delete records from audit_entry table with null logged in member id. Configured to not delete records from audit_entry table. fixValuesCount: 0fixAssignsCount: 0Configured to not delete records from DeletedPointInTimeObjects.
Error in verifyTableIdIndexes: java.lang.RuntimeException: Problem with query in listSelect: select id from grouper_sync_dep_group_group where id_index is null order by id,
Problem in HibernateSession: HibernateSession (6c5e0cb2): new, notReadonly, READ_WRITE_NEW, notActiveTransaction, session (35b82c40)
at edu.internet2.middleware.grouper.hibernate.BySqlStatic$4.callback(BySqlStatic.java:390)
at edu.internet2.middleware.grouper.hibernate.HibernateSession.callbackHibernateSession(HibernateSession.java:722)
at edu.internet2.middleware.grouper.hibernate.BySqlStatic.listSelect(BySqlStatic.java:333)
at edu.internet2.middleware.grouper.app.loader.GrouperDaemonDeleteOldRecords.verifyTableIdIndexes(GrouperDaemonDeleteOldRecords.java:902)
at edu.internet2.middleware.grouper.app.loader.GrouperDaemonDeleteOldRecords.maintenanceDeleteOldRecords(GrouperDaemonDeleteOldRecords.java:191)
at edu.internet2.middleware.grouper.app.loader.GrouperLoaderType$4.runJob(GrouperLoaderType.java:288)
at edu.internet2.middleware.grouper.app.loader.GrouperLoaderJob.runJob(GrouperLoaderJob.java:554)
at edu.internet2.middleware.grouper.app.loader.GrouperLoaderJob$1.callback(GrouperLoaderJob.java:355)
at edu.internet2.middleware.grouper.GrouperSession.callbackGrouperSession(GrouperSession.java:999)
at edu.internet2.middleware.grouper.GrouperSession.internal_callbackRootGrouperSession(GrouperSession.java:1068)
at edu.internet2.middleware.grouper.GrouperSession.internal_callbackRootGrouperSession(GrouperSession.java:1035)
at edu.internet2.middleware.grouper.app.loader.GrouperLoaderJob.execute(GrouperLoaderJob.java:90)
at org.quartz.core.JobRunShell.run(JobRunShell.java:202)
at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:573)
Caused by: org.postgresql.util.PSQLException: ERROR: column "id" does not exist
Position: 8
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2725)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2412)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:371)
at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:502)
at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:419)
at org.postgresql.jdbc.PgPreparedStatement.executeWithFlags(PgPreparedStatement.java:194)
at org.postgresql.jdbc.PgPreparedStatement.executeQuery(PgPreparedStatement.java:137)
at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:431)
at edu.internet2.middleware.grouper.hibernate.BySqlStatic$4.callback(BySqlStatic.java:357)
... 13 more
2 replies
Michael Gettes
4 hours ago
@mchyzer
There is no id column on this table.
Michael Gettes
4 hours ago
there is a column called id_index