BUG: doctrine:migrate causes exception running on an empty postgresql database #5752
Description
Is there an existing issue for this?
- I have searched the existing issues
Current Behavior
I'm having an empty database and i'm running doctrine:migrate to create the scheme for neos. This is what happens:
{"severity":"INFO","timestamp":"2026-03-02T10:56:14+01:00","message":"File Monitor \"Flow_ConfigurationFiles\" detected 167 changed files and 34 changed directories.","packageKey":"Neos.Flow","className":"Neos\\Flow\\Monitor\\FileMonitor","methodName":"detectChanges"}
{"severity":"INFO","timestamp":"2026-03-02T10:56:14+01:00","message":"File Monitor \"Flow_TranslationFiles\" detected 1074 changed files and 14 changed directories.","packageKey":"Neos.Flow","className":"Neos\\Flow\\Monitor\\FileMonitor","methodName":"detectChanges"}
{"severity":"INFO","timestamp":"2026-03-02T10:56:20+01:00","message":"Reflected 33 emerged classes.","packageKey":"Neos.Flow","className":"Neos\\Flow\\Reflection\\ReflectionService","methodName":"reflectEmergedClasses"}
{"severity":"INFO","timestamp":"2026-03-02T10:56:21+01:00","message":"Aspects have been modified, therefore rebuilding all target classes.","packageKey":"Neos.Flow","className":"Neos\\Flow\\Aop\\Builder\\ProxyClassBuilder","methodName":"build"}
{"severity":"INFO","timestamp":"2026-03-02T10:56:23+01:00","message":"Updated reflection caches (1818 classes).","packageKey":null,"className":null,"methodName":null}{"severity":"CRITICAL","timestamp":"2026-03-02T10:56:24+01:00","message":"Exception #1355480641 in line 665 of /var/Neos/Packages/Framework/Neos.Flow/Classes/Core/Booting/Scripts.php: {\"severity\":\"CRITICAL\",\"timestamp\":\"2026-03-02T10:56:24+01:00\",\"message\":\"Exception #7 in line 1976 of /var/Neos/Packages/Libraries/doctrine/dbal/src/Connection.php: An exception occurred while executing a query: SQLSTATE[42P01]: Undefined table: 7 ERROR: relation \\\"neos_flow_security_account\\\" does not exist\\nLINE 1: ...n0_.persistence_object_identifier) AS sclr_0 FROM neos_flow_...\\n ^ - See also: 202603021056232795dd.txt\",\"packageKey\":null,\"className\":null,\"methodName\":null}\nAn exception occurred while executing a query: SQLSTATE[42P01]: Undefined table: 7 ERROR: relation \"neos_flow_security_account\" does not exist\nLINE 1: ...n0_.persistence_object_identifier) AS sclr_0 FROM\nneos_flow_...\n ^\n\n Type: Doctrine\\DBAL\\Exception\\TableNotFoundException\n Code: 7\n File: Packages/Libraries/doctrine/dbal/src/Driver/API/PostgreSQL/ExceptionConvert\n er.php\n Line: 71\n\nNested exception:\nSQLSTATE[42P01]: Undefined table: 7 ERROR: relation \"neos_flow_security_account\" does not exist\nLINE 1: ...n0_.persistence_object_identifier) AS sclr_0 FROM\nneos_flow_...\n ^\n\n Type: Doctrine\\DBAL\\Driver\\PDO\\Exception\n Code: 7\n File: Packages/Libraries/doctrine/dbal/src/Driver/PDO/Exception.php\n Line: 24\n\nNested exception:\nSQLSTATE[42P01]: Undefined table: 7 ERROR: relation \"neos_flow_security_account\" does not exist\nLINE 1: ...n0_.persistence_object_identifier) AS sclr_0 FROM\nneos_flow_...\n ^\n\n Type: PDOException\n Code: 42P01\n File: Packages/Libraries/doctrine/dbal/src/Driver/PDO/Connection.php\n Line: 71 - See also: 202603021056136278a6.txt","packageKey":null,"className":null,"methodName":null}
{"severity":"CRITICAL","timestamp":"2026-03-02T10:56:24+01:00","message":"Exception #7 in line 1976 of /var/Neos/Packages/Libraries/doctrine/dbal/src/Connection.php: An exception occurred while executing a query: SQLSTATE[42P01]: Undefined table: 7 ERROR: relation \"neos_flow_security_account\" does not exist\nLINE 1: ...n0_.persistence_object_identifier) AS sclr_0 FROM neos_flow_...\n ^ - See also: 202603021056232795dd.txt","packageKey":null,"className":null,"methodName":null}
An exception occurred while executing a query: SQLSTATE[42P01]: Undefined
table: 7 ERROR: relation "neos_flow_security_account" does not exist
LINE 1: ...n0_.persistence_object_identifier) AS sclr_0 FROM
neos_flow_...
^
Type: Doctrine\DBAL\Exception\TableNotFoundException
Code: 7
File:
Packages/Libraries/doctrine/dbal/src/Driver/API/PostgreSQL/ExceptionConvert
er.php
Line: 71
Nested exception:
SQLSTATE[42P01]: Undefined table: 7 ERROR: relation
"neos_flow_security_account" does not exist
LINE 1: ...n0_.persistence_object_identifier) AS sclr_0 FROM
neos_flow_...
^
Type: Doctrine\DBAL\Driver\PDO\Exception
Code: 7
File: Packages/Libraries/doctrine/dbal/src/Driver/PDO/Exception.php
Line: 24
Nested exception:
SQLSTATE[42P01]: Undefined table: 7 ERROR: relation
"neos_flow_security_account" does not exist
LINE 1: ...n0_.persistence_object_identifier) AS sclr_0 FROM
neos_flow_...
^
Type: PDOException
Code: 42P01
File: Packages/Libraries/doctrine/dbal/src/Driver/PDO/Connection.php
Line: 71
Type: Neos\Flow\Core\Booting\Exception\SubProcessException
Code: 1355480641
File: Packages/Framework/Neos.Flow/Classes/Core/Booting/Scripts.php
Line: 723
Open Data/Logs/Exceptions/202603021056136278a6.txt for a full stack trace.
The full exception:
Exception #7 in line 1976 of /var/Neos/Packages/Libraries/doctrine/dbal/src/Connection.php: An exception occurred while executing a query: SQLSTATE[42P01]: Undefined table: 7 ERROR: relation "neos_flow_security_account" does not exist
LINE 1: ...n0_.persistence_object_identifier) AS sclr_0 FROM neos_flow_...
^
21 Doctrine\DBAL\Driver\API\PostgreSQL\ExceptionConverter::convert(Exception|PDOException: SQLSTATE[42P01]: Undefined table: 7 ERROR: relation "neos_flow_security_account" does…|, Doctrine\DBAL\Query)
20 Doctrine\DBAL\Connection::handleDriverException(Exception|PDOException: SQLSTATE[42P01]: Undefined table: 7 ERROR: relation "neos_flow_security_account" does…|, Doctrine\DBAL\Query)
19 Doctrine\DBAL\Connection::convertExceptionDuringQuery(Exception|PDOException: SQLSTATE[42P01]: Undefined table: 7 ERROR: relation "neos_flow_security_account" does…|, "SELECT count(n0_.persistence_object_identifier) AS sclr_0 FROM neos_flow_security_account n0_", array|0|, array|0|)
18 Doctrine\DBAL\Connection::executeQuery("SELECT count(n0_.persistence_object_identifier) AS sclr_0 FROM neos_flow_security_account n0_", array|0|, array|0|, null)
17 Doctrine\ORM\Query\Exec\FinalizedSelectExecutor::execute(Doctrine\DBAL\Connection, array|0|, array|0|)
16 Doctrine\ORM\Query::_doExecute()
15 Doctrine\ORM\AbstractQuery::executeIgnoreQueryCache(null, 4)
14 Doctrine\ORM\AbstractQuery::execute(null, 4)
13 Doctrine\ORM\AbstractQuery::getSingleResult(4)
12 Doctrine\ORM\AbstractQuery::getSingleScalarResult()
11 Neos\Flow\Persistence\Doctrine\Query_Original::count()
10 Neos\Flow\Persistence\Repository::countAll()
9 Neos\Flow\ObjectManagement\DependencyInjection\DependencyProxy::__call("countAll", array|0|)
8 mb\PrometheusExporter\UserMetricsCollector_Original::collect("Neos\Flow\Core\Bootstrap::finishedRuntimeRun")
7 call_user_func_array(array|2|, array|1|)
6 Neos\Flow\SignalSlot\Dispatcher::dispatch("Neos\Flow\Core\Bootstrap", "finishedRuntimeRun", array|0|)
5 Neos\Flow\Core\Bootstrap::emitFinishedRuntimeRun()
4 Neos\Flow\Core\Bootstrap::shutdown("Runtime")
3 Neos\Flow\Cli\CommandRequestHandler::shutdown("Runtime")
2 Neos\Flow\Cli\CommandRequestHandler::handleRequest()
1 Neos\Flow\Core\Bootstrap::run()
Previous exception: Exception #7 in line 76 of /var/Neos/Packages/Libraries/doctrine/dbal/src/Driver/PDO/Connection.php: SQLSTATE[42P01]: Undefined table: 7 ERROR: relation "neos_flow_security_account" does not exist
LINE 1: ...n0_.persistence_object_identifier) AS sclr_0 FROM neos_flow_...
^
20 Doctrine\DBAL\Driver\PDO\Exception::new(PDOException|PDOException: SQLSTATE[42P01]: Undefined table: 7 ERROR: relation "neos_flow_security_account" does…|)
19 Doctrine\DBAL\Driver\PDO\Connection::query("SELECT count(n0_.persistence_object_identifier) AS sclr_0 FROM neos_flow_security_account n0_")
18 Doctrine\DBAL\Connection::executeQuery("SELECT count(n0_.persistence_object_identifier) AS sclr_0 FROM neos_flow_security_account n0_", array|0|, array|0|, null)
17 Doctrine\ORM\Query\Exec\FinalizedSelectExecutor::execute(Doctrine\DBAL\Connection, array|0|, array|0|)
16 Doctrine\ORM\Query::_doExecute()
15 Doctrine\ORM\AbstractQuery::executeIgnoreQueryCache(null, 4)
14 Doctrine\ORM\AbstractQuery::execute(null, 4)
13 Doctrine\ORM\AbstractQuery::getSingleResult(4)
12 Doctrine\ORM\AbstractQuery::getSingleScalarResult()
11 Neos\Flow\Persistence\Doctrine\Query_Original::count()
10 Neos\Flow\Persistence\Repository::countAll()
9 Neos\Flow\ObjectManagement\DependencyInjection\DependencyProxy::__call("countAll", array|0|)
8 mb\PrometheusExporter\UserMetricsCollector_Original::collect("Neos\Flow\Core\Bootstrap::finishedRuntimeRun")
7 call_user_func_array(array|2|, array|1|)
6 Neos\Flow\SignalSlot\Dispatcher::dispatch("Neos\Flow\Core\Bootstrap", "finishedRuntimeRun", array|0|)
5 Neos\Flow\Core\Bootstrap::emitFinishedRuntimeRun()
4 Neos\Flow\Core\Bootstrap::shutdown("Runtime")
3 Neos\Flow\Cli\CommandRequestHandler::shutdown("Runtime")
2 Neos\Flow\Cli\CommandRequestHandler::handleRequest()
1 Neos\Flow\Core\Bootstrap::run()
Previous exception: Exception [42P01] in line 71 of /var/Neos/Packages/Libraries/doctrine/dbal/src/Driver/PDO/Connection.php: SQLSTATE[42P01]: Undefined table: 7 ERROR: relation "neos_flow_security_account" does not exist
LINE 1: ...n0_.persistence_object_identifier) AS sclr_0 FROM neos_flow_...
^
20 PDO::query("SELECT count(n0_.persistence_object_identifier) AS sclr_0 FROM neos_flow_security_account n0_")
19 Doctrine\DBAL\Driver\PDO\Connection::query("SELECT count(n0_.persistence_object_identifier) AS sclr_0 FROM neos_flow_security_account n0_")
18 Doctrine\DBAL\Connection::executeQuery("SELECT count(n0_.persistence_object_identifier) AS sclr_0 FROM neos_flow_security_account n0_", array|0|, array|0|, null)
17 Doctrine\ORM\Query\Exec\FinalizedSelectExecutor::execute(Doctrine\DBAL\Connection, array|0|, array|0|)
16 Doctrine\ORM\Query::_doExecute()
15 Doctrine\ORM\AbstractQuery::executeIgnoreQueryCache(null, 4)
14 Doctrine\ORM\AbstractQuery::execute(null, 4)
13 Doctrine\ORM\AbstractQuery::getSingleResult(4)
12 Doctrine\ORM\AbstractQuery::getSingleScalarResult()
11 Neos\Flow\Persistence\Doctrine\Query_Original::count()
10 Neos\Flow\Persistence\Repository::countAll()
9 Neos\Flow\ObjectManagement\DependencyInjection\DependencyProxy::__call("countAll", array|0|)
8 mb\PrometheusExporter\UserMetricsCollector_Original::collect("Neos\Flow\Core\Bootstrap::finishedRuntimeRun")
7 call_user_func_array(array|2|, array|1|)
6 Neos\Flow\SignalSlot\Dispatcher::dispatch("Neos\Flow\Core\Bootstrap", "finishedRuntimeRun", array|0|)
5 Neos\Flow\Core\Bootstrap::emitFinishedRuntimeRun()
4 Neos\Flow\Core\Bootstrap::shutdown("Runtime")
3 Neos\Flow\Cli\CommandRequestHandler::shutdown("Runtime")
2 Neos\Flow\Cli\CommandRequestHandler::handleRequest()
1 Neos\Flow\Core\Bootstrap::run()
[array] =>
previousException:
[string] => Exception #7 in line 76 of /var/Neos/Packages/Libraries/doctrine/dbal/src/Driver/PDO/Connection.php: SQLSTATE[42P01]: Undefined table: 7 ERROR: relation "neos_flow_security_account" does not exist
LINE 1: ...n0_.persistence_object_identifier) AS sclr_0 FROM neos_flow_...
^
As coming from Sebastian the fix was adding:
"doctrine/dbal": "^2.13"
to the require block within the root composer.yaml.
Expected Behavior
The migration creates the tables.
Steps To Reproduce
- Deploy a fresh postgresql (using helm on kubernetes) with a new pvc
- Deploy neos using the credentials to connect to the postgresql
- run: doctrine:migrate
Environment
"postgresql":"17.5"
"neos/neos": "8.4.4"
"neos/flow": "8.4.2"
"neos/neos-ui": "8.4.2"
"php":"8.5.3"
running within kubernetes 1.35Anything else?
See in Slack