Bug#1131248: marked as done (pgl-ddl-deploy: FTBFS in trixie: override_dh_pgxs_test fails)

Debian Bug Tracking System Thu, 19 Mar 2026 04:53:16 -0700

Your message dated Thu, 19 Mar 2026 12:51:30 +0100
with message-id <[email protected]>
and subject line Re: Bug#1131248: pgl-ddl-deploy: FTBFS in trixie: 
override_dh_pgxs_test fails
has caused the Debian Bug report #1131248,
regarding pgl-ddl-deploy: FTBFS in trixie: override_dh_pgxs_test fails
to be marked as done.


This means that you claim that the problem has been dealt with.
If this is not the case it is now your responsibility to reopen the
Bug report if necessary, and/or fix the problem forthwith.

(NB: If you are a system administrator and have no idea what this
message is talking about, this may indicate a serious mail system
misconfiguration somewhere. Please contact [email protected]
immediately.)


-- 
1131248: https://bugs.debian.org/cgi-bin/bugreport.cgi?bug=1131248
Debian Bug Tracking System
Contact [email protected] with problems

--- Begin Message ---

Package: src:pgl-ddl-deploy
Version: 2.2.1-2
Severity: serious
Tags: ftbfs trixie

Dear maintainer:

During a rebuild of all packages in trixie, this package failed to build.

Below you will find the last part of the build log (probably the most
relevant part, but not necessarily). If required, the full build log
is available here:

https://people.debian.org/~sanvila/build-logs/trixie/

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 cannot 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 add an affects on src:pgl-ddl-deploy, so that this is still
visible in the BTS web page for this package.

Thanks.

--------------------------------------------------------------------------------
[...]

- test3    | DROP TABLE foobar.foo CASCADE; | DROP TABLE foobar.foo CASCADE;
+ set_name |                           ddl_sql_raw                            | 
                          ddl_sql_sent                           
+----------+------------------------------------------------------------------+------------------------------------------------------------------
+ test4    | DROP TABLE foo CASCADE;                                          | 
DROP TABLE foo CASCADE;
+ test3    | DROP TABLE foo CASCADE;                                          | 
DROP TABLE foo CASCADE;
+ test2    | DROP TABLE foo CASCADE;                                          | 
DROP TABLE foo CASCADE;
+ test1    | DROP TABLE foo CASCADE;                                          | 
DROP TABLE foo CASCADE;
+ test4    | DROP TABLE foobar.foo CASCADE;                                   | 
DROP TABLE foobar.foo CASCADE;
+ test3    | DROP TABLE foobar.foo CASCADE;                                   | 
DROP TABLE foobar.foo CASCADE;
+ test2    | DROP TABLE foobar.foo CASCADE;                                   | 
DROP TABLE foobar.foo CASCADE;
+ test1    | DROP TABLE foobar.foo CASCADE;                                   | 
DROP TABLE foobar.foo CASCADE;
+ test8    | ALTER TABLE foobar.foo ADD COLUMN foo_id INT REFERENCES foo(id); | 
ALTER TABLE foobar.foo ADD COLUMN foo_id INT REFERENCES foo(id);
+ test7    | ALTER TABLE foobar.foo ADD COLUMN foo_id INT REFERENCES foo(id); | 
ALTER TABLE foobar.foo ADD COLUMN foo_id INT REFERENCES foo(id);
 (10 rows)
 
 SELECT set_name, ddl_sql_raw, command_tag, reason FROM 
pgl_ddl_deploy.unhandled ORDER BY id DESC LIMIT 10;
- set_name |                                 ddl_sql_raw                        
         |   command_tag   |          reason          
-----------+-----------------------------------------------------------------------------+-----------------+--------------------------
- test4    | CREATE TABLE foo AS                                                
        +| CREATE TABLE AS | unsupported_command
-          | SELECT 1 AS myfield;                                               
         |                 | 
- test3    | CREATE TABLE foo AS                                                
        +| CREATE TABLE AS | unsupported_command
-          | SELECT 1 AS myfield;                                               
         |                 | 
- test2    | CREATE TABLE foo AS                                                
        +| CREATE TABLE AS | unsupported_command
-          | SELECT 1 AS myfield;                                               
         |                 | 
- test1    | CREATE TABLE foo AS                                                
        +| CREATE TABLE AS | unsupported_command
-          | SELECT 1 AS myfield;                                               
         |                 | 
- test8    | DROP TABLE foo, foobar.foo CASCADE;                                
         | DROP TABLE      | mixed_objects
- test7    | DROP TABLE foo, foobar.foo CASCADE;                                
         | DROP TABLE      | mixed_objects
- test6    | DROP TABLE foo, foobar.foo CASCADE;                                
         | DROP TABLE      | mixed_objects
- test5    | DROP TABLE foo, foobar.foo CASCADE;                                
         | DROP TABLE      | mixed_objects
- test8    | CREATE TABLE foobar.foo(id int primary key); DROP TABLE foobar.foo 
CASCADE; | CREATE TABLE    | rejected_multi_statement
- test6    | CREATE TABLE foobar.foo(id int primary key); DROP TABLE foobar.foo 
CASCADE; | CREATE TABLE    | rejected_multi_statement
+ set_name |             ddl_sql_raw             |   command_tag   |       
reason        
+----------+-------------------------------------+-----------------+---------------------
+ test4    | CREATE TABLE foo AS                +| CREATE TABLE AS | 
unsupported_command
+          | SELECT 1 AS myfield;                |                 | 
+ test3    | CREATE TABLE foo AS                +| CREATE TABLE AS | 
unsupported_command
+          | SELECT 1 AS myfield;                |                 | 
+ test2    | CREATE TABLE foo AS                +| CREATE TABLE AS | 
unsupported_command
+          | SELECT 1 AS myfield;                |                 | 
+ test1    | CREATE TABLE foo AS                +| CREATE TABLE AS | 
unsupported_command
+          | SELECT 1 AS myfield;                |                 | 
+ test8    | DROP TABLE foobar.foo CASCADE;      | DROP TABLE      | 
mixed_objects
+ test7    | DROP TABLE foobar.foo CASCADE;      | DROP TABLE      | 
mixed_objects
+ test6    | DROP TABLE foobar.foo CASCADE;      | DROP TABLE      | 
mixed_objects
+ test5    | DROP TABLE foobar.foo CASCADE;      | DROP TABLE      | 
mixed_objects
+ test8    | DROP TABLE foo, foobar.foo CASCADE; | DROP TABLE      | 
mixed_objects
+ test7    | DROP TABLE foo, foobar.foo CASCADE; | DROP TABLE      | 
mixed_objects
 (10 rows)
 
 SELECT 1 AS myfield INTO foobar.foo;
@@ -51,18 +51,18 @@
 WARNING:  Unhandled deployment logged in pgl_ddl_deploy.unhandled
 WARNING:  Unhandled deployment logged in pgl_ddl_deploy.unhandled
 SELECT set_name, ddl_sql_raw, ddl_sql_sent FROM pgl_ddl_deploy.events ORDER BY 
id DESC LIMIT 10;
- set_name |          ddl_sql_raw           |          ddl_sql_sent          
-----------+--------------------------------+--------------------------------
- test4    | DROP TABLE foo CASCADE;        | DROP TABLE foo CASCADE;
- test3    | DROP TABLE foo CASCADE;        | DROP TABLE foo CASCADE;
- test2    | DROP TABLE foo CASCADE;        | DROP TABLE foo CASCADE;
- test1    | DROP TABLE foo CASCADE;        | DROP TABLE foo CASCADE;
- test8    | DROP TABLE foobar.foo CASCADE; | DROP TABLE foobar.foo CASCADE;
- test7    | DROP TABLE foobar.foo CASCADE; | DROP TABLE foobar.foo CASCADE;
- test6    | DROP TABLE foobar.foo CASCADE; | DROP TABLE foobar.foo CASCADE;
- test5    | DROP TABLE foobar.foo CASCADE; | DROP TABLE foobar.foo CASCADE;
- test4    | DROP TABLE foobar.foo CASCADE; | DROP TABLE foobar.foo CASCADE;
- test3    | DROP TABLE foobar.foo CASCADE; | DROP TABLE foobar.foo CASCADE;
+ set_name |                           ddl_sql_raw                            | 
                          ddl_sql_sent                           
+----------+------------------------------------------------------------------+------------------------------------------------------------------
+ test4    | DROP TABLE foo CASCADE;                                          | 
DROP TABLE foo CASCADE;
+ test3    | DROP TABLE foo CASCADE;                                          | 
DROP TABLE foo CASCADE;
+ test2    | DROP TABLE foo CASCADE;                                          | 
DROP TABLE foo CASCADE;
+ test1    | DROP TABLE foo CASCADE;                                          | 
DROP TABLE foo CASCADE;
+ test4    | DROP TABLE foobar.foo CASCADE;                                   | 
DROP TABLE foobar.foo CASCADE;
+ test3    | DROP TABLE foobar.foo CASCADE;                                   | 
DROP TABLE foobar.foo CASCADE;
+ test2    | DROP TABLE foobar.foo CASCADE;                                   | 
DROP TABLE foobar.foo CASCADE;
+ test1    | DROP TABLE foobar.foo CASCADE;                                   | 
DROP TABLE foobar.foo CASCADE;
+ test8    | ALTER TABLE foobar.foo ADD COLUMN foo_id INT REFERENCES foo(id); | 
ALTER TABLE foobar.foo ADD COLUMN foo_id INT REFERENCES foo(id);
+ test7    | ALTER TABLE foobar.foo ADD COLUMN foo_id INT REFERENCES foo(id); | 
ALTER TABLE foobar.foo ADD COLUMN foo_id INT REFERENCES foo(id);
 (10 rows)
 
 SELECT set_name, ddl_sql_raw, command_tag, reason FROM 
pgl_ddl_deploy.unhandled ORDER BY id DESC LIMIT 10;
diff -U3 /<<PKGBUILDDIR>>/expected/24_sub_retries.out 
/<<PKGBUILDDIR>>/results/24_sub_retries.out
--- /<<PKGBUILDDIR>>/expected/24_sub_retries.out        2023-11-29 
20:12:27.000000000 +0000
+++ /<<PKGBUILDDIR>>/results/24_sub_retries.out 2026-03-14 17:46:03.337221674 
+0000
@@ -236,10 +236,6 @@
  {test2}               | Q            | "\n        SELECT p 
[too-long-redacted] ver := ?\n        );\n        "
  {test3}               | Q            | "\n        SELECT 
pgl_ddl_deploy.subscriber_command\n        (\n          p_provider_name := ?,\n 
         p_set_name := ARRAY['test3'],\n          p_nspname := NULL,\n          
p_relname := NULL,\n          p_ddl_sql_sent := $pgl_ddl_deploy_sql$DROP TABLE 
foobar.foo CASCADE;$pgl_ddl_deploy_sql$,\n          p_full_ddl := 
$pgl_ddl_deploy_sql$\n        --Be sure to use provider's search_path for SQL 
environment consistency\n            SET SEARCH_PATH TO \"$user\", public;\n\n  
          DROP TABLE foobar.foo CASCADE;\n            ;\n        
$pgl_ddl_deploy_sql$,\n          p_pid := ?,\n          p_set_config_id := 3,\n 
         p_queue_subscriber_failures := false,\n          
p_signal_blocking_subscriber_sessions := NULL,\n          p_lock_timeout := 
3000,\n          p_driver := ?\n        );\n        "
  {test4}               | Q            | "\n        SELECT 
pgl_ddl_deploy.subscriber_command\n        (\n          p_provider_name := ?,\n 
         p_set_name := ARRAY['test4'],\n          p_nspname := NULL,\n          
p_relname := NULL,\n          p_ddl_sql_sent := $pgl_ddl_deploy_sql$DROP TABLE 
foobar.foo CASCADE;$pgl_ddl_deploy_sql$,\n          p_full_ddl := 
$pgl_ddl_deploy_sql$\n        --Be sure to use provider's search_path for SQL 
environment consistency\n            SET SEARCH_PATH TO \"$user\", public;\n\n  
          DROP TABLE foobar.foo CASCADE;\n            ;\n        
$pgl_ddl_deploy_sql$,\n          p_pid := ?,\n          p_set_config_id := 4,\n 
         p_queue_subscriber_failures := false,\n          
p_signal_blocking_subscriber_sessions := NULL,\n          p_lock_timeout := 
3000,\n          p_driver := ?\n        );\n        "
- {test5}               | Q            | "\n        SELECT p 
[too-long-redacted] ver := ?\n        );\n        "
- {test6}               | Q            | "\n        SELECT p 
[too-long-redacted] ver := ?\n        );\n        "
- {test7}               | Q            | "\n        SELECT 
pgl_ddl_deploy.subscriber_command\n        (\n          p_provider_name := ?,\n 
         p_set_name := ARRAY['test7'],\n          p_nspname := NULL,\n          
p_relname := NULL,\n          p_ddl_sql_sent := $pgl_ddl_deploy_sql$DROP TABLE 
foobar.foo CASCADE;$pgl_ddl_deploy_sql$,\n          p_full_ddl := 
$pgl_ddl_deploy_sql$\n        --Be sure to use provider's search_path for SQL 
environment consistency\n            SET SEARCH_PATH TO \"$user\", public;\n\n  
          DROP TABLE foobar.foo CASCADE;\n            ;\n        
$pgl_ddl_deploy_sql$,\n          p_pid := ?,\n          p_set_config_id := 7,\n 
         p_queue_subscriber_failures := false,\n          
p_signal_blocking_subscriber_sessions := NULL,\n          p_lock_timeout := 
3000,\n          p_driver := ?\n        );\n        "
- {test8}               | Q            | "\n        SELECT 
pgl_ddl_deploy.subscriber_command\n        (\n          p_provider_name := ?,\n 
         p_set_name := ARRAY['test8'],\n          p_nspname := NULL,\n          
p_relname := NULL,\n          p_ddl_sql_sent := $pgl_ddl_deploy_sql$DROP TABLE 
foobar.foo CASCADE;$pgl_ddl_deploy_sql$,\n          p_full_ddl := 
$pgl_ddl_deploy_sql$\n        --Be sure to use provider's search_path for SQL 
environment consistency\n            SET SEARCH_PATH TO \"$user\", public;\n\n  
          DROP TABLE foobar.foo CASCADE;\n            ;\n        
$pgl_ddl_deploy_sql$,\n          p_pid := ?,\n          p_set_config_id := 8,\n 
         p_queue_subscriber_failures := false,\n          
p_signal_blocking_subscriber_sessions := NULL,\n          p_lock_timeout := 
3000,\n          p_driver := ?\n        );\n        "
  {test1}               | Q            | "\n        SELECT p 
[too-long-redacted] ver := ?\n        );\n        "
  {test2}               | Q            | "\n        SELECT p 
[too-long-redacted] ver := ?\n        );\n        "
  {test3}               | Q            | "\n        SELECT 
pgl_ddl_deploy.subscriber_command\n        (\n          p_provider_name := ?,\n 
         p_set_name := ARRAY['test3'],\n          p_nspname := NULL,\n          
p_relname := NULL,\n          p_ddl_sql_sent := $pgl_ddl_deploy_sql$DROP TABLE 
foo CASCADE;$pgl_ddl_deploy_sql$,\n          p_full_ddl := 
$pgl_ddl_deploy_sql$\n        --Be sure to use provider's search_path for SQL 
environment consistency\n            SET SEARCH_PATH TO \"$user\", public;\n\n  
          DROP TABLE foo CASCADE;\n            ;\n        
$pgl_ddl_deploy_sql$,\n          p_pid := ?,\n          p_set_config_id := 3,\n 
         p_queue_subscriber_failures := false,\n          
p_signal_blocking_subscriber_sessions := NULL,\n          p_lock_timeout := 
3000,\n          p_driver := ?\n        );\n        "
@@ -436,7 +432,7 @@
  {test_ddl_only}       | Q            | "\n        SELECT 
pgl_ddl_deploy.subscriber_command\n        (\n          p_provider_name := ?,\n 
         p_set_name := ARRAY['test_ddl_only'],\n          p_nspname := 
'duper',\n          p_relname := 'man',\n          p_ddl_sql_sent := 
$pgl_ddl_deploy_sql$ALTER TABLE duper.man ADD COLUMN foo 
text;$pgl_ddl_deploy_sql$,\n          p_full_ddl := $pgl_ddl_deploy_sql$\n      
  --Be sure to use provider's search_path for SQL environment consistency\n     
       SET SEARCH_PATH TO '';\n\n            ALTER TABLE duper.man ADD COLUMN 
foo text;\n            ;\n        $pgl_ddl_deploy_sql$,\n          p_pid := 
?,\n          p_set_config_id := 20,\n          p_queue_subscriber_failures := 
false,\n          p_signal_blocking_subscriber_sessions := NULL,\n          
p_lock_timeout := 3000,\n          p_driver := ?\n        );\n        "
  {test_ddl_only}       | Q            | "\n        SELECT 
pgl_ddl_deploy.subscriber_command\n        (\n          p_provider_name := ?,\n 
         p_set_name := ARRAY['test_ddl_only'],\n          p_nspname := NULL,\n  
        p_relname := NULL,\n          p_ddl_sql_sent := 
$pgl_ddl_deploy_sql$DROP TABLE super.man CASCADE;$pgl_ddl_deploy_sql$,\n        
  p_full_ddl := $pgl_ddl_deploy_sql$\n        --Be sure to use provider's 
search_path for SQL environment consistency\n            SET SEARCH_PATH TO 
'';\n\n            DROP TABLE super.man CASCADE;\n            ;\n        
$pgl_ddl_deploy_sql$,\n          p_pid := ?,\n          p_set_config_id := 
19,\n          p_queue_subscriber_failures := false,\n          
p_signal_blocking_subscriber_sessions := NULL,\n          p_lock_timeout := 
3000,\n          p_driver := ?\n        );\n        "
  {test_ddl_only}       | Q            | "\n        SELECT 
pgl_ddl_deploy.subscriber_command\n        (\n          p_provider_name := ?,\n 
         p_set_name := ARRAY['test_ddl_only'],\n          p_nspname := NULL,\n  
        p_relname := NULL,\n          p_ddl_sql_sent := 
$pgl_ddl_deploy_sql$DROP TABLE duper.man;$pgl_ddl_deploy_sql$,\n          
p_full_ddl := $pgl_ddl_deploy_sql$\n        --Be sure to use provider's 
search_path for SQL environment consistency\n            SET SEARCH_PATH TO 
'';\n\n            DROP TABLE duper.man;\n            ;\n        
$pgl_ddl_deploy_sql$,\n          p_pid := ?,\n          p_set_config_id := 
20,\n          p_queue_subscriber_failures := false,\n          
p_signal_blocking_subscriber_sessions := NULL,\n          p_lock_timeout := 
3000,\n          p_driver := ?\n        );\n        "
-(432 rows)
+(428 rows)
 
 DO $$
 DECLARE v_ct INT;
diff -U3 /<<PKGBUILDDIR>>/expected/35_edges.out 
/<<PKGBUILDDIR>>/results/35_edges.out
--- /<<PKGBUILDDIR>>/expected/35_edges.out      2023-11-29 20:12:27.000000000 
+0000
+++ /<<PKGBUILDDIR>>/results/35_edges.out       2026-03-14 17:46:29.837421214 
+0000
@@ -20,4 +20,8 @@
 (10 rows)
 
 DROP TABLE foobar.foo CASCADE;
+WARNING:  Unhandled deployment logged in pgl_ddl_deploy.unhandled
+WARNING:  Unhandled deployment logged in pgl_ddl_deploy.unhandled
+WARNING:  Unhandled deployment logged in pgl_ddl_deploy.unhandled
+WARNING:  Unhandled deployment logged in pgl_ddl_deploy.unhandled
 DROP TABLE foo CASCADE;
diff -U3 /<<PKGBUILDDIR>>/expected/36_ignored.out 
/<<PKGBUILDDIR>>/results/36_ignored.out
--- /<<PKGBUILDDIR>>/expected/36_ignored.out    2023-11-29 20:12:27.000000000 
+0000
+++ /<<PKGBUILDDIR>>/results/36_ignored.out     2026-03-14 17:46:29.885421574 
+0000
@@ -8,17 +8,17 @@
 SELECT 1 AS myfield;
 DROP TABLE foo;
 SELECT set_name, ddl_sql_raw, ddl_sql_sent FROM pgl_ddl_deploy.events ORDER BY 
id DESC LIMIT 10;
- set_name |          ddl_sql_raw           |          ddl_sql_sent          
-----------+--------------------------------+--------------------------------
- test4    | DROP TABLE foo CASCADE;        | DROP TABLE foo CASCADE;
- test3    | DROP TABLE foo CASCADE;        | DROP TABLE foo CASCADE;
- test2    | DROP TABLE foo CASCADE;        | DROP TABLE foo CASCADE;
- test1    | DROP TABLE foo CASCADE;        | DROP TABLE foo CASCADE;
- test8    | DROP TABLE foobar.foo CASCADE; | DROP TABLE foobar.foo CASCADE;
- test7    | DROP TABLE foobar.foo CASCADE; | DROP TABLE foobar.foo CASCADE;
- test6    | DROP TABLE foobar.foo CASCADE; | DROP TABLE foobar.foo CASCADE;
- test5    | DROP TABLE foobar.foo CASCADE; | DROP TABLE foobar.foo CASCADE;
- test4    | DROP TABLE foobar.foo CASCADE; | DROP TABLE foobar.foo CASCADE;
- test3    | DROP TABLE foobar.foo CASCADE; | DROP TABLE foobar.foo CASCADE;
+ set_name |                           ddl_sql_raw                            | 
                          ddl_sql_sent                           
+----------+------------------------------------------------------------------+------------------------------------------------------------------
+ test4    | DROP TABLE foo CASCADE;                                          | 
DROP TABLE foo CASCADE;
+ test3    | DROP TABLE foo CASCADE;                                          | 
DROP TABLE foo CASCADE;
+ test2    | DROP TABLE foo CASCADE;                                          | 
DROP TABLE foo CASCADE;
+ test1    | DROP TABLE foo CASCADE;                                          | 
DROP TABLE foo CASCADE;
+ test4    | DROP TABLE foobar.foo CASCADE;                                   | 
DROP TABLE foobar.foo CASCADE;
+ test3    | DROP TABLE foobar.foo CASCADE;                                   | 
DROP TABLE foobar.foo CASCADE;
+ test2    | DROP TABLE foobar.foo CASCADE;                                   | 
DROP TABLE foobar.foo CASCADE;
+ test1    | DROP TABLE foobar.foo CASCADE;                                   | 
DROP TABLE foobar.foo CASCADE;
+ test8    | ALTER TABLE foobar.foo ADD COLUMN foo_id INT REFERENCES foo(id); | 
ALTER TABLE foobar.foo ADD COLUMN foo_id INT REFERENCES foo(id);
+ test7    | ALTER TABLE foobar.foo ADD COLUMN foo_id INT REFERENCES foo(id); | 
ALTER TABLE foobar.foo ADD COLUMN foo_id INT REFERENCES foo(id);
 (10 rows)
 
diff -U3 /<<PKGBUILDDIR>>/expected/37_unsupported.out 
/<<PKGBUILDDIR>>/results/37_unsupported.out
--- /<<PKGBUILDDIR>>/expected/37_unsupported.out        2023-11-29 
20:12:27.000000000 +0000
+++ /<<PKGBUILDDIR>>/results/37_unsupported.out 2026-03-14 17:46:29.929421906 
+0000
@@ -8,37 +8,37 @@
 WARNING:  Unhandled deployment logged in pgl_ddl_deploy.unhandled
 WARNING:  Unhandled deployment logged in pgl_ddl_deploy.unhandled
 SELECT set_name, ddl_sql_raw, ddl_sql_sent FROM pgl_ddl_deploy.events ORDER BY 
id DESC LIMIT 10;
- set_name |          ddl_sql_raw           |          ddl_sql_sent          
-----------+--------------------------------+--------------------------------
- test4    | DROP TABLE foo CASCADE;        | DROP TABLE foo CASCADE;
- test3    | DROP TABLE foo CASCADE;        | DROP TABLE foo CASCADE;
- test2    | DROP TABLE foo CASCADE;        | DROP TABLE foo CASCADE;
- test1    | DROP TABLE foo CASCADE;        | DROP TABLE foo CASCADE;
- test8    | DROP TABLE foobar.foo CASCADE; | DROP TABLE foobar.foo CASCADE;
- test7    | DROP TABLE foobar.foo CASCADE; | DROP TABLE foobar.foo CASCADE;
- test6    | DROP TABLE foobar.foo CASCADE; | DROP TABLE foobar.foo CASCADE;
- test5    | DROP TABLE foobar.foo CASCADE; | DROP TABLE foobar.foo CASCADE;
- test4    | DROP TABLE foobar.foo CASCADE; | DROP TABLE foobar.foo CASCADE;
- test3    | DROP TABLE foobar.foo CASCADE; | DROP TABLE foobar.foo CASCADE;
+ set_name |                           ddl_sql_raw                            | 
                          ddl_sql_sent                           
+----------+------------------------------------------------------------------+------------------------------------------------------------------
+ test4    | DROP TABLE foo CASCADE;                                          | 
DROP TABLE foo CASCADE;
+ test3    | DROP TABLE foo CASCADE;                                          | 
DROP TABLE foo CASCADE;
+ test2    | DROP TABLE foo CASCADE;                                          | 
DROP TABLE foo CASCADE;
+ test1    | DROP TABLE foo CASCADE;                                          | 
DROP TABLE foo CASCADE;
+ test4    | DROP TABLE foobar.foo CASCADE;                                   | 
DROP TABLE foobar.foo CASCADE;
+ test3    | DROP TABLE foobar.foo CASCADE;                                   | 
DROP TABLE foobar.foo CASCADE;
+ test2    | DROP TABLE foobar.foo CASCADE;                                   | 
DROP TABLE foobar.foo CASCADE;
+ test1    | DROP TABLE foobar.foo CASCADE;                                   | 
DROP TABLE foobar.foo CASCADE;
+ test8    | ALTER TABLE foobar.foo ADD COLUMN foo_id INT REFERENCES foo(id); | 
ALTER TABLE foobar.foo ADD COLUMN foo_id INT REFERENCES foo(id);
+ test7    | ALTER TABLE foobar.foo ADD COLUMN foo_id INT REFERENCES foo(id); | 
ALTER TABLE foobar.foo ADD COLUMN foo_id INT REFERENCES foo(id);
 (10 rows)
 
 SELECT set_name, ddl_sql_raw, command_tag, reason FROM 
pgl_ddl_deploy.unhandled ORDER BY id DESC LIMIT 10;
- set_name |                                 ddl_sql_raw                        
         |   command_tag   |          reason          
-----------+-----------------------------------------------------------------------------+-----------------+--------------------------
- test4    | CREATE TABLE foo AS                                                
        +| CREATE TABLE AS | unsupported_command
-          | SELECT 1 AS myfield;                                               
         |                 | 
- test3    | CREATE TABLE foo AS                                                
        +| CREATE TABLE AS | unsupported_command
-          | SELECT 1 AS myfield;                                               
         |                 | 
- test2    | CREATE TABLE foo AS                                                
        +| CREATE TABLE AS | unsupported_command
-          | SELECT 1 AS myfield;                                               
         |                 | 
- test1    | CREATE TABLE foo AS                                                
        +| CREATE TABLE AS | unsupported_command
-          | SELECT 1 AS myfield;                                               
         |                 | 
- test8    | DROP TABLE foo, foobar.foo CASCADE;                                
         | DROP TABLE      | mixed_objects
- test7    | DROP TABLE foo, foobar.foo CASCADE;                                
         | DROP TABLE      | mixed_objects
- test6    | DROP TABLE foo, foobar.foo CASCADE;                                
         | DROP TABLE      | mixed_objects
- test5    | DROP TABLE foo, foobar.foo CASCADE;                                
         | DROP TABLE      | mixed_objects
- test8    | CREATE TABLE foobar.foo(id int primary key); DROP TABLE foobar.foo 
CASCADE; | CREATE TABLE    | rejected_multi_statement
- test6    | CREATE TABLE foobar.foo(id int primary key); DROP TABLE foobar.foo 
CASCADE; | CREATE TABLE    | rejected_multi_statement
+ set_name |             ddl_sql_raw             |   command_tag   |       
reason        
+----------+-------------------------------------+-----------------+---------------------
+ test4    | CREATE TABLE foo AS                +| CREATE TABLE AS | 
unsupported_command
+          | SELECT 1 AS myfield;                |                 | 
+ test3    | CREATE TABLE foo AS                +| CREATE TABLE AS | 
unsupported_command
+          | SELECT 1 AS myfield;                |                 | 
+ test2    | CREATE TABLE foo AS                +| CREATE TABLE AS | 
unsupported_command
+          | SELECT 1 AS myfield;                |                 | 
+ test1    | CREATE TABLE foo AS                +| CREATE TABLE AS | 
unsupported_command
+          | SELECT 1 AS myfield;                |                 | 
+ test8    | DROP TABLE foobar.foo CASCADE;      | DROP TABLE      | 
mixed_objects
+ test7    | DROP TABLE foobar.foo CASCADE;      | DROP TABLE      | 
mixed_objects
+ test6    | DROP TABLE foobar.foo CASCADE;      | DROP TABLE      | 
mixed_objects
+ test5    | DROP TABLE foobar.foo CASCADE;      | DROP TABLE      | 
mixed_objects
+ test8    | DROP TABLE foo, foobar.foo CASCADE; | DROP TABLE      | 
mixed_objects
+ test7    | DROP TABLE foo, foobar.foo CASCADE; | DROP TABLE      | 
mixed_objects
 (10 rows)
 
 SELECT 1 AS myfield INTO foobar.foo;
@@ -51,18 +51,18 @@
 WARNING:  Unhandled deployment logged in pgl_ddl_deploy.unhandled
 WARNING:  Unhandled deployment logged in pgl_ddl_deploy.unhandled
 SELECT set_name, ddl_sql_raw, ddl_sql_sent FROM pgl_ddl_deploy.events ORDER BY 
id DESC LIMIT 10;
- set_name |          ddl_sql_raw           |          ddl_sql_sent          
-----------+--------------------------------+--------------------------------
- test4    | DROP TABLE foo CASCADE;        | DROP TABLE foo CASCADE;
- test3    | DROP TABLE foo CASCADE;        | DROP TABLE foo CASCADE;
- test2    | DROP TABLE foo CASCADE;        | DROP TABLE foo CASCADE;
- test1    | DROP TABLE foo CASCADE;        | DROP TABLE foo CASCADE;
- test8    | DROP TABLE foobar.foo CASCADE; | DROP TABLE foobar.foo CASCADE;
- test7    | DROP TABLE foobar.foo CASCADE; | DROP TABLE foobar.foo CASCADE;
- test6    | DROP TABLE foobar.foo CASCADE; | DROP TABLE foobar.foo CASCADE;
- test5    | DROP TABLE foobar.foo CASCADE; | DROP TABLE foobar.foo CASCADE;
- test4    | DROP TABLE foobar.foo CASCADE; | DROP TABLE foobar.foo CASCADE;
- test3    | DROP TABLE foobar.foo CASCADE; | DROP TABLE foobar.foo CASCADE;
+ set_name |                           ddl_sql_raw                            | 
                          ddl_sql_sent                           
+----------+------------------------------------------------------------------+------------------------------------------------------------------
+ test4    | DROP TABLE foo CASCADE;                                          | 
DROP TABLE foo CASCADE;
+ test3    | DROP TABLE foo CASCADE;                                          | 
DROP TABLE foo CASCADE;
+ test2    | DROP TABLE foo CASCADE;                                          | 
DROP TABLE foo CASCADE;
+ test1    | DROP TABLE foo CASCADE;                                          | 
DROP TABLE foo CASCADE;
+ test4    | DROP TABLE foobar.foo CASCADE;                                   | 
DROP TABLE foobar.foo CASCADE;
+ test3    | DROP TABLE foobar.foo CASCADE;                                   | 
DROP TABLE foobar.foo CASCADE;
+ test2    | DROP TABLE foobar.foo CASCADE;                                   | 
DROP TABLE foobar.foo CASCADE;
+ test1    | DROP TABLE foobar.foo CASCADE;                                   | 
DROP TABLE foobar.foo CASCADE;
+ test8    | ALTER TABLE foobar.foo ADD COLUMN foo_id INT REFERENCES foo(id); | 
ALTER TABLE foobar.foo ADD COLUMN foo_id INT REFERENCES foo(id);
+ test7    | ALTER TABLE foobar.foo ADD COLUMN foo_id INT REFERENCES foo(id); | 
ALTER TABLE foobar.foo ADD COLUMN foo_id INT REFERENCES foo(id);
 (10 rows)
 
 SELECT set_name, ddl_sql_raw, command_tag, reason FROM 
pgl_ddl_deploy.unhandled ORDER BY id DESC LIMIT 10;
diff -U3 /<<PKGBUILDDIR>>/expected/52_sub_retries.out 
/<<PKGBUILDDIR>>/results/52_sub_retries.out
--- /<<PKGBUILDDIR>>/expected/52_sub_retries.out        2023-11-29 
20:12:27.000000000 +0000
+++ /<<PKGBUILDDIR>>/results/52_sub_retries.out 2026-03-14 17:46:30.893429164 
+0000
@@ -236,10 +236,6 @@
  {test2}               | Q            | "\n        SELECT p 
[too-long-redacted] ver := ?\n        );\n        "
  {test3}               | Q            | "\n        SELECT 
pgl_ddl_deploy.subscriber_command\n        (\n          p_provider_name := ?,\n 
         p_set_name := ARRAY['test3'],\n          p_nspname := NULL,\n          
p_relname := NULL,\n          p_ddl_sql_sent := $pgl_ddl_deploy_sql$DROP TABLE 
foobar.foo CASCADE;$pgl_ddl_deploy_sql$,\n          p_full_ddl := 
$pgl_ddl_deploy_sql$\n        --Be sure to use provider's search_path for SQL 
environment consistency\n            SET SEARCH_PATH TO \"$user\", public;\n\n  
          DROP TABLE foobar.foo CASCADE;\n            ;\n        
$pgl_ddl_deploy_sql$,\n          p_pid := ?,\n          p_set_config_id := 3,\n 
         p_queue_subscriber_failures := false,\n          
p_signal_blocking_subscriber_sessions := NULL,\n          p_lock_timeout := 
3000,\n          p_driver := ?\n        );\n        "
  {test4}               | Q            | "\n        SELECT 
pgl_ddl_deploy.subscriber_command\n        (\n          p_provider_name := ?,\n 
         p_set_name := ARRAY['test4'],\n          p_nspname := NULL,\n          
p_relname := NULL,\n          p_ddl_sql_sent := $pgl_ddl_deploy_sql$DROP TABLE 
foobar.foo CASCADE;$pgl_ddl_deploy_sql$,\n          p_full_ddl := 
$pgl_ddl_deploy_sql$\n        --Be sure to use provider's search_path for SQL 
environment consistency\n            SET SEARCH_PATH TO \"$user\", public;\n\n  
          DROP TABLE foobar.foo CASCADE;\n            ;\n        
$pgl_ddl_deploy_sql$,\n          p_pid := ?,\n          p_set_config_id := 4,\n 
         p_queue_subscriber_failures := false,\n          
p_signal_blocking_subscriber_sessions := NULL,\n          p_lock_timeout := 
3000,\n          p_driver := ?\n        );\n        "
- {test5}               | Q            | "\n        SELECT p 
[too-long-redacted] ver := ?\n        );\n        "
- {test6}               | Q            | "\n        SELECT p 
[too-long-redacted] ver := ?\n        );\n        "
- {test7}               | Q            | "\n        SELECT 
pgl_ddl_deploy.subscriber_command\n        (\n          p_provider_name := ?,\n 
         p_set_name := ARRAY['test7'],\n          p_nspname := NULL,\n          
p_relname := NULL,\n          p_ddl_sql_sent := $pgl_ddl_deploy_sql$DROP TABLE 
foobar.foo CASCADE;$pgl_ddl_deploy_sql$,\n          p_full_ddl := 
$pgl_ddl_deploy_sql$\n        --Be sure to use provider's search_path for SQL 
environment consistency\n            SET SEARCH_PATH TO \"$user\", public;\n\n  
          DROP TABLE foobar.foo CASCADE;\n            ;\n        
$pgl_ddl_deploy_sql$,\n          p_pid := ?,\n          p_set_config_id := 7,\n 
         p_queue_subscriber_failures := false,\n          
p_signal_blocking_subscriber_sessions := NULL,\n          p_lock_timeout := 
3000,\n          p_driver := ?\n        );\n        "
- {test8}               | Q            | "\n        SELECT 
pgl_ddl_deploy.subscriber_command\n        (\n          p_provider_name := ?,\n 
         p_set_name := ARRAY['test8'],\n          p_nspname := NULL,\n          
p_relname := NULL,\n          p_ddl_sql_sent := $pgl_ddl_deploy_sql$DROP TABLE 
foobar.foo CASCADE;$pgl_ddl_deploy_sql$,\n          p_full_ddl := 
$pgl_ddl_deploy_sql$\n        --Be sure to use provider's search_path for SQL 
environment consistency\n            SET SEARCH_PATH TO \"$user\", public;\n\n  
          DROP TABLE foobar.foo CASCADE;\n            ;\n        
$pgl_ddl_deploy_sql$,\n          p_pid := ?,\n          p_set_config_id := 8,\n 
         p_queue_subscriber_failures := false,\n          
p_signal_blocking_subscriber_sessions := NULL,\n          p_lock_timeout := 
3000,\n          p_driver := ?\n        );\n        "
  {test1}               | Q            | "\n        SELECT p 
[too-long-redacted] ver := ?\n        );\n        "
  {test2}               | Q            | "\n        SELECT p 
[too-long-redacted] ver := ?\n        );\n        "
  {test3}               | Q            | "\n        SELECT 
pgl_ddl_deploy.subscriber_command\n        (\n          p_provider_name := ?,\n 
         p_set_name := ARRAY['test3'],\n          p_nspname := NULL,\n          
p_relname := NULL,\n          p_ddl_sql_sent := $pgl_ddl_deploy_sql$DROP TABLE 
foo CASCADE;$pgl_ddl_deploy_sql$,\n          p_full_ddl := 
$pgl_ddl_deploy_sql$\n        --Be sure to use provider's search_path for SQL 
environment consistency\n            SET SEARCH_PATH TO \"$user\", public;\n\n  
          DROP TABLE foo CASCADE;\n            ;\n        
$pgl_ddl_deploy_sql$,\n          p_pid := ?,\n          p_set_config_id := 3,\n 
         p_queue_subscriber_failures := false,\n          
p_signal_blocking_subscriber_sessions := NULL,\n          p_lock_timeout := 
3000,\n          p_driver := ?\n        );\n        "
@@ -436,7 +432,7 @@
  {test_ddl_only}       | Q            | "\n        SELECT 
pgl_ddl_deploy.subscriber_command\n        (\n          p_provider_name := ?,\n 
         p_set_name := ARRAY['test_ddl_only'],\n          p_nspname := 
'duper',\n          p_relname := 'man',\n          p_ddl_sql_sent := 
$pgl_ddl_deploy_sql$ALTER TABLE duper.man ADD COLUMN foo 
text;$pgl_ddl_deploy_sql$,\n          p_full_ddl := $pgl_ddl_deploy_sql$\n      
  --Be sure to use provider's search_path for SQL environment consistency\n     
       SET SEARCH_PATH TO '';\n\n            ALTER TABLE duper.man ADD COLUMN 
foo text;\n            ;\n        $pgl_ddl_deploy_sql$,\n          p_pid := 
?,\n          p_set_config_id := 20,\n          p_queue_subscriber_failures := 
false,\n          p_signal_blocking_subscriber_sessions := NULL,\n          
p_lock_timeout := 3000,\n          p_driver := ?\n        );\n        "
  {test_ddl_only}       | Q            | "\n        SELECT 
pgl_ddl_deploy.subscriber_command\n        (\n          p_provider_name := ?,\n 
         p_set_name := ARRAY['test_ddl_only'],\n          p_nspname := NULL,\n  
        p_relname := NULL,\n          p_ddl_sql_sent := 
$pgl_ddl_deploy_sql$DROP TABLE super.man CASCADE;$pgl_ddl_deploy_sql$,\n        
  p_full_ddl := $pgl_ddl_deploy_sql$\n        --Be sure to use provider's 
search_path for SQL environment consistency\n            SET SEARCH_PATH TO 
'';\n\n            DROP TABLE super.man CASCADE;\n            ;\n        
$pgl_ddl_deploy_sql$,\n          p_pid := ?,\n          p_set_config_id := 
19,\n          p_queue_subscriber_failures := false,\n          
p_signal_blocking_subscriber_sessions := NULL,\n          p_lock_timeout := 
3000,\n          p_driver := ?\n        );\n        "
  {test_ddl_only}       | Q            | "\n        SELECT 
pgl_ddl_deploy.subscriber_command\n        (\n          p_provider_name := ?,\n 
         p_set_name := ARRAY['test_ddl_only'],\n          p_nspname := NULL,\n  
        p_relname := NULL,\n          p_ddl_sql_sent := 
$pgl_ddl_deploy_sql$DROP TABLE duper.man;$pgl_ddl_deploy_sql$,\n          
p_full_ddl := $pgl_ddl_deploy_sql$\n        --Be sure to use provider's 
search_path for SQL environment consistency\n            SET SEARCH_PATH TO 
'';\n\n            DROP TABLE duper.man;\n            ;\n        
$pgl_ddl_deploy_sql$,\n          p_pid := ?,\n          p_set_config_id := 
20,\n          p_queue_subscriber_failures := false,\n          
p_signal_blocking_subscriber_sessions := NULL,\n          p_lock_timeout := 
3000,\n          p_driver := ?\n        );\n        "
-(432 rows)
+(428 rows)
 
 DO $$
 DECLARE v_ct INT;
### End 17 installcheck (FAILED with exit code 1) ###
make[1]: *** [debian/rules:4: override_dh_pgxs_test] Error 1
make[1]: Leaving directory '/<<PKGBUILDDIR>>'
make: *** [debian/rules:9: binary] Error 2
dpkg-buildpackage: error: debian/rules binary subprocess returned exit status 2
--------------------------------------------------------------------------------

--- End Message ---

--- Begin Message ---

Version: 2.2.1-2+rm

Re: Santiago Vila
> During a rebuild of all packages in trixie, this package failed to build.

The package has been removed from unstable already.

Christoph

--- End Message ---

Bug#1131248: marked as done (pgl-ddl-deploy: FTBFS in trixie: override_dh_pgxs_test fails)

Reply via email to