autopkgtest [02:22:36]: starting date: 2023-05-20 autopkgtest [02:22:36]: git checkout: 842ca0f Temporarily don't consider exitocde 255 a testbed failure autopkgtest [02:22:36]: host juju-4d1272-prod-proposed-migration-14; command line: /home/ubuntu/autopkgtest/runner/autopkgtest --output-dir /tmp/autopkgtest-work.tsfen32f/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@bos02-s390x-7.secgroup --name adt-jammy-s390x-prometheus-sql-exporter-20230520-022236-juju-4d1272-prod-proposed-migration-14 --image adt/ubuntu-jammy-s390x-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://ftpmaster.internal/ubuntu/ autopkgtest [02:23:50]: @@@@@@@@@@@@@@@@@@@@ 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/multiverse Sources [976 B] Get:5 http://ftpmaster.internal/ubuntu jammy-proposed/restricted Sources [8280 B] Get:6 http://ftpmaster.internal/ubuntu jammy-proposed/main s390x Packages [99.7 kB] Get:7 http://ftpmaster.internal/ubuntu jammy-proposed/main s390x c-n-f Metadata [2860 B] Get:8 http://ftpmaster.internal/ubuntu jammy-proposed/restricted s390x Packages [992 B] Get:9 http://ftpmaster.internal/ubuntu jammy-proposed/restricted s390x c-n-f Metadata [116 B] Get:10 http://ftpmaster.internal/ubuntu jammy-proposed/universe s390x Packages [95.1 kB] Get:11 http://ftpmaster.internal/ubuntu jammy-proposed/universe s390x c-n-f Metadata [1728 B] Get:12 http://ftpmaster.internal/ubuntu jammy-proposed/multiverse s390x c-n-f Metadata [116 B] Fetched 554 kB in 1s (695 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 ... 72830 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 ... 72468 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 [02:24:01]: rebooting testbed after setup commands that affected boot autopkgtest [02:24:15]: testbed running kernel: Linux 5.15.0-72-generic #79-Ubuntu SMP Tue Apr 18 17:08:32 UTC 2023 autopkgtest [02:24:15]: testbed dpkg architecture: s390x autopkgtest [02:24:16]: @@@@@@@@@@@@@@@@@@@@ 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 [02:24:18]: testing package prometheus-sql-exporter version 0.4.2-1 autopkgtest [02:24:18]: build not needed autopkgtest [02:24:19]: 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: libjson-perl libpq-dev libpq5 libssl-dev libxslt1.1 postgresql postgresql-14 postgresql-client-14 postgresql-client-common postgresql-common postgresql-server-dev-14 postgresql-server-dev-all prometheus-sql-exporter ssl-cert Suggested packages: postgresql-doc-14 libssl-doc postgresql-doc Recommended packages: libjson-xs-perl sysstat The following NEW packages will be installed: libjson-perl libpq-dev libpq5 libssl-dev libxslt1.1 postgresql postgresql-14 postgresql-client-14 postgresql-client-common postgresql-common postgresql-server-dev-14 postgresql-server-dev-all prometheus-sql-exporter ssl-cert 0 upgraded, 14 newly installed, 0 to remove and 0 not upgraded. 1 not fully installed or removed. Need to get 13.0 MB of archives. After this operation, 53.8 MB of additional disk space will be used. Get:1 http://ftpmaster.internal/ubuntu jammy/main s390x libjson-perl all 4.04000-1 [81.8 kB] Get:2 http://ftpmaster.internal/ubuntu jammy-proposed/main s390x postgresql-client-common all 238ubuntu0.1 [29.2 kB] Get:3 http://ftpmaster.internal/ubuntu jammy/main s390x ssl-cert all 1.1.2 [17.4 kB] Get:4 http://ftpmaster.internal/ubuntu jammy-proposed/main s390x postgresql-common all 238ubuntu0.1 [169 kB] Get:5 http://ftpmaster.internal/ubuntu jammy/universe s390x prometheus-sql-exporter s390x 0.4.2-1 [2736 kB] Get:6 http://ftpmaster.internal/ubuntu jammy-updates/main s390x libpq5 s390x 14.7-0ubuntu0.22.04.1 [135 kB] Get:7 http://ftpmaster.internal/ubuntu jammy-updates/main s390x postgresql-client-14 s390x 14.7-0ubuntu0.22.04.1 [1201 kB] Get:8 http://ftpmaster.internal/ubuntu jammy-updates/main s390x libxslt1.1 s390x 1.1.34-4ubuntu0.22.04.1 [157 kB] Get:9 http://ftpmaster.internal/ubuntu jammy-updates/main s390x postgresql-14 s390x 14.7-0ubuntu0.22.04.1 [5075 kB] Get:10 http://ftpmaster.internal/ubuntu jammy-proposed/main s390x postgresql all 14+238ubuntu0.1 [2958 B] Get:11 http://ftpmaster.internal/ubuntu jammy-updates/main s390x libssl-dev s390x 3.0.2-0ubuntu1.9 [2024 kB] Get:12 http://ftpmaster.internal/ubuntu jammy-updates/main s390x libpq-dev s390x 14.7-0ubuntu0.22.04.1 [146 kB] Get:13 http://ftpmaster.internal/ubuntu jammy-updates/universe s390x postgresql-server-dev-14 s390x 14.7-0ubuntu0.22.04.1 [1169 kB] Get:14 http://ftpmaster.internal/ubuntu jammy-proposed/universe s390x postgresql-server-dev-all s390x 238ubuntu0.1 [13.6 kB] Preconfiguring packages ... Fetched 13.0 MB in 4s (3596 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 ... 72410 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_s390x.deb ... Unpacking prometheus-sql-exporter (0.4.2-1) ... Selecting previously unselected package libpq5:s390x. Preparing to unpack .../05-libpq5_14.7-0ubuntu0.22.04.1_s390x.deb ... Unpacking libpq5:s390x (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_s390x.deb ... Unpacking postgresql-client-14 (14.7-0ubuntu0.22.04.1) ... Selecting previously unselected package libxslt1.1:s390x. Preparing to unpack .../07-libxslt1.1_1.1.34-4ubuntu0.22.04.1_s390x.deb ... Unpacking libxslt1.1:s390x (1.1.34-4ubuntu0.22.04.1) ... Selecting previously unselected package postgresql-14. Preparing to unpack .../08-postgresql-14_14.7-0ubuntu0.22.04.1_s390x.deb ... Unpacking postgresql-14 (14.7-0ubuntu0.22.04.1) ... Selecting previously unselected package postgresql. Preparing to unpack .../09-postgresql_14+238ubuntu0.1_all.deb ... Unpacking postgresql (14+238ubuntu0.1) ... Selecting previously unselected package libssl-dev:s390x. Preparing to unpack .../10-libssl-dev_3.0.2-0ubuntu1.9_s390x.deb ... Unpacking libssl-dev:s390x (3.0.2-0ubuntu1.9) ... Selecting previously unselected package libpq-dev. Preparing to unpack .../11-libpq-dev_14.7-0ubuntu0.22.04.1_s390x.deb ... Unpacking libpq-dev (14.7-0ubuntu0.22.04.1) ... Selecting previously unselected package postgresql-server-dev-14. Preparing to unpack .../12-postgresql-server-dev-14_14.7-0ubuntu0.22.04.1_s390x.deb ... Unpacking postgresql-server-dev-14 (14.7-0ubuntu0.22.04.1) ... Selecting previously unselected package postgresql-server-dev-all:s390x. Preparing to unpack .../13-postgresql-server-dev-all_238ubuntu0.1_s390x.deb ... Unpacking postgresql-server-dev-all:s390x (238ubuntu0.1) ... Setting up postgresql-client-common (238ubuntu0.1) ... Setting up libpq5:s390x (14.7-0ubuntu0.22.04.1) ... 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 ssl-cert (1.1.2) ... Setting up libssl-dev:s390x (3.0.2-0ubuntu1.9) ... Setting up libjson-perl (4.04000-1) ... Setting up libxslt1.1:s390x (1.1.34-4ubuntu0.22.04.1) ... Setting up libpq-dev (14.7-0ubuntu0.22.04.1) ... 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 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 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 postgresql-server-dev-14 (14.7-0ubuntu0.22.04.1) ... Setting up postgresql (14+238ubuntu0.1) ... Setting up postgresql-server-dev-all:s390x (238ubuntu0.1) ... Setting up autopkgtest-satdep (0) ... Processing triggers for man-db (2.10.2-1) ... Processing triggers for libc-bin (2.35-0ubuntu3.1) ... (Reading database ... 74353 files and directories currently installed.) Removing autopkgtest-satdep (0) ... autopkgtest [02:24:36]: 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.9dw9Ls + trap 'kill $pid || :; rm -f $config' 0 2 3 15 + cat + cat /tmp/sql_exporter.9dw9Ls 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=2618 + sleep 1 + prometheus-sql-exporter -config.file /tmp/sql_exporter.9dw9Ls -web.listen-address localhost:9238 {"build_context":"(go=go1.17.3, user=, date=)","caller":"main.go:55","msg":"Starting sql_exporter","ts":"2023-05-20T02:24:38.834212207Z","version_info":"(version=, branch=, revision=)"} {"caller":"main.go:78","level":"info","listenAddress":"localhost:9238","msg":"Listening","ts":"2023-05-20T02:24:38.834534226Z"} {"caller":"job.go:185","job":"example","level":"debug","msg":"Starting","ts":"2023-05-20T02:24:38.834829961Z"} + grep 'testlabel.*2716' + curl -f http://localhost:9238/metrics % Total % Received % Xferd Average Speed Time Time Time Current Dload Upload Total Spent Left Speed 0 0 0 0 0 0 {"caller":"job.go:236","job":"example","level":"debug","msg":"Running Query","query":"test_table","ts":"2023-05-20T02:24:39.853328764Z"} {"caller":"job.go:242","job":"example","level":"debug","msg":"Query finished","query":"test_table","ts":"2023-05-20T02:24:39.853909789Z"} 0 0 --:--:-- --:--:-- --:--:-- 0 100 6274 0 6274 0 0 523k sql_test_table{col="a",database="postgres",driver="postgres",host=":5433",l="testlabel",sql_job="example",user=""} 2716 Dropping cluster 14/regress ... 0 --:--:-- --:--:-- --:--:-- 556k + kill 2618 + rm -f /tmp/sql_exporter.9dw9Ls autopkgtest [02:24:41]: test exporter: -----------------------] autopkgtest [02:24:42]: test exporter: - - - - - - - - - - results - - - - - - - - - - exporter PASS autopkgtest [02:24:42]: @@@@@@@@@@@@@@@@@@@@ summary exporter PASS Creating nova instance adt-jammy-s390x-prometheus-sql-exporter-20230520-022236-juju-4d1272-prod-proposed-migration-14 from image adt/ubuntu-jammy-s390x-server-20230519.img (UUID 7928f8b1-c85f-4928-a366-7de198779cf0)...