Skip to Content.
Sympa Menu

grouper-users - [grouper-users] RE: Grouper database schema DDL requires updates

Subject: Grouper Users - Open Discussion List

List archive

[grouper-users] RE: Grouper database schema DDL requires updates


Chronological Thread 
  • From: "Doppala, Karthik" <>
  • To: Chris Hyzer <>
  • Cc: "" <>
  • Subject: [grouper-users] RE: Grouper database schema DDL requires updates
  • Date: Fri, 25 Apr 2014 19:14:50 +0000
  • Accept-language: en-US

Thanks Chris, that helped we copied the schema without any data so obviously it couldn’t find the version at start up. Just curious, what is GroupOrg? I see that the first two rows are created when we setup the registry.

 

From: Chris Hyzer [mailto:]
Sent: Friday, April 25, 2014 11:01 AM
To: Doppala, Karthik
Cc:
Subject: RE: Grouper database schema DDL requires updates

 

What does your grouper_ddl table have in it?

 

The Grouper entry should be 26 I believe…  if that matches what Grouper expects then it should not bomb on startup… (if you are sure all the db objects are up to date)

 

Chris

 

 

From: Doppala, Karthik []
Sent: Friday, April 25, 2014 1:53 PM
To: Chris Hyzer
Cc:
Subject: Grouper database schema DDL requires updates

 

Hi,

We are currently upgrading to 2.1.5 and as part of the upgrade we made some modifications to our grouper database schema including changing data type to nvachar and removing few indexes. This was based on some analysis we did on our SQL Server database. I am unable to get the loader running as Grouper throws an error requiring a DDL update. The first time I started gsh yesterday against the new db schema I got the same error, I ran the “gsh –registry -check” couple of times without updating the schema and gsh did work. I was even able to set up the loader from UI but when I came in today to run the loader I get the same error I previously got. I am not sure what might have corrupted the schema, has anyone encountered a similar thing before? I would appreciate your response.

 

 

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

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:

/usr/local/gmt-util/ddlScripts/grouperDdl_20140425_10_19_43_200.sql

 

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.<init>(HibernateSession.java:129)

        at edu.internet2.middleware.grouper.hibernate.HibernateSession._internal_hibernateSession(HibernateSession.java:393)

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

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

        at edu.internet2.middleware.grouper.internal.dao.hib3.Hib3MemberDAO.findBySubject(Hib3MemberDAO.java:296)

        at edu.internet2.middleware.grouper.internal.dao.hib3.Hib3MemberDAO.findBySubject(Hib3MemberDAO.java:202)

        at edu.internet2.middleware.grouper.MemberFinder.internal_findOrCreateBySubject(MemberFinder.java:346)

        at edu.internet2.middleware.grouper.MemberFinder.internal_findBySubject(MemberFinder.java:312)

        at edu.internet2.middleware.grouper.GrouperSession.start(GrouperSession.java:429)

        at edu.internet2.middleware.grouper.GrouperSession.startRootSession(GrouperSession.java:379)

        at edu.internet2.middleware.grouper.GrouperSession.startRootSession(GrouperSession.java:397)

        at edu.internet2.middleware.grouper.misc.GrouperCheckConfig.checkGroups(GrouperCheckConfig.java:475)

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

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

        at edu.internet2.middleware.grouper.app.loader.GrouperLoader.main(GrouperLoader.java:90)

        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)

        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

        at java.lang.reflect.Method.invoke(Method.java:606)

        at edu.internet2.middleware.grouper.app.gsh.GrouperShell.handleSpecialCase(GrouperShell.java:204)

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

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

Exception in thread "main" java.lang.RuntimeException: java.lang.reflect.InvocationTargetException

        at edu.internet2.middleware.grouper.app.gsh.GrouperShell.handleSpecialCase(GrouperShell.java:214)

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

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

Caused by: java.lang.reflect.InvocationTargetException

        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)

        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

        at java.lang.reflect.Method.invoke(Method.java:606)

        at edu.internet2.middleware.grouper.app.gsh.GrouperShell.handleSpecialCase(GrouperShell.java:204)

        ... 2 more

Caused by: java.lang.RuntimeException: Database schema ddl is not up to date, or has issues, check logs and config ddl in grouper.properties and run: gsh -registry -check,

Problem in HibernateSession: null,

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.<init>(HibernateSession.java:129)

        at edu.internet2.middleware.grouper.hibernate.HibernateSession._internal_hibernateSession(HibernateSession.java:393)

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

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

        at edu.internet2.middleware.grouper.internal.dao.hib3.Hib3MemberDAO.findBySubject(Hib3MemberDAO.java:296)

        at edu.internet2.middleware.grouper.internal.dao.hib3.Hib3MemberDAO.findBySubject(Hib3MemberDAO.java:202)

        at edu.internet2.middleware.grouper.MemberFinder.internal_findOrCreateBySubject(MemberFinder.java:346)

        at edu.internet2.middleware.grouper.MemberFinder.internal_findBySubject(MemberFinder.java:312)

        at edu.internet2.middleware.grouper.GrouperSession.start(GrouperSession.java:429)

        at edu.internet2.middleware.grouper.GrouperSession.startRootSession(GrouperSession.java:379)

        at edu.internet2.middleware.grouper.GrouperSession.startRootSession(GrouperSession.java:397)

        at edu.internet2.middleware.grouper.misc.GrouperCheckConfig.checkGroups(GrouperCheckConfig.java:475)

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

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

        at edu.internet2.middleware.grouper.app.loader.GrouperLoader.main(GrouperLoader.java:90)

 

 

Thanks,

Karthik




Archive powered by MHonArc 2.6.16.

Top of Page