[Bug]: unrecognized parameter "no_relocate" in file "/usr/share/postgresql/15/extension/ai.control" #844
Description
What happened?
postgres=# SELECT 1 FROM pg_catalog.pg_available_extensions;
ERROR: unrecognized parameter "no_relocate" in file "/usr/share/postgresql/15/extension/ai.control"
reproducible env:
docker run --rm -ti -e POSTGRES_PASSWORD=postgres docker.io/timescale/timescaledb-ha:pg15
pgai extension affected
No response
pgai library affected
No response
PostgreSQL version used
15.13
What operating system did you use?
Linux 08532f28226a 6.8.0-1026-gcp #28~22.04.1-Ubuntu
What installation method did you use?
Docker
What platform did you run on?
Google Cloud Platform (GCP)
Relevant log output and stack trace
The files belonging to this database system will be owned by user "postgres".
This user must also own the server process.
The database cluster will be initialized with locale "C.UTF-8".
The default database encoding has accordingly been set to "UTF8".
The default text search configuration will be set to "english".
Data page checksums are disabled.
fixing permissions on existing directory /home/postgres/pgdata/data ... ok
creating subdirectories ... ok
selecting dynamic shared memory implementation ... posix
selecting default max_connections ... 100
selecting default shared_buffers ... 128MB
selecting default time zone ... Etc/UTC
creating configuration files ... ok
running bootstrap script ...
ok
performing post-bootstrap initialization ...
ok
syncing data to disk ... ok
initdb: warning: enabling "trust" authentication for local connections
initdb: hint: You can change this by editing pg_hba.conf or using the option -A, or --auth-local and --auth-host, the next time you run initdb.
Success. You can now start the database server using:
pg_ctl -D /home/postgres/pgdata/data -l logfile start
waiting for server to start....2025-07-03 10:11:40.383 UTC [38] LOG: starting PostgreSQL 15.13 (Ubuntu 15.13-1.pgdg22.04+1) on x86_64-pc-linux-gnu, compiled by gcc (Ubuntu 11.4.0-1ubuntu1~22.04) 11.4.0, 64-bit
2025-07-03 10:11:40.384 UTC [38] LOG: listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"
2025-07-03 10:11:40.390 UTC [41] LOG: database system was shut down at 2025-07-03 10:11:39 UTC
2025-07-03 10:11:40.397 UTC [38] LOG: database system is ready to accept connections
2025-07-03 10:11:40.399 UTC [44] LOG: TimescaleDB background worker launcher connected to shared catalogs
done
server started
/docker-entrypoint.sh: sourcing /docker-entrypoint-initdb.d/000_install_timescaledb.sh
CREATE EXTENSION
CREATE EXTENSION
2025-07-03 10:11:40.842 UTC [59] ERROR: background worker "TimescaleDB Background Worker Scheduler for database 1" trying to connect to template database, exiting
/docker-entrypoint.sh: running /docker-entrypoint-initdb.d/001_timescaledb_tune.sh
Using postgresql.conf at this path:
/home/postgres/pgdata/data/postgresql.conf
Writing backup to:
/tmp/timescaledb_tune.backup202507031011
Recommendations based on 7.75 GB of available memory and 2 CPUs for PostgreSQL 15
shared_buffers = 1984MB
effective_cache_size = 5954MB
maintenance_work_mem = 1016229kB
work_mem = 10162kB
timescaledb.max_background_workers = 16
max_worker_processes = 21
max_parallel_workers_per_gather = 1
max_parallel_workers = 2
wal_buffers = 16MB
min_wal_size = 512MB
default_statistics_target = 100
random_page_cost = 1.1
checkpoint_completion_target = 0.9
max_locks_per_transaction = 128
autovacuum_max_workers = 10
autovacuum_naptime = 10
default_toast_compression = lz4
jit = off
effective_io_concurrency = 256
timescaledb.last_tuned = '2025-07-03T10:11:40Z'
timescaledb.last_tuned_version = '0.18.0'
Saving changes to: /home/postgres/pgdata/data/postgresql.conf
/docker-entrypoint.sh: running /docker-entrypoint-initdb.d/010_install_timescaledb_toolkit.sh
/docker-entrypoint-initdb.d/010_install_timescaledb_toolkit.sh: line 5: [: 15}: integer expression expected
CREATE EXTENSION
CREATE EXTENSION
2025-07-03 10:11:41.103 UTC [38] LOG: received fast shutdown request
waiting for server to shut down....2025-07-03 10:11:41.105 UTC [38] LOG: aborting any active transactions
2025-07-03 10:11:41.108 UTC [54] FATAL: terminating background worker "TimescaleDB Background Worker Scheduler" due to administrator command
2025-07-03 10:11:41.111 UTC [44] FATAL: terminating background worker "TimescaleDB Background Worker Launcher" due to administrator command
2025-07-03 10:11:41.114 UTC [38] LOG: background worker "TimescaleDB Background Worker Launcher" (PID 44) exited with exit code 1
2025-07-03 10:11:41.115 UTC [38] LOG: background worker "TimescaleDB Background Worker Scheduler" (PID 54) exited with exit code 1
2025-07-03 10:11:41.115 UTC [38] LOG: background worker "logical replication launcher" (PID 45) exited with exit code 1
2025-07-03 10:11:41.116 UTC [39] LOG: shutting down
2025-07-03 10:11:41.117 UTC [39] LOG: checkpoint starting: shutdown immediate
2025-07-03 10:11:41.300 UTC [39] LOG: checkpoint complete: wrote 1055 buffers (6.4%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.010 s, sync=0.170 s, total=0.185 s; sync files=430, longest=0.003 s, average=0.001 s; distance=8737 kB, estimate=8737 kB
2025-07-03 10:11:41.309 UTC [38] LOG: database system is shut down
done
server stopped
PostgreSQL init process complete; ready for start up.
2025-07-03 10:11:41.479 UTC [1] LOG: starting PostgreSQL 15.13 (Ubuntu 15.13-1.pgdg22.04+1) on x86_64-pc-linux-gnu, compiled by gcc (Ubuntu 11.4.0-1ubuntu1~22.04) 11.4.0, 64-bit
2025-07-03 10:11:41.479 UTC [1] LOG: listening on IPv4 address "0.0.0.0", port 5432
2025-07-03 10:11:41.479 UTC [1] LOG: listening on IPv6 address "::", port 5432
2025-07-03 10:11:41.482 UTC [1] LOG: listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"
2025-07-03 10:11:41.489 UTC [84] LOG: database system was shut down at 2025-07-03 10:11:41 UTC
2025-07-03 10:11:41.543 UTC [1] LOG: database system is ready to accept connections
2025-07-03 10:11:41.546 UTC [87] LOG: TimescaleDB background worker launcher connected to shared catalogs
2025-07-03 10:12:02.453 UTC [105] ERROR: unrecognized parameter "no_relocate" in file "/usr/share/postgresql/15/extension/ai.control"
2025-07-03 10:12:02.453 UTC [105] STATEMENT: SELECT 1 FROM pg_catalog.pg_available_extensions;
How can we reproduce the bug?
Just start the env with this docker image: `docker.io/timescale/timescaledb-ha:pg15`Are you going to work on the bugfix?
None