Resolved Plesk updato to 18.0.69 error

totti240282

New Pleskian
Server operating system version
Ubuntu 24.04.2 LTS
Plesk version and microupdate number
18.0.68
Hello,
i try to update Plesk and obtain this error:

===> Plesk database scheme upgrade has been started.
Applying migrations from: /opt/psa/bootstrapper/pp18.0.69-bootstrapper/migrations/
Migration failed: 18.0.69/2025-04-04-16-09-23_add_id_to_sessions.php
Error on rename of './psa/sessions' to './psa/#sql-backup-65c-1efa8' (errno: 168 "Unknown (generic) error from engine")

===> Plesk database scheme was not upgraded completely.

Applying migrations from: /opt/psa/bootstrapper/pp18.0.69-bootstrapper/migrations/
Migration failed: 18.0.69/2025-04-04-16-09-23_add_id_to_sessions.php
Error on rename of './psa/sessions' to './psa/#sql-backup-65c-1efa8' (errno: 168 "Unknown (generic) error from engine")
***** problem report *****
===> Plesk database scheme was not upgraded completely.
 
Try to run a Plesk repair:
Code:
plesk repair  db -v
Looks like you might have a broken table in the psa database.
 
Checking the structure of the Plesk database ........................ [OK]

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

Error messages: 0; Warnings: 0; Errors resolved: 0
 
Unfortunately, it's not possible to decrypt the Plesk PHP files.

Can you select data from the sessions table?
 
I've just upgraded on my AlmaLinux 8 server and it worked.
Code:
===> Plesk database scheme upgrade has been started.
Applying migrations from: /usr/local/psa/bootstrapper/pp18.0.69-bootstrapper/migrations/
Migration 18.0.69/2025-04-04-16-09-23_add_id_to_sessions.php applied
===> Plesk database scheme upgrade has been completed.

This is what the table looks like on Plesk Obsidian 18.0.68.2
Code:
| sessions | CREATE TABLE `sessions` (
  `sess_id` varchar(33) NOT NULL,
  `type` smallint(5) unsigned NOT NULL DEFAULT 0,
  `login` varchar(255) DEFAULT NULL,
  `ip_address` varchar(39) DEFAULT NULL,
  `ip_dual_stack` varchar(39) DEFAULT NULL,
  `login_time` int(10) unsigned DEFAULT NULL,
  `modified` int(10) unsigned DEFAULT NULL,
  `lifetime` int(10) unsigned DEFAULT NULL,
  PRIMARY KEY (`sess_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci |

and this is what it looks like on Plesk Obsidian 18.0.69.0
Code:
| sessions | CREATE TABLE `sessions` (
  `sess_id` varchar(33) NOT NULL,
  `type` smallint(5) unsigned NOT NULL DEFAULT 0,
  `login` varchar(255) DEFAULT NULL,
  `ip_address` varchar(39) DEFAULT NULL,
  `ip_dual_stack` varchar(39) DEFAULT NULL,
  `login_time` int(10) unsigned DEFAULT NULL,
  `modified` int(10) unsigned DEFAULT NULL,
  `lifetime` int(10) unsigned DEFAULT NULL,
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`id`),
  UNIQUE KEY `sess_id` (`sess_id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci |

You can get the table structure using:
Code:
plesk db "show create table sessions"
 
Back
Top