-
Notifications
You must be signed in to change notification settings - Fork 9
Score release upgrade instruction
-
Score 3.0.x user MUST upgrade DB schemas through the migration script mig_3.0.4_to_3.1.0.sql before application upgrading. It is a normal SQL script, and any preferred MySQL client could be used to execute the script. If you have no MySQL client, MySQL Workbench could be an option.
-
Make a backup of your data from your instance using MySQL Workbench or other third-party database management tools. Ensure that it is downloaded from your Docker
srt-repoimage, if you are using thedocker execcommand for the backup. -
Stop docker-compose instances using the
docker-compose downcommand. -
Delete existing volumes to clean data.
- In order to find the docker DB volume, run the following command:
docker volume ls | grep db-volume | awk '{print 2ドル;}'
- Remove the volume
docker volume rm {volume_name}
- In order to find the docker DB volume, run the following command:
-
Update the tag in
docker-compose.ymlfrom 3.0.x to 3.1.0. -
Run docker-compose instances using the
docker-compose up -dcommand. -
After a few minutes, the instance will initiate. Import the backup data to the instance.
-
Run the following 'post-process' script to ensure all DB tables have the 1B+ ID numbers.
-- Post processes -- ALTER TABLE `acc` AUTO_INCREMENT = 100000001; ALTER TABLE `acc_manifest` AUTO_INCREMENT = 100000001; ALTER TABLE `agency_id_list` AUTO_INCREMENT = 100000001; ALTER TABLE `agency_id_list_manifest` AUTO_INCREMENT = 100000001; ALTER TABLE `agency_id_list_value` AUTO_INCREMENT = 100000001; ALTER TABLE `agency_id_list_value_manifest` AUTO_INCREMENT = 100000001; ALTER TABLE `app_user` AUTO_INCREMENT = 100000001; ALTER TABLE `ascc` AUTO_INCREMENT = 100000001; ALTER TABLE `ascc_manifest` AUTO_INCREMENT = 100000001; ALTER TABLE `bcc` AUTO_INCREMENT = 100000001; ALTER TABLE `bcc_manifest` AUTO_INCREMENT = 100000001; ALTER TABLE `asccp` AUTO_INCREMENT = 100000001; ALTER TABLE `asccp_manifest` AUTO_INCREMENT = 100000001; ALTER TABLE `bccp` AUTO_INCREMENT = 100000001; ALTER TABLE `bccp_manifest` AUTO_INCREMENT = 100000001; ALTER TABLE `bdt_pri_restri` AUTO_INCREMENT = 100000001; ALTER TABLE `bdt_sc_pri_restri` AUTO_INCREMENT = 100000001; ALTER TABLE `cdt_awd_pri` AUTO_INCREMENT = 100000001; ALTER TABLE `cdt_awd_pri_xps_type_map` AUTO_INCREMENT = 100000001; ALTER TABLE `cdt_ref_spec` AUTO_INCREMENT = 100000001; ALTER TABLE `cdt_sc_awd_pri` AUTO_INCREMENT = 100000001; ALTER TABLE `cdt_sc_awd_pri_xps_type_map` AUTO_INCREMENT = 100000001; ALTER TABLE `cdt_sc_ref_spec` AUTO_INCREMENT = 100000001; ALTER TABLE `code_list` AUTO_INCREMENT = 100000001; ALTER TABLE `code_list_manifest` AUTO_INCREMENT = 100000001; ALTER TABLE `code_list_value` AUTO_INCREMENT = 100000001; ALTER TABLE `code_list_value_manifest` AUTO_INCREMENT = 100000001; ALTER TABLE `dt` AUTO_INCREMENT = 100000001; ALTER TABLE `dt_manifest` AUTO_INCREMENT = 100000001; ALTER TABLE `dt_sc` AUTO_INCREMENT = 100000001; ALTER TABLE `dt_sc_manifest` AUTO_INCREMENT = 100000001; ALTER TABLE `log` AUTO_INCREMENT = 100000001; ALTER TABLE `namespace` AUTO_INCREMENT = 100000001; ALTER TABLE `seq_key` AUTO_INCREMENT = 100000001; -- End of 'Post processes' --