Article ID: 127340, created on Nov 5, 2015, last review on Nov 5, 2015

  • Applies to:
  • Plesk Automation 11.5

Symptoms

Cannot remove the database service node:

Service "db" on Service Node 192.0.2.2 used by 1 domains.

Cause

The 'psa' database contains the records about the database(s) registered on the service node.

The service node cannot be removed until there are no databases remain registered there.

Resolution

  1. Back up 'psa' database.

  2. Connect to psa database:

    # plesk db
    
  3. Find the database that is hosting on the service node:

    mysql>  select 
    
    
        db.id,
        db.name "Database",
        d.name  Domain,
        s.host
    
        from
    
        data_bases db
        left join domains d 
        on db.dom_id = d.id
        inner join DatabaseServers s  
        on db.db_server_id = s.id 
    
        where s.host = '192.0.2.2';
    
    +------+-------------+---------------+------------+ | id | Database | Domain | host | +------+-------------+---------------+------------+ | 101 | example_com | example.com | 192.0.2.2 | +------+-------------+---------------+------------+ 1 row in set (0.00 sec)
  4. Remove the database from the control panel of domain.

NOTE: In case the result of the query did not show the domain name:

    +------+-------------+---------------+------------+
    | id   | Database    |     Domain    |     host   |
    +------+-------------+---------------+------------+
    | 101  | example_com |      NULL     | 192.0.2.2  |
    +------+-------------+---------------+------------+
    1 row in set (0.00 sec)

, remove the associated record from psa.data_bases table:

mysql> delete from data_bases where id = 101;
Query OK, 1 row affected (0.11 sec)

,

Search Words

delete service node

Service "db" is used

cannot remove db service node

Service "db" on Service Node

33a70544d00d562bbc5b17762c4ed2b3 caea8340e2d186a540518d08602aa065 e0aff7830fa22f92062ee4db78133079

Email subscription for changes to this article
Save as PDF