Skip to content

BUG: cr:status -> Lock Timeout (and further lock timeouts) #5579

New issue
New issue
Open
Open
BUG: cr:status -> Lock Timeout (and further lock timeouts)#5579
Labels
9.0Bug
@kdambekalns

Description

@kdambekalns
kdambekalns
opened on Jun 21, 2025

Is there an existing issue for this?

  • I have searched the existing issues

Current Behavior

Subscription Engine locks ALSO if you only want to read, e.g. when calling ./flow cr:status.

  • we should create a new method in SubscriptionStore::findByCriteriaForReading (TODO naming scheme?)
  • TODO: for the WRITE case, we need ANOTHER WAY to deal with the lock timeout!!! -> Retry??? (or cancel early and report to UI)

(discovered togetehr with @skurfuerst ) // cc @bwaidelich @mhsdesign


Exception #1651153651 in line 101 of /application/Packages/Libraries/neos/eventstore-doctrineadapter/src/DoctrineEventStore.php: Expected version: 0, actual version: 1

70 Neos\EventStore\Model\EventStream\ExpectedVersion::verifyVersion(MaybeVersion|1|)
69 Neos\EventStore\DoctrineAdapter\DoctrineEventStore::commit(StreamName|{"value":"ContentStream:8d50e69d-9e57-4ce2-8cd8-5ff8893b737e"}|, Neos\EventStore\Model\Events, ExpectedVersion|0|)
68 Neos\ContentRepository\Core\ContentRepository::handle(Neos\ContentRepository\Core\Feature\NodeModification\Command\SetNodeProperties)
67 Neos\Neos\Ui\Domain\Model\Changes\Property_Original::handlePropertyChange(Neos\ContentRepository\Core\Projection\ContentGraph\Node, NodeType|{"name":"Neos.NeosIo:ImageTeaser"}|, "image")
66 Neos\Neos\Ui\Domain\Model\Changes\Property_Original::apply()
65 Neos\Neos\Ui\Domain\Model\ChangeCollection::apply()
64 Neos\Neos\Ui\Controller\BackendServiceController_Original::changeAction(array|1|)
63 Neos\Neos\Ui\Controller\BackendServiceController::changeAction(array|1|)
62 Neos\Neos\Ui\Controller\BackendServiceController::Flow_Aop_Proxy_invokeJoinPoint(Neos\Flow\Aop\JoinPoint)
61 Neos\Flow\Aop\Advice\AdviceChain::proceed(Neos\Flow\Aop\JoinPoint)
60 Neos\Flow\Security\Aspect\PolicyEnforcementAspect_Original::enforcePolicy(Neos\Flow\Aop\JoinPoint)
59 Neos\Flow\Aop\Advice\AroundAdvice::invoke(Neos\Flow\Aop\JoinPoint)
58 Neos\Flow\Aop\Advice\AdviceChain::proceed(Neos\Flow\Aop\JoinPoint)
57 Neos\Neos\Ui\Controller\BackendServiceController::changeAction(array|1|)
56 Neos\Flow\Mvc\Controller\ActionController_Original::callActionMethod(Neos\Flow\Mvc\ActionRequest, Neos\Flow\Mvc\Controller\Arguments, Neos\Flow\Mvc\ActionResponse)
55 Neos\Neos\Ui\Controller\BackendServiceController::callActionMethod(Neos\Flow\Mvc\ActionRequest, Neos\Flow\Mvc\Controller\Arguments, Neos\Flow\Mvc\ActionResponse)
54 Neos\Neos\Ui\Controller\BackendServiceController::Flow_Aop_Proxy_invokeJoinPoint(Neos\Flow\Aop\JoinPoint)
53 Neos\Flow\Aop\Advice\AdviceChain::proceed(Neos\Flow\Aop\JoinPoint)
52 Neos\Flow\Security\Aspect\PolicyEnforcementAspect_Original::enforcePolicy(Neos\Flow\Aop\JoinPoint)
51 Neos\Flow\Aop\Advice\AroundAdvice::invoke(Neos\Flow\Aop\JoinPoint)
50 Neos\Flow\Aop\Advice\AdviceChain::proceed(Neos\Flow\Aop\JoinPoint)
49 Neos\Neos\Ui\Controller\BackendServiceController::callActionMethod(Neos\Flow\Mvc\ActionRequest, Neos\Flow\Mvc\Controller\Arguments, Neos\Flow\Mvc\ActionResponse)
48 Neos\Flow\Mvc\Controller\ActionController_Original::processRequest(Neos\Flow\Mvc\ActionRequest)
47 Neos\Neos\Ui\Controller\BackendServiceController::processRequest(Neos\Flow\Mvc\ActionRequest)
46 Neos\Neos\Ui\Controller\BackendServiceController::Flow_Aop_Proxy_invokeJoinPoint(Neos\Flow\Aop\JoinPoint)
45 Neos\Flow\Aop\Advice\AdviceChain::proceed(Neos\Flow\Aop\JoinPoint)
44 Neos\Flow\Security\Aspect\PolicyEnforcementAspect_Original::enforcePolicy(Neos\Flow\Aop\JoinPoint)
43 Neos\Flow\Aop\Advice\AroundAdvice::invoke(Neos\Flow\Aop\JoinPoint)
42 Neos\Flow\Aop\Advice\AdviceChain::proceed(Neos\Flow\Aop\JoinPoint)
41 Neos\Neos\Ui\Controller\BackendServiceController::processRequest(Neos\Flow\Mvc\ActionRequest)
40 Neos\Flow\Mvc\Dispatcher_Original::initiateDispatchLoop(Neos\Flow\Mvc\ActionRequest)
39 Neos\Flow\Mvc\Dispatcher_Original::dispatch(Neos\Flow\Mvc\ActionRequest)
38 Neos\Flow\Mvc\DispatchMiddleware_Original::process(GuzzleHttp\Psr7\ServerRequest, Neos\Flow\Http\Middleware\MiddlewaresChain)
37 Neos\Flow\Http\Middleware\MiddlewaresChain::handle(GuzzleHttp\Psr7\ServerRequest)
36 Neos\Flow\Http\Middleware\SecurityEntryPointMiddleware_Original::process(GuzzleHttp\Psr7\ServerRequest, Neos\Flow\Http\Middleware\MiddlewaresChain)
35 Neos\Flow\Http\Middleware\MiddlewaresChain::handle(GuzzleHttp\Psr7\ServerRequest)
34 Neos\Flow\Http\Middleware\RequestBodyParsingMiddleware_Original::process(GuzzleHttp\Psr7\ServerRequest, Neos\Flow\Http\Middleware\MiddlewaresChain)
33 Neos\Flow\Http\Middleware\MiddlewaresChain::handle(GuzzleHttp\Psr7\ServerRequest)
32 Neos\Flow\Mvc\FlashMessage\FlashMessageMiddleware_Original::process(GuzzleHttp\Psr7\ServerRequest, Neos\Flow\Http\Middleware\MiddlewaresChain)
31 Neos\Flow\Http\Middleware\MiddlewaresChain::handle(GuzzleHttp\Psr7\ServerRequest)
30 Neos\Flow\Http\Middleware\PoweredByMiddleware_Original::process(GuzzleHttp\Psr7\ServerRequest, Neos\Flow\Http\Middleware\MiddlewaresChain)
29 Neos\Flow\Http\Middleware\MiddlewaresChain::handle(GuzzleHttp\Psr7\ServerRequest)
28 Neos\NeosIo\Http\CspMiddleware_Original::process(GuzzleHttp\Psr7\ServerRequest, Neos\Flow\Http\Middleware\MiddlewaresChain)
27 Neos\Flow\Http\Middleware\MiddlewaresChain::handle(GuzzleHttp\Psr7\ServerRequest)
26 Neos\RedirectHandler\RedirectMiddleware_Original::process(GuzzleHttp\Psr7\ServerRequest, Neos\Flow\Http\Middleware\MiddlewaresChain)
25 Neos\Flow\Http\Middleware\MiddlewaresChain::handle(GuzzleHttp\Psr7\ServerRequest)
24 Neos\Flow\Mvc\Routing\RoutingMiddleware_Original::process(GuzzleHttp\Psr7\ServerRequest, Neos\Flow\Http\Middleware\MiddlewaresChain)
23 Neos\Flow\Http\Middleware\MiddlewaresChain::handle(GuzzleHttp\Psr7\ServerRequest)
22 Flowpack\Media\Ui\GraphQL\Middleware\GraphQLMiddleware_Original::process(GuzzleHttp\Psr7\ServerRequest, Neos\Flow\Http\Middleware\MiddlewaresChain)
21 Neos\Flow\Http\Middleware\MiddlewaresChain::handle(GuzzleHttp\Psr7\ServerRequest)
20 Flowpack\Media\Ui\GraphQL\Middleware\GraphQLUploadMiddleware::process(GuzzleHttp\Psr7\ServerRequest, Neos\Flow\Http\Middleware\MiddlewaresChain)
19 Neos\Flow\Http\Middleware\MiddlewaresChain::handle(GuzzleHttp\Psr7\ServerRequest)
18 Neos\Neos\FrontendRouting\SiteDetection\SiteDetectionMiddleware_Original::process(GuzzleHttp\Psr7\ServerRequest, Neos\Flow\Http\Middleware\MiddlewaresChain)
17 Neos\Flow\Http\Middleware\MiddlewaresChain::handle(GuzzleHttp\Psr7\ServerRequest)
16 Neos\FluidAdaptor\Core\Widget\AjaxWidgetMiddleware_Original::process(GuzzleHttp\Psr7\ServerRequest, Neos\Flow\Http\Middleware\MiddlewaresChain)
15 Neos\Flow\Http\Middleware\MiddlewaresChain::handle(GuzzleHttp\Psr7\ServerRequest)
14 Neos\Flow\Http\Middleware\SessionMiddleware_Original::process(GuzzleHttp\Psr7\ServerRequest, Neos\Flow\Http\Middleware\MiddlewaresChain)
13 Neos\Flow\Http\Middleware\MiddlewaresChain::handle(GuzzleHttp\Psr7\ServerRequest)
12 Neos\Flow\Http\Middleware\MethodOverrideMiddleware::process(GuzzleHttp\Psr7\ServerRequest, Neos\Flow\Http\Middleware\MiddlewaresChain)
11 Neos\Flow\Http\Middleware\MiddlewaresChain::handle(GuzzleHttp\Psr7\ServerRequest)
10 Flowpack\FullPageCache\Middleware\FusionAutoconfigurationMiddleware_Original::process(GuzzleHttp\Psr7\ServerRequest, Neos\Flow\Http\Middleware\MiddlewaresChain)
9 Neos\Flow\Http\Middleware\MiddlewaresChain::handle(GuzzleHttp\Psr7\ServerRequest)
8 Flowpack\FullPageCache\Middleware\RequestCacheMiddleware_Original::process(GuzzleHttp\Psr7\ServerRequest, Neos\Flow\Http\Middleware\MiddlewaresChain)
7 Neos\Flow\Http\Middleware\MiddlewaresChain::handle(GuzzleHttp\Psr7\ServerRequest)
6 Neos\Flow\Http\Middleware\TrustedProxiesMiddleware_Original::process(GuzzleHttp\Psr7\ServerRequest, Neos\Flow\Http\Middleware\MiddlewaresChain)
5 Neos\Flow\Http\Middleware\MiddlewaresChain::handle(GuzzleHttp\Psr7\ServerRequest)
4 Neos\Flow\Http\Middleware\StandardsComplianceMiddleware::process(GuzzleHttp\Psr7\ServerRequest, Neos\Flow\Http\Middleware\MiddlewaresChain)
3 Neos\Flow\Http\Middleware\MiddlewaresChain::handle(GuzzleHttp\Psr7\ServerRequest)
2 Neos\Flow\Http\RequestHandler::handleRequest()
1 Neos\Flow\Core\Bootstrap::run()


HTTP REQUEST:
target: /neos/ui-services/change
Cookie: Neos_Session=JF7w8HB8wqS37h36Te9o6QrxcOZqGX4d
Priority: u=0
Sec-Fetch-Site: same-origin
Sec-Fetch-Mode: cors
Sec-Fetch-Dest: empty
Origin: https://www.neoscon.io
Content-Type: application/json
X-Flow-Csrftoken: 22b5299ceb8552ee8c7094950f8a067d
Referer: https://www.neoscon.io/neos/content?node=%7B%22contentRepositoryId%22%3A%22default%22%2C%22workspaceName%22%3A%22tobias-gruber%22%2C%22dimensionSpacePoint%22%3A%7B%22language%22%3A%22en%22%7D%2C%22aggregateId%22%3A%228d568377-10b4-4bf4-841a-fa540c685923%22%7D
Accept-Encoding: gzip, deflate, br, zstd
Accept-Language: en-US,en;q=0.5
Accept: */*
User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.15; rv:139.0) Gecko/20100101 Firefox/139.0
Content-Length: 1497
X-Scheme: https
X-Original-Uri: /neos/ui-services/change
X-Forwarded-Scheme: https
X-Forwarded-Proto: https
X-Forwarded-Port: 443
X-Forwarded-Host: www.neoscon.io
X-Forwarded-For: 62.153.117.2
X-Real-Ip: 62.153.117.2
X-Request-Id: b434adffaca07924d852441c9b67bd7c
Host: www.neoscon.io

PHP PROCESS:
Inode: 31641219
PID: 244858
UID: 1000
GID: 1000
User: beach

Exception #1205 in line 1976 of /application/Packages/Libraries/doctrine/dbal/src/Connection.php: An exception occurred while executing a query: SQLSTATE[HY000]: General error: 1205 Lock wait timeout exceeded; try restarting transaction

17 Doctrine\DBAL\Driver\API\MySQL\ExceptionConverter::convert(Exception|PDOException: SQLSTATE[HY000]: General error: 1205 Lock wait timeout exceeded; try restarting transa…|, Doctrine\DBAL\Query)
16 Doctrine\DBAL\Connection::handleDriverException(Exception|PDOException: SQLSTATE[HY000]: General error: 1205 Lock wait timeout exceeded; try restarting transa…|, Doctrine\DBAL\Query)
15 Doctrine\DBAL\Connection::convertExceptionDuringQuery(Exception|PDOException: SQLSTATE[HY000]: General error: 1205 Lock wait timeout exceeded; try restarting transa…|, "SELECT * FROM cr_default_subscriptions ORDER BY id ASC FOR UPDATE", array|0|, array|0|)
14 Doctrine\DBAL\Connection::executeQuery("SELECT * FROM cr_default_subscriptions ORDER BY id ASC FOR UPDATE", array|0|, array|0|, null)
13 Doctrine\DBAL\Query\QueryBuilder::executeQuery()
12 Neos\ContentRepositoryRegistry\Factory\SubscriptionStore\DoctrineSubscriptionStore::findByCriteriaForUpdate(Neos\ContentRepository\Core\Subscription\Store\SubscriptionCriteria)
11 Neos\ContentRepository\Core\Subscription\Engine\SubscriptionEngine::subscriptionStatus()
10 Neos\ContentRepository\Core\Service\ContentRepositoryMaintainer::status()
9 Neos\ContentRepositoryRegistry\Command\CrCommandController_Original::statusCommand("default", false, false)
8 Neos\Flow\Cli\CommandController_Original::callCommandMethod()
7 Neos\Flow\Cli\CommandController_Original::processRequest(Neos\Flow\Cli\Request, Neos\Flow\Cli\Response)
6 Neos\Flow\Cli\Dispatcher_Original::dispatch(Neos\Flow\Cli\Request, Neos\Flow\Cli\Response)
5 Neos\Flow\Cli\CommandRequestHandler::Neos\Flow\Cli\{closure}()
4 Neos\Flow\Security\Context_Original::withoutAuthorizationChecks(Closure)
3 Neos\Flow\Cli\CommandRequestHandler::handleRequest()
2 Neos\Flow\Core\Bootstrap::run()
1 require("/application/Packages/Framework/Neos.Flow/Scripts/flow.php")

Previous exception: Exception #1205 in line 76 of /application/Packages/Libraries/doctrine/dbal/src/Driver/PDO/Connection.php: SQLSTATE[HY000]: General error: 1205 Lock wait timeout exceeded; try restarting transaction

16 Doctrine\DBAL\Driver\PDO\Exception::new(PDOException|PDOException: SQLSTATE[HY000]: General error: 1205 Lock wait timeout exceeded; try restarting transa…|)
15 Doctrine\DBAL\Driver\PDO\Connection::query("SELECT * FROM cr_default_subscriptions ORDER BY id ASC FOR UPDATE")
14 Doctrine\DBAL\Connection::executeQuery("SELECT * FROM cr_default_subscriptions ORDER BY id ASC FOR UPDATE", array|0|, array|0|, null)
13 Doctrine\DBAL\Query\QueryBuilder::executeQuery()
12 Neos\ContentRepositoryRegistry\Factory\SubscriptionStore\DoctrineSubscriptionStore::findByCriteriaForUpdate(Neos\ContentRepository\Core\Subscription\Store\SubscriptionCriteria)
11 Neos\ContentRepository\Core\Subscription\Engine\SubscriptionEngine::subscriptionStatus()
10 Neos\ContentRepository\Core\Service\ContentRepositoryMaintainer::status()
9 Neos\ContentRepositoryRegistry\Command\CrCommandController_Original::statusCommand("default", false, false)
8 Neos\Flow\Cli\CommandController_Original::callCommandMethod()
7 Neos\Flow\Cli\CommandController_Original::processRequest(Neos\Flow\Cli\Request, Neos\Flow\Cli\Response)
6 Neos\Flow\Cli\Dispatcher_Original::dispatch(Neos\Flow\Cli\Request, Neos\Flow\Cli\Response)
5 Neos\Flow\Cli\CommandRequestHandler::Neos\Flow\Cli\{closure}()
4 Neos\Flow\Security\Context_Original::withoutAuthorizationChecks(Closure)
3 Neos\Flow\Cli\CommandRequestHandler::handleRequest()
2 Neos\Flow\Core\Bootstrap::run()
1 require("/application/Packages/Framework/Neos.Flow/Scripts/flow.php")

Previous exception: Exception [HY000] in line 71 of /application/Packages/Libraries/doctrine/dbal/src/Driver/PDO/Connection.php: SQLSTATE[HY000]: General error: 1205 Lock wait timeout exceeded; try restarting transaction

16 PDO::query("SELECT * FROM cr_default_subscriptions ORDER BY id ASC FOR UPDATE")
15 Doctrine\DBAL\Driver\PDO\Connection::query("SELECT * FROM cr_default_subscriptions ORDER BY id ASC FOR UPDATE")
14 Doctrine\DBAL\Connection::executeQuery("SELECT * FROM cr_default_subscriptions ORDER BY id ASC FOR UPDATE", array|0|, array|0|, null)
13 Doctrine\DBAL\Query\QueryBuilder::executeQuery()
12 Neos\ContentRepositoryRegistry\Factory\SubscriptionStore\DoctrineSubscriptionStore::findByCriteriaForUpdate(Neos\ContentRepository\Core\Subscription\Store\SubscriptionCriteria)
11 Neos\ContentRepository\Core\Subscription\Engine\SubscriptionEngine::subscriptionStatus()
10 Neos\ContentRepository\Core\Service\ContentRepositoryMaintainer::status()
9 Neos\ContentRepositoryRegistry\Command\CrCommandController_Original::statusCommand("default", false, false)
8 Neos\Flow\Cli\CommandController_Original::callCommandMethod()
7 Neos\Flow\Cli\CommandController_Original::processRequest(Neos\Flow\Cli\Request, Neos\Flow\Cli\Response)
6 Neos\Flow\Cli\Dispatcher_Original::dispatch(Neos\Flow\Cli\Request, Neos\Flow\Cli\Response)
5 Neos\Flow\Cli\CommandRequestHandler::Neos\Flow\Cli\{closure}()
4 Neos\Flow\Security\Context_Original::withoutAuthorizationChecks(Closure)
3 Neos\Flow\Cli\CommandRequestHandler::handleRequest()
2 Neos\Flow\Core\Bootstrap::run()
1 require("/application/Packages/Framework/Neos.Flow/Scripts/flow.php")


    [array] =>
        previousException:
        [string] => Exception #1205 in line 76 of /application/Packages/Libraries/doctrine/dbal/src/Driver/PDO/Connection.php: SQLSTATE[HY000]: General error: 1205 Lock wait timeout exceeded; try restarting transaction

Exception #1205 in line 1976 of /application/Packages/Libraries/doctrine/dbal/src/Connection.php: An exception occurred while executing a query: SQLSTATE[HY000]: General error: 1205 Lock wait timeout exceeded; try restarting transaction

17 Doctrine\DBAL\Driver\API\MySQL\ExceptionConverter::convert(Exception|PDOException: SQLSTATE[HY000]: General error: 1205 Lock wait timeout exceeded; try restarting transa…|, Doctrine\DBAL\Query)
16 Doctrine\DBAL\Connection::handleDriverException(Exception|PDOException: SQLSTATE[HY000]: General error: 1205 Lock wait timeout exceeded; try restarting transa…|, Doctrine\DBAL\Query)
15 Doctrine\DBAL\Connection::convertExceptionDuringQuery(Exception|PDOException: SQLSTATE[HY000]: General error: 1205 Lock wait timeout exceeded; try restarting transa…|, "SELECT * FROM cr_default_subscriptions ORDER BY id ASC FOR UPDATE", array|0|, array|0|)
14 Doctrine\DBAL\Connection::executeQuery("SELECT * FROM cr_default_subscriptions ORDER BY id ASC FOR UPDATE", array|0|, array|0|, null)
13 Doctrine\DBAL\Query\QueryBuilder::executeQuery()
12 Neos\ContentRepositoryRegistry\Factory\SubscriptionStore\DoctrineSubscriptionStore::findByCriteriaForUpdate(Neos\ContentRepository\Core\Subscription\Store\SubscriptionCriteria)
11 Neos\ContentRepository\Core\Subscription\Engine\SubscriptionEngine::subscriptionStatus()
10 Neos\ContentRepository\Core\Service\ContentRepositoryMaintainer::status()
9 Neos\ContentRepositoryRegistry\Command\CrCommandController_Original::statusCommand("default", false, false)
8 Neos\Flow\Cli\CommandController_Original::callCommandMethod()
7 Neos\Flow\Cli\CommandController_Original::processRequest(Neos\Flow\Cli\Request, Neos\Flow\Cli\Response)
6 Neos\Flow\Cli\Dispatcher_Original::dispatch(Neos\Flow\Cli\Request, Neos\Flow\Cli\Response)
5 Neos\Flow\Cli\CommandRequestHandler::Neos\Flow\Cli\{closure}()
4 Neos\Flow\Security\Context_Original::withoutAuthorizationChecks(Closure)
3 Neos\Flow\Cli\CommandRequestHandler::handleRequest()
2 Neos\Flow\Core\Bootstrap::run()
1 require("/application/Packages/Framework/Neos.Flow/Scripts/flow.php")

Previous exception: Exception #1205 in line 76 of /application/Packages/Libraries/doctrine/dbal/src/Driver/PDO/Connection.php: SQLSTATE[HY000]: General error: 1205 Lock wait timeout exceeded; try restarting transaction

16 Doctrine\DBAL\Driver\PDO\Exception::new(PDOException|PDOException: SQLSTATE[HY000]: General error: 1205 Lock wait timeout exceeded; try restarting transa…|)
15 Doctrine\DBAL\Driver\PDO\Connection::query("SELECT * FROM cr_default_subscriptions ORDER BY id ASC FOR UPDATE")
14 Doctrine\DBAL\Connection::executeQuery("SELECT * FROM cr_default_subscriptions ORDER BY id ASC FOR UPDATE", array|0|, array|0|, null)
13 Doctrine\DBAL\Query\QueryBuilder::executeQuery()
12 Neos\ContentRepositoryRegistry\Factory\SubscriptionStore\DoctrineSubscriptionStore::findByCriteriaForUpdate(Neos\ContentRepository\Core\Subscription\Store\SubscriptionCriteria)
11 Neos\ContentRepository\Core\Subscription\Engine\SubscriptionEngine::subscriptionStatus()
10 Neos\ContentRepository\Core\Service\ContentRepositoryMaintainer::status()
9 Neos\ContentRepositoryRegistry\Command\CrCommandController_Original::statusCommand("default", false, false)
8 Neos\Flow\Cli\CommandController_Original::callCommandMethod()
7 Neos\Flow\Cli\CommandController_Original::processRequest(Neos\Flow\Cli\Request, Neos\Flow\Cli\Response)
6 Neos\Flow\Cli\Dispatcher_Original::dispatch(Neos\Flow\Cli\Request, Neos\Flow\Cli\Response)
5 Neos\Flow\Cli\CommandRequestHandler::Neos\Flow\Cli\{closure}()
4 Neos\Flow\Security\Context_Original::withoutAuthorizationChecks(Closure)
3 Neos\Flow\Cli\CommandRequestHandler::handleRequest()
2 Neos\Flow\Core\Bootstrap::run()
1 require("/application/Packages/Framework/Neos.Flow/Scripts/flow.php")

Previous exception: Exception [HY000] in line 71 of /application/Packages/Libraries/doctrine/dbal/src/Driver/PDO/Connection.php: SQLSTATE[HY000]: General error: 1205 Lock wait timeout exceeded; try restarting transaction

16 PDO::query("SELECT * FROM cr_default_subscriptions ORDER BY id ASC FOR UPDATE")
15 Doctrine\DBAL\Driver\PDO\Connection::query("SELECT * FROM cr_default_subscriptions ORDER BY id ASC FOR UPDATE")
14 Doctrine\DBAL\Connection::executeQuery("SELECT * FROM cr_default_subscriptions ORDER BY id ASC FOR UPDATE", array|0|, array|0|, null)
13 Doctrine\DBAL\Query\QueryBuilder::executeQuery()
12 Neos\ContentRepositoryRegistry\Factory\SubscriptionStore\DoctrineSubscriptionStore::findByCriteriaForUpdate(Neos\ContentRepository\Core\Subscription\Store\SubscriptionCriteria)
11 Neos\ContentRepository\Core\Subscription\Engine\SubscriptionEngine::subscriptionStatus()
10 Neos\ContentRepository\Core\Service\ContentRepositoryMaintainer::status()
9 Neos\ContentRepositoryRegistry\Command\CrCommandController_Original::statusCommand("default", false, false)
8 Neos\Flow\Cli\CommandController_Original::callCommandMethod()
7 Neos\Flow\Cli\CommandController_Original::processRequest(Neos\Flow\Cli\Request, Neos\Flow\Cli\Response)
6 Neos\Flow\Cli\Dispatcher_Original::dispatch(Neos\Flow\Cli\Request, Neos\Flow\Cli\Response)
5 Neos\Flow\Cli\CommandRequestHandler::Neos\Flow\Cli\{closure}()
4 Neos\Flow\Security\Context_Original::withoutAuthorizationChecks(Closure)
3 Neos\Flow\Cli\CommandRequestHandler::handleRequest()
2 Neos\Flow\Core\Bootstrap::run()
1 require("/application/Packages/Framework/Neos.Flow/Scripts/flow.php")


    [array] =>
        previousException:
        [string] => Exception #1205 in line 76 of /application/Packages/Libraries/doctrine/dbal/src/Driver/PDO/Connection.php: SQLSTATE[HY000]: General error: 1205 Lock wait timeout exceeded; try restarting transaction

Expected Behavior

...

Steps To Reproduce

No response

Environment

- Flow:
- Neos:
- PHP:

Anything else?

No response

Metadata

Metadata

Assignees

No one assigned

    Labels

    9.0Bug

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions