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

gsh init fails on gsh.sh -registry -check -runscript -noprompt

    XMLWordPrintable

Details

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

    Description

      heckin -> false, testConnectionOnCheckout -> false, unreturnedConnectionTimeout -> 0, usesTraditionalReflectiveProxies -> false; userOverrides: {} ], dataSourceName -> null, extensions -> {}, factoryClassLocation -> null, identityToken -> 1bqq1hea9pq2yqb1nhagf5|20a967fe, numHelperThreads -> 3 ]

      1. edu.internet2.middleware.grouper.exception.GrouperException: unable to initialize registry: Problem in HibernateSession: HibernateSession (6e243175): new, readonly, READONLY_NEW, notActiveTransaction, session (58dad04a),
      2. Exception in uniqueResult: (class edu.internet2.middleware.grouper.Member), ByHqlStatic, query: 'from Member as m where m.subjectIdDb = :sid and m.subjectSourceIdDb = :source and m.subjectTypeId = :type', cacheable: true, cacheRegion: edu.internet2.middleware.grouper.internal.dao.hib3.Hib3MemberDAO.FindBySubject, tx type: null, tx type: nullBind var[0]: 'Param (class java.lang.String): 'sid'>'GrouperSystem', Bind var[1]: 'Param (class java.lang.String): 'type'>'application'Bind var[2]: 'Param (class java.lang.String): 'source'->'g:isa',
      3. at edu.internet2.middleware.grouper.registry.RegistryInstall.install(RegistryInstall.java:122)
      4. at edu.internet2.middleware.grouper.ddl.GrouperDdlEngine.registryInstall(GrouperDdlEngine.java:1059)
      5. at edu.internet2.middleware.grouper.ddl.GrouperDdlEngine.initRegistryAndClearCache(GrouperDdlEngine.java:1015)
      6. at edu.internet2.middleware.grouper.ddl.GrouperDdlEngine.runDdl(GrouperDdlEngine.java:886)
      7. at edu.internet2.middleware.grouper.registry.RegistryInitializeSchema.main(RegistryInitializeSchema.java:210)
      8. at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      9. at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
      10. at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
      11. at java.lang.reflect.Method.invoke(Method.java:498)
      12. at edu.internet2.middleware.grouper.app.gsh.GrouperShell.handleSpecialCase(GrouperShell.java:224)
      13. at edu.internet2.middleware.grouper.app.gsh.GrouperShell.main(GrouperShell.java:158)
      14. at edu.internet2.middleware.grouper.app.gsh.GrouperShellWrapper.main(GrouperShellWrapper.java:31)
      15. Caused by: edu.internet2.middleware.grouper.internal.dao.GrouperDAOException: Problem in HibernateSession: HibernateSession (6e243175): new, readonly, READONLY_NEW, notActiveTransaction, session (58dad04a),
      16. Exception in uniqueResult: (class edu.internet2.middleware.grouper.Member), ByHqlStatic, query: 'from Member as m where m.subjectIdDb = :sid and m.subjectSourceIdDb = :source and m.subjectTypeId = :type', cacheable: true, cacheRegion: edu.internet2.middleware.grouper.internal.dao.hib3.Hib3MemberDAO.FindBySubject, tx type: null, tx type: nullBind var[0]: 'Param (class java.lang.String): 'sid'>'GrouperSystem', Bind var[1]: 'Param (class java.lang.String): 'type'>'application'Bind var[2]: 'Param (class java.lang.String): 'source'->'g:isa',
      17. at edu.internet2.middleware.grouper.hibernate.HibernateSession._internal_hibernateSessionCatch(HibernateSession.java:591)
      18. at edu.internet2.middleware.grouper.hibernate.HibernateSession.callbackHibernateSession(HibernateSession.java:713)
      19. at edu.internet2.middleware.grouper.hibernate.ByHqlStatic.uniqueResult(ByHqlStatic.java:356)
      20. at edu.internet2.middleware.grouper.internal.dao.hib3.Hib3MemberDAO.findBySubject(Hib3MemberDAO.java:314)
      21. at edu.internet2.middleware.grouper.MemberFinder.internal_findOrCreateBySubject(MemberFinder.java:710)
      22. at edu.internet2.middleware.grouper.MemberFinder.internal_findBySubject(MemberFinder.java:626)
      23. at edu.internet2.middleware.grouper.MemberFinder.internal_findBySubject(MemberFinder.java:611)
      24. at edu.internet2.middleware.grouper.GrouperSession.start(GrouperSession.java:486)
      25. at edu.internet2.middleware.grouper.registry.RegistryInstall.install(RegistryInstall.java:81)
      26. ... 11 more
      27. Caused by: org.hibernate.exception.SQLGrammarException: could not extract ResultSet
      28. at org.hibernate.exception.internal.SQLExceptionTypeDelegate.convert(SQLExceptionTypeDelegate.java:63)
      29. at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:42)
      30. at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:109)
      31. at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:95)
      32. at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.extract(ResultSetReturnImpl.java:79)
      33. at org.hibernate.loader.Loader.getResultSet(Loader.java:2117)
      34. at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1900)
      35. at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1876)
      36. at org.hibernate.loader.Loader.doQuery(Loader.java:919)
      37. at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:336)
      38. at org.hibernate.loader.Loader.doList(Loader.java:2617)
      39. at org.hibernate.loader.Loader.listUsingQueryCache(Loader.java:2459)
      40. at org.hibernate.loader.Loader.list(Loader.java:2421)
      41. at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:501)
      42. at org.hibernate.hql.internal.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:371)
      43. at org.hibernate.engine.query.spi.HQLQueryPlan.performList(HQLQueryPlan.java:216)
      44. at org.hibernate.internal.SessionImpl.list(SessionImpl.java:1326)
      45. at org.hibernate.internal.QueryImpl.list(QueryImpl.java:87)
      46. at org.hibernate.internal.AbstractQueryImpl.uniqueResult(AbstractQueryImpl.java:966)
      47. at edu.internet2.middleware.grouper.hibernate.ByHql.uniqueResult(ByHql.java:283)
      48. at edu.internet2.middleware.grouper.hibernate.ByHqlStatic$1.callback(ByHqlStatic.java:365)
      49. at edu.internet2.middleware.grouper.hibernate.HibernateSession.callbackHibernateSession(HibernateSession.java:703)
      50. ... 18 more
      51. Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'grouper.grouper_members' doesn't exist
      52. at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
      53. at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
      54. at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
      55. at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
      56. at com.mysql.jdbc.Util.handleNewInstance(Util.java:425)
      57. at com.mysql.jdbc.Util.getInstance(Util.java:408)
      58. at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:944)
      59. at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3973)
      60. at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3909)
      61. at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2527)
      62. at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2680)
      63. at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2484)
      64. at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1858)
      65. at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1966)
      66. at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:431)
      67. at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.extract(ResultSetReturnImpl.java:70)
      68. ... 35 more
      69. Exception in thread "main" java.lang.RuntimeException: java.lang.reflect.InvocationTargetException
      70. at edu.internet2.middleware.grouper.app.gsh.GrouperShell.handleSpecialCase(GrouperShell.java:234)
      71. at edu.internet2.middleware.grouper.app.gsh.GrouperShell.main(GrouperShell.java:158)
      72. at edu.internet2.middleware.grouper.app.gsh.GrouperShellWrapper.main(GrouperShellWrapper.java:31)
      73. Caused by: java.lang.reflect.InvocationTargetException
      74. at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      75. at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
      76. at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
      77. at java.lang.reflect.Method.invoke(Method.java:498)
      78. at edu.internet2.middleware.grouper.app.gsh.GrouperShell.handleSpecialCase(GrouperShell.java:224)
      79. ... 2 more
      80. Caused by: java.lang.RuntimeException: edu.internet2.middleware.grouper.exception.GrouperException: unable to initialize registry: Problem in HibernateSession: HibernateSession (6e243175): new, readonly, READONLY_NEW, notActiveTransaction, session (58dad04a),
      81. Exception in uniqueResult: (class edu.internet2.middleware.grouper.Member), ByHqlStatic, query: 'from Member as m where m.subjectIdDb = :sid and m.subjectSourceIdDb = :source and m.subjectTypeId = :type', cacheable: true, cacheRegion: edu.internet2.middleware.grouper.internal.dao.hib3.Hib3MemberDAO.FindBySubject, tx type: null, tx type: nullBind var[0]: 'Param (class java.lang.String): 'sid'>'GrouperSystem', Bind var[1]: 'Param (class java.lang.String): 'type'>'application'Bind var[2]: 'Param (class java.lang.String): 'source'->'g:isa',
      82. at edu.internet2.middleware.grouper.registry.RegistryInitializeSchema.main(RegistryInitializeSchema.java:227)
      83. ... 7 more
      84. Caused by: edu.internet2.middleware.grouper.exception.GrouperException: unable to initialize registry: Problem in HibernateSession: HibernateSession (6e243175): new, readonly, READONLY_NEW, notActiveTransaction, session (58dad04a),
      85. Exception in uniqueResult: (class edu.internet2.middleware.grouper.Member), ByHqlStatic, query: 'from Member as m where m.subjectIdDb = :sid and m.subjectSourceIdDb = :source and m.subjectTypeId = :type', cacheable: true, cacheRegion: edu.internet2.middleware.grouper.internal.dao.hib3.Hib3MemberDAO.FindBySubject, tx type: null, tx type: nullBind var[0]: 'Param (class java.lang.String): 'sid'>'GrouperSystem', Bind var[1]: 'Param (class java.lang.String): 'type'>'application'Bind var[2]: 'Param (class java.lang.String): 'source'->'g:isa',
      86. at edu.internet2.middleware.grouper.registry.RegistryInstall.install(RegistryInstall.java:122)
      87. at edu.internet2.middleware.grouper.ddl.GrouperDdlEngine.registryInstall(GrouperDdlEngine.java:1059)
      88. at edu.internet2.middleware.grouper.ddl.GrouperDdlEngine.initRegistryAndClearCache(GrouperDdlEngine.java:1015)
      89. at edu.internet2.middleware.grouper.ddl.GrouperDdlEngine.runDdl(GrouperDdlEngine.java:886)
      90. at edu.internet2.middleware.grouper.registry.RegistryInitializeSchema.main(RegistryInitializeSchema.java:210)
      91. ... 7 more
      92. Caused by: edu.internet2.middleware.grouper.internal.dao.GrouperDAOException: Problem in HibernateSession: HibernateSession (6e243175): new, readonly, READONLY_NEW, notActiveTransaction, session (58dad04a),
      93. Exception in uniqueResult: (class edu.internet2.middleware.grouper.Member), ByHqlStatic, query: 'from Member as m where m.subjectIdDb = :sid and m.subjectSourceIdDb = :source and m.subjectTypeId = :type', cacheable: true, cacheRegion: edu.internet2.middleware.grouper.internal.dao.hib3.Hib3MemberDAO.FindBySubject, tx type: null, tx type: nullBind var[0]: 'Param (class java.lang.String): 'sid'>'GrouperSystem', Bind var[1]: 'Param (class java.lang.String): 'type'>'application'Bind var[2]: 'Param (class java.lang.String): 'source'->'g:isa',
      94. at edu.internet2.middleware.grouper.hibernate.HibernateSession._internal_hibernateSessionCatch(HibernateSession.java:591)
      95. at edu.internet2.middleware.grouper.hibernate.HibernateSession.callbackHibernateSession(HibernateSession.java:713)
      96. at edu.internet2.middleware.grouper.hibernate.ByHqlStatic.uniqueResult(ByHqlStatic.java:356)
      97. at edu.internet2.middleware.grouper.internal.dao.hib3.Hib3MemberDAO.findBySubject(Hib3MemberDAO.java:314)
      98. at edu.internet2.middleware.grouper.MemberFinder.internal_findOrCreateBySubject(MemberFinder.java:710)
      99. at edu.internet2.middleware.grouper.MemberFinder.internal_findBySubject(MemberFinder.java:626)
      100. at edu.internet2.middleware.grouper.MemberFinder.internal_findBySubject(MemberFinder.java:611)
      101. at edu.internet2.middleware.grouper.GrouperSession.start(GrouperSession.java:486)
      102. at edu.internet2.middleware.grouper.registry.RegistryInstall.install(RegistryInstall.java:81)
      103. ... 11 more
      104. Caused by: org.hibernate.exception.SQLGrammarException: could not extract ResultSet
      105. at org.hibernate.exception.internal.SQLExceptionTypeDelegate.convert(SQLExceptionTypeDelegate.java:63)
      106. at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:42)
      107. at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:109)
      108. at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:95)
      109. at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.extract(ResultSetReturnImpl.java:79)
      110. at org.hibernate.loader.Loader.getResultSet(Loader.java:2117)
      111. at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1900)
      112. at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1876)
      113. at org.hibernate.loader.Loader.doQuery(Loader.java:919)
      114. at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:336)
      115. at org.hibernate.loader.Loader.doList(Loader.java:2617)
      116. at org.hibernate.loader.Loader.listUsingQueryCache(Loader.java:2459)
      117. at org.hibernate.loader.Loader.list(Loader.java:2421)
      118. at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:501)
      119. at org.hibernate.hql.internal.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:371)
      120. at org.hibernate.engine.query.spi.HQLQueryPlan.performList(HQLQueryPlan.java:216)
      121. at org.hibernate.internal.SessionImpl.list(SessionImpl.java:1326)
      122. at org.hibernate.internal.QueryImpl.list(QueryImpl.java:87)
      123. at org.hibernate.internal.AbstractQueryImpl.uniqueResult(AbstractQueryImpl.java:966)
      124. at edu.internet2.middleware.grouper.hibernate.ByHql.uniqueResult(ByHql.java:283)
      125. at edu.internet2.middleware.grouper.hibernate.ByHqlStatic$1.callback(ByHqlStatic.java:365)
      126. at edu.internet2.middleware.grouper.hibernate.HibernateSession.callbackHibernateSession(HibernateSession.java:703)
      127. ... 18 more
      128. Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'grouper.grouper_members' doesn't exist
      129. at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
      130. at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
      131. at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
      132. at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
      133. at com.mysql.jdbc.Util.handleNewInstance(Util.java:425)
      134. at com.mysql.jdbc.Util.getInstance(Util.java:408)
      135. at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:944)
      136. at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3973)
      137. at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3909)

      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