Grouper Users - Open Discussion List

[Colin Hudler <>]

hi,

Following instructions from
<https://spaces.internet2.edu/display/GrouperWG/v1.5.0+Upgrade+Instructions+from+v1.4.2>
Method 1 again.  First, starting from a totally empty database, running

./bin/gsh.sh -registry -runscript

I get the massive stack trace, which is attached to this email (trace1). 
 It seems to hinge on "Specified key was too long; max key length is 
1000 bytes".  This might be related to 
<https://bugs.internet2.edu/jira/browse/GRP-197>.  This defect appears 
to be fixed, which is my question.  Should I pursue a fix in the 
database or alter the DDL?

If I run the command against a db with ddlVersion: 13, but all data 
truncated (including grouper_ddl), per instructions "Drop all of the 
Grouper objects from your database", it fails differently (trace2).  I 
now realize this is probably not what is intended by the "drop all 
grouper objects" statement, perhaps it means to literally drop the 
tables/structures (as I first tried to do)?

Finally, if I truncate all tables EXCEPT ddlVersion, I get no error. 
But should I trust it?  FWIW, in this case, I would prefer it create a 
clean new database to insert the exported xml into.
Using GROUPER_HOME: /srv/grouper/api-1.5.2
Using GROUPER_CONF: /srv/grouper/api-1.5.2/conf
Using JAVA: java
using MEMORY: 64m-512m
Grouper starting up: version: 1.5.2, build date: 2010/04/06 09:17:42, env: 
production
grouper.properties read from: /srv/grouper/api-1.5.2/conf/grouper.properties
Grouper current directory is: /srv/grouper/api-1.5.2
log4j.properties read from:   /srv/grouper/api-1.5.2/conf/log4j.properties
Grouper is logging to file:   /srv/grouper/logs/grouper_error.log, at min 
level WARN for package: edu.internet2.middleware.grouper, based on 
log4j.properties
grouper.hibernate.properties: 
/srv/grouper/api-1.5.2/conf/grouper.hibernate.properties
grouper.hibernate.properties: 
grouper@jdbc:mysql://localhost:3306/test_grouper
sources.xml read from:        /srv/grouper/api-1.5.2/conf/sources.xml
sources.xml groupersource id: g:gsa
sources.xml jdbc source id:   jdbc: GrouperJdbcConnectionProvider
(note, might need to type in your response multiple times (Java stdin is 
flaky))
(note, you can whitelist or blacklist db urls and users in the 
grouper.properties)
Are you sure you want to schemaexport all tables 
(dropThenCreate=F,writeAndRunScript=T) in db user 'grouper', db url 
'jdbc:mysql://localhost:3306/test_grouper'? (y|n): 
Continuing...
Grouper ddl object type 'Grouper' has dbVersion: 0 and java version: 22
Grouper ddl object type 'Subject' has dbVersion: 0 and java version: 1
Grouper database schema DDL requires updates
(should run script manually and carefully, in sections, verify data before 
drop statements, backup/export important data before starting, follow change 
log on confluence, dont run exact same script in multiple envs - generate a 
new one for each env),
script file is:
/srv/grouper/api-1.5.2/ddlScripts/grouperDdl_20100406_11_00_18_877.sql
Error running script: 
/srv/grouper/api-1.5.2/ddlScripts/grouperDdl_20100406_11_00_18_877.sql, 
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Specified key was 
too long; max key length is 1000 bytes
        at org.apache.tools.ant.taskdefs.SQLExec.execute(SQLExec.java:463)
        at 
edu.internet2.middleware.grouper.ddl.GrouperDdlUtils.sqlRun(GrouperDdlUtils.java:805)
        at 
edu.internet2.middleware.grouper.ddl.GrouperDdlUtils.bootstrapHelper(GrouperDdlUtils.java:671)
        at 
edu.internet2.middleware.grouper.registry.RegistryInitializeSchema.main(RegistryInitializeSchema.java:157)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at 
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
        at 
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:597)
        at 
edu.internet2.middleware.grouper.app.gsh.GrouperShell.handleSpecialCase(GrouperShell.java:176)
        at 
edu.internet2.middleware.grouper.app.gsh.GrouperShell.main(GrouperShell.java:116)
        at 
edu.internet2.middleware.grouper.app.gsh.GrouperShellWrapper.main(GrouperShellWrapper.java:16)
Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: 
Specified key was too long; max key length is 1000 bytes
        at sun.reflect.GeneratedConstructorAccessor12.newInstance(Unknown 
Source)
        at 
sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
        at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
        at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)
        at com.mysql.jdbc.Util.getInstance(Util.java:381)
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1030)
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3491)
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3423)
        at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1936)
        at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2060)
        at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2536)
        at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2465)
        at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:734)
        at org.apache.tools.ant.taskdefs.SQLExec.execSQL(SQLExec.java:565)
        at 
org.apache.tools.ant.taskdefs.SQLExec.runStatements(SQLExec.java:535)
        at 
org.apache.tools.ant.taskdefs.SQLExec$Transaction.runTransaction(SQLExec.java:776)
        at 
org.apache.tools.ant.taskdefs.SQLExec$Transaction.access$000(SQLExec.java:706)
        at org.apache.tools.ant.taskdefs.SQLExec.execute(SQLExec.java:449)
        ... 10 more
--- Nested Exception ---
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Specified key was 
too long; max key length is 1000 bytes
        at sun.reflect.GeneratedConstructorAccessor12.newInstance(Unknown 
Source)
        at 
sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
        at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
        at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)
        at com.mysql.jdbc.Util.getInstance(Util.java:381)
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1030)
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3491)
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3423)
        at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1936)
        at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2060)
        at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2536)
        at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2465)
        at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:734)
        at org.apache.tools.ant.taskdefs.SQLExec.execSQL(SQLExec.java:565)
        at 
org.apache.tools.ant.taskdefs.SQLExec.runStatements(SQLExec.java:535)
        at 
org.apache.tools.ant.taskdefs.SQLExec$Transaction.runTransaction(SQLExec.java:776)
        at 
org.apache.tools.ant.taskdefs.SQLExec$Transaction.access$000(SQLExec.java:706)
        at org.apache.tools.ant.taskdefs.SQLExec.execute(SQLExec.java:449)
        at 
edu.internet2.middleware.grouper.ddl.GrouperDdlUtils.sqlRun(GrouperDdlUtils.java:805)
        at 
edu.internet2.middleware.grouper.ddl.GrouperDdlUtils.bootstrapHelper(GrouperDdlUtils.java:671)
        at 
edu.internet2.middleware.grouper.registry.RegistryInitializeSchema.main(RegistryInitializeSchema.java:157)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at 
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
        at 
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:597)
        at 
edu.internet2.middleware.grouper.app.gsh.GrouperShell.handleSpecialCase(GrouperShell.java:176)
        at 
edu.internet2.middleware.grouper.app.gsh.GrouperShell.main(GrouperShell.java:116)
        at 
edu.internet2.middleware.grouper.app.gsh.GrouperShellWrapper.main(GrouperShellWrapper.java:16)


edu.internet2.middleware.grouper.exception.GrouperException: unable to 
initialize registry: Problem in HibernateSession: HibernateSession: isNew: 
true, isReadonly: true, grouperTransactionType: READONLY_NEW,
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.registry.RegistryInstall.install(RegistryInstall.java:91)
        at 
edu.internet2.middleware.grouper.ddl.GrouperDdlUtils.bootstrapHelper(GrouperDdlUtils.java:702)
        at 
edu.internet2.middleware.grouper.registry.RegistryInitializeSchema.main(RegistryInitializeSchema.java:157)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at 
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
        at 
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:597)
        at 
edu.internet2.middleware.grouper.app.gsh.GrouperShell.handleSpecialCase(GrouperShell.java:176)
        at 
edu.internet2.middleware.grouper.app.gsh.GrouperShell.main(GrouperShell.java:116)
        at 
edu.internet2.middleware.grouper.app.gsh.GrouperShellWrapper.main(GrouperShellWrapper.java:16)
Caused by: edu.internet2.middleware.grouper.internal.dao.GrouperDAOException: 
Problem in HibernateSession: HibernateSession: isNew: true, isReadonly: true, 
grouperTransactionType: READONLY_NEW,
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:358)
        at 
edu.internet2.middleware.grouper.hibernate.HibernateSession.callbackHibernateSession(HibernateSession.java:444)
        at 
edu.internet2.middleware.grouper.hibernate.ByHqlStatic.uniqueResult(ByHqlStatic.java:297)
        at 
edu.internet2.middleware.grouper.internal.dao.hib3.Hib3MemberDAO.findBySubject(Hib3MemberDAO.java:179)
        at 
edu.internet2.middleware.grouper.internal.dao.hib3.Hib3MemberDAO.findBySubject(Hib3MemberDAO.java:161)
        at 
edu.internet2.middleware.grouper.MemberFinder.internal_findOrCreateBySubject(MemberFinder.java:269)
        at 
edu.internet2.middleware.grouper.MemberFinder.internal_findBySubject(MemberFinder.java:240)
        at 
edu.internet2.middleware.grouper.GrouperSession.start(GrouperSession.java:271)
        at 
edu.internet2.middleware.grouper.registry.RegistryInstall.install(RegistryInstall.java:61)
        ... 9 more
Caused by: org.hibernate.exception.SQLGrammarException: could not execute 
query
        at 
org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:67)
        at 
org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
        at org.hibernate.loader.Loader.doList(Loader.java:2216)
        at org.hibernate.loader.Loader.listUsingQueryCache(Loader.java:2136)
        at org.hibernate.loader.Loader.list(Loader.java:2096)
        at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:378)
        at 
org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:338)
        at 
org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:172)
        at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1121)
        at org.hibernate.impl.QueryImpl.list(QueryImpl.java:79)
        at 
org.hibernate.impl.AbstractQueryImpl.uniqueResult(AbstractQueryImpl.java:811)
        at 
edu.internet2.middleware.grouper.hibernate.ByHql.uniqueResult(ByHql.java:242)
        at 
edu.internet2.middleware.grouper.hibernate.ByHqlStatic$1.callback(ByHqlStatic.java:306)
        at 
edu.internet2.middleware.grouper.hibernate.HibernateSession.callbackHibernateSession(HibernateSession.java:434)
        ... 16 more
Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 
'test_grouper.grouper_members' doesn't exist
        at sun.reflect.GeneratedConstructorAccessor12.newInstance(Unknown 
Source)
        at 
sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
        at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
        at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)
        at com.mysql.jdbc.Util.getInstance(Util.java:381)
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1030)
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3491)
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3423)
        at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1936)
        at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2060)
        at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2542)
        at 
com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1734)
        at 
com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1885)
        at 
com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:76)
        at 
org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:186)
        at org.hibernate.loader.Loader.getResultSet(Loader.java:1787)
        at org.hibernate.loader.Loader.doQuery(Loader.java:674)
        at 
org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:236)
        at org.hibernate.loader.Loader.doList(Loader.java:2213)
        ... 27 more
Exception in thread "main" java.lang.RuntimeException: 
java.lang.reflect.InvocationTargetException
        at 
edu.internet2.middleware.grouper.app.gsh.GrouperShell.handleSpecialCase(GrouperShell.java:181)
        at 
edu.internet2.middleware.grouper.app.gsh.GrouperShell.main(GrouperShell.java:116)
        at 
edu.internet2.middleware.grouper.app.gsh.GrouperShellWrapper.main(GrouperShellWrapper.java:16)
Caused by: java.lang.reflect.InvocationTargetException
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at 
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
        at 
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:597)
        at 
edu.internet2.middleware.grouper.app.gsh.GrouperShell.handleSpecialCase(GrouperShell.java:176)
        ... 2 more
Caused by: java.lang.RuntimeException: 
edu.internet2.middleware.grouper.exception.GrouperException: unable to 
initialize registry: Problem in HibernateSession: HibernateSession: isNew: 
true, isReadonly: true, grouperTransactionType: READONLY_NEW,
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.registry.RegistryInitializeSchema.main(RegistryInitializeSchema.java:178)
        ... 7 more
Caused by: edu.internet2.middleware.grouper.exception.GrouperException: 
unable to initialize registry: Problem in HibernateSession: HibernateSession: 
isNew: true, isReadonly: true, grouperTransactionType: READONLY_NEW,
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.registry.RegistryInstall.install(RegistryInstall.java:91)
        at 
edu.internet2.middleware.grouper.ddl.GrouperDdlUtils.bootstrapHelper(GrouperDdlUtils.java:702)
        at 
edu.internet2.middleware.grouper.registry.RegistryInitializeSchema.main(RegistryInitializeSchema.java:157)
        ... 7 more
Caused by: edu.internet2.middleware.grouper.internal.dao.GrouperDAOException: 
Problem in HibernateSession: HibernateSession: isNew: true, isReadonly: true, 
grouperTransactionType: READONLY_NEW,
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:358)
        at 
edu.internet2.middleware.grouper.hibernate.HibernateSession.callbackHibernateSession(HibernateSession.java:444)
        at 
edu.internet2.middleware.grouper.hibernate.ByHqlStatic.uniqueResult(ByHqlStatic.java:297)
        at 
edu.internet2.middleware.grouper.internal.dao.hib3.Hib3MemberDAO.findBySubject(Hib3MemberDAO.java:179)
        at 
edu.internet2.middleware.grouper.internal.dao.hib3.Hib3MemberDAO.findBySubject(Hib3MemberDAO.java:161)
        at 
edu.internet2.middleware.grouper.MemberFinder.internal_findOrCreateBySubject(MemberFinder.java:269)
        at 
edu.internet2.middleware.grouper.MemberFinder.internal_findBySubject(MemberFinder.java:240)
        at 
edu.internet2.middleware.grouper.GrouperSession.start(GrouperSession.java:271)
        at 
edu.internet2.middleware.grouper.registry.RegistryInstall.install(RegistryInstall.java:61)
        ... 9 more
Caused by: org.hibernate.exception.SQLGrammarException: could not execute 
query
        at 
org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:67)
        at 
org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
        at org.hibernate.loader.Loader.doList(Loader.java:2216)
        at org.hibernate.loader.Loader.listUsingQueryCache(Loader.java:2136)
        at org.hibernate.loader.Loader.list(Loader.java:2096)
        at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:378)
        at 
org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:338)
        at 
org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:172)
        at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1121)
        at org.hibernate.impl.QueryImpl.list(QueryImpl.java:79)
        at 
org.hibernate.impl.AbstractQueryImpl.uniqueResult(AbstractQueryImpl.java:811)
        at 
edu.internet2.middleware.grouper.hibernate.ByHql.uniqueResult(ByHql.java:242)
        at 
edu.internet2.middleware.grouper.hibernate.ByHqlStatic$1.callback(ByHqlStatic.java:306)
        at 
edu.internet2.middleware.grouper.hibernate.HibernateSession.callbackHibernateSession(HibernateSession.java:434)
        ... 16 more
Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 
'test_grouper.grouper_members' doesn't exist
        at sun.reflect.GeneratedConstructorAccessor12.newInstance(Unknown 
Source)
        at 
sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
        at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
        at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)
        at com.mysql.jdbc.Util.getInstance(Util.java:381)
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1030)
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3491)
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3423)
        at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1936)
        at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2060)
        at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2542)
        at 
com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1734)
        at 
com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1885)
        at 
com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:76)
        at 
org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:186)
        at org.hibernate.loader.Loader.getResultSet(Loader.java:1787)
        at org.hibernate.loader.Loader.doQuery(Loader.java:674)
        at 
org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:236)
        at org.hibernate.loader.Loader.doList(Loader.java:2213)
        ... 27 more
Using GROUPER_HOME: /srv/grouper/api-1.5.2
Using GROUPER_CONF: /srv/grouper/api-1.5.2/conf
Using JAVA: java
using MEMORY: 64m-512m
Grouper starting up: version: 1.5.2, build date: 2010/04/06 09:17:42, env: 
production
grouper.properties read from: /srv/grouper/api-1.5.2/conf/grouper.properties
Grouper current directory is: /srv/grouper/api-1.5.2
log4j.properties read from:   /srv/grouper/api-1.5.2/conf/log4j.properties
Grouper is logging to file:   /srv/grouper/logs/grouper_error.log, at min 
level WARN for package: edu.internet2.middleware.grouper, based on 
log4j.properties
grouper.hibernate.properties: 
/srv/grouper/api-1.5.2/conf/grouper.hibernate.properties
grouper.hibernate.properties: 
grouper@jdbc:mysql://localhost:3306/new_grouper
sources.xml read from:        /srv/grouper/api-1.5.2/conf/sources.xml
sources.xml groupersource id: g:gsa
sources.xml jdbc source id:   jdbc: GrouperJdbcConnectionProvider
(note, might need to type in your response multiple times (Java stdin is 
flaky))
(note, you can whitelist or blacklist db urls and users in the 
grouper.properties)
Are you sure you want to schemaexport all tables 
(dropThenCreate=F,writeAndRunScript=T) in db user 'grouper', db url 
'jdbc:mysql://localhost:3306/new_grouper'? (y|n): 
Continuing...
Grouper ddl object type 'Grouper' has dbVersion: 0 and java version: 22
java.lang.RuntimeException: Cant find table: 'grouper_memberships' columns: 
'owner_group_id', perhaps you need to rollback your ddl version in the DB and 
sync up
        at 
edu.internet2.middleware.grouper.ddl.GrouperDdlUtils.ddlutilsFindColumn(GrouperDdlUtils.java:2014)
        at 
edu.internet2.middleware.grouper.ddl.GrouperDdlUtils.ddlutilsFindOrCreateIndex(GrouperDdlUtils.java:1850)
        at 
edu.internet2.middleware.grouper.ddl.GrouperDdlUtils.ddlutilsFindOrCreateIndex(GrouperDdlUtils.java:1784)
        at 
edu.internet2.middleware.grouper.ddl.GrouperDdl.addMembershipFieldIndexes(GrouperDdl.java:5210)
        at 
edu.internet2.middleware.grouper.ddl.GrouperDdl.access$600(GrouperDdl.java:58)
        at 
edu.internet2.middleware.grouper.ddl.GrouperDdl$21.updateVersionFromPrevious(GrouperDdl.java:1500)
        at 
edu.internet2.middleware.grouper.ddl.GrouperDdlUtils.upgradeDatabaseVersion(GrouperDdlUtils.java:1752)
        at 
edu.internet2.middleware.grouper.ddl.GrouperDdlUtils.bootstrapHelper(GrouperDdlUtils.java:521)
        at 
edu.internet2.middleware.grouper.registry.RegistryInitializeSchema.main(RegistryInitializeSchema.java:157)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at 
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
        at 
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:597)
        at 
edu.internet2.middleware.grouper.app.gsh.GrouperShell.handleSpecialCase(GrouperShell.java:176)
        at 
edu.internet2.middleware.grouper.app.gsh.GrouperShell.main(GrouperShell.java:116)
        at 
edu.internet2.middleware.grouper.app.gsh.GrouperShellWrapper.main(GrouperShellWrapper.java:16)
Exception in thread "main" java.lang.RuntimeException: 
java.lang.reflect.InvocationTargetException
        at 
edu.internet2.middleware.grouper.app.gsh.GrouperShell.handleSpecialCase(GrouperShell.java:181)
        at 
edu.internet2.middleware.grouper.app.gsh.GrouperShell.main(GrouperShell.java:116)
        at 
edu.internet2.middleware.grouper.app.gsh.GrouperShellWrapper.main(GrouperShellWrapper.java:16)
Caused by: java.lang.reflect.InvocationTargetException
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at 
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
        at 
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:597)
        at 
edu.internet2.middleware.grouper.app.gsh.GrouperShell.handleSpecialCase(GrouperShell.java:176)
        ... 2 more
Caused by: java.lang.RuntimeException: java.lang.RuntimeException: Cant find 
table: 'grouper_memberships' columns: 'owner_group_id', perhaps you need to 
rollback your ddl version in the DB and sync up
        at 
edu.internet2.middleware.grouper.registry.RegistryInitializeSchema.main(RegistryInitializeSchema.java:178)
        ... 7 more
Caused by: java.lang.RuntimeException: Cant find table: 'grouper_memberships' 
columns: 'owner_group_id', perhaps you need to rollback your ddl version in 
the DB and sync up
        at 
edu.internet2.middleware.grouper.ddl.GrouperDdlUtils.ddlutilsFindColumn(GrouperDdlUtils.java:2014)
        at 
edu.internet2.middleware.grouper.ddl.GrouperDdlUtils.ddlutilsFindOrCreateIndex(GrouperDdlUtils.java:1850)
        at 
edu.internet2.middleware.grouper.ddl.GrouperDdlUtils.ddlutilsFindOrCreateIndex(GrouperDdlUtils.java:1784)
        at 
edu.internet2.middleware.grouper.ddl.GrouperDdl.addMembershipFieldIndexes(GrouperDdl.java:5210)
        at 
edu.internet2.middleware.grouper.ddl.GrouperDdl.access$600(GrouperDdl.java:58)
        at 
edu.internet2.middleware.grouper.ddl.GrouperDdl$21.updateVersionFromPrevious(GrouperDdl.java:1500)
        at 
edu.internet2.middleware.grouper.ddl.GrouperDdlUtils.upgradeDatabaseVersion(GrouperDdlUtils.java:1752)
        at 
edu.internet2.middleware.grouper.ddl.GrouperDdlUtils.bootstrapHelper(GrouperDdlUtils.java:521)
        at 
edu.internet2.middleware.grouper.registry.RegistryInitializeSchema.main(RegistryInitializeSchema.java:157)
        ... 7 more