Skip to Content.
Sympa Menu

grouper-users - Re: [grouper-users] grouper post upgrade script error

Subject: Grouper Users - Open Discussion List

List archive

Re: [grouper-users] grouper post upgrade script error


Chronological Thread 
  • From: Rahul Doshi <>
  • To: Shilen Patel <>, "" <>
  • Subject: Re: [grouper-users] grouper post upgrade script error
  • Date: Wed, 26 Nov 2014 18:09:53 +0000
  • Accept-language: en-US

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'





Archive powered by MHonArc 2.6.16.

Top of Page