0s autopkgtest [20:25:38]: starting date and time: 2024-11-21 20:25:38+0000 0s autopkgtest [20:25:38]: git checkout: 0acbae0a WIP show VirtSubproc stderr in real-time 0s autopkgtest [20:25:38]: host juju-7f2275-prod-proposed-migration-environment-2; command line: /home/ubuntu/autopkgtest/runner/autopkgtest --output-dir /tmp/autopkgtest-work.cnjg7p3t/out --timeout-copy=6000 --setup-commands /home/ubuntu/autopkgtest-cloud/worker-config-production/setup-canonical.sh --apt-pocket=proposed=src:postgresql-common --apt-upgrade pg-partman --timeout-short=300 --timeout-copy=20000 --timeout-build=20000 --env=ADT_TEST_TRIGGERS=postgresql-common/267 -- ssh -s /home/ubuntu/autopkgtest/ssh-setup/nova -- --flavor builder-cpu2-ram4-disk20 --security-groups autopkgtest-juju-7f2275-prod-proposed-migration-environment-2@bos03-19.secgroup --name adt-plucky-amd64-pg-partman-20241121-202538-juju-7f2275-prod-proposed-migration-environment-2-84fb5ff6-5c94-4394-932c-1946095b442e --image adt/ubuntu-plucky-amd64-server --keyname testbed-juju-7f2275-prod-proposed-migration-environment-2 --net-id=net_prod-proposed-migration-amd64 -e TERM=linux -e ''"'"'http_proxy=http://squid.internal:3128'"'"'' -e ''"'"'https_proxy=http://squid.internal:3128'"'"'' -e ''"'"'no_proxy=127.0.0.1,127.0.1.1,login.ubuntu.com,localhost,localdomain,novalocal,internal,archive.ubuntu.com,ports.ubuntu.com,security.ubuntu.com,ddebs.ubuntu.com,changelogs.ubuntu.com,keyserver.ubuntu.com,launchpadlibrarian.net,launchpadcontent.net,launchpad.net,10.24.0.0/24,keystone.ps5.canonical.com,objectstorage.prodstack5.canonical.com'"'"'' --mirror=http://ftpmaster.internal/ubuntu/ 46s autopkgtest [20:26:24]: testbed dpkg architecture: amd64 46s autopkgtest [20:26:24]: testbed apt version: 2.9.8 46s autopkgtest [20:26:24]: @@@@@@@@@@@@@@@@@@@@ test bed setup 47s Get:1 http://ftpmaster.internal/ubuntu plucky-proposed InRelease [73.9 kB] 47s Get:2 http://ftpmaster.internal/ubuntu plucky-proposed/multiverse Sources [12.0 kB] 47s Get:3 http://ftpmaster.internal/ubuntu plucky-proposed/universe Sources [876 kB] 47s Get:4 http://ftpmaster.internal/ubuntu plucky-proposed/restricted Sources [9704 B] 47s Get:5 http://ftpmaster.internal/ubuntu plucky-proposed/main Sources [54.2 kB] 47s Get:6 http://ftpmaster.internal/ubuntu plucky-proposed/main i386 Packages [42.5 kB] 47s Get:7 http://ftpmaster.internal/ubuntu plucky-proposed/main amd64 Packages [91.7 kB] 47s Get:8 http://ftpmaster.internal/ubuntu plucky-proposed/restricted amd64 Packages [40.1 kB] 47s Get:9 http://ftpmaster.internal/ubuntu plucky-proposed/restricted i386 Packages [2408 B] 47s Get:10 http://ftpmaster.internal/ubuntu plucky-proposed/universe amd64 Packages [743 kB] 47s Get:11 http://ftpmaster.internal/ubuntu plucky-proposed/universe i386 Packages [274 kB] 47s Get:12 http://ftpmaster.internal/ubuntu plucky-proposed/multiverse amd64 Packages [13.0 kB] 47s Get:13 http://ftpmaster.internal/ubuntu plucky-proposed/multiverse i386 Packages [2820 B] 48s Fetched 2235 kB in 1s (2778 kB/s) 48s Reading package lists... 50s Reading package lists... 50s Building dependency tree... 50s Reading state information... 51s Calculating upgrade... 51s The following packages will be upgraded: 51s bpftrace curl distro-info fwupd-signed gir1.2-girepository-2.0 51s gir1.2-glib-2.0 intel-microcode libaudit-common libaudit1 libcurl3t64-gnutls 51s libcurl4t64 libgirepository-1.0-1 libglib2.0-0t64 libglib2.0-data 51s libpam-modules libpam-modules-bin libpam-runtime libpam0g libplymouth5 51s libselinux1 libsemanage-common libsemanage2 linux-base lxd-installer 51s openssh-client openssh-server openssh-sftp-server plymouth 51s plymouth-theme-ubuntu-text python3-dbus python3-gi 51s python3-jsonschema-specifications python3-rpds-py python3-yaml 51s 34 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 51s Need to get 15.7 MB of archives. 51s After this operation, 2666 kB of additional disk space will be used. 51s Get:1 http://ftpmaster.internal/ubuntu plucky/main amd64 libaudit-common all 1:4.0.2-2ubuntu1 [6578 B] 51s Get:2 http://ftpmaster.internal/ubuntu plucky/main amd64 libaudit1 amd64 1:4.0.2-2ubuntu1 [53.9 kB] 51s Get:3 http://ftpmaster.internal/ubuntu plucky/main amd64 libpam0g amd64 1.5.3-7ubuntu4 [69.6 kB] 51s Get:4 http://ftpmaster.internal/ubuntu plucky/main amd64 libselinux1 amd64 3.7-3ubuntu1 [86.9 kB] 51s Get:5 http://ftpmaster.internal/ubuntu plucky/main amd64 libpam-modules-bin amd64 1.5.3-7ubuntu4 [53.7 kB] 51s Get:6 http://ftpmaster.internal/ubuntu plucky/main amd64 libpam-modules amd64 1.5.3-7ubuntu4 [294 kB] 51s Get:7 http://ftpmaster.internal/ubuntu plucky/main amd64 openssh-sftp-server amd64 1:9.9p1-3ubuntu1 [41.2 kB] 51s Get:8 http://ftpmaster.internal/ubuntu plucky/main amd64 openssh-server amd64 1:9.9p1-3ubuntu1 [625 kB] 51s Get:9 http://ftpmaster.internal/ubuntu plucky/main amd64 openssh-client amd64 1:9.9p1-3ubuntu1 [1080 kB] 51s Get:10 http://ftpmaster.internal/ubuntu plucky/main amd64 libpam-runtime all 1.5.3-7ubuntu4 [40.8 kB] 51s Get:11 http://ftpmaster.internal/ubuntu plucky/main amd64 libsemanage-common all 3.7-2build1 [7186 B] 51s Get:12 http://ftpmaster.internal/ubuntu plucky/main amd64 libsemanage2 amd64 3.7-2build1 [105 kB] 51s Get:13 http://ftpmaster.internal/ubuntu plucky/main amd64 distro-info amd64 1.12 [20.0 kB] 51s Get:14 http://ftpmaster.internal/ubuntu plucky/main amd64 gir1.2-girepository-2.0 amd64 1.82.0-2 [25.3 kB] 51s Get:15 http://ftpmaster.internal/ubuntu plucky/main amd64 gir1.2-glib-2.0 amd64 2.82.2-3 [182 kB] 51s Get:16 http://ftpmaster.internal/ubuntu plucky/main amd64 libglib2.0-0t64 amd64 2.82.2-3 [1655 kB] 52s Get:17 http://ftpmaster.internal/ubuntu plucky/main amd64 libgirepository-1.0-1 amd64 1.82.0-2 [88.7 kB] 52s Get:18 http://ftpmaster.internal/ubuntu plucky/main amd64 libglib2.0-data all 2.82.2-3 [51.7 kB] 52s Get:19 http://ftpmaster.internal/ubuntu plucky/main amd64 python3-dbus amd64 1.3.2-5build4 [110 kB] 52s Get:20 http://ftpmaster.internal/ubuntu plucky/main amd64 python3-gi amd64 3.50.0-3build1 [293 kB] 52s Get:21 http://ftpmaster.internal/ubuntu plucky/main amd64 python3-yaml amd64 6.0.2-1build1 [187 kB] 52s Get:22 http://ftpmaster.internal/ubuntu plucky/main amd64 libplymouth5 amd64 24.004.60-2ubuntu2 [144 kB] 52s Get:23 http://ftpmaster.internal/ubuntu plucky/main amd64 plymouth-theme-ubuntu-text amd64 24.004.60-2ubuntu2 [10.3 kB] 52s Get:24 http://ftpmaster.internal/ubuntu plucky/main amd64 plymouth amd64 24.004.60-2ubuntu2 [139 kB] 52s Get:25 http://ftpmaster.internal/ubuntu plucky/main amd64 bpftrace amd64 0.21.2-2ubuntu3 [1787 kB] 52s Get:26 http://ftpmaster.internal/ubuntu plucky/main amd64 curl amd64 8.9.1-2ubuntu3 [243 kB] 52s Get:27 http://ftpmaster.internal/ubuntu plucky/main amd64 libcurl4t64 amd64 8.9.1-2ubuntu3 [420 kB] 52s Get:28 http://ftpmaster.internal/ubuntu plucky/main amd64 fwupd-signed amd64 1.55+1.7-1 [30.6 kB] 52s Get:29 http://ftpmaster.internal/ubuntu plucky/main amd64 libcurl3t64-gnutls amd64 8.9.1-2ubuntu3 [412 kB] 52s Get:30 http://ftpmaster.internal/ubuntu plucky/main amd64 linux-base all 4.10.1ubuntu1 [34.8 kB] 52s Get:31 http://ftpmaster.internal/ubuntu plucky/main amd64 lxd-installer all 10 [5264 B] 52s Get:32 http://ftpmaster.internal/ubuntu plucky/main amd64 python3-rpds-py amd64 0.21.0-2ubuntu1 [323 kB] 52s Get:33 http://ftpmaster.internal/ubuntu plucky/main amd64 python3-jsonschema-specifications all 2023.12.1-2 [9116 B] 52s Get:34 http://ftpmaster.internal/ubuntu plucky/main amd64 intel-microcode amd64 3.20241112.1ubuntu1 [7056 kB] 52s Preconfiguring packages ... 52s Fetched 15.7 MB in 1s (13.9 MB/s) 53s (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 ... 75620 files and directories currently installed.) 53s Preparing to unpack .../libaudit-common_1%3a4.0.2-2ubuntu1_all.deb ... 53s Unpacking libaudit-common (1:4.0.2-2ubuntu1) over (1:4.0.1-1ubuntu2) ... 53s Setting up libaudit-common (1:4.0.2-2ubuntu1) ... 53s (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 ... 75620 files and directories currently installed.) 53s Preparing to unpack .../libaudit1_1%3a4.0.2-2ubuntu1_amd64.deb ... 53s Unpacking libaudit1:amd64 (1:4.0.2-2ubuntu1) over (1:4.0.1-1ubuntu2) ... 53s Setting up libaudit1:amd64 (1:4.0.2-2ubuntu1) ... 53s (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 ... 75620 files and directories currently installed.) 53s Preparing to unpack .../libpam0g_1.5.3-7ubuntu4_amd64.deb ... 53s Unpacking libpam0g:amd64 (1.5.3-7ubuntu4) over (1.5.3-7ubuntu2) ... 53s Setting up libpam0g:amd64 (1.5.3-7ubuntu4) ... 53s (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 ... 75620 files and directories currently installed.) 53s Preparing to unpack .../libselinux1_3.7-3ubuntu1_amd64.deb ... 53s Unpacking libselinux1:amd64 (3.7-3ubuntu1) over (3.5-2ubuntu5) ... 53s Setting up libselinux1:amd64 (3.7-3ubuntu1) ... 53s (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 ... 75620 files and directories currently installed.) 53s Preparing to unpack .../libpam-modules-bin_1.5.3-7ubuntu4_amd64.deb ... 53s Unpacking libpam-modules-bin (1.5.3-7ubuntu4) over (1.5.3-7ubuntu2) ... 53s Setting up libpam-modules-bin (1.5.3-7ubuntu4) ... 53s pam_namespace.service is a disabled or a static unit not running, not starting it. 54s (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 ... 75620 files and directories currently installed.) 54s Preparing to unpack .../libpam-modules_1.5.3-7ubuntu4_amd64.deb ... 54s Unpacking libpam-modules:amd64 (1.5.3-7ubuntu4) over (1.5.3-7ubuntu2) ... 54s Setting up libpam-modules:amd64 (1.5.3-7ubuntu4) ... 54s (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 ... 75620 files and directories currently installed.) 54s Preparing to unpack .../openssh-sftp-server_1%3a9.9p1-3ubuntu1_amd64.deb ... 54s Unpacking openssh-sftp-server (1:9.9p1-3ubuntu1) over (1:9.7p1-7ubuntu5) ... 54s Preparing to unpack .../openssh-server_1%3a9.9p1-3ubuntu1_amd64.deb ... 54s Unpacking openssh-server (1:9.9p1-3ubuntu1) over (1:9.7p1-7ubuntu5) ... 54s Preparing to unpack .../openssh-client_1%3a9.9p1-3ubuntu1_amd64.deb ... 54s Unpacking openssh-client (1:9.9p1-3ubuntu1) over (1:9.7p1-7ubuntu5) ... 54s Preparing to unpack .../libpam-runtime_1.5.3-7ubuntu4_all.deb ... 54s Unpacking libpam-runtime (1.5.3-7ubuntu4) over (1.5.3-7ubuntu2) ... 54s Setting up libpam-runtime (1.5.3-7ubuntu4) ... 54s (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 ... 75622 files and directories currently installed.) 54s Preparing to unpack .../libsemanage-common_3.7-2build1_all.deb ... 54s Unpacking libsemanage-common (3.7-2build1) over (3.5-1build6) ... 54s Setting up libsemanage-common (3.7-2build1) ... 54s (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 ... 75621 files and directories currently installed.) 54s Preparing to unpack .../libsemanage2_3.7-2build1_amd64.deb ... 54s Unpacking libsemanage2:amd64 (3.7-2build1) over (3.5-1build6) ... 54s Setting up libsemanage2:amd64 (3.7-2build1) ... 54s (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 ... 75621 files and directories currently installed.) 54s Preparing to unpack .../00-distro-info_1.12_amd64.deb ... 54s Unpacking distro-info (1.12) over (1.9) ... 55s Preparing to unpack .../01-gir1.2-girepository-2.0_1.82.0-2_amd64.deb ... 55s Unpacking gir1.2-girepository-2.0:amd64 (1.82.0-2) over (1.80.1-4) ... 55s Preparing to unpack .../02-gir1.2-glib-2.0_2.82.2-3_amd64.deb ... 55s Unpacking gir1.2-glib-2.0:amd64 (2.82.2-3) over (2.82.1-0ubuntu1) ... 55s Preparing to unpack .../03-libglib2.0-0t64_2.82.2-3_amd64.deb ... 55s Unpacking libglib2.0-0t64:amd64 (2.82.2-3) over (2.82.1-0ubuntu1) ... 55s Preparing to unpack .../04-libgirepository-1.0-1_1.82.0-2_amd64.deb ... 55s Unpacking libgirepository-1.0-1:amd64 (1.82.0-2) over (1.80.1-4) ... 55s Preparing to unpack .../05-libglib2.0-data_2.82.2-3_all.deb ... 55s Unpacking libglib2.0-data (2.82.2-3) over (2.82.1-0ubuntu1) ... 55s Preparing to unpack .../06-python3-dbus_1.3.2-5build4_amd64.deb ... 55s Unpacking python3-dbus (1.3.2-5build4) over (1.3.2-5build3) ... 55s Preparing to unpack .../07-python3-gi_3.50.0-3build1_amd64.deb ... 55s Unpacking python3-gi (3.50.0-3build1) over (3.50.0-3) ... 55s Preparing to unpack .../08-python3-yaml_6.0.2-1build1_amd64.deb ... 55s Unpacking python3-yaml (6.0.2-1build1) over (6.0.2-1) ... 55s Preparing to unpack .../09-libplymouth5_24.004.60-2ubuntu2_amd64.deb ... 55s Unpacking libplymouth5:amd64 (24.004.60-2ubuntu2) over (24.004.60-1ubuntu11) ... 55s Preparing to unpack .../10-plymouth-theme-ubuntu-text_24.004.60-2ubuntu2_amd64.deb ... 55s Unpacking plymouth-theme-ubuntu-text (24.004.60-2ubuntu2) over (24.004.60-1ubuntu11) ... 55s Preparing to unpack .../11-plymouth_24.004.60-2ubuntu2_amd64.deb ... 55s Unpacking plymouth (24.004.60-2ubuntu2) over (24.004.60-1ubuntu11) ... 55s Preparing to unpack .../12-bpftrace_0.21.2-2ubuntu3_amd64.deb ... 55s Unpacking bpftrace (0.21.2-2ubuntu3) over (0.21.2-2ubuntu2) ... 55s Preparing to unpack .../13-curl_8.9.1-2ubuntu3_amd64.deb ... 55s Unpacking curl (8.9.1-2ubuntu3) over (8.9.1-2ubuntu2) ... 55s Preparing to unpack .../14-libcurl4t64_8.9.1-2ubuntu3_amd64.deb ... 55s Unpacking libcurl4t64:amd64 (8.9.1-2ubuntu3) over (8.9.1-2ubuntu2) ... 55s Preparing to unpack .../15-fwupd-signed_1.55+1.7-1_amd64.deb ... 55s Unpacking fwupd-signed (1.55+1.7-1) over (1.54+1.6-1build1) ... 55s Preparing to unpack .../16-libcurl3t64-gnutls_8.9.1-2ubuntu3_amd64.deb ... 55s Unpacking libcurl3t64-gnutls:amd64 (8.9.1-2ubuntu3) over (8.9.1-2ubuntu2) ... 55s Preparing to unpack .../17-linux-base_4.10.1ubuntu1_all.deb ... 55s Unpacking linux-base (4.10.1ubuntu1) over (4.5ubuntu9) ... 56s Preparing to unpack .../18-lxd-installer_10_all.deb ... 56s Unpacking lxd-installer (10) over (9) ... 56s Preparing to unpack .../19-python3-rpds-py_0.21.0-2ubuntu1_amd64.deb ... 56s Unpacking python3-rpds-py (0.21.0-2ubuntu1) over (0.20.0-0ubuntu3) ... 56s Preparing to unpack .../20-python3-jsonschema-specifications_2023.12.1-2_all.deb ... 56s Unpacking python3-jsonschema-specifications (2023.12.1-2) over (2023.12.1-1ubuntu1) ... 56s Preparing to unpack .../21-intel-microcode_3.20241112.1ubuntu1_amd64.deb ... 56s Unpacking intel-microcode (3.20241112.1ubuntu1) over (3.20240910.0ubuntu1) ... 56s Setting up distro-info (1.12) ... 56s Setting up linux-base (4.10.1ubuntu1) ... 56s Setting up libcurl4t64:amd64 (8.9.1-2ubuntu3) ... 56s Setting up bpftrace (0.21.2-2ubuntu3) ... 56s Setting up openssh-client (1:9.9p1-3ubuntu1) ... 56s Setting up intel-microcode (3.20241112.1ubuntu1) ... 56s intel-microcode: microcode will be updated at next boot 56s Setting up libcurl3t64-gnutls:amd64 (8.9.1-2ubuntu3) ... 56s Setting up fwupd-signed (1.55+1.7-1) ... 56s Setting up python3-yaml (6.0.2-1build1) ... 56s Setting up libglib2.0-0t64:amd64 (2.82.2-3) ... 56s No schema files found: doing nothing. 56s Setting up libglib2.0-data (2.82.2-3) ... 56s Setting up gir1.2-glib-2.0:amd64 (2.82.2-3) ... 56s Setting up lxd-installer (10) ... 57s Setting up python3-rpds-py (0.21.0-2ubuntu1) ... 57s Setting up libplymouth5:amd64 (24.004.60-2ubuntu2) ... 57s Setting up libgirepository-1.0-1:amd64 (1.82.0-2) ... 57s Setting up curl (8.9.1-2ubuntu3) ... 57s Setting up python3-jsonschema-specifications (2023.12.1-2) ... 57s Setting up openssh-sftp-server (1:9.9p1-3ubuntu1) ... 57s Setting up python3-dbus (1.3.2-5build4) ... 57s Setting up openssh-server (1:9.9p1-3ubuntu1) ... 57s Installing new version of config file /etc/ssh/moduli ... 58s Setting up plymouth (24.004.60-2ubuntu2) ... 58s update-initramfs: Generating /boot/initrd.img-6.11.0-8-generic 58s W: No lz4 in /usr/bin:/sbin:/bin, using gzip 67s update-rc.d: warning: start and stop actions are no longer supported; falling back to defaults 67s update-rc.d: warning: start and stop actions are no longer supported; falling back to defaults 67s Setting up plymouth-theme-ubuntu-text (24.004.60-2ubuntu2) ... 67s update-initramfs: deferring update (trigger activated) 67s Setting up gir1.2-girepository-2.0:amd64 (1.82.0-2) ... 67s Setting up python3-gi (3.50.0-3build1) ... 67s Processing triggers for ufw (0.36.2-8) ... 67s Processing triggers for man-db (2.13.0-1) ... 68s Processing triggers for libc-bin (2.40-1ubuntu3) ... 68s Processing triggers for initramfs-tools (0.142ubuntu35) ... 68s update-initramfs: Generating /boot/initrd.img-6.11.0-8-generic 68s W: No lz4 in /usr/bin:/sbin:/bin, using gzip 76s Reading package lists... 76s Building dependency tree... 76s Reading state information... 76s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 76s Hit:1 http://ftpmaster.internal/ubuntu plucky-proposed InRelease 76s Hit:2 http://ftpmaster.internal/ubuntu plucky InRelease 77s Hit:3 http://ftpmaster.internal/ubuntu plucky-updates InRelease 77s Hit:4 http://ftpmaster.internal/ubuntu plucky-security InRelease 77s Reading package lists... 77s Reading package lists... 78s Building dependency tree... 78s Reading state information... 78s Calculating upgrade... 78s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 78s Reading package lists... 78s Building dependency tree... 78s Reading state information... 79s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 79s autopkgtest [20:26:57]: rebooting testbed after setup commands that affected boot 96s autopkgtest [20:27:14]: testbed running kernel: Linux 6.11.0-8-generic #8-Ubuntu SMP PREEMPT_DYNAMIC Mon Sep 16 13:41:20 UTC 2024 99s autopkgtest [20:27:17]: @@@@@@@@@@@@@@@@@@@@ apt-source pg-partman 101s Get:1 http://ftpmaster.internal/ubuntu plucky-proposed/universe pg-partman 5.1.0-2 (dsc) [2307 B] 101s Get:2 http://ftpmaster.internal/ubuntu plucky-proposed/universe pg-partman 5.1.0-2 (tar) [1178 kB] 101s Get:3 http://ftpmaster.internal/ubuntu plucky-proposed/universe pg-partman 5.1.0-2 (diff) [4216 B] 101s gpgv: Signature made Fri Sep 13 12:29:10 2024 UTC 101s gpgv: using RSA key 5C48FE6157F49179597087C64C5A6BAB12D2A7AE 101s gpgv: Can't check signature: No public key 101s dpkg-source: warning: cannot verify inline signature for ./pg-partman_5.1.0-2.dsc: no acceptable signature found 102s autopkgtest [20:27:20]: testing package pg-partman version 5.1.0-2 102s autopkgtest [20:27:20]: build not needed 104s autopkgtest [20:27:22]: test prove: preparing testbed 105s Reading package lists... 106s Building dependency tree... 106s Reading state information... 106s Starting pkgProblemResolver with broken count: 0 106s Starting 2 pkgProblemResolver with broken count: 0 106s Done 106s The following additional packages will be installed: 106s libio-pty-perl libipc-run-perl libjson-perl libpq5 106s libtap-parser-sourcehandler-pgtap-perl libxslt1.1 postgresql-17 106s postgresql-17-partman postgresql-17-pgtap postgresql-client-17 106s postgresql-client-common postgresql-common python3-psycopg2 ssl-cert 106s Suggested packages: 106s postgresql-doc-17 python-psycopg2-doc 106s Recommended packages: 106s libjson-xs-perl libtap-harness-archive-perl pgtap-doc 106s The following NEW packages will be installed: 106s autopkgtest-satdep libio-pty-perl libipc-run-perl libjson-perl libpq5 106s libtap-parser-sourcehandler-pgtap-perl libxslt1.1 postgresql-17 106s postgresql-17-partman postgresql-17-pgtap postgresql-client-17 106s postgresql-client-common postgresql-common python3-psycopg2 ssl-cert 106s 0 upgraded, 15 newly installed, 0 to remove and 0 not upgraded. 106s Need to get 21.3 MB/21.3 MB of archives. 106s After this operation, 81.8 MB of additional disk space will be used. 106s Get:1 /tmp/autopkgtest.TIDjGX/1-autopkgtest-satdep.deb autopkgtest-satdep amd64 0 [760 B] 106s Get:2 http://ftpmaster.internal/ubuntu plucky/main amd64 libjson-perl all 4.10000-1 [81.9 kB] 107s Get:3 http://ftpmaster.internal/ubuntu plucky/main amd64 libio-pty-perl amd64 1:1.20-1build3 [31.4 kB] 107s Get:4 http://ftpmaster.internal/ubuntu plucky/main amd64 libipc-run-perl all 20231003.0-2 [91.5 kB] 107s Get:5 http://ftpmaster.internal/ubuntu plucky-proposed/main amd64 postgresql-client-common all 267 [37.1 kB] 107s Get:6 http://ftpmaster.internal/ubuntu plucky/main amd64 ssl-cert all 1.1.2ubuntu2 [18.0 kB] 107s Get:7 http://ftpmaster.internal/ubuntu plucky-proposed/main amd64 postgresql-common all 267 [162 kB] 107s Get:8 http://ftpmaster.internal/ubuntu plucky/main amd64 libpq5 amd64 17.0-1 [249 kB] 107s Get:9 http://ftpmaster.internal/ubuntu plucky/main amd64 libxslt1.1 amd64 1.1.39-0exp1ubuntu1 [169 kB] 107s Get:10 http://ftpmaster.internal/ubuntu plucky/main amd64 postgresql-client-17 amd64 17.0-1 [2111 kB] 107s Get:11 http://ftpmaster.internal/ubuntu plucky/main amd64 postgresql-17 amd64 17.0-1 [17.9 MB] 107s Get:12 http://ftpmaster.internal/ubuntu plucky/main amd64 python3-psycopg2 amd64 2.9.9-2build1 [146 kB] 107s Get:13 http://ftpmaster.internal/ubuntu plucky-proposed/universe amd64 postgresql-17-partman amd64 5.1.0-2 [224 kB] 107s Get:14 http://ftpmaster.internal/ubuntu plucky/universe amd64 postgresql-17-pgtap all 1.3.3-3 [45.6 kB] 107s Get:15 http://ftpmaster.internal/ubuntu plucky/universe amd64 libtap-parser-sourcehandler-pgtap-perl all 3.36-2 [35.2 kB] 108s Preconfiguring packages ... 108s Fetched 21.3 MB in 1s (18.6 MB/s) 108s Selecting previously unselected package libjson-perl. 108s (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 ... 75654 files and directories currently installed.) 108s Preparing to unpack .../00-libjson-perl_4.10000-1_all.deb ... 108s Unpacking libjson-perl (4.10000-1) ... 108s Selecting previously unselected package libio-pty-perl. 108s Preparing to unpack .../01-libio-pty-perl_1%3a1.20-1build3_amd64.deb ... 108s Unpacking libio-pty-perl (1:1.20-1build3) ... 108s Selecting previously unselected package libipc-run-perl. 108s Preparing to unpack .../02-libipc-run-perl_20231003.0-2_all.deb ... 108s Unpacking libipc-run-perl (20231003.0-2) ... 108s Selecting previously unselected package postgresql-client-common. 108s Preparing to unpack .../03-postgresql-client-common_267_all.deb ... 108s Unpacking postgresql-client-common (267) ... 108s Selecting previously unselected package ssl-cert. 108s Preparing to unpack .../04-ssl-cert_1.1.2ubuntu2_all.deb ... 108s Unpacking ssl-cert (1.1.2ubuntu2) ... 108s Selecting previously unselected package postgresql-common. 108s Preparing to unpack .../05-postgresql-common_267_all.deb ... 108s Adding 'diversion of /usr/bin/pg_config to /usr/bin/pg_config.libpq-dev by postgresql-common' 108s Unpacking postgresql-common (267) ... 108s Selecting previously unselected package libpq5:amd64. 108s Preparing to unpack .../06-libpq5_17.0-1_amd64.deb ... 108s Unpacking libpq5:amd64 (17.0-1) ... 108s Selecting previously unselected package libxslt1.1:amd64. 108s Preparing to unpack .../07-libxslt1.1_1.1.39-0exp1ubuntu1_amd64.deb ... 108s Unpacking libxslt1.1:amd64 (1.1.39-0exp1ubuntu1) ... 108s Selecting previously unselected package postgresql-client-17. 108s Preparing to unpack .../08-postgresql-client-17_17.0-1_amd64.deb ... 108s Unpacking postgresql-client-17 (17.0-1) ... 108s Selecting previously unselected package postgresql-17. 108s Preparing to unpack .../09-postgresql-17_17.0-1_amd64.deb ... 108s Unpacking postgresql-17 (17.0-1) ... 109s Selecting previously unselected package python3-psycopg2. 109s Preparing to unpack .../10-python3-psycopg2_2.9.9-2build1_amd64.deb ... 109s Unpacking python3-psycopg2 (2.9.9-2build1) ... 109s Selecting previously unselected package postgresql-17-partman. 109s Preparing to unpack .../11-postgresql-17-partman_5.1.0-2_amd64.deb ... 109s Unpacking postgresql-17-partman (5.1.0-2) ... 109s Selecting previously unselected package postgresql-17-pgtap. 109s Preparing to unpack .../12-postgresql-17-pgtap_1.3.3-3_all.deb ... 109s Unpacking postgresql-17-pgtap (1.3.3-3) ... 109s Selecting previously unselected package libtap-parser-sourcehandler-pgtap-perl. 109s Preparing to unpack .../13-libtap-parser-sourcehandler-pgtap-perl_3.36-2_all.deb ... 109s Unpacking libtap-parser-sourcehandler-pgtap-perl (3.36-2) ... 109s Selecting previously unselected package autopkgtest-satdep. 109s Preparing to unpack .../14-1-autopkgtest-satdep.deb ... 109s Unpacking autopkgtest-satdep (0) ... 109s Setting up libtap-parser-sourcehandler-pgtap-perl (3.36-2) ... 109s Setting up libio-pty-perl (1:1.20-1build3) ... 109s Setting up libpq5:amd64 (17.0-1) ... 109s Setting up ssl-cert (1.1.2ubuntu2) ... 109s Created symlink '/etc/systemd/system/multi-user.target.wants/ssl-cert.service' → '/usr/lib/systemd/system/ssl-cert.service'. 110s Setting up python3-psycopg2 (2.9.9-2build1) ... 110s Setting up libipc-run-perl (20231003.0-2) ... 110s Setting up libjson-perl (4.10000-1) ... 110s Setting up libxslt1.1:amd64 (1.1.39-0exp1ubuntu1) ... 110s Setting up postgresql-client-common (267) ... 110s Setting up postgresql-client-17 (17.0-1) ... 110s update-alternatives: using /usr/share/postgresql/17/man/man1/psql.1.gz to provide /usr/share/man/man1/psql.1.gz (psql.1.gz) in auto mode 110s Setting up postgresql-common (267) ... 111s 111s Creating config file /etc/postgresql-common/createcluster.conf with new version 111s Building PostgreSQL dictionaries from installed myspell/hunspell packages... 111s Removing obsolete dictionary files: 111s Created symlink '/etc/systemd/system/multi-user.target.wants/postgresql.service' → '/usr/lib/systemd/system/postgresql.service'. 112s Setting up postgresql-17 (17.0-1) ... 112s Creating new PostgreSQL cluster 17/main ... 112s /usr/lib/postgresql/17/bin/initdb -D /var/lib/postgresql/17/main --auth-local peer --auth-host scram-sha-256 --no-instructions 112s The files belonging to this database system will be owned by user "postgres". 112s This user must also own the server process. 112s 112s The database cluster will be initialized with locale "C.UTF-8". 112s The default database encoding has accordingly been set to "UTF8". 112s The default text search configuration will be set to "english". 112s 112s Data page checksums are disabled. 112s 112s fixing permissions on existing directory /var/lib/postgresql/17/main ... ok 112s creating subdirectories ... ok 112s selecting dynamic shared memory implementation ... posix 112s selecting default "max_connections" ... 100 112s selecting default "shared_buffers" ... 128MB 112s selecting default time zone ... Etc/UTC 112s creating configuration files ... ok 112s running bootstrap script ... ok 113s performing post-bootstrap initialization ... ok 113s syncing data to disk ... ok 116s Setting up postgresql-17-pgtap (1.3.3-3) ... 116s Setting up postgresql-17-partman (5.1.0-2) ... 116s Setting up autopkgtest-satdep (0) ... 116s Processing triggers for man-db (2.13.0-1) ... 117s Processing triggers for libc-bin (2.40-1ubuntu3) ... 120s (Reading database ... 78187 files and directories currently installed.) 120s Removing autopkgtest-satdep (0) ... 121s autopkgtest [20:27:39]: test prove: [----------------------- 121s ### PostgreSQL 17 virtualenv ### 121s Creating new PostgreSQL cluster 17/regress ... 124s + psql -c 'CREATE EXTENSION pgtap' 124s CREATE EXTENSION 124s + psql -c 'CREATE EXTENSION pg_partman' 124s CREATE EXTENSION 124s + pg_prove -ovf test/test-id-10.sql 124s Duplicate specification "psql-bin|b=s" for option "b" 124s Duplicate specification "host|h=s" for option "h" 124s Duplicate specification "port|p=s" for option "p" 124s Duplicate specification "pset|P=s%" for option "P" 124s Duplicate specification "schema|s=s" for option "s" 124s Duplicate specification "version|V" for option "version" 124s Duplicate specification "version|V" for option "V" 124s Duplicate specification "help|H|?" for option "help" 124s Duplicate specification "help|H|?" for option "H" 124s Duplicate specification "help|H|?" for option "?" 124s Duplicate specification "man|m" for option "man" 124s Duplicate specification "man|m" for option "m" 124s psql:test/test-id-10.sql:208: NOTICE: Moved 11 row(s) to the target table. Removed 1 partitions. 124s psql:test/test-id-10.sql:211: NOTICE: Moved 10 row(s) to the target table. Removed 1 partitions. 125s psql:test/test-id-10.sql:215: NOTICE: Moved 9 row(s) to the target table. Removed 5 partitions. 125s test/test-id-10.sql .. 125s partman, public 125s 1..135 125s t 125s ok 1 - Check id_taptest_table_p3000000000 exists 125s ok 2 - Check id_taptest_table_p3000000010 exists 125s ok 3 - Check id_taptest_table_p3000000020 exists 125s ok 4 - Check id_taptest_table_p3000000030 exists 125s ok 5 - Check id_taptest_table_p3000000040 exists 125s ok 6 - Check id_taptest_table_default exists 125s ok 7 - Check id_taptest_table_p3000000050 doesn't exists yet 125s ok 8 - Check for primary key in id_taptest_table_p3000000000 125s ok 9 - Check for primary key in id_taptest_table_p3000000010 125s ok 10 - Check for primary key in id_taptest_table_p3000000020 125s ok 11 - Check for primary key in id_taptest_table_p3000000030 125s ok 12 - Check for primary key in id_taptest_table_p3000000040 125s ok 13 - Check for primary key in id_taptest_table_default 125s ok 14 - Check that foreign key was inherited to id_taptest_table_p3000000000 125s ok 15 - Check that foreign key was inherited to id_taptest_table_p3000000010 125s ok 16 - Check that foreign key was inherited to id_taptest_table_p3000000020 125s ok 17 - Check that foreign key was inherited to id_taptest_table_p3000000030 125s ok 18 - Check that foreign key was inherited to id_taptest_table_p3000000040 125s ok 19 - Check that foreign key was inherited to id_taptest_table_default 125s ok 20 - Check that unique index was inherited to id_taptest_table_p3000000000 125s ok 21 - Check that unique index was inherited to id_taptest_table_p3000000010 125s ok 22 - Check that unique index was inherited to id_taptest_table_p3000000020 125s ok 23 - Check that unique index was inherited to id_taptest_table_p3000000030 125s ok 24 - Check that unique index was inherited to id_taptest_table_p3000000040 125s ok 25 - Check that unique index was inherited to id_taptest_table_default 125s ok 26 - Check partman_basic privileges of id_taptest_table_p3000000000 125s ok 27 - Check partman_basic privileges of id_taptest_table_p3000000010 125s ok 28 - Check partman_basic privileges of id_taptest_table_p3000000020 125s ok 29 - Check partman_basic privileges of id_taptest_table_p3000000030 125s ok 30 - Check partman_basic privileges of id_taptest_table_p3000000040 125s ok 31 - Check partman_basic privileges of id_taptest_table_default 125s ok 32 - Check partman_revoke privileges of id_taptest_table_p3000000000 125s ok 33 - Check partman_revoke privileges of id_taptest_table_p3000000010 125s ok 34 - Check partman_revoke privileges of id_taptest_table_p3000000020 125s ok 35 - Check partman_revoke privileges of id_taptest_table_p3000000030 125s ok 36 - Check partman_revoke privileges of id_taptest_table_p3000000040 125s ok 37 - Check partman_revoke privileges of id_taptest_table_default 125s ok 38 - Check that parent table is unlogged 125s ok 39 - Check that id_taptest_table_p3000000000 is unlogged 125s ok 40 - Check that id_taptest_table_p3000000010 is unlogged 125s ok 41 - Check that id_taptest_table_p3000000020 is unlogged 125s ok 42 - Check that id_taptest_table_p3000000030 is unlogged 125s ok 43 - Check that id_taptest_table_p3000000040 is unlogged 125s ok 44 - Check that id_taptest_table_default is unlogged 125s ok 45 - Check that default table has no data 125s ok 46 - Check count from parent table 125s ok 47 - Check count from id_taptest_table_p3000000000 125s ok 48 - Check that parent table has had no data inserted to it 125s ok 49 - Check count from id_taptest_table_p3000000010 125s ok 50 - Check count from id_taptest_table_p3000000020 125s ok 51 - Check id_taptest_table_p3000000050 exists 125s ok 52 - Check that id_taptest_table_p3000000050 is unlogged 125s ok 53 - Check id_taptest_table_p3000000060 exists yet 125s ok 54 - Check that id_taptest_table_p3000000060 is unlogged 125s ok 55 - Check id_taptest_table_p3000000070 doesn't exists yet 125s ok 56 - Check for primary key in id_taptest_table_p3000000050 125s ok 57 - Check that foreign key was inherited to id_taptest_table_p3000000050 125s ok 58 - Check partman_basic privileges of id_taptest_table_p3000000000 125s ok 59 - Check partman_basic privileges of id_taptest_table_p3000000010 125s ok 60 - Check partman_basic privileges of id_taptest_table_p3000000020 125s ok 61 - Check partman_basic privileges of id_taptest_table_p3000000030 125s ok 62 - Check partman_basic privileges of id_taptest_table_p3000000040 125s ok 63 - Check partman_basic privileges of id_taptest_table_p3000000050 125s ok 64 - Check partman_revoke privileges of id_taptest_table_p3000000050 125s ok 65 - Check partman_basic privileges of id_taptest_table_p3000000060 125s ok 66 - Check partman_revoke privileges of id_taptest_table_p3000000060 125s ok 67 - Check that parent table has had no data inserted to it 125s ok 68 - Check count from id_taptest_table 125s ok 69 - Check count from id_taptest_table_p3000000020 125s ok 70 - Check count from id_taptest_table_p3000000030 125s ok 71 - Check id_taptest_table_p3000000070 exists 125s ok 72 - Check that id_taptest_table_p3000000070 is unlogged 125s ok 73 - Check id_taptest_table_p3000000080 doesn't exists yet 125s ok 74 - Check for primary key in id_taptest_table_p3000000060 125s ok 75 - Check for primary key in id_taptest_table_p3000000070 125s ok 76 - Check that foreign key was inherited to id_taptest_table_p3000000060 125s ok 77 - Check that foreign key was inherited to id_taptest_table_p3000000070 125s ok 78 - Check partman_basic privileges of id_taptest_table_p3000000000 125s ok 79 - Check partman_basic privileges of id_taptest_table_p3000000010 125s ok 80 - Check partman_basic privileges of id_taptest_table_p3000000020 125s ok 81 - Check partman_basic privileges of id_taptest_table_p3000000030 125s ok 82 - Check partman_basic privileges of id_taptest_table_p3000000040 125s ok 83 - Check partman_basic privileges of id_taptest_table_default 125s ok 84 - Check partman_basic privileges of id_taptest_table_p3000000050 125s ok 85 - Check partman_revoke privileges of id_taptest_table_p3000000050 125s ok 86 - Check partman_basic privileges of id_taptest_table_p3000000060 125s ok 87 - Check partman_revoke privileges of id_taptest_table_p3000000060 125s ok 88 - Check partman_basic privileges of id_taptest_table_p3000000070 125s ok 89 - Check that ownership change worked for id_taptest_table_p3000000070 125s ok 90 - Check partman_revoke has no privileges on id_taptest_table_p3000000070 125s ok 91 - Check that data outside child scope goes to default 125s ok 92 - Check partman_basic privileges of id_taptest_table_p3000000000 125s ok 93 - Check partman_basic privileges of id_taptest_table_p3000000010 125s ok 94 - Check partman_basic privileges of id_taptest_table_p3000000020 125s ok 95 - Check partman_basic privileges of id_taptest_table_p3000000030 125s ok 96 - Check partman_basic privileges of id_taptest_table_p3000000040 125s ok 97 - Check partman_basic privileges of id_taptest_table_p3000000050 125s ok 98 - Check partman_basic privileges of id_taptest_table_p3000000060 125s ok 99 - Check partman_basic privileges of id_taptest_table_p3000000070 125s ok 100 - Check partman_basic privileges of id_taptest_table_default 125s ok 101 - Check partman_revoke has no privileges on id_taptest_table_p3000000000 125s ok 102 - Check partman_revoke has no privileges on id_taptest_table_p3000000010 125s ok 103 - Check partman_revoke has no privileges on id_taptest_table_p3000000020 125s ok 104 - Check partman_revoke has no privileges on id_taptest_table_p3000000030 125s ok 105 - Check partman_revoke has no privileges on id_taptest_table_p3000000040 125s ok 106 - Check partman_revoke has no privileges on id_taptest_table_p3000000050 125s ok 107 - Check partman_revoke has no privileges on id_taptest_table_p3000000060 125s ok 108 - Check partman_revoke has no privileges on id_taptest_table_p3000000070 125s ok 109 - Check partman_revoke has no privileges on id_taptest_table_default 125s ok 110 - Check that ownership change worked for id_taptest_table_p3000000000 125s ok 111 - Check that ownership change worked for id_taptest_table_p3000000010 125s ok 112 - Check that ownership change worked for id_taptest_table_p3000000020 125s ok 113 - Check that ownership change worked for id_taptest_table_p3000000030 125s ok 114 - Check that ownership change worked for id_taptest_table_p3000000040 125s ok 115 - Check that ownership change worked for id_taptest_table_p3000000050 125s ok 116 - Check that ownership change worked for id_taptest_table_p3000000060 125s ok 117 - Check that ownership change worked for id_taptest_table_p3000000070 125s ok 118 - Check that ownership change worked for id_taptest_table_default 125s 1 125s ok 119 - Check id_taptest_table_p3000000000 doesn't exists anymore 125s 1 125s ok 120 - Check id_taptest_table_p3000000010 doesn't exists anymore 125s ok 121 - Check id_taptest_table_p3000000010 got moved to new schema 125s (1,11) 125s ok 122 - Check id_taptest_table_default does not exist 125s (1,10) 125s ok 123 - Check id_taptest_table_p3000000020 does not exist 125s (5,9) 125s ok 124 - Check count from undo table after undo 125s ok 125 - Check id_taptest_table_p3000000030 still exists 125s ok 126 - Check child table had its data removed id_taptest_table_p3000000030 125s ok 127 - Check id_taptest_table_p3000000040 still exists 125s ok 128 - Check child table had its data removed id_taptest_table_p3000000040 125s ok 129 - Check id_taptest_table_p3000000050 still exists 125s ok 130 - Check child table had its data removed id_taptest_table_p3000000050 125s ok 131 - Check id_taptest_table_p3000000060 still exists 125s ok 132 - Check child table had its data removed id_taptest_table_p3000000060 125s ok 133 - Check id_taptest_table_p3000000070 still exists 125s ok 134 - Check child table had its data removed id_taptest_table_p3000000070 125s ok 135 - Check that template table was dropped 125s ok 125s All tests successful. 125s Files=1, Tests=135, 1 wallclock secs ( 0.02 usr 0.01 sys + 0.03 cusr 0.02 csys = 0.08 CPU) 125s Result: PASS 125s + pg_prove -ovf test/test_bgw/test-time-daily-bgw.sql 125s Duplicate specification "psql-bin|b=s" for option "b" 125s Duplicate specification "host|h=s" for option "h" 125s Duplicate specification "port|p=s" for option "p" 125s Duplicate specification "pset|P=s%" for option "P" 125s Duplicate specification "schema|s=s" for option "s" 125s Duplicate specification "version|V" for option "version" 125s Duplicate specification "version|V" for option "V" 125s Duplicate specification "help|H|?" for option "help" 125s Duplicate specification "help|H|?" for option "H" 125s Duplicate specification "help|H|?" for option "?" 125s Duplicate specification "man|m" for option "man" 125s Duplicate specification "man|m" for option "m" 185s psql:test/test_bgw/test-time-daily-bgw.sql:253: NOTICE: Moved 36 row(s) to the target table. Removed 12 partitions. 185s psql:test/test_bgw/test-time-daily-bgw.sql:296: NOTICE: drop cascades to 14 other objects 185s DETAIL: drop cascades to table partman_test.time_taptest_table 185s drop cascades to table partman_test.undo_taptest 185s drop cascades to table partman_test.time_taptest_table_p20241119 185s drop cascades to table partman_test.time_taptest_table_p20241120 185s drop cascades to table partman_test.time_taptest_table_p20241121 185s drop cascades to table partman_test.time_taptest_table_p20241122 185s drop cascades to table partman_test.time_taptest_table_p20241123 185s drop cascades to table partman_test.time_taptest_table_p20241124 185s drop cascades to table partman_test.time_taptest_table_p20241125 185s drop cascades to table partman_test.time_taptest_table_default 185s drop cascades to table partman_test.time_taptest_table_p20241126 185s drop cascades to table partman_test.time_taptest_table_p20241127 185s drop cascades to table partman_test.time_taptest_table_p20241128 185s drop cascades to table partman_test.time_taptest_table_p20241129 185s psql:test/test_bgw/test-time-daily-bgw.sql:297: NOTICE: drop cascades to table partman_retention_test.time_taptest_table_p20241118 185s test/test_bgw/test-time-daily-bgw.sql .. 185s partman, public 185s 1..105 185s t 185s ok 1 - Check time_taptest_table_p20241121 exists 185s ok 2 - Check time_taptest_table_p20241122 exists 185s ok 3 - Check time_taptest_table_p20241123 exists 185s ok 4 - Check time_taptest_table_p20241124 exists 185s ok 5 - Check time_taptest_table_p20241125 exists 185s ok 6 - Check time_taptest_table_p20241126 exists 185s ok 7 - Check for primary key in time_taptest_table_p20241121 185s ok 8 - Check for primary key in time_taptest_table_p20241122 185s ok 9 - Check for primary key in time_taptest_table_p20241123 185s ok 10 - Check for primary key in time_taptest_table_p20241124 185s ok 11 - Check for primary key in time_taptest_table_p20241125 185s ok 12 - Check partman_basic privileges of time_taptest_table_p20241121 185s ok 13 - Check partman_basic privileges of time_taptest_table_p20241122 185s ok 14 - Check partman_basic privileges of time_taptest_table_p20241123 185s ok 15 - Check partman_basic privileges of time_taptest_table_p20241124 185s ok 16 - Check partman_basic privileges of time_taptest_table_p20241125 185s ok 17 - Check partman_revoke privileges of time_taptest_table_p20241121 185s ok 18 - Check partman_revoke privileges of time_taptest_table_p20241122 185s ok 19 - Check partman_revoke privileges of time_taptest_table_p20241123 185s ok 20 - Check partman_revoke privileges of time_taptest_table_p20241124 185s ok 21 - Check partman_revoke privileges of time_taptest_table_p20241125 185s ok 22 - Check count from parent table 185s ok 23 - Check count from time_taptest_table_p20241121 185s ok 24 - Check count from time_taptest_table 185s ok 25 - Check count from time_taptest_table_p20241122 185s ok 26 - Check count from time_taptest_table_p20241123 185s ok 27 - Waiting 20 seconds for background worker to run... 185s ok 28 - Check time_taptest_table_p20241126 exists 185s ok 29 - Check time_taptest_table_p20241127 exists 185s ok 30 - Check time_taptest_table_p20241128 exists 185s ok 31 - Check time_taptest_table_p20241129 exists 185s ok 32 - Check for primary key in time_taptest_table_p20241126 185s ok 33 - Check for primary key in time_taptest_table_p20241127 185s ok 34 - Check for primary key in time_taptest_table_p20241128 185s ok 35 - Check partman_basic privileges of time_taptest_table_p20241126 185s ok 36 - Check partman_basic privileges of time_taptest_table_p20241127 185s ok 37 - Check partman_basic privileges of time_taptest_table_p20241128 185s ok 38 - Check partman_revoke privileges of time_taptest_table_p20241126 185s ok 39 - Check partman_revoke privileges of time_taptest_table_p20241127 185s ok 40 - Check partman_revoke privileges of time_taptest_table_p20241128 185s ok 41 - Waiting 20 seconds for background worker to run... 185s ok 42 - Check time_taptest_table_p20241129 exists 185s ok 43 - Check time_taptest_table_p20241130 exists 185s ok 44 - Check for primary key in time_taptest_table_p20241129 185s ok 45 - Check partman_basic privileges of time_taptest_table_p20241129 185s ok 46 - Check partman_revoke privileges of time_taptest_table_p20241129 185s ok 47 - Check that ownership change worked for time_taptest_table_p20241129 185s ok 48 - Check that data outside scope goes to default 185s ok 49 - Check partman_basic privileges of time_taptest_table_p20241121 185s ok 50 - Check partman_basic privileges of time_taptest_table_p20241122 185s ok 51 - Check partman_basic privileges of time_taptest_table_p20241123 185s ok 52 - Check partman_basic privileges of time_taptest_table_p20241124 185s ok 53 - Check partman_basic privileges of time_taptest_table_p20241125 185s ok 54 - Check partman_basic privileges of time_taptest_table_p20241126 185s ok 55 - Check partman_basic privileges of time_taptest_table_p20241127 185s ok 56 - Check partman_basic privileges of time_taptest_table_p20241128 185s ok 57 - Check partman_basic privileges of time_taptest_table_p20241129 185s ok 58 - Check partman_revoke privileges of time_taptest_table_p20241121 185s ok 59 - Check partman_revoke privileges of time_taptest_table_p20241122 185s ok 60 - Check partman_revoke privileges of time_taptest_table_p20241123 185s ok 61 - Check partman_revoke privileges of time_taptest_table_p20241124 185s ok 62 - Check partman_revoke privileges of time_taptest_table_p20241125 185s ok 63 - Check partman_revoke privileges of time_taptest_table_p20241126 185s ok 64 - Check partman_revoke privileges of time_taptest_table_p20241127 185s ok 65 - Check partman_revoke privileges of time_taptest_table_p20241128 185s ok 66 - Check partman_revoke privileges of time_taptest_table_p20241129 185s ok 67 - Check that ownership change worked for time_taptest_table_p20241121 185s ok 68 - Check that ownership change worked for time_taptest_table_p20241122 185s ok 69 - Check that ownership change worked for time_taptest_table_p20241123 185s ok 70 - Check that ownership change worked for time_taptest_table_p20241124 185s ok 71 - Check that ownership change worked for time_taptest_table_p20241125 185s ok 72 - Check that ownership change worked for time_taptest_table_p20241126 185s ok 73 - Check that ownership change worked for time_taptest_table_p20241127 185s ok 74 - Check that ownership change worked for time_taptest_table_p20241128 185s ok 75 - Check that ownership change worked for time_taptest_table_p20241129 185s 1 185s ok 76 - Check time_taptest_table_p20241117 does not exist 185s ok 77 - Waiting 20 seconds for background worker to run... 185s ok 78 - Check time_taptest_table_p20241118 does not exist 185s ok 79 - Check time_taptest_table_p20241118 got moved to new schema 185s (12,36) 185s ok 80 - Check time_taptest_table_p20241121 exists 185s ok 81 - Check time_taptest_table_p20241122 still exists 185s ok 82 - Check time_taptest_table_p20241120 is empty 185s ok 83 - Check time_taptest_table_p20241120 is empty 185s ok 84 - Check time_taptest_table_p20241119 still exists 185s ok 85 - Check time_taptest_table_p20241119 is empty 185s ok 86 - Check time_taptest_table_p20241122 is empty 185s ok 87 - Check time_taptest_table_p20241123 still exists 185s ok 88 - Check time_taptest_table_p20241123 is empty 185s ok 89 - Check time_taptest_table_p20241124 still exists 185s ok 90 - Check time_taptest_table_p20241124 is empty 185s ok 91 - Check time_taptest_table_p20241125 still exists 185s ok 92 - Check time_taptest_table_p20241125 is empty 185s ok 93 - Check time_taptest_table_p20241126 still exists 185s ok 94 - Check time_taptest_table_p20241126 is empty 185s ok 95 - Check time_taptest_table_p20241127 still exists 185s ok 96 - Check time_taptest_table_p20241127 is empty 185s ok 97 - Check time_taptest_table_p20241128 still exists 185s ok 98 - Check time_taptest_table_p20241128 is empty 185s ok 99 - Check time_taptest_table_p20241129 still exists 185s ok 100 - Check time_taptest_table_p20241129 is empty 185s ok 101 - Ensure partman_test schema has been dropped 185s ok 102 - Ensure partman_retention_test schema has been dropped 185s ok 103 - Ensure partman_basic role has been dropped 185s ok 104 - Ensure partman_revoke role has been dropped 185s ok 105 - Ensure partman_owner role has been dropped 185s ok 185s All tests successful. 185s Files=1, Tests=105, 60 wallclock secs ( 0.03 usr 0.00 sys + 0.05 cusr 0.01 csys = 0.09 CPU) 185s Result: PASS 185s Dropping cluster 17/regress ... 185s ### End 17 virtualenv ### 186s autopkgtest [20:28:44]: test prove: -----------------------] 186s prove PASS 186s autopkgtest [20:28:44]: test prove: - - - - - - - - - - results - - - - - - - - - - 187s autopkgtest [20:28:45]: test scripts: preparing testbed 236s autopkgtest [20:29:34]: testbed dpkg architecture: amd64 236s autopkgtest [20:29:34]: testbed apt version: 2.9.8 236s autopkgtest [20:29:34]: @@@@@@@@@@@@@@@@@@@@ test bed setup 237s Get:1 http://ftpmaster.internal/ubuntu plucky-proposed InRelease [73.9 kB] 237s Get:2 http://ftpmaster.internal/ubuntu plucky-proposed/multiverse Sources [12.0 kB] 237s Get:3 http://ftpmaster.internal/ubuntu plucky-proposed/universe Sources [876 kB] 237s Get:4 http://ftpmaster.internal/ubuntu plucky-proposed/main Sources [54.2 kB] 237s Get:5 http://ftpmaster.internal/ubuntu plucky-proposed/restricted Sources [9704 B] 237s Get:6 http://ftpmaster.internal/ubuntu plucky-proposed/main i386 Packages [42.5 kB] 237s Get:7 http://ftpmaster.internal/ubuntu plucky-proposed/main amd64 Packages [91.7 kB] 238s Get:8 http://ftpmaster.internal/ubuntu plucky-proposed/restricted amd64 Packages [40.1 kB] 238s Get:9 http://ftpmaster.internal/ubuntu plucky-proposed/restricted i386 Packages [2408 B] 238s Get:10 http://ftpmaster.internal/ubuntu plucky-proposed/universe amd64 Packages [743 kB] 238s Get:11 http://ftpmaster.internal/ubuntu plucky-proposed/universe i386 Packages [274 kB] 238s Get:12 http://ftpmaster.internal/ubuntu plucky-proposed/multiverse i386 Packages [2820 B] 238s Get:13 http://ftpmaster.internal/ubuntu plucky-proposed/multiverse amd64 Packages [13.0 kB] 238s Fetched 2235 kB in 1s (1532 kB/s) 238s Reading package lists... 240s Reading package lists... 240s Building dependency tree... 240s Reading state information... 241s Calculating upgrade... 241s The following packages will be upgraded: 241s bpftrace curl distro-info fwupd-signed gir1.2-girepository-2.0 241s gir1.2-glib-2.0 intel-microcode libaudit-common libaudit1 libcurl3t64-gnutls 241s libcurl4t64 libgirepository-1.0-1 libglib2.0-0t64 libglib2.0-data 241s libpam-modules libpam-modules-bin libpam-runtime libpam0g libplymouth5 241s libselinux1 libsemanage-common libsemanage2 linux-base lxd-installer 241s openssh-client openssh-server openssh-sftp-server plymouth 241s plymouth-theme-ubuntu-text python3-dbus python3-gi 241s python3-jsonschema-specifications python3-rpds-py python3-yaml 241s 34 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 241s Need to get 15.7 MB of archives. 241s After this operation, 2666 kB of additional disk space will be used. 241s Get:1 http://ftpmaster.internal/ubuntu plucky/main amd64 libaudit-common all 1:4.0.2-2ubuntu1 [6578 B] 241s Get:2 http://ftpmaster.internal/ubuntu plucky/main amd64 libaudit1 amd64 1:4.0.2-2ubuntu1 [53.9 kB] 241s Get:3 http://ftpmaster.internal/ubuntu plucky/main amd64 libpam0g amd64 1.5.3-7ubuntu4 [69.6 kB] 241s Get:4 http://ftpmaster.internal/ubuntu plucky/main amd64 libselinux1 amd64 3.7-3ubuntu1 [86.9 kB] 241s Get:5 http://ftpmaster.internal/ubuntu plucky/main amd64 libpam-modules-bin amd64 1.5.3-7ubuntu4 [53.7 kB] 241s Get:6 http://ftpmaster.internal/ubuntu plucky/main amd64 libpam-modules amd64 1.5.3-7ubuntu4 [294 kB] 241s Get:7 http://ftpmaster.internal/ubuntu plucky/main amd64 openssh-sftp-server amd64 1:9.9p1-3ubuntu1 [41.2 kB] 241s Get:8 http://ftpmaster.internal/ubuntu plucky/main amd64 openssh-server amd64 1:9.9p1-3ubuntu1 [625 kB] 242s Get:9 http://ftpmaster.internal/ubuntu plucky/main amd64 openssh-client amd64 1:9.9p1-3ubuntu1 [1080 kB] 242s Get:10 http://ftpmaster.internal/ubuntu plucky/main amd64 libpam-runtime all 1.5.3-7ubuntu4 [40.8 kB] 242s Get:11 http://ftpmaster.internal/ubuntu plucky/main amd64 libsemanage-common all 3.7-2build1 [7186 B] 242s Get:12 http://ftpmaster.internal/ubuntu plucky/main amd64 libsemanage2 amd64 3.7-2build1 [105 kB] 242s Get:13 http://ftpmaster.internal/ubuntu plucky/main amd64 distro-info amd64 1.12 [20.0 kB] 242s Get:14 http://ftpmaster.internal/ubuntu plucky/main amd64 gir1.2-girepository-2.0 amd64 1.82.0-2 [25.3 kB] 242s Get:15 http://ftpmaster.internal/ubuntu plucky/main amd64 gir1.2-glib-2.0 amd64 2.82.2-3 [182 kB] 242s Get:16 http://ftpmaster.internal/ubuntu plucky/main amd64 libglib2.0-0t64 amd64 2.82.2-3 [1655 kB] 242s Get:17 http://ftpmaster.internal/ubuntu plucky/main amd64 libgirepository-1.0-1 amd64 1.82.0-2 [88.7 kB] 242s Get:18 http://ftpmaster.internal/ubuntu plucky/main amd64 libglib2.0-data all 2.82.2-3 [51.7 kB] 242s Get:19 http://ftpmaster.internal/ubuntu plucky/main amd64 python3-dbus amd64 1.3.2-5build4 [110 kB] 243s Get:20 http://ftpmaster.internal/ubuntu plucky/main amd64 python3-gi amd64 3.50.0-3build1 [293 kB] 243s Get:21 http://ftpmaster.internal/ubuntu plucky/main amd64 python3-yaml amd64 6.0.2-1build1 [187 kB] 243s Get:22 http://ftpmaster.internal/ubuntu plucky/main amd64 libplymouth5 amd64 24.004.60-2ubuntu2 [144 kB] 243s Get:23 http://ftpmaster.internal/ubuntu plucky/main amd64 plymouth-theme-ubuntu-text amd64 24.004.60-2ubuntu2 [10.3 kB] 243s Get:24 http://ftpmaster.internal/ubuntu plucky/main amd64 plymouth amd64 24.004.60-2ubuntu2 [139 kB] 243s Get:25 http://ftpmaster.internal/ubuntu plucky/main amd64 bpftrace amd64 0.21.2-2ubuntu3 [1787 kB] 243s Get:26 http://ftpmaster.internal/ubuntu plucky/main amd64 curl amd64 8.9.1-2ubuntu3 [243 kB] 243s Get:27 http://ftpmaster.internal/ubuntu plucky/main amd64 libcurl4t64 amd64 8.9.1-2ubuntu3 [420 kB] 243s Get:28 http://ftpmaster.internal/ubuntu plucky/main amd64 fwupd-signed amd64 1.55+1.7-1 [30.6 kB] 243s Get:29 http://ftpmaster.internal/ubuntu plucky/main amd64 libcurl3t64-gnutls amd64 8.9.1-2ubuntu3 [412 kB] 243s Get:30 http://ftpmaster.internal/ubuntu plucky/main amd64 linux-base all 4.10.1ubuntu1 [34.8 kB] 243s Get:31 http://ftpmaster.internal/ubuntu plucky/main amd64 lxd-installer all 10 [5264 B] 243s Get:32 http://ftpmaster.internal/ubuntu plucky/main amd64 python3-rpds-py amd64 0.21.0-2ubuntu1 [323 kB] 243s Get:33 http://ftpmaster.internal/ubuntu plucky/main amd64 python3-jsonschema-specifications all 2023.12.1-2 [9116 B] 243s Get:34 http://ftpmaster.internal/ubuntu plucky/main amd64 intel-microcode amd64 3.20241112.1ubuntu1 [7056 kB] 244s Preconfiguring packages ... 244s Fetched 15.7 MB in 3s (4953 kB/s) 244s (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 ... 75620 files and directories currently installed.) 244s Preparing to unpack .../libaudit-common_1%3a4.0.2-2ubuntu1_all.deb ... 244s Unpacking libaudit-common (1:4.0.2-2ubuntu1) over (1:4.0.1-1ubuntu2) ... 244s Setting up libaudit-common (1:4.0.2-2ubuntu1) ... 244s (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 ... 75620 files and directories currently installed.) 244s Preparing to unpack .../libaudit1_1%3a4.0.2-2ubuntu1_amd64.deb ... 244s Unpacking libaudit1:amd64 (1:4.0.2-2ubuntu1) over (1:4.0.1-1ubuntu2) ... 244s Setting up libaudit1:amd64 (1:4.0.2-2ubuntu1) ... 245s (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 ... 75620 files and directories currently installed.) 245s Preparing to unpack .../libpam0g_1.5.3-7ubuntu4_amd64.deb ... 245s Unpacking libpam0g:amd64 (1.5.3-7ubuntu4) over (1.5.3-7ubuntu2) ... 245s Setting up libpam0g:amd64 (1.5.3-7ubuntu4) ... 245s (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 ... 75620 files and directories currently installed.) 245s Preparing to unpack .../libselinux1_3.7-3ubuntu1_amd64.deb ... 245s Unpacking libselinux1:amd64 (3.7-3ubuntu1) over (3.5-2ubuntu5) ... 245s Setting up libselinux1:amd64 (3.7-3ubuntu1) ... 245s (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 ... 75620 files and directories currently installed.) 245s Preparing to unpack .../libpam-modules-bin_1.5.3-7ubuntu4_amd64.deb ... 245s Unpacking libpam-modules-bin (1.5.3-7ubuntu4) over (1.5.3-7ubuntu2) ... 245s Setting up libpam-modules-bin (1.5.3-7ubuntu4) ... 245s pam_namespace.service is a disabled or a static unit not running, not starting it. 245s (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 ... 75620 files and directories currently installed.) 245s Preparing to unpack .../libpam-modules_1.5.3-7ubuntu4_amd64.deb ... 245s Unpacking libpam-modules:amd64 (1.5.3-7ubuntu4) over (1.5.3-7ubuntu2) ... 245s Setting up libpam-modules:amd64 (1.5.3-7ubuntu4) ... 245s (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 ... 75620 files and directories currently installed.) 245s Preparing to unpack .../openssh-sftp-server_1%3a9.9p1-3ubuntu1_amd64.deb ... 245s Unpacking openssh-sftp-server (1:9.9p1-3ubuntu1) over (1:9.7p1-7ubuntu5) ... 245s Preparing to unpack .../openssh-server_1%3a9.9p1-3ubuntu1_amd64.deb ... 245s Unpacking openssh-server (1:9.9p1-3ubuntu1) over (1:9.7p1-7ubuntu5) ... 246s Preparing to unpack .../openssh-client_1%3a9.9p1-3ubuntu1_amd64.deb ... 246s Unpacking openssh-client (1:9.9p1-3ubuntu1) over (1:9.7p1-7ubuntu5) ... 246s Preparing to unpack .../libpam-runtime_1.5.3-7ubuntu4_all.deb ... 246s Unpacking libpam-runtime (1.5.3-7ubuntu4) over (1.5.3-7ubuntu2) ... 246s Setting up libpam-runtime (1.5.3-7ubuntu4) ... 246s (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 ... 75622 files and directories currently installed.) 246s Preparing to unpack .../libsemanage-common_3.7-2build1_all.deb ... 246s Unpacking libsemanage-common (3.7-2build1) over (3.5-1build6) ... 246s Setting up libsemanage-common (3.7-2build1) ... 246s (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 ... 75621 files and directories currently installed.) 246s Preparing to unpack .../libsemanage2_3.7-2build1_amd64.deb ... 246s Unpacking libsemanage2:amd64 (3.7-2build1) over (3.5-1build6) ... 246s Setting up libsemanage2:amd64 (3.7-2build1) ... 246s (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 ... 75621 files and directories currently installed.) 246s Preparing to unpack .../00-distro-info_1.12_amd64.deb ... 246s Unpacking distro-info (1.12) over (1.9) ... 246s Preparing to unpack .../01-gir1.2-girepository-2.0_1.82.0-2_amd64.deb ... 246s Unpacking gir1.2-girepository-2.0:amd64 (1.82.0-2) over (1.80.1-4) ... 246s Preparing to unpack .../02-gir1.2-glib-2.0_2.82.2-3_amd64.deb ... 246s Unpacking gir1.2-glib-2.0:amd64 (2.82.2-3) over (2.82.1-0ubuntu1) ... 246s Preparing to unpack .../03-libglib2.0-0t64_2.82.2-3_amd64.deb ... 246s Unpacking libglib2.0-0t64:amd64 (2.82.2-3) over (2.82.1-0ubuntu1) ... 246s Preparing to unpack .../04-libgirepository-1.0-1_1.82.0-2_amd64.deb ... 246s Unpacking libgirepository-1.0-1:amd64 (1.82.0-2) over (1.80.1-4) ... 246s Preparing to unpack .../05-libglib2.0-data_2.82.2-3_all.deb ... 246s Unpacking libglib2.0-data (2.82.2-3) over (2.82.1-0ubuntu1) ... 246s Preparing to unpack .../06-python3-dbus_1.3.2-5build4_amd64.deb ... 246s Unpacking python3-dbus (1.3.2-5build4) over (1.3.2-5build3) ... 246s Preparing to unpack .../07-python3-gi_3.50.0-3build1_amd64.deb ... 246s Unpacking python3-gi (3.50.0-3build1) over (3.50.0-3) ... 246s Preparing to unpack .../08-python3-yaml_6.0.2-1build1_amd64.deb ... 246s Unpacking python3-yaml (6.0.2-1build1) over (6.0.2-1) ... 246s Preparing to unpack .../09-libplymouth5_24.004.60-2ubuntu2_amd64.deb ... 246s Unpacking libplymouth5:amd64 (24.004.60-2ubuntu2) over (24.004.60-1ubuntu11) ... 246s Preparing to unpack .../10-plymouth-theme-ubuntu-text_24.004.60-2ubuntu2_amd64.deb ... 246s Unpacking plymouth-theme-ubuntu-text (24.004.60-2ubuntu2) over (24.004.60-1ubuntu11) ... 246s Preparing to unpack .../11-plymouth_24.004.60-2ubuntu2_amd64.deb ... 247s Unpacking plymouth (24.004.60-2ubuntu2) over (24.004.60-1ubuntu11) ... 247s Preparing to unpack .../12-bpftrace_0.21.2-2ubuntu3_amd64.deb ... 247s Unpacking bpftrace (0.21.2-2ubuntu3) over (0.21.2-2ubuntu2) ... 247s Preparing to unpack .../13-curl_8.9.1-2ubuntu3_amd64.deb ... 247s Unpacking curl (8.9.1-2ubuntu3) over (8.9.1-2ubuntu2) ... 247s Preparing to unpack .../14-libcurl4t64_8.9.1-2ubuntu3_amd64.deb ... 247s Unpacking libcurl4t64:amd64 (8.9.1-2ubuntu3) over (8.9.1-2ubuntu2) ... 247s Preparing to unpack .../15-fwupd-signed_1.55+1.7-1_amd64.deb ... 247s Unpacking fwupd-signed (1.55+1.7-1) over (1.54+1.6-1build1) ... 247s Preparing to unpack .../16-libcurl3t64-gnutls_8.9.1-2ubuntu3_amd64.deb ... 247s Unpacking libcurl3t64-gnutls:amd64 (8.9.1-2ubuntu3) over (8.9.1-2ubuntu2) ... 247s Preparing to unpack .../17-linux-base_4.10.1ubuntu1_all.deb ... 247s Unpacking linux-base (4.10.1ubuntu1) over (4.5ubuntu9) ... 247s Preparing to unpack .../18-lxd-installer_10_all.deb ... 247s Unpacking lxd-installer (10) over (9) ... 247s Preparing to unpack .../19-python3-rpds-py_0.21.0-2ubuntu1_amd64.deb ... 247s Unpacking python3-rpds-py (0.21.0-2ubuntu1) over (0.20.0-0ubuntu3) ... 247s Preparing to unpack .../20-python3-jsonschema-specifications_2023.12.1-2_all.deb ... 247s Unpacking python3-jsonschema-specifications (2023.12.1-2) over (2023.12.1-1ubuntu1) ... 247s Preparing to unpack .../21-intel-microcode_3.20241112.1ubuntu1_amd64.deb ... 247s Unpacking intel-microcode (3.20241112.1ubuntu1) over (3.20240910.0ubuntu1) ... 247s Setting up distro-info (1.12) ... 247s Setting up linux-base (4.10.1ubuntu1) ... 247s Setting up libcurl4t64:amd64 (8.9.1-2ubuntu3) ... 247s Setting up bpftrace (0.21.2-2ubuntu3) ... 247s Setting up openssh-client (1:9.9p1-3ubuntu1) ... 247s Setting up intel-microcode (3.20241112.1ubuntu1) ... 247s intel-microcode: microcode will be updated at next boot 247s Setting up libcurl3t64-gnutls:amd64 (8.9.1-2ubuntu3) ... 247s Setting up fwupd-signed (1.55+1.7-1) ... 247s Setting up python3-yaml (6.0.2-1build1) ... 247s Setting up libglib2.0-0t64:amd64 (2.82.2-3) ... 247s No schema files found: doing nothing. 247s Setting up libglib2.0-data (2.82.2-3) ... 247s Setting up gir1.2-glib-2.0:amd64 (2.82.2-3) ... 247s Setting up lxd-installer (10) ... 248s Setting up python3-rpds-py (0.21.0-2ubuntu1) ... 248s Setting up libplymouth5:amd64 (24.004.60-2ubuntu2) ... 248s Setting up libgirepository-1.0-1:amd64 (1.82.0-2) ... 248s Setting up curl (8.9.1-2ubuntu3) ... 248s Setting up python3-jsonschema-specifications (2023.12.1-2) ... 248s Setting up openssh-sftp-server (1:9.9p1-3ubuntu1) ... 248s Setting up python3-dbus (1.3.2-5build4) ... 248s Setting up openssh-server (1:9.9p1-3ubuntu1) ... 248s Installing new version of config file /etc/ssh/moduli ... 249s Setting up plymouth (24.004.60-2ubuntu2) ... 249s update-initramfs: Generating /boot/initrd.img-6.11.0-8-generic 249s W: No lz4 in /usr/bin:/sbin:/bin, using gzip 257s update-rc.d: warning: start and stop actions are no longer supported; falling back to defaults 257s update-rc.d: warning: start and stop actions are no longer supported; falling back to defaults 257s Setting up plymouth-theme-ubuntu-text (24.004.60-2ubuntu2) ... 257s update-initramfs: deferring update (trigger activated) 257s Setting up gir1.2-girepository-2.0:amd64 (1.82.0-2) ... 257s Setting up python3-gi (3.50.0-3build1) ... 258s Processing triggers for ufw (0.36.2-8) ... 258s Processing triggers for man-db (2.13.0-1) ... 259s Processing triggers for libc-bin (2.40-1ubuntu3) ... 259s Processing triggers for initramfs-tools (0.142ubuntu35) ... 259s update-initramfs: Generating /boot/initrd.img-6.11.0-8-generic 259s W: No lz4 in /usr/bin:/sbin:/bin, using gzip 266s Reading package lists... 266s Building dependency tree... 266s Reading state information... 266s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 266s Hit:1 http://ftpmaster.internal/ubuntu plucky-proposed InRelease 266s Hit:2 http://ftpmaster.internal/ubuntu plucky InRelease 266s Hit:3 http://ftpmaster.internal/ubuntu plucky-updates InRelease 267s Hit:4 http://ftpmaster.internal/ubuntu plucky-security InRelease 267s Reading package lists... 268s Reading package lists... 268s Building dependency tree... 268s Reading state information... 268s Calculating upgrade... 268s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 268s Reading package lists... 268s Building dependency tree... 268s Reading state information... 268s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 268s autopkgtest [20:30:06]: rebooting testbed after setup commands that affected boot 272s autopkgtest-virt-ssh: WARNING: ssh connection failed. Retrying in 3 seconds... 290s Reading package lists... 291s Building dependency tree... 291s Reading state information... 291s Starting pkgProblemResolver with broken count: 0 292s Starting 2 pkgProblemResolver with broken count: 0 292s Done 292s The following additional packages will be installed: 292s libio-pty-perl libipc-run-perl libjson-perl libpq5 libxslt1.1 postgresql-17 292s postgresql-17-partman postgresql-client-17 postgresql-client-common 292s postgresql-common python3-psycopg2 ssl-cert 292s Suggested packages: 292s postgresql-doc-17 python-psycopg2-doc 292s Recommended packages: 292s libjson-xs-perl 292s The following NEW packages will be installed: 292s autopkgtest-satdep libio-pty-perl libipc-run-perl libjson-perl libpq5 292s libxslt1.1 postgresql-17 postgresql-17-partman postgresql-client-17 292s postgresql-client-common postgresql-common python3-psycopg2 ssl-cert 292s 0 upgraded, 13 newly installed, 0 to remove and 0 not upgraded. 292s Need to get 21.2 MB/21.2 MB of archives. 292s After this operation, 79.9 MB of additional disk space will be used. 292s Get:1 /tmp/autopkgtest.TIDjGX/2-autopkgtest-satdep.deb autopkgtest-satdep amd64 0 [712 B] 292s Get:2 http://ftpmaster.internal/ubuntu plucky/main amd64 libjson-perl all 4.10000-1 [81.9 kB] 293s Get:3 http://ftpmaster.internal/ubuntu plucky/main amd64 libio-pty-perl amd64 1:1.20-1build3 [31.4 kB] 293s Get:4 http://ftpmaster.internal/ubuntu plucky/main amd64 libipc-run-perl all 20231003.0-2 [91.5 kB] 293s Get:5 http://ftpmaster.internal/ubuntu plucky-proposed/main amd64 postgresql-client-common all 267 [37.1 kB] 293s Get:6 http://ftpmaster.internal/ubuntu plucky/main amd64 ssl-cert all 1.1.2ubuntu2 [18.0 kB] 293s Get:7 http://ftpmaster.internal/ubuntu plucky-proposed/main amd64 postgresql-common all 267 [162 kB] 293s Get:8 http://ftpmaster.internal/ubuntu plucky/main amd64 libpq5 amd64 17.0-1 [249 kB] 293s Get:9 http://ftpmaster.internal/ubuntu plucky/main amd64 libxslt1.1 amd64 1.1.39-0exp1ubuntu1 [169 kB] 293s Get:10 http://ftpmaster.internal/ubuntu plucky/main amd64 postgresql-client-17 amd64 17.0-1 [2111 kB] 293s Get:11 http://ftpmaster.internal/ubuntu plucky/main amd64 postgresql-17 amd64 17.0-1 [17.9 MB] 294s Get:12 http://ftpmaster.internal/ubuntu plucky/main amd64 python3-psycopg2 amd64 2.9.9-2build1 [146 kB] 294s Get:13 http://ftpmaster.internal/ubuntu plucky-proposed/universe amd64 postgresql-17-partman amd64 5.1.0-2 [224 kB] 295s Preconfiguring packages ... 295s Fetched 21.2 MB in 2s (9880 kB/s) 295s Selecting previously unselected package libjson-perl. 295s (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 ... 75654 files and directories currently installed.) 295s Preparing to unpack .../00-libjson-perl_4.10000-1_all.deb ... 295s Unpacking libjson-perl (4.10000-1) ... 295s Selecting previously unselected package libio-pty-perl. 295s Preparing to unpack .../01-libio-pty-perl_1%3a1.20-1build3_amd64.deb ... 295s Unpacking libio-pty-perl (1:1.20-1build3) ... 295s Selecting previously unselected package libipc-run-perl. 295s Preparing to unpack .../02-libipc-run-perl_20231003.0-2_all.deb ... 295s Unpacking libipc-run-perl (20231003.0-2) ... 295s Selecting previously unselected package postgresql-client-common. 295s Preparing to unpack .../03-postgresql-client-common_267_all.deb ... 295s Unpacking postgresql-client-common (267) ... 295s Selecting previously unselected package ssl-cert. 295s Preparing to unpack .../04-ssl-cert_1.1.2ubuntu2_all.deb ... 295s Unpacking ssl-cert (1.1.2ubuntu2) ... 295s Selecting previously unselected package postgresql-common. 295s Preparing to unpack .../05-postgresql-common_267_all.deb ... 295s Adding 'diversion of /usr/bin/pg_config to /usr/bin/pg_config.libpq-dev by postgresql-common' 296s Unpacking postgresql-common (267) ... 296s Selecting previously unselected package libpq5:amd64. 296s Preparing to unpack .../06-libpq5_17.0-1_amd64.deb ... 296s Unpacking libpq5:amd64 (17.0-1) ... 296s Selecting previously unselected package libxslt1.1:amd64. 296s Preparing to unpack .../07-libxslt1.1_1.1.39-0exp1ubuntu1_amd64.deb ... 296s Unpacking libxslt1.1:amd64 (1.1.39-0exp1ubuntu1) ... 296s Selecting previously unselected package postgresql-client-17. 296s Preparing to unpack .../08-postgresql-client-17_17.0-1_amd64.deb ... 296s Unpacking postgresql-client-17 (17.0-1) ... 296s Selecting previously unselected package postgresql-17. 296s Preparing to unpack .../09-postgresql-17_17.0-1_amd64.deb ... 296s Unpacking postgresql-17 (17.0-1) ... 296s Selecting previously unselected package python3-psycopg2. 296s Preparing to unpack .../10-python3-psycopg2_2.9.9-2build1_amd64.deb ... 296s Unpacking python3-psycopg2 (2.9.9-2build1) ... 296s Selecting previously unselected package postgresql-17-partman. 296s Preparing to unpack .../11-postgresql-17-partman_5.1.0-2_amd64.deb ... 296s Unpacking postgresql-17-partman (5.1.0-2) ... 297s Selecting previously unselected package autopkgtest-satdep. 297s Preparing to unpack .../12-2-autopkgtest-satdep.deb ... 297s Unpacking autopkgtest-satdep (0) ... 297s Setting up libio-pty-perl (1:1.20-1build3) ... 297s Setting up libpq5:amd64 (17.0-1) ... 297s Setting up ssl-cert (1.1.2ubuntu2) ... 297s Created symlink '/etc/systemd/system/multi-user.target.wants/ssl-cert.service' → '/usr/lib/systemd/system/ssl-cert.service'. 297s Setting up python3-psycopg2 (2.9.9-2build1) ... 298s Setting up libipc-run-perl (20231003.0-2) ... 298s Setting up libjson-perl (4.10000-1) ... 298s Setting up libxslt1.1:amd64 (1.1.39-0exp1ubuntu1) ... 298s Setting up postgresql-client-common (267) ... 298s Setting up postgresql-client-17 (17.0-1) ... 298s update-alternatives: using /usr/share/postgresql/17/man/man1/psql.1.gz to provide /usr/share/man/man1/psql.1.gz (psql.1.gz) in auto mode 298s Setting up postgresql-common (267) ... 299s 299s Creating config file /etc/postgresql-common/createcluster.conf with new version 299s Building PostgreSQL dictionaries from installed myspell/hunspell packages... 299s Removing obsolete dictionary files: 300s Created symlink '/etc/systemd/system/multi-user.target.wants/postgresql.service' → '/usr/lib/systemd/system/postgresql.service'. 300s Setting up postgresql-17 (17.0-1) ... 301s Creating new PostgreSQL cluster 17/main ... 301s /usr/lib/postgresql/17/bin/initdb -D /var/lib/postgresql/17/main --auth-local peer --auth-host scram-sha-256 --no-instructions 301s The files belonging to this database system will be owned by user "postgres". 301s This user must also own the server process. 301s 301s The database cluster will be initialized with locale "C.UTF-8". 301s The default database encoding has accordingly been set to "UTF8". 301s The default text search configuration will be set to "english". 301s 301s Data page checksums are disabled. 301s 301s fixing permissions on existing directory /var/lib/postgresql/17/main ... ok 301s creating subdirectories ... ok 301s selecting dynamic shared memory implementation ... posix 301s selecting default "max_connections" ... 100 301s selecting default "shared_buffers" ... 128MB 301s selecting default time zone ... Etc/UTC 301s creating configuration files ... ok 301s running bootstrap script ... ok 302s performing post-bootstrap initialization ... ok 302s syncing data to disk ... ok 306s Setting up postgresql-17-partman (5.1.0-2) ... 306s Setting up autopkgtest-satdep (0) ... 306s Processing triggers for man-db (2.13.0-1) ... 307s Processing triggers for libc-bin (2.40-1ubuntu3) ... 310s (Reading database ... 78145 files and directories currently installed.) 310s Removing autopkgtest-satdep (0) ... 312s autopkgtest [20:30:50]: test scripts: [----------------------- 312s + /usr/lib/postgresql/17/bin/check_unique_constraint.py --help 312s usage: check_unique_constraint.py [-h] [-p PARENT] [-l COLUMN_LIST] 312s [-c CONNECTION] [-t TEMP] [--psql PSQL] 312s [--simple] [--index_scan] [-q] [--version] 312s 312s This script is used to check that all rows in a partition set are unique for 312s the given columns. Since unique constraints are not applied across partition 312s sets, this cannot be enforced within the database. This script can be used as 312s a monitor to ensure uniquness. If any unique violations are found, the values, 312s along with a count of each, are output. 312s 312s options: 312s -h, --help show this help message and exit 312s -p PARENT, --parent PARENT 312s Parent table of the partition set to be checked 312s -l COLUMN_LIST, --column_list COLUMN_LIST 312s Comma separated list of columns that make up the 312s unique constraint to be checked 312s -c CONNECTION, --connection CONNECTION 312s Connection string for use by psycopg. Defaults to 312s "host=" (local socket). 312s -t TEMP, --temp TEMP Path to a writable folder that can be used for temp 312s working files. Defaults system temp folder. 312s --psql PSQL Full path to psql binary if not in current PATH 312s --simple Output a single integer value with the total duplicate 312s count. Use this for monitoring software that requires 312s a simple value to be checked for. 312s --index_scan By default index scans are disabled to force the 312s script to check the actual table data with sequential 312s scans. Set this option if you want the script to allow 312s index scans to be used (does not guarentee that they 312s will be used). 312s -q, --quiet Suppress all output unless there is a constraint 312s violation found. 312s --version Print out the minimum version of pg_partman this 312s script is meant to work with. The version of 312s pg_partman installed may be greater than this. 312s + /usr/lib/postgresql/17/bin/dump_partition.py --help 312s usage: dump_partition.py [-h] [-n SCHEMA] [-c CONNECTION] [-o OUTPUT] 312s [-d DUMP_DATABASE] [--dump_host DUMP_HOST] 312s [--dump_username DUMP_USERNAME] 312s [--dump_port DUMP_PORT] [--pg_dump_path PG_DUMP_PATH] 312s [--Fp] [--nohashfile] [--nodrop] [-v] [--version] 312s 312s This script will dump out and then drop all tables contained in the designated 312s schema using pg_dump. Each table will be in its own separate file along with a 312s SHA-512 hash of the dump file. Tables are not dropped from the database if 312s pg_dump does not return successfully. All dump_* option defaults are the same 312s as they would be for pg_dump if they are not given. 312s 312s options: 312s -h, --help show this help message and exit 312s -n SCHEMA, --schema SCHEMA 312s (Required) The schema that contains the tables that 312s will be dumped. 312s -c CONNECTION, --connection CONNECTION 312s Connection string for use by psycopg. Role used must 312s be able to select pg_catalog.pg_tables in the relevant 312s database and drop all tables in the given schema. 312s Defaults to "host=" (local socket). Note this is 312s distinct from the parameters sent to pg_dump. 312s -o OUTPUT, --output OUTPUT 312s Path to dump file output location. Default is where 312s the script is run from. 312s -d DUMP_DATABASE, --dump_database DUMP_DATABASE 312s Used for pg_dump, same as its --dbname (-d) option or 312s final database name parameter. 312s --dump_host DUMP_HOST 312s Used for pg_dump, same as its --host (-h) option. 312s --dump_username DUMP_USERNAME 312s Used for pg_dump, same as its --username (-U) option. 312s --dump_port DUMP_PORT 312s Used for pg_dump, same as its --port (-p) option. 312s --pg_dump_path PG_DUMP_PATH 312s Path to pg_dump binary location. Must set if not in 312s current PATH. 312s --Fp Dump using pg_dump plain text format. Default is 312s binary custom (-Fc). 312s --nohashfile Do NOT create a separate file with the SHA-512 hash of 312s the dump. If dump files are very large, hash 312s generation can possibly take a long time. 312s --nodrop Do NOT drop the tables from the given schema after 312s dumping/hashing. 312s -v, --verbose Provide more verbose output. 312s --version Print out the minimum version of pg_partman this 312s script is meant to work with. The version of 312s pg_partman installed may be greater than this. 312s 312s NOTE: The connection options for psyocpg and pg_dump were separated out due to 312s distinct differences in their requirements depending on your database 312s connection configuration. 312s + /usr/lib/postgresql/17/bin/vacuum_maintenance.py --help 312s usage: vacuum_maintenance.py [-h] [-p PARENT] [--all] [-c CONNECTION] [-z] 312s [-f] [-a VACUUM_FREEZE_MIN_AGE] [-t {time,id}] 312s [-i INTERVAL] [--noparent] [--dryrun] [-q] 312s [--version] [--debug] 312s 312s Script for performing additional vacuum maintenance on the child tables of a 312s partition set in order to avoid excess vacuuming and transaction id wraparound 312s issues. Whether a table is vacuumed or not by this script depends on whether 312s its age(relfrozenxid) is greater than vacuum_freeze_min_age. This ensures 312s repeated runs of this script do not re-vacuum tables that have already had all 312s of their page tuples frozen. This script does not require pg_partman to be 312s installed and will work on any inheritance set given a parent table, as long 312s as the options --all, --type or --interval are NOT set. 312s 312s options: 312s -h, --help show this help message and exit 312s -p PARENT, --parent PARENT 312s Parent table of an already created 312s partition/inheritance set. Either this option or --all 312s is required. 312s --all Run against all tables managed by pg_partman. Either 312s this option or -p is required. Overrides -p if both 312s are set. 312s -c CONNECTION, --connection CONNECTION 312s Connection string for use by psycopg. Defaults to 312s "host=" (local socket). 312s -z, --freeze Sets the FREEZE option to the VACUUM command. 312s -f, --full Sets the FULL option to the VACUUM command. Note that 312s --freeze is not necessary if you set this. Recommend 312s reviewing --dryrun before running this since it will 312s lock all tables it runs against, possibly including 312s the parent. 312s -a VACUUM_FREEZE_MIN_AGE, --vacuum_freeze_min_age VACUUM_FREEZE_MIN_AGE 312s By default the script obtains this value from the 312s system catalogs. By setting this, you can override the 312s value obtained from the database. Note this does not 312s change the value in the database, only the value this 312s script uses. 312s -t {time,id}, --type {time,id} 312s Tells the script whether the value given by --interval 312s is either time or id based. Also, if --all is set, 312s limits the partition sets that the script runs against 312s to just those types. Valid values are: "id" and 312s "time". 312s -i INTERVAL, --interval INTERVAL 312s In addition to checking transaction age, only run 312s against tables that are older than the interval given. 312s Takes either a postgresql time interval or integer 312s value. For time-based partitioning, uses the time that 312s script is run as baseline. For id-based partitioning, 312s the integer value will set that any partitions with an 312s id value less than the current maximum id value minus 312s the given value will be vacuumed. For example, if the 312s current max id is 100 and the given value is 30, any 312s partitions with id values less than 70 will be 312s vacuumed. The current maximum id value at the time the 312s script is run is always used. 312s --noparent Normally the parent table is included in the list of 312s tables to vacuum if its age(relfrozenxid) is higher 312s than vacuum_freeze_min_age. Set this to force 312s exclusion of the parent table, even if it meets that 312s criteria. 312s --dryrun Show what the script will do without actually running 312s it against the database. Highly recommend reviewing 312s this before running for the first time. 312s -q, --quiet Turn off all output. 312s --version Print out the minimum version of pg_partman this 312s script is meant to work with. The version of 312s pg_partman installed may be greater than this. 312s --debug Show additional debugging output 313s autopkgtest [20:30:51]: test scripts: -----------------------] 313s scripts PASS 313s autopkgtest [20:30:51]: test scripts: - - - - - - - - - - results - - - - - - - - - - 313s autopkgtest [20:30:51]: @@@@@@@@@@@@@@@@@@@@ summary 313s prove PASS 313s scripts PASS 326s virt: nova [W] Skipping flock for amd64 326s virt: Creating nova instance adt-plucky-amd64-pg-partman-20241121-202538-juju-7f2275-prod-proposed-migration-environment-2-84fb5ff6-5c94-4394-932c-1946095b442e from image adt/ubuntu-plucky-amd64-server-20241119.img (UUID 2e5306de-7efa-448c-bc27-5518979e66f0)... 326s virt: nova [W] Skipping flock for amd64 326s virt: Creating nova instance adt-plucky-amd64-pg-partman-20241121-202538-juju-7f2275-prod-proposed-migration-environment-2-84fb5ff6-5c94-4394-932c-1946095b442e from image adt/ubuntu-plucky-amd64-server-20241119.img (UUID 2e5306de-7efa-448c-bc27-5518979e66f0)...