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 --------------------------------------------------------------------------------
