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.

asked 3 months ago106 views
No Answers

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions