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

grouper will not start with no db tables

    XMLWordPrintable

Details

    • Improvement
    • Resolution: Fixed
    • Minor
    • 2.5.52
    • None
    • None
    • None

    Description

      2021-05-27 14:25:41,746: [Thread-2] ERROR SqlExceptionHelper.logExceptions(129) -  - user lacks privilege or object not found: GROUPER_MEMBERS in statement [select member0_.id as id1_27_, member0_.hibernate_version_number as hibernat2_27_, member0_.subject_id as subject_3_27_, member0_.subject_source as subject_4_27_, member0_.subject_type as subject_5_27_, member0_.context_id as context_6_27_, member0_.subject_identifier0 as subject_7_27_, member0_.sort_string0 as sort_str8_27_, member0_.sort_string1 as sort_str9_27_, member0_.sort_string2 as sort_st10_27_, member0_.sort_string3 as sort_st11_27_, member0_.sort_string4 as sort_st12_27_, member0_.search_string0 as search_13_27_, member0_.search_string1 as search_14_27_, member0_.search_string2 as search_15_27_, member0_.search_string3 as search_16_27_, member0_.search_string4 as search_17_27_, member0_.name as name18_27_, member0_.description as descrip19_27_, member0_.subject_resolution_resolvable as subject20_27_, member0_.subject_resolution_deleted as subject21_27_ from grouper_members member0_ where member0_.subject_id=? and member0_.subject_source=? and member0_.subject_type=?]2021-05-27 14:25:41,746: [Thread-2] ERROR SqlExceptionHelper.logExceptions(129) -  - user lacks privilege or object not found: GROUPER_MEMBERS in statement [select member0_.id as id1_27_, member0_.hibernate_version_number as hibernat2_27_, member0_.subject_id as subject_3_27_, member0_.subject_source as subject_4_27_, member0_.subject_type as subject_5_27_, member0_.context_id as context_6_27_, member0_.subject_identifier0 as subject_7_27_, member0_.sort_string0 as sort_str8_27_, member0_.sort_string1 as sort_str9_27_, member0_.sort_string2 as sort_st10_27_, member0_.sort_string3 as sort_st11_27_, member0_.sort_string4 as sort_st12_27_, member0_.search_string0 as search_13_27_, member0_.search_string1 as search_14_27_, member0_.search_string2 as search_15_27_, member0_.search_string3 as search_16_27_, member0_.search_string4 as search_17_27_, member0_.name as name18_27_, member0_.description as descrip19_27_, member0_.subject_resolution_resolvable as subject20_27_, member0_.subject_resolution_deleted as subject21_27_ from grouper_members member0_ where member0_.subject_id=? and member0_.subject_source=? and member0_.subject_type=?]
      Couldnt startup grouper: Problem in HibernateSession: HibernateSession (4f50bea9): new, readonly, READONLY_NEW, notActiveTransaction, session (202af341),
      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', 
      edu.internet2.middleware.grouper.internal.dao.GrouperDAOException: Problem in HibernateSession: HibernateSession (4f50bea9): new, readonly, READONLY_NEW, notActiveTransaction, session (202af341),
      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', 
       at edu.internet2.middleware.grouper.hibernate.HibernateSession._internal_hibernateSessionCatch(HibernateSession.java:591)
       at edu.internet2.middleware.grouper.hibernate.HibernateSession.callbackHibernateSession(HibernateSession.java:713)
       at edu.internet2.middleware.grouper.hibernate.ByHqlStatic.uniqueResult(ByHqlStatic.java:356)
       at edu.internet2.middleware.grouper.internal.dao.hib3.Hib3MemberDAO.findBySubject(Hib3MemberDAO.java:306)
       at edu.internet2.middleware.grouper.MemberFinder.internal_findOrCreateBySubject(MemberFinder.java:719)
       at edu.internet2.middleware.grouper.MemberFinder.internal_findBySubject(MemberFinder.java:634)
       at edu.internet2.middleware.grouper.MemberFinder.internal_findBySubject(MemberFinder.java:618)
       at edu.internet2.middleware.grouper.GrouperSession.start(GrouperSession.java:486)
       at edu.internet2.middleware.grouper.GrouperSession.startRootSession(GrouperSession.java:426)
       at edu.internet2.middleware.grouper.GrouperSession.internal_callbackRootGrouperSession(GrouperSession.java:1038)
       at edu.internet2.middleware.grouper.GrouperSession.internal_callbackRootGrouperSession(GrouperSession.java:1012)
       at edu.internet2.middleware.grouper.misc.GrouperStartup.startup(GrouperStartup.java:296)
       at edu.internet2.middleware.grouper.app.loader.GrouperLoader.main(GrouperLoader.java:124)
       at edu.internet2.middleware.grouper.j2ee.CommonServletContainerInitializer$1.run(CommonServletContainerInitializer.java:170)
       at java.lang.Thread.run(Thread.java:748)
      Caused by: org.hibernate.exception.SQLGrammarException: could not prepare statement
       at org.hibernate.exception.internal.SQLExceptionTypeDelegate.convert(SQLExceptionTypeDelegate.java:63)
       at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:42)
       at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:109)
       at org.hibernate.engine.jdbc.internal.StatementPreparerImpl$StatementPreparationTemplate.prepareStatement(StatementPreparerImpl.java:182)
       at org.hibernate.engine.jdbc.internal.StatementPreparerImpl.prepareQueryStatement(StatementPreparerImpl.java:148)
       at org.hibernate.loader.Loader.prepareQueryStatement(Loader.java:1929)
       at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1898)
       at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1876)
       at org.hibernate.loader.Loader.doQuery(Loader.java:919)
       at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:336)
       at org.hibernate.loader.Loader.doList(Loader.java:2617)
       at org.hibernate.loader.Loader.listUsingQueryCache(Loader.java:2459)
       at org.hibernate.loader.Loader.list(Loader.java:2421)
       at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:501)
       at org.hibernate.hql.internal.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:371)
       at org.hibernate.engine.query.spi.HQLQueryPlan.performList(HQLQueryPlan.java:216)
       at org.hibernate.internal.SessionImpl.list(SessionImpl.java:1326)
       at org.hibernate.internal.QueryImpl.list(QueryImpl.java:87)
       at org.hibernate.internal.AbstractQueryImpl.uniqueResult(AbstractQueryImpl.java:966)
       at edu.internet2.middleware.grouper.hibernate.ByHql.uniqueResult(ByHql.java:283)
       at edu.internet2.middleware.grouper.hibernate.ByHqlStatic$1.callback(ByHqlStatic.java:365)
       at edu.internet2.middleware.grouper.hibernate.HibernateSession.callbackHibernateSession(HibernateSession.java:703)
       ... 13 more
      May 27, 2021 2:25:41 PM org.apache.catalina.core.StandardContext filterStart
      SEVERE: Exception starting filter [GrouperUi]
      edu.internet2.middleware.grouper.internal.dao.GrouperDAOException: Problem in HibernateSession: HibernateSession (7c68f872): new, readonly, READONLY_NEW, notActiveTransaction, session (54dfdf2a),
      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', 
       at edu.internet2.middleware.grouper.hibernate.HibernateSession._internal_hibernateSessionCatch(HibernateSession.java:591)
       at edu.internet2.middleware.grouper.hibernate.HibernateSession.callbackHibernateSession(HibernateSession.java:713)
       at edu.internet2.middleware.grouper.hibernate.ByHqlStatic.uniqueResult(ByHqlStatic.java:356)
       at edu.internet2.middleware.grouper.internal.dao.hib3.Hib3MemberDAO.findBySubject(Hib3MemberDAO.java:306)
       at edu.internet2.middleware.grouper.MemberFinder.internal_findOrCreateBySubject(MemberFinder.java:719)
       at edu.internet2.middleware.grouper.MemberFinder.internal_findBySubject(MemberFinder.java:634)
       at edu.internet2.middleware.grouper.MemberFinder.internal_findBySubject(MemberFinder.java:618)
       at edu.internet2.middleware.grouper.GrouperSession.start(GrouperSession.java:486)
       at edu.internet2.middleware.grouper.GrouperSession.startRootSession(GrouperSession.java:426)
       at edu.internet2.middleware.grouper.GrouperSession.internal_callbackRootGrouperSession(GrouperSession.java:1038)
       at edu.internet2.middleware.grouper.GrouperSession.internal_callbackRootGrouperSession(GrouperSession.java:1012)
       at edu.internet2.middleware.grouper.ui.GrouperUiFilter.initGroup(GrouperUiFilter.java:923)
       at edu.internet2.middleware.grouper.ui.GrouperUiFilter.initOnce(GrouperUiFilter.java:900)
       at edu.internet2.middleware.grouper.ui.GrouperUiFilter.init(GrouperUiFilter.java:803)
       at org.apache.catalina.core.ApplicationFilterConfig.initFilter(ApplicationFilterConfig.java:281)
       at org.apache.catalina.core.ApplicationFilterConfig.getFilter(ApplicationFilterConfig.java:262)
       at org.apache.catalina.core.ApplicationFilterConfig.<init>(ApplicationFilterConfig.java:106)
       at org.apache.catalina.core.StandardContext.filterStart(StandardContext.java:4538)
       at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5181)
       at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183)
       at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1412)
       at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1402)
       at java.util.concurrent.FutureTask.run(FutureTask.java:266)
       at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
       at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
       at java.lang.Thread.run(Thread.java:748)
      Caused by: org.hibernate.exception.SQLGrammarException: could not prepare statement
       at org.hibernate.exception.internal.SQLExceptionTypeDelegate.convert(SQLExceptionTypeDelegate.java:63)
       at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:42)
       at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:109)
       at org.hibernate.engine.jdbc.internal.StatementPreparerImpl$StatementPreparationTemplate.prepareStatement(StatementPreparerImpl.java:182)
       at org.hibernate.engine.jdbc.internal.StatementPreparerImpl.prepareQueryStatement(StatementPreparerImpl.java:148)
       at org.hibernate.loader.Loader.prepareQueryStatement(Loader.java:1929)
       at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1898)
       at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1876)
       at org.hibernate.loader.Loader.doQuery(Loader.java:919)
       at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:336)
       at org.hibernate.loader.Loader.doList(Loader.java:2617)
       at org.hibernate.loader.Loader.listUsingQueryCache(Loader.java:2459)
       at org.hibernate.loader.Loader.list(Loader.java:2421)
       at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:501)
       at org.hibernate.hql.internal.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:371)
       at org.hibernate.engine.query.spi.HQLQueryPlan.performList(HQLQueryPlan.java:216)
       at org.hibernate.internal.SessionImpl.list(SessionImpl.java:1326)
       at org.hibernate.internal.QueryImpl.list(QueryImpl.java:87)
       at org.hibernate.internal.AbstractQueryImpl.uniqueResult(AbstractQueryImpl.java:966)
       at edu.internet2.middleware.grouper.hibernate.ByHql.uniqueResult(ByHql.java:283)
       at edu.internet2.middleware.grouper.hibernate.ByHqlStatic$1.callback(ByHqlStatic.java:365)
       at edu.internet2.middleware.grouper.hibernate.HibernateSession.callbackHibernateSession(HibernateSession.java:703)
       ... 24 more
      Caused by: java.sql.SQLSyntaxErrorException: user lacks privilege or object not found: GROUPER_MEMBERS in statement [select member0_.id as id1_27_, member0_.hibernate_version_number as hibernat2_27_, member0_.subject_id as subject_3_27_, member0_.subject_source as subject_4_27_, member0_.subject_type as subject_5_27_, member0_.context_id as context_6_27_, member0_.subject_identifier0 as subject_7_27_, member0_.sort_string0 as sort_str8_27_, member0_.sort_string1 as sort_str9_27_, member0_.sort_string2 as sort_st10_27_, member0_.sort_string3 as sort_st11_27_, member0_.sort_string4 as sort_st12_27_, member0_.search_string0 as search_13_27_, member0_.search_string1 as search_14_27_, member0_.search_string2 as search_15_27_, member0_.search_string3 as search_16_27_, member0_.search_string4 as search_17_27_, member0_.name as name18_27_, member0_.description as descrip19_27_, member0_.subject_resolution_resolvable as subject20_27_, member0_.subject_resolution_deleted as subject21_27_ from grouper_members member0_ where member0_.subject_id=? and member0_.subject_source=? and member0_.subject_type=?]
       at org.hsqldb.jdbc.JDBCUtil.sqlException(Unknown Source)
       at org.hsqldb.jdbc.JDBCUtil.sqlException(Unknown Source)
       at org.hsqldb.jdbc.JDBCPreparedStatement.<init>(Unknown Source)
       at org.hsqldb.jdbc.JDBCConnection.prepareStatement(Unknown Source)
       at com.mchange.v2.c3p0.impl.NewProxyConnection.prepareStatement(NewProxyConnection.java:387)
       at org.hibernate.engine.jdbc.internal.StatementPreparerImpl$5.doPrepare(StatementPreparerImpl.java:146)
       at org.hibernate.engine.jdbc.internal.StatementPreparerImpl$StatementPreparationTemplate.prepareStatement(StatementPreparerImpl.java:172)
       ... 42 more
      Caused by: java.sql.SQLSyntaxErrorException: user lacks privilege or object not found: GROUPER_MEMBERS in statement [select member0_.id as id1_27_, member0_.hibernate_version_number as hibernat2_27_, member0_.subject_id as subject_3_27_, member0_.subject_source as subject_4_27_, member0_.subject_type as subject_5_27_, member0_.context_id as context_6_27_, member0_.subject_identifier0 as subject_7_27_, member0_.sort_string0 as sort_str8_27_, member0_.sort_string1 as sort_str9_27_, member0_.sort_string2 as sort_st10_27_, member0_.sort_string3 as sort_st11_27_, member0_.sort_string4 as sort_st12_27_, member0_.search_string0 as search_13_27_, member0_.search_string1 as search_14_27_, member0_.search_string2 as search_15_27_, member0_.search_string3 as search_16_27_, member0_.search_string4 as search_17_27_, member0_.name as name18_27_, member0_.description as descrip19_27_, member0_.subject_resolution_resolvable as subject20_27_, member0_.subject_resolution_deleted as subject21_27_ from grouper_members member0_ where member0_.subject_id=? and member0_.subject_source=? and member0_.subject_type=?]
       at org.hsqldb.jdbc.JDBCUtil.sqlException(Unknown Source)
       at org.hsqldb.jdbc.JDBCUtil.sqlException(Unknown Source)
       at org.hsqldb.jdbc.JDBCPreparedStatement.<init>(Unknown Source)
       at org.hsqldb.jdbc.JDBCConnection.prepareStatement(Unknown Source)
       at com.mchange.v2.c3p0.impl.NewProxyConnection.prepareStatement(NewProxyConnection.java:387)
       at org.hibernate.engine.jdbc.internal.StatementPreparerImpl$5.doPrepare(StatementPreparerImpl.java:146)
       at org.hibernate.engine.jdbc.internal.StatementPreparerImpl$StatementPreparationTemplate.prepareStatement(StatementPreparerImpl.java:172)
       ... 31 more
      May 27, 2021 2:25:41 PM org.apache.catalina.core.StandardContext startInternal
      SEVERE: One or more Filters failed to start. Full details will be found in the appropriate container log file
      May 27, 2021 2:25:41 PM org.apache.catalina.core.StandardContext startInternal
      SEVERE: Context [/grouper] startup failed due to previous errors
      May 27, 2021 2:25:41 PM org.apache.catalina.loader.WebappClassLoaderBase clearReferencesThreads
      WARNING: The web application [grouper] appears to have started a thread named [Thread-2] but has failed to stop it. This is very likely to create a memory leak. Stack trace of thread:
       java.util.zip.ZipFile.getEntry(ZipFile.java:314)
       java.util.jar.JarFile.getEntry(JarFile.java:240)
       java.util.jar.JarFile.getJarEntry(JarFile.java:223)
       org.apache.catalina.webresources.AbstractSingleArchiveResourceSet.getArchiveEntry(AbstractSingleArchiveResourceSet.java:97)
       org.apache.catalina.webresources.AbstractArchiveResourceSet.getResource(AbstractArchiveResourceSet.java:257)
       org.apache.catalina.webresources.StandardRoot.getResourceInternal(StandardRoot.java:280)
       org.apache.catalina.webresources.Cache.getResource(Cache.java:62)
       org.apache.catalina.webresources.StandardRoot.getResource(StandardRoot.java:215)
       org.apache.catalina.webresources.StandardRoot.getClassLoaderResource(StandardRoot.java:224)
       org.apache.catalina.loader.WebappClassLoaderBase.findClassInternal(WebappClassLoaderBase.java:2292)
       org.apache.catalina.loader.WebappClassLoaderBase.findClass(WebappClassLoaderBase.java:855)
       org.apache.catalina.loader.WebappClassLoaderBase.loadClass(WebappClassLoaderBase.java:1327)
       org.apache.catalina.loader.WebappClassLoaderBase.loadClass(WebappClassLoaderBase.java:1180)
       org.apache.log4j.spi.ThrowableInformation.getThrowableStrRep(ThrowableInformation.java:87)
       org.apache.log4j.spi.LoggingEvent.getThrowableStrRep(LoggingEvent.java:413)
       org.apache.log4j.WriterAppender.subAppend(WriterAppender.java:313)
       org.apache.log4j.WriterAppender.append(WriterAppender.java:162)
       org.apache.log4j.AppenderSkeleton.doAppend(AppenderSkeleton.java:251)
       org.apache.log4j.helpers.AppenderAttachableImpl.appendLoopOnAppenders(AppenderAttachableImpl.java:66)
       org.apache.log4j.Category.callAppenders(Category.java:206)
       org.apache.log4j.Category.forcedLog(Category.java:391)
       org.apache.log4j.Category.log(Category.java:856)
       org.apache.commons.logging.impl.Log4JLogger.error(Log4JLogger.java:229)
       edu.internet2.middleware.grouper.misc.GrouperStartup.startup(GrouperStartup.java:415)
       edu.internet2.middleware.grouper.app.loader.GrouperLoader.main(GrouperLoader.java:124)
       edu.internet2.middleware.grouper.j2ee.CommonServletContainerInitializer$1.run(CommonServletContainerInitializer.java:170)
       java.lang.Thread.run(Thread.java:748)
      May 27, 2021 2:25:41 PM org.apache.catalina.loader.WebappClassLoaderBase clearReferencesThreads
      WARNING: The web application [grouper] appears to have started a thread named [Thread-3] but has failed to stop it. This is very likely to create a memory leak. Stack trace of thread:
       java.lang.Thread.sleep(Native Method)
       edu.internet2.middleware.grouperClient.jdbc.GcDbQueryCacheMap$Janitor.run(GcDbQueryCacheMap.java:74)
       java.lang.Thread.run(Thread.java:748)
      May 27, 2021 2:25:41 PM org.apache.catalina.loader.WebappClassLoaderBase clearReferencesThreads
      WARNING: The web application [grouper] appears to have started a thread named [pool-5-thread-1] but has failed to stop it. This is very likely to create a memory leak. Stack trace of thread:
       java.lang.Thread.sleep(Native Method)
       edu.internet2.middleware.grouper.util.GrouperUtil.sleep(GrouperUtil.java:1360)
       edu.internet2.middleware.grouper.misc.GrouperStartup.waitForGrouperStartup(GrouperStartup.java:87)
       edu.internet2.middleware.grouper.instrumentation.InstrumentationThread$1.run(InstrumentationThread.java:77)
       java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
       java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
       java.lang.Thread.run(Thread.java:748)
      May 27, 2021 2:25:41 PM org.apache.catalina.loader.WebappClassLoaderBase clearReferencesThreads
      WARNING: The web application [grouper] appears to have started a thread named [Thread-5] but has failed to stop it. This is very likely to create a memory leak. Stack trace of thread:
       java.lang.Thread.sleep(Native Method)
       edu.internet2.middleware.grouper.util.GrouperUtil.sleep(GrouperUtil.java:1360)
       edu.internet2.middleware.grouper.subj.cache.SubjectSourceCache.subjectSourceCacheThread(SubjectSourceCache.java:237)
       edu.internet2.middleware.grouper.subj.cache.SubjectSourceCache$1.run(SubjectSourceCache.java:219)
       java.lang.Thread.run(Thread.java:748)
      May 27, 2021 2:25:41 PM org.apache.catalina.loader.WebappClassLoaderBase clearReferencesThreads
      WARNING: The web application [grouper] appears to have started a thread named [C3P0PooledConnectionPoolManager[identityToken->2szeaxah1ckru5r1k8xijw|7ccacb80]-HelperThread-#2] but has failed to stop it. This is very likely to create a memory leak. Stack trace of thread:
       java.net.SocketInputStream.socketRead0(Native Method)
       java.net.SocketInputStream.socketRead(SocketInputStream.java:116)
       java.net.SocketInputStream.read(SocketInputStream.java:171)
       java.net.SocketInputStream.read(SocketInputStream.java:141)
       java.io.BufferedInputStream.fill(BufferedInputStream.java:246)
       java.io.BufferedInputStream.read(BufferedInputStream.java:265)
       java.io.DataInputStream.readByte(DataInputStream.java:265)
       org.hsqldb.result.Result.newResult(Unknown Source)
       org.hsqldb.ClientConnection.read(Unknown Source)
       org.hsqldb.ClientConnection.execute(Unknown Source)
       org.hsqldb.ClientConnection.<init>(Unknown Source)
       org.hsqldb.jdbc.JDBCConnection.<init>(Unknown Source)
       org.hsqldb.jdbc.JDBCDriver.getConnection(Unknown Source)
       org.hsqldb.jdbc.JDBCDriver.connect(Unknown Source)
       com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(DriverManagerDataSource.java:175)
       com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:220)
       com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:206)
       com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1PooledConnectionResourcePoolManager.acquireResource(C3P0PooledConnectionPool.java:203)
       com.mchange.v2.resourcepool.BasicResourcePool.doAcquire(BasicResourcePool.java:1176)
       com.mchange.v2.resourcepool.BasicResourcePool.doAcquireAndDecrementPendingAcquiresWithinLockOnSuccess(BasicResourcePool.java:1163)
       com.mchange.v2.resourcepool.BasicResourcePool.access$700(BasicResourcePool.java:44)
       com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask.run(BasicResourcePool.java:1908)
       com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:696)
      2021-05-27 14:25:41,790: [Thread-2] ERROR GrouperStartup.startup(415) -  - Couldnt startup grouper: Problem in HibernateSession: HibernateSession (4f50bea9): new, readonly, READONLY_NEW, notActiveTransaction, session (202af341),
      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', 
      edu.internet2.middleware.grouper.internal.dao.GrouperDAOException: Problem in HibernateSession: HibernateSession (4f50bea9): new, readonly, READONLY_NEW, notActiveTransaction, session (202af341),
      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', 
       at edu.internet2.middleware.grouper.hibernate.HibernateSession._internal_hibernateSessionCatch(HibernateSession.java:591)
       at edu.internet2.middleware.grouper.hibernate.HibernateSession.callbackHibernateSession(HibernateSession.java:713)
       at edu.internet2.middleware.grouper.hibernate.ByHqlStatic.uniqueResult(ByHqlStatic.java:356)
       at edu.internet2.middleware.grouper.internal.dao.hib3.Hib3MemberDAO.findBySubject(Hib3MemberDAO.java:306)
       at edu.internet2.middleware.grouper.MemberFinder.internal_findOrCreateBySubject(MemberFinder.java:719)
       at edu.internet2.middleware.grouper.MemberFinder.internal_findBySubject(MemberFinder.java:634)
       at edu.internet2.middleware.grouper.MemberFinder.internal_findBySubject(MemberFinder.java:618)
       at edu.internet2.middleware.grouper.GrouperSession.start(GrouperSession.java:486)
       at edu.internet2.middleware.grouper.GrouperSession.startRootSession(GrouperSession.java:426)
       at edu.internet2.middleware.grouper.GrouperSession.internal_callbackRootGrouperSession(GrouperSession.java:1038)
       at edu.internet2.middleware.grouper.GrouperSession.internal_callbackRootGrouperSession(GrouperSession.java:1012)
       at edu.internet2.middleware.grouper.misc.GrouperStartup.startup(GrouperStartup.java:296)
       at edu.internet2.middleware.grouper.app.loader.GrouperLoader.main(GrouperLoader.java:124)
       at edu.internet2.middleware.grouper.j2ee.CommonServletContainerInitializer$1.run(CommonServletContainerInitializer.java:170)
       at java.lang.Thread.run(Thread.java:748)
      Caused by: org.hibernate.exception.SQLGrammarException: could not prepare statement
       at org.hibernate.exception.internal.SQLExceptionTypeDelegate.convert(SQLExceptionTypeDelegate.java:63)
       at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:42)
       at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:109)
       at org.hibernate.engine.jdbc.internal.StatementPreparerImpl$StatementPreparationTemplate.prepareStatement(StatementPreparerImpl.java:182)
       at org.hibernate.engine.jdbc.internal.StatementPreparerImpl.prepareQueryStatement(StatementPreparerImpl.java:148)
       at org.hibernate.loader.Loader.prepareQueryStatement(Loader.java:1929)
       at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1898)
       at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1876)
       at org.hibernate.loader.Loader.doQuery(Loader.java:919)
       at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:336)
       at org.hibernate.loader.Loader.doList(Loader.java:2617)
       at org.hibernate.loader.Loader.listUsingQueryCache(Loader.java:2459)
       at org.hibernate.loader.Loader.list(Loader.java:2421)
       at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:501)
       at org.hibernate.hql.internal.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:371)
       at org.hibernate.engine.query.spi.HQLQueryPlan.performList(HQLQueryPlan.java:216)
       at org.hibernate.internal.SessionImpl.list(SessionImpl.java:1326)
       at org.hibernate.internal.QueryImpl.list(QueryImpl.java:87)
       at org.hibernate.internal.AbstractQueryImpl.uniqueResult(AbstractQueryImpl.java:966)
       at edu.internet2.middleware.grouper.hibernate.ByHql.uniqueResult(ByHql.java:283)
       at edu.internet2.middleware.grouper.hibernate.ByHqlStatic$1.callback(ByHqlStatic.java:365)
       at edu.internet2.middleware.grouper.hibernate.HibernateSession.callbackHibernateSession(HibernateSession.java:703)
       ... 13 more
      Caused by: java.sql.SQLSyntaxErrorException: user lacks privilege or object not found: GROUPER_MEMBERS in statement [select member0_.id as id1_27_, member0_.hibernate_version_number as hibernat2_27_, member0_.subject_id as subject_3_27_, member0_.subject_source as subject_4_27_, member0_.subject_type as subject_5_27_, member0_.context_id as context_6_27_, member0_.subject_identifier0 as subject_7_27_, member0_.sort_string0 as sort_str8_27_, member0_.sort_string1 as sort_str9_27_, member0_.sort_string2 as sort_st10_27_, member0_.sort_string3 as sort_st11_27_, member0_.sort_string4 as sort_st12_27_, member0_.search_string0 as search_13_27_, member0_.search_string1 as search_14_27_, member0_.search_string2 as search_15_27_, member0_.search_string3 as search_16_27_, member0_.search_string4 as search_17_27_, member0_.name as name18_27_, member0_.description as descrip19_27_, member0_.subject_resolution_resolvable as subject20_27_, member0_.subject_resolution_deleted as subject21_27_ from grouper_members member0_ where member0_.subject_id=? and member0_.subject_source=? and member0_.subject_type=?]
       at org.hsqldb.jdbc.JDBCUtil.sqlException(Unknown Source)
       at org.hsqldb.jdbc.JDBCUtil.sqlException(Unknown Source)
       at org.hsqldb.jdbc.JDBCPreparedStatement.<init>(Unknown Source)
       at org.hsqldb.jdbc.JDBCConnection.prepareStatement(Unknown Source)
       at com.mchange.v2.c3p0.impl.NewProxyConnection.prepareStatement(NewProxyConnection.java:387)
       at org.hibernate.engine.jdbc.internal.StatementPreparerImpl$5.doPrepare(StatementPreparerImpl.java:146)
       at org.hibernate.engine.jdbc.internal.StatementPreparerImpl$StatementPreparationTemplate.prepareStatement(StatementPreparerImpl.java:172)
       ... 31 more
      May 27, 2021 2:25:41 PM org.apache.catalina.loader.WebappClassLoaderBase checkThreadLocalMapForLeaks
      SEVERE: The web application [grouper] created a ThreadLocal with key of type [java.lang.ThreadLocal] (value [java.lang.ThreadLocal@580a37bb]) and a value of type [edu.internet2.middleware.morphString.Crypto] (value [edu.internet2.middleware.morphString.Crypto@4848fe54]) but failed to remove it when the web application was stopped. Threads are going to be renewed over time to try and avoid a probable memory leak.
      2021-05-27 14:25:41,799: [Thread-2] ERROR CommonServletContainerInitializer$1.run(172) -  - error in loader. Problem in HibernateSession: HibernateSession (4f50bea9): new, readonly, READONLY_NEW, notActiveTransaction, session (202af341),
      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', 
      May 27, 2021 2:25:41 PM org.apache.catalina.loader.WebappClassLoaderBase checkThreadLocalMapForLeaks
      SEVERE: The web application [grouper] created a ThreadLocal with key of type [java.lang.ThreadLocal] (value [java.lang.ThreadLocal@186859b3]) and a value of type [edu.internet2.middleware.grouper.hibernate.GrouperContext] (value [edu.internet2.middleware.grouper.hibernate.GrouperContext@48ef825d]) but failed to remove it when the web application was stopped. Threads are going to be renewed over time to try and avoid a probable memory leak.
      May 27, 2021 2:25:41 PM org.apache.catalina.loader.WebappClassLoaderBase checkThreadLocalMapForLeaks
      SEVERE: The web application [grouper] created a ThreadLocal with key of type [java.lang.ThreadLocal] (value [java.lang.ThreadLocal@580a37bb]) and a value of type [edu.internet2.middleware.morphString.Crypto] (value [edu.internet2.middleware.morphString.Crypto@4151d314]) but failed to remove it when the web application was stopped. Threads are going to be renewed over time to try and avoid a probable memory leak.
      May 27, 2021 2:25:41 PM org.apache.coyote.AbstractProtocol start
      INFO: Starting ProtocolHandler ["http-nio-8400"]
      May 27, 2021 2:25:41 PM org.apache.catalina.startup.Catalina start
      INFO: Server startup in 19557 ms 

      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: