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.

posta 3 mesi fa119 visualizzazioni
Nessuna risposta

Accesso non effettuato. Accedi per postare una risposta.

Una buona risposta soddisfa chiaramente la domanda, fornisce un feedback costruttivo e incoraggia la crescita professionale del richiedente.

Linee guida per rispondere alle domande