[Bug]: Windmill Postgres error cannot create the DB correctly #3917
Comments
kikohs
added
🐛 Bug
|
https://github.com/coollabsio/coolify/blob/460b9929940351b6c848d47116ac2a0201755a60/templates/compose/windmill.yaml |
|
Ok. I have a 404. Something wrong with TLS but i thought it might be the postgres thing.. |
|
Please use this updated compose and let me know if you still get this issue: https://github.com/coollabsio/coolify/blob/next/templates/compose/windmill.yaml |
peaklabs-dev
removed
the
🔍 Triage
|
it works now! |
github-actions
bot
removed
the
🐛 Bug
Merged
|
I can't run any jobs in any lang. It seems the workers are not detected
|
|
Just hit the same issues with workers, will let you know if I find the cause. |
|
This |
|
Yeah, The issue was the MODE that is reading the variable, but variable is "server" and worker need "worker" mode. services:
db:
image: 'postgres:16'
shm_size: 1g
volumes:
- 'db-data:/var/lib/postgresql/data'
environment:
- POSTGRES_PASSWORD=$SERVICE_PASSWORD_POSTGRES
- 'POSTGRES_DB=${POSTGRES_DB:-windmill}'
healthcheck:
test:
- CMD-SHELL
- 'pg_isready -U postgres'
interval: 10s
timeout: 5s
retries: 5
windmill-server:
image: 'ghcr.io/windmill-labs/windmill:main'
environment:
- SERVICE_FQDN_WINDMILL_8000
- 'DATABASE_URL=postgres://postgres:$SERVICE_PASSWORD_POSTGRES@db/windmill'
- 'MODE=server'
- BASE_URL=$SERVICE_FQDN_WINDMILL
depends_on:
db:
condition: service_healthy
volumes:
- 'worker-logs:/tmp/windmill/logs'
healthcheck:
test:
- CMD
- curl
- '-f'
- 'http://localhost:8000/health'
interval: 30s
timeout: 10s
retries: 3
windmill-worker-1:
image: 'ghcr.io/windmill-labs/windmill:main'
environment:
- 'DATABASE_URL=postgres://postgres:$SERVICE_PASSWORD_POSTGRES@db/windmill'
- 'MODE=worker'
- 'WORKER_GROUP=${WORKER_GROUP:-default}'
depends_on:
db:
condition: service_healthy
volumes:
- '/var/run/docker.sock:/var/run/docker.sock'
- 'worker-dependency-cache:/tmp/windmill/cache'
- 'worker-logs:/tmp/windmill/logs'
healthcheck:
test:
- CMD-SHELL
- 'exit 0'
interval: 30s
timeout: 10s
retries: 3
windmill-worker-2:
image: 'ghcr.io/windmill-labs/windmill:main'
environment:
- 'DATABASE_URL=postgres://postgres:$SERVICE_PASSWORD_POSTGRES@db/windmill'
- 'MODE=worker'
- 'WORKER_GROUP=${WORKER_GROUP:-default}'
depends_on:
db:
condition: service_healthy
volumes:
- '/var/run/docker.sock:/var/run/docker.sock'
- 'worker-dependency-cache:/tmp/windmill/cache'
- 'worker-logs:/tmp/windmill/logs'
healthcheck:
test:
- CMD-SHELL
- 'exit 0'
interval: 30s
timeout: 10s
retries: 3
windmill-worker-3:
image: 'ghcr.io/windmill-labs/windmill:main'
environment:
- 'DATABASE_URL=postgres://postgres:$SERVICE_PASSWORD_POSTGRES@db/windmill'
- 'MODE=worker'
- 'WORKER_GROUP=${WORKER_GROUP:-default}'
depends_on:
db:
condition: service_healthy
volumes:
- '/var/run/docker.sock:/var/run/docker.sock'
- 'worker-dependency-cache:/tmp/windmill/cache'
- 'worker-logs:/tmp/windmill/logs'
healthcheck:
test:
- CMD-SHELL
- 'exit 0'
interval: 30s
timeout: 10s
retries: 3
windmill-worker-native:
image: 'ghcr.io/windmill-labs/windmill:main'
environment:
- 'DATABASE_URL=postgres://postgres:$SERVICE_PASSWORD_POSTGRES@db/windmill'
- 'MODE=worker'
- 'WORKER_GROUP=native'
- 'NUM_WORKERS=${NUM_WORKERS:-8}'
- 'SLEEP_QUEUE=${SLEEP_QUEUE:-200}'
depends_on:
db:
condition: service_healthy
volumes:
- 'worker-logs:/tmp/windmill/logs'
healthcheck:
test:
- CMD-SHELL
- 'exit 0'
interval: 30s
timeout: 10s
retries: 3
lsp:
image: 'ghcr.io/windmill-labs/windmill-lsp:latest'
volumes:
- 'lsp-cache:/root/.cache'
healthcheck:
test:
- CMD-SHELL
- 'exit 0'
interval: 30s
timeout: 10s
retries: 3 |
|
I created a PR (did not test) with more sane compose (founder of Windmill) |
peaklabs-dev
added
🐛 Bug
|
I fixed some things again, could you please retest if it works now: https://github.com/coollabsio/coolify/blob/next/templates/compose/windmill.yaml |
|
I managed to get it to work with a reduced number of workers yes. |
github-actions
bot
removed
🐛 Bug
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
Error Message and Logs
The postgres container of windmill cannot create the database correctly:
Steps to Reproduce
Example Repository URL
No response
Coolify Version
v4.0.0-beta460
Are you using Coolify Cloud?
No (self-hosted)
Operating System and Version (self-hosted)
Ubunto 24.04
Additional Information
No response
The text was updated successfully, but these errors were encountered: