Database server id is undefined

Created:

2016-11-16 13:06:17 UTC

Modified:

2017-04-24 11:02:04 UTC

0

Was this article helpful?


Have more questions?

Submit a request

Database server id is undefined

Applicable to:

  • Plesk 11.5 for Windows
  • Plesk 11.5 for Linux
  • Plesk 12.0 for Windows
  • Plesk 12.0 for Linux

Symptoms

Database server id is undefined

Cause

Plesk database inconsistency

Resolution

Ensure that required domain database is refer to the appropriate database server in psa.DatabaseServers

mysql> select * from psa.data_bases db  left join psa.DatabaseServers ds on ds.id=db.db_server_id where ds.id is null;
+----+--------+-------+--------+--------------+-----------------+------+------+------+------+-------------+----------------+------------+----------------+---------------+
| id | name | type | dom_id | db_server_id | default_user_id | id | host | port | type | admin_login | admin_password | last_error | server_version | parameters_id |
+----+--------+-------+--------+--------------+-----------------+------+------+------+------+-------------+----------------+------------+----------------+---------------+
| 3 | testdb | mysql | 999 | 99 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL |
+----+--------+-------+--------+--------------+-----------------+------+------+------+------+-------------+----------------+------------+----------------+---------------+
1 row in set (0.00 sec)

As you can see there is no entries in psa.DatabaseServers defined for the domain with id=999 .

You need either register a new database server in Plesk GUI or update db_server_id with proper DatabaseServers.id value.

Have more questions? Submit a request
Please sign in to leave a comment.