Unable to create reseller or change subscriber in Plesk: Unable to find row with id 1 in IP_Addresses table

Symptoms

Unable to create reseller at Resellers > Add Reseller or change subscriber at Subscriptions > Change subscriber:

Unable to find row with id 1 in IP_Addresses table

Cause

Database inconsistency:

• IP address with the mentioned ID is missing:

  # plesk db "select * from IP_Addresses where id=1"
  #

  # plesk db "select * from IpAddressesCollections where ipAddressId=1;"
  #

• The record exists in the ip_pool table:

  # plesk db "select * from ip_pool where ip_address_id=1"
  +----+---------------+--------+
  | id | ip_address_id | type     
  +----+---------------+--------+
  | 1  | 1             | shared 
  +----+---------------+--------+

Resolution

1. Login server via SSH

2. Create a backup of Plesk database:

   # plesk db dump psa > "psadump_$(date +"%Y_%m_%d_%I_%M_%p").sql"

3. Remove orphaned record:

   # plesk db "delete from ip_pool where ip_address_id=1;"