Forwarded to devs Plesk 18.0.38 Update Removes All Domain Aliases

[G J Piper]

Username: G J Piper

TITLE

Plesk 18.0.38 Update Removes All Domain Aliases

PRODUCT, VERSION, OPERATING SYSTEM, ARCHITECTURE

Plesk 18.0.38 | CentOS 7.9.2009 | Nginx 1.20.1 | Apache 2.4.6 | MySQL 10.5.12-MariaDB

PROBLEM DESCRIPTION

After update to 18.0.38 and running 'plesk repair' facility on the server (which I do every time it is updated) I noticed all domain aliases were missing from the GUI in the Domains tab and the Subscriptions tabs.

STEPS TO REPRODUCE

Update from 18.0.37 to 18.0.38. Run 'plesk repair' on server and fix all requested errors like these:

Inconsistency in the table 'dns_zone' for the column id: No rows in
the table 'domains' with dns_zone_id = 152 ........................ [WARNING]
To see more details, run the command in the verbose mode: plesk repair db -verbose
Remove unnecessary rows from the table 'dns_zone'? [Y/n] Y
................................................................ [FIXED]

Inconsistency in the table 'domain_aliases' for the column
dns_zone_id: No rows in the table 'dns_zone' with id = 144 ........ [WARNING]
To see more details, run the command in the verbose mode: plesk repair db -verbose
Remove unnecessary rows from the table 'domain_aliases'? [Y/n] Y
Removing unnecessary rows ....................................... [FIXED]

ACTUAL RESULT

all aliases are missing after update and plesk repair.

EXPECTED RESULT

Retain all aliases even after upgrading and running 'plesk repair db'

ANY ADDITIONAL INFORMATION

If you go into the Subscriptions tab for a domain that is missing the aliases, and try to add them again, you get this error:

Error: mailmng-outgoing failed: ERROR:__main__:column name is not unique
Search for related Knowledge Base articles

And upon returning to the Subscription the alias is restored! However, running 'plesk repair db' again removes it from the GUI.

YOUR EXPECTATIONS FROM PLESK SERVICE TEAM

Confirm bug

 

[G J Piper]

More info:
Apparently the aliases are still there and active, but renewing a Let's Encrypt certificate for a subscription excludes the aliases which are also hidden from the GUI everywhere.

 

[G J Piper]

After manually removing several aliases I re-added, then adding them again, I ran plesk repair db and it removes them again from the GUI. Here is the output:

# plesk repair db -y

Checking the Plesk database using the native database server tools .. [OK]

Checking the structure of the Plesk database ........................ [OK]

Checking the consistency of the Plesk database

Inconsistency in the table 'dns_zone' for the column id: No rows in
the table 'domains' with dns_zone_id = 154 ........................ [WARNING]
To see more details, run the command in the verbose mode: plesk repair db -verbose
Creating a database dump ........................................ [OK]
A dump of the database was created before an attempt to repair the database: /var/lib/psa/dumps/mysql.preresolve.20210831-183231.dump.gz
................................................................ [FIXED]

Inconsistency in the table 'dns_zone' for the column id: No rows in
the table 'domains' with dns_zone_id = 155 ........................ [WARNING]
To see more details, run the command in the verbose mode: plesk repair db -verbose
................................................................ [FIXED]

Inconsistency in the table 'dns_zone' for the column id: No rows in
the table 'domains' with dns_zone_id = 157 ........................ [WARNING]
To see more details, run the command in the verbose mode: plesk repair db -verbose
................................................................ [FIXED]

Inconsistency in the table 'domain_aliases' for the column
dns_zone_id: No rows in the table 'dns_zone' with id = 154 ........ [WARNING]
To see more details, run the command in the verbose mode: plesk repair db -verbose
Removing unnecessary rows ....................................... [FIXED]

Inconsistency in the table 'domain_aliases' for the column
dns_zone_id: No rows in the table 'dns_zone' with id = 155 ........ [WARNING]
To see more details, run the command in the verbose mode: plesk repair db -verbose
Removing unnecessary rows ....................................... [FIXED]

Inconsistency in the table 'domain_aliases' for the column
dns_zone_id: No rows in the table 'dns_zone' with id = 157 ........ [WARNING]
To see more details, run the command in the verbose mode: plesk repair db -verbose
Removing unnecessary rows ....................................... [FIXED]

Inconsistency in the table 'DomainAliasesParameters' for the column
aliasId: No rows in the table 'domain_aliases' with id = 70 ....... [WARNING]
To see more details, run the command in the verbose mode: plesk repair db -verbose
Removing unnecessary rows ....................................... [FIXED]

Error messages: 0; Warnings: 7; Errors resolved: 7

Also, I should mention that all my domains have DNSA settings running as slave. I use external DNS at GoDaddy.

 

[IgorG]

Thank you.
The bug is confirmed and submitted: PPPM-13188

 

[Greg Sevastos]

I just updated Plesk to version 18.0.38 and can also confirm the above bug.

Any ETA on fix?

 

[Hangover2]

Hello @Greg Sevastos,

the bug was fixe in Plesk Obsidian 18.0.38 Update 1.

 

[G J Piper]

Yes I can confirm the new 18.0.38.1 update fixes the problem. I had to manually add all the aliases back that it had previously deleted, but they do stay back now. Feel sorry for anyone who had more than a few dozen removed. ;-)