-
Type:
Bug
-
Resolution: Unresolved
-
Priority:
Major
-
None
-
Affects Version/s: 4.17.6, 4.17.7
-
Component/s: gsh
-
None
-
Environment:Internet2 Docker container
new GrouperDdlDataMigration().assignDatabaseFrom("grouper").assignDatabaseTo("mysqlDb").migrateDatabase();
{{}}
...Will generate and attempt to execute a bad sql script shortly after execution. The chief error looks to be a repeated CREATE TABLE [TABLENAME] in each of the CREATE TABLE statements.
{{}}
Steps to recreate:
-create an external system pointed to a blank postgres database
-start a gsh container and run:
import edu.internet2.middleware.grouper.ddl.GrouperDdlDataMigration;
new GrouperDdlDataMigration().assignDatabaseFrom("grouper").assignDatabaseTo("targetDB").migrateDatabase();
Error should occur shortly after execution starts.
{{}}
Note: issue does not occur in 4.17.4.{}
{{}}