Forwarded to devs Plesk Migrator: mysql Store Procedures and Functions comments are lost during migration

[IT Ufficio Key-One]

Username:

TITLE

Plesk Migrator: mysql Store Procedures and Functions comments are lost during migration

PRODUCT, VERSION, OPERATING SYSTEM, ARCHITECTURE

Plesk 18.0.59 - Plesk Migrator 2.25.2-1922 - Source servers: Centos7, Mariadb 10.5.24 or 5.5.68 - Destination servers: Almalinux 8.9 - Mariadb 10.3.39 or 10.11.7

PROBLEM DESCRIPTION

Migration / Resync of a website containing a mysql/mariadb database. All comments inside Mysql Stored Procedures / Functions are lost in destination servers. Only blank lines are shown instead of comments.

STEPS TO REPRODUCE

Have a Mysql DB with some Stored Procedure/Function, containing some comments too, and migrate it to a new server.

ACTUAL RESULT

If the SP/FN contians comments (either in format -- or in format /* ... */), all comments are lost in destination server. Only blank lines are resulting. All the remaining SQL code is kept correctly.

EXPECTED RESULT

Expecting comments in MySQL SP/FN are maintained in destination server.

ANY ADDITIONAL INFORMATION

Manually dumping MySQL SP/FN from source server and re-importing to destination server (i.e. with Mysql Workbench) will keep all comments.

It seems not to be related with the MySQL/Mariadb version.

YOUR EXPECTATIONS FROM PLESK SERVICE TEAM

Confirm bug

 

[Peter Debik]

Thank you, forwarded to developers for further analysis as PPS-15770.

 

[Peter Debik]

Developers have confirmed the issue. It is now tracked as PMT-5269.

 

[IT Ufficio Key-One]

Thanks Peter, where can I track this?

 

[Kaspar]

If/when fixed it will be listed at the Plesk Change Log.

 

[IT Ufficio Key-One]

Hi, I can't find this issue resolved in Change Log. Has this been resolved?

Meanwhile, I found that the same behaviuor happens in restoring a Plesk Backup. All MySQL Stored Procedues / Functions have all comments missing when restoring a MariaDB Database.
Is that possibile to add this bug too (if this can be confirmed as a bug)?

Thanks.

 

[Sebahat.hadzhi]

Hello, there. A fix for the missing comments hasn't been released yet. Unfortunately, I cannot provide any ETA for the time being. I will provide more details as soon as possible. Thank you for reporting the additional issue. I will forward the report to our team for further review. Thank you for your patience and understanding in the meantime.