0s autopkgtest [06:57:41]: starting date and time: 2025-02-22 06:57:41+0000 0s autopkgtest [06:57:41]: git checkout: 325255d2 Merge branch 'pin-any-arch' into 'ubuntu/production' 0s autopkgtest [06:57:41]: host juju-7f2275-prod-proposed-migration-environment-2; command line: /home/ubuntu/autopkgtest/runner/autopkgtest --output-dir /tmp/autopkgtest-work.ids4h__t/out --timeout-copy=6000 --setup-commands /home/ubuntu/autopkgtest-cloud/worker-config-production/setup-canonical.sh --apt-pocket=proposed=src:postgresql-17 --apt-upgrade pg-partman --timeout-short=300 --timeout-copy=20000 --timeout-build=20000 --env=ADT_TEST_TRIGGERS=postgresql-17/17.4-1 -- ssh -s /home/ubuntu/autopkgtest/ssh-setup/nova -- --flavor autopkgtest-ppc64el --security-groups autopkgtest-juju-7f2275-prod-proposed-migration-environment-2@bos03-ppc64el-15.secgroup --name adt-plucky-ppc64el-pg-partman-20250222-065741-juju-7f2275-prod-proposed-migration-environment-2-169403d7-da84-48a8-98bd-f3fc90434af8 --image adt/ubuntu-plucky-ppc64el-server --keyname testbed-juju-7f2275-prod-proposed-migration-environment-2 --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/ 95s autopkgtest [06:59:16]: testbed dpkg architecture: ppc64el 95s autopkgtest [06:59:16]: testbed apt version: 2.9.30ubuntu1 95s autopkgtest [06:59:16]: @@@@@@@@@@@@@@@@@@@@ test bed setup 96s autopkgtest [06:59:17]: testbed release detected to be: None 96s autopkgtest [06:59:17]: updating testbed package index (apt update) 97s Get:1 http://ftpmaster.internal/ubuntu plucky-proposed InRelease [110 kB] 97s Hit:2 http://ftpmaster.internal/ubuntu plucky InRelease 97s Hit:3 http://ftpmaster.internal/ubuntu plucky-updates InRelease 97s Hit:4 http://ftpmaster.internal/ubuntu plucky-security InRelease 97s Get:5 http://ftpmaster.internal/ubuntu plucky-proposed/universe Sources [504 kB] 97s Get:6 http://ftpmaster.internal/ubuntu plucky-proposed/restricted Sources [3120 B] 97s Get:7 http://ftpmaster.internal/ubuntu plucky-proposed/main Sources [80.9 kB] 97s Get:8 http://ftpmaster.internal/ubuntu plucky-proposed/multiverse Sources [13.5 kB] 97s Get:9 http://ftpmaster.internal/ubuntu plucky-proposed/main ppc64el Packages [127 kB] 97s Get:10 http://ftpmaster.internal/ubuntu plucky-proposed/restricted ppc64el Packages [760 B] 97s Get:11 http://ftpmaster.internal/ubuntu plucky-proposed/universe ppc64el Packages [432 kB] 97s Get:12 http://ftpmaster.internal/ubuntu plucky-proposed/multiverse ppc64el Packages [3292 B] 97s Fetched 1276 kB in 1s (1386 kB/s) 98s Reading package lists... 99s Reading package lists... 99s Building dependency tree... 99s Reading state information... 100s Calculating upgrade... 100s Calculating upgrade... 100s The following packages will be upgraded: 100s curl libcurl3t64-gnutls libcurl4t64 100s 3 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 100s Need to get 1221 kB of archives. 100s After this operation, 3072 B disk space will be freed. 100s Get:1 http://ftpmaster.internal/ubuntu plucky/main ppc64el curl ppc64el 8.12.1-2ubuntu1 [258 kB] 101s Get:2 http://ftpmaster.internal/ubuntu plucky/main ppc64el libcurl4t64 ppc64el 8.12.1-2ubuntu1 [482 kB] 101s Get:3 http://ftpmaster.internal/ubuntu plucky/main ppc64el libcurl3t64-gnutls ppc64el 8.12.1-2ubuntu1 [481 kB] 101s Fetched 1221 kB in 1s (1976 kB/s) 102s (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 ... 106371 files and directories currently installed.) 102s Preparing to unpack .../curl_8.12.1-2ubuntu1_ppc64el.deb ... 102s Unpacking curl (8.12.1-2ubuntu1) over (8.12.0+git20250209.89ed161+ds-1ubuntu1) ... 102s Preparing to unpack .../libcurl4t64_8.12.1-2ubuntu1_ppc64el.deb ... 102s Unpacking libcurl4t64:ppc64el (8.12.1-2ubuntu1) over (8.12.0+git20250209.89ed161+ds-1ubuntu1) ... 102s Preparing to unpack .../libcurl3t64-gnutls_8.12.1-2ubuntu1_ppc64el.deb ... 102s Unpacking libcurl3t64-gnutls:ppc64el (8.12.1-2ubuntu1) over (8.12.0+git20250209.89ed161+ds-1ubuntu1) ... 102s Setting up libcurl4t64:ppc64el (8.12.1-2ubuntu1) ... 102s Setting up libcurl3t64-gnutls:ppc64el (8.12.1-2ubuntu1) ... 102s Setting up curl (8.12.1-2ubuntu1) ... 102s Processing triggers for man-db (2.13.0-1) ... 102s Processing triggers for libc-bin (2.40-4ubuntu1) ... 102s Reading package lists... 103s Building dependency tree... 103s Reading state information... 103s Solving dependencies... 103s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 103s autopkgtest [06:59:24]: upgrading testbed (apt dist-upgrade and autopurge) 103s Reading package lists... 103s Building dependency tree... 103s Reading state information... 104s Calculating upgrade...Starting pkgProblemResolver with broken count: 0 104s Starting 2 pkgProblemResolver with broken count: 0 104s Done 104s Entering ResolveByKeep 104s 104s Calculating upgrade... 104s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 105s Reading package lists... 105s Building dependency tree... 105s Reading state information... 105s Starting pkgProblemResolver with broken count: 0 105s Starting 2 pkgProblemResolver with broken count: 0 105s Done 105s Solving dependencies... 105s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 108s autopkgtest [06:59:29]: testbed running kernel: Linux 6.12.0-15-generic #15-Ubuntu SMP Tue Feb 4 16:32:08 UTC 2025 108s autopkgtest [06:59:29]: @@@@@@@@@@@@@@@@@@@@ apt-source pg-partman 110s Get:1 http://ftpmaster.internal/ubuntu plucky/universe pg-partman 5.2.4-1 (dsc) [2307 B] 110s Get:2 http://ftpmaster.internal/ubuntu plucky/universe pg-partman 5.2.4-1 (tar) [1254 kB] 110s Get:3 http://ftpmaster.internal/ubuntu plucky/universe pg-partman 5.2.4-1 (diff) [4268 B] 110s gpgv: Signature made Wed Jan 8 09:02:38 2025 UTC 110s gpgv: using RSA key 5C48FE6157F49179597087C64C5A6BAB12D2A7AE 110s gpgv: Can't check signature: No public key 110s dpkg-source: warning: cannot verify inline signature for ./pg-partman_5.2.4-1.dsc: no acceptable signature found 111s autopkgtest [06:59:32]: testing package pg-partman version 5.2.4-1 111s autopkgtest [06:59:32]: build not needed 112s autopkgtest [06:59:33]: test prove: preparing testbed 112s Reading package lists... 112s Building dependency tree... 112s Reading state information... 112s Starting pkgProblemResolver with broken count: 0 113s Starting 2 pkgProblemResolver with broken count: 0 113s Done 113s The following NEW packages will be installed: 113s libio-pty-perl libipc-run-perl libjson-perl libllvm20 libpq5 113s libtap-parser-sourcehandler-pgtap-perl libxslt1.1 postgresql-17 113s postgresql-17-partman postgresql-17-pgtap postgresql-client-17 113s postgresql-client-common postgresql-common postgresql-common-dev 113s python3-psycopg2 ssl-cert 113s 0 upgraded, 16 newly installed, 0 to remove and 0 not upgraded. 113s Need to get 51.9 MB of archives. 113s After this operation, 232 MB of additional disk space will be used. 113s Get:1 http://ftpmaster.internal/ubuntu plucky/main ppc64el libjson-perl all 4.10000-1 [81.9 kB] 113s Get:2 http://ftpmaster.internal/ubuntu plucky/main ppc64el postgresql-client-common all 273 [47.5 kB] 113s Get:3 http://ftpmaster.internal/ubuntu plucky/main ppc64el libio-pty-perl ppc64el 1:1.20-1build3 [32.0 kB] 113s Get:4 http://ftpmaster.internal/ubuntu plucky/main ppc64el libipc-run-perl all 20231003.0-2 [91.5 kB] 113s Get:5 http://ftpmaster.internal/ubuntu plucky/main ppc64el postgresql-common-dev all 273 [72.9 kB] 113s Get:6 http://ftpmaster.internal/ubuntu plucky/main ppc64el ssl-cert all 1.1.3ubuntu1 [18.7 kB] 113s Get:7 http://ftpmaster.internal/ubuntu plucky/main ppc64el postgresql-common all 273 [101 kB] 113s Get:8 http://ftpmaster.internal/ubuntu plucky/main ppc64el libllvm20 ppc64el 1:20.1.0~+rc2-1~exp2ubuntu0.4 [31.9 MB] 115s Get:9 http://ftpmaster.internal/ubuntu plucky-proposed/main ppc64el libpq5 ppc64el 17.4-1 [174 kB] 115s Get:10 http://ftpmaster.internal/ubuntu plucky/main ppc64el libxslt1.1 ppc64el 1.1.39-0exp1ubuntu2 [191 kB] 115s Get:11 http://ftpmaster.internal/ubuntu plucky-proposed/main ppc64el postgresql-client-17 ppc64el 17.4-1 [1482 kB] 115s Get:12 http://ftpmaster.internal/ubuntu plucky-proposed/main ppc64el postgresql-17 ppc64el 17.4-1 [17.2 MB] 115s Get:13 http://ftpmaster.internal/ubuntu plucky/main ppc64el python3-psycopg2 ppc64el 2.9.10-1 [160 kB] 115s Get:14 http://ftpmaster.internal/ubuntu plucky/universe ppc64el postgresql-17-partman ppc64el 5.2.4-1 [230 kB] 115s Get:15 http://ftpmaster.internal/ubuntu plucky/universe ppc64el postgresql-17-pgtap all 1.3.3-3 [45.6 kB] 115s Get:16 http://ftpmaster.internal/ubuntu plucky/universe ppc64el libtap-parser-sourcehandler-pgtap-perl all 3.36-2 [35.2 kB] 115s Preconfiguring packages ... 115s Fetched 51.9 MB in 2s (23.5 MB/s) 115s Selecting previously unselected package libjson-perl. 115s (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 ... 106371 files and directories currently installed.) 115s Preparing to unpack .../00-libjson-perl_4.10000-1_all.deb ... 115s Unpacking libjson-perl (4.10000-1) ... 115s Selecting previously unselected package postgresql-client-common. 115s Preparing to unpack .../01-postgresql-client-common_273_all.deb ... 115s Unpacking postgresql-client-common (273) ... 115s Selecting previously unselected package libio-pty-perl. 115s Preparing to unpack .../02-libio-pty-perl_1%3a1.20-1build3_ppc64el.deb ... 115s Unpacking libio-pty-perl (1:1.20-1build3) ... 115s Selecting previously unselected package libipc-run-perl. 115s Preparing to unpack .../03-libipc-run-perl_20231003.0-2_all.deb ... 115s Unpacking libipc-run-perl (20231003.0-2) ... 116s Selecting previously unselected package postgresql-common-dev. 116s Preparing to unpack .../04-postgresql-common-dev_273_all.deb ... 116s Unpacking postgresql-common-dev (273) ... 116s Selecting previously unselected package ssl-cert. 116s Preparing to unpack .../05-ssl-cert_1.1.3ubuntu1_all.deb ... 116s Unpacking ssl-cert (1.1.3ubuntu1) ... 116s Selecting previously unselected package postgresql-common. 116s Preparing to unpack .../06-postgresql-common_273_all.deb ... 116s Adding 'diversion of /usr/bin/pg_config to /usr/bin/pg_config.libpq-dev by postgresql-common' 116s Unpacking postgresql-common (273) ... 116s Selecting previously unselected package libllvm20:ppc64el. 116s Preparing to unpack .../07-libllvm20_1%3a20.1.0~+rc2-1~exp2ubuntu0.4_ppc64el.deb ... 116s Unpacking libllvm20:ppc64el (1:20.1.0~+rc2-1~exp2ubuntu0.4) ... 116s Selecting previously unselected package libpq5:ppc64el. 116s Preparing to unpack .../08-libpq5_17.4-1_ppc64el.deb ... 116s Unpacking libpq5:ppc64el (17.4-1) ... 116s Selecting previously unselected package libxslt1.1:ppc64el. 116s Preparing to unpack .../09-libxslt1.1_1.1.39-0exp1ubuntu2_ppc64el.deb ... 116s Unpacking libxslt1.1:ppc64el (1.1.39-0exp1ubuntu2) ... 116s Selecting previously unselected package postgresql-client-17. 116s Preparing to unpack .../10-postgresql-client-17_17.4-1_ppc64el.deb ... 116s Unpacking postgresql-client-17 (17.4-1) ... 116s Selecting previously unselected package postgresql-17. 116s Preparing to unpack .../11-postgresql-17_17.4-1_ppc64el.deb ... 116s Unpacking postgresql-17 (17.4-1) ... 117s Selecting previously unselected package python3-psycopg2. 117s Preparing to unpack .../12-python3-psycopg2_2.9.10-1_ppc64el.deb ... 117s Unpacking python3-psycopg2 (2.9.10-1) ... 117s Selecting previously unselected package postgresql-17-partman. 117s Preparing to unpack .../13-postgresql-17-partman_5.2.4-1_ppc64el.deb ... 117s Unpacking postgresql-17-partman (5.2.4-1) ... 117s Selecting previously unselected package postgresql-17-pgtap. 117s Preparing to unpack .../14-postgresql-17-pgtap_1.3.3-3_all.deb ... 117s Unpacking postgresql-17-pgtap (1.3.3-3) ... 117s Selecting previously unselected package libtap-parser-sourcehandler-pgtap-perl. 117s Preparing to unpack .../15-libtap-parser-sourcehandler-pgtap-perl_3.36-2_all.deb ... 117s Unpacking libtap-parser-sourcehandler-pgtap-perl (3.36-2) ... 117s Setting up postgresql-client-common (273) ... 117s Setting up libtap-parser-sourcehandler-pgtap-perl (3.36-2) ... 117s Setting up libio-pty-perl (1:1.20-1build3) ... 117s Setting up libpq5:ppc64el (17.4-1) ... 117s Setting up ssl-cert (1.1.3ubuntu1) ... 117s Created symlink '/etc/systemd/system/multi-user.target.wants/ssl-cert.service' → '/usr/lib/systemd/system/ssl-cert.service'. 118s Setting up libllvm20:ppc64el (1:20.1.0~+rc2-1~exp2ubuntu0.4) ... 118s Setting up python3-psycopg2 (2.9.10-1) ... 118s Setting up libipc-run-perl (20231003.0-2) ... 118s Setting up libjson-perl (4.10000-1) ... 118s Setting up libxslt1.1:ppc64el (1.1.39-0exp1ubuntu2) ... 118s Setting up postgresql-common-dev (273) ... 118s Setting up postgresql-client-17 (17.4-1) ... 118s 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 118s Setting up postgresql-common (273) ... 119s Creating config file /etc/postgresql-common/createcluster.conf with new version 119s Building PostgreSQL dictionaries from installed myspell/hunspell packages... 119s Removing obsolete dictionary files: 120s Created symlink '/etc/systemd/system/multi-user.target.wants/postgresql.service' → '/usr/lib/systemd/system/postgresql.service'. 120s Setting up postgresql-17 (17.4-1) ... 121s Creating new PostgreSQL cluster 17/main ... 121s /usr/lib/postgresql/17/bin/initdb -D /var/lib/postgresql/17/main --auth-local peer --auth-host scram-sha-256 --no-instructions 121s The files belonging to this database system will be owned by user "postgres". 121s This user must also own the server process. 121s 121s The database cluster will be initialized with locale "C.UTF-8". 121s The default database encoding has accordingly been set to "UTF8". 121s The default text search configuration will be set to "english". 121s 121s Data page checksums are disabled. 121s 121s fixing permissions on existing directory /var/lib/postgresql/17/main ... ok 121s creating subdirectories ... ok 121s selecting dynamic shared memory implementation ... posix 121s selecting default "max_connections" ... 100 121s selecting default "shared_buffers" ... 128MB 121s selecting default time zone ... Etc/UTC 121s creating configuration files ... ok 121s running bootstrap script ... ok 122s performing post-bootstrap initialization ... ok 122s syncing data to disk ... ok 125s Setting up postgresql-17-pgtap (1.3.3-3) ... 125s Setting up postgresql-17-partman (5.2.4-1) ... 125s Processing triggers for man-db (2.13.0-1) ... 126s Processing triggers for libc-bin (2.40-4ubuntu1) ... 127s autopkgtest [06:59:48]: test prove: [----------------------- 127s ### PostgreSQL 17 virtualenv ### 127s Creating new PostgreSQL cluster 17/regress ... 131s + psql -c 'CREATE EXTENSION pgtap' 131s CREATE EXTENSION 131s + psql -c 'CREATE EXTENSION pg_partman' 131s CREATE EXTENSION 131s + pg_prove -ovf test/test-id-10.sql 131s Duplicate specification "psql-bin|b=s" for option "b" 131s Duplicate specification "host|h=s" for option "h" 131s Duplicate specification "port|p=s" for option "p" 131s Duplicate specification "pset|P=s%" for option "P" 131s Duplicate specification "schema|s=s" for option "s" 131s Duplicate specification "version|V" for option "version" 131s Duplicate specification "version|V" for option "V" 131s Duplicate specification "help|H|?" for option "help" 131s Duplicate specification "help|H|?" for option "H" 131s Duplicate specification "help|H|?" for option "?" 131s Duplicate specification "man|m" for option "man" 131s Duplicate specification "man|m" for option "m" 132s psql:test/test-id-10.sql:208: NOTICE: Moved 11 row(s) to the target table. Removed 1 partitions. 132s psql:test/test-id-10.sql:211: NOTICE: Moved 10 row(s) to the target table. Removed 1 partitions. 132s psql:test/test-id-10.sql:215: NOTICE: Moved 9 row(s) to the target table. Removed 5 partitions. 132s test/test-id-10.sql .. 132s partman, public 132s 1..135 132s t 132s ok 1 - Check id_taptest_table_p3000000000 exists 132s ok 2 - Check id_taptest_table_p3000000010 exists 132s ok 3 - Check id_taptest_table_p3000000020 exists 132s ok 4 - Check id_taptest_table_p3000000030 exists 132s ok 5 - Check id_taptest_table_p3000000040 exists 132s ok 6 - Check id_taptest_table_default exists 132s ok 7 - Check id_taptest_table_p3000000050 doesn't exists yet 132s ok 8 - Check for primary key in id_taptest_table_p3000000000 132s ok 9 - Check for primary key in id_taptest_table_p3000000010 132s ok 10 - Check for primary key in id_taptest_table_p3000000020 132s ok 11 - Check for primary key in id_taptest_table_p3000000030 132s ok 12 - Check for primary key in id_taptest_table_p3000000040 132s ok 13 - Check for primary key in id_taptest_table_default 132s ok 14 - Check that foreign key was inherited to id_taptest_table_p3000000000 132s ok 15 - Check that foreign key was inherited to id_taptest_table_p3000000010 132s ok 16 - Check that foreign key was inherited to id_taptest_table_p3000000020 132s ok 17 - Check that foreign key was inherited to id_taptest_table_p3000000030 132s ok 18 - Check that foreign key was inherited to id_taptest_table_p3000000040 132s ok 19 - Check that foreign key was inherited to id_taptest_table_default 132s ok 20 - Check that unique index was inherited to id_taptest_table_p3000000000 132s ok 21 - Check that unique index was inherited to id_taptest_table_p3000000010 132s ok 22 - Check that unique index was inherited to id_taptest_table_p3000000020 132s ok 23 - Check that unique index was inherited to id_taptest_table_p3000000030 132s ok 24 - Check that unique index was inherited to id_taptest_table_p3000000040 132s ok 25 - Check that unique index was inherited to id_taptest_table_default 132s ok 26 - Check partman_basic privileges of id_taptest_table_p3000000000 132s ok 27 - Check partman_basic privileges of id_taptest_table_p3000000010 132s ok 28 - Check partman_basic privileges of id_taptest_table_p3000000020 132s ok 29 - Check partman_basic privileges of id_taptest_table_p3000000030 132s ok 30 - Check partman_basic privileges of id_taptest_table_p3000000040 132s ok 31 - Check partman_basic privileges of id_taptest_table_default 132s ok 32 - Check partman_revoke privileges of id_taptest_table_p3000000000 132s ok 33 - Check partman_revoke privileges of id_taptest_table_p3000000010 132s ok 34 - Check partman_revoke privileges of id_taptest_table_p3000000020 132s ok 35 - Check partman_revoke privileges of id_taptest_table_p3000000030 132s ok 36 - Check partman_revoke privileges of id_taptest_table_p3000000040 132s ok 37 - Check partman_revoke privileges of id_taptest_table_default 132s ok 38 - Check that parent table is unlogged 132s ok 39 - Check that id_taptest_table_p3000000000 is unlogged 132s ok 40 - Check that id_taptest_table_p3000000010 is unlogged 132s ok 41 - Check that id_taptest_table_p3000000020 is unlogged 132s ok 42 - Check that id_taptest_table_p3000000030 is unlogged 132s ok 43 - Check that id_taptest_table_p3000000040 is unlogged 132s ok 44 - Check that id_taptest_table_default is unlogged 132s ok 45 - Check that default table has no data 132s ok 46 - Check count from parent table 132s ok 47 - Check count from id_taptest_table_p3000000000 132s ok 48 - Check that parent table has had no data inserted to it 132s ok 49 - Check count from id_taptest_table_p3000000010 132s ok 50 - Check count from id_taptest_table_p3000000020 132s ok 51 - Check id_taptest_table_p3000000050 exists 132s ok 52 - Check that id_taptest_table_p3000000050 is unlogged 132s ok 53 - Check id_taptest_table_p3000000060 exists yet 132s ok 54 - Check that id_taptest_table_p3000000060 is unlogged 132s ok 55 - Check id_taptest_table_p3000000070 doesn't exists yet 132s ok 56 - Check for primary key in id_taptest_table_p3000000050 132s ok 57 - Check that foreign key was inherited to id_taptest_table_p3000000050 132s ok 58 - Check partman_basic privileges of id_taptest_table_p3000000000 132s ok 59 - Check partman_basic privileges of id_taptest_table_p3000000010 132s ok 60 - Check partman_basic privileges of id_taptest_table_p3000000020 132s ok 61 - Check partman_basic privileges of id_taptest_table_p3000000030 132s ok 62 - Check partman_basic privileges of id_taptest_table_p3000000040 132s ok 63 - Check partman_basic privileges of id_taptest_table_p3000000050 132s ok 64 - Check partman_revoke privileges of id_taptest_table_p3000000050 132s ok 65 - Check partman_basic privileges of id_taptest_table_p3000000060 132s ok 66 - Check partman_revoke privileges of id_taptest_table_p3000000060 132s ok 67 - Check that parent table has had no data inserted to it 132s ok 68 - Check count from id_taptest_table 132s ok 69 - Check count from id_taptest_table_p3000000020 132s ok 70 - Check count from id_taptest_table_p3000000030 132s ok 71 - Check id_taptest_table_p3000000070 exists 132s ok 72 - Check that id_taptest_table_p3000000070 is unlogged 132s ok 73 - Check id_taptest_table_p3000000080 doesn't exists yet 132s ok 74 - Check for primary key in id_taptest_table_p3000000060 132s ok 75 - Check for primary key in id_taptest_table_p3000000070 132s ok 76 - Check that foreign key was inherited to id_taptest_table_p3000000060 132s ok 77 - Check that foreign key was inherited to id_taptest_table_p3000000070 132s ok 78 - Check partman_basic privileges of id_taptest_table_p3000000000 132s ok 79 - Check partman_basic privileges of id_taptest_table_p3000000010 132s ok 80 - Check partman_basic privileges of id_taptest_table_p3000000020 132s ok 81 - Check partman_basic privileges of id_taptest_table_p3000000030 132s ok 82 - Check partman_basic privileges of id_taptest_table_p3000000040 132s ok 83 - Check partman_basic privileges of id_taptest_table_default 132s ok 84 - Check partman_basic privileges of id_taptest_table_p3000000050 132s ok 85 - Check partman_revoke privileges of id_taptest_table_p3000000050 132s ok 86 - Check partman_basic privileges of id_taptest_table_p3000000060 132s ok 87 - Check partman_revoke privileges of id_taptest_table_p3000000060 132s ok 88 - Check partman_basic privileges of id_taptest_table_p3000000070 132s ok 89 - Check that ownership change worked for id_taptest_table_p3000000070 132s ok 90 - Check partman_revoke has no privileges on id_taptest_table_p3000000070 132s ok 91 - Check that data outside child scope goes to default 132s ok 92 - Check partman_basic privileges of id_taptest_table_p3000000000 132s ok 93 - Check partman_basic privileges of id_taptest_table_p3000000010 132s ok 94 - Check partman_basic privileges of id_taptest_table_p3000000020 132s ok 95 - Check partman_basic privileges of id_taptest_table_p3000000030 132s ok 96 - Check partman_basic privileges of id_taptest_table_p3000000040 132s ok 97 - Check partman_basic privileges of id_taptest_table_p3000000050 132s ok 98 - Check partman_basic privileges of id_taptest_table_p3000000060 132s ok 99 - Check partman_basic privileges of id_taptest_table_p3000000070 132s ok 100 - Check partman_basic privileges of id_taptest_table_default 132s ok 101 - Check partman_revoke has no privileges on id_taptest_table_p3000000000 132s ok 102 - Check partman_revoke has no privileges on id_taptest_table_p3000000010 132s ok 103 - Check partman_revoke has no privileges on id_taptest_table_p3000000020 132s ok 104 - Check partman_revoke has no privileges on id_taptest_table_p3000000030 132s ok 105 - Check partman_revoke has no privileges on id_taptest_table_p3000000040 132s ok 106 - Check partman_revoke has no privileges on id_taptest_table_p3000000050 132s ok 107 - Check partman_revoke has no privileges on id_taptest_table_p3000000060 132s ok 108 - Check partman_revoke has no privileges on id_taptest_table_p3000000070 132s ok 109 - Check partman_revoke has no privileges on id_taptest_table_default 132s ok 110 - Check that ownership change worked for id_taptest_table_p3000000000 132s ok 111 - Check that ownership change worked for id_taptest_table_p3000000010 132s ok 112 - Check that ownership change worked for id_taptest_table_p3000000020 132s ok 113 - Check that ownership change worked for id_taptest_table_p3000000030 132s ok 114 - Check that ownership change worked for id_taptest_table_p3000000040 132s ok 115 - Check that ownership change worked for id_taptest_table_p3000000050 132s ok 116 - Check that ownership change worked for id_taptest_table_p3000000060 132s ok 117 - Check that ownership change worked for id_taptest_table_p3000000070 132s ok 118 - Check that ownership change worked for id_taptest_table_default 132s 1 132s ok 119 - Check id_taptest_table_p3000000000 doesn't exists anymore 132s 1 132s ok 120 - Check id_taptest_table_p3000000010 doesn't exists anymore 132s ok 121 - Check id_taptest_table_p3000000010 got moved to new schema 132s (1,11) 132s ok 122 - Check id_taptest_table_default does not exist 132s (1,10) 132s ok 123 - Check id_taptest_table_p3000000020 does not exist 132s (5,9) 132s ok 124 - Check count from undo table after undo 132s ok 125 - Check id_taptest_table_p3000000030 still exists 132s ok 126 - Check child table had its data removed id_taptest_table_p3000000030 132s ok 127 - Check id_taptest_table_p3000000040 still exists 132s ok 128 - Check child table had its data removed id_taptest_table_p3000000040 132s ok 129 - Check id_taptest_table_p3000000050 still exists 132s ok 130 - Check child table had its data removed id_taptest_table_p3000000050 132s ok 131 - Check id_taptest_table_p3000000060 still exists 132s ok 132 - Check child table had its data removed id_taptest_table_p3000000060 132s ok 133 - Check id_taptest_table_p3000000070 still exists 132s ok 134 - Check child table had its data removed id_taptest_table_p3000000070 132s ok 135 - Check that template table was dropped 132s ok 132s + pg_prove -ovf test/test_bgw/test-time-daily-bgw.sql 132s All tests successful. 132s Files=1, Tests=135, 1 wallclock secs ( 0.03 usr 0.00 sys + 0.07 cusr 0.03 csys = 0.13 CPU) 132s Result: PASS 132s Duplicate specification "psql-bin|b=s" for option "b" 132s Duplicate specification "host|h=s" for option "h" 132s Duplicate specification "port|p=s" for option "p" 132s Duplicate specification "pset|P=s%" for option "P" 132s Duplicate specification "schema|s=s" for option "s" 132s Duplicate specification "version|V" for option "version" 132s Duplicate specification "version|V" for option "V" 132s Duplicate specification "help|H|?" for option "help" 132s Duplicate specification "help|H|?" for option "H" 132s Duplicate specification "help|H|?" for option "?" 132s Duplicate specification "man|m" for option "man" 132s Duplicate specification "man|m" for option "m" 192s psql:test/test_bgw/test-time-daily-bgw.sql:253: NOTICE: Moved 36 row(s) to the target table. Removed 12 partitions. 192s psql:test/test_bgw/test-time-daily-bgw.sql:296: NOTICE: drop cascades to 14 other objects 192s DETAIL: drop cascades to table partman_test.time_taptest_table 192s drop cascades to table partman_test.undo_taptest 192s drop cascades to table partman_test.time_taptest_table_p20250220 192s drop cascades to table partman_test.time_taptest_table_p20250221 192s drop cascades to table partman_test.time_taptest_table_p20250222 192s drop cascades to table partman_test.time_taptest_table_p20250223 192s drop cascades to table partman_test.time_taptest_table_p20250224 192s drop cascades to table partman_test.time_taptest_table_p20250225 192s drop cascades to table partman_test.time_taptest_table_p20250226 192s drop cascades to table partman_test.time_taptest_table_default 192s drop cascades to table partman_test.time_taptest_table_p20250227 192s drop cascades to table partman_test.time_taptest_table_p20250228 192s drop cascades to table partman_test.time_taptest_table_p20250301 192s drop cascades to table partman_test.time_taptest_table_p20250302 192s psql:test/test_bgw/test-time-daily-bgw.sql:297: NOTICE: drop cascades to table partman_retention_test.time_taptest_table_p20250219 192s test/test_bgw/test-time-daily-bgw.sql .. 192s partman, public 192s 1..105 192s t 192s ok 1 - Check time_taptest_table_p20250222 exists 192s ok 2 - Check time_taptest_table_p20250223 exists 192s ok 3 - Check time_taptest_table_p20250224 exists 192s ok 4 - Check time_taptest_table_p20250225 exists 192s ok 5 - Check time_taptest_table_p20250226 exists 192s ok 6 - Check time_taptest_table_p20250227 exists 192s ok 7 - Check for primary key in time_taptest_table_p20250222 192s ok 8 - Check for primary key in time_taptest_table_p20250223 192s ok 9 - Check for primary key in time_taptest_table_p20250224 192s ok 10 - Check for primary key in time_taptest_table_p20250225 192s ok 11 - Check for primary key in time_taptest_table_p20250226 192s ok 12 - Check partman_basic privileges of time_taptest_table_p20250222 192s ok 13 - Check partman_basic privileges of time_taptest_table_p20250223 192s ok 14 - Check partman_basic privileges of time_taptest_table_p20250224 192s ok 15 - Check partman_basic privileges of time_taptest_table_p20250225 192s ok 16 - Check partman_basic privileges of time_taptest_table_p20250226 192s ok 17 - Check partman_revoke privileges of time_taptest_table_p20250222 192s ok 18 - Check partman_revoke privileges of time_taptest_table_p20250223 192s ok 19 - Check partman_revoke privileges of time_taptest_table_p20250224 192s ok 20 - Check partman_revoke privileges of time_taptest_table_p20250225 192s ok 21 - Check partman_revoke privileges of time_taptest_table_p20250226 192s ok 22 - Check count from parent table 192s ok 23 - Check count from time_taptest_table_p20250222 192s ok 24 - Check count from time_taptest_table 192s ok 25 - Check count from time_taptest_table_p20250223 192s ok 26 - Check count from time_taptest_table_p20250224 192s ok 27 - Waiting 20 seconds for background worker to run... 192s ok 28 - Check time_taptest_table_p20250227 exists 192s ok 29 - Check time_taptest_table_p20250228 exists 192s ok 30 - Check time_taptest_table_p20250301 exists 192s ok 31 - Check time_taptest_table_p20250302 exists 192s ok 32 - Check for primary key in time_taptest_table_p20250227 192s ok 33 - Check for primary key in time_taptest_table_p20250228 192s ok 34 - Check for primary key in time_taptest_table_p20250301 192s ok 35 - Check partman_basic privileges of time_taptest_table_p20250227 192s ok 36 - Check partman_basic privileges of time_taptest_table_p20250228 192s ok 37 - Check partman_basic privileges of time_taptest_table_p20250301 192s ok 38 - Check partman_revoke privileges of time_taptest_table_p20250227 192s ok 39 - Check partman_revoke privileges of time_taptest_table_p20250228 192s ok 40 - Check partman_revoke privileges of time_taptest_table_p20250301 192s ok 41 - Waiting 20 seconds for background worker to run... 192s ok 42 - Check time_taptest_table_p20250302 exists 192s ok 43 - Check time_taptest_table_p20250303 exists 192s ok 44 - Check for primary key in time_taptest_table_p20250302 192s ok 45 - Check partman_basic privileges of time_taptest_table_p20250302 192s ok 46 - Check partman_revoke privileges of time_taptest_table_p20250302 192s ok 47 - Check that ownership change worked for time_taptest_table_p20250302 192s ok 48 - Check that data outside scope goes to default 192s ok 49 - Check partman_basic privileges of time_taptest_table_p20250222 192s ok 50 - Check partman_basic privileges of time_taptest_table_p20250223 192s ok 51 - Check partman_basic privileges of time_taptest_table_p20250224 192s ok 52 - Check partman_basic privileges of time_taptest_table_p20250225 192s ok 53 - Check partman_basic privileges of time_taptest_table_p20250226 192s ok 54 - Check partman_basic privileges of time_taptest_table_p20250227 192s ok 55 - Check partman_basic privileges of time_taptest_table_p20250228 192s ok 56 - Check partman_basic privileges of time_taptest_table_p20250301 192s ok 57 - Check partman_basic privileges of time_taptest_table_p20250302 192s ok 58 - Check partman_revoke privileges of time_taptest_table_p20250222 192s ok 59 - Check partman_revoke privileges of time_taptest_table_p20250223 192s ok 60 - Check partman_revoke privileges of time_taptest_table_p20250224 192s ok 61 - Check partman_revoke privileges of time_taptest_table_p20250225 192s ok 62 - Check partman_revoke privileges of time_taptest_table_p20250226 192s ok 63 - Check partman_revoke privileges of time_taptest_table_p20250227 192s ok 64 - Check partman_revoke privileges of time_taptest_table_p20250228 192s ok 65 - Check partman_revoke privileges of time_taptest_table_p20250301 192s ok 66 - Check partman_revoke privileges of time_taptest_table_p20250302 192s ok 67 - Check that ownership change worked for time_taptest_table_p20250222 192s ok 68 - Check that ownership change worked for time_taptest_table_p20250223 192s ok 69 - Check that ownership change worked for time_taptest_table_p20250224 192s ok 70 - Check that ownership change worked for time_taptest_table_p20250225 192s ok 71 - Check that ownership change worked for time_taptest_table_p20250226 192s ok 72 - Check that ownership change worked for time_taptest_table_p20250227 192s ok 73 - Check that ownership change worked for time_taptest_table_p20250228 192s ok 74 - Check that ownership change worked for time_taptest_table_p20250301 192s ok 75 - Check that ownership change worked for time_taptest_table_p20250302 192s 1 192s ok 76 - Check time_taptest_table_p20250218 does not exist 192s ok 77 - Waiting 20 seconds for background worker to run... 192s ok 78 - Check time_taptest_table_p20250219 does not exist 192s ok 79 - Check time_taptest_table_p20250219 got moved to new schema 192s (12,36) 192s ok 80 - Check time_taptest_table_p20250222 exists 192s ok 81 - Check time_taptest_table_p20250223 still exists 192s ok 82 - Check time_taptest_table_p20250221 is empty 192s ok 83 - Check time_taptest_table_p20250221 is empty 192s ok 84 - Check time_taptest_table_p20250220 still exists 192s ok 85 - Check time_taptest_table_p20250220 is empty 192s ok 86 - Check time_taptest_table_p20250223 is empty 192s ok 87 - Check time_taptest_table_p20250224 still exists 192s ok 88 - Check time_taptest_table_p20250224 is empty 192s ok 89 - Check time_taptest_table_p20250225 still exists 192s ok 90 - Check time_taptest_table_p20250225 is empty 192s ok 91 - Check time_taptest_table_p20250226 still exists 192s ok 92 - Check time_taptest_table_p20250226 is empty 192s ok 93 - Check time_taptest_table_p20250227 still exists 192s ok 94 - Check time_taptest_table_p20250227 is empty 192s ok 95 - Check time_taptest_table_p20250228 still exists 192s ok 96 - Check time_taptest_table_p20250228 is empty 192s ok 97 - Check time_taptest_table_p20250301 still exists 192s ok 98 - Check time_taptest_table_p20250301 is empty 192s ok 99 - Check time_taptest_table_p20250302 still exists 192s ok 100 - Check time_taptest_table_p20250302 is empty 192s ok 101 - Ensure partman_test schema has been dropped 192s ok 102 - Ensure partman_retention_test schema has been dropped 192s ok 103 - Ensure partman_basic role has been dropped 192s ok 104 - Ensure partman_revoke role has been dropped 192s ok 105 - Ensure partman_owner role has been dropped 192s ok 192s All tests successful. 192s Files=1, Tests=105, 60 wallclock secs ( 0.04 usr 0.00 sys + 0.06 cusr 0.00 csys = 0.10 CPU) 192s Result: PASS 192s Dropping cluster 17/regress ... 192s ### End 17 virtualenv ### 193s autopkgtest [07:00:54]: test prove: -----------------------] 193s autopkgtest [07:00:54]: test prove: - - - - - - - - - - results - - - - - - - - - - 193s prove PASS 194s autopkgtest [07:00:55]: test scripts: preparing testbed 325s autopkgtest [07:03:06]: testbed dpkg architecture: ppc64el 325s autopkgtest [07:03:06]: testbed apt version: 2.9.30ubuntu1 325s autopkgtest [07:03:06]: @@@@@@@@@@@@@@@@@@@@ test bed setup 325s autopkgtest [07:03:06]: testbed release detected to be: plucky 326s autopkgtest [07:03:07]: updating testbed package index (apt update) 326s Get:1 http://ftpmaster.internal/ubuntu plucky-proposed InRelease [110 kB] 327s Hit:2 http://ftpmaster.internal/ubuntu plucky InRelease 327s 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/restricted Sources [3120 B] 327s Get:6 http://ftpmaster.internal/ubuntu plucky-proposed/main Sources [80.9 kB] 327s Get:7 http://ftpmaster.internal/ubuntu plucky-proposed/universe Sources [504 kB] 327s Get:8 http://ftpmaster.internal/ubuntu plucky-proposed/multiverse Sources [13.5 kB] 327s Get:9 http://ftpmaster.internal/ubuntu plucky-proposed/main ppc64el Packages [127 kB] 327s Get:10 http://ftpmaster.internal/ubuntu plucky-proposed/restricted ppc64el Packages [760 B] 327s Get:11 http://ftpmaster.internal/ubuntu plucky-proposed/universe ppc64el Packages [432 kB] 327s Get:12 http://ftpmaster.internal/ubuntu plucky-proposed/multiverse ppc64el Packages [3292 B] 327s Fetched 1276 kB in 1s (1356 kB/s) 328s Reading package lists... 329s Reading package lists... 329s Building dependency tree... 329s Reading state information... 329s Calculating upgrade... 330s Calculating upgrade... 330s The following packages will be upgraded: 330s curl libcurl3t64-gnutls libcurl4t64 330s 3 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 330s Need to get 1221 kB of archives. 330s After this operation, 3072 B disk space will be freed. 330s Get:1 http://ftpmaster.internal/ubuntu plucky/main ppc64el curl ppc64el 8.12.1-2ubuntu1 [258 kB] 330s Get:2 http://ftpmaster.internal/ubuntu plucky/main ppc64el libcurl4t64 ppc64el 8.12.1-2ubuntu1 [482 kB] 330s Get:3 http://ftpmaster.internal/ubuntu plucky/main ppc64el libcurl3t64-gnutls ppc64el 8.12.1-2ubuntu1 [481 kB] 331s Fetched 1221 kB in 1s (1173 kB/s) 331s (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 ... 106371 files and directories currently installed.) 331s Preparing to unpack .../curl_8.12.1-2ubuntu1_ppc64el.deb ... 331s Unpacking curl (8.12.1-2ubuntu1) over (8.12.0+git20250209.89ed161+ds-1ubuntu1) ... 332s Preparing to unpack .../libcurl4t64_8.12.1-2ubuntu1_ppc64el.deb ... 332s Unpacking libcurl4t64:ppc64el (8.12.1-2ubuntu1) over (8.12.0+git20250209.89ed161+ds-1ubuntu1) ... 332s Preparing to unpack .../libcurl3t64-gnutls_8.12.1-2ubuntu1_ppc64el.deb ... 332s Unpacking libcurl3t64-gnutls:ppc64el (8.12.1-2ubuntu1) over (8.12.0+git20250209.89ed161+ds-1ubuntu1) ... 332s Setting up libcurl4t64:ppc64el (8.12.1-2ubuntu1) ... 332s Setting up libcurl3t64-gnutls:ppc64el (8.12.1-2ubuntu1) ... 332s Setting up curl (8.12.1-2ubuntu1) ... 332s Processing triggers for man-db (2.13.0-1) ... 332s Processing triggers for libc-bin (2.40-4ubuntu1) ... 333s Reading package lists... 333s Building dependency tree... 333s Reading state information... 333s Solving dependencies... 333s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 333s autopkgtest [07:03:14]: upgrading testbed (apt dist-upgrade and autopurge) 334s Reading package lists... 334s Building dependency tree... 334s Reading state information... 334s Calculating upgrade...Starting pkgProblemResolver with broken count: 0 334s Starting 2 pkgProblemResolver with broken count: 0 334s Done 335s Entering ResolveByKeep 335s 335s Calculating upgrade... 335s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 335s Reading package lists... 335s Building dependency tree... 335s Reading state information... 336s Starting pkgProblemResolver with broken count: 0 336s Starting 2 pkgProblemResolver with broken count: 0 336s Done 336s Solving dependencies... 336s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 339s Reading package lists... 340s Building dependency tree... 340s Reading state information... 340s Starting pkgProblemResolver with broken count: 0 340s Starting 2 pkgProblemResolver with broken count: 0 340s Done 341s The following NEW packages will be installed: 341s libio-pty-perl libipc-run-perl libjson-perl libllvm20 libpq5 libxslt1.1 341s postgresql-17 postgresql-17-partman postgresql-client-17 341s postgresql-client-common postgresql-common postgresql-common-dev 341s python3-psycopg2 ssl-cert 341s 0 upgraded, 14 newly installed, 0 to remove and 0 not upgraded. 341s Need to get 51.8 MB of archives. 341s After this operation, 230 MB of additional disk space will be used. 341s Get:1 http://ftpmaster.internal/ubuntu plucky/main ppc64el libjson-perl all 4.10000-1 [81.9 kB] 341s Get:2 http://ftpmaster.internal/ubuntu plucky/main ppc64el postgresql-client-common all 273 [47.5 kB] 341s Get:3 http://ftpmaster.internal/ubuntu plucky/main ppc64el libio-pty-perl ppc64el 1:1.20-1build3 [32.0 kB] 341s Get:4 http://ftpmaster.internal/ubuntu plucky/main ppc64el libipc-run-perl all 20231003.0-2 [91.5 kB] 341s Get:5 http://ftpmaster.internal/ubuntu plucky/main ppc64el postgresql-common-dev all 273 [72.9 kB] 341s Get:6 http://ftpmaster.internal/ubuntu plucky/main ppc64el ssl-cert all 1.1.3ubuntu1 [18.7 kB] 341s Get:7 http://ftpmaster.internal/ubuntu plucky/main ppc64el postgresql-common all 273 [101 kB] 341s Get:8 http://ftpmaster.internal/ubuntu plucky/main ppc64el libllvm20 ppc64el 1:20.1.0~+rc2-1~exp2ubuntu0.4 [31.9 MB] 345s Get:9 http://ftpmaster.internal/ubuntu plucky-proposed/main ppc64el libpq5 ppc64el 17.4-1 [174 kB] 345s Get:10 http://ftpmaster.internal/ubuntu plucky/main ppc64el libxslt1.1 ppc64el 1.1.39-0exp1ubuntu2 [191 kB] 345s Get:11 http://ftpmaster.internal/ubuntu plucky-proposed/main ppc64el postgresql-client-17 ppc64el 17.4-1 [1482 kB] 345s Get:12 http://ftpmaster.internal/ubuntu plucky-proposed/main ppc64el postgresql-17 ppc64el 17.4-1 [17.2 MB] 346s Get:13 http://ftpmaster.internal/ubuntu plucky/main ppc64el python3-psycopg2 ppc64el 2.9.10-1 [160 kB] 346s Get:14 http://ftpmaster.internal/ubuntu plucky/universe ppc64el postgresql-17-partman ppc64el 5.2.4-1 [230 kB] 346s Preconfiguring packages ... 346s Fetched 51.8 MB in 5s (9970 kB/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 ... 106371 files and directories currently installed.) 346s Preparing to unpack .../00-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 .../01-postgresql-client-common_273_all.deb ... 346s Unpacking postgresql-client-common (273) ... 346s Selecting previously unselected package libio-pty-perl. 346s Preparing to unpack .../02-libio-pty-perl_1%3a1.20-1build3_ppc64el.deb ... 346s Unpacking libio-pty-perl (1:1.20-1build3) ... 346s Selecting previously unselected package libipc-run-perl. 346s Preparing to unpack .../03-libipc-run-perl_20231003.0-2_all.deb ... 346s Unpacking libipc-run-perl (20231003.0-2) ... 346s Selecting previously unselected package postgresql-common-dev. 346s Preparing to unpack .../04-postgresql-common-dev_273_all.deb ... 346s Unpacking postgresql-common-dev (273) ... 346s Selecting previously unselected package ssl-cert. 346s Preparing to unpack .../05-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 .../06-postgresql-common_273_all.deb ... 346s Adding 'diversion of /usr/bin/pg_config to /usr/bin/pg_config.libpq-dev by postgresql-common' 346s Unpacking postgresql-common (273) ... 347s Selecting previously unselected package libllvm20:ppc64el. 347s Preparing to unpack .../07-libllvm20_1%3a20.1.0~+rc2-1~exp2ubuntu0.4_ppc64el.deb ... 347s Unpacking libllvm20:ppc64el (1:20.1.0~+rc2-1~exp2ubuntu0.4) ... 347s Selecting previously unselected package libpq5:ppc64el. 347s Preparing to unpack .../08-libpq5_17.4-1_ppc64el.deb ... 347s Unpacking libpq5:ppc64el (17.4-1) ... 347s Selecting previously unselected package libxslt1.1:ppc64el. 347s Preparing to unpack .../09-libxslt1.1_1.1.39-0exp1ubuntu2_ppc64el.deb ... 347s Unpacking libxslt1.1:ppc64el (1.1.39-0exp1ubuntu2) ... 347s Selecting previously unselected package postgresql-client-17. 347s Preparing to unpack .../10-postgresql-client-17_17.4-1_ppc64el.deb ... 347s Unpacking postgresql-client-17 (17.4-1) ... 347s Selecting previously unselected package postgresql-17. 347s Preparing to unpack .../11-postgresql-17_17.4-1_ppc64el.deb ... 347s Unpacking postgresql-17 (17.4-1) ... 348s Selecting previously unselected package python3-psycopg2. 348s Preparing to unpack .../12-python3-psycopg2_2.9.10-1_ppc64el.deb ... 348s Unpacking python3-psycopg2 (2.9.10-1) ... 348s Selecting previously unselected package postgresql-17-partman. 348s Preparing to unpack .../13-postgresql-17-partman_5.2.4-1_ppc64el.deb ... 348s Unpacking postgresql-17-partman (5.2.4-1) ... 348s Setting up postgresql-client-common (273) ... 348s Setting up libio-pty-perl (1:1.20-1build3) ... 348s Setting up libpq5:ppc64el (17.4-1) ... 348s Setting up ssl-cert (1.1.3ubuntu1) ... 348s Created symlink '/etc/systemd/system/multi-user.target.wants/ssl-cert.service' → '/usr/lib/systemd/system/ssl-cert.service'. 349s Setting up libllvm20:ppc64el (1:20.1.0~+rc2-1~exp2ubuntu0.4) ... 349s Setting up python3-psycopg2 (2.9.10-1) ... 349s Setting up libipc-run-perl (20231003.0-2) ... 349s Setting up libjson-perl (4.10000-1) ... 349s Setting up libxslt1.1:ppc64el (1.1.39-0exp1ubuntu2) ... 349s Setting up postgresql-common-dev (273) ... 349s Setting up postgresql-client-17 (17.4-1) ... 349s 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 349s Setting up postgresql-common (273) ... 350s Creating config file /etc/postgresql-common/createcluster.conf with new version 350s Building PostgreSQL dictionaries from installed myspell/hunspell packages... 350s Removing obsolete dictionary files: 350s Created symlink '/etc/systemd/system/multi-user.target.wants/postgresql.service' → '/usr/lib/systemd/system/postgresql.service'. 351s Setting up postgresql-17 (17.4-1) ... 352s Creating new PostgreSQL cluster 17/main ... 352s /usr/lib/postgresql/17/bin/initdb -D /var/lib/postgresql/17/main --auth-local peer --auth-host scram-sha-256 --no-instructions 352s The files belonging to this database system will be owned by user "postgres". 352s This user must also own the server process. 352s 352s The database cluster will be initialized with locale "C.UTF-8". 352s The default database encoding has accordingly been set to "UTF8". 352s The default text search configuration will be set to "english". 352s 352s Data page checksums are disabled. 352s 352s fixing permissions on existing directory /var/lib/postgresql/17/main ... ok 352s creating subdirectories ... ok 352s selecting dynamic shared memory implementation ... posix 352s selecting default "max_connections" ... 100 352s selecting default "shared_buffers" ... 128MB 352s selecting default time zone ... Etc/UTC 352s creating configuration files ... ok 352s running bootstrap script ... ok 353s performing post-bootstrap initialization ... ok 353s syncing data to disk ... ok 356s Setting up postgresql-17-partman (5.2.4-1) ... 356s Processing triggers for man-db (2.13.0-1) ... 357s Processing triggers for libc-bin (2.40-4ubuntu1) ... 360s autopkgtest [07:03:41]: test scripts: [----------------------- 360s + /usr/lib/postgresql/17/bin/check_unique_constraint.py --help 360s usage: check_unique_constraint.py [-h] [-p PARENT] [-l COLUMN_LIST] 360s [-c CONNECTION] [-t TEMP] [--psql PSQL] 360s [--simple] [--index_scan] [-q] [--version] 360s 360s This script is used to check that all rows in a partition set are unique for 360s the given columns. Since unique constraints are not applied across partition 360s sets, this cannot be enforced within the database. This script can be used as 360s a monitor to ensure uniquness. If any unique violations are found, the values, 360s along with a count of each, are output. 360s 360s options: 360s -h, --help show this help message and exit 360s -p, --parent PARENT Parent table of the partition set to be checked 360s -l, --column_list COLUMN_LIST 360s Comma separated list of columns that make up the 360s unique constraint to be checked 360s -c, --connection CONNECTION 360s Connection string for use by psycopg. Defaults to 360s "host=" (local socket). 360s -t, --temp TEMP Path to a writable folder that can be used for temp 360s working files. Defaults system temp folder. 360s --psql PSQL Full path to psql binary if not in current PATH 360s --simple Output a single integer value with the total duplicate 360s count. Use this for monitoring software that requires 360s a simple value to be checked for. 360s --index_scan By default index scans are disabled to force the 360s script to check the actual table data with sequential 360s scans. Set this option if you want the script to allow 360s index scans to be used (does not guarentee that they 360s will be used). 360s -q, --quiet Suppress all output unless there is a constraint 360s violation found. 360s --version Print out the minimum version of pg_partman this 360s script is meant to work with. The version of 360s pg_partman installed may be greater than this. 360s + /usr/lib/postgresql/17/bin/dump_partition.py --help 360s usage: dump_partition.py [-h] [-n SCHEMA] [-c CONNECTION] [-o OUTPUT] 360s [-d DUMP_DATABASE] [--dump_host DUMP_HOST] 360s [--dump_username DUMP_USERNAME] 360s [--dump_port DUMP_PORT] [--pg_dump_path PG_DUMP_PATH] 360s [--Fp] [--nohashfile] [--nodrop] [-v] [--version] 360s 360s This script will dump out and then drop all tables contained in the designated 360s schema using pg_dump. Each table will be in its own separate file along with a 360s SHA-512 hash of the dump file. Tables are not dropped from the database if 360s pg_dump does not return successfully. All dump_* option defaults are the same 360s as they would be for pg_dump if they are not given. 360s 360s options: 360s -h, --help show this help message and exit 360s -n, --schema SCHEMA (Required) The schema that contains the tables that 360s will be dumped. 360s -c, --connection CONNECTION 360s Connection string for use by psycopg. Role used must 360s be able to select pg_catalog.pg_tables in the relevant 360s database and drop all tables in the given schema. 360s Defaults to "host=" (local socket). Note this is 360s distinct from the parameters sent to pg_dump. 360s -o, --output OUTPUT Path to dump file output location. Default is where 360s the script is run from. 360s -d, --dump_database DUMP_DATABASE 360s Used for pg_dump, same as its --dbname (-d) option or 360s final database name parameter. 360s --dump_host DUMP_HOST 360s Used for pg_dump, same as its --host (-h) option. 360s --dump_username DUMP_USERNAME 360s Used for pg_dump, same as its --username (-U) option. 360s --dump_port DUMP_PORT 360s Used for pg_dump, same as its --port (-p) option. 360s --pg_dump_path PG_DUMP_PATH 360s Path to pg_dump binary location. Must set if not in 360s current PATH. 360s --Fp Dump using pg_dump plain text format. Default is 360s binary custom (-Fc). 360s --nohashfile Do NOT create a separate file with the SHA-512 hash of 360s the dump. If dump files are very large, hash 360s generation can possibly take a long time. 360s --nodrop Do NOT drop the tables from the given schema after 360s dumping/hashing. 360s -v, --verbose Provide more verbose output. 360s --version Print out the minimum version of pg_partman this 360s script is meant to work with. The version of 360s pg_partman installed may be greater than this. 360s 360s NOTE: The connection options for psyocpg and pg_dump were separated out due to 360s distinct differences in their requirements depending on your database 360s connection configuration. 360s + /usr/lib/postgresql/17/bin/vacuum_maintenance.py --help 360s usage: vacuum_maintenance.py [-h] [-p PARENT] [--all] [-c CONNECTION] [-z] 360s [-f] [-a VACUUM_FREEZE_MIN_AGE] [-t {time,id}] 360s [-i INTERVAL] [--noparent] [--dryrun] [-q] 360s [--version] [--debug] 360s 360s Script for performing additional vacuum maintenance on the child tables of a 360s partition set in order to avoid excess vacuuming and transaction id wraparound 360s issues. Whether a table is vacuumed or not by this script depends on whether 360s its age(relfrozenxid) is greater than vacuum_freeze_min_age. This ensures 360s repeated runs of this script do not re-vacuum tables that have already had all 360s of their page tuples frozen. This script does not require pg_partman to be 360s installed and will work on any inheritance set given a parent table, as long 360s as the options --all, --type or --interval are NOT set. 360s 360s options: 360s -h, --help show this help message and exit 360s -p, --parent PARENT Parent table of an already created 360s partition/inheritance set. Either this option or --all 360s is required. 360s --all Run against all tables managed by pg_partman. Either 360s this option or -p is required. Overrides -p if both 360s are set. 360s -c, --connection CONNECTION 360s Connection string for use by psycopg. Defaults to 360s "host=" (local socket). 360s -z, --freeze Sets the FREEZE option to the VACUUM command. 360s -f, --full Sets the FULL option to the VACUUM command. Note that 360s --freeze is not necessary if you set this. Recommend 360s reviewing --dryrun before running this since it will 360s lock all tables it runs against, possibly including 360s the parent. 360s -a, --vacuum_freeze_min_age VACUUM_FREEZE_MIN_AGE 360s By default the script obtains this value from the 360s system catalogs. By setting this, you can override the 360s value obtained from the database. Note this does not 360s change the value in the database, only the value this 360s script uses. 360s -t, --type {time,id} Tells the script whether the value given by --interval 360s is either time or id based. Also, if --all is set, 360s limits the partition sets that the script runs against 360s to just those types. Valid values are: "id" and 360s "time". 360s -i, --interval INTERVAL 360s In addition to checking transaction age, only run 360s against tables that are older than the interval given. 360s Takes either a postgresql time interval or integer 360s value. For time-based partitioning, uses the time that 360s script is run as baseline. For id-based partitioning, 360s the integer value will set that any partitions with an 360s id value less than the current maximum id value minus 360s the given value will be vacuumed. For example, if the 360s current max id is 100 and the given value is 30, any 360s partitions with id values less than 70 will be 360s vacuumed. The current maximum id value at the time the 360s script is run is always used. 360s --noparent Normally the parent table is included in the list of 360s tables to vacuum if its age(relfrozenxid) is higher 360s than vacuum_freeze_min_age. Set this to force 360s exclusion of the parent table, even if it meets that 360s criteria. 360s --dryrun Show what the script will do without actually running 360s it against the database. Highly recommend reviewing 360s this before running for the first time. 360s -q, --quiet Turn off all output. 360s --version Print out the minimum version of pg_partman this 360s script is meant to work with. The version of 360s pg_partman installed may be greater than this. 360s --debug Show additional debugging output 361s autopkgtest [07:03:42]: test scripts: -----------------------] 361s autopkgtest [07:03:42]: test scripts: - - - - - - - - - - results - - - - - - - - - - 361s scripts PASS 361s autopkgtest [07:03:42]: @@@@@@@@@@@@@@@@@@@@ summary 361s prove PASS 361s scripts PASS 379s nova [W] Using flock in prodstack6-ppc64el 379s Creating nova instance adt-plucky-ppc64el-pg-partman-20250222-065741-juju-7f2275-prod-proposed-migration-environment-2-169403d7-da84-48a8-98bd-f3fc90434af8 from image adt/ubuntu-plucky-ppc64el-server-20250222.img (UUID fe93544b-49e9-47e0-b80a-745acc8cd85b)... 379s nova [W] Timed out waiting for 3fd5ec33-2433-45e3-af23-5dd198a7d87f to get deleted. 379s nova [W] Using flock in prodstack6-ppc64el 379s Creating nova instance adt-plucky-ppc64el-pg-partman-20250222-065741-juju-7f2275-prod-proposed-migration-environment-2-169403d7-da84-48a8-98bd-f3fc90434af8 from image adt/ubuntu-plucky-ppc64el-server-20250222.img (UUID fe93544b-49e9-47e0-b80a-745acc8cd85b)... 379s nova [W] Timed out waiting for 90b3e87a-3326-4bff-89f2-e50d0eb8ebc4 to get deleted.