grouper-users - [grouper-users] Grouper 2.2.0 exception

Subject: Grouper Users - Open Discussion List

List archive

[grouper-users] Grouper 2.2.0 exception

From: Rahul Doshi <>
To: "" <>
Subject: [grouper-users] Grouper 2.2.0 exception
Date: Thu, 17 Jul 2014 14:15:57 +0000
Accept-language: en-US

Hello,

I upgraded our grouper 2.1.4 dev environment with grouper 2.2.0 and when I ran gsh received exception below. Can anyone please assist me with this?

Thanks,

Rahul

[root@grouper-d01 bin]# ./gsh.sh

Using GROUPER_HOME: /opt/grouper/grouper.apiBinary-2.2.0/bin/..

Using GROUPER_CONF: /opt/grouper/grouper.apiBinary-2.2.0/bin/../conf

Using JAVA: java

using MEMORY: 64m-750m

Grouper starting up: version: 2.2.0, build date: 2014/07/05 12:00:03, env: <no label configured>

grouper.properties read from: /opt/grouper/grouper.apiBinary-2.2.0/conf/grouper.properties

Grouper current directory is: /opt/grouper/grouper.apiBinary-2.2.0/bin

log4j.properties read from: /opt/grouper/grouper.apiBinary-2.2.0/conf/log4j.properties

Grouper is logging to file: /opt/grouper/grouper.apiBinary-2.2.0/bin/../logs/grouper_error.log, at min level WARN for package: edu.internet2.middleware.grouper, based on log4j.properties

grouper.hibernate.properties: /opt/grouper/grouper.apiBinary-2.2.0/conf/grouper.hibernate.properties

grouper.hibernate.properties: grouper@jdbc:mysql://idm-dev-01.net.cmu.edu/grouper

sources.xml read from: /opt/grouper/grouper.apiBinary-2.2.0/conf/sources.xml

sources.xml groupersource id: g:gsa

sources.xml groupersource id: grouperEntities

sources.xml jdbc source id: jdbc: GrouperJdbcConnectionProvider

Grouper ddl object type 'Grouper' has dbVersion: 26 and java version: 28

NOTE: Grouper database schema DDL may require updates, but the temp change log must be empty to perform an upgrade. To process the temp change log, start up your current version of GSH and run: loaderRunOneJob("CHANGE_LOG_changeLogTempToChangeLog")

Couldnt startup grouper: Problem find stem by name: 'etc:legacy:attribute', Problem in HibernateSession: HibernateSession (766a25bb): new, readonly, READONLY_NEW, notActiveTransaction, session (6eb6add7),

Exception in uniqueResult: (class edu.internet2.middleware.grouper.Stem), ByHqlStatic, query: 'from Stem as ns where ns.nameDb = :name or ns.alternateNameDb = :name', cacheable: true, cacheRegion: edu.internet2.middleware.grouper.internal.dao.hib3.Hib3StemDAO.FindByName, tx type: null, tx type: nullBind var[0]: 'Param (class java.lang.String): 'name'->'etc:legacy:attribute',

edu.internet2.middleware.grouper.internal.dao.GrouperDAOException: Problem find stem by name: 'etc:legacy:attribute', Problem in HibernateSession: HibernateSession (766a25bb): new, readonly, READONLY_NEW, notActiveTransaction, session (6eb6add7),

at edu.internet2.middleware.grouper.internal.dao.hib3.Hib3StemDAO.findByName(Hib3StemDAO.java:1683)

at edu.internet2.middleware.grouper.StemFinder.findByName(StemFinder.java:176)

at edu.internet2.middleware.grouper.StemFinder.findByName(StemFinder.java:152)

at edu.internet2.middleware.grouper.misc.GrouperCheckConfig.legacyAttributeBaseStem(GrouperCheckConfig.java:2244)

at edu.internet2.middleware.grouper.misc.GrouperCheckConfig.checkAttributes(GrouperCheckConfig.java:1580)

at edu.internet2.middleware.grouper.misc.GrouperCheckConfig.checkConfig(GrouperCheckConfig.java:435)

at edu.internet2.middleware.grouper.misc.GrouperStartup.startup(GrouperStartup.java:243)

at edu.internet2.middleware.grouper.app.gsh.GrouperShell.main(GrouperShell.java:151)

at edu.internet2.middleware.grouper.app.gsh.GrouperShellWrapper.main(GrouperShellWrapper.java:31)

Caused by: edu.internet2.middleware.grouper.internal.dao.GrouperDAOException: Problem in HibernateSession: HibernateSession (766a25bb): new, readonly, READONLY_NEW, notActiveTransaction, session (6eb6add7),

at edu.internet2.middleware.grouper.hibernate.HibernateSession._internal_hibernateSessionCatch(HibernateSession.java:542)

at edu.internet2.middleware.grouper.hibernate.HibernateSession.callbackHibernateSession(HibernateSession.java:664)

at edu.internet2.middleware.grouper.hibernate.ByHqlStatic.uniqueResult(ByHqlStatic.java:323)

at edu.internet2.middleware.grouper.internal.dao.hib3.Hib3StemDAO.findByName(Hib3StemDAO.java:1668)

... 8 more

Caused by: org.hibernate.exception.SQLGrammarException: could not execute query

at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:92)

at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)

at org.hibernate.loader.Loader.doList(Loader.java:2536)

at org.hibernate.loader.Loader.listUsingQueryCache(Loader.java:2319)

at org.hibernate.loader.Loader.list(Loader.java:2268)

at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:452)

at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:363)

at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:196)

at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1268)

at org.hibernate.impl.QueryImpl.list(QueryImpl.java:102)

at org.hibernate.impl.AbstractQueryImpl.uniqueResult(AbstractQueryImpl.java:890)

at edu.internet2.middleware.grouper.hibernate.ByHql.uniqueResult(ByHql.java:268)

at edu.internet2.middleware.grouper.hibernate.ByHqlStatic$1.callback(ByHqlStatic.java:332)

at edu.internet2.middleware.grouper.hibernate.HibernateSession.callbackHibernateSession(HibernateSession.java:654)

... 10 more

Caused by: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Unknown column 'stem0_.id_index' in 'field list'

at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:936)

at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2985)

at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1631)

at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1723)

at com.mysql.jdbc.Connection.execSQL(Connection.java:3283)

at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1332)

at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1467)

at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:76)

at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:208)

at org.hibernate.loader.Loader.getResultSet(Loader.java:1953)

at org.hibernate.loader.Loader.doQuery(Loader.java:802)

at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:274)

at org.hibernate.loader.Loader.doList(Loader.java:2533)

... 21 more

Exception in thread "main" edu.internet2.middleware.grouper.internal.dao.GrouperDAOException: Problem find stem by name: 'etc:legacy:attribute', Problem in HibernateSession: HibernateSession (766a25bb): new, readonly, READONLY_NEW, notActiveTransaction, session (6eb6add7),