Issue no installation of components possible anymore

[shopuser]

Server operating system version

Ubuntu 22.04.5 LTS

Plesk version and microupdate number

Plesk Obsidian 18.0.65

The error occurred when I wanted to migrate something via Plesk migrator, an error occurred,
then I uninstalled the Plesk migrator.A new installation is no longer possible but for all uninstalled components
It is possible that the performance booster has changed something in the database.I reset it but it didn't work either.

[2024-11-09 21:24:15.101083] Bootstrapper has finished action (exec time: 0 sec.): parent_name='PLESK_18_0_65', sequence='post', stage='rollback', sequence_order='1', operation='install', exec_cmd='rm -f /tmp/pp-bootstrapper-mode.flag; rm -f /var/lock/parallels-panel-maintenance-mode.flag; touch /var/lock/parallels-panel-upgrade-failure.flag; :'', m_arch='', exit code: 0, output: ~empty
[2024-11-09 21:24:15.102167] Überprüfung der Komponenten und Produkte wird gestartet...
[2024-11-09 21:24:15.102190] FileFetcher: get file (~empty)/report-update
[2024-11-09 21:24:15.102242] Datei wird heruntergeladen report-update: 0%
[2024-11-09 21:24:15.165897] Datei wird heruntergeladen report-update: 100% fertig.
[2024-11-09 21:24:15.166113] FileFetcher: get file (~empty)/pool/PSA_18.0.65_15773/examiners/py_launcher.sh
[2024-11-09 21:24:15.166146] Datei wird heruntergeladen pool/PSA_18.0.65_15773/examiners/py_launcher.sh: 0%
[2024-11-09 21:24:15.186116] Datei wird heruntergeladen pool/PSA_18.0.65_15773/examiners/py_launcher.sh: 100% fertig.
[2024-11-09 21:24:15.549490] Examination executed ["/root/parallels/pool/PSA_18.0.65_15773/examiners/py_launcher.sh" "/root/parallels/report-update" --op update --rc 1 --start-flag /var/lock/plesk-report-update.flag --to=18.0.65.0 --from=18.0.65] with code 0
Output:
~empty
Error:
mysql: unknown variable 'innodb_flush_log_at_trx_commit=2'
mysql: unknown variable 'innodb_flush_neighbors=0'
mysql: unknown variable 'innodb_flush_method=O_DIRECT_NO_FSYNC'
mysql: unknown variable 'innodb_io_capacity=450'
mysql: unknown variable 'innodb_random_read_ahead=ON'
mysql: unknown variable 'table_open_cache=5000'
mysql: unknown option '--mysql -max-connections 151'
mysql: unknown variable 'innodb_buffer_pool_size=728462131'
mysql: unknown variable 'innodb_log_file_size=182115532'
mysql: unknown variable 'innodb_flush_log_at_trx_commit=2'
mysql: unknown variable 'innodb_flush_neighbors=0'
mysql: unknown variable 'innodb_flush_method=O_DIRECT_NO_FSYNC'
mysql: unknown variable 'innodb_io_capacity=450'
mysql: unknown variable 'innodb_random_read_ahead=ON'
mysql: unknown variable 'table_open_cache=5000'
mysql: unknown option '--mysql -max-connections 151'
mysql: unknown variable 'innodb_buffer_pool_size=728462131'
mysql: unknown variable 'innodb_log_file_size=182115532'

[2024-11-09 21:24:15.549733] Execute command /opt/psa/admin/bin/send-error-report install --version 18.0.65
[2024-11-09 21:24:15.550573] Warning: Failed to detach from parents cgroup, installer might be unexpectedly killed later by the system
[2024-11-09 21:24:15.552156] Error: Während der POST-Installation ist ein Fehler aufgetreten (siehe Protokoll für Einzelheiten).
Warnung! Es wurden nicht alle Pakete installiert.
Bitte prüfen Sie, ob Ihre Systemdienste betriebsbereit sind.
Bitte beheben Sie dieses Problem und versuchen Sie, die Pakete erneut zu installieren. Rufen Sie https://support.plesk.com/ auf, um eine Lösung für dieses Problem zu finden.

 

[shopuser]

later I tried Plesk Repair:

Reconfiguring the Plesk installation
Reconfiguring the Plesk installation ............................ [FAILED]
- Started bootstrapper repair procedure (fast mode). This may
take a while.
- Certain actions may be skipped if not applicable.
-
-
- **** Product repair started.
- Started bootstrapper repair procedure (fast mode). This may
take a while.
- Certain actions may be skipped if not applicable.
-
- Trying to start service mariadb... active
- done
- Trying to establish test connection... /usr/bin/mysql: unknown
variable 'innodb_flush_log_at_trx_commit=2'
- /usr/bin/mysql: unknown variable 'innodb_flush_neighbors=0'
- /usr/bin/mysql: unknown variable
'innodb_flush_method=O_DIRECT_NO_FSYNC'
- /usr/bin/mysql: unknown variable 'innodb_io_capacity=450'
- /usr/bin/mysql: unknown variable 'innodb_random_read_ahead=ON'
- /usr/bin/mysql: unknown variable 'table_open_cache=5000'
- /usr/bin/mysql: unknown option '--mysql -max-connections 151'
- /usr/bin/mysql: unknown variable
'innodb_buffer_pool_size=728462131'
- /usr/bin/mysql: unknown variable
'innodb_log_file_size=182115532'
- /usr/bin/mysql: unknown variable
'innodb_flush_log_at_trx_commit=2'
- /usr/bin/mysql: unknown variable 'innodb_flush_neighbors=0'
- /usr/bin/mysql: unknown variable
'innodb_flush_method=O_DIRECT_NO_FSYNC'
- /usr/bin/mysql: unknown variable 'innodb_io_capacity=450'
- /usr/bin/mysql: unknown variable 'innodb_random_read_ahead=ON'
- /usr/bin/mysql: unknown variable 'table_open_cache=5000'
- /usr/bin/mysql: unknown option '--mysql -max-connections 151'
- /usr/bin/mysql: unknown variable
'innodb_buffer_pool_size=728462131'
- /usr/bin/mysql: unknown variable
'innodb_log_file_size=182115532'
- /usr/bin/mysql: unknown variable
'innodb_flush_log_at_trx_commit=2'
- /usr/bin/mysql: unknown variable 'innodb_flush_neighbors=0'
- /usr/bin/mysql: unknown variable
'innodb_flush_method=O_DIRECT_NO_FSYNC'
- /usr/bin/mysql: unknown variable 'innodb_io_capacity=450'
- /usr/bin/mysql: unknown variable 'innodb_random_read_ahead=ON'
- /usr/bin/mysql: unknown variable 'table_open_cache=5000'
- /usr/bin/mysql: unknown option '--mysql -max-connections 151'
- /usr/bin/mysql: unknown variable
'innodb_buffer_pool_size=728462131'
- /usr/bin/mysql: unknown variable
'innodb_log_file_size=182115532'
- /usr/bin/mysql: unknown variable
'innodb_flush_log_at_trx_commit=2'
- /usr/bin/mysql: unknown variable 'innodb_flush_neighbors=0'
- /usr/bin/mysql: unknown variable
'innodb_flush_method=O_DIRECT_NO_FSYNC'
- /usr/bin/mysql: unknown variable 'innodb_io_capacity=450'
- /usr/bin/mysql: unknown variable 'innodb_random_read_ahead=ON'
- /usr/bin/mysql: unknown variable 'table_open_cache=5000'
- /usr/bin/mysql: unknown option '--mysql -max-connections 151'
- /usr/bin/mysql: unknown variable
'innodb_buffer_pool_size=728462131'
- /usr/bin/mysql: unknown variable
'innodb_log_file_size=182115532'
- /usr/bin/mysql: unknown variable
'innodb_flush_log_at_trx_commit=2'
- /usr/bin/mysql: unknown variable 'innodb_flush_neighbors=0'
- /usr/bin/mysql: unknown variable
'innodb_flush_method=O_DIRECT_NO_FSYNC'
- /usr/bin/mysql: unknown variable 'innodb_io_capacity=450'
- /usr/bin/mysql: unknown variable 'innodb_random_read_ahead=ON'
- /usr/bin/mysql: unknown variable 'table_open_cache=5000'
- /usr/bin/mysql: unknown option '--mysql -max-connections 151'
- /usr/bin/mysql: unknown variable
'innodb_buffer_pool_size=728462131'
- /usr/bin/mysql: unknown variable
'innodb_log_file_size=182115532'
- /usr/bin/mysql: unknown variable
'innodb_flush_log_at_trx_commit=2'
- /usr/bin/mysql: unknown variable 'innodb_flush_neighbors=0'
- /usr/bin/mysql: unknown variable
'innodb_flush_method=O_DIRECT_NO_FSYNC'
- /usr/bin/mysql: unknown variable 'innodb_io_capacity=450'
- /usr/bin/mysql: unknown variable 'innodb_random_read_ahead=ON'
- /usr/bin/mysql: unknown variable 'table_open_cache=5000'
- /usr/bin/mysql: unknown option '--mysql -max-connections 151'
- /usr/bin/mysql: unknown variable
'innodb_buffer_pool_size=728462131'
- /usr/bin/mysql: unknown variable
'innodb_log_file_size=182115532'
- /usr/bin/mysql: unknown variable
'innodb_flush_log_at_trx_commit=2'
- /usr/bin/mysql: unknown variable 'innodb_flush_neighbors=0'
- /usr/bin/mysql: unknown variable
'innodb_flush_method=O_DIRECT_NO_FSYNC'
- /usr/bin/mysql: unknown variable 'innodb_io_capacity=450'
- /usr/bin/mysql: unknown variable 'innodb_random_read_ahead=ON'
- /usr/bin/mysql: unknown variable 'table_open_cache=5000'
- /usr/bin/mysql: unknown option '--mysql -max-connections 151'
- /usr/bin/mysql: unknown variable
'innodb_buffer_pool_size=728462131'
- /usr/bin/mysql: unknown variable
'innodb_log_file_size=182115532'
- /usr/bin/mysql: unknown variable
'innodb_flush_log_at_trx_commit=2'
- /usr/bin/mysql: unknown variable 'innodb_flush_neighbors=0'
- /usr/bin/mysql: unknown variable
'innodb_flush_method=O_DIRECT_NO_FSYNC'
- /usr/bin/mysql: unknown variable 'innodb_io_capacity=450'
- /usr/bin/mysql: unknown variable 'innodb_random_read_ahead=ON'
- /usr/bin/mysql: unknown variable 'table_open_cache=5000'
- /usr/bin/mysql: unknown option '--mysql -max-connections 151'
- /usr/bin/mysql: unknown variable
'innodb_buffer_pool_size=728462131'
- /usr/bin/mysql: unknown variable
'innodb_log_file_size=182115532'
- /usr/bin/mysql: unknown variable
'innodb_flush_log_at_trx_commit=2'
- /usr/bin/mysql: unknown variable 'innodb_flush_neighbors=0'
- /usr/bin/mysql: unknown variable
'innodb_flush_method=O_DIRECT_NO_FSYNC'
- /usr/bin/mysql: unknown variable 'innodb_io_capacity=450'
- /usr/bin/mysql: unknown variable 'innodb_random_read_ahead=ON'
- /usr/bin/mysql: unknown variable 'table_open_cache=5000'
- /usr/bin/mysql: unknown option '--mysql -max-connections 151'
- /usr/bin/mysql: unknown variable
'innodb_buffer_pool_size=728462131'
- /usr/bin/mysql: unknown variable
'innodb_log_file_size=182115532'
- /usr/bin/mysql: unknown variable
'innodb_flush_log_at_trx_commit=2'
- /usr/bin/mysql: unknown variable 'innodb_flush_neighbors=0'
- /usr/bin/mysql: unknown variable
'innodb_flush_method=O_DIRECT_NO_FSYNC'
- /usr/bin/mysql: unknown variable 'innodb_io_capacity=450'
- /usr/bin/mysql: unknown variable 'innodb_random_read_ahead=ON'
- /usr/bin/mysql: unknown variable 'table_open_cache=5000'
- /usr/bin/mysql: unknown option '--mysql -max-connections 151'
- /usr/bin/mysql: unknown variable
'innodb_buffer_pool_size=728462131'
- /usr/bin/mysql: unknown variable
'innodb_log_file_size=182115532'
- failed
-
- ERROR while trying to establish test connection
-
- Check the error reason (see log file:
/var/log/plesk/install/plesk_18.0.65_repair.log), fix and try
again
- ***** problem report *****
- ERROR while trying to establish test connection

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 ...................... [OK]

Checking system users ............................................... [OK]

Checking Linux system files

There are incorrect permissions on some items: /var/lock .......... [ERROR]
To see more details, run the command in the verbose mode: plesk repair fs -verbose
Do you want to repair incorrect permissions? [Y/n] y
Repairing incorrect permissions ................................. [2024-11-09 20:55:09.787]
2277061:672fbe1dc0108 ERR [util_exec] proc_close() failed ['/opt/psa/admin/bin/fsmng' '--set-ac' '/var/lock'] with exit code [1]
[FAILED]
- fsmng failed: ERROR: Cannot fix %s: file exists and it is not a
symlink

 

[Raul A.]

Hi,

Please share your /etc/my.cnf file. performance booster adds some variables there.

Can you restart MariaDB? What version of MariaDB are you running?

 

[Sebahat.hadzhi]

Hello, @shopuser, could you please also check if there are misconfigured packages:

plesk sbin pum --check

dpkg --audit

As for the Cannot fix %s: file exists and it is not a symlink error, you might try applying the following workaround.

 

[shopuser]

Hello, @shopuser, could you please also check if there are misconfigured packages:





As for the Cannot fix %s: file exists and it is not a symlink error, you might try applying the following workaround.

Hello, i get this :

root@server1:~# plesk sbin pum --check
2024-11-10 18:01:39 INFO: pum is called with arguments: ['--check']

root@server1:~# dpkg --audit
root@server1:~#

 

[shopuser]

As for the Cannot fix %s: file exists and it is not a symlink error, you might try applying the following workaround.

and this thread solve not the problem, and i check at a other server with plesk but the folder /var/lock is not a symlink but a normal folder

root@server1:/# mv /var/lock{,.backup}
root@server1:/# plesk repair fs -system -y

Checking Linux system files

There are incorrect permissions on some items: /var/lock .......... [ERROR]
To see more details, run the command in the verbose mode: plesk repair fs -verbose
Repairing incorrect permissions ................................. [FIXED]

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

 

[shopuser]

Hi,

Please share your /etc/my.cnf file. performance booster adds some variables there.

Can you restart MariaDB? What version of MariaDB are you running?

i have deactivated the performance booster but in was still the configuration, /etc/mysql/conf.d mysql.cnf


i deleted the all entrys in this file and and the last entries in the my.inf from Plesk Performance Booster


now it is possible to install components again !
the Plesk Performance Booster was the Problem !



/etc/mysql/conf.d
mysql.cnf

[mysql]


# next values added by Plesk Performance Booster
innodb_flush_log_at_trx_commit = 2
innodb_flush_neighbors = 0
innodb_flush_method = O_DIRECT_NO_FSYNC
innodb_io_capacity = 450
innodb_random_read_ahead = ON
table_open_cache = 5000
mysql -max-connections 151
innodb_buffer_pool_size = 728462131
innodb_log_file_size = 182115532
# values above added by Plesk Performance Booster

mariadb.cnf

socket = /run/mysqld/mysqld.sock

# Import all .cnf files from configuration directory
!includedir /etc/mysql/conf.d/
!includedir /etc/mysql/mariadb.conf.d/
[mysqld]
local-infile=0

my.cnf

[client-server]
# Port or socket location where to connect
# port = 3306
socket = /run/mysqld/mysqld.sock

# Import all .cnf files from configuration directory
!includedir /etc/mysql/conf.d/
!includedir /etc/mysql/mariadb.conf.d/
[mysqld]
sql_mode=ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION
bind-address = 127.0.0.1
local-infile=0


max_connections=1000

# wait_timeout = 28800
# interactive_timeout = 28800# added by Plesk Performance Booster
# added by Plesk Performance Booster
# !include /etc/mysql/db-performance.cnf