Postgresql can’t start after updating to 1.24.1
I have baserow selfhosted on a ubuntu server vm, it was working fine, and i started to build my database with my collegues, but after updating to 1.24.1 i got this message :
Last login: Sat Apr 20 14:29:52 2024 baserow@baserow:~$ docker compose pull WARN[0000] /home/baserow/docker-compose.yml: versionis obsolete [+] Pulling 1/1 ✔ baserow Pulled 1.3s baserow@baserow:~$ docker compose up WARN[0000] /home/baserow/docker-compose.yml:version` is obsolete
[+] Running 1/0
Container baserow Created 0.0s
Attaching to baserow
baserow | [STARTUP][2024-04-20 14:30:20] No DATABASE_HOST or DATABASE_URL prov ided, using embedded postgres.
baserow | [STARTUP][2024-04-20 14:30:20] Using embedded baserow redis as no RE DIS_HOST or REDIS_URL provided.
baserow | [STARTUP][2024-04-20 14:30:20] Importing REDIS_PASSWORD secret from /baserow/data/.redispass
baserow | [STARTUP][2024-04-20 14:30:20] Importing SECRET_KEY secret from /bas erow/data/.secret
baserow | [STARTUP][2024-04-20 14:30:20] Importing BASEROW_JWT_SIGNING_KEY sec ret from /baserow/data/.jwt_signing_key
baserow | [STARTUP][2024-04-20 14:30:20] Importing DATABASE_PASSWORD secret fr om /baserow/data/.pgpass
baserow | ===================================================================== ====================
baserow |
baserow | ██████╗ █████╗ ███████╗███████╗██████╗ ██████╗ ██╗ ██╗
baserow | ██╔══██╗██╔══██╗██╔════╝██╔════╝██╔══██╗██╔═══██╗██║ ██║
baserow | ██████╔╝███████║███████╗█████╗ ██████╔╝██║ ██║██║ █╗ ██║
baserow | ██╔══██╗██╔══██║╚════██║██╔══╝ ██╔══██╗██║ ██║██║███╗██║
baserow | ██████╔╝██║ ██║███████║███████╗██║ ██║╚██████╔╝╚███╔███╔╝
baserow | ╚═════╝ ╚═╝ ╚═╝╚══════╝╚══════╝╚═╝ ╚═╝ ╚═════╝ ╚══╝╚══╝
baserow |
baserow | Version 1.24.2
baserow |
baserow | ===================================================================== ====================
baserow | Welcome to Baserow. See https://baserow.io/installation/install-with- docker/ for detailed instructions on
baserow | how to use this Docker image.
baserow | [STARTUP][2024-04-20 14:30:20] Running setup of embedded baserow dat abase.
baserow | [POSTGRES_INIT][2024-04-20 14:30:20] Becoming postgres superuser to run setup SQL commands:
baserow | [POSTGRES_INIT][2024-04-20 14:30:20]
baserow | [POSTGRES_INIT][2024-04-20 14:30:20] PostgreSQL Database directory a ppears to contain a database; Skipping initialization
baserow | [POSTGRES_INIT][2024-04-20 14:30:20]
baserow | [POSTGRES_INIT][2024-04-20 14:30:20]
baserow | [POSTGRES_INIT][2024-04-20 14:30:20] Your PostgreSQL data directory was initialized with version 11, but this image is running version 15.
baserow | [POSTGRES_INIT][2024-04-20 14:30:20] Please look into official Baser ow documentation at Install with Docker // Baserow pgrading-postgresql-database-from-a-previous-version for more information on how to upgrade your database using a different Baserow image (‘baserow/baserow-pgau toupgrade:1.24.2’) or how to run Baserow using legacy PostgreSQL 11 image (‘base row/baserow-pg11:1.24.2’).
baserow | [POSTGRES_INIT][2024-04-20 14:30:20]
baserow exited with code 1
i also have a copy of the vm before the update, and it’s not starting neither(
baserow.core.notifications.tasks.beat_send_instant_notifications_summary_by_email() (baserow.core.notifications.tasks.beat_send_instant_notifications_summary_by_email)
baserow | 2024-04-20 15:07:04,616 INFO stopped: beatworker (terminated by SIGQUIT (core dumped))
baserow | 2024-04-20 15:07:04,616 INFO stopped: beatworker (terminated by SIGQUIT (core dumped))
baserow | 2024-04-20 15:07:04,617 INFO reaped unknown pid 237 (exit status 0)
baserow | 2024-04-20 15:07:04,617 INFO reaped unknown pid 237 (exit status 0)
baserow | [WEBFRONTEND][2024-04-20 15:07:04] ℹ Listening on: http://localhost:3000/
baserow | 2024-04-20 15:07:04,630 INFO stopped: webfrontend (terminated by SIGTERM)
baserow | 2024-04-20 15:07:04,630 INFO stopped: webfrontend (terminated by SIGTERM)
baserow | [EXPORT_WORKER][2024-04-20 15:07:04]
baserow | [EXPORT_WORKER][2024-04-20 15:07:04]
baserow | 2024-04-20 15:07:05,632 INFO reaped unknown pid 262 (exit status 0)
baserow | 2024-04-20 15:07:05,632 INFO reaped unknown pid 262 (exit status 0)
baserow | [EXPORT_WORKER][2024-04-20 15:07:06] worker: Warm shutdown (MainProcess)
baserow | 2024-04-20 15:07:06,498 INFO stopped: exportworker (exit status 0)
baserow | 2024-04-20 15:07:06,498 INFO stopped: exportworker (exit status 0)
baserow | 2024-04-20 15:07:06,498 INFO reaped unknown pid 256 (exit status 0)
baserow | 2024-04-20 15:07:06,498 INFO reaped unknown pid 256 (exit status 0)
baserow | [CELERY_WORKER][2024-04-20 15:07:06] [2024-04-20 15:06:10,612: INFO/MainProcess] default-worker@f4ac50ec41cd ready.
baserow | [CELERY_WORKER][2024-04-20 15:07:06]
baserow | [BASEROW-WATCHER][2024-04-20 15:07:07] Waiting for Baserow to become available, this might take 30+ seconds...
baserow | 2024-04-20 15:07:08,096 INFO waiting for processes, baserow-watcher, caddy, postgresql, redis, celeryworker to die
baserow | 2024-04-20 15:07:08,096 INFO waiting for processes, baserow-watcher, caddy, postgresql, redis, celeryworker to die
baserow | [CELERY_WORKER][2024-04-20 15:07:08] worker: Warm shutdown (MainProcess)
baserow | 2024-04-20 15:07:08,387 INFO stopped: celeryworker (exit status 0)
baserow | 2024-04-20 15:07:08,387 INFO stopped: celeryworker (exit status 0)
baserow | 2024-04-20 15:07:08,387 INFO reaped unknown pid 280 (exit status 0)
baserow | 2024-04-20 15:07:08,387 INFO reaped unknown pid 280 (exit status 0)
baserow | [REDIS][2024-04-20 15:07:08] 166:M 20 Apr 2024 15:06:05.466 * Ready to accept connections
baserow | [REDIS][2024-04-20 15:07:08] 166:signal-handler (1713625628) Received SIGTERM scheduling shutdown...
baserow | [REDIS][2024-04-20 15:07:08] 166:M 20 Apr 2024 15:07:08.453 # User requested shutdown...
baserow | [REDIS][2024-04-20 15:07:08] 166:M 20 Apr 2024 15:07:08.453 # Redis is now ready to exit, bye bye...
baserow | 2024-04-20 15:07:08,454 INFO stopped: redis (exit status 0)
baserow | 2024-04-20 15:07:08,454 INFO stopped: redis (exit status 0)
baserow | [POSTGRES][2024-04-20 15:07:08] 2024-04-20 15:07:00.464 UTC [592] baserow@baserow FATAL: the database system is starting up
baserow | 2024-04-20 15:07:08,455 INFO reaped unknown pid 282 (exit status 0)
baserow | 2024-04-20 15:07:08,455 INFO reaped unknown pid 282 (exit status 0)
baserow | 2024-04-20 15:07:11,461 INFO waiting for processes, baserow-watcher, caddy, postgresql to die
baserow | 2024-04-20 15:07:11,461 INFO waiting for processes, baserow-watcher, caddy, postgresql to die
baserow | 2024-04-20 15:07:14,464 INFO waiting for processes, baserow-watcher, caddy, postgresql to die
baserow | 2024-04-20 15:07:14,464 INFO waiting for processes, baserow-watcher, caddy, postgresql to die
baserow | [BASEROW-WATCHER][2024-04-20 15:07:17] Waiting for Baserow to become available, this might take 30+ seconds...
baserow | 2024-04-20 15:07:18,107 INFO waiting for processes, baserow-watcher, caddy, postgresql to die
baserow | 2024-04-20 15:07:18,107 INFO waiting for processes, baserow-watcher, caddy, postgresql to die
baserow | 2024-04-20 15:07:21,110 INFO waiting for processes, baserow-watcher, caddy, postgresql to die
baserow | 2024-04-20 15:07:21,110 INFO waiting for processes, baserow-watcher, caddy, postgresql to die
baserow | 2024-04-20 15:07:24,115 INFO waiting for processes, baserow-watcher, caddy, postgresql to die
baserow | 2024-04-20 15:07:24,115 INFO waiting for processes, baserow-watcher, caddy, postgresql to die
baserow | [BASEROW-WATCHER][2024-04-20 15:07:27] Waiting for Baserow to become available, this might take 30+ seconds...
baserow | 2024-04-20 15:07:27,119 INFO waiting for processes, baserow-watcher, caddy, postgresql to die
baserow | 2024-04-20 15:07:27,119 INFO waiting for processes, baserow-watcher, caddy, postgresql to die
baserow | 2024-04-20 15:07:29,121 WARN killing 'postgresql' (165) with SIGKILL
baserow | 2024-04-20 15:07:29,121 WARN killing 'postgresql' (165) with SIGKILL
baserow | 2024-04-20 15:07:30,125 INFO stopped: postgresql (terminated by SIGKILL)
baserow | 2024-04-20 15:07:30,125 INFO stopped: postgresql (terminated by SIGKILL)
baserow | 2024-04-20 15:07:30,125 INFO waiting for processes, baserow-watcher, caddy to die
baserow | 2024-04-20 15:07:30,125 INFO waiting for processes, baserow-watcher, caddy to die
baserow | [CADDY][2024-04-20 15:07:30] {"level":"info","ts":1713625565.5156622,"logger":"tls","msg":"finished cleaning storage units"}
baserow | [CADDY][2024-04-20 15:07:30] {"level":"info","ts":1713625650.1259408,"msg":"shutting down apps, then terminating","signal":"SIGTERM"}
baserow | [CADDY][2024-04-20 15:07:30] {"level":"warn","ts":1713625650.1259615,"msg":"exiting; byeee!! 👋","signal":"SIGTERM"}
baserow | [CADDY][2024-04-20 15:07:30] {"level":"info","ts":1713625650.126005,"logger":"http","msg":"servers shutting down with eternal grace period"}
baserow | [CADDY][2024-04-20 15:07:30] {"level":"info","ts":1713625650.1262538,"logger":"admin","msg":"stopped previous server","address":"localhost:2019"}
baserow | [CADDY][2024-04-20 15:07:30] {"level":"info","ts":1713625650.1262808,"msg":"shutdown complete","signal":"SIGTERM","exit_code":0}
baserow | 2024-04-20 15:07:30,129 INFO stopped: caddy (exit status 0)
baserow | 2024-04-20 15:07:30,129 INFO stopped: caddy (exit status 0)
baserow | 2024-04-20 15:07:30,129 INFO reaped unknown pid 235 (exit status 0)
baserow | 2024-04-20 15:07:30,129 INFO reaped unknown pid 235 (exit status 0)
baserow | 2024-04-20 15:07:30,129 INFO stopped: baserow-watcher (terminated by SIGTERM)
baserow | 2024-04-20 15:07:30,129 INFO stopped: baserow-watcher (terminated by SIGTERM)
baserow | 2024-04-20 15:07:30,130 INFO stopped: processes (terminated by SIGTERM)
baserow | 2024-04-20 15:07:30,130 INFO stopped: processes (terminated by SIGTERM)
baserow exited with code 0
any help please! im newbie with this stuff and me and my collegues already added a lot of important info to the database, dont wana spend more time to build it again from scratch(`