Running 10.9.3 migration script with Data Loader 1.3 does not populate 10.9.3 content

[jim-wilson-kt]

What I did

I ran the 10.9.3 migration script on oagiscore.net using Data Loader 1.3. See the command and the output below.

What happened / what's wrong

After running it, I checked Core Components in Score for version 10.9.3 and didn't find any. See screen captures below for 10.9.2 and 10.9.3.

Command

java -jar OAGIS-dataloader-1.3.jar --host=oagiscore.net --password --user=oagi 10_9_3/mig_info_10.9.3.json

Output

Enter value for --password (Password to use when connecting to server.):
SLF4J: Failed to load class "org.slf4j.impl.StaticLoggerBinder".
SLF4J: Defaulting to no-operation (NOP) logger implementation
SLF4J: See http://www.slf4j.org/codes.html#StaticLoggerBinder for further details.
Working Directory:  /Users/jw/Downloads/connectSpec-data-loader-1.3/10_9_3
Information File:   /Users/jw/Downloads/connectSpec-data-loader-1.3/10_9_3/mig_info_10.9.3.json
---------------------
-- Add 10.9.3 release
-- Maintainer: oagis
---------------------

** This program will overwrite all records defined by OAGIS developer accounts.
** You may lose your data if there are non-standard records defined by developer accounts.

Reposition end-user data...
    Reposition end-user records in `app_user` table...
        Found 0 target `app_user` record(s)
    Reposition end-user records in `asccp` table...
        Found 0 target `asccp` record(s)
        Found 0 target `asccp_manifest` record(s)
    Reposition end-user records in `bccp` table...
        Found 0 target `bccp` record(s)
        Found 0 target `bccp_manifest` record(s)
    Reposition end-user records in `dt` table...
        Found 0 target `dt` record(s)
        Found 0 target `dt_manifest` record(s)
    Reposition end-user records in `dt_sc` table...
        Found 0 target `dt_sc` record(s)
        Found 0 target `dt_sc_manifest` record(s)
    Reposition end-user records in `ascc` table...
        Found 0 target `ascc` record(s)
        Found 0 target `ascc_manifest` record(s)
    Reposition end-user records in `bcc` table...
        Found 0 target `bcc` record(s)
        Found 0 target `bcc_manifest` record(s)
    Reposition end-user records in `acc` table...
        Found 0 target `acc` record(s)
        Found 0 target `acc_manifest` record(s)
    Reposition end-user records in `seq_key` table...
        Found 0 target `seq_key` record(s)
    Reposition end-user records in `code_list` table...
        Found 0 target `code_list` record(s)
        Found 0 target `code_list_manifest` record(s)
    Reposition end-user records in `code_list_value` table...
        Found 0 target `code_list_value` record(s)
        Found 0 target `code_list_value_manifest` record(s)
    Reposition end-user records in `log` table...
        Found 0 target `log` record(s)
    Reposition end-user records in `namespace` table...
        Found 0 target `namespace` record(s)
Remove developer components in Working release...
    Remove developer components in Working release for `asccp` table...
        Found 0 target `asccp` record(s)
    Remove developer components in Working release for `bccp` table...
        Found 0 target `bccp` record(s)
    Remove developer components in Working release for `ascc` table...
        Found 0 target `ascc` record(s)
    Remove developer components in Working release for `bcc` table...
        Found 0 target `bcc` record(s)
    Remove developer components in Working release for `acc` table...
        Found 0 target `acc` record(s)
Execute processes...
    Executing mig_10.9.3.sql
    Executing /Users/jw/Downloads/connectSpec-data-loader-1.3/10_9_3/mig_10.9.3.sql as a SQL script
Completed.

10.9.2 Search Example (all good)

10.9.3 Search Example (problem - no components!)

[jim-wilson-kt]

Migration script (link expires 2023-09-14):

https://oagi-temp.s3.amazonaws.com/10_9_3.zip?X-Amz-Algorithm=AWS4-HMAC-SHA256&X-Amz-Credential=AKIAIQBTUYPH7ZNLDD2Q/20230907/us-east-1/s3/aws4_request&X-Amz-Date=20230907T202058Z&X-Amz-Expires=604800&X-Amz-SignedHeaders=host&X-Amz-Signature=2d2ca3722255111fc465fd609013620021bb2fa52b54d6a589dcd60cc12f2d86

[jim-wilson-kt]

Note that this issue is in the context of our first migration attempt since switching from MySQL to MariaDB.

[jim-wilson-kt]

I restored the database from the backup on oagiscore.net taken just prior to the failed 10.9.2 → 10.9.3 migration.

[bingqi2045]

The migration failed because the post-process script after update to Score 3.1.0 increased the Auto_Increment in most tables to 1B (100000000).

I just restored the developer instance using the data backup on Aug 26, 2023, which has no effect of post-process script.