This is an automated email from the ASF dual-hosted git repository.
klesh pushed a commit to branch main
in repository https://gitbox.apache.org/repos/asf/devlake.git
The following commit(s) were added to refs/heads/main by this push:
new b70ac93a8 chore(docker): bump PostgreSQL to 18.1 and MySQL to 8.4.10
(#9003)
b70ac93a8 is described below
commit b70ac93a8468d5292cccb3826c41cf27c4a59253
Author: Dirk <[email protected]>
AuthorDate: Sun Jul 26 13:14:47 2026 +0200
chore(docker): bump PostgreSQL to 18.1 and MySQL to 8.4.10 (#9003)
Bump database engine images across the dev, devcontainer, temporal
deployment and remote e2e compose files: PostgreSQL 17.2/14.2 to 18.1 and MySQL
8/8.0.26 to 8.4.10.
For PostgreSQL 18 the remote e2e volume is mounted at /var/lib/postgresql
(parent of the new versioned data dir) instead of /var/lib/postgresql/data, and
the Grafana datasource provisioning sets postgresVersion to 1800.
Grafana database env parametrization is intentionally out of scope.
Signed-off-by: DoDiODev <[email protected]>
---
.devcontainer/docker-compose.yml | 2 +-
backend/test/e2e/remote/docker-compose.test.yml | 6 +++---
devops/deployment/temporal/docker-compose-temporal.yml | 2 +-
docker-compose-dev-mysql.yml | 2 +-
docker-compose-dev-postgresql.yml | 4 ++--
docker-compose.datasources.yml | 2 +-
grafana/scripts/entrypoint.sh | 2 +-
7 files changed, 10 insertions(+), 10 deletions(-)
diff --git a/.devcontainer/docker-compose.yml b/.devcontainer/docker-compose.yml
index b30d7a75b..2b2d977a5 100644
--- a/.devcontainer/docker-compose.yml
+++ b/.devcontainer/docker-compose.yml
@@ -24,7 +24,7 @@ services:
- default
command: sleep infinity
mysql:
- image: mysql:8
+ image: mysql:8.4.10
volumes:
- mysql-storage:/var/lib/mysql
restart: always
diff --git a/backend/test/e2e/remote/docker-compose.test.yml
b/backend/test/e2e/remote/docker-compose.test.yml
index 393cab00a..63827d73c 100644
--- a/backend/test/e2e/remote/docker-compose.test.yml
+++ b/backend/test/e2e/remote/docker-compose.test.yml
@@ -19,7 +19,7 @@ version: "3"
services:
mysql-test:
- image: mysql:8.0.26
+ image: mysql:8.4.10
platform: linux/x86_64
volumes:
- mysql-test-storage:/var/lib/mysql
@@ -33,12 +33,12 @@ services:
MYSQL_PASSWORD: merico
postgres-test:
- image: postgres:14.2-alpine
+ image: postgres:18.1-alpine
restart: always
ports:
- "3308:5432"
volumes:
- - postgres-test-storage:/var/lib/postgresql/data
+ - postgres-test-storage:/var/lib/postgresql
environment:
POSTGRES_DB: lake
POSTGRES_USER: merico
diff --git a/devops/deployment/temporal/docker-compose-temporal.yml
b/devops/deployment/temporal/docker-compose-temporal.yml
index 7b7aa1dca..5cad40acf 100644
--- a/devops/deployment/temporal/docker-compose-temporal.yml
+++ b/devops/deployment/temporal/docker-compose-temporal.yml
@@ -16,7 +16,7 @@
version: "3"
services:
mysql:
- image: mysql:8.0.26
+ image: mysql:8.4.10
volumes:
- mysql-storage:/var/lib/mysql
restart: always
diff --git a/docker-compose-dev-mysql.yml b/docker-compose-dev-mysql.yml
index 11b9bab0b..e7ad6a72f 100644
--- a/docker-compose-dev-mysql.yml
+++ b/docker-compose-dev-mysql.yml
@@ -18,7 +18,7 @@ name: devlake-mysql
services:
mysql:
- image: mysql:8
+ image: mysql:8.4.10
volumes:
- mysql-storage:/var/lib/mysql
restart: always
diff --git a/docker-compose-dev-postgresql.yml
b/docker-compose-dev-postgresql.yml
index 36b0a34e6..5a73b00c4 100644
--- a/docker-compose-dev-postgresql.yml
+++ b/docker-compose-dev-postgresql.yml
@@ -16,8 +16,8 @@
name: devlake-postgresql
services:
- postgres:
- image: postgres:17.2
+ postgres:
+ image: postgres:18.1
volumes:
- postgres-storage:/var/lib/postgresql
restart: always
diff --git a/docker-compose.datasources.yml b/docker-compose.datasources.yml
index 98f922324..a6fcc0a7b 100644
--- a/docker-compose.datasources.yml
+++ b/docker-compose.datasources.yml
@@ -20,7 +20,7 @@ version: "3"
services:
mysql-ds:
- image: mysql:8
+ image: mysql:8.4.10
volumes:
- ./.docker/mysql-ds:/var/lib/mysql
# init.sql only runs on bootstrap. If you want to manually add the extra
databases, run the SQL statements in the init.sql as MySQL root user
diff --git a/grafana/scripts/entrypoint.sh b/grafana/scripts/entrypoint.sh
index f5a13fa4c..6b0493d41 100644
--- a/grafana/scripts/entrypoint.sh
+++ b/grafana/scripts/entrypoint.sh
@@ -204,7 +204,7 @@ else
},
"jsonData": {
"sslmode": "${SSL_MODE}",
- "postgresVersion": 1400,
+ "postgresVersion": 1800,
"database": "${POSTGRES_DATABASE}"
},
"access": "proxy",
