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

Subject: Grouper Users - Open Discussion List

List archive

[grouper-users] RE: Grouper 2.2.0 exception

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

: Unknown column 'stem0_.id_index' in 'field list'

Did you do the gsh -registry -check and run the sql to add that column to the grouper_stems table? Was that column in the sql script? Do you see that column (id_index) in grouper_stems now? Note, there are a lot more DDL changes than just that…

What happens when you do that command now, does it have updates to run?

Thanks,

Chris

From: [mailto:] On Behalf Of Rahul Doshi
Sent: Thursday, July 17, 2014 10:16 AM
To:
Subject: [grouper-users] Grouper 2.2.0 exception

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:

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),