Question Template processing failed: file = /opt/psa/admin/conf/templates/default/domainVhost.php

[MWD]

Hi guy,

I migrating from an old pelsk (11.5.30) with Migration & Transfer Manager to a new Plesk Obsidian 18.04 plesk.
I receive the following error:

Template processing failed: file = /opt/psa/admin/conf/templates/default/domainVhost.php, error = Template_Exception: No data. file: /opt/psa/admin/plib/Template/Processor.php line: 28 code: 0 Previous error: Template_Variable_Exception: No data. file: /opt/psa/admin/plib/Template/Variable/AbstractCachedData.php line: 67 code: 0

I can't find the reason for this error.
Do you have any ideas?

Thanks

 

[IgorG]

What is the output of commands:

# httpd -t

# nginx -t

# plesk repair fs

# plesk repair web

?

 

[MWD]

root@v130:~# apachectl -t
Syntax OK

root@v130:~# nginx -t
nginx: the configuration file /etc/nginx/nginx.conf syntax is ok
nginx: configuration file /etc/nginx/nginx.conf test is successful

root@v130:~# plesk repair fs

...
...

Error messages: 0; Warnings: 38; Errors resolved: 0

root@v130:~# plesk repair web -y

Checking Plesk version .............................................. [OK]

Checking for custom configuration templates ......................... [OK]

Checking the JkWorkersFile directive in the Apache configuration .... [OK]

Checking associations between domains and IP addresses .............. [OK]

Checking for corrupted reference between IP collections and   
IPaddresses ......................................................... [OK]

Checking for links between APS applications and subscriptions ....... [OK]

Checking for nginx ULIMIT value ..................................... [OK]

Checking for extra configurations in database not owned by any object
................................................................... [OK]

Checking the configuration of Apache modules ........................ [OK]

Checking web server configuration. Please wait
    Reinstalling SSL/TLS certificates ............................... [OK]
    Applying the default SSL/TLS certificate to all IP addresses .... [OK]
    Repairing web server configuration for all domains. This aspect   
    can be used with individual domains ("plesk repair web           
    example.com"), and on the server level ("plesk repair web") ..... [OK]
    Repairing server-wide configuration parameters for web servers .. [OK]
    Updating the file of sharing passwords and permissions of users   
    according to actual information ................................. [OK]

Checking the usage of PHP handlers .................................. [OK]

Error messages: 0; Warnings: 0; Errors resolved: 0

I found this error in: /var/log/plesk/panel.log

[2019-12-16 09:36:30.926] ERR [panel.ui] Template processing failed: file = /opt/psa/admin/conf/templates/default/domainVhost.php, error = Template_Exception: No data.
file: /opt/psa/admin/plib/Template/Processor.php
line: 28
code: 0
Previous error: Template_Variable_Exception: No data.
file: /opt/psa/admin/plib/Template/Variable/AbstractCachedData.php
line: 67
code: 0
[2019-12-16 09:37:36.410] ERR [panel] DB query failed: SQLSTATE[HY000] [2002] No such file or directory:
0: /opt/psa/admin/plib/Db/Adapter/Pdo/Mysql.php:60
    Db_Adapter_Pdo_Mysql->query(string 'SET sql_mode = ''')
1: /opt/psa/admin/plib/CommonPanel/Application/Abstract.php:95
    CommonPanel_Application_Abstract::initDbAdapter()
2: /opt/psa/admin/plib/Session/Helper.php:176
    Plesk\Session\Helper::initStorage()
3: /opt/psa/admin/plib/auth.php:285
    AutoPrepend->initUserSession()
4: /opt/psa/admin/plib/auth.php:202
    AutoPrepend->run()
5: /opt/psa/admin/plib/auth.php:591
[2019-12-16 09:37:36.410] ERR [panel] DB query failed: SQLSTATE[HY000] [2002] No such file or directory:
0: /opt/psa/admin/plib/Db/Adapter/Pdo/Mysql.php:60
    Db_Adapter_Pdo_Mysql->query(string 'SET sql_mode = ''')
1: /opt/psa/admin/plib/CommonPanel/Application/Abstract.php:95
    CommonPanel_Application_Abstract::initDbAdapter()
2: /opt/psa/admin/plib/Session/Helper.php:176
    Plesk\Session\Helper::initStorage()
3: /opt/psa/admin/plib/auth.php:285
    AutoPrepend->initUserSession()
4: /opt/psa/admin/plib/auth.php:202
    AutoPrepend->run()
5: /opt/psa/admin/plib/auth.php:591
[2019-12-16 09:37:54.427] ERR [panel.ui] Template processing failed: file = /opt/psa/admin/conf/templates/default/domainVhost.php, error = Template_Exception: No data.
file: /opt/psa/admin/plib/Template/Processor.php
line: 28
code: 0
Previous error: Template_Variable_Exception: No data.
file: /opt/psa/admin/plib/Template/Variable/AbstractCachedData.php
line: 67
code: 0
[2019-12-16 09:40:07.482] ERR [panel.ui] Template processing failed: file = /opt/psa/admin/conf/templates/default/domainVhost.php, error = Template_Exception: No data.
file: /opt/psa/admin/plib/Template/Processor.php
line: 28
code: 0
Previous error: Template_Variable_Exception: No data.
file: /opt/psa/admin/plib/Template/Variable/AbstractCachedData.php
line: 67
code: 0

maybe corrupt DB???
I'm investigating....

Thanks

 

[IgorG]

maybe corrupt DB???

What about

# plesk repair db

?

 

[MWD]

root@v130:~# plesk repair db -y

Checking the Plesk database using the native database server tools .. [OK]

Checking the structure of the Plesk database ........................ [OK]

Checking the consistency of the Plesk database

  Inconsistency in the table 'apsResources' for the column registryId:
  There is no object in the 'apsc' database in the table             
  'aps_registry_object' with UID =                                   
  1f2fc74f-cef5-4531-8e06-e71cd42146ad .............................. [ERROR]
    Creating a database dump ........................................ [OK]
    A dump of the database was created before an attempt to repair the database: /var/lib/psa/dumps/mysql.preresolve.20191216-101001.dump.gz
    Removing rows ................................................... [FIXED]

  Inconsistency in the table 'apsResources' for the column registryId:
  There is no object in the 'apsc' database in the table             
  'aps_registry_object' with UID =                                   
  bbb7cb09-554d-4584-af72-6b18e4d7f2dc .............................. [ERROR]
    Removing rows ................................................... [FIXED]

Error messages: 2; Warnings: 0; Errors resolved: 2

but the error is still present...