Uploaded image for project: 'Runtime'
  1. Runtime
  2. RUNTIME-4369

Automatic migration: Some migration components without initialization lead to 0

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Unresolved
    • Icon: Major Major
    • 4.10.3, 4.9.16, 4.11.0
    • 4.11.0
    • None
    • None

      For example, I am running the following unit test org.ametys.plugins.odfsync.ApogeeTestCase.testOrgUnit() and I get this log:

      INFO [org.ametys.core.migration.MigrationEngine] - Automatic migration start
      INFO [org.ametys.core.migration.MigrationExtensionPoint.versionStorage.sql] - Check internal versions table for datasource SQL-ametys-internal
      INFO [org.ametys.core.migration.MigrationEngine] - Run action : Initialization of type 'sql'. Last version is '20210401T0000'
      INFO [org.ametys.core.migration.MigrationEngine] - Store new version: Version '20210401T0000' for component 'ametys.versions.table' (Automatic Initialization)
      INFO [org.ametys.core.migration.MigrationEngine] - Store new version: Version '0' for component 'migration-data.authentication' (Initial version)
      INFO [org.ametys.core.migration.MigrationEngine] - Run action : Initialization of type 'sql'. Last version is 'null'
      INFO [org.ametys.core.migration.MigrationEngine] - Store new version: Version '20230120T0000' for component 'user-directory.jdbc_AdminUsers' (Automatic Initialization)
      INFO [org.ametys.core.migration.MigrationEngine] - Store new version: Version '0' for component 'migration-data.user_AdminUsers' (Initial version)
      INFO [org.ametys.core.migration.MigrationEngine] - Store new version: Version '0' for component 'migration-data.credential-provider.form' (Initial version)
      INFO [org.ametys.core.migration.MigrationEngine] - Store new version: Version '20230503T0000' for component 'migration-data-jcr' (Automatic Initialization)
      INFO [org.ametys.core.migration.MigrationEngine] - 3 pending upgrade(s):
      INFO [org.ametys.core.migration.MigrationEngine] - Run action : Upgrade '20230310T0000' of type 'script' (RUNTIME-3703 Rename JDBC user migration data)
      INFO [org.ametys.core.migration.MigrationEngine] - Store new version: Version '20230310T0000' for component 'migration-data.user_AdminUsers' (Automatic Upgrade: RUNTIME-3703 Rename JDBC user migration data)
      INFO [org.ametys.core.migration.MigrationEngine] - Run action : Upgrade '20230925T0000' of type 'script' (RUNTIME-3790 error of duplicate entry when there is a connection error)
      INFO [org.ametys.core.migration.MigrationEngine] - Store new version: Version '20230925T0000' for component 'migration-data.credential-provider.form' (Automatic Upgrade: RUNTIME-3790 error of duplicate entry when there is a connection error)
      INFO [org.ametys.core.migration.MigrationEngine] - Run action : Upgrade '20240118T0000' of type 'script' (EXTUSERMGT-18 Implement a silent mode for Entra ID authentication)
      INFO [org.ametys.core.migration.MigrationEngine] - Store new version: Version '20240118T0000' for component 'migration-data.authentication' (Automatic Upgrade: EXTUSERMGT-18 Implement a silent mode for Entra ID authentication)
      INFO [org.ametys.core.migration.MigrationEngine] - Store new version: Version '0' for component 'org.ametys.plugins.odfsync.upgrade.pegase.safe' (Initial version)
      INFO [org.ametys.core.migration.MigrationEngine] - Store new version: Version '0' for component 'solr.send.schema' (Initial version)
      INFO [org.ametys.core.migration.MigrationExtensionPoint.versionStorage.sql] - Check internal versions table for datasource SQL-other
      INFO [org.ametys.core.migration.MigrationEngine] - Run action : Initialization of type 'sql'. Last version is '20210401T0000'
      INFO [org.ametys.core.migration.MigrationEngine] - Store new version: Version '20210401T0000' for component 'ametys.versions.table' (Automatic Initialization)
      INFO [org.ametys.core.migration.MigrationEngine] - Store new version: Version '0' for component 'org.ametys.plugins.core.schedule.SchedulerInit.upgrades' (Initial version)
      INFO [org.ametys.core.migration.MigrationEngine] - Store new version: Version '0' for component 'cms.rights' (Initial version)
      INFO [org.ametys.core.migration.MigrationEngine] - Store new version: Version '0' for component 'plugin.odf.safe' (Initial version)
      INFO [org.ametys.core.migration.MigrationEngine] - Store new version: Version '0' for component 'plugin.odfsync.import.apogee.config' (Initial version)
      INFO [org.ametys.core.migration.MigrationEngine] - Store new version: Version '0' for component 'plugin.odf.sql.rights' (Initial version)
      INFO [org.ametys.core.migration.MigrationEngine] - Store new version: Version '0' for component 'plugin.odfsync.import.cdmfr.config' (Initial version)
      INFO [org.ametys.core.migration.MigrationEngine] - Store new version: Version '0' for component 'authentication' (Initial version)
      INFO [org.ametys.core.migration.MigrationEngine] - Run action : Initialization of type 'sql'. Last version is 'null'
      INFO [org.ametys.core.migration.MigrationEngine] - Store new version: Version '0' for component 'credential-provider.form' (Automatic Initialization)
      INFO [org.ametys.core.migration.MigrationEngine] - Store new version: Version '20260312T0000' for component 'org.ametys.plugins.cms.upgrade' (Automatic Initialization)
      INFO [org.ametys.core.migration.MigrationEngine] - Store new version: Version '20210929T0000' for component 'plugin.odfsync.import.apogee.jcr' (Automatic Initialization)
      INFO [org.ametys.core.migration.MigrationEngine] - Run action : Initialization of type 'sql'. Last version is 'null'
      INFO [org.ametys.core.migration.MigrationEngine] - Store new version: Version '0' for component 'org.ametys.core.script.multifactorauthentication.admin.SqlTablesInit' (Automatic Initialization)
      INFO [org.ametys.core.migration.MigrationEngine] - Run action : Initialization of type 'sql'. Last version is 'null'
      INFO [org.ametys.core.migration.MigrationEngine] - Store new version: Version '20250101T0000' for component 'users.status' (Automatic Initialization)
      INFO [org.ametys.core.migration.MigrationEngine] - Run action : Initialization of type 'sql'. Last version is 'null'
      INFO [org.ametys.core.migration.MigrationEngine] - Store new version: Version '0' for component 'org.ametys.core.script.userpopulations.SqlTablesInit' (Automatic Initialization)
      INFO [org.ametys.core.migration.MigrationEngine] - Store new version: Version '20260618T0000' for component 'plugin.odf.jcr' (Automatic Initialization)
      INFO [org.ametys.core.migration.MigrationEngine] - Run action : Initialization of type 'sql'. Last version is 'null'
      INFO [org.ametys.core.migration.MigrationEngine] - Store new version: Version '20260624T0000' for component 'org.ametys.core.script.authenticationtokens.SqlTablesInit' (Automatic Initialization)
      INFO [org.ametys.core.migration.MigrationEngine] - Run action : Initialization of type 'sql'. Last version is 'null'
      INFO [org.ametys.core.migration.MigrationEngine] - Store new version: Version '20260130T0000' for component 'org.ametys.core.script.multifactorauthentication.SqlTablesInit' (Automatic Initialization)
      INFO [org.ametys.core.migration.MigrationEngine] - Run action : Initialization of type 'sql'. Last version is 'null'
      INFO [org.ametys.core.migration.MigrationEngine] - Store new version: Version '20251014T0000' for component 'org.ametys.core.script.profile.SqlTablesInit' (Automatic Initialization)
      INFO [org.ametys.core.migration.MigrationEngine] - Store new version: Version '20210101T0220' for component 'org.ametys.plugins.cms.upgrade.before' (Automatic Initialization)
      INFO [org.ametys.core.migration.MigrationEngine] - Run action : Initialization of type 'sql'. Last version is 'null'
      INFO [org.ametys.core.migration.MigrationEngine] - Store new version: Version '0' for component 'org.ametys.core.script.groupdirectories.SqlTablesInit' (Automatic Initialization)
      INFO [org.ametys.core.migration.MigrationEngine] - Store new version: Version '20250401T0000' for component 'plugin.queries.directory.jcr' (Automatic Initialization)
      INFO [org.ametys.core.migration.MigrationEngine] - 22 pending upgrade(s):
      INFO [org.ametys.core.migration.MigrationEngine] - Run action : Upgrade '20100101T0000' of type 'script' (CMS-11382 Update Solr schema)
      ERROR [org.ametys.core.migration.MigrationExtensionPoint.upgrade.script.solr.send.schema] - Send schema has failed
      INFO [org.ametys.core.migration.MigrationEngine] - Store new version: Version '20100101T0000' for component 'solr.send.schema' (Automatic Upgrade: CMS-11382 Update Solr schema)
      INFO [org.ametys.core.migration.MigrationEngine] - Run action : Upgrade '20201130T0000' of type 'script' (Migration for ODF-2790 (part 1))
      INFO [org.ametys.core.migration.MigrationEngine] - Store new version: Version '20201130T0000' for component 'plugin.odf.safe' (Automatic Upgrade: Migration for ODF-2790 (part 1))
      INFO [org.ametys.core.migration.MigrationEngine] - Run action : Upgrade '20210520T0000' of type 'script' (Migration to new Extra User Management plugin)
      INFO [org.ametys.core.migration.MigrationEngine] - Store new version: Version '20210520T0000' for component 'authentication' (Automatic Upgrade: Migration to new Extra User Management plugin)
      INFO [org.ametys.core.migration.MigrationEngine] - Run action : Upgrade '20210909T0000' of type 'script' (Migration of Exchange configuration)
      INFO [org.ametys.core.migration.MigrationEngine] - Store new version: Version '20210909T0000' for component 'authentication' (Automatic Upgrade: Migration of Exchange configuration)
      INFO [org.ametys.core.migration.MigrationEngine] - Run action : Upgrade '20211118T0000' of type 'script' (Migration of ODF config file for CDM-fr (ODF-3046))
      INFO [org.ametys.core.migration.MigrationEngine] - Store new version: Version '20211118T0000' for component 'plugin.odfsync.import.cdmfr.config' (Automatic Upgrade: Migration of ODF config file for CDM-fr (ODF-3046))
      INFO [org.ametys.core.migration.MigrationEngine] - Run action : Upgrade '20220610T0000' of type 'script' (Migrate rights related to educational booklet ODF-3220)
      INFO [org.ametys.core.migration.MigrationExtensionPoint.upgrade.script.plugin.odf.sql.rights] - Start migrating of rights related to educational booklet
      INFO [org.ametys.core.migration.MigrationExtensionPoint.upgrade.script.plugin.odf.sql.rights] - 0 profile(s) have been updated
      INFO [org.ametys.core.migration.MigrationEngine] - Store new version: Version '20220610T0000' for component 'plugin.odf.sql.rights' (Automatic Upgrade: Migrate rights related to educational booklet ODF-3220)
      INFO [org.ametys.core.migration.MigrationEngine] - Run action : Upgrade '20221116T0000' of type 'script' (Migration for multifactor authentication)
      INFO [org.ametys.core.migration.MigrationEngine] - Store new version: Version '20221116T0000' for component 'authentication' (Automatic Upgrade: Migration for multifactor authentication)
      INFO [org.ametys.core.migration.MigrationEngine] - Run action : Upgrade '20230109T0000' of type 'script' (Migration of JDBC user directory)
      INFO [org.ametys.core.migration.MigrationEngine] - Store new version: Version '20230109T0000' for component 'authentication' (Automatic Upgrade: Migration of JDBC user directory)
      INFO [org.ametys.core.migration.MigrationEngine] - Run action : Upgrade '20230209T0000' of type 'script' (Migrate clean cache jobs for RUNTIME-3686)
      INFO [org.ametys.core.migration.MigrationExtensionPoint.upgrade.script.org.ametys.plugins.core.schedule.SchedulerInit.upgrades] - 0 jobs were migrated successfully.
      INFO [org.ametys.core.migration.MigrationEngine] - Store new version: Version '20230209T0000' for component 'org.ametys.plugins.core.schedule.SchedulerInit.upgrades' (Automatic Upgrade: Migrate clean cache jobs for RUNTIME-3686)
      INFO [org.ametys.core.migration.MigrationEngine] - Run action : Upgrade '20230210T0000' of type 'script' (Migration of JDBC user directory password requirements)
      INFO [org.ametys.core.migration.MigrationEngine] - Store new version: Version '20230210T0000' for component 'authentication' (Automatic Upgrade: Migration of JDBC user directory password requirements)
      INFO [org.ametys.core.migration.MigrationEngine] - Run action : Upgrade '20230525T0000' of type 'script' (Adding Apogée course part SCC if necessary (ODF-3334))
      INFO [org.ametys.core.migration.MigrationEngine] - Store new version: Version '20230525T0000' for component 'plugin.odfsync.import.apogee.config' (Automatic Upgrade: Adding Apogée course part SCC if necessary (ODF-3334))
      INFO [org.ametys.core.migration.MigrationEngine] - Run action : Upgrade '202400905T0000' of type 'script' (Remove all mixin assignment (CMS-12178))
      INFO [org.ametys.core.migration.MigrationEngine] - Store new version: Version '202400905T0000' for component 'cms.rights' (Automatic Upgrade: Remove all mixin assignment (CMS-12178))
      INFO [org.ametys.core.migration.MigrationEngine] - Run action : Upgrade '20240516T0000' of type 'script' (Migration for reset password parameter)
      INFO [org.ametys.core.migration.MigrationEngine] - Store new version: Version '20240516T0000' for component 'authentication' (Automatic Upgrade: Migration for reset password parameter)
      INFO [org.ametys.core.migration.MigrationEngine] - Run action : Upgrade '20240605T0000' of type 'script' (Migrate profiles related ODF-3698)
      INFO [org.ametys.core.migration.MigrationExtensionPoint.upgrade.script.plugin.odf.sql.rights] - Add 'ODF_Rights_ProgramTree_RemoveElement' to all profiles with 'ODF_Rights_Program_Edit'
      INFO [org.ametys.core.migration.MigrationExtensionPoint.upgrade.script.plugin.odf.sql.rights] - 0 profile(s) have been updated
      INFO [org.ametys.core.migration.MigrationEngine] - Store new version: Version '20240605T0000' for component 'plugin.odf.sql.rights' (Automatic Upgrade: Migrate profiles related ODF-3698)
      INFO [org.ametys.core.migration.MigrationEngine] - Run action : Upgrade '20250922T0000' of type 'script' (Update profiles (CMS-12524))
      INFO [org.ametys.core.migration.MigrationExtensionPoint.upgrade.script.cms.rights] - Add 'CMS_Rights_SearchAsyncExport' to all profiles with 'CMS_Rights_SearchContents'
      INFO [org.ametys.core.migration.MigrationExtensionPoint.upgrade.script.cms.rights] - 0 profile(s) have been updated
      INFO [org.ametys.core.migration.MigrationEngine] - Store new version: Version '20250922T0000' for component 'cms.rights' (Automatic Upgrade: Update profiles (CMS-12524))
      INFO [org.ametys.core.migration.MigrationEngine] - Run action : Upgrade '20251029T0000' of type 'script' (Migrate skills rights to one handle skill right ODF-3927)
      INFO [org.ametys.core.migration.MigrationEngine] - Store new version: Version '20251029T0000' for component 'plugin.odf.sql.rights' (Automatic Upgrade: Migrate skills rights to one handle skill right ODF-3927)
      INFO [org.ametys.core.migration.MigrationEngine] - Run action : Upgrade '20251203T0000' of type 'script' (Migrate jobs label and description for RUNTIME-4272)
      INFO [org.ametys.core.migration.MigrationExtensionPoint.upgrade.script.org.ametys.plugins.core.schedule.SchedulerInit.upgrades] - 0 jobs were migrated successfully.
      INFO [org.ametys.core.migration.MigrationEngine] - Store new version: Version '20251203T0000' for component 'org.ametys.plugins.core.schedule.SchedulerInit.upgrades' (Automatic Upgrade: Migrate jobs label and description for RUNTIME-4272)
      INFO [org.ametys.core.migration.MigrationEngine] - Run action : Upgrade '20260206T0000' of type 'script' (Migration for cache expiration (RUNTIME-4304))
      INFO [org.ametys.core.migration.MigrationEngine] - Store new version: Version '20260206T0000' for component 'authentication' (Automatic Upgrade: Migration for cache expiration (RUNTIME-4304))
      INFO [org.ametys.core.migration.MigrationEngine] - Run action : Upgrade '20260522T0000' of type 'script' (Add new skills rights to some profiles ODF-4194)
      INFO [org.ametys.core.migration.MigrationExtensionPoint.upgrade.script.plugin.odf.sql.rights] - Add new skill 'ODF_Rights_Skills_Program_Fields' rights to all profiles that had 'ODF_Rights_Skills_Handle' right
      INFO [org.ametys.core.migration.MigrationExtensionPoint.upgrade.script.plugin.odf.sql.rights] - 0 profile(s) have been updated
      INFO [org.ametys.core.migration.MigrationEngine] - Store new version: Version '20260522T0000' for component 'plugin.odf.sql.rights' (Automatic Upgrade: Add new skills rights to some profiles ODF-4194)
      INFO [org.ametys.core.migration.MigrationEngine] - Run action : Upgrade '20260618T0000' of type 'script' (Add new seperated skills rights to every profile that had the previous one ODF-4046)
      INFO [org.ametys.core.migration.MigrationExtensionPoint.upgrade.script.plugin.odf.sql.rights] - Add new seperated skills rights to all profiles that had 'ODF_Rights_Skills_Handle' right
      INFO [org.ametys.core.migration.MigrationExtensionPoint.upgrade.script.plugin.odf.sql.rights] - 0 profile(s) have been updated
      INFO [org.ametys.core.migration.MigrationEngine] - Store new version: Version '20260618T0000' for component 'plugin.odf.sql.rights' (Automatic Upgrade: Add new seperated skills rights to every profile that had the previous one ODF-4046)
      INFO [org.ametys.core.migration.MigrationEngine] - Run action : Upgrade '20260709T0000' of type 'sql' (Enlarge JOB_DATA column for RUNTIME-4346)
      INFO [org.ametys.core.migration.MigrationEngine] - Store new version: Version '20260709T0000' for component 'org.ametys.plugins.core.schedule.SchedulerInit.upgrades' (Automatic Upgrade: Enlarge JOB_DATA column for RUNTIME-4346)
      INFO [org.ametys.core.migration.MigrationEngine] - Run action : Upgrade '20260825T0000' of type 'script' (Moving Pégase config parameter (ODF-4258))
      INFO [org.ametys.core.migration.MigrationExtensionPoint.upgrade.script.org.ametys.plugins.odfsync.upgrade.pegase.safe] - Migration needs a restart of the application
      INFO [org.ametys.core.migration.MigrationEngine] - Store new version: Version '20260825T0000' for component 'org.ametys.plugins.odfsync.upgrade.pegase.safe' (Automatic Upgrade: Moving Pégase config parameter (ODF-4258))
      INFO [org.ametys.core.migration.MigrationEngine] - Automatic migration finished.

      There is no initial data so no migration should be needed except initialization, but we can see that a lot of upgrades are running and some migrations are initialized to 0 and should not.

      Maybe it can be useful to take a look to the following issue: RUNTIME-3834 All migration components without initialization lead to version 0

      Note: To activate these logs on unit test, modify the log4.properties by adding log4j.logger.org.ametys.core.migration=INFO.

            Unassigned Unassigned
            bmaurel Bérénice Maurel
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Created:
              Updated: