WordPress update gets stuck when updating via Plesk WP Toolkit: DELETE command denied to user

Symptoms

• WordPress update gets stuck when updating via WP Toolkit.

• In /var/log/plesk/panel.log, the following error is found:

  '/usr/local/psa/admin/bin/filemng' 'example' 'exec' '/var/www/vhosts/example.com/httpdocs' 'timeout' '1800' '/opt/plesk/php/7.4/bin/php' '-d' 'safe_mode=off' '-d' 'display_errors=on' '-d' 'opcache.enable_cli=off' '-d' 'open_basedir=' '-d' 'error_reporting=341' '-d' 'max_execution_time=1800' '-c' '/var/www/vhosts/system/example.com/etc/php.ini' '/usr/local/psa/admin/plib/modules/wp-toolkit/vendor/wp-cli/wpt-wp-cli.php' '--path=/var/www/vhosts/example.com/httpdocs' '--no-color' 'core' 'update' '--version=5.7.5' '--minor'] with exit code [11]

• The following messages appear in /var/www/vhosts/system/example.com/logs/error_log, cumulatively growing:

  [fcgid:warn] [pid 21127] [client 203.0.113.2:54350] mod_fcgid: stderr: WordPress-Datenbank-Fehler DELETE command denied to user 'john_doe'@'localhost' for table ...

Cause

DELETE permissions is missing for the database user john_doe.

Resolution

1. Log in to Plesk.

2. Go to to Domains > example.com > Databases > User Management > john_doe.

3. Check the Delete checkbox in Data Access section and apply the changes.

   

4. Update the WordPress instance.