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.