0s autopkgtest [06:55:50]: starting date and time: 2025-02-22 06:55:50+0000 0s autopkgtest [06:55:50]: git checkout: 325255d2 Merge branch 'pin-any-arch' into 'ubuntu/production' 0s autopkgtest [06:55:50]: host juju-7f2275-prod-proposed-migration-environment-15; command line: /home/ubuntu/autopkgtest/runner/autopkgtest --output-dir /tmp/autopkgtest-work.5dhkecfq/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-cron --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-15@bos03-ppc64el-16.secgroup --name adt-plucky-ppc64el-pg-cron-20250222-065550-juju-7f2275-prod-proposed-migration-environment-15-fb4440c5-a8b1-4f1f-a609-dbdc2b3f4cdd --image adt/ubuntu-plucky-ppc64el-server --keyname testbed-juju-7f2275-prod-proposed-migration-environment-15 --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:52]: testbed dpkg architecture: ppc64el 122s autopkgtest [06:57:52]: testbed apt version: 2.9.30ubuntu1 122s autopkgtest [06:57:52]: @@@@@@@@@@@@@@@@@@@@ test bed setup 122s autopkgtest [06:57:52]: testbed release detected to be: None 123s autopkgtest [06:57:53]: 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/restricted Sources [3120 B] 124s Get:6 http://ftpmaster.internal/ubuntu plucky-proposed/multiverse Sources [13.5 kB] 124s Get:7 http://ftpmaster.internal/ubuntu plucky-proposed/main Sources [80.9 kB] 124s Get:8 http://ftpmaster.internal/ubuntu plucky-proposed/universe Sources [504 kB] 124s Get:9 http://ftpmaster.internal/ubuntu plucky-proposed/main ppc64el Packages [127 kB] 124s Get:10 http://ftpmaster.internal/ubuntu plucky-proposed/restricted ppc64el Packages [760 B] 124s Get:11 http://ftpmaster.internal/ubuntu plucky-proposed/universe ppc64el Packages [432 kB] 124s Get:12 http://ftpmaster.internal/ubuntu plucky-proposed/multiverse ppc64el Packages [3292 B] 125s Fetched 1276 kB in 1s (1334 kB/s) 126s Reading package lists... 126s + lsb_release --codename --short 126s + RELEASE=plucky 126s + cat 126s + [ plucky != trusty ] 126s + DEBIAN_FRONTEND=noninteractive eatmydata apt-get -y --allow-downgrades -o Dpkg::Options::=--force-confnew dist-upgrade 126s Reading package lists... 127s Building dependency tree... 127s 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] 129s Fetched 1221 kB in 1s (1993 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) ... 130s Processing triggers for libc-bin (2.40-4ubuntu1) ... 130s + rm /etc/apt/preferences.d/force-downgrade-to-release.pref 130s + /usr/lib/apt/apt-helper analyze-pattern ?true 130s + uname -r 130s + sed s/\./\\./g 130s + running_kernel_pattern=^linux-.*6\.12\.0-15-generic.* 130s + apt list ?obsolete 130s + tail -n+2 130s + cut -d/ -f1 130s + grep -v ^linux-.*6\.12\.0-15-generic.* 130s + true 130s + obsolete_pkgs= 130s + DEBIAN_FRONTEND=noninteractive eatmydata apt-get -y purge --autoremove 130s Reading package lists... 131s Building dependency tree... 131s Reading state information... 131s Solving dependencies... 131s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 131s + grep -q trusty /etc/lsb-release 131s + [ ! -d /usr/share/doc/unattended-upgrades ] 131s + [ ! -d /usr/share/doc/lxd ] 131s + [ ! -d /usr/share/doc/lxd-client ] 131s + [ ! -d /usr/share/doc/snapd ] 131s + type iptables 131s + cat 131s + chmod 755 /etc/rc.local 131s + . /etc/rc.local 131s + iptables -w -t mangle -A FORWARD -p tcp --tcp-flags SYN,RST SYN -j TCPMSS --clamp-mss-to-pmtu 131s + iptables -A OUTPUT -d 10.255.255.1/32 -p tcp -j DROP 131s + iptables -A OUTPUT -d 10.255.255.2/32 -p tcp -j DROP 131s + uname -m 131s + [ ppc64le = ppc64le ] 131s + systemctl is-active keyboard-setup.service 131s + [ active = failed ] 131s + [ -d /run/systemd/system ] 131s + systemd-detect-virt --quiet --vm 131s + mkdir -p /etc/systemd/system/systemd-random-seed.service.d/ 131s + cat 131s + grep -q lz4 /etc/initramfs-tools/initramfs.conf 131s + echo COMPRESS=lz4 131s autopkgtest [06:58:01]: upgrading testbed (apt dist-upgrade and autopurge) 131s Reading package lists... 132s Building dependency tree... 132s Reading state information... 132s Calculating upgrade...Starting pkgProblemResolver with broken count: 0 133s Starting 2 pkgProblemResolver with broken count: 0 133s Done 133s Entering ResolveByKeep 134s 134s Calculating upgrade... 134s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 134s Reading package lists... 135s Building dependency tree... 135s Reading state information... 135s Starting pkgProblemResolver with broken count: 0 135s Starting 2 pkgProblemResolver with broken count: 0 135s Done 136s Solving dependencies... 136s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 139s autopkgtest [06:58:09]: testbed running kernel: Linux 6.12.0-15-generic #15-Ubuntu SMP Tue Feb 4 16:32:08 UTC 2025 139s autopkgtest [06:58:09]: @@@@@@@@@@@@@@@@@@@@ apt-source pg-cron 141s Get:1 http://ftpmaster.internal/ubuntu plucky/universe pg-cron 1.6.5-1 (dsc) [2073 B] 141s Get:2 http://ftpmaster.internal/ubuntu plucky/universe pg-cron 1.6.5-1 (tar) [55.9 kB] 141s Get:3 http://ftpmaster.internal/ubuntu plucky/universe pg-cron 1.6.5-1 (diff) [4396 B] 141s gpgv: Signature made Tue Dec 17 18:53:16 2024 UTC 141s gpgv: using RSA key 5C48FE6157F49179597087C64C5A6BAB12D2A7AE 141s gpgv: Can't check signature: No public key 141s dpkg-source: warning: cannot verify inline signature for ./pg-cron_1.6.5-1.dsc: no acceptable signature found 141s autopkgtest [06:58:11]: testing package pg-cron version 1.6.5-1 142s autopkgtest [06:58:12]: build not needed 142s autopkgtest [06:58:12]: test cron: preparing testbed 143s Reading package lists... 143s Building dependency tree... 143s Reading state information... 143s Starting pkgProblemResolver with broken count: 0 143s Starting 2 pkgProblemResolver with broken count: 0 143s Done 144s The following NEW packages will be installed: 144s libio-pty-perl libipc-run-perl libjson-perl libllvm20 libpq5 libxslt1.1 144s postgresql-17 postgresql-17-cron postgresql-client-17 144s postgresql-client-common postgresql-common postgresql-common-dev ssl-cert 144s 0 upgraded, 13 newly installed, 0 to remove and 0 not upgraded. 144s Need to get 51.5 MB of archives. 144s After this operation, 222 MB of additional disk space will be used. 144s Get:1 http://ftpmaster.internal/ubuntu plucky/main ppc64el libjson-perl all 4.10000-1 [81.9 kB] 144s Get:2 http://ftpmaster.internal/ubuntu plucky/main ppc64el postgresql-client-common all 273 [47.5 kB] 144s Get:3 http://ftpmaster.internal/ubuntu plucky/main ppc64el libio-pty-perl ppc64el 1:1.20-1build3 [32.0 kB] 144s Get:4 http://ftpmaster.internal/ubuntu plucky/main ppc64el libipc-run-perl all 20231003.0-2 [91.5 kB] 144s Get:5 http://ftpmaster.internal/ubuntu plucky/main ppc64el postgresql-common-dev all 273 [72.9 kB] 144s Get:6 http://ftpmaster.internal/ubuntu plucky/main ppc64el ssl-cert all 1.1.3ubuntu1 [18.7 kB] 144s Get:7 http://ftpmaster.internal/ubuntu plucky/main ppc64el postgresql-common all 273 [101 kB] 144s Get:8 http://ftpmaster.internal/ubuntu plucky/main ppc64el libllvm20 ppc64el 1:20.1.0~+rc2-1~exp2ubuntu0.4 [31.9 MB] 145s Get:9 http://ftpmaster.internal/ubuntu plucky-proposed/main ppc64el libpq5 ppc64el 17.4-1 [174 kB] 145s Get:10 http://ftpmaster.internal/ubuntu plucky/main ppc64el libxslt1.1 ppc64el 1.1.39-0exp1ubuntu2 [191 kB] 145s Get:11 http://ftpmaster.internal/ubuntu plucky-proposed/main ppc64el postgresql-client-17 ppc64el 17.4-1 [1482 kB] 145s Get:12 http://ftpmaster.internal/ubuntu plucky-proposed/main ppc64el postgresql-17 ppc64el 17.4-1 [17.2 MB] 146s Get:13 http://ftpmaster.internal/ubuntu plucky/universe ppc64el postgresql-17-cron ppc64el 1.6.5-1 [97.7 kB] 146s Preconfiguring packages ... 146s Fetched 51.5 MB in 2s (27.8 MB/s) 146s Selecting previously unselected package libjson-perl. 146s (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.) 146s Preparing to unpack .../00-libjson-perl_4.10000-1_all.deb ... 146s Unpacking libjson-perl (4.10000-1) ... 146s Selecting previously unselected package postgresql-client-common. 146s Preparing to unpack .../01-postgresql-client-common_273_all.deb ... 146s Unpacking postgresql-client-common (273) ... 146s Selecting previously unselected package libio-pty-perl. 146s Preparing to unpack .../02-libio-pty-perl_1%3a1.20-1build3_ppc64el.deb ... 146s Unpacking libio-pty-perl (1:1.20-1build3) ... 146s Selecting previously unselected package libipc-run-perl. 146s Preparing to unpack .../03-libipc-run-perl_20231003.0-2_all.deb ... 146s Unpacking libipc-run-perl (20231003.0-2) ... 146s Selecting previously unselected package postgresql-common-dev. 146s Preparing to unpack .../04-postgresql-common-dev_273_all.deb ... 146s Unpacking postgresql-common-dev (273) ... 146s Selecting previously unselected package ssl-cert. 146s Preparing to unpack .../05-ssl-cert_1.1.3ubuntu1_all.deb ... 146s Unpacking ssl-cert (1.1.3ubuntu1) ... 147s Selecting previously unselected package postgresql-common. 147s Preparing to unpack .../06-postgresql-common_273_all.deb ... 147s Adding 'diversion of /usr/bin/pg_config to /usr/bin/pg_config.libpq-dev by postgresql-common' 147s Unpacking postgresql-common (273) ... 147s Selecting previously unselected package libllvm20:ppc64el. 147s Preparing to unpack .../07-libllvm20_1%3a20.1.0~+rc2-1~exp2ubuntu0.4_ppc64el.deb ... 147s Unpacking libllvm20:ppc64el (1:20.1.0~+rc2-1~exp2ubuntu0.4) ... 147s Selecting previously unselected package libpq5:ppc64el. 147s Preparing to unpack .../08-libpq5_17.4-1_ppc64el.deb ... 147s Unpacking libpq5:ppc64el (17.4-1) ... 147s Selecting previously unselected package libxslt1.1:ppc64el. 147s Preparing to unpack .../09-libxslt1.1_1.1.39-0exp1ubuntu2_ppc64el.deb ... 147s Unpacking libxslt1.1:ppc64el (1.1.39-0exp1ubuntu2) ... 147s Selecting previously unselected package postgresql-client-17. 147s Preparing to unpack .../10-postgresql-client-17_17.4-1_ppc64el.deb ... 147s Unpacking postgresql-client-17 (17.4-1) ... 147s Selecting previously unselected package postgresql-17. 147s Preparing to unpack .../11-postgresql-17_17.4-1_ppc64el.deb ... 147s Unpacking postgresql-17 (17.4-1) ... 148s Selecting previously unselected package postgresql-17-cron. 148s Preparing to unpack .../12-postgresql-17-cron_1.6.5-1_ppc64el.deb ... 148s Unpacking postgresql-17-cron (1.6.5-1) ... 148s Setting up postgresql-client-common (273) ... 148s Setting up libio-pty-perl (1:1.20-1build3) ... 148s Setting up libpq5:ppc64el (17.4-1) ... 148s Setting up ssl-cert (1.1.3ubuntu1) ... 149s Created symlink '/etc/systemd/system/multi-user.target.wants/ssl-cert.service' → '/usr/lib/systemd/system/ssl-cert.service'. 149s Setting up libllvm20:ppc64el (1:20.1.0~+rc2-1~exp2ubuntu0.4) ... 149s Setting up libipc-run-perl (20231003.0-2) ... 149s Setting up libjson-perl (4.10000-1) ... 149s Setting up libxslt1.1:ppc64el (1.1.39-0exp1ubuntu2) ... 149s Setting up postgresql-common-dev (273) ... 149s Setting up postgresql-client-17 (17.4-1) ... 150s 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 150s Setting up postgresql-common (273) ... 150s Creating config file /etc/postgresql-common/createcluster.conf with new version 150s Building PostgreSQL dictionaries from installed myspell/hunspell packages... 150s Removing obsolete dictionary files: 152s Created symlink '/etc/systemd/system/multi-user.target.wants/postgresql.service' → '/usr/lib/systemd/system/postgresql.service'. 152s Setting up postgresql-17 (17.4-1) ... 153s Creating new PostgreSQL cluster 17/main ... 153s /usr/lib/postgresql/17/bin/initdb -D /var/lib/postgresql/17/main --auth-local peer --auth-host scram-sha-256 --no-instructions 153s The files belonging to this database system will be owned by user "postgres". 153s This user must also own the server process. 153s 153s The database cluster will be initialized with locale "C.UTF-8". 153s The default database encoding has accordingly been set to "UTF8". 153s The default text search configuration will be set to "english". 153s 153s Data page checksums are disabled. 153s 153s fixing permissions on existing directory /var/lib/postgresql/17/main ... ok 153s creating subdirectories ... ok 153s selecting dynamic shared memory implementation ... posix 153s selecting default "max_connections" ... 100 154s selecting default "shared_buffers" ... 128MB 154s selecting default time zone ... Etc/UTC 154s creating configuration files ... ok 154s running bootstrap script ... ok 155s performing post-bootstrap initialization ... ok 155s syncing data to disk ... ok 158s Setting up postgresql-17-cron (1.6.5-1) ... 158s Processing triggers for man-db (2.13.0-1) ... 159s Processing triggers for libc-bin (2.40-4ubuntu1) ... 160s autopkgtest [06:58:30]: test cron: [----------------------- 161s + id -un 161s + [ ubuntu = root ] 161s + export PGPASSFILE=/home/ubuntu/.pgpass 161s + trap sed -i -e '/# added by pg_cron testsuite/,$ d' /home/ubuntu/.pgpass 0 2 3 15 161s + pg_buildext installed-versions 161s + pg_virtualenv -v 17 -o shared_preload_libraries=pg_cron 161s Creating new PostgreSQL cluster 17/regress ... 164s + umask 077 164s + echo '# added by pg_cron testsuite' 164s + echo localhost:5433:postgres:ubuntu:3bb844b36e87096833b0e53e2ce4a304 164s + psql -eX 164s CREATE EXTENSION pg_cron VERSION '1.0'; 164s CREATE EXTENSION 164s ALTER EXTENSION pg_cron UPDATE; 164s ALTER EXTENSION 164s SELECT cron.schedule('* * * * *', 'CREATE TABLE foo()'); 164s schedule 164s ---------- 164s 1 164s (1 row) 164s 164s SELECT * FROM cron.job; 164s jobid | schedule | command | nodename | nodeport | database | username | active | jobname 164s -------+-----------+--------------------+-----------+----------+----------+----------+--------+--------- 164s 1 | * * * * * | CREATE TABLE foo() | localhost | 5433 | postgres | ubuntu | t | 164s (1 row) 164s 164s SELECT pg_sleep(70); 234s pg_sleep 234s ---------- 234s 234s (1 row) 234s 234s SELECT * FROM foo; 234s -- 234s (0 rows) 234s 234s Dropping cluster 17/regress ... 235s + sed -i -e /# added by pg_cron testsuite/,$ d /home/ubuntu/.pgpass 235s + sed -i -e /# added by pg_cron testsuite/,$ d /home/ubuntu/.pgpass 235s autopkgtest [06:59:45]: test cron: -----------------------] 235s autopkgtest [06:59:45]: test cron: - - - - - - - - - - results - - - - - - - - - - 235s cron PASS 236s autopkgtest [06:59:46]: test installcheck: preparing testbed 236s Reading package lists... 236s Building dependency tree... 236s Reading state information... 237s Starting pkgProblemResolver with broken count: 0 237s Starting 2 pkgProblemResolver with broken count: 0 237s Done 237s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 238s autopkgtest [06:59:48]: test installcheck: pg_buildext -o 'shared_preload_libraries=pg_cron' installcheck 238s autopkgtest [06:59:48]: test installcheck: [----------------------- 238s ### PostgreSQL 17 installcheck ### 238s Creating new PostgreSQL cluster 17/regress ... 241s 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 pg_cron-test 241s # +++ regress install-check in +++ 241s # using postmaster on localhost, port 5433 242s ok 1 - pg_cron-test 225 ms 242s 1..1 242s # All 1 tests passed. 242s Dropping cluster 17/regress ... 242s rm -f pg_cron.so libpg_cron.a libpg_cron.pc 242s rm -f pg_cron--1.0.sql 242s rm -f src/entry.o src/job_metadata.o src/misc.o src/pg_cron.o src/task_states.o src/entry.bc src/job_metadata.bc src/misc.bc src/pg_cron.bc src/task_states.bc 242s rm -rf src/*.gcno src/*.gcda 242s rm -rf results/ regression.diffs regression.out tmp_check/ tmp_check_iso/ log/ output_iso/ 242s ### End 17 installcheck ### 242s autopkgtest [06:59:52]: test installcheck: -----------------------] 243s autopkgtest [06:59:53]: test installcheck: - - - - - - - - - - results - - - - - - - - - - 243s installcheck PASS 243s autopkgtest [06:59:53]: @@@@@@@@@@@@@@@@@@@@ summary 243s cron PASS 243s installcheck PASS 248s nova [W] Using flock in prodstack6-ppc64el 248s Creating nova instance adt-plucky-ppc64el-pg-cron-20250222-065550-juju-7f2275-prod-proposed-migration-environment-15-fb4440c5-a8b1-4f1f-a609-dbdc2b3f4cdd from image adt/ubuntu-plucky-ppc64el-server-20250222.img (UUID fe93544b-49e9-47e0-b80a-745acc8cd85b)... 248s nova [W] Timed out waiting for 76df4b12-9599-46ee-9639-079e96cc3c91 to get deleted.