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