Some days ago I wanted to back-up psa database and I did it through the only option I could find in the server: Back up from server backup.
That backup tried to back up all server and hosts, so I had to hard kill it because the server is heavy loaded and used.
Anyway hard killing backup processes was not clean (there is no way I found to stop the backup process in a clear way).
Now, trying to update plesk obsidian to 18.0.35 gives me an error:
Trying to backup MySQL database...
ERROR while trying to Another transaction in progress!
And I cannot update the system. I restarted the system today so I understand the database should not be in an unstable state.
Any help will be highly appreciated
Here it is the log:
[2021-05-24 13:50:49.627539] Installation started in background
...
===> Upgrading database
Trying to start service mysql... active
done
Trying to establish test connection... connected
done
Trying to find psa database... version is 018000000
Trying to backup MySQL database...
ERROR while trying to Another transaction in progress!
Check the error reason (see log file: /var/log/plesk/install/plesk_18.0.35_installation.log), fix and try again
***** problem report *****
ERROR while trying to Another transaction in progress!
Bootstrapper has finished action (exec time: 1 sec.): parent_name='panel', sequence='prep', stage='execute', sequence_order='0', operation='install', exec_cmd='/opt/psa/bootstrapper/pp18.0.35-bootstrapper/bootstrapper.sh prep-install BASE'', m_arch='', exit code: 1, output:
**** Product prep-install started.
Create user 'psaadm' and group 'psaadm'
Group 'psaadm' already exists
Checking for the user 'psaadm'...
User 'psaadm' already exists
Create group 'swkey-data'
Group 'swkey-data' already exists
Trying to add supplementary group 'swkey-data' for user 'psaadm'... already there
Create group 'psaserv'
Group 'psaserv' already exists
Trying to add supplementary group 'psaserv' for user 'psaadm'... already there
Create group 'psacln'
Group 'psacln' already exists
Trying to got legacy variables... done
Trying to save legacy variables... done
Checking that /opt/psa/bin/chrootsh registered as login shell...
===> Performing safe prep-install database actions
===> Upgrading database
Trying to start service mysql... active
done
Trying to establish test connection... connected
done
Trying to find psa database... version is 018000000
Trying to backup MySQL database...
ERROR while trying to Another transaction in progress!
***** problem report *****
ERROR while trying to Another transaction in progress!
[2021-05-24 13:50:52.411901] Bootstrapper has finished action (exec time: 0 sec.): parent_name='PLESK_18_0_35', sequence='prep', 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; rm -f /var/lock/parallels-panel-upgrade-failure.flag; :'', m_arch='', exit code: 0, output: ~empty
[2021-05-24 13:50:52.837293] Bootstrapper has finished action (exec time: 0 sec.): parent_name='panel', sequence='prep', stage='rollback', sequence_order='9999', operation='install', exec_cmd='test ! -f /opt/psa/admin/plib/scripts/update-failure-notification.php || /opt/psa/admin/bin/php /opt/psa/admin/plib/scripts/update-failure-notification.php'', m_arch='', exit code: 0, output: ~empty
[2021-05-24 13:50:52.849285] Launching component and product checkers...
[2021-05-24 13:50:52.849368] FileFetcher: get file (~empty)/report-update
[2021-05-24 13:50:52.849590] Downloading file report-update: 0%
[2021-05-24 13:50:52.864753] Downloading file report-update: 100% was finished.
[2021-05-24 13:50:52.865145] FileFetcher: get file (~empty)/pool/PSA_18.0.35_6022/examiners/py_launcher.sh
[2021-05-24 13:50:52.865219] Downloading file pool/PSA_18.0.35_6022/examiners/py_launcher.sh: 0%
[2021-05-24 13:50:52.870795] Downloading file pool/PSA_18.0.35_6022/examiners/py_launcher.sh: 100% was finished.
[2021-05-24 13:50:53.216851] Examination executed ["/root/parallels/pool/PSA_18.0.35_6022/examiners/py_launcher.sh" "/root/parallels/report-update" --op upgrade --rc 1 --start-flag /var/lock/plesk-report-update.flag --to=18.0.35.1 --from=18.0.34] with code 0
Output:
~empty
Error:
~empty
[2021-05-24 13:50:53.217730] Execute command /opt/psa/admin/bin/send-error-report install --version 18.0.35
[2021-05-24 13:50:53.219605] Warning: Failed to attach to cgroup /sys/fs/cgroup/systemd/user/root/tasks, installer might be unexpectedly killed later by the system
[2021-05-24 13:50:53.225013] Error: An error occurred during performing of installation PREP actions (see log for details). Installation was rolled back.
Warning! Not all packages were installed.
Please check if your system services are operable.
Please resolve this issue and try to install the packages again.
Visit Plesk Help Center to search for a solution.
That backup tried to back up all server and hosts, so I had to hard kill it because the server is heavy loaded and used.
Anyway hard killing backup processes was not clean (there is no way I found to stop the backup process in a clear way).
Now, trying to update plesk obsidian to 18.0.35 gives me an error:
Trying to backup MySQL database...
ERROR while trying to Another transaction in progress!
And I cannot update the system. I restarted the system today so I understand the database should not be in an unstable state.
Any help will be highly appreciated
Here it is the log:
[2021-05-24 13:50:49.627539] Installation started in background
...
===> Upgrading database
Trying to start service mysql... active
done
Trying to establish test connection... connected
done
Trying to find psa database... version is 018000000
Trying to backup MySQL database...
ERROR while trying to Another transaction in progress!
Check the error reason (see log file: /var/log/plesk/install/plesk_18.0.35_installation.log), fix and try again
***** problem report *****
ERROR while trying to Another transaction in progress!
Bootstrapper has finished action (exec time: 1 sec.): parent_name='panel', sequence='prep', stage='execute', sequence_order='0', operation='install', exec_cmd='/opt/psa/bootstrapper/pp18.0.35-bootstrapper/bootstrapper.sh prep-install BASE'', m_arch='', exit code: 1, output:
**** Product prep-install started.
Create user 'psaadm' and group 'psaadm'
Group 'psaadm' already exists
Checking for the user 'psaadm'...
User 'psaadm' already exists
Create group 'swkey-data'
Group 'swkey-data' already exists
Trying to add supplementary group 'swkey-data' for user 'psaadm'... already there
Create group 'psaserv'
Group 'psaserv' already exists
Trying to add supplementary group 'psaserv' for user 'psaadm'... already there
Create group 'psacln'
Group 'psacln' already exists
Trying to got legacy variables... done
Trying to save legacy variables... done
Checking that /opt/psa/bin/chrootsh registered as login shell...
===> Performing safe prep-install database actions
===> Upgrading database
Trying to start service mysql... active
done
Trying to establish test connection... connected
done
Trying to find psa database... version is 018000000
Trying to backup MySQL database...
ERROR while trying to Another transaction in progress!
***** problem report *****
ERROR while trying to Another transaction in progress!
[2021-05-24 13:50:52.411901] Bootstrapper has finished action (exec time: 0 sec.): parent_name='PLESK_18_0_35', sequence='prep', 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; rm -f /var/lock/parallels-panel-upgrade-failure.flag; :'', m_arch='', exit code: 0, output: ~empty
[2021-05-24 13:50:52.837293] Bootstrapper has finished action (exec time: 0 sec.): parent_name='panel', sequence='prep', stage='rollback', sequence_order='9999', operation='install', exec_cmd='test ! -f /opt/psa/admin/plib/scripts/update-failure-notification.php || /opt/psa/admin/bin/php /opt/psa/admin/plib/scripts/update-failure-notification.php'', m_arch='', exit code: 0, output: ~empty
[2021-05-24 13:50:52.849285] Launching component and product checkers...
[2021-05-24 13:50:52.849368] FileFetcher: get file (~empty)/report-update
[2021-05-24 13:50:52.849590] Downloading file report-update: 0%
[2021-05-24 13:50:52.864753] Downloading file report-update: 100% was finished.
[2021-05-24 13:50:52.865145] FileFetcher: get file (~empty)/pool/PSA_18.0.35_6022/examiners/py_launcher.sh
[2021-05-24 13:50:52.865219] Downloading file pool/PSA_18.0.35_6022/examiners/py_launcher.sh: 0%
[2021-05-24 13:50:52.870795] Downloading file pool/PSA_18.0.35_6022/examiners/py_launcher.sh: 100% was finished.
[2021-05-24 13:50:53.216851] Examination executed ["/root/parallels/pool/PSA_18.0.35_6022/examiners/py_launcher.sh" "/root/parallels/report-update" --op upgrade --rc 1 --start-flag /var/lock/plesk-report-update.flag --to=18.0.35.1 --from=18.0.34] with code 0
Output:
~empty
Error:
~empty
[2021-05-24 13:50:53.217730] Execute command /opt/psa/admin/bin/send-error-report install --version 18.0.35
[2021-05-24 13:50:53.219605] Warning: Failed to attach to cgroup /sys/fs/cgroup/systemd/user/root/tasks, installer might be unexpectedly killed later by the system
[2021-05-24 13:50:53.225013] Error: An error occurred during performing of installation PREP actions (see log for details). Installation was rolled back.
Warning! Not all packages were installed.
Please check if your system services are operable.
Please resolve this issue and try to install the packages again.
Visit Plesk Help Center to search for a solution.
Last edited: