CHANGE_LOG_consumer_sqlCacheGroup fails when deleting a list name

XMLWordPrintable

    • Type: Bug
    • Resolution: Unresolved
    • Priority: Minor
    • None
    • Affects Version/s: 5.12.2
    • Component/s: daemon
    • None

      HQL "select  from OBJECT" indicates running a GcDbAccess query without setting the SQL.

       

      method: dispatchEventList, eventCount: 1, lastSequenceAvailable: 1789, removeCacheCount: 1, eventsSkipped: 0, tookMillis: 12399Error: java.lang.RuntimeException: Couldn't process any records: type: consumer, finalLog: true, state: sendToPublisher, consumerName: sqlCacheGroup, currentSequenceNumber: null, elFilter: event.eventType eq 'ATTRIBUTE_ASSIGN_VALUE_ADD' || event.eventType eq 'ATTRIBUTE_ASSIGN_VALUE_DELETE', publisherClass: edu.internet2.middleware.grouper.sqlCache.EsbPublisherSqlCache, exception: java.lang.RuntimeException: sql:  select  from OBJECT;, args: ArrayList size: 3: [0]: 1728015448879000
      		 
      [1]: etc:sqlCacheable:sqlCacheableListName
      		 
      [2]: 2caa2e9225ea434ba1f216bf33f30815
      		 
       
      		 
      	at edu.internet2.middleware.grouperClient.jdbc.GcDbAccess.callbackResultSet(GcDbAccess.java:2497)
      		 
      	at edu.internet2.middleware.grouperClient.jdbc.GcDbAccess.selectList(GcDbAccess.java:1816)
      		 
      	at edu.internet2.middleware.grouperClient.jdbc.GcDbAccess.selectList(GcDbAccess.java:1690)
      		 
      	at edu.internet2.middleware.grouperClient.jdbc.GcDbAccess.selectList(GcDbAccess.java:1665)
      		 
      	at edu.internet2.middleware.grouper.sqlCache.SqlCacheGroupDao.retrieveNonexistingAttributeAssignments(SqlCacheGroupDao.java:296)
      		 
      	at edu.internet2.middleware.grouper.sqlCache.EsbPublisherSqlCache.dispatchEventList(EsbPublisherSqlCache.java:157)
      		 
      	at edu.internet2.middleware.grouper.changeLog.esb.consumer.EsbConsumer.processChangeLogEntries(EsbConsumer.java:511)
      		 
      	at edu.internet2.middleware.grouper.changeLog.ChangeLogHelper.processRecords(ChangeLogHelper.java:415)
      		 
      	at edu.internet2.middleware.grouper.changeLog.ChangeLogHelper.processRecordsWrapper(ChangeLogHelper.java:250)
      		 
      	at edu.internet2.middleware.grouper.app.loader.GrouperLoaderType$5.runJob(GrouperLoaderType.java:508)
      		 
      	at edu.internet2.middleware.grouper.app.loader.GrouperLoaderJob.runJob(GrouperLoaderJob.java:558)
      		 
      	at edu.internet2.middleware.grouper.app.loader.GrouperLoaderJob$1.callback(GrouperLoaderJob.java:357)
      		 
      	at edu.internet2.middleware.grouper.GrouperSession.callbackGrouperSession(GrouperSession.java:1063)
      		 
      	at edu.internet2.middleware.grouper.GrouperSession.internal_callbackRootGrouperSession(GrouperSession.java:1132)
      		 
      	at edu.internet2.middleware.grouper.GrouperSession.internal_callbackRootGrouperSession(GrouperSession.java:1099)
      		 
      	at edu.internet2.middleware.grouper.app.loader.GrouperLoaderJob.execute(GrouperLoaderJob.java:92)
      		 
      	at org.quartz.core.JobRunShell.run(JobRunShell.java:202)
      		 
      	at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:573)
      		 
      Caused by: java.lang.RuntimeException: Problem attaching param index: 1, param: '1728015448879000'
      		 
      	at edu.internet2.middleware.grouperClient.jdbc.GcBoundDataConversionImpl.addBindVariableToStatement(GcBoundDataConversionImpl.java:70)
      		 
      	at edu.internet2.middleware.grouperClient.jdbc.GcDbAccess.callbackResultSet(GcDbAccess.java:2457)
      		 
      	... 17 more
      		 
      Caused by: org.postgresql.util.PSQLException: The column index is out of range: 1, number of columns: 0.
      		 
      	at org.postgresql.core.v3.SimpleParameterList.bind(SimpleParameterList.java:70)
      		 
      	at org.postgresql.core.v3.SimpleParameterList.setBinaryParameter(SimpleParameterList.java:144)
      		 
      	at org.postgresql.jdbc.PgPreparedStatement.bindBytes(PgPreparedStatement.java:1113)
      		 
      	at org.postgresql.jdbc.PgPreparedStatement.setLong(PgPreparedStatement.java:344)
      		 
      	at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.setLong(NewProxyPreparedStatement.java:197)
      		 
      	at edu.internet2.middleware.grouperClient.jdbc.GcBoundDataConversionImpl.addBindVariableToStatement(GcBoundDataConversionImpl.java:45)
      		 
      	... 18 more
      		 
      , tookMillis: 12399
      		 
      	at edu.internet2.middleware.grouper.changeLog.esb.consumer.EsbConsumer.processChangeLogEntries(EsbConsumer.java:603)
      		 
      	at edu.internet2.middleware.grouper.changeLog.ChangeLogHelper.processRecords(ChangeLogHelper.java:415)
      		 
      	at edu.internet2.middleware.grouper.changeLog.ChangeLogHelper.processRecordsWrapper(ChangeLogHelper.java:250)
      		 
      	at edu.internet2.middleware.grouper.app.loader.GrouperLoaderType$5.runJob(GrouperLoaderType.java:508)
      		 
      	at edu.internet2.middleware.grouper.app.loader.GrouperLoaderJob.runJob(GrouperLoaderJob.java:558)
      		 
      	at edu.internet2.middleware.grouper.app.loader.GrouperLoaderJob$1.callback(GrouperLoaderJob.java:357)
      		 
      	at edu.internet2.middleware.grouper.GrouperSession.callbackGrouperSession(GrouperSession.java:1063)
      		 
      	at edu.internet2.middleware.grouper.GrouperSession.internal_callbackRootGrouperSession(GrouperSession.java:1132)
      		 
      	at edu.internet2.middleware.grouper.GrouperSession.internal_callbackRootGrouperSession(GrouperSession.java:1099)
      		 
      	at edu.internet2.middleware.grouper.app.loader.GrouperLoaderJob.execute(GrouperLoaderJob.java:92)
      		 
      	at org.quartz.core.JobRunShell.run(JobRunShell.java:202)
      		 
      	at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:573)
      		 
      Error: Error processing record -1, sequenceNumber: -1, java.lang.RuntimeException: sql:  select  from OBJECT;, args: ArrayList size: 3: [0]: 1728015448879000
      		 
      [1]: etc:sqlCacheable:sqlCacheableListName
      		 
      [2]: 2caa2e9225ea434ba1f216bf33f30815
      		 
       
      		 
      	at edu.internet2.middleware.grouperClient.jdbc.GcDbAccess.callbackResultSet(GcDbAccess.java:2497)
      		 
      	at edu.internet2.middleware.grouperClient.jdbc.GcDbAccess.selectList(GcDbAccess.java:1816)
      		 
      	at edu.internet2.middleware.grouperClient.jdbc.GcDbAccess.selectList(GcDbAccess.java:1690)
      		 
      	at edu.internet2.middleware.grouperClient.jdbc.GcDbAccess.selectList(GcDbAccess.java:1665)
      		 
      	at edu.internet2.middleware.grouper.sqlCache.SqlCacheGroupDao.retrieveNonexistingAttributeAssignments(SqlCacheGroupDao.java:296)
      		 
      	at edu.internet2.middleware.grouper.sqlCache.EsbPublisherSqlCache.dispatchEventList(EsbPublisherSqlCache.java:157)
      		 
      	at edu.internet2.middleware.grouper.changeLog.esb.consumer.EsbConsumer.processChangeLogEntries(EsbConsumer.java:511)
      		 
      	at edu.internet2.middleware.grouper.changeLog.ChangeLogHelper.processRecords(ChangeLogHelper.java:415)
      		 
      	at edu.internet2.middleware.grouper.changeLog.ChangeLogHelper.processRecordsWrapper(ChangeLogHelper.java:250)
      		 
      	at edu.internet2.middleware.grouper.app.loader.GrouperLoaderType$5.runJob(GrouperLoaderType.java:508)
      		 
      	at edu.internet2.middleware.grouper.app.loader.GrouperLoaderJob.runJob(GrouperLoaderJob.java:558)
      		 
      	at edu.internet2.middleware.grouper.app.loader.GrouperLoaderJob$1.callback(GrouperLoaderJob.java:357)
      		 
      	at edu.internet2.middleware.grouper.GrouperSession.callbackGrouperSession(GrouperSession.java:1063)
      		 
      	at edu.internet2.middleware.grouper.GrouperSession.internal_callbackRootGrouperSession(GrouperSession.java:1132)
      		 
      	at edu.internet2.middleware.grouper.GrouperSession.internal_callbackRootGrouperSession(GrouperSession.java:1099)
      		 
      	at edu.internet2.middleware.grouper.app.loader.GrouperLoaderJob.execute(GrouperLoaderJob.java:92)
      		 
      	at org.quartz.core.JobRunShell.run(JobRunShell.java:202)
      		 
      	at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:573)
      		 
      Caused by: java.lang.RuntimeException: Problem attaching param index: 1, param: '1728015448879000'
      		 
      	at edu.internet2.middleware.grouperClient.jdbc.GcBoundDataConversionImpl.addBindVariableToStatement(GcBoundDataConversionImpl.java:70)
      		 
      	at edu.internet2.middleware.grouperClient.jdbc.GcDbAccess.callbackResultSet(GcDbAccess.java:2457)
      		 
      	... 17 more
      		 
      Caused by: org.postgresql.util.PSQLException: The column index is out of range: 1, number of columns: 0.
      		 
      	at org.postgresql.core.v3.SimpleParameterList.bind(SimpleParameterList.java:70)
      		 
      	at org.postgresql.core.v3.SimpleParameterList.setBinaryParameter(SimpleParameterList.java:144)
      		 
      	at org.postgresql.jdbc.PgPreparedStatement.bindBytes(PgPreparedStatement.java:1113)
      		 
      	at org.postgresql.jdbc.PgPreparedStatement.setLong(PgPreparedStatement.java:344)
      		 
      	at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.setLong(NewProxyPreparedStatement.java:197)
      		 
      	at edu.internet2.middleware.grouperClient.jdbc.GcBoundDataConversionImpl.addBindVariableToStatement(GcBoundDataConversionImpl.java:45)
      		 
      	... 18 more
      		 
      Did not get all the way through the batch! -1 != 1789java.lang.RuntimeException: Error in loader job: null, status: ERROR, check logs: method: dispatchEventList, eventCount: 1, lastSequenceAvailable: 1789, removeCacheCount: 1, eventsSkipped: 0, tookMillis: 12399Error: java.lang.RuntimeException: Couldn't process any records: type: consumer, finalLog: true, state: sendToPublisher, consumerName: sqlCacheGroup, currentSequenceNumber: null, elFilter: event.eventType eq 'ATTRIBUTE_ASSIGN_VALUE_ADD' || event.eventType eq 'ATTRIBUTE_ASSIGN_VALUE_DELETE', publisherClass: edu.internet2.middleware.grouper.sqlCache.EsbPublisherSqlCache, exception: java.lang.RuntimeException: sql:  select  from OBJECT;, args: ArrayList size: 3: [0]: 1728015448879000
      		 
      [1]: etc:sqlCacheable:sqlCacheableListName
      		 
      [2]: 2caa2e9225ea434ba1f216bf33f30815
      		 
       
      		 
      	at edu.internet2.middleware.grouperClient.jdbc.GcDbAccess.callbackResultSet(GcDbAccess.java:2497)
      		 
      	at edu.internet2.middleware.grouperClient.jdbc.GcDbAccess.selectList(GcDbAccess.java:1816)
      		 
      	at edu.internet2.middleware.grouperClient.jdbc.GcDbAccess.selectList(GcDbAccess.java:1690)
      		 
      	at edu.internet2.middleware.grouperClient.jdbc.GcDbAccess.selectList(GcDbAccess.java:1665)
      		 
      	at edu.internet2.middleware.grouper.sqlCache.SqlCacheGroupDao.retrieveNonexistingAttributeAssignments(SqlCacheGroupDao.java:296)
      		 
      	at edu.internet2.middleware.grouper.sqlCache.EsbPublisherSqlCache.dispatchEventList(EsbPublisherSqlCache.java:157)
      		 
      	at edu.internet2.middleware.grouper.changeLog.esb.consumer.EsbConsumer.processChangeLogEntries(EsbConsumer.java:511)
      		 
      	at edu.internet2.middleware.grouper.changeLog.ChangeLogHelper.processRecords(ChangeLogHelper.java:415)
      		 
      	at edu.internet2.middleware.grouper.changeLog.ChangeLogHelper.processRecordsWrapper(ChangeLogHelper.java:250)
      		 
      	at edu.internet2.middleware.grouper.app.loader.GrouperLoaderType$5.runJob(GrouperLoaderType.java:508)
      		 
      	at edu.internet2.middleware.grouper.app.loader.GrouperLoaderJob.runJob(GrouperLoaderJob.java:558)
      		 
      	at edu.internet2.middleware.grouper.app.loader.GrouperLoaderJob$1.callback(GrouperLoaderJob.java:357)
      		 
      	at edu.internet2.middleware.grouper.GrouperSession.callbackGrouperSession(GrouperSession.java:1063)
      		 
      	at edu.internet2.middleware.grouper.GrouperSession.internal_callbackRootGrouperSession(GrouperSession.java:1132)
      		 
      	at edu.internet2.middleware.grouper.GrouperSession.internal_callbackRootGrouperSession(GrouperSession.java:1099)
      		 
      	at edu.internet2.middleware.grouper.app.loader.GrouperLoaderJob.execute(GrouperLoaderJob.java:92)
      		 
      	at org.quartz.core.JobRunShell.run(JobRunShell.java:202)
      		 
      	at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:573)
      		 
      Caused by: java.lang.RuntimeException: Problem attaching param index: 1, param: '1728015448879000'
      		 
      	at edu.internet2.middleware.grouperClient.jdbc.GcBoundDataConversionImpl.addBindVariableToStatement(GcBoundDataConversionImpl.java:70)
      		 
      	at edu.internet2.middleware.grouperClient.jdbc.GcDbAccess.callbackResultSet(GcDbAccess.java:2457)
      		 
      	... 17 more
      		 
      Caused by: org.postgresql.util.PSQLException: The column index is out of range: 1, number of columns: 0.
      		 
      	at org.postgresql.core.v3.SimpleParameterList.bind(SimpleParameterList.java:70)
      		 
      	at org.postgresql.core.v3.SimpleParameterList.setBinaryParameter(SimpleParameterList.java:144)
      		 
      	at org.postgresql.jdbc.PgPreparedStatement.bindBytes(PgPreparedStatement.java:1113)
      		 
      	at org.postgresql.jdbc.PgPreparedStatement.setLong(PgPreparedStatement.java:344)
      		 
      	at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.setLong(NewProxyPreparedStatement.java:197)
      		 
      	at edu.internet2.middleware.grouperClient.jdbc.GcBoundDataConversionImpl.addBindVariableToStatement(GcBoundDataConversionImpl.java:45)
      		 
      	... 18 more
      		 
      , tookMillis: 12399
      		 
      	at edu.internet2.middleware.grouper.changeLog.esb.consumer.EsbConsumer.processChangeLogEntries(EsbConsumer.java:603)
      		 
      	at edu.internet2.middleware.grouper.changeLog.ChangeLogHelper.processRecords(ChangeLogHelper.java:415)
      		 
      	at edu.internet2.middleware.grouper.changeLog.ChangeLogHelper.processRecordsWrapper(ChangeLogHelper.java:250)
      		 
      	at edu.internet2.middleware.grouper.app.loader.GrouperLoaderType$5.runJob(GrouperLoaderType.java:508)
      		 
      	at edu.internet2.middleware.grouper.app.loader.GrouperLoaderJob.runJob(GrouperLoaderJob.java:558)
      		 
      	at edu.internet2.middleware.grouper.app.loader.GrouperLoaderJob$1.callback(GrouperLoaderJob.java:357)
      		 
      	at edu.internet2.middleware.grouper.GrouperSession.callbackGrouperSession(GrouperSession.java:1063)
      		 
      	at edu.internet2.middleware.grouper.GrouperSession.internal_callbackRootGrouperSession(GrouperSession.java:1132)
      		 
      	at edu.internet2.middleware.grouper.GrouperSession.internal_callbackRootGrouperSession(GrouperSession.java:1099)
      		 
      	at edu.internet2.middleware.grouper.app.loader.GrouperLoaderJob.execute(GrouperLoaderJob.java:92)
      		 
      	at org.quartz.core.JobRunShell.run(JobRunShell.java:202)
      		 
      	at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:573)
      		 
      Error: Error processing record -1, sequenceNumber: -1, java.lang.RuntimeException: sql:  select  from OBJECT;, args: ArrayList size: 3: [0]: 1728015448879000
      		 
      [1]: etc:sqlCacheable:sqlCacheableListName
      		 
      [2]: 2caa2e9225ea434ba1f216bf33f30815
      		 
       
      		 
      	at edu.internet2.middleware.grouperClient.jdbc.GcDbAccess.callbackResultSet(GcDbAccess.java:2497)
      		 
      	at edu.internet2.middleware.grouperClient.jdbc.GcDbAccess.selectList(GcDbAccess.java:1816)
      		 
      	at edu.internet2.middleware.grouperClient.jdbc.GcDbAccess.selectList(GcDbAccess.java:1690)
      		 
      	at edu.internet2.middleware.grouperClient.jdbc.GcDbAccess.selectList(GcDbAccess.java:1665)
      		 
      	at edu.internet2.middleware.grouper.sqlCache.SqlCacheGroupDao.retrieveNonexistingAttributeAssignments(SqlCacheGroupDao.java:296)
      		 
      	at edu.internet2.middleware.grouper.sqlCache.EsbPublisherSqlCache.dispatchEventList(EsbPublisherSqlCache.java:157)
      		 
      	at edu.internet2.middleware.grouper.changeLog.esb.consumer.EsbConsumer.processChangeLogEntries(EsbConsumer.java:511)
      		 
      	at edu.internet2.middleware.grouper.changeLog.ChangeLogHelper.processRecords(ChangeLogHelper.java:415)
      		 
      	at edu.internet2.middleware.grouper.changeLog.ChangeLogHelper.processRecordsWrapper(ChangeLogHelper.java:250)
      		 
      	at edu.internet2.middleware.grouper.app.loader.GrouperLoaderType$5.runJob(GrouperLoaderType.java:508)
      		 
      	at edu.internet2.middleware.grouper.app.loader.GrouperLoaderJob.runJob(GrouperLoaderJob.java:558)
      		 
      	at edu.internet2.middleware.grouper.app.loader.GrouperLoaderJob$1.callback(GrouperLoaderJob.java:357)
      		 
      	at edu.internet2.middleware.grouper.GrouperSession.callbackGrouperSession(GrouperSession.java:1063)
      		 
      	at edu.internet2.middleware.grouper.GrouperSession.internal_callbackRootGrouperSession(GrouperSession.java:1132)
      		 
      	at edu.internet2.middleware.grouper.GrouperSession.internal_callbackRootGrouperSession(GrouperSession.java:1099)
      		 
      	at edu.internet2.middleware.grouper.app.loader.GrouperLoaderJob.execute(GrouperLoaderJob.java:92)
      		 
      	at org.quartz.core.JobRunShell.run(JobRunShell.java:202)
      		 
      	at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:573)
      		 
      Caused by: java.lang.RuntimeException: Problem attaching param index: 1, param: '1728015448879000'
      		 
      	at edu.internet2.middleware.grouperClient.jdbc.GcBoundDataConversionImpl.addBindVariableToStatement(GcBoundDataConversionImpl.java:70)
      		 
      	at edu.internet2.middleware.grouperClient.jdbc.GcDbAccess.callbackResultSet(GcDbAccess.java:2457)
      		 
      	... 17 more
      		 
      Caused by: org.postgresql.util.PSQLException: The column index is out of range: 1, number of columns: 0.
      		 
      	at org.postgresql.core.v3.SimpleParameterList.bind(SimpleParameterList.java:70)
      		 
      	at org.postgresql.core.v3.SimpleParameterList.setBinaryParameter(SimpleParameterList.java:144)
      		 
      	at org.postgresql.jdbc.PgPreparedStatement.bindBytes(PgPreparedStatement.java:1113)
      		 
      	at org.postgresql.jdbc.PgPreparedStatement.setLong(PgPreparedStatement.java:344)
      		 
      	at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.setLong(NewProxyPreparedStatement.java:197)
      		 
      	at edu.internet2.middleware.grouperClient.jdbc.GcBoundDataConversionImpl.addBindVariableToStatement(GcBoundDataConversionImpl.java:45)
      		 
      	... 18 more
      		 
      Did not get all the way through the batch! -1 != 1789
      		 
      	at edu.internet2.middleware.grouper.app.loader.GrouperLoaderJob.runJob(GrouperLoaderJob.java:566)
      		 
      	at edu.internet2.middleware.grouper.app.loader.GrouperLoaderJob$1.callback(GrouperLoaderJob.java:357)
      		 
      	at edu.internet2.middleware.grouper.GrouperSession.callbackGrouperSession(GrouperSession.java:1063)
      		 
      	at edu.internet2.middleware.grouper.GrouperSession.internal_callbackRootGrouperSession(GrouperSession.java:1132)
      		 
      	at edu.internet2.middleware.grouper.GrouperSession.internal_callbackRootGrouperSession(GrouperSession.java:1099)
      		 
      	at edu.internet2.middleware.grouper.app.loader.GrouperLoaderJob.execute(GrouperLoaderJob.java:92)
      		 
      	at org.quartz.core.JobRunShell.run(JobRunShell.java:202)
      		 
      	at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:573)

       

            Assignee:
            Chris Hyzer (upenn.edu)
            Reporter:
            Chad Redman
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Created:
              Updated: