0s autopkgtest [15:42:28]: starting date and time: 2025-01-08 15:42:28+0000 1s autopkgtest [15:42:29]: git checkout: 325255d2 Merge branch 'pin-any-arch' into 'ubuntu/production' 1s autopkgtest [15:42:29]: host juju-7f2275-prod-proposed-migration-environment-20; command line: /home/ubuntu/autopkgtest/runner/autopkgtest --output-dir /tmp/autopkgtest-work.ocymvbyx/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 builder-cpu2-ram4-disk20 --security-groups autopkgtest-juju-7f2275-prod-proposed-migration-environment-20@bos03-9.secgroup --name adt-plucky-amd64-pg-partman-20250108-154228-juju-7f2275-prod-proposed-migration-environment-20-831eb23f-410d-4ec7-846a-16d99f550878 --image adt/ubuntu-plucky-amd64-server --keyname testbed-juju-7f2275-prod-proposed-migration-environment-20 --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,radosgw.ps5.canonical.com'"'"'' --mirror=http://ftpmaster.internal/ubuntu/ 59s autopkgtest [15:43:27]: testbed dpkg architecture: amd64 59s autopkgtest [15:43:27]: testbed apt version: 2.9.18 59s autopkgtest [15:43:27]: @@@@@@@@@@@@@@@@@@@@ test bed setup 59s autopkgtest [15:43:27]: testbed release detected to be: None 60s autopkgtest [15:43:28]: updating testbed package index (apt update) 60s Get:1 http://ftpmaster.internal/ubuntu plucky-proposed InRelease [73.9 kB] 61s Hit:2 http://ftpmaster.internal/ubuntu plucky InRelease 61s Hit:3 http://ftpmaster.internal/ubuntu plucky-updates InRelease 61s Hit:4 http://ftpmaster.internal/ubuntu plucky-security InRelease 61s Get:5 http://ftpmaster.internal/ubuntu plucky-proposed/restricted Sources [9708 B] 61s Get:6 http://ftpmaster.internal/ubuntu plucky-proposed/universe Sources [820 kB] 61s Get:7 http://ftpmaster.internal/ubuntu plucky-proposed/main Sources [127 kB] 61s Get:8 http://ftpmaster.internal/ubuntu plucky-proposed/multiverse Sources [17.3 kB] 61s Get:9 http://ftpmaster.internal/ubuntu plucky-proposed/main amd64 Packages [262 kB] 61s Get:10 http://ftpmaster.internal/ubuntu plucky-proposed/main i386 Packages [169 kB] 61s Get:11 http://ftpmaster.internal/ubuntu plucky-proposed/restricted i386 Packages [2408 B] 61s Get:12 http://ftpmaster.internal/ubuntu plucky-proposed/restricted amd64 Packages [40.1 kB] 61s Get:13 http://ftpmaster.internal/ubuntu plucky-proposed/universe i386 Packages [416 kB] 61s Get:14 http://ftpmaster.internal/ubuntu plucky-proposed/universe amd64 Packages [1026 kB] 61s Get:15 http://ftpmaster.internal/ubuntu plucky-proposed/multiverse amd64 Packages [23.7 kB] 61s Get:16 http://ftpmaster.internal/ubuntu plucky-proposed/multiverse i386 Packages [4028 B] 61s Fetched 2991 kB in 1s (3103 kB/s) 62s Reading package lists... 63s Reading package lists... 63s Building dependency tree... 63s Reading state information... 63s Calculating upgrade... 63s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 63s Reading package lists... 63s Building dependency tree... 63s Reading state information... 64s 0 upgraded, 0 newly installed, 0 to remove and 3 not upgraded. 64s autopkgtest [15:43:32]: upgrading testbed (apt dist-upgrade and autopurge) 64s Reading package lists... 64s Building dependency tree... 64s Reading state information... 64s Calculating upgrade...Starting pkgProblemResolver with broken count: 0 64s Starting 2 pkgProblemResolver with broken count: 0 64s Done 65s Entering ResolveByKeep 65s 65s The following packages were automatically installed and are no longer required: 65s python3.12 python3.12-minimal 65s Use 'sudo apt autoremove' to remove them. 65s The following NEW packages will be installed: 65s libpython3.13-minimal libpython3.13-stdlib python3.13 python3.13-minimal 65s The following packages will be upgraded: 65s libpython3-stdlib python3 python3-minimal 67s 3 upgraded, 4 newly installed, 0 to remove and 0 not upgraded. 67s Need to get 6118 kB of archives. 67s After this operation, 22.7 MB of additional disk space will be used. 67s Get:1 http://ftpmaster.internal/ubuntu plucky/main amd64 libpython3.13-minimal amd64 3.13.1-2 [881 kB] 67s Get:2 http://ftpmaster.internal/ubuntu plucky/main amd64 python3.13-minimal amd64 3.13.1-2 [2358 kB] 68s Get:3 http://ftpmaster.internal/ubuntu plucky-proposed/main amd64 python3-minimal amd64 3.13.1-1~exp2 [27.6 kB] 68s Get:4 http://ftpmaster.internal/ubuntu plucky-proposed/main amd64 python3 amd64 3.13.1-1~exp2 [23.9 kB] 68s Get:5 http://ftpmaster.internal/ubuntu plucky/main amd64 libpython3.13-stdlib amd64 3.13.1-2 [2088 kB] 68s Get:6 http://ftpmaster.internal/ubuntu plucky/main amd64 python3.13 amd64 3.13.1-2 [729 kB] 68s Get:7 http://ftpmaster.internal/ubuntu plucky-proposed/main amd64 libpython3-stdlib amd64 3.13.1-1~exp2 [10.2 kB] 68s Fetched 6118 kB in 3s (2033 kB/s) 68s Selecting previously unselected package libpython3.13-minimal:amd64. 68s (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 ... 75804 files and directories currently installed.) 68s Preparing to unpack .../libpython3.13-minimal_3.13.1-2_amd64.deb ... 68s Unpacking libpython3.13-minimal:amd64 (3.13.1-2) ... 68s Selecting previously unselected package python3.13-minimal. 68s Preparing to unpack .../python3.13-minimal_3.13.1-2_amd64.deb ... 68s Unpacking python3.13-minimal (3.13.1-2) ... 69s Setting up libpython3.13-minimal:amd64 (3.13.1-2) ... 69s Setting up python3.13-minimal (3.13.1-2) ... 69s (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 ... 76124 files and directories currently installed.) 69s Preparing to unpack .../python3-minimal_3.13.1-1~exp2_amd64.deb ... 69s Unpacking python3-minimal (3.13.1-1~exp2) over (3.12.8-1) ... 69s Setting up python3-minimal (3.13.1-1~exp2) ... 69s (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 ... 76124 files and directories currently installed.) 69s Preparing to unpack .../python3_3.13.1-1~exp2_amd64.deb ... 69s Unpacking python3 (3.13.1-1~exp2) over (3.12.8-1) ... 69s Selecting previously unselected package libpython3.13-stdlib:amd64. 69s Preparing to unpack .../libpython3.13-stdlib_3.13.1-2_amd64.deb ... 69s Unpacking libpython3.13-stdlib:amd64 (3.13.1-2) ... 70s Selecting previously unselected package python3.13. 70s Preparing to unpack .../python3.13_3.13.1-2_amd64.deb ... 70s Unpacking python3.13 (3.13.1-2) ... 70s Preparing to unpack .../libpython3-stdlib_3.13.1-1~exp2_amd64.deb ... 70s Unpacking libpython3-stdlib:amd64 (3.13.1-1~exp2) over (3.12.8-1) ... 70s Setting up libpython3.13-stdlib:amd64 (3.13.1-2) ... 70s Setting up libpython3-stdlib:amd64 (3.13.1-1~exp2) ... 70s Setting up python3.13 (3.13.1-2) ... 70s Setting up python3 (3.13.1-1~exp2) ... 70s /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. 70s for fn in glob1(directory, "%s.*" % fname): 71s Processing triggers for man-db (2.13.0-1) ... 71s Processing triggers for systemd (257-2ubuntu1) ... 71s Reading package lists... 72s Building dependency tree... 72s Reading state information... 72s Starting pkgProblemResolver with broken count: 0 72s Starting 2 pkgProblemResolver with broken count: 0 72s Done 72s The following packages will be REMOVED: 72s python3.12* python3.12-minimal* 72s 0 upgraded, 0 newly installed, 2 to remove and 0 not upgraded. 72s After this operation, 8926 kB disk space will be freed. 72s (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 ... 76541 files and directories currently installed.) 72s Removing python3.12 (3.12.8-3) ... 72s Removing python3.12-minimal (3.12.8-3) ... 73s /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. 73s for fn in glob1(directory, "%s.%s.py[co]" % (fname, magic_tag)): 73s Processing triggers for man-db (2.13.0-1) ... 73s Processing triggers for systemd (257-2ubuntu1) ... 73s (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 ... 76513 files and directories currently installed.) 73s Purging configuration files for python3.12-minimal (3.12.8-3) ... 76s autopkgtest [15:43:44]: testbed running kernel: Linux 6.11.0-8-generic #8-Ubuntu SMP PREEMPT_DYNAMIC Mon Sep 16 13:41:20 UTC 2024 76s autopkgtest [15:43:44]: @@@@@@@@@@@@@@@@@@@@ apt-source pg-partman 78s Get:1 http://ftpmaster.internal/ubuntu plucky/universe pg-partman 5.2.2-1 (dsc) [2307 B] 78s Get:2 http://ftpmaster.internal/ubuntu plucky/universe pg-partman 5.2.2-1 (tar) [1248 kB] 78s Get:3 http://ftpmaster.internal/ubuntu plucky/universe pg-partman 5.2.2-1 (diff) [4260 B] 78s gpgv: Signature made Wed Dec 11 22:00:11 2024 UTC 78s gpgv: using RSA key 5C48FE6157F49179597087C64C5A6BAB12D2A7AE 78s gpgv: Can't check signature: No public key 78s dpkg-source: warning: cannot verify inline signature for ./pg-partman_5.2.2-1.dsc: no acceptable signature found 78s autopkgtest [15:43:46]: testing package pg-partman version 5.2.2-1 78s autopkgtest [15:43:46]: build not needed 79s autopkgtest [15:43:47]: test prove: preparing testbed 80s Reading package lists... 80s Building dependency tree... 80s Reading state information... 80s Starting pkgProblemResolver with broken count: 0 80s Starting 2 pkgProblemResolver with broken count: 0 80s Done 80s The following NEW packages will be installed: 80s libjson-perl libpq5 libtap-parser-sourcehandler-pgtap-perl libxslt1.1 80s postgresql-17 postgresql-17-partman postgresql-17-pgtap postgresql-client-17 80s postgresql-client-common postgresql-common python3-psycopg2 ssl-cert 80s 0 upgraded, 12 newly installed, 0 to remove and 0 not upgraded. 80s Need to get 19.0 MB of archives. 80s After this operation, 65.6 MB of additional disk space will be used. 80s Get:1 http://ftpmaster.internal/ubuntu plucky/main amd64 libjson-perl all 4.10000-1 [81.9 kB] 81s Get:2 http://ftpmaster.internal/ubuntu plucky/main amd64 postgresql-client-common all 262 [36.7 kB] 81s Get:3 http://ftpmaster.internal/ubuntu plucky/main amd64 ssl-cert all 1.1.3ubuntu1 [18.7 kB] 81s Get:4 http://ftpmaster.internal/ubuntu plucky/main amd64 postgresql-common all 262 [162 kB] 81s Get:5 http://ftpmaster.internal/ubuntu plucky/main amd64 libpq5 amd64 17.2-1 [153 kB] 81s Get:6 http://ftpmaster.internal/ubuntu plucky/main amd64 libxslt1.1 amd64 1.1.39-0exp1ubuntu2 [175 kB] 81s Get:7 http://ftpmaster.internal/ubuntu plucky/main amd64 postgresql-client-17 amd64 17.2-1 [1405 kB] 81s Get:8 http://ftpmaster.internal/ubuntu plucky/main amd64 postgresql-17 amd64 17.2-1 [16.5 MB] 84s Get:9 http://ftpmaster.internal/ubuntu plucky/main amd64 python3-psycopg2 amd64 2.9.10-1 [146 kB] 84s Get:10 http://ftpmaster.internal/ubuntu plucky/universe amd64 postgresql-17-partman amd64 5.2.2-1 [228 kB] 84s Get:11 http://ftpmaster.internal/ubuntu plucky/universe amd64 postgresql-17-pgtap all 1.3.3-3 [45.6 kB] 84s Get:12 http://ftpmaster.internal/ubuntu plucky/universe amd64 libtap-parser-sourcehandler-pgtap-perl all 3.36-2 [35.2 kB] 84s Preconfiguring packages ... 84s Fetched 19.0 MB in 3s (5681 kB/s) 84s Selecting previously unselected package libjson-perl. 84s (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 ... 76513 files and directories currently installed.) 84s Preparing to unpack .../00-libjson-perl_4.10000-1_all.deb ... 84s Unpacking libjson-perl (4.10000-1) ... 84s Selecting previously unselected package postgresql-client-common. 84s Preparing to unpack .../01-postgresql-client-common_262_all.deb ... 84s Unpacking postgresql-client-common (262) ... 84s Selecting previously unselected package ssl-cert. 84s Preparing to unpack .../02-ssl-cert_1.1.3ubuntu1_all.deb ... 84s Unpacking ssl-cert (1.1.3ubuntu1) ... 84s Selecting previously unselected package postgresql-common. 84s Preparing to unpack .../03-postgresql-common_262_all.deb ... 84s Adding 'diversion of /usr/bin/pg_config to /usr/bin/pg_config.libpq-dev by postgresql-common' 84s Unpacking postgresql-common (262) ... 84s Selecting previously unselected package libpq5:amd64. 84s Preparing to unpack .../04-libpq5_17.2-1_amd64.deb ... 84s Unpacking libpq5:amd64 (17.2-1) ... 84s Selecting previously unselected package libxslt1.1:amd64. 84s Preparing to unpack .../05-libxslt1.1_1.1.39-0exp1ubuntu2_amd64.deb ... 84s Unpacking libxslt1.1:amd64 (1.1.39-0exp1ubuntu2) ... 84s Selecting previously unselected package postgresql-client-17. 84s Preparing to unpack .../06-postgresql-client-17_17.2-1_amd64.deb ... 84s Unpacking postgresql-client-17 (17.2-1) ... 84s Selecting previously unselected package postgresql-17. 84s Preparing to unpack .../07-postgresql-17_17.2-1_amd64.deb ... 84s Unpacking postgresql-17 (17.2-1) ... 85s Selecting previously unselected package python3-psycopg2. 85s Preparing to unpack .../08-python3-psycopg2_2.9.10-1_amd64.deb ... 85s Unpacking python3-psycopg2 (2.9.10-1) ... 85s Selecting previously unselected package postgresql-17-partman. 85s Preparing to unpack .../09-postgresql-17-partman_5.2.2-1_amd64.deb ... 85s Unpacking postgresql-17-partman (5.2.2-1) ... 85s Selecting previously unselected package postgresql-17-pgtap. 85s Preparing to unpack .../10-postgresql-17-pgtap_1.3.3-3_all.deb ... 85s Unpacking postgresql-17-pgtap (1.3.3-3) ... 85s Selecting previously unselected package libtap-parser-sourcehandler-pgtap-perl. 85s Preparing to unpack .../11-libtap-parser-sourcehandler-pgtap-perl_3.36-2_all.deb ... 85s Unpacking libtap-parser-sourcehandler-pgtap-perl (3.36-2) ... 85s Setting up postgresql-client-common (262) ... 85s Setting up libtap-parser-sourcehandler-pgtap-perl (3.36-2) ... 85s Setting up libpq5:amd64 (17.2-1) ... 85s Setting up ssl-cert (1.1.3ubuntu1) ... 85s Created symlink '/etc/systemd/system/multi-user.target.wants/ssl-cert.service' → '/usr/lib/systemd/system/ssl-cert.service'. 85s Setting up python3-psycopg2 (2.9.10-1) ... 85s Setting up libjson-perl (4.10000-1) ... 85s Setting up libxslt1.1:amd64 (1.1.39-0exp1ubuntu2) ... 85s Setting up postgresql-client-17 (17.2-1) ... 86s 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 86s Setting up postgresql-common (262) ... 86s Creating config file /etc/postgresql-common/createcluster.conf with new version 86s Building PostgreSQL dictionaries from installed myspell/hunspell packages... 86s Removing obsolete dictionary files: 87s Created symlink '/etc/systemd/system/multi-user.target.wants/postgresql.service' → '/usr/lib/systemd/system/postgresql.service'. 87s Setting up postgresql-17 (17.2-1) ... 87s Creating new PostgreSQL cluster 17/main ... 87s /usr/lib/postgresql/17/bin/initdb -D /var/lib/postgresql/17/main --auth-local peer --auth-host scram-sha-256 --no-instructions 87s The files belonging to this database system will be owned by user "postgres". 87s This user must also own the server process. 87s 87s The database cluster will be initialized with locale "C.UTF-8". 87s The default database encoding has accordingly been set to "UTF8". 87s The default text search configuration will be set to "english". 87s 87s Data page checksums are disabled. 87s 87s fixing permissions on existing directory /var/lib/postgresql/17/main ... ok 87s creating subdirectories ... ok 87s selecting dynamic shared memory implementation ... posix 87s selecting default "max_connections" ... 100 87s selecting default "shared_buffers" ... 128MB 88s selecting default time zone ... Etc/UTC 88s creating configuration files ... ok 88s running bootstrap script ... ok 88s performing post-bootstrap initialization ... ok 88s syncing data to disk ... ok 92s Setting up postgresql-17-pgtap (1.3.3-3) ... 92s Setting up postgresql-17-partman (5.2.2-1) ... 92s Processing triggers for man-db (2.13.0-1) ... 92s Processing triggers for libc-bin (2.40-4ubuntu1) ... 93s autopkgtest [15:44:01]: test prove: [----------------------- 94s ### PostgreSQL 17 virtualenv ### 94s Creating new PostgreSQL cluster 17/regress ... 96s + psql -c 'CREATE EXTENSION pgtap' 97s CREATE EXTENSION 97s + psql -c 'CREATE EXTENSION pg_partman' 97s + pg_prove -ovf test/test-id-10.sql 97s CREATE EXTENSION 97s Duplicate specification "psql-bin|b=s" for option "b" 97s Duplicate specification "host|h=s" for option "h" 97s Duplicate specification "port|p=s" for option "p" 97s Duplicate specification "pset|P=s%" for option "P" 97s Duplicate specification "schema|s=s" for option "s" 97s Duplicate specification "version|V" for option "version" 97s Duplicate specification "version|V" for option "V" 97s Duplicate specification "help|H|?" for option "help" 97s Duplicate specification "help|H|?" for option "H" 97s Duplicate specification "help|H|?" for option "?" 97s Duplicate specification "man|m" for option "man" 97s Duplicate specification "man|m" for option "m" 97s psql:test/test-id-10.sql:208: NOTICE: Moved 11 row(s) to the target table. Removed 1 partitions. 97s psql:test/test-id-10.sql:211: NOTICE: Moved 10 row(s) to the target table. Removed 1 partitions. 97s psql:test/test-id-10.sql:215: NOTICE: Moved 9 row(s) to the target table. Removed 5 partitions. 97s test/test-id-10.sql .. 97s partman, public 97s 1..135 97s t 97s ok 1 - Check id_taptest_table_p3000000000 exists 97s ok 2 - Check id_taptest_table_p3000000010 exists 97s ok 3 - Check id_taptest_table_p3000000020 exists 97s ok 4 - Check id_taptest_table_p3000000030 exists 97s ok 5 - Check id_taptest_table_p3000000040 exists 97s ok 6 - Check id_taptest_table_default exists 97s ok 7 - Check id_taptest_table_p3000000050 doesn't exists yet 97s ok 8 - Check for primary key in id_taptest_table_p3000000000 97s ok 9 - Check for primary key in id_taptest_table_p3000000010 97s ok 10 - Check for primary key in id_taptest_table_p3000000020 97s ok 11 - Check for primary key in id_taptest_table_p3000000030 97s ok 12 - Check for primary key in id_taptest_table_p3000000040 97s ok 13 - Check for primary key in id_taptest_table_default 97s ok 14 - Check that foreign key was inherited to id_taptest_table_p3000000000 97s ok 15 - Check that foreign key was inherited to id_taptest_table_p3000000010 97s ok 16 - Check that foreign key was inherited to id_taptest_table_p3000000020 97s ok 17 - Check that foreign key was inherited to id_taptest_table_p3000000030 97s ok 18 - Check that foreign key was inherited to id_taptest_table_p3000000040 97s ok 19 - Check that foreign key was inherited to id_taptest_table_default 97s ok 20 - Check that unique index was inherited to id_taptest_table_p3000000000 97s ok 21 - Check that unique index was inherited to id_taptest_table_p3000000010 97s ok 22 - Check that unique index was inherited to id_taptest_table_p3000000020 97s ok 23 - Check that unique index was inherited to id_taptest_table_p3000000030 97s ok 24 - Check that unique index was inherited to id_taptest_table_p3000000040 97s ok 25 - Check that unique index was inherited to id_taptest_table_default 97s ok 26 - Check partman_basic privileges of id_taptest_table_p3000000000 97s ok 27 - Check partman_basic privileges of id_taptest_table_p3000000010 97s ok 28 - Check partman_basic privileges of id_taptest_table_p3000000020 97s ok 29 - Check partman_basic privileges of id_taptest_table_p3000000030 97s ok 30 - Check partman_basic privileges of id_taptest_table_p3000000040 97s ok 31 - Check partman_basic privileges of id_taptest_table_default 97s ok 32 - Check partman_revoke privileges of id_taptest_table_p3000000000 97s ok 33 - Check partman_revoke privileges of id_taptest_table_p3000000010 97s ok 34 - Check partman_revoke privileges of id_taptest_table_p3000000020 97s ok 35 - Check partman_revoke privileges of id_taptest_table_p3000000030 97s ok 36 - Check partman_revoke privileges of id_taptest_table_p3000000040 97s ok 37 - Check partman_revoke privileges of id_taptest_table_default 97s ok 38 - Check that parent table is unlogged 97s ok 39 - Check that id_taptest_table_p3000000000 is unlogged 97s ok 40 - Check that id_taptest_table_p3000000010 is unlogged 97s ok 41 - Check that id_taptest_table_p3000000020 is unlogged 97s ok 42 - Check that id_taptest_table_p3000000030 is unlogged 97s ok 43 - Check that id_taptest_table_p3000000040 is unlogged 97s ok 44 - Check that id_taptest_table_default is unlogged 97s ok 45 - Check that default table has no data 97s ok 46 - Check count from parent table 97s ok 47 - Check count from id_taptest_table_p3000000000 97s ok 48 - Check that parent table has had no data inserted to it 97s ok 49 - Check count from id_taptest_table_p3000000010 97s ok 50 - Check count from id_taptest_table_p3000000020 97s ok 51 - Check id_taptest_table_p3000000050 exists 97s ok 52 - Check that id_taptest_table_p3000000050 is unlogged 97s ok 53 - Check id_taptest_table_p3000000060 exists yet 97s ok 54 - Check that id_taptest_table_p3000000060 is unlogged 97s ok 55 - Check id_taptest_table_p3000000070 doesn't exists yet 97s ok 56 - Check for primary key in id_taptest_table_p3000000050 97s ok 57 - Check that foreign key was inherited to id_taptest_table_p3000000050 97s ok 58 - Check partman_basic privileges of id_taptest_table_p3000000000 97s ok 59 - Check partman_basic privileges of id_taptest_table_p3000000010 97s ok 60 - Check partman_basic privileges of id_taptest_table_p3000000020 97s ok 61 - Check partman_basic privileges of id_taptest_table_p3000000030 97s ok 62 - Check partman_basic privileges of id_taptest_table_p3000000040 97s ok 63 - Check partman_basic privileges of id_taptest_table_p3000000050 97s ok 64 - Check partman_revoke privileges of id_taptest_table_p3000000050 97s ok 65 - Check partman_basic privileges of id_taptest_table_p3000000060 97s ok 66 - Check partman_revoke privileges of id_taptest_table_p3000000060 97s ok 67 - Check that parent table has had no data inserted to it 97s ok 68 - Check count from id_taptest_table 97s ok 69 - Check count from id_taptest_table_p3000000020 97s ok 70 - Check count from id_taptest_table_p3000000030 97s ok 71 - Check id_taptest_table_p3000000070 exists 97s ok 72 - Check that id_taptest_table_p3000000070 is unlogged 97s ok 73 - Check id_taptest_table_p3000000080 doesn't exists yet 97s ok 74 - Check for primary key in id_taptest_table_p3000000060 97s ok 75 - Check for primary key in id_taptest_table_p3000000070 97s ok 76 - Check that foreign key was inherited to id_taptest_table_p3000000060 97s ok 77 - Check that foreign key was inherited to id_taptest_table_p3000000070 97s ok 78 - Check partman_basic privileges of id_taptest_table_p3000000000 97s ok 79 - Check partman_basic privileges of id_taptest_table_p3000000010 97s ok 80 - Check partman_basic privileges of id_taptest_table_p3000000020 97s ok 81 - Check partman_basic privileges of id_taptest_table_p3000000030 97s ok 82 - Check partman_basic privileges of id_taptest_table_p3000000040 97s ok 83 - Check partman_basic privileges of id_taptest_table_default 97s ok 84 - Check partman_basic privileges of id_taptest_table_p3000000050 97s ok 85 - Check partman_revoke privileges of id_taptest_table_p3000000050 97s ok 86 - Check partman_basic privileges of id_taptest_table_p3000000060 97s ok 87 - Check partman_revoke privileges of id_taptest_table_p3000000060 97s ok 88 - Check partman_basic privileges of id_taptest_table_p3000000070 97s ok 89 - Check that ownership change worked for id_taptest_table_p3000000070 97s ok 90 - Check partman_revoke has no privileges on id_taptest_table_p3000000070 97s ok 91 - Check that data outside child scope goes to default 97s ok 92 - Check partman_basic privileges of id_taptest_table_p3000000000 97s ok 93 - Check partman_basic privileges of id_taptest_table_p3000000010 97s ok 94 - Check partman_basic privileges of id_taptest_table_p3000000020 97s ok 95 - Check partman_basic privileges of id_taptest_table_p3000000030 97s ok 96 - Check partman_basic privileges of id_taptest_table_p3000000040 97s ok 97 - Check partman_basic privileges of id_taptest_table_p3000000050 97s ok 98 - Check partman_basic privileges of id_taptest_table_p3000000060 97s ok 99 - Check partman_basic privileges of id_taptest_table_p3000000070 97s ok 100 - Check partman_basic privileges of id_taptest_table_default 97s ok 101 - Check partman_revoke has no privileges on id_taptest_table_p3000000000 97s ok 102 - Check partman_revoke has no privileges on id_taptest_table_p3000000010 97s ok 103 - Check partman_revoke has no privileges on id_taptest_table_p3000000020 97s ok 104 - Check partman_revoke has no privileges on id_taptest_table_p3000000030 97s ok 105 - Check partman_revoke has no privileges on id_taptest_table_p3000000040 97s ok 106 - Check partman_revoke has no privileges on id_taptest_table_p3000000050 97s ok 107 - Check partman_revoke has no privileges on id_taptest_table_p3000000060 97s ok 108 - Check partman_revoke has no privileges on id_taptest_table_p3000000070 97s ok 109 - Check partman_revoke has no privileges on id_taptest_table_default 97s ok 110 - Check that ownership change worked for id_taptest_table_p3000000000 97s ok 111 - Check that ownership change worked for id_taptest_table_p3000000010 97s ok 112 - Check that ownership change worked for id_taptest_table_p3000000020 97s ok 113 - Check that ownership change worked for id_taptest_table_p3000000030 97s ok 114 - Check that ownership change worked for id_taptest_table_p3000000040 97s ok 115 - Check that ownership change worked for id_taptest_table_p3000000050 97s ok 116 - Check that ownership change worked for id_taptest_table_p3000000060 97s ok 117 - Check that ownership change worked for id_taptest_table_p3000000070 97s ok 118 - Check that ownership change worked for id_taptest_table_default 97s 1 97s ok 119 - Check id_taptest_table_p3000000000 doesn't exists anymore 97s 1 97s ok 120 - Check id_taptest_table_p3000000010 doesn't exists anymore 97s ok 121 - Check id_taptest_table_p3000000010 got moved to new schema 97s (1,11) 97s ok 122 - Check id_taptest_table_default does not exist 97s (1,10) 97s ok 123 - Check id_taptest_table_p3000000020 does not exist 97s (5,9) 97s ok 124 - Check count from undo table after undo 97s ok 125 - Check id_taptest_table_p3000000030 still exists 97s ok 126 - Check child table had its data removed id_taptest_table_p3000000030 97s ok 127 - Check id_taptest_table_p3000000040 still exists 97s ok 128 - Check child table had its data removed id_taptest_table_p3000000040 97s ok 129 - Check id_taptest_table_p3000000050 still exists 97s ok 130 - Check child table had its data removed id_taptest_table_p3000000050 97s ok 131 - Check id_taptest_table_p3000000060 still exists 97s ok 132 - Check child table had its data removed id_taptest_table_p3000000060 97s ok 133 - Check id_taptest_table_p3000000070 still exists 97s ok 134 - Check child table had its data removed id_taptest_table_p3000000070 97s ok 135 - Check that template table was dropped 97s ok 97s + pg_prove -ovf test/test_bgw/test-time-daily-bgw.sql 97s All tests successful. 97s Files=1, Tests=135, 0 wallclock secs ( 0.02 usr 0.00 sys + 0.03 cusr 0.01 csys = 0.06 CPU) 97s Result: PASS 97s Duplicate specification "psql-bin|b=s" for option "b" 97s Duplicate specification "host|h=s" for option "h" 97s Duplicate specification "port|p=s" for option "p" 97s Duplicate specification "pset|P=s%" for option "P" 97s Duplicate specification "schema|s=s" for option "s" 97s Duplicate specification "version|V" for option "version" 97s Duplicate specification "version|V" for option "V" 97s Duplicate specification "help|H|?" for option "help" 97s Duplicate specification "help|H|?" for option "H" 97s Duplicate specification "help|H|?" for option "?" 97s Duplicate specification "man|m" for option "man" 97s Duplicate specification "man|m" for option "m" 157s psql:test/test_bgw/test-time-daily-bgw.sql:253: NOTICE: Moved 36 row(s) to the target table. Removed 12 partitions. 157s psql:test/test_bgw/test-time-daily-bgw.sql:296: NOTICE: drop cascades to 14 other objects 157s DETAIL: drop cascades to table partman_test.time_taptest_table 157s drop cascades to table partman_test.undo_taptest 157s drop cascades to table partman_test.time_taptest_table_p20250106 157s drop cascades to table partman_test.time_taptest_table_p20250107 157s drop cascades to table partman_test.time_taptest_table_p20250108 157s drop cascades to table partman_test.time_taptest_table_p20250109 157s drop cascades to table partman_test.time_taptest_table_p20250110 157s drop cascades to table partman_test.time_taptest_table_p20250111 157s drop cascades to table partman_test.time_taptest_table_p20250112 157s drop cascades to table partman_test.time_taptest_table_default 157s drop cascades to table partman_test.time_taptest_table_p20250113 157s drop cascades to table partman_test.time_taptest_table_p20250114 157s drop cascades to table partman_test.time_taptest_table_p20250115 157s drop cascades to table partman_test.time_taptest_table_p20250116 157s psql:test/test_bgw/test-time-daily-bgw.sql:297: NOTICE: drop cascades to table partman_retention_test.time_taptest_table_p20250105 157s test/test_bgw/test-time-daily-bgw.sql .. 157s partman, public 157s 1..105 157s t 157s ok 1 - Check time_taptest_table_p20250108 exists 157s ok 2 - Check time_taptest_table_p20250109 exists 157s ok 3 - Check time_taptest_table_p20250110 exists 157s ok 4 - Check time_taptest_table_p20250111 exists 157s ok 5 - Check time_taptest_table_p20250112 exists 157s ok 6 - Check time_taptest_table_p20250113 exists 157s ok 7 - Check for primary key in time_taptest_table_p20250108 157s ok 8 - Check for primary key in time_taptest_table_p20250109 157s ok 9 - Check for primary key in time_taptest_table_p20250110 157s ok 10 - Check for primary key in time_taptest_table_p20250111 157s ok 11 - Check for primary key in time_taptest_table_p20250112 157s ok 12 - Check partman_basic privileges of time_taptest_table_p20250108 157s ok 13 - Check partman_basic privileges of time_taptest_table_p20250109 157s ok 14 - Check partman_basic privileges of time_taptest_table_p20250110 157s ok 15 - Check partman_basic privileges of time_taptest_table_p20250111 157s ok 16 - Check partman_basic privileges of time_taptest_table_p20250112 157s ok 17 - Check partman_revoke privileges of time_taptest_table_p20250108 157s ok 18 - Check partman_revoke privileges of time_taptest_table_p20250109 157s ok 19 - Check partman_revoke privileges of time_taptest_table_p20250110 157s ok 20 - Check partman_revoke privileges of time_taptest_table_p20250111 157s ok 21 - Check partman_revoke privileges of time_taptest_table_p20250112 157s ok 22 - Check count from parent table 157s ok 23 - Check count from time_taptest_table_p20250108 157s ok 24 - Check count from time_taptest_table 157s ok 25 - Check count from time_taptest_table_p20250109 157s ok 26 - Check count from time_taptest_table_p20250110 157s ok 27 - Waiting 20 seconds for background worker to run... 157s ok 28 - Check time_taptest_table_p20250113 exists 157s ok 29 - Check time_taptest_table_p20250114 exists 157s ok 30 - Check time_taptest_table_p20250115 exists 157s ok 31 - Check time_taptest_table_p20250116 exists 157s ok 32 - Check for primary key in time_taptest_table_p20250113 157s ok 33 - Check for primary key in time_taptest_table_p20250114 157s ok 34 - Check for primary key in time_taptest_table_p20250115 157s ok 35 - Check partman_basic privileges of time_taptest_table_p20250113 157s ok 36 - Check partman_basic privileges of time_taptest_table_p20250114 157s ok 37 - Check partman_basic privileges of time_taptest_table_p20250115 157s ok 38 - Check partman_revoke privileges of time_taptest_table_p20250113 157s ok 39 - Check partman_revoke privileges of time_taptest_table_p20250114 157s ok 40 - Check partman_revoke privileges of time_taptest_table_p20250115 157s ok 41 - Waiting 20 seconds for background worker to run... 157s ok 42 - Check time_taptest_table_p20250116 exists 157s ok 43 - Check time_taptest_table_p20250117 exists 157s ok 44 - Check for primary key in time_taptest_table_p20250116 157s ok 45 - Check partman_basic privileges of time_taptest_table_p20250116 157s ok 46 - Check partman_revoke privileges of time_taptest_table_p20250116 157s ok 47 - Check that ownership change worked for time_taptest_table_p20250116 157s ok 48 - Check that data outside scope goes to default 157s ok 49 - Check partman_basic privileges of time_taptest_table_p20250108 157s ok 50 - Check partman_basic privileges of time_taptest_table_p20250109 157s ok 51 - Check partman_basic privileges of time_taptest_table_p20250110 157s ok 52 - Check partman_basic privileges of time_taptest_table_p20250111 157s ok 53 - Check partman_basic privileges of time_taptest_table_p20250112 157s ok 54 - Check partman_basic privileges of time_taptest_table_p20250113 157s ok 55 - Check partman_basic privileges of time_taptest_table_p20250114 157s ok 56 - Check partman_basic privileges of time_taptest_table_p20250115 157s ok 57 - Check partman_basic privileges of time_taptest_table_p20250116 157s ok 58 - Check partman_revoke privileges of time_taptest_table_p20250108 157s ok 59 - Check partman_revoke privileges of time_taptest_table_p20250109 157s ok 60 - Check partman_revoke privileges of time_taptest_table_p20250110 157s ok 61 - Check partman_revoke privileges of time_taptest_table_p20250111 157s ok 62 - Check partman_revoke privileges of time_taptest_table_p20250112 157s ok 63 - Check partman_revoke privileges of time_taptest_table_p20250113 157s ok 64 - Check partman_revoke privileges of time_taptest_table_p20250114 157s ok 65 - Check partman_revoke privileges of time_taptest_table_p20250115 157s ok 66 - Check partman_revoke privileges of time_taptest_table_p20250116 157s ok 67 - Check that ownership change worked for time_taptest_table_p20250108 157s ok 68 - Check that ownership change worked for time_taptest_table_p20250109 157s ok 69 - Check that ownership change worked for time_taptest_table_p20250110 157s ok 70 - Check that ownership change worked for time_taptest_table_p20250111 157s ok 71 - Check that ownership change worked for time_taptest_table_p20250112 157s ok 72 - Check that ownership change worked for time_taptest_table_p20250113 157s ok 73 - Check that ownership change worked for time_taptest_table_p20250114 157s ok 74 - Check that ownership change worked for time_taptest_table_p20250115 157s ok 75 - Check that ownership change worked for time_taptest_table_p20250116 157s 1 157s ok 76 - Check time_taptest_table_p20250104 does not exist 157s ok 77 - Waiting 20 seconds for background worker to run... 157s ok 78 - Check time_taptest_table_p20250105 does not exist 157s ok 79 - Check time_taptest_table_p20250105 got moved to new schema 157s (12,36) 157s ok 80 - Check time_taptest_table_p20250108 exists 157s ok 81 - Check time_taptest_table_p20250109 still exists 157s ok 82 - Check time_taptest_table_p20250107 is empty 157s ok 83 - Check time_taptest_table_p20250107 is empty 157s ok 84 - Check time_taptest_table_p20250106 still exists 157s ok 85 - Check time_taptest_table_p20250106 is empty 157s ok 86 - Check time_taptest_table_p20250109 is empty 157s ok 87 - Check time_taptest_table_p20250110 still exists 157s ok 88 - Check time_taptest_table_p20250110 is empty 157s ok 89 - Check time_taptest_table_p20250111 still exists 157s ok 90 - Check time_taptest_table_p20250111 is empty 157s ok 91 - Check time_taptest_table_p20250112 still exists 157s ok 92 - Check time_taptest_table_p20250112 is empty 157s ok 93 - Check time_taptest_table_p20250113 still exists 157s ok 94 - Check time_taptest_table_p20250113 is empty 157s ok 95 - Check time_taptest_table_p20250114 still exists 157s ok 96 - Check time_taptest_table_p20250114 is empty 157s ok 97 - Check time_taptest_table_p20250115 still exists 157s ok 98 - Check time_taptest_table_p20250115 is empty 157s ok 99 - Check time_taptest_table_p20250116 still exists 157s ok 100 - Check time_taptest_table_p20250116 is empty 157s ok 101 - Ensure partman_test schema has been dropped 157s ok 102 - Ensure partman_retention_test schema has been dropped 157s ok 103 - Ensure partman_basic role has been dropped 157s ok 104 - Ensure partman_revoke role has been dropped 157s ok 105 - Ensure partman_owner role has been dropped 157s ok 157s All tests successful. 157s Files=1, Tests=105, 60 wallclock secs ( 0.02 usr 0.00 sys + 0.03 cusr 0.01 csys = 0.06 CPU) 157s Result: PASS 157s Dropping cluster 17/regress ... 157s ### End 17 virtualenv ### 157s autopkgtest [15:45:05]: test prove: -----------------------] 158s autopkgtest [15:45:06]: test prove: - - - - - - - - - - results - - - - - - - - - - 158s prove PASS 158s autopkgtest [15:45:06]: test scripts: preparing testbed 258s autopkgtest [15:46:46]: testbed dpkg architecture: amd64 258s autopkgtest [15:46:46]: testbed apt version: 2.9.18 259s autopkgtest [15:46:47]: @@@@@@@@@@@@@@@@@@@@ test bed setup 259s autopkgtest [15:46:47]: testbed release detected to be: plucky 260s autopkgtest [15:46:48]: updating testbed package index (apt update) 260s Get:1 http://ftpmaster.internal/ubuntu plucky-proposed InRelease [73.9 kB] 260s Hit:2 http://ftpmaster.internal/ubuntu plucky InRelease 261s Hit:3 http://ftpmaster.internal/ubuntu plucky-updates InRelease 261s Hit:4 http://ftpmaster.internal/ubuntu plucky-security InRelease 261s Get:5 http://ftpmaster.internal/ubuntu plucky-proposed/multiverse Sources [17.3 kB] 261s Get:6 http://ftpmaster.internal/ubuntu plucky-proposed/universe Sources [820 kB] 261s Get:7 http://ftpmaster.internal/ubuntu plucky-proposed/restricted Sources [9708 B] 261s Get:8 http://ftpmaster.internal/ubuntu plucky-proposed/main Sources [127 kB] 261s Get:9 http://ftpmaster.internal/ubuntu plucky-proposed/main i386 Packages [169 kB] 261s Get:10 http://ftpmaster.internal/ubuntu plucky-proposed/main amd64 Packages [262 kB] 261s Get:11 http://ftpmaster.internal/ubuntu plucky-proposed/restricted i386 Packages [2408 B] 261s Get:12 http://ftpmaster.internal/ubuntu plucky-proposed/restricted amd64 Packages [40.1 kB] 261s Get:13 http://ftpmaster.internal/ubuntu plucky-proposed/universe i386 Packages [416 kB] 261s Get:14 http://ftpmaster.internal/ubuntu plucky-proposed/universe amd64 Packages [1026 kB] 261s Get:15 http://ftpmaster.internal/ubuntu plucky-proposed/multiverse amd64 Packages [23.7 kB] 261s Get:16 http://ftpmaster.internal/ubuntu plucky-proposed/multiverse i386 Packages [4028 B] 261s Fetched 2991 kB in 1s (2577 kB/s) 262s Reading package lists... 262s Reading package lists... 263s Building dependency tree... 263s Reading state information... 263s Calculating upgrade... 263s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 263s Reading package lists... 263s Building dependency tree... 263s Reading state information... 263s 0 upgraded, 0 newly installed, 0 to remove and 3 not upgraded. 263s autopkgtest [15:46:51]: upgrading testbed (apt dist-upgrade and autopurge) 264s Reading package lists... 264s Building dependency tree... 264s Reading state information... 264s Calculating upgrade...Starting pkgProblemResolver with broken count: 0 264s Starting 2 pkgProblemResolver with broken count: 0 264s Done 264s Entering ResolveByKeep 265s 265s The following packages were automatically installed and are no longer required: 265s python3.12 python3.12-minimal 265s Use 'sudo apt autoremove' to remove them. 265s The following NEW packages will be installed: 265s libpython3.13-minimal libpython3.13-stdlib python3.13 python3.13-minimal 265s The following packages will be upgraded: 265s libpython3-stdlib python3 python3-minimal 267s 3 upgraded, 4 newly installed, 0 to remove and 0 not upgraded. 267s Need to get 6118 kB of archives. 267s After this operation, 22.7 MB of additional disk space will be used. 267s Get:1 http://ftpmaster.internal/ubuntu plucky/main amd64 libpython3.13-minimal amd64 3.13.1-2 [881 kB] 267s Get:2 http://ftpmaster.internal/ubuntu plucky/main amd64 python3.13-minimal amd64 3.13.1-2 [2358 kB] 267s Get:3 http://ftpmaster.internal/ubuntu plucky-proposed/main amd64 python3-minimal amd64 3.13.1-1~exp2 [27.6 kB] 267s Get:4 http://ftpmaster.internal/ubuntu plucky-proposed/main amd64 python3 amd64 3.13.1-1~exp2 [23.9 kB] 267s Get:5 http://ftpmaster.internal/ubuntu plucky/main amd64 libpython3.13-stdlib amd64 3.13.1-2 [2088 kB] 267s Get:6 http://ftpmaster.internal/ubuntu plucky/main amd64 python3.13 amd64 3.13.1-2 [729 kB] 267s Get:7 http://ftpmaster.internal/ubuntu plucky-proposed/main amd64 libpython3-stdlib amd64 3.13.1-1~exp2 [10.2 kB] 268s Fetched 6118 kB in 3s (2259 kB/s) 268s Selecting previously unselected package libpython3.13-minimal:amd64. 268s (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 ... 75804 files and directories currently installed.) 268s Preparing to unpack .../libpython3.13-minimal_3.13.1-2_amd64.deb ... 268s Unpacking libpython3.13-minimal:amd64 (3.13.1-2) ... 268s Selecting previously unselected package python3.13-minimal. 268s Preparing to unpack .../python3.13-minimal_3.13.1-2_amd64.deb ... 268s Unpacking python3.13-minimal (3.13.1-2) ... 268s Setting up libpython3.13-minimal:amd64 (3.13.1-2) ... 268s Setting up python3.13-minimal (3.13.1-2) ... 269s (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 ... 76124 files and directories currently installed.) 269s Preparing to unpack .../python3-minimal_3.13.1-1~exp2_amd64.deb ... 269s Unpacking python3-minimal (3.13.1-1~exp2) over (3.12.8-1) ... 269s Setting up python3-minimal (3.13.1-1~exp2) ... 269s (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 ... 76124 files and directories currently installed.) 269s Preparing to unpack .../python3_3.13.1-1~exp2_amd64.deb ... 269s Unpacking python3 (3.13.1-1~exp2) over (3.12.8-1) ... 269s Selecting previously unselected package libpython3.13-stdlib:amd64. 269s Preparing to unpack .../libpython3.13-stdlib_3.13.1-2_amd64.deb ... 269s Unpacking libpython3.13-stdlib:amd64 (3.13.1-2) ... 269s Selecting previously unselected package python3.13. 269s Preparing to unpack .../python3.13_3.13.1-2_amd64.deb ... 269s Unpacking python3.13 (3.13.1-2) ... 269s Preparing to unpack .../libpython3-stdlib_3.13.1-1~exp2_amd64.deb ... 269s Unpacking libpython3-stdlib:amd64 (3.13.1-1~exp2) over (3.12.8-1) ... 269s Setting up libpython3.13-stdlib:amd64 (3.13.1-2) ... 269s Setting up libpython3-stdlib:amd64 (3.13.1-1~exp2) ... 269s Setting up python3.13 (3.13.1-2) ... 270s Setting up python3 (3.13.1-1~exp2) ... 270s /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. 270s for fn in glob1(directory, "%s.*" % fname): 270s Processing triggers for man-db (2.13.0-1) ... 271s Processing triggers for systemd (257-2ubuntu1) ... 271s Reading package lists... 273s Building dependency tree... 273s Reading state information... 273s Starting pkgProblemResolver with broken count: 0 273s Starting 2 pkgProblemResolver with broken count: 0 273s Done 273s The following packages will be REMOVED: 273s python3.12* python3.12-minimal* 273s 0 upgraded, 0 newly installed, 2 to remove and 0 not upgraded. 273s After this operation, 8926 kB disk space will be freed. 273s (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 ... 76541 files and directories currently installed.) 273s Removing python3.12 (3.12.8-3) ... 273s Removing python3.12-minimal (3.12.8-3) ... 273s /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. 273s for fn in glob1(directory, "%s.%s.py[co]" % (fname, magic_tag)): 273s Processing triggers for man-db (2.13.0-1) ... 274s Processing triggers for systemd (257-2ubuntu1) ... 274s (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 ... 76513 files and directories currently installed.) 274s Purging configuration files for python3.12-minimal (3.12.8-3) ... 278s Reading package lists... 278s Building dependency tree... 278s Reading state information... 279s Starting pkgProblemResolver with broken count: 0 279s Starting 2 pkgProblemResolver with broken count: 0 279s Done 279s The following NEW packages will be installed: 279s libjson-perl libpq5 libxslt1.1 postgresql-17 postgresql-17-partman 279s postgresql-client-17 postgresql-client-common postgresql-common 279s python3-psycopg2 ssl-cert 280s 0 upgraded, 10 newly installed, 0 to remove and 0 not upgraded. 280s Need to get 18.9 MB of archives. 280s After this operation, 63.7 MB of additional disk space will be used. 280s Get:1 http://ftpmaster.internal/ubuntu plucky/main amd64 libjson-perl all 4.10000-1 [81.9 kB] 280s Get:2 http://ftpmaster.internal/ubuntu plucky/main amd64 postgresql-client-common all 262 [36.7 kB] 280s Get:3 http://ftpmaster.internal/ubuntu plucky/main amd64 ssl-cert all 1.1.3ubuntu1 [18.7 kB] 280s Get:4 http://ftpmaster.internal/ubuntu plucky/main amd64 postgresql-common all 262 [162 kB] 280s Get:5 http://ftpmaster.internal/ubuntu plucky/main amd64 libpq5 amd64 17.2-1 [153 kB] 280s Get:6 http://ftpmaster.internal/ubuntu plucky/main amd64 libxslt1.1 amd64 1.1.39-0exp1ubuntu2 [175 kB] 280s Get:7 http://ftpmaster.internal/ubuntu plucky/main amd64 postgresql-client-17 amd64 17.2-1 [1405 kB] 281s Get:8 http://ftpmaster.internal/ubuntu plucky/main amd64 postgresql-17 amd64 17.2-1 [16.5 MB] 281s Get:9 http://ftpmaster.internal/ubuntu plucky/main amd64 python3-psycopg2 amd64 2.9.10-1 [146 kB] 281s Get:10 http://ftpmaster.internal/ubuntu plucky/universe amd64 postgresql-17-partman amd64 5.2.2-1 [228 kB] 281s Preconfiguring packages ... 281s Fetched 18.9 MB in 2s (9481 kB/s) 281s Selecting previously unselected package libjson-perl. 281s (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 ... 76513 files and directories currently installed.) 281s Preparing to unpack .../0-libjson-perl_4.10000-1_all.deb ... 281s Unpacking libjson-perl (4.10000-1) ... 281s Selecting previously unselected package postgresql-client-common. 281s Preparing to unpack .../1-postgresql-client-common_262_all.deb ... 281s Unpacking postgresql-client-common (262) ... 281s Selecting previously unselected package ssl-cert. 281s Preparing to unpack .../2-ssl-cert_1.1.3ubuntu1_all.deb ... 281s Unpacking ssl-cert (1.1.3ubuntu1) ... 281s Selecting previously unselected package postgresql-common. 281s Preparing to unpack .../3-postgresql-common_262_all.deb ... 281s Adding 'diversion of /usr/bin/pg_config to /usr/bin/pg_config.libpq-dev by postgresql-common' 281s Unpacking postgresql-common (262) ... 281s Selecting previously unselected package libpq5:amd64. 281s Preparing to unpack .../4-libpq5_17.2-1_amd64.deb ... 281s Unpacking libpq5:amd64 (17.2-1) ... 281s Selecting previously unselected package libxslt1.1:amd64. 281s Preparing to unpack .../5-libxslt1.1_1.1.39-0exp1ubuntu2_amd64.deb ... 281s Unpacking libxslt1.1:amd64 (1.1.39-0exp1ubuntu2) ... 282s Selecting previously unselected package postgresql-client-17. 282s Preparing to unpack .../6-postgresql-client-17_17.2-1_amd64.deb ... 282s Unpacking postgresql-client-17 (17.2-1) ... 282s Selecting previously unselected package postgresql-17. 282s Preparing to unpack .../7-postgresql-17_17.2-1_amd64.deb ... 282s Unpacking postgresql-17 (17.2-1) ... 282s Selecting previously unselected package python3-psycopg2. 282s Preparing to unpack .../8-python3-psycopg2_2.9.10-1_amd64.deb ... 282s Unpacking python3-psycopg2 (2.9.10-1) ... 282s Selecting previously unselected package postgresql-17-partman. 282s Preparing to unpack .../9-postgresql-17-partman_5.2.2-1_amd64.deb ... 282s Unpacking postgresql-17-partman (5.2.2-1) ... 282s Setting up postgresql-client-common (262) ... 282s Setting up libpq5:amd64 (17.2-1) ... 282s Setting up ssl-cert (1.1.3ubuntu1) ... 282s Created symlink '/etc/systemd/system/multi-user.target.wants/ssl-cert.service' → '/usr/lib/systemd/system/ssl-cert.service'. 283s Setting up python3-psycopg2 (2.9.10-1) ... 284s Setting up libjson-perl (4.10000-1) ... 284s Setting up libxslt1.1:amd64 (1.1.39-0exp1ubuntu2) ... 284s Setting up postgresql-client-17 (17.2-1) ... 284s 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 284s Setting up postgresql-common (262) ... 284s Creating config file /etc/postgresql-common/createcluster.conf with new version 284s Building PostgreSQL dictionaries from installed myspell/hunspell packages... 284s Removing obsolete dictionary files: 284s Created symlink '/etc/systemd/system/multi-user.target.wants/postgresql.service' → '/usr/lib/systemd/system/postgresql.service'. 284s Setting up postgresql-17 (17.2-1) ... 285s Creating new PostgreSQL cluster 17/main ... 285s /usr/lib/postgresql/17/bin/initdb -D /var/lib/postgresql/17/main --auth-local peer --auth-host scram-sha-256 --no-instructions 285s The files belonging to this database system will be owned by user "postgres". 285s This user must also own the server process. 285s 285s The database cluster will be initialized with locale "C.UTF-8". 285s The default database encoding has accordingly been set to "UTF8". 285s The default text search configuration will be set to "english". 285s 285s Data page checksums are disabled. 285s 285s fixing permissions on existing directory /var/lib/postgresql/17/main ... ok 285s creating subdirectories ... ok 285s selecting dynamic shared memory implementation ... posix 285s selecting default "max_connections" ... 100 285s selecting default "shared_buffers" ... 128MB 285s selecting default time zone ... Etc/UTC 285s creating configuration files ... ok 285s running bootstrap script ... ok 285s performing post-bootstrap initialization ... ok 285s syncing data to disk ... ok 289s Setting up postgresql-17-partman (5.2.2-1) ... 289s Processing triggers for man-db (2.13.0-1) ... 290s Processing triggers for libc-bin (2.40-4ubuntu1) ... 296s autopkgtest [15:47:24]: test scripts: [----------------------- 296s + /usr/lib/postgresql/17/bin/check_unique_constraint.py --help 296s usage: check_unique_constraint.py [-h] [-p PARENT] [-l COLUMN_LIST] 296s [-c CONNECTION] [-t TEMP] [--psql PSQL] 296s [--simple] [--index_scan] [-q] [--version] 296s 296s This script is used to check that all rows in a partition set are unique for 296s the given columns. Since unique constraints are not applied across partition 296s sets, this cannot be enforced within the database. This script can be used as 296s a monitor to ensure uniquness. If any unique violations are found, the values, 296s along with a count of each, are output. 296s 296s options: 296s -h, --help show this help message and exit 296s -p, --parent PARENT Parent table of the partition set to be checked 296s -l, --column_list COLUMN_LIST 296s Comma separated list of columns that make up the 296s unique constraint to be checked 296s -c, --connection CONNECTION 296s Connection string for use by psycopg. Defaults to 296s "host=" (local socket). 296s -t, --temp TEMP Path to a writable folder that can be used for temp 296s working files. Defaults system temp folder. 296s --psql PSQL Full path to psql binary if not in current PATH 296s --simple Output a single integer value with the total duplicate 296s count. Use this for monitoring software that requires 296s a simple value to be checked for. 296s --index_scan By default index scans are disabled to force the 296s script to check the actual table data with sequential 296s scans. Set this option if you want the script to allow 296s index scans to be used (does not guarentee that they 296s will be used). 296s -q, --quiet Suppress all output unless there is a constraint 296s violation found. 296s --version Print out the minimum version of pg_partman this 296s script is meant to work with. The version of 296s pg_partman installed may be greater than this. 296s + /usr/lib/postgresql/17/bin/dump_partition.py --help 296s usage: dump_partition.py [-h] [-n SCHEMA] [-c CONNECTION] [-o OUTPUT] 296s [-d DUMP_DATABASE] [--dump_host DUMP_HOST] 296s [--dump_username DUMP_USERNAME] 296s [--dump_port DUMP_PORT] [--pg_dump_path PG_DUMP_PATH] 296s [--Fp] [--nohashfile] [--nodrop] [-v] [--version] 296s 296s This script will dump out and then drop all tables contained in the designated 296s schema using pg_dump. Each table will be in its own separate file along with a 296s SHA-512 hash of the dump file. Tables are not dropped from the database if 296s pg_dump does not return successfully. All dump_* option defaults are the same 296s as they would be for pg_dump if they are not given. 296s 296s options: 296s -h, --help show this help message and exit 296s -n, --schema SCHEMA (Required) The schema that contains the tables that 296s will be dumped. 296s -c, --connection CONNECTION 296s Connection string for use by psycopg. Role used must 296s be able to select pg_catalog.pg_tables in the relevant 296s database and drop all tables in the given schema. 296s Defaults to "host=" (local socket). Note this is 296s distinct from the parameters sent to pg_dump. 296s -o, --output OUTPUT Path to dump file output location. Default is where 296s the script is run from. 296s -d, --dump_database DUMP_DATABASE 296s Used for pg_dump, same as its --dbname (-d) option or 296s final database name parameter. 296s --dump_host DUMP_HOST 296s Used for pg_dump, same as its --host (-h) option. 296s --dump_username DUMP_USERNAME 296s Used for pg_dump, same as its --username (-U) option. 296s --dump_port DUMP_PORT 296s Used for pg_dump, same as its --port (-p) option. 296s --pg_dump_path PG_DUMP_PATH 296s Path to pg_dump binary location. Must set if not in 296s current PATH. 296s --Fp Dump using pg_dump plain text format. Default is 296s binary custom (-Fc). 296s --nohashfile Do NOT create a separate file with the SHA-512 hash of 296s the dump. If dump files are very large, hash 296s generation can possibly take a long time. 296s --nodrop Do NOT drop the tables from the given schema after 296s dumping/hashing. 296s -v, --verbose Provide more verbose output. 296s --version Print out the minimum version of pg_partman this 296s script is meant to work with. The version of 296s pg_partman installed may be greater than this. 296s 296s NOTE: The connection options for psyocpg and pg_dump were separated out due to 296s distinct differences in their requirements depending on your database 296s connection configuration. 296s + /usr/lib/postgresql/17/bin/vacuum_maintenance.py --help 296s usage: vacuum_maintenance.py [-h] [-p PARENT] [--all] [-c CONNECTION] [-z] 296s [-f] [-a VACUUM_FREEZE_MIN_AGE] [-t {time,id}] 296s [-i INTERVAL] [--noparent] [--dryrun] [-q] 296s [--version] [--debug] 296s 296s Script for performing additional vacuum maintenance on the child tables of a 296s partition set in order to avoid excess vacuuming and transaction id wraparound 296s issues. Whether a table is vacuumed or not by this script depends on whether 296s its age(relfrozenxid) is greater than vacuum_freeze_min_age. This ensures 296s repeated runs of this script do not re-vacuum tables that have already had all 296s of their page tuples frozen. This script does not require pg_partman to be 296s installed and will work on any inheritance set given a parent table, as long 296s as the options --all, --type or --interval are NOT set. 296s 296s options: 296s -h, --help show this help message and exit 296s -p, --parent PARENT Parent table of an already created 296s partition/inheritance set. Either this option or --all 296s is required. 296s --all Run against all tables managed by pg_partman. Either 296s this option or -p is required. Overrides -p if both 296s are set. 296s -c, --connection CONNECTION 296s Connection string for use by psycopg. Defaults to 296s "host=" (local socket). 296s -z, --freeze Sets the FREEZE option to the VACUUM command. 296s -f, --full Sets the FULL option to the VACUUM command. Note that 296s --freeze is not necessary if you set this. Recommend 296s reviewing --dryrun before running this since it will 296s lock all tables it runs against, possibly including 296s the parent. 296s -a, --vacuum_freeze_min_age VACUUM_FREEZE_MIN_AGE 296s By default the script obtains this value from the 296s system catalogs. By setting this, you can override the 296s value obtained from the database. Note this does not 296s change the value in the database, only the value this 296s script uses. 296s -t, --type {time,id} Tells the script whether the value given by --interval 296s is either time or id based. Also, if --all is set, 296s limits the partition sets that the script runs against 296s to just those types. Valid values are: "id" and 296s "time". 296s -i, --interval INTERVAL 296s In addition to checking transaction age, only run 296s against tables that are older than the interval given. 296s Takes either a postgresql time interval or integer 296s value. For time-based partitioning, uses the time that 296s script is run as baseline. For id-based partitioning, 296s the integer value will set that any partitions with an 296s id value less than the current maximum id value minus 296s the given value will be vacuumed. For example, if the 296s current max id is 100 and the given value is 30, any 296s partitions with id values less than 70 will be 296s vacuumed. The current maximum id value at the time the 296s script is run is always used. 296s --noparent Normally the parent table is included in the list of 296s tables to vacuum if its age(relfrozenxid) is higher 296s than vacuum_freeze_min_age. Set this to force 296s exclusion of the parent table, even if it meets that 296s criteria. 296s --dryrun Show what the script will do without actually running 296s it against the database. Highly recommend reviewing 296s this before running for the first time. 296s -q, --quiet Turn off all output. 296s --version Print out the minimum version of pg_partman this 296s script is meant to work with. The version of 296s pg_partman installed may be greater than this. 296s --debug Show additional debugging output 297s autopkgtest [15:47:25]: test scripts: -----------------------] 297s scripts PASS 297s autopkgtest [15:47:25]: test scripts: - - - - - - - - - - results - - - - - - - - - - 298s autopkgtest [15:47:26]: @@@@@@@@@@@@@@@@@@@@ summary 298s prove PASS 298s scripts PASS 314s nova [W] Skipping flock for amd64 314s Creating nova instance adt-plucky-amd64-pg-partman-20250108-154228-juju-7f2275-prod-proposed-migration-environment-20-831eb23f-410d-4ec7-846a-16d99f550878 from image adt/ubuntu-plucky-amd64-server-20250108.img (UUID 99ddef43-3911-4ae7-933a-ef999fcbb876)... 314s nova [W] Timed out waiting for 0c323ca1-7933-40df-adc9-86d1cab2fafa to get deleted. 314s nova [W] Skipping flock for amd64 314s Creating nova instance adt-plucky-amd64-pg-partman-20250108-154228-juju-7f2275-prod-proposed-migration-environment-20-831eb23f-410d-4ec7-846a-16d99f550878 from image adt/ubuntu-plucky-amd64-server-20250108.img (UUID 99ddef43-3911-4ae7-933a-ef999fcbb876)... 314s nova [W] Timed out waiting for 50af31e5-1ec9-4187-966e-f19075344e6c to get deleted.