Table broker with name 'ServiceNodes' not found // Failures after system crash

[TorstenS]

Hi there,

today our server was dropped down due a power failure in the datacenter and after that the file system found some orphaned inodes - damn.

After I've recognized that the files belongs to the databases I've dumped them and imported them successfully ... mysql is now running fine.

After that I've found some other missing files or errors on some webspaces and decided to use our last backup to recover something. Plesk Panel not running .. showing this message "
Internal error:
Table broker with name 'ServiceNodes' not found. Used prefixes: Db_Table_Broker_, Plesk\Db\Table\Broker\
Message Table broker with name 'ServiceNodes' not found. Used prefixes: Db_Table_Broker_, Plesk\Db\Table\Broker\
File Broker.php
Line 98
Type PleskFatalException"

Seems that the Database was corrupted ... so I've imported the mysql.daily.dump.0.gz with no luck.

Damn ... tested to recover the backup from the console with pleskbackup but same message appears "
__ci_last_regenerate|i:1526845388;logged_in|b:1;[2018-05-25 02:15:03] ERR [panel] Table broker with name 'ServiceNodes' not found. Used prefixes: Db_Table_Broker_, Plesk\Db\Table\Broker\:
0: /opt/psa/admin/plib/Db/Table/Broker.php:98
Db_Table_Broker::_getClassName(string 'ServiceNodes')
1: /opt/psa/admin/plib/Db/Table/Broker.php:42
Db_Table_Broker::get(string 'ServiceNodes')
2: /opt/psa/admin/plib/api-common/AbstractCu.php:1679
AbstractCu::initCLI()
3: /opt/psa/admin/plib/backup/pleskrestore.php:6
ERROR: PleskFatalException: Table broker with name 'ServiceNodes' not found. Used prefixes: Db_Table_Broker_, Plesk\Db\Table\Broker\ (Broker.php:98)
exit status 1"

So, are there any suggestions?

Best regards and good night from germany,
Torsten

 

[IgorG]

Try to fix database structure with

# plesk repair db

 

[TorstenS]

I've done this already about 4 times cause of foreign keys constraint failed in some db's, now I've got no more errormessages from this.

__ci_last_regenerate|i:1526845388;logged_in|b:1;
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 ...................... [OK]
Error messages: 0; Warnings: 0; Errors resolved: 0

But helped nothing .. error is the same. (

# plesk bin pleskrestore --info /tmp/backup/backup_1805222100.tar

__ci_last_regenerate|i:1526845388;logged_in|b:1;[2018-05-25 08:02:07] ERR [panel] Table broker with name 'ServiceNodes' not found. Used prefixes: Db_Table_Broker_, Plesk\Db\Table\Broker\:
0: /opt/psa/admin/plib/Db/Table/Broker.php:98
Db_Table_Broker::_getClassName(string 'ServiceNodes')
1: /opt/psa/admin/plib/Db/Table/Broker.php:42
Db_Table_Broker::get(string 'ServiceNodes')
2: /opt/psa/admin/plib/api-common/AbstractCu.php:1679
AbstractCu::initCLI()
3: /opt/psa/admin/plib/backup/pleskrestore.php:6
ERROR: PleskFatalException: Table broker with name 'ServiceNodes' not found. Used prefixes: Db_Table_Broker_, Plesk\Db\Table\Broker\ (Broker.php:98)
exit status 1

 

[IgorG]

I think it would be better to ask Plesk Support Team assistance.

 

[TorstenS]

Decided to make a new install and recover the backup *hopefully*. Stay tuned ...

 

[Bitpalast]

@TorstenS Is this a consequence of the Hetzner outage on Thursday?

 

[TorstenS]

@Peter Debik Yes it is! Absolute horrible ... managed to reinstall the server and about 70% of the domains are back online. For the rest I'm searching for a solution, cause they need an old PHP version

 

[Bitpalast]

If you reinstalled the server and restored the websites from a backup, you can always add old PHP versions from the Plesk modules in case that the OS PHP version is now a newer one. Go to Tools & Settings > Updates & Upgrades, then see the web hosting section and select all the PHP versions that you need. I hope this will help you.

 

[TorstenS]

I know this, but not recognized, that Debian Stretch only supports php7+. So I managed and installed a custom php5.6 handler ... for php5.3 I'll take an vserver, cause only 3 domains require this and I think it's time to upgrade for the customers ;o)