0s autopkgtest [16:47:58]: starting date and time: 2025-03-15 16:47:58+0000 0s autopkgtest [16:47:58]: git checkout: 325255d2 Merge branch 'pin-any-arch' into 'ubuntu/production' 0s autopkgtest [16:47:58]: host juju-7f2275-prod-proposed-migration-environment-2; command line: /home/ubuntu/autopkgtest/runner/autopkgtest --output-dir /tmp/autopkgtest-work.4cws3t5r/out --timeout-copy=6000 --setup-commands /home/ubuntu/autopkgtest-cloud/worker-config-production/setup-canonical.sh --apt-pocket=proposed=src:glibc --apt-upgrade postgresql-mysql-fdw --timeout-short=300 --timeout-copy=20000 --timeout-build=20000 --env=ADT_TEST_TRIGGERS=glibc/2.41-1ubuntu2 -- ssh -s /home/ubuntu/autopkgtest/ssh-setup/nova -- --flavor autopkgtest-s390x --security-groups autopkgtest-juju-7f2275-prod-proposed-migration-environment-2@bos03-s390x-24.secgroup --name adt-plucky-s390x-postgresql-mysql-fdw-20250315-164758-juju-7f2275-prod-proposed-migration-environment-2-73c794d2-5d2e-48e4-9dba-b1872f8605ba --image adt/ubuntu-plucky-s390x-server --keyname testbed-juju-7f2275-prod-proposed-migration-environment-2 --net-id=net_prod-proposed-migration-s390x -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/ 135s autopkgtest [16:50:13]: testbed dpkg architecture: s390x 136s autopkgtest [16:50:14]: testbed apt version: 2.9.33 136s autopkgtest [16:50:14]: @@@@@@@@@@@@@@@@@@@@ test bed setup 136s autopkgtest [16:50:14]: testbed release detected to be: None 137s autopkgtest [16:50:15]: updating testbed package index (apt update) 137s Get:1 http://ftpmaster.internal/ubuntu plucky-proposed InRelease [126 kB] 138s Hit:2 http://ftpmaster.internal/ubuntu plucky InRelease 138s Hit:3 http://ftpmaster.internal/ubuntu plucky-updates InRelease 138s Hit:4 http://ftpmaster.internal/ubuntu plucky-security InRelease 138s Get:5 http://ftpmaster.internal/ubuntu plucky-proposed/multiverse Sources [15.8 kB] 138s Get:6 http://ftpmaster.internal/ubuntu plucky-proposed/universe Sources [379 kB] 138s Get:7 http://ftpmaster.internal/ubuntu plucky-proposed/main Sources [99.7 kB] 138s Get:8 http://ftpmaster.internal/ubuntu plucky-proposed/main s390x Packages [113 kB] 138s Get:9 http://ftpmaster.internal/ubuntu plucky-proposed/main s390x c-n-f Metadata [1824 B] 138s Get:10 http://ftpmaster.internal/ubuntu plucky-proposed/restricted s390x c-n-f Metadata [116 B] 138s Get:11 http://ftpmaster.internal/ubuntu plucky-proposed/universe s390x Packages [320 kB] 139s Get:12 http://ftpmaster.internal/ubuntu plucky-proposed/universe s390x c-n-f Metadata [13.4 kB] 139s Get:13 http://ftpmaster.internal/ubuntu plucky-proposed/multiverse s390x Packages [3776 B] 139s Get:14 http://ftpmaster.internal/ubuntu plucky-proposed/multiverse s390x c-n-f Metadata [240 B] 139s Fetched 1073 kB in 2s (681 kB/s) 140s Reading package lists... 140s Reading package lists... 140s Building dependency tree... 140s Reading state information... 140s Calculating upgrade... 140s Calculating upgrade... 140s The following packages were automatically installed and are no longer required: 140s libnsl2 libpython3.12-minimal libpython3.12-stdlib libpython3.12t64 140s linux-headers-6.11.0-8 linux-headers-6.11.0-8-generic 140s linux-modules-6.11.0-8-generic linux-tools-6.11.0-8 140s linux-tools-6.11.0-8-generic 140s Use 'sudo apt autoremove' to remove them. 140s The following packages will be upgraded: 140s pinentry-curses python3-jinja2 strace 141s 3 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 141s Need to get 652 kB of archives. 141s After this operation, 27.6 kB of additional disk space will be used. 141s Get:1 http://ftpmaster.internal/ubuntu plucky/main s390x strace s390x 6.13+ds-1ubuntu1 [500 kB] 141s Get:2 http://ftpmaster.internal/ubuntu plucky/main s390x pinentry-curses s390x 1.3.1-2ubuntu3 [42.9 kB] 141s Get:3 http://ftpmaster.internal/ubuntu plucky/main s390x python3-jinja2 all 3.1.5-2ubuntu1 [109 kB] 142s Fetched 652 kB in 1s (649 kB/s) 142s (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 ... 81428 files and directories currently installed.) 142s Preparing to unpack .../strace_6.13+ds-1ubuntu1_s390x.deb ... 142s Unpacking strace (6.13+ds-1ubuntu1) over (6.11-0ubuntu1) ... 142s Preparing to unpack .../pinentry-curses_1.3.1-2ubuntu3_s390x.deb ... 142s Unpacking pinentry-curses (1.3.1-2ubuntu3) over (1.3.1-2ubuntu2) ... 142s Preparing to unpack .../python3-jinja2_3.1.5-2ubuntu1_all.deb ... 142s Unpacking python3-jinja2 (3.1.5-2ubuntu1) over (3.1.5-2) ... 142s Setting up pinentry-curses (1.3.1-2ubuntu3) ... 142s Setting up python3-jinja2 (3.1.5-2ubuntu1) ... 142s Setting up strace (6.13+ds-1ubuntu1) ... 142s Processing triggers for man-db (2.13.0-1) ... 143s Reading package lists... 143s Building dependency tree... 143s Reading state information... 143s Solving dependencies... 143s The following packages will be REMOVED: 143s libnsl2* libpython3.12-minimal* libpython3.12-stdlib* libpython3.12t64* 143s linux-headers-6.11.0-8* linux-headers-6.11.0-8-generic* 143s linux-modules-6.11.0-8-generic* linux-tools-6.11.0-8* 143s linux-tools-6.11.0-8-generic* 143s 0 upgraded, 0 newly installed, 9 to remove and 5 not upgraded. 143s After this operation, 167 MB disk space will be freed. 143s (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 ... 81428 files and directories currently installed.) 143s Removing linux-tools-6.11.0-8-generic (6.11.0-8.8) ... 143s Removing linux-tools-6.11.0-8 (6.11.0-8.8) ... 143s Removing libpython3.12t64:s390x (3.12.9-1) ... 143s Removing libpython3.12-stdlib:s390x (3.12.9-1) ... 143s Removing libnsl2:s390x (1.3.0-3build3) ... 143s Removing libpython3.12-minimal:s390x (3.12.9-1) ... 143s Removing linux-headers-6.11.0-8-generic (6.11.0-8.8) ... 143s Removing linux-headers-6.11.0-8 (6.11.0-8.8) ... 144s Removing linux-modules-6.11.0-8-generic (6.11.0-8.8) ... 144s Processing triggers for libc-bin (2.41-1ubuntu1) ... 144s (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 ... 56328 files and directories currently installed.) 144s Purging configuration files for libpython3.12-minimal:s390x (3.12.9-1) ... 144s Purging configuration files for linux-modules-6.11.0-8-generic (6.11.0-8.8) ... 144s autopkgtest [16:50:22]: upgrading testbed (apt dist-upgrade and autopurge) 145s Reading package lists... 145s Building dependency tree... 145s Reading state information... 145s Calculating upgrade...Starting pkgProblemResolver with broken count: 0 145s Starting 2 pkgProblemResolver with broken count: 0 145s Done 145s Entering ResolveByKeep 145s 145s Calculating upgrade... 145s The following packages will be upgraded: 145s libc-bin libc-dev-bin libc6 libc6-dev locales 145s 5 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 145s Need to get 9512 kB of archives. 145s After this operation, 8192 B of additional disk space will be used. 145s Get:1 http://ftpmaster.internal/ubuntu plucky-proposed/main s390x libc6-dev s390x 2.41-1ubuntu2 [1678 kB] 148s Get:2 http://ftpmaster.internal/ubuntu plucky-proposed/main s390x libc-dev-bin s390x 2.41-1ubuntu2 [24.3 kB] 148s Get:3 http://ftpmaster.internal/ubuntu plucky-proposed/main s390x libc6 s390x 2.41-1ubuntu2 [2892 kB] 151s Get:4 http://ftpmaster.internal/ubuntu plucky-proposed/main s390x libc-bin s390x 2.41-1ubuntu2 [671 kB] 151s Get:5 http://ftpmaster.internal/ubuntu plucky-proposed/main s390x locales all 2.41-1ubuntu2 [4246 kB] 157s Preconfiguring packages ... 157s Fetched 9512 kB in 11s (863 kB/s) 157s (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 ... 56326 files and directories currently installed.) 157s Preparing to unpack .../libc6-dev_2.41-1ubuntu2_s390x.deb ... 157s Unpacking libc6-dev:s390x (2.41-1ubuntu2) over (2.41-1ubuntu1) ... 157s Preparing to unpack .../libc-dev-bin_2.41-1ubuntu2_s390x.deb ... 157s Unpacking libc-dev-bin (2.41-1ubuntu2) over (2.41-1ubuntu1) ... 157s Preparing to unpack .../libc6_2.41-1ubuntu2_s390x.deb ... 157s Unpacking libc6:s390x (2.41-1ubuntu2) over (2.41-1ubuntu1) ... 157s Setting up libc6:s390x (2.41-1ubuntu2) ... 157s (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 ... 56326 files and directories currently installed.) 157s Preparing to unpack .../libc-bin_2.41-1ubuntu2_s390x.deb ... 157s Unpacking libc-bin (2.41-1ubuntu2) over (2.41-1ubuntu1) ... 157s Setting up libc-bin (2.41-1ubuntu2) ... 157s (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 ... 56326 files and directories currently installed.) 157s Preparing to unpack .../locales_2.41-1ubuntu2_all.deb ... 157s Unpacking locales (2.41-1ubuntu2) over (2.41-1ubuntu1) ... 157s Setting up locales (2.41-1ubuntu2) ... 157s Generating locales (this might take a while)... 158s en_US.UTF-8... done 158s Generation complete. 158s Setting up libc-dev-bin (2.41-1ubuntu2) ... 158s Setting up libc6-dev:s390x (2.41-1ubuntu2) ... 158s Processing triggers for man-db (2.13.0-1) ... 159s Processing triggers for systemd (257.3-1ubuntu3) ... 160s Reading package lists... 160s Building dependency tree... 160s Reading state information... 160s Starting pkgProblemResolver with broken count: 0 160s Starting 2 pkgProblemResolver with broken count: 0 160s Done 160s Solving dependencies... 160s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 161s autopkgtest [16:50:39]: rebooting testbed after setup commands that affected boot 165s autopkgtest-virt-ssh: WARNING: ssh connection failed. Retrying in 3 seconds... 180s autopkgtest [16:50:58]: testbed running kernel: Linux 6.14.0-10-generic #10-Ubuntu SMP Wed Mar 12 14:53:49 UTC 2025 182s autopkgtest [16:51:00]: @@@@@@@@@@@@@@@@@@@@ apt-source postgresql-mysql-fdw 184s Get:1 http://ftpmaster.internal/ubuntu plucky/universe postgresql-mysql-fdw 2.9.2-2build1 (dsc) [2357 B] 184s Get:2 http://ftpmaster.internal/ubuntu plucky/universe postgresql-mysql-fdw 2.9.2-2build1 (tar) [173 kB] 184s Get:3 http://ftpmaster.internal/ubuntu plucky/universe postgresql-mysql-fdw 2.9.2-2build1 (diff) [5172 B] 184s gpgv: Signature made Sat Feb 22 17:26:09 2025 UTC 184s gpgv: using RSA key 63EEFC3DE14D5146CE7F24BF34B8AD7D9529E793 184s gpgv: Can't check signature: No public key 184s dpkg-source: warning: cannot verify inline signature for ./postgresql-mysql-fdw_2.9.2-2build1.dsc: no acceptable signature found 184s autopkgtest [16:51:02]: testing package postgresql-mysql-fdw version 2.9.2-2build1 185s autopkgtest [16:51:03]: build not needed 185s autopkgtest [16:51:03]: test installcheck: preparing testbed 186s Reading package lists... 186s Building dependency tree... 186s Reading state information... 186s Starting pkgProblemResolver with broken count: 0 186s Starting 2 pkgProblemResolver with broken count: 0 186s Done 186s The following NEW packages will be installed: 186s default-libmysqlclient-dev default-mysql-server libio-pty-perl 186s libipc-run-perl libjson-perl libllvm20 libmecab2 libmysqlclient-dev 186s libmysqlclient24 libpq5 libprotobuf-lite32t64 libssl-dev libxslt1.1 186s libzstd-dev locales-all mysql-client mysql-client-core mysql-common 186s mysql-server mysql-server-core postgresql-17 postgresql-17-mysql-fdw 186s postgresql-client-17 postgresql-client-common postgresql-common 186s postgresql-common-dev ssl-cert zlib1g-dev 186s 0 upgraded, 28 newly installed, 0 to remove and 0 not upgraded. 186s Need to get 92.2 MB of archives. 186s After this operation, 670 MB of additional disk space will be used. 186s Get:1 http://ftpmaster.internal/ubuntu plucky/main s390x mysql-common all 5.8+1.1.1ubuntu1 [6922 B] 186s Get:2 http://ftpmaster.internal/ubuntu plucky/main s390x mysql-client-core s390x 8.4.4-0ubuntu2 [2222 kB] 189s Get:3 http://ftpmaster.internal/ubuntu plucky/main s390x mysql-client s390x 8.4.4-0ubuntu2 [9122 B] 189s Get:4 http://ftpmaster.internal/ubuntu plucky/main s390x libmecab2 s390x 0.996-15.1build2 [214 kB] 189s Get:5 http://ftpmaster.internal/ubuntu plucky/main s390x libprotobuf-lite32t64 s390x 3.21.12-10build2 [238 kB] 189s Get:6 http://ftpmaster.internal/ubuntu plucky/main s390x mysql-server-core s390x 8.4.4-0ubuntu2 [20.1 MB] 213s Get:7 http://ftpmaster.internal/ubuntu plucky/main s390x mysql-server s390x 8.4.4-0ubuntu2 [1369 kB] 215s Get:8 http://ftpmaster.internal/ubuntu plucky/main s390x libjson-perl all 4.10000-1 [81.9 kB] 215s Get:9 http://ftpmaster.internal/ubuntu plucky/main s390x postgresql-client-common all 274 [47.6 kB] 215s Get:10 http://ftpmaster.internal/ubuntu plucky/main s390x libio-pty-perl s390x 1:1.20-1build3 [31.6 kB] 215s Get:11 http://ftpmaster.internal/ubuntu plucky/main s390x libipc-run-perl all 20231003.0-2 [91.5 kB] 215s Get:12 http://ftpmaster.internal/ubuntu plucky/main s390x postgresql-common-dev all 274 [73.0 kB] 215s Get:13 http://ftpmaster.internal/ubuntu plucky/main s390x ssl-cert all 1.1.3ubuntu1 [18.7 kB] 215s Get:14 http://ftpmaster.internal/ubuntu plucky/main s390x postgresql-common all 274 [101 kB] 215s Get:15 http://ftpmaster.internal/ubuntu plucky/main s390x libmysqlclient24 s390x 8.4.4-0ubuntu2 [1295 kB] 217s Get:16 http://ftpmaster.internal/ubuntu plucky/main s390x libssl-dev s390x 3.4.1-1ubuntu1 [2429 kB] 220s Get:17 http://ftpmaster.internal/ubuntu plucky/main s390x libzstd-dev s390x 1.5.6+dfsg-2 [408 kB] 220s Get:18 http://ftpmaster.internal/ubuntu plucky/main s390x zlib1g-dev s390x 1:1.3.dfsg+really1.3.1-1ubuntu1 [898 kB] 221s Get:19 http://ftpmaster.internal/ubuntu plucky/main s390x libmysqlclient-dev s390x 8.4.4-0ubuntu2 [1690 kB] 223s Get:20 http://ftpmaster.internal/ubuntu plucky/main s390x default-libmysqlclient-dev s390x 1.1.1ubuntu1 [3302 B] 223s Get:21 http://ftpmaster.internal/ubuntu plucky/universe s390x default-mysql-server all 1.1.1ubuntu1 [3088 B] 223s Get:22 http://ftpmaster.internal/ubuntu plucky/main s390x libllvm20 s390x 1:20.1.0~+rc2-1~exp2ubuntu0.4 [31.3 MB] 259s Get:23 http://ftpmaster.internal/ubuntu plucky/main s390x libpq5 s390x 17.4-1 [147 kB] 259s Get:24 http://ftpmaster.internal/ubuntu plucky/main s390x libxslt1.1 s390x 1.1.39-0exp1ubuntu2 [169 kB] 259s Get:25 http://ftpmaster.internal/ubuntu plucky-proposed/universe s390x locales-all s390x 2.41-1ubuntu2 [11.5 MB] 272s Get:26 http://ftpmaster.internal/ubuntu plucky/main s390x postgresql-client-17 s390x 17.4-1 [1367 kB] 273s Get:27 http://ftpmaster.internal/ubuntu plucky/main s390x postgresql-17 s390x 17.4-1 [16.3 MB] 291s Get:28 http://ftpmaster.internal/ubuntu plucky/universe s390x postgresql-17-mysql-fdw s390x 2.9.2-2build1 [134 kB] 291s Preconfiguring packages ... 291s Fetched 92.2 MB in 1min 45s (880 kB/s) 291s Selecting previously unselected package mysql-common. 291s (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 ... 56326 files and directories currently installed.) 291s Preparing to unpack .../0-mysql-common_5.8+1.1.1ubuntu1_all.deb ... 291s Unpacking mysql-common (5.8+1.1.1ubuntu1) ... 291s Selecting previously unselected package mysql-client-core. 291s Preparing to unpack .../1-mysql-client-core_8.4.4-0ubuntu2_s390x.deb ... 291s Unpacking mysql-client-core (8.4.4-0ubuntu2) ... 291s Selecting previously unselected package mysql-client. 291s Preparing to unpack .../2-mysql-client_8.4.4-0ubuntu2_s390x.deb ... 291s Unpacking mysql-client (8.4.4-0ubuntu2) ... 291s Selecting previously unselected package libmecab2:s390x. 291s Preparing to unpack .../3-libmecab2_0.996-15.1build2_s390x.deb ... 291s Unpacking libmecab2:s390x (0.996-15.1build2) ... 291s Selecting previously unselected package libprotobuf-lite32t64:s390x. 291s Preparing to unpack .../4-libprotobuf-lite32t64_3.21.12-10build2_s390x.deb ... 291s Unpacking libprotobuf-lite32t64:s390x (3.21.12-10build2) ... 291s Selecting previously unselected package mysql-server-core. 291s Preparing to unpack .../5-mysql-server-core_8.4.4-0ubuntu2_s390x.deb ... 291s Unpacking mysql-server-core (8.4.4-0ubuntu2) ... 292s Setting up mysql-common (5.8+1.1.1ubuntu1) ... 292s update-alternatives: using /etc/mysql/my.cnf.fallback to provide /etc/mysql/my.cnf (my.cnf) in auto mode 292s Selecting previously unselected package mysql-server. 292s (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 ... 56525 files and directories currently installed.) 292s Preparing to unpack .../00-mysql-server_8.4.4-0ubuntu2_s390x.deb ... 292s Unpacking mysql-server (8.4.4-0ubuntu2) ... 292s Selecting previously unselected package libjson-perl. 292s Preparing to unpack .../01-libjson-perl_4.10000-1_all.deb ... 292s Unpacking libjson-perl (4.10000-1) ... 292s Selecting previously unselected package postgresql-client-common. 292s Preparing to unpack .../02-postgresql-client-common_274_all.deb ... 292s Unpacking postgresql-client-common (274) ... 292s Selecting previously unselected package libio-pty-perl. 292s Preparing to unpack .../03-libio-pty-perl_1%3a1.20-1build3_s390x.deb ... 292s Unpacking libio-pty-perl (1:1.20-1build3) ... 292s Selecting previously unselected package libipc-run-perl. 292s Preparing to unpack .../04-libipc-run-perl_20231003.0-2_all.deb ... 292s Unpacking libipc-run-perl (20231003.0-2) ... 292s Selecting previously unselected package postgresql-common-dev. 292s Preparing to unpack .../05-postgresql-common-dev_274_all.deb ... 292s Unpacking postgresql-common-dev (274) ... 292s Selecting previously unselected package ssl-cert. 292s Preparing to unpack .../06-ssl-cert_1.1.3ubuntu1_all.deb ... 292s Unpacking ssl-cert (1.1.3ubuntu1) ... 292s Selecting previously unselected package postgresql-common. 292s Preparing to unpack .../07-postgresql-common_274_all.deb ... 292s Adding 'diversion of /usr/bin/pg_config to /usr/bin/pg_config.libpq-dev by postgresql-common' 292s Unpacking postgresql-common (274) ... 292s Selecting previously unselected package libmysqlclient24:s390x. 292s Preparing to unpack .../08-libmysqlclient24_8.4.4-0ubuntu2_s390x.deb ... 292s Unpacking libmysqlclient24:s390x (8.4.4-0ubuntu2) ... 292s Selecting previously unselected package libssl-dev:s390x. 292s Preparing to unpack .../09-libssl-dev_3.4.1-1ubuntu1_s390x.deb ... 292s Unpacking libssl-dev:s390x (3.4.1-1ubuntu1) ... 292s Selecting previously unselected package libzstd-dev:s390x. 292s Preparing to unpack .../10-libzstd-dev_1.5.6+dfsg-2_s390x.deb ... 292s Unpacking libzstd-dev:s390x (1.5.6+dfsg-2) ... 292s Selecting previously unselected package zlib1g-dev:s390x. 292s Preparing to unpack .../11-zlib1g-dev_1%3a1.3.dfsg+really1.3.1-1ubuntu1_s390x.deb ... 292s Unpacking zlib1g-dev:s390x (1:1.3.dfsg+really1.3.1-1ubuntu1) ... 292s Selecting previously unselected package libmysqlclient-dev. 292s Preparing to unpack .../12-libmysqlclient-dev_8.4.4-0ubuntu2_s390x.deb ... 292s Unpacking libmysqlclient-dev (8.4.4-0ubuntu2) ... 292s Selecting previously unselected package default-libmysqlclient-dev:s390x. 292s Preparing to unpack .../13-default-libmysqlclient-dev_1.1.1ubuntu1_s390x.deb ... 292s Unpacking default-libmysqlclient-dev:s390x (1.1.1ubuntu1) ... 292s Selecting previously unselected package default-mysql-server. 292s Preparing to unpack .../14-default-mysql-server_1.1.1ubuntu1_all.deb ... 292s Unpacking default-mysql-server (1.1.1ubuntu1) ... 292s Selecting previously unselected package libllvm20:s390x. 292s Preparing to unpack .../15-libllvm20_1%3a20.1.0~+rc2-1~exp2ubuntu0.4_s390x.deb ... 292s Unpacking libllvm20:s390x (1:20.1.0~+rc2-1~exp2ubuntu0.4) ... 293s Selecting previously unselected package libpq5:s390x. 293s Preparing to unpack .../16-libpq5_17.4-1_s390x.deb ... 293s Unpacking libpq5:s390x (17.4-1) ... 293s Selecting previously unselected package libxslt1.1:s390x. 293s Preparing to unpack .../17-libxslt1.1_1.1.39-0exp1ubuntu2_s390x.deb ... 293s Unpacking libxslt1.1:s390x (1.1.39-0exp1ubuntu2) ... 293s Selecting previously unselected package locales-all. 293s Preparing to unpack .../18-locales-all_2.41-1ubuntu2_s390x.deb ... 293s Unpacking locales-all (2.41-1ubuntu2) ... 294s Selecting previously unselected package postgresql-client-17. 294s Preparing to unpack .../19-postgresql-client-17_17.4-1_s390x.deb ... 294s Unpacking postgresql-client-17 (17.4-1) ... 294s Selecting previously unselected package postgresql-17. 294s Preparing to unpack .../20-postgresql-17_17.4-1_s390x.deb ... 294s Unpacking postgresql-17 (17.4-1) ... 295s Selecting previously unselected package postgresql-17-mysql-fdw. 295s Preparing to unpack .../21-postgresql-17-mysql-fdw_2.9.2-2build1_s390x.deb ... 295s Unpacking postgresql-17-mysql-fdw (2.9.2-2build1) ... 295s Setting up libprotobuf-lite32t64:s390x (3.21.12-10build2) ... 295s Setting up postgresql-client-common (274) ... 295s Setting up libmecab2:s390x (0.996-15.1build2) ... 295s Setting up libzstd-dev:s390x (1.5.6+dfsg-2) ... 295s Setting up libio-pty-perl (1:1.20-1build3) ... 295s Setting up libpq5:s390x (17.4-1) ... 295s Setting up libmysqlclient24:s390x (8.4.4-0ubuntu2) ... 295s Setting up locales-all (2.41-1ubuntu2) ... 295s Setting up ssl-cert (1.1.3ubuntu1) ... 295s Created symlink '/etc/systemd/system/multi-user.target.wants/ssl-cert.service' → '/usr/lib/systemd/system/ssl-cert.service'. 295s Setting up mysql-server-core (8.4.4-0ubuntu2) ... 295s Setting up libssl-dev:s390x (3.4.1-1ubuntu1) ... 295s Setting up libllvm20:s390x (1:20.1.0~+rc2-1~exp2ubuntu0.4) ... 295s Setting up libipc-run-perl (20231003.0-2) ... 295s Setting up zlib1g-dev:s390x (1:1.3.dfsg+really1.3.1-1ubuntu1) ... 295s Setting up mysql-client-core (8.4.4-0ubuntu2) ... 295s Setting up libjson-perl (4.10000-1) ... 295s Setting up libxslt1.1:s390x (1.1.39-0exp1ubuntu2) ... 295s Setting up libmysqlclient-dev (8.4.4-0ubuntu2) ... 295s Setting up postgresql-common-dev (274) ... 295s Setting up default-libmysqlclient-dev:s390x (1.1.1ubuntu1) ... 295s Setting up mysql-client (8.4.4-0ubuntu2) ... 295s Setting up postgresql-client-17 (17.4-1) ... 296s 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 296s Setting up postgresql-common (274) ... 296s Creating config file /etc/postgresql-common/createcluster.conf with new version 296s Building PostgreSQL dictionaries from installed myspell/hunspell packages... 296s Removing obsolete dictionary files: 296s Created symlink '/etc/systemd/system/multi-user.target.wants/postgresql.service' → '/usr/lib/systemd/system/postgresql.service'. 297s Setting up mysql-server (8.4.4-0ubuntu2) ... 297s update-alternatives: using /etc/mysql/mysql.cnf to provide /etc/mysql/my.cnf (my.cnf) in auto mode 297s Renaming removed key_buffer and myisam-recover options (if present) 302s Created symlink '/etc/systemd/system/multi-user.target.wants/mysql.service' → '/usr/lib/systemd/system/mysql.service'. 303s Setting up postgresql-17 (17.4-1) ... 303s Creating new PostgreSQL cluster 17/main ... 303s /usr/lib/postgresql/17/bin/initdb -D /var/lib/postgresql/17/main --auth-local peer --auth-host scram-sha-256 --no-instructions 303s The files belonging to this database system will be owned by user "postgres". 303s This user must also own the server process. 303s 303s The database cluster will be initialized with locale "C.UTF-8". 303s The default database encoding has accordingly been set to "UTF8". 303s The default text search configuration will be set to "english". 303s 303s Data page checksums are disabled. 303s 303s fixing permissions on existing directory /var/lib/postgresql/17/main ... ok 303s creating subdirectories ... ok 304s selecting dynamic shared memory implementation ... posix 304s selecting default "max_connections" ... 100 304s selecting default "shared_buffers" ... 128MB 304s selecting default time zone ... Etc/UTC 304s creating configuration files ... ok 304s running bootstrap script ... ok 304s performing post-bootstrap initialization ... ok 304s syncing data to disk ... ok 307s Setting up postgresql-17-mysql-fdw (2.9.2-2build1) ... 307s Setting up default-mysql-server (1.1.1ubuntu1) ... 307s Processing triggers for libc-bin (2.41-1ubuntu2) ... 307s Processing triggers for man-db (2.13.0-1) ... 309s autopkgtest [16:53:07]: test installcheck: [----------------------- 309s + service mariadb start 309s Failed to start mariadb.service: Unit mariadb.service not found. 309s + service mysql start 310s mode of '/var/run/mysqld' retained as 0755 (rwxr-xr-x) 310s == creating the MySQL test database 310s + test -d /var/run/mysqld 310s + chmod -v 755 /var/run/mysqld 310s + echo == creating the MySQL test database 310s + cat debian/tests/mysql.testschema.sql 310s + mysql --defaults-file=/etc/mysql/debian.cnf -v mysql 310s -------------- 310s CREATE DATABASE mysql_fdw_regress 310s -------------- 310s 310s -------------- 310s CREATE DATABASE mysql_fdw_regress1 310s -------------- 310s 310s -------------- 310s CREATE USER 'edb'@'localhost' IDENTIFIED BY 'edb' 310s -------------- 310s 310s -------------- 310s GRANT ALL PRIVILEGES ON mysql_fdw_regress.* TO 'edb'@'localhost' 310s -------------- 310s 310s -------------- 310s GRANT ALL PRIVILEGES ON mysql_fdw_regress1.* TO 'edb'@'localhost' 310s -------------- 310s 310s + ./mysql_init.sh 310s + pg_buildext installed-versions 310s + NO_JIT=-o jit=off 310s + PG_VIRTUALENV_UNSHARE= MYSQL_USER_NAME=edb MYSQL_PWD=edb pg_buildext -o jit=off installcheck-17 310s ### PostgreSQL 17 installcheck ### 310s Creating new PostgreSQL cluster 17/regress ... 313s 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 server_options connection_validation dml select pushdown join_pushdown aggregate_pushdown limit_offset_pushdown misc 313s # +++ regress install-check in +++ 313s # using postmaster on localhost, port 5433 313s ok 1 - server_options 81 ms 313s not ok 2 - connection_validation 52 ms 313s ok 3 - dml 104 ms 313s ok 4 - select 464 ms 314s ok 5 - pushdown 111 ms 314s ok 6 - join_pushdown 149 ms 314s ok 7 - aggregate_pushdown 106 ms 314s ok 8 - limit_offset_pushdown 59 ms 314s ok 9 - misc 138 ms 314s 1..9 314s # 1 of 9 tests failed. 314s # The differences that caused some tests to fail can be viewed in the file "/tmp/autopkgtest.RLxUpe/build.IvT/src/regression.diffs". 314s # A copy of the test summary that you see above is saved in the file "/tmp/autopkgtest.RLxUpe/build.IvT/src/regression.out". 314s make: *** [/usr/lib/postgresql/17/lib/pgxs/src/makefiles/pgxs.mk:436: installcheck] Error 1 314s *** /tmp/pg_virtualenv.mMtWML/log/postgresql-17-regress.log (last 100 lines) *** 314s 2025-03-15 16:53:11.463 UTC [4115] postgres@contrib_regression STATEMENT: INSERT INTO f_mysql_test VALUES(1,1) ON CONFLICT (a) DO UPDATE SET b = 10; 314s WARNING: MYSQL_OPT_RECONNECT is deprecated and will be removed in a future version. 314s 2025-03-15 16:53:11.590 UTC [4128] postgres@contrib_regression ERROR: invalid reference to FROM-clause entry for table "t1" at character 88 314s 2025-03-15 16:53:11.590 UTC [4128] postgres@contrib_regression DETAIL: The combining JOIN type must be INNER or LEFT for a LATERAL reference. 314s 2025-03-15 16:53:11.590 UTC [4128] postgres@contrib_regression STATEMENT: SELECT t1.c1, t3.c1, t3.t1_c8 FROM f_test_tbl1 t1 RIGHT JOIN LATERAL ( 314s SELECT t2.c1, t1.c8 AS t1_c8 FROM f_test_tbl2 t2) t3 ON t3.c1 = t3.t1_c8 314s ORDER BY 1, 2, 3; 314s WARNING: MYSQL_OPT_RECONNECT is deprecated and will be removed in a future version. 314s WARNING: MYSQL_OPT_RECONNECT is deprecated and will be removed in a future version. 314s 2025-03-15 16:53:11.611 UTC [4128] postgres@contrib_regression ERROR: invalid input value for enum size_t: "big" at character 34 314s 2025-03-15 16:53:11.611 UTC [4128] postgres@contrib_regression STATEMENT: INSERT INTO f_enum_t1 VALUES (4, 'big'); 314s WARNING: MYSQL_OPT_RECONNECT is deprecated and will be removed in a future version. 314s WARNING: MYSQL_OPT_RECONNECT is deprecated and will be removed in a future version. 314s WARNING: MYSQL_OPT_RECONNECT is deprecated and will be removed in a future version. 314s WARNING: MYSQL_OPT_RECONNECT is deprecated and will be removed in a future version. 314s WARNING: MYSQL_OPT_RECONNECT is deprecated and will be removed in a future version. 314s WARNING: MYSQL_OPT_RECONNECT is deprecated and will be removed in a future version. 314s WARNING: MYSQL_OPT_RECONNECT is deprecated and will be removed in a future version. 314s 2025-03-15 16:53:11.635 UTC [4128] postgres@contrib_regression ERROR: system attribute "xmin" can't be fetched from remote relation 314s 2025-03-15 16:53:11.635 UTC [4128] postgres@contrib_regression STATEMENT: SELECT xmin FROM f_test_tbl1; 314s 2025-03-15 16:53:11.635 UTC [4128] postgres@contrib_regression ERROR: system attribute "ctid" can't be fetched from remote relation 314s 2025-03-15 16:53:11.635 UTC [4128] postgres@contrib_regression STATEMENT: SELECT ctid, xmax, tableoid FROM f_test_tbl1; 314s 2025-03-15 16:53:11.635 UTC [4128] postgres@contrib_regression ERROR: system attribute "xmax" can't be fetched from remote relation 314s 2025-03-15 16:53:11.635 UTC [4128] postgres@contrib_regression STATEMENT: SELECT xmax, c1 FROM f_test_tbl1; 314s 2025-03-15 16:53:11.635 UTC [4128] postgres@contrib_regression ERROR: system attribute "tableoid" can't be fetched from remote relation 314s 2025-03-15 16:53:11.635 UTC [4128] postgres@contrib_regression STATEMENT: SELECT count(tableoid) FROM f_test_tbl1; 314s WARNING: MYSQL_OPT_RECONNECT is deprecated and will be removed in a future version. 314s WARNING: MYSQL_OPT_RECONNECT is deprecated and will be removed in a future version. 314s WARNING: MYSQL_OPT_RECONNECT is deprecated and will be removed in a future version. 314s 2025-03-15 16:53:11.869 UTC [4128] postgres@contrib_regression WARNING: skipping import for relation "test_set" 314s 2025-03-15 16:53:11.869 UTC [4128] postgres@contrib_regression DETAIL: MySQL SET columns are not supported. 314s WARNING: MYSQL_OPT_RECONNECT is deprecated and will be removed in a future version. 314s 2025-03-15 16:53:11.871 UTC [4128] postgres@contrib_regression ERROR: failed to execute the MySQL query: 314s Column 'b' cannot be null 314s 2025-03-15 16:53:11.871 UTC [4128] postgres@contrib_regression STATEMENT: UPDATE f_mysql_test SET b = NULL WHERE a = 1; 314s WARNING: MYSQL_OPT_RECONNECT is deprecated and will be removed in a future version. 314s WARNING: MYSQL_OPT_RECONNECT is deprecated and will be removed in a future version. 314s 2025-03-15 16:53:11.877 UTC [4128] postgres@contrib_regression ERROR: failed to execute the MySQL query: 314s Variable 'sql_mode' can't be set to the value of 'ABCD' 314s 2025-03-15 16:53:11.877 UTC [4128] postgres@contrib_regression STATEMENT: SELECT * FROM f_mysql_test ORDER BY 1; 314s WARNING: MYSQL_OPT_RECONNECT is deprecated and will be removed in a future version. 314s 2025-03-15 16:53:11.880 UTC [4128] postgres@contrib_regression ERROR: numeric field overflow 314s 2025-03-15 16:53:11.880 UTC [4128] postgres@contrib_regression DETAIL: A field with precision 3, scale 2 must round to an absolute value less than 10^1. 314s 2025-03-15 16:53:11.880 UTC [4128] postgres@contrib_regression STATEMENT: SELECT * FROM f_test6 ORDER BY 1; 314s WARNING: MYSQL_OPT_RECONNECT is deprecated and will be removed in a future version. 314s WARNING: MYSQL_OPT_RECONNECT is deprecated and will be removed in a future version. 314s WARNING: MYSQL_OPT_RECONNECT is deprecated and will be removed in a future version. 314s WARNING: MYSQL_OPT_RECONNECT is deprecated and will be removed in a future version. 314s WARNING: MYSQL_OPT_RECONNECT is deprecated and will be removed in a future version. 314s WARNING: MYSQL_OPT_RECONNECT is deprecated and will be removed in a future version. 314s WARNING: MYSQL_OPT_RECONNECT is deprecated and will be removed in a future version. 314s WARNING: MYSQL_OPT_RECONNECT is deprecated and will be removed in a future version. 314s WARNING: MYSQL_OPT_RECONNECT is deprecated and will be removed in a future version. 314s 2025-03-15 16:53:12.428 UTC [4191] postgres@contrib_regression ERROR: truncatable requires a Boolean value 314s 2025-03-15 16:53:12.428 UTC [4191] postgres@contrib_regression STATEMENT: ALTER SERVER mysql_svr OPTIONS (ADD truncatable 'abc'); 314s 2025-03-15 16:53:12.428 UTC [4191] postgres@contrib_regression ERROR: truncatable requires a Boolean value 314s 2025-03-15 16:53:12.428 UTC [4191] postgres@contrib_regression STATEMENT: ALTER FOREIGN TABLE fdw519_ft1 OPTIONS (ADD truncatable 'abc'); 314s 2025-03-15 16:53:12.439 UTC [4191] postgres@contrib_regression ERROR: foreign table "fdw519_ft1" does not allow truncates 314s 2025-03-15 16:53:12.439 UTC [4191] postgres@contrib_regression STATEMENT: TRUNCATE fdw519_ft1; 314s WARNING: MYSQL_OPT_RECONNECT is deprecated and will be removed in a future version. 314s WARNING: MYSQL_OPT_RECONNECT is deprecated and will be removed in a future version. 314s WARNING: MYSQL_OPT_RECONNECT is deprecated and will be removed in a future version. 314s 2025-03-15 16:53:12.460 UTC [4191] postgres@contrib_regression ERROR: foreign table "fdw519_ft1" does not allow truncates 314s 2025-03-15 16:53:12.460 UTC [4191] postgres@contrib_regression STATEMENT: TRUNCATE fdw519_ft1, fdw519_ft2; 314s WARNING: MYSQL_OPT_RECONNECT is deprecated and will be removed in a future version. 314s 2025-03-15 16:53:12.461 UTC [4191] postgres@contrib_regression ERROR: foreign table "fdw519_ft1" does not allow truncates 314s 2025-03-15 16:53:12.461 UTC [4191] postgres@contrib_regression STATEMENT: TRUNCATE fdw519_ft1, fdw519_ft2; 314s WARNING: MYSQL_OPT_RECONNECT is deprecated and will be removed in a future version. 314s WARNING: MYSQL_OPT_RECONNECT is deprecated and will be removed in a future version. 314s WARNING: MYSQL_OPT_RECONNECT is deprecated and will be removed in a future version. 314s 2025-03-15 16:53:12.486 UTC [4191] postgres@contrib_regression ERROR: CASCADE option in TRUNCATE is not supported by this FDW 314s 2025-03-15 16:53:12.486 UTC [4191] postgres@contrib_regression STATEMENT: TRUNCATE fdw519_ft1 CASCADE; 314s 2025-03-15 16:53:12.494 UTC [4191] postgres@contrib_regression ERROR: failed to execute the MySQL query: 314s Cannot truncate a table referenced in a foreign key constraint (`mysql_fdw_regress1`.`dept`, CONSTRAINT `dept_ibfk_1`) 314s 2025-03-15 16:53:12.494 UTC [4191] postgres@contrib_regression STATEMENT: TRUNCATE fdw519_ft4; 314s WARNING: MYSQL_OPT_RECONNECT is deprecated and will be removed in a future version. 314s 2025-03-15 16:53:12.501 UTC [4191] postgres@contrib_regression ERROR: cannot use generated column "c3" in column generation expression at character 140 314s 2025-03-15 16:53:12.501 UTC [4191] postgres@contrib_regression DETAIL: A generated column cannot reference another generated column. 314s 2025-03-15 16:53:12.501 UTC [4191] postgres@contrib_regression QUERY: CREATE FOREIGN TABLE fdw520_1 ( 314s c1 int NOT NULL, 314s c2 int, 314s c3 int GENERATED ALWAYS AS ("c2" * 2) STORED, 314s c4 int GENERATED ALWAYS AS ("c3" * 4) STORED NOT NULL 314s ) SERVER mysql_svr OPTIONS (dbname 'mysql_fdw_regress', table_name 'fdw520_1'); 314s 314s 2025-03-15 16:53:12.501 UTC [4191] postgres@contrib_regression CONTEXT: importing foreign table "fdw520_1" 314s 2025-03-15 16:53:12.501 UTC [4191] postgres@contrib_regression STATEMENT: IMPORT FOREIGN SCHEMA mysql_fdw_regress LIMIT TO (fdw520_1) 314s FROM SERVER mysql_svr INTO public OPTIONS (import_generated 'true'); 314s WARNING: MYSQL_OPT_RECONNECT is deprecated and will be removed in a future version. 314s WARNING: MYSQL_OPT_RECONNECT is deprecated and will be removed in a future version. 314s WARNING: MYSQL_OPT_RECONNECT is deprecated and will be removed in a future version. 314s 2025-03-15 16:53:12.512 UTC [4191] postgres@contrib_regression ERROR: cannot insert a non-DEFAULT value into column "c3" 314s 2025-03-15 16:53:12.512 UTC [4191] postgres@contrib_regression DETAIL: Column "c3" is a generated column. 314s 2025-03-15 16:53:12.512 UTC [4191] postgres@contrib_regression STATEMENT: INSERT INTO fdw520 VALUES(1, 2, 3, 4); 314s 2025-03-15 16:53:12.514 UTC [4191] postgres@contrib_regression ERROR: column "c4" can only be updated to DEFAULT 314s 2025-03-15 16:53:12.514 UTC [4191] postgres@contrib_regression DETAIL: Column "c4" is a generated column. 314s 2025-03-15 16:53:12.514 UTC [4191] postgres@contrib_regression STATEMENT: UPDATE fdw520 SET c4 = 20 WHERE c1 = 2; 314s 2025-03-15 16:53:12.514 UTC [4191] postgres@contrib_regression ERROR: column "c3" can only be updated to DEFAULT 314s 2025-03-15 16:53:12.514 UTC [4191] postgres@contrib_regression DETAIL: Column "c3" is a generated column. 314s 2025-03-15 16:53:12.514 UTC [4191] postgres@contrib_regression STATEMENT: UPDATE fdw520 SET c3 = 20 WHERE c1 = 2; 314s Dropping cluster 17/regress ... 314s **** regression.diffs **** 314s diff -U3 /tmp/autopkgtest.RLxUpe/build.IvT/src/expected/connection_validation.out /tmp/autopkgtest.RLxUpe/build.IvT/src/results/connection_validation.out 314s --- /tmp/autopkgtest.RLxUpe/build.IvT/src/expected/connection_validation.out 2024-07-11 05:24:25.000000000 +0000 314s +++ /tmp/autopkgtest.RLxUpe/build.IvT/src/results/connection_validation.out 2025-03-15 16:53:11.374291096 +0000 314s @@ -118,11 +118,7 @@ 314s \! echo secure_auth=true >> /tmp/my.cnf 314s -- Connection should happen as default file exists with details. 314s SELECT * FROM f_mysql_file_test ORDER BY 1, 2; 314s - a | b 314s ----+--- 314s - 1 | 1 314s -(1 row) 314s - 314s +ERROR: failed to connect to MySQL: Unknown MySQL server host '' (-5) 314s -- Cleanup 314s DROP FOREIGN TABLE f_mysql_test; 314s DROP FOREIGN TABLE f_mysql_file_test; 314s ### End 17 installcheck (FAILED with exit code 1) ### 314s == dropping the MySQL test database 314s -------------- 314s DROP USER 'edb'@'localhost' 314s -------------- 314s 314s -------------- 314s DROP DATABASE mysql_fdw_regress 314s -------------- 314s 314s -------------- 314s DROP DATABASE mysql_fdw_regress1 314s -------------- 314s 315s Failed to stop mariadb.service: Unit mariadb.service not loaded. 317s autopkgtest [16:53:15]: test installcheck: -----------------------] 317s autopkgtest [16:53:15]: test installcheck: - - - - - - - - - - results - - - - - - - - - - 317s installcheck FLAKY non-zero exit status 1 318s autopkgtest [16:53:16]: test create-extension: preparing testbed 494s autopkgtest [16:56:12]: testbed dpkg architecture: s390x 494s autopkgtest [16:56:12]: testbed apt version: 2.9.33 495s autopkgtest [16:56:13]: @@@@@@@@@@@@@@@@@@@@ test bed setup 495s autopkgtest [16:56:13]: testbed release detected to be: plucky 496s autopkgtest [16:56:14]: updating testbed package index (apt update) 496s Get:1 http://ftpmaster.internal/ubuntu plucky-proposed InRelease [126 kB] 496s Hit:2 http://ftpmaster.internal/ubuntu plucky InRelease 496s Hit:3 http://ftpmaster.internal/ubuntu plucky-updates InRelease 497s Hit:4 http://ftpmaster.internal/ubuntu plucky-security InRelease 497s Get:5 http://ftpmaster.internal/ubuntu plucky-proposed/multiverse Sources [15.8 kB] 497s Get:6 http://ftpmaster.internal/ubuntu plucky-proposed/main Sources [99.7 kB] 497s Get:7 http://ftpmaster.internal/ubuntu plucky-proposed/universe Sources [379 kB] 497s Get:8 http://ftpmaster.internal/ubuntu plucky-proposed/main s390x Packages [113 kB] 498s Get:9 http://ftpmaster.internal/ubuntu plucky-proposed/main s390x c-n-f Metadata [1824 B] 498s Get:10 http://ftpmaster.internal/ubuntu plucky-proposed/restricted s390x c-n-f Metadata [116 B] 498s Get:11 http://ftpmaster.internal/ubuntu plucky-proposed/universe s390x Packages [320 kB] 498s Get:12 http://ftpmaster.internal/ubuntu plucky-proposed/universe s390x c-n-f Metadata [13.4 kB] 498s Get:13 http://ftpmaster.internal/ubuntu plucky-proposed/multiverse s390x Packages [3776 B] 498s Get:14 http://ftpmaster.internal/ubuntu plucky-proposed/multiverse s390x c-n-f Metadata [240 B] 499s Fetched 1073 kB in 3s (403 kB/s) 499s Reading package lists... 500s Reading package lists... 500s Building dependency tree... 500s Reading state information... 500s Calculating upgrade... 500s Calculating upgrade... 500s The following packages were automatically installed and are no longer required: 500s libnsl2 libpython3.12-minimal libpython3.12-stdlib libpython3.12t64 500s linux-headers-6.11.0-8 linux-headers-6.11.0-8-generic 500s linux-modules-6.11.0-8-generic linux-tools-6.11.0-8 500s linux-tools-6.11.0-8-generic 500s Use 'sudo apt autoremove' to remove them. 500s The following packages will be upgraded: 500s pinentry-curses python3-jinja2 strace 500s 3 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 500s Need to get 652 kB of archives. 500s After this operation, 27.6 kB of additional disk space will be used. 500s Get:1 http://ftpmaster.internal/ubuntu plucky/main s390x strace s390x 6.13+ds-1ubuntu1 [500 kB] 501s Get:2 http://ftpmaster.internal/ubuntu plucky/main s390x pinentry-curses s390x 1.3.1-2ubuntu3 [42.9 kB] 501s Get:3 http://ftpmaster.internal/ubuntu plucky/main s390x python3-jinja2 all 3.1.5-2ubuntu1 [109 kB] 502s Fetched 652 kB in 1s (649 kB/s) 502s (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 ... 81428 files and directories currently installed.) 502s Preparing to unpack .../strace_6.13+ds-1ubuntu1_s390x.deb ... 502s Unpacking strace (6.13+ds-1ubuntu1) over (6.11-0ubuntu1) ... 502s Preparing to unpack .../pinentry-curses_1.3.1-2ubuntu3_s390x.deb ... 502s Unpacking pinentry-curses (1.3.1-2ubuntu3) over (1.3.1-2ubuntu2) ... 502s Preparing to unpack .../python3-jinja2_3.1.5-2ubuntu1_all.deb ... 502s Unpacking python3-jinja2 (3.1.5-2ubuntu1) over (3.1.5-2) ... 502s Setting up pinentry-curses (1.3.1-2ubuntu3) ... 502s Setting up python3-jinja2 (3.1.5-2ubuntu1) ... 502s Setting up strace (6.13+ds-1ubuntu1) ... 502s Processing triggers for man-db (2.13.0-1) ... 502s Reading package lists... 503s Building dependency tree... 503s Reading state information... 503s Solving dependencies... 503s The following packages will be REMOVED: 503s libnsl2* libpython3.12-minimal* libpython3.12-stdlib* libpython3.12t64* 503s linux-headers-6.11.0-8* linux-headers-6.11.0-8-generic* 503s linux-modules-6.11.0-8-generic* linux-tools-6.11.0-8* 503s linux-tools-6.11.0-8-generic* 503s 0 upgraded, 0 newly installed, 9 to remove and 5 not upgraded. 503s After this operation, 167 MB disk space will be freed. 503s (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 ... 81428 files and directories currently installed.) 503s Removing linux-tools-6.11.0-8-generic (6.11.0-8.8) ... 503s Removing linux-tools-6.11.0-8 (6.11.0-8.8) ... 503s Removing libpython3.12t64:s390x (3.12.9-1) ... 503s Removing libpython3.12-stdlib:s390x (3.12.9-1) ... 503s Removing libnsl2:s390x (1.3.0-3build3) ... 503s Removing libpython3.12-minimal:s390x (3.12.9-1) ... 503s Removing linux-headers-6.11.0-8-generic (6.11.0-8.8) ... 503s Removing linux-headers-6.11.0-8 (6.11.0-8.8) ... 504s Removing linux-modules-6.11.0-8-generic (6.11.0-8.8) ... 504s Processing triggers for libc-bin (2.41-1ubuntu1) ... 504s (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 ... 56328 files and directories currently installed.) 504s Purging configuration files for libpython3.12-minimal:s390x (3.12.9-1) ... 504s Purging configuration files for linux-modules-6.11.0-8-generic (6.11.0-8.8) ... 504s autopkgtest [16:56:22]: upgrading testbed (apt dist-upgrade and autopurge) 505s Reading package lists... 505s Building dependency tree... 505s Reading state information... 505s Calculating upgrade...Starting pkgProblemResolver with broken count: 0 505s Starting 2 pkgProblemResolver with broken count: 0 505s Done 505s Entering ResolveByKeep 505s 505s Calculating upgrade... 506s The following packages will be upgraded: 506s libc-bin libc-dev-bin libc6 libc6-dev locales 506s 5 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 506s Need to get 9512 kB of archives. 506s After this operation, 8192 B of additional disk space will be used. 506s Get:1 http://ftpmaster.internal/ubuntu plucky-proposed/main s390x libc6-dev s390x 2.41-1ubuntu2 [1678 kB] 508s Get:2 http://ftpmaster.internal/ubuntu plucky-proposed/main s390x libc-dev-bin s390x 2.41-1ubuntu2 [24.3 kB] 508s Get:3 http://ftpmaster.internal/ubuntu plucky-proposed/main s390x libc6 s390x 2.41-1ubuntu2 [2892 kB] 511s Get:4 http://ftpmaster.internal/ubuntu plucky-proposed/main s390x libc-bin s390x 2.41-1ubuntu2 [671 kB] 511s Get:5 http://ftpmaster.internal/ubuntu plucky-proposed/main s390x locales all 2.41-1ubuntu2 [4246 kB] 516s Preconfiguring packages ... 517s Fetched 9512 kB in 11s (891 kB/s) 517s (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 ... 56326 files and directories currently installed.) 517s Preparing to unpack .../libc6-dev_2.41-1ubuntu2_s390x.deb ... 517s Unpacking libc6-dev:s390x (2.41-1ubuntu2) over (2.41-1ubuntu1) ... 517s Preparing to unpack .../libc-dev-bin_2.41-1ubuntu2_s390x.deb ... 517s Unpacking libc-dev-bin (2.41-1ubuntu2) over (2.41-1ubuntu1) ... 517s Preparing to unpack .../libc6_2.41-1ubuntu2_s390x.deb ... 517s Unpacking libc6:s390x (2.41-1ubuntu2) over (2.41-1ubuntu1) ... 517s Setting up libc6:s390x (2.41-1ubuntu2) ... 517s (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 ... 56326 files and directories currently installed.) 517s Preparing to unpack .../libc-bin_2.41-1ubuntu2_s390x.deb ... 517s Unpacking libc-bin (2.41-1ubuntu2) over (2.41-1ubuntu1) ... 517s Setting up libc-bin (2.41-1ubuntu2) ... 517s (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 ... 56326 files and directories currently installed.) 517s Preparing to unpack .../locales_2.41-1ubuntu2_all.deb ... 517s Unpacking locales (2.41-1ubuntu2) over (2.41-1ubuntu1) ... 517s Setting up locales (2.41-1ubuntu2) ... 517s Generating locales (this might take a while)... 518s en_US.UTF-8... done 518s Generation complete. 518s Setting up libc-dev-bin (2.41-1ubuntu2) ... 518s Setting up libc6-dev:s390x (2.41-1ubuntu2) ... 518s Processing triggers for man-db (2.13.0-1) ... 519s Processing triggers for systemd (257.3-1ubuntu3) ... 520s Reading package lists... 520s Building dependency tree... 520s Reading state information... 520s Starting pkgProblemResolver with broken count: 0 520s Starting 2 pkgProblemResolver with broken count: 0 520s Done 520s Solving dependencies... 521s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 521s autopkgtest [16:56:39]: rebooting testbed after setup commands that affected boot 542s Reading package lists... 542s Building dependency tree... 542s Reading state information... 542s Starting pkgProblemResolver with broken count: 0 542s Starting 2 pkgProblemResolver with broken count: 0 542s Done 542s The following NEW packages will be installed: 542s default-libmysqlclient-dev libio-pty-perl libipc-run-perl libjson-perl 542s libllvm20 libmysqlclient-dev libmysqlclient24 libpq5 libssl-dev libxslt1.1 542s libzstd-dev mysql-common postgresql-17 postgresql-17-mysql-fdw 542s postgresql-client-17 postgresql-client-common postgresql-common 542s postgresql-common-dev ssl-cert zlib1g-dev 543s 0 upgraded, 20 newly installed, 0 to remove and 0 not upgraded. 543s Need to get 56.6 MB of archives. 543s After this operation, 246 MB of additional disk space will be used. 543s Get:1 http://ftpmaster.internal/ubuntu plucky/main s390x libjson-perl all 4.10000-1 [81.9 kB] 543s Get:2 http://ftpmaster.internal/ubuntu plucky/main s390x postgresql-client-common all 274 [47.6 kB] 543s Get:3 http://ftpmaster.internal/ubuntu plucky/main s390x libio-pty-perl s390x 1:1.20-1build3 [31.6 kB] 543s Get:4 http://ftpmaster.internal/ubuntu plucky/main s390x libipc-run-perl all 20231003.0-2 [91.5 kB] 543s Get:5 http://ftpmaster.internal/ubuntu plucky/main s390x postgresql-common-dev all 274 [73.0 kB] 543s Get:6 http://ftpmaster.internal/ubuntu plucky/main s390x ssl-cert all 1.1.3ubuntu1 [18.7 kB] 543s Get:7 http://ftpmaster.internal/ubuntu plucky/main s390x postgresql-common all 274 [101 kB] 543s Get:8 http://ftpmaster.internal/ubuntu plucky/main s390x mysql-common all 5.8+1.1.1ubuntu1 [6922 B] 543s Get:9 http://ftpmaster.internal/ubuntu plucky/main s390x libmysqlclient24 s390x 8.4.4-0ubuntu2 [1295 kB] 545s Get:10 http://ftpmaster.internal/ubuntu plucky/main s390x libssl-dev s390x 3.4.1-1ubuntu1 [2429 kB] 548s Get:11 http://ftpmaster.internal/ubuntu plucky/main s390x libzstd-dev s390x 1.5.6+dfsg-2 [408 kB] 548s Get:12 http://ftpmaster.internal/ubuntu plucky/main s390x zlib1g-dev s390x 1:1.3.dfsg+really1.3.1-1ubuntu1 [898 kB] 549s Get:13 http://ftpmaster.internal/ubuntu plucky/main s390x libmysqlclient-dev s390x 8.4.4-0ubuntu2 [1690 kB] 551s Get:14 http://ftpmaster.internal/ubuntu plucky/main s390x default-libmysqlclient-dev s390x 1.1.1ubuntu1 [3302 B] 551s Get:15 http://ftpmaster.internal/ubuntu plucky/main s390x libllvm20 s390x 1:20.1.0~+rc2-1~exp2ubuntu0.4 [31.3 MB] 584s Get:16 http://ftpmaster.internal/ubuntu plucky/main s390x libpq5 s390x 17.4-1 [147 kB] 584s Get:17 http://ftpmaster.internal/ubuntu plucky/main s390x libxslt1.1 s390x 1.1.39-0exp1ubuntu2 [169 kB] 584s Get:18 http://ftpmaster.internal/ubuntu plucky/main s390x postgresql-client-17 s390x 17.4-1 [1367 kB] 586s Get:19 http://ftpmaster.internal/ubuntu plucky/main s390x postgresql-17 s390x 17.4-1 [16.3 MB] 605s Get:20 http://ftpmaster.internal/ubuntu plucky/universe s390x postgresql-17-mysql-fdw s390x 2.9.2-2build1 [134 kB] 605s Preconfiguring packages ... 605s Fetched 56.6 MB in 1min 2s (908 kB/s) 605s Selecting previously unselected package libjson-perl. 605s (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 ... 56326 files and directories currently installed.) 605s Preparing to unpack .../00-libjson-perl_4.10000-1_all.deb ... 605s Unpacking libjson-perl (4.10000-1) ... 605s Selecting previously unselected package postgresql-client-common. 605s Preparing to unpack .../01-postgresql-client-common_274_all.deb ... 605s Unpacking postgresql-client-common (274) ... 605s Selecting previously unselected package libio-pty-perl. 605s Preparing to unpack .../02-libio-pty-perl_1%3a1.20-1build3_s390x.deb ... 605s Unpacking libio-pty-perl (1:1.20-1build3) ... 605s Selecting previously unselected package libipc-run-perl. 605s Preparing to unpack .../03-libipc-run-perl_20231003.0-2_all.deb ... 605s Unpacking libipc-run-perl (20231003.0-2) ... 605s Selecting previously unselected package postgresql-common-dev. 605s Preparing to unpack .../04-postgresql-common-dev_274_all.deb ... 605s Unpacking postgresql-common-dev (274) ... 605s Selecting previously unselected package ssl-cert. 605s Preparing to unpack .../05-ssl-cert_1.1.3ubuntu1_all.deb ... 605s Unpacking ssl-cert (1.1.3ubuntu1) ... 605s Selecting previously unselected package postgresql-common. 605s Preparing to unpack .../06-postgresql-common_274_all.deb ... 605s Adding 'diversion of /usr/bin/pg_config to /usr/bin/pg_config.libpq-dev by postgresql-common' 605s Unpacking postgresql-common (274) ... 605s Selecting previously unselected package mysql-common. 605s Preparing to unpack .../07-mysql-common_5.8+1.1.1ubuntu1_all.deb ... 605s Unpacking mysql-common (5.8+1.1.1ubuntu1) ... 605s Selecting previously unselected package libmysqlclient24:s390x. 605s Preparing to unpack .../08-libmysqlclient24_8.4.4-0ubuntu2_s390x.deb ... 605s Unpacking libmysqlclient24:s390x (8.4.4-0ubuntu2) ... 605s Selecting previously unselected package libssl-dev:s390x. 605s Preparing to unpack .../09-libssl-dev_3.4.1-1ubuntu1_s390x.deb ... 605s Unpacking libssl-dev:s390x (3.4.1-1ubuntu1) ... 605s Selecting previously unselected package libzstd-dev:s390x. 605s Preparing to unpack .../10-libzstd-dev_1.5.6+dfsg-2_s390x.deb ... 605s Unpacking libzstd-dev:s390x (1.5.6+dfsg-2) ... 605s Selecting previously unselected package zlib1g-dev:s390x. 605s Preparing to unpack .../11-zlib1g-dev_1%3a1.3.dfsg+really1.3.1-1ubuntu1_s390x.deb ... 605s Unpacking zlib1g-dev:s390x (1:1.3.dfsg+really1.3.1-1ubuntu1) ... 605s Selecting previously unselected package libmysqlclient-dev. 605s Preparing to unpack .../12-libmysqlclient-dev_8.4.4-0ubuntu2_s390x.deb ... 605s Unpacking libmysqlclient-dev (8.4.4-0ubuntu2) ... 605s Selecting previously unselected package default-libmysqlclient-dev:s390x. 605s Preparing to unpack .../13-default-libmysqlclient-dev_1.1.1ubuntu1_s390x.deb ... 605s Unpacking default-libmysqlclient-dev:s390x (1.1.1ubuntu1) ... 605s Selecting previously unselected package libllvm20:s390x. 605s Preparing to unpack .../14-libllvm20_1%3a20.1.0~+rc2-1~exp2ubuntu0.4_s390x.deb ... 605s Unpacking libllvm20:s390x (1:20.1.0~+rc2-1~exp2ubuntu0.4) ... 606s Selecting previously unselected package libpq5:s390x. 606s Preparing to unpack .../15-libpq5_17.4-1_s390x.deb ... 606s Unpacking libpq5:s390x (17.4-1) ... 606s Selecting previously unselected package libxslt1.1:s390x. 606s Preparing to unpack .../16-libxslt1.1_1.1.39-0exp1ubuntu2_s390x.deb ... 606s Unpacking libxslt1.1:s390x (1.1.39-0exp1ubuntu2) ... 606s Selecting previously unselected package postgresql-client-17. 606s Preparing to unpack .../17-postgresql-client-17_17.4-1_s390x.deb ... 606s Unpacking postgresql-client-17 (17.4-1) ... 606s Selecting previously unselected package postgresql-17. 606s Preparing to unpack .../18-postgresql-17_17.4-1_s390x.deb ... 606s Unpacking postgresql-17 (17.4-1) ... 606s Selecting previously unselected package postgresql-17-mysql-fdw. 606s Preparing to unpack .../19-postgresql-17-mysql-fdw_2.9.2-2build1_s390x.deb ... 606s Unpacking postgresql-17-mysql-fdw (2.9.2-2build1) ... 606s Setting up postgresql-client-common (274) ... 606s Setting up mysql-common (5.8+1.1.1ubuntu1) ... 606s update-alternatives: using /etc/mysql/my.cnf.fallback to provide /etc/mysql/my.cnf (my.cnf) in auto mode 606s Setting up libzstd-dev:s390x (1.5.6+dfsg-2) ... 606s Setting up libio-pty-perl (1:1.20-1build3) ... 606s Setting up libpq5:s390x (17.4-1) ... 606s Setting up libmysqlclient24:s390x (8.4.4-0ubuntu2) ... 606s Setting up ssl-cert (1.1.3ubuntu1) ... 607s Created symlink '/etc/systemd/system/multi-user.target.wants/ssl-cert.service' → '/usr/lib/systemd/system/ssl-cert.service'. 607s Setting up libssl-dev:s390x (3.4.1-1ubuntu1) ... 607s Setting up libllvm20:s390x (1:20.1.0~+rc2-1~exp2ubuntu0.4) ... 607s Setting up libipc-run-perl (20231003.0-2) ... 607s Setting up zlib1g-dev:s390x (1:1.3.dfsg+really1.3.1-1ubuntu1) ... 607s Setting up libjson-perl (4.10000-1) ... 607s Setting up libxslt1.1:s390x (1.1.39-0exp1ubuntu2) ... 607s Setting up libmysqlclient-dev (8.4.4-0ubuntu2) ... 607s Setting up postgresql-common-dev (274) ... 607s Setting up default-libmysqlclient-dev:s390x (1.1.1ubuntu1) ... 607s Setting up postgresql-client-17 (17.4-1) ... 607s 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 607s Setting up postgresql-common (274) ... 607s Creating config file /etc/postgresql-common/createcluster.conf with new version 608s Building PostgreSQL dictionaries from installed myspell/hunspell packages... 608s Removing obsolete dictionary files: 608s Created symlink '/etc/systemd/system/multi-user.target.wants/postgresql.service' → '/usr/lib/systemd/system/postgresql.service'. 608s Setting up postgresql-17 (17.4-1) ... 609s Creating new PostgreSQL cluster 17/main ... 609s /usr/lib/postgresql/17/bin/initdb -D /var/lib/postgresql/17/main --auth-local peer --auth-host scram-sha-256 --no-instructions 609s The files belonging to this database system will be owned by user "postgres". 609s This user must also own the server process. 609s 609s The database cluster will be initialized with locale "C.UTF-8". 609s The default database encoding has accordingly been set to "UTF8". 609s The default text search configuration will be set to "english". 609s 609s Data page checksums are disabled. 609s 609s fixing permissions on existing directory /var/lib/postgresql/17/main ... ok 609s creating subdirectories ... ok 609s selecting dynamic shared memory implementation ... posix 609s selecting default "max_connections" ... 100 609s selecting default "shared_buffers" ... 128MB 609s selecting default time zone ... Etc/UTC 609s creating configuration files ... ok 609s running bootstrap script ... ok 609s performing post-bootstrap initialization ... ok 609s syncing data to disk ... ok 612s Setting up postgresql-17-mysql-fdw (2.9.2-2build1) ... 612s Processing triggers for libc-bin (2.41-1ubuntu2) ... 612s Processing triggers for man-db (2.13.0-1) ... 615s autopkgtest [16:58:13]: test create-extension: [----------------------- 615s ### PostgreSQL 17 psql ### 615s Creating new PostgreSQL cluster 17/regress ... 618s create extension mysql_fdw 618s CREATE EXTENSION 618s Dropping cluster 17/regress ... 618s ### End 17 psql ### 618s autopkgtest [16:58:16]: test create-extension: -----------------------] 619s autopkgtest [16:58:17]: test create-extension: - - - - - - - - - - results - - - - - - - - - - 619s create-extension PASS (superficial) 619s autopkgtest [16:58:17]: @@@@@@@@@@@@@@@@@@@@ summary 619s installcheck FLAKY non-zero exit status 1 619s create-extension PASS (superficial) 624s nova [W] Using flock in prodstack6-s390x 624s Creating nova instance adt-plucky-s390x-postgresql-mysql-fdw-20250315-164758-juju-7f2275-prod-proposed-migration-environment-2-73c794d2-5d2e-48e4-9dba-b1872f8605ba from image adt/ubuntu-plucky-s390x-server-20250315.img (UUID 3d3557fa-fd0f-4bba-9b89-8d5964e09f61)... 624s nova [W] Timed out waiting for e950b935-3478-4906-ba43-dcc80de7bf23 to get deleted. 624s nova [W] Using flock in prodstack6-s390x 624s Creating nova instance adt-plucky-s390x-postgresql-mysql-fdw-20250315-164758-juju-7f2275-prod-proposed-migration-environment-2-73c794d2-5d2e-48e4-9dba-b1872f8605ba from image adt/ubuntu-plucky-s390x-server-20250315.img (UUID 3d3557fa-fd0f-4bba-9b89-8d5964e09f61)... 624s nova [W] Timed out waiting for 7be01dde-12e7-45e1-94b6-655bf4d09ba0 to get deleted.