0s autopkgtest [14:27:32]: starting date and time: 2025-03-15 14:27:32+0000 0s autopkgtest [14:27:32]: git checkout: 325255d2 Merge branch 'pin-any-arch' into 'ubuntu/production' 0s autopkgtest [14:27:32]: host juju-7f2275-prod-proposed-migration-environment-15; command line: /home/ubuntu/autopkgtest/runner/autopkgtest --output-dir /tmp/autopkgtest-work.h32mcyg4/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 --security-groups autopkgtest-juju-7f2275-prod-proposed-migration-environment-15@bos03-arm64-34.secgroup --name adt-plucky-arm64-postgresql-mysql-fdw-20250315-142732-juju-7f2275-prod-proposed-migration-environment-15-776d20d6-c6bf-494c-81d7-038e3d0f2981 --image adt/ubuntu-plucky-arm64-server --keyname testbed-juju-7f2275-prod-proposed-migration-environment-15 --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,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/ 177s autopkgtest [14:30:29]: testbed dpkg architecture: arm64 177s autopkgtest [14:30:29]: testbed apt version: 2.9.33 177s autopkgtest [14:30:29]: @@@@@@@@@@@@@@@@@@@@ test bed setup 177s autopkgtest [14:30:29]: testbed release detected to be: None 178s autopkgtest [14:30:30]: updating testbed package index (apt update) 179s Get:1 http://ftpmaster.internal/ubuntu plucky-proposed InRelease [126 kB] 179s Hit:2 http://ftpmaster.internal/ubuntu plucky InRelease 179s Hit:3 http://ftpmaster.internal/ubuntu plucky-updates InRelease 179s Hit:4 http://ftpmaster.internal/ubuntu plucky-security InRelease 179s Get:5 http://ftpmaster.internal/ubuntu plucky-proposed/main Sources [101 kB] 179s Get:6 http://ftpmaster.internal/ubuntu plucky-proposed/multiverse Sources [15.8 kB] 179s Get:7 http://ftpmaster.internal/ubuntu plucky-proposed/universe Sources [404 kB] 180s Get:8 http://ftpmaster.internal/ubuntu plucky-proposed/main arm64 Packages [78.2 kB] 180s Get:9 http://ftpmaster.internal/ubuntu plucky-proposed/main arm64 c-n-f Metadata [1976 B] 180s Get:10 http://ftpmaster.internal/ubuntu plucky-proposed/restricted arm64 c-n-f Metadata [116 B] 180s Get:11 http://ftpmaster.internal/ubuntu plucky-proposed/universe arm64 Packages [346 kB] 180s Get:12 http://ftpmaster.internal/ubuntu plucky-proposed/universe arm64 c-n-f Metadata [15.8 kB] 180s Get:13 http://ftpmaster.internal/ubuntu plucky-proposed/multiverse arm64 Packages [4948 B] 180s Get:14 http://ftpmaster.internal/ubuntu plucky-proposed/multiverse arm64 c-n-f Metadata [572 B] 181s Fetched 1094 kB in 2s (648 kB/s) 181s Reading package lists... 182s + lsb_release --codename --short 182s + RELEASE=plucky 182s + cat 182s + [ plucky != trusty ] 182s + DEBIAN_FRONTEND=noninteractive eatmydata apt-get -y --allow-downgrades -o Dpkg::Options::=--force-confnew dist-upgrade 182s Reading package lists... 182s Building dependency tree... 182s Reading state information... 183s Calculating upgrade... 183s Calculating upgrade... 184s The following packages will be upgraded: 184s python3-jinja2 strace 184s 2 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 184s Need to get 608 kB of archives. 184s After this operation, 11.3 kB of additional disk space will be used. 184s Get:1 http://ftpmaster.internal/ubuntu plucky/main arm64 strace arm64 6.13+ds-1ubuntu1 [499 kB] 184s Get:2 http://ftpmaster.internal/ubuntu plucky/main arm64 python3-jinja2 all 3.1.5-2ubuntu1 [109 kB] 185s Fetched 608 kB in 1s (695 kB/s) 185s (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 ... 117701 files and directories currently installed.) 185s Preparing to unpack .../strace_6.13+ds-1ubuntu1_arm64.deb ... 185s Unpacking strace (6.13+ds-1ubuntu1) over (6.11-0ubuntu1) ... 185s Preparing to unpack .../python3-jinja2_3.1.5-2ubuntu1_all.deb ... 185s Unpacking python3-jinja2 (3.1.5-2ubuntu1) over (3.1.5-2) ... 185s Setting up python3-jinja2 (3.1.5-2ubuntu1) ... 186s Setting up strace (6.13+ds-1ubuntu1) ... 186s Processing triggers for man-db (2.13.0-1) ... 186s + rm /etc/apt/preferences.d/force-downgrade-to-release.pref 186s + /usr/lib/apt/apt-helper analyze-pattern ?true 186s + uname+ -r 186s sed s/\./\\./g 186s + running_kernel_pattern=^linux-.*6\.14\.0-10-generic.* 186s + apt list ?obsolete 186s + tail -n+2 186s + cut -d/ -f1 186s + grep -v ^linux-.*6\.14\.0-10-generic.* 187s + obsolete_pkgs=linux-headers-6.11.0-8-generic 187s linux-headers-6.11.0-8 187s linux-image-6.11.0-8-generic 187s linux-modules-6.11.0-8-generic 187s linux-tools-6.11.0-8-generic 187s linux-tools-6.11.0-8 187s + DEBIAN_FRONTEND=noninteractive eatmydata apt-get -y purge --autoremove linux-headers-6.11.0-8-genericReading package lists... 187s Building dependency tree... linux-headers-6.11.0-8 linux-image-6.11.0-8-generic linux-modules-6.11.0-8-generic linux-tools-6.11.0-8-generic linux-tools-6.11.0-8 187s 187s Reading state information... 187s Solving dependencies... 188s The following packages will be REMOVED: 188s libnsl2* libpython3.12-minimal* libpython3.12-stdlib* libpython3.12t64* 188s libunwind8* linux-headers-6.11.0-8* linux-headers-6.11.0-8-generic* 188s linux-image-6.11.0-8-generic* linux-modules-6.11.0-8-generic* 188s linux-tools-6.11.0-8* linux-tools-6.11.0-8-generic* 188s 0 upgraded, 0 newly installed, 11 to remove and 5 not upgraded. 188s After this operation, 267 MB disk space will be freed. 188s (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 ... 117701 files and directories currently installed.) 188s Removing linux-tools-6.11.0-8-generic (6.11.0-8.8) ... 188s Removing linux-tools-6.11.0-8 (6.11.0-8.8) ... 188s Removing libpython3.12t64:arm64 (3.12.9-1) ... 188s Removing libpython3.12-stdlib:arm64 (3.12.9-1) ... 188s Removing libnsl2:arm64 (1.3.0-3build3) ... 188s Removing libpython3.12-minimal:arm64 (3.12.9-1) ... 188s Removing libunwind8:arm64 (1.6.2-3.1) ... 188s Removing linux-headers-6.11.0-8-generic (6.11.0-8.8) ... 189s Removing linux-headers-6.11.0-8 (6.11.0-8.8) ... 190s Removing linux-image-6.11.0-8-generic (6.11.0-8.8) ... 191s I: /boot/vmlinuz.old is now a symlink to vmlinuz-6.14.0-10-generic 191s I: /boot/initrd.img.old is now a symlink to initrd.img-6.14.0-10-generic 191s /etc/kernel/postrm.d/initramfs-tools: 191s update-initramfs: Deleting /boot/initrd.img-6.11.0-8-generic 191s /etc/kernel/postrm.d/zz-flash-kernel: 191s flash-kernel: Kernel 6.11.0-8-generic has been removed. 191s flash-kernel: A higher version (6.14.0-10-generic) is still installed, no reflashing required. 191s /etc/kernel/postrm.d/zz-update-grub: 191s Sourcing file `/etc/default/grub' 191s Sourcing file `/etc/default/grub.d/50-cloudimg-settings.cfg' 191s Generating grub configuration file ... 191s Found linux image: /boot/vmlinuz-6.14.0-10-generic 191s Found initrd image: /boot/initrd.img-6.14.0-10-generic 192s Warning: os-prober will not be executed to detect other bootable partitions. 192s Systems on them will not be added to the GRUB boot configuration. 192s Check GRUB_DISABLE_OS_PROBER documentation entry. 192s Adding boot menu entry for UEFI Firmware Settings ... 192s done 192s Removing linux-modules-6.11.0-8-generic (6.11.0-8.8) ... 192s Processing triggers for libc-bin (2.41-1ubuntu1) ... 192s (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 ... 81650 files and directories currently installed.) 192s Purging configuration files for linux-image-6.11.0-8-generic (6.11.0-8.8) ... 192s Purging configuration files for libpython3.12-minimal:arm64 (3.12.9-1) ... 192s Purging configuration files for linux-modules-6.11.0-8-generic (6.11.0-8.8) ... 192s + grep -q trusty /etc/lsb-release 192s + [ ! -d /usr/share/doc/unattended-upgrades ] 192s + [ ! -d /usr/share/doc/lxd ] 192s + [ ! -d /usr/share/doc/lxd-client ] 192s + [ ! -d /usr/share/doc/snapd ] 192s + type iptables 192s + cat 192s + chmod 755 /etc/rc.local 192s + . /etc/rc.local 192s + iptables -w -t mangle -A FORWARD -p tcp --tcp-flags SYN,RST SYN -j TCPMSS --clamp-mss-to-pmtu 192s + iptables -A OUTPUT -d 10.255.255.1/32 -p tcp -j DROP 192s + iptables -A OUTPUT -d 10.255.255.2/32 -p tcp -j DROP 192s + uname -m 192s + [ aarch64 = ppc64le ] 192s + [ -d /run/systemd/system ] 192s + systemd-detect-virt --quiet --vm 192s + mkdir -p /etc/systemd/system/systemd-random-seed.service.d/ 192s + cat 192s + grep -q lz4 /etc/initramfs-tools/initramfs.conf 192s + echo COMPRESS=lz4 192s autopkgtest [14:30:44]: upgrading testbed (apt dist-upgrade and autopurge) 193s Reading package lists... 193s Building dependency tree... 193s Reading state information... 193s Calculating upgrade...Starting pkgProblemResolver with broken count: 0 194s Starting 2 pkgProblemResolver with broken count: 0 194s Done 194s Entering ResolveByKeep 195s 195s Calculating upgrade... 195s The following packages will be upgraded: 195s libc-bin libc-dev-bin libc6 libc6-dev locales 195s 5 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 195s Need to get 9530 kB of archives. 195s After this operation, 0 B of additional disk space will be used. 195s Get:1 http://ftpmaster.internal/ubuntu plucky-proposed/main arm64 libc6-dev arm64 2.41-1ubuntu2 [1750 kB] 197s Get:2 http://ftpmaster.internal/ubuntu plucky-proposed/main arm64 libc-dev-bin arm64 2.41-1ubuntu2 [24.0 kB] 197s Get:3 http://ftpmaster.internal/ubuntu plucky-proposed/main arm64 libc6 arm64 2.41-1ubuntu2 [2910 kB] 199s Get:4 http://ftpmaster.internal/ubuntu plucky-proposed/main arm64 libc-bin arm64 2.41-1ubuntu2 [600 kB] 200s Get:5 http://ftpmaster.internal/ubuntu plucky-proposed/main arm64 locales all 2.41-1ubuntu2 [4246 kB] 203s Preconfiguring packages ... 204s Fetched 9530 kB in 8s (1194 kB/s) 204s (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 ... 81647 files and directories currently installed.) 204s Preparing to unpack .../libc6-dev_2.41-1ubuntu2_arm64.deb ... 204s Unpacking libc6-dev:arm64 (2.41-1ubuntu2) over (2.41-1ubuntu1) ... 204s Preparing to unpack .../libc-dev-bin_2.41-1ubuntu2_arm64.deb ... 204s Unpacking libc-dev-bin (2.41-1ubuntu2) over (2.41-1ubuntu1) ... 204s Preparing to unpack .../libc6_2.41-1ubuntu2_arm64.deb ... 204s Unpacking libc6:arm64 (2.41-1ubuntu2) over (2.41-1ubuntu1) ... 204s Setting up libc6:arm64 (2.41-1ubuntu2) ... 204s (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 ... 81647 files and directories currently installed.) 204s Preparing to unpack .../libc-bin_2.41-1ubuntu2_arm64.deb ... 204s Unpacking libc-bin (2.41-1ubuntu2) over (2.41-1ubuntu1) ... 204s Setting up libc-bin (2.41-1ubuntu2) ... 205s (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 ... 81647 files and directories currently installed.) 205s Preparing to unpack .../locales_2.41-1ubuntu2_all.deb ... 205s Unpacking locales (2.41-1ubuntu2) over (2.41-1ubuntu1) ... 205s Setting up locales (2.41-1ubuntu2) ... 205s Generating locales (this might take a while)... 207s en_US.UTF-8... done 207s Generation complete. 208s Setting up libc-dev-bin (2.41-1ubuntu2) ... 208s Setting up libc6-dev:arm64 (2.41-1ubuntu2) ... 208s Processing triggers for man-db (2.13.0-1) ... 208s Processing triggers for systemd (257.3-1ubuntu3) ... 209s Reading package lists... 210s Building dependency tree... 210s Reading state information... 210s Starting pkgProblemResolver with broken count: 0 210s Starting 2 pkgProblemResolver with broken count: 0 210s Done 211s Solving dependencies... 211s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 211s autopkgtest [14:31:03]: rebooting testbed after setup commands that affected boot 236s autopkgtest [14:31:28]: testbed running kernel: Linux 6.14.0-10-generic #10-Ubuntu SMP PREEMPT_DYNAMIC Wed Mar 12 15:45:31 UTC 2025 239s autopkgtest [14:31:31]: @@@@@@@@@@@@@@@@@@@@ apt-source postgresql-mysql-fdw 241s Get:1 http://ftpmaster.internal/ubuntu plucky/universe postgresql-mysql-fdw 2.9.2-2build1 (dsc) [2357 B] 242s Get:2 http://ftpmaster.internal/ubuntu plucky/universe postgresql-mysql-fdw 2.9.2-2build1 (tar) [173 kB] 242s Get:3 http://ftpmaster.internal/ubuntu plucky/universe postgresql-mysql-fdw 2.9.2-2build1 (diff) [5172 B] 242s gpgv: Signature made Sat Feb 22 17:26:09 2025 UTC 242s gpgv: using RSA key 63EEFC3DE14D5146CE7F24BF34B8AD7D9529E793 242s gpgv: Can't check signature: No public key 242s dpkg-source: warning: cannot verify inline signature for ./postgresql-mysql-fdw_2.9.2-2build1.dsc: no acceptable signature found 242s autopkgtest [14:31:33]: testing package postgresql-mysql-fdw version 2.9.2-2build1 242s autopkgtest [14:31:34]: build not needed 243s autopkgtest [14:31:35]: test installcheck: preparing testbed 243s Reading package lists... 243s Building dependency tree... 243s Reading state information... 243s Starting pkgProblemResolver with broken count: 0 244s Starting 2 pkgProblemResolver with broken count: 0 244s Done 244s The following NEW packages will be installed: 244s default-libmysqlclient-dev default-mysql-server libio-pty-perl 244s libipc-run-perl libjson-perl libllvm20 libmecab2 libmysqlclient-dev 244s libmysqlclient24 libpq5 libprotobuf-lite32t64 libssl-dev libxslt1.1 244s libzstd-dev locales-all mysql-client mysql-client-core mysql-common 244s mysql-server mysql-server-core postgresql-17 postgresql-17-mysql-fdw 244s postgresql-client-17 postgresql-client-common postgresql-common 244s postgresql-common-dev ssl-cert zlib1g-dev 245s 0 upgraded, 28 newly installed, 0 to remove and 0 not upgraded. 245s Need to get 88.2 MB of archives. 245s After this operation, 653 MB of additional disk space will be used. 245s Get:1 http://ftpmaster.internal/ubuntu plucky/main arm64 mysql-common all 5.8+1.1.1ubuntu1 [6922 B] 245s Get:2 http://ftpmaster.internal/ubuntu plucky/main arm64 mysql-client-core arm64 8.4.4-0ubuntu2 [2094 kB] 247s Get:3 http://ftpmaster.internal/ubuntu plucky/main arm64 mysql-client arm64 8.4.4-0ubuntu2 [9122 B] 247s Get:4 http://ftpmaster.internal/ubuntu plucky/main arm64 libmecab2 arm64 0.996-15.1build2 [191 kB] 247s Get:5 http://ftpmaster.internal/ubuntu plucky/main arm64 libprotobuf-lite32t64 arm64 3.21.12-10build2 [220 kB] 247s Get:6 http://ftpmaster.internal/ubuntu plucky/main arm64 mysql-server-core arm64 8.4.4-0ubuntu2 [18.8 MB] 267s Get:7 http://ftpmaster.internal/ubuntu plucky/main arm64 mysql-server arm64 8.4.4-0ubuntu2 [1364 kB] 268s Get:8 http://ftpmaster.internal/ubuntu plucky/main arm64 libjson-perl all 4.10000-1 [81.9 kB] 268s Get:9 http://ftpmaster.internal/ubuntu plucky/main arm64 postgresql-client-common all 274 [47.6 kB] 268s Get:10 http://ftpmaster.internal/ubuntu plucky/main arm64 libio-pty-perl arm64 1:1.20-1build3 [31.3 kB] 268s Get:11 http://ftpmaster.internal/ubuntu plucky/main arm64 libipc-run-perl all 20231003.0-2 [91.5 kB] 268s Get:12 http://ftpmaster.internal/ubuntu plucky/main arm64 postgresql-common-dev all 274 [73.0 kB] 268s Get:13 http://ftpmaster.internal/ubuntu plucky/main arm64 ssl-cert all 1.1.3ubuntu1 [18.7 kB] 268s Get:14 http://ftpmaster.internal/ubuntu plucky/main arm64 postgresql-common all 274 [101 kB] 269s Get:15 http://ftpmaster.internal/ubuntu plucky/main arm64 libmysqlclient24 arm64 8.4.4-0ubuntu2 [1243 kB] 270s Get:16 http://ftpmaster.internal/ubuntu plucky/main arm64 libssl-dev arm64 3.4.1-1ubuntu1 [3287 kB] 274s Get:17 http://ftpmaster.internal/ubuntu plucky/main arm64 libzstd-dev arm64 1.5.6+dfsg-2 [353 kB] 274s Get:18 http://ftpmaster.internal/ubuntu plucky/main arm64 zlib1g-dev arm64 1:1.3.dfsg+really1.3.1-1ubuntu1 [894 kB] 275s Get:19 http://ftpmaster.internal/ubuntu plucky/main arm64 libmysqlclient-dev arm64 8.4.4-0ubuntu2 [1653 kB] 277s Get:20 http://ftpmaster.internal/ubuntu plucky/main arm64 default-libmysqlclient-dev arm64 1.1.1ubuntu1 [3300 B] 277s Get:21 http://ftpmaster.internal/ubuntu plucky/universe arm64 default-mysql-server all 1.1.1ubuntu1 [3088 B] 277s Get:22 http://ftpmaster.internal/ubuntu plucky/main arm64 libllvm20 arm64 1:20.1.0~+rc2-1~exp2ubuntu0.4 [29.1 MB] 309s Get:23 http://ftpmaster.internal/ubuntu plucky/main arm64 libpq5 arm64 17.4-1 [142 kB] 309s Get:24 http://ftpmaster.internal/ubuntu plucky/main arm64 libxslt1.1 arm64 1.1.39-0exp1ubuntu2 [168 kB] 309s Get:25 http://ftpmaster.internal/ubuntu plucky-proposed/universe arm64 locales-all arm64 2.41-1ubuntu2 [11.2 MB] 320s Get:26 http://ftpmaster.internal/ubuntu plucky/main arm64 postgresql-client-17 arm64 17.4-1 [1342 kB] 322s Get:27 http://ftpmaster.internal/ubuntu plucky/main arm64 postgresql-17 arm64 17.4-1 [15.6 MB] 337s Get:28 http://ftpmaster.internal/ubuntu plucky/universe arm64 postgresql-17-mysql-fdw arm64 2.9.2-2build1 [131 kB] 337s Preconfiguring packages ... 338s Fetched 88.2 MB in 1min 33s (951 kB/s) 338s Selecting previously unselected package mysql-common. 338s (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 ... 81647 files and directories currently installed.) 338s Preparing to unpack .../0-mysql-common_5.8+1.1.1ubuntu1_all.deb ... 338s Unpacking mysql-common (5.8+1.1.1ubuntu1) ... 338s Selecting previously unselected package mysql-client-core. 338s Preparing to unpack .../1-mysql-client-core_8.4.4-0ubuntu2_arm64.deb ... 338s Unpacking mysql-client-core (8.4.4-0ubuntu2) ... 338s Selecting previously unselected package mysql-client. 338s Preparing to unpack .../2-mysql-client_8.4.4-0ubuntu2_arm64.deb ... 338s Unpacking mysql-client (8.4.4-0ubuntu2) ... 338s Selecting previously unselected package libmecab2:arm64. 338s Preparing to unpack .../3-libmecab2_0.996-15.1build2_arm64.deb ... 338s Unpacking libmecab2:arm64 (0.996-15.1build2) ... 338s Selecting previously unselected package libprotobuf-lite32t64:arm64. 338s Preparing to unpack .../4-libprotobuf-lite32t64_3.21.12-10build2_arm64.deb ... 338s Unpacking libprotobuf-lite32t64:arm64 (3.21.12-10build2) ... 338s Selecting previously unselected package mysql-server-core. 338s Preparing to unpack .../5-mysql-server-core_8.4.4-0ubuntu2_arm64.deb ... 338s Unpacking mysql-server-core (8.4.4-0ubuntu2) ... 339s Setting up mysql-common (5.8+1.1.1ubuntu1) ... 339s update-alternatives: using /etc/mysql/my.cnf.fallback to provide /etc/mysql/my.cnf (my.cnf) in auto mode 339s Selecting previously unselected package mysql-server. 339s (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 ... 81846 files and directories currently installed.) 339s Preparing to unpack .../00-mysql-server_8.4.4-0ubuntu2_arm64.deb ... 339s Unpacking mysql-server (8.4.4-0ubuntu2) ... 339s Selecting previously unselected package libjson-perl. 339s Preparing to unpack .../01-libjson-perl_4.10000-1_all.deb ... 339s Unpacking libjson-perl (4.10000-1) ... 339s Selecting previously unselected package postgresql-client-common. 339s Preparing to unpack .../02-postgresql-client-common_274_all.deb ... 339s Unpacking postgresql-client-common (274) ... 339s Selecting previously unselected package libio-pty-perl. 339s Preparing to unpack .../03-libio-pty-perl_1%3a1.20-1build3_arm64.deb ... 339s Unpacking libio-pty-perl (1:1.20-1build3) ... 339s Selecting previously unselected package libipc-run-perl. 339s Preparing to unpack .../04-libipc-run-perl_20231003.0-2_all.deb ... 339s Unpacking libipc-run-perl (20231003.0-2) ... 339s Selecting previously unselected package postgresql-common-dev. 339s Preparing to unpack .../05-postgresql-common-dev_274_all.deb ... 339s Unpacking postgresql-common-dev (274) ... 339s Selecting previously unselected package ssl-cert. 339s Preparing to unpack .../06-ssl-cert_1.1.3ubuntu1_all.deb ... 339s Unpacking ssl-cert (1.1.3ubuntu1) ... 340s Selecting previously unselected package postgresql-common. 340s Preparing to unpack .../07-postgresql-common_274_all.deb ... 340s Adding 'diversion of /usr/bin/pg_config to /usr/bin/pg_config.libpq-dev by postgresql-common' 340s Unpacking postgresql-common (274) ... 340s Selecting previously unselected package libmysqlclient24:arm64. 340s Preparing to unpack .../08-libmysqlclient24_8.4.4-0ubuntu2_arm64.deb ... 340s Unpacking libmysqlclient24:arm64 (8.4.4-0ubuntu2) ... 340s Selecting previously unselected package libssl-dev:arm64. 340s Preparing to unpack .../09-libssl-dev_3.4.1-1ubuntu1_arm64.deb ... 340s Unpacking libssl-dev:arm64 (3.4.1-1ubuntu1) ... 340s Selecting previously unselected package libzstd-dev:arm64. 340s Preparing to unpack .../10-libzstd-dev_1.5.6+dfsg-2_arm64.deb ... 340s Unpacking libzstd-dev:arm64 (1.5.6+dfsg-2) ... 340s Selecting previously unselected package zlib1g-dev:arm64. 340s Preparing to unpack .../11-zlib1g-dev_1%3a1.3.dfsg+really1.3.1-1ubuntu1_arm64.deb ... 340s Unpacking zlib1g-dev:arm64 (1:1.3.dfsg+really1.3.1-1ubuntu1) ... 340s Selecting previously unselected package libmysqlclient-dev. 340s Preparing to unpack .../12-libmysqlclient-dev_8.4.4-0ubuntu2_arm64.deb ... 340s Unpacking libmysqlclient-dev (8.4.4-0ubuntu2) ... 340s Selecting previously unselected package default-libmysqlclient-dev:arm64. 340s Preparing to unpack .../13-default-libmysqlclient-dev_1.1.1ubuntu1_arm64.deb ... 340s Unpacking default-libmysqlclient-dev:arm64 (1.1.1ubuntu1) ... 340s Selecting previously unselected package default-mysql-server. 340s Preparing to unpack .../14-default-mysql-server_1.1.1ubuntu1_all.deb ... 340s Unpacking default-mysql-server (1.1.1ubuntu1) ... 340s Selecting previously unselected package libllvm20:arm64. 340s Preparing to unpack .../15-libllvm20_1%3a20.1.0~+rc2-1~exp2ubuntu0.4_arm64.deb ... 340s Unpacking libllvm20:arm64 (1:20.1.0~+rc2-1~exp2ubuntu0.4) ... 341s Selecting previously unselected package libpq5:arm64. 341s Preparing to unpack .../16-libpq5_17.4-1_arm64.deb ... 341s Unpacking libpq5:arm64 (17.4-1) ... 341s Selecting previously unselected package libxslt1.1:arm64. 341s Preparing to unpack .../17-libxslt1.1_1.1.39-0exp1ubuntu2_arm64.deb ... 341s Unpacking libxslt1.1:arm64 (1.1.39-0exp1ubuntu2) ... 341s Selecting previously unselected package locales-all. 341s Preparing to unpack .../18-locales-all_2.41-1ubuntu2_arm64.deb ... 341s Unpacking locales-all (2.41-1ubuntu2) ... 343s Selecting previously unselected package postgresql-client-17. 343s Preparing to unpack .../19-postgresql-client-17_17.4-1_arm64.deb ... 343s Unpacking postgresql-client-17 (17.4-1) ... 343s Selecting previously unselected package postgresql-17. 343s Preparing to unpack .../20-postgresql-17_17.4-1_arm64.deb ... 343s Unpacking postgresql-17 (17.4-1) ... 343s Selecting previously unselected package postgresql-17-mysql-fdw. 343s Preparing to unpack .../21-postgresql-17-mysql-fdw_2.9.2-2build1_arm64.deb ... 343s Unpacking postgresql-17-mysql-fdw (2.9.2-2build1) ... 343s Setting up libprotobuf-lite32t64:arm64 (3.21.12-10build2) ... 343s Setting up postgresql-client-common (274) ... 343s Setting up libmecab2:arm64 (0.996-15.1build2) ... 343s Setting up libzstd-dev:arm64 (1.5.6+dfsg-2) ... 343s Setting up libio-pty-perl (1:1.20-1build3) ... 343s Setting up libpq5:arm64 (17.4-1) ... 343s Setting up libmysqlclient24:arm64 (8.4.4-0ubuntu2) ... 343s Setting up locales-all (2.41-1ubuntu2) ... 343s Setting up ssl-cert (1.1.3ubuntu1) ... 344s Created symlink '/etc/systemd/system/multi-user.target.wants/ssl-cert.service' → '/usr/lib/systemd/system/ssl-cert.service'. 344s Setting up mysql-server-core (8.4.4-0ubuntu2) ... 344s Setting up libssl-dev:arm64 (3.4.1-1ubuntu1) ... 344s Setting up libllvm20:arm64 (1:20.1.0~+rc2-1~exp2ubuntu0.4) ... 344s Setting up libipc-run-perl (20231003.0-2) ... 344s Setting up zlib1g-dev:arm64 (1:1.3.dfsg+really1.3.1-1ubuntu1) ... 344s Setting up mysql-client-core (8.4.4-0ubuntu2) ... 344s Setting up libjson-perl (4.10000-1) ... 344s Setting up libxslt1.1:arm64 (1.1.39-0exp1ubuntu2) ... 344s Setting up libmysqlclient-dev (8.4.4-0ubuntu2) ... 344s Setting up postgresql-common-dev (274) ... 344s Setting up default-libmysqlclient-dev:arm64 (1.1.1ubuntu1) ... 344s Setting up mysql-client (8.4.4-0ubuntu2) ... 344s Setting up postgresql-client-17 (17.4-1) ... 345s 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 345s Setting up postgresql-common (274) ... 345s Creating config file /etc/postgresql-common/createcluster.conf with new version 345s Building PostgreSQL dictionaries from installed myspell/hunspell packages... 345s Removing obsolete dictionary files: 346s Created symlink '/etc/systemd/system/multi-user.target.wants/postgresql.service' → '/usr/lib/systemd/system/postgresql.service'. 346s Setting up mysql-server (8.4.4-0ubuntu2) ... 346s update-alternatives: using /etc/mysql/mysql.cnf to provide /etc/mysql/my.cnf (my.cnf) in auto mode 346s Renaming removed key_buffer and myisam-recover options (if present) 353s Created symlink '/etc/systemd/system/multi-user.target.wants/mysql.service' → '/usr/lib/systemd/system/mysql.service'. 354s Setting up postgresql-17 (17.4-1) ... 355s Creating new PostgreSQL cluster 17/main ... 355s /usr/lib/postgresql/17/bin/initdb -D /var/lib/postgresql/17/main --auth-local peer --auth-host scram-sha-256 --no-instructions 355s The files belonging to this database system will be owned by user "postgres". 355s This user must also own the server process. 355s 355s The database cluster will be initialized with locale "C.UTF-8". 355s The default database encoding has accordingly been set to "UTF8". 355s The default text search configuration will be set to "english". 355s 355s Data page checksums are disabled. 355s 355s fixing permissions on existing directory /var/lib/postgresql/17/main ... ok 355s creating subdirectories ... ok 355s selecting dynamic shared memory implementation ... posix 355s selecting default "max_connections" ... 100 355s selecting default "shared_buffers" ... 128MB 355s selecting default time zone ... Etc/UTC 355s creating configuration files ... ok 355s running bootstrap script ... ok 356s performing post-bootstrap initialization ... ok 356s syncing data to disk ... ok 359s Setting up postgresql-17-mysql-fdw (2.9.2-2build1) ... 359s Setting up default-mysql-server (1.1.1ubuntu1) ... 359s Processing triggers for libc-bin (2.41-1ubuntu2) ... 359s Processing triggers for man-db (2.13.0-1) ... 361s autopkgtest [14:33:33]: test installcheck: [----------------------- 362s + service mariadb start 362s Failed to start mariadb.service: Unit mariadb.service not found. 362s + service mysql start 363s + test -d /var/run/mysqld 363s + chmod -v 755 /var/run/mysqld 363s mode of '/var/run/mysqld' retained as 0755 (rwxr-xr-x) 363s == creating the MySQL test database 363s + echo == creating the MySQL test database 363s + cat debian/tests/mysql.testschema.sql 363s + mysql --defaults-file=/etc/mysql/debian.cnf -v mysql 363s -------------- 363s CREATE DATABASE mysql_fdw_regress 363s -------------- 363s 363s -------------- 363s CREATE DATABASE mysql_fdw_regress1 363s -------------- 363s 363s -------------- 363s CREATE USER 'edb'@'localhost' IDENTIFIED BY 'edb' 363s -------------- 363s 363s -------------- 363s GRANT ALL PRIVILEGES ON mysql_fdw_regress.* TO 'edb'@'localhost' 363s -------------- 363s 363s -------------- 363s GRANT ALL PRIVILEGES ON mysql_fdw_regress1.* TO 'edb'@'localhost' 363s -------------- 363s 363s + ./mysql_init.sh 364s + pg_buildext installed-versions 364s + NO_JIT=-o jit=off 364s + PG_VIRTUALENV_UNSHARE= MYSQL_USER_NAME=edb MYSQL_PWD=edb pg_buildext -o jit=off installcheck-17 364s ### PostgreSQL 17 installcheck ### 364s Creating new PostgreSQL cluster 17/regress ... 367s 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 367s # +++ regress install-check in +++ 367s # using postmaster on localhost, port 5433 367s ok 1 - server_options 164 ms 367s not ok 2 - connection_validation 84 ms 367s ok 3 - dml 236 ms 368s ok 4 - select 960 ms 369s ok 5 - pushdown 313 ms 369s ok 6 - join_pushdown 457 ms 369s ok 7 - aggregate_pushdown 245 ms 370s ok 8 - limit_offset_pushdown 133 ms 370s ok 9 - misc 456 ms 370s 1..9 370s *** /tmp/pg_virtualenv.IFAsZR/log/postgresql-17-regress.log (last 100 lines) *** 370s # 1 of 9 tests failed. 370s # The differences that caused some tests to fail can be viewed in the file "/tmp/autopkgtest.oiGaWA/build.xx2/src/regression.diffs". 370s # A copy of the test summary that you see above is saved in the file "/tmp/autopkgtest.oiGaWA/build.xx2/src/regression.out". 370s make: *** [/usr/lib/postgresql/17/lib/pgxs/src/makefiles/pgxs.mk:436: installcheck] Error 1 370s 2025-03-15 14:33:39.874 UTC [4092] postgres@contrib_regression STATEMENT: INSERT INTO f_mysql_test VALUES(1,1) ON CONFLICT (a) DO UPDATE SET b = 10; 370s WARNING: MYSQL_OPT_RECONNECT is deprecated and will be removed in a future version. 370s 2025-03-15 14:33:40.209 UTC [4105] postgres@contrib_regression ERROR: invalid reference to FROM-clause entry for table "t1" at character 88 370s 2025-03-15 14:33:40.209 UTC [4105] postgres@contrib_regression DETAIL: The combining JOIN type must be INNER or LEFT for a LATERAL reference. 370s 2025-03-15 14:33:40.209 UTC [4105] postgres@contrib_regression STATEMENT: SELECT t1.c1, t3.c1, t3.t1_c8 FROM f_test_tbl1 t1 RIGHT JOIN LATERAL ( 370s SELECT t2.c1, t1.c8 AS t1_c8 FROM f_test_tbl2 t2) t3 ON t3.c1 = t3.t1_c8 370s ORDER BY 1, 2, 3; 370s WARNING: MYSQL_OPT_RECONNECT is deprecated and will be removed in a future version. 370s WARNING: MYSQL_OPT_RECONNECT is deprecated and will be removed in a future version. 370s 2025-03-15 14:33:40.284 UTC [4105] postgres@contrib_regression ERROR: invalid input value for enum size_t: "big" at character 34 370s 2025-03-15 14:33:40.284 UTC [4105] postgres@contrib_regression STATEMENT: INSERT INTO f_enum_t1 VALUES (4, 'big'); 370s WARNING: MYSQL_OPT_RECONNECT is deprecated and will be removed in a future version. 370s WARNING: MYSQL_OPT_RECONNECT is deprecated and will be removed in a future version. 370s WARNING: MYSQL_OPT_RECONNECT is deprecated and will be removed in a future version. 370s WARNING: MYSQL_OPT_RECONNECT is deprecated and will be removed in a future version. 370s WARNING: MYSQL_OPT_RECONNECT is deprecated and will be removed in a future version. 370s WARNING: MYSQL_OPT_RECONNECT is deprecated and will be removed in a future version. 370s WARNING: MYSQL_OPT_RECONNECT is deprecated and will be removed in a future version. 370s 2025-03-15 14:33:40.341 UTC [4105] postgres@contrib_regression ERROR: system attribute "xmin" can't be fetched from remote relation 370s 2025-03-15 14:33:40.341 UTC [4105] postgres@contrib_regression STATEMENT: SELECT xmin FROM f_test_tbl1; 370s 2025-03-15 14:33:40.342 UTC [4105] postgres@contrib_regression ERROR: system attribute "ctid" can't be fetched from remote relation 370s 2025-03-15 14:33:40.342 UTC [4105] postgres@contrib_regression STATEMENT: SELECT ctid, xmax, tableoid FROM f_test_tbl1; 370s 2025-03-15 14:33:40.342 UTC [4105] postgres@contrib_regression ERROR: system attribute "xmax" can't be fetched from remote relation 370s 2025-03-15 14:33:40.342 UTC [4105] postgres@contrib_regression STATEMENT: SELECT xmax, c1 FROM f_test_tbl1; 370s 2025-03-15 14:33:40.342 UTC [4105] postgres@contrib_regression ERROR: system attribute "tableoid" can't be fetched from remote relation 370s 2025-03-15 14:33:40.342 UTC [4105] postgres@contrib_regression STATEMENT: SELECT count(tableoid) FROM f_test_tbl1; 370s WARNING: MYSQL_OPT_RECONNECT is deprecated and will be removed in a future version. 370s WARNING: MYSQL_OPT_RECONNECT is deprecated and will be removed in a future version. 370s WARNING: MYSQL_OPT_RECONNECT is deprecated and will be removed in a future version. 370s 2025-03-15 14:33:40.607 UTC [4105] postgres@contrib_regression WARNING: skipping import for relation "test_set" 370s 2025-03-15 14:33:40.607 UTC [4105] postgres@contrib_regression DETAIL: MySQL SET columns are not supported. 370s WARNING: MYSQL_OPT_RECONNECT is deprecated and will be removed in a future version. 370s 2025-03-15 14:33:40.612 UTC [4105] postgres@contrib_regression ERROR: failed to execute the MySQL query: 370s Column 'b' cannot be null 370s 2025-03-15 14:33:40.612 UTC [4105] postgres@contrib_regression STATEMENT: UPDATE f_mysql_test SET b = NULL WHERE a = 1; 370s WARNING: MYSQL_OPT_RECONNECT is deprecated and will be removed in a future version. 370s WARNING: MYSQL_OPT_RECONNECT is deprecated and will be removed in a future version. 370s 2025-03-15 14:33:40.634 UTC [4105] postgres@contrib_regression ERROR: failed to execute the MySQL query: 370s Variable 'sql_mode' can't be set to the value of 'ABCD' 370s 2025-03-15 14:33:40.634 UTC [4105] postgres@contrib_regression STATEMENT: SELECT * FROM f_mysql_test ORDER BY 1; 370s WARNING: MYSQL_OPT_RECONNECT is deprecated and will be removed in a future version. 370s 2025-03-15 14:33:40.642 UTC [4105] postgres@contrib_regression ERROR: numeric field overflow 370s 2025-03-15 14:33:40.642 UTC [4105] postgres@contrib_regression DETAIL: A field with precision 3, scale 2 must round to an absolute value less than 10^1. 370s 2025-03-15 14:33:40.642 UTC [4105] postgres@contrib_regression STATEMENT: SELECT * FROM f_test6 ORDER BY 1; 370s WARNING: MYSQL_OPT_RECONNECT is deprecated and will be removed in a future version. 370s WARNING: MYSQL_OPT_RECONNECT is deprecated and will be removed in a future version. 370s WARNING: MYSQL_OPT_RECONNECT is deprecated and will be removed in a future version. 370s WARNING: MYSQL_OPT_RECONNECT is deprecated and will be removed in a future version. 370s WARNING: MYSQL_OPT_RECONNECT is deprecated and will be removed in a future version. 370s WARNING: MYSQL_OPT_RECONNECT is deprecated and will be removed in a future version. 370s WARNING: MYSQL_OPT_RECONNECT is deprecated and will be removed in a future version. 370s WARNING: MYSQL_OPT_RECONNECT is deprecated and will be removed in a future version. 370s WARNING: MYSQL_OPT_RECONNECT is deprecated and will be removed in a future version. 370s 2025-03-15 14:33:42.156 UTC [4168] postgres@contrib_regression ERROR: truncatable requires a Boolean value 370s 2025-03-15 14:33:42.156 UTC [4168] postgres@contrib_regression STATEMENT: ALTER SERVER mysql_svr OPTIONS (ADD truncatable 'abc'); 370s 2025-03-15 14:33:42.157 UTC [4168] postgres@contrib_regression ERROR: truncatable requires a Boolean value 370s 2025-03-15 14:33:42.157 UTC [4168] postgres@contrib_regression STATEMENT: ALTER FOREIGN TABLE fdw519_ft1 OPTIONS (ADD truncatable 'abc'); 370s 2025-03-15 14:33:42.204 UTC [4168] postgres@contrib_regression ERROR: foreign table "fdw519_ft1" does not allow truncates 370s 2025-03-15 14:33:42.204 UTC [4168] postgres@contrib_regression STATEMENT: TRUNCATE fdw519_ft1; 370s WARNING: MYSQL_OPT_RECONNECT is deprecated and will be removed in a future version. 370s WARNING: MYSQL_OPT_RECONNECT is deprecated and will be removed in a future version. 370s WARNING: MYSQL_OPT_RECONNECT is deprecated and will be removed in a future version. 370s 2025-03-15 14:33:42.291 UTC [4168] postgres@contrib_regression ERROR: foreign table "fdw519_ft1" does not allow truncates 370s 2025-03-15 14:33:42.291 UTC [4168] postgres@contrib_regression STATEMENT: TRUNCATE fdw519_ft1, fdw519_ft2; 370s WARNING: MYSQL_OPT_RECONNECT is deprecated and will be removed in a future version. 370s 2025-03-15 14:33:42.295 UTC [4168] postgres@contrib_regression ERROR: foreign table "fdw519_ft1" does not allow truncates 370s 2025-03-15 14:33:42.295 UTC [4168] postgres@contrib_regression STATEMENT: TRUNCATE fdw519_ft1, fdw519_ft2; 370s WARNING: MYSQL_OPT_RECONNECT is deprecated and will be removed in a future version. 370s WARNING: MYSQL_OPT_RECONNECT is deprecated and will be removed in a future version. 370s WARNING: MYSQL_OPT_RECONNECT is deprecated and will be removed in a future version. 370s 2025-03-15 14:33:42.412 UTC [4168] postgres@contrib_regression ERROR: CASCADE option in TRUNCATE is not supported by this FDW 370s 2025-03-15 14:33:42.412 UTC [4168] postgres@contrib_regression STATEMENT: TRUNCATE fdw519_ft1 CASCADE; 370s 2025-03-15 14:33:42.446 UTC [4168] postgres@contrib_regression ERROR: failed to execute the MySQL query: 370s Cannot truncate a table referenced in a foreign key constraint (`mysql_fdw_regress1`.`dept`, CONSTRAINT `dept_ibfk_1`) 370s 2025-03-15 14:33:42.446 UTC [4168] postgres@contrib_regression STATEMENT: TRUNCATE fdw519_ft4; 370s WARNING: MYSQL_OPT_RECONNECT is deprecated and will be removed in a future version. 370s 2025-03-15 14:33:42.463 UTC [4168] postgres@contrib_regression ERROR: cannot use generated column "c3" in column generation expression at character 140 370s 2025-03-15 14:33:42.463 UTC [4168] postgres@contrib_regression DETAIL: A generated column cannot reference another generated column. 370s 2025-03-15 14:33:42.463 UTC [4168] postgres@contrib_regression QUERY: CREATE FOREIGN TABLE fdw520_1 ( 370s c1 int NOT NULL, 370s c2 int, 370s c3 int GENERATED ALWAYS AS ("c2" * 2) STORED, 370s c4 int GENERATED ALWAYS AS ("c3" * 4) STORED NOT NULL 370s ) SERVER mysql_svr OPTIONS (dbname 'mysql_fdw_regress', table_name 'fdw520_1'); 370s 370s 2025-03-15 14:33:42.463 UTC [4168] postgres@contrib_regression CONTEXT: importing foreign table "fdw520_1" 370s 2025-03-15 14:33:42.463 UTC [4168] postgres@contrib_regression STATEMENT: IMPORT FOREIGN SCHEMA mysql_fdw_regress LIMIT TO (fdw520_1) 370s FROM SERVER mysql_svr INTO public OPTIONS (import_generated 'true'); 370s WARNING: MYSQL_OPT_RECONNECT is deprecated and will be removed in a future version. 370s WARNING: MYSQL_OPT_RECONNECT is deprecated and will be removed in a future version. 370s WARNING: MYSQL_OPT_RECONNECT is deprecated and will be removed in a future version. 370s 2025-03-15 14:33:42.494 UTC [4168] postgres@contrib_regression ERROR: cannot insert a non-DEFAULT value into column "c3" 370s 2025-03-15 14:33:42.494 UTC [4168] postgres@contrib_regression DETAIL: Column "c3" is a generated column. 370s 2025-03-15 14:33:42.494 UTC [4168] postgres@contrib_regression STATEMENT: INSERT INTO fdw520 VALUES(1, 2, 3, 4); 370s 2025-03-15 14:33:42.506 UTC [4168] postgres@contrib_regression ERROR: column "c4" can only be updated to DEFAULT 370s 2025-03-15 14:33:42.506 UTC [4168] postgres@contrib_regression DETAIL: Column "c4" is a generated column. 370s 2025-03-15 14:33:42.506 UTC [4168] postgres@contrib_regression STATEMENT: UPDATE fdw520 SET c4 = 20 WHERE c1 = 2; 370s 2025-03-15 14:33:42.507 UTC [4168] postgres@contrib_regression ERROR: column "c3" can only be updated to DEFAULT 370s 2025-03-15 14:33:42.507 UTC [4168] postgres@contrib_regression DETAIL: Column "c3" is a generated column. 370s 2025-03-15 14:33:42.507 UTC [4168] postgres@contrib_regression STATEMENT: UPDATE fdw520 SET c3 = 20 WHERE c1 = 2; 370s Dropping cluster 17/regress ... 370s **** regression.diffs **** 370s diff -U3 /tmp/autopkgtest.oiGaWA/build.xx2/src/expected/connection_validation.out /tmp/autopkgtest.oiGaWA/build.xx2/src/results/connection_validation.out 370s --- /tmp/autopkgtest.oiGaWA/build.xx2/src/expected/connection_validation.out 2024-07-11 05:24:25.000000000 +0000 370s +++ /tmp/autopkgtest.oiGaWA/build.xx2/src/results/connection_validation.out 2025-03-15 14:33:39.686229306 +0000 370s @@ -118,11 +118,7 @@ 370s \! echo secure_auth=true >> /tmp/my.cnf 370s -- Connection should happen as default file exists with details. 370s SELECT * FROM f_mysql_file_test ORDER BY 1, 2; 370s - a | b 370s ----+--- 370s - 1 | 1 370s -(1 row) 370s - 370s +ERROR: failed to connect to MySQL: Unknown MySQL server host '' (-5) 370s -- Cleanup 370s DROP FOREIGN TABLE f_mysql_test; 370s DROP FOREIGN TABLE f_mysql_file_test; 370s ### End 17 installcheck (FAILED with exit code 1) ### 370s == dropping the MySQL test database 370s -------------- 370s DROP USER 'edb'@'localhost' 370s -------------- 370s 371s -------------- 371s DROP DATABASE mysql_fdw_regress 371s -------------- 371s 371s -------------- 371s DROP DATABASE mysql_fdw_regress1 371s -------------- 371s 371s Failed to stop mariadb.service: Unit mariadb.service not loaded. 373s autopkgtest [14:33:45]: test installcheck: -----------------------] 373s installcheck FLAKY non-zero exit status 1 373s autopkgtest [14:33:45]: test installcheck: - - - - - - - - - - results - - - - - - - - - - 374s autopkgtest [14:33:46]: test create-extension: preparing testbed 519s autopkgtest [14:36:11]: testbed dpkg architecture: arm64 519s autopkgtest [14:36:11]: testbed apt version: 2.9.33 519s autopkgtest [14:36:11]: @@@@@@@@@@@@@@@@@@@@ test bed setup 520s autopkgtest [14:36:12]: testbed release detected to be: plucky 521s autopkgtest [14:36:13]: updating testbed package index (apt update) 521s Get:1 http://ftpmaster.internal/ubuntu plucky-proposed InRelease [126 kB] 521s Hit:2 http://ftpmaster.internal/ubuntu plucky InRelease 521s Hit:3 http://ftpmaster.internal/ubuntu plucky-updates InRelease 521s Hit:4 http://ftpmaster.internal/ubuntu plucky-security InRelease 521s Get:5 http://ftpmaster.internal/ubuntu plucky-proposed/multiverse Sources [15.8 kB] 522s Get:6 http://ftpmaster.internal/ubuntu plucky-proposed/main Sources [101 kB] 522s Get:7 http://ftpmaster.internal/ubuntu plucky-proposed/universe Sources [404 kB] 522s Get:8 http://ftpmaster.internal/ubuntu plucky-proposed/main arm64 Packages [78.2 kB] 522s Get:9 http://ftpmaster.internal/ubuntu plucky-proposed/main arm64 c-n-f Metadata [1976 B] 522s Get:10 http://ftpmaster.internal/ubuntu plucky-proposed/restricted arm64 c-n-f Metadata [116 B] 522s Get:11 http://ftpmaster.internal/ubuntu plucky-proposed/universe arm64 Packages [346 kB] 522s Get:12 http://ftpmaster.internal/ubuntu plucky-proposed/universe arm64 c-n-f Metadata [15.8 kB] 522s Get:13 http://ftpmaster.internal/ubuntu plucky-proposed/multiverse arm64 Packages [4948 B] 522s Get:14 http://ftpmaster.internal/ubuntu plucky-proposed/multiverse arm64 c-n-f Metadata [572 B] 523s Fetched 1094 kB in 2s (646 kB/s) 524s Reading package lists... 524s + lsb_release --codename --short 524s + RELEASE=plucky 524s + cat 524s + [ plucky != trusty ] 524s + DEBIAN_FRONTEND=noninteractive eatmydata apt-get -y --allow-downgrades -o Dpkg::Options::=--force-confnew dist-upgrade 524s Reading package lists... 524s Building dependency tree... 524s Reading state information... 525s Calculating upgrade... 525s Calculating upgrade... 525s The following packages will be upgraded: 525s python3-jinja2 strace 526s 2 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 526s Need to get 608 kB of archives. 526s After this operation, 11.3 kB of additional disk space will be used. 526s Get:1 http://ftpmaster.internal/ubuntu plucky/main arm64 strace arm64 6.13+ds-1ubuntu1 [499 kB] 526s Get:2 http://ftpmaster.internal/ubuntu plucky/main arm64 python3-jinja2 all 3.1.5-2ubuntu1 [109 kB] 527s Fetched 608 kB in 1s (699 kB/s) 527s (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 ... 117701 files and directories currently installed.) 527s Preparing to unpack .../strace_6.13+ds-1ubuntu1_arm64.deb ... 527s Unpacking strace (6.13+ds-1ubuntu1) over (6.11-0ubuntu1) ... 527s Preparing to unpack .../python3-jinja2_3.1.5-2ubuntu1_all.deb ... 527s Unpacking python3-jinja2 (3.1.5-2ubuntu1) over (3.1.5-2) ... 527s Setting up python3-jinja2 (3.1.5-2ubuntu1) ... 527s Setting up strace (6.13+ds-1ubuntu1) ... 527s Processing triggers for man-db (2.13.0-1) ... 528s + rm /etc/apt/preferences.d/force-downgrade-to-release.pref 528s + /usr/lib/apt/apt-helper analyze-pattern ?true 528s + uname -r 528s + sed s/\./\\./g 528s + running_kernel_pattern=^linux-.*6\.14\.0-10-generic.* 528s + apt list ?obsolete 528s + tail -n+2 528s + cut -d/ -f1 528s + grep -v ^linux-.*6\.14\.0-10-generic.* 528s + obsolete_pkgs=linux-headers-6.11.0-8-generic 528s linux-headers-6.11.0-8 528s linux-image-6.11.0-8-generic 528s linux-modules-6.11.0-8-generic 528s linux-tools-6.11.0-8-generic 528s linux-tools-6.11.0-8 528s + DEBIAN_FRONTEND=noninteractive eatmydata apt-get -y purge --autoremove linux-headers-6.11.0-8-generic linux-headers-6.11.0-8 linux-image-6.11.0-8-generic linux-modules-6.11.0-8-generic linux-tools-6.11.0-8-generic linux-tools-6.11.0-8 529s Reading package lists... 529s Building dependency tree... 529s Reading state information... 529s Solving dependencies... 529s The following packages will be REMOVED: 529s libnsl2* libpython3.12-minimal* libpython3.12-stdlib* libpython3.12t64* 529s libunwind8* linux-headers-6.11.0-8* linux-headers-6.11.0-8-generic* 529s linux-image-6.11.0-8-generic* linux-modules-6.11.0-8-generic* 529s linux-tools-6.11.0-8* linux-tools-6.11.0-8-generic* 530s 0 upgraded, 0 newly installed, 11 to remove and 5 not upgraded. 530s After this operation, 267 MB disk space will be freed. 530s (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 ... 117701 files and directories currently installed.) 530s Removing linux-tools-6.11.0-8-generic (6.11.0-8.8) ... 530s Removing linux-tools-6.11.0-8 (6.11.0-8.8) ... 530s Removing libpython3.12t64:arm64 (3.12.9-1) ... 530s Removing libpython3.12-stdlib:arm64 (3.12.9-1) ... 530s Removing libnsl2:arm64 (1.3.0-3build3) ... 530s Removing libpython3.12-minimal:arm64 (3.12.9-1) ... 530s Removing libunwind8:arm64 (1.6.2-3.1) ... 530s Removing linux-headers-6.11.0-8-generic (6.11.0-8.8) ... 531s Removing linux-headers-6.11.0-8 (6.11.0-8.8) ... 532s Removing linux-image-6.11.0-8-generic (6.11.0-8.8) ... 532s I: /boot/vmlinuz.old is now a symlink to vmlinuz-6.14.0-10-generic 532s I: /boot/initrd.img.old is now a symlink to initrd.img-6.14.0-10-generic 532s /etc/kernel/postrm.d/initramfs-tools: 532s update-initramfs: Deleting /boot/initrd.img-6.11.0-8-generic 532s /etc/kernel/postrm.d/zz-flash-kernel: 532s flash-kernel: Kernel 6.11.0-8-generic has been removed. 532s flash-kernel: A higher version (6.14.0-10-generic) is still installed, no reflashing required. 533s /etc/kernel/postrm.d/zz-update-grub: 533s Sourcing file `/etc/default/grub' 533s Sourcing file `/etc/default/grub.d/50-cloudimg-settings.cfg' 533s Generating grub configuration file ... 533s Found linux image: /boot/vmlinuz-6.14.0-10-generic 533s Found initrd image: /boot/initrd.img-6.14.0-10-generic 533s Warning: os-prober will not be executed to detect other bootable partitions. 533s Systems on them will not be added to the GRUB boot configuration. 533s Check GRUB_DISABLE_OS_PROBER documentation entry. 533s Adding boot menu entry for UEFI Firmware Settings ... 533s done 533s Removing linux-modules-6.11.0-8-generic (6.11.0-8.8) ... 533s Processing triggers for libc-bin (2.41-1ubuntu1) ... 533s (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 ... 81650 files and directories currently installed.) 533s Purging configuration files for linux-image-6.11.0-8-generic (6.11.0-8.8) ... 534s Purging configuration files for libpython3.12-minimal:arm64 (3.12.9-1) ... 534s Purging configuration files for linux-modules-6.11.0-8-generic (6.11.0-8.8) ... 534s + grep -q trusty /etc/lsb-release 534s + [ ! -d /usr/share/doc/unattended-upgrades ] 534s + [ ! -d /usr/share/doc/lxd ] 534s + [ ! -d /usr/share/doc/lxd-client ] 534s + [ ! -d /usr/share/doc/snapd ] 534s + type iptables 534s + cat 534s + chmod 755 /etc/rc.local 534s + . /etc/rc.local 534s + iptables -w -t mangle -A FORWARD -p tcp --tcp-flags SYN,RST SYN -j TCPMSS --clamp-mss-to-pmtu 534s + iptables -A OUTPUT -d 10.255.255.1/32 -p tcp -j DROP 534s + iptables -A OUTPUT -d 10.255.255.2/32 -p tcp -j DROP 534s + uname -m 534s + [ aarch64 = ppc64le ] 534s + [ -d /run/systemd/system ] 534s + systemd-detect-virt --quiet --vm 534s + mkdir -p /etc/systemd/system/systemd-random-seed.service.d/ 534s + cat 534s + grep -q lz4 /etc/initramfs-tools/initramfs.conf 534s + echo COMPRESS=lz4 534s autopkgtest [14:36:26]: upgrading testbed (apt dist-upgrade and autopurge) 534s Reading package lists... 534s Building dependency tree... 534s Reading state information... 535s Calculating upgrade...Starting pkgProblemResolver with broken count: 0 535s Starting 2 pkgProblemResolver with broken count: 0 535s Done 535s Entering ResolveByKeep 536s 536s Calculating upgrade... 536s The following packages will be upgraded: 536s libc-bin libc-dev-bin libc6 libc6-dev locales 536s 5 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 536s Need to get 9530 kB of archives. 536s After this operation, 0 B of additional disk space will be used. 536s Get:1 http://ftpmaster.internal/ubuntu plucky-proposed/main arm64 libc6-dev arm64 2.41-1ubuntu2 [1750 kB] 538s Get:2 http://ftpmaster.internal/ubuntu plucky-proposed/main arm64 libc-dev-bin arm64 2.41-1ubuntu2 [24.0 kB] 538s Get:3 http://ftpmaster.internal/ubuntu plucky-proposed/main arm64 libc6 arm64 2.41-1ubuntu2 [2910 kB] 542s Get:4 http://ftpmaster.internal/ubuntu plucky-proposed/main arm64 libc-bin arm64 2.41-1ubuntu2 [600 kB] 542s Get:5 http://ftpmaster.internal/ubuntu plucky-proposed/main arm64 locales all 2.41-1ubuntu2 [4246 kB] 547s Preconfiguring packages ... 547s Fetched 9530 kB in 10s (921 kB/s) 547s (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 ... 81647 files and directories currently installed.) 547s Preparing to unpack .../libc6-dev_2.41-1ubuntu2_arm64.deb ... 547s Unpacking libc6-dev:arm64 (2.41-1ubuntu2) over (2.41-1ubuntu1) ... 547s Preparing to unpack .../libc-dev-bin_2.41-1ubuntu2_arm64.deb ... 547s Unpacking libc-dev-bin (2.41-1ubuntu2) over (2.41-1ubuntu1) ... 547s Preparing to unpack .../libc6_2.41-1ubuntu2_arm64.deb ... 547s Unpacking libc6:arm64 (2.41-1ubuntu2) over (2.41-1ubuntu1) ... 548s Setting up libc6:arm64 (2.41-1ubuntu2) ... 548s (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 ... 81647 files and directories currently installed.) 548s Preparing to unpack .../libc-bin_2.41-1ubuntu2_arm64.deb ... 548s Unpacking libc-bin (2.41-1ubuntu2) over (2.41-1ubuntu1) ... 548s Setting up libc-bin (2.41-1ubuntu2) ... 548s (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 ... 81647 files and directories currently installed.) 548s Preparing to unpack .../locales_2.41-1ubuntu2_all.deb ... 548s Unpacking locales (2.41-1ubuntu2) over (2.41-1ubuntu1) ... 548s Setting up locales (2.41-1ubuntu2) ... 549s Generating locales (this might take a while)... 551s en_US.UTF-8... done 551s Generation complete. 551s Setting up libc-dev-bin (2.41-1ubuntu2) ... 551s Setting up libc6-dev:arm64 (2.41-1ubuntu2) ... 551s Processing triggers for man-db (2.13.0-1) ... 552s Processing triggers for systemd (257.3-1ubuntu3) ... 552s Reading package lists... 553s Building dependency tree... 553s Reading state information... 553s Starting pkgProblemResolver with broken count: 0 553s Starting 2 pkgProblemResolver with broken count: 0 553s Done 554s Solving dependencies... 554s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 554s autopkgtest [14:36:46]: rebooting testbed after setup commands that affected boot 580s Reading package lists... 581s Building dependency tree... 581s Reading state information... 582s Starting pkgProblemResolver with broken count: 0 582s Starting 2 pkgProblemResolver with broken count: 0 582s Done 582s The following NEW packages will be installed: 582s default-libmysqlclient-dev libio-pty-perl libipc-run-perl libjson-perl 582s libllvm20 libmysqlclient-dev libmysqlclient24 libpq5 libssl-dev libxslt1.1 582s libzstd-dev mysql-common postgresql-17 postgresql-17-mysql-fdw 582s postgresql-client-17 postgresql-client-common postgresql-common 582s postgresql-common-dev ssl-cert zlib1g-dev 582s 0 upgraded, 20 newly installed, 0 to remove and 0 not upgraded. 582s Need to get 54.4 MB of archives. 582s After this operation, 232 MB of additional disk space will be used. 582s Get:1 http://ftpmaster.internal/ubuntu plucky/main arm64 libjson-perl all 4.10000-1 [81.9 kB] 582s Get:2 http://ftpmaster.internal/ubuntu plucky/main arm64 postgresql-client-common all 274 [47.6 kB] 582s Get:3 http://ftpmaster.internal/ubuntu plucky/main arm64 libio-pty-perl arm64 1:1.20-1build3 [31.3 kB] 582s Get:4 http://ftpmaster.internal/ubuntu plucky/main arm64 libipc-run-perl all 20231003.0-2 [91.5 kB] 583s Get:5 http://ftpmaster.internal/ubuntu plucky/main arm64 postgresql-common-dev all 274 [73.0 kB] 583s Get:6 http://ftpmaster.internal/ubuntu plucky/main arm64 ssl-cert all 1.1.3ubuntu1 [18.7 kB] 583s Get:7 http://ftpmaster.internal/ubuntu plucky/main arm64 postgresql-common all 274 [101 kB] 583s Get:8 http://ftpmaster.internal/ubuntu plucky/main arm64 mysql-common all 5.8+1.1.1ubuntu1 [6922 B] 583s Get:9 http://ftpmaster.internal/ubuntu plucky/main arm64 libmysqlclient24 arm64 8.4.4-0ubuntu2 [1243 kB] 584s Get:10 http://ftpmaster.internal/ubuntu plucky/main arm64 libssl-dev arm64 3.4.1-1ubuntu1 [3287 kB] 586s Get:11 http://ftpmaster.internal/ubuntu plucky/main arm64 libzstd-dev arm64 1.5.6+dfsg-2 [353 kB] 587s Get:12 http://ftpmaster.internal/ubuntu plucky/main arm64 zlib1g-dev arm64 1:1.3.dfsg+really1.3.1-1ubuntu1 [894 kB] 587s Get:13 http://ftpmaster.internal/ubuntu plucky/main arm64 libmysqlclient-dev arm64 8.4.4-0ubuntu2 [1653 kB] 589s Get:14 http://ftpmaster.internal/ubuntu plucky/main arm64 default-libmysqlclient-dev arm64 1.1.1ubuntu1 [3300 B] 589s Get:15 http://ftpmaster.internal/ubuntu plucky/main arm64 libllvm20 arm64 1:20.1.0~+rc2-1~exp2ubuntu0.4 [29.1 MB] 616s Get:16 http://ftpmaster.internal/ubuntu plucky/main arm64 libpq5 arm64 17.4-1 [142 kB] 616s Get:17 http://ftpmaster.internal/ubuntu plucky/main arm64 libxslt1.1 arm64 1.1.39-0exp1ubuntu2 [168 kB] 616s Get:18 http://ftpmaster.internal/ubuntu plucky/main arm64 postgresql-client-17 arm64 17.4-1 [1342 kB] 617s Get:19 http://ftpmaster.internal/ubuntu plucky/main arm64 postgresql-17 arm64 17.4-1 [15.6 MB] 631s Get:20 http://ftpmaster.internal/ubuntu plucky/universe arm64 postgresql-17-mysql-fdw arm64 2.9.2-2build1 [131 kB] 632s Preconfiguring packages ... 632s Fetched 54.4 MB in 49s (1103 kB/s) 632s Selecting previously unselected package libjson-perl. 632s (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 ... 81647 files and directories currently installed.) 632s Preparing to unpack .../00-libjson-perl_4.10000-1_all.deb ... 632s Unpacking libjson-perl (4.10000-1) ... 632s Selecting previously unselected package postgresql-client-common. 632s Preparing to unpack .../01-postgresql-client-common_274_all.deb ... 632s Unpacking postgresql-client-common (274) ... 632s Selecting previously unselected package libio-pty-perl. 632s Preparing to unpack .../02-libio-pty-perl_1%3a1.20-1build3_arm64.deb ... 632s Unpacking libio-pty-perl (1:1.20-1build3) ... 632s Selecting previously unselected package libipc-run-perl. 632s Preparing to unpack .../03-libipc-run-perl_20231003.0-2_all.deb ... 632s Unpacking libipc-run-perl (20231003.0-2) ... 632s Selecting previously unselected package postgresql-common-dev. 632s Preparing to unpack .../04-postgresql-common-dev_274_all.deb ... 632s Unpacking postgresql-common-dev (274) ... 632s Selecting previously unselected package ssl-cert. 632s Preparing to unpack .../05-ssl-cert_1.1.3ubuntu1_all.deb ... 632s Unpacking ssl-cert (1.1.3ubuntu1) ... 632s Selecting previously unselected package postgresql-common. 632s Preparing to unpack .../06-postgresql-common_274_all.deb ... 632s Adding 'diversion of /usr/bin/pg_config to /usr/bin/pg_config.libpq-dev by postgresql-common' 632s Unpacking postgresql-common (274) ... 632s Selecting previously unselected package mysql-common. 632s Preparing to unpack .../07-mysql-common_5.8+1.1.1ubuntu1_all.deb ... 632s Unpacking mysql-common (5.8+1.1.1ubuntu1) ... 632s Selecting previously unselected package libmysqlclient24:arm64. 632s Preparing to unpack .../08-libmysqlclient24_8.4.4-0ubuntu2_arm64.deb ... 632s Unpacking libmysqlclient24:arm64 (8.4.4-0ubuntu2) ... 632s Selecting previously unselected package libssl-dev:arm64. 632s Preparing to unpack .../09-libssl-dev_3.4.1-1ubuntu1_arm64.deb ... 632s Unpacking libssl-dev:arm64 (3.4.1-1ubuntu1) ... 633s Selecting previously unselected package libzstd-dev:arm64. 633s Preparing to unpack .../10-libzstd-dev_1.5.6+dfsg-2_arm64.deb ... 633s Unpacking libzstd-dev:arm64 (1.5.6+dfsg-2) ... 633s Selecting previously unselected package zlib1g-dev:arm64. 633s Preparing to unpack .../11-zlib1g-dev_1%3a1.3.dfsg+really1.3.1-1ubuntu1_arm64.deb ... 633s Unpacking zlib1g-dev:arm64 (1:1.3.dfsg+really1.3.1-1ubuntu1) ... 633s Selecting previously unselected package libmysqlclient-dev. 633s Preparing to unpack .../12-libmysqlclient-dev_8.4.4-0ubuntu2_arm64.deb ... 633s Unpacking libmysqlclient-dev (8.4.4-0ubuntu2) ... 633s Selecting previously unselected package default-libmysqlclient-dev:arm64. 633s Preparing to unpack .../13-default-libmysqlclient-dev_1.1.1ubuntu1_arm64.deb ... 633s Unpacking default-libmysqlclient-dev:arm64 (1.1.1ubuntu1) ... 633s Selecting previously unselected package libllvm20:arm64. 633s Preparing to unpack .../14-libllvm20_1%3a20.1.0~+rc2-1~exp2ubuntu0.4_arm64.deb ... 633s Unpacking libllvm20:arm64 (1:20.1.0~+rc2-1~exp2ubuntu0.4) ... 634s Selecting previously unselected package libpq5:arm64. 634s Preparing to unpack .../15-libpq5_17.4-1_arm64.deb ... 634s Unpacking libpq5:arm64 (17.4-1) ... 634s Selecting previously unselected package libxslt1.1:arm64. 634s Preparing to unpack .../16-libxslt1.1_1.1.39-0exp1ubuntu2_arm64.deb ... 634s Unpacking libxslt1.1:arm64 (1.1.39-0exp1ubuntu2) ... 634s Selecting previously unselected package postgresql-client-17. 634s Preparing to unpack .../17-postgresql-client-17_17.4-1_arm64.deb ... 634s Unpacking postgresql-client-17 (17.4-1) ... 634s Selecting previously unselected package postgresql-17. 634s Preparing to unpack .../18-postgresql-17_17.4-1_arm64.deb ... 634s Unpacking postgresql-17 (17.4-1) ... 634s Selecting previously unselected package postgresql-17-mysql-fdw. 634s Preparing to unpack .../19-postgresql-17-mysql-fdw_2.9.2-2build1_arm64.deb ... 634s Unpacking postgresql-17-mysql-fdw (2.9.2-2build1) ... 634s Setting up postgresql-client-common (274) ... 634s Setting up mysql-common (5.8+1.1.1ubuntu1) ... 634s update-alternatives: using /etc/mysql/my.cnf.fallback to provide /etc/mysql/my.cnf (my.cnf) in auto mode 634s Setting up libzstd-dev:arm64 (1.5.6+dfsg-2) ... 634s Setting up libio-pty-perl (1:1.20-1build3) ... 634s Setting up libpq5:arm64 (17.4-1) ... 634s Setting up libmysqlclient24:arm64 (8.4.4-0ubuntu2) ... 634s Setting up ssl-cert (1.1.3ubuntu1) ... 635s Created symlink '/etc/systemd/system/multi-user.target.wants/ssl-cert.service' → '/usr/lib/systemd/system/ssl-cert.service'. 635s Setting up libssl-dev:arm64 (3.4.1-1ubuntu1) ... 635s Setting up libllvm20:arm64 (1:20.1.0~+rc2-1~exp2ubuntu0.4) ... 635s Setting up libipc-run-perl (20231003.0-2) ... 635s Setting up zlib1g-dev:arm64 (1:1.3.dfsg+really1.3.1-1ubuntu1) ... 635s Setting up libjson-perl (4.10000-1) ... 635s Setting up libxslt1.1:arm64 (1.1.39-0exp1ubuntu2) ... 635s Setting up libmysqlclient-dev (8.4.4-0ubuntu2) ... 635s Setting up postgresql-common-dev (274) ... 635s Setting up default-libmysqlclient-dev:arm64 (1.1.1ubuntu1) ... 635s Setting up postgresql-client-17 (17.4-1) ... 636s 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 636s Setting up postgresql-common (274) ... 636s Creating config file /etc/postgresql-common/createcluster.conf with new version 636s Building PostgreSQL dictionaries from installed myspell/hunspell packages... 636s Removing obsolete dictionary files: 637s Created symlink '/etc/systemd/system/multi-user.target.wants/postgresql.service' → '/usr/lib/systemd/system/postgresql.service'. 637s Setting up postgresql-17 (17.4-1) ... 638s Creating new PostgreSQL cluster 17/main ... 638s /usr/lib/postgresql/17/bin/initdb -D /var/lib/postgresql/17/main --auth-local peer --auth-host scram-sha-256 --no-instructions 638s The files belonging to this database system will be owned by user "postgres". 638s This user must also own the server process. 638s 638s The database cluster will be initialized with locale "C.UTF-8". 638s The default database encoding has accordingly been set to "UTF8". 638s The default text search configuration will be set to "english". 638s 638s Data page checksums are disabled. 638s 638s fixing permissions on existing directory /var/lib/postgresql/17/main ... ok 638s creating subdirectories ... ok 638s selecting dynamic shared memory implementation ... posix 638s selecting default "max_connections" ... 100 638s selecting default "shared_buffers" ... 128MB 638s selecting default time zone ... Etc/UTC 638s creating configuration files ... ok 638s running bootstrap script ... ok 639s performing post-bootstrap initialization ... ok 639s syncing data to disk ... ok 642s Setting up postgresql-17-mysql-fdw (2.9.2-2build1) ... 642s Processing triggers for libc-bin (2.41-1ubuntu2) ... 642s Processing triggers for man-db (2.13.0-1) ... 646s autopkgtest [14:38:18]: test create-extension: [----------------------- 646s ### PostgreSQL 17 psql ### 646s Creating new PostgreSQL cluster 17/regress ... 649s create extension mysql_fdw 649s CREATE EXTENSION 649s Dropping cluster 17/regress ... 649s ### End 17 psql ### 649s autopkgtest [14:38:21]: test create-extension: -----------------------] 650s create-extension PASS (superficial) 650s autopkgtest [14:38:22]: test create-extension: - - - - - - - - - - results - - - - - - - - - - 650s autopkgtest [14:38:22]: @@@@@@@@@@@@@@@@@@@@ summary 650s installcheck FLAKY non-zero exit status 1 650s create-extension PASS (superficial) 668s nova [W] Using flock in prodstack6-arm64 668s Creating nova instance adt-plucky-arm64-postgresql-mysql-fdw-20250315-142732-juju-7f2275-prod-proposed-migration-environment-15-776d20d6-c6bf-494c-81d7-038e3d0f2981 from image adt/ubuntu-plucky-arm64-server-20250315.img (UUID bd6e766c-b51f-4b53-86d6-23aa4d18f524)... 668s nova [W] Timed out waiting for 530573d9-2b81-4566-a183-7d7f34d6f1f3 to get deleted. 668s nova [W] Using flock in prodstack6-arm64 668s Creating nova instance adt-plucky-arm64-postgresql-mysql-fdw-20250315-142732-juju-7f2275-prod-proposed-migration-environment-15-776d20d6-c6bf-494c-81d7-038e3d0f2981 from image adt/ubuntu-plucky-arm64-server-20250315.img (UUID bd6e766c-b51f-4b53-86d6-23aa4d18f524)... 668s nova [W] Timed out waiting for eba32bb8-46d3-4cd9-a95f-df3825fd634c to get deleted.