Stored Procedures changes not updating in PrePatchCompatibility.log when trying to update from MySQL 5.7.44 to MySQL 8.0.36

0

When trying to migrate from MySQL 5.7.44 to MySQL 8.0.36, the update fails and the PrePatchCompability.log file shows numerous statements in Section "12) Usage of removed functions" such as: "PROCEDURE uses removed functions ASTEXT (consider using ST_ASTEXT instead), X (consider using ST_X instead), Y (consider using ST_Y instead)".

We have altered the procedures to use the "ST_" prefixed functions as suggested in the log, however the messages in the log do not update. If we remove a procedure, it gets removed from the list in the log file, but our changes don't seem to register with the pre upgrade script.

Any help regarding getting our stored procedure changes to be seen by the upgrade check script would be appreciated.

I don't know if this helps, but there are several other messages in sections: 2) Usage of db objects with names conflicting with new reserved keywords 3) Usage of utf8mb3 charset 18) Issues reported by 'check table x for upgrade' command 24) Creating indexes larger than 767 bytes on tables with redundant row format might cause the tables to be inaccessible.

We show 1 error and 2 warnings, but the log does not specify which messages are errors and which are warnings. We are using the "Modify" option from the RDS instance dashboard, if that helps.

已提問 3 個月前檢視次數 120 次
沒有答案

您尚未登入。 登入 去張貼答案。

一個好的回答可以清楚地回答問題並提供建設性的意見回饋,同時有助於提問者的專業成長。

回答問題指南