failed to delete test domain

Support
1

Description

apiscp-int-tnbxgrrzwtdsbutc.test appeared after bootstrap build of php8.3 Failed to delete test domain manually using Panel interface.
Action failed

Admin_Module::delete_site(): Opcenter\Provisioning\Pam::disable(): pam service `ssh' not enabled
Admin_Module::delete_site(): Opcenter\Provisioning\Pam::disable(): pam service `ftp' not enabled
4 more messages
    Admin_Module::delete_site(): Opcenter\Provisioning\Pam::disable(): pam service `cp' not enabled
    Admin_Module::delete_site(): Opcenter\Provisioning\Pam::disable(): pam service `dav' not enabled
    Util_Process::formatDataCallProc(): DeleteDomain: WARNING: Opcenter\Provisioning\Pam::disable(): pam service `ssh' not enabled
    WARNING: Opcenter\Provisioning\Pam::disable(): pam service `ftp' not enabled
    WARNING: Opcenter\Provisioning\Pam::disable(): pam service `cp' not enabled
    WARNING: Opcenter\Provisioning\Pam::disable(): pam service `dav' not enabled
    ERROR  : unknown(): failed to remove site `site12': SQLSTATE[53200]: Out of memory: 7 ERROR:  out of shared memory
    HINT:  You might need to increase max_locks_per_transaction.
    CONTEXT:  SQL statement "DELETE FROM ONLY "_timescaledb_internal"."_hyper_3_994_chunk" WHERE $1 OPERATOR(pg_catalog.=) "uid""
             0. PDOStatement->execute([site_id:12, domain:"apiscp-int-tnbxgrrzwtdsbutc.test"])
                [/usr/local/apnscp/lib/Opcenter/Database/PostgreSQL/Opcenter.php:175]
             1. PDOStatement->execute([site_id:12, domain:"apiscp-int-tnbxgrrzwtdsbutc.test"])
                [/usr/local/apnscp/lib/Opcenter/Database/PostgreSQL/Opcenter.php:175]
             2. Opcenter\Database\PostgreSQL\Opcenter->deleteSite(12, "apiscp-int-tnbxgrrzwtdsbutc.test")
                [/usr/local/apnscp/lib/Opcenter/Service/Validators/Siteinfo/Enabled.php:155]
             3. Opcenter\Service\Validators\Siteinfo\Enabled->depopulate(Opcenter\SiteConfiguration)
                [/usr/local/apnscp/lib/Opcenter/Account/Delete.php:287]
             4. Opcenter\Account\Delete->exec()
                [/usr/local/apnscp/bin/DeleteDomain:97]
    Admin_Module::delete_site(): unknown(): failed to remove site `site12': SQLSTATE[53200]: Out of memory: 7 ERROR:  out of shared memory
    HINT:  You might need to increase max_locks_per_transaction.
    CONTEXT:  SQL statement "DELETE FROM ONLY "_timescaledb_internal"."_hyper_3_994_chunk" WHERE $1 OPERATOR(pg_catalog.=) "uid""

Have tried /usr/local/apnscp/bin/scripts/mapCheck.php rebuild
and then DeleteDomain --force apiscp-int-tnbxgrrzwtdsbutc.test I also tried to delete a real domain/account to start as a fresh site however I cant log into that real account now

Server Information

  • OS: CentOS 8
  • apisCP Version: [Current version]
2

Solution:

  1. Fixed PostgreSQL memory: ALTER SYSTEM SET max_locks_per_transaction = 256; + restart

Root Cause: PostgreSQL max_locks_per_transaction was too low (128) for apisCP operations.

Solution:

  1. Force deleted domains: DeleteDomain --force example.com (bypassed EditDomain lock)

  2. Cleaned rogue domains: DeleteDomain --force apiscp-int-*

  3. Restarted apisCP: systemctl restart apnscp