|
OK, I think there is a scenario where if the sql script fails the first time in just the right spot, it can lead to the problems that you saw. I’m not sure if that’s exactly what happened to you, but in any case, I just added a fix for the issue I saw.
The fix is in the 2.2 branch and will be in 2.2.2.
Thanks!
— Shilen
From: Rahul Doshi <>
Date: Wednesday, November 26, 2014 at 1:30 PM
To: Shilen Patel <>, "" <>
Subject: Re: [grouper-users] grouper post upgrade script error
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'
|
