[2.10] Unable to persist entites while using PrimaryReadReplicaConnection #6857

New Issue

admin · 2026-01-22T15:40:08+01:00

admin commented

2026-01-22 15:40:08 +01:00

Originally created by @lp-contentplus on GitHub (Oct 8, 2021).

Issue introduced in:
afa837a361

$this->_nextValue = (int) $conn->query($sql)->fetchColumn();

Deprecated method query() calls ensureConnectedToPrimary() inside.
executeQuery() does not.

An exception occurred while executing 'SELECT NEXTVAL('...')':
SQLSTATE[25006]: Read only sql transaction: 7

Originally created by @lp-contentplus on GitHub (Oct 8, 2021). Issue introduced in: https://github.com/doctrine/orm/commit/afa837a3611490adbcf559fa9ea9db9dc04397a9 ``` $this->_nextValue = (int) $conn->query($sql)->fetchColumn(); ``` Deprecated method query() calls ensureConnectedToPrimary() inside. executeQuery() does not. ``` An exception occurred while executing 'SELECT NEXTVAL('...')': SQLSTATE[25006]: Read only sql transaction: 7 ```

admin added the Regression label 2026-01-22 15:40:08 +01:00

admin closed this issue

2026-01-22 15:40:08 +01:00

admin commented

2026-01-22 15:40:09 +01:00

@beberlei commented on GitHub (Oct 29, 2021):

Good catch. This should maybe use $conn->executeStatement($sql) instead?

@beberlei commented on GitHub (Oct 29, 2021): Good catch. This should maybe use `$conn->executeStatement($sql)` instead?

admin commented

2026-01-22 15:40:10 +01:00

@lp-contentplus commented on GitHub (Oct 29, 2021):

executeStatement also won't work (it returns the number of affected rows instead of the query result)
There is no direct replacement for query()

@lp-contentplus commented on GitHub (Oct 29, 2021): `executeStatement` also won't work (it returns the number of affected rows instead of the query result) There is no direct replacement for `query()`

admin commented

2026-01-22 15:40:10 +01:00

@anarxistkot commented on GitHub (Dec 3, 2021):

Are there any solution options?
We need doctrine/dbal version 3.2 :(

@anarxistkot commented on GitHub (Dec 3, 2021): Are there any solution options? We need doctrine/dbal version 3.2 :(

admin commented

2026-01-22 15:40:10 +01:00

@derrabus commented on GitHub (Dec 21, 2021):

Does 2.10.4 fix your issue?

@derrabus commented on GitHub (Dec 21, 2021): Does 2.10.4 fix your issue?

admin commented

2026-01-22 15:40:10 +01:00