0s autopkgtest [07:00:39]: starting date and time: 2025-02-22 07:00:39+0000 0s autopkgtest [07:00:39]: git checkout: 325255d2 Merge branch 'pin-any-arch' into 'ubuntu/production' 0s autopkgtest [07:00:39]: host juju-7f2275-prod-proposed-migration-environment-2; command line: /home/ubuntu/autopkgtest/runner/autopkgtest --output-dir /tmp/autopkgtest-work.smpsubhf/out --timeout-copy=6000 --setup-commands /home/ubuntu/autopkgtest-cloud/worker-config-production/setup-canonical.sh --apt-pocket=proposed=src:postgresql-17 --apt-upgrade pgauditlogtofile --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-4.secgroup --name adt-plucky-ppc64el-pgauditlogtofile-20250222-070039-juju-7f2275-prod-proposed-migration-environment-2-3e183335-05bb-4bc7-b92e-7ea2ff243368 --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/ 94s autopkgtest [07:02:13]: testbed dpkg architecture: ppc64el 94s autopkgtest [07:02:13]: testbed apt version: 2.9.30ubuntu1 94s autopkgtest [07:02:13]: @@@@@@@@@@@@@@@@@@@@ test bed setup 94s autopkgtest [07:02:13]: testbed release detected to be: None 95s autopkgtest [07:02:14]: updating testbed package index (apt update) 96s Get:1 http://ftpmaster.internal/ubuntu plucky-proposed InRelease [110 kB] 96s Hit:2 http://ftpmaster.internal/ubuntu plucky InRelease 96s Hit:3 http://ftpmaster.internal/ubuntu plucky-updates InRelease 96s Hit:4 http://ftpmaster.internal/ubuntu plucky-security InRelease 96s Get:5 http://ftpmaster.internal/ubuntu plucky-proposed/multiverse Sources [13.5 kB] 96s Get:6 http://ftpmaster.internal/ubuntu plucky-proposed/restricted Sources [3120 B] 96s Get:7 http://ftpmaster.internal/ubuntu plucky-proposed/universe Sources [504 kB] 96s Get:8 http://ftpmaster.internal/ubuntu plucky-proposed/main Sources [80.9 kB] 96s Get:9 http://ftpmaster.internal/ubuntu plucky-proposed/main ppc64el Packages [127 kB] 96s Get:10 http://ftpmaster.internal/ubuntu plucky-proposed/restricted ppc64el Packages [760 B] 96s Get:11 http://ftpmaster.internal/ubuntu plucky-proposed/universe ppc64el Packages [432 kB] 96s Get:12 http://ftpmaster.internal/ubuntu plucky-proposed/multiverse ppc64el Packages [3292 B] 96s Fetched 1276 kB in 1s (1405 kB/s) 97s Reading package lists... 98s Reading package lists... 98s Building dependency tree... 98s Reading state information... 99s Calculating upgrade... 99s Calculating upgrade... 99s The following packages will be upgraded: 99s curl libcurl3t64-gnutls libcurl4t64 99s 3 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 99s Need to get 1221 kB of archives. 99s After this operation, 3072 B disk space will be freed. 99s Get:1 http://ftpmaster.internal/ubuntu plucky/main ppc64el curl ppc64el 8.12.1-2ubuntu1 [258 kB] 99s Get:2 http://ftpmaster.internal/ubuntu plucky/main ppc64el libcurl4t64 ppc64el 8.12.1-2ubuntu1 [482 kB] 99s Get:3 http://ftpmaster.internal/ubuntu plucky/main ppc64el libcurl3t64-gnutls ppc64el 8.12.1-2ubuntu1 [481 kB] 100s Fetched 1221 kB in 1s (2006 kB/s) 100s (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.) 100s Preparing to unpack .../curl_8.12.1-2ubuntu1_ppc64el.deb ... 100s Unpacking curl (8.12.1-2ubuntu1) over (8.12.0+git20250209.89ed161+ds-1ubuntu1) ... 100s Preparing to unpack .../libcurl4t64_8.12.1-2ubuntu1_ppc64el.deb ... 100s Unpacking libcurl4t64:ppc64el (8.12.1-2ubuntu1) over (8.12.0+git20250209.89ed161+ds-1ubuntu1) ... 100s Preparing to unpack .../libcurl3t64-gnutls_8.12.1-2ubuntu1_ppc64el.deb ... 100s Unpacking libcurl3t64-gnutls:ppc64el (8.12.1-2ubuntu1) over (8.12.0+git20250209.89ed161+ds-1ubuntu1) ... 100s Setting up libcurl4t64:ppc64el (8.12.1-2ubuntu1) ... 100s Setting up libcurl3t64-gnutls:ppc64el (8.12.1-2ubuntu1) ... 100s Setting up curl (8.12.1-2ubuntu1) ... 100s Processing triggers for man-db (2.13.0-1) ... 101s Processing triggers for libc-bin (2.40-4ubuntu1) ... 101s Reading package lists... 102s Building dependency tree... 102s Reading state information... 102s Solving dependencies... 102s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 102s autopkgtest [07:02:21]: upgrading testbed (apt dist-upgrade and autopurge) 102s Reading package lists... 102s Building dependency tree... 102s Reading state information... 103s Calculating upgrade...Starting pkgProblemResolver with broken count: 0 103s Starting 2 pkgProblemResolver with broken count: 0 103s Done 103s Entering ResolveByKeep 103s 103s Calculating upgrade... 104s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 104s Reading package lists... 104s Building dependency tree... 104s Reading state information... 104s Starting pkgProblemResolver with broken count: 0 104s Starting 2 pkgProblemResolver with broken count: 0 104s Done 105s Solving dependencies... 105s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 107s autopkgtest [07:02:26]: testbed running kernel: Linux 6.12.0-15-generic #15-Ubuntu SMP Tue Feb 4 16:32:08 UTC 2025 108s autopkgtest [07:02:27]: @@@@@@@@@@@@@@@@@@@@ apt-source pgauditlogtofile 109s Get:1 http://ftpmaster.internal/ubuntu plucky/universe pgauditlogtofile 1.6.4-1 (dsc) [2264 B] 109s Get:2 http://ftpmaster.internal/ubuntu plucky/universe pgauditlogtofile 1.6.4-1 (tar) [14.8 kB] 109s Get:3 http://ftpmaster.internal/ubuntu plucky/universe pgauditlogtofile 1.6.4-1 (diff) [3396 B] 110s gpgv: Signature made Sat Dec 21 19:59:10 2024 UTC 110s gpgv: using RSA key 5C48FE6157F49179597087C64C5A6BAB12D2A7AE 110s gpgv: Can't check signature: No public key 110s dpkg-source: warning: cannot verify inline signature for ./pgauditlogtofile_1.6.4-1.dsc: no acceptable signature found 110s autopkgtest [07:02:29]: testing package pgauditlogtofile version 1.6.4-1 110s autopkgtest [07:02:29]: build not needed 110s autopkgtest [07:02:29]: test logtofile: preparing testbed 110s Reading package lists... 111s Building dependency tree... 111s Reading state information... 111s Starting pkgProblemResolver with broken count: 0 111s Starting 2 pkgProblemResolver with broken count: 0 111s Done 111s The following NEW packages will be installed: 111s libio-pty-perl libipc-run-perl libjson-perl libllvm20 libpq5 libxslt1.1 111s postgresql-17 postgresql-17-pgaudit postgresql-17-pgauditlogtofile 111s postgresql-client-17 postgresql-client-common postgresql-common 111s postgresql-common-dev ssl-cert 111s 0 upgraded, 14 newly installed, 0 to remove and 0 not upgraded. 111s Need to get 51.5 MB of archives. 111s After this operation, 222 MB of additional disk space will be used. 111s Get:1 http://ftpmaster.internal/ubuntu plucky/main ppc64el libjson-perl all 4.10000-1 [81.9 kB] 112s Get:2 http://ftpmaster.internal/ubuntu plucky/main ppc64el postgresql-client-common all 273 [47.5 kB] 112s Get:3 http://ftpmaster.internal/ubuntu plucky/main ppc64el libio-pty-perl ppc64el 1:1.20-1build3 [32.0 kB] 112s Get:4 http://ftpmaster.internal/ubuntu plucky/main ppc64el libipc-run-perl all 20231003.0-2 [91.5 kB] 112s Get:5 http://ftpmaster.internal/ubuntu plucky/main ppc64el postgresql-common-dev all 273 [72.9 kB] 112s Get:6 http://ftpmaster.internal/ubuntu plucky/main ppc64el ssl-cert all 1.1.3ubuntu1 [18.7 kB] 112s Get:7 http://ftpmaster.internal/ubuntu plucky/main ppc64el postgresql-common all 273 [101 kB] 112s Get:8 http://ftpmaster.internal/ubuntu plucky/main ppc64el libllvm20 ppc64el 1:20.1.0~+rc2-1~exp2ubuntu0.4 [31.9 MB] 113s Get:9 http://ftpmaster.internal/ubuntu plucky-proposed/main ppc64el libpq5 ppc64el 17.4-1 [174 kB] 113s Get:10 http://ftpmaster.internal/ubuntu plucky/main ppc64el libxslt1.1 ppc64el 1.1.39-0exp1ubuntu2 [191 kB] 113s Get:11 http://ftpmaster.internal/ubuntu plucky-proposed/main ppc64el postgresql-client-17 ppc64el 17.4-1 [1482 kB] 113s Get:12 http://ftpmaster.internal/ubuntu plucky-proposed/main ppc64el postgresql-17 ppc64el 17.4-1 [17.2 MB] 114s Get:13 http://ftpmaster.internal/ubuntu plucky/universe ppc64el postgresql-17-pgaudit ppc64el 17.0-2 [51.9 kB] 114s Get:14 http://ftpmaster.internal/ubuntu plucky/universe ppc64el postgresql-17-pgauditlogtofile ppc64el 1.6.4-1 [45.5 kB] 114s Preconfiguring packages ... 114s Fetched 51.5 MB in 3s (20.4 MB/s) 114s Selecting previously unselected package libjson-perl. 114s (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.) 114s Preparing to unpack .../00-libjson-perl_4.10000-1_all.deb ... 114s Unpacking libjson-perl (4.10000-1) ... 114s Selecting previously unselected package postgresql-client-common. 114s Preparing to unpack .../01-postgresql-client-common_273_all.deb ... 114s Unpacking postgresql-client-common (273) ... 114s Selecting previously unselected package libio-pty-perl. 114s Preparing to unpack .../02-libio-pty-perl_1%3a1.20-1build3_ppc64el.deb ... 114s Unpacking libio-pty-perl (1:1.20-1build3) ... 114s Selecting previously unselected package libipc-run-perl. 114s Preparing to unpack .../03-libipc-run-perl_20231003.0-2_all.deb ... 114s Unpacking libipc-run-perl (20231003.0-2) ... 114s Selecting previously unselected package postgresql-common-dev. 114s Preparing to unpack .../04-postgresql-common-dev_273_all.deb ... 114s Unpacking postgresql-common-dev (273) ... 114s Selecting previously unselected package ssl-cert. 114s Preparing to unpack .../05-ssl-cert_1.1.3ubuntu1_all.deb ... 114s Unpacking ssl-cert (1.1.3ubuntu1) ... 114s Selecting previously unselected package postgresql-common. 114s Preparing to unpack .../06-postgresql-common_273_all.deb ... 114s Adding 'diversion of /usr/bin/pg_config to /usr/bin/pg_config.libpq-dev by postgresql-common' 114s Unpacking postgresql-common (273) ... 114s Selecting previously unselected package libllvm20:ppc64el. 114s Preparing to unpack .../07-libllvm20_1%3a20.1.0~+rc2-1~exp2ubuntu0.4_ppc64el.deb ... 114s Unpacking libllvm20:ppc64el (1:20.1.0~+rc2-1~exp2ubuntu0.4) ... 115s Selecting previously unselected package libpq5:ppc64el. 115s Preparing to unpack .../08-libpq5_17.4-1_ppc64el.deb ... 115s Unpacking libpq5:ppc64el (17.4-1) ... 115s Selecting previously unselected package libxslt1.1:ppc64el. 115s Preparing to unpack .../09-libxslt1.1_1.1.39-0exp1ubuntu2_ppc64el.deb ... 115s Unpacking libxslt1.1:ppc64el (1.1.39-0exp1ubuntu2) ... 115s Selecting previously unselected package postgresql-client-17. 115s Preparing to unpack .../10-postgresql-client-17_17.4-1_ppc64el.deb ... 115s Unpacking postgresql-client-17 (17.4-1) ... 115s Selecting previously unselected package postgresql-17. 115s Preparing to unpack .../11-postgresql-17_17.4-1_ppc64el.deb ... 115s Unpacking postgresql-17 (17.4-1) ... 116s Selecting previously unselected package postgresql-17-pgaudit. 116s Preparing to unpack .../12-postgresql-17-pgaudit_17.0-2_ppc64el.deb ... 116s Unpacking postgresql-17-pgaudit (17.0-2) ... 116s Selecting previously unselected package postgresql-17-pgauditlogtofile. 116s Preparing to unpack .../13-postgresql-17-pgauditlogtofile_1.6.4-1_ppc64el.deb ... 116s Unpacking postgresql-17-pgauditlogtofile (1.6.4-1) ... 116s Setting up postgresql-client-common (273) ... 116s Setting up libio-pty-perl (1:1.20-1build3) ... 116s Setting up libpq5:ppc64el (17.4-1) ... 116s Setting up ssl-cert (1.1.3ubuntu1) ... 116s Created symlink '/etc/systemd/system/multi-user.target.wants/ssl-cert.service' → '/usr/lib/systemd/system/ssl-cert.service'. 117s Setting up libllvm20:ppc64el (1:20.1.0~+rc2-1~exp2ubuntu0.4) ... 117s Setting up libipc-run-perl (20231003.0-2) ... 117s Setting up libjson-perl (4.10000-1) ... 117s Setting up libxslt1.1:ppc64el (1.1.39-0exp1ubuntu2) ... 117s Setting up postgresql-common-dev (273) ... 117s Setting up postgresql-client-17 (17.4-1) ... 117s 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 117s Setting up postgresql-common (273) ... 118s Creating config file /etc/postgresql-common/createcluster.conf with new version 118s Building PostgreSQL dictionaries from installed myspell/hunspell packages... 118s Removing obsolete dictionary files: 119s Created symlink '/etc/systemd/system/multi-user.target.wants/postgresql.service' → '/usr/lib/systemd/system/postgresql.service'. 119s Setting up postgresql-17 (17.4-1) ... 120s Creating new PostgreSQL cluster 17/main ... 120s /usr/lib/postgresql/17/bin/initdb -D /var/lib/postgresql/17/main --auth-local peer --auth-host scram-sha-256 --no-instructions 120s The files belonging to this database system will be owned by user "postgres". 120s This user must also own the server process. 120s 120s The database cluster will be initialized with locale "C.UTF-8". 120s The default database encoding has accordingly been set to "UTF8". 120s The default text search configuration will be set to "english". 120s 120s Data page checksums are disabled. 120s 120s fixing permissions on existing directory /var/lib/postgresql/17/main ... ok 120s creating subdirectories ... ok 120s selecting dynamic shared memory implementation ... posix 120s selecting default "max_connections" ... 100 120s selecting default "shared_buffers" ... 128MB 120s selecting default time zone ... Etc/UTC 120s creating configuration files ... ok 121s running bootstrap script ... ok 121s performing post-bootstrap initialization ... ok 121s syncing data to disk ... ok 124s Setting up postgresql-17-pgaudit (17.0-2) ... 124s Setting up postgresql-17-pgauditlogtofile (1.6.4-1) ... 124s Processing triggers for man-db (2.13.0-1) ... 126s Processing triggers for libc-bin (2.40-4ubuntu1) ... 127s autopkgtest [07:02:46]: test logtofile: [----------------------- 127s ### PostgreSQL 17 installcheck ### 127s Creating new PostgreSQL cluster 17/regress ... 131s 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 logtofile 131s # +++ regress install-check in +++ 131s # using postmaster on localhost, port 5433 131s ok 1 - logtofile 46 ms 131s 1..1 131s # All 1 tests passed. 131s Dropping cluster 17/regress ... 131s rm -f pgauditlogtofile.so libpgauditlogtofile.a libpgauditlogtofile.pc 131s rm -f pgauditlogtofile.o logtofile.o logtofile_bgw.o logtofile_connect.o logtofile_guc.o logtofile_log.o logtofile_shmem.o logtofile_autoclose.o logtofile_vars.o logtofile_filename.o pgauditlogtofile.bc logtofile.bc logtofile_bgw.bc logtofile_connect.bc logtofile_guc.bc logtofile_log.bc logtofile_shmem.bc logtofile_autoclose.bc logtofile_vars.bc logtofile_filename.bc 131s rm -rf results/ regression.diffs regression.out tmp_check/ tmp_check_iso/ log/ output_iso/ 131s ### End 17 installcheck ### 132s autopkgtest [07:02:51]: test logtofile: -----------------------] 132s autopkgtest [07:02:51]: test logtofile: - - - - - - - - - - results - - - - - - - - - - 132s logtofile PASS 133s autopkgtest [07:02:52]: @@@@@@@@@@@@@@@@@@@@ summary 133s logtofile PASS 138s nova [W] Using flock in prodstack6-ppc64el 138s Creating nova instance adt-plucky-ppc64el-pgauditlogtofile-20250222-070039-juju-7f2275-prod-proposed-migration-environment-2-3e183335-05bb-4bc7-b92e-7ea2ff243368 from image adt/ubuntu-plucky-ppc64el-server-20250222.img (UUID fe93544b-49e9-47e0-b80a-745acc8cd85b)... 138s nova [W] Timed out waiting for 54e8718b-d82e-4a9c-a30e-2798273ddf1a to get deleted.