Unable to create databases on a Subscription: There are no database servers available for this subscription

Symptoms

• When clicking on the Add Database button within and Subscription in Plesk, the following error message is shown:
  

  PLESK_ERROR: Error: There are no database servers available for this subscription.

• When opening the WP Toolkit in the Plesk GUI, one of the following error messages is shown:

  PLESK_ERROR: Your hosting plan does not allow you to create any more databases. This WordPress installation will use an existing database instead of creating a new one.

  PLESK_ERROR: Internal Server Error: PleskExt\WpToolkit\Helper\Db::makeUniqueDbName(): Argument #1 ($dbServerId) must be of type int, null given, called in /usr/local/psa/admin/plib/modules/wp-toolkit/library/Helper/Install/PleskInstallTargetDatabase.php on line 144

Cause

A default MySQL server is not set for the Subscription on which the database creation attempt is made.

Resolution

Synchronize the Subscription that is experiencing the issue with its Service plan:

1. Log into your server via SSH

2. Synchronize the affected Subscription with its Service plan by executing the following command:

   # plesk bin subscription --sync-subscription example.com

Click on a section to expand