0s autopkgtest [22:58:13]: starting date and time: 2025-01-03 22:58:13+0000 0s autopkgtest [22:58:13]: git checkout: 325255d2 Merge branch 'pin-any-arch' into 'ubuntu/production' 0s autopkgtest [22:58:13]: host juju-7f2275-prod-proposed-migration-environment-15; command line: /home/ubuntu/autopkgtest/runner/autopkgtest --output-dir /tmp/autopkgtest-work.jronjf1j/out --timeout-copy=6000 --setup-commands /home/ubuntu/autopkgtest-cloud/worker-config-production/setup-canonical.sh --apt-pocket=proposed=src:python3-defaults --apt-upgrade pg-partman --timeout-short=300 --timeout-copy=20000 --timeout-build=20000 '--env=ADT_TEST_TRIGGERS=python3-defaults/3.13.1-1~exp2' -- ssh -s /home/ubuntu/autopkgtest/ssh-setup/nova -- --flavor autopkgtest-ppc64el --security-groups autopkgtest-juju-7f2275-prod-proposed-migration-environment-15@bos03-ppc64el-12.secgroup --name adt-plucky-ppc64el-pg-partman-20250103-224240-juju-7f2275-prod-proposed-migration-environment-15-80cb8a93-225c-4e65-8c94-641bae5de4db --image adt/ubuntu-plucky-ppc64el-server --keyname testbed-juju-7f2275-prod-proposed-migration-environment-15 --net-id=net_prod-proposed-migration-ppc64el -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,radosgw.ps5.canonical.com'"'"'' --mirror=http://ftpmaster.internal/ubuntu/ 124s autopkgtest [23:00:17]: testbed dpkg architecture: ppc64el 124s autopkgtest [23:00:17]: testbed apt version: 2.9.18 124s autopkgtest [23:00:17]: @@@@@@@@@@@@@@@@@@@@ test bed setup 125s autopkgtest [23:00:18]: testbed release detected to be: None 125s autopkgtest [23:00:18]: updating testbed package index (apt update) 126s Get:1 http://ftpmaster.internal/ubuntu plucky-proposed InRelease [73.9 kB] 126s Hit:2 http://ftpmaster.internal/ubuntu plucky InRelease 126s Hit:3 http://ftpmaster.internal/ubuntu plucky-updates InRelease 126s Hit:4 http://ftpmaster.internal/ubuntu plucky-security InRelease 126s Get:5 http://ftpmaster.internal/ubuntu plucky-proposed/universe Sources [804 kB] 126s Get:6 http://ftpmaster.internal/ubuntu plucky-proposed/restricted Sources [9708 B] 126s Get:7 http://ftpmaster.internal/ubuntu plucky-proposed/main Sources [78.5 kB] 126s Get:8 http://ftpmaster.internal/ubuntu plucky-proposed/multiverse Sources [12.3 kB] 126s Get:9 http://ftpmaster.internal/ubuntu plucky-proposed/main ppc64el Packages [87.2 kB] 126s Get:10 http://ftpmaster.internal/ubuntu plucky-proposed/restricted ppc64el Packages [756 B] 126s Get:11 http://ftpmaster.internal/ubuntu plucky-proposed/universe ppc64el Packages [693 kB] 126s Get:12 http://ftpmaster.internal/ubuntu plucky-proposed/multiverse ppc64el Packages [4084 B] 127s Fetched 1763 kB in 1s (1669 kB/s) 127s Reading package lists... 128s Reading package lists... 128s Building dependency tree... 128s Reading state information... 128s Calculating upgrade... 128s The following packages will be upgraded: 128s binutils binutils-common binutils-powerpc64le-linux-gnu libbinutils 128s libctf-nobfd0 libctf0 libsframe1 128s 7 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 128s Need to get 3752 kB of archives. 128s After this operation, 0 B of additional disk space will be used. 128s Get:1 http://ftpmaster.internal/ubuntu plucky/main ppc64el libctf0 ppc64el 2.43.50.20241230-1ubuntu1 [114 kB] 129s Get:2 http://ftpmaster.internal/ubuntu plucky/main ppc64el libctf-nobfd0 ppc64el 2.43.50.20241230-1ubuntu1 [117 kB] 129s Get:3 http://ftpmaster.internal/ubuntu plucky/main ppc64el binutils-powerpc64le-linux-gnu ppc64el 2.43.50.20241230-1ubuntu1 [2569 kB] 129s Get:4 http://ftpmaster.internal/ubuntu plucky/main ppc64el libbinutils ppc64el 2.43.50.20241230-1ubuntu1 [711 kB] 129s Get:5 http://ftpmaster.internal/ubuntu plucky/main ppc64el binutils ppc64el 2.43.50.20241230-1ubuntu1 [3096 B] 129s Get:6 http://ftpmaster.internal/ubuntu plucky/main ppc64el binutils-common ppc64el 2.43.50.20241230-1ubuntu1 [222 kB] 129s Get:7 http://ftpmaster.internal/ubuntu plucky/main ppc64el libsframe1 ppc64el 2.43.50.20241230-1ubuntu1 [15.9 kB] 129s Fetched 3752 kB in 1s (4785 kB/s) 130s (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 ... 74025 files and directories currently installed.) 130s Preparing to unpack .../0-libctf0_2.43.50.20241230-1ubuntu1_ppc64el.deb ... 130s Unpacking libctf0:ppc64el (2.43.50.20241230-1ubuntu1) over (2.43.50.20241221-1ubuntu1) ... 130s Preparing to unpack .../1-libctf-nobfd0_2.43.50.20241230-1ubuntu1_ppc64el.deb ... 130s Unpacking libctf-nobfd0:ppc64el (2.43.50.20241230-1ubuntu1) over (2.43.50.20241221-1ubuntu1) ... 130s Preparing to unpack .../2-binutils-powerpc64le-linux-gnu_2.43.50.20241230-1ubuntu1_ppc64el.deb ... 130s Unpacking binutils-powerpc64le-linux-gnu (2.43.50.20241230-1ubuntu1) over (2.43.50.20241221-1ubuntu1) ... 130s Preparing to unpack .../3-libbinutils_2.43.50.20241230-1ubuntu1_ppc64el.deb ... 130s Unpacking libbinutils:ppc64el (2.43.50.20241230-1ubuntu1) over (2.43.50.20241221-1ubuntu1) ... 130s Preparing to unpack .../4-binutils_2.43.50.20241230-1ubuntu1_ppc64el.deb ... 130s Unpacking binutils (2.43.50.20241230-1ubuntu1) over (2.43.50.20241221-1ubuntu1) ... 130s Preparing to unpack .../5-binutils-common_2.43.50.20241230-1ubuntu1_ppc64el.deb ... 130s Unpacking binutils-common:ppc64el (2.43.50.20241230-1ubuntu1) over (2.43.50.20241221-1ubuntu1) ... 130s Preparing to unpack .../6-libsframe1_2.43.50.20241230-1ubuntu1_ppc64el.deb ... 130s Unpacking libsframe1:ppc64el (2.43.50.20241230-1ubuntu1) over (2.43.50.20241221-1ubuntu1) ... 130s Setting up binutils-common:ppc64el (2.43.50.20241230-1ubuntu1) ... 130s Setting up libctf-nobfd0:ppc64el (2.43.50.20241230-1ubuntu1) ... 130s Setting up libsframe1:ppc64el (2.43.50.20241230-1ubuntu1) ... 130s Setting up libbinutils:ppc64el (2.43.50.20241230-1ubuntu1) ... 130s Setting up libctf0:ppc64el (2.43.50.20241230-1ubuntu1) ... 130s Setting up binutils-powerpc64le-linux-gnu (2.43.50.20241230-1ubuntu1) ... 130s Setting up binutils (2.43.50.20241230-1ubuntu1) ... 130s Processing triggers for libc-bin (2.40-4ubuntu1) ... 130s Processing triggers for man-db (2.13.0-1) ... 131s Reading package lists... 131s Building dependency tree... 131s Reading state information... 131s 0 upgraded, 0 newly installed, 0 to remove and 3 not upgraded. 131s autopkgtest [23:00:24]: upgrading testbed (apt dist-upgrade and autopurge) 131s Reading package lists... 132s Building dependency tree... 132s Reading state information... 132s Calculating upgrade...Starting pkgProblemResolver with broken count: 0 132s Starting 2 pkgProblemResolver with broken count: 0 132s Done 132s Entering ResolveByKeep 132s 132s The following packages were automatically installed and are no longer required: 132s python3.12 python3.12-minimal 132s Use 'sudo apt autoremove' to remove them. 132s The following NEW packages will be installed: 132s libpython3.13-minimal libpython3.13-stdlib python3.13 python3.13-minimal 132s The following packages will be upgraded: 132s libpython3-stdlib python3 python3-minimal 133s 3 upgraded, 4 newly installed, 0 to remove and 0 not upgraded. 133s Need to get 6300 kB of archives. 133s After this operation, 26.2 MB of additional disk space will be used. 133s Get:1 http://ftpmaster.internal/ubuntu plucky/main ppc64el libpython3.13-minimal ppc64el 3.13.1-2 [883 kB] 133s Get:2 http://ftpmaster.internal/ubuntu plucky/main ppc64el python3.13-minimal ppc64el 3.13.1-2 [2496 kB] 133s Get:3 http://ftpmaster.internal/ubuntu plucky-proposed/main ppc64el python3-minimal ppc64el 3.13.1-1~exp2 [27.6 kB] 133s Get:4 http://ftpmaster.internal/ubuntu plucky-proposed/main ppc64el python3 ppc64el 3.13.1-1~exp2 [24.0 kB] 133s Get:5 http://ftpmaster.internal/ubuntu plucky/main ppc64el libpython3.13-stdlib ppc64el 3.13.1-2 [2131 kB] 133s Get:6 http://ftpmaster.internal/ubuntu plucky/main ppc64el python3.13 ppc64el 3.13.1-2 [729 kB] 134s Get:7 http://ftpmaster.internal/ubuntu plucky-proposed/main ppc64el libpython3-stdlib ppc64el 3.13.1-1~exp2 [10.2 kB] 134s Fetched 6300 kB in 1s (5780 kB/s) 134s Selecting previously unselected package libpython3.13-minimal:ppc64el. 134s (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 ... 74025 files and directories currently installed.) 134s Preparing to unpack .../libpython3.13-minimal_3.13.1-2_ppc64el.deb ... 134s Unpacking libpython3.13-minimal:ppc64el (3.13.1-2) ... 134s Selecting previously unselected package python3.13-minimal. 134s Preparing to unpack .../python3.13-minimal_3.13.1-2_ppc64el.deb ... 134s Unpacking python3.13-minimal (3.13.1-2) ... 134s Setting up libpython3.13-minimal:ppc64el (3.13.1-2) ... 134s Setting up python3.13-minimal (3.13.1-2) ... 135s (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 ... 74345 files and directories currently installed.) 135s Preparing to unpack .../python3-minimal_3.13.1-1~exp2_ppc64el.deb ... 135s Unpacking python3-minimal (3.13.1-1~exp2) over (3.12.8-1) ... 135s Setting up python3-minimal (3.13.1-1~exp2) ... 135s (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 ... 74345 files and directories currently installed.) 135s Preparing to unpack .../python3_3.13.1-1~exp2_ppc64el.deb ... 135s Unpacking python3 (3.13.1-1~exp2) over (3.12.8-1) ... 135s Selecting previously unselected package libpython3.13-stdlib:ppc64el. 135s Preparing to unpack .../libpython3.13-stdlib_3.13.1-2_ppc64el.deb ... 135s Unpacking libpython3.13-stdlib:ppc64el (3.13.1-2) ... 135s Selecting previously unselected package python3.13. 135s Preparing to unpack .../python3.13_3.13.1-2_ppc64el.deb ... 135s Unpacking python3.13 (3.13.1-2) ... 135s Preparing to unpack .../libpython3-stdlib_3.13.1-1~exp2_ppc64el.deb ... 135s Unpacking libpython3-stdlib:ppc64el (3.13.1-1~exp2) over (3.12.8-1) ... 135s Setting up libpython3.13-stdlib:ppc64el (3.13.1-2) ... 135s Setting up libpython3-stdlib:ppc64el (3.13.1-1~exp2) ... 135s Setting up python3.13 (3.13.1-2) ... 136s Setting up python3 (3.13.1-1~exp2) ... 136s /usr/bin/py3clean:101: DeprecationWarning: glob.glob1 is deprecated and will be removed in Python 3.15. Use glob.glob and pass a directory to its root_dir argument instead. 136s for fn in glob1(directory, "%s.*" % fname): 136s Processing triggers for man-db (2.13.0-1) ... 137s Processing triggers for systemd (257-2ubuntu1) ... 137s Reading package lists... 137s Building dependency tree... 137s Reading state information... 137s Starting pkgProblemResolver with broken count: 0 137s Starting 2 pkgProblemResolver with broken count: 0 137s Done 138s The following packages will be REMOVED: 138s python3.12* python3.12-minimal* 138s 0 upgraded, 0 newly installed, 2 to remove and 0 not upgraded. 138s After this operation, 9889 kB disk space will be freed. 138s (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 ... 74762 files and directories currently installed.) 138s Removing python3.12 (3.12.8-3) ... 138s Removing python3.12-minimal (3.12.8-3) ... 138s /usr/bin/py3clean:125: DeprecationWarning: glob.glob1 is deprecated and will be removed in Python 3.15. Use glob.glob and pass a directory to its root_dir argument instead. 138s for fn in glob1(directory, "%s.%s.py[co]" % (fname, magic_tag)): 139s Processing triggers for man-db (2.13.0-1) ... 139s Processing triggers for systemd (257-2ubuntu1) ... 139s (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 ... 74734 files and directories currently installed.) 139s Purging configuration files for python3.12-minimal (3.12.8-3) ... 142s autopkgtest [23:00:35]: testbed running kernel: Linux 6.11.0-8-generic #8-Ubuntu SMP Mon Sep 16 13:49:23 UTC 2024 142s autopkgtest [23:00:35]: @@@@@@@@@@@@@@@@@@@@ apt-source pg-partman 144s Get:1 http://ftpmaster.internal/ubuntu plucky/universe pg-partman 5.2.2-1 (dsc) [2307 B] 144s Get:2 http://ftpmaster.internal/ubuntu plucky/universe pg-partman 5.2.2-1 (tar) [1248 kB] 144s Get:3 http://ftpmaster.internal/ubuntu plucky/universe pg-partman 5.2.2-1 (diff) [4260 B] 144s gpgv: Signature made Wed Dec 11 22:00:11 2024 UTC 144s gpgv: using RSA key 5C48FE6157F49179597087C64C5A6BAB12D2A7AE 144s gpgv: Can't check signature: No public key 144s dpkg-source: warning: cannot verify inline signature for ./pg-partman_5.2.2-1.dsc: no acceptable signature found 144s autopkgtest [23:00:37]: testing package pg-partman version 5.2.2-1 144s autopkgtest [23:00:37]: build not needed 145s autopkgtest [23:00:38]: test prove: preparing testbed 145s Reading package lists... 146s Building dependency tree... 146s Reading state information... 146s Starting pkgProblemResolver with broken count: 0 146s Starting 2 pkgProblemResolver with broken count: 0 146s Done 146s The following NEW packages will be installed: 146s libjson-perl libpq5 libtap-parser-sourcehandler-pgtap-perl libxslt1.1 146s postgresql-17 postgresql-17-partman postgresql-17-pgtap postgresql-client-17 146s postgresql-client-common postgresql-common python3-psycopg2 ssl-cert 146s 0 upgraded, 12 newly installed, 0 to remove and 0 not upgraded. 146s Need to get 19.7 MB of archives. 146s After this operation, 76.1 MB of additional disk space will be used. 146s Get:1 http://ftpmaster.internal/ubuntu plucky/main ppc64el libjson-perl all 4.10000-1 [81.9 kB] 146s Get:2 http://ftpmaster.internal/ubuntu plucky/main ppc64el postgresql-client-common all 262 [36.7 kB] 146s Get:3 http://ftpmaster.internal/ubuntu plucky/main ppc64el ssl-cert all 1.1.3ubuntu1 [18.7 kB] 146s Get:4 http://ftpmaster.internal/ubuntu plucky/main ppc64el postgresql-common all 262 [162 kB] 146s Get:5 http://ftpmaster.internal/ubuntu plucky/main ppc64el libpq5 ppc64el 17.2-1 [173 kB] 147s Get:6 http://ftpmaster.internal/ubuntu plucky/main ppc64el libxslt1.1 ppc64el 1.1.39-0exp1ubuntu2 [191 kB] 147s Get:7 http://ftpmaster.internal/ubuntu plucky/main ppc64el postgresql-client-17 ppc64el 17.2-1 [1464 kB] 147s Get:8 http://ftpmaster.internal/ubuntu plucky/main ppc64el postgresql-17 ppc64el 17.2-1 [17.1 MB] 147s Get:9 http://ftpmaster.internal/ubuntu plucky/main ppc64el python3-psycopg2 ppc64el 2.9.10-1 [160 kB] 147s Get:10 http://ftpmaster.internal/ubuntu plucky/universe ppc64el postgresql-17-partman ppc64el 5.2.2-1 [230 kB] 147s Get:11 http://ftpmaster.internal/ubuntu plucky/universe ppc64el postgresql-17-pgtap all 1.3.3-3 [45.6 kB] 147s Get:12 http://ftpmaster.internal/ubuntu plucky/universe ppc64el libtap-parser-sourcehandler-pgtap-perl all 3.36-2 [35.2 kB] 147s Preconfiguring packages ... 147s Fetched 19.7 MB in 1s (18.5 MB/s) 147s Selecting previously unselected package libjson-perl. 147s (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 ... 74734 files and directories currently installed.) 147s Preparing to unpack .../00-libjson-perl_4.10000-1_all.deb ... 147s Unpacking libjson-perl (4.10000-1) ... 147s Selecting previously unselected package postgresql-client-common. 147s Preparing to unpack .../01-postgresql-client-common_262_all.deb ... 147s Unpacking postgresql-client-common (262) ... 148s Selecting previously unselected package ssl-cert. 148s Preparing to unpack .../02-ssl-cert_1.1.3ubuntu1_all.deb ... 148s Unpacking ssl-cert (1.1.3ubuntu1) ... 148s Selecting previously unselected package postgresql-common. 148s Preparing to unpack .../03-postgresql-common_262_all.deb ... 148s Adding 'diversion of /usr/bin/pg_config to /usr/bin/pg_config.libpq-dev by postgresql-common' 148s Unpacking postgresql-common (262) ... 148s Selecting previously unselected package libpq5:ppc64el. 148s Preparing to unpack .../04-libpq5_17.2-1_ppc64el.deb ... 148s Unpacking libpq5:ppc64el (17.2-1) ... 148s Selecting previously unselected package libxslt1.1:ppc64el. 148s Preparing to unpack .../05-libxslt1.1_1.1.39-0exp1ubuntu2_ppc64el.deb ... 148s Unpacking libxslt1.1:ppc64el (1.1.39-0exp1ubuntu2) ... 148s Selecting previously unselected package postgresql-client-17. 148s Preparing to unpack .../06-postgresql-client-17_17.2-1_ppc64el.deb ... 148s Unpacking postgresql-client-17 (17.2-1) ... 148s Selecting previously unselected package postgresql-17. 148s Preparing to unpack .../07-postgresql-17_17.2-1_ppc64el.deb ... 148s Unpacking postgresql-17 (17.2-1) ... 148s Selecting previously unselected package python3-psycopg2. 148s Preparing to unpack .../08-python3-psycopg2_2.9.10-1_ppc64el.deb ... 148s Unpacking python3-psycopg2 (2.9.10-1) ... 148s Selecting previously unselected package postgresql-17-partman. 148s Preparing to unpack .../09-postgresql-17-partman_5.2.2-1_ppc64el.deb ... 148s Unpacking postgresql-17-partman (5.2.2-1) ... 148s Selecting previously unselected package postgresql-17-pgtap. 148s Preparing to unpack .../10-postgresql-17-pgtap_1.3.3-3_all.deb ... 148s Unpacking postgresql-17-pgtap (1.3.3-3) ... 148s Selecting previously unselected package libtap-parser-sourcehandler-pgtap-perl. 148s Preparing to unpack .../11-libtap-parser-sourcehandler-pgtap-perl_3.36-2_all.deb ... 148s Unpacking libtap-parser-sourcehandler-pgtap-perl (3.36-2) ... 148s Setting up postgresql-client-common (262) ... 148s Setting up libtap-parser-sourcehandler-pgtap-perl (3.36-2) ... 148s Setting up libpq5:ppc64el (17.2-1) ... 148s Setting up ssl-cert (1.1.3ubuntu1) ... 149s Created symlink '/etc/systemd/system/multi-user.target.wants/ssl-cert.service' → '/usr/lib/systemd/system/ssl-cert.service'. 149s Setting up python3-psycopg2 (2.9.10-1) ... 149s Setting up libjson-perl (4.10000-1) ... 149s Setting up libxslt1.1:ppc64el (1.1.39-0exp1ubuntu2) ... 149s Setting up postgresql-client-17 (17.2-1) ... 149s 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 149s Setting up postgresql-common (262) ... 150s Creating config file /etc/postgresql-common/createcluster.conf with new version 150s Building PostgreSQL dictionaries from installed myspell/hunspell packages... 150s Removing obsolete dictionary files: 150s Created symlink '/etc/systemd/system/multi-user.target.wants/postgresql.service' → '/usr/lib/systemd/system/postgresql.service'. 151s Setting up postgresql-17 (17.2-1) ... 151s Creating new PostgreSQL cluster 17/main ... 151s /usr/lib/postgresql/17/bin/initdb -D /var/lib/postgresql/17/main --auth-local peer --auth-host scram-sha-256 --no-instructions 151s The files belonging to this database system will be owned by user "postgres". 151s This user must also own the server process. 151s 151s The database cluster will be initialized with locale "C.UTF-8". 151s The default database encoding has accordingly been set to "UTF8". 151s The default text search configuration will be set to "english". 151s 151s Data page checksums are disabled. 151s 151s fixing permissions on existing directory /var/lib/postgresql/17/main ... ok 151s creating subdirectories ... ok 151s selecting dynamic shared memory implementation ... posix 151s selecting default "max_connections" ... 100 151s selecting default "shared_buffers" ... 128MB 151s selecting default time zone ... Etc/UTC 151s creating configuration files ... ok 151s running bootstrap script ... ok 152s performing post-bootstrap initialization ... ok 152s syncing data to disk ... ok 155s Setting up postgresql-17-pgtap (1.3.3-3) ... 155s Setting up postgresql-17-partman (5.2.2-1) ... 155s Processing triggers for man-db (2.13.0-1) ... 156s Processing triggers for libc-bin (2.40-4ubuntu1) ... 157s autopkgtest [23:00:50]: test prove: [----------------------- 157s ### PostgreSQL 17 virtualenv ### 157s Creating new PostgreSQL cluster 17/regress ... 160s + psql -c 'CREATE EXTENSION pgtap' 161s CREATE EXTENSION 161s + psql -c 'CREATE EXTENSION pg_partman' 161s + pg_prove -ovf test/test-id-10.sql 161s CREATE EXTENSION 161s Duplicate specification "psql-bin|b=s" for option "b" 161s Duplicate specification "host|h=s" for option "h" 161s Duplicate specification "port|p=s" for option "p" 161s Duplicate specification "pset|P=s%" for option "P" 161s Duplicate specification "schema|s=s" for option "s" 161s Duplicate specification "version|V" for option "version" 161s Duplicate specification "version|V" for option "V" 161s Duplicate specification "help|H|?" for option "help" 161s Duplicate specification "help|H|?" for option "H" 161s Duplicate specification "help|H|?" for option "?" 161s Duplicate specification "man|m" for option "man" 161s Duplicate specification "man|m" for option "m" 161s psql:test/test-id-10.sql:208: NOTICE: Moved 11 row(s) to the target table. Removed 1 partitions. 161s psql:test/test-id-10.sql:211: NOTICE: Moved 10 row(s) to the target table. Removed 1 partitions. 161s psql:test/test-id-10.sql:215: NOTICE: Moved 9 row(s) to the target table. Removed 5 partitions. 161s test/test-id-10.sql .. 161s partman, public 161s 1..135 161s t 161s ok 1 - Check id_taptest_table_p3000000000 exists 161s ok 2 - Check id_taptest_table_p3000000010 exists 161s ok 3 - Check id_taptest_table_p3000000020 exists 161s ok 4 - Check id_taptest_table_p3000000030 exists 161s ok 5 - Check id_taptest_table_p3000000040 exists 161s ok 6 - Check id_taptest_table_default exists 161s ok 7 - Check id_taptest_table_p3000000050 doesn't exists yet 161s ok 8 - Check for primary key in id_taptest_table_p3000000000 161s ok 9 - Check for primary key in id_taptest_table_p3000000010 161s ok 10 - Check for primary key in id_taptest_table_p3000000020 161s ok 11 - Check for primary key in id_taptest_table_p3000000030 161s ok 12 - Check for primary key in id_taptest_table_p3000000040 161s ok 13 - Check for primary key in id_taptest_table_default 161s ok 14 - Check that foreign key was inherited to id_taptest_table_p3000000000 161s ok 15 - Check that foreign key was inherited to id_taptest_table_p3000000010 161s ok 16 - Check that foreign key was inherited to id_taptest_table_p3000000020 161s ok 17 - Check that foreign key was inherited to id_taptest_table_p3000000030 161s ok 18 - Check that foreign key was inherited to id_taptest_table_p3000000040 161s ok 19 - Check that foreign key was inherited to id_taptest_table_default 161s ok 20 - Check that unique index was inherited to id_taptest_table_p3000000000 161s ok 21 - Check that unique index was inherited to id_taptest_table_p3000000010 161s ok 22 - Check that unique index was inherited to id_taptest_table_p3000000020 161s ok 23 - Check that unique index was inherited to id_taptest_table_p3000000030 161s ok 24 - Check that unique index was inherited to id_taptest_table_p3000000040 161s ok 25 - Check that unique index was inherited to id_taptest_table_default 161s ok 26 - Check partman_basic privileges of id_taptest_table_p3000000000 161s ok 27 - Check partman_basic privileges of id_taptest_table_p3000000010 161s ok 28 - Check partman_basic privileges of id_taptest_table_p3000000020 161s ok 29 - Check partman_basic privileges of id_taptest_table_p3000000030 161s ok 30 - Check partman_basic privileges of id_taptest_table_p3000000040 161s ok 31 - Check partman_basic privileges of id_taptest_table_default 161s ok 32 - Check partman_revoke privileges of id_taptest_table_p3000000000 161s ok 33 - Check partman_revoke privileges of id_taptest_table_p3000000010 161s ok 34 - Check partman_revoke privileges of id_taptest_table_p3000000020 161s ok 35 - Check partman_revoke privileges of id_taptest_table_p3000000030 161s ok 36 - Check partman_revoke privileges of id_taptest_table_p3000000040 161s ok 37 - Check partman_revoke privileges of id_taptest_table_default 161s ok 38 - Check that parent table is unlogged 161s ok 39 - Check that id_taptest_table_p3000000000 is unlogged 161s ok 40 - Check that id_taptest_table_p3000000010 is unlogged 161s ok 41 - Check that id_taptest_table_p3000000020 is unlogged 161s ok 42 - Check that id_taptest_table_p3000000030 is unlogged 161s ok 43 - Check that id_taptest_table_p3000000040 is unlogged 161s ok 44 - Check that id_taptest_table_default is unlogged 161s ok 45 - Check that default table has no data 161s ok 46 - Check count from parent table 161s ok 47 - Check count from id_taptest_table_p3000000000 161s ok 48 - Check that parent table has had no data inserted to it 161s ok 49 - Check count from id_taptest_table_p3000000010 161s ok 50 - Check count from id_taptest_table_p3000000020 161s ok 51 - Check id_taptest_table_p3000000050 exists 161s ok 52 - Check that id_taptest_table_p3000000050 is unlogged 161s ok 53 - Check id_taptest_table_p3000000060 exists yet 161s ok 54 - Check that id_taptest_table_p3000000060 is unlogged 161s ok 55 - Check id_taptest_table_p3000000070 doesn't exists yet 161s ok 56 - Check for primary key in id_taptest_table_p3000000050 161s ok 57 - Check that foreign key was inherited to id_taptest_table_p3000000050 161s ok 58 - Check partman_basic privileges of id_taptest_table_p3000000000 161s ok 59 - Check partman_basic privileges of id_taptest_table_p3000000010 161s ok 60 - Check partman_basic privileges of id_taptest_table_p3000000020 161s ok 61 - Check partman_basic privileges of id_taptest_table_p3000000030 161s ok 62 - Check partman_basic privileges of id_taptest_table_p3000000040 161s ok 63 - Check partman_basic privileges of id_taptest_table_p3000000050 161s ok 64 - Check partman_revoke privileges of id_taptest_table_p3000000050 161s ok 65 - Check partman_basic privileges of id_taptest_table_p3000000060 161s ok 66 - Check partman_revoke privileges of id_taptest_table_p3000000060 161s ok 67 - Check that parent table has had no data inserted to it 161s ok 68 - Check count from id_taptest_table 161s ok 69 - Check count from id_taptest_table_p3000000020 161s ok 70 - Check count from id_taptest_table_p3000000030 161s ok 71 - Check id_taptest_table_p3000000070 exists 161s ok 72 - Check that id_taptest_table_p3000000070 is unlogged 161s ok 73 - Check id_taptest_table_p3000000080 doesn't exists yet 161s ok 74 - Check for primary key in id_taptest_table_p3000000060 161s ok 75 - Check for primary key in id_taptest_table_p3000000070 161s ok 76 - Check that foreign key was inherited to id_taptest_table_p3000000060 161s ok 77 - Check that foreign key was inherited to id_taptest_table_p3000000070 161s ok 78 - Check partman_basic privileges of id_taptest_table_p3000000000 161s ok 79 - Check partman_basic privileges of id_taptest_table_p3000000010 161s ok 80 - Check partman_basic privileges of id_taptest_table_p3000000020 161s ok 81 - Check partman_basic privileges of id_taptest_table_p3000000030 161s ok 82 - Check partman_basic privileges of id_taptest_table_p3000000040 161s ok 83 - Check partman_basic privileges of id_taptest_table_default 161s ok 84 - Check partman_basic privileges of id_taptest_table_p3000000050 161s ok 85 - Check partman_revoke privileges of id_taptest_table_p3000000050 161s ok 86 - Check partman_basic privileges of id_taptest_table_p3000000060 161s ok 87 - Check partman_revoke privileges of id_taptest_table_p3000000060 161s ok 88 - Check partman_basic privileges of id_taptest_table_p3000000070 161s ok 89 - Check that ownership change worked for id_taptest_table_p3000000070 161s ok 90 - Check partman_revoke has no privileges on id_taptest_table_p3000000070 161s ok 91 - Check that data outside child scope goes to default 161s ok 92 - Check partman_basic privileges of id_taptest_table_p3000000000 161s ok 93 - Check partman_basic privileges of id_taptest_table_p3000000010 161s ok 94 - Check partman_basic privileges of id_taptest_table_p3000000020 161s ok 95 - Check partman_basic privileges of id_taptest_table_p3000000030 161s ok 96 - Check partman_basic privileges of id_taptest_table_p3000000040 161s ok 97 - Check partman_basic privileges of id_taptest_table_p3000000050 161s ok 98 - Check partman_basic privileges of id_taptest_table_p3000000060 161s ok 99 - Check partman_basic privileges of id_taptest_table_p3000000070 161s ok 100 - Check partman_basic privileges of id_taptest_table_default 161s ok 101 - Check partman_revoke has no privileges on id_taptest_table_p3000000000 161s ok 102 - Check partman_revoke has no privileges on id_taptest_table_p3000000010 161s ok 103 - Check partman_revoke has no privileges on id_taptest_table_p3000000020 161s ok 104 - Check partman_revoke has no privileges on id_taptest_table_p3000000030 161s ok 105 - Check partman_revoke has no privileges on id_taptest_table_p3000000040 161s ok 106 - Check partman_revoke has no privileges on id_taptest_table_p3000000050 161s ok 107 - Check partman_revoke has no privileges on id_taptest_table_p3000000060 161s ok 108 - Check partman_revoke has no privileges on id_taptest_table_p3000000070 161s ok 109 - Check partman_revoke has no privileges on id_taptest_table_default 161s ok 110 - Check that ownership change worked for id_taptest_table_p3000000000 161s ok 111 - Check that ownership change worked for id_taptest_table_p3000000010 161s ok 112 - Check that ownership change worked for id_taptest_table_p3000000020 161s ok 113 - Check that ownership change worked for id_taptest_table_p3000000030 161s ok 114 - Check that ownership change worked for id_taptest_table_p3000000040 161s ok 115 - Check that ownership change worked for id_taptest_table_p3000000050 161s ok 116 - Check that ownership change worked for id_taptest_table_p3000000060 161s ok 117 - Check that ownership change worked for id_taptest_table_p3000000070 161s ok 118 - Check that ownership change worked for id_taptest_table_default 161s 1 161s ok 119 - Check id_taptest_table_p3000000000 doesn't exists anymore 161s 1 161s ok 120 - Check id_taptest_table_p3000000010 doesn't exists anymore 161s ok 121 - Check id_taptest_table_p3000000010 got moved to new schema 161s (1,11) 161s ok 122 - Check id_taptest_table_default does not exist 161s (1,10) 161s ok 123 - Check id_taptest_table_p3000000020 does not exist 161s (5,9) 161s ok 124 - Check count from undo table after undo 161s ok 125 - Check id_taptest_table_p3000000030 still exists 161s ok 126 - Check child table had its data removed id_taptest_table_p3000000030 161s ok 127 - Check id_taptest_table_p3000000040 still exists 161s ok 128 - Check child table had its data removed id_taptest_table_p3000000040 161s ok 129 - Check id_taptest_table_p3000000050 still exists 161s ok 130 - Check child table had its data removed id_taptest_table_p3000000050 161s ok 131 - Check id_taptest_table_p3000000060 still exists 161s ok 132 - Check child table had its data removed id_taptest_table_p3000000060 161s ok 133 - Check id_taptest_table_p3000000070 still exists 161s ok 134 - Check child table had its data removed id_taptest_table_p3000000070 161s ok 135 - Check that template table was dropped 161s ok 161s All tests successful. 161s Files=1, Tests=135, 0 wallclock secs ( 0.03 usr 0.01 sys + 0.04 cusr 0.01 csys = 0.09 CPU) 161s Result: PASS 161s + pg_prove -ovf test/test_bgw/test-time-daily-bgw.sql 161s Duplicate specification "psql-bin|b=s" for option "b" 161s Duplicate specification "host|h=s" for option "h" 161s Duplicate specification "port|p=s" for option "p" 161s Duplicate specification "pset|P=s%" for option "P" 161s Duplicate specification "schema|s=s" for option "s" 161s Duplicate specification "version|V" for option "version" 161s Duplicate specification "version|V" for option "V" 161s Duplicate specification "help|H|?" for option "help" 161s Duplicate specification "help|H|?" for option "H" 161s Duplicate specification "help|H|?" for option "?" 161s Duplicate specification "man|m" for option "man" 161s Duplicate specification "man|m" for option "m" 222s psql:test/test_bgw/test-time-daily-bgw.sql:253: NOTICE: Moved 36 row(s) to the target table. Removed 12 partitions. 222s psql:test/test_bgw/test-time-daily-bgw.sql:296: NOTICE: drop cascades to 14 other objects 222s DETAIL: drop cascades to table partman_test.time_taptest_table 222s drop cascades to table partman_test.undo_taptest 222s drop cascades to table partman_test.time_taptest_table_p20250101 222s drop cascades to table partman_test.time_taptest_table_p20250102 222s drop cascades to table partman_test.time_taptest_table_p20250103 222s drop cascades to table partman_test.time_taptest_table_p20250104 222s drop cascades to table partman_test.time_taptest_table_p20250105 222s drop cascades to table partman_test.time_taptest_table_p20250106 222s drop cascades to table partman_test.time_taptest_table_p20250107 222s drop cascades to table partman_test.time_taptest_table_default 222s drop cascades to table partman_test.time_taptest_table_p20250108 222s drop cascades to table partman_test.time_taptest_table_p20250109 222s drop cascades to table partman_test.time_taptest_table_p20250110 222s drop cascades to table partman_test.time_taptest_table_p20250111 222s psql:test/test_bgw/test-time-daily-bgw.sql:297: NOTICE: drop cascades to table partman_retention_test.time_taptest_table_p20241231 222s test/test_bgw/test-time-daily-bgw.sql .. 222s partman, public 222s 1..105 222s t 222s ok 1 - Check time_taptest_table_p20250103 exists 222s ok 2 - Check time_taptest_table_p20250104 exists 222s ok 3 - Check time_taptest_table_p20250105 exists 222s ok 4 - Check time_taptest_table_p20250106 exists 222s ok 5 - Check time_taptest_table_p20250107 exists 222s ok 6 - Check time_taptest_table_p20250108 exists 222s ok 7 - Check for primary key in time_taptest_table_p20250103 222s ok 8 - Check for primary key in time_taptest_table_p20250104 222s ok 9 - Check for primary key in time_taptest_table_p20250105 222s ok 10 - Check for primary key in time_taptest_table_p20250106 222s ok 11 - Check for primary key in time_taptest_table_p20250107 222s ok 12 - Check partman_basic privileges of time_taptest_table_p20250103 222s ok 13 - Check partman_basic privileges of time_taptest_table_p20250104 222s ok 14 - Check partman_basic privileges of time_taptest_table_p20250105 222s ok 15 - Check partman_basic privileges of time_taptest_table_p20250106 222s ok 16 - Check partman_basic privileges of time_taptest_table_p20250107 222s ok 17 - Check partman_revoke privileges of time_taptest_table_p20250103 222s ok 18 - Check partman_revoke privileges of time_taptest_table_p20250104 222s ok 19 - Check partman_revoke privileges of time_taptest_table_p20250105 222s ok 20 - Check partman_revoke privileges of time_taptest_table_p20250106 222s ok 21 - Check partman_revoke privileges of time_taptest_table_p20250107 222s ok 22 - Check count from parent table 222s ok 23 - Check count from time_taptest_table_p20250103 222s ok 24 - Check count from time_taptest_table 222s ok 25 - Check count from time_taptest_table_p20250104 222s ok 26 - Check count from time_taptest_table_p20250105 222s ok 27 - Waiting 20 seconds for background worker to run... 222s ok 28 - Check time_taptest_table_p20250108 exists 222s ok 29 - Check time_taptest_table_p20250109 exists 222s ok 30 - Check time_taptest_table_p20250110 exists 222s ok 31 - Check time_taptest_table_p20250111 exists 222s ok 32 - Check for primary key in time_taptest_table_p20250108 222s ok 33 - Check for primary key in time_taptest_table_p20250109 222s ok 34 - Check for primary key in time_taptest_table_p20250110 222s ok 35 - Check partman_basic privileges of time_taptest_table_p20250108 222s ok 36 - Check partman_basic privileges of time_taptest_table_p20250109 222s ok 37 - Check partman_basic privileges of time_taptest_table_p20250110 222s ok 38 - Check partman_revoke privileges of time_taptest_table_p20250108 222s ok 39 - Check partman_revoke privileges of time_taptest_table_p20250109 222s ok 40 - Check partman_revoke privileges of time_taptest_table_p20250110 222s ok 41 - Waiting 20 seconds for background worker to run... 222s ok 42 - Check time_taptest_table_p20250111 exists 222s ok 43 - Check time_taptest_table_p20250112 exists 222s ok 44 - Check for primary key in time_taptest_table_p20250111 222s ok 45 - Check partman_basic privileges of time_taptest_table_p20250111 222s ok 46 - Check partman_revoke privileges of time_taptest_table_p20250111 222s ok 47 - Check that ownership change worked for time_taptest_table_p20250111 222s ok 48 - Check that data outside scope goes to default 222s ok 49 - Check partman_basic privileges of time_taptest_table_p20250103 222s ok 50 - Check partman_basic privileges of time_taptest_table_p20250104 222s ok 51 - Check partman_basic privileges of time_taptest_table_p20250105 222s ok 52 - Check partman_basic privileges of time_taptest_table_p20250106 222s ok 53 - Check partman_basic privileges of time_taptest_table_p20250107 222s ok 54 - Check partman_basic privileges of time_taptest_table_p20250108 222s ok 55 - Check partman_basic privileges of time_taptest_table_p20250109 222s ok 56 - Check partman_basic privileges of time_taptest_table_p20250110 222s ok 57 - Check partman_basic privileges of time_taptest_table_p20250111 222s ok 58 - Check partman_revoke privileges of time_taptest_table_p20250103 222s ok 59 - Check partman_revoke privileges of time_taptest_table_p20250104 222s ok 60 - Check partman_revoke privileges of time_taptest_table_p20250105 222s ok 61 - Check partman_revoke privileges of time_taptest_table_p20250106 222s ok 62 - Check partman_revoke privileges of time_taptest_table_p20250107 222s ok 63 - Check partman_revoke privileges of time_taptest_table_p20250108 222s ok 64 - Check partman_revoke privileges of time_taptest_table_p20250109 222s ok 65 - Check partman_revoke privileges of time_taptest_table_p20250110 222s ok 66 - Check partman_revoke privileges of time_taptest_table_p20250111 222s ok 67 - Check that ownership change worked for time_taptest_table_p20250103 222s ok 68 - Check that ownership change worked for time_taptest_table_p20250104 222s ok 69 - Check that ownership change worked for time_taptest_table_p20250105 222s ok 70 - Check that ownership change worked for time_taptest_table_p20250106 222s ok 71 - Check that ownership change worked for time_taptest_table_p20250107 222s ok 72 - Check that ownership change worked for time_taptest_table_p20250108 222s ok 73 - Check that ownership change worked for time_taptest_table_p20250109 222s ok 74 - Check that ownership change worked for time_taptest_table_p20250110 222s ok 75 - Check that ownership change worked for time_taptest_table_p20250111 222s 1 222s ok 76 - Check time_taptest_table_p20241230 does not exist 222s ok 77 - Waiting 20 seconds for background worker to run... 222s ok 78 - Check time_taptest_table_p20241231 does not exist 222s ok 79 - Check time_taptest_table_p20241231 got moved to new schema 222s (12,36) 222s ok 80 - Check time_taptest_table_p20250103 exists 222s ok 81 - Check time_taptest_table_p20250104 still exists 222s ok 82 - Check time_taptest_table_p20250102 is empty 222s ok 83 - Check time_taptest_table_p20250102 is empty 222s ok 84 - Check time_taptest_table_p20250101 still exists 222s ok 85 - Check time_taptest_table_p20250101 is empty 222s ok 86 - Check time_taptest_table_p20250104 is empty 222s ok 87 - Check time_taptest_table_p20250105 still exists 222s ok 88 - Check time_taptest_table_p20250105 is empty 222s ok 89 - Check time_taptest_table_p20250106 still exists 222s ok 90 - Check time_taptest_table_p20250106 is empty 222s ok 91 - Check time_taptest_table_p20250107 still exists 222s ok 92 - Check time_taptest_table_p20250107 is empty 222s ok 93 - Check time_taptest_table_p20250108 still exists 222s ok 94 - Check time_taptest_table_p20250108 is empty 222s ok 95 - Check time_taptest_table_p20250109 still exists 222s ok 96 - Check time_taptest_table_p20250109 is empty 222s ok 97 - Check time_taptest_table_p20250110 still exists 222s ok 98 - Check time_taptest_table_p20250110 is empty 222s ok 99 - Check time_taptest_table_p20250111 still exists 222s ok 100 - Check time_taptest_table_p20250111 is empty 222s ok 101 - Ensure partman_test schema has been dropped 222s ok 102 - Ensure partman_retention_test schema has been dropped 222s ok 103 - Ensure partman_basic role has been dropped 222s ok 104 - Ensure partman_revoke role has been dropped 222s ok 105 - Ensure partman_owner role has been dropped 222s ok 222s All tests successful. 222s Files=1, Tests=105, 61 wallclock secs ( 0.02 usr 0.00 sys + 0.04 cusr 0.01 csys = 0.07 CPU) 222s Result: PASS 222s Dropping cluster 17/regress ... 222s ### End 17 virtualenv ### 222s autopkgtest [23:01:55]: test prove: -----------------------] 223s prove PASS 223s autopkgtest [23:01:56]: test prove: - - - - - - - - - - results - - - - - - - - - - 223s autopkgtest [23:01:56]: test scripts: preparing testbed 324s autopkgtest [23:03:37]: testbed dpkg architecture: ppc64el 325s autopkgtest [23:03:38]: testbed apt version: 2.9.18 325s autopkgtest [23:03:38]: @@@@@@@@@@@@@@@@@@@@ test bed setup 325s autopkgtest [23:03:38]: testbed release detected to be: plucky 326s autopkgtest [23:03:39]: updating testbed package index (apt update) 326s Get:1 http://ftpmaster.internal/ubuntu plucky-proposed InRelease [73.9 kB] 326s Hit:2 http://ftpmaster.internal/ubuntu plucky InRelease 326s Hit:3 http://ftpmaster.internal/ubuntu plucky-updates InRelease 327s Hit:4 http://ftpmaster.internal/ubuntu plucky-security InRelease 327s Get:5 http://ftpmaster.internal/ubuntu plucky-proposed/universe Sources [804 kB] 327s Get:6 http://ftpmaster.internal/ubuntu plucky-proposed/multiverse Sources [12.3 kB] 327s Get:7 http://ftpmaster.internal/ubuntu plucky-proposed/restricted Sources [9708 B] 327s Get:8 http://ftpmaster.internal/ubuntu plucky-proposed/main Sources [78.5 kB] 327s Get:9 http://ftpmaster.internal/ubuntu plucky-proposed/main ppc64el Packages [87.2 kB] 327s Get:10 http://ftpmaster.internal/ubuntu plucky-proposed/restricted ppc64el Packages [756 B] 327s Get:11 http://ftpmaster.internal/ubuntu plucky-proposed/universe ppc64el Packages [693 kB] 327s Get:12 http://ftpmaster.internal/ubuntu plucky-proposed/multiverse ppc64el Packages [4084 B] 327s Fetched 1763 kB in 1s (1741 kB/s) 328s Reading package lists... 328s Reading package lists... 329s Building dependency tree... 329s Reading state information... 329s Calculating upgrade... 329s The following packages will be upgraded: 329s binutils binutils-common binutils-powerpc64le-linux-gnu libbinutils 329s libctf-nobfd0 libctf0 libsframe1 329s 7 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 329s Need to get 3752 kB of archives. 329s After this operation, 0 B of additional disk space will be used. 329s Get:1 http://ftpmaster.internal/ubuntu plucky/main ppc64el libctf0 ppc64el 2.43.50.20241230-1ubuntu1 [114 kB] 329s Get:2 http://ftpmaster.internal/ubuntu plucky/main ppc64el libctf-nobfd0 ppc64el 2.43.50.20241230-1ubuntu1 [117 kB] 329s Get:3 http://ftpmaster.internal/ubuntu plucky/main ppc64el binutils-powerpc64le-linux-gnu ppc64el 2.43.50.20241230-1ubuntu1 [2569 kB] 330s Get:4 http://ftpmaster.internal/ubuntu plucky/main ppc64el libbinutils ppc64el 2.43.50.20241230-1ubuntu1 [711 kB] 330s Get:5 http://ftpmaster.internal/ubuntu plucky/main ppc64el binutils ppc64el 2.43.50.20241230-1ubuntu1 [3096 B] 330s Get:6 http://ftpmaster.internal/ubuntu plucky/main ppc64el binutils-common ppc64el 2.43.50.20241230-1ubuntu1 [222 kB] 330s Get:7 http://ftpmaster.internal/ubuntu plucky/main ppc64el libsframe1 ppc64el 2.43.50.20241230-1ubuntu1 [15.9 kB] 330s Fetched 3752 kB in 1s (4424 kB/s) 330s (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 ... 74025 files and directories currently installed.) 330s Preparing to unpack .../0-libctf0_2.43.50.20241230-1ubuntu1_ppc64el.deb ... 330s Unpacking libctf0:ppc64el (2.43.50.20241230-1ubuntu1) over (2.43.50.20241221-1ubuntu1) ... 330s Preparing to unpack .../1-libctf-nobfd0_2.43.50.20241230-1ubuntu1_ppc64el.deb ... 330s Unpacking libctf-nobfd0:ppc64el (2.43.50.20241230-1ubuntu1) over (2.43.50.20241221-1ubuntu1) ... 330s Preparing to unpack .../2-binutils-powerpc64le-linux-gnu_2.43.50.20241230-1ubuntu1_ppc64el.deb ... 330s Unpacking binutils-powerpc64le-linux-gnu (2.43.50.20241230-1ubuntu1) over (2.43.50.20241221-1ubuntu1) ... 331s Preparing to unpack .../3-libbinutils_2.43.50.20241230-1ubuntu1_ppc64el.deb ... 331s Unpacking libbinutils:ppc64el (2.43.50.20241230-1ubuntu1) over (2.43.50.20241221-1ubuntu1) ... 331s Preparing to unpack .../4-binutils_2.43.50.20241230-1ubuntu1_ppc64el.deb ... 331s Unpacking binutils (2.43.50.20241230-1ubuntu1) over (2.43.50.20241221-1ubuntu1) ... 331s Preparing to unpack .../5-binutils-common_2.43.50.20241230-1ubuntu1_ppc64el.deb ... 331s Unpacking binutils-common:ppc64el (2.43.50.20241230-1ubuntu1) over (2.43.50.20241221-1ubuntu1) ... 331s Preparing to unpack .../6-libsframe1_2.43.50.20241230-1ubuntu1_ppc64el.deb ... 331s Unpacking libsframe1:ppc64el (2.43.50.20241230-1ubuntu1) over (2.43.50.20241221-1ubuntu1) ... 331s Setting up binutils-common:ppc64el (2.43.50.20241230-1ubuntu1) ... 331s Setting up libctf-nobfd0:ppc64el (2.43.50.20241230-1ubuntu1) ... 331s Setting up libsframe1:ppc64el (2.43.50.20241230-1ubuntu1) ... 331s Setting up libbinutils:ppc64el (2.43.50.20241230-1ubuntu1) ... 331s Setting up libctf0:ppc64el (2.43.50.20241230-1ubuntu1) ... 331s Setting up binutils-powerpc64le-linux-gnu (2.43.50.20241230-1ubuntu1) ... 331s Setting up binutils (2.43.50.20241230-1ubuntu1) ... 331s Processing triggers for libc-bin (2.40-4ubuntu1) ... 331s Processing triggers for man-db (2.13.0-1) ... 332s Reading package lists... 332s Building dependency tree... 332s Reading state information... 332s 0 upgraded, 0 newly installed, 0 to remove and 3 not upgraded. 332s autopkgtest [23:03:45]: upgrading testbed (apt dist-upgrade and autopurge) 332s Reading package lists... 332s Building dependency tree... 332s Reading state information... 333s Calculating upgrade...Starting pkgProblemResolver with broken count: 0 333s Starting 2 pkgProblemResolver with broken count: 0 333s Done 333s Entering ResolveByKeep 333s 333s The following packages were automatically installed and are no longer required: 333s python3.12 python3.12-minimal 333s Use 'sudo apt autoremove' to remove them. 333s The following NEW packages will be installed: 333s libpython3.13-minimal libpython3.13-stdlib python3.13 python3.13-minimal 333s The following packages will be upgraded: 333s libpython3-stdlib python3 python3-minimal 333s 3 upgraded, 4 newly installed, 0 to remove and 0 not upgraded. 333s Need to get 6300 kB of archives. 333s After this operation, 26.2 MB of additional disk space will be used. 333s Get:1 http://ftpmaster.internal/ubuntu plucky/main ppc64el libpython3.13-minimal ppc64el 3.13.1-2 [883 kB] 334s Get:2 http://ftpmaster.internal/ubuntu plucky/main ppc64el python3.13-minimal ppc64el 3.13.1-2 [2496 kB] 334s Get:3 http://ftpmaster.internal/ubuntu plucky-proposed/main ppc64el python3-minimal ppc64el 3.13.1-1~exp2 [27.6 kB] 334s Get:4 http://ftpmaster.internal/ubuntu plucky-proposed/main ppc64el python3 ppc64el 3.13.1-1~exp2 [24.0 kB] 334s Get:5 http://ftpmaster.internal/ubuntu plucky/main ppc64el libpython3.13-stdlib ppc64el 3.13.1-2 [2131 kB] 334s Get:6 http://ftpmaster.internal/ubuntu plucky/main ppc64el python3.13 ppc64el 3.13.1-2 [729 kB] 334s Get:7 http://ftpmaster.internal/ubuntu plucky-proposed/main ppc64el libpython3-stdlib ppc64el 3.13.1-1~exp2 [10.2 kB] 335s Fetched 6300 kB in 1s (6288 kB/s) 335s Selecting previously unselected package libpython3.13-minimal:ppc64el. 335s (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 ... 74025 files and directories currently installed.) 335s Preparing to unpack .../libpython3.13-minimal_3.13.1-2_ppc64el.deb ... 335s Unpacking libpython3.13-minimal:ppc64el (3.13.1-2) ... 335s Selecting previously unselected package python3.13-minimal. 335s Preparing to unpack .../python3.13-minimal_3.13.1-2_ppc64el.deb ... 335s Unpacking python3.13-minimal (3.13.1-2) ... 335s Setting up libpython3.13-minimal:ppc64el (3.13.1-2) ... 335s Setting up python3.13-minimal (3.13.1-2) ... 336s (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 ... 74345 files and directories currently installed.) 336s Preparing to unpack .../python3-minimal_3.13.1-1~exp2_ppc64el.deb ... 336s Unpacking python3-minimal (3.13.1-1~exp2) over (3.12.8-1) ... 336s Setting up python3-minimal (3.13.1-1~exp2) ... 336s (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 ... 74345 files and directories currently installed.) 336s Preparing to unpack .../python3_3.13.1-1~exp2_ppc64el.deb ... 336s Unpacking python3 (3.13.1-1~exp2) over (3.12.8-1) ... 336s Selecting previously unselected package libpython3.13-stdlib:ppc64el. 336s Preparing to unpack .../libpython3.13-stdlib_3.13.1-2_ppc64el.deb ... 336s Unpacking libpython3.13-stdlib:ppc64el (3.13.1-2) ... 336s Selecting previously unselected package python3.13. 336s Preparing to unpack .../python3.13_3.13.1-2_ppc64el.deb ... 336s Unpacking python3.13 (3.13.1-2) ... 336s Preparing to unpack .../libpython3-stdlib_3.13.1-1~exp2_ppc64el.deb ... 336s Unpacking libpython3-stdlib:ppc64el (3.13.1-1~exp2) over (3.12.8-1) ... 336s Setting up libpython3.13-stdlib:ppc64el (3.13.1-2) ... 336s Setting up libpython3-stdlib:ppc64el (3.13.1-1~exp2) ... 336s Setting up python3.13 (3.13.1-2) ... 337s Setting up python3 (3.13.1-1~exp2) ... 337s /usr/bin/py3clean:101: DeprecationWarning: glob.glob1 is deprecated and will be removed in Python 3.15. Use glob.glob and pass a directory to its root_dir argument instead. 337s for fn in glob1(directory, "%s.*" % fname): 337s Processing triggers for man-db (2.13.0-1) ... 338s Processing triggers for systemd (257-2ubuntu1) ... 338s Reading package lists... 338s Building dependency tree... 338s Reading state information... 338s Starting pkgProblemResolver with broken count: 0 339s Starting 2 pkgProblemResolver with broken count: 0 339s Done 339s The following packages will be REMOVED: 339s python3.12* python3.12-minimal* 339s 0 upgraded, 0 newly installed, 2 to remove and 0 not upgraded. 339s After this operation, 9889 kB disk space will be freed. 339s (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 ... 74762 files and directories currently installed.) 339s Removing python3.12 (3.12.8-3) ... 339s Removing python3.12-minimal (3.12.8-3) ... 339s /usr/bin/py3clean:125: DeprecationWarning: glob.glob1 is deprecated and will be removed in Python 3.15. Use glob.glob and pass a directory to its root_dir argument instead. 339s for fn in glob1(directory, "%s.%s.py[co]" % (fname, magic_tag)): 340s Processing triggers for man-db (2.13.0-1) ... 340s Processing triggers for systemd (257-2ubuntu1) ... 340s (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 ... 74734 files and directories currently installed.) 340s Purging configuration files for python3.12-minimal (3.12.8-3) ... 343s Reading package lists... 343s Building dependency tree... 343s Reading state information... 343s Starting pkgProblemResolver with broken count: 0 343s Starting 2 pkgProblemResolver with broken count: 0 343s Done 343s The following NEW packages will be installed: 343s libjson-perl libpq5 libxslt1.1 postgresql-17 postgresql-17-partman 343s postgresql-client-17 postgresql-client-common postgresql-common 343s python3-psycopg2 ssl-cert 344s 0 upgraded, 10 newly installed, 0 to remove and 0 not upgraded. 344s Need to get 19.6 MB of archives. 344s After this operation, 74.2 MB of additional disk space will be used. 344s Get:1 http://ftpmaster.internal/ubuntu plucky/main ppc64el libjson-perl all 4.10000-1 [81.9 kB] 344s Get:2 http://ftpmaster.internal/ubuntu plucky/main ppc64el postgresql-client-common all 262 [36.7 kB] 344s Get:3 http://ftpmaster.internal/ubuntu plucky/main ppc64el ssl-cert all 1.1.3ubuntu1 [18.7 kB] 344s Get:4 http://ftpmaster.internal/ubuntu plucky/main ppc64el postgresql-common all 262 [162 kB] 344s Get:5 http://ftpmaster.internal/ubuntu plucky/main ppc64el libpq5 ppc64el 17.2-1 [173 kB] 344s Get:6 http://ftpmaster.internal/ubuntu plucky/main ppc64el libxslt1.1 ppc64el 1.1.39-0exp1ubuntu2 [191 kB] 344s Get:7 http://ftpmaster.internal/ubuntu plucky/main ppc64el postgresql-client-17 ppc64el 17.2-1 [1464 kB] 344s Get:8 http://ftpmaster.internal/ubuntu plucky/main ppc64el postgresql-17 ppc64el 17.2-1 [17.1 MB] 345s Get:9 http://ftpmaster.internal/ubuntu plucky/main ppc64el python3-psycopg2 ppc64el 2.9.10-1 [160 kB] 345s Get:10 http://ftpmaster.internal/ubuntu plucky/universe ppc64el postgresql-17-partman ppc64el 5.2.2-1 [230 kB] 345s Preconfiguring packages ... 346s Fetched 19.6 MB in 2s (10.9 MB/s) 346s Selecting previously unselected package libjson-perl. 346s (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 ... 74734 files and directories currently installed.) 346s Preparing to unpack .../0-libjson-perl_4.10000-1_all.deb ... 346s Unpacking libjson-perl (4.10000-1) ... 346s Selecting previously unselected package postgresql-client-common. 346s Preparing to unpack .../1-postgresql-client-common_262_all.deb ... 346s Unpacking postgresql-client-common (262) ... 346s Selecting previously unselected package ssl-cert. 346s Preparing to unpack .../2-ssl-cert_1.1.3ubuntu1_all.deb ... 346s Unpacking ssl-cert (1.1.3ubuntu1) ... 346s Selecting previously unselected package postgresql-common. 346s Preparing to unpack .../3-postgresql-common_262_all.deb ... 346s Adding 'diversion of /usr/bin/pg_config to /usr/bin/pg_config.libpq-dev by postgresql-common' 346s Unpacking postgresql-common (262) ... 346s Selecting previously unselected package libpq5:ppc64el. 346s Preparing to unpack .../4-libpq5_17.2-1_ppc64el.deb ... 346s Unpacking libpq5:ppc64el (17.2-1) ... 346s Selecting previously unselected package libxslt1.1:ppc64el. 346s Preparing to unpack .../5-libxslt1.1_1.1.39-0exp1ubuntu2_ppc64el.deb ... 346s Unpacking libxslt1.1:ppc64el (1.1.39-0exp1ubuntu2) ... 346s Selecting previously unselected package postgresql-client-17. 346s Preparing to unpack .../6-postgresql-client-17_17.2-1_ppc64el.deb ... 346s Unpacking postgresql-client-17 (17.2-1) ... 346s Selecting previously unselected package postgresql-17. 346s Preparing to unpack .../7-postgresql-17_17.2-1_ppc64el.deb ... 346s Unpacking postgresql-17 (17.2-1) ... 346s Selecting previously unselected package python3-psycopg2. 346s Preparing to unpack .../8-python3-psycopg2_2.9.10-1_ppc64el.deb ... 346s Unpacking python3-psycopg2 (2.9.10-1) ... 346s Selecting previously unselected package postgresql-17-partman. 346s Preparing to unpack .../9-postgresql-17-partman_5.2.2-1_ppc64el.deb ... 346s Unpacking postgresql-17-partman (5.2.2-1) ... 346s Setting up postgresql-client-common (262) ... 346s Setting up libpq5:ppc64el (17.2-1) ... 346s Setting up ssl-cert (1.1.3ubuntu1) ... 347s Created symlink '/etc/systemd/system/multi-user.target.wants/ssl-cert.service' → '/usr/lib/systemd/system/ssl-cert.service'. 347s Setting up python3-psycopg2 (2.9.10-1) ... 347s Setting up libjson-perl (4.10000-1) ... 347s Setting up libxslt1.1:ppc64el (1.1.39-0exp1ubuntu2) ... 347s Setting up postgresql-client-17 (17.2-1) ... 347s 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 347s Setting up postgresql-common (262) ... 348s Creating config file /etc/postgresql-common/createcluster.conf with new version 348s Building PostgreSQL dictionaries from installed myspell/hunspell packages... 348s Removing obsolete dictionary files: 349s Created symlink '/etc/systemd/system/multi-user.target.wants/postgresql.service' → '/usr/lib/systemd/system/postgresql.service'. 349s Setting up postgresql-17 (17.2-1) ... 349s Creating new PostgreSQL cluster 17/main ... 349s /usr/lib/postgresql/17/bin/initdb -D /var/lib/postgresql/17/main --auth-local peer --auth-host scram-sha-256 --no-instructions 349s The files belonging to this database system will be owned by user "postgres". 349s This user must also own the server process. 349s 349s The database cluster will be initialized with locale "C.UTF-8". 349s The default database encoding has accordingly been set to "UTF8". 349s The default text search configuration will be set to "english". 349s 349s Data page checksums are disabled. 349s 349s fixing permissions on existing directory /var/lib/postgresql/17/main ... ok 349s creating subdirectories ... ok 349s selecting dynamic shared memory implementation ... posix 349s selecting default "max_connections" ... 100 349s selecting default "shared_buffers" ... 128MB 349s selecting default time zone ... Etc/UTC 349s creating configuration files ... ok 349s running bootstrap script ... ok 350s performing post-bootstrap initialization ... ok 350s syncing data to disk ... ok 353s Setting up postgresql-17-partman (5.2.2-1) ... 353s Processing triggers for man-db (2.13.0-1) ... 355s Processing triggers for libc-bin (2.40-4ubuntu1) ... 357s autopkgtest [23:04:10]: test scripts: [----------------------- 357s + /usr/lib/postgresql/17/bin/check_unique_constraint.py --help 357s usage: check_unique_constraint.py [-h] [-p PARENT] [-l COLUMN_LIST] 357s [-c CONNECTION] [-t TEMP] [--psql PSQL] 357s [--simple] [--index_scan] [-q] [--version] 357s 357s This script is used to check that all rows in a partition set are unique for 357s the given columns. Since unique constraints are not applied across partition 357s sets, this cannot be enforced within the database. This script can be used as 357s a monitor to ensure uniquness. If any unique violations are found, the values, 357s along with a count of each, are output. 357s 357s options: 357s -h, --help show this help message and exit 357s -p, --parent PARENT Parent table of the partition set to be checked 357s -l, --column_list COLUMN_LIST 357s Comma separated list of columns that make up the 357s unique constraint to be checked 357s -c, --connection CONNECTION 357s Connection string for use by psycopg. Defaults to 357s "host=" (local socket). 357s -t, --temp TEMP Path to a writable folder that can be used for temp 357s working files. Defaults system temp folder. 357s --psql PSQL Full path to psql binary if not in current PATH 357s --simple Output a single integer value with the total duplicate 357s count. Use this for monitoring software that requires 357s a simple value to be checked for. 357s --index_scan By default index scans are disabled to force the 357s script to check the actual table data with sequential 357s scans. Set this option if you want the script to allow 357s index scans to be used (does not guarentee that they 357s will be used). 357s -q, --quiet Suppress all output unless there is a constraint 357s violation found. 357s --version Print out the minimum version of pg_partman this 357s script is meant to work with. The version of 357s pg_partman installed may be greater than this. 357s + /usr/lib/postgresql/17/bin/dump_partition.py --help 357s + /usr/lib/postgresql/17/bin/vacuum_maintenance.py --help 357s usage: dump_partition.py [-h] [-n SCHEMA] [-c CONNECTION] [-o OUTPUT] 357s [-d DUMP_DATABASE] [--dump_host DUMP_HOST] 357s [--dump_username DUMP_USERNAME] 357s [--dump_port DUMP_PORT] [--pg_dump_path PG_DUMP_PATH] 357s [--Fp] [--nohashfile] [--nodrop] [-v] [--version] 357s 357s This script will dump out and then drop all tables contained in the designated 357s schema using pg_dump. Each table will be in its own separate file along with a 357s SHA-512 hash of the dump file. Tables are not dropped from the database if 357s pg_dump does not return successfully. All dump_* option defaults are the same 357s as they would be for pg_dump if they are not given. 357s 357s options: 357s -h, --help show this help message and exit 357s -n, --schema SCHEMA (Required) The schema that contains the tables that 357s will be dumped. 357s -c, --connection CONNECTION 357s Connection string for use by psycopg. Role used must 357s be able to select pg_catalog.pg_tables in the relevant 357s database and drop all tables in the given schema. 357s Defaults to "host=" (local socket). Note this is 357s distinct from the parameters sent to pg_dump. 357s -o, --output OUTPUT Path to dump file output location. Default is where 357s the script is run from. 357s -d, --dump_database DUMP_DATABASE 357s Used for pg_dump, same as its --dbname (-d) option or 357s final database name parameter. 357s --dump_host DUMP_HOST 357s Used for pg_dump, same as its --host (-h) option. 357s --dump_username DUMP_USERNAME 357s Used for pg_dump, same as its --username (-U) option. 357s --dump_port DUMP_PORT 357s Used for pg_dump, same as its --port (-p) option. 357s --pg_dump_path PG_DUMP_PATH 357s Path to pg_dump binary location. Must set if not in 357s current PATH. 357s --Fp Dump using pg_dump plain text format. Default is 357s binary custom (-Fc). 357s --nohashfile Do NOT create a separate file with the SHA-512 hash of 357s the dump. If dump files are very large, hash 357s generation can possibly take a long time. 357s --nodrop Do NOT drop the tables from the given schema after 357s dumping/hashing. 357s -v, --verbose Provide more verbose output. 357s --version Print out the minimum version of pg_partman this 357s script is meant to work with. The version of 357s pg_partman installed may be greater than this. 357s 357s NOTE: The connection options for psyocpg and pg_dump were separated out due to 357s distinct differences in their requirements depending on your database 357s connection configuration. 357s usage: vacuum_maintenance.py [-h] [-p PARENT] [--all] [-c CONNECTION] [-z] 357s [-f] [-a VACUUM_FREEZE_MIN_AGE] [-t {time,id}] 357s [-i INTERVAL] [--noparent] [--dryrun] [-q] 357s [--version] [--debug] 357s 357s Script for performing additional vacuum maintenance on the child tables of a 357s partition set in order to avoid excess vacuuming and transaction id wraparound 357s issues. Whether a table is vacuumed or not by this script depends on whether 357s its age(relfrozenxid) is greater than vacuum_freeze_min_age. This ensures 357s repeated runs of this script do not re-vacuum tables that have already had all 357s of their page tuples frozen. This script does not require pg_partman to be 357s installed and will work on any inheritance set given a parent table, as long 357s as the options --all, --type or --interval are NOT set. 357s 357s options: 357s -h, --help show this help message and exit 357s -p, --parent PARENT Parent table of an already created 357s partition/inheritance set. Either this option or --all 357s is required. 357s --all Run against all tables managed by pg_partman. Either 357s this option or -p is required. Overrides -p if both 357s are set. 357s -c, --connection CONNECTION 357s Connection string for use by psycopg. Defaults to 357s "host=" (local socket). 357s -z, --freeze Sets the FREEZE option to the VACUUM command. 357s -f, --full Sets the FULL option to the VACUUM command. Note that 357s --freeze is not necessary if you set this. Recommend 357s reviewing --dryrun before running this since it will 357s lock all tables it runs against, possibly including 357s the parent. 357s -a, --vacuum_freeze_min_age VACUUM_FREEZE_MIN_AGE 357s By default the script obtains this value from the 357s system catalogs. By setting this, you can override the 357s value obtained from the database. Note this does not 357s change the value in the database, only the value this 357s script uses. 357s -t, --type {time,id} Tells the script whether the value given by --interval 357s is either time or id based. Also, if --all is set, 357s limits the partition sets that the script runs against 357s to just those types. Valid values are: "id" and 357s "time". 357s -i, --interval INTERVAL 357s In addition to checking transaction age, only run 357s against tables that are older than the interval given. 357s Takes either a postgresql time interval or integer 357s value. For time-based partitioning, uses the time that 357s script is run as baseline. For id-based partitioning, 357s the integer value will set that any partitions with an 357s id value less than the current maximum id value minus 357s the given value will be vacuumed. For example, if the 357s current max id is 100 and the given value is 30, any 357s partitions with id values less than 70 will be 357s vacuumed. The current maximum id value at the time the 357s script is run is always used. 357s --noparent Normally the parent table is included in the list of 357s tables to vacuum if its age(relfrozenxid) is higher 357s than vacuum_freeze_min_age. Set this to force 357s exclusion of the parent table, even if it meets that 357s criteria. 357s --dryrun Show what the script will do without actually running 357s it against the database. Highly recommend reviewing 357s this before running for the first time. 357s -q, --quiet Turn off all output. 357s --version Print out the minimum version of pg_partman this 357s script is meant to work with. The version of 357s pg_partman installed may be greater than this. 357s --debug Show additional debugging output 358s autopkgtest [23:04:11]: test scripts: -----------------------] 358s autopkgtest [23:04:11]: test scripts: - - - - - - - - - - results - - - - - - - - - - 358s scripts PASS 359s autopkgtest [23:04:12]: @@@@@@@@@@@@@@@@@@@@ summary 359s prove PASS 359s scripts PASS 364s nova [W] Using flock in prodstack6-ppc64el 364s Creating nova instance adt-plucky-ppc64el-pg-partman-20250103-224240-juju-7f2275-prod-proposed-migration-environment-15-80cb8a93-225c-4e65-8c94-641bae5de4db from image adt/ubuntu-plucky-ppc64el-server-20250103.img (UUID f20efbba-1df4-424c-8de8-0f24e2643aa4)... 364s nova [W] Timed out waiting for ce2ca8db-4da4-4124-bd66-8a82d7cefc82 to get deleted. 364s nova [W] Using flock in prodstack6-ppc64el 364s Creating nova instance adt-plucky-ppc64el-pg-partman-20250103-224240-juju-7f2275-prod-proposed-migration-environment-15-80cb8a93-225c-4e65-8c94-641bae5de4db from image adt/ubuntu-plucky-ppc64el-server-20250103.img (UUID f20efbba-1df4-424c-8de8-0f24e2643aa4)... 364s nova [W] Timed out waiting for 0a79a5be-8923-42f0-b991-70d90414ce38 to get deleted.