autopkgtest [01:19:40]: starting date: 2023-05-20 autopkgtest [01:19:40]: git checkout: 842ca0f Temporarily don't consider exitocde 255 a testbed failure autopkgtest [01:19:40]: host juju-4d1272-prod-proposed-migration-14; command line: /home/ubuntu/autopkgtest/runner/autopkgtest --output-dir /tmp/autopkgtest-work.9ndyw5a6/out --timeout-copy=6000 --setup-commands /home/ubuntu/autopkgtest-cloud/worker-config-production/setup-canonical.sh --setup-commands /home/ubuntu/autopkgtest/setup-commands/setup-testbed --apt-pocket=proposed=src:postgresql-common --apt-upgrade prometheus-sql-exporter --timeout-short=300 --timeout-copy=20000 --timeout-build=20000 --env=ADT_TEST_TRIGGERS=postgresql-common/238ubuntu0.1 -- ssh -s /home/ubuntu/autopkgtest/ssh-setup/nova -- --flavor autopkgtest --security-groups autopkgtest-juju-4d1272-prod-proposed-migration-14@bos01-ppc64el-5.secgroup --name adt-jammy-ppc64el-prometheus-sql-exporter-20230520-011940-juju-4d1272-prod-proposed-migration-14 --image adt/ubuntu-jammy-ppc64el-server --keyname testbed-juju-4d1272-prod-proposed-migration-14 --net-id=net_prod-proposed-migration -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,localhost,localdomain,novalocal,internal,archive.ubuntu.com,ports.ubuntu.com,security.ubuntu.com,ddebs.ubuntu.com,changelogs.ubuntu.com,launchpad.net,10.24.0.0/24'"'"'' --mirror=http://us.ports.ubuntu.com/ubuntu-ports/ autopkgtest [01:23:49]: @@@@@@@@@@@@@@@@@@@@ test bed setup Get:1 http://ftpmaster.internal/ubuntu jammy-proposed InRelease [270 kB] Get:2 http://ftpmaster.internal/ubuntu jammy-proposed/multiverse Sources [976 B] Get:3 http://ftpmaster.internal/ubuntu jammy-proposed/universe Sources [22.0 kB] Get:4 http://ftpmaster.internal/ubuntu jammy-proposed/restricted Sources [8280 B] Get:5 http://ftpmaster.internal/ubuntu jammy-proposed/main Sources [51.8 kB] Get:6 http://ftpmaster.internal/ubuntu jammy-proposed/main ppc64el Packages [102 kB] Get:7 http://ftpmaster.internal/ubuntu jammy-proposed/main ppc64el c-n-f Metadata [2624 B] Get:8 http://ftpmaster.internal/ubuntu jammy-proposed/restricted ppc64el Packages [992 B] Get:9 http://ftpmaster.internal/ubuntu jammy-proposed/restricted ppc64el c-n-f Metadata [116 B] Get:10 http://ftpmaster.internal/ubuntu jammy-proposed/universe ppc64el Packages [121 kB] Get:11 http://ftpmaster.internal/ubuntu jammy-proposed/universe ppc64el c-n-f Metadata [2768 B] Get:12 http://ftpmaster.internal/ubuntu jammy-proposed/multiverse ppc64el c-n-f Metadata [116 B] Fetched 583 kB in 1s (715 kB/s) Reading package lists... sh: Attempting to set up Debian/Ubuntu apt sources automatically sh: Distribution appears to be Ubuntu Reading package lists... Building dependency tree... Reading state information... eatmydata is already the newest version (130-2build1). dbus is already the newest version (1.12.20-2ubuntu4.1). 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. Reading package lists... Building dependency tree... Reading state information... rng-tools-debian is already the newest version (2.3). 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. Reading package lists... Building dependency tree... Reading state information... haveged is already the newest version (1.9.14-1ubuntu1). 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. Reading package lists... Building dependency tree... Reading state information... The following packages will be REMOVED: cloud-init* python3-configobj* python3-debconf* 0 upgraded, 0 newly installed, 3 to remove and 0 not upgraded. After this operation, 3059 kB disk space will be freed. (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 ... 94746 files and directories currently installed.) Removing cloud-init (23.1.2-0ubuntu0~22.04.1) ... Removing python3-configobj (5.0.6-5) ... Removing python3-debconf (1.5.79ubuntu1) ... Processing triggers for man-db (2.10.2-1) ... (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 ... 94384 files and directories currently installed.) Purging configuration files for cloud-init (23.1.2-0ubuntu0~22.04.1) ... dpkg: warning: while removing cloud-init, directory '/etc/cloud/cloud.cfg.d' not empty so not removed Processing triggers for rsyslog (8.2112.0-2ubuntu2.2) ... Reading package lists... Building dependency tree... Reading state information... linux-generic is already the newest version (5.15.0.72.70). 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. Hit:1 http://ftpmaster.internal/ubuntu jammy InRelease Hit:2 http://ftpmaster.internal/ubuntu jammy-updates InRelease Hit:3 http://ftpmaster.internal/ubuntu jammy-security InRelease Hit:4 http://ftpmaster.internal/ubuntu jammy-proposed InRelease Reading package lists... Reading package lists... Building dependency tree... Reading state information... Calculating upgrade... 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. Reading package lists... Building dependency tree... Reading state information... 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. autopkgtest [01:24:05]: rebooting testbed after setup commands that affected boot autopkgtest-virt-ssh: WARNING: ssh connection failed. Retrying in 3 seconds... autopkgtest [01:26:55]: testbed running kernel: Linux 5.15.0-72-generic #79-Ubuntu SMP Tue Apr 18 16:53:37 UTC 2023 autopkgtest [01:26:56]: testbed dpkg architecture: ppc64el autopkgtest [01:26:57]: @@@@@@@@@@@@@@@@@@@@ apt-source prometheus-sql-exporter Get:1 http://ftpmaster.internal/ubuntu jammy/universe prometheus-sql-exporter 0.4.2-1 (dsc) [2520 B] Get:2 http://ftpmaster.internal/ubuntu jammy/universe prometheus-sql-exporter 0.4.2-1 (tar) [217 kB] Get:3 http://ftpmaster.internal/ubuntu jammy/universe prometheus-sql-exporter 0.4.2-1 (diff) [5884 B] gpgv: Signature made Fri Feb 4 11:13:44 2022 UTC gpgv: using RSA key 5C48FE6157F49179597087C64C5A6BAB12D2A7AE gpgv: Can't check signature: No public key dpkg-source: warning: cannot verify signature ./prometheus-sql-exporter_0.4.2-1.dsc autopkgtest [01:26:59]: testing package prometheus-sql-exporter version 0.4.2-1 autopkgtest [01:26:59]: build not needed autopkgtest [01:27:00]: test exporter: preparing testbed Reading package lists... Building dependency tree... Reading state information... Correcting dependencies...Starting pkgProblemResolver with broken count: 0 Starting 2 pkgProblemResolver with broken count: 0 Done Done Starting pkgProblemResolver with broken count: 0 Starting 2 pkgProblemResolver with broken count: 0 Done The following additional packages will be installed: clang-14 gcc-11-base icu-devtools libasan6 libatomic1 libc-dev-bin libc6-dev libclang-common-14-dev libclang-cpp14 libclang1-14 libcrypt-dev libffi-dev libgc1 libgcc-11-dev libgomp1 libicu-dev libitm1 libjson-perl libllvm14 liblsan0 libncurses-dev libnsl-dev libobjc-11-dev libobjc4 libpfm4 libpq-dev libpq5 libquadmath0 libssl-dev libstdc++-11-dev libtinfo-dev libtirpc-dev libtsan0 libubsan1 libxml2-dev libxslt1.1 libz3-4 libz3-dev linux-libc-dev llvm-14 llvm-14-dev llvm-14-linker-tools llvm-14-runtime llvm-14-tools postgresql postgresql-14 postgresql-client-14 postgresql-client-common postgresql-common postgresql-server-dev-14 postgresql-server-dev-all prometheus-sql-exporter python3-pygments rpcsvc-proto ssl-cert Suggested packages: clang-14-doc glibc-doc manpages-dev icu-doc ncurses-doc postgresql-doc-14 libssl-doc libstdc++-11-doc pkg-config llvm-14-doc postgresql-doc python-pygments-doc ttf-bitstream-vera Recommended packages: manpages manpages-dev libc-devtools libjson-xs-perl binfmt-support sysstat The following NEW packages will be installed: clang-14 gcc-11-base icu-devtools libasan6 libatomic1 libc-dev-bin libc6-dev libclang-common-14-dev libclang-cpp14 libclang1-14 libcrypt-dev libffi-dev libgc1 libgcc-11-dev libgomp1 libicu-dev libitm1 libjson-perl libllvm14 liblsan0 libncurses-dev libnsl-dev libobjc-11-dev libobjc4 libpfm4 libpq-dev libpq5 libquadmath0 libssl-dev libstdc++-11-dev libtinfo-dev libtirpc-dev libtsan0 libubsan1 libxml2-dev libxslt1.1 libz3-4 libz3-dev linux-libc-dev llvm-14 llvm-14-dev llvm-14-linker-tools llvm-14-runtime llvm-14-tools postgresql postgresql-14 postgresql-client-14 postgresql-client-common postgresql-common postgresql-server-dev-14 postgresql-server-dev-all prometheus-sql-exporter python3-pygments rpcsvc-proto ssl-cert 0 upgraded, 55 newly installed, 0 to remove and 0 not upgraded. 1 not fully installed or removed. Need to get 165 MB of archives. After this operation, 899 MB of additional disk space will be used. Get:1 http://ftpmaster.internal/ubuntu jammy/main ppc64el libjson-perl all 4.04000-1 [81.8 kB] Get:2 http://ftpmaster.internal/ubuntu jammy-proposed/main ppc64el postgresql-client-common all 238ubuntu0.1 [29.2 kB] Get:3 http://ftpmaster.internal/ubuntu jammy/main ppc64el ssl-cert all 1.1.2 [17.4 kB] Get:4 http://ftpmaster.internal/ubuntu jammy-proposed/main ppc64el postgresql-common all 238ubuntu0.1 [169 kB] Get:5 http://ftpmaster.internal/ubuntu jammy/universe ppc64el prometheus-sql-exporter ppc64el 0.4.2-1 [2516 kB] Get:6 http://ftpmaster.internal/ubuntu jammy-updates/main ppc64el libpq5 ppc64el 14.7-0ubuntu0.22.04.1 [176 kB] Get:7 http://ftpmaster.internal/ubuntu jammy-updates/main ppc64el postgresql-client-14 ppc64el 14.7-0ubuntu0.22.04.1 [1332 kB] Get:8 http://ftpmaster.internal/ubuntu jammy/main ppc64el libllvm14 ppc64el 1:14.0.0-1ubuntu1 [24.7 MB] Get:9 http://ftpmaster.internal/ubuntu jammy-updates/main ppc64el libxslt1.1 ppc64el 1.1.34-4ubuntu0.22.04.1 [184 kB] Get:10 http://ftpmaster.internal/ubuntu jammy-updates/main ppc64el postgresql-14 ppc64el 14.7-0ubuntu0.22.04.1 [17.4 MB] Get:11 http://ftpmaster.internal/ubuntu jammy-proposed/main ppc64el postgresql all 14+238ubuntu0.1 [2958 B] Get:12 http://ftpmaster.internal/ubuntu jammy/universe ppc64el libclang-cpp14 ppc64el 1:14.0.0-1ubuntu1 [12.6 MB] Get:13 http://ftpmaster.internal/ubuntu jammy-updates/main ppc64el gcc-11-base ppc64el 11.3.0-1ubuntu1~22.04.1 [20.9 kB] Get:14 http://ftpmaster.internal/ubuntu jammy-updates/main ppc64el libgomp1 ppc64el 12.1.0-2ubuntu1~22.04 [140 kB] Get:15 http://ftpmaster.internal/ubuntu jammy-updates/main ppc64el libitm1 ppc64el 12.1.0-2ubuntu1~22.04 [32.9 kB] Get:16 http://ftpmaster.internal/ubuntu jammy-updates/main ppc64el libatomic1 ppc64el 12.1.0-2ubuntu1~22.04 [10.6 kB] Get:17 http://ftpmaster.internal/ubuntu jammy-updates/main ppc64el libasan6 ppc64el 11.3.0-1ubuntu1~22.04.1 [2306 kB] Get:18 http://ftpmaster.internal/ubuntu jammy-updates/main ppc64el liblsan0 ppc64el 12.1.0-2ubuntu1~22.04 [1090 kB] Get:19 http://ftpmaster.internal/ubuntu jammy-updates/main ppc64el libtsan0 ppc64el 11.3.0-1ubuntu1~22.04.1 [2282 kB] Get:20 http://ftpmaster.internal/ubuntu jammy-updates/main ppc64el libubsan1 ppc64el 12.1.0-2ubuntu1~22.04 [1001 kB] Get:21 http://ftpmaster.internal/ubuntu jammy-updates/main ppc64el libquadmath0 ppc64el 12.1.0-2ubuntu1~22.04 [156 kB] Get:22 http://ftpmaster.internal/ubuntu jammy-updates/main ppc64el libgcc-11-dev ppc64el 11.3.0-1ubuntu1~22.04.1 [1484 kB] Get:23 http://ftpmaster.internal/ubuntu jammy-updates/main ppc64el libc-dev-bin ppc64el 2.35-0ubuntu3.1 [21.4 kB] Get:24 http://ftpmaster.internal/ubuntu jammy-updates/main ppc64el linux-libc-dev ppc64el 5.15.0-72.79 [1324 kB] Get:25 http://ftpmaster.internal/ubuntu jammy/main ppc64el libcrypt-dev ppc64el 1:4.4.27-1 [142 kB] Get:26 http://ftpmaster.internal/ubuntu jammy/main ppc64el rpcsvc-proto ppc64el 1.4.2-0ubuntu6 [82.3 kB] Get:27 http://ftpmaster.internal/ubuntu jammy-updates/main ppc64el libtirpc-dev ppc64el 1.3.2-2ubuntu0.1 [223 kB] Get:28 http://ftpmaster.internal/ubuntu jammy/main ppc64el libnsl-dev ppc64el 1.3.0-2build2 [80.0 kB] Get:29 http://ftpmaster.internal/ubuntu jammy-updates/main ppc64el libc6-dev ppc64el 2.35-0ubuntu3.1 [2055 kB] Get:30 http://ftpmaster.internal/ubuntu jammy-updates/main ppc64el libstdc++-11-dev ppc64el 11.3.0-1ubuntu1~22.04.1 [2189 kB] Get:31 http://ftpmaster.internal/ubuntu jammy/main ppc64el libgc1 ppc64el 1:8.0.6-1.1build1 [109 kB] Get:32 http://ftpmaster.internal/ubuntu jammy-updates/universe ppc64el libobjc4 ppc64el 12.1.0-2ubuntu1~22.04 [54.3 kB] Get:33 http://ftpmaster.internal/ubuntu jammy-updates/universe ppc64el libobjc-11-dev ppc64el 11.3.0-1ubuntu1~22.04.1 [223 kB] Get:34 http://ftpmaster.internal/ubuntu jammy/universe ppc64el libclang-common-14-dev ppc64el 1:14.0.0-1ubuntu1 [4254 kB] Get:35 http://ftpmaster.internal/ubuntu jammy/universe ppc64el llvm-14-linker-tools ppc64el 1:14.0.0-1ubuntu1 [1404 kB] Get:36 http://ftpmaster.internal/ubuntu jammy/universe ppc64el libclang1-14 ppc64el 1:14.0.0-1ubuntu1 [7453 kB] Get:37 http://ftpmaster.internal/ubuntu jammy/universe ppc64el clang-14 ppc64el 1:14.0.0-1ubuntu1 [81.3 kB] Get:38 http://ftpmaster.internal/ubuntu jammy-updates/main ppc64el libssl-dev ppc64el 3.0.2-0ubuntu1.9 [2617 kB] Get:39 http://ftpmaster.internal/ubuntu jammy-updates/main ppc64el libpq-dev ppc64el 14.7-0ubuntu0.22.04.1 [170 kB] Get:40 http://ftpmaster.internal/ubuntu jammy/main ppc64el libffi-dev ppc64el 3.4.2-4 [67.5 kB] Get:41 http://ftpmaster.internal/ubuntu jammy/universe ppc64el llvm-14-runtime ppc64el 1:14.0.0-1ubuntu1 [509 kB] Get:42 http://ftpmaster.internal/ubuntu jammy-updates/main ppc64el libpfm4 ppc64el 4.11.1+git32-gd0b85fb-1ubuntu0.1 [166 kB] Get:43 http://ftpmaster.internal/ubuntu jammy/universe ppc64el llvm-14 ppc64el 1:14.0.0-1ubuntu1 [12.6 MB] Get:44 http://ftpmaster.internal/ubuntu jammy/main ppc64el libncurses-dev ppc64el 6.3-2 [480 kB] Get:45 http://ftpmaster.internal/ubuntu jammy/main ppc64el libtinfo-dev ppc64el 6.3-2 [774 B] Get:46 http://ftpmaster.internal/ubuntu jammy/main ppc64el python3-pygments all 2.11.2+dfsg-2 [750 kB] Get:47 http://ftpmaster.internal/ubuntu jammy/universe ppc64el llvm-14-tools ppc64el 1:14.0.0-1ubuntu1 [478 kB] Get:48 http://ftpmaster.internal/ubuntu jammy/universe ppc64el libz3-4 ppc64el 4.8.12-1 [6066 kB] Get:49 http://ftpmaster.internal/ubuntu jammy/universe ppc64el libz3-dev ppc64el 4.8.12-1 [72.2 kB] Get:50 http://ftpmaster.internal/ubuntu jammy/main ppc64el icu-devtools ppc64el 70.1-2 [224 kB] Get:51 http://ftpmaster.internal/ubuntu jammy/main ppc64el libicu-dev ppc64el 70.1-2 [12.2 MB] Get:52 http://ftpmaster.internal/ubuntu jammy-updates/main ppc64el libxml2-dev ppc64el 2.9.13+dfsg-1ubuntu0.3 [929 kB] Get:53 http://ftpmaster.internal/ubuntu jammy/universe ppc64el llvm-14-dev ppc64el 1:14.0.0-1ubuntu1 [39.0 MB] Get:54 http://ftpmaster.internal/ubuntu jammy-updates/universe ppc64el postgresql-server-dev-14 ppc64el 14.7-0ubuntu0.22.04.1 [1213 kB] Get:55 http://ftpmaster.internal/ubuntu jammy-proposed/universe ppc64el postgresql-server-dev-all ppc64el 238ubuntu0.1 [13.6 kB] Preconfiguring packages ... Fetched 165 MB in 31s (5377 kB/s) Selecting previously unselected package libjson-perl. (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 ... 94326 files and directories currently installed.) Preparing to unpack .../00-libjson-perl_4.04000-1_all.deb ... Unpacking libjson-perl (4.04000-1) ... Selecting previously unselected package postgresql-client-common. Preparing to unpack .../01-postgresql-client-common_238ubuntu0.1_all.deb ... Unpacking postgresql-client-common (238ubuntu0.1) ... Selecting previously unselected package ssl-cert. Preparing to unpack .../02-ssl-cert_1.1.2_all.deb ... Unpacking ssl-cert (1.1.2) ... Selecting previously unselected package postgresql-common. Preparing to unpack .../03-postgresql-common_238ubuntu0.1_all.deb ... Adding 'diversion of /usr/bin/pg_config to /usr/bin/pg_config.libpq-dev by postgresql-common' Unpacking postgresql-common (238ubuntu0.1) ... Selecting previously unselected package prometheus-sql-exporter. Preparing to unpack .../04-prometheus-sql-exporter_0.4.2-1_ppc64el.deb ... Unpacking prometheus-sql-exporter (0.4.2-1) ... Selecting previously unselected package libpq5:ppc64el. Preparing to unpack .../05-libpq5_14.7-0ubuntu0.22.04.1_ppc64el.deb ... Unpacking libpq5:ppc64el (14.7-0ubuntu0.22.04.1) ... Selecting previously unselected package postgresql-client-14. Preparing to unpack .../06-postgresql-client-14_14.7-0ubuntu0.22.04.1_ppc64el.deb ... Unpacking postgresql-client-14 (14.7-0ubuntu0.22.04.1) ... Selecting previously unselected package libllvm14:ppc64el. Preparing to unpack .../07-libllvm14_1%3a14.0.0-1ubuntu1_ppc64el.deb ... Unpacking libllvm14:ppc64el (1:14.0.0-1ubuntu1) ... Selecting previously unselected package libxslt1.1:ppc64el. Preparing to unpack .../08-libxslt1.1_1.1.34-4ubuntu0.22.04.1_ppc64el.deb ... Unpacking libxslt1.1:ppc64el (1.1.34-4ubuntu0.22.04.1) ... Selecting previously unselected package postgresql-14. Preparing to unpack .../09-postgresql-14_14.7-0ubuntu0.22.04.1_ppc64el.deb ... Unpacking postgresql-14 (14.7-0ubuntu0.22.04.1) ... Selecting previously unselected package postgresql. Preparing to unpack .../10-postgresql_14+238ubuntu0.1_all.deb ... Unpacking postgresql (14+238ubuntu0.1) ... Selecting previously unselected package libclang-cpp14. Preparing to unpack .../11-libclang-cpp14_1%3a14.0.0-1ubuntu1_ppc64el.deb ... Unpacking libclang-cpp14 (1:14.0.0-1ubuntu1) ... Selecting previously unselected package gcc-11-base:ppc64el. Preparing to unpack .../12-gcc-11-base_11.3.0-1ubuntu1~22.04.1_ppc64el.deb ... Unpacking gcc-11-base:ppc64el (11.3.0-1ubuntu1~22.04.1) ... Selecting previously unselected package libgomp1:ppc64el. Preparing to unpack .../13-libgomp1_12.1.0-2ubuntu1~22.04_ppc64el.deb ... Unpacking libgomp1:ppc64el (12.1.0-2ubuntu1~22.04) ... Selecting previously unselected package libitm1:ppc64el. Preparing to unpack .../14-libitm1_12.1.0-2ubuntu1~22.04_ppc64el.deb ... Unpacking libitm1:ppc64el (12.1.0-2ubuntu1~22.04) ... Selecting previously unselected package libatomic1:ppc64el. Preparing to unpack .../15-libatomic1_12.1.0-2ubuntu1~22.04_ppc64el.deb ... Unpacking libatomic1:ppc64el (12.1.0-2ubuntu1~22.04) ... Selecting previously unselected package libasan6:ppc64el. Preparing to unpack .../16-libasan6_11.3.0-1ubuntu1~22.04.1_ppc64el.deb ... Unpacking libasan6:ppc64el (11.3.0-1ubuntu1~22.04.1) ... Selecting previously unselected package liblsan0:ppc64el. Preparing to unpack .../17-liblsan0_12.1.0-2ubuntu1~22.04_ppc64el.deb ... Unpacking liblsan0:ppc64el (12.1.0-2ubuntu1~22.04) ... Selecting previously unselected package libtsan0:ppc64el. Preparing to unpack .../18-libtsan0_11.3.0-1ubuntu1~22.04.1_ppc64el.deb ... Unpacking libtsan0:ppc64el (11.3.0-1ubuntu1~22.04.1) ... Selecting previously unselected package libubsan1:ppc64el. Preparing to unpack .../19-libubsan1_12.1.0-2ubuntu1~22.04_ppc64el.deb ... Unpacking libubsan1:ppc64el (12.1.0-2ubuntu1~22.04) ... Selecting previously unselected package libquadmath0:ppc64el. Preparing to unpack .../20-libquadmath0_12.1.0-2ubuntu1~22.04_ppc64el.deb ... Unpacking libquadmath0:ppc64el (12.1.0-2ubuntu1~22.04) ... Selecting previously unselected package libgcc-11-dev:ppc64el. Preparing to unpack .../21-libgcc-11-dev_11.3.0-1ubuntu1~22.04.1_ppc64el.deb ... Unpacking libgcc-11-dev:ppc64el (11.3.0-1ubuntu1~22.04.1) ... Selecting previously unselected package libc-dev-bin. Preparing to unpack .../22-libc-dev-bin_2.35-0ubuntu3.1_ppc64el.deb ... Unpacking libc-dev-bin (2.35-0ubuntu3.1) ... Selecting previously unselected package linux-libc-dev:ppc64el. Preparing to unpack .../23-linux-libc-dev_5.15.0-72.79_ppc64el.deb ... Unpacking linux-libc-dev:ppc64el (5.15.0-72.79) ... Selecting previously unselected package libcrypt-dev:ppc64el. Preparing to unpack .../24-libcrypt-dev_1%3a4.4.27-1_ppc64el.deb ... Unpacking libcrypt-dev:ppc64el (1:4.4.27-1) ... Selecting previously unselected package rpcsvc-proto. Preparing to unpack .../25-rpcsvc-proto_1.4.2-0ubuntu6_ppc64el.deb ... Unpacking rpcsvc-proto (1.4.2-0ubuntu6) ... Selecting previously unselected package libtirpc-dev:ppc64el. Preparing to unpack .../26-libtirpc-dev_1.3.2-2ubuntu0.1_ppc64el.deb ... Unpacking libtirpc-dev:ppc64el (1.3.2-2ubuntu0.1) ... Selecting previously unselected package libnsl-dev:ppc64el. Preparing to unpack .../27-libnsl-dev_1.3.0-2build2_ppc64el.deb ... Unpacking libnsl-dev:ppc64el (1.3.0-2build2) ... Selecting previously unselected package libc6-dev:ppc64el. Preparing to unpack .../28-libc6-dev_2.35-0ubuntu3.1_ppc64el.deb ... Unpacking libc6-dev:ppc64el (2.35-0ubuntu3.1) ... Selecting previously unselected package libstdc++-11-dev:ppc64el. Preparing to unpack .../29-libstdc++-11-dev_11.3.0-1ubuntu1~22.04.1_ppc64el.deb ... Unpacking libstdc++-11-dev:ppc64el (11.3.0-1ubuntu1~22.04.1) ... Selecting previously unselected package libgc1:ppc64el. Preparing to unpack .../30-libgc1_1%3a8.0.6-1.1build1_ppc64el.deb ... Unpacking libgc1:ppc64el (1:8.0.6-1.1build1) ... Selecting previously unselected package libobjc4:ppc64el. Preparing to unpack .../31-libobjc4_12.1.0-2ubuntu1~22.04_ppc64el.deb ... Unpacking libobjc4:ppc64el (12.1.0-2ubuntu1~22.04) ... Selecting previously unselected package libobjc-11-dev:ppc64el. Preparing to unpack .../32-libobjc-11-dev_11.3.0-1ubuntu1~22.04.1_ppc64el.deb ... Unpacking libobjc-11-dev:ppc64el (11.3.0-1ubuntu1~22.04.1) ... Selecting previously unselected package libclang-common-14-dev. Preparing to unpack .../33-libclang-common-14-dev_1%3a14.0.0-1ubuntu1_ppc64el.deb ... Unpacking libclang-common-14-dev (1:14.0.0-1ubuntu1) ... Selecting previously unselected package llvm-14-linker-tools. Preparing to unpack .../34-llvm-14-linker-tools_1%3a14.0.0-1ubuntu1_ppc64el.deb ... Unpacking llvm-14-linker-tools (1:14.0.0-1ubuntu1) ... Selecting previously unselected package libclang1-14. Preparing to unpack .../35-libclang1-14_1%3a14.0.0-1ubuntu1_ppc64el.deb ... Unpacking libclang1-14 (1:14.0.0-1ubuntu1) ... Selecting previously unselected package clang-14. Preparing to unpack .../36-clang-14_1%3a14.0.0-1ubuntu1_ppc64el.deb ... Unpacking clang-14 (1:14.0.0-1ubuntu1) ... Selecting previously unselected package libssl-dev:ppc64el. Preparing to unpack .../37-libssl-dev_3.0.2-0ubuntu1.9_ppc64el.deb ... Unpacking libssl-dev:ppc64el (3.0.2-0ubuntu1.9) ... Selecting previously unselected package libpq-dev. Preparing to unpack .../38-libpq-dev_14.7-0ubuntu0.22.04.1_ppc64el.deb ... Unpacking libpq-dev (14.7-0ubuntu0.22.04.1) ... Selecting previously unselected package libffi-dev:ppc64el. Preparing to unpack .../39-libffi-dev_3.4.2-4_ppc64el.deb ... Unpacking libffi-dev:ppc64el (3.4.2-4) ... Selecting previously unselected package llvm-14-runtime. Preparing to unpack .../40-llvm-14-runtime_1%3a14.0.0-1ubuntu1_ppc64el.deb ... Unpacking llvm-14-runtime (1:14.0.0-1ubuntu1) ... Selecting previously unselected package libpfm4:ppc64el. Preparing to unpack .../41-libpfm4_4.11.1+git32-gd0b85fb-1ubuntu0.1_ppc64el.deb ... Unpacking libpfm4:ppc64el (4.11.1+git32-gd0b85fb-1ubuntu0.1) ... Selecting previously unselected package llvm-14. Preparing to unpack .../42-llvm-14_1%3a14.0.0-1ubuntu1_ppc64el.deb ... Unpacking llvm-14 (1:14.0.0-1ubuntu1) ... Selecting previously unselected package libncurses-dev:ppc64el. Preparing to unpack .../43-libncurses-dev_6.3-2_ppc64el.deb ... Unpacking libncurses-dev:ppc64el (6.3-2) ... Selecting previously unselected package libtinfo-dev:ppc64el. Preparing to unpack .../44-libtinfo-dev_6.3-2_ppc64el.deb ... Unpacking libtinfo-dev:ppc64el (6.3-2) ... Selecting previously unselected package python3-pygments. Preparing to unpack .../45-python3-pygments_2.11.2+dfsg-2_all.deb ... Unpacking python3-pygments (2.11.2+dfsg-2) ... Selecting previously unselected package llvm-14-tools. Preparing to unpack .../46-llvm-14-tools_1%3a14.0.0-1ubuntu1_ppc64el.deb ... Unpacking llvm-14-tools (1:14.0.0-1ubuntu1) ... Selecting previously unselected package libz3-4:ppc64el. Preparing to unpack .../47-libz3-4_4.8.12-1_ppc64el.deb ... Unpacking libz3-4:ppc64el (4.8.12-1) ... Selecting previously unselected package libz3-dev:ppc64el. Preparing to unpack .../48-libz3-dev_4.8.12-1_ppc64el.deb ... Unpacking libz3-dev:ppc64el (4.8.12-1) ... Selecting previously unselected package icu-devtools. Preparing to unpack .../49-icu-devtools_70.1-2_ppc64el.deb ... Unpacking icu-devtools (70.1-2) ... Selecting previously unselected package libicu-dev:ppc64el. Preparing to unpack .../50-libicu-dev_70.1-2_ppc64el.deb ... Unpacking libicu-dev:ppc64el (70.1-2) ... Selecting previously unselected package libxml2-dev:ppc64el. Preparing to unpack .../51-libxml2-dev_2.9.13+dfsg-1ubuntu0.3_ppc64el.deb ... Unpacking libxml2-dev:ppc64el (2.9.13+dfsg-1ubuntu0.3) ... Selecting previously unselected package llvm-14-dev. Preparing to unpack .../52-llvm-14-dev_1%3a14.0.0-1ubuntu1_ppc64el.deb ... Unpacking llvm-14-dev (1:14.0.0-1ubuntu1) ... Selecting previously unselected package postgresql-server-dev-14. Preparing to unpack .../53-postgresql-server-dev-14_14.7-0ubuntu0.22.04.1_ppc64el.deb ... Unpacking postgresql-server-dev-14 (14.7-0ubuntu0.22.04.1) ... Selecting previously unselected package postgresql-server-dev-all:ppc64el. Preparing to unpack .../54-postgresql-server-dev-all_238ubuntu0.1_ppc64el.deb ... Unpacking postgresql-server-dev-all:ppc64el (238ubuntu0.1) ... Setting up postgresql-client-common (238ubuntu0.1) ... Setting up gcc-11-base:ppc64el (11.3.0-1ubuntu1~22.04.1) ... Setting up libpq5:ppc64el (14.7-0ubuntu0.22.04.1) ... Setting up linux-libc-dev:ppc64el (5.15.0-72.79) ... Setting up libgomp1:ppc64el (12.1.0-2ubuntu1~22.04) ... Setting up postgresql-client-14 (14.7-0ubuntu0.22.04.1) ... update-alternatives: using /usr/share/postgresql/14/man/man1/psql.1.gz to provide /usr/share/man/man1/psql.1.gz (psql.1.gz) in auto mode Setting up libffi-dev:ppc64el (3.4.2-4) ... Setting up libasan6:ppc64el (11.3.0-1ubuntu1~22.04.1) ... Setting up python3-pygments (2.11.2+dfsg-2) ... Setting up libz3-4:ppc64el (4.8.12-1) ... Setting up libtirpc-dev:ppc64el (1.3.2-2ubuntu0.1) ... Setting up libpfm4:ppc64el (4.11.1+git32-gd0b85fb-1ubuntu0.1) ... Setting up rpcsvc-proto (1.4.2-0ubuntu6) ... Setting up ssl-cert (1.1.2) ... Setting up libquadmath0:ppc64el (12.1.0-2ubuntu1~22.04) ... Setting up libssl-dev:ppc64el (3.0.2-0ubuntu1.9) ... Setting up libatomic1:ppc64el (12.1.0-2ubuntu1~22.04) ... Setting up icu-devtools (70.1-2) ... Setting up libgc1:ppc64el (1:8.0.6-1.1build1) ... Setting up libubsan1:ppc64el (12.1.0-2ubuntu1~22.04) ... Setting up libllvm14:ppc64el (1:14.0.0-1ubuntu1) ... Setting up libnsl-dev:ppc64el (1.3.0-2build2) ... Setting up libcrypt-dev:ppc64el (1:4.4.27-1) ... Setting up libjson-perl (4.04000-1) ... Setting up libxslt1.1:ppc64el (1.1.34-4ubuntu0.22.04.1) ... Setting up libc-dev-bin (2.35-0ubuntu3.1) ... Setting up llvm-14-linker-tools (1:14.0.0-1ubuntu1) ... Setting up liblsan0:ppc64el (12.1.0-2ubuntu1~22.04) ... Setting up libitm1:ppc64el (12.1.0-2ubuntu1~22.04) ... Setting up libtsan0:ppc64el (11.3.0-1ubuntu1~22.04.1) ... Setting up llvm-14-tools (1:14.0.0-1ubuntu1) ... Setting up libz3-dev:ppc64el (4.8.12-1) ... Setting up libclang1-14 (1:14.0.0-1ubuntu1) ... Setting up libpq-dev (14.7-0ubuntu0.22.04.1) ... Setting up libobjc4:ppc64el (12.1.0-2ubuntu1~22.04) ... Setting up llvm-14-runtime (1:14.0.0-1ubuntu1) ... Setting up postgresql-common (238ubuntu0.1) ... ERROR: ld.so: object 'libeatmydata.so' from LD_PRELOAD cannot be preloaded (cannot open shared object file): ignored. Adding user postgres to group ssl-cert Creating config file /etc/postgresql-common/createcluster.conf with new version Building PostgreSQL dictionaries from installed myspell/hunspell packages... Removing obsolete dictionary files: Created symlink /etc/systemd/system/multi-user.target.wants/postgresql.service → /lib/systemd/system/postgresql.service. Setting up libclang-common-14-dev (1:14.0.0-1ubuntu1) ... Setting up libclang-cpp14 (1:14.0.0-1ubuntu1) ... Setting up libgcc-11-dev:ppc64el (11.3.0-1ubuntu1~22.04.1) ... Setting up libc6-dev:ppc64el (2.35-0ubuntu3.1) ... Setting up prometheus-sql-exporter (0.4.2-1) ... Created symlink /etc/systemd/system/multi-user.target.wants/prometheus-sql-exporter.service → /lib/systemd/system/prometheus-sql-exporter.service. Setting up libicu-dev:ppc64el (70.1-2) ... Setting up llvm-14 (1:14.0.0-1ubuntu1) ... Setting up postgresql-14 (14.7-0ubuntu0.22.04.1) ... Creating new PostgreSQL cluster 14/main ... /usr/lib/postgresql/14/bin/initdb -D /var/lib/postgresql/14/main --auth-local peer --auth-host scram-sha-256 --no-instructions The files belonging to this database system will be owned by user "postgres". This user must also own the server process. The database cluster will be initialized with locale "C.UTF-8". The default database encoding has accordingly been set to "UTF8". The default text search configuration will be set to "english". Data page checksums are disabled. fixing permissions on existing directory /var/lib/postgresql/14/main ... ok creating subdirectories ... ok selecting dynamic shared memory implementation ... posix selecting default max_connections ... 100 selecting default shared_buffers ... 128MB selecting default time zone ... Etc/UTC creating configuration files ... ok running bootstrap script ... ok performing post-bootstrap initialization ... ok syncing data to disk ... ok update-alternatives: using /usr/share/postgresql/14/man/man1/postmaster.1.gz to provide /usr/share/man/man1/postmaster.1.gz (postmaster.1.gz) in auto mode Setting up libncurses-dev:ppc64el (6.3-2) ... Setting up libobjc-11-dev:ppc64el (11.3.0-1ubuntu1~22.04.1) ... Setting up libxml2-dev:ppc64el (2.9.13+dfsg-1ubuntu0.3) ... Setting up libstdc++-11-dev:ppc64el (11.3.0-1ubuntu1~22.04.1) ... Setting up postgresql (14+238ubuntu0.1) ... Setting up llvm-14-dev (1:14.0.0-1ubuntu1) ... Setting up libtinfo-dev:ppc64el (6.3-2) ... Setting up clang-14 (1:14.0.0-1ubuntu1) ... Setting up postgresql-server-dev-14 (14.7-0ubuntu0.22.04.1) ... Setting up postgresql-server-dev-all:ppc64el (238ubuntu0.1) ... Setting up autopkgtest-satdep (0) ... Processing triggers for man-db (2.10.2-1) ... Processing triggers for install-info (6.8-4build1) ... Processing triggers for libc-bin (2.35-0ubuntu3.1) ... (Reading database ... 103956 files and directories currently installed.) Removing autopkgtest-satdep (0) ... autopkgtest [01:27:53]: test exporter: [----------------------- + pg_virtualenv Creating new PostgreSQL cluster 14/regress ... + psql CREATE TABLE INSERT 0 1 ++ mktemp --tmpdir sql_exporter.XXXXXX + config=/tmp/sql_exporter.yb3ea0 + trap 'kill $pid || :; rm -f $config' 0 2 3 15 + cat + cat /tmp/sql_exporter.yb3ea0 jobs: - name: "example" interval: 0 connections: - 'postgres://:5433/postgres?sslmode=disable' queries: - name: "test_table" help: "test query for autopkgtest" labels: - "l" values: - "a" query: "SELECT * FROM sql_exporter" + unset PGSYSCONFDIR + pid=3093 + sleep 1 + prometheus-sql-exporter -config.file /tmp/sql_exporter.yb3ea0 -web.listen-address localhost:9238 {"build_context":"(go=go1.17.3, user=, date=)","caller":"main.go:55","msg":"Starting sql_exporter","ts":"2023-05-20T01:27:56.921101678Z","version_info":"(version=, branch=, revision=)"} {"caller":"main.go:78","level":"info","listenAddress":"localhost:9238","msg":"Listening","ts":"2023-05-20T01:27:56.921677024Z"} {"caller":"job.go:185","job":"example","level":"debug","msg":"Starting","ts":"2023-05-20T01:27:56.922509345Z"} + grep 'testlabel.*2716' + curl -f http://localhost:9238/metrics % Total % Received % Xferd Average Speed Time Time Time Current Dload Upload Tot{"caller":"job.go:236","job":"example","level":"debug","msg":"Running Query","query":"test_table","ts":"2023-05-20T01:27:57.934781649Z"} {"caller":"job.go:242","job":"example","level":"debug","msg":"Query finished","query":"test_table","ts":"2023-05-20T01:27:57.935457296Z"} sql_test_table{col="a",database="postgres",driver="postgres",host=":5433",l="testlabel",sql_job="example",user=""} 2716 Dropping cluster 14/regress ... al Spent Left Speed 0 0 0 0 0 0 0 0 --:--:-- --:--:-- --:--:-- 0 100 6279 0 6279 0 0 296k 0 --:--:-- --:--:-- --:--:-- 306k + kill 3093 + rm -f /tmp/sql_exporter.yb3ea0 autopkgtest [01:27:58]: test exporter: -----------------------] autopkgtest [01:27:58]: test exporter: - - - - - - - - - - results - - - - - - - - - - exporter PASS autopkgtest [01:27:59]: @@@@@@@@@@@@@@@@@@@@ summary exporter PASS Creating nova instance adt-jammy-ppc64el-prometheus-sql-exporter-20230520-011940-juju-4d1272-prod-proposed-migration-14 from image adt/ubuntu-jammy-ppc64el-server-20230519.img (UUID ec8e0497-4217-4f25-a0e7-8d904b0e6fe9)...