Issue Plesk Version Mismatch

[Pakon]

Hey,

in Order to try to repair some file permissions and very strange behavior with vhosts I tried "plesk repair all".

According to my problem Resolved - Plesk - installed version / update missmtach it's not really possible to repair anything.
Some components of Plesk pretend to be in "Version" 18.0.20.0 and other components pretend to be in "Version" 18.0.43, which is the corret one.

server:/var/log/plesk# plesk version
Product version: Plesk Obsidian 18.0.20.0
OS version: Ubuntu 20.04 x86_64
Build date: 2022/04/14 18:00
Revision: 1a6b26fb2fd0ac923f3ca10bdfd13b721cb5c676

server:/var/log/plesk# plesk checkupgrade

[2022-04-17 08:35:29][INFO] Installed Plesk version/build: 18.0.43 Ubuntu 20.04 1800220414.18...
[2022-04-17 08:35:29][INFO] You have already installed the latest version Plesk 18.0.43. Tool must be launched prior to upgrade to Plesk 18.0.43 for the purpose of getting a report on potential problems with the upgrade.

Does anybody know how to fix the incorrect Version Number (18.0.20.0)?

Thank you,
Pakon

 

[IgorG]

Please check the output of the following commands:

In Plesk database:

MariaDB [psa]> select * from upgrade_history;
MariaDB [psa]> select * from misc where param='version';

In command line:

# cat /usr/local/psa/version

 

[Pakon]

Hey IgorG, hey all,

the output of /usr/local/psa/version:

server:/# cat /usr/local/psa/version
18.0.43 Ubuntu 20.04 1800220414.18

and the database output:

mysql> select * from upgrade_history;
+---------------------+--------------+-------------------+--------------+------+--------------------------------------+
| upgrade_date | version_info | db_version | os | mu | update_ticket |
+---------------------+--------------+-------------------+--------------+------+--------------------------------------+
[...]
| 2019-07-27 06:27:30 | 17.8.11 | NULL | Ubuntu 16.04 | 61 | |
| 2019-08-04 06:25:44 | 17.8.11 | NULL | Ubuntu 16.04 | 62 | |
| 2019-08-12 06:26:07 | 17.8.11 | NULL | Ubuntu 16.04 | 63 | |
| 2019-08-20 06:27:47 | 17.8.11 | NULL | Ubuntu 16.04 | 65 | |
| 2019-08-28 06:28:42 | 17.8.11 | NULL | Ubuntu 16.04 | 66 | |
| 2019-09-13 06:26:03 | 17.8.11 | NULL | Ubuntu 16.04 | 67 | |
| 2019-09-21 06:26:20 | 17.8.11 | NULL | Ubuntu 16.04 | 68 | |
| 2019-10-03 06:52:29 | 18.0.19 | NULL | Ubuntu 16.04 | NULL | |
| 2019-10-23 06:45:45 | 18.0.20 | NULL | Ubuntu 16.04 | 0 | c6a51dd3-532f-4f2f-b812-1077b4c8ffa5 |
| 2019-10-26 22:19:47 | 18.0.20 | NULL | Ubuntu 18.04 | 0 | c6a51dd3-532f-4f2f-b812-1077b4c8ffa5 |
| 2021-02-13 08:26:33 | 18.0.20 | NULL | Ubuntu 20.04 | 0 | |
+---------------------+--------------+-------------------+--------------+------+--------------------------------------+


mysql> select * from misc where param='version';
+---------+-----------+
| param | val |
+---------+-----------+
| version | 018000000 |
+---------+-----------+
1 row in set (0.00 sec)

I can spot the Problem. I know that I had major issues with an inplace release upgrade of ubuntu and plesk.
I know that I successfully could install `18.0.43` yesterday. So I am right that I just need do update the `18.0.20` value in the database?

If yes, where I need to do this?

Thank you,
Pakon

 

[IgorG]

Try to fix this mismatch with

# plesk repail installation

Actually, output of mysql> select * from misc where param='version'; is correct.

 

[Pakon]

Hey, the same problem again.

[...]
Downloading file php52.inf3: 0%
Downloading file php52.inf3: 100% was finished.
Downloading file pmm.inf3: 0%
Downloading file pmm.inf3: 100% was finished.
Checking for installed packages...
ERROR: Selector '18.0.20' does not match any product ID, release ID, release tier, or release version. Use either 'list' or 'list-all' command to list known entities.

ERROR:Unable to retrieve repository configuration from autoinstaller: unknown error

Bootstrapper repair finished.
Errors occurred while performing the following actions: fix Plesk packages permissions.
Check '/var/log/plesk/install/plesk_18.0.43_repair.log' and '/var/log/plesk/install/plesk_18.0.43_repair_problems.log' for details.
If you can't resolve the issue on your own, please address Plesk support.
***** problem report *****
Warning: phpMyAdmin was configured without configuration storage in database

exit status 1

I assume the Selector 18.0.20 comes from the database. This value must be increased to 18.0.43, isn't it?

 

[IgorG]

Try to switch to alternative archive repository with

# plesk installer --source autoinstall-archives.plesk.com

and then plesk repair installation again.

 

[IgorG]

Hey, the same problem again.


I assume the Selector 18.0.20 comes from the database. This value must be increased to 18.0.43, isn't it?

You can try to update line

2021-02-13 08:26:33 | 18.0.20 | NULL | Ubuntu 20.04 | 0 | |

in database to 18.0.43 but I afraid that consequences may be unpredictable.

 

[Pakon]

Hey,

i decided to increase the value in the db to 18.0.43

mysql> select * from upgrade_history order by upgrade_date desc limit 2;
+---------------------+--------------+------------+--------------+------+--------------------------------------+
| upgrade_date | version_info | db_version | os | mu | update_ticket |
+---------------------+--------------+------------+--------------+------+--------------------------------------+
| 2021-02-13 08:26:33 | 18.0.43 | NULL | Ubuntu 20.04 | 0 | |
| 2019-10-26 22:19:47 | 18.0.20 | NULL | Ubuntu 18.04 | 0 | c6a51dd3-532f-4f2f-b812-1077b4c8ffa5 |
+---------------------+--------------+------------+--------------+------+--------------------------------------+

The repair tool still thinks the the version is 18.0.20 :-(

Thank you,
Pakon