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.

preguntada hace 3 meses120 visualizaciones
No hay respuestas

No has iniciado sesión. Iniciar sesión para publicar una respuesta.

Una buena respuesta responde claramente a la pregunta, proporciona comentarios constructivos y fomenta el crecimiento profesional en la persona que hace la pregunta.

Pautas para responder preguntas