<?php

namespace App\Model\Table;

class ContainersTable extends Table {

    public function initialize(array $config): void {
        parent::initialize($config);

        $this->setTable('containers');
        $this->setDisplayField('name');
        $this->setPrimaryKey('id');

        $this->addBehavior('Tree', [
            'cascadeCallbacks' => true // I tried true and false - same results
        ]);

    }

    public function beforeSave(EventInterface $event, EntityInterface $entity, \ArrayObject $options) {
        Log::debug('beforeSave - Acquire table lock');
        $this->acquireLock();
    }

    public function afterSave(EventInterface $event, EntityInterface $entity, \ArrayObject $options) {
        Log::debug(' afterSave - Release table lock');
        $this->releaseLock();
    }

    public function beforeDelete(EventInterface $event, EntityInterface $entity, \ArrayObject $options) {
        Log::debug('beforeDelete - Acquire table lock');
        $this->acquireLock();
    }

    public function afterDelete(EventInterface $event, EntityInterface $entity, \ArrayObject $options) {
        Log::debug('afterDelete - Release table lock');
        $this->releaseLock();
    }
    

    /**
     * Will create a Semaphor with a limit of 1 to avoid multiple operations running concurrently on the containers table
     * This method blocks (if necessary) until the semaphore can be acquired
     *
     * https://github.com/cakephp/cakephp/issues/14983#issuecomment-1613491168
     * @return bool
     */
    public function acquireLock() {
        if ($this->semaphoreKey === null) {
            $this->semaphoreKey = ftok(__FILE__, 'c');
            $this->semaphore = sem_get($this->semaphoreKey, 1, 0666, true);
        }

        return sem_acquire($this->semaphore);
    }

    /**
     * @return bool
     */
    public function releaseLock() {
        if (!is_null($this->semaphore)) {
            return sem_release($this->semaphore);
        }
    }
}

<?php

namespace App\Controller;

class ServicetemplategroupsController extends AppController {

    public function delete($id = null) {

        /** @var ContainersTable $ContainersTable */
        $ContainersTable = TableRegistry::getTableLocator()->get('Containers');

        $ContainersTable->acquireLock();

        /** @var $ContainersTable ContainersTable */
        $ContainersTable = TableRegistry::getTableLocator()->get('Containers');
        $container = $ContainersTable->get($id, [
            'contain' => [
                'Servicetemplategroups'
            ]
        ]);

        $ContainersTable->delete($container);

        $ContainersTable->releaseLock();
    }
}