0s autopkgtest [06:55:53]: starting date and time: 2025-02-22 06:55:53+0000 1s autopkgtest [06:55:54]: git checkout: 325255d2 Merge branch 'pin-any-arch' into 'ubuntu/production' 1s autopkgtest [06:55:54]: host juju-7f2275-prod-proposed-migration-environment-2; command line: /home/ubuntu/autopkgtest/runner/autopkgtest --output-dir /tmp/autopkgtest-work.28501puw/out --timeout-copy=6000 --setup-commands /home/ubuntu/autopkgtest-cloud/worker-config-production/setup-canonical.sh --apt-pocket=proposed=src:postgresql-17 --apt-upgrade pg-dirtyread --timeout-short=300 --timeout-copy=20000 --timeout-build=20000 --env=ADT_TEST_TRIGGERS=postgresql-17/17.4-1 -- ssh -s /home/ubuntu/autopkgtest/ssh-setup/nova -- --flavor autopkgtest-ppc64el --security-groups autopkgtest-juju-7f2275-prod-proposed-migration-environment-2@bos03-ppc64el-14.secgroup --name adt-plucky-ppc64el-pg-dirtyread-20250222-065553-juju-7f2275-prod-proposed-migration-environment-2-c5a8fd07-b06d-484c-93d6-a79db7cdbfed --image adt/ubuntu-plucky-ppc64el-server --keyname testbed-juju-7f2275-prod-proposed-migration-environment-2 --net-id=net_prod-proposed-migration-ppc64el -e TERM=linux -e ''"'"'http_proxy=http://squid.internal:3128'"'"'' -e ''"'"'https_proxy=http://squid.internal:3128'"'"'' -e ''"'"'no_proxy=127.0.0.1,127.0.1.1,login.ubuntu.com,localhost,localdomain,novalocal,internal,archive.ubuntu.com,ports.ubuntu.com,security.ubuntu.com,ddebs.ubuntu.com,changelogs.ubuntu.com,keyserver.ubuntu.com,launchpadlibrarian.net,launchpadcontent.net,launchpad.net,10.24.0.0/24,keystone.ps5.canonical.com,objectstorage.prodstack5.canonical.com,radosgw.ps5.canonical.com'"'"'' --mirror=http://ftpmaster.internal/ubuntu/ 122s autopkgtest [06:57:55]: testbed dpkg architecture: ppc64el 122s autopkgtest [06:57:55]: testbed apt version: 2.9.30ubuntu1 123s autopkgtest [06:57:56]: @@@@@@@@@@@@@@@@@@@@ test bed setup 123s autopkgtest [06:57:56]: testbed release detected to be: None 124s autopkgtest [06:57:57]: updating testbed package index (apt update) 124s Get:1 http://ftpmaster.internal/ubuntu plucky-proposed InRelease [110 kB] 124s Hit:2 http://ftpmaster.internal/ubuntu plucky InRelease 124s Hit:3 http://ftpmaster.internal/ubuntu plucky-updates InRelease 124s Hit:4 http://ftpmaster.internal/ubuntu plucky-security InRelease 124s Get:5 http://ftpmaster.internal/ubuntu plucky-proposed/universe Sources [504 kB] 125s Get:6 http://ftpmaster.internal/ubuntu plucky-proposed/main Sources [80.9 kB] 125s Get:7 http://ftpmaster.internal/ubuntu plucky-proposed/restricted Sources [3120 B] 125s Get:8 http://ftpmaster.internal/ubuntu plucky-proposed/multiverse Sources [13.5 kB] 125s Get:9 http://ftpmaster.internal/ubuntu plucky-proposed/main ppc64el Packages [127 kB] 125s Get:10 http://ftpmaster.internal/ubuntu plucky-proposed/restricted ppc64el Packages [760 B] 125s Get:11 http://ftpmaster.internal/ubuntu plucky-proposed/universe ppc64el Packages [432 kB] 125s Get:12 http://ftpmaster.internal/ubuntu plucky-proposed/multiverse ppc64el Packages [3292 B] 125s Fetched 1276 kB in 1s (1424 kB/s) 126s Reading package lists... 126s Reading package lists... 126s Building dependency tree... 126s Reading state information... 127s Calculating upgrade... 127s Calculating upgrade... 127s The following packages will be upgraded: 127s curl libcurl3t64-gnutls libcurl4t64 127s 3 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 127s Need to get 1221 kB of archives. 127s After this operation, 3072 B disk space will be freed. 127s Get:1 http://ftpmaster.internal/ubuntu plucky/main ppc64el curl ppc64el 8.12.1-2ubuntu1 [258 kB] 128s Get:2 http://ftpmaster.internal/ubuntu plucky/main ppc64el libcurl4t64 ppc64el 8.12.1-2ubuntu1 [482 kB] 128s Get:3 http://ftpmaster.internal/ubuntu plucky/main ppc64el libcurl3t64-gnutls ppc64el 8.12.1-2ubuntu1 [481 kB] 128s Fetched 1221 kB in 1s (1999 kB/s) 129s (Reading database ... (Reading database ... 5% (Reading database ... 10% (Reading database ... 15% (Reading database ... 20% (Reading database ... 25% (Reading database ... 30% (Reading database ... 35% (Reading database ... 40% (Reading database ... 45% (Reading database ... 50% (Reading database ... 55% (Reading database ... 60% (Reading database ... 65% (Reading database ... 70% (Reading database ... 75% (Reading database ... 80% (Reading database ... 85% (Reading database ... 90% (Reading database ... 95% (Reading database ... 100% (Reading database ... 106371 files and directories currently installed.) 129s Preparing to unpack .../curl_8.12.1-2ubuntu1_ppc64el.deb ... 129s Unpacking curl (8.12.1-2ubuntu1) over (8.12.0+git20250209.89ed161+ds-1ubuntu1) ... 129s Preparing to unpack .../libcurl4t64_8.12.1-2ubuntu1_ppc64el.deb ... 129s Unpacking libcurl4t64:ppc64el (8.12.1-2ubuntu1) over (8.12.0+git20250209.89ed161+ds-1ubuntu1) ... 129s Preparing to unpack .../libcurl3t64-gnutls_8.12.1-2ubuntu1_ppc64el.deb ... 129s Unpacking libcurl3t64-gnutls:ppc64el (8.12.1-2ubuntu1) over (8.12.0+git20250209.89ed161+ds-1ubuntu1) ... 129s Setting up libcurl4t64:ppc64el (8.12.1-2ubuntu1) ... 129s Setting up libcurl3t64-gnutls:ppc64el (8.12.1-2ubuntu1) ... 129s Setting up curl (8.12.1-2ubuntu1) ... 129s Processing triggers for man-db (2.13.0-1) ... 129s Processing triggers for libc-bin (2.40-4ubuntu1) ... 130s Reading package lists... 130s Building dependency tree... 130s Reading state information... 130s Solving dependencies... 130s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 130s autopkgtest [06:58:03]: upgrading testbed (apt dist-upgrade and autopurge) 131s Reading package lists... 131s Building dependency tree... 131s Reading state information... 131s Calculating upgrade...Starting pkgProblemResolver with broken count: 0 131s Starting 2 pkgProblemResolver with broken count: 0 131s Done 132s Entering ResolveByKeep 132s 133s Calculating upgrade... 133s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 133s Reading package lists... 133s Building dependency tree... 133s Reading state information... 133s Starting pkgProblemResolver with broken count: 0 134s Starting 2 pkgProblemResolver with broken count: 0 134s Done 134s Solving dependencies... 134s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 137s autopkgtest [06:58:10]: testbed running kernel: Linux 6.12.0-15-generic #15-Ubuntu SMP Tue Feb 4 16:32:08 UTC 2025 137s autopkgtest [06:58:10]: @@@@@@@@@@@@@@@@@@@@ apt-source pg-dirtyread 139s Get:1 http://ftpmaster.internal/ubuntu plucky/universe pg-dirtyread 2.7-2 (dsc) [2045 B] 139s Get:2 http://ftpmaster.internal/ubuntu plucky/universe pg-dirtyread 2.7-2 (tar) [21.9 kB] 139s Get:3 http://ftpmaster.internal/ubuntu plucky/universe pg-dirtyread 2.7-2 (diff) [2984 B] 139s gpgv: Signature made Fri Sep 13 16:17:32 2024 UTC 139s gpgv: using RSA key 5C48FE6157F49179597087C64C5A6BAB12D2A7AE 139s gpgv: Can't check signature: No public key 139s dpkg-source: warning: cannot verify inline signature for ./pg-dirtyread_2.7-2.dsc: no acceptable signature found 139s autopkgtest [06:58:12]: testing package pg-dirtyread version 2.7-2 140s autopkgtest [06:58:13]: build not needed 140s autopkgtest [06:58:13]: test installcheck: preparing testbed 140s Reading package lists... 141s Building dependency tree... 141s Reading state information... 141s Starting pkgProblemResolver with broken count: 0 141s Starting 2 pkgProblemResolver with broken count: 0 141s Done 142s The following NEW packages will be installed: 142s libio-pty-perl libipc-run-perl libjson-perl libllvm20 libpq5 libxslt1.1 142s postgresql-17 postgresql-17-dirtyread postgresql-client-17 142s postgresql-client-common postgresql-common postgresql-common-dev ssl-cert 142s 0 upgraded, 13 newly installed, 0 to remove and 0 not upgraded. 142s Need to get 51.4 MB of archives. 142s After this operation, 222 MB of additional disk space will be used. 142s Get:1 http://ftpmaster.internal/ubuntu plucky/main ppc64el libjson-perl all 4.10000-1 [81.9 kB] 142s Get:2 http://ftpmaster.internal/ubuntu plucky/main ppc64el postgresql-client-common all 273 [47.5 kB] 142s Get:3 http://ftpmaster.internal/ubuntu plucky/main ppc64el libio-pty-perl ppc64el 1:1.20-1build3 [32.0 kB] 142s Get:4 http://ftpmaster.internal/ubuntu plucky/main ppc64el libipc-run-perl all 20231003.0-2 [91.5 kB] 142s Get:5 http://ftpmaster.internal/ubuntu plucky/main ppc64el postgresql-common-dev all 273 [72.9 kB] 142s Get:6 http://ftpmaster.internal/ubuntu plucky/main ppc64el ssl-cert all 1.1.3ubuntu1 [18.7 kB] 142s Get:7 http://ftpmaster.internal/ubuntu plucky/main ppc64el postgresql-common all 273 [101 kB] 142s Get:8 http://ftpmaster.internal/ubuntu plucky/main ppc64el libllvm20 ppc64el 1:20.1.0~+rc2-1~exp2ubuntu0.4 [31.9 MB] 143s Get:9 http://ftpmaster.internal/ubuntu plucky-proposed/main ppc64el libpq5 ppc64el 17.4-1 [174 kB] 143s Get:10 http://ftpmaster.internal/ubuntu plucky/main ppc64el libxslt1.1 ppc64el 1.1.39-0exp1ubuntu2 [191 kB] 143s Get:11 http://ftpmaster.internal/ubuntu plucky-proposed/main ppc64el postgresql-client-17 ppc64el 17.4-1 [1482 kB] 143s Get:12 http://ftpmaster.internal/ubuntu plucky-proposed/main ppc64el postgresql-17 ppc64el 17.4-1 [17.2 MB] 143s Get:13 http://ftpmaster.internal/ubuntu plucky/universe ppc64el postgresql-17-dirtyread ppc64el 2.7-2 [24.2 kB] 144s Preconfiguring packages ... 144s Fetched 51.4 MB in 2s (28.7 MB/s) 144s Selecting previously unselected package libjson-perl. 144s (Reading database ... (Reading database ... 5% (Reading database ... 10% (Reading database ... 15% (Reading database ... 20% (Reading database ... 25% (Reading database ... 30% (Reading database ... 35% (Reading database ... 40% (Reading database ... 45% (Reading database ... 50% (Reading database ... 55% (Reading database ... 60% (Reading database ... 65% (Reading database ... 70% (Reading database ... 75% (Reading database ... 80% (Reading database ... 85% (Reading database ... 90% (Reading database ... 95% (Reading database ... 100% (Reading database ... 106371 files and directories currently installed.) 144s Preparing to unpack .../00-libjson-perl_4.10000-1_all.deb ... 144s Unpacking libjson-perl (4.10000-1) ... 144s Selecting previously unselected package postgresql-client-common. 144s Preparing to unpack .../01-postgresql-client-common_273_all.deb ... 144s Unpacking postgresql-client-common (273) ... 144s Selecting previously unselected package libio-pty-perl. 144s Preparing to unpack .../02-libio-pty-perl_1%3a1.20-1build3_ppc64el.deb ... 144s Unpacking libio-pty-perl (1:1.20-1build3) ... 144s Selecting previously unselected package libipc-run-perl. 144s Preparing to unpack .../03-libipc-run-perl_20231003.0-2_all.deb ... 144s Unpacking libipc-run-perl (20231003.0-2) ... 144s Selecting previously unselected package postgresql-common-dev. 144s Preparing to unpack .../04-postgresql-common-dev_273_all.deb ... 144s Unpacking postgresql-common-dev (273) ... 144s Selecting previously unselected package ssl-cert. 144s Preparing to unpack .../05-ssl-cert_1.1.3ubuntu1_all.deb ... 144s Unpacking ssl-cert (1.1.3ubuntu1) ... 144s Selecting previously unselected package postgresql-common. 144s Preparing to unpack .../06-postgresql-common_273_all.deb ... 144s Adding 'diversion of /usr/bin/pg_config to /usr/bin/pg_config.libpq-dev by postgresql-common' 144s Unpacking postgresql-common (273) ... 144s Selecting previously unselected package libllvm20:ppc64el. 144s Preparing to unpack .../07-libllvm20_1%3a20.1.0~+rc2-1~exp2ubuntu0.4_ppc64el.deb ... 144s Unpacking libllvm20:ppc64el (1:20.1.0~+rc2-1~exp2ubuntu0.4) ... 145s Selecting previously unselected package libpq5:ppc64el. 145s Preparing to unpack .../08-libpq5_17.4-1_ppc64el.deb ... 145s Unpacking libpq5:ppc64el (17.4-1) ... 145s Selecting previously unselected package libxslt1.1:ppc64el. 145s Preparing to unpack .../09-libxslt1.1_1.1.39-0exp1ubuntu2_ppc64el.deb ... 145s Unpacking libxslt1.1:ppc64el (1.1.39-0exp1ubuntu2) ... 145s Selecting previously unselected package postgresql-client-17. 145s Preparing to unpack .../10-postgresql-client-17_17.4-1_ppc64el.deb ... 145s Unpacking postgresql-client-17 (17.4-1) ... 145s Selecting previously unselected package postgresql-17. 145s Preparing to unpack .../11-postgresql-17_17.4-1_ppc64el.deb ... 145s Unpacking postgresql-17 (17.4-1) ... 145s Selecting previously unselected package postgresql-17-dirtyread. 145s Preparing to unpack .../12-postgresql-17-dirtyread_2.7-2_ppc64el.deb ... 145s Unpacking postgresql-17-dirtyread (2.7-2) ... 145s Setting up postgresql-client-common (273) ... 145s Setting up libio-pty-perl (1:1.20-1build3) ... 145s Setting up libpq5:ppc64el (17.4-1) ... 145s Setting up ssl-cert (1.1.3ubuntu1) ... 146s Created symlink '/etc/systemd/system/multi-user.target.wants/ssl-cert.service' → '/usr/lib/systemd/system/ssl-cert.service'. 146s Setting up libllvm20:ppc64el (1:20.1.0~+rc2-1~exp2ubuntu0.4) ... 146s Setting up libipc-run-perl (20231003.0-2) ... 146s Setting up libjson-perl (4.10000-1) ... 146s Setting up libxslt1.1:ppc64el (1.1.39-0exp1ubuntu2) ... 146s Setting up postgresql-common-dev (273) ... 146s Setting up postgresql-client-17 (17.4-1) ... 147s 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 147s Setting up postgresql-common (273) ... 147s Creating config file /etc/postgresql-common/createcluster.conf with new version 147s Building PostgreSQL dictionaries from installed myspell/hunspell packages... 147s Removing obsolete dictionary files: 148s Created symlink '/etc/systemd/system/multi-user.target.wants/postgresql.service' → '/usr/lib/systemd/system/postgresql.service'. 148s Setting up postgresql-17 (17.4-1) ... 149s Creating new PostgreSQL cluster 17/main ... 149s /usr/lib/postgresql/17/bin/initdb -D /var/lib/postgresql/17/main --auth-local peer --auth-host scram-sha-256 --no-instructions 149s The files belonging to this database system will be owned by user "postgres". 149s This user must also own the server process. 149s 149s The database cluster will be initialized with locale "C.UTF-8". 149s The default database encoding has accordingly been set to "UTF8". 149s The default text search configuration will be set to "english". 149s 149s Data page checksums are disabled. 149s 149s fixing permissions on existing directory /var/lib/postgresql/17/main ... ok 149s creating subdirectories ... ok 149s selecting dynamic shared memory implementation ... posix 149s selecting default "max_connections" ... 100 149s selecting default "shared_buffers" ... 128MB 149s selecting default time zone ... Etc/UTC 149s creating configuration files ... ok 149s running bootstrap script ... ok 150s performing post-bootstrap initialization ... ok 150s syncing data to disk ... ok 153s Setting up postgresql-17-dirtyread (2.7-2) ... 153s Processing triggers for man-db (2.13.0-1) ... 155s Processing triggers for libc-bin (2.40-4ubuntu1) ... 156s autopkgtest [06:58:29]: test installcheck: [----------------------- 156s ### PostgreSQL 17 installcheck ### 156s Creating new PostgreSQL cluster 17/regress ... 159s echo "# +++ regress install-check in +++" && /usr/lib/postgresql/17/lib/pgxs/src/makefiles/../../src/test/regress/pg_regress --inputdir=./ --bindir='/usr/lib/postgresql/17/bin' --dbname=contrib_regression extension dirtyread oid index toast 159s # +++ regress install-check in +++ 159s # using postmaster on localhost, port 5433 160s ok 1 - extension 42 ms 160s ok 2 - dirtyread 44 ms 160s ok 3 - oid 28 ms 160s ok 4 - index 23 ms 160s ok 5 - toast 37 ms 160s 1..5 160s # All 5 tests passed. 160s Dropping cluster 17/regress ... 160s rm -f pg_dirtyread.so libpg_dirtyread.a libpg_dirtyread.pc 160s rm -f pg_dirtyread.o dirtyread_tupconvert.o pg_dirtyread.bc dirtyread_tupconvert.bc 160s rm -rf results/ regression.diffs regression.out tmp_check/ tmp_check_iso/ log/ output_iso/ 160s ### End 17 installcheck ### 160s autopkgtest [06:58:33]: test installcheck: -----------------------] 161s installcheck PASS 161s autopkgtest [06:58:34]: test installcheck: - - - - - - - - - - results - - - - - - - - - - 161s autopkgtest [06:58:34]: @@@@@@@@@@@@@@@@@@@@ summary 161s installcheck PASS 178s nova [W] Using flock in prodstack6-ppc64el 178s Creating nova instance adt-plucky-ppc64el-pg-dirtyread-20250222-065553-juju-7f2275-prod-proposed-migration-environment-2-c5a8fd07-b06d-484c-93d6-a79db7cdbfed from image adt/ubuntu-plucky-ppc64el-server-20250222.img (UUID fe93544b-49e9-47e0-b80a-745acc8cd85b)... 178s nova [W] Timed out waiting for 7b83501c-a7fd-4608-a306-ce73d8731362 to get deleted.