Package: src:postgresql-16
Version: 16.4-1
Severity: serious
Tags: ftbfs
Dear maintainer:
During a rebuild of all packages in unstable, your package failed to build:
--------------------------------------------------------------------------------
[...]
debian/rules binary
dh binary
dh_update_autotools_config
cp: warning: behavior of -n is non-portable and may change in future; use
--update=none instead
cp: warning: behavior of -n is non-portable and may change in future; use
--update=none instead
dh_autoreconf
configure.ac:373: warning: The macro 'AC_PROG_CC_C99' is obsolete.
configure.ac:373: You should run autoupdate.
./lib/autoconf/c.m4:1662: AC_PROG_CC_C99 is expanded from...
configure.ac:373: the top level
configure.ac:1248: warning: $as_echo is obsolete; use AS_ECHO(["message"])
instead
lib/m4sugar/m4sh.m4:690: _AS_IF_ELSE is expanded from...
lib/m4sugar/m4sh.m4:697: AS_IF is expanded from...
./lib/autoconf/general.m4:2249: AC_CACHE_VAL is expanded from...
[... snipped ...]
new relfrozenxid: 18113, which is 11859 XIDs ahead of previous value
new relminmxid: 3, which is 2 MXIDs ahead of previous value
frozen: 0 pages from table (0.00% of total) had 0 tuples frozen
index scan needed: 4 pages from table (100.00% of total) had 163 dead
item identifiers removed
index "pg_authid_rolname_index": pages: 2 in total, 0 newly deleted, 0
currently deleted, 0 reusable
index "pg_authid_oid_index": pages: 2 in total, 0 newly deleted, 0
currently deleted, 0 reusable
avg read rate: 0.000 MB/s, avg write rate: 202.683 MB/s
buffer usage: 51 hits, 0 misses, 11 dirtied
WAL usage: 17 records, 8 full page images, 19962 bytes
system usage: CPU: user: 0.00 s, system: 0.00 s, elapsed: 0.00 s
2024-10-06 17:27:46.142 UTC client backend[252076] pg_regress/indexing ERROR: duplicate
key value violates unique constraint "covidxpart1_a_b_idx"
2024-10-06 17:27:46.142 UTC client backend[252076] pg_regress/indexing DETAIL:
Key (a)=(1) already exists.
2024-10-06 17:27:46.142 UTC client backend[252076] pg_regress/indexing
STATEMENT: insert into covidxpart values (1, 1);
2024-10-06 17:27:46.144 UTC client backend[252076] pg_regress/indexing ERROR: duplicate
key value violates unique constraint "covidxpart3_a_b_idx"
2024-10-06 17:27:46.144 UTC client backend[252076] pg_regress/indexing DETAIL:
Key (a)=(3) already exists.
2024-10-06 17:27:46.144 UTC client backend[252076] pg_regress/indexing
STATEMENT: insert into covidxpart values (3, 1);
2024-10-06 17:27:46.145 UTC client backend[252076] pg_regress/indexing ERROR: duplicate
key value violates unique constraint "covidxpart4_a_b_idx"
2024-10-06 17:27:46.145 UTC client backend[252076] pg_regress/indexing DETAIL:
Key (a)=(4) already exists.
2024-10-06 17:27:46.145 UTC client backend[252076] pg_regress/indexing
STATEMENT: insert into covidxpart values (4, 1);
2024-10-06 17:27:46.146 UTC client backend[252076] pg_regress/indexing ERROR:
unique constraint on partitioned table must include all partitioning columns
2024-10-06 17:27:46.146 UTC client backend[252076] pg_regress/indexing DETAIL: UNIQUE constraint
on table "covidxpart" lacks column "a" which is part of the partition key.
2024-10-06 17:27:46.146 UTC client backend[252076] pg_regress/indexing
STATEMENT: create unique index on covidxpart (b) include (a);
2024-10-06 17:27:46.146 UTC client backend[252076] pg_regress/indexing ERROR: cannot drop
inherited constraint "parted_pk_detach_test1_pkey" of relation
"parted_pk_detach_test1"
2024-10-06 17:27:46.146 UTC client backend[252076] pg_regress/indexing
STATEMENT: alter table parted_pk_detach_test1 drop constraint
parted_pk_detach_test1_pkey;
2024-10-06 17:27:46.147 UTC autovacuum worker[252162] LOG: automatic analyze of table
"postgres.pg_catalog.pg_authid"
avg read rate: 40.039 MB/s, avg write rate: 3.906 MB/s
buffer usage: 482 hits, 41 misses, 4 dirtied
system usage: CPU: user: 0.00 s, system: 0.00 s, elapsed: 0.00 s
2024-10-06 17:27:46.148 UTC client backend[252076] pg_regress/indexing ERROR: cannot drop
inherited constraint "parted_uniq_detach_test1_a_key" of relation
"parted_uniq_detach_test1"
2024-10-06 17:27:46.148 UTC client backend[252076] pg_regress/indexing
STATEMENT: alter table parted_uniq_detach_test1 drop constraint
parted_uniq_detach_test1_a_key;
2024-10-06 17:27:46.150 UTC autovacuum worker[252162] LOG: automatic analyze of table
"postgres.pg_catalog.pg_subscription"
avg read rate: 15.625 MB/s, avg write rate: 2.604 MB/s
buffer usage: 205 hits, 6 misses, 1 dirtied
system usage: CPU: user: 0.00 s, system: 0.00 s, elapsed: 0.00 s
2024-10-06 17:27:46.150 UTC autovacuum worker[252162] LOG: automatic vacuum of table
"postgres.pg_catalog.pg_auth_members": index scans: 1
pages: 0 removed, 1 remain, 1 scanned (100.00% of total)
tuples: 99 removed, 3 remain, 0 are dead but not yet removable
removable cutoff: 18148, which was 1 XIDs old when operation ended
new relfrozenxid: 18148, which is 11883 XIDs ahead of previous value
new relminmxid: 3, which is 2 MXIDs ahead of previous value
frozen: 0 pages from table (0.00% of total) had 0 tuples frozen
index scan needed: 1 pages from table (100.00% of total) had 89 dead
item identifiers removed
index "pg_auth_members_role_member_index": pages: 2 in total, 0 newly
deleted, 0 currently deleted, 0 reusable
index "pg_auth_members_member_role_index": pages: 2 in total, 0 newly
deleted, 0 currently deleted, 0 reusable
index "pg_auth_members_grantor_index": pages: 2 in total, 0 newly
deleted, 0 currently deleted, 0 reusable
index "pg_auth_members_oid_index": pages: 2 in total, 0 newly deleted,
0 currently deleted, 0 reusable
avg read rate: 0.000 MB/s, avg write rate: 343.947 MB/s
buffer usage: 54 hits, 0 misses, 7 dirtied
WAL usage: 8 records, 7 full page images, 17655 bytes
system usage: CPU: user: 0.00 s, system: 0.00 s, elapsed: 0.00 s
2024-10-06 17:27:46.152 UTC autovacuum worker[252162] LOG: automatic analyze of table
"postgres.pg_catalog.pg_auth_members"
avg read rate: 7.812 MB/s, avg write rate: 7.812 MB/s
buffer usage: 83 hits, 3 misses, 3 dirtied
system usage: CPU: user: 0.00 s, system: 0.00 s, elapsed: 0.00 s
2024-10-06 17:27:46.155 UTC autovacuum worker[252162] LOG: automatic vacuum of table
"postgres.pg_catalog.pg_shdepend": index scans: 1
pages: 4 removed, 0 remain, 4 scanned (100.00% of total)
tuples: 137 removed, 0 remain, 0 are dead but not yet removable
removable cutoff: 18152, which was 2 XIDs old when operation ended
new relfrozenxid: 18152, which is 17430 XIDs ahead of previous value
new relminmxid: 3, which is 2 MXIDs ahead of previous value
frozen: 0 pages from table (0.00% of total) had 0 tuples frozen
index scan needed: 4 pages from table (100.00% of total) had 856 dead
item identifiers removed
index "pg_shdepend_depender_index": pages: 4 in total, 1 newly deleted,
1 currently deleted, 0 reusable
index "pg_shdepend_reference_index": pages: 2 in total, 0 newly
deleted, 0 currently deleted, 0 reusable
avg read rate: 0.000 MB/s, avg write rate: 44.936 MB/s
buffer usage: 85 hits, 0 misses, 14 dirtied
WAL usage: 21 records, 10 full page images, 25263 bytes
system usage: CPU: user: 0.00 s, system: 0.00 s, elapsed: 0.00 s
2024-10-06 17:27:46.155 UTC autovacuum worker[252162] LOG: automatic analyze of table
"postgres.pg_catalog.pg_shdepend"
avg read rate: 0.000 MB/s, avg write rate: 0.000 MB/s
buffer usage: 22 hits, 0 misses, 0 dirtied
system usage: CPU: user: 0.00 s, system: 0.00 s, elapsed: 0.00 s
2024-10-06 17:27:46.394 UTC client backend[252076] pg_regress/indexing ERROR:
division by zero
2024-10-06 17:27:46.394 UTC client backend[252076] pg_regress/indexing
STATEMENT: create index concurrently parted_isvalid_idx_11 on
parted_isvalid_tab_11 ((a/b));
2024-10-06 17:27:46.440 UTC client backend[252193] pg_regress/event_trigger
ERROR: function pg_backend_pid must return type event_trigger
2024-10-06 17:27:46.440 UTC client backend[252193] pg_regress/event_trigger
STATEMENT: create event trigger regress_event_trigger
on ddl_command_start
execute procedure pg_backend_pid();
2024-10-06 17:27:46.458 UTC client backend[252193] pg_regress/event_trigger
ERROR: trigger functions can only be called as triggers
2024-10-06 17:27:46.458 UTC client backend[252193] pg_regress/event_trigger CONTEXT:
compilation of PL/pgSQL function "test_event_trigger" near line 1
2024-10-06 17:27:46.458 UTC client backend[252193] pg_regress/event_trigger
STATEMENT: SELECT test_event_trigger();
2024-10-06 17:27:46.459 UTC client backend[252193] pg_regress/event_trigger
ERROR: event trigger functions cannot have declared arguments
2024-10-06 17:27:46.459 UTC client backend[252193] pg_regress/event_trigger CONTEXT:
compilation of PL/pgSQL function "test_event_trigger_arg" near line 1
2024-10-06 17:27:46.459 UTC client backend[252193] pg_regress/event_trigger
STATEMENT: create function test_event_trigger_arg(name text)
returns event_trigger as $$ BEGIN RETURN 1; END $$ language plpgsql;
2024-10-06 17:27:46.459 UTC client backend[252193] pg_regress/event_trigger
ERROR: SQL functions cannot return type event_trigger
2024-10-06 17:27:46.459 UTC client backend[252193] pg_regress/event_trigger
STATEMENT: create function test_event_trigger_sql() returns event_trigger as $$
SELECT 1 $$ language sql;
2024-10-06 17:27:46.459 UTC client backend[252193] pg_regress/event_trigger ERROR:
unrecognized event name "elephant_bootstrap"
2024-10-06 17:27:46.459 UTC client backend[252193] pg_regress/event_trigger
STATEMENT: create event trigger regress_event_trigger on elephant_bootstrap
execute procedure test_event_trigger();
2024-10-06 17:27:46.459 UTC client backend[252193] pg_regress/event_trigger ERROR:
unrecognized filter variable "food"
2024-10-06 17:27:46.459 UTC client backend[252193] pg_regress/event_trigger
STATEMENT: create event trigger regress_event_trigger2 on ddl_command_start
when food in ('sandwich')
execute procedure test_event_trigger();
2024-10-06 17:27:46.459 UTC client backend[252193] pg_regress/event_trigger ERROR: filter value
"sandwich" not recognized for filter variable "tag"
2024-10-06 17:27:46.459 UTC client backend[252193] pg_regress/event_trigger
STATEMENT: create event trigger regress_event_trigger2 on ddl_command_start
when tag in ('sandwich')
execute procedure test_event_trigger();
2024-10-06 17:27:46.460 UTC client backend[252193] pg_regress/event_trigger ERROR: filter value
"create skunkcabbage" not recognized for filter variable "tag"
2024-10-06 17:27:46.460 UTC client backend[252193] pg_regress/event_trigger
STATEMENT: create event trigger regress_event_trigger2 on ddl_command_start
when tag in ('create table', 'create skunkcabbage')
execute procedure test_event_trigger();
2024-10-06 17:27:46.460 UTC client backend[252193] pg_regress/event_trigger
ERROR: event triggers are not supported for DROP EVENT TRIGGER
2024-10-06 17:27:46.460 UTC client backend[252193] pg_regress/event_trigger
STATEMENT: create event trigger regress_event_trigger2 on ddl_command_start
when tag in ('DROP EVENT TRIGGER')
execute procedure test_event_trigger();
2024-10-06 17:27:46.460 UTC client backend[252193] pg_regress/event_trigger
ERROR: event triggers are not supported for CREATE ROLE
2024-10-06 17:27:46.460 UTC client backend[252193] pg_regress/event_trigger
STATEMENT: create event trigger regress_event_trigger2 on ddl_command_start
when tag in ('CREATE ROLE')
execute procedure test_event_trigger();
2024-10-06 17:27:46.460 UTC client backend[252193] pg_regress/event_trigger
ERROR: event triggers are not supported for CREATE DATABASE
2024-10-06 17:27:46.460 UTC client backend[252193] pg_regress/event_trigger
STATEMENT: create event trigger regress_event_trigger2 on ddl_command_start
when tag in ('CREATE DATABASE')
execute procedure test_event_trigger();
2024-10-06 17:27:46.460 UTC client backend[252193] pg_regress/event_trigger
ERROR: event triggers are not supported for CREATE TABLESPACE
2024-10-06 17:27:46.460 UTC client backend[252193] pg_regress/event_trigger
STATEMENT: create event trigger regress_event_trigger2 on ddl_command_start
when tag in ('CREATE TABLESPACE')
execute procedure test_event_trigger();
2024-10-06 17:27:46.460 UTC client backend[252193] pg_regress/event_trigger ERROR:
filter variable "tag" specified more than once
2024-10-06 17:27:46.460 UTC client backend[252193] pg_regress/event_trigger
STATEMENT: create event trigger regress_event_trigger2 on ddl_command_start
when tag in ('create table') and tag in ('CREATE FUNCTION')
execute procedure test_event_trigger();
2024-10-06 17:27:46.460 UTC client backend[252193] pg_regress/event_trigger ERROR:
syntax error at or near "'argument not allowed'" at character 106
2024-10-06 17:27:46.460 UTC client backend[252193] pg_regress/event_trigger
STATEMENT: create event trigger regress_event_trigger2 on ddl_command_start
execute procedure test_event_trigger('argument not allowed');
2024-10-06 17:27:46.460 UTC client backend[252193] pg_regress/event_trigger ERROR:
permission denied to create event trigger "regress_event_trigger_noperms"
2024-10-06 17:27:46.460 UTC client backend[252193] pg_regress/event_trigger
HINT: Must be superuser to create an event trigger.
2024-10-06 17:27:46.460 UTC client backend[252193] pg_regress/event_trigger
STATEMENT: create event trigger regress_event_trigger_noperms on
ddl_command_start
execute procedure test_event_trigger();
2024-10-06 17:27:46.465 UTC client backend[252193] pg_regress/event_trigger ERROR:
permission denied to change owner of event trigger "regress_event_trigger"
2024-10-06 17:27:46.465 UTC client backend[252193] pg_regress/event_trigger
HINT: The owner of an event trigger must be a superuser.
2024-10-06 17:27:46.465 UTC client backend[252193] pg_regress/event_trigger
STATEMENT: alter event trigger regress_event_trigger owner to regress_evt_user;
2024-10-06 17:27:46.466 UTC client backend[252193] pg_regress/event_trigger ERROR: event
trigger "regress_event_trigger2" already exists
2024-10-06 17:27:46.466 UTC client backend[252193] pg_regress/event_trigger
STATEMENT: alter event trigger regress_event_trigger rename to
regress_event_trigger2;
2024-10-06 17:27:46.466 UTC client backend[252193] pg_regress/event_trigger ERROR: event
trigger "regress_event_trigger" does not exist
2024-10-06 17:27:46.466 UTC client backend[252193] pg_regress/event_trigger
STATEMENT: drop event trigger regress_event_trigger;
2024-10-06 17:27:46.466 UTC client backend[252193] pg_regress/event_trigger ERROR: role
"regress_evt_user" cannot be dropped because some objects depend on it
2024-10-06 17:27:46.466 UTC client backend[252193] pg_regress/event_trigger
DETAIL: owner of event trigger regress_event_trigger3
owner of user mapping for regress_evt_user on server useless_server
owner of default privileges on new relations belonging to role
regress_evt_user
2024-10-06 17:27:46.466 UTC client backend[252193] pg_regress/event_trigger
STATEMENT: drop role regress_evt_user;
2024-10-06 17:27:46.492 UTC client backend[252193] pg_regress/event_trigger
ERROR: object audit_tbls.schema_two_table_three of type table cannot be dropped
2024-10-06 17:27:46.492 UTC client backend[252193] pg_regress/event_trigger
CONTEXT: PL/pgSQL function undroppable() line 14 at RAISE
SQL statement "DROP TABLE IF EXISTS audit_tbls.schema_two_table_three"
PL/pgSQL function test_evtrig_dropped_objects() line 8 at EXECUTE
2024-10-06 17:27:46.492 UTC client backend[252193] pg_regress/event_trigger
STATEMENT: DROP SCHEMA schema_one, schema_two CASCADE;
2024-10-06 17:27:46.523 UTC client backend[252193] pg_regress/event_trigger
ERROR: object schema_one.table_three of type table cannot be dropped
2024-10-06 17:27:46.523 UTC client backend[252193] pg_regress/event_trigger
CONTEXT: PL/pgSQL function undroppable() line 14 at RAISE
2024-10-06 17:27:46.523 UTC client backend[252193] pg_regress/event_trigger
STATEMENT: DROP SCHEMA schema_one, schema_two CASCADE;
2024-10-06 17:27:46.567 UTC client backend[252193] pg_regress/event_trigger
ERROR: pg_event_trigger_table_rewrite_oid() can only be called in a
table_rewrite event trigger function
2024-10-06 17:27:46.567 UTC client backend[252193] pg_regress/event_trigger
STATEMENT: select pg_event_trigger_table_rewrite_oid();
2024-10-06 17:27:46.570 UTC client backend[252193] pg_regress/event_trigger
ERROR: rewrites not allowed
2024-10-06 17:27:46.570 UTC client backend[252193] pg_regress/event_trigger
CONTEXT: PL/pgSQL function test_evtrig_no_rewrite() line 3 at RAISE
2024-10-06 17:27:46.570 UTC client backend[252193] pg_regress/event_trigger
STATEMENT: alter table rewriteme alter column foo type numeric;
2024-10-06 17:27:46.579 UTC client backend[252193] pg_regress/event_trigger ERROR: cannot alter
type "rewritetype" because column "rewritemetoo3.a" uses it
2024-10-06 17:27:46.579 UTC client backend[252193] pg_regress/event_trigger
STATEMENT: alter type rewritetype alter attribute a type varchar cascade;
2024-10-06 17:27:47.316 UTC client backend[252208] pg_regress/tablespace ERROR:
tablespace location must be an absolute path
2024-10-06 17:27:47.316 UTC client backend[252208] pg_regress/tablespace
STATEMENT: CREATE TABLESPACE regress_tblspace LOCATION 'relative';
2024-10-06 17:27:47.316 UTC client backend[252208] pg_regress/tablespace ERROR:
tablespace location must be an absolute path
2024-10-06 17:27:47.316 UTC client backend[252208] pg_regress/tablespace
STATEMENT: CREATE TABLESPACE regress_tblspace LOCATION '';
2024-10-06 17:27:47.316 UTC client backend[252208] pg_regress/tablespace ERROR:
unrecognized parameter "some_nonexistent_parameter"
2024-10-06 17:27:47.316 UTC client backend[252208] pg_regress/tablespace
STATEMENT: CREATE TABLESPACE regress_tblspacewith LOCATION '' WITH
(some_nonexistent_parameter = true);
2024-10-06 17:27:47.337 UTC client backend[252208] pg_regress/tablespace ERROR:
unrecognized parameter "some_nonexistent_parameter"
2024-10-06 17:27:47.337 UTC client backend[252208] pg_regress/tablespace
STATEMENT: ALTER TABLESPACE regress_tblspace SET (some_nonexistent_parameter =
true);
2024-10-06 17:27:47.337 UTC client backend[252208] pg_regress/tablespace ERROR:
RESET must not include values for parameters
2024-10-06 17:27:47.337 UTC client backend[252208] pg_regress/tablespace
STATEMENT: ALTER TABLESPACE regress_tblspace RESET (random_page_cost = 2.0);
2024-10-06 17:27:47.337 UTC client backend[252208] pg_regress/tablespace ERROR: cannot
move system relation "pg_am_name_index"
2024-10-06 17:27:47.337 UTC client backend[252208] pg_regress/tablespace
STATEMENT: REINDEX (TABLESPACE regress_tblspace) TABLE pg_am;
2024-10-06 17:27:47.337 UTC client backend[252208] pg_regress/tablespace ERROR:
cannot reindex system catalogs concurrently
2024-10-06 17:27:47.337 UTC client backend[252208] pg_regress/tablespace
STATEMENT: REINDEX (TABLESPACE regress_tblspace) TABLE CONCURRENTLY pg_am;
2024-10-06 17:27:47.337 UTC client backend[252208] pg_regress/tablespace ERROR: cannot
move system relation "pg_authid_rolname_index"
2024-10-06 17:27:47.337 UTC client backend[252208] pg_regress/tablespace
STATEMENT: REINDEX (TABLESPACE regress_tblspace) TABLE pg_authid;
2024-10-06 17:27:47.337 UTC client backend[252208] pg_regress/tablespace ERROR:
cannot reindex system catalogs concurrently
2024-10-06 17:27:47.337 UTC client backend[252208] pg_regress/tablespace
STATEMENT: REINDEX (TABLESPACE regress_tblspace) TABLE CONCURRENTLY pg_authid;
2024-10-06 17:27:47.338 UTC client backend[252208] pg_regress/tablespace ERROR: cannot
move system relation "pg_toast_1260_index"
2024-10-06 17:27:47.338 UTC client backend[252208] pg_regress/tablespace
STATEMENT: REINDEX (TABLESPACE regress_tblspace) INDEX
pg_toast.pg_toast_1260_index;
2024-10-06 17:27:47.338 UTC client backend[252208] pg_regress/tablespace ERROR:
cannot reindex system catalogs concurrently
2024-10-06 17:27:47.338 UTC client backend[252208] pg_regress/tablespace
STATEMENT: REINDEX (TABLESPACE regress_tblspace) INDEX CONCURRENTLY
pg_toast.pg_toast_1260_index;
2024-10-06 17:27:47.338 UTC client backend[252208] pg_regress/tablespace ERROR: cannot
move system relation "pg_toast_1260_index"
2024-10-06 17:27:47.338 UTC client backend[252208] pg_regress/tablespace
STATEMENT: REINDEX (TABLESPACE regress_tblspace) TABLE pg_toast.pg_toast_1260;
2024-10-06 17:27:47.338 UTC client backend[252208] pg_regress/tablespace ERROR:
cannot reindex system catalogs concurrently
2024-10-06 17:27:47.338 UTC client backend[252208] pg_regress/tablespace
STATEMENT: REINDEX (TABLESPACE regress_tblspace) TABLE CONCURRENTLY
pg_toast.pg_toast_1260;
2024-10-06 17:27:47.338 UTC client backend[252208] pg_regress/tablespace ERROR: cannot
move system relation "pg_authid_rolname_index"
2024-10-06 17:27:47.338 UTC client backend[252208] pg_regress/tablespace
STATEMENT: REINDEX (TABLESPACE pg_global) TABLE pg_authid;
2024-10-06 17:27:47.338 UTC client backend[252208] pg_regress/tablespace ERROR:
cannot reindex system catalogs concurrently
2024-10-06 17:27:47.338 UTC client backend[252208] pg_regress/tablespace
STATEMENT: REINDEX (TABLESPACE pg_global) TABLE CONCURRENTLY pg_authid;
2024-10-06 17:27:47.341 UTC client backend[252208] pg_regress/tablespace ERROR:
only shared relations can be placed in pg_global tablespace
2024-10-06 17:27:47.341 UTC client backend[252208] pg_regress/tablespace
STATEMENT: REINDEX (TABLESPACE pg_global) INDEX regress_tblspace_test_tbl_idx;
2024-10-06 17:27:47.341 UTC client backend[252208] pg_regress/tablespace ERROR: cannot
move non-shared relation to tablespace "pg_global"
2024-10-06 17:27:47.341 UTC client backend[252208] pg_regress/tablespace
STATEMENT: REINDEX (TABLESPACE pg_global) INDEX CONCURRENTLY
regress_tblspace_test_tbl_idx;
2024-10-06 17:27:47.476 UTC client backend[252208] pg_regress/tablespace ERROR:
only shared relations can be placed in pg_global tablespace
2024-10-06 17:27:47.476 UTC client backend[252208] pg_regress/tablespace
STATEMENT: CREATE TABLE testschema.part_1 PARTITION OF testschema.part FOR
VALUES IN (1);
2024-10-06 17:27:47.477 UTC client backend[252208] pg_regress/tablespace ERROR:
only shared relations can be placed in pg_global tablespace
2024-10-06 17:27:47.477 UTC client backend[252208] pg_regress/tablespace
STATEMENT: CREATE TABLE testschema.part_3 PARTITION OF testschema.part FOR
VALUES IN (3);
2024-10-06 17:27:47.478 UTC client backend[252208] pg_regress/tablespace ERROR:
only shared relations can be placed in pg_global tablespace
2024-10-06 17:27:47.478 UTC client backend[252208] pg_regress/tablespace
STATEMENT: CREATE TABLE testschema.part_78 PARTITION OF testschema.part FOR
VALUES IN (7, 8)
PARTITION BY LIST (a);
2024-10-06 17:27:47.777 UTC client backend[252208] pg_regress/tablespace ERROR:
cannot specify default tablespace for partitioned relations
2024-10-06 17:27:47.777 UTC client backend[252208] pg_regress/tablespace
STATEMENT: CREATE TABLE testschema.dflt (a int PRIMARY KEY) PARTITION BY LIST
(a) TABLESPACE pg_default;
2024-10-06 17:27:47.777 UTC client backend[252208] pg_regress/tablespace ERROR:
cannot specify default tablespace for partitioned relations
2024-10-06 17:27:47.777 UTC client backend[252208] pg_regress/tablespace
STATEMENT: CREATE TABLE testschema.dflt (a int PRIMARY KEY USING INDEX
TABLESPACE pg_default) PARTITION BY LIST (a);
2024-10-06 17:27:47.777 UTC client backend[252208] pg_regress/tablespace ERROR:
cannot specify default tablespace for partitioned relations
2024-10-06 17:27:47.777 UTC client backend[252208] pg_regress/tablespace
STATEMENT: CREATE TABLE testschema.dflt (a int PRIMARY KEY) PARTITION BY LIST
(a) TABLESPACE regress_tblspace;
2024-10-06 17:27:47.778 UTC client backend[252208] pg_regress/tablespace ERROR:
cannot specify default tablespace for partitioned relations
2024-10-06 17:27:47.778 UTC client backend[252208] pg_regress/tablespace
STATEMENT: CREATE TABLE testschema.dflt (a int PRIMARY KEY USING INDEX
TABLESPACE regress_tblspace) PARTITION BY LIST (a);
2024-10-06 17:27:48.926 UTC client backend[252208] pg_regress/tablespace ERROR:
only shared relations can be placed in pg_global tablespace
2024-10-06 17:27:48.926 UTC client backend[252208] pg_regress/tablespace
STATEMENT: ALTER INDEX testschema.part_a_idx SET TABLESPACE pg_global;
2024-10-06 17:27:48.928 UTC client backend[252208] pg_regress/tablespace ERROR:
duplicate key value violates unique constraint "anindex"
2024-10-06 17:27:48.928 UTC client backend[252208] pg_regress/tablespace
DETAIL: Key (column1)=(1) already exists.
2024-10-06 17:27:48.928 UTC client backend[252208] pg_regress/tablespace
STATEMENT: INSERT INTO testschema.atable VALUES(1);
2024-10-06 17:27:48.931 UTC client backend[252208] pg_regress/tablespace ERROR:
directory "/no/such/location" does not exist
2024-10-06 17:27:48.931 UTC client backend[252208] pg_regress/tablespace
STATEMENT: CREATE TABLESPACE regress_badspace LOCATION '/no/such/location';
2024-10-06 17:27:48.931 UTC client backend[252208] pg_regress/tablespace ERROR:
tablespace "regress_nosuchspace" does not exist
2024-10-06 17:27:48.931 UTC client backend[252208] pg_regress/tablespace
STATEMENT: CREATE TABLE bar (i int) TABLESPACE regress_nosuchspace;
2024-10-06 17:27:48.931 UTC client backend[252208] pg_regress/tablespace ERROR:
tablespace "regress_tblspace" cannot be dropped because some objects depend on
it
2024-10-06 17:27:48.931 UTC client backend[252208] pg_regress/tablespace
DETAIL: tablespace for index testschema.part_a_idx
2024-10-06 17:27:48.931 UTC client backend[252208] pg_regress/tablespace
STATEMENT: DROP TABLESPACE regress_tblspace;
2024-10-06 17:27:48.931 UTC checkpointer[250611] LOG: checkpoint starting:
immediate force wait
2024-10-06 17:27:48.945 UTC checkpointer[250611] LOG: checkpoint complete:
wrote 1345 buffers (8.2%); 0 WAL file(s) added, 0 removed, 1 recycled;
write=0.007 s, sync=0.001 s, total=0.014 s; sync files=0, longest=0.000 s,
average=0.000 s; distance=11227 kB, estimate=138538 kB; lsn=0/109A9C50, redo
lsn=0/109A9C18
2024-10-06 17:27:48.946 UTC client backend[252208] pg_regress/tablespace ERROR:
tablespace "regress_tblspace" is not empty
2024-10-06 17:27:48.946 UTC client backend[252208] pg_regress/tablespace
STATEMENT: DROP TABLESPACE regress_tblspace;
2024-10-06 17:27:48.947 UTC client backend[252208] pg_regress/tablespace ERROR:
permission denied for tablespace regress_tblspace
2024-10-06 17:27:48.947 UTC client backend[252208] pg_regress/tablespace
STATEMENT: CREATE TABLE tablespace_table (i int) TABLESPACE regress_tblspace;
2024-10-06 17:27:48.948 UTC client backend[252208] pg_regress/tablespace ERROR:
permission denied for tablespace regress_tblspace
2024-10-06 17:27:48.948 UTC client backend[252208] pg_regress/tablespace
STATEMENT: REINDEX (TABLESPACE regress_tblspace) TABLE tablespace_table;
2024-10-06 17:27:48.948 UTC client backend[252208] pg_regress/tablespace ERROR:
permission denied for tablespace regress_tblspace
2024-10-06 17:27:48.948 UTC client backend[252208] pg_regress/tablespace
STATEMENT: REINDEX (TABLESPACE regress_tblspace, CONCURRENTLY) TABLE
tablespace_table;
2024-10-06 17:27:48.950 UTC checkpointer[250611] LOG: checkpoint starting:
immediate force wait
2024-10-06 17:27:48.951 UTC checkpointer[250611] LOG: checkpoint complete:
wrote 43 buffers (0.3%); 0 WAL file(s) added, 0 removed, 0 recycled;
write=0.001 s, sync=0.001 s, total=0.001 s; sync files=0, longest=0.000 s,
average=0.000 s; distance=312 kB, estimate=124716 kB; lsn=0/109F8040, redo
lsn=0/109F7FF0
2024-10-06 17:27:48.956 UTC postmaster[250608] LOG: received fast shutdown
request
2024-10-06 17:27:48.956 UTC postmaster[250608] LOG: aborting any active
transactions
2024-10-06 17:27:48.959 UTC postmaster[250608] LOG: background worker "logical
replication launcher" (PID 250616) exited with exit code 1
2024-10-06 17:27:48.962 UTC checkpointer[250611] LOG: shutting down
2024-10-06 17:27:48.962 UTC checkpointer[250611] LOG: checkpoint starting:
shutdown immediate
2024-10-06 17:27:48.963 UTC checkpointer[250611] LOG: checkpoint complete:
wrote 29 buffers (0.2%); 0 WAL file(s) added, 0 removed, 0 recycled;
write=0.001 s, sync=0.001 s, total=0.001 s; sync files=0, longest=0.000 s,
average=0.000 s; distance=99 kB, estimate=112254 kB; lsn=0/10A10BF8, redo
lsn=0/10A10BF8
2024-10-06 17:27:48.986 UTC postmaster[250608] LOG: database system is shut
down
******** build/src/test/regress/regression.out ********
# using temp instance on port 61700 with PID 250608
ok 1 - test_setup 131 ms
# parallel group (20 tests): varchar oid pg_lsn char name txid int2 regproc
text float4 uuid int4 money enum float8 int8 bit boolean rangetypes numeric
ok 2 + boolean 941 ms
ok 3 + char 396 ms
ok 4 + name 440 ms
ok 5 + varchar 338 ms
ok 6 + text 605 ms
ok 7 + int2 590 ms
ok 8 + int4 652 ms
ok 9 + int8 831 ms
ok 10 + oid 384 ms
ok 11 + float4 620 ms
ok 12 + float8 793 ms
ok 13 + bit 913 ms
ok 14 + numeric 1708 ms
ok 15 + txid 467 ms
ok 16 + uuid 650 ms
ok 17 + enum 712 ms
ok 18 + money 701 ms
ok 19 + rangetypes 1191 ms
ok 20 + pg_lsn 385 ms
ok 21 + regproc 594 ms
# parallel group (20 tests): lseg md5 line path time macaddr circle timetz
numerology macaddr8 inet interval date point timestamp timestamptz polygon
strings box multirangetypes
ok 22 + strings 1225 ms
ok 23 + md5 294 ms
ok 24 + numerology 576 ms
ok 25 + point 954 ms
ok 26 + lseg 283 ms
ok 27 + line 330 ms
ok 28 + box 1388 ms
ok 29 + path 365 ms
ok 30 + polygon 1203 ms
ok 31 + circle 464 ms
not ok 32 + date 894 ms
ok 33 + time 425 ms
ok 34 + timetz 473 ms
ok 35 + timestamp 959 ms
not ok 36 + timestamptz 1170 ms
ok 37 + interval 867 ms
ok 38 + inet 669 ms
ok 39 + macaddr 446 ms
ok 40 + macaddr8 582 ms
ok 41 + multirangetypes 1505 ms
# parallel group (13 tests): unicode comments misc_sanity xid expressions
tstypes database regex mvcc type_sanity horology geometry opr_sanity
ok 42 + geometry 1982 ms
not ok 43 + horology 1295 ms
ok 44 + tstypes 788 ms
ok 45 + regex 1100 ms
ok 46 + type_sanity 1239 ms
ok 47 + opr_sanity 2288 ms
ok 48 + misc_sanity 299 ms
ok 49 + comments 172 ms
ok 50 + expressions 775 ms
ok 51 + unicode 155 ms
ok 52 + xid 375 ms
ok 53 + mvcc 1121 ms
ok 54 + database 821 ms
# parallel group (5 tests): copyselect copydml copy insert_conflict insert
ok 55 + copy 164 ms
ok 56 + copyselect 118 ms
ok 57 + copydml 141 ms
ok 58 + insert 1191 ms
ok 59 + insert_conflict 246 ms
# parallel group (7 tests): create_function_c create_operator create_type
create_procedure create_misc create_schema create_table
ok 60 + create_function_c 95 ms
ok 61 + create_misc 255 ms
ok 62 + create_operator 115 ms
ok 63 + create_procedure 208 ms
ok 64 + create_table 1346 ms
ok 65 + create_type 156 ms
ok 66 + create_schema 313 ms
# parallel group (5 tests): index_including_gist index_including
create_index_spgist create_view create_index
ok 67 + create_index 1874 ms
ok 68 + create_index_spgist 1185 ms
ok 69 + create_view 1558 ms
ok 70 + index_including 701 ms
ok 71 + index_including_gist 654 ms
# parallel group (16 tests): drop_if_exists errors create_cast
create_aggregate roleattributes hash_func create_am select constraints vacuum
typed_table create_function_sql updatable_views triggers inherit
infinite_recurse
ok 72 + create_aggregate 307 ms
ok 73 + create_function_sql 1584 ms
ok 74 + create_cast 233 ms
ok 75 + constraints 1120 ms
ok 76 + triggers 3711 ms
ok 77 + select 1026 ms
ok 78 + inherit 4079 ms
ok 79 + typed_table 1465 ms
ok 80 + vacuum 1413 ms
ok 81 + drop_if_exists 116 ms
ok 82 + updatable_views 3685 ms
ok 83 + roleattributes 512 ms
ok 84 + create_am 856 ms
ok 85 + hash_func 548 ms
ok 86 + errors 203 ms
ok 87 + infinite_recurse 4984 ms
ok 88 - sanity_check 95 ms
# parallel group (20 tests): delete select_distinct_on namespace select_into
select_having random select_implicit prepared_xacts transactions case portals
select_distinct hash_index union arrays subselect aggregates update btree_index
join
ok 89 + select_into 393 ms
ok 90 + select_distinct 1039 ms
ok 91 + select_distinct_on 341 ms
ok 92 + select_implicit 735 ms
ok 93 + select_having 454 ms
ok 94 + subselect 2598 ms
ok 95 + union 1743 ms
ok 96 + case 1015 ms
ok 97 + join 4783 ms
ok 98 + aggregates 3756 ms
ok 99 + transactions 1008 ms
ok 100 + random 460 ms
ok 101 + portals 1023 ms
ok 102 + arrays 1981 ms
ok 103 + btree_index 4401 ms
ok 104 + hash_index 1336 ms
ok 105 + update 3908 ms
ok 106 + delete 316 ms
ok 107 + namespace 350 ms
ok 108 + prepared_xacts 957 ms
# parallel group (20 tests): security_label init_privs drop_operator lock
password tablesample object_address spgist gist collate gin replica_identity
identity matview groupingsets rowsecurity generated brin join_hash privileges
ok 109 + brin 8119 ms
ok 110 + gin 3788 ms
ok 111 + gist 2264 ms
ok 112 + spgist 1774 ms
ok 113 + privileges 8769 ms
ok 114 + init_privs 231 ms
ok 115 + security_label 93 ms
ok 116 + collate 2752 ms
ok 117 + matview 4459 ms
ok 118 + lock 589 ms
ok 119 + replica_identity 4158 ms
ok 120 + rowsecurity 5299 ms
ok 121 + object_address 1647 ms
ok 122 + tablesample 1033 ms
ok 123 + groupingsets 4462 ms
ok 124 + drop_operator 332 ms
ok 125 + password 660 ms
ok 126 + identity 4370 ms
ok 127 + generated 5670 ms
ok 128 + join_hash 8184 ms
# parallel group (2 tests): brin_bloom brin_multi
ok 129 + brin_bloom 249 ms
ok 130 + brin_multi 804 ms
# parallel group (16 tests): create_role collate.icu.utf8 async dbsize
alter_operator tid tidscan alter_generic tidrangescan sysviews misc_functions
tsrf incremental_sort misc create_table_like merge
ok 131 + create_table_like 2187 ms
ok 132 + alter_generic 636 ms
ok 133 + alter_operator 317 ms
ok 134 + misc 2051 ms
ok 135 + async 219 ms
ok 136 + dbsize 232 ms
ok 137 + merge 2217 ms
ok 138 + misc_functions 715 ms
ok 139 + sysviews 687 ms
ok 140 + tsrf 742 ms
ok 141 + tid 318 ms
ok 142 + tidscan 479 ms
ok 143 + tidrangescan 657 ms
ok 144 + collate.icu.utf8 179 ms
ok 145 + incremental_sort 894 ms
ok 146 + create_role 162 ms
# parallel group (7 tests): collate.windows.win1252 collate.linux.utf8 amutils
psql_crosstab rules psql stats_ext
ok 147 + rules 2206 ms
ok 148 + psql 2507 ms
ok 149 + psql_crosstab 210 ms
ok 150 + amutils 131 ms
ok 151 + stats_ext 2793 ms
ok 152 + collate.linux.utf8 80 ms
ok 153 + collate.windows.win1252 73 ms
ok 154 - select_parallel 3078 ms
ok 155 - write_parallel 369 ms
ok 156 - vacuum_parallel 102 ms
# parallel group (2 tests): subscription publication
ok 157 + publication 2096 ms
ok 158 + subscription 134 ms
# parallel group (17 tests): functional_deps portals_p2 equivclass combocid
xmlmap advisory_lock guc dependency tsdicts select_views bitmapops
indirect_toast cluster window tsearch foreign_key foreign_data
ok 159 + select_views 914 ms
ok 160 + portals_p2 264 ms
ok 161 + foreign_key 4267 ms
ok 162 + cluster 1382 ms
ok 163 + dependency 689 ms
ok 164 + guc 609 ms
ok 165 + bitmapops 968 ms
ok 166 + combocid 515 ms
ok 167 + tsearch 3976 ms
ok 168 + tsdicts 702 ms
ok 169 + foreign_data 5378 ms
ok 170 + window 3205 ms
ok 171 + xmlmap 535 ms
ok 172 + functional_deps 258 ms
ok 173 + advisory_lock 540 ms
ok 174 + indirect_toast 1088 ms
ok 175 + equivclass 357 ms
# parallel group (7 tests): jsonpath_encoding json_encoding jsonpath sqljson
jsonb_jsonpath json jsonb
ok 176 + json 765 ms
ok 177 + jsonb 1216 ms
ok 178 + json_encoding 126 ms
ok 179 + jsonpath 350 ms
ok 180 + jsonpath_encoding 108 ms
ok 181 + jsonb_jsonpath 576 ms
ok 182 + sqljson 430 ms
# parallel group (18 tests): prepare plancache temp returning truncate copy2
largeobject rowtypes limit sequence domain polymorphism xml rangefuncs with
plpgsql conversion alter_table
ok 183 + plancache 883 ms
ok 184 + limit 1751 ms
ok 185 + plpgsql 4313 ms
ok 186 + copy2 1488 ms
ok 187 + temp 1013 ms
ok 188 + domain 2396 ms
ok 189 + rangefuncs 3297 ms
ok 190 + prepare 372 ms
ok 191 + conversion 4559 ms
ok 192 + truncate 1306 ms
ok 193 + alter_table 7202 ms
ok 194 + sequence 1784 ms
ok 195 + polymorphism 2750 ms
ok 196 + rowtypes 1658 ms
ok 197 + returning 1135 ms
ok 198 + largeobject 1490 ms
ok 199 + with 3757 ms
ok 200 + xml 3171 ms
# parallel group (12 tests): explain hash_part reloptions partition_info
memoize tuplesort partition_aggregate stats compression partition_prune
partition_join indexing
ok 201 + partition_join 4670 ms
ok 202 + partition_prune 4487 ms
ok 203 + reloptions 447 ms
ok 204 + hash_part 238 ms
ok 205 + indexing 5050 ms
ok 206 + partition_aggregate 3347 ms
ok 207 + partition_info 469 ms
ok 208 + tuplesort 2653 ms
ok 209 + explain 157 ms
ok 210 + compression 3458 ms
ok 211 + memoize 1244 ms
ok 212 + stats 3382 ms
# parallel group (2 tests): event_trigger oidjoins
ok 213 + event_trigger 155 ms
ok 214 + oidjoins 659 ms
ok 215 - fast_default 214 ms
ok 216 - tablespace 1646 ms
1..216
# 3 of 216 tests failed.
# The differences that caused some tests to fail can be viewed in the file
"/<<PKGBUILDDIR>>/build/src/test/regress/regression.diffs".
# A copy of the test summary that you see above is saved in the file
"/<<PKGBUILDDIR>>/build/src/test/regress/regression.out".
make[1]: *** [/usr/share/postgresql-common/server/postgresql.mk:261:
override_dh_auto_test-arch] Error 1
make[1]: Leaving directory '/<<PKGBUILDDIR>>'
make: *** [/usr/share/postgresql-common/server/postgresql.mk:158: binary] Error
2
dpkg-buildpackage: error: debian/rules binary subprocess returned exit status 2
--------------------------------------------------------------------------------
The above is just how the build ends and not necessarily the most relevant part.
If required, the full build log is available here:
https://people.debian.org/~sanvila/build-logs/202410/
About the archive rebuild: The build was made on virtual machines from AWS,
using sbuild and a reduced chroot with only build-essential packages.
If you could not reproduce the bug please contact me privately, as I
am willing to provide ssh access to a virtual machine where the bug is
fully reproducible.
If this is really a bug in one of the build-depends, please use
reassign and affects, so that this is still visible in the BTS web
page for this package.
Thanks.
