Diff of the two buildlogs: -- --- b1/build.log 2024-06-01 20:41:07.811418055 +0000 +++ b2/build.log 2024-06-01 20:47:26.603298174 +0000 @@ -1,6 +1,6 @@ I: pbuilder: network access will be disabled during build -I: Current time: Fri Jul 4 15:01:10 -12 2025 -I: pbuilder-time-stamp: 1751684470 +I: Current time: Sun Jun 2 10:41:12 +14 2024 +I: pbuilder-time-stamp: 1717274472 I: Building the build Environment I: extracting base tarball [/var/cache/pbuilder/unstable-reproducible-base.tgz] I: copying local configuration @@ -25,52 +25,84 @@ dpkg-source: info: unpacking pgl-ddl-deploy_2.2.1-1.debian.tar.xz I: Not using root during the build. I: Installing the build-deps -I: user script /srv/workspace/pbuilder/2631667/tmp/hooks/D02_print_environment starting +I: user script /srv/workspace/pbuilder/2076054/tmp/hooks/D01_modify_environment starting +debug: Running on ionos1-amd64. +I: Changing host+domainname to test build reproducibility +I: Adding a custom variable just for the fun of it... +I: Changing /bin/sh to bash +'/bin/sh' -> '/bin/bash' +lrwxrwxrwx 1 root root 9 Jun 1 20:41 /bin/sh -> /bin/bash +I: Setting pbuilder2's login shell to /bin/bash +I: Setting pbuilder2's GECOS to second user,second room,second work-phone,second home-phone,second other +I: user script /srv/workspace/pbuilder/2076054/tmp/hooks/D01_modify_environment finished +I: user script /srv/workspace/pbuilder/2076054/tmp/hooks/D02_print_environment starting I: set - BUILDDIR='/build/reproducible-path' - BUILDUSERGECOS='first user,first room,first work-phone,first home-phone,first other' - BUILDUSERNAME='pbuilder1' - BUILD_ARCH='amd64' - DEBIAN_FRONTEND='noninteractive' - DEB_BUILD_OPTIONS='buildinfo=+all reproducible=+all parallel=42 ' - DISTRIBUTION='unstable' - HOME='/root' - HOST_ARCH='amd64' + BASH=/bin/sh + BASHOPTS=checkwinsize:cmdhist:complete_fullquote:extquote:force_fignore:globasciiranges:globskipdots:hostcomplete:interactive_comments:patsub_replacement:progcomp:promptvars:sourcepath + BASH_ALIASES=() + BASH_ARGC=() + BASH_ARGV=() + BASH_CMDS=() + BASH_LINENO=([0]="12" [1]="0") + BASH_LOADABLES_PATH=/usr/local/lib/bash:/usr/lib/bash:/opt/local/lib/bash:/usr/pkg/lib/bash:/opt/pkg/lib/bash:. + BASH_SOURCE=([0]="/tmp/hooks/D02_print_environment" [1]="/tmp/hooks/D02_print_environment") + BASH_VERSINFO=([0]="5" [1]="2" [2]="21" [3]="1" [4]="release" [5]="x86_64-pc-linux-gnu") + BASH_VERSION='5.2.21(1)-release' + BUILDDIR=/build/reproducible-path + BUILDUSERGECOS='second user,second room,second work-phone,second home-phone,second other' + BUILDUSERNAME=pbuilder2 + BUILD_ARCH=amd64 + DEBIAN_FRONTEND=noninteractive + DEB_BUILD_OPTIONS='buildinfo=+all reproducible=+all parallel=20 ' + DIRSTACK=() + DISTRIBUTION=unstable + EUID=0 + FUNCNAME=([0]="Echo" [1]="main") + GROUPS=() + HOME=/root + HOSTNAME=i-capture-the-hostname + HOSTTYPE=x86_64 + HOST_ARCH=amd64 IFS=' ' - INVOCATION_ID='ee314e8e23f94526bd1e21bdd52d6079' - LANG='C' - LANGUAGE='en_US:en' - LC_ALL='C' - MAIL='/var/mail/root' - OPTIND='1' - PATH='/usr/sbin:/usr/bin:/sbin:/bin:/usr/games' - PBCURRENTCOMMANDLINEOPERATION='build' - PBUILDER_OPERATION='build' - PBUILDER_PKGDATADIR='/usr/share/pbuilder' - PBUILDER_PKGLIBDIR='/usr/lib/pbuilder' - PBUILDER_SYSCONFDIR='/etc' - PPID='2631667' - PS1='# ' - PS2='> ' + INVOCATION_ID=b9455e038f3a43d3954861398c69acca + LANG=C + LANGUAGE=et_EE:et + LC_ALL=C + MACHTYPE=x86_64-pc-linux-gnu + MAIL=/var/mail/root + OPTERR=1 + OPTIND=1 + OSTYPE=linux-gnu + PATH=/usr/sbin:/usr/bin:/sbin:/bin:/usr/games:/i/capture/the/path + PBCURRENTCOMMANDLINEOPERATION=build + PBUILDER_OPERATION=build + PBUILDER_PKGDATADIR=/usr/share/pbuilder + PBUILDER_PKGLIBDIR=/usr/lib/pbuilder + PBUILDER_SYSCONFDIR=/etc + PIPESTATUS=([0]="0") + POSIXLY_CORRECT=y + PPID=2076054 PS4='+ ' - PWD='/' - SHELL='/bin/bash' - SHLVL='2' - SUDO_COMMAND='/usr/bin/timeout -k 18.1h 18h /usr/bin/ionice -c 3 /usr/bin/nice /usr/sbin/pbuilder --build --configfile /srv/reproducible-results/rbuild-debian/r-b-build.M72ELguB/pbuilderrc_nQ2n --distribution unstable --hookdir /etc/pbuilder/first-build-hooks --debbuildopts -b --basetgz /var/cache/pbuilder/unstable-reproducible-base.tgz --buildresult /srv/reproducible-results/rbuild-debian/r-b-build.M72ELguB/b1 --logfile b1/build.log pgl-ddl-deploy_2.2.1-1.dsc' - SUDO_GID='111' - SUDO_UID='106' - SUDO_USER='jenkins' - TERM='unknown' - TZ='/usr/share/zoneinfo/Etc/GMT+12' - USER='root' - _='/usr/bin/systemd-run' - http_proxy='http://213.165.73.152:3128' + PWD=/ + SHELL=/bin/bash + SHELLOPTS=braceexpand:errexit:hashall:interactive-comments:posix + SHLVL=3 + SUDO_COMMAND='/usr/bin/timeout -k 24.1h 24h /usr/bin/ionice -c 3 /usr/bin/nice -n 11 /usr/bin/unshare --uts -- /usr/sbin/pbuilder --build --configfile /srv/reproducible-results/rbuild-debian/r-b-build.M72ELguB/pbuilderrc_Wlmq --distribution unstable --hookdir /etc/pbuilder/rebuild-hooks --debbuildopts -b --basetgz /var/cache/pbuilder/unstable-reproducible-base.tgz --buildresult /srv/reproducible-results/rbuild-debian/r-b-build.M72ELguB/b2 --logfile b2/build.log pgl-ddl-deploy_2.2.1-1.dsc' + SUDO_GID=110 + SUDO_UID=105 + SUDO_USER=jenkins + TERM=unknown + TZ=/usr/share/zoneinfo/Etc/GMT-14 + UID=0 + USER=root + _='I: set' + http_proxy=http://46.16.76.132:3128 I: uname -a - Linux ionos15-amd64 6.7.12+bpo-amd64 #1 SMP PREEMPT_DYNAMIC Debian 6.7.12-1~bpo12+1 (2024-05-06) x86_64 GNU/Linux + Linux i-capture-the-hostname 6.1.0-21-amd64 #1 SMP PREEMPT_DYNAMIC Debian 6.1.90-1 (2024-05-03) x86_64 GNU/Linux I: ls -l /bin - lrwxrwxrwx 1 root root 7 Jun 30 14:05 /bin -> usr/bin -I: user script /srv/workspace/pbuilder/2631667/tmp/hooks/D02_print_environment finished + lrwxrwxrwx 1 root root 7 Jun 1 07:43 /bin -> usr/bin +I: user script /srv/workspace/pbuilder/2076054/tmp/hooks/D02_print_environment finished -> Attempting to satisfy build-dependencies -> Creating pbuilder-satisfydepends-dummy package Package: pbuilder-satisfydepends-dummy @@ -224,7 +256,7 @@ Get: 110 http://deb.debian.org/debian unstable/main amd64 postgresql-plpython3-16 amd64 16.3-1 [110 kB] Get: 111 http://deb.debian.org/debian unstable/main amd64 postgresql-pltcl-16 amd64 16.3-1 [40.5 kB] Get: 112 http://deb.debian.org/debian unstable/main amd64 postgresql-all all 260 [11.9 kB] -Fetched 182 MB in 14s (13.3 MB/s) +Fetched 182 MB in 7s (26.0 MB/s) debconf: delaying package configuration, since apt-utils is not installed Selecting previously unselected package libjson-perl. (Reading database ... (Reading database ... 5% (Reading database ... 10% (Reading database ... 15% (Reading database ... 20% (Reading database ... 25% (Reading database ... 30% (Reading database ... 35% (Reading database ... 40% (Reading database ... 45% (Reading database ... 50% (Reading database ... 55% (Reading database ... 60% (Reading database ... 65% (Reading database ... 70% (Reading database ... 75% (Reading database ... 80% (Reading database ... 85% (Reading database ... 90% (Reading database ... 95% (Reading database ... 100% (Reading database ... 19719 files and directories currently installed.) @@ -600,8 +632,8 @@ Setting up tzdata (2024a-4) ... Current default time zone: 'Etc/UTC' -Local time is now: Sat Jul 5 03:02:26 UTC 2025. -Universal Time is now: Sat Jul 5 03:02:26 UTC 2025. +Local time is now: Sat Jun 1 20:44:32 UTC 2024. +Universal Time is now: Sat Jun 1 20:44:32 UTC 2024. Run 'dpkg-reconfigure tzdata' if you wish to change it. Setting up autotools-dev (20220109.1) ... @@ -703,7 +735,7 @@ selecting dynamic shared memory implementation ... posix selecting default max_connections ... 100 selecting default shared_buffers ... 128MB -selecting default time zone ... /usr/share/zoneinfo/Etc/GMT+12 +selecting default time zone ... /usr/share/zoneinfo/Etc/GMT-14 creating configuration files ... ok running bootstrap script ... ok performing post-bootstrap initialization ... ok @@ -731,7 +763,11 @@ Building tag database... -> Finished parsing the build-deps I: Building the package -I: Running cd /build/reproducible-path/pgl-ddl-deploy-2.2.1/ && env PATH="/usr/sbin:/usr/bin:/sbin:/bin:/usr/games" HOME="/nonexistent/first-build" dpkg-buildpackage -us -uc -b && env PATH="/usr/sbin:/usr/bin:/sbin:/bin:/usr/games" HOME="/nonexistent/first-build" dpkg-genchanges -S > ../pgl-ddl-deploy_2.2.1-1_source.changes +I: user script /srv/workspace/pbuilder/2076054/tmp/hooks/A99_set_merged_usr starting +Not re-configuring usrmerge for unstable +I: user script /srv/workspace/pbuilder/2076054/tmp/hooks/A99_set_merged_usr finished +hostname: Name or service not known +I: Running cd /build/reproducible-path/pgl-ddl-deploy-2.2.1/ && env PATH="/usr/sbin:/usr/bin:/sbin:/bin:/usr/games:/i/capture/the/path" HOME="/nonexistent/second-build" dpkg-buildpackage -us -uc -b && env PATH="/usr/sbin:/usr/bin:/sbin:/bin:/usr/games:/i/capture/the/path" HOME="/nonexistent/second-build" dpkg-genchanges -S > ../pgl-ddl-deploy_2.2.1-1_source.changes dpkg-buildpackage: info: source package pgl-ddl-deploy dpkg-buildpackage: info: source version 2.2.1-1 dpkg-buildpackage: info: source distribution unstable @@ -802,125 +838,259 @@ ### PostgreSQL 16 installcheck ### Creating new PostgreSQL cluster 16/regress ... Warning: connection to the database failed, disabling startup checks: -psql: error: connection to server on socket "/tmp/.s.PGSQL.5432" failed: FATAL: role "pbuilder1" does not exist +psql: error: connection to server on socket "/tmp/.s.PGSQL.5432" failed: FATAL: role "pbuilder2" does not exist make[2]: Entering directory '/build/reproducible-path/pgl-ddl-deploy-2.2.1' echo "# +++ regress install-check in +++" && /usr/lib/postgresql/16/lib/pgxs/src/makefiles/../../src/test/regress/pg_regress --inputdir=./ --bindir='/usr/lib/postgresql/16/bin' --dbname=contrib_regression 01_create_ext 02_setup 03_add_configs 04_deploy 04_deploy_update 05_allowed 06_multi 07_edges 08_ignored 09_unsupported 10_no_create_user 11_override 12_sql_command_tags 13_transaction 15_new_set_behavior 16_multi_set_tags 17_include_only_repset_tables_1 18_include_only_repset_tables_2 19_include_only_repset_tables_3 20_include_only_repset_tables_4 21_unprivileged_users 22_is_deployed 23_1_4_features 24_sub_retries 25_1_5_features 26_new_setup 27_raise_message 28_1_6_features 29_create_ext 30_setup 31_add_configs 32_deploy_update 33_allowed 34_multi 35_edges 36_ignored 37_unsupported 38_no_create_user 39_override 40_sql_command_tags 41_transaction 43_new_set_behavior 44_multi_set_tags 45_include_only_repset_tables_1 46_include_only_repset_tables_2 47_include_only_repset_tables_3 48_include_only_repset_tables_4 49_unprivileged_users 50_is_deployed 51_1_4_features 52_sub_retries 53_1_5_features 54_new_setup 55_raise_message 56_1_6_features 57_native_features # +++ regress install-check in +++ # using postmaster on localhost, port 5432 # could not set core size: disallowed by hard limit -ok 1 - 01_create_ext 861 ms -ok 2 - 02_setup 35 ms -ok 3 - 03_add_configs 29 ms -ok 4 - 04_deploy 223 ms -ok 5 - 04_deploy_update 744 ms -ok 6 - 05_allowed 594 ms -ok 7 - 06_multi 2902 ms -ok 8 - 07_edges 125 ms -ok 9 - 08_ignored 69 ms -ok 10 - 09_unsupported 73 ms -ok 11 - 10_no_create_user 51 ms -ok 12 - 11_override 26 ms -ok 13 - 12_sql_command_tags 23 ms -ok 14 - 13_transaction 137 ms -ok 15 - 15_new_set_behavior 136 ms -ok 16 - 16_multi_set_tags 112 ms -ok 17 - 17_include_only_repset_tables_1 310 ms -ok 18 - 18_include_only_repset_tables_2 107 ms -ok 19 - 19_include_only_repset_tables_3 154 ms -ok 20 - 20_include_only_repset_tables_4 900 ms -ok 21 - 21_unprivileged_users 49 ms -ok 22 - 22_is_deployed 377 ms -ok 23 - 23_1_4_features 271 ms -ok 24 - 24_sub_retries 158 ms -ok 25 - 25_1_5_features 25538 ms -ok 26 - 26_new_setup 301 ms -ok 27 - 27_raise_message 26 ms -ok 28 - 28_1_6_features 113 ms -ok 29 - 29_create_ext 166 ms -ok 30 - 30_setup 42 ms -ok 31 - 31_add_configs 31 ms -ok 32 - 32_deploy_update 178 ms -ok 33 - 33_allowed 294 ms -ok 34 - 34_multi 1101 ms -ok 35 - 35_edges 125 ms -ok 36 - 36_ignored 75 ms -ok 37 - 37_unsupported 75 ms -ok 38 - 38_no_create_user 58 ms -ok 39 - 39_override 28 ms -ok 40 - 40_sql_command_tags 25 ms -ok 41 - 41_transaction 137 ms -ok 42 - 43_new_set_behavior 341 ms -ok 43 - 44_multi_set_tags 111 ms -ok 44 - 45_include_only_repset_tables_1 106 ms -ok 45 - 46_include_only_repset_tables_2 127 ms -ok 46 - 47_include_only_repset_tables_3 119 ms -ok 47 - 48_include_only_repset_tables_4 195 ms -ok 48 - 49_unprivileged_users 65 ms -ok 49 - 50_is_deployed 1531 ms -ok 50 - 51_1_4_features 210 ms -ok 51 - 52_sub_retries 182 ms -ok 52 - 53_1_5_features 25882 ms -ok 53 - 54_new_setup 169 ms -ok 54 - 55_raise_message 28 ms -ok 55 - 56_1_6_features 81 ms -ok 56 - 57_native_features 190 ms +ok 1 - 01_create_ext 608 ms +ok 2 - 02_setup 251 ms +ok 3 - 03_add_configs 180 ms +ok 4 - 04_deploy 615 ms +ok 5 - 04_deploy_update 535 ms +ok 6 - 05_allowed 1707 ms +ok 7 - 06_multi 6250 ms +ok 8 - 07_edges 747 ms +ok 9 - 08_ignored 379 ms +ok 10 - 09_unsupported 423 ms +ok 11 - 10_no_create_user 211 ms +ok 12 - 11_override 187 ms +ok 13 - 12_sql_command_tags 178 ms +ok 14 - 13_transaction 459 ms +ok 15 - 15_new_set_behavior 575 ms +ok 16 - 16_multi_set_tags 733 ms +ok 17 - 17_include_only_repset_tables_1 479 ms +ok 18 - 18_include_only_repset_tables_2 527 ms +ok 19 - 19_include_only_repset_tables_3 611 ms +ok 20 - 20_include_only_repset_tables_4 1127 ms +ok 21 - 21_unprivileged_users 319 ms +ok 22 - 22_is_deployed 1855 ms +ok 23 - 23_1_4_features 725 ms +ok 24 - 24_sub_retries 927 ms +not ok 25 - 25_1_5_features 21575 ms +ok 26 - 26_new_setup 703 ms +ok 27 - 27_raise_message 83 ms +ok 28 - 28_1_6_features 447 ms +ok 29 - 29_create_ext 1038 ms +ok 30 - 30_setup 211 ms +ok 31 - 31_add_configs 235 ms +ok 32 - 32_deploy_update 675 ms +ok 33 - 33_allowed 1839 ms +ok 34 - 34_multi 5476 ms +ok 35 - 35_edges 654 ms +ok 36 - 36_ignored 371 ms +ok 37 - 37_unsupported 301 ms +ok 38 - 38_no_create_user 267 ms +ok 39 - 39_override 203 ms +ok 40 - 40_sql_command_tags 179 ms +ok 41 - 41_transaction 683 ms +ok 42 - 43_new_set_behavior 610 ms +ok 43 - 44_multi_set_tags 703 ms +ok 44 - 45_include_only_repset_tables_1 339 ms +ok 45 - 46_include_only_repset_tables_2 623 ms +ok 46 - 47_include_only_repset_tables_3 428 ms +ok 47 - 48_include_only_repset_tables_4 1007 ms +ok 48 - 49_unprivileged_users 299 ms +ok 49 - 50_is_deployed 1643 ms +ok 50 - 51_1_4_features 415 ms +ok 51 - 52_sub_retries 768 ms +not ok 52 - 53_1_5_features 22252 ms +ok 53 - 54_new_setup 780 ms +ok 54 - 55_raise_message 99 ms +ok 55 - 56_1_6_features 403 ms +ok 56 - 57_native_features 571 ms 1..56 -# All 56 tests passed. +# 2 of 56 tests failed. +# The differences that caused some tests to fail can be viewed in the file "/build/reproducible-path/pgl-ddl-deploy-2.2.1/regression.diffs". +# A copy of the test summary that you see above is saved in the file "/build/reproducible-path/pgl-ddl-deploy-2.2.1/regression.out". +make[2]: *** [/usr/lib/postgresql/16/lib/pgxs/src/makefiles/pgxs.mk:436: installcheck] Error 1 make[2]: Leaving directory '/build/reproducible-path/pgl-ddl-deploy-2.2.1' +*** /tmp/pg_virtualenv.yiNPx0/log/postgresql-16-regress.log (last 100 lines) *** + RESET session_replication_role; + ELSE + SELECT COUNT(1) INTO v_ct FROM pgl_ddl_deploy.subscriber_logs; + PERFORM verify_count(v_ct, 0); + END IF; + + END$$; +2024-06-02 10:47:19.961 /USR/SHARE/ZONEINFO/ETC/GMT [2126686] postgres@contrib_regression LOG: ct: 3 +2024-06-02 10:47:19.961 /USR/SHARE/ZONEINFO/ETC/GMT [2126686] postgres@contrib_regression CONTEXT: PL/pgSQL function verify_count(integer,integer) line 4 at RAISE + SQL statement "SELECT verify_count(v_ct, 3)" + PL/pgSQL function inline_code_block line 13 at PERFORM +2024-06-02 10:47:19.961 /USR/SHARE/ZONEINFO/ETC/GMT [2126686] postgres@contrib_regression STATEMENT: DO $$ + DECLARE v_ct INT; + BEGIN + + IF current_setting('server_version_num')::INT >= 100000 THEN + SELECT COUNT(1) INTO v_ct FROM information_schema.columns WHERE table_name = 'nativerox'; + PERFORM verify_count(v_ct, 2); + SELECT COUNT(1) INTO v_ct FROM pgl_ddl_deploy.subscriber_logs; + PERFORM verify_count(v_ct, 1); + PERFORM pgl_ddl_deploy.retry_all_subscriber_logs(); + SELECT (SELECT COUNT(1) FROM pgl_ddl_deploy.subscriber_logs WHERE NOT succeeded) + + (SELECT COUNT(1) FROM pgl_ddl_deploy.subscriber_logs WHERE error_message ~* 'No subscription to publication mock exists') INTO v_ct; + PERFORM verify_count(v_ct, 3); + -- test for duplicate avoidance with multiple subscriptions + SELECT COUNT(1) INTO v_ct FROM pgl_ddl_deploy.queue; + PERFORM verify_count(v_ct, 3); + SET session_replication_role TO replica; + INSERT INTO pgl_ddl_deploy.queue SELECT * FROM pgl_ddl_deploy.queue; + SELECT COUNT(1) INTO v_ct FROM pgl_ddl_deploy.queue; + PERFORM verify_count(v_ct, 3); + RESET session_replication_role; + ELSE + SELECT COUNT(1) INTO v_ct FROM pgl_ddl_deploy.subscriber_logs; + PERFORM verify_count(v_ct, 0); + END IF; + + END$$; +2024-06-02 10:47:19.961 /USR/SHARE/ZONEINFO/ETC/GMT [2126686] postgres@contrib_regression LOG: ct: 3 +2024-06-02 10:47:19.961 /USR/SHARE/ZONEINFO/ETC/GMT [2126686] postgres@contrib_regression CONTEXT: PL/pgSQL function verify_count(integer,integer) line 4 at RAISE + SQL statement "SELECT verify_count(v_ct, 3)" + PL/pgSQL function inline_code_block line 16 at PERFORM +2024-06-02 10:47:19.961 /USR/SHARE/ZONEINFO/ETC/GMT [2126686] postgres@contrib_regression STATEMENT: DO $$ + DECLARE v_ct INT; + BEGIN + + IF current_setting('server_version_num')::INT >= 100000 THEN + SELECT COUNT(1) INTO v_ct FROM information_schema.columns WHERE table_name = 'nativerox'; + PERFORM verify_count(v_ct, 2); + SELECT COUNT(1) INTO v_ct FROM pgl_ddl_deploy.subscriber_logs; + PERFORM verify_count(v_ct, 1); + PERFORM pgl_ddl_deploy.retry_all_subscriber_logs(); + SELECT (SELECT COUNT(1) FROM pgl_ddl_deploy.subscriber_logs WHERE NOT succeeded) + + (SELECT COUNT(1) FROM pgl_ddl_deploy.subscriber_logs WHERE error_message ~* 'No subscription to publication mock exists') INTO v_ct; + PERFORM verify_count(v_ct, 3); + -- test for duplicate avoidance with multiple subscriptions + SELECT COUNT(1) INTO v_ct FROM pgl_ddl_deploy.queue; + PERFORM verify_count(v_ct, 3); + SET session_replication_role TO replica; + INSERT INTO pgl_ddl_deploy.queue SELECT * FROM pgl_ddl_deploy.queue; + SELECT COUNT(1) INTO v_ct FROM pgl_ddl_deploy.queue; + PERFORM verify_count(v_ct, 3); + RESET session_replication_role; + ELSE + SELECT COUNT(1) INTO v_ct FROM pgl_ddl_deploy.subscriber_logs; + PERFORM verify_count(v_ct, 0); + END IF; + + END$$; +2024-06-02 10:47:19.967 /USR/SHARE/ZONEINFO/ETC/GMT [2126686] postgres@contrib_regression LOG: ct: 3 +2024-06-02 10:47:19.967 /USR/SHARE/ZONEINFO/ETC/GMT [2126686] postgres@contrib_regression CONTEXT: PL/pgSQL function verify_count(integer,integer) line 4 at RAISE + SQL statement "SELECT verify_count(v_ct, 3)" + PL/pgSQL function inline_code_block line 20 at PERFORM +2024-06-02 10:47:19.967 /USR/SHARE/ZONEINFO/ETC/GMT [2126686] postgres@contrib_regression STATEMENT: DO $$ + DECLARE v_ct INT; + BEGIN + + IF current_setting('server_version_num')::INT >= 100000 THEN + SELECT COUNT(1) INTO v_ct FROM information_schema.columns WHERE table_name = 'nativerox'; + PERFORM verify_count(v_ct, 2); + SELECT COUNT(1) INTO v_ct FROM pgl_ddl_deploy.subscriber_logs; + PERFORM verify_count(v_ct, 1); + PERFORM pgl_ddl_deploy.retry_all_subscriber_logs(); + SELECT (SELECT COUNT(1) FROM pgl_ddl_deploy.subscriber_logs WHERE NOT succeeded) + + (SELECT COUNT(1) FROM pgl_ddl_deploy.subscriber_logs WHERE error_message ~* 'No subscription to publication mock exists') INTO v_ct; + PERFORM verify_count(v_ct, 3); + -- test for duplicate avoidance with multiple subscriptions + SELECT COUNT(1) INTO v_ct FROM pgl_ddl_deploy.queue; + PERFORM verify_count(v_ct, 3); + SET session_replication_role TO replica; + INSERT INTO pgl_ddl_deploy.queue SELECT * FROM pgl_ddl_deploy.queue; + SELECT COUNT(1) INTO v_ct FROM pgl_ddl_deploy.queue; + PERFORM verify_count(v_ct, 3); + RESET session_replication_role; + ELSE + SELECT COUNT(1) INTO v_ct FROM pgl_ddl_deploy.subscriber_logs; + PERFORM verify_count(v_ct, 0); + END IF; + + END$$; Dropping cluster 16/regress ... -make[2]: Entering directory '/build/reproducible-path/pgl-ddl-deploy-2.2.1' -rm -f pgl_ddl_deploy.so ddl_deparse.so pgl_ddl_deploy.o ddl_deparse.o \ - pgl_ddl_deploy.bc ddl_deparse.bc -rm -rf results/ regression.diffs regression.out tmp_check/ tmp_check_iso/ log/ output_iso/ -make[2]: Leaving directory '/build/reproducible-path/pgl-ddl-deploy-2.2.1' -### End 16 installcheck ### +**** regression.diffs **** +diff -U3 /build/reproducible-path/pgl-ddl-deploy-2.2.1/expected/25_1_5_features.out /build/reproducible-path/pgl-ddl-deploy-2.2.1/results/25_1_5_features.out +--- /build/reproducible-path/pgl-ddl-deploy-2.2.1/expected/25_1_5_features.out 2023-11-30 10:12:27.000000000 +1400 ++++ /build/reproducible-path/pgl-ddl-deploy-2.2.1/results/25_1_5_features.out 2024-06-02 10:46:34.210989143 +1400 +@@ -324,21 +324,18 @@ + id | bla + ----+----- + 1 | 1 +- 2 | 1 +-(2 rows) ++(1 row) + + DROP TABLE public.bar CASCADE; + SELECT signal, successful, state, query, reported + FROM pgl_ddl_deploy.killed_blockers + ORDER BY signal, query; +- signal | successful | state | query | reported +------------+------------+---------------------+---------------------------------------------------------------------+---------- +- cancel | t | active | BEGIN; SELECT * FROM public.foo; SELECT pg_sleep(30); | f +- cancel | t | idle in transaction | SELECT * FROM public.foo; | f +- terminate | t | active | BEGIN; ALTER TABLE public.foo DROP COLUMN bar; SELECT pg_sleep(30); | f +- terminate | t | active | BEGIN; SELECT * FROM public.foo; SELECT pg_sleep(30); | f +- terminate | t | idle in transaction | SELECT * FROM public.foo; | f +-(5 rows) ++ signal | successful | state | query | reported ++-----------+------------+--------+---------------------------------------------------------------------+---------- ++ cancel | t | active | BEGIN; SELECT * FROM public.foo; SELECT pg_sleep(30); | f ++ terminate | t | active | BEGIN; ALTER TABLE public.foo DROP COLUMN bar; SELECT pg_sleep(30); | f ++ terminate | t | active | BEGIN; SELECT * FROM public.foo; SELECT pg_sleep(30); | f ++(3 rows) + + SELECT pg_sleep(1); + pg_sleep +diff -U3 /build/reproducible-path/pgl-ddl-deploy-2.2.1/expected/53_1_5_features.out /build/reproducible-path/pgl-ddl-deploy-2.2.1/results/53_1_5_features.out +--- /build/reproducible-path/pgl-ddl-deploy-2.2.1/expected/53_1_5_features.out 2023-11-30 10:12:27.000000000 +1400 ++++ /build/reproducible-path/pgl-ddl-deploy-2.2.1/results/53_1_5_features.out 2024-06-02 10:47:17.997313735 +1400 +@@ -324,21 +324,18 @@ + id | bla + ----+----- + 1 | 1 +- 2 | 1 +-(2 rows) ++(1 row) + + DROP TABLE public.bar CASCADE; + SELECT signal, successful, state, query, reported + FROM pgl_ddl_deploy.killed_blockers + ORDER BY signal, query; +- signal | successful | state | query | reported +------------+------------+---------------------+---------------------------------------------------------------------+---------- +- cancel | t | active | BEGIN; SELECT * FROM public.foo; SELECT pg_sleep(30); | f +- cancel | t | idle in transaction | SELECT * FROM public.foo; | f +- terminate | t | active | BEGIN; ALTER TABLE public.foo DROP COLUMN bar; SELECT pg_sleep(30); | f +- terminate | t | active | BEGIN; SELECT * FROM public.foo; SELECT pg_sleep(30); | f +- terminate | t | idle in transaction | SELECT * FROM public.foo; | f +-(5 rows) ++ signal | successful | state | query | reported ++-----------+------------+--------+---------------------------------------------------------------------+---------- ++ cancel | t | active | BEGIN; SELECT * FROM public.foo; SELECT pg_sleep(30); | f ++ terminate | t | active | BEGIN; ALTER TABLE public.foo DROP COLUMN bar; SELECT pg_sleep(30); | f ++ terminate | t | active | BEGIN; SELECT * FROM public.foo; SELECT pg_sleep(30); | f ++(3 rows) + + SELECT pg_sleep(1); + pg_sleep +### End 16 installcheck (FAILED with exit code 1) ### +make[1]: *** [debian/rules:4: override_dh_pgxs_test] Error 1 make[1]: Leaving directory '/build/reproducible-path/pgl-ddl-deploy-2.2.1' - dh_strip_nondeterminism - dh_compress - dh_fixperms - dh_missing - dh_dwz -a - dh_strip -a - dh_makeshlibs -a - dh_shlibdeps -a - dh_installdeb - dh_gencontrol -dpkg-gencontrol: warning: Depends field of package postgresql-16-pgl-ddl-deploy: substitution variable ${shlibs:Depends} used, but is not defined -dpkg-gencontrol: warning: package postgresql-16-pgl-ddl-deploy: substitution variable ${postgresql:Depends} unused, but is defined -dpkg-gencontrol: warning: Depends field of package postgresql-16-pgl-ddl-deploy: substitution variable ${shlibs:Depends} used, but is not defined -dpkg-gencontrol: warning: package postgresql-16-pgl-ddl-deploy: substitution variable ${postgresql:Depends} unused, but is defined - dh_md5sums - dh_builddeb -dpkg-deb: building package 'postgresql-16-pgl-ddl-deploy' in '../postgresql-16-pgl-ddl-deploy_2.2.1-1_amd64.deb'. -dpkg-deb: building package 'postgresql-16-pgl-ddl-deploy-dbgsym' in '../postgresql-16-pgl-ddl-deploy-dbgsym_2.2.1-1_amd64.deb'. - dpkg-genbuildinfo --build=binary -O../pgl-ddl-deploy_2.2.1-1_amd64.buildinfo - dpkg-genchanges --build=binary -O../pgl-ddl-deploy_2.2.1-1_amd64.changes -dpkg-genchanges: info: binary-only upload (no source code included) - dpkg-source --after-build . -dpkg-buildpackage: info: binary-only upload (no source included) -dpkg-genchanges: info: including full source code in upload +make: *** [debian/rules:9: binary] Error 2 +dpkg-buildpackage: error: debian/rules binary subprocess returned exit status 2 I: copying local configuration +E: Failed autobuilding of package +I: user script /srv/workspace/pbuilder/2076054/tmp/hooks/C01_cleanup starting +debug output: disk usage on i-capture-the-hostname at Sat Jun 1 20:47:21 UTC 2024 +Filesystem Size Used Avail Use% Mounted on +tmpfs 40G 0 40G 0% /dev/shm + +I: user script /srv/workspace/pbuilder/2076054/tmp/hooks/C01_cleanup finished I: unmounting dev/ptmx filesystem I: unmounting dev/pts filesystem I: unmounting dev/shm filesystem I: unmounting proc filesystem I: unmounting sys filesystem -W: Stray processes left from build: -* system-pbuilder-build-pgl\x2dddl\x2ddeploy_2.2.1\x2d1-2631667.slice - Slice /system/pbuilder/build/pgl-ddl-deploy_2.2.1-1/2631667 - Loaded: loaded - Active: active since Fri 2025-07-04 15:01:17 -12; 2min 44s ago - Tasks: 3 - Memory: 1.3G - CPU: 51.632s - CGroup: /system.slice/system-pbuilder.slice/system-pbuilder-build.slice/system-pbuilder-build-pgl\x2dddl\x2ddeploy_2.2.1\x2d1.slice/system-pbuilder-build-pgl\x2dddl\x2ddeploy_2.2.1\x2d1-2631667.slice - `-run-r5a871e1826fd48d7a625e47af516a228.scope - |-2679440 /usr/lib/postgresql/16/bin/psql contrib_regression - |-2679492 sh -c -- "sleep 15" - `-2679493 sleep 15 - -Jul 04 15:01:17 ionos15-amd64 systemd[1]: Created slice system-pbuilder-build-pgl\x2dddl\x2ddeploy_2.2.1\x2d1-2631667.slice - Slice /system/pbuilder/build/pgl-ddl-deploy_2.2.1-1/2631667. I: cleaning the build env -I: removing directory /srv/workspace/pbuilder/2631667 and its subdirectories -I: Current time: Fri Jul 4 15:04:06 -12 2025 -I: pbuilder-time-stamp: 1751684646 +I: removing directory /srv/workspace/pbuilder/2076054 and its subdirectories