Please fill in the questionnaire below.
Technical Help Questionnaire
Have you read and followed the instructions at: *READ ME FIRST* Technical Help FAQs - #2 by nigel ?
Yes
Self-Hosted Installation and Setup Questions
Delete this section if you are using Baserow.io.
How have you self-hosted Baserow.
Portainer v2.19.3 on OpenSuse Leap 15.5 host running on a raspberry pi 4.
What are the specs of the service or server you are using to host Baserow.
Host has 8GB RAM with 4GB available
Which version of Baserow are you using.
dociker image baserow/baserow:1.22.0
How have you configured your self-hosted installation?
---
version: "2.1"
services:
baserow:
image: baserow/baserow:1.22.0
container_name: baserow
environment:
- TZ=America/Los_Angeles
- BASEROW_PUBLIC_URL='http://myhost.com:280'
volumes:
- data:/baserow/data
ports:
- 280:80 #changed from default 80
- 2443:443
restart: unless-stopped
volumes:
data:
What commands if any did you use to start your Baserow server?
Deployed successfully via Portainer, but errors were encountered in the baserow container log
Describe the problem
I see errors in the container log during initialization. The entire log is bigger than I can put into a single message, so I will split into several postings.
[STARTUP][2023-12-20 12:25:54] No DATABASE_HOST or DATABASE_URL provided, using embedded postgres.
[STARTUP][2023-12-20 12:25:54] Using embedded baserow redis as no REDIS_HOST or REDIS_URL provided.
[STARTUP][2023-12-20 12:25:54] Creating REDIS_PASSWORD secret in /baserow/data/.redispass
[STARTUP][2023-12-20 12:25:54] Importing REDIS_PASSWORD secret from /baserow/data/.redispass
[STARTUP][2023-12-20 12:25:54] Creating SECRET_KEY secret in /baserow/data/.secret
[STARTUP][2023-12-20 12:25:54] Importing SECRET_KEY secret from /baserow/data/.secret
[STARTUP][2023-12-20 12:25:54] Creating BASEROW_JWT_SIGNING_KEY secret in /baserow/data/.jwt_signing_key
[STARTUP][2023-12-20 12:25:54] Importing BASEROW_JWT_SIGNING_KEY secret from /baserow/data/.jwt_signing_key
[STARTUP][2023-12-20 12:25:54] Creating DATABASE_PASSWORD secret in /baserow/data/.pgpass
[STARTUP][2023-12-20 12:25:54] Importing DATABASE_PASSWORD secret from /baserow/data/.pgpass
=========================================================================================
██████╗ █████╗ ███████╗███████╗██████╗ ██████╗ ██╗ ██╗
██╔══██╗██╔══██╗██╔════╝██╔════╝██╔══██╗██╔═══██╗██║ ██║
██████╔╝███████║███████╗█████╗ ██████╔╝██║ ██║██║ █╗ ██║
██╔══██╗██╔══██║╚════██║██╔══╝ ██╔══██╗██║ ██║██║███╗██║
██████╔╝██║ ██║███████║███████╗██║ ██║╚██████╔╝╚███╔███╔╝
╚═════╝ ╚═╝ ╚═╝╚══════╝╚══════╝╚═╝ ╚═╝ ╚═════╝ ╚══╝╚══╝
Version 1.22.0
=========================================================================================
Welcome to Baserow. See https://baserow.io/installation/install-with-docker/ for detailed instructions on
how to use this Docker image.
[STARTUP][2023-12-20 12:25:54] Running setup of embedded baserow database.
[POSTGRES_INIT][2023-12-20 12:26:00] Becoming postgres superuser to run setup SQL commands:
[POSTGRES_INIT][2023-12-20 12:26:00] CREATE DATABASE
[POSTGRES_INIT][2023-12-20 12:26:00] CREATE ROLE
[POSTGRES_INIT][2023-12-20 12:26:00] GRANT
[POSTGRES_INIT][2023-12-20 12:26:00]
[POSTGRES_INIT][2023-12-20 12:26:00] PostgreSQL init process complete; ready for start up.
[POSTGRES_INIT][2023-12-20 12:26:00]
[STARTUP][2023-12-20 12:26:00] Starting Baserow using addresses http://semi.permeable.com:280/, if any are https automatically Caddy will attempt to setup HTTPS automatically.
[STARTUP][2023-12-20 12:26:00] Starting all Baserow processes:
2023-12-20 12:26:01,206 CRIT Supervisor is running as root. Privileges were not dropped because no user is specified in the config file. If you intend to run as root, you can set user=root in the config file to avoid this message.
2023-12-20 12:26:01,206 CRIT Supervisor is running as root. Privileges were not dropped because no user is specified in the config file. If you intend to run as root, you can set user=root in the config file to avoid this message.
2023-12-20 12:26:01,206 INFO Included extra file "/baserow/supervisor/includes/enabled/embedded-postgres.conf" during parsing
2023-12-20 12:26:01,206 INFO Included extra file "/baserow/supervisor/includes/enabled/embedded-postgres.conf" during parsing
2023-12-20 12:26:01,206 INFO Included extra file "/baserow/supervisor/includes/enabled/embedded-redis.conf" during parsing
2023-12-20 12:26:01,206 INFO Included extra file "/baserow/supervisor/includes/enabled/embedded-redis.conf" during parsing
2023-12-20 12:26:01,210 INFO supervisord started with pid 1
2023-12-20 12:26:01,210 INFO supervisord started with pid 1
2023-12-20 12:26:02,218 INFO spawned: 'processes' with pid 269
2023-12-20 12:26:02,218 INFO spawned: 'processes' with pid 269
2023-12-20 12:26:02,225 INFO spawned: 'baserow-watcher' with pid 270
2023-12-20 12:26:02,225 INFO spawned: 'baserow-watcher' with pid 270
2023-12-20 12:26:02,232 INFO spawned: 'caddy' with pid 271
2023-12-20 12:26:02,232 INFO spawned: 'caddy' with pid 271
2023-12-20 12:26:02,241 INFO spawned: 'postgresql' with pid 272
2023-12-20 12:26:02,241 INFO spawned: 'postgresql' with pid 272
2023-12-20 12:26:02,249 INFO spawned: 'redis' with pid 273
2023-12-20 12:26:02,249 INFO spawned: 'redis' with pid 273
2023-12-20 12:26:02,256 INFO spawned: 'backend' with pid 275
2023-12-20 12:26:02,256 INFO spawned: 'backend' with pid 275
2023-12-20 12:26:02,263 INFO spawned: 'celeryworker' with pid 277
2023-12-20 12:26:02,263 INFO spawned: 'celeryworker' with pid 277
2023-12-20 12:26:02,274 INFO spawned: 'exportworker' with pid 278
2023-12-20 12:26:02,274 INFO spawned: 'exportworker' with pid 278
2023-12-20 12:26:02,283 INFO spawned: 'webfrontend' with pid 281
2023-12-20 12:26:02,283 INFO spawned: 'webfrontend' with pid 281
2023-12-20 12:26:02,294 INFO spawned: 'beatworker' with pid 282
2023-12-20 12:26:02,294 INFO spawned: 'beatworker' with pid 282
2023-12-20 12:26:02,297 INFO reaped unknown pid 267 (exit status 0)
2023-12-20 12:26:02,297 INFO reaped unknown pid 267 (exit status 0)
[REDIS][2023-12-20 12:26:02] 273:C 20 Dec 2023 12:26:02.511 # oO0OoO0OoO0Oo Redis is starting oO0OoO0OoO0Oo
[REDIS][2023-12-20 12:26:02] 273:C 20 Dec 2023 12:26:02.511 # Redis version=6.0.16, bits=64, commit=00000000, modified=0, pid=273, just started
[REDIS][2023-12-20 12:26:02] 273:C 20 Dec 2023 12:26:02.511 # Configuration loaded
[REDIS][2023-12-20 12:26:02] 273:M 20 Dec 2023 12:26:02.531 * Running mode=standalone, port=6379.
[REDIS][2023-12-20 12:26:02] 273:M 20 Dec 2023 12:26:02.541 # Server initialized
[REDIS][2023-12-20 12:26:02] 273:M 20 Dec 2023 12:26:02.541 # WARNING overcommit_memory is set to 0! Background save may fail under low memory condition. To fix this issue add 'vm.overcommit_memory = 1' to /etc/sysctl.conf and then reboot or run the command 'sysctl vm.overcommit_memory=1' for this to take effect.
[REDIS][2023-12-20 12:26:02] 273:M 20 Dec 2023 12:26:02.541 # WARNING you have Transparent Huge Pages (THP) support enabled in your kernel. This will create latency and memory usage issues with Redis. To fix this issue run the command 'echo madvise > /sys/kernel/mm/transparent_hugepage/enabled' as root, and add it to your /etc/rc.local in order to retain the setting after a reboot. Redis must be restarted after THP is disabled (set to 'madvise' or 'never').
[CADDY][2023-12-20 12:26:02] {"level":"info","ts":1703103962.5929003,"msg":"using provided configuration","config_file":"/baserow/caddy/Caddyfile","config_adapter":""}
[CADDY][2023-12-20 12:26:02] {"level":"warn","ts":1703103962.6020608,"msg":"input is not formatted with 'caddy fmt'","adapter":"caddyfile","file":"/baserow/caddy/Caddyfile","line":2}
[CADDY][2023-12-20 12:26:02] {"level":"info","ts":1703103962.6178703,"logger":"admin","msg":"admin endpoint started","address":"tcp/localhost:2019","enforce_origin":false,"origins":["localhost:2019","[::1]:2019","127.0.0.1:2019"]}
[CADDY][2023-12-20 12:26:02] {"level":"info","ts":1703103962.6186807,"logger":"http","msg":"server is listening only on the HTTP port, so no automatic HTTPS will be applied to this server","server_name":"srv0","http_port":80}
[POSTGRES][2023-12-20 12:26:02] 2023-12-20 20:26:02.629 UTC [272] LOG: listening on IPv4 address "127.0.0.1", port 5432
[POSTGRES][2023-12-20 12:26:02] 2023-12-20 20:26:02.629 UTC [272] LOG: could not bind IPv6 address "::1": Cannot assign requested address
[CADDY][2023-12-20 12:26:02] {"level":"info","ts":1703103962.6215599,"logger":"tls.cache.maintenance","msg":"started background certificate maintenance","cache":"0x40001a0000"}
[CADDY][2023-12-20 12:26:02] {"level":"info","ts":1703103962.6337762,"logger":"tls","msg":"cleaning storage unit","description":"FileStorage:/baserow/data/caddy/data/caddy"}
[CADDY][2023-12-20 12:26:02] {"level":"info","ts":1703103962.633986,"logger":"tls","msg":"finished cleaning storage units"}
[CADDY][2023-12-20 12:26:02] {"level":"info","ts":1703103962.636469,"msg":"autosaved config (load with --resume flag)","file":"/baserow/data/caddy/config/caddy/autosave.json"}
[POSTGRES][2023-12-20 12:26:02] 2023-12-20 20:26:02.629 UTC [272] HINT: Is another postmaster already running on port 5432? If not, wait a few seconds and retry.
[POSTGRES][2023-12-20 12:26:02] 2023-12-20 20:26:02.645 UTC [272] LOG: listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"
[POSTGRES][2023-12-20 12:26:02] 2023-12-20 20:26:02.701 UTC [457] LOG: database system was shut down at 2023-12-20 20:26:00 UTC
[BEAT_WORKER][2023-12-20 12:26:02] OTEL_RESOURCE_ATTRIBUTES=service.namespace=Baserow,service.version=1.22.0,deployment.environment=unknown
[BACKEND][2023-12-20 12:26:03] OTEL_RESOURCE_ATTRIBUTES=service.namespace=Baserow,service.version=1.22.0,deployment.environment=unknown
[BACKEND][2023-12-20 12:26:03] PostgreSQL is available
2023-12-20 12:26:04,124 INFO success: processes entered RUNNING state, process has stayed up for > than 1 seconds (startsecs)
2023-12-20 12:26:04,124 INFO success: processes entered RUNNING state, process has stayed up for > than 1 seconds (startsecs)
2023-12-20 12:26:04,125 INFO success: baserow-watcher entered RUNNING state, process has stayed up for > than 1 seconds (startsecs)
2023-12-20 12:26:04,125 INFO success: baserow-watcher entered RUNNING state, process has stayed up for > than 1 seconds (startsecs)
[BASEROW-WATCHER][2023-12-20 12:26:12] Waiting for Baserow to become available, this might take 30+ seconds...
[BACKEND][2023-12-20 12:26:18] python /baserow/backend/src/baserow/manage.py locked_migrate
[BACKEND][2023-12-20 12:26:18] 2023-12-20 20:26:18.483 | INFO | baserow.core.management.commands.locked_migrate:acquire_lock:54 - Attempting to lock the postgres advisory lock with id: 123456 You can disable using locked_migrate by default and switch back to the non-locking version by setting BASEROW_DISABLE_LOCKED_MIGRATIONS=true
[BEAT_WORKER][2023-12-20 12:26:21] Sleeping for 15 before starting beat to prevent startup errors.
[CELERY_WORKER][2023-12-20 12:26:22] OTEL_RESOURCE_ATTRIBUTES=service.namespace=Baserow,service.version=1.22.0,deployment.environment=unknown
[CELERY_WORKER][2023-12-20 12:26:22]
[CELERY_WORKER][2023-12-20 12:26:22] -------------- default-worker@df658564bd78 v5.2.7 (dawn-chorus)
[CELERY_WORKER][2023-12-20 12:26:22] --- ***** -----
[CELERY_WORKER][2023-12-20 12:26:22] -- ******* ---- Linux-5.14.21-150500.55.39-default-aarch64-with-glibc2.31 2023-12-20 20:26:22
[CELERY_WORKER][2023-12-20 12:26:22] - *** --- * ---
[CELERY_WORKER][2023-12-20 12:26:22] - ** ---------- [config]
[CELERY_WORKER][2023-12-20 12:26:22] - ** ---------- .> app: baserow:0xffff9b307760
[CELERY_WORKER][2023-12-20 12:26:22] - ** ---------- .> transport: redis://:**@localhost:6379/0
[CELERY_WORKER][2023-12-20 12:26:22] - ** ---------- .> results: disabled://
[CELERY_WORKER][2023-12-20 12:26:22] - *** --- * --- .> concurrency: 1 (prefork)
[CELERY_WORKER][2023-12-20 12:26:22] -- ******* ---- .> task events: OFF (enable -E to monitor tasks in this worker)
[CELERY_WORKER][2023-12-20 12:26:22] --- ***** -----
[CELERY_WORKER][2023-12-20 12:26:22] -------------- [queues]
[CELERY_WORKER][2023-12-20 12:26:22] .> celery exchange=celery(direct) key=celery
[CELERY_WORKER][2023-12-20 12:26:22]
[CELERY_WORKER][2023-12-20 12:26:22]
[CELERY_WORKER][2023-12-20 12:26:22] [tasks]
[CELERY_WORKER][2023-12-20 12:26:22] . baserow.contrib.database.export.tasks.clean_up_old_jobs
[CELERY_WORKER][2023-12-20 12:26:22] . baserow.contrib.database.export.tasks.run_export_job
[CELERY_WORKER][2023-12-20 12:26:22] . baserow.contrib.database.fields.tasks.run_periodic_fields_updates
[CELERY_WORKER][2023-12-20 12:26:22] . baserow.contrib.database.rows.tasks.clean_up_row_history_entries
[CELERY_WORKER][2023-12-20 12:26:22] . baserow.contrib.database.search.tasks.async_update_tsvector_columns
[CELERY_WORKER][2023-12-20 12:26:22] . baserow.contrib.database.table.tasks.run_row_count_job
[CELERY_WORKER][2023-12-20 12:26:22] . baserow.contrib.database.table.tasks.setup_created_by_and_last_modified_by_column
[CELERY_WORKER][2023-12-20 12:26:22] . baserow.contrib.database.table.tasks.setup_new_background_update_and_search_columns
[CELERY_WORKER][2023-12-20 12:26:22] . baserow.contrib.database.table.tasks.unsubscribe_user_from_tables_when_removed_from_workspace
[CELERY_WORKER][2023-12-20 12:26:22] . baserow.contrib.database.views.tasks._check_for_pending_view_index_updates
[CELERY_WORKER][2023-12-20 12:26:22] . baserow.contrib.database.views.tasks.update_view_index
[CELERY_WORKER][2023-12-20 12:26:22] . baserow.contrib.database.webhooks.tasks.call_webhook
[CELERY_WORKER][2023-12-20 12:26:22] . baserow.core.action.tasks.cleanup_old_actions
[CELERY_WORKER][2023-12-20 12:26:22] . baserow.core.jobs.tasks.clean_up_jobs
[CELERY_WORKER][2023-12-20 12:26:22] . baserow.core.jobs.tasks.run_async_job
[CELERY_WORKER][2023-12-20 12:26:22] . baserow.core.notifications.tasks.beat_send_instant_notifications_summary_by_email
[CELERY_WORKER][2023-12-20 12:26:22] . baserow.core.notifications.tasks.send_daily_and_weekly_notifications_summary_by_email
[CELERY_WORKER][2023-12-20 12:26:22] . baserow.core.notifications.tasks.send_queued_notifications_to_users
[CELERY_WORKER][2023-12-20 12:26:22] . baserow.core.notifications.tasks.singleton_send_instant_notifications_summary_by_email
[CELERY_WORKER][2023-12-20 12:26:22] . baserow.core.snapshots.tasks.delete_application_snapshot
[CELERY_WORKER][2023-12-20 12:26:22] . baserow.core.snapshots.tasks.delete_expired_snapshots
[CELERY_WORKER][2023-12-20 12:26:22] . baserow.core.tasks.sync_templates_task
[CELERY_WORKER][2023-12-20 12:26:22] . baserow.core.trash.tasks.mark_old_trash_for_permanent_deletion
[CELERY_WORKER][2023-12-20 12:26:22] . baserow.core.trash.tasks.permanently_delete_marked_trash
[CELERY_WORKER][2023-12-20 12:26:22] . baserow.core.usage.tasks.run_calculate_storage
[CELERY_WORKER][2023-12-20 12:26:22] . baserow.core.user.tasks.check_pending_account_deletion
[CELERY_WORKER][2023-12-20 12:26:22] . baserow.core.user.tasks.flush_expired_tokens
[CELERY_WORKER][2023-12-20 12:26:22] . baserow.ws.tasks.broadcast_application_created