Plesk GUI returns Error 500: /var/www/vhosts is out of webspace

Symptoms

• Unable to access Plesk GUI:

  /var/www/vhosts/ is out of webspace

• The following details can be seen in /var/log/plesk/panel.log:

  [2023-09-11 19:58:19.847] 22587:64ff634bceb23 ERR [panel] PleskFatalException:
  /var/www/vhosts is out of webspace
  file: /usr/local/psa/admin/plib/Webspace.php
  line: 439
  code: 0
  trace: #0 /usr/local/psa/admin/plib/Commands/MoveDomain.php(229): Webspace->getRelativePathInsideWebspace(string '/var/www/vhosts')
  #1 /usr/local/psa/admin/plib/Commands/MoveDomain.php(175): Commands_MoveDomain->getTargetPath(string '/var/www/vhosts')
  #2 /usr/local/psa/admin/plib/Commands/MoveDomain.php(121): Commands_MoveDomain->prepareValidate()
  #3 /usr/local/psa/admin/plib/Commands/MergeSubscriptions.php(167): Commands_MoveDomain->isSourceValid(boolean true)
  #4 /usr/local/psa/admin/plib/Commands/MergeSubscriptions.php(104): Commands_MergeSubscriptions->validateSource()
  #5 /usr/local/psa/admin/plib/Smb/View/Web/SiteRenderer.php(277): Commands_MergeSubscriptions->isSourceValid()
  #6 /usr/local/psa/admin/plib/Smb/View/Web/SiteRenderer.php(127): Smb_View_Web_SiteRenderer->getSiteMovingError(object of type PhDomain)
  #7 /usr/local/psa/admin/plib/Smb/View/List/Sites.php(228): Smb_View_Web_SiteRenderer->getSiteRecord(object of type PhDomain)
  #8 /usr/local/psa/admin/plib/CommonPanel/View/List/Abstract.php(269): Smb_View_List_Sites->_getData()
  #9 /usr/local/psa/admin/plib/CommonPanel/View/ActiveList.php(202): CommonPanel_View_List_Abstract->fetchData()
  #10 /usr/local/psa/admin/plib/CommonPanel/View/ActiveList.php(337): CommonPanel_View_ActiveList->fetchData()
  #11 /usr/local/psa/admin/plib/Smb/View/ActiveList/Sites.php(180): CommonPanel_View_ActiveList->getJsConfig()
  #12 /usr/local/psa/admin/application/smb/controllers/WebController.php(115): Smb_View_ActiveList_Sites->getJsConfig()
  #13 /usr/local/psa/admin/plib/vendor/plesk/zf1/library/Zend/Controller/Action.php(516): Smb_WebController->viewAction()
  #14 /usr/local/psa/admin/plib/vendor/plesk/zf1/library/Zend/Controller/Dispatcher/Standard.php(308): Zend_Controller_Action->dispatch(string 'viewAction')
  #15 /usr/local/psa/admin/plib/vendor/plesk/zf1/library/Zend/Controller/Front.php(954): Zend_Controller_Dispatcher_Standard->dispatch(object of type Zend_Controller_Request_Http, object of type Zend_Controller_Response_Http)
  #16 /usr/local/psa/admin/plib/Application/Web.php(48): Zend_Controller_Front->dispatch(object of type Zend_Controller_Request_Http)
  #17 /usr/local/psa/admin/htdocs/application.php(15): PleskApplication_Web->run()

• All the system users home paths exist in the filesystem.

Cause

Inconsistency in the psa.hosting table. A www_root value is set to something different than /var/www/vhosts/example.com/anything.

Resolution

1. Connect to the server via SSH

2. Create Plesk database backup

3. Access Plesk database

4. Find all the www_root values that are different than /var/www/vhosts/example.com/<anything>:

   select d.id, d.name, h.www_root from domains d join hosting h on d.id=h.dom_id where www_root not like "/var/www/vhosts/%/%";
   +----+-----------------+---------------------------------+
   | id | name | www_root |
   +----+-----------------+---------------------------------+
   | 10 | example.com | /var/www/vhosts/example.com |
   +----+-----------------+---------------------------------+
   1 row in set (0.00 sec)

5. Update the faulty value:

   update hosting set www_root="/var/www/vhosts/example.com/httpdocs" where dom_id=10;
   Query OK, 1 row affected (0.00 sec)
   Rows matched: 1 Changed: 1 Warnings: 0