その他問い合わせ #3795
未完了MySQL8.0から8.4へのアップグレード時に出力された警告ログについて
説明
先日は『MySQL8.4以降非推奨:非一意キーまたは部分キーを外部キーとして使用すること』にて、
動作確認等、丁寧な回答ありがとうございました。
度重なるお問合せとなり、大変恐縮ではございますが、RDS(MySQL 8.0.40から8.4.7)のブルー/グリーンデプロイにて、
PrePatchCompatibility.logに出力されました以下のエラーの内容および対応方針について、貴見を伺えますでしょうか。
------------------------------------------------------------------------------------------------------------
3) Checks for foreing keys not referencing a full unique index
Foreign keys to partial indexes may be forbidden as of 8.4.0, this check identifies such cases to warn the user.
zabbix.ja_flow_control_fk1 - invalid foreign key defined as 'ja_flow_control_table(jobnet_id,update_date)' references a non unique key at table 'ja_job_control_table'.
zabbix.ja_flow_control_fk2 - invalid foreign key defined as 'ja_flow_control_table(jobnet_id,update_date)' references a non unique key at table 'ja_job_control_table'.
zabbix.ja_icon_agentless_fk1 - invalid foreign key defined as 'ja_icon_agentless_table(jobnet_id,update_date)' references a non unique key at table 'ja_job_control_table'.
zabbix.ja_icon_calc_fk1 - invalid foreign key defined as 'ja_icon_calc_table(jobnet_id,update_date)' references a non unique key at table 'ja_job_control_table'.
zabbix.ja_icon_end_fk1 - invalid foreign key defined as 'ja_icon_end_table(jobnet_id,update_date)' references a non unique key at table 'ja_job_control_table'.
zabbix.ja_icon_extjob_fk1 - invalid foreign key defined as 'ja_icon_extjob_table(jobnet_id,update_date)' references a non unique key at table 'ja_job_control_table'.
zabbix.ja_icon_fcopy_fk1 - invalid foreign key defined as 'ja_icon_fcopy_table(jobnet_id,update_date)' references a non unique key at table 'ja_job_control_table'.
zabbix.ja_icon_fwait_fk1 - invalid foreign key defined as 'ja_icon_fwait_table(jobnet_id,update_date)' references a non unique key at table 'ja_job_control_table'.
zabbix.ja_icon_if_fk1 - invalid foreign key defined as 'ja_icon_if_table(jobnet_id,update_date)' references a non unique key at table 'ja_job_control_table'.
zabbix.ja_icon_info_fk1 - invalid foreign key defined as 'ja_icon_info_table(jobnet_id,update_date)' references a non unique key at table 'ja_job_control_table'.
zabbix.ja_icon_job_fk1 - invalid foreign key defined as 'ja_icon_job_table(jobnet_id,update_date)' references a non unique key at table 'ja_job_control_table'.
zabbix.ja_icon_jobnet_fk1 - invalid foreign key defined as 'ja_icon_jobnet_table(jobnet_id,update_date)' references a non unique key at table 'ja_job_control_table'.
zabbix.ja_icon_reboot_fk1 - invalid foreign key defined as 'ja_icon_reboot_table(jobnet_id,update_date)' references a non unique key at table 'ja_job_control_table'.
zabbix.ja_icon_release_fk1 - invalid foreign key defined as 'ja_icon_release_table(jobnet_id,update_date)' references a non unique key at table 'ja_job_control_table'.
zabbix.ja_icon_task_fk1 - invalid foreign key defined as 'ja_icon_task_table(jobnet_id,update_date)' references a non unique key at table 'ja_job_control_table'.
zabbix.ja_icon_value_fk1 - invalid foreign key defined as 'ja_icon_value_table(jobnet_id,update_date)' references a non unique key at table 'ja_job_control_table'.
zabbix.ja_icon_zabbix_link_fk1 - invalid foreign key defined as 'ja_icon_zabbix_link_table(jobnet_id,update_date)' references a non unique key at table 'ja_job_control_table'.