[
https://issues.apache.org/jira/browse/CALCITE-7241?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=18032381#comment-18032381
]
Stamatis Zampetakis commented on CALCITE-7241:
----------------------------------------------
Thanks for looking into this [~jensen] . I can repro locally by doing the
following:
{noformat}
$ git clone [email protected]:zabetak/calcite-druid-dataset.git
$ cd calcite-druid-dataset
$ docker compose pull
$ docker compose up -d
{noformat}
As already pointed out in the PR the Postgres container fails to start due to
the following:
{noformat}
$ docker logs postgres
Error: in 18+, these Docker images are configured to store database data in a
format which is compatible with "pg_ctlcluster" (specifically, using
major-version-specific directory names). This better reflects how
PostgreSQL itself works, and how upgrades are to be performed.
See also https://github.com/docker-library/postgres/pull/1259
Counter to that, there appears to be PostgreSQL data in:
/var/lib/postgresql/data (unused mount/volume)
This is usually the result of upgrading the Docker image without
upgrading the underlying database using "pg_upgrade" (which requires both
versions).
The suggested container configuration for 18+ is to place a single mount
at /var/lib/postgresql which will then place PostgreSQL data in a
subdirectory, allowing usage of "pg_upgrade --link" without mount point
boundary issues.
See https://github.com/docker-library/postgres/issues/37 for a (long)
discussion around this process, and suggestions for how to do so.
{noformat}
> PostgreSQL image upgrade to latest tag breaks Druid CI tests
> ------------------------------------------------------------
>
> Key: CALCITE-7241
> URL: https://issues.apache.org/jira/browse/CALCITE-7241
> Project: Calcite
> Issue Type: Bug
> Components: core
> Affects Versions: 1.40.0
> Reporter: Zhen Chen
> Assignee: Stamatis Zampetakis
> Priority: Major
> Fix For: 1.41.0
>
>
> For detailed information about the issue, please refer to:
> [https://github.com/apache/calcite/pull/4596]
>
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
