Skip to Content.
Sympa Menu

grouper-users - [grouper-users] RE: Upgrade DB from 2.2 -> 2.3, MySQL issues

Subject: Grouper Users - Open Discussion List

List archive

[grouper-users] RE: Upgrade DB from 2.2 -> 2.3, MySQL issues

Chronological Thread 
  • From: "Hyzer, Chris" <>
  • To: "Waldbieser, Carl" <>, Gouper Users List <>
  • Subject: [grouper-users] RE: Upgrade DB from 2.2 -> 2.3, MySQL issues
  • Date: Sun, 15 May 2016 20:22:50 +0000
  • Accept-language: en-US
  • Authentication-results:; dkim=none (message not signed) header.d=none;; dmarc=none action=none;
  • Spamdiagnosticmetadata: NSPM
  • Spamdiagnosticoutput: 1:23

Not sure why your subject table had a wrong value in there, maybe the
original script didn’t finish all the way?

You can add "-deep" to the call which will ignore those version numbers and
just interrogate your database.

Is your database utfmb4? Any chance it can just be utf8 bin? If not, you
can try increasing the max index value, I wasn’t aware you could do that :)


-----Original Message-----

On Behalf Of Waldbieser, Carl
Sent: Friday, May 13, 2016 3:34 PM
To: Gouper Users List
Subject: Re: [grouper-users] Upgrade DB from 2.2 -> 2.3, MySQL issues

After poking at this issue for a while, I changed the value of
"grouper_ddl.db_version" for the row with objectname == "Subject" from 1 to
I have no idea what this means, but after that, `gsh -registry -check`
generated a DDL script with the DROPs I'd expect.

My problem now is the following definition:

sched_name VARCHAR(120) NOT NULL,
job_name VARCHAR(200) NOT NULL,
job_group VARCHAR(200) NOT NULL,
description VARCHAR(250) NULL,
job_class_name VARCHAR(250) NOT NULL,
is_durable TINYINT(1) NOT NULL,
is_nonconcurrent TINYINT(1) NOT NULL,
is_update_data TINYINT(1) NOT NULL,
requests_recovery TINYINT(1) NOT NULL,
PRIMARY KEY (sched_name, job_name, job_group)

Specifically, I get the following error:

ERROR 1071 (42000) at line 153: Specified key was too long; max key length
is 1000 bytes

Have any other folks using MySQL run into this? I see there is a
StackExchange article [1] that talks about how this limit can be increased to
3072 bytes-- is that what others have done?

Carl Waldbieser
ITS Systems Programmer
Lafayette College


----- Original Message -----
From: "waldbiec"
To: "Gouper Users List"
Sent: Friday, May 13, 2016 1:52:28 PM
Subject: [grouper-users] Upgrade DB from 2.2 -> 2.3, MySQL issues

I tried upgrading my development instance of Grouper today from v2.2 to v2.3.
The software upgrade went pretty smoothly.

The generated SQL script is another story. The first statement in it is
`CREATE TABLE grouper_ddl`. This table already exists in my Grouper
database, so that's going to cause an error.

Is there something I am missing that has caused the SQL script that was
generated to *not* recognize a bunch of tables in my database? It appears as
though there are many CREATE TABLE statements in the script that already
exist in my database.

Any advice would be appreciated.

Carl Waldbieser
ITS Systems Programmer
Lafayette College

Archive powered by MHonArc 2.6.16.

Top of Page