Major version upgrade to MySQL 8.0 from 5.7: Fails validation process with error "Usage of removed functions" but it doesn't show any detail on what functions are failing.

Question

I am trying to upgrade my Azure MySQL from 5.7 to 8.0 version. I am following the current guide:

https://learn.microsoft.com/en-us/azure/mysql/flexible-server/how-to-upgrade

The first problem I faced to was than I was unable to install the mysql shell to run the function util.checkforserverupgrade(), (I suppose because I am not inside the mysql as it is mysql as a managed server)

https://dev.mysql.com/doc/mysql-shell/8.0/en/mysql-shell-utilities-upgrade.html

The main problem I am facing with is when I push in the validate button it fails with this message:

The problem is that it doesn't specify which functions are failing or the objects than are causing the issue, and it's very difficult to check all of then reading the document of deprecated functions.

Is there a function or logs to find out more details about this problem?

Thank you very much in advance.

Regards.

Answer 1

¡Hola SUAREZ SUAREZ GONZALO!

Esperamos que este mensaje te encuentre bien.

Lamentamos sinceramente la demora en abordar tu tema en este foro.  

Use the MySQL Upgrade Checker tool to identify incompatible functions and objects. If issues persist, consider contacting Azure support for detailed assistance. 

Si no recibimos una respuesta tuya en los próximos días, procederemos a cerrar el tema. Sin embargo, queremos asegurarte que siempre estamos disponibles para cualquier asistencia que puedas necesitar.

Agradecemos tu comprensión y estamos aquí para ayudar en lo que sea necesario.

Estaré atento a tu respuesta.,

 Jonathan

----------*

Tu opinión es muy importante para nosotros! Si esta respuesta resolvió tu consulta, por favor haz clic en 'SÍ'. Esto nos ayuda a mejorar continuamente la calidad y relevancia de nuestras soluciones.