0s autopkgtest [09:25:14]: starting date and time: 2025-01-06 09:25:14+0000 0s autopkgtest [09:25:14]: git checkout: 325255d2 Merge branch 'pin-any-arch' into 'ubuntu/production' 0s autopkgtest [09:25:14]: host juju-7f2275-prod-proposed-migration-environment-20; command line: /home/ubuntu/autopkgtest/runner/autopkgtest --output-dir /tmp/autopkgtest-work.z1kcrbrm/out --timeout-copy=6000 --setup-commands /home/ubuntu/autopkgtest-cloud/worker-config-production/setup-canonical.sh --apt-pocket=proposed=src:postgresql-17,src:icu --apt-upgrade pg-partman --timeout-short=300 --timeout-copy=20000 --timeout-build=20000 '--env=ADT_TEST_TRIGGERS=postgresql-17/17.2-1build2 icu/76.1-1ubuntu1' -- ssh -s /home/ubuntu/autopkgtest/ssh-setup/nova -- --flavor autopkgtest --security-groups autopkgtest-juju-7f2275-prod-proposed-migration-environment-20@bos03-arm64-19.secgroup --name adt-plucky-arm64-pg-partman-20250106-092514-juju-7f2275-prod-proposed-migration-environment-20-895c4266-aad0-4b27-a887-0e727e15f4ad --image adt/ubuntu-plucky-arm64-server --keyname testbed-juju-7f2275-prod-proposed-migration-environment-20 --net-id=net_prod-proposed-migration -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/ 119s autopkgtest [09:27:13]: testbed dpkg architecture: arm64 119s autopkgtest [09:27:13]: testbed apt version: 2.9.18 120s autopkgtest [09:27:14]: @@@@@@@@@@@@@@@@@@@@ test bed setup 120s autopkgtest [09:27:14]: testbed release detected to be: None 121s autopkgtest [09:27:15]: updating testbed package index (apt update) 121s Get:1 http://ftpmaster.internal/ubuntu plucky-proposed InRelease [73.9 kB] 121s Hit:2 http://ftpmaster.internal/ubuntu plucky InRelease 121s Hit:3 http://ftpmaster.internal/ubuntu plucky-updates InRelease 121s Hit:4 http://ftpmaster.internal/ubuntu plucky-security InRelease 121s Get:5 http://ftpmaster.internal/ubuntu plucky-proposed/main Sources [105 kB] 122s Get:6 http://ftpmaster.internal/ubuntu plucky-proposed/universe Sources [746 kB] 122s Get:7 http://ftpmaster.internal/ubuntu plucky-proposed/multiverse Sources [17.2 kB] 122s Get:8 http://ftpmaster.internal/ubuntu plucky-proposed/restricted Sources [9708 B] 122s Get:9 http://ftpmaster.internal/ubuntu plucky-proposed/main arm64 Packages [189 kB] 122s Get:10 http://ftpmaster.internal/ubuntu plucky-proposed/restricted arm64 Packages [57.8 kB] 122s Get:11 http://ftpmaster.internal/ubuntu plucky-proposed/universe arm64 Packages [826 kB] 122s Get:12 http://ftpmaster.internal/ubuntu plucky-proposed/multiverse arm64 Packages [23.1 kB] 122s Fetched 2048 kB in 1s (1996 kB/s) 123s Reading package lists... 123s Reading package lists... 124s Building dependency tree... 124s Reading state information... 124s Calculating upgrade... 125s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 125s Reading package lists... 125s Building dependency tree... 125s Reading state information... 126s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 126s autopkgtest [09:27:20]: upgrading testbed (apt dist-upgrade and autopurge) 126s Reading package lists... 126s Building dependency tree... 126s Reading state information... 127s Calculating upgrade...Starting pkgProblemResolver with broken count: 0 127s Starting 2 pkgProblemResolver with broken count: 0 127s Done 128s Entering ResolveByKeep 128s 128s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 129s Reading package lists... 129s Building dependency tree... 129s Reading state information... 129s Starting pkgProblemResolver with broken count: 0 129s Starting 2 pkgProblemResolver with broken count: 0 129s Done 130s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 133s autopkgtest [09:27:27]: testbed running kernel: Linux 6.11.0-8-generic #8-Ubuntu SMP PREEMPT_DYNAMIC Mon Sep 16 14:19:41 UTC 2024 133s autopkgtest [09:27:27]: @@@@@@@@@@@@@@@@@@@@ apt-source pg-partman 135s Get:1 http://ftpmaster.internal/ubuntu plucky/universe pg-partman 5.2.2-1 (dsc) [2307 B] 135s Get:2 http://ftpmaster.internal/ubuntu plucky/universe pg-partman 5.2.2-1 (tar) [1248 kB] 135s Get:3 http://ftpmaster.internal/ubuntu plucky/universe pg-partman 5.2.2-1 (diff) [4260 B] 135s gpgv: Signature made Wed Dec 11 22:00:11 2024 UTC 135s gpgv: using RSA key 5C48FE6157F49179597087C64C5A6BAB12D2A7AE 135s gpgv: Can't check signature: No public key 135s dpkg-source: warning: cannot verify inline signature for ./pg-partman_5.2.2-1.dsc: no acceptable signature found 135s autopkgtest [09:27:29]: testing package pg-partman version 5.2.2-1 136s autopkgtest [09:27:30]: build not needed 136s autopkgtest [09:27:30]: test prove: preparing testbed 137s Reading package lists... 137s Building dependency tree... 137s Reading state information... 137s Starting pkgProblemResolver with broken count: 0 138s Starting 2 pkgProblemResolver with broken count: 0 138s Done 138s The following NEW packages will be installed: 138s libicu76 libjson-perl libpq5 libtap-parser-sourcehandler-pgtap-perl 138s libxslt1.1 postgresql-17 postgresql-17-partman postgresql-17-pgtap 138s postgresql-client-17 postgresql-client-common postgresql-common 138s python3-psycopg2 ssl-cert 139s 0 upgraded, 13 newly installed, 0 to remove and 0 not upgraded. 139s Need to get 29.0 MB of archives. 139s After this operation, 106 MB of additional disk space will be used. 139s Get:1 http://ftpmaster.internal/ubuntu plucky/main arm64 libjson-perl all 4.10000-1 [81.9 kB] 139s Get:2 http://ftpmaster.internal/ubuntu plucky/main arm64 postgresql-client-common all 262 [36.7 kB] 139s Get:3 http://ftpmaster.internal/ubuntu plucky/main arm64 ssl-cert all 1.1.3ubuntu1 [18.7 kB] 139s Get:4 http://ftpmaster.internal/ubuntu plucky/main arm64 postgresql-common all 262 [162 kB] 139s Get:5 http://ftpmaster.internal/ubuntu plucky-proposed/main arm64 libicu76 arm64 76.1-1ubuntu1 [11.1 MB] 140s Get:6 http://ftpmaster.internal/ubuntu plucky-proposed/main arm64 libpq5 arm64 17.2-1build2 [141 kB] 140s Get:7 http://ftpmaster.internal/ubuntu plucky/main arm64 libxslt1.1 arm64 1.1.39-0exp1ubuntu2 [168 kB] 140s Get:8 http://ftpmaster.internal/ubuntu plucky-proposed/main arm64 postgresql-client-17 arm64 17.2-1build2 [1318 kB] 140s Get:9 http://ftpmaster.internal/ubuntu plucky-proposed/main arm64 postgresql-17 arm64 17.2-1build2 [15.5 MB] 141s Get:10 http://ftpmaster.internal/ubuntu plucky/main arm64 python3-psycopg2 arm64 2.9.10-1 [150 kB] 141s Get:11 http://ftpmaster.internal/ubuntu plucky/universe arm64 postgresql-17-partman arm64 5.2.2-1 [228 kB] 141s Get:12 http://ftpmaster.internal/ubuntu plucky/universe arm64 postgresql-17-pgtap all 1.3.3-3 [45.6 kB] 141s Get:13 http://ftpmaster.internal/ubuntu plucky/universe arm64 libtap-parser-sourcehandler-pgtap-perl all 3.36-2 [35.2 kB] 142s Preconfiguring packages ... 142s Fetched 29.0 MB in 3s (10.5 MB/s) 142s Selecting previously unselected package libjson-perl. 142s (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 ... 80185 files and directories currently installed.) 142s Preparing to unpack .../00-libjson-perl_4.10000-1_all.deb ... 142s Unpacking libjson-perl (4.10000-1) ... 142s Selecting previously unselected package postgresql-client-common. 142s Preparing to unpack .../01-postgresql-client-common_262_all.deb ... 142s Unpacking postgresql-client-common (262) ... 142s Selecting previously unselected package ssl-cert. 142s Preparing to unpack .../02-ssl-cert_1.1.3ubuntu1_all.deb ... 142s Unpacking ssl-cert (1.1.3ubuntu1) ... 142s Selecting previously unselected package postgresql-common. 142s Preparing to unpack .../03-postgresql-common_262_all.deb ... 142s Adding 'diversion of /usr/bin/pg_config to /usr/bin/pg_config.libpq-dev by postgresql-common' 142s Unpacking postgresql-common (262) ... 142s Selecting previously unselected package libicu76:arm64. 142s Preparing to unpack .../04-libicu76_76.1-1ubuntu1_arm64.deb ... 142s Unpacking libicu76:arm64 (76.1-1ubuntu1) ... 142s Selecting previously unselected package libpq5:arm64. 142s Preparing to unpack .../05-libpq5_17.2-1build2_arm64.deb ... 142s Unpacking libpq5:arm64 (17.2-1build2) ... 142s Selecting previously unselected package libxslt1.1:arm64. 142s Preparing to unpack .../06-libxslt1.1_1.1.39-0exp1ubuntu2_arm64.deb ... 142s Unpacking libxslt1.1:arm64 (1.1.39-0exp1ubuntu2) ... 142s Selecting previously unselected package postgresql-client-17. 143s Preparing to unpack .../07-postgresql-client-17_17.2-1build2_arm64.deb ... 143s Unpacking postgresql-client-17 (17.2-1build2) ... 143s Selecting previously unselected package postgresql-17. 143s Preparing to unpack .../08-postgresql-17_17.2-1build2_arm64.deb ... 143s Unpacking postgresql-17 (17.2-1build2) ... 143s Selecting previously unselected package python3-psycopg2. 143s Preparing to unpack .../09-python3-psycopg2_2.9.10-1_arm64.deb ... 143s Unpacking python3-psycopg2 (2.9.10-1) ... 143s Selecting previously unselected package postgresql-17-partman. 143s Preparing to unpack .../10-postgresql-17-partman_5.2.2-1_arm64.deb ... 143s Unpacking postgresql-17-partman (5.2.2-1) ... 143s Selecting previously unselected package postgresql-17-pgtap. 143s Preparing to unpack .../11-postgresql-17-pgtap_1.3.3-3_all.deb ... 143s Unpacking postgresql-17-pgtap (1.3.3-3) ... 143s Selecting previously unselected package libtap-parser-sourcehandler-pgtap-perl. 143s Preparing to unpack .../12-libtap-parser-sourcehandler-pgtap-perl_3.36-2_all.deb ... 143s Unpacking libtap-parser-sourcehandler-pgtap-perl (3.36-2) ... 143s Setting up postgresql-client-common (262) ... 143s Setting up libtap-parser-sourcehandler-pgtap-perl (3.36-2) ... 143s Setting up libpq5:arm64 (17.2-1build2) ... 143s Setting up ssl-cert (1.1.3ubuntu1) ... 144s Created symlink '/etc/systemd/system/multi-user.target.wants/ssl-cert.service' → '/usr/lib/systemd/system/ssl-cert.service'. 144s Setting up python3-psycopg2 (2.9.10-1) ... 144s Setting up libjson-perl (4.10000-1) ... 144s Setting up libxslt1.1:arm64 (1.1.39-0exp1ubuntu2) ... 144s Setting up libicu76:arm64 (76.1-1ubuntu1) ... 144s Setting up postgresql-client-17 (17.2-1build2) ... 145s 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 145s Setting up postgresql-common (262) ... 146s Creating config file /etc/postgresql-common/createcluster.conf with new version 146s Building PostgreSQL dictionaries from installed myspell/hunspell packages... 146s Removing obsolete dictionary files: 147s Created symlink '/etc/systemd/system/multi-user.target.wants/postgresql.service' → '/usr/lib/systemd/system/postgresql.service'. 147s Setting up postgresql-17 (17.2-1build2) ... 147s Creating new PostgreSQL cluster 17/main ... 147s /usr/lib/postgresql/17/bin/initdb -D /var/lib/postgresql/17/main --auth-local peer --auth-host scram-sha-256 --no-instructions 147s The files belonging to this database system will be owned by user "postgres". 147s This user must also own the server process. 147s 147s The database cluster will be initialized with locale "C.UTF-8". 147s The default database encoding has accordingly been set to "UTF8". 147s The default text search configuration will be set to "english". 147s 147s Data page checksums are disabled. 147s 147s fixing permissions on existing directory /var/lib/postgresql/17/main ... ok 147s creating subdirectories ... ok 147s selecting dynamic shared memory implementation ... posix 147s selecting default "max_connections" ... 100 147s selecting default "shared_buffers" ... 128MB 147s selecting default time zone ... Etc/UTC 147s creating configuration files ... ok 147s running bootstrap script ... ok 148s performing post-bootstrap initialization ... ok 148s syncing data to disk ... ok 152s Setting up postgresql-17-pgtap (1.3.3-3) ... 152s Setting up postgresql-17-partman (5.2.2-1) ... 152s Processing triggers for man-db (2.13.0-1) ... 153s Processing triggers for libc-bin (2.40-4ubuntu1) ... 154s autopkgtest [09:27:48]: test prove: [----------------------- 155s ### PostgreSQL 17 virtualenv ### 155s Creating new PostgreSQL cluster 17/regress ... 158s + psql -c 'CREATE EXTENSION pgtap' 158s CREATE EXTENSION 158s + psql -c 'CREATE EXTENSION pg_partman' 158s CREATE EXTENSION 158s + pg_prove -ovf test/test-id-10.sql 158s Duplicate specification "psql-bin|b=s" for option "b" 158s Duplicate specification "host|h=s" for option "h" 158s Duplicate specification "port|p=s" for option "p" 158s Duplicate specification "pset|P=s%" for option "P" 158s Duplicate specification "schema|s=s" for option "s" 158s Duplicate specification "version|V" for option "version" 158s Duplicate specification "version|V" for option "V" 158s Duplicate specification "help|H|?" for option "help" 158s Duplicate specification "help|H|?" for option "H" 158s Duplicate specification "help|H|?" for option "?" 158s Duplicate specification "man|m" for option "man" 158s Duplicate specification "man|m" for option "m" 159s psql:test/test-id-10.sql:208: NOTICE: Moved 11 row(s) to the target table. Removed 1 partitions. 159s psql:test/test-id-10.sql:211: NOTICE: Moved 10 row(s) to the target table. Removed 1 partitions. 159s psql:test/test-id-10.sql:215: NOTICE: Moved 9 row(s) to the target table. Removed 5 partitions. 159s test/test-id-10.sql .. 159s partman, public 159s 1..135 159s t 159s ok 1 - Check id_taptest_table_p3000000000 exists 159s ok 2 - Check id_taptest_table_p3000000010 exists 159s ok 3 - Check id_taptest_table_p3000000020 exists 159s ok 4 - Check id_taptest_table_p3000000030 exists 159s ok 5 - Check id_taptest_table_p3000000040 exists 159s ok 6 - Check id_taptest_table_default exists 159s ok 7 - Check id_taptest_table_p3000000050 doesn't exists yet 159s ok 8 - Check for primary key in id_taptest_table_p3000000000 159s ok 9 - Check for primary key in id_taptest_table_p3000000010 159s ok 10 - Check for primary key in id_taptest_table_p3000000020 159s ok 11 - Check for primary key in id_taptest_table_p3000000030 159s ok 12 - Check for primary key in id_taptest_table_p3000000040 159s ok 13 - Check for primary key in id_taptest_table_default 159s ok 14 - Check that foreign key was inherited to id_taptest_table_p3000000000 159s ok 15 - Check that foreign key was inherited to id_taptest_table_p3000000010 159s ok 16 - Check that foreign key was inherited to id_taptest_table_p3000000020 159s ok 17 - Check that foreign key was inherited to id_taptest_table_p3000000030 159s ok 18 - Check that foreign key was inherited to id_taptest_table_p3000000040 159s ok 19 - Check that foreign key was inherited to id_taptest_table_default 159s ok 20 - Check that unique index was inherited to id_taptest_table_p3000000000 159s ok 21 - Check that unique index was inherited to id_taptest_table_p3000000010 159s ok 22 - Check that unique index was inherited to id_taptest_table_p3000000020 159s ok 23 - Check that unique index was inherited to id_taptest_table_p3000000030 159s ok 24 - Check that unique index was inherited to id_taptest_table_p3000000040 159s ok 25 - Check that unique index was inherited to id_taptest_table_default 159s ok 26 - Check partman_basic privileges of id_taptest_table_p3000000000 159s ok 27 - Check partman_basic privileges of id_taptest_table_p3000000010 159s ok 28 - Check partman_basic privileges of id_taptest_table_p3000000020 159s ok 29 - Check partman_basic privileges of id_taptest_table_p3000000030 159s ok 30 - Check partman_basic privileges of id_taptest_table_p3000000040 159s ok 31 - Check partman_basic privileges of id_taptest_table_default 159s ok 32 - Check partman_revoke privileges of id_taptest_table_p3000000000 159s ok 33 - Check partman_revoke privileges of id_taptest_table_p3000000010 159s ok 34 - Check partman_revoke privileges of id_taptest_table_p3000000020 159s ok 35 - Check partman_revoke privileges of id_taptest_table_p3000000030 159s ok 36 - Check partman_revoke privileges of id_taptest_table_p3000000040 159s ok 37 - Check partman_revoke privileges of id_taptest_table_default 159s ok 38 - Check that parent table is unlogged 159s ok 39 - Check that id_taptest_table_p3000000000 is unlogged 159s ok 40 - Check that id_taptest_table_p3000000010 is unlogged 159s ok 41 - Check that id_taptest_table_p3000000020 is unlogged 159s ok 42 - Check that id_taptest_table_p3000000030 is unlogged 159s ok 43 - Check that id_taptest_table_p3000000040 is unlogged 159s ok 44 - Check that id_taptest_table_default is unlogged 159s ok 45 - Check that default table has no data 159s ok 46 - Check count from parent table 159s ok 47 - Check count from id_taptest_table_p3000000000 159s ok 48 - Check that parent table has had no data inserted to it 159s ok 49 - Check count from id_taptest_table_p3000000010 159s ok 50 - Check count from id_taptest_table_p3000000020 159s ok 51 - Check id_taptest_table_p3000000050 exists 159s ok 52 - Check that id_taptest_table_p3000000050 is unlogged 159s ok 53 - Check id_taptest_table_p3000000060 exists yet 159s ok 54 - Check that id_taptest_table_p3000000060 is unlogged 159s ok 55 - Check id_taptest_table_p3000000070 doesn't exists yet 159s ok 56 - Check for primary key in id_taptest_table_p3000000050 159s ok 57 - Check that foreign key was inherited to id_taptest_table_p3000000050 159s ok 58 - Check partman_basic privileges of id_taptest_table_p3000000000 159s ok 59 - Check partman_basic privileges of id_taptest_table_p3000000010 159s ok 60 - Check partman_basic privileges of id_taptest_table_p3000000020 159s ok 61 - Check partman_basic privileges of id_taptest_table_p3000000030 159s ok 62 - Check partman_basic privileges of id_taptest_table_p3000000040 159s ok 63 - Check partman_basic privileges of id_taptest_table_p3000000050 159s ok 64 - Check partman_revoke privileges of id_taptest_table_p3000000050 159s ok 65 - Check partman_basic privileges of id_taptest_table_p3000000060 159s ok 66 - Check partman_revoke privileges of id_taptest_table_p3000000060 159s ok 67 - Check that parent table has had no data inserted to it 159s ok 68 - Check count from id_taptest_table 159s ok 69 - Check count from id_taptest_table_p3000000020 159s ok 70 - Check count from id_taptest_table_p3000000030 159s ok 71 - Check id_taptest_table_p3000000070 exists 159s ok 72 - Check that id_taptest_table_p3000000070 is unlogged 159s ok 73 - Check id_taptest_table_p3000000080 doesn't exists yet 159s ok 74 - Check for primary key in id_taptest_table_p3000000060 159s ok 75 - Check for primary key in id_taptest_table_p3000000070 159s ok 76 - Check that foreign key was inherited to id_taptest_table_p3000000060 159s ok 77 - Check that foreign key was inherited to id_taptest_table_p3000000070 159s ok 78 - Check partman_basic privileges of id_taptest_table_p3000000000 159s ok 79 - Check partman_basic privileges of id_taptest_table_p3000000010 159s ok 80 - Check partman_basic privileges of id_taptest_table_p3000000020 159s ok 81 - Check partman_basic privileges of id_taptest_table_p3000000030 159s ok 82 - Check partman_basic privileges of id_taptest_table_p3000000040 159s ok 83 - Check partman_basic privileges of id_taptest_table_default 159s ok 84 - Check partman_basic privileges of id_taptest_table_p3000000050 159s ok 85 - Check partman_revoke privileges of id_taptest_table_p3000000050 159s ok 86 - Check partman_basic privileges of id_taptest_table_p3000000060 159s ok 87 - Check partman_revoke privileges of id_taptest_table_p3000000060 159s ok 88 - Check partman_basic privileges of id_taptest_table_p3000000070 159s ok 89 - Check that ownership change worked for id_taptest_table_p3000000070 159s ok 90 - Check partman_revoke has no privileges on id_taptest_table_p3000000070 159s ok 91 - Check that data outside child scope goes to default 159s ok 92 - Check partman_basic privileges of id_taptest_table_p3000000000 159s ok 93 - Check partman_basic privileges of id_taptest_table_p3000000010 159s ok 94 - Check partman_basic privileges of id_taptest_table_p3000000020 159s ok 95 - Check partman_basic privileges of id_taptest_table_p3000000030 159s ok 96 - Check partman_basic privileges of id_taptest_table_p3000000040 159s ok 97 - Check partman_basic privileges of id_taptest_table_p3000000050 159s ok 98 - Check partman_basic privileges of id_taptest_table_p3000000060 159s ok 99 - Check partman_basic privileges of id_taptest_table_p3000000070 159s ok 100 - Check partman_basic privileges of id_taptest_table_default 159s ok 101 - Check partman_revoke has no privileges on id_taptest_table_p3000000000 159s ok 102 - Check partman_revoke has no privileges on id_taptest_table_p3000000010 159s ok 103 - Check partman_revoke has no privileges on id_taptest_table_p3000000020 159s ok 104 - Check partman_revoke has no privileges on id_taptest_table_p3000000030 159s ok 105 - Check partman_revoke has no privileges on id_taptest_table_p3000000040 159s ok 106 - Check partman_revoke has no privileges on id_taptest_table_p3000000050 159s ok 107 - Check partman_revoke has no privileges on id_taptest_table_p3000000060 159s ok 108 - Check partman_revoke has no privileges on id_taptest_table_p3000000070 159s ok 109 - Check partman_revoke has no privileges on id_taptest_table_default 159s ok 110 - Check that ownership change worked for id_taptest_table_p3000000000 159s ok 111 - Check that ownership change worked for id_taptest_table_p3000000010 159s ok 112 - Check that ownership change worked for id_taptest_table_p3000000020 159s ok 113 - Check that ownership change worked for id_taptest_table_p3000000030 159s ok 114 - Check that ownership change worked for id_taptest_table_p3000000040 159s ok 115 - Check that ownership change worked for id_taptest_table_p3000000050 159s ok 116 - Check that ownership change worked for id_taptest_table_p3000000060 159s ok 117 - Check that ownership change worked for id_taptest_table_p3000000070 159s ok 118 - Check that ownership change worked for id_taptest_table_default 159s 1 159s ok 119 - Check id_taptest_table_p3000000000 doesn't exists anymore 159s 1 159s ok 120 - Check id_taptest_table_p3000000010 doesn't exists anymore 159s ok 121 - Check id_taptest_table_p3000000010 got moved to new schema 159s (1,11) 159s ok 122 - Check id_taptest_table_default does not exist 159s (1,10) 159s ok 123 - Check id_taptest_table_p3000000020 does not exist 159s (5,9) 159s ok 124 - Check count from undo table after undo 159s ok 125 - Check id_taptest_table_p3000000030 still exists 159s ok 126 - Check child table had its data removed id_taptest_table_p3000000030 159s ok 127 - Check id_taptest_table_p3000000040 still exists 159s ok 128 - Check child table had its data removed id_taptest_table_p3000000040 159s ok 129 - Check id_taptest_table_p3000000050 still exists 159s ok 130 - Check child table had its data removed id_taptest_table_p3000000050 159s ok 131 - Check id_taptest_table_p3000000060 still exists 159s ok 132 - Check child table had its data removed id_taptest_table_p3000000060 159s ok 133 - Check id_taptest_table_p3000000070 still exists 159s ok 134 - Check child table had its data removed id_taptest_table_p3000000070 159s ok 135 - Check that template table was dropped 159s + pg_prove -ovf test/test_bgw/test-time-daily-bgw.sql 159s ok 159s All tests successful. 159s Files=1, Tests=135, 1 wallclock secs ( 0.04 usr 0.02 sys + 0.04 cusr 0.02 csys = 0.12 CPU) 159s Result: PASS 159s Duplicate specification "psql-bin|b=s" for option "b" 159s Duplicate specification "host|h=s" for option "h" 159s Duplicate specification "port|p=s" for option "p" 159s Duplicate specification "pset|P=s%" for option "P" 159s Duplicate specification "schema|s=s" for option "s" 159s Duplicate specification "version|V" for option "version" 159s Duplicate specification "version|V" for option "V" 159s Duplicate specification "help|H|?" for option "help" 159s Duplicate specification "help|H|?" for option "H" 159s Duplicate specification "help|H|?" for option "?" 159s Duplicate specification "man|m" for option "man" 159s Duplicate specification "man|m" for option "m" 219s psql:test/test_bgw/test-time-daily-bgw.sql:253: NOTICE: Moved 36 row(s) to the target table. Removed 12 partitions. 219s psql:test/test_bgw/test-time-daily-bgw.sql:296: NOTICE: drop cascades to 14 other objects 219s DETAIL: drop cascades to table partman_test.time_taptest_table 219s drop cascades to table partman_test.undo_taptest 219s drop cascades to table partman_test.time_taptest_table_p20250104 219s drop cascades to table partman_test.time_taptest_table_p20250105 219s drop cascades to table partman_test.time_taptest_table_p20250106 219s drop cascades to table partman_test.time_taptest_table_p20250107 219s drop cascades to table partman_test.time_taptest_table_p20250108 219s drop cascades to table partman_test.time_taptest_table_p20250109 219s drop cascades to table partman_test.time_taptest_table_p20250110 219s drop cascades to table partman_test.time_taptest_table_default 219s drop cascades to table partman_test.time_taptest_table_p20250111 219s drop cascades to table partman_test.time_taptest_table_p20250112 219s drop cascades to table partman_test.time_taptest_table_p20250113 219s drop cascades to table partman_test.time_taptest_table_p20250114 219s psql:test/test_bgw/test-time-daily-bgw.sql:297: NOTICE: drop cascades to table partman_retention_test.time_taptest_table_p20250103 219s test/test_bgw/test-time-daily-bgw.sql .. 219s partman, public 219s 1..105 219s t 219s ok 1 - Check time_taptest_table_p20250106 exists 219s ok 2 - Check time_taptest_table_p20250107 exists 219s ok 3 - Check time_taptest_table_p20250108 exists 219s ok 4 - Check time_taptest_table_p20250109 exists 219s ok 5 - Check time_taptest_table_p20250110 exists 219s ok 6 - Check time_taptest_table_p20250111 exists 219s ok 7 - Check for primary key in time_taptest_table_p20250106 219s ok 8 - Check for primary key in time_taptest_table_p20250107 219s ok 9 - Check for primary key in time_taptest_table_p20250108 219s ok 10 - Check for primary key in time_taptest_table_p20250109 219s ok 11 - Check for primary key in time_taptest_table_p20250110 219s ok 12 - Check partman_basic privileges of time_taptest_table_p20250106 219s ok 13 - Check partman_basic privileges of time_taptest_table_p20250107 219s ok 14 - Check partman_basic privileges of time_taptest_table_p20250108 219s ok 15 - Check partman_basic privileges of time_taptest_table_p20250109 219s ok 16 - Check partman_basic privileges of time_taptest_table_p20250110 219s ok 17 - Check partman_revoke privileges of time_taptest_table_p20250106 219s ok 18 - Check partman_revoke privileges of time_taptest_table_p20250107 219s ok 19 - Check partman_revoke privileges of time_taptest_table_p20250108 219s ok 20 - Check partman_revoke privileges of time_taptest_table_p20250109 219s ok 21 - Check partman_revoke privileges of time_taptest_table_p20250110 219s ok 22 - Check count from parent table 219s ok 23 - Check count from time_taptest_table_p20250106 219s ok 24 - Check count from time_taptest_table 219s ok 25 - Check count from time_taptest_table_p20250107 219s ok 26 - Check count from time_taptest_table_p20250108 219s ok 27 - Waiting 20 seconds for background worker to run... 219s ok 28 - Check time_taptest_table_p20250111 exists 219s ok 29 - Check time_taptest_table_p20250112 exists 219s ok 30 - Check time_taptest_table_p20250113 exists 219s ok 31 - Check time_taptest_table_p20250114 exists 219s ok 32 - Check for primary key in time_taptest_table_p20250111 219s ok 33 - Check for primary key in time_taptest_table_p20250112 219s ok 34 - Check for primary key in time_taptest_table_p20250113 219s ok 35 - Check partman_basic privileges of time_taptest_table_p20250111 219s ok 36 - Check partman_basic privileges of time_taptest_table_p20250112 219s ok 37 - Check partman_basic privileges of time_taptest_table_p20250113 219s ok 38 - Check partman_revoke privileges of time_taptest_table_p20250111 219s ok 39 - Check partman_revoke privileges of time_taptest_table_p20250112 219s ok 40 - Check partman_revoke privileges of time_taptest_table_p20250113 219s ok 41 - Waiting 20 seconds for background worker to run... 219s ok 42 - Check time_taptest_table_p20250114 exists 219s ok 43 - Check time_taptest_table_p20250115 exists 219s ok 44 - Check for primary key in time_taptest_table_p20250114 219s ok 45 - Check partman_basic privileges of time_taptest_table_p20250114 219s ok 46 - Check partman_revoke privileges of time_taptest_table_p20250114 219s ok 47 - Check that ownership change worked for time_taptest_table_p20250114 219s ok 48 - Check that data outside scope goes to default 219s ok 49 - Check partman_basic privileges of time_taptest_table_p20250106 219s ok 50 - Check partman_basic privileges of time_taptest_table_p20250107 219s ok 51 - Check partman_basic privileges of time_taptest_table_p20250108 219s ok 52 - Check partman_basic privileges of time_taptest_table_p20250109 219s ok 53 - Check partman_basic privileges of time_taptest_table_p20250110 219s ok 54 - Check partman_basic privileges of time_taptest_table_p20250111 219s ok 55 - Check partman_basic privileges of time_taptest_table_p20250112 219s ok 56 - Check partman_basic privileges of time_taptest_table_p20250113 219s ok 57 - Check partman_basic privileges of time_taptest_table_p20250114 219s ok 58 - Check partman_revoke privileges of time_taptest_table_p20250106 219s ok 59 - Check partman_revoke privileges of time_taptest_table_p20250107 219s ok 60 - Check partman_revoke privileges of time_taptest_table_p20250108 219s ok 61 - Check partman_revoke privileges of time_taptest_table_p20250109 219s ok 62 - Check partman_revoke privileges of time_taptest_table_p20250110 219s ok 63 - Check partman_revoke privileges of time_taptest_table_p20250111 219s ok 64 - Check partman_revoke privileges of time_taptest_table_p20250112 219s ok 65 - Check partman_revoke privileges of time_taptest_table_p20250113 219s ok 66 - Check partman_revoke privileges of time_taptest_table_p20250114 219s ok 67 - Check that ownership change worked for time_taptest_table_p20250106 219s ok 68 - Check that ownership change worked for time_taptest_table_p20250107 219s ok 69 - Check that ownership change worked for time_taptest_table_p20250108 219s ok 70 - Check that ownership change worked for time_taptest_table_p20250109 219s ok 71 - Check that ownership change worked for time_taptest_table_p20250110 219s ok 72 - Check that ownership change worked for time_taptest_table_p20250111 219s ok 73 - Check that ownership change worked for time_taptest_table_p20250112 219s ok 74 - Check that ownership change worked for time_taptest_table_p20250113 219s ok 75 - Check that ownership change worked for time_taptest_table_p20250114 219s 1 219s ok 76 - Check time_taptest_table_p20250102 does not exist 219s ok 77 - Waiting 20 seconds for background worker to run... 219s ok 78 - Check time_taptest_table_p20250103 does not exist 219s ok 79 - Check time_taptest_table_p20250103 got moved to new schema 219s (12,36) 219s ok 80 - Check time_taptest_table_p20250106 exists 219s ok 81 - Check time_taptest_table_p20250107 still exists 219s ok 82 - Check time_taptest_table_p20250105 is empty 219s ok 83 - Check time_taptest_table_p20250105 is empty 219s ok 84 - Check time_taptest_table_p20250104 still exists 219s ok 85 - Check time_taptest_table_p20250104 is empty 219s ok 86 - Check time_taptest_table_p20250107 is empty 219s ok 87 - Check time_taptest_table_p20250108 still exists 219s ok 88 - Check time_taptest_table_p20250108 is empty 219s ok 89 - Check time_taptest_table_p20250109 still exists 219s ok 90 - Check time_taptest_table_p20250109 is empty 219s ok 91 - Check time_taptest_table_p20250110 still exists 219s ok 92 - Check time_taptest_table_p20250110 is empty 219s ok 93 - Check time_taptest_table_p20250111 still exists 219s ok 94 - Check time_taptest_table_p20250111 is empty 219s ok 95 - Check time_taptest_table_p20250112 still exists 219s ok 96 - Check time_taptest_table_p20250112 is empty 219s ok 97 - Check time_taptest_table_p20250113 still exists 219s ok 98 - Check time_taptest_table_p20250113 is empty 219s ok 99 - Check time_taptest_table_p20250114 still exists 219s ok 100 - Check time_taptest_table_p20250114 is empty 219s ok 101 - Ensure partman_test schema has been dropped 219s ok 102 - Ensure partman_retention_test schema has been dropped 219s ok 103 - Ensure partman_basic role has been dropped 219s ok 104 - Ensure partman_revoke role has been dropped 219s ok 105 - Ensure partman_owner role has been dropped 219s ok 219s All tests successful. 219s Files=1, Tests=105, 60 wallclock secs ( 0.03 usr 0.01 sys + 0.03 cusr 0.01 csys = 0.08 CPU) 219s Result: PASS 219s Dropping cluster 17/regress ... 219s ### End 17 virtualenv ### 220s autopkgtest [09:28:54]: test prove: -----------------------] 220s prove PASS 220s autopkgtest [09:28:54]: test prove: - - - - - - - - - - results - - - - - - - - - - 221s autopkgtest [09:28:55]: test scripts: preparing testbed 366s autopkgtest [09:31:20]: testbed dpkg architecture: arm64 366s autopkgtest [09:31:20]: testbed apt version: 2.9.18 366s autopkgtest [09:31:20]: @@@@@@@@@@@@@@@@@@@@ test bed setup 366s autopkgtest [09:31:20]: testbed release detected to be: plucky 367s autopkgtest [09:31:21]: updating testbed package index (apt update) 368s Get:1 http://ftpmaster.internal/ubuntu plucky-proposed InRelease [73.9 kB] 368s Hit:2 http://ftpmaster.internal/ubuntu plucky InRelease 368s Hit:3 http://ftpmaster.internal/ubuntu plucky-updates InRelease 368s Hit:4 http://ftpmaster.internal/ubuntu plucky-security InRelease 368s Get:5 http://ftpmaster.internal/ubuntu plucky-proposed/universe Sources [746 kB] 368s Get:6 http://ftpmaster.internal/ubuntu plucky-proposed/multiverse Sources [17.2 kB] 368s Get:7 http://ftpmaster.internal/ubuntu plucky-proposed/main Sources [105 kB] 368s Get:8 http://ftpmaster.internal/ubuntu plucky-proposed/restricted Sources [9708 B] 368s Get:9 http://ftpmaster.internal/ubuntu plucky-proposed/main arm64 Packages [189 kB] 368s Get:10 http://ftpmaster.internal/ubuntu plucky-proposed/restricted arm64 Packages [57.8 kB] 368s Get:11 http://ftpmaster.internal/ubuntu plucky-proposed/universe arm64 Packages [826 kB] 368s Get:12 http://ftpmaster.internal/ubuntu plucky-proposed/multiverse arm64 Packages [23.1 kB] 368s Fetched 2048 kB in 1s (2176 kB/s) 369s Reading package lists... 370s Reading package lists... 370s Building dependency tree... 370s Reading state information... 371s Calculating upgrade... 371s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 371s Reading package lists... 372s Building dependency tree... 372s Reading state information... 372s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 372s autopkgtest [09:31:26]: upgrading testbed (apt dist-upgrade and autopurge) 373s Reading package lists... 373s Building dependency tree... 373s Reading state information... 373s Calculating upgrade...Starting pkgProblemResolver with broken count: 0 373s Starting 2 pkgProblemResolver with broken count: 0 373s Done 375s Entering ResolveByKeep 375s 375s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 375s Reading package lists... 376s Building dependency tree... 376s Reading state information... 376s Starting pkgProblemResolver with broken count: 0 376s Starting 2 pkgProblemResolver with broken count: 0 376s Done 377s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 380s Reading package lists... 380s Building dependency tree... 380s Reading state information... 381s Starting pkgProblemResolver with broken count: 0 381s Starting 2 pkgProblemResolver with broken count: 0 381s Done 381s The following NEW packages will be installed: 381s libicu76 libjson-perl libpq5 libxslt1.1 postgresql-17 postgresql-17-partman 381s postgresql-client-17 postgresql-client-common postgresql-common 381s python3-psycopg2 ssl-cert 382s 0 upgraded, 11 newly installed, 0 to remove and 0 not upgraded. 382s Need to get 28.9 MB of archives. 382s After this operation, 104 MB of additional disk space will be used. 382s Get:1 http://ftpmaster.internal/ubuntu plucky/main arm64 libjson-perl all 4.10000-1 [81.9 kB] 382s Get:2 http://ftpmaster.internal/ubuntu plucky/main arm64 postgresql-client-common all 262 [36.7 kB] 382s Get:3 http://ftpmaster.internal/ubuntu plucky/main arm64 ssl-cert all 1.1.3ubuntu1 [18.7 kB] 382s Get:4 http://ftpmaster.internal/ubuntu plucky/main arm64 postgresql-common all 262 [162 kB] 382s Get:5 http://ftpmaster.internal/ubuntu plucky-proposed/main arm64 libicu76 arm64 76.1-1ubuntu1 [11.1 MB] 382s Get:6 http://ftpmaster.internal/ubuntu plucky-proposed/main arm64 libpq5 arm64 17.2-1build2 [141 kB] 382s Get:7 http://ftpmaster.internal/ubuntu plucky/main arm64 libxslt1.1 arm64 1.1.39-0exp1ubuntu2 [168 kB] 382s Get:8 http://ftpmaster.internal/ubuntu plucky-proposed/main arm64 postgresql-client-17 arm64 17.2-1build2 [1318 kB] 382s Get:9 http://ftpmaster.internal/ubuntu plucky-proposed/main arm64 postgresql-17 arm64 17.2-1build2 [15.5 MB] 383s Get:10 http://ftpmaster.internal/ubuntu plucky/main arm64 python3-psycopg2 arm64 2.9.10-1 [150 kB] 383s Get:11 http://ftpmaster.internal/ubuntu plucky/universe arm64 postgresql-17-partman arm64 5.2.2-1 [228 kB] 383s Preconfiguring packages ... 384s Fetched 28.9 MB in 2s (18.1 MB/s) 384s Selecting previously unselected package libjson-perl. 384s (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 ... 80185 files and directories currently installed.) 384s Preparing to unpack .../00-libjson-perl_4.10000-1_all.deb ... 384s Unpacking libjson-perl (4.10000-1) ... 384s Selecting previously unselected package postgresql-client-common. 384s Preparing to unpack .../01-postgresql-client-common_262_all.deb ... 384s Unpacking postgresql-client-common (262) ... 384s Selecting previously unselected package ssl-cert. 384s Preparing to unpack .../02-ssl-cert_1.1.3ubuntu1_all.deb ... 384s Unpacking ssl-cert (1.1.3ubuntu1) ... 384s Selecting previously unselected package postgresql-common. 384s Preparing to unpack .../03-postgresql-common_262_all.deb ... 384s Adding 'diversion of /usr/bin/pg_config to /usr/bin/pg_config.libpq-dev by postgresql-common' 384s Unpacking postgresql-common (262) ... 384s Selecting previously unselected package libicu76:arm64. 384s Preparing to unpack .../04-libicu76_76.1-1ubuntu1_arm64.deb ... 384s Unpacking libicu76:arm64 (76.1-1ubuntu1) ... 385s Selecting previously unselected package libpq5:arm64. 385s Preparing to unpack .../05-libpq5_17.2-1build2_arm64.deb ... 385s Unpacking libpq5:arm64 (17.2-1build2) ... 385s Selecting previously unselected package libxslt1.1:arm64. 385s Preparing to unpack .../06-libxslt1.1_1.1.39-0exp1ubuntu2_arm64.deb ... 385s Unpacking libxslt1.1:arm64 (1.1.39-0exp1ubuntu2) ... 385s Selecting previously unselected package postgresql-client-17. 385s Preparing to unpack .../07-postgresql-client-17_17.2-1build2_arm64.deb ... 385s Unpacking postgresql-client-17 (17.2-1build2) ... 385s Selecting previously unselected package postgresql-17. 385s Preparing to unpack .../08-postgresql-17_17.2-1build2_arm64.deb ... 385s Unpacking postgresql-17 (17.2-1build2) ... 385s Selecting previously unselected package python3-psycopg2. 385s Preparing to unpack .../09-python3-psycopg2_2.9.10-1_arm64.deb ... 385s Unpacking python3-psycopg2 (2.9.10-1) ... 385s Selecting previously unselected package postgresql-17-partman. 385s Preparing to unpack .../10-postgresql-17-partman_5.2.2-1_arm64.deb ... 385s Unpacking postgresql-17-partman (5.2.2-1) ... 385s Setting up postgresql-client-common (262) ... 385s Setting up libpq5:arm64 (17.2-1build2) ... 385s Setting up ssl-cert (1.1.3ubuntu1) ... 386s Created symlink '/etc/systemd/system/multi-user.target.wants/ssl-cert.service' → '/usr/lib/systemd/system/ssl-cert.service'. 386s Setting up python3-psycopg2 (2.9.10-1) ... 386s Setting up libjson-perl (4.10000-1) ... 386s Setting up libxslt1.1:arm64 (1.1.39-0exp1ubuntu2) ... 386s Setting up libicu76:arm64 (76.1-1ubuntu1) ... 386s Setting up postgresql-client-17 (17.2-1build2) ... 387s 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 387s Setting up postgresql-common (262) ... 388s Creating config file /etc/postgresql-common/createcluster.conf with new version 388s Building PostgreSQL dictionaries from installed myspell/hunspell packages... 388s Removing obsolete dictionary files: 389s Created symlink '/etc/systemd/system/multi-user.target.wants/postgresql.service' → '/usr/lib/systemd/system/postgresql.service'. 389s Setting up postgresql-17 (17.2-1build2) ... 389s Creating new PostgreSQL cluster 17/main ... 389s /usr/lib/postgresql/17/bin/initdb -D /var/lib/postgresql/17/main --auth-local peer --auth-host scram-sha-256 --no-instructions 389s The files belonging to this database system will be owned by user "postgres". 389s This user must also own the server process. 389s 389s The database cluster will be initialized with locale "C.UTF-8". 389s The default database encoding has accordingly been set to "UTF8". 389s The default text search configuration will be set to "english". 389s 389s Data page checksums are disabled. 389s 389s fixing permissions on existing directory /var/lib/postgresql/17/main ... ok 389s creating subdirectories ... ok 389s selecting dynamic shared memory implementation ... posix 389s selecting default "max_connections" ... 100 389s selecting default "shared_buffers" ... 128MB 389s selecting default time zone ... Etc/UTC 389s creating configuration files ... ok 390s running bootstrap script ... ok 390s performing post-bootstrap initialization ... ok 390s syncing data to disk ... ok 394s Setting up postgresql-17-partman (5.2.2-1) ... 394s Processing triggers for man-db (2.13.0-1) ... 396s Processing triggers for libc-bin (2.40-4ubuntu1) ... 398s autopkgtest [09:31:52]: test scripts: [----------------------- 398s + /usr/lib/postgresql/17/bin/check_unique_constraint.py --help 398s usage: check_unique_constraint.py [-h] [-p PARENT] [-l COLUMN_LIST] 398s [-c CONNECTION] [-t TEMP] [--psql PSQL] 398s [--simple] [--index_scan] [-q] [--version] 398s 398s This script is used to check that all rows in a partition set are unique for 398s the given columns. Since unique constraints are not applied across partition 398s sets, this cannot be enforced within the database. This script can be used as 398s a monitor to ensure uniquness. If any unique violations are found, the values, 398s along with a count of each, are output. 398s 398s options: 398s -h, --help show this help message and exit 398s -p PARENT, --parent PARENT 398s Parent table of the partition set to be checked 398s -l COLUMN_LIST, --column_list COLUMN_LIST 398s Comma separated list of columns that make up the 398s unique constraint to be checked 398s -c CONNECTION, --connection CONNECTION 398s Connection string for use by psycopg. Defaults to 398s "host=" (local socket). 398s -t TEMP, --temp TEMP Path to a writable folder that can be used for temp 398s working files. Defaults system temp folder. 398s --psql PSQL Full path to psql binary if not in current PATH 398s --simple Output a single integer value with the total duplicate 398s count. Use this for monitoring software that requires 398s a simple value to be checked for. 398s --index_scan By default index scans are disabled to force the 398s script to check the actual table data with sequential 398s scans. Set this option if you want the script to allow 398s index scans to be used (does not guarentee that they 398s will be used). 398s -q, --quiet Suppress all output unless there is a constraint 398s violation found. 398s --version Print out the minimum version of pg_partman this 398s script is meant to work with. The version of 398s pg_partman installed may be greater than this. 398s + /usr/lib/postgresql/17/bin/dump_partition.py --help 399s usage: dump_partition.py [-h] [-n SCHEMA] [-c CONNECTION] [-o OUTPUT] 399s [-d DUMP_DATABASE] [--dump_host DUMP_HOST] 399s [--dump_username DUMP_USERNAME] 399s [--dump_port DUMP_PORT] [--pg_dump_path PG_DUMP_PATH] 399s [--Fp] [--nohashfile] [--nodrop] [-v] [--version] 399s 399s This script will dump out and then drop all tables contained in the designated 399s schema using pg_dump. Each table will be in its own separate file along with a 399s SHA-512 hash of the dump file. Tables are not dropped from the database if 399s pg_dump does not return successfully. All dump_* option defaults are the same 399s as they would be for pg_dump if they are not given. 399s 399s options: 399s -h, --help show this help message and exit 399s -n SCHEMA, --schema SCHEMA 399s (Required) The schema that contains the tables that 399s will be dumped. 399s -c CONNECTION, --connection CONNECTION 399s Connection string for use by psycopg. Role used must 399s be able to select pg_catalog.pg_tables in the relevant 399s database and drop all tables in the given schema. 399s Defaults to "host=" (local socket). Note this is 399s distinct from the parameters sent to pg_dump. 399s -o OUTPUT, --output OUTPUT 399s Path to dump file output location. Default is where 399s the script is run from. 399s -d DUMP_DATABASE, --dump_database DUMP_DATABASE 399s Used for pg_dump, same as its --dbname (-d) option or 399s final database name parameter. 399s --dump_host DUMP_HOST 399s Used for pg_dump, same as its --host (-h) option. 399s --dump_username DUMP_USERNAME 399s Used for pg_dump, same as its --username (-U) option. 399s --dump_port DUMP_PORT 399s Used for pg_dump, same as its --port (-p) option. 399s --pg_dump_path PG_DUMP_PATH 399s Path to pg_dump binary location. Must set if not in 399s current PATH. 399s --Fp Dump using pg_dump plain text format. Default is 399s binary custom (-Fc). 399s --nohashfile Do NOT create a separate file with the SHA-512 hash of 399s the dump. If dump files are very large, hash 399s generation can possibly take a long time. 399s --nodrop Do NOT drop the tables from the given schema after 399s dumping/hashing. 399s -v, --verbose Provide more verbose output. 399s --version Print out the minimum version of pg_partman this 399s script is meant to work with. The version of 399s pg_partman installed may be greater than this. 399s 399s NOTE: The connection options for psyocpg and pg_dump were separated out due to 399s distinct differences in their requirements depending on your database 399s connection configuration. 399s + /usr/lib/postgresql/17/bin/vacuum_maintenance.py --help 399s usage: vacuum_maintenance.py [-h] [-p PARENT] [--all] [-c CONNECTION] [-z] 399s [-f] [-a VACUUM_FREEZE_MIN_AGE] [-t {time,id}] 399s [-i INTERVAL] [--noparent] [--dryrun] [-q] 399s [--version] [--debug] 399s 399s Script for performing additional vacuum maintenance on the child tables of a 399s partition set in order to avoid excess vacuuming and transaction id wraparound 399s issues. Whether a table is vacuumed or not by this script depends on whether 399s its age(relfrozenxid) is greater than vacuum_freeze_min_age. This ensures 399s repeated runs of this script do not re-vacuum tables that have already had all 399s of their page tuples frozen. This script does not require pg_partman to be 399s installed and will work on any inheritance set given a parent table, as long 399s as the options --all, --type or --interval are NOT set. 399s 399s options: 399s -h, --help show this help message and exit 399s -p PARENT, --parent PARENT 399s Parent table of an already created 399s partition/inheritance set. Either this option or --all 399s is required. 399s --all Run against all tables managed by pg_partman. Either 399s this option or -p is required. Overrides -p if both 399s are set. 399s -c CONNECTION, --connection CONNECTION 399s Connection string for use by psycopg. Defaults to 399s "host=" (local socket). 399s -z, --freeze Sets the FREEZE option to the VACUUM command. 399s -f, --full Sets the FULL option to the VACUUM command. Note that 399s --freeze is not necessary if you set this. Recommend 399s reviewing --dryrun before running this since it will 399s lock all tables it runs against, possibly including 399s the parent. 399s -a VACUUM_FREEZE_MIN_AGE, --vacuum_freeze_min_age VACUUM_FREEZE_MIN_AGE 399s By default the script obtains this value from the 399s system catalogs. By setting this, you can override the 399s value obtained from the database. Note this does not 399s change the value in the database, only the value this 399s script uses. 399s -t {time,id}, --type {time,id} 399s Tells the script whether the value given by --interval 399s is either time or id based. Also, if --all is set, 399s limits the partition sets that the script runs against 399s to just those types. Valid values are: "id" and 399s "time". 399s -i INTERVAL, --interval INTERVAL 399s In addition to checking transaction age, only run 399s against tables that are older than the interval given. 399s Takes either a postgresql time interval or integer 399s value. For time-based partitioning, uses the time that 399s script is run as baseline. For id-based partitioning, 399s the integer value will set that any partitions with an 399s id value less than the current maximum id value minus 399s the given value will be vacuumed. For example, if the 399s current max id is 100 and the given value is 30, any 399s partitions with id values less than 70 will be 399s vacuumed. The current maximum id value at the time the 399s script is run is always used. 399s --noparent Normally the parent table is included in the list of 399s tables to vacuum if its age(relfrozenxid) is higher 399s than vacuum_freeze_min_age. Set this to force 399s exclusion of the parent table, even if it meets that 399s criteria. 399s --dryrun Show what the script will do without actually running 399s it against the database. Highly recommend reviewing 399s this before running for the first time. 399s -q, --quiet Turn off all output. 399s --version Print out the minimum version of pg_partman this 399s script is meant to work with. The version of 399s pg_partman installed may be greater than this. 399s --debug Show additional debugging output 399s autopkgtest [09:31:53]: test scripts: -----------------------] 399s autopkgtest [09:31:53]: test scripts: - - - - - - - - - - results - - - - - - - - - - 399s scripts PASS 400s autopkgtest [09:31:54]: @@@@@@@@@@@@@@@@@@@@ summary 400s prove PASS 400s scripts PASS 416s nova [W] Using flock in prodstack6-arm64 416s Creating nova instance adt-plucky-arm64-pg-partman-20250106-092514-juju-7f2275-prod-proposed-migration-environment-20-895c4266-aad0-4b27-a887-0e727e15f4ad from image adt/ubuntu-plucky-arm64-server-20250106.img (UUID 0be70afa-891d-4967-bd77-8481ebe681bd)... 416s nova [W] Timed out waiting for 60ab8597-c781-4b62-9aea-128de7db705c to get deleted. 416s nova [W] Using flock in prodstack6-arm64 416s Creating nova instance adt-plucky-arm64-pg-partman-20250106-092514-juju-7f2275-prod-proposed-migration-environment-20-895c4266-aad0-4b27-a887-0e727e15f4ad from image adt/ubuntu-plucky-arm64-server-20250106.img (UUID 0be70afa-891d-4967-bd77-8481ebe681bd)... 416s nova [W] Timed out waiting for 8f9b33ab-61cb-4c91-a782-284ea9f17535 to get deleted.