Call to a member function findDependentRowset() on null (Database.php:X)

[JavierI]

Inconsistent database for a wordpress template. Now I cant delete subscription, I received this messages (show attach images)
I can not reconstruct the configuration files.

When I try delete wordpress installation I received:

ERROR: Call to a member function findDependentRowset() on null (Database.php:62)

This does not work:

plesk bin subscription -r maresvirtuales.com
PHP Fatal error:  Call to a member function findDependentRowset() on null in /opt/psa/admin/plib/Apspp/Hosting/Resource/Database.php on line 62
Error occured while sending feedback. HTTP code returned: 502
exit status 255

And this...

/usr/local/psa/admin/bin/httpdmng --reconfigure-domain maresvirtuales.com

And this...

/usr/local/psa/bin/repair --db -verbose
...
...
Checking the structure of the Plesk database ........................ [OK]

Checking the consistency of the Plesk database

  Inconsistency in the table 'apsResourcesParameters' for the column 
  apsResourceId: No rows in the table 'apsResources' with id = 23 ... [WARNING]

  Broken references in table 'apsResourcesParameters':
  *************************** 1. row ***************************
  id: 115
  apsResourceId: 23
  name: prefix
  value:

  Remove unnecessary rows from the table 'apsResourcesParameters'? [Y/n] y
  Creating a database dump ........................................ [OK]
  A dump of the database was created before an attempt to repair the database: /var/lib/psa/dumps/mysql.preresolve.20151014-145447.dump.gz
  Removing unnecessary rows ....................................... [FIXED]

Error messages: 0; Warnings: 1; Errors resolved: 1

Any idea?

NOTE:
Subscription ID = 30 (maresvirtuales.com)
Wordpress corrupt ID: https://myplesk:8443/smb/wordpress/detail/id/18



Excuse my english

Thanks!!
Best Regards

 

[vlikhtanskiy]

Hi @JavierI!

You database is still inconsistent: there is no information about APS application database in table apsResources.

You'd better contact Odin Support to correctly fix your database.

 

[JavierI]

Thanks vlikhtanskiy, how I can do it?
I generate a technical report and contact support too, but I dont know what I have to input here (see attach image)
My license key does not work.

 

[vlikhtanskiy]

Do you need the subscription maresvirtuales.com (because you were trying to remove it)? I can help you to remove it.

 

[JavierI]

yes, Im trying to remove all subscription (wordpress app too) and later reinstall all again, but I can't do it.
Can you help me?

 

[vlikhtanskiy]

1. Run the following command to remove blocking you rows: plesk db "DELETE FROM apsResources WHERE pleskId IN (SELECT id FROM domains WHERE name = 'maresvirtuales.com')"
2. Run the following command to fix other inconsistencies: plesk repair db -y
3. Try to remove subscription again: plesk bin subscription -r maresvirtuales.com

 

[JavierI]

Hello vlikhtanskiy, query on white.
domains.id field = 30 for maresvirtuales.com
but there is no pleskId = 30 into apsResources.pkeskId field
It seems to have lost the relationship between domain and wordpress app, therefore I think that I cant delete subscription.

Thanks

 

[JavierI]

SOLVED!!! I dont know why, but I run plesk repair db now (backup BBDD before):

Checking the structure of the Plesk database ........................ [OK]

Checking the consistency of the Plesk database

  Inconsistency in the table 'apsResourcesParameters' for the column 
  apsResourceId: No rows in the table 'apsResources' with id = 21 (3 
  broken references) ................................................ [WARNING]
 
  Broken references in table 'apsResourcesParameters':
  *************************** 1. row ***************************
             id: 108
  apsResourceId: 21
           name: urlPrefix
          value:
  *************************** 2. row ***************************
             id: 109
  apsResourceId: 21
           name: isSiteRoot
          value: false
  *************************** 3. row ***************************
             id: 110
  apsResourceId: 21
           name: phpMinVersion
          value: 5.2.4

  Remove unnecessary rows from the table 'apsResourcesParameters'? [Y/n] Y
    Creating a database dump ........................................ [OK]
    A dump of the database was created before an attempt to repair the database: /var/lib/psa/dumps/mysql.preresolve.20151016-100313.dump.gz
    Removing unnecessary rows ....................................... [FIXED]

  Inconsistency in the table 'apsResourcesParameters' for the column 
  apsResourceId: No rows in the table 'apsResources' with id = 22 (4 
  broken references) ................................................ [WARNING]
 
  Broken references in table 'apsResourcesParameters':
  *************************** 1. row ***************************
             id: 111
  apsResourceId: 22
           name: /
          value: /var/www/vhosts/maresvirtuales.com/httpdocs/
  *************************** 2. row ***************************
             id: 112
  apsResourceId: 22
           name: /wp-content
          value: /var/www/vhosts/maresvirtuales.com/httpdocs/wp-content
  *************************** 3. row ***************************
             id: 113
  apsResourceId: 22
           name: /blogs/media
          value: /var/www/vhosts/maresvirtuales.com/httpdocs/blogs/media
  *************************** 4. row ***************************
             id: 114
  apsResourceId: 22
           name: /tmp
          value: /var/www/vhosts/maresvirtuales.com/httpdocs/tmp

  Remove unnecessary rows from the table 'apsResourcesParameters'? [Y/n] y
    Removing unnecessary rows ....................................... [FIXED]

Error messages: 0; Warnings: 2; Errors resolved: 2

Later run:

plesk bin subscription -r maresvirtuales.com
[2015-10-16 10:04:30] ERR [panel] resource of type aps.environment with id eddf738c-f0a1-4613-9878-3c74387b4b06 not found by brokers
[2015-10-16 10:04:30] ERR [panel] Dangling resource reference detected for application resource with ID 54f7f3bb-df81-4e23-98d4-71802891435f
SUCCESS: Removal of 'maresvirtuales.com' completed.

Thank you very much vlikhtanskiy!!!

 

[vlikhtanskiy]

Glad to help you!