Major org.ametys.core.migration.MigrationException: Error during SQL query to set the new version for: Version '0' for component 'org.ametys.plugins.core.group.directory.Jdbc.upgrade_UsersGroups3' (Automatic Initialization.) dataSource id: 'SQL-default-datasource', databaseType: 'mysql' (dataSource: SQL-default-datasource)
[RUNTIME-3568] Automatic migration issue with groups : name is too long
Raphaël Franchet
added a comment - I unlocked myself this way
let sqlDataSourceManager = Ametys.serviceManager.lookup(org.ametys.core.datasource.SQLDataSourceManager.ROLE); let dss = sqlDataSourceManager.getSQLDataSources(); for (let index of dss.keySet()) { let exists; let connection = dss.get(index).getConnection(); let dbType = org.ametys.core.datasource.ConnectionHelper.getDatabaseType(connection); org.ametys.core.datasource.ConnectionHelper.cleanup(connection); console.log(dbType + " - " + index) switch (dbType) { case "postgre": case "oracle": case "mysql": try { SQL.update("ALTER TABLE Ametys_Versions MODIFY component_identifier varchar(250) NOT NULL", index); } catch (e) { print(e); } break; case "derby": try { SQL.update("ALTER TABLE Ametys_Versions ALTER COLUMN component_identifier SET DATA TYPE varchar(250)", index); } catch (e) { print(e); } break; case "hsqldb": try { SQL.update("ALTER TABLE Ametys_Versions ALTER COLUMN component_identifier varchar(250)", index); } catch (e) { print(e); } break; } }
Raphaël Franchet
added a comment - I unlocked myself this way
let sqlDataSourceManager = Ametys.serviceManager.lookup(org.ametys.core.datasource.SQLDataSourceManager.ROLE);
let dss = sqlDataSourceManager.getSQLDataSources();
for (let index of dss.keySet())
{
let exists;
let connection = dss.get(index).getConnection();
let dbType = org.ametys.core.datasource.ConnectionHelper.getDatabaseType(connection);
org.ametys.core.datasource.ConnectionHelper.cleanup(connection);
console.log(dbType + " - " + index)
switch (dbType)
{
case "postgre" :
case "oracle" :
case "mysql" :
try {
SQL.update( "ALTER TABLE Ametys_Versions MODIFY component_identifier varchar(250) NOT NULL" , index);
} catch (e) { print(e); }
break ;
case "derby" :
try {
SQL.update( "ALTER TABLE Ametys_Versions ALTER COLUMN component_identifier SET DATA TYPE varchar(250)" , index);
} catch (e) { print(e); }
break ;
case "hsqldb" :
try {
SQL.update( "ALTER TABLE Ametys_Versions ALTER COLUMN component_identifier varchar(250)" , index);
} catch (e) { print(e); }
break ;
}
}
migration can be linked to RUNTIME-3570