grouper-users - RE: [grouper-users] Re: Upgrade DB from 2.2 -> 2.3, MySQL issues
Please Wait...
grouper-users@internet2.edu
Subject: Grouper Users - Open Discussion List
List archive
- From: "Hyzer, Chris" <mchyzer@isc.upenn.edu>
- To: Brett Bieber <bieber@unl.edu>, "Waldbieser, Carl" <waldbiec@lafayette.edu>
- Cc: Gouper Users List <grouper-users@internet2.edu>
- Subject: RE: [grouper-users] Re: Upgrade DB from 2.2 -> 2.3, MySQL issues
- Date: Wed, 25 May 2016 16:36:03 +0000
- Accept-language: en-US
- Authentication-results: unl.edu; dkim=none (message not signed) header.d=none;unl.edu; dmarc=none action=none header.from=isc.upenn.edu;
- Spamdiagnosticmetadata: NSPM
- Spamdiagnosticoutput: 1:23
I think the setting suggested by Carl is the way to go. Can you please do that? http://mechanics.flite.com/blog/2014/07/29/using-innodb-large-prefix-to-avoid-error-1071/ Please let us know how it goes. Thanks Chris From: Brett Bieber [mailto:bieber@unl.edu]
I ran in to the same issue as Carl, the upgrade failed to create a proper ddl upgrade script and failed to complete. Adding -deep didn't seem to do anything different to the check, or the generated ddl sql script. We're using Server version:
5.5.47-MariaDB-log MariaDB Server, InnoDB engine, utf8_bin default collation. I don't see the error message regarding the key length, but I haven't manually messed with the Subject versions in the table. Are there any complete instructions for overcoming this issue? Thanks, -Brett On Mon, May 16, 2016 at 10:40 AM Waldbieser, Carl <waldbiec@lafayette.edu> wrote:
|
- [grouper-users] Upgrade DB from 2.2 -> 2.3, MySQL issues, Waldbieser, Carl, 05/13/2016
- Re: [grouper-users] Upgrade DB from 2.2 -> 2.3, MySQL issues, Waldbieser, Carl, 05/13/2016
- [grouper-users] RE: Upgrade DB from 2.2 -> 2.3, MySQL issues, Hyzer, Chris, 05/15/2016
- [grouper-users] Re: Upgrade DB from 2.2 -> 2.3, MySQL issues, Waldbieser, Carl, 05/16/2016
- Message not available
- Re: [grouper-users] Re: Upgrade DB from 2.2 -> 2.3, MySQL issues, Brett Bieber, 05/24/2016
- RE: [grouper-users] Re: Upgrade DB from 2.2 -> 2.3, MySQL issues, Hyzer, Chris, 05/25/2016
- Re: [grouper-users] Re: Upgrade DB from 2.2 -> 2.3, MySQL issues, Brett Bieber, 05/24/2016
- [grouper-users] RE: Upgrade DB from 2.2 -> 2.3, MySQL issues, Hyzer, Chris, 05/15/2016
- Re: [grouper-users] Upgrade DB from 2.2 -> 2.3, MySQL issues, Waldbieser, Carl, 05/13/2016
Archive powered by MHonArc 2.6.16.