Resolved Problem for update Plesk Obsidian

[JM Malsacre]

Server operating system version

Debian11

Plesk version and microupdate number

Plesk Obsidian 18.0.81 Update #2

Hello everyone,
I'm trying to update the Plesk Obsidian of one of my Plesk servers but I receive an error in the log file:

ERROR: Plesk\Exception\Database: DB query failed: (1034) SQLSTATE[HY000]: General error: 1034 Index for table 'PanelNotificationMessages' is corrupt; try to repair it, query was: INSERT INTO `PanelNotificationMessages` (`clientId`, `adminAliasId`, `isRead`, `isFavorite`, `subject`, `message`, `actionText`, `actionLink`, `category`, `area`, `context`, `contextIconUrl`, `isViewed`, `code`, `openInNewTab`, `messageKey`, `isPromotion`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (Mysql.php:79)
Bootstrapper has finished action (exec time: 1 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: 1, output: ERROR: Plesk\Exception\Database: DB query failed: (1034) SQLSTATE[HY000]: General error: 1034 Index for table 'PanelNotificationMessages' is corrupt; try to repair it, query was: INSERT INTO `PanelNotificationMessages` (`clientId`, `adminAliasId`, `isRead`, `isFavorite`, `subject`, `message`, `actionText`, `actionLink`, `category`, `area`, `context`, `contextIconUrl`, `isViewed`, `code`, `openInNewTab`, `messageKey`, `isPromotion`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (Mysql.php:79)

I'm not a computer expert and I would appreciate some help if you have a solution to offer me.

Regards.
Jean-Marie from France

 

[JM Malsacre]

For information, i try to repair the 'PanelNotificationMessages' table in 'psa' BDD with phpmyadmin but i receive : 'This type of table does not support repairs'
Thank you for any possible help.
Jean-Marie

 

[Martin Dias]

did you already try "plesk repair db"? if yes what error you get there?

If it fails you can adjust this article to your affected table:

Plesk shows the error: Error 1034: Index for table 'log_actions' is corrupt

Applicable to: Plesk for Linux Symptoms When logging in to Plesk, the following error message is shown in a web browser: PLESK_INFO: Server Error500 Plesk\Exception\DatabaseDB query failed: (1034)...

support.plesk.com

 

[JM Malsacre]

For information :
I deleted the table that had a probeme, then I retrieved the table structure on another Plesk and recreated the Table successfully!
Everything is ok now.
Good day
Jean-Marie

 

[JM Malsacre]

I don't know how i can change 'QUESTION' to 'RESOLVED'