Open d33kayyy opened 2 years ago
We're using latest postgis/postgis:13-3.2-alpine
and having the same issue. Seems like some PostgreSQL scheduler problem though
"variable not found in subplan target list"
This is similar to your issue: https://www.postgresql.org/message-id/flat/4c347490-d734-5fdd-d613-1327601b4e7e%40mit.edu "With yesterday’s release of PostgreSQL 11.15, 12.10, and 13.6 (presumably 10.20 and 14.2 as well), Zulip’s test suite started failing with “variable not found in subplan target list” errors from PostgreSQL on a table that has a PGroonga index. I found the following reproduction recipe from a fresh database:"
good news:
bad news:
So this is a PostgreSQL's problem.
The previous images Job list can be accessed here: https://github.com/postgis/docker-postgis/actions/runs/1804724878
12-3.2-alpine: digest: sha256:22ce834ccf439390556a06342edcf150b03d413d29a1383675111597548a5572
docker pull postgis/postgis:12-3.2-alpine@sha256:22ce834ccf439390556a06342edcf150b03d413d29a1383675111597548a5572
COMMENT:
EDIT:
You can find digest in "Push docker image to dockerhub" step UPD: It worked! Thank you!
the new postgis\postgis
images were created with the latest PG 14.3, 13.7, 12.11, 11.16, and 10.21.
( merged PR https://github.com/postgis/docker-postgis/pull/294 )
Please re-test !
Hi,
We are using
postgis:10-2.5-alpine
image to run our CI/CD pipeline, which started to fail after the latest release. (we always pull the latestpostgis:10-2.5-alpine
image, and the latest that we have is214a7af1fedc
). I tried with an older version and it works just fine. This error is quite strange to me, as I tried to google it but there doesn't seem to be much resource around it.Any help is appreciated.
pg log