autopkgtest [01:18:42]: starting date: 2023-05-20 autopkgtest [01:18:42]: git checkout: 5b37e4c Merge branch 'fix-default-release' autopkgtest [01:18:42]: host juju-4d1272-prod-proposed-migration-48; command line: /home/ubuntu/autopkgtest/runner/autopkgtest --output-dir /tmp/autopkgtest-work.juz2c0hr/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-48@lcy02-19.secgroup --name adt-jammy-amd64-prometheus-sql-exporter-20230520-011842-juju-4d1272-prod-proposed-migration-48 --image adt/ubuntu-jammy-amd64-server --keyname testbed-juju-4d1272-prod-proposed-migration-48 --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://ftpmaster.internal/ubuntu/ autopkgtest [01:23:30]: @@@@@@@@@@@@@@@@@@@@ test bed setup Get:1 http://ftpmaster.internal/ubuntu jammy-proposed InRelease [270 kB] Get:2 http://ftpmaster.internal/ubuntu jammy-proposed/main Sources [51.8 kB] 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/multiverse Sources [976 B] Get:6 http://ftpmaster.internal/ubuntu jammy-proposed/main i386 Packages [66.4 kB] Get:7 http://ftpmaster.internal/ubuntu jammy-proposed/main amd64 Packages [159 kB] Get:8 http://ftpmaster.internal/ubuntu jammy-proposed/main amd64 c-n-f Metadata [2704 B] Get:9 http://ftpmaster.internal/ubuntu jammy-proposed/restricted i386 Packages [3688 B] Get:10 http://ftpmaster.internal/ubuntu jammy-proposed/restricted amd64 Packages [156 kB] Get:11 http://ftpmaster.internal/ubuntu jammy-proposed/restricted amd64 c-n-f Metadata [316 B] Get:12 http://ftpmaster.internal/ubuntu jammy-proposed/universe amd64 Packages [159 kB] Get:13 http://ftpmaster.internal/ubuntu jammy-proposed/universe i386 Packages [124 kB] Get:14 http://ftpmaster.internal/ubuntu jammy-proposed/universe amd64 c-n-f Metadata [3352 B] Get:15 http://ftpmaster.internal/ubuntu jammy-proposed/multiverse amd64 Packages [8416 B] Get:16 http://ftpmaster.internal/ubuntu jammy-proposed/multiverse i386 Packages [7776 B] Get:17 http://ftpmaster.internal/ubuntu jammy-proposed/multiverse amd64 c-n-f Metadata [116 B] Fetched 1044 kB in 0s (5015 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 ... 96774 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 ... 96412 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:23:43]: rebooting testbed after setup commands that affected boot autopkgtest [01:23:54]: testbed running kernel: Linux 5.15.0-72-generic #79-Ubuntu SMP Wed Apr 19 08:22:18 UTC 2023 autopkgtest [01:23:55]: testbed dpkg architecture: amd64 autopkgtest [01:23:55]: @@@@@@@@@@@@@@@@@@@@ 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:23:56]: testing package prometheus-sql-exporter version 0.4.2-1 autopkgtest [01:23:56]: build not needed autopkgtest [01:23:56]: 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 lib32gcc-s1 lib32stdc++6 libasan6 libatomic1 libc-dev-bin libc6-dev libc6-i386 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 lib32gcc-s1 lib32stdc++6 libasan6 libatomic1 libc-dev-bin libc6-dev libc6-i386 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, 58 newly installed, 0 to remove and 0 not upgraded. 1 not fully installed or removed. Need to get 166 MB of archives. After this operation, 862 MB of additional disk space will be used. Get:1 http://ftpmaster.internal/ubuntu jammy/main amd64 libjson-perl all 4.04000-1 [81.8 kB] Get:2 http://ftpmaster.internal/ubuntu jammy-proposed/main amd64 postgresql-client-common all 238ubuntu0.1 [29.2 kB] Get:3 http://ftpmaster.internal/ubuntu jammy/main amd64 ssl-cert all 1.1.2 [17.4 kB] Get:4 http://ftpmaster.internal/ubuntu jammy-proposed/main amd64 postgresql-common all 238ubuntu0.1 [169 kB] Get:5 http://ftpmaster.internal/ubuntu jammy/universe amd64 prometheus-sql-exporter amd64 0.4.2-1 [2966 kB] Get:6 http://ftpmaster.internal/ubuntu jammy-updates/main amd64 libpq5 amd64 14.7-0ubuntu0.22.04.1 [141 kB] Get:7 http://ftpmaster.internal/ubuntu jammy-updates/main amd64 postgresql-client-14 amd64 14.7-0ubuntu0.22.04.1 [1220 kB] Get:8 http://ftpmaster.internal/ubuntu jammy/main amd64 libllvm14 amd64 1:14.0.0-1ubuntu1 [24.0 MB] Get:9 http://ftpmaster.internal/ubuntu jammy-updates/main amd64 libxslt1.1 amd64 1.1.34-4ubuntu0.22.04.1 [164 kB] Get:10 http://ftpmaster.internal/ubuntu jammy-updates/main amd64 postgresql-14 amd64 14.7-0ubuntu0.22.04.1 [16.1 MB] Get:11 http://ftpmaster.internal/ubuntu jammy-proposed/main amd64 postgresql all 14+238ubuntu0.1 [2958 B] Get:12 http://ftpmaster.internal/ubuntu jammy/universe amd64 libclang-cpp14 amd64 1:14.0.0-1ubuntu1 [12.1 MB] Get:13 http://ftpmaster.internal/ubuntu jammy-updates/main amd64 gcc-11-base amd64 11.3.0-1ubuntu1~22.04.1 [20.9 kB] Get:14 http://ftpmaster.internal/ubuntu jammy-updates/main amd64 libgomp1 amd64 12.1.0-2ubuntu1~22.04 [126 kB] Get:15 http://ftpmaster.internal/ubuntu jammy-updates/main amd64 libitm1 amd64 12.1.0-2ubuntu1~22.04 [30.2 kB] Get:16 http://ftpmaster.internal/ubuntu jammy-updates/main amd64 libatomic1 amd64 12.1.0-2ubuntu1~22.04 [10.4 kB] Get:17 http://ftpmaster.internal/ubuntu jammy-updates/main amd64 libasan6 amd64 11.3.0-1ubuntu1~22.04.1 [2284 kB] Get:18 http://ftpmaster.internal/ubuntu jammy-updates/main amd64 liblsan0 amd64 12.1.0-2ubuntu1~22.04 [1069 kB] Get:19 http://ftpmaster.internal/ubuntu jammy-updates/main amd64 libtsan0 amd64 11.3.0-1ubuntu1~22.04.1 [2260 kB] Get:20 http://ftpmaster.internal/ubuntu jammy-updates/main amd64 libubsan1 amd64 12.1.0-2ubuntu1~22.04 [976 kB] Get:21 http://ftpmaster.internal/ubuntu jammy-updates/main amd64 libquadmath0 amd64 12.1.0-2ubuntu1~22.04 [154 kB] Get:22 http://ftpmaster.internal/ubuntu jammy-updates/main amd64 libgcc-11-dev amd64 11.3.0-1ubuntu1~22.04.1 [2516 kB] Get:23 http://ftpmaster.internal/ubuntu jammy-updates/main amd64 libc-dev-bin amd64 2.35-0ubuntu3.1 [20.4 kB] Get:24 http://ftpmaster.internal/ubuntu jammy-updates/main amd64 linux-libc-dev amd64 5.15.0-72.79 [1331 kB] Get:25 http://ftpmaster.internal/ubuntu jammy/main amd64 libcrypt-dev amd64 1:4.4.27-1 [112 kB] Get:26 http://ftpmaster.internal/ubuntu jammy/main amd64 rpcsvc-proto amd64 1.4.2-0ubuntu6 [68.5 kB] Get:27 http://ftpmaster.internal/ubuntu jammy-updates/main amd64 libtirpc-dev amd64 1.3.2-2ubuntu0.1 [192 kB] Get:28 http://ftpmaster.internal/ubuntu jammy/main amd64 libnsl-dev amd64 1.3.0-2build2 [71.3 kB] Get:29 http://ftpmaster.internal/ubuntu jammy-updates/main amd64 libc6-dev amd64 2.35-0ubuntu3.1 [2099 kB] Get:30 http://ftpmaster.internal/ubuntu jammy-updates/main amd64 libstdc++-11-dev amd64 11.3.0-1ubuntu1~22.04.1 [2087 kB] Get:31 http://ftpmaster.internal/ubuntu jammy/main amd64 libgc1 amd64 1:8.0.6-1.1build1 [96.8 kB] Get:32 http://ftpmaster.internal/ubuntu jammy-updates/universe amd64 libobjc4 amd64 12.1.0-2ubuntu1~22.04 [48.7 kB] Get:33 http://ftpmaster.internal/ubuntu jammy-updates/universe amd64 libobjc-11-dev amd64 11.3.0-1ubuntu1~22.04.1 [196 kB] Get:34 http://ftpmaster.internal/ubuntu jammy-updates/main amd64 libc6-i386 amd64 2.35-0ubuntu3.1 [2837 kB] Get:35 http://ftpmaster.internal/ubuntu jammy-updates/main amd64 lib32gcc-s1 amd64 12.1.0-2ubuntu1~22.04 [64.5 kB] Get:36 http://ftpmaster.internal/ubuntu jammy-updates/main amd64 lib32stdc++6 amd64 12.1.0-2ubuntu1~22.04 [737 kB] Get:37 http://ftpmaster.internal/ubuntu jammy/universe amd64 libclang-common-14-dev amd64 1:14.0.0-1ubuntu1 [5976 kB] Get:38 http://ftpmaster.internal/ubuntu jammy/universe amd64 llvm-14-linker-tools amd64 1:14.0.0-1ubuntu1 [1353 kB] Get:39 http://ftpmaster.internal/ubuntu jammy/universe amd64 libclang1-14 amd64 1:14.0.0-1ubuntu1 [6796 kB] Get:40 http://ftpmaster.internal/ubuntu jammy/universe amd64 clang-14 amd64 1:14.0.0-1ubuntu1 [81.2 kB] Get:41 http://ftpmaster.internal/ubuntu jammy-updates/main amd64 libssl-dev amd64 3.0.2-0ubuntu1.9 [2373 kB] Get:42 http://ftpmaster.internal/ubuntu jammy-updates/main amd64 libpq-dev amd64 14.7-0ubuntu0.22.04.1 [147 kB] Get:43 http://ftpmaster.internal/ubuntu jammy/main amd64 libffi-dev amd64 3.4.2-4 [63.7 kB] Get:44 http://ftpmaster.internal/ubuntu jammy/universe amd64 llvm-14-runtime amd64 1:14.0.0-1ubuntu1 [484 kB] Get:45 http://ftpmaster.internal/ubuntu jammy-updates/main amd64 libpfm4 amd64 4.11.1+git32-gd0b85fb-1ubuntu0.1 [345 kB] Get:46 http://ftpmaster.internal/ubuntu jammy/universe amd64 llvm-14 amd64 1:14.0.0-1ubuntu1 [12.7 MB] Get:47 http://ftpmaster.internal/ubuntu jammy/main amd64 libncurses-dev amd64 6.3-2 [380 kB] Get:48 http://ftpmaster.internal/ubuntu jammy/main amd64 libtinfo-dev amd64 6.3-2 [774 B] Get:49 http://ftpmaster.internal/ubuntu jammy/main amd64 python3-pygments all 2.11.2+dfsg-2 [750 kB] Get:50 http://ftpmaster.internal/ubuntu jammy/universe amd64 llvm-14-tools amd64 1:14.0.0-1ubuntu1 [404 kB] Get:51 http://ftpmaster.internal/ubuntu jammy/universe amd64 libz3-4 amd64 4.8.12-1 [5766 kB] Get:52 http://ftpmaster.internal/ubuntu jammy/universe amd64 libz3-dev amd64 4.8.12-1 [72.2 kB] Get:53 http://ftpmaster.internal/ubuntu jammy/main amd64 icu-devtools amd64 70.1-2 [197 kB] Get:54 http://ftpmaster.internal/ubuntu jammy/main amd64 libicu-dev amd64 70.1-2 [11.6 MB] Get:55 http://ftpmaster.internal/ubuntu jammy-updates/main amd64 libxml2-dev amd64 2.9.13+dfsg-1ubuntu0.3 [804 kB] Get:56 http://ftpmaster.internal/ubuntu jammy/universe amd64 llvm-14-dev amd64 1:14.0.0-1ubuntu1 [37.8 MB] Get:57 http://ftpmaster.internal/ubuntu jammy-updates/universe amd64 postgresql-server-dev-14 amd64 14.7-0ubuntu0.22.04.1 [1174 kB] Get:58 http://ftpmaster.internal/ubuntu jammy-proposed/universe amd64 postgresql-server-dev-all amd64 238ubuntu0.1 [13.6 kB] Preconfiguring packages ... Fetched 166 MB in 1s (159 MB/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 ... 96354 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_amd64.deb ... Unpacking prometheus-sql-exporter (0.4.2-1) ... Selecting previously unselected package libpq5:amd64. Preparing to unpack .../05-libpq5_14.7-0ubuntu0.22.04.1_amd64.deb ... Unpacking libpq5:amd64 (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_amd64.deb ... Unpacking postgresql-client-14 (14.7-0ubuntu0.22.04.1) ... Selecting previously unselected package libllvm14:amd64. Preparing to unpack .../07-libllvm14_1%3a14.0.0-1ubuntu1_amd64.deb ... Unpacking libllvm14:amd64 (1:14.0.0-1ubuntu1) ... Selecting previously unselected package libxslt1.1:amd64. Preparing to unpack .../08-libxslt1.1_1.1.34-4ubuntu0.22.04.1_amd64.deb ... Unpacking libxslt1.1:amd64 (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_amd64.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_amd64.deb ... Unpacking libclang-cpp14 (1:14.0.0-1ubuntu1) ... Selecting previously unselected package gcc-11-base:amd64. Preparing to unpack .../12-gcc-11-base_11.3.0-1ubuntu1~22.04.1_amd64.deb ... Unpacking gcc-11-base:amd64 (11.3.0-1ubuntu1~22.04.1) ... Selecting previously unselected package libgomp1:amd64. Preparing to unpack .../13-libgomp1_12.1.0-2ubuntu1~22.04_amd64.deb ... Unpacking libgomp1:amd64 (12.1.0-2ubuntu1~22.04) ... Selecting previously unselected package libitm1:amd64. Preparing to unpack .../14-libitm1_12.1.0-2ubuntu1~22.04_amd64.deb ... Unpacking libitm1:amd64 (12.1.0-2ubuntu1~22.04) ... Selecting previously unselected package libatomic1:amd64. Preparing to unpack .../15-libatomic1_12.1.0-2ubuntu1~22.04_amd64.deb ... Unpacking libatomic1:amd64 (12.1.0-2ubuntu1~22.04) ... Selecting previously unselected package libasan6:amd64. Preparing to unpack .../16-libasan6_11.3.0-1ubuntu1~22.04.1_amd64.deb ... Unpacking libasan6:amd64 (11.3.0-1ubuntu1~22.04.1) ... Selecting previously unselected package liblsan0:amd64. Preparing to unpack .../17-liblsan0_12.1.0-2ubuntu1~22.04_amd64.deb ... Unpacking liblsan0:amd64 (12.1.0-2ubuntu1~22.04) ... Selecting previously unselected package libtsan0:amd64. Preparing to unpack .../18-libtsan0_11.3.0-1ubuntu1~22.04.1_amd64.deb ... Unpacking libtsan0:amd64 (11.3.0-1ubuntu1~22.04.1) ... Selecting previously unselected package libubsan1:amd64. Preparing to unpack .../19-libubsan1_12.1.0-2ubuntu1~22.04_amd64.deb ... Unpacking libubsan1:amd64 (12.1.0-2ubuntu1~22.04) ... Selecting previously unselected package libquadmath0:amd64. Preparing to unpack .../20-libquadmath0_12.1.0-2ubuntu1~22.04_amd64.deb ... Unpacking libquadmath0:amd64 (12.1.0-2ubuntu1~22.04) ... Selecting previously unselected package libgcc-11-dev:amd64. Preparing to unpack .../21-libgcc-11-dev_11.3.0-1ubuntu1~22.04.1_amd64.deb ... Unpacking libgcc-11-dev:amd64 (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_amd64.deb ... Unpacking libc-dev-bin (2.35-0ubuntu3.1) ... Selecting previously unselected package linux-libc-dev:amd64. Preparing to unpack .../23-linux-libc-dev_5.15.0-72.79_amd64.deb ... Unpacking linux-libc-dev:amd64 (5.15.0-72.79) ... Selecting previously unselected package libcrypt-dev:amd64. Preparing to unpack .../24-libcrypt-dev_1%3a4.4.27-1_amd64.deb ... Unpacking libcrypt-dev:amd64 (1:4.4.27-1) ... Selecting previously unselected package rpcsvc-proto. Preparing to unpack .../25-rpcsvc-proto_1.4.2-0ubuntu6_amd64.deb ... Unpacking rpcsvc-proto (1.4.2-0ubuntu6) ... Selecting previously unselected package libtirpc-dev:amd64. Preparing to unpack .../26-libtirpc-dev_1.3.2-2ubuntu0.1_amd64.deb ... Unpacking libtirpc-dev:amd64 (1.3.2-2ubuntu0.1) ... Selecting previously unselected package libnsl-dev:amd64. Preparing to unpack .../27-libnsl-dev_1.3.0-2build2_amd64.deb ... Unpacking libnsl-dev:amd64 (1.3.0-2build2) ... Selecting previously unselected package libc6-dev:amd64. Preparing to unpack .../28-libc6-dev_2.35-0ubuntu3.1_amd64.deb ... Unpacking libc6-dev:amd64 (2.35-0ubuntu3.1) ... Selecting previously unselected package libstdc++-11-dev:amd64. Preparing to unpack .../29-libstdc++-11-dev_11.3.0-1ubuntu1~22.04.1_amd64.deb ... Unpacking libstdc++-11-dev:amd64 (11.3.0-1ubuntu1~22.04.1) ... Selecting previously unselected package libgc1:amd64. Preparing to unpack .../30-libgc1_1%3a8.0.6-1.1build1_amd64.deb ... Unpacking libgc1:amd64 (1:8.0.6-1.1build1) ... Selecting previously unselected package libobjc4:amd64. Preparing to unpack .../31-libobjc4_12.1.0-2ubuntu1~22.04_amd64.deb ... Unpacking libobjc4:amd64 (12.1.0-2ubuntu1~22.04) ... Selecting previously unselected package libobjc-11-dev:amd64. Preparing to unpack .../32-libobjc-11-dev_11.3.0-1ubuntu1~22.04.1_amd64.deb ... Unpacking libobjc-11-dev:amd64 (11.3.0-1ubuntu1~22.04.1) ... Selecting previously unselected package libc6-i386. Preparing to unpack .../33-libc6-i386_2.35-0ubuntu3.1_amd64.deb ... Unpacking libc6-i386 (2.35-0ubuntu3.1) ... Selecting previously unselected package lib32gcc-s1. Preparing to unpack .../34-lib32gcc-s1_12.1.0-2ubuntu1~22.04_amd64.deb ... Unpacking lib32gcc-s1 (12.1.0-2ubuntu1~22.04) ... Selecting previously unselected package lib32stdc++6. Preparing to unpack .../35-lib32stdc++6_12.1.0-2ubuntu1~22.04_amd64.deb ... Unpacking lib32stdc++6 (12.1.0-2ubuntu1~22.04) ... Selecting previously unselected package libclang-common-14-dev. Preparing to unpack .../36-libclang-common-14-dev_1%3a14.0.0-1ubuntu1_amd64.deb ... Unpacking libclang-common-14-dev (1:14.0.0-1ubuntu1) ... Selecting previously unselected package llvm-14-linker-tools. Preparing to unpack .../37-llvm-14-linker-tools_1%3a14.0.0-1ubuntu1_amd64.deb ... Unpacking llvm-14-linker-tools (1:14.0.0-1ubuntu1) ... Selecting previously unselected package libclang1-14. Preparing to unpack .../38-libclang1-14_1%3a14.0.0-1ubuntu1_amd64.deb ... Unpacking libclang1-14 (1:14.0.0-1ubuntu1) ... Selecting previously unselected package clang-14. Preparing to unpack .../39-clang-14_1%3a14.0.0-1ubuntu1_amd64.deb ... Unpacking clang-14 (1:14.0.0-1ubuntu1) ... Selecting previously unselected package libssl-dev:amd64. Preparing to unpack .../40-libssl-dev_3.0.2-0ubuntu1.9_amd64.deb ... Unpacking libssl-dev:amd64 (3.0.2-0ubuntu1.9) ... Selecting previously unselected package libpq-dev. Preparing to unpack .../41-libpq-dev_14.7-0ubuntu0.22.04.1_amd64.deb ... Unpacking libpq-dev (14.7-0ubuntu0.22.04.1) ... Selecting previously unselected package libffi-dev:amd64. Preparing to unpack .../42-libffi-dev_3.4.2-4_amd64.deb ... Unpacking libffi-dev:amd64 (3.4.2-4) ... Selecting previously unselected package llvm-14-runtime. Preparing to unpack .../43-llvm-14-runtime_1%3a14.0.0-1ubuntu1_amd64.deb ... Unpacking llvm-14-runtime (1:14.0.0-1ubuntu1) ... Selecting previously unselected package libpfm4:amd64. Preparing to unpack .../44-libpfm4_4.11.1+git32-gd0b85fb-1ubuntu0.1_amd64.deb ... Unpacking libpfm4:amd64 (4.11.1+git32-gd0b85fb-1ubuntu0.1) ... Selecting previously unselected package llvm-14. Preparing to unpack .../45-llvm-14_1%3a14.0.0-1ubuntu1_amd64.deb ... Unpacking llvm-14 (1:14.0.0-1ubuntu1) ... Selecting previously unselected package libncurses-dev:amd64. Preparing to unpack .../46-libncurses-dev_6.3-2_amd64.deb ... Unpacking libncurses-dev:amd64 (6.3-2) ... Selecting previously unselected package libtinfo-dev:amd64. Preparing to unpack .../47-libtinfo-dev_6.3-2_amd64.deb ... Unpacking libtinfo-dev:amd64 (6.3-2) ... Selecting previously unselected package python3-pygments. Preparing to unpack .../48-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 .../49-llvm-14-tools_1%3a14.0.0-1ubuntu1_amd64.deb ... Unpacking llvm-14-tools (1:14.0.0-1ubuntu1) ... Selecting previously unselected package libz3-4:amd64. Preparing to unpack .../50-libz3-4_4.8.12-1_amd64.deb ... Unpacking libz3-4:amd64 (4.8.12-1) ... Selecting previously unselected package libz3-dev:amd64. Preparing to unpack .../51-libz3-dev_4.8.12-1_amd64.deb ... Unpacking libz3-dev:amd64 (4.8.12-1) ... Selecting previously unselected package icu-devtools. Preparing to unpack .../52-icu-devtools_70.1-2_amd64.deb ... Unpacking icu-devtools (70.1-2) ... Selecting previously unselected package libicu-dev:amd64. Preparing to unpack .../53-libicu-dev_70.1-2_amd64.deb ... Unpacking libicu-dev:amd64 (70.1-2) ... Selecting previously unselected package libxml2-dev:amd64. Preparing to unpack .../54-libxml2-dev_2.9.13+dfsg-1ubuntu0.3_amd64.deb ... Unpacking libxml2-dev:amd64 (2.9.13+dfsg-1ubuntu0.3) ... Selecting previously unselected package llvm-14-dev. Preparing to unpack .../55-llvm-14-dev_1%3a14.0.0-1ubuntu1_amd64.deb ... Unpacking llvm-14-dev (1:14.0.0-1ubuntu1) ... Selecting previously unselected package postgresql-server-dev-14. Preparing to unpack .../56-postgresql-server-dev-14_14.7-0ubuntu0.22.04.1_amd64.deb ... Unpacking postgresql-server-dev-14 (14.7-0ubuntu0.22.04.1) ... Selecting previously unselected package postgresql-server-dev-all:amd64. Preparing to unpack .../57-postgresql-server-dev-all_238ubuntu0.1_amd64.deb ... Unpacking postgresql-server-dev-all:amd64 (238ubuntu0.1) ... Setting up postgresql-client-common (238ubuntu0.1) ... Setting up gcc-11-base:amd64 (11.3.0-1ubuntu1~22.04.1) ... Setting up libpq5:amd64 (14.7-0ubuntu0.22.04.1) ... Setting up linux-libc-dev:amd64 (5.15.0-72.79) ... Setting up libgomp1:amd64 (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:amd64 (3.4.2-4) ... Setting up libasan6:amd64 (11.3.0-1ubuntu1~22.04.1) ... Setting up python3-pygments (2.11.2+dfsg-2) ... Setting up libz3-4:amd64 (4.8.12-1) ... Setting up libtirpc-dev:amd64 (1.3.2-2ubuntu0.1) ... Setting up libpfm4:amd64 (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:amd64 (12.1.0-2ubuntu1~22.04) ... Setting up libssl-dev:amd64 (3.0.2-0ubuntu1.9) ... Setting up libatomic1:amd64 (12.1.0-2ubuntu1~22.04) ... Setting up icu-devtools (70.1-2) ... Setting up libgc1:amd64 (1:8.0.6-1.1build1) ... Setting up libubsan1:amd64 (12.1.0-2ubuntu1~22.04) ... Setting up libllvm14:amd64 (1:14.0.0-1ubuntu1) ... Setting up libnsl-dev:amd64 (1.3.0-2build2) ... Setting up libcrypt-dev:amd64 (1:4.4.27-1) ... Setting up libjson-perl (4.04000-1) ... Setting up libxslt1.1:amd64 (1.1.34-4ubuntu0.22.04.1) ... Setting up libc6-i386 (2.35-0ubuntu3.1) ... Setting up libc-dev-bin (2.35-0ubuntu3.1) ... Setting up llvm-14-linker-tools (1:14.0.0-1ubuntu1) ... Setting up liblsan0:amd64 (12.1.0-2ubuntu1~22.04) ... Setting up libitm1:amd64 (12.1.0-2ubuntu1~22.04) ... Setting up libtsan0:amd64 (11.3.0-1ubuntu1~22.04.1) ... Setting up llvm-14-tools (1:14.0.0-1ubuntu1) ... Setting up libz3-dev:amd64 (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:amd64 (12.1.0-2ubuntu1~22.04) ... Setting up llvm-14-runtime (1:14.0.0-1ubuntu1) ... Setting up lib32gcc-s1 (12.1.0-2ubuntu1~22.04) ... Setting up lib32stdc++6 (12.1.0-2ubuntu1~22.04) ... 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:amd64 (11.3.0-1ubuntu1~22.04.1) ... Setting up libc6-dev:amd64 (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:amd64 (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:amd64 (6.3-2) ... Setting up libobjc-11-dev:amd64 (11.3.0-1ubuntu1~22.04.1) ... Setting up libxml2-dev:amd64 (2.9.13+dfsg-1ubuntu0.3) ... Setting up libstdc++-11-dev:amd64 (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:amd64 (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:amd64 (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 ... 106441 files and directories currently installed.) Removing autopkgtest-satdep (0) ... autopkgtest [01:24:14]: 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.CASAWk + trap 'kill $pid || :; rm -f $config' 0 2 3 15 + cat + cat /tmp/sql_exporter.CASAWk 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=3132 + sleep 1 + prometheus-sql-exporter -config.file /tmp/sql_exporter.CASAWk -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:24:16.127157934Z","version_info":"(version=, branch=, revision=)"} {"caller":"main.go:78","level":"info","listenAddress":"localhost:9238","msg":"Listening","ts":"2023-05-20T01:24:16.127436084Z"} {"caller":"job.go:185","job":"example","level":"debug","msg":"Starting","ts":"2023-05-20T01:24:16.127504584Z"} + curl -f http://localhost:9238/metrics + grep 'testlabel.*2716' % Total % Received % Xferd Average Speed Time Time Time Current Dload Upload Total Spent Left Speed 0 0 0 0 0 0 0 0 --:--:-- --:--:-- --:--:-- 0{"caller":"job.go:236","job":"example","level":"debug","msg":"Running Query","query":"test_table","ts":"2023-05-20T01:24:17.137742763Z"} {"caller":"job.go:242","job":"example","level":"debug","msg":"Query finished","query":"test_table","ts":"2023-05-20T01:24:17.138192874Z"} 100 6272 0 6272 0 0 960k 0 --:--:-- --:--:-- --:--:-- 1020k sql_test_table{col="a",database="postgres",driver="postgres",host=":5433",l="testlabel",sql_job="example",user=""} 2716 + kill 3132 + rm -f /tmp/sql_exporter.CASAWk Dropping cluster 14/regress ... autopkgtest [01:24:18]: test exporter: -----------------------] autopkgtest [01:24:18]: test exporter: - - - - - - - - - - results - - - - - - - - - - exporter PASS autopkgtest [01:24:18]: @@@@@@@@@@@@@@@@@@@@ summary exporter PASS Creating nova instance adt-jammy-amd64-prometheus-sql-exporter-20230520-011842-juju-4d1272-prod-proposed-migration-48 from image adt/ubuntu-jammy-amd64-server-20230519.img (UUID 8705f953-a581-4e42-b2ee-204bbd4f7a25)...