Issue Plesk update failed : mysqldump: Couldn't execute 'show create table `general_log`'

[AdelM]

Hello

Since a few days autoupdate fails with the below error
Any help would very much appreciated

========================================================
Version Plesk Obsidian v18.0.38_build1800210913.22 os_Ubuntu 18.04
OS Ubuntu 18.04.6 LTS
10.1.48-MariaDB-0ubuntu0.18.04.1 - Ubuntu 18.04
========================================================

**** 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 mariadb... active
done
Trying to establish test connection... connected
done
Trying to find psa database... version is 018000000
Trying to backup MySQL database... mysqldump: Couldn't execute 'show create table `general_log`': Can't find record in 'general_log' (1032)

ERROR while trying to backup MySQL database
**** Product prep-install for BASE failed.

mysqldump: Couldn't execute 'show create table `general_log`': Can't find record in 'general_log' (1032)
***** problem report *****
ERROR while trying to backup MySQL database

============================================

 

[IgorG]

Couldn't execute 'show create table `general_log`': Can't find record in 'general_log' (1032)

Looks like mysql database is corrupted. Try to re-create the missing table:

# plesk db

> use mysql;

> drop table general_log;

> CREATE TABLE `general_log` (
  `event_time` timestamp(6) NOT NULL DEFAULT current_timestamp(6) ON UPDATE current_timestamp(6),
  `user_host` mediumtext NOT NULL,
  `thread_id` bigint(21) unsigned NOT NULL,
  `server_id` int(10) unsigned NOT NULL,
  `command_type` varchar(64) NOT NULL,
  `argument` mediumtext NOT NULL
) ENGINE=CSV DEFAULT CHARSET=utf8 COMMENT='General log';

 

[AdelM]

Hi Igor
I found this morning that general_log table has a huge size and more than 1G size (Attched file)
Applied the solution you have provided.
Thanks a lot