Grouper Users - Open Discussion List

[Rahul Doshi <>]

We are doing another upgrade in the development environment and will keep lot more details about each step.  We will let you know if we see the same issue running post upgrade script again.

Thanks,

Rahul

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

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'