Uploaded image for project: 'Grouper'
  1. Grouper
  2. GRP-2230

sql table provisoner: error for last_updated

    XMLWordPrintable

Details

    • Improvement
    • Resolution: Unresolved
    • Minor
    • None
    • 2.4.0
    • provisioning
    • None
    • tier docker

    Description

      With the following config I get the error below:

      the uf_change_log_consumer is a table just like grouper_change_log_consumer

      grouperClient.syncTable.EXT_IDENTITY.databaseFrom = shibtst

      grouperClient.syncTable.EXT_IDENTITY.schemaFrom = IDREGISTRY

      grouperClient.syncTable.EXT_IDENTITY.tableFrom = EXT_IDENTITY

      grouperClient.syncTable.EXT_IDENTITY.databaseTo = grouper

      grouperClient.syncTable.EXT_IDENTITY.schemaTo = grouper

      grouperClient.syncTable.EXT_IDENTITY.tableTo = uf_EXT_IDENTITY

      grouperClient.syncTable.EXT_IDENTITY.columns = REGISTRY_ID, SEQUENCE_NO, LINKED_ID, UFID, PRINCIPAL, PRIN_RSC_TYP, FRIENDLY_NAME, HONORIFIC_PREFIX, GIVEN_NAME, MIDDLE_NAME, FAMILY_NAME, HONORIFIC_SUFFIX, DISPLAY_NAME, EMAIL, PHONE_NUMBER, PHONE_TYPE, CREATED_TS, INACTIVE_TS, END_TS, STATUS, UPDT_ENT_ID, UPDT_SOR_ID, UPDT_TS, STRING01

      grouperClient.syncTable.EXT_IDENTITY.primaryKeyColumns = REGISTRY_ID

      grouperClient.syncTable.EXT_IDENTITY.groupingColumn = REGISTRY_ID

      grouperClient.syncTable.EXT_IDENTITY.groupingSize = 100000

      grouperClient.syncTable.EXT_IDENTITY.batchSize = 100000

      grouperClient.syncTable.EXT_IDENTITY.realTimeLastUpdatedCol = last_updated

      grouperClient.syncTable.EXT_IDENTITY.statusDatabase = grouper

      grouperClient.syncTable.EXT_IDENTITY.statusSchema = grouper

      grouperClient.syncTable.EXT_IDENTITY.statusTable = uf_change_log_consumer

      2019-06-24T01:36:20+00:00 DAEMON:dev grouper-api;grouper_event.log;grouper_dev;daemon;2019-06-23 21:36:20,510: [Thread-152] ERROR GrouperClientLog.error(116) -  - Error assigning status and logging

      2019-06-24T01:36:20+00:00 DAEMON:dev java.lang.RuntimeException: java.sql.SQLException: Can not issue data manipulation statements with executeQuery().,

      2019-06-24T01:36:20+00:00 DAEMON:dev sql: insert into grouper.uf_change_log_consumer ( name, last_sequence_processed, last_updated, created_on, id, hibernate_version_number ) values ( ?, ?, ?, ?, ?, ? )

      --------  error

      2019-06-24T01:36:20+00:00 DAEMON:dev at edu.internet2.middleware.grouperClient.jdbc.GcDbAccess.callbackResultSet(GcDbAccess.java:1901)

      2019-06-24T01:36:20+00:00 DAEMON:dev at edu.internet2.middleware.grouperClient.jdbc.GcDbAccess.selectList(GcDbAccess.java:1371)

      2019-06-24T01:36:20+00:00 DAEMON:dev at edu.internet2.middleware.grouperClient.jdbc.GcDbAccess.selectList(GcDbAccess.java:1245)

      2019-06-24T01:36:20+00:00 DAEMON:dev at edu.internet2.middleware.grouperClient.jdbc.GcDbAccess.select(GcDbAccess.java:1195)

      2019-06-24T01:36:20+00:00 DAEMON:dev at edu.internet2.middleware.grouperClient.jdbc.tableSync.GcTableSync.statusAssignLastUpdated(GcTableSync.java:558)

      2019-06-24T01:36:20+00:00 DAEMON:dev at edu.internet2.middleware.grouperClient.jdbc.tableSync.GcTableSync$3.run(GcTableSync.java:610)

      2019-06-24T01:36:20+00:00 DAEMON:dev at java.lang.Thread.run(Thread.java:748)

      2019-06-24T01:36:20+00:00 DAEMON:dev Caused by: java.sql.SQLException: Can not issue data manipulation statements with executeQuery().,

      2019-06-24T01:36:20+00:00 DAEMON:dev sql: insert into grouper.uf_change_log_consumer ( name, last_sequence_processed, last_updated, created_on, id, hibernate_version_number ) values ( ?, ?, ?, ?, ?, ? )

      2019-06-24T01:36:20+00:00 DAEMON:dev at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:129)

      2019-06-24T01:36:20+00:00 DAEMON:dev at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97)

      2019-06-24T01:36:20+00:00 DAEMON:dev at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:89)

      2019-06-24T01:36:20+00:00 DAEMON:dev at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:63)

      2019-06-24T01:36:20+00:00 DAEMON:dev at com.mysql.cj.jdbc.StatementImpl.checkForDml(StatementImpl.java:385)

      2019-06-24T01:36:20+00:00 DAEMON:dev at com.mysql.cj.jdbc.ClientPreparedStatement.executeQuery(ClientPreparedStatement.java:964)

      2019-06-24T01:36:20+00:00 DAEMON:dev at edu.internet2.middleware.grouperClient.jdbc.GcDbAccess.callbackResultSet(GcDbAccess.java:1896)

      2019-06-24T01:36:20+00:00 DAEMON:dev ... 6 more

      Attachments

        Activity

          People

            chris.hyzer@at.internet2.edu Chris Hyzer (upenn.edu)
            michael.gettes.4@at.internet2.edu Michael Gettes (ufl.edu)
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated: