Article ID: 119664, created on Jan 15, 2014, last review on Aug 26, 2014

  • Applies to:
  • Plesk Automation 11.1
  • Plesk Automation 11.5

Symptoms

You have got error while PPA upgrade:

[LOGTEE]: 2014-01-09 20:44:16.459  WARN Action executing atomic action 13030_POA-75155_services_PREPARE owner BIND has been ABORTED
[LOGTEE]: 2014-01-09 20:44:16.459 ERROR PrecheckFailed ("Precheck error: \n\t\tColumn 'dns_bind_services.service_id' contains values that reference entities missing in column 'services.service_id'.\n\t\tData in table 'dns_bind_services' require modification before foreign key constraint can be enabled.\n\t\tItems that reference not-existing parent entities:\n\t\tservice_id: 13\n\t\tIf this issue is ignored, the POA updater will attempt to fix it automatically, but still the positive result is not guaranteed.\nYou should: remove records from table dns_bind_services, that are referencing missing values in table services.\n\n",) while executing atomic action 13030_POA-75155_services_PREPARE owner BIND
[LOGTEE]: 2014-01-09 20:44:16.460 ERROR poaupdater.uAction.PrecheckFailed
[LOGTEE]: Precheck error:
[LOGTEE]:               Column 'dns_bind_services.service_id' contains values that reference entities missing in column 'services.service_id'.
[LOGTEE]:               Data in table 'dns_bind_services' require modification before foreign key constraint can be enabled.
[LOGTEE]:               Items that reference not-existing parent entities:
[LOGTEE]:               service_id: 13
[LOGTEE]:               If this issue is ignored, the POA updater will attempt to fix it automatically, but still the positive result is not guaranteed.
[LOGTEE]: You should: remove records from table dns_bind_services, that are referencing missing values in table services.

Cause

There is redundant record in the PPA database which points to non-existing service.

Resolution

NOTE: Please be extremely careful while modifying PPA database. It is the best way to submit ticket to Parallels Technical Support for perform these actions by experienced engineer.

  1. Login to PPA management node. Create backup of PPA Postgres database using #118890 article.

  2. Login to Postgres database:

    [root@ppa ~] psql -U plesk -h `hostname` plesk
    
  3. Make sure that DNS service from the error does not exist:

    plesk=> select dns_service_id,service_id  from dns_bind_services;
     dns_service_id | service_id
    ----------------+------------
                  2 |         13
                  1 |          1
                  3 |         14
    
    plesk=> select * from services where service_id = 13;
     service_id | owner_id | service_state | required_state | state_to_show | component_id | sc_id | host_id | name | cpu_usage | memory_usage | system | last_state_change
    ------------+----------+---------------+----------------+---------------+--------------+-------+---------+------+-----------+--------------+--------+-------------------
    (0 rows)
    
  4. Remove redundant record from the database:

    plesk=> begin;
    BEGIN
    plesk=> delete from dns_bind_services where dns_service_id = 2 and service_id = 13;
    DELETE 1
    plesk=> commit;
    COMMIT
    
  5. Re-initiate PPA upgrade:

    ./ppa_update --upgrade
    

Search Words

Data in table 'dns_bind_services' require modification

WARN Action executing atomic action 13030_POA-75155_services_PREPARE owner BIND has been ABORTED

c1ecc6010feff26cb42d1d14a7881dd6 e0aff7830fa22f92062ee4db78133079 caea8340e2d186a540518d08602aa065 33a70544d00d562bbc5b17762c4ed2b3

Email subscription for changes to this article
Save as PDF