0s autopkgtest [06:54:47]: starting date and time: 2025-02-22 06:54:47+0000 0s autopkgtest [06:54:47]: git checkout: 325255d2 Merge branch 'pin-any-arch' into 'ubuntu/production' 0s autopkgtest [06:54:47]: host juju-7f2275-prod-proposed-migration-environment-2; command line: /home/ubuntu/autopkgtest/runner/autopkgtest --output-dir /tmp/autopkgtest-work.vhnno819/out --timeout-copy=6000 --setup-commands /home/ubuntu/autopkgtest-cloud/worker-config-production/setup-canonical.sh --apt-pocket=proposed=src:postgresql-17 --apt-upgrade orafce --timeout-short=300 --timeout-copy=20000 --timeout-build=20000 --env=ADT_TEST_TRIGGERS=postgresql-17/17.4-1 -- ssh -s /home/ubuntu/autopkgtest/ssh-setup/nova -- --flavor autopkgtest-ppc64el --security-groups autopkgtest-juju-7f2275-prod-proposed-migration-environment-2@bos03-ppc64el-15.secgroup --name adt-plucky-ppc64el-orafce-20250222-065447-juju-7f2275-prod-proposed-migration-environment-2-6518f3c9-3308-4c77-9ed4-f845e5afed0e --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/ 105s autopkgtest [06:56:32]: testbed dpkg architecture: ppc64el 105s autopkgtest [06:56:32]: testbed apt version: 2.9.30ubuntu1 106s autopkgtest [06:56:33]: @@@@@@@@@@@@@@@@@@@@ test bed setup 106s autopkgtest [06:56:33]: testbed release detected to be: None 107s autopkgtest [06:56:34]: updating testbed package index (apt update) 107s Get:1 http://ftpmaster.internal/ubuntu plucky-proposed InRelease [110 kB] 107s Hit:2 http://ftpmaster.internal/ubuntu plucky InRelease 107s Hit:3 http://ftpmaster.internal/ubuntu plucky-updates InRelease 108s Hit:4 http://ftpmaster.internal/ubuntu plucky-security InRelease 108s Get:5 http://ftpmaster.internal/ubuntu plucky-proposed/universe Sources [504 kB] 108s Get:6 http://ftpmaster.internal/ubuntu plucky-proposed/multiverse Sources [13.5 kB] 108s Get:7 http://ftpmaster.internal/ubuntu plucky-proposed/restricted Sources [3120 B] 108s Get:8 http://ftpmaster.internal/ubuntu plucky-proposed/main Sources [80.9 kB] 108s Get:9 http://ftpmaster.internal/ubuntu plucky-proposed/main ppc64el Packages [127 kB] 108s Get:10 http://ftpmaster.internal/ubuntu plucky-proposed/restricted ppc64el Packages [760 B] 108s Get:11 http://ftpmaster.internal/ubuntu plucky-proposed/universe ppc64el Packages [432 kB] 108s Get:12 http://ftpmaster.internal/ubuntu plucky-proposed/multiverse ppc64el Packages [3292 B] 108s Fetched 1276 kB in 1s (1270 kB/s) 109s Reading package lists... 110s Reading package lists... 110s Building dependency tree... 110s Reading state information... 111s Calculating upgrade... 111s Calculating upgrade... 112s The following packages will be upgraded: 112s curl libcurl3t64-gnutls libcurl4t64 112s 3 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 112s Need to get 1221 kB of archives. 112s After this operation, 3072 B disk space will be freed. 112s Get:1 http://ftpmaster.internal/ubuntu plucky/main ppc64el curl ppc64el 8.12.1-2ubuntu1 [258 kB] 112s Get:2 http://ftpmaster.internal/ubuntu plucky/main ppc64el libcurl4t64 ppc64el 8.12.1-2ubuntu1 [482 kB] 112s Get:3 http://ftpmaster.internal/ubuntu plucky/main ppc64el libcurl3t64-gnutls ppc64el 8.12.1-2ubuntu1 [481 kB] 113s Fetched 1221 kB in 1s (2027 kB/s) 113s (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.) 113s Preparing to unpack .../curl_8.12.1-2ubuntu1_ppc64el.deb ... 113s Unpacking curl (8.12.1-2ubuntu1) over (8.12.0+git20250209.89ed161+ds-1ubuntu1) ... 113s Preparing to unpack .../libcurl4t64_8.12.1-2ubuntu1_ppc64el.deb ... 113s Unpacking libcurl4t64:ppc64el (8.12.1-2ubuntu1) over (8.12.0+git20250209.89ed161+ds-1ubuntu1) ... 113s Preparing to unpack .../libcurl3t64-gnutls_8.12.1-2ubuntu1_ppc64el.deb ... 113s Unpacking libcurl3t64-gnutls:ppc64el (8.12.1-2ubuntu1) over (8.12.0+git20250209.89ed161+ds-1ubuntu1) ... 113s Setting up libcurl4t64:ppc64el (8.12.1-2ubuntu1) ... 113s Setting up libcurl3t64-gnutls:ppc64el (8.12.1-2ubuntu1) ... 113s Setting up curl (8.12.1-2ubuntu1) ... 113s Processing triggers for man-db (2.13.0-1) ... 114s Processing triggers for libc-bin (2.40-4ubuntu1) ... 114s Reading package lists... 114s Building dependency tree... 114s Reading state information... 115s Solving dependencies... 115s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 115s autopkgtest [06:56:42]: upgrading testbed (apt dist-upgrade and autopurge) 115s Reading package lists... 115s Building dependency tree... 115s Reading state information... 116s Calculating upgrade...Starting pkgProblemResolver with broken count: 0 116s Starting 2 pkgProblemResolver with broken count: 0 116s Done 117s Entering ResolveByKeep 117s 117s Calculating upgrade... 117s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 118s Reading package lists... 118s Building dependency tree... 118s Reading state information... 118s Starting pkgProblemResolver with broken count: 0 118s Starting 2 pkgProblemResolver with broken count: 0 118s Done 119s Solving dependencies... 119s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 123s autopkgtest [06:56:50]: testbed running kernel: Linux 6.12.0-15-generic #15-Ubuntu SMP Tue Feb 4 16:32:08 UTC 2025 123s autopkgtest [06:56:50]: @@@@@@@@@@@@@@@@@@@@ apt-source orafce 125s Get:1 http://ftpmaster.internal/ubuntu plucky/universe orafce 4.14.1-1 (dsc) [2215 B] 125s Get:2 http://ftpmaster.internal/ubuntu plucky/universe orafce 4.14.1-1 (tar) [736 kB] 125s Get:3 http://ftpmaster.internal/ubuntu plucky/universe orafce 4.14.1-1 (diff) [4608 B] 126s gpgv: Signature made Fri Dec 20 20:42:39 2024 UTC 126s gpgv: using RSA key 5C48FE6157F49179597087C64C5A6BAB12D2A7AE 126s gpgv: Can't check signature: No public key 126s dpkg-source: warning: cannot verify inline signature for ./orafce_4.14.1-1.dsc: no acceptable signature found 126s autopkgtest [06:56:53]: testing package orafce version 4.14.1-1 126s autopkgtest [06:56:53]: build not needed 128s autopkgtest [06:56:55]: test installcheck: preparing testbed 128s 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 The following NEW packages will be installed: 130s libio-pty-perl libipc-run-perl libjson-perl libllvm20 libpq5 libxslt1.1 130s locales-all postgresql-17 postgresql-17-orafce postgresql-client-17 130s postgresql-client-common postgresql-common postgresql-common-dev ssl-cert 130s 0 upgraded, 14 newly installed, 0 to remove and 0 not upgraded. 130s Need to get 62.9 MB of archives. 130s After this operation, 464 MB of additional disk space will be used. 130s Get:1 http://ftpmaster.internal/ubuntu plucky/main ppc64el libjson-perl all 4.10000-1 [81.9 kB] 130s Get:2 http://ftpmaster.internal/ubuntu plucky/main ppc64el postgresql-client-common all 273 [47.5 kB] 130s Get:3 http://ftpmaster.internal/ubuntu plucky/main ppc64el libio-pty-perl ppc64el 1:1.20-1build3 [32.0 kB] 130s Get:4 http://ftpmaster.internal/ubuntu plucky/main ppc64el libipc-run-perl all 20231003.0-2 [91.5 kB] 130s Get:5 http://ftpmaster.internal/ubuntu plucky/main ppc64el postgresql-common-dev all 273 [72.9 kB] 130s Get:6 http://ftpmaster.internal/ubuntu plucky/main ppc64el ssl-cert all 1.1.3ubuntu1 [18.7 kB] 130s Get:7 http://ftpmaster.internal/ubuntu plucky/main ppc64el postgresql-common all 273 [101 kB] 130s Get:8 http://ftpmaster.internal/ubuntu plucky/main ppc64el libllvm20 ppc64el 1:20.1.0~+rc2-1~exp2ubuntu0.4 [31.9 MB] 131s Get:9 http://ftpmaster.internal/ubuntu plucky-proposed/main ppc64el libpq5 ppc64el 17.4-1 [174 kB] 131s Get:10 http://ftpmaster.internal/ubuntu plucky/main ppc64el libxslt1.1 ppc64el 1.1.39-0exp1ubuntu2 [191 kB] 131s Get:11 http://ftpmaster.internal/ubuntu plucky/universe ppc64el locales-all ppc64el 2.40-4ubuntu1 [11.1 MB] 132s Get:12 http://ftpmaster.internal/ubuntu plucky-proposed/main ppc64el postgresql-client-17 ppc64el 17.4-1 [1482 kB] 132s Get:13 http://ftpmaster.internal/ubuntu plucky-proposed/main ppc64el postgresql-17 ppc64el 17.4-1 [17.2 MB] 132s Get:14 http://ftpmaster.internal/ubuntu plucky/universe ppc64el postgresql-17-orafce ppc64el 4.14.1-1 [407 kB] 132s Preconfiguring packages ... 133s Fetched 62.9 MB in 2s (29.3 MB/s) 133s Selecting previously unselected package libjson-perl. 133s (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.) 133s Preparing to unpack .../00-libjson-perl_4.10000-1_all.deb ... 133s Unpacking libjson-perl (4.10000-1) ... 133s Selecting previously unselected package postgresql-client-common. 133s Preparing to unpack .../01-postgresql-client-common_273_all.deb ... 133s Unpacking postgresql-client-common (273) ... 133s Selecting previously unselected package libio-pty-perl. 133s Preparing to unpack .../02-libio-pty-perl_1%3a1.20-1build3_ppc64el.deb ... 133s Unpacking libio-pty-perl (1:1.20-1build3) ... 133s Selecting previously unselected package libipc-run-perl. 133s Preparing to unpack .../03-libipc-run-perl_20231003.0-2_all.deb ... 133s Unpacking libipc-run-perl (20231003.0-2) ... 133s Selecting previously unselected package postgresql-common-dev. 133s Preparing to unpack .../04-postgresql-common-dev_273_all.deb ... 133s Unpacking postgresql-common-dev (273) ... 133s Selecting previously unselected package ssl-cert. 133s Preparing to unpack .../05-ssl-cert_1.1.3ubuntu1_all.deb ... 133s Unpacking ssl-cert (1.1.3ubuntu1) ... 133s Selecting previously unselected package postgresql-common. 133s Preparing to unpack .../06-postgresql-common_273_all.deb ... 133s Adding 'diversion of /usr/bin/pg_config to /usr/bin/pg_config.libpq-dev by postgresql-common' 133s Unpacking postgresql-common (273) ... 133s Selecting previously unselected package libllvm20:ppc64el. 133s Preparing to unpack .../07-libllvm20_1%3a20.1.0~+rc2-1~exp2ubuntu0.4_ppc64el.deb ... 133s Unpacking libllvm20:ppc64el (1:20.1.0~+rc2-1~exp2ubuntu0.4) ... 134s Selecting previously unselected package libpq5:ppc64el. 134s Preparing to unpack .../08-libpq5_17.4-1_ppc64el.deb ... 134s Unpacking libpq5:ppc64el (17.4-1) ... 134s Selecting previously unselected package libxslt1.1:ppc64el. 134s Preparing to unpack .../09-libxslt1.1_1.1.39-0exp1ubuntu2_ppc64el.deb ... 134s Unpacking libxslt1.1:ppc64el (1.1.39-0exp1ubuntu2) ... 134s Selecting previously unselected package locales-all. 134s Preparing to unpack .../10-locales-all_2.40-4ubuntu1_ppc64el.deb ... 134s Unpacking locales-all (2.40-4ubuntu1) ... 136s Selecting previously unselected package postgresql-client-17. 136s Preparing to unpack .../11-postgresql-client-17_17.4-1_ppc64el.deb ... 136s Unpacking postgresql-client-17 (17.4-1) ... 136s Selecting previously unselected package postgresql-17. 136s Preparing to unpack .../12-postgresql-17_17.4-1_ppc64el.deb ... 136s Unpacking postgresql-17 (17.4-1) ... 137s Selecting previously unselected package postgresql-17-orafce. 137s Preparing to unpack .../13-postgresql-17-orafce_4.14.1-1_ppc64el.deb ... 137s Unpacking postgresql-17-orafce (4.14.1-1) ... 137s Setting up postgresql-client-common (273) ... 137s Setting up libio-pty-perl (1:1.20-1build3) ... 137s Setting up libpq5:ppc64el (17.4-1) ... 137s Setting up locales-all (2.40-4ubuntu1) ... 137s Setting up ssl-cert (1.1.3ubuntu1) ... 137s Created symlink '/etc/systemd/system/multi-user.target.wants/ssl-cert.service' → '/usr/lib/systemd/system/ssl-cert.service'. 138s Setting up libllvm20:ppc64el (1:20.1.0~+rc2-1~exp2ubuntu0.4) ... 138s Setting up libipc-run-perl (20231003.0-2) ... 138s Setting up libjson-perl (4.10000-1) ... 138s Setting up libxslt1.1:ppc64el (1.1.39-0exp1ubuntu2) ... 138s Setting up postgresql-common-dev (273) ... 138s Setting up postgresql-client-17 (17.4-1) ... 138s 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 138s Setting up postgresql-common (273) ... 139s Creating config file /etc/postgresql-common/createcluster.conf with new version 139s Building PostgreSQL dictionaries from installed myspell/hunspell packages... 139s Removing obsolete dictionary files: 140s Created symlink '/etc/systemd/system/multi-user.target.wants/postgresql.service' → '/usr/lib/systemd/system/postgresql.service'. 141s Setting up postgresql-17 (17.4-1) ... 142s Creating new PostgreSQL cluster 17/main ... 142s /usr/lib/postgresql/17/bin/initdb -D /var/lib/postgresql/17/main --auth-local peer --auth-host scram-sha-256 --no-instructions 142s The files belonging to this database system will be owned by user "postgres". 142s This user must also own the server process. 142s 142s The database cluster will be initialized with locale "C.UTF-8". 142s The default database encoding has accordingly been set to "UTF8". 142s The default text search configuration will be set to "english". 142s 142s Data page checksums are disabled. 142s 142s fixing permissions on existing directory /var/lib/postgresql/17/main ... ok 142s creating subdirectories ... ok 142s selecting dynamic shared memory implementation ... posix 142s selecting default "max_connections" ... 100 142s selecting default "shared_buffers" ... 128MB 142s selecting default time zone ... Etc/UTC 142s creating configuration files ... ok 142s running bootstrap script ... ok 142s performing post-bootstrap initialization ... ok 142s syncing data to disk ... ok 146s Setting up postgresql-17-orafce (4.14.1-1) ... 146s Processing triggers for libc-bin (2.40-4ubuntu1) ... 146s Processing triggers for man-db (2.13.0-1) ... 148s autopkgtest [06:57:15]: test installcheck: [----------------------- 148s ### PostgreSQL 17 installcheck ### 148s Creating new PostgreSQL cluster 17/regress ... 151s 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' --schedule=parallel_schedule --encoding=utf8 --dbname=contrib_regression orafce orafce2 dbms_output dbms_utility files varchar2 nvarchar2 aggregates nlssort regexp_func dbms_sql 151s # +++ regress install-check in +++ 151s # using postmaster on localhost, port 5433 152s ok 1 - init 194 ms 162s # parallel group (2 tests): dbms_pipe_session_A dbms_pipe_session_B 162s ok 2 + dbms_pipe_session_A 152 ms 162s ok 3 + dbms_pipe_session_B 10175 ms 162s ok 4 - orafce 213 ms 162s ok 5 - orafce2 31 ms 162s ok 6 - dbms_output 111 ms 164s ok 7 - dbms_utility 2037 ms 164s ok 8 - files 82 ms 164s ok 9 - varchar2 49 ms 165s ok 10 - nvarchar2 52 ms 165s ok 11 - aggregates 50 ms 165s ok 12 - nlssort 212 ms 165s ok 13 - regexp_func 71 ms 165s ok 14 - dbms_sql 96 ms 165s 1..14 165s # All 14 tests passed. 165s Dropping cluster 17/regress ... 165s rm -f orafce.so liborafce.a liborafce.pc 165s rm -f regexp.o parse_keyword.o convert.o file.o datefce.o magic.o others.o plvstr.o plvdate.o shmmc.o plvsubst.o utility.o plvlex.o alert.o pipe.o sqlparse.o putline.o assert.o plunit.o random.o aggregate.o orafce.o varchar2.o nvarchar2.o charpad.o charlen.o replace_empty_string.o math.o dbms_sql.o regexp.bc parse_keyword.bc convert.bc file.bc datefce.bc magic.bc others.bc plvstr.bc plvdate.bc shmmc.bc plvsubst.bc utility.bc plvlex.bc alert.bc pipe.bc sqlparse.bc putline.bc assert.bc plunit.bc random.bc aggregate.bc orafce.bc varchar2.bc nvarchar2.bc charpad.bc charlen.bc replace_empty_string.bc math.bc dbms_sql.bc 165s rm -rf results/ regression.diffs regression.out tmp_check/ tmp_check_iso/ log/ output_iso/ 165s ### End 17 installcheck ### 166s autopkgtest [06:57:33]: test installcheck: -----------------------] 166s autopkgtest [06:57:33]: test installcheck: - - - - - - - - - - results - - - - - - - - - - 166s installcheck PASS 167s autopkgtest [06:57:34]: @@@@@@@@@@@@@@@@@@@@ summary 167s installcheck PASS 172s nova [W] Using flock in prodstack6-ppc64el 172s Creating nova instance adt-plucky-ppc64el-orafce-20250222-065447-juju-7f2275-prod-proposed-migration-environment-2-6518f3c9-3308-4c77-9ed4-f845e5afed0e from image adt/ubuntu-plucky-ppc64el-server-20250222.img (UUID fe93544b-49e9-47e0-b80a-745acc8cd85b)... 172s nova [W] Timed out waiting for 5dd31f26-6f2d-4734-9e7d-17e7b8a93548 to get deleted.