Grouper Users - Open Discussion List

[Rahul Doshi <>]

Both the tables have the same set of columns.  I didn’t take the backup of database since it was just test environment upgrade.

CREATE TABLE `grouper_fields` (

  `id` varchar(40) NOT NULL,

  `name` varchar(32) NOT NULL,

  `read_privilege` varchar(32) NOT NULL,

  `type` varchar(32) NOT NULL,

  `write_privilege` varchar(32) NOT NULL,

  `hibernate_version_number` bigint(20) DEFAULT NULL,

  `context_id` varchar(40) DEFAULT NULL,

  PRIMARY KEY (`id`),

  UNIQUE KEY `name_and_type` (`name`,`type`),

  KEY `fields_context_idx` (`context_id`),

  KEY `grouper_fields_type_idx` (`type`)

) ENGINE=MyISAM DEFAULT CHARSET=latin1$$

CREATE TABLE `grouper_fields_legacy` (

  `id` varchar(40) NOT NULL,

  `name` varchar(32) NOT NULL,

  `read_privilege` varchar(32) NOT NULL,

  `type` varchar(32) NOT NULL,

  `write_privilege` varchar(32) NOT NULL,

  `hibernate_version_number` bigint(20) DEFAULT NULL,

  `context_id` varchar(40) DEFAULT NULL

) ENGINE=MyISAM DEFAULT CHARSET=latin1$$

Thanks,

Rahul

From: Shilen Patel <>
Date: Wednesday, November 26, 2014 at 12:58 PM
To: Rahul Doshi <>, "" <>
Subject: Re: [grouper-users] grouper post upgrade script error

What columns do you have in your grouper_fields and grouper_fields_legacy tables right now?  Do you have a backup of your database before doing any of the upgrade steps that you can use to revert back to?

Thanks!

— Shilen

From: Rahul Doshi <>
Date: Wednesday, November 26, 2014 at 12:32 PM
To: "" <>
Subject: Re: [grouper-users] grouper post upgrade script error

I just used  -registry –check every time.  Once script terminated because it couldn’t write to /tmp.  So I cleaned up ddl and other log files and regenerated script.   Unfortunately I just have the last script that I ran.

Thanks,

Rahul

From: Shilen Patel <>
Date: Wednesday, November 26, 2014 at 12:14 PM
To: Rahul Doshi <>, "" <>
Subject: Re: [grouper-users] grouper post upgrade script error

Did you run the upgrader or –registry –check before this?  In the attached sql file, I don’t see the upgrade having happened there.  That file suggests the db was already at 2.2.1.

Thanks!

— Shilen

From: Rahul Doshi <>
Date: Wednesday, November 26, 2014 at 12:05 PM
To: Shilen Patel <>, "" <>
Subject: Re: [grouper-users] grouper post upgrade script error

I generated the script running –registry –check –deep.  

Thanks,

Rahul

From: Shilen Patel <>
Date: Wednesday, November 26, 2014 at 11:36 AM
To: Rahul Doshi <>, "" <>
Subject: Re: [grouper-users] grouper post upgrade script error

How did you do the upgrade?  The new upgrader or manually running –registry –check?  Either way, do you mind sending me the sql file?

— Shilen

From: Rahul Doshi <>
Date: Wednesday, November 26, 2014 at 11:02 AM
To: "" <>
Subject: [grouper-users] grouper post upgrade script error

Hello,

When I ran  ./bin/gsh.sh misc/postGrouper2_2Upgrade.gsh after upgrading grouper from 2.1.4 to 2.2.1 I received error below. Is it a bug in the post upgrade script?

Thanks,

Rahul

Searching for legacy attributes

// Error: unable to evaluate command: Sourced file: inline evaluation of: ``new MigrateLegacyAttributes().saveUpdates(true).fullMigration();'' : Method Invocation fullMigration

// See error log for full stacktrace

// caused by: java.lang.RuntimeException:

// Problem with query in listSelect: select grouptype_uuid, name from grouper_fields_legacy where type='attribute',

Problem in HibernateSession: HibernateSession (72849cc9): new, notReadonly, READ_WRITE_NEW, notActiveTransaction, session (101e0247)

// caused by: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException:

// Unknown column 'grouptype_uuid' in 'field list'