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

ddlutils cant read mysql tables

    XMLWordPrintable

Details

    • Bug
    • Status: Resolved
    • Minor
    • Resolution: Fixed
    • None
    • 2.5.19
    • None
    • None

    Description

      Grouper ddl object type 'Grouper' has dbVersion: 31 (2.4.0) and java version: 32 (2.5.0)
      org.apache.ddlutils.DatabaseOperationException: java.sql.SQLSyntaxErrorException: Unknown table 'grouper_QZ_BLOB_TRIGGERS' in information_schema
          at org.apache.ddlutils.platform.PlatformImplBase.readModelFromDatabase(PlatformImplBase.java:1931)
          at edu.internet2.middleware.grouper.ddl.GrouperDdlEngine.runDdlForObjectName(GrouperDdlEngine.java:323)
          at edu.internet2.middleware.grouper.ddl.GrouperDdlEngine.runDdl(GrouperDdlEngine.java:731)
          at edu.internet2.middleware.grouper.registry.RegistryInitializeSchema.main(RegistryInitializeSchema.java:184)
          at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
          at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
          at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
          at java.lang.reflect.Method.invoke(Method.java:498)
          at edu.internet2.middleware.grouper.app.gsh.GrouperShell.handleSpecialCase(GrouperShell.java:224)
          at edu.internet2.middleware.grouper.app.gsh.GrouperShell.main(GrouperShell.java:158)
          at edu.internet2.middleware.grouper.app.gsh.GrouperShellWrapper.main(GrouperShellWrapper.java:31)
      Caused by: java.sql.SQLSyntaxErrorException: Unknown table 'grouper_QZ_BLOB_TRIGGERS' in information_schema
          at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:120)
          at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97)
          at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122)
          at com.mysql.cj.jdbc.StatementImpl.executeQuery(StatementImpl.java:1218)
          at com.mysql.cj.jdbc.DatabaseMetaData$7.forEach(DatabaseMetaData.java:2980)
          at com.mysql.cj.jdbc.DatabaseMetaData$7.forEach(DatabaseMetaData.java:2968)
          at com.mysql.cj.jdbc.IterateBlock.doForAll(IterateBlock.java:56)
          at com.mysql.cj.jdbc.DatabaseMetaData.getPrimaryKeys(DatabaseMetaData.java:3021)
          at com.mchange.v2.c3p0.impl.NewProxyDatabaseMetaData.getPrimaryKeys(NewProxyDatabaseMetaData.java:3270)
          at org.apache.ddlutils.platform.DatabaseMetaDataWrapper.getPrimaryKeys(DatabaseMetaDataWrapper.java:162)
          at org.apache.ddlutils.platform.JdbcModelReader.readPrimaryKeyNames(JdbcModelReader.java:819)
          at org.apache.ddlutils.platform.JdbcModelReader.readTable(JdbcModelReader.java:569)
          at org.apache.ddlutils.platform.mysql.MySqlModelReader.readTable(MySqlModelReader.java:63)
          at org.apache.ddlutils.platform.JdbcModelReader.readTables(JdbcModelReader.java:516)
          at org.apache.ddlutils.platform.JdbcModelReader.getDatabase(JdbcModelReader.java:472)
          at org.apache.ddlutils.platform.PlatformImplBase.readModelFromDatabase(PlatformImplBase.java:1920)
          ... 10 more
      Exception in thread "main" java.lang.RuntimeException: java.lang.reflect.InvocationTargetException
          at edu.internet2.middleware.grouper.app.gsh.GrouperShell.handleSpecialCase(GrouperShell.java:234)
          at edu.internet2.middleware.grouper.app.gsh.GrouperShell.main(GrouperShell.java:158)
          at edu.internet2.middleware.grouper.app.gsh.GrouperShellWrapper.main(GrouperShellWrapper.java:31)
      Caused by: java.lang.reflect.InvocationTargetException
          at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
          at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
          at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
          at java.lang.reflect.Method.invoke(Method.java:498)
          at edu.internet2.middleware.grouper.app.gsh.GrouperShell.handleSpecialCase(GrouperShell.java:224)
          ... 2 more
      Caused by: java.lang.RuntimeException: org.apache.ddlutils.DatabaseOperationException: java.sql.SQLSyntaxErrorException: Unknown table 'grouper_QZ_BLOB_TRIGGERS' in information_schema
          at edu.internet2.middleware.grouper.registry.RegistryInitializeSchema.main(RegistryInitializeSchema.java:199)
          ... 7 more
      Caused by: org.apache.ddlutils.DatabaseOperationException: java.sql.SQLSyntaxErrorException: Unknown table 'grouper_QZ_BLOB_TRIGGERS' in information_schema
          at org.apache.ddlutils.platform.PlatformImplBase.readModelFromDatabase(PlatformImplBase.java:1931)
          at edu.internet2.middleware.grouper.ddl.GrouperDdlEngine.runDdlForObjectName(GrouperDdlEngine.java:323)
          at edu.internet2.middleware.grouper.ddl.GrouperDdlEngine.runDdl(GrouperDdlEngine.java:731)
          at edu.internet2.middleware.grouper.registry.RegistryInitializeSchema.main(RegistryInitializeSchema.java:184)
          ... 7 more
      Caused by: java.sql.SQLSyntaxErrorException: Unknown table 'grouper_QZ_BLOB_TRIGGERS' in information_schema
          at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:120)
          at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97)
          at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122)
          at com.mysql.cj.jdbc.StatementImpl.executeQuery(StatementImpl.java:1218)
          at com.mysql.cj.jdbc.DatabaseMetaData$7.forEach(DatabaseMetaData.java:2980)
          at com.mysql.cj.jdbc.DatabaseMetaData$7.forEach(DatabaseMetaData.java:2968)
          at com.mysql.cj.jdbc.IterateBlock.doForAll(IterateBlock.java:56)
          at com.mysql.cj.jdbc.DatabaseMetaData.getPrimaryKeys(DatabaseMetaData.java:3021)
          at com.mchange.v2.c3p0.impl.NewProxyDatabaseMetaData.getPrimaryKeys(NewProxyDatabaseMetaData.java:3270)
          at org.apache.ddlutils.platform.DatabaseMetaDataWrapper.getPrimaryKeys(DatabaseMetaDataWrapper.java:162)
          at org.apache.ddlutils.platform.JdbcModelReader.readPrimaryKeyNames(JdbcModelReader.java:819)
          at org.apache.ddlutils.platform.JdbcModelReader.readTable(JdbcModelReader.java:569)
          at org.apache.ddlutils.platform.mysql.MySqlModelReader.readTable(MySqlModelReader.java:63)
          at org.apache.ddlutils.platform.JdbcModelReader.readTables(JdbcModelReader.java:516)
          at org.apache.ddlutils.platform.JdbcModelReader.getDatabase(JdbcModelReader.java:472)
          at org.apache.ddlutils.platform.PlatformImplBase.readModelFromDatabase(PlatformImplBase.java:1920)
          ... 10 more
       

      Attachments

        Activity

          People

            chris.hyzer@at.internet2.edu Chris Hyzer (upenn.edu)
            chris.hyzer@at.internet2.edu Chris Hyzer (upenn.edu)
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Smart Checklist