0s autopkgtest [15:46:23]: starting date and time: 2025-03-15 15:46:23+0000 0s autopkgtest [15:46:23]: git checkout: 325255d2 Merge branch 'pin-any-arch' into 'ubuntu/production' 0s autopkgtest [15:46:23]: host juju-7f2275-prod-proposed-migration-environment-2; command line: /home/ubuntu/autopkgtest/runner/autopkgtest --output-dir /tmp/autopkgtest-work.lie8e8rm/out --timeout-copy=6000 --setup-commands /home/ubuntu/autopkgtest-cloud/worker-config-production/setup-canonical.sh --apt-pocket=proposed=src:glibc --apt-upgrade mysql-8.4 --timeout-short=300 --timeout-copy=20000 --timeout-test=20000 --timeout-build=20000 --env=ADT_TEST_TRIGGERS=glibc/2.41-1ubuntu2 -- ssh -s /home/ubuntu/autopkgtest/ssh-setup/nova -- --flavor autopkgtest-big-s390x --security-groups autopkgtest-juju-7f2275-prod-proposed-migration-environment-2@bos03-s390x-12.secgroup --name adt-plucky-s390x-mysql-8.4-20250315-154623-juju-7f2275-prod-proposed-migration-environment-2-4120a1ef-f5fe-4555-b1ea-716cfb556434 --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/ 108s autopkgtest [15:48:11]: testbed dpkg architecture: s390x 108s autopkgtest [15:48:11]: testbed apt version: 2.9.33 108s autopkgtest [15:48:11]: @@@@@@@@@@@@@@@@@@@@ test bed setup 108s autopkgtest [15:48:11]: testbed release detected to be: None 109s autopkgtest [15:48:12]: updating testbed package index (apt update) 109s Get:1 http://ftpmaster.internal/ubuntu plucky-proposed InRelease [126 kB] 110s Hit:2 http://ftpmaster.internal/ubuntu plucky InRelease 110s Hit:3 http://ftpmaster.internal/ubuntu plucky-updates InRelease 110s Hit:4 http://ftpmaster.internal/ubuntu plucky-security InRelease 110s Get:5 http://ftpmaster.internal/ubuntu plucky-proposed/universe Sources [379 kB] 110s Get:6 http://ftpmaster.internal/ubuntu plucky-proposed/multiverse Sources [15.8 kB] 110s Get:7 http://ftpmaster.internal/ubuntu plucky-proposed/main Sources [99.7 kB] 111s Get:8 http://ftpmaster.internal/ubuntu plucky-proposed/main s390x Packages [113 kB] 111s Get:9 http://ftpmaster.internal/ubuntu plucky-proposed/main s390x c-n-f Metadata [1824 B] 111s Get:10 http://ftpmaster.internal/ubuntu plucky-proposed/restricted s390x c-n-f Metadata [116 B] 111s Get:11 http://ftpmaster.internal/ubuntu plucky-proposed/universe s390x Packages [320 kB] 111s Get:12 http://ftpmaster.internal/ubuntu plucky-proposed/universe s390x c-n-f Metadata [13.4 kB] 111s Get:13 http://ftpmaster.internal/ubuntu plucky-proposed/multiverse s390x Packages [3776 B] 111s Get:14 http://ftpmaster.internal/ubuntu plucky-proposed/multiverse s390x c-n-f Metadata [240 B] 111s Fetched 1073 kB in 2s (591 kB/s) 112s Reading package lists... 112s Reading package lists... 113s Building dependency tree... 113s Reading state information... 113s Calculating upgrade... 113s Calculating upgrade... 113s The following packages were automatically installed and are no longer required: 113s libnsl2 libpython3.12-minimal libpython3.12-stdlib libpython3.12t64 113s linux-headers-6.11.0-8 linux-headers-6.11.0-8-generic 113s linux-modules-6.11.0-8-generic linux-tools-6.11.0-8 113s linux-tools-6.11.0-8-generic 113s Use 'sudo apt autoremove' to remove them. 113s The following packages will be upgraded: 113s pinentry-curses python3-jinja2 strace 113s 3 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 113s Need to get 652 kB of archives. 113s After this operation, 27.6 kB of additional disk space will be used. 113s Get:1 http://ftpmaster.internal/ubuntu plucky/main s390x strace s390x 6.13+ds-1ubuntu1 [500 kB] 114s Get:2 http://ftpmaster.internal/ubuntu plucky/main s390x pinentry-curses s390x 1.3.1-2ubuntu3 [42.9 kB] 114s Get:3 http://ftpmaster.internal/ubuntu plucky/main s390x python3-jinja2 all 3.1.5-2ubuntu1 [109 kB] 114s Fetched 652 kB in 1s (635 kB/s) 114s (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.) 114s Preparing to unpack .../strace_6.13+ds-1ubuntu1_s390x.deb ... 114s Unpacking strace (6.13+ds-1ubuntu1) over (6.11-0ubuntu1) ... 114s Preparing to unpack .../pinentry-curses_1.3.1-2ubuntu3_s390x.deb ... 114s Unpacking pinentry-curses (1.3.1-2ubuntu3) over (1.3.1-2ubuntu2) ... 114s Preparing to unpack .../python3-jinja2_3.1.5-2ubuntu1_all.deb ... 114s Unpacking python3-jinja2 (3.1.5-2ubuntu1) over (3.1.5-2) ... 114s Setting up pinentry-curses (1.3.1-2ubuntu3) ... 114s Setting up python3-jinja2 (3.1.5-2ubuntu1) ... 114s Setting up strace (6.13+ds-1ubuntu1) ... 114s Processing triggers for man-db (2.13.0-1) ... 115s Reading package lists... 115s Building dependency tree... 115s Reading state information... 115s Solving dependencies... 115s The following packages will be REMOVED: 115s libnsl2* libpython3.12-minimal* libpython3.12-stdlib* libpython3.12t64* 115s linux-headers-6.11.0-8* linux-headers-6.11.0-8-generic* 115s linux-modules-6.11.0-8-generic* linux-tools-6.11.0-8* 115s linux-tools-6.11.0-8-generic* 116s 0 upgraded, 0 newly installed, 9 to remove and 5 not upgraded. 116s After this operation, 167 MB disk space will be freed. 116s (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.) 116s Removing linux-tools-6.11.0-8-generic (6.11.0-8.8) ... 116s Removing linux-tools-6.11.0-8 (6.11.0-8.8) ... 116s Removing libpython3.12t64:s390x (3.12.9-1) ... 116s Removing libpython3.12-stdlib:s390x (3.12.9-1) ... 116s Removing libnsl2:s390x (1.3.0-3build3) ... 116s Removing libpython3.12-minimal:s390x (3.12.9-1) ... 116s Removing linux-headers-6.11.0-8-generic (6.11.0-8.8) ... 116s Removing linux-headers-6.11.0-8 (6.11.0-8.8) ... 117s Removing linux-modules-6.11.0-8-generic (6.11.0-8.8) ... 117s Processing triggers for libc-bin (2.41-1ubuntu1) ... 117s (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.) 117s Purging configuration files for libpython3.12-minimal:s390x (3.12.9-1) ... 117s Purging configuration files for linux-modules-6.11.0-8-generic (6.11.0-8.8) ... 117s autopkgtest [15:48:20]: upgrading testbed (apt dist-upgrade and autopurge) 117s Reading package lists... 117s Building dependency tree... 117s Reading state information... 117s Calculating upgrade...Starting pkgProblemResolver with broken count: 0 117s Starting 2 pkgProblemResolver with broken count: 0 117s Done 118s Entering ResolveByKeep 118s 118s Calculating upgrade... 118s The following packages will be upgraded: 118s libc-bin libc-dev-bin libc6 libc6-dev locales 118s 5 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 118s Need to get 9512 kB of archives. 118s After this operation, 8192 B of additional disk space will be used. 118s Get:1 http://ftpmaster.internal/ubuntu plucky-proposed/main s390x libc6-dev s390x 2.41-1ubuntu2 [1678 kB] 120s Get:2 http://ftpmaster.internal/ubuntu plucky-proposed/main s390x libc-dev-bin s390x 2.41-1ubuntu2 [24.3 kB] 120s Get:3 http://ftpmaster.internal/ubuntu plucky-proposed/main s390x libc6 s390x 2.41-1ubuntu2 [2892 kB] 124s Get:4 http://ftpmaster.internal/ubuntu plucky-proposed/main s390x libc-bin s390x 2.41-1ubuntu2 [671 kB] 125s Get:5 http://ftpmaster.internal/ubuntu plucky-proposed/main s390x locales all 2.41-1ubuntu2 [4246 kB] 130s Preconfiguring packages ... 130s Fetched 9512 kB in 12s (803 kB/s) 130s (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.) 130s Preparing to unpack .../libc6-dev_2.41-1ubuntu2_s390x.deb ... 130s Unpacking libc6-dev:s390x (2.41-1ubuntu2) over (2.41-1ubuntu1) ... 130s Preparing to unpack .../libc-dev-bin_2.41-1ubuntu2_s390x.deb ... 130s Unpacking libc-dev-bin (2.41-1ubuntu2) over (2.41-1ubuntu1) ... 130s Preparing to unpack .../libc6_2.41-1ubuntu2_s390x.deb ... 130s Unpacking libc6:s390x (2.41-1ubuntu2) over (2.41-1ubuntu1) ... 130s Setting up libc6:s390x (2.41-1ubuntu2) ... 130s (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.) 130s Preparing to unpack .../libc-bin_2.41-1ubuntu2_s390x.deb ... 130s Unpacking libc-bin (2.41-1ubuntu2) over (2.41-1ubuntu1) ... 130s Setting up libc-bin (2.41-1ubuntu2) ... 130s (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.) 130s Preparing to unpack .../locales_2.41-1ubuntu2_all.deb ... 130s Unpacking locales (2.41-1ubuntu2) over (2.41-1ubuntu1) ... 130s Setting up locales (2.41-1ubuntu2) ... 131s Generating locales (this might take a while)... 132s en_US.UTF-8... done 132s Generation complete. 132s Setting up libc-dev-bin (2.41-1ubuntu2) ... 132s Setting up libc6-dev:s390x (2.41-1ubuntu2) ... 132s Processing triggers for man-db (2.13.0-1) ... 132s Processing triggers for systemd (257.3-1ubuntu3) ... 133s Reading package lists... 133s Building dependency tree... 133s Reading state information... 133s Starting pkgProblemResolver with broken count: 0 133s Starting 2 pkgProblemResolver with broken count: 0 133s Done 134s Solving dependencies... 134s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 134s autopkgtest [15:48:37]: rebooting testbed after setup commands that affected boot 154s autopkgtest [15:48:57]: testbed running kernel: Linux 6.14.0-10-generic #10-Ubuntu SMP Wed Mar 12 14:53:49 UTC 2025 156s autopkgtest [15:48:59]: @@@@@@@@@@@@@@@@@@@@ apt-source mysql-8.4 673s Get:1 http://ftpmaster.internal/ubuntu plucky/main mysql-8.4 8.4.4-0ubuntu2 (dsc) [3768 B] 673s Get:2 http://ftpmaster.internal/ubuntu plucky/main mysql-8.4 8.4.4-0ubuntu2 (tar) [465 MB] 673s Get:3 http://ftpmaster.internal/ubuntu plucky/main mysql-8.4 8.4.4-0ubuntu2 (asc) [833 B] 673s Get:4 http://ftpmaster.internal/ubuntu plucky/main mysql-8.4 8.4.4-0ubuntu2 (diff) [134 kB] 674s gpgv: Signature made Fri Feb 21 04:17:29 2025 UTC 674s gpgv: using RSA key 63EEFC3DE14D5146CE7F24BF34B8AD7D9529E793 674s gpgv: issuer "lena.voytek@canonical.com" 674s gpgv: Can't check signature: No public key 674s dpkg-source: warning: cannot verify inline signature for ./mysql-8.4_8.4.4-0ubuntu2.dsc: no acceptable signature found 680s autopkgtest [15:57:43]: testing package mysql-8.4 version 8.4.4-0ubuntu2 681s autopkgtest [15:57:44]: build not needed 731s autopkgtest [15:58:34]: test smoke: preparing testbed 732s Reading package lists... 732s Building dependency tree... 732s Reading state information... 732s Starting pkgProblemResolver with broken count: 0 732s Starting 2 pkgProblemResolver with broken count: 0 732s Done 732s The following NEW packages will be installed: 732s libmecab2 libprotobuf-lite32t64 mysql-client mysql-client-core mysql-common 732s mysql-server mysql-server-core 732s 0 upgraded, 7 newly installed, 0 to remove and 0 not upgraded. 732s Need to get 24.2 MB of archives. 732s After this operation, 182 MB of additional disk space will be used. 732s Get:1 http://ftpmaster.internal/ubuntu plucky/main s390x mysql-common all 5.8+1.1.1ubuntu1 [6922 B] 732s Get:2 http://ftpmaster.internal/ubuntu plucky/main s390x mysql-client-core s390x 8.4.4-0ubuntu2 [2222 kB] 735s Get:3 http://ftpmaster.internal/ubuntu plucky/main s390x mysql-client s390x 8.4.4-0ubuntu2 [9122 B] 735s Get:4 http://ftpmaster.internal/ubuntu plucky/main s390x libmecab2 s390x 0.996-15.1build2 [214 kB] 735s Get:5 http://ftpmaster.internal/ubuntu plucky/main s390x libprotobuf-lite32t64 s390x 3.21.12-10build2 [238 kB] 735s Get:6 http://ftpmaster.internal/ubuntu plucky/main s390x mysql-server-core s390x 8.4.4-0ubuntu2 [20.1 MB] 757s Get:7 http://ftpmaster.internal/ubuntu plucky/main s390x mysql-server s390x 8.4.4-0ubuntu2 [1369 kB] 758s Preconfiguring packages ... 759s Fetched 24.2 MB in 26s (922 kB/s) 759s Selecting previously unselected package mysql-common. 759s (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.) 759s Preparing to unpack .../0-mysql-common_5.8+1.1.1ubuntu1_all.deb ... 759s Unpacking mysql-common (5.8+1.1.1ubuntu1) ... 759s Selecting previously unselected package mysql-client-core. 759s Preparing to unpack .../1-mysql-client-core_8.4.4-0ubuntu2_s390x.deb ... 759s Unpacking mysql-client-core (8.4.4-0ubuntu2) ... 759s Selecting previously unselected package mysql-client. 759s Preparing to unpack .../2-mysql-client_8.4.4-0ubuntu2_s390x.deb ... 759s Unpacking mysql-client (8.4.4-0ubuntu2) ... 759s Selecting previously unselected package libmecab2:s390x. 759s Preparing to unpack .../3-libmecab2_0.996-15.1build2_s390x.deb ... 759s Unpacking libmecab2:s390x (0.996-15.1build2) ... 759s Selecting previously unselected package libprotobuf-lite32t64:s390x. 759s Preparing to unpack .../4-libprotobuf-lite32t64_3.21.12-10build2_s390x.deb ... 759s Unpacking libprotobuf-lite32t64:s390x (3.21.12-10build2) ... 759s Selecting previously unselected package mysql-server-core. 759s Preparing to unpack .../5-mysql-server-core_8.4.4-0ubuntu2_s390x.deb ... 759s Unpacking mysql-server-core (8.4.4-0ubuntu2) ... 759s Setting up mysql-common (5.8+1.1.1ubuntu1) ... 759s update-alternatives: using /etc/mysql/my.cnf.fallback to provide /etc/mysql/my.cnf (my.cnf) in auto mode 759s Selecting previously unselected package mysql-server. 759s (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.) 760s Preparing to unpack .../mysql-server_8.4.4-0ubuntu2_s390x.deb ... 760s Unpacking mysql-server (8.4.4-0ubuntu2) ... 760s Setting up libprotobuf-lite32t64:s390x (3.21.12-10build2) ... 760s Setting up libmecab2:s390x (0.996-15.1build2) ... 760s Setting up mysql-server-core (8.4.4-0ubuntu2) ... 760s Setting up mysql-client-core (8.4.4-0ubuntu2) ... 760s Setting up mysql-client (8.4.4-0ubuntu2) ... 760s Setting up mysql-server (8.4.4-0ubuntu2) ... 760s update-alternatives: using /etc/mysql/mysql.cnf to provide /etc/mysql/my.cnf (my.cnf) in auto mode 760s Renaming removed key_buffer and myisam-recover options (if present) 765s Created symlink '/etc/systemd/system/multi-user.target.wants/mysql.service' → '/usr/lib/systemd/system/mysql.service'. 766s Processing triggers for man-db (2.13.0-1) ... 767s Processing triggers for libc-bin (2.41-1ubuntu2) ... 768s autopkgtest [15:59:11]: test smoke: [----------------------- 768s + debconf-set-selections 768s + DEBIAN_FRONTEND=noninteractive dpkg-reconfigure mysql-server 773s + mysql --user=root --password=rootpassword 773s mysql: [Warning] Using a password on the command line interface can be insecure. 773s + mysql --user=testuser --password=testpassword testdatabase 773s mysql: [Warning] Using a password on the command line interface can be insecure. 773s + echo SELECT bar+1 FROM foo; 773s + mysql --batch --skip-column-names --user=testuser --password=testpassword testdatabase 773s mysql: [Warning] Using a password on the command line interface can be insecure. 773s + result=42 773s + [ 42 != 42 ] 773s + mysql --user=testuser --password=testpassword testdatabase 773s mysql: [Warning] Using a password on the command line interface can be insecure. 773s + mysql --user=root --password=rootpassword 773s mysql: [Warning] Using a password on the command line interface can be insecure. 773s autopkgtest [15:59:16]: test smoke: -----------------------] 774s smoke PASS 774s autopkgtest [15:59:17]: test smoke: - - - - - - - - - - results - - - - - - - - - - 774s autopkgtest [15:59:17]: test upstream: preparing testbed 872s autopkgtest [16:00:55]: testbed dpkg architecture: s390x 872s autopkgtest [16:00:55]: testbed apt version: 2.9.33 872s autopkgtest [16:00:55]: @@@@@@@@@@@@@@@@@@@@ test bed setup 873s autopkgtest [16:00:56]: testbed release detected to be: plucky 873s autopkgtest [16:00:56]: updating testbed package index (apt update) 874s Get:1 http://ftpmaster.internal/ubuntu plucky-proposed InRelease [126 kB] 874s Hit:2 http://ftpmaster.internal/ubuntu plucky InRelease 874s Hit:3 http://ftpmaster.internal/ubuntu plucky-updates InRelease 874s Hit:4 http://ftpmaster.internal/ubuntu plucky-security InRelease 874s Get:5 http://ftpmaster.internal/ubuntu plucky-proposed/multiverse Sources [15.8 kB] 874s Get:6 http://ftpmaster.internal/ubuntu plucky-proposed/universe Sources [379 kB] 875s Get:7 http://ftpmaster.internal/ubuntu plucky-proposed/main Sources [99.7 kB] 875s Get:8 http://ftpmaster.internal/ubuntu plucky-proposed/main s390x Packages [113 kB] 875s Get:9 http://ftpmaster.internal/ubuntu plucky-proposed/main s390x c-n-f Metadata [1824 B] 875s Get:10 http://ftpmaster.internal/ubuntu plucky-proposed/restricted s390x c-n-f Metadata [116 B] 875s Get:11 http://ftpmaster.internal/ubuntu plucky-proposed/universe s390x Packages [320 kB] 875s Get:12 http://ftpmaster.internal/ubuntu plucky-proposed/universe s390x c-n-f Metadata [13.4 kB] 875s Get:13 http://ftpmaster.internal/ubuntu plucky-proposed/multiverse s390x Packages [3776 B] 875s Get:14 http://ftpmaster.internal/ubuntu plucky-proposed/multiverse s390x c-n-f Metadata [240 B] 875s Fetched 1073 kB in 2s (610 kB/s) 876s Reading package lists... 877s Reading package lists... 877s Building dependency tree... 877s Reading state information... 877s Calculating upgrade... 877s Calculating upgrade... 877s The following packages were automatically installed and are no longer required: 877s libnsl2 libpython3.12-minimal libpython3.12-stdlib libpython3.12t64 877s linux-headers-6.11.0-8 linux-headers-6.11.0-8-generic 877s linux-modules-6.11.0-8-generic linux-tools-6.11.0-8 877s linux-tools-6.11.0-8-generic 877s Use 'sudo apt autoremove' to remove them. 877s The following packages will be upgraded: 877s pinentry-curses python3-jinja2 strace 877s 3 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 877s Need to get 652 kB of archives. 877s After this operation, 27.6 kB of additional disk space will be used. 877s Get:1 http://ftpmaster.internal/ubuntu plucky/main s390x strace s390x 6.13+ds-1ubuntu1 [500 kB] 878s Get:2 http://ftpmaster.internal/ubuntu plucky/main s390x pinentry-curses s390x 1.3.1-2ubuntu3 [42.9 kB] 878s Get:3 http://ftpmaster.internal/ubuntu plucky/main s390x python3-jinja2 all 3.1.5-2ubuntu1 [109 kB] 879s Fetched 652 kB in 1s (485 kB/s) 879s (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.) 879s Preparing to unpack .../strace_6.13+ds-1ubuntu1_s390x.deb ... 879s Unpacking strace (6.13+ds-1ubuntu1) over (6.11-0ubuntu1) ... 879s Preparing to unpack .../pinentry-curses_1.3.1-2ubuntu3_s390x.deb ... 879s Unpacking pinentry-curses (1.3.1-2ubuntu3) over (1.3.1-2ubuntu2) ... 879s Preparing to unpack .../python3-jinja2_3.1.5-2ubuntu1_all.deb ... 879s Unpacking python3-jinja2 (3.1.5-2ubuntu1) over (3.1.5-2) ... 879s Setting up pinentry-curses (1.3.1-2ubuntu3) ... 879s Setting up python3-jinja2 (3.1.5-2ubuntu1) ... 879s Setting up strace (6.13+ds-1ubuntu1) ... 879s Processing triggers for man-db (2.13.0-1) ... 880s Reading package lists... 880s Building dependency tree... 880s Reading state information... 880s Solving dependencies... 880s The following packages will be REMOVED: 880s libnsl2* libpython3.12-minimal* libpython3.12-stdlib* libpython3.12t64* 880s linux-headers-6.11.0-8* linux-headers-6.11.0-8-generic* 880s linux-modules-6.11.0-8-generic* linux-tools-6.11.0-8* 880s linux-tools-6.11.0-8-generic* 880s 0 upgraded, 0 newly installed, 9 to remove and 5 not upgraded. 880s After this operation, 167 MB disk space will be freed. 880s (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.) 880s Removing linux-tools-6.11.0-8-generic (6.11.0-8.8) ... 880s Removing linux-tools-6.11.0-8 (6.11.0-8.8) ... 880s Removing libpython3.12t64:s390x (3.12.9-1) ... 880s Removing libpython3.12-stdlib:s390x (3.12.9-1) ... 880s Removing libnsl2:s390x (1.3.0-3build3) ... 880s Removing libpython3.12-minimal:s390x (3.12.9-1) ... 880s Removing linux-headers-6.11.0-8-generic (6.11.0-8.8) ... 880s Removing linux-headers-6.11.0-8 (6.11.0-8.8) ... 881s Removing linux-modules-6.11.0-8-generic (6.11.0-8.8) ... 881s Processing triggers for libc-bin (2.41-1ubuntu1) ... 881s (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.) 881s Purging configuration files for libpython3.12-minimal:s390x (3.12.9-1) ... 881s Purging configuration files for linux-modules-6.11.0-8-generic (6.11.0-8.8) ... 881s autopkgtest [16:01:04]: upgrading testbed (apt dist-upgrade and autopurge) 882s Reading package lists... 882s Building dependency tree... 882s Reading state information... 882s Calculating upgrade...Starting pkgProblemResolver with broken count: 0 882s Starting 2 pkgProblemResolver with broken count: 0 882s Done 882s Entering ResolveByKeep 882s 882s Calculating upgrade... 882s The following packages will be upgraded: 882s libc-bin libc-dev-bin libc6 libc6-dev locales 883s 5 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 883s Need to get 9512 kB of archives. 883s After this operation, 8192 B of additional disk space will be used. 883s Get:1 http://ftpmaster.internal/ubuntu plucky-proposed/main s390x libc6-dev s390x 2.41-1ubuntu2 [1678 kB] 885s Get:2 http://ftpmaster.internal/ubuntu plucky-proposed/main s390x libc-dev-bin s390x 2.41-1ubuntu2 [24.3 kB] 885s Get:3 http://ftpmaster.internal/ubuntu plucky-proposed/main s390x libc6 s390x 2.41-1ubuntu2 [2892 kB] 888s Get:4 http://ftpmaster.internal/ubuntu plucky-proposed/main s390x libc-bin s390x 2.41-1ubuntu2 [671 kB] 889s Get:5 http://ftpmaster.internal/ubuntu plucky-proposed/main s390x locales all 2.41-1ubuntu2 [4246 kB] 894s Preconfiguring packages ... 894s Fetched 9512 kB in 12s (812 kB/s) 895s (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.) 895s Preparing to unpack .../libc6-dev_2.41-1ubuntu2_s390x.deb ... 895s Unpacking libc6-dev:s390x (2.41-1ubuntu2) over (2.41-1ubuntu1) ... 895s Preparing to unpack .../libc-dev-bin_2.41-1ubuntu2_s390x.deb ... 895s Unpacking libc-dev-bin (2.41-1ubuntu2) over (2.41-1ubuntu1) ... 895s Preparing to unpack .../libc6_2.41-1ubuntu2_s390x.deb ... 895s Unpacking libc6:s390x (2.41-1ubuntu2) over (2.41-1ubuntu1) ... 895s Setting up libc6:s390x (2.41-1ubuntu2) ... 895s (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.) 895s Preparing to unpack .../libc-bin_2.41-1ubuntu2_s390x.deb ... 895s Unpacking libc-bin (2.41-1ubuntu2) over (2.41-1ubuntu1) ... 895s Setting up libc-bin (2.41-1ubuntu2) ... 895s (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.) 895s Preparing to unpack .../locales_2.41-1ubuntu2_all.deb ... 895s Unpacking locales (2.41-1ubuntu2) over (2.41-1ubuntu1) ... 895s Setting up locales (2.41-1ubuntu2) ... 895s Generating locales (this might take a while)... 896s en_US.UTF-8... done 896s Generation complete. 896s Setting up libc-dev-bin (2.41-1ubuntu2) ... 896s Setting up libc6-dev:s390x (2.41-1ubuntu2) ... 896s Processing triggers for man-db (2.13.0-1) ... 897s Processing triggers for systemd (257.3-1ubuntu3) ... 898s Reading package lists... 898s Building dependency tree... 898s Reading state information... 898s Starting pkgProblemResolver with broken count: 0 898s Starting 2 pkgProblemResolver with broken count: 0 898s Done 898s Solving dependencies... 898s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 898s autopkgtest [16:01:21]: rebooting testbed after setup commands that affected boot 920s Reading package lists... 920s Building dependency tree... 920s Reading state information... 920s Starting pkgProblemResolver with broken count: 0 920s Starting 2 pkgProblemResolver with broken count: 0 920s Done 920s The following NEW packages will be installed: 920s libexpect-perl libio-pty-perl libio-stty-perl libjson-perl libmecab2 920s libprotobuf-lite32t64 libprotobuf32t64 lz4 mysql-client mysql-client-core 920s mysql-common mysql-server mysql-server-core mysql-testsuite unzip 920s 0 upgraded, 15 newly installed, 0 to remove and 0 not upgraded. 920s Need to get 406 MB of archives. 920s After this operation, 979 MB of additional disk space will be used. 920s Get:1 http://ftpmaster.internal/ubuntu plucky/main s390x mysql-common all 5.8+1.1.1ubuntu1 [6922 B] 920s Get:2 http://ftpmaster.internal/ubuntu plucky/main s390x mysql-client-core s390x 8.4.4-0ubuntu2 [2222 kB] 923s Get:3 http://ftpmaster.internal/ubuntu plucky/main s390x mysql-client s390x 8.4.4-0ubuntu2 [9122 B] 923s Get:4 http://ftpmaster.internal/ubuntu plucky/main s390x libmecab2 s390x 0.996-15.1build2 [214 kB] 923s Get:5 http://ftpmaster.internal/ubuntu plucky/main s390x libprotobuf-lite32t64 s390x 3.21.12-10build2 [238 kB] 923s Get:6 http://ftpmaster.internal/ubuntu plucky/main s390x mysql-server-core s390x 8.4.4-0ubuntu2 [20.1 MB] 946s Get:7 http://ftpmaster.internal/ubuntu plucky/main s390x mysql-server s390x 8.4.4-0ubuntu2 [1369 kB] 948s Get:8 http://ftpmaster.internal/ubuntu plucky/main s390x libio-pty-perl s390x 1:1.20-1build3 [31.6 kB] 948s Get:9 http://ftpmaster.internal/ubuntu plucky/universe s390x libio-stty-perl all 0.04-2 [13.4 kB] 948s Get:10 http://ftpmaster.internal/ubuntu plucky/universe s390x libexpect-perl all 1.38-1 [65.0 kB] 948s Get:11 http://ftpmaster.internal/ubuntu plucky/main s390x libjson-perl all 4.10000-1 [81.9 kB] 948s Get:12 http://ftpmaster.internal/ubuntu plucky/main s390x libprotobuf32t64 s390x 3.21.12-10build2 [943 kB] 949s Get:13 http://ftpmaster.internal/ubuntu plucky/universe s390x lz4 s390x 1.10.0-4 [53.0 kB] 949s Get:14 http://ftpmaster.internal/ubuntu plucky/main s390x unzip s390x 6.0-28ubuntu6 [186 kB] 950s Get:15 http://ftpmaster.internal/ubuntu plucky/universe s390x mysql-testsuite s390x 8.4.4-0ubuntu2 [380 MB] 1450s Preconfiguring packages ... 1450s Fetched 406 MB in 8min 49s (767 kB/s) 1450s Selecting previously unselected package mysql-common. 1450s (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.) 1450s Preparing to unpack .../0-mysql-common_5.8+1.1.1ubuntu1_all.deb ... 1450s Unpacking mysql-common (5.8+1.1.1ubuntu1) ... 1450s Selecting previously unselected package mysql-client-core. 1450s Preparing to unpack .../1-mysql-client-core_8.4.4-0ubuntu2_s390x.deb ... 1450s Unpacking mysql-client-core (8.4.4-0ubuntu2) ... 1450s Selecting previously unselected package mysql-client. 1450s Preparing to unpack .../2-mysql-client_8.4.4-0ubuntu2_s390x.deb ... 1450s Unpacking mysql-client (8.4.4-0ubuntu2) ... 1450s Selecting previously unselected package libmecab2:s390x. 1450s Preparing to unpack .../3-libmecab2_0.996-15.1build2_s390x.deb ... 1450s Unpacking libmecab2:s390x (0.996-15.1build2) ... 1450s Selecting previously unselected package libprotobuf-lite32t64:s390x. 1450s Preparing to unpack .../4-libprotobuf-lite32t64_3.21.12-10build2_s390x.deb ... 1450s Unpacking libprotobuf-lite32t64:s390x (3.21.12-10build2) ... 1450s Selecting previously unselected package mysql-server-core. 1450s Preparing to unpack .../5-mysql-server-core_8.4.4-0ubuntu2_s390x.deb ... 1450s Unpacking mysql-server-core (8.4.4-0ubuntu2) ... 1451s Setting up mysql-common (5.8+1.1.1ubuntu1) ... 1451s update-alternatives: using /etc/mysql/my.cnf.fallback to provide /etc/mysql/my.cnf (my.cnf) in auto mode 1451s Selecting previously unselected package mysql-server. 1451s (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.) 1451s Preparing to unpack .../0-mysql-server_8.4.4-0ubuntu2_s390x.deb ... 1451s Unpacking mysql-server (8.4.4-0ubuntu2) ... 1451s Selecting previously unselected package libio-pty-perl. 1451s Preparing to unpack .../1-libio-pty-perl_1%3a1.20-1build3_s390x.deb ... 1451s Unpacking libio-pty-perl (1:1.20-1build3) ... 1451s Selecting previously unselected package libio-stty-perl. 1451s Preparing to unpack .../2-libio-stty-perl_0.04-2_all.deb ... 1451s Unpacking libio-stty-perl (0.04-2) ... 1451s Selecting previously unselected package libexpect-perl. 1451s Preparing to unpack .../3-libexpect-perl_1.38-1_all.deb ... 1451s Unpacking libexpect-perl (1.38-1) ... 1451s Selecting previously unselected package libjson-perl. 1451s Preparing to unpack .../4-libjson-perl_4.10000-1_all.deb ... 1451s Unpacking libjson-perl (4.10000-1) ... 1451s Selecting previously unselected package libprotobuf32t64:s390x. 1451s Preparing to unpack .../5-libprotobuf32t64_3.21.12-10build2_s390x.deb ... 1451s Unpacking libprotobuf32t64:s390x (3.21.12-10build2) ... 1451s Selecting previously unselected package lz4. 1451s Preparing to unpack .../6-lz4_1.10.0-4_s390x.deb ... 1451s Unpacking lz4 (1.10.0-4) ... 1451s Selecting previously unselected package unzip. 1451s Preparing to unpack .../7-unzip_6.0-28ubuntu6_s390x.deb ... 1451s Unpacking unzip (6.0-28ubuntu6) ... 1451s Selecting previously unselected package mysql-testsuite. 1451s Preparing to unpack .../8-mysql-testsuite_8.4.4-0ubuntu2_s390x.deb ... 1451s Unpacking mysql-testsuite (8.4.4-0ubuntu2) ... 1454s Setting up libprotobuf-lite32t64:s390x (3.21.12-10build2) ... 1454s Setting up libmecab2:s390x (0.996-15.1build2) ... 1454s Setting up libprotobuf32t64:s390x (3.21.12-10build2) ... 1454s Setting up libio-stty-perl (0.04-2) ... 1454s Setting up libio-pty-perl (1:1.20-1build3) ... 1454s Setting up unzip (6.0-28ubuntu6) ... 1454s Setting up libexpect-perl (1.38-1) ... 1454s Setting up mysql-server-core (8.4.4-0ubuntu2) ... 1454s Setting up lz4 (1.10.0-4) ... 1454s Setting up mysql-client-core (8.4.4-0ubuntu2) ... 1454s Setting up libjson-perl (4.10000-1) ... 1454s Setting up mysql-client (8.4.4-0ubuntu2) ... 1454s Setting up mysql-server (8.4.4-0ubuntu2) ... 1454s update-alternatives: using /etc/mysql/mysql.cnf to provide /etc/mysql/my.cnf (my.cnf) in auto mode 1454s Renaming removed key_buffer and myisam-recover options (if present) 1459s Created symlink '/etc/systemd/system/multi-user.target.wants/mysql.service' → '/usr/lib/systemd/system/mysql.service'. 1460s Setting up mysql-testsuite (8.4.4-0ubuntu2) ... 1460s Processing triggers for man-db (2.13.0-1) ... 1461s Processing triggers for libc-bin (2.41-1ubuntu2) ... 1635s autopkgtest [16:13:38]: test upstream: [----------------------- 1636s running test 'testsuite' 1636s using vardir: /tmp/tmp.S4l2H0nLf2/var 1636s using tmpdir: /tmp/tmp.S4l2H0nLf2/tmp 1636s Setting up skip-tests-list 1636s starting mysql-test-run.pl... 1636s Logging: ./mysql-test-run.pl --suite=main --vardir=/tmp/tmp.S4l2H0nLf2/var --tmpdir=/tmp/tmp.S4l2H0nLf2/tmp --skip-ndbcluster --parallel=auto --skip-rpl --report-features --client-bindir=/usr/lib/mysql-test/bin/ --force --skip-test-list=/tmp/skip-test.lst --report-unstable-tests 1636s MySQL Version 8.4.4 1636s Checking supported features 1636s Using suite(s): main 1636s Collecting tests 1641s Removing old var directory 1641s Creating var directory '/tmp/tmp.S4l2H0nLf2/var' 1641s Installing system database 1644s Using parallel: 4 1644s 1644s ============================================================================== 1644s TEST NAME WORKER RESULT TIME (ms) COMMENT 1644s ------------------------------------------------------------------------------ 1645s [ 0%] main.myisam_row_rpl [ skipped ] No replication tests, --skip-rpl is enabled. 1645s [ 0%] main.server_offline_7 [ skipped ] No replication tests, --skip-rpl is enabled. 1645s [ 0%] main.all_persisted_variables [ skipped ] Test needs debug binaries. 1645s [ 0%] main.alter_debug [ skipped ] Test needs debug binaries. 1645s [ 0%] main.alter_table-big [ skipped ] Test needs 'big-test' or 'only-big-test' option. 1645s [ 0%] main.alter_table-big_myisam [ skipped ] Test needs 'big-test' or 'only-big-test' option. 1645s [ 0%] main.archive_debug [ skipped ] Test needs debug binaries. 1645s [ 0%] main.auth_rpl [ skipped ] No replication tests, --skip-rpl is enabled. 1645s [ 0%] main.big_packets [ skipped ] Test needs 'big-test' or 'only-big-test' option. 1645s [ 0%] main.big_packets_async [ skipped ] Test needs 'big-test' or 'only-big-test' option. 1645s [ 0%] main.big_packets_boundary [ skipped ] Test needs 'big-test' or 'only-big-test' option. 1645s [ 0%] main.big_packets_boundary_async [ skipped ] Test needs 'big-test' or 'only-big-test' option. 1645s [ 0%] main.bug12368203 [ skipped ] No replication tests, --skip-rpl is enabled. 1645s [ 0%] main.change_user_deadlock [ skipped ] Test needs 'big-test' or 'only-big-test' option. 1645s [ 1%] main.check_constraints_debug [ skipped ] Test needs debug binaries. 1645s [ 1%] main.component_debug [ skipped ] Test needs debug binaries. 1645s [ 1%] main.count_distinct3 [ skipped ] Test needs 'big-test' or 'only-big-test' option. 1645s [ 1%] main.create-big [ skipped ] Test needs 'big-test' or 'only-big-test' option. 1645s [ 1%] main.create_select_atomic [ skipped ] Test needs debug binaries. 1645s [ 1%] main.ctype_cp932_binlog_stm [ skipped ] Test needs 'big-test' or 'only-big-test' option. 1645s [ 1%] main.ctype_eucjpms [ skipped ] Test needs 'big-test' or 'only-big-test' option. 1645s [ 1%] main.ctype_euckr [ skipped ] Test needs 'big-test' or 'only-big-test' option. 1645s [ 1%] main.ctype_gb18030_conversion [ skipped ] Test needs 'big-test' or 'only-big-test' option. 1645s [ 1%] main.ctype_like_range [ skipped ] Test needs debug binaries. 1645s [ 1%] main.ctype_ujis [ skipped ] Test needs 'big-test' or 'only-big-test' option. 1645s [ 1%] main.ctype_unicode900_casetable [ skipped ] Test needs 'big-test' or 'only-big-test' option. 1645s [ 1%] main.dd_bootstrap [ skipped ] Test needs 'big-test' or 'only-big-test' option. 1645s [ 1%] main.dd_bootstrap_debug [ skipped ] Test needs 'big-test' or 'only-big-test' option. 1645s [ 1%] main.dd_debug [ skipped ] Test needs debug binaries. 1645s [ 2%] main.dd_debug_lowercase1 [ skipped ] Test needs debug binaries. 1645s [ 2%] main.dd_is_debug [ skipped ] Test needs debug binaries. 1645s [ 2%] main.dd_is_debug_myisam [ skipped ] Test needs debug binaries. 1645s [ 2%] main.dd_schema_dd_properties_debug [ skipped ] Test needs debug binaries. 1645s [ 2%] main.dd_schema_definition_after_upgrade_80_debug [ skipped ] Test needs 'big-test' or 'only-big-test' option. 1645s [ 2%] main.dd_schema_definition_debug [ skipped ] Test needs debug binaries. 1645s [ 2%] main.dd_table_access [ skipped ] Test needs debug binaries. 1645s [ 2%] main.dd_upgrade_cs [ skipped ] Test needs 'big-test' or 'only-big-test' option. 1645s [ 2%] main.dd_upgrade_error_debug [ skipped ] Test needs 'big-test' or 'only-big-test' option. 1645s [ 2%] main.dd_view_columns_debug [ skipped ] Test needs debug binaries. 1645s [ 2%] main.default_as_expr_debug [ skipped ] Test needs debug binaries. 1645s [ 2%] main.deprecation_56 [ skipped ] Test needs 'big-test' or 'only-big-test' option. 1645s [ 2%] main.disable_drop_rename_user [ skipped ] Test needs 'big-test' or 'only-big-test' option. 1645s [ 2%] main.drop_debug [ skipped ] Test needs debug binaries. 1645s [ 3%] main.ds_mrr-big [ skipped ] Test needs 'big-test' or 'only-big-test' option. 1645s [ 3%] main.engine_attribute_debug [ skipped ] Test needs debug binaries. 1645s [ 3%] main.eq_range_idx_stat [ skipped ] Test needs debug binaries. 1645s [ 3%] main.error_simulation [ skipped ] Test needs debug binaries. 1645s [ 3%] main.events_bugs_debug [ skipped ] Test needs debug binaries. 1645s [ 3%] main.events_sql_mode [ skipped ] Test needs debug binaries. 1645s [ 3%] main.events_stress [ skipped ] Test needs 'big-test' or 'only-big-test' option. 1645s [ 3%] main.events_time_zone [ skipped ] Test needs 'big-test' or 'only-big-test' option. 1645s [ 3%] main.explain_dml [ skipped ] Test needs debug binaries. 1645s [ 3%] main.explain_for_connection_small_json [ skipped ] Test needs debug binaries. 1645s [ 3%] main.explain_for_connection_small_json_innodb [ skipped ] Test needs debug binaries. 1645s [ 3%] main.explain_for_connection_small_trad [ skipped ] Test needs debug binaries. 1645s [ 3%] main.explain_other [ skipped ] Test needs debug binaries. 1645s [ 3%] main.filesort_debug [ skipped ] Test needs debug binaries. 1645s [ 3%] main.flush_read_lock_kill [ skipped ] Test needs debug binaries. 1645s [ 4%] main.foreign_key_debug [ skipped ] Test needs debug binaries. 1645s [ 4%] main.foreign_key_debug_myisam [ skipped ] Test needs debug binaries. 1645s [ 4%] main.functional_index_debug [ skipped ] Test needs debug binaries. 1645s [ 4%] main.get_diagnostics_debug [ skipped ] Test needs debug binaries. 1645s [ 4%] main.get_table_share [ skipped ] Test needs debug binaries. 1645s [ 4%] main.gis-debug [ skipped ] Test needs debug binaries. 1645s [ 4%] main.grant_debug [ skipped ] Test needs debug binaries. 1645s [ 4%] main.grant_dynamic_flush_privileges_upgrade [ skipped ] Test needs 'big-test' or 'only-big-test' option. 1645s [ 4%] main.grant_dynamic_flush_upgrade [ skipped ] Test needs 'big-test' or 'only-big-test' option. 1645s [ 4%] main.grant_dynamic_suid_upgrade [ skipped ] Test needs 'big-test' or 'only-big-test' option. 1645s [ 4%] main.greedy_optimizer [ skipped ] Test needs 'big-test' or 'only-big-test' option. 1645s [ 4%] main.group_min_max_ext-debug [ skipped ] Test needs debug binaries. 1645s [ 4%] main.gtid_next_xa_binlog_off [ skipped ] Test needs debug binaries. 1645s [ 4%] main.handler_debug [ skipped ] Test needs debug binaries. 1645s [ 5%] main.histogram_auto_update [ skipped ] Test needs debug binaries. 1645s [ 5%] main.histogram_background_error [ skipped ] Test needs debug binaries. 1645s [ 5%] main.histogram_background_error_throttling [ skipped ] Test needs debug binaries. 1645s [ 5%] main.histograms_debug [ skipped ] Test needs debug binaries. 1645s [ 5%] main.hostname_length [ skipped ] Test needs debug binaries. 1645s [ 5%] main.hostname_length_ipv4 [ skipped ] Test needs debug binaries. 1645s [ 5%] main.hostname_length_ipv6 [ skipped ] Test needs debug binaries. 1645s [ 5%] main.hypergraph_bugs_debug [ skipped ] Test needs debug binaries. 1645s [ 5%] main.import_debug [ skipped ] Test needs debug binaries. 1645s [ 5%] main.index_merge_innodb [ skipped ] Test needs 'big-test' or 'only-big-test' option. 1645s [ 5%] main.index_merge_innodb_hypergraph [ skipped ] Test needs 'big-test' or 'only-big-test' option. 1645s [ 5%] main.index_skip_scan_end_range [ skipped ] Test needs debug binaries. 1645s [ 5%] main.information_schema_keywords [ skipped ] Test needs debug binaries. 1645s [ 5%] main.information_schema_statistics [ skipped ] Test needs debug binaries. 1645s [ 5%] main.information_schema_stats_expiry_debug [ skipped ] Test needs debug binaries. 1645s [ 6%] main.initialize-bug20350099 [ skipped ] Test needs 'big-test' or 'only-big-test' option. 1645s [ 6%] main.initialize-bug20504142 [ skipped ] Test needs 'big-test' or 'only-big-test' option. 1645s [ 6%] main.initialize-bug21335821 [ skipped ] Test needs 'big-test' or 'only-big-test' option. 1645s [ 6%] main.initialize-bug35254025 [ skipped ] Test needs 'big-test' or 'only-big-test' option. 1645s [ 6%] main.initialize-errors [ skipped ] Test needs 'big-test' or 'only-big-test' option. 1645s [ 6%] main.initialize-init-acls [ skipped ] Test needs 'big-test' or 'only-big-test' option. 1645s [ 6%] main.initialize-sha256 [ skipped ] Test needs 'big-test' or 'only-big-test' option. 1645s [ 6%] main.initialize [ skipped ] Test needs 'big-test' or 'only-big-test' option. 1645s [ 6%] main.innodb_explain_json_non_select_all [ skipped ] Test needs 'big-test' or 'only-big-test' option. 1645s [ 6%] main.innodb_explain_json_non_select_none [ skipped ] Test needs 'big-test' or 'only-big-test' option. 1645s [ 6%] main.innodb_explain_non_select_all [ skipped ] Test needs 'big-test' or 'only-big-test' option. 1645s [ 6%] main.innodb_explain_non_select_none [ skipped ] Test needs 'big-test' or 'only-big-test' option. 1645s [ 6%] main.innodb_mysql_sync [ skipped ] Test needs debug binaries. 1645s [ 6%] main.innodb_tmp_table_heap_to_disk [ skipped ] Test needs 'big-test' or 'only-big-test' option. 1645s [ 7%] main.insert_debug [ skipped ] Test needs debug binaries. 1645s [ 7%] main.internal_tmp_disk_storage_engine [ skipped ] Test needs debug binaries. 1645s [ 7%] main.ipv6_debug [ skipped ] Test needs debug binaries. 1645s [ 7%] main.join_debug [ skipped ] Test needs debug binaries. 1645s [ 7%] main.kill_debug [ skipped ] Test needs debug binaries. 1645s [ 7%] main.lock_backup_debug [ skipped ] Test needs debug binaries. 1645s [ 7%] main.log_backtrace_debug [ skipped ] Test needs debug binaries. 1645s [ 7%] main.log_buffered-big [ skipped ] Test needs 'big-test' or 'only-big-test' option. 1645s [ 7%] main.log_components [ skipped ] Test needs debug binaries. 1645s [ 7%] main.log_components_config [ skipped ] Test needs debug binaries. 1645s [ 7%] main.log_components_eventlog [ skipped ] Test needs debug binaries. 1645s [ 7%] main.log_components_filter [ skipped ] Test needs debug binaries. 1645s [ 7%] main.log_components_implicit [ skipped ] Test needs debug binaries. 1645s [ 7%] main.log_components_split [ skipped ] Test needs debug binaries. 1645s [ 7%] main.log_components_syslog [ skipped ] Test needs debug binaries. 1645s [ 8%] main.log_connection_hanging [ skipped ] Test needs 'big-test' or 'only-big-test' option. 1645s [ 8%] main.log_options_cmdline [ skipped ] Test needs 'big-test' or 'only-big-test' option. 1645s [ 8%] main.log_server_stages [ skipped ] Test needs 'big-test' or 'only-big-test' option. 1645s [ 8%] main.log_tables-big [ skipped ] Test needs 'big-test' or 'only-big-test' option. 1645s [ 8%] main.log_tables_debug [ skipped ] Test needs debug binaries. 1645s [ 8%] main.log_timestamp_ts [ skipped ] Test needs debug binaries. 1645s [ 8%] main.lowercase_table4 [ skipped ] Test needs 'big-test' or 'only-big-test' option. 1645s [ 8%] main.lowercase_utf8 [ skipped ] Test needs 'big-test' or 'only-big-test' option. 1645s [ 8%] main.lowercase_view [ skipped ] Test needs 'big-test' or 'only-big-test' option. 1645s [ 8%] main.max_statement_time [ skipped ] Test needs debug binaries. 1645s [ 8%] main.mdl_tablespace [ skipped ] Test needs debug binaries. 1645s [ 8%] main.mem_cnt_common_debug [ skipped ] Test needs debug binaries. 1645s [ 8%] main.mem_cnt_sql_keys [ skipped ] Test needs debug binaries. 1645s [ 8%] main.mem_cnt_temptable_keys [ skipped ] Test needs debug binaries. 1645s [ 9%] main.merge-big [ skipped ] Test needs 'big-test' or 'only-big-test' option. 1645s [ 9%] main.multi_update2 [ skipped ] Test needs 'big-test' or 'only-big-test' option. 1645s [ 9%] main.myisam_crash_before_flush_keys [ skipped ] Test needs debug binaries. 1645s [ 9%] main.myisam_debug [ skipped ] Test needs debug binaries. 1645s [ 9%] main.mysql_80_inplace_upgrade [ skipped ] Test needs 'big-test' or 'only-big-test' option. 1645s [ 9%] main.mysql_client_test_valgrind [ skipped ] Test needs debug binaries. 1645s [ 9%] main.mysql_inplace_upgrade [ skipped ] Test needs debug binaries. 1645s [ 9%] main.mysql_upgrade [ skipped ] Test needs 'big-test' or 'only-big-test' option. 1645s [ 9%] main.mysql_upgrade_grant [ skipped ] Test needs 'big-test' or 'only-big-test' option. 1645s [ 9%] main.mysql_upgrade_slave_master_info [ skipped ] Test needs 'big-test' or 'only-big-test' option. 1645s [ 9%] main.mysqlbinlog_row_big [ skipped ] Test needs 'big-test' or 'only-big-test' option. 1645s [ 9%] main.mysqldump_replica_terminology [ skipped ] No replication tests, --skip-rpl is enabled. 1645s [ 9%] main.no_binlog_gtid_next_partially_failed_stmts [ skipped ] Test needs debug binaries. 1645s [ 9%] main.no_binlog_gtid_next_partially_failed_stmts_anonymous [ skipped ] Test needs debug binaries. 1645s [ 9%] main.no_binlog_gtid_next_partially_failed_stmts_error [ skipped ] Test needs debug binaries. 1645s [ 10%] main.non_table_atomic_ddl [ skipped ] Test needs debug binaries. 1645s [ 10%] main.opt_costmodel_upgrade [ skipped ] Test needs 'big-test' or 'only-big-test' option. 1645s [ 10%] main.outfile_fsync_debug [ skipped ] Test needs debug binaries. 1645s [ 10%] main.packet_big_test [ skipped ] Test needs 'big-test' or 'only-big-test' option. 1645s [ 10%] main.parser-big-64bit [ skipped ] Test needs 'big-test' or 'only-big-test' option. 1645s [ 10%] main.partition_debug [ skipped ] Test needs debug binaries. 1645s [ 10%] main.partition_debug_sync [ skipped ] Test needs debug binaries. 1645s [ 10%] main.partition_debug_sync_stmt [ skipped ] Test needs debug binaries. 1645s [ 10%] main.partition_sync [ skipped ] Test needs debug binaries. 1645s [ 10%] main.per_thread_connection_handler [ skipped ] Test needs debug binaries. 1645s [ 10%] main.persisted_variables_bugs_debug [ skipped ] Test needs debug binaries. 1645s [ 10%] main.plugin [ skipped ] Test needs debug binaries. 1645s [ 10%] main.plugin_is_dying [ skipped ] Test needs debug binaries. 1645s [ 10%] main.ps_sys_upgrade [ skipped ] Test needs 'big-test' or 'only-big-test' option. 1645s [ 11%] main.query_expression_debug [ skipped ] Test needs debug binaries. 1645s [ 11%] main.range_debug [ skipped ] Test needs debug binaries. 1645s [ 11%] main.read_only_ddl [ skipped ] Test needs 'big-test' or 'only-big-test' option. 1645s [ 11%] main.rename_debug [ skipped ] Test needs debug binaries. 1645s [ 11%] main.rename_debug_myisam [ skipped ] Test needs debug binaries. 1645s [ 11%] main.reset_connection [ skipped ] Test needs debug binaries. 1645s [ 11%] main.resource_group_bugs_debug [ skipped ] Test needs debug binaries. 1645s [ 11%] main.resource_group_debug [ skipped ] Test needs debug binaries. 1645s [ 11%] main.resource_group_thr_prio_unsupported_debug [ skipped ] Test needs debug binaries. 1645s [ 11%] main.restart_server_no_acl [ skipped ] Test needs 'big-test' or 'only-big-test' option. 1645s [ 11%] main.roles_bugs_debug [ skipped ] Test needs debug binaries. 1645s [ 11%] main.rpl_connect_attr [ skipped ] No replication tests, --skip-rpl is enabled. 1645s [ 11%] main.rpl_lock_backup [ skipped ] No replication tests, --skip-rpl is enabled. 1645s [ 11%] main.rpl_mysqldump_slave [ skipped ] No replication tests, --skip-rpl is enabled. 1645s [ 11%] main.rpl_password_history [ skipped ] No replication tests, --skip-rpl is enabled. 1645s [ 12%] main.savepoint_debug [ skipped ] Test needs debug binaries. 1645s [ 12%] main.schema_read_only_ci [ skipped ] Test needs debug binaries. 1645s [ 12%] main.schema_read_only_cs [ skipped ] Test needs debug binaries. 1645s [ 12%] main.select_distinct_debug [ skipped ] Test needs debug binaries. 1645s [ 12%] main.sensitive_variables_permission [ skipped ] Test needs debug binaries. 1645s [ 12%] main.sensitive_variables_persistence_without_keyring [ skipped ] Test needs debug binaries. 1645s [ 12%] main.sensitive_variables_rewrite [ skipped ] Test needs debug binaries. 1645s [ 12%] main.server_offline_debug [ skipped ] Test needs debug binaries. 1645s [ 12%] main.show_parse_tree [ skipped ] Test needs debug binaries. 1645s [ 12%] main.signal_code [ skipped ] Test needs debug binaries. 1645s [ 12%] main.skip_records_in_range [ skipped ] Test needs debug binaries. 1645s [ 12%] main.slow_log_extra-big [ skipped ] Test needs 'big-test' or 'only-big-test' option. 1645s [ 12%] main.sp-code [ skipped ] Test needs debug binaries. 1645s [ 12%] main.sp_debug [ skipped ] Test needs debug binaries. 1645s [ 13%] main.ssl-big [ skipped ] Test needs 'big-test' or 'only-big-test' option. 1645s [ 13%] main.ssl_connect [ skipped ] Test needs 'big-test' or 'only-big-test' option. 1645s [ 13%] main.subplan_tokens [ skipped ] Test needs debug binaries. 1645s [ 13%] main.subselect_debug [ skipped ] Test needs debug binaries. 1645s [ 13%] main.sum_distinct-big [ skipped ] Test needs 'big-test' or 'only-big-test' option. 1645s [ 13%] main.tablespace [ skipped ] Test needs debug binaries. 1645s [ 13%] main.tablespace_myisam [ skipped ] Test needs debug binaries. 1645s [ 13%] main.temp_table_debug [ skipped ] Test needs debug binaries. 1645s [ 13%] main.temptable_basic [ skipped ] Test needs debug binaries. 1645s [ 13%] main.temptable_error_injection [ skipped ] Test needs debug binaries. 1645s [ 13%] main.temptable_fallback [ skipped ] Test needs debug binaries. 1645s [ 13%] main.temptable_tests_injection [ skipped ] Test needs debug binaries. 1645s [ 13%] main.time_zone_debug [ skipped ] Test needs debug binaries. 1645s [ 13%] main.trigger-compat-debug [ skipped ] Test needs debug binaries. 1645s [ 13%] main.trigger_debug [ skipped ] Test needs debug binaries. 1645s [ 14%] main.trigger_mdl [ skipped ] Test needs debug binaries. 1645s [ 14%] main.truncate_debug [ skipped ] Test needs debug binaries. 1645s [ 14%] main.type_newdecimal-big [ skipped ] Test needs 'big-test' or 'only-big-test' option. 1645s [ 14%] main.upgrade_with_float_auto_increment [ skipped ] Test needs 'big-test' or 'only-big-test' option. 1645s [ 14%] main.user_account_password_lock_dbug [ skipped ] Test needs debug binaries. 1645s [ 14%] main.validate_password_component [ skipped ] Test needs debug binaries. 1645s [ 14%] main.validate_password_component_random_password [ skipped ] Test needs debug binaries. 1645s [ 14%] main.variables-big [ skipped ] Test needs 'big-test' or 'only-big-test' option. 1645s [ 14%] main.variables_debug [ skipped ] Test needs debug binaries. 1645s [ 14%] main.view_debug [ skipped ] Test needs debug binaries. 1645s [ 14%] main.wait_for_disk_space [ skipped ] Test needs debug binaries. 1645s [ 14%] main.window_functions_big [ skipped ] Test needs 'big-test' or 'only-big-test' option. 1645s [ 14%] main.with_recursive_closure [ skipped ] Test needs 'big-test' or 'only-big-test' option. 1645s [ 14%] main.xa_applier_shutdown [ skipped ] Test needs 'big-test' or 'only-big-test' option. 1645s [ 15%] main.xa_commit_failure_before_commit_engines [ skipped ] Test needs debug binaries. 1645s [ 15%] main.xa_commit_failure_before_commit_engines_mmap [ skipped ] Test needs debug binaries. 1645s [ 15%] main.xa_commit_failure_before_commit_tc [ skipped ] Test needs debug binaries. 1645s [ 15%] main.xa_commit_failure_before_commit_tc_mmap [ skipped ] Test needs debug binaries. 1645s [ 15%] main.xa_commit_failure_before_gtid_externalization [ skipped ] Test needs debug binaries. 1645s [ 15%] main.xa_commit_failure_before_gtid_externalization_mmap [ skipped ] Test needs debug binaries. 1645s [ 15%] main.xa_commit_one_phase_failure_before_commit_engines [ skipped ] Test needs debug binaries. 1645s [ 15%] main.xa_commit_one_phase_failure_before_commit_engines_mmap [ skipped ] Test needs debug binaries. 1645s [ 15%] main.xa_commit_one_phase_failure_before_commit_tc [ skipped ] Test needs debug binaries. 1645s [ 15%] main.xa_commit_one_phase_failure_before_commit_tc_mmap [ skipped ] Test needs debug binaries. 1645s [ 15%] main.xa_commit_one_phase_failure_before_gtid_externalization [ skipped ] Test needs debug binaries. 1645s [ 15%] main.xa_commit_one_phase_failure_before_gtid_externalization_mmap [ skipped ] Test needs debug binaries. 1645s [ 15%] main.xa_deadlock_binlog [ skipped ] No replication tests, --skip-rpl is enabled. 1645s [ 15%] main.xa_debug [ skipped ] Test needs debug binaries. 1645s [ 15%] main.xa_prepare_failure_before_gtid_externalization [ skipped ] Test needs debug binaries. 1645s [ 16%] main.xa_prepare_failure_before_gtid_externalization_mmap [ skipped ] Test needs debug binaries. 1645s [ 16%] main.xa_prepare_failure_before_prepare_2nd_phase [ skipped ] Test needs debug binaries. 1645s [ 16%] main.xa_prepare_failure_before_prepare_2nd_phase_mmap [ skipped ] Test needs debug binaries. 1645s [ 16%] main.xa_prepare_failure_before_prepare_in_engines [ skipped ] Test needs debug binaries. 1645s [ 16%] main.xa_prepare_failure_before_prepare_in_engines_mmap [ skipped ] Test needs debug binaries. 1645s [ 16%] main.xa_prepare_failure_before_prepare_tc [ skipped ] Test needs debug binaries. 1645s [ 16%] main.xa_prepare_failure_before_prepare_tc_mmap [ skipped ] Test needs debug binaries. 1645s [ 16%] main.xa_recovery_errors [ skipped ] Test needs 'big-test' or 'only-big-test' option. 1645s [ 16%] main.xa_recovery_errors_mmap [ skipped ] Test needs 'big-test' or 'only-big-test' option. 1645s [ 16%] main.xa_rollback_failure_before_gtid_externalization [ skipped ] Test needs debug binaries. 1645s [ 16%] main.xa_rollback_failure_before_gtid_externalization_mmap [ skipped ] Test needs debug binaries. 1645s [ 16%] main.xa_rollback_failure_before_rollback_engines [ skipped ] Test needs debug binaries. 1645s [ 16%] main.xa_rollback_failure_before_rollback_engines_mmap [ skipped ] Test needs debug binaries. 1645s [ 16%] main.xa_rollback_failure_before_rollback_tc [ skipped ] Test needs debug binaries. 1645s [ 17%] main.xa_rollback_failure_before_rollback_tc_mmap [ skipped ] Test needs debug binaries. 1645s [ 17%] main.archive [ disabled ] BUG#111156 - fails on s390x since 8.4.2 1645s [ 17%] main.file_contents [ disabled ] BUG#000000 - Tests package contents, which differs from upstream 1645s [ 17%] main.func_compress [ disabled ] BUG#111156 - fails on s390x since 8.4.2 1645s [ 17%] main.histograms [ disabled ] BUG#000000 - requires additional resources 1645s [ 17%] main.loaddata_special [ disabled ] BUG#96341 - Access blocked by apparmor. https://bugs.mysql.com/bug.php?id=96341 1645s [ 17%] main.log_state [ disabled ] BUG#000000 - requires additional resources 1645s [ 17%] main.mysql_client_test [ disabled ] BUG#100274 - Unstable test 1645s [ 17%] main.print_stacktrace [ disabled ] Bug#36027494 Add mtr test for my_print_stacktrace 1645s [ 17%] main.slow_log [ disabled ] BUG#000000 - broken 1645s [ 17%] main.sp-threads [ disabled ] BUG#000000 - requires additional resources 1647s [ 17%] main.test_mysql_thd_store_service w1 [ pass ] 4 1647s [ 17%] main.conflicting_variables_plugin w3 [ pass ] 17 1647s [ 17%] report_features w2 [ pass ] 2 1647s [ 17%] main.component_set w4 [ pass ] 72 1650s [ 18%] main.plugin_load w3 [ pass ] 1650s [ 18%] main.plugin_load_option w2 [ pass ] 1 1650s [ 18%] main.plugin_load_early w4 [ pass ] 11 1654s [ 18%] main.bug46261 w4 [ pass ] 4 1661s [ 18%] main.component-upgrade w1 [ pass ] 14198 1662s [ 18%] main.locking_service w4 [ pass ] 5277 1662s [ 18%] main.log_components_notwin w4 [ pass ] 4 1662s [ 18%] main.disabled_storage_engines w2 [ pass ] 8606 1664s [ 18%] main.no_engine_substitution w3 [ pass ] 10748 1665s [ 18%] main.multi_plugin_load w2 [ pass ] 1 1666s [ 18%] main.plugin_auth_qa_2 w4 [ pass ] 139 1667s [ 18%] main.component w1 [ pass ] 5801 1668s [ 18%] main.multi_plugin_load_add2 w3 [ pass ] 1 1671s [ 18%] main.enable_cleartext_plugin w1 [ pass ] 94 1671s [ 19%] main.multi_plugin_load_add w3 [ pass ] 1 1674s [ 19%] main.plugin_auth_qa_3 w3 [ pass ] 51 1676s [ 19%] main.grant_alter_user_qa w2 [ pass ] 7356 1677s [ 19%] main.query_attributes w3 [ pass ] 36 1680s [ 19%] main.binlog_storage_iterator_skip_binlog w3 [ pass ] 12 1683s [ 19%] main.fulltext_plugin w3 [ pass ] 12 1688s [ 19%] main.plugin_auth w1 [ pass ] 17188 1688s [ 19%] main.plugin_auth_expire w1 [ pass ] 4 1689s [ 19%] main.plugin_auth_password_history w1 [ pass ] 11 1689s [ 19%] main.plugin_auth_qa w1 [ pass ] 118 1689s [ 19%] main.plugin_auth_qa_1 w1 [ pass ] 152 1689s [ 19%] main.plugin_auth_user_lock w1 [ pass ] 12 1692s [ 19%] main.udf_services w1 [ pass ] 4 1695s [ 19%] main.basedir w2 [ pass ] 16408 1695s [ 19%] main.component_backup_lock_service w1 [ pass ] 2915 1695s [ 20%] main.test_security_context w1 [ pass ] 3 1695s [ 20%] main.component_string_service w1 [ pass ] 2 1695s [ 20%] main.component_string_service_charset w1 [ pass ] 10 1696s [ 20%] main.component_string_service_long w1 [ pass ] 2 1696s [ 20%] main.mysqld_cmdline_warnings w2 [ pass ] 694 1699s [ 20%] main.udf_skip_grants w2 [ pass ] 1 1702s [ 20%] main.create_if_not_exists w2 [ pass ] 46 1703s [ 20%] main.persisted_variables_extended w4 [ pass ] 34529 1707s [ 20%] main.default_as_expr w2 [ pass ] 4944 1707s [ 20%] main.system_variable_source w1 [ pass ] 11568 1711s [ 20%] main.validate_password_plugin_check_user w1 [ pass ] 29 1714s [ 20%] main.persisted_variables_for_component w4 [ pass ] 8586 1715s [ 20%] main.validate_password_component_check_user w4 [ pass ] 40 1717s [ 20%] main.system_tables_myisam w2 [ pass ] 7848 1719s [ 21%] main.udf w2 [ pass ] 480 1722s [ 21%] main.roles-sp-case w2 [ pass ] 22 1725s [ 21%] main.plugin_auth_sha256_server_default_tls w2 [ pass ] 167 1727s [ 21%] main.read_only_persisted_plugin_variables w4 [ pass ] 11688 1728s [ 21%] main.bind_address_2_not_windows w2 [ pass ] 97 1730s [ 21%] main.ipv4_as_ipv6 w2 [ pass ] 984 1730s [ 21%] main.persisted_variables_for_plugin w1 [ pass ] 16533 1732s [ 21%] main.bind_address_3 w2 [ pass ] 65 1734s [ 21%] main.version_token w4 [ pass ] 6679 1734s [ 21%] main.session_tracker w1 [ pass ] 2856 1735s [ 21%] main.flush2 w2 [ pass ] 15 1735s [ 21%] main.validate_password_plugin w1 [ pass ] 1252 1738s [ 21%] main.version_token_bug21280801 w4 [ pass ] 4054 1738s [ 21%] main.mysqlbinlog_compressed_files w2 [ pass ] 38 1738s [ 21%] main.version_token_errors w4 [ pass ] 27 1738s [ 22%] main.lock_tables_lost_commit w1 [ pass ] 18 1739s [ 22%] main.mysqlbinlog_start_stop_streaming_input w2 [ pass ] 218 1741s [ 22%] main.lock_sync w4 [ skipped ] Test requires 'have_debug_sync' 1742s [ 22%] main.ctype_filesystem w2 [ pass ] 4 1744s [ 22%] main.mysqlbinlog w1 [ pass ] 2197 1744s [ 22%] main.ctype_latin1_de_myisam w4 [ pass ] 37 1745s [ 22%] main.ctype_latin1_de w2 [ pass ] 131 1746s [ 22%] main.ctype_ucs2_def w1 [ pass ] 30 1747s [ 22%] main.ctype_utf16_def w4 [ pass ] 5 1748s [ 22%] main.persisted_variables w3 [ pass ] 61744 1749s [ 22%] main.deprecate_user_defined_collations w1 [ pass ] 31 1750s [ 22%] main.utf8_hugeid_ci w4 [ pass ] 9 1751s [ 22%] main.ctype_ldml w2 [ pass ] 627 1752s [ 22%] main.type_timestamp_myisam w2 [ pass ] 6 1754s [ 23%] main.boot_coll_server_binary w4 [ pass ] 4 1755s [ 23%] main.mdl_sync w2 [ skipped ] Test requires 'have_debug_sync' 1759s [ 23%] main.myisam-blob w2 [ pass ] 698 1760s [ 23%] main.invalid_collation w1 [ pass ] 7814 1762s [ 23%] main.key_cache w2 [ pass ] 90 1765s [ 23%] main.show_check_ci_myisam w2 [ skipped ] Test requires 'case_insensitive_file_system' 1765s [ 23%] main.show_check_cs_myisam w2 [ pass ] 76 1767s [ 23%] main.partition_innodb_semi_consistent w4 [ pass ] 10138 1768s [ 23%] main.populate_charsets w1 [ pass ] 7745 1769s [ 23%] main.merge_mmap w4 [ pass ] 93 1770s [ 23%] main.myisam_recover w2 [ pass ] 2057 1770s [ 23%] main.import_empty_secure_file_priv w1 [ pass ] 21 1772s [ 23%] main.no_binlog_gtid_next_single_stmt_trx_rollback w2 [ pass ] 188 1772s [ 23%] main.delete_all_rows_myisam w4 [ pass ] 37 1773s [ 23%] main.session_tracker_trx_state_myisam w4 [ pass ] 152 1774s [ 24%] main.log_tables_myisam w1 [ pass ] 45 1774s [ 24%] main.import_symlink w2 [ pass ] 15 1775s [ 24%] main.almost_full w4 [ pass ] 152 1775s [ 24%] main.symlink w2 [ pass ] 369 1775s [ 24%] main.alter_sync_myisam w4 [ skipped ] Test requires 'have_debug_sync' 1777s [ 24%] main.alter_table_myisam w4 [ pass ] 1078 1777s [ 24%] main.disconnect_on_expired_password_off w1 [ pass ] 92 1777s [ 24%] main.analyze_myisam w4 [ pass ] 17 1777s [ 24%] main.auto_increment w4 [ pass ] 267 1778s [ 24%] main.bench_count_distinct w4 [ pass ] 221 1778s [ 24%] main.bug46760_myisam w4 [ pass ] 6 1778s [ 24%] main.mysqldump_single_trans_min_privs w2 [ pass ] 69 1778s [ 24%] main.check_constraints_myisam w4 [ pass ] 21 1779s [ 24%] main.check_myisam w4 [ pass ] 18 1779s [ 25%] main.mysqldump_gtid w2 [ pass ] 50 1779s [ 25%] main.create-big_myisam w4 [ skipped ] Test requires 'have_debug_sync' 1779s [ 25%] main.create_myisam w4 [ pass ] 19 1779s [ 25%] main.create_select_tmp_myisam w4 [ pass ] 20 1780s [ 25%] main.csv_myisam w4 [ pass ] 33 1780s [ 25%] main.ctype_binary_myisam w4 [ pass ] 105 1780s [ 25%] main.xa_gtid w1 [ pass ] 247 1780s [ 25%] main.ctype_cp1251_myisam w4 [ pass ] 156 1781s [ 25%] main.ctype_gb18030_binlog w4 [ pass ] 55 1781s [ 25%] main.no_binlog_gtid_empty_transaction w2 [ pass ] 60 1782s [ 25%] main.ctype_latin1_myisam w4 [ pass ] 1302 1783s [ 25%] main.ctype_latin2_ch_myisam w4 [ pass ] 23 1783s [ 25%] main.ctype_tis620_myisam w4 [ pass ] 29 1783s [ 25%] main.no_binlog_gtid_mode_on w1 [ pass ] 354 1783s [ 25%] main.ctype_uca_myisam w4 [ pass ] 25 1783s [ 26%] main.ctype_ucs2_def_myisam w4 [ pass ] 5 1784s [ 26%] main.no_binlog_gtid_mode_on_explicit_prepared_stmts w1 [ pass ] 386 1784s [ 26%] main.ctype_ucs_myisam w4 [ pass ] 160 1784s [ 26%] main.no_binlog_gtid_next_begin_caused_trx w1 [ pass ] 42 1784s [ 26%] main.ctype_ujis_myisam w4 [ pass ] 9 1784s [ 26%] main.ctype_utf16_myisam w4 [ pass ] 49 1785s [ 26%] main.ctype_utf16_uca_myisam w4 [ pass ] 17 1785s [ 26%] main.ctype_utf16le_myisam w4 [ pass ] 41 1785s [ 26%] main.type_timestamp w2 [ pass ] 737 1785s [ 26%] main.ctype_utf32_myisam w4 [ pass ] 56 1786s [ 26%] main.ctype_utf32_uca_myisam w4 [ pass ] 26 1787s [ 26%] main.type_timestamp_explicit w1 [ pass ] 1061 1788s [ 26%] main.log_state_bug33693 w2 [ pass ] 1 1788s [ 26%] main.ctype_utf8 w4 [ pass ] 2546 1790s [ 27%] main.ctype_utf8mb4 w4 [ pass ] 1086 1790s [ 27%] main.mem_cnt_common w1 [ pass ] 893 1791s [ 27%] main.ctype_utf8mb4_myisam w4 [ pass ] 741 1791s [ 27%] main.dd_is_compatibility_ci_myisam w4 [ skipped ] Test requires 'case_insensitive_file_system' 1791s [ 27%] main.dd_is_compatibility_cs_myisam w4 [ pass ] 60 1792s [ 27%] main.dd_is_gcov_myisam w4 [ pass ] 21 1792s [ 27%] main.debug_sync_myisam w4 [ skipped ] Test requires 'have_debug_sync' 1792s [ 27%] main.delete_myisam w4 [ pass ] 22 1793s [ 27%] main.init_file w2 [ pass ] 19 1794s [ 27%] main.init_connect w1 [ pass ] 169 1800s [ 27%] main.derived w4 [ pass ] 7407 1802s [ 27%] main.explain w4 [ pass ] 1898 1802s [ 27%] main.explain_json_all w4 [ pass ] 332 1803s [ 27%] main.explain_json_none w4 [ pass ] 237 1803s [ 27%] main.filter_single_col_idx_big_myisam w4 [ pass ] 83 1804s [ 28%] main.filter_single_col_idx_small_myisam w4 [ pass ] 38 1804s [ 28%] main.flush_myisam w4 [ pass ] 18 1804s [ 28%] main.flush_read_lock w4 [ skipped ] Test requires 'have_debug_sync' 1804s [ 28%] main.flush_read_lock_on_function_update_temp_table_row w4 [ skipped ] Test requires 'have_debug_sync' 1804s [ 28%] main.flush_table_myisam w4 [ pass ] 4 1805s [ 28%] main.table_open_cache_functionality w1 [ pass ] 5955 1805s [ 28%] main.foreign_key_myisam w4 [ pass ] 750 1806s [ 28%] main.alter_table w2 [ pass ] 8164 1807s [ 28%] main.fulltext w4 [ pass ] 857 1808s [ 28%] main.fulltext2 w4 [ pass ] 1332 1809s [ 28%] main.fulltext3 w4 [ pass ] 126 1809s [ 28%] main.fulltext_cache w4 [ pass ] 17 1809s [ 28%] main.alter_table_partition w1 [ pass ] 1746 1809s [ 28%] main.fulltext_distinct w4 [ pass ] 12 1809s [ 29%] main.fulltext_left_join w4 [ pass ] 54 1810s [ 29%] main.fulltext_multi w4 [ pass ] 11 1810s [ 29%] main.fulltext_order_by w4 [ pass ] 39 1810s [ 29%] main.fulltext_update w4 [ pass ] 11 1810s [ 29%] main.fulltext_var w4 [ pass ] 10 1811s [ 29%] main.func_date_add_myisam w4 [ pass ] 22 1811s [ 29%] main.func_str_myisam w4 [ pass ] 43 1811s [ 29%] main.lowercase_mixed_tmpdir w2 [ pass ] 21 1811s [ 29%] main.persisted_variables_bugs w3 [ pass ] 62073 1812s [ 29%] main.function_defaults_myisam w4 [ pass ] 567 1812s [ 29%] main.ctype_utf8mb4_innodb w1 [ pass ] 2565 1812s [ 29%] main.func_group_innodb_16k w1 [ pass ] 21 1812s [ 29%] main.gis-precise w4 [ pass ] 146 1813s [ 29%] main.gis-rt-precise w4 [ pass ] 234 1813s [ 29%] main.gis-rtree w4 [ pass ] 439 1816s [ 30%] main.group_by w1 [ pass ] 3449 1816s [ 30%] main.gis w4 [ pass ] 2416 1817s [ 30%] main.grant2 w4 [ pass ] 455 1817s [ 30%] main.lowercase_mixed_tmpdir_innodb w2 [ skipped ] Test requires 'lower_case_table_names = 2' 1817s [ 30%] main.grant4_myisam w4 [ pass ] 124 1818s [ 30%] main.system_tables_myisam_lctn_1 w3 [ pass ] 1227 1819s [ 30%] main.group_skip_scan w4 [ pass ] 1280 1819s [ 30%] main.group_skip_scan_hypergraph w4 [ skipped ] Test requires binaries built with WITH_HYPERGRAPH_OPTIMIZER=ON 1819s [ 30%] main.host_cache_size_functionality w1 [ pass ] 2916 1820s [ 30%] main.system_tables_myisam_lctn_2 w2 [ skipped ] Test requires 'case_insensitive_file_system' 1822s [ 30%] main.innodb_pk_extension_off w1 [ pass ] 218 1823s [ 30%] main.innodb_pk_extension_on w1 [ pass ] 282 1823s [ 30%] main.lowercase_table w3 [ pass ] 205 1823s [ 30%] main.lowercase_table_grant w3 [ pass ] 18 1824s [ 31%] main.partition_list w2 [ pass ] 712 1824s [ 31%] main.key w1 [ pass ] 1377 1824s [ 31%] main.handler_innodb w4 [ pass ] 5242 1825s [ 31%] main.opt_costmodel w1 [ pass ] 528 1825s [ 31%] main.opt_costmodel_flush w1 [ pass ] 124 1829s [ 31%] main.handler_myisam w4 [ pass ] 3921 1829s [ 31%] main.having_myisam w4 [ pass ] 28 1829s [ 31%] main.heap_btree_myisam w4 [ pass ] 29 1829s [ 31%] main.heap_hash_myisam w4 [ pass ] 25 1830s [ 31%] main.partition_innodb_tablespace w3 [ pass ] 3453 1833s [ 31%] main.innodb_recovery_with_upper_case_names w3 [ skipped ] Test requires 'case_insensitive_file_system' 1836s [ 31%] main.bug46760 w3 [ pass ] 48 1837s [ 31%] main.opt_costmodel_restart w1 [ pass ] 10942 1837s [ 31%] main.partition_index_innodb w1 [ pass ] 100 1839s [ 31%] main.partition w2 [ pass ] 11447 1840s [ 32%] main.import w4 [ pass ] 10460 1841s [ 32%] main.partition_locking w1 [ pass ] 3149 1842s [ 32%] main.partition_exchange w2 [ pass ] 2498 1842s [ 32%] main.ps_1general w1 [ pass ] 720 1845s [ 32%] main.sort_buffer_size_functionality w1 [ pass ] 3256 1846s [ 32%] main.partition_innodb w2 [ pass ] 4138 1850s [ 32%] main.table_definition_cache_functionality w1 [ pass ] 2990 1853s [ 32%] main.dd_pfs w2 [ pass ] 3341 1853s [ 32%] main.index_merge_myisam w4 [ pass ] 12627 1853s [ 32%] main.index_merge_myisam_hypergraph w4 [ skipped ] Test requires binaries built with WITH_HYPERGRAPH_OPTIMIZER=ON 1854s [ 32%] main.information_schema_ci_myisam w4 [ skipped ] Test requires 'case_insensitive_file_system' 1854s [ 32%] main.information_schema_cs_myisam w4 [ pass ] 9 1854s [ 32%] main.information_schema_statistics_myisam w4 [ pass ] 28 1854s [ 32%] main.insert_myisam w4 [ pass ] 31 1855s [ 33%] main.insert_select_myisam w4 [ pass ] 36 1855s [ 33%] main.insert_update_myisam w4 [ pass ] 21 1855s [ 33%] main.invalid_text_sort w4 [ pass ] 8 1856s [ 33%] main.invisible_columns_myisam w4 [ pass ] 304 1856s [ 33%] main.ps w1 [ pass ] 2962 1856s [ 33%] main.invisible_indexes_myisam w4 [ pass ] 344 1857s [ 33%] main.key_myisam w4 [ pass ] 140 1857s [ 33%] main.kill_myisam w4 [ skipped ] Test requires 'have_debug_sync' 1857s [ 33%] main.limit_myisam w4 [ pass ] 4 1862s [ 33%] main.innodb_mysql_lock w1 [ pass ] 2252 1862s [ 33%] main.lock_backup_ddl_myisam w4 [ pass ] 4950 1864s [ 33%] main.mysql_load_data_local_dir w1 [ pass ] 97 1865s [ 33%] main.concurrent_innodb_safelog w2 [ pass ] 9458 1866s [ 33%] main.innodb_deadlock w2 [ pass ] 233 1867s [ 33%] main.secure_file_priv_win w1 [ skipped ] Need windows 1871s [ 34%] main.select_for_update w2 [ pass ] 5152 1872s [ 34%] main.lock_multi w4 [ pass ] 9081 1872s [ 34%] main.lock_myisam w4 [ pass ] 47 1872s [ 34%] main.locking_clause_myisam w4 [ pass ] 4 1874s [ 34%] main.ssl_dynamic_binlog w2 [ pass ] 45 1878s [ 34%] main.func_time w1 [ pass ] 7700 1878s [ 34%] main.error_logging_verbosity w2 [ pass ] 347 1884s [ 34%] main.log_tables_upgrade w4 [ pass ] 11053 1884s [ 34%] main.merge_innodb w4 [ pass ] 37 1884s [ 34%] main.bug17076131 w2 [ pass ] 4024 1887s [ 34%] main.show_check_ci w2 [ skipped ] Test requires 'case_insensitive_file_system' 1889s [ 34%] main.grant_alter_user w1 [ pass ] 11060 1890s [ 34%] main.show_check_cs w2 [ pass ] 1909 1892s [ 34%] main.grant_user_lock w1 [ pass ] 2013 1892s [ 35%] main.multi_statement w2 [ pass ] 20 1893s [ 35%] main.loaddata w1 [ pass ] 1104 1897s [ 35%] main.loadxml w1 [ pass ] 3488 1897s [ 35%] main.mysqlimport w1 [ pass ] 197 1898s [ 35%] main.partition_binlog_stmt w1 [ pass ] 41 1898s [ 35%] main.read_only_persisted_variables w3 [ pass ] 58526 1899s [ 35%] main.merge_myisam w4 [ pass ] 14718 1899s [ 35%] main.metadata_myisam w4 [ pass ] 20 1900s [ 35%] main.union w2 [ pass ] 4534 1902s [ 35%] main.mix2_myisam w4 [ pass ] 2676 1903s [ 35%] main.no_binlog_related_options w3 [ pass ] 17 1903s [ 35%] main.mix2_myisam_ucs2 w4 [ pass ] 173 1903s [ 35%] main.multi_update_myisam w4 [ pass ] 180 1903s [ 35%] main.rewrite_general_log w1 [ pass ] 5115 1903s [ 35%] main.myisam-system w4 [ pass ] 9 1904s [ 36%] main.rewrite_slow_log w1 [ pass ] 144 1905s [ 36%] main.slow_log_extra w2 [ pass ] 2052 1905s [ 36%] main.slow_log_extra_myisam w2 [ pass ] 28 1906s [ 36%] main.myisam w4 [ pass ] 2361 1907s [ 36%] main.log_timestamps w1 [ pass ] 1908s [ 36%] main.plugin_auth_sha256_2 w2 [ pass ] 253 1908s [ 36%] main.plugin_auth_sha256_server_default w2 [ pass ] 206 1910s [ 36%] main.debug_sync2 w1 [ skipped ] Test requires 'have_debug_sync' 1911s [ 36%] main.named_pipe w2 [ skipped ] Need windows 1914s [ 36%] main.myisam_explain_json_non_select_all w4 [ pass ] 7640 1918s [ 36%] main.events_bugs w3 [ pass ] 14325 1918s [ 36%] main.innodb_mrr w1 [ pass ] 5260 1922s [ 36%] main.plugin_auth_sha256 w3 [ pass ] 306 1922s [ 36%] main.myisam_explain_json_non_select_none w4 [ pass ] 7638 1924s [ 37%] main.shm w3 [ skipped ] Need windows 1924s [ 37%] main.innodb_mrr_all w1 [ pass ] 5145 1926s [ 37%] main.myisam_explain_non_select_all w4 [ pass ] 3583 1927s [ 37%] main.shm_server_restart w3 [ skipped ] Need windows 1929s [ 37%] main.innodb_mrr_cost w1 [ pass ] 5061 1930s [ 37%] main.myisam_explain_non_select_none w4 [ pass ] 3895 1930s [ 37%] main.skip_log_bin w3 [ pass ] 34 1931s [ 37%] main.myisam_icp w4 [ pass ] 572 1932s [ 37%] main.myisam_icp_all w4 [ pass ] 505 1932s [ 37%] main.myisam_icp_none w4 [ pass ] 482 1933s [ 37%] main.myisam_mrr w4 [ pass ] 397 1934s [ 37%] main.myisam_mrr_all w4 [ pass ] 358 1934s [ 37%] main.ssl_8k_key w3 [ pass ] 138 1934s [ 37%] main.myisam_mrr_cost w4 [ pass ] 327 1935s [ 37%] main.myisam_mrr_cost_all w4 [ pass ] 322 1935s [ 38%] main.innodb_mrr_cost_all w1 [ pass ] 5228 1936s [ 38%] main.myisam_mrr_cost_icp w4 [ pass ] 464 1936s [ 38%] main.func_digest_small_buffer w3 [ pass ] 20 1936s [ 38%] main.myisam_mrr_icp w4 [ pass ] 434 1937s [ 38%] main.myisam_mrr_none w4 [ pass ] 329 1937s [ 38%] main.myisam_optimize_table w4 [ pass ] 32 1940s [ 38%] main.innodb_mrr_cost_icp w1 [ pass ] 5100 1941s [ 38%] main.ssl-big-packet w3 [ pass ] 1335 1941s [ 38%] main.myisam_skip_lock_nowait w4 [ pass ] 4071 1943s [ 38%] main.myisampack w4 [ pass ] 1362 1943s [ 38%] main.mysqlbinlog_base64_flag w4 [ pass ] 24 1945s [ 38%] main.mysqlbinlog_mixed_or_statment w4 [ pass ] 1022 1945s [ 38%] main.mysqlcheck_myisam w4 [ pass ] 109 1946s [ 38%] main.innodb_mrr_icp w1 [ pass ] 5050 1946s [ 39%] main.mysqldump-max w4 [ pass ] 953 1947s [ 39%] main.mysqldump_myisam w4 [ pass ] 546 1947s [ 39%] main.null_key_all_myisam w4 [ pass ] 76 1948s [ 39%] main.null_key_icp_myisam w4 [ pass ] 83 1948s [ 39%] main.null_key_none_myisam w4 [ pass ] 91 1948s [ 39%] main.olap_myisam w4 [ pass ] 76 1949s [ 39%] main.opt_costmodel_myisam w4 [ pass ] 112 1950s [ 39%] main.status w2 [ pass ] 35465 1951s [ 39%] main.innodb_mrr_none w1 [ pass ] 5105 1951s [ 39%] main.count_distinct2 w3 [ pass ] 8538 1952s [ 39%] main.multi_update_tiny_hash w3 [ pass ] 75 1954s [ 39%] main.skip_grants w1 [ pass ] 61 1955s [ 39%] main.transactional_acl_tables w3 [ skipped ] Test requires 'have_debug_sync' 1956s [ 39%] main.skip_grants_flush w1 [ pass ] 14 1956s [ 39%] main.mysql_native_password w2 [ pass ] 2879 1957s [ 40%] main.bug12969156 w1 [ pass ] 14 1958s [ 40%] main.server_offline_6 w3 [ pass ] 117 1959s [ 40%] main.bug58669 w2 [ pass ] 19 1960s [ 40%] main.relay_log_index_variables w1 [ pass ] 2 1961s [ 40%] main.relay_log_variables w3 [ pass ] 2 1962s [ 40%] main.opt_costmodel_restart_myisam w4 [ pass ] 12894 1962s [ 40%] main.grant3 w2 [ pass ] 126 1962s [ 40%] main.opt_hints_join_order_myisam w4 [ pass ] 261 1963s [ 40%] main.optimizer_bug12837084 w4 [ pass ] 32 1963s [ 40%] main.disabled_replication w1 [ pass ] 34 1965s [ 40%] main.warnings w3 [ pass ] 253 1965s [ 40%] main.packet_myisam w4 [ pass ] 2263 1965s [ 40%] main.parser_myisam w4 [ pass ] 1 1966s [ 40%] main.delete_all_rows w2 [ pass ] 76 1966s [ 41%] main.partition_myisam w4 [ pass ] 44 1966s [ 41%] main.no_binlog_gtid_next_temporary_table w2 [ pass ] 36 1966s [ 41%] main.partition_not_supported_myisam w4 [ pass ] 97 1966s [ 41%] main.mysqldump-no-binlog w1 [ pass ] 19 1966s [ 41%] main.session_tracker_trx_state w2 [ pass ] 219 1967s [ 41%] main.xa_prepared_binlog_off w1 [ skipped ] Test only executed when `GLOBAL.xa_detach_on_prepare = 0` 1967s [ 41%] main.no_binlog w3 [ pass ] 19 1967s [ 41%] main.no_binlog_gtid_empty_statement w3 [ pass ] 30 1967s [ 41%] main.preload w4 [ pass ] 988 1968s [ 41%] main.ps_2myisam w4 [ pass ] 239 1968s [ 41%] main.ps_ddl_myisam w4 [ pass ] 139 1969s [ 41%] main.ps_grant w4 [ pass ] 58 1969s [ 41%] main.flush_privileges_sql_mode w3 [ pass ] 48 1970s [ 41%] main.bind_address_1_not_windows w2 [ pass ] 131 1971s [ 41%] main.ipv6 w2 [ pass ] 638 1971s [ 42%] main.skip_name_resolve w2 [ pass ] 83 1973s [ 42%] main.ssl_verify_identity w3 [ pass ] 133 1974s [ 42%] main.ssl-sha512 w2 [ pass ] 28 1976s [ 42%] main.utility_warnings w2 [ pass ] 126 1977s [ 42%] main.log_tables w1 [ pass ] 7968 1978s [ 42%] main.tls_certificate_validation_ca_path w3 [ pass ] 2838 1979s [ 42%] main.ssl_crl_clients w1 [ pass ] 57 1979s [ 42%] main.ssl_crl_clients_valid w2 [ pass ] 36 1979s [ 42%] main.rename_myisam w4 [ pass ] 10338 1979s [ 42%] main.repair w4 [ pass ] 81 1980s [ 42%] main.rollback_myisam w4 [ pass ] 7 1981s [ 42%] main.ssl_crl w3 [ pass ] 87 1982s [ 42%] main.ssl_crl_crlpath w1 [ pass ] 51 1982s [ 42%] main.ssl_ca w2 [ pass ] 75 1986s [ 43%] main.ssl_cipher w1 [ pass ] 33 1987s [ 43%] main.tls_certificate_validation_crl w3 [ pass ] 2940 1989s [ 43%] main.archive_symlink w1 [ pass ] 23 1989s [ 43%] main.schema_myisam w4 [ pass ] 9216 1990s [ 43%] main.sdi_utf8 w4 [ pass ] 4 1990s [ 43%] main.select_count w4 [ pass ] 197 1990s [ 43%] main.server_offline_3_myisam w4 [ pass ] 14 1991s [ 43%] main.ssl w2 [ pass ] 4904 1991s [ 43%] main.server_offline_4 w4 [ pass ] 219 1992s [ 43%] main.sysdate_is_now w3 [ pass ] 1007 1992s [ 43%] main.trigger-single-table w1 [ pass ] 22 1993s [ 43%] main.single_delete_update w4 [ pass ] 2323 1994s [ 43%] main.skip_scan_myisam w4 [ pass ] 584 1994s [ 43%] main.sp_gis w4 [ pass ] 16 1995s [ 43%] main.no-threads w3 [ pass ] 3 1995s [ 44%] main.sp_trans_log w4 [ pass ] 142 1995s [ 44%] main.sp_trans_myisam w4 [ pass ] 125 1996s [ 44%] main.strict w4 [ pass ] 471 1996s [ 44%] main.strict_autoinc_1myisam w4 [ pass ] 8 1996s [ 44%] main.grant_user_lock_qa w1 [ pass ] 926 1996s [ 44%] main.strict_autoinc_3heap w4 [ pass ] 6 1997s [ 44%] main.subselect_gis w4 [ pass ] 12 1997s [ 44%] main.temptable_disk w2 [ pass ] 3115 1997s [ 44%] main.temp_table_myisam w4 [ pass ] 8 1998s [ 44%] main.temptable_myisam w4 [ pass ] 753 1998s [ 44%] main.mysql_ssl w3 [ pass ] 22 1998s [ 44%] main.time_zone2_myisam w4 [ pass ] 10 1999s [ 44%] main.temp_table w2 [ pass ] 317 2001s [ 44%] main.time_zone3 w4 [ skipped ] Test requires 'have_moscow_leap_timezone' 2002s [ 45%] main.long_tmpdir w3 [ pass ] 6 2002s [ 45%] main.change_user w2 [ pass ] 27 2002s [ 45%] main.1st w2 [ pass ] 2 2004s [ 45%] main.trigger-trans_myisam w4 [ pass ] 37 2004s [ 45%] main.trigger_before_not_null_myisam w4 [ pass ] 198 2009s [ 45%] main.trigger_myisam w4 [ pass ] 4077 2009s [ 45%] main.type_bit_myisam w4 [ pass ] 305 2010s [ 45%] main.type_blob_myisam w4 [ pass ] 8 2010s [ 45%] main.type_datetime_myisam w4 [ pass ] 13 2010s [ 45%] main.type_float_myisam w4 [ pass ] 12 2010s [ 45%] main.type_newdecimal_myisam w4 [ pass ] 5 2011s [ 45%] main.type_set_myisam w4 [ pass ] 9 2011s [ 45%] main.undo_tablespace_myisam w4 [ pass ] 1 2011s [ 45%] main.union_myisam w4 [ pass ] 104 2011s [ 45%] main.update_myisam w4 [ pass ] 61 2012s [ 46%] main.multi_update w1 [ pass ] 11973 2012s [ 46%] main.view_myisam w4 [ pass ] 621 2013s [ 46%] main.window_functions_myisam w4 [ pass ] 12 2013s [ 46%] main.windows_myisam w4 [ skipped ] Need windows 2013s [ 46%] main.year-myisam w4 [ pass ] 203 2014s [ 46%] main.events_restart w3 [ pass ] 8691 2017s [ 46%] main.join_cache_bnl w1 [ pass ] 3225 2020s [ 46%] main.events_scheduling w3 [ pass ] 6128 2020s [ 46%] main.log_errchk w4 [ pass ] 2927 2021s [ 46%] main.join_cache_nojb w1 [ pass ] 2990 2021s [ 46%] main.events_trans w3 [ pass ] 231 2021s [ 46%] main.join_crash w1 [ pass ] 78 2022s [ 46%] main.log_slow w4 [ pass ] 3 2022s [ 46%] main.long_table_name w4 [ pass ] 5 2022s [ 47%] main.loose_scan w4 [ pass ] 214 2022s [ 47%] main.join_nested w1 [ pass ] 1169 2024s [ 47%] main.join_nested_bka w1 [ pass ] 1165 2025s [ 47%] main.join_nested_bka_nobnl w1 [ pass ] 1108 2028s [ 47%] main.join_outer w1 [ pass ] 2429 2030s [ 47%] main.lowercase_fs_off w4 [ pass ] 7253 2030s [ 47%] main.lowercase_fs_on w4 [ skipped ] Test requires 'case_insensitive_file_system' 2030s [ 47%] main.lowercase_table2 w4 [ skipped ] Test requires 'lower_case_table_names = 2' 2030s [ 47%] main.join_outer_bka w1 [ pass ] 2193 2030s [ 47%] main.lowercase_table5 w4 [ pass ] 35 2031s [ 47%] main.lpad w4 [ pass ] 1 2031s [ 47%] main.materialize_cost w4 [ pass ] 26 2031s [ 47%] main.materialize_cost_hypergraph w4 [ skipped ] Test requires binaries built with WITH_HYPERGRAPH_OPTIMIZER=ON 2031s [ 47%] main.memory_skip_lock_nowait w4 [ pass ] 8 2032s [ 47%] main.metadata w4 [ pass ] 226 2033s [ 48%] main.join_outer_bka_nobnl w1 [ pass ] 2234 2033s [ 48%] main.join_outer_innodb w1 [ pass ] 94 2033s [ 48%] main.key_diff w1 [ pass ] 28 2033s [ 48%] main.mtr_unit_tests w4 [ pass ] 1342 2034s [ 48%] main.key_primary w1 [ pass ] 16 2034s [ 48%] main.multi_update_innodb w4 [ pass ] 140 2034s [ 48%] main.keyring_migration_password w1 [ pass ] 283 2035s [ 48%] main.keywords w1 [ pass ] 129 2035s [ 48%] main.kill w1 [ skipped ] Test requires 'have_debug_sync' 2040s [ 48%] main.examined_rows w3 [ pass ] 19122 2041s [ 48%] main.execution_constants w3 [ pass ] 413 2041s [ 48%] main.explain_for_connection_crash w3 [ skipped ] Test requires 'have_debug_sync' 2041s [ 48%] main.explain_for_schema w3 [ pass ] 72 2042s [ 48%] main.explain_for_schema_hypergraph w3 [ skipped ] Test requires binaries built with WITH_HYPERGRAPH_OPTIMIZER=ON 2042s [ 49%] main.explain_into w3 [ pass ] 28 2042s [ 49%] main.explain_into_hypergraph w3 [ skipped ] Test requires binaries built with WITH_HYPERGRAPH_OPTIMIZER=ON 2042s [ 49%] main.explain_json_hypergraph w3 [ skipped ] Test requires binaries built with WITH_HYPERGRAPH_OPTIMIZER=ON 2044s [ 49%] main.explain_tree w3 [ pass ] 1287 2044s [ 49%] main.explain_tree_hypergraph w3 [ skipped ] Test requires binaries built with WITH_HYPERGRAPH_OPTIMIZER=ON 2044s [ 49%] main.filesort w3 [ pass ] 397 2045s [ 49%] main.filesort_json w3 [ pass ] 58 2046s [ 49%] main.filesort_merge w3 [ pass ] 1180 2046s [ 49%] main.admin_interface w2 [ pass ] 43864 2047s [ 49%] main.filesort_pack w3 [ pass ] 121 2047s [ 49%] main.filter_single_col_idx_big w3 [ pass ] 54 2047s [ 49%] main.filter_single_col_idx_small w3 [ pass ] 45 2047s [ 49%] main.fix_priv_tables w3 [ skipped ] Test need MYSQL_FIX_PRIVILEGE_TABLES 2054s [ 49%] main.kill_bomb w1 [ pass ] 19041 2054s [ 49%] main.kill_explain_analyze w1 [ skipped ] Test requires 'have_debug_sync' 2054s [ 50%] main.admin_interface_ipv4_mapped w2 [ pass ] 7824 2055s [ 50%] main.lead_lag w1 [ pass ] 209 2055s [ 50%] main.alias w2 [ pass ] 129 2055s [ 50%] main.alter_sync w2 [ skipped ] Test requires 'have_debug_sync' 2055s [ 50%] main.lead_lag_explain w1 [ pass ] 133 2055s [ 50%] main.analyze w2 [ pass ] 219 2056s [ 50%] main.analyze_debug w2 [ skipped ] Test requires 'have_debug_sync' 2056s [ 50%] main.limit w1 [ pass ] 350 2056s [ 50%] main.analyze_histogram w2 [ skipped ] Test requires 'have_debug_sync' 2056s [ 50%] main.loaddata_autocom_innodb w1 [ pass ] 31 2056s [ 50%] main.ansi w2 [ pass ] 49 2056s [ 50%] main.locale w1 [ pass ] 38 2056s [ 50%] main.archive_bitfield w2 [ pass ] 46 2057s [ 50%] main.archive_gis w2 [ pass ] 99 2057s [ 50%] main.archive_no_symlink w2 [ pass ] 9 2057s [ 51%] main.lock w1 [ pass ] 539 2057s [ 51%] main.archive_skip_lock_nowait w2 [ pass ] 6 2058s [ 51%] main.fk_on_std_key_upgrade w3 [ pass ] 10104 2059s [ 51%] main.lock_backup w1 [ pass ] 1440 2061s [ 51%] main.flush w3 [ pass ] 3109 2062s [ 51%] main.flush_block_commit w3 [ pass ] 1033 2064s [ 51%] main.flush_block_commit_have_log_bin w3 [ pass ] 1203 2070s [ 51%] main.flush_table w3 [ pass ] 5543 2079s [ 51%] main.multiaddress_bind w4 [ pass ] 45194 2080s [ 51%] main.mysql-bug41486 w4 [ pass ] 333 2080s [ 51%] main.lock_backup_ddl w1 [ pass ] 21106 2081s [ 51%] main.mysql-bug45236 w4 [ pass ] 221 2082s [ 51%] main.mysql w4 [ pass ] 1270 2082s [ 51%] main.mysql_batch_mode w4 [ pass ] 15 2083s [ 52%] main.mysql_binary_mode w4 [ pass ] 171 2083s [ 52%] main.mysql_comments w4 [ pass ] 115 2086s [ 52%] main.mysql_config_editor w4 [ pass ] 3166 2087s [ 52%] main.mysql_cp932 w4 [ pass ] 43 2087s [ 52%] main.mysql_locale_posix w4 [ skipped ] Need POSIX locale de_DE.iso88591 2088s [ 52%] main.mysql_max_packet w4 [ pass ] 576 2088s [ 52%] main.mysql_os_user w4 [ pass ] 8 2088s [ 52%] main.mysql_os_user_unix w4 [ pass ] 12 2088s [ 52%] main.mysql_pager w4 [ pass ] 5 2089s [ 52%] main.mysql_protocols w4 [ pass ] 48 2089s [ 52%] main.mysql_ssl_default w4 [ pass ] 100 2089s [ 52%] main.mysql_system_cmd_unix w4 [ pass ] 35 2090s [ 52%] main.mysql_tzinfo_to_sql w4 [ pass ] 129 2090s [ 52%] main.mysql_tzinfo_to_sql_sys w4 [ skipped ] Unable to locate zoneinfo/Japan 2090s [ 52%] main.async_client w2 [ pass ] 32582 2092s [ 53%] main.lock_backup_sessions w1 [ pass ] 11099 2097s [ 53%] main.mysql_upgrade_ssl w4 [ pass ] 6439 2102s [ 53%] main.lock_multi_bug38499 w1 [ pass ] 9905 2106s [ 53%] main.mysql_upgrade_with_inf_schema_user w4 [ pass ] 6029 2114s [ 53%] main.mysql_wait w4 [ pass ] 5025 2114s [ 53%] main.mysql_win32_system w4 [ skipped ] Need windows 2114s [ 53%] main.lock_multi_bug38691 w1 [ pass ] 12216 2115s [ 53%] main.locking_clause w1 [ pass ] 159 2115s [ 53%] main.locking_clause_privileges w1 [ pass ] 81 2117s [ 53%] main.mysqladmin w4 [ pass ] 2179 2121s [ 53%] main.locking_part w1 [ pass ] 5421 2122s [ 53%] main.mysqladmin_shutdown w4 [ pass ] 4912 2122s [ 53%] main.mysqlbinlog_debug w4 [ skipped ] mysqlbinlog needs to be debug compiled 2122s [ 53%] main.mysqlbinlog_hexdump w4 [ pass ] 6 2125s [ 54%] main.mysqlbinlog_raw_mode w4 [ pass ] 2106 2125s [ 54%] main.mysqlbinlog_raw_mode_win w4 [ skipped ] Need windows 2127s [ 54%] main.mysqlcheck w4 [ pass ] 1416 2127s [ 54%] main.mysqld--defaults-file w4 [ pass ] 112 2127s [ 54%] main.mysqld--help-notwin w4 [ pass ] 60 2128s [ 54%] main.mysqld--help-win w4 [ skipped ] Need windows 2129s [ 54%] main.foreign_key w3 [ pass ] 58454 2129s [ 54%] main.func_aes w3 [ pass ] 50 2129s [ 54%] main.func_aes_cfb1 w3 [ pass ] 35 2129s [ 54%] main.locking_readonly_db w1 [ pass ] 8076 2129s [ 54%] main.func_aes_cfb128 w3 [ pass ] 33 2130s [ 54%] main.func_aes_cfb8 w3 [ pass ] 26 2130s [ 54%] main.func_aes_kdf_hkdf w3 [ pass ] 2 2130s [ 54%] main.func_aes_kdf_pbkdf2_hmac w3 [ pass ] 59 2131s [ 54%] main.func_aes_misc w3 [ pass ] 126 2131s [ 55%] main.func_aes_ofb w3 [ pass ] 19 2131s [ 55%] main.mysqld--validate-config w4 [ pass ] 3027 2131s [ 55%] main.func_at_time_zone w3 [ pass ] 31 2132s [ 55%] main.func_bitwise_ops w3 [ pass ] 476 2132s [ 55%] main.func_comparison w3 [ pass ] 303 2133s [ 55%] main.func_concat w3 [ pass ] 94 2133s [ 55%] main.func_date_add w3 [ pass ] 28 2133s [ 55%] main.func_default w3 [ pass ] 36 2134s [ 55%] main.func_digest w3 [ pass ] 212 2134s [ 55%] main.func_equal w3 [ pass ] 46 2135s [ 55%] main.func_gconcat w3 [ pass ] 1174 2137s [ 55%] main.func_group w3 [ pass ] 1762 2138s [ 55%] main.func_group_innodb w3 [ pass ] 101 2138s [ 55%] main.locking_with_out_key w1 [ pass ] 8101 2138s [ 56%] main.func_if w3 [ pass ] 191 2141s [ 56%] main.mysqld_daemon w4 [ pass ] 9555 2143s [ 56%] main.func_in_all w3 [ pass ] 4159 2145s [ 56%] main.parser_bug21114_innodb w1 [ pass ] 6622 2145s [ 56%] main.parser_precedence w1 [ pass ] 23 2147s [ 56%] main.func_in_icp w3 [ pass ] 4097 2148s [ 56%] main.parser_stack w1 [ pass ] 680 2149s [ 56%] main.partition_binlog w1 [ pass ] 92 2149s [ 56%] main.partition_bug18198 w1 [ pass ] 24 2150s [ 56%] main.partition_charset w1 [ pass ] 35 2150s [ 56%] main.partition_check_myisam w1 [ pass ] 52 2151s [ 56%] main.partition_column w1 [ pass ] 854 2151s [ 56%] main.func_in_icp_mrr w3 [ pass ] 3952 2152s [ 56%] main.partition_column_prune w1 [ pass ] 280 2153s [ 56%] main.partition_datatype w1 [ pass ] 1516 2156s [ 57%] main.partition_error w1 [ pass ] 1799 2156s [ 57%] main.partition_exchange_myisam w1 [ pass ] 129 2156s [ 57%] main.func_in_mrr w3 [ pass ] 4512 2157s [ 57%] main.async_compress_client w2 [ pass ] 66742 2158s [ 57%] main.partition_explicit_prune w1 [ pass ] 1343 2158s [ 57%] main.partition_grant w1 [ pass ] 83 2158s [ 57%] main.bigint w2 [ pass ] 350 2159s [ 57%] main.binary w2 [ pass ] 210 2159s [ 57%] main.binary_to_hex w2 [ pass ] 88 2161s [ 57%] main.func_in_mrr_cost w3 [ pass ] 4566 2166s [ 57%] main.func_in_none w3 [ pass ] 4648 2166s [ 57%] main.partition_hash w1 [ pass ] 7753 2166s [ 57%] main.func_isnull w3 [ pass ] 124 2166s [ 57%] main.partition_innodb_plugin w1 [ pass ] 129 2167s [ 58%] main.partition_innodb_stmt w1 [ pass ] 35 2167s [ 58%] main.func_like w3 [ pass ] 356 2168s [ 58%] main.func_math w3 [ pass ] 649 2168s [ 58%] main.func_md5 w3 [ pass ] 69 2168s [ 58%] main.func_md5_fail w3 [ skipped ] OpenSSL 3 FIPS is not active 2169s [ 58%] main.func_misc w3 [ pass ] 284 2169s [ 58%] main.partition_locking_4 w1 [ pass ] 2164 2169s [ 58%] main.func_op w3 [ pass ] 43 2169s [ 58%] main.partition_locking_ps_protocol w1 [ skipped ] Need ps-protocol 2170s [ 58%] main.func_prefix_key w3 [ pass ] 215 2170s [ 58%] main.func_rand w3 [ pass ] 42 2170s [ 58%] main.func_regexp w3 [ pass ] 147 2170s [ 58%] main.partition_mgm w1 [ pass ] 752 2171s [ 58%] main.func_rollback w3 [ pass ] 131 2171s [ 58%] main.func_sapdb w3 [ pass ] 35 2171s [ 59%] main.partition_mgm_err w1 [ pass ] 363 2171s [ 59%] main.func_set w3 [ pass ] 142 2171s [ 59%] main.partition_not_supported w1 [ pass ] 243 2172s [ 59%] main.partition_not_windows w1 [ pass ] 103 2173s [ 59%] main.mysqld_safe w4 [ pass ] 32151 2173s [ 59%] main.partition_order w1 [ pass ] 1283 2174s [ 59%] main.mysqldump-binary w4 [ pass ] 121 2174s [ 59%] main.mysqldump-compat w4 [ pass ] 56 2174s [ 59%] main.binlog_partial_json_warnings w2 [ pass ] 13096 2174s [ 59%] main.mysqldump-long-query-time w4 [ pass ] 81 2175s [ 59%] main.mysqldump-tablespace-escape w4 [ skipped ] mysql needs to be debug compiled 2176s [ 59%] main.blackhole w2 [ pass ] 42 2176s [ 59%] main.func_str w3 [ pass ] 4394 2176s [ 59%] main.bool w2 [ pass ] 47 2176s [ 60%] main.func_str_debug w3 [ skipped ] Test requires 'have_debug_sync' 2176s [ 60%] main.bug17666696 w2 [ pass ] 2 2176s [ 60%] main.func_str_no_ps w3 [ pass ] 1 2176s [ 60%] main.bug26331795 w2 [ pass ] 1 2177s [ 60%] main.func_system w3 [ pass ] 99 2177s [ 60%] main.bug28940878 w2 [ pass ] 22 2177s [ 60%] main.partition_prefixkey_upgrade w1 [ pass ] 3167 2177s [ 60%] main.bug29175494 w2 [ pass ] 91 2177s [ 60%] main.func_test w3 [ pass ] 435 2177s [ 60%] main.bug33509 w2 [ pass ] 25 2178s [ 60%] main.func_timestamp w3 [ pass ] 25 2178s [ 60%] main.bug35507223 w2 [ pass ] 20 2178s [ 60%] main.bug39022 w2 [ skipped ] Test cannot run with binlog_format ROW 2178s [ 60%] main.func_unixtime w3 [ pass ] 80 2178s [ 60%] main.bulk_replace w2 [ pass ] 29 2179s [ 61%] main.func_uuid w3 [ pass ] 161 2179s [ 61%] main.func_weight_string w3 [ pass ] 148 2179s [ 61%] main.case w2 [ pass ] 488 2180s [ 61%] main.cast w2 [ pass ] 876 2181s [ 61%] main.function_defaults w3 [ pass ] 1603 2182s [ 61%] main.functional_index w3 [ pass ] 1237 2183s [ 61%] main.gcc296 w3 [ pass ] 156 2183s [ 61%] main.partition_pruning w1 [ pass ] 5738 2185s [ 61%] main.generated_invisible_primary_key w3 [ pass ] 1411 2185s [ 61%] main.get_diagnostics w3 [ pass ] 203 2185s [ 61%] main.partition_range w1 [ pass ] 1916 2185s [ 61%] main.global_status_gr w3 [ pass ] 3 2186s [ 61%] main.partition_rename_longfilename w1 [ pass ] 68 2186s [ 61%] main.gr_member_actions w3 [ pass ] 2 2186s [ 62%] main.partition_truncate w1 [ pass ] 95 2186s [ 62%] main.partition_utf8 w1 [ pass ] 76 2186s [ 62%] main.perror-win w1 [ skipped ] Need windows 2187s [ 62%] main.perror w1 [ pass ] 18 2187s [ 62%] main.persisted_variables_bugs_fast w1 [ pass ] 249 2189s [ 62%] main.mysqldump w4 [ pass ] 14207 2189s [ 62%] main.grant w3 [ pass ] 3277 2189s [ 62%] main.mysqldump_bug29998457 w4 [ pass ] 53 2190s [ 62%] main.grant4 w3 [ pass ] 141 2190s [ 62%] main.mysqldump_bugs w4 [ pass ] 607 2190s [ 62%] main.mysqldump_debug_bugs w4 [ skipped ] mysql needs to be debug compiled 2191s [ 62%] main.mysqldump_event_terminology w4 [ pass ] 190 2191s [ 62%] main.mysqldump_restore w4 [ pass ] 286 2192s [ 62%] main.mysqldump_secondary_engine w4 [ pass ] 50 2192s [ 62%] main.mysqldumpslow w4 [ pass ] 21 2192s [ 63%] main.mysqlshow_ci w4 [ skipped ] Test requires 'case_insensitive_file_system' 2193s [ 63%] main.mysqlshow_cs w4 [ pass ] 245 2196s [ 63%] main.grant_dynamic w3 [ pass ] 5569 2196s [ 63%] main.grant_dynamic_bugs w3 [ pass ] 10 2196s [ 63%] main.grant_dynamic_flush w3 [ pass ] 84 2196s [ 63%] main.grant_dynamic_flush_privileges w3 [ pass ] 38 2197s [ 63%] main.grant_dynamic_session_variables_admin w3 [ pass ] 63 2197s [ 63%] main.grant_dynamic_suid w3 [ pass ] 179 2197s [ 63%] main.persisted_variables_replication w1 [ pass ] 9840 2197s [ 63%] main.grant_explain_non_select w3 [ pass ] 86 2198s [ 63%] main.plugin_auth_native_auth_suppress w1 [ pass ] 13 2198s [ 63%] main.grant_lowercase_fs w3 [ skipped ] Test requires 'case_insensitive_file_system' 2198s [ 63%] main.grant_revoke_not_existing_privilege w3 [ pass ] 92 2198s [ 63%] main.plugin_auth_sha256_tls w1 [ pass ] 181 2198s [ 64%] main.point_select_hypergraph w1 [ skipped ] Test requires binaries built with WITH_HYPERGRAPH_OPTIMIZER=ON 2198s [ 64%] main.grant_revoke_not_existing_privilege_routine w3 [ pass ] 57 2199s [ 64%] main.grant_revoke_not_existing_privilege_table w3 [ pass ] 180 2203s [ 64%] main.greedy_search w3 [ pass ] 4284 2204s [ 64%] main.populate_collations_read_only w1 [ pass ] 5671 2204s [ 64%] main.group_by_fd_no_prot w3 [ pass ] 787 2205s [ 64%] main.group_by_fd_ps_prot w3 [ skipped ] Need ps-protocol 2205s [ 64%] main.profiling w1 [ pass ] 228 2205s [ 64%] main.group_by_hypergraph w3 [ skipped ] Test requires binaries built with WITH_HYPERGRAPH_OPTIMIZER=ON 2205s [ 64%] main.ps_10nestset w1 [ pass ] 32 2205s [ 64%] main.ps_11bugs w1 [ pass ] 216 2205s [ 64%] main.group_min_max_innodb w3 [ pass ] 395 2206s [ 64%] main.ps_1general_ci w1 [ skipped ] Test requires 'case_insensitive_file_system' 2206s [ 64%] main.group_min_max_ps_protocol w3 [ skipped ] Need ps-protocol 2206s [ 64%] main.ps_3innodb w1 [ pass ] 562 2207s [ 65%] main.mysqlslap w4 [ pass ] 13636 2207s [ 65%] main.ps_4heap w1 [ pass ] 476 2208s [ 65%] main.ps_5merge w1 [ pass ] 745 2210s [ 65%] main.group_skip_scan_ext w3 [ pass ] 4444 2211s [ 65%] main.group_skip_scan_ext_hypergraph w3 [ skipped ] Test requires binaries built with WITH_HYPERGRAPH_OPTIMIZER=ON 2211s [ 65%] main.gtids_anonymous_trxs_violations w3 [ pass ] 49 2211s [ 65%] main.ps_ddl w1 [ pass ] 2416 2211s [ 65%] main.handler_non_debug w3 [ pass ] 35 2211s [ 65%] main.ps_ddl1 w1 [ pass ] 250 2211s [ 65%] main.handler_read_last w3 [ pass ] 25 2212s [ 65%] main.ps_not_windows w1 [ pass ] 7 2213s [ 65%] main.ps_type_deduction w1 [ pass ] 913 2214s [ 65%] main.ps_w_max_indexes_64 w1 [ pass ] 694 2215s [ 65%] main.ps_w_max_indexes_64_myisam w1 [ pass ] 661 2215s [ 66%] main.qualify w1 [ pass ] 16 2215s [ 66%] main.hash_join w3 [ pass ] 3366 2215s [ 66%] main.qualify_hypergraph w1 [ skipped ] Test requires binaries built with WITH_HYPERGRAPH_OPTIMIZER=ON 2215s [ 66%] main.hash_join_hypergraph w3 [ skipped ] Test requires binaries built with WITH_HYPERGRAPH_OPTIMIZER=ON 2216s [ 66%] main.query_expression-bugs w1 [ pass ] 138 2216s [ 66%] main.having w3 [ pass ] 844 2217s [ 66%] main.mysqltest w4 [ pass ] 10336 2217s [ 66%] main.heap w3 [ pass ] 672 2218s [ 66%] main.heap_auto_increment w3 [ pass ] 55 2218s [ 66%] main.mysqltest_escape w4 [ pass ] 178 2218s [ 66%] main.heap_btree w3 [ pass ] 140 2218s [ 66%] main.mysqltest_json w4 [ pass ] 58 2218s [ 66%] main.negation_elimination w4 [ pass ] 28 2218s [ 66%] main.heap_hash w3 [ pass ] 149 2219s [ 66%] main.no-login-paths w4 [ pass ] 43 2219s [ 67%] main.help w3 [ pass ] 69 2219s [ 67%] main.nth w4 [ pass ] 53 2219s [ 67%] main.help_verbose w3 [ pass ] 181 2219s [ 67%] main.nth_explain w4 [ pass ] 23 2220s [ 67%] main.null w4 [ pass ] 405 2220s [ 67%] main.character_set_deprecation w2 [ pass ] 39817 2221s [ 67%] main.null_key_all_innodb w4 [ pass ] 368 2221s [ 67%] main.histogram_equi_height w3 [ pass ] 1239 2221s [ 67%] main.null_key_icp_innodb w4 [ pass ] 367 2221s [ 67%] main.histogram_singleton w3 [ pass ] 188 2222s [ 67%] main.null_key_none_innodb w4 [ pass ] 413 2222s [ 67%] main.histogram_update_using_data w3 [ pass ] 476 2222s [ 67%] main.hypergraph_bugs w3 [ skipped ] Test requires binaries built with WITH_HYPERGRAPH_OPTIMIZER=ON 2222s [ 67%] main.odbc w4 [ pass ] 67 2222s [ 68%] main.hypergraph_cost_constants w3 [ skipped ] Test requires binaries built with WITH_HYPERGRAPH_OPTIMIZER=ON 2222s [ 68%] main.offline_mode_kill w4 [ pass ] 63 2223s [ 68%] main.hypergraph_oom w3 [ pass ] 195 2223s [ 68%] main.offline_mode_privileges w4 [ pass ] 77 2224s [ 68%] main.query_expression w1 [ pass ] 7635 2224s [ 68%] main.ignore_strict w3 [ pass ] 885 2224s [ 68%] main.olap w4 [ pass ] 999 2224s [ 68%] main.implicit_char_to_num_conversion w3 [ pass ] 126 2225s [ 68%] main.implicit_commit w3 [ pass ] 510 2225s [ 68%] main.openssl_1 w4 [ pass ] 809 2225s [ 68%] main.opt_costmodel_pfs w4 [ pass ] 1 2225s [ 68%] main.import_schema_mismatch w3 [ pass ] 87 2226s [ 68%] main.inconsistent_scan w3 [ pass ] 115 2226s [ 68%] main.index_merge_bug29952775 w3 [ pass ] 19 2226s [ 68%] main.index_merge_bugs w3 [ pass ] 85 2227s [ 69%] main.index_merge_bugs_no_ps w3 [ pass ] 40 2227s [ 69%] main.opt_costmodel_tables w4 [ pass ] 1062 2227s [ 69%] main.range_all w1 [ pass ] 3035 2227s [ 69%] main.index_merge_delete w3 [ pass ] 567 2228s [ 69%] main.index_merge_insert-and-replace w3 [ pass ] 701 2229s [ 69%] main.index_merge_intersect_dml w3 [ pass ] 364 2230s [ 69%] main.index_merge_update w3 [ pass ] 573 2230s [ 69%] main.range_icp w1 [ pass ] 2836 2230s [ 69%] main.information_schema_ci w3 [ skipped ] Test requires 'case_insensitive_file_system' 2231s [ 69%] main.character_set_server w2 [ pass ] 8110 2233s [ 69%] main.range_icp_mrr w1 [ pass ] 2771 2234s [ 69%] main.information_schema_cs w3 [ pass ] 3503 2234s [ 69%] main.information_schema_inno w3 [ pass ] 195 2235s [ 69%] main.charset w2 [ pass ] 3311 2235s [ 70%] main.information_schema_parameters w3 [ pass ] 108 2235s [ 70%] main.information_schema_parameters_ci w3 [ skipped ] Test requires 'case_insensitive_file_system' 2236s [ 70%] main.information_schema_part w3 [ pass ] 395 2236s [ 70%] main.information_schema_routines w3 [ pass ] 99 2236s [ 70%] main.information_schema_routines_ci w3 [ skipped ] Test requires 'case_insensitive_file_system' 2236s [ 70%] main.range_mrr w1 [ pass ] 2862 2238s [ 70%] main.opt_costmodel_warnings w4 [ pass ] 10827 2239s [ 70%] main.opt_hint_timeout w4 [ pass ] 126 2239s [ 70%] main.opt_hints w4 [ pass ] 663 2240s [ 70%] main.range_mrr_cost w1 [ pass ] 2939 2240s [ 70%] main.opt_hints_index w4 [ pass ] 71 2240s [ 70%] main.opt_hints_index_merge w4 [ pass ] 128 2241s [ 70%] main.opt_hints_join_order w4 [ pass ] 760 2241s [ 70%] main.opt_hints_lowercase w4 [ pass ] 53 2242s [ 70%] main.opt_hints_pfs w4 [ pass ] 32 2243s [ 71%] main.range_none w1 [ pass ] 3136 2244s [ 71%] main.opt_hints_set_var w4 [ pass ] 1707 2244s [ 71%] main.opt_hints_subquery w4 [ pass ] 66 2244s [ 71%] main.optimize_table w4 [ pass ] 170 2245s [ 71%] main.optimizer_debug_sync w4 [ skipped ] Test requires 'have_debug_sync' 2245s [ 71%] main.optimizer_switch w4 [ pass ] 219 2245s [ 71%] main.check w2 [ pass ] 10361 2247s [ 71%] main.initialize_gtid w3 [ pass ] 10836 2248s [ 71%] main.order_by_all w4 [ pass ] 3092 2248s [ 71%] main.check_auto_permission w2 [ pass ] 2926 2249s [ 71%] main.check_basedir w2 [ pass ] 108 2249s [ 71%] main.read_only w1 [ pass ] 3923 2251s [ 71%] main.read_only_innodb w1 [ pass ] 97 2251s [ 71%] main.regular_expressions_func w1 [ pass ] 59 2252s [ 72%] main.regular_expressions_func_icu_54 w1 [ pass ] 178 2253s [ 72%] main.order_by_icp_mrr w4 [ pass ] 3943 2253s [ 72%] main.order_by_limit w4 [ skipped ] Test requires 'have_debug_sync' 2253s [ 72%] main.check_constraints w2 [ pass ] 4155 2254s [ 72%] main.initialize_plugins w3 [ pass ] 6016 2254s [ 72%] main.clear_diag_area w2 [ pass ] 142 2254s [ 72%] main.regular_expressions_utf-8 w1 [ pass ] 2280 2254s [ 72%] main.client_command_line_aliases w2 [ pass ] 222 2254s [ 72%] main.regular_expressions_utf-8_icu_58 w1 [ pass ] 4 2255s [ 72%] main.client_ssl_data_print w2 [ pass ] 26 2255s [ 72%] main.regular_expressions_utf-8_icu_59 w1 [ pass ] 7 2255s [ 72%] main.client_xml w2 [ pass ] 91 2255s [ 72%] main.regular_expressions_utf-8_icu_67 w1 [ pass ] 6 2255s [ 72%] main.innodb_icp w3 [ pass ] 1318 2255s [ 72%] main.comment_column w2 [ pass ] 316 2256s [ 73%] main.comment_column2 w2 [ pass ] 469 2256s [ 73%] main.removed_features w1 [ pass ] 1080 2257s [ 73%] main.comment_index w2 [ pass ] 126 2257s [ 73%] main.order_by_none w4 [ pass ] 3639 2257s [ 73%] main.innodb_icp_all w3 [ pass ] 1381 2257s [ 73%] main.comment_table w2 [ pass ] 137 2257s [ 73%] main.comments w2 [ pass ] 20 2258s [ 73%] main.commit w2 [ pass ] 146 2258s [ 73%] main.order_by_sortkey w4 [ pass ] 857 2258s [ 73%] main.commit_1innodb w2 [ pass ] 283 2258s [ 73%] main.innodb_icp_none w3 [ pass ] 1193 2259s [ 73%] main.comp_err w2 [ pass ] 5 2259s [ 73%] main.compare w2 [ pass ] 157 2261s [ 73%] main.innodb_mysql_lock2 w3 [ pass ] 2412 2261s [ 74%] main.order_fill_sortbuf w4 [ pass ] 3164 2262s [ 74%] main.outfile w4 [ pass ] 49 2262s [ 74%] main.outfile_loaddata w4 [ pass ] 272 2262s [ 74%] main.overflow w4 [ pass ] 1 2263s [ 74%] main.packet w4 [ pass ] 46 2265s [ 74%] main.compress w2 [ pass ] 5454 2265s [ 74%] main.parser w4 [ pass ] 1951 2265s [ 74%] main.parser_57 w4 [ pass ] 12 2265s [ 74%] main.restart_server_win w4 [ skipped ] Need windows 2266s [ 74%] main.revoke_if_exists w4 [ pass ] 680 2267s [ 74%] main.insert w3 [ pass ] 5179 2267s [ 74%] main.roles-admin w4 [ pass ] 202 2267s [ 74%] main.roles-ddl w4 [ pass ] 50 2267s [ 74%] main.insert_select w3 [ pass ] 467 2267s [ 74%] main.roles-sp w4 [ pass ] 104 2270s [ 75%] main.insert_update w3 [ pass ] 2839 2271s [ 75%] main.rename w1 [ pass ] 13771 2271s [ 75%] main.invalid_comment w3 [ pass ] 39 2271s [ 75%] main.rename_roles w1 [ pass ] 119 2271s [ 75%] main.rename_sync w1 [ skipped ] Test requires 'have_debug_sync' 2271s [ 75%] main.compression w2 [ pass ] 6212 2271s [ 75%] main.renamedb w1 [ pass ] 2272s [ 75%] main.invisible_columns w3 [ pass ] 760 2272s [ 75%] main.replace w1 [ pass ] 58 2272s [ 75%] main.reset_persisted_variables w1 [ skipped ] Test requires 'have_debug_sync' 2272s [ 75%] main.resource_group w1 [ skipped ] Skipping test. (Test requires thread priority to be supported.) 2272s [ 75%] main.resource_group_binlog_events w1 [ pass ] 42 2272s [ 75%] main.resource_group_bugs w1 [ pass ] 7 2273s [ 75%] main.invisible_indexes w3 [ pass ] 828 2273s [ 76%] main.resource_group_thr_prio_unsupported w1 [ pass ] 55 2273s [ 76%] main.resource_group_unsupported w1 [ skipped ] Needs OSX or MacOS 2273s [ 76%] main.is_lock_table w3 [ pass ] 112 2275s [ 76%] main.join w3 [ pass ] 1755 2278s [ 76%] main.join_cache_bka w3 [ pass ] 2300 2280s [ 76%] main.concurrent_innodb_unsafelog w2 [ pass ] 5416 2280s [ 76%] main.condition_filter w2 [ pass ] 121 2281s [ 76%] main.join_cache_bka_nobnl w3 [ pass ] 2769 2282s [ 76%] main.sp-vars w3 [ pass ] 429 2283s [ 76%] main.roles-upgrade w4 [ pass ] 15735 2284s [ 76%] main.roles-view w4 [ pass ] 178 2290s [ 76%] main.roles w4 [ pass ] 5545 2290s [ 76%] main.roles2 w4 [ pass ] 346 2291s [ 76%] main.roles_bugs w4 [ pass ] 225 2291s [ 76%] main.roles_bugs_wildcard w4 [ pass ] 30 2291s [ 77%] main.rollback w4 [ pass ] 127 2292s [ 77%] main.round w4 [ pass ] 212 2292s [ 77%] main.row w4 [ pass ] 190 2293s [ 77%] main.restart_server w1 [ pass ] 19321 2293s [ 77%] main.rowid_order_innodb w4 [ pass ] 93 2293s [ 77%] main.rpad w4 [ pass ] 1 2293s [ 77%] main.subquery_sj_innodb_all w1 [ pass ] 150 2293s [ 77%] main.rpl_multi_source_mysqldump_slave w4 [ pass ] 211 2293s [ 77%] main.subquery_sj_innodb_all_bka w1 [ pass ] 195 2293s [ 77%] main.schema w4 [ skipped ] Test requires 'have_debug_sync' 2294s [ 77%] main.subquery_sj_innodb_all_bka_nobnl w1 [ pass ] 181 2294s [ 77%] main.subquery_sj_innodb_none w1 [ pass ] 199 2295s [ 77%] main.subquery_sj_innodb_none_bka w1 [ pass ] 186 2295s [ 77%] main.subquery_sj_innodb_none_bka_nobnl w1 [ pass ] 209 2295s [ 78%] main.sp w3 [ pass ] 13228 2298s [ 78%] main.sp_stress_case w3 [ pass ] 2765 2298s [ 78%] main.sp_sync w3 [ skipped ] Test requires 'have_debug_sync' 2299s [ 78%] main.sp_trans w3 [ pass ] 563 2301s [ 78%] main.sp_validation w3 [ pass ] 1266 2301s [ 78%] main.connect w2 [ pass ] 20731 2301s [ 78%] main.sql_mode w3 [ pass ] 385 2302s [ 78%] main.connection_compression_zstd w2 [ pass ] 42 2302s [ 78%] main.ssl_cache w3 [ skipped ] Test requires openssl version to be 1\.1.* 2302s [ 78%] main.ssl_cache_openssl1_0 w3 [ skipped ] Test requires openssl version to be 1\.0.* 2302s [ 78%] main.consistent_snapshot w2 [ pass ] 31 2302s [ 78%] main.subquery_sj_loosescan w1 [ pass ] 6448 2302s [ 78%] main.ssl_cache_tls13 w3 [ skipped ] Test requires openssl version to be 1\.1.* 2302s [ 78%] main.sdi_tablespace w4 [ pass ] 8197 2302s [ 78%] main.ssl_charset_code w3 [ skipped ] mysql needs to be debug compiled 2305s [ 79%] main.const_folding w2 [ pass ] 3356 2305s [ 79%] main.ssl_compress w3 [ pass ] 3034 2306s [ 79%] main.ssl_dynamic w3 [ pass ] 197 2307s [ 79%] main.constraints w2 [ pass ] 1468 2308s [ 79%] main.count_distinct w2 [ pass ] 341 2309s [ 79%] main.select_all w4 [ pass ] 6550 2310s [ 79%] main.subquery_sj_loosescan_bka w1 [ pass ] 7571 2312s [ 79%] main.create w2 [ pass ] 3631 2312s [ 79%] main.create_not_windows w2 [ pass ] 16 2312s [ 79%] main.create_ps_protocol w2 [ skipped ] Need ps-protocol 2313s [ 79%] main.create_select_foreign_key w2 [ pass ] 192 2313s [ 79%] main.create_select_tmp w2 [ pass ] 34 2313s [ 79%] main.ssl_dynamic_persisted w3 [ pass ] 6869 2314s [ 79%] main.status2 w3 [ pass ] 39 2314s [ 80%] main.status_bug17954 w3 [ pass ] 13 2314s [ 80%] main.status_debug w3 [ skipped ] Test requires 'have_debug_sync' 2314s [ 80%] main.strict_autoinc_2innodb w3 [ pass ] 20 2315s [ 80%] main.select_all_bka w4 [ pass ] 6133 2316s [ 80%] main.create_w_max_indexes_64 w2 [ pass ] 2545 2317s [ 80%] main.csv w2 [ pass ] 1168 2318s [ 80%] main.subquery_sj_loosescan_bka_nobnl w1 [ pass ] 7450 2318s [ 80%] main.csv_alter_table w2 [ pass ] 41 2318s [ 80%] main.csv_not_null w2 [ pass ] 62 2318s [ 80%] main.ctype_ascii w2 [ pass ] 33 2320s [ 80%] main.ctype_big5 w2 [ pass ] 1066 2323s [ 80%] main.select_all_bka_nobnl w4 [ pass ] 6801 2323s [ 80%] main.select_found w4 [ pass ] 408 2324s [ 80%] main.ctype_binary w2 [ pass ] 3617 2324s [ 80%] main.ctype_collate w2 [ pass ] 318 2325s [ 81%] main.ctype_cp1250_ch w2 [ pass ] 182 2325s [ 81%] main.subquery_sj_mat w1 [ pass ] 7204 2329s [ 81%] main.ctype_cp1251 w2 [ pass ] 3658 2329s [ 81%] main.ctype_cp932 w2 [ pass ] 39 2329s [ 81%] main.ctype_cp932_binlog_row w2 [ pass ] 66 2330s [ 81%] main.ctype_create w2 [ pass ] 105 2330s [ 81%] main.subquery_all w3 [ pass ] 14953 2330s [ 81%] main.ctype_errors w2 [ pass ] 28 2330s [ 81%] main.ctype_filename w2 [ pass ] 102 2330s [ 81%] main.select_icp_mrr w4 [ pass ] 6783 2331s [ 81%] main.ctype_gb18030 w2 [ pass ] 805 2332s [ 81%] main.ctype_gb18030_encoding_cn w2 [ pass ] 679 2333s [ 81%] main.subquery_sj_mat_bka w1 [ pass ] 7671 2333s [ 81%] main.ctype_gb18030_encoding_utf8 w2 [ pass ] 812 2334s [ 82%] main.ctype_gb18030_ligatures w2 [ pass ] 183 2335s [ 82%] main.ctype_gb2312 w2 [ pass ] 943 2337s [ 82%] main.ctype_gbk w2 [ pass ] 1151 2337s [ 82%] main.ctype_gbk_binlog w2 [ pass ] 104 2337s [ 82%] main.ctype_hebrew w2 [ pass ] 33 2338s [ 82%] main.ctype_latin1 w2 [ pass ] 164 2338s [ 82%] main.select_icp_mrr_bka w4 [ pass ] 7222 2338s [ 82%] main.ctype_latin2 w2 [ pass ] 64 2338s [ 82%] main.ctype_latin2_ch w2 [ pass ] 238 2339s [ 82%] main.ctype_many w2 [ pass ] 391 2339s [ 82%] main.ctype_mb w2 [ pass ] 88 2340s [ 82%] main.ctype_recoding w2 [ pass ] 285 2342s [ 82%] main.ctype_sjis w2 [ pass ] 1187 2342s [ 82%] main.ctype_tis620 w2 [ pass ] 166 2343s [ 82%] main.subquery_sj_mat_bka_nobnl w1 [ fail ] 2343s Test ended at 2025-03-15 16:25:26 2343s 2343s CURRENT_TEST: main.subquery_sj_mat_bka_nobnl 2343s --- /usr/lib/mysql-test/r/subquery_sj_mat_bka_nobnl.result 2024-12-16 14:00:04.000000000 +0300 2343s +++ /tmp/tmp.S4l2H0nLf2/var/1/log/subquery_sj_mat_bka_nobnl.reject 2025-03-15 19:25:24.390191468 +0300 2343s @@ -132,7 +132,7 @@ 2343s Flattened because of dependency, t10=func(t1) 2343s explain select * from t1 where a in (select pk from t10); 2343s id select_type table partitions type possible_keys key key_len ref rows filtered Extra 2343s -1 SIMPLE t1 NULL ALL NULL NULL NULL NULL 3 100.00 Using where 2343s +1 SIMPLE t1 NULL ALL NULL NULL NULL NULL 4 100.00 Using where 2343s 1 SIMPLE t10 NULL eq_ref PRIMARY PRIMARY 4 test.t1.a 1 100.00 Using index 2343s Warnings: 2343s Note 1003 /* select#1 */ select `test`.`t1`.`a` AS `a`,`test`.`t1`.`b` AS `b` from `test`.`t10` join `test`.`t1` where (`test`.`t10`.`pk` = `test`.`t1`.`a`) 2343s @@ -152,7 +152,7 @@ 2343s explain select * from t1 where a in (select a from t10 where pk=9); 2343s id select_type table partitions type possible_keys key key_len ref rows filtered Extra 2343s 1 SIMPLE t10 NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL 2343s -1 SIMPLE t1 NULL ALL NULL NULL NULL NULL 3 33.33 Using where 2343s +1 SIMPLE t1 NULL ALL NULL NULL NULL NULL 4 25.00 Using where 2343s Warnings: 2343s Note 1003 /* select#1 */ select `test`.`t1`.`a` AS `a`,`test`.`t1`.`b` AS `b` from `test`.`t10` join `test`.`t1` where ((`test`.`t1`.`a` = '9')) 2343s select * from t1 where a in (select a from t10 where pk=9); 2343s @@ -161,7 +161,7 @@ 2343s explain select * from t1 where a in (select a from t11); 2343s id select_type table partitions type possible_keys key key_len ref rows filtered Extra 2343s 1 SIMPLE NULL ALL NULL NULL NULL NULL NULL 100.00 NULL 2343s -1 SIMPLE t1 NULL ALL NULL NULL NULL NULL 3 33.33 Using where 2343s +1 SIMPLE t1 NULL ALL NULL NULL NULL NULL 4 25.00 Using where 2343s 2 MATERIALIZED t11 NULL ALL NULL NULL NULL NULL 1 100.00 NULL 2343s Warnings: 2343s Note 1003 /* select#1 */ select `test`.`t1`.`a` AS `a`,`test`.`t1`.`b` AS `b` from `test`.`t1` semi join (`test`.`t11`) where (`test`.`t1`.`a` = ``.`a`) 2343s @@ -169,7 +169,7 @@ 2343s a b 2343s explain select * from t1 where a in (select pk from t10) and b in (select pk from t10); 2343s id select_type table partitions type possible_keys key key_len ref rows filtered Extra 2343s -1 SIMPLE t1 NULL ALL NULL NULL NULL NULL 3 100.00 Using where 2343s +1 SIMPLE t1 NULL ALL NULL NULL NULL NULL 4 100.00 Using where 2343s 1 SIMPLE t10 NULL eq_ref PRIMARY PRIMARY 4 test.t1.a 1 100.00 Using index 2343s 1 SIMPLE t10 NULL eq_ref PRIMARY PRIMARY 4 test.t1.b 1 100.00 Using index 2343s Warnings: 2343s @@ -182,7 +182,7 @@ 2343s flattening a nested subquery 2343s explain select * from t1 where a in (select pk from t10 where t10.a in (select pk from t12)); 2343s id select_type table partitions type possible_keys key key_len ref rows filtered Extra 2343s -1 SIMPLE t1 NULL ALL NULL NULL NULL NULL 3 100.00 Using where 2343s +1 SIMPLE t1 NULL ALL NULL NULL NULL NULL 4 100.00 Using where 2343s 1 SIMPLE t10 NULL eq_ref PRIMARY PRIMARY 4 test.t1.a 1 100.00 Using where 2343s 1 SIMPLE t12 NULL eq_ref PRIMARY PRIMARY 4 test.t10.a 1 100.00 Using index 2343s Warnings: 2343s @@ -195,7 +195,7 @@ 2343s flattening subquery w/ several tables 2343s explain select * from t1 where a in (select t10.pk from t10, t12 where t12.pk=t10.a); 2343s id select_type table partitions type possible_keys key key_len ref rows filtered Extra 2343s -1 SIMPLE t1 NULL ALL NULL NULL NULL NULL 3 100.00 Using where 2343s +1 SIMPLE t1 NULL ALL NULL NULL NULL NULL 4 100.00 Using where 2343s 1 SIMPLE t10 NULL eq_ref PRIMARY PRIMARY 4 test.t1.a 1 100.00 Using where 2343s 1 SIMPLE t12 NULL eq_ref PRIMARY PRIMARY 4 test.t10.a 1 100.00 Using index 2343s Warnings: 2343s @@ -204,7 +204,7 @@ 2343s explain 2343s select * from t1 left join (t2 A, t2 B) on ( A.A= t1.A and B.A in (select pk from t10)); 2343s id select_type table partitions type possible_keys key key_len ref rows filtered Extra 2343s -1 SIMPLE t1 NULL ALL NULL NULL NULL NULL 3 100.00 NULL 2343s +1 SIMPLE t1 NULL ALL NULL NULL NULL NULL 4 100.00 NULL 2343s 1 SIMPLE A NULL ALL NULL NULL NULL NULL 3 100.00 Using where 2343s 1 SIMPLE B NULL ALL NULL NULL NULL NULL 3 100.00 NULL 2343s 1 SIMPLE t10 NULL eq_ref PRIMARY PRIMARY 4 test.B.A 1 100.00 Using index 2343s @@ -214,7 +214,7 @@ 2343s explain 2343s select * from t1 left join t2 on (t2.A= t1.A and t2.A in (select pk from t10)); 2343s id select_type table partitions type possible_keys key key_len ref rows filtered Extra 2343s -1 SIMPLE t1 NULL ALL NULL NULL NULL NULL 3 100.00 NULL 2343s +1 SIMPLE t1 NULL ALL NULL NULL NULL NULL 4 100.00 NULL 2343s 1 SIMPLE t10 NULL eq_ref PRIMARY PRIMARY 4 test.t1.A 1 100.00 Using index 2343s 1 SIMPLE t2 NULL ALL NULL NULL NULL NULL 3 100.00 Using where 2343s Warnings: 2343s @@ -233,76 +233,76 @@ 2343s t1 m10, t1 m11, t1 m12, t1 m13, t1 m14,t1 m15,t1 m16,t1 m17,t1 m18,t1 m19 2343s ); 2343s id select_type table partitions type possible_keys key key_len ref rows filtered Extra 2343s -1 PRIMARY s00 NULL ALL NULL NULL NULL NULL 3 100.00 Using where 2343s -1 PRIMARY s01 NULL ALL NULL NULL NULL NULL 3 100.00 NULL 2343s -1 PRIMARY s02 NULL ALL NULL NULL NULL NULL 3 100.00 NULL 2343s -1 PRIMARY s03 NULL ALL NULL NULL NULL NULL 3 100.00 NULL 2343s -1 PRIMARY s04 NULL ALL NULL NULL NULL NULL 3 100.00 NULL 2343s -1 PRIMARY s05 NULL ALL NULL NULL NULL NULL 3 100.00 NULL 2343s -1 PRIMARY s06 NULL ALL NULL NULL NULL NULL 3 100.00 NULL 2343s -1 PRIMARY s07 NULL ALL NULL NULL NULL NULL 3 100.00 NULL 2343s -1 PRIMARY s08 NULL ALL NULL NULL NULL NULL 3 100.00 NULL 2343s -1 PRIMARY s09 NULL ALL NULL NULL NULL NULL 3 100.00 NULL 2343s -1 PRIMARY s10 NULL ALL NULL NULL NULL NULL 3 100.00 NULL 2343s -1 PRIMARY s11 NULL ALL NULL NULL NULL NULL 3 100.00 NULL 2343s -1 PRIMARY s12 NULL ALL NULL NULL NULL NULL 3 100.00 NULL 2343s -1 PRIMARY s13 NULL ALL NULL NULL NULL NULL 3 100.00 NULL 2343s -1 PRIMARY s14 NULL ALL NULL NULL NULL NULL 3 100.00 NULL 2343s -1 PRIMARY s15 NULL ALL NULL NULL NULL NULL 3 100.00 NULL 2343s -1 PRIMARY s16 NULL ALL NULL NULL NULL NULL 3 100.00 NULL 2343s -1 PRIMARY s17 NULL ALL NULL NULL NULL NULL 3 100.00 NULL 2343s -1 PRIMARY s18 NULL ALL NULL NULL NULL NULL 3 100.00 NULL 2343s -1 PRIMARY s19 NULL ALL NULL NULL NULL NULL 3 100.00 NULL 2343s -1 PRIMARY s20 NULL ALL NULL NULL NULL NULL 3 100.00 NULL 2343s -1 PRIMARY s21 NULL ALL NULL NULL NULL NULL 3 100.00 NULL 2343s -1 PRIMARY s22 NULL ALL NULL NULL NULL NULL 3 100.00 NULL 2343s -1 PRIMARY s23 NULL ALL NULL NULL NULL NULL 3 100.00 NULL 2343s -1 PRIMARY s24 NULL ALL NULL NULL NULL NULL 3 100.00 NULL 2343s -1 PRIMARY s25 NULL ALL NULL NULL NULL NULL 3 100.00 NULL 2343s -1 PRIMARY s26 NULL ALL NULL NULL NULL NULL 3 100.00 NULL 2343s -1 PRIMARY s27 NULL ALL NULL NULL NULL NULL 3 100.00 NULL 2343s -1 PRIMARY s28 NULL ALL NULL NULL NULL NULL 3 100.00 NULL 2343s -1 PRIMARY s29 NULL ALL NULL NULL NULL NULL 3 100.00 NULL 2343s -1 PRIMARY s30 NULL ALL NULL NULL NULL NULL 3 100.00 NULL 2343s -1 PRIMARY s31 NULL ALL NULL NULL NULL NULL 3 100.00 NULL 2343s -1 PRIMARY s32 NULL ALL NULL NULL NULL NULL 3 100.00 NULL 2343s -1 PRIMARY s33 NULL ALL NULL NULL NULL NULL 3 100.00 NULL 2343s -1 PRIMARY s34 NULL ALL NULL NULL NULL NULL 3 100.00 NULL 2343s -1 PRIMARY s35 NULL ALL NULL NULL NULL NULL 3 100.00 NULL 2343s -1 PRIMARY s36 NULL ALL NULL NULL NULL NULL 3 100.00 NULL 2343s -1 PRIMARY s37 NULL ALL NULL NULL NULL NULL 3 100.00 NULL 2343s -1 PRIMARY s38 NULL ALL NULL NULL NULL NULL 3 100.00 NULL 2343s -1 PRIMARY s39 NULL ALL NULL NULL NULL NULL 3 100.00 NULL 2343s -1 PRIMARY s40 NULL ALL NULL NULL NULL NULL 3 100.00 NULL 2343s -1 PRIMARY s41 NULL ALL NULL NULL NULL NULL 3 100.00 NULL 2343s -1 PRIMARY s42 NULL ALL NULL NULL NULL NULL 3 100.00 NULL 2343s -1 PRIMARY s43 NULL ALL NULL NULL NULL NULL 3 100.00 NULL 2343s -1 PRIMARY s44 NULL ALL NULL NULL NULL NULL 3 100.00 NULL 2343s -1 PRIMARY s45 NULL ALL NULL NULL NULL NULL 3 100.00 NULL 2343s -1 PRIMARY s46 NULL ALL NULL NULL NULL NULL 3 100.00 NULL 2343s -1 PRIMARY s47 NULL ALL NULL NULL NULL NULL 3 100.00 NULL 2343s -1 PRIMARY s48 NULL ALL NULL NULL NULL NULL 3 100.00 NULL 2343s -1 PRIMARY s49 NULL ALL NULL NULL NULL NULL 3 100.00 NULL 2343s -2 SUBQUERY m00 NULL ALL NULL NULL NULL NULL 3 100.00 NULL 2343s -2 SUBQUERY m01 NULL ALL NULL NULL NULL NULL 3 100.00 NULL 2343s -2 SUBQUERY m02 NULL ALL NULL NULL NULL NULL 3 100.00 NULL 2343s -2 SUBQUERY m03 NULL ALL NULL NULL NULL NULL 3 100.00 NULL 2343s -2 SUBQUERY m04 NULL ALL NULL NULL NULL NULL 3 100.00 NULL 2343s -2 SUBQUERY m05 NULL ALL NULL NULL NULL NULL 3 100.00 NULL 2343s -2 SUBQUERY m06 NULL ALL NULL NULL NULL NULL 3 100.00 NULL 2343s -2 SUBQUERY m07 NULL ALL NULL NULL NULL NULL 3 100.00 NULL 2343s -2 SUBQUERY m08 NULL ALL NULL NULL NULL NULL 3 100.00 NULL 2343s -2 SUBQUERY m09 NULL ALL NULL NULL NULL NULL 3 100.00 NULL 2343s -2 SUBQUERY m10 NULL ALL NULL NULL NULL NULL 3 100.00 NULL 2343s -2 SUBQUERY m11 NULL ALL NULL NULL NULL NULL 3 100.00 NULL 2343s -2 SUBQUERY m12 NULL ALL NULL NULL NULL NULL 3 100.00 NULL 2343s -2 SUBQUERY m13 NULL ALL NULL NULL NULL NULL 3 100.00 NULL 2343s -2 SUBQUERY m14 NULL ALL NULL NULL NULL NULL 3 100.00 NULL 2343s -2 SUBQUERY m15 NULL ALL NULL NULL NULL NULL 3 100.00 NULL 2343s -2 SUBQUERY m16 NULL ALL NULL NULL NULL NULL 3 100.00 NULL 2343s -2 SUBQUERY m17 NULL ALL NULL NULL NULL NULL 3 100.00 NULL 2343s -2 SUBQUERY m18 NULL ALL NULL NULL NULL NULL 3 100.00 NULL 2343s -2 SUBQUERY m19 NULL ALL NULL NULL NULL NULL 3 100.00 NULL 2343s +1 PRIMARY s00 NULL ALL NULL NULL NULL NULL 4 100.00 Using where 2343s +1 PRIMARY s01 NULL ALL NULL NULL NULL NULL 4 100.00 NULL 2343s +1 PRIMARY s02 NULL ALL NULL NULL NULL NULL 4 100.00 NULL 2343s +1 PRIMARY s03 NULL ALL NULL NULL NULL NULL 4 100.00 NULL 2343s +1 PRIMARY s04 NULL ALL NULL NULL NULL NULL 4 100.00 NULL 2343s +1 PRIMARY s05 NULL ALL NULL NULL NULL NULL 4 100.00 NULL 2343s +1 PRIMARY s06 NULL ALL NULL NULL NULL NULL 4 100.00 NULL 2343s +1 PRIMARY s07 NULL ALL NULL NULL NULL NULL 4 100.00 NULL 2343s +1 PRIMARY s08 NULL ALL NULL NULL NULL NULL 4 100.00 NULL 2343s +1 PRIMARY s09 NULL ALL NULL NULL NULL NULL 4 100.00 NULL 2343s +1 PRIMARY s10 NULL ALL NULL NULL NULL NULL 4 100.00 NULL 2343s +1 PRIMARY s11 NULL ALL NULL NULL NULL NULL 4 100.00 NULL 2343s +1 PRIMARY s12 NULL ALL NULL NULL NULL NULL 4 100.00 NULL 2343s +1 PRIMARY s13 NULL ALL NULL NULL NULL NULL 4 100.00 NULL 2343s +1 PRIMARY s14 NULL ALL NULL NULL NULL NULL 4 100.00 NULL 2343s +1 PRIMARY s15 NULL ALL NULL NULL NULL NULL 4 100.00 NULL 2343s +1 PRIMARY s16 NULL ALL NULL NULL NULL NULL 4 100.00 NULL 2343s +1 PRIMARY s17 NULL ALL NULL NULL NULL NULL 4 100.00 NULL 2343s +1 PRIMARY s18 NULL ALL NULL NULL NULL NULL 4 100.00 NULL 2343s +1 PRIMARY s19 NULL ALL NULL NULL NULL NULL 4 100.00 NULL 2343s +1 PRIMARY s20 NULL ALL NULL NULL NULL NULL 4 100.00 NULL 2343s +1 PRIMARY s21 NULL ALL NULL NULL NULL NULL 4 100.00 NULL 2343s +1 PRIMARY s22 NULL ALL NULL NULL NULL NULL 4 100.00 NULL 2343s +1 PRIMARY s23 NULL ALL NULL NULL NULL NULL 4 100.00 NULL 2343s +1 PRIMARY s24 NULL ALL NULL NULL NULL NULL 4 100.00 NULL 2343s +1 PRIMARY s25 NULL ALL NULL NULL NULL NULL 4 100.00 NULL 2343s +1 PRIMARY s26 NULL ALL NULL NULL NULL NULL 4 100.00 NULL 2343s +1 PRIMARY s27 NULL ALL NULL NULL NULL NULL 4 100.00 NULL 2343s +1 PRIMARY s28 NULL ALL NULL NULL NULL NULL 4 100.00 NULL 2343s +1 PRIMARY s29 NULL ALL NULL NULL NULL NULL 4 100.00 NULL 2343s +1 PRIMARY s30 NULL ALL NULL NULL NULL NULL 4 100.00 NULL 2343s +1 PRIMARY s31 NULL ALL NULL NULL NULL NULL 4 100.00 NULL 2343s +1 PRIMARY s32 NULL ALL NULL NULL NULL NULL 4 100.00 NULL 2343s +1 PRIMARY s33 NULL ALL NULL NULL NULL NULL 4 100.00 NULL 2343s +1 PRIMARY s34 NULL ALL NULL NULL NULL NULL 4 100.00 NULL 2343s +1 PRIMARY s35 NULL ALL NULL NULL NULL NULL 4 100.00 NULL 2343s +1 PRIMARY s36 NULL ALL NULL NULL NULL NULL 4 100.00 NULL 2343s +1 PRIMARY s37 NULL ALL NULL NULL NULL NULL 4 100.00 NULL 2343s +1 PRIMARY s38 NULL ALL NULL NULL NULL NULL 4 100.00 NULL 2343s +1 PRIMARY s39 NULL ALL NULL NULL NULL NULL 4 100.00 NULL 2343s +1 PRIMARY s40 NULL ALL NULL NULL NULL NULL 4 100.00 NULL 2343s +1 PRIMARY s41 NULL ALL NULL NULL NULL NULL 4 100.00 NULL 2343s +1 PRIMARY s42 NULL ALL NULL NULL NULL NULL 4 100.00 NULL 2343s +1 PRIMARY s43 NULL ALL NULL NULL NULL NULL 4 100.00 NULL 2343s +1 PRIMARY s44 NULL ALL NULL NULL NULL NULL 4 100.00 NULL 2343s +1 PRIMARY s45 NULL ALL NULL NULL NULL NULL 4 100.00 NULL 2343s +1 PRIMARY s46 NULL ALL NULL NULL NULL NULL 4 100.00 NULL 2343s +1 PRIMARY s47 NULL ALL NULL NULL NULL NULL 4 100.00 NULL 2343s +1 PRIMARY s48 NULL ALL NULL NULL NULL NULL 4 100.00 NULL 2343s +1 PRIMARY s49 NULL ALL NULL NULL NULL NULL 4 100.00 NULL 2343s +2 SUBQUERY m00 NULL ALL NULL NULL NULL NULL 4 100.00 NULL 2343s +2 SUBQUERY m01 NULL ALL NULL NULL NULL NULL 4 100.00 NULL 2343s +2 SUBQUERY m02 NULL ALL NULL NULL NULL NULL 4 100.00 NULL 2343s +2 SUBQUERY m03 NULL ALL NULL NULL NULL NULL 4 100.00 NULL 2343s +2 SUBQUERY m04 NULL ALL NULL NULL NULL NULL 4 100.00 NULL 2343s +2 SUBQUERY m05 NULL ALL NULL NULL NULL NULL 4 100.00 NULL 2343s +2 SUBQUERY m06 NULL ALL NULL NULL NULL NULL 4 100.00 NULL 2343s +2 SUBQUERY m07 NULL ALL NULL NULL NULL NULL 4 100.00 NULL 2343s +2 SUBQUERY m08 NULL ALL NULL NULL NULL NULL 4 100.00 NULL 2343s +2 SUBQUERY m09 NULL ALL NULL NULL NULL NULL 4 100.00 NULL 2343s +2 SUBQUERY m10 NULL ALL NULL NULL NULL NULL 4 100.00 NULL 2343s +2 SUBQUERY m11 NULL ALL NULL NULL NULL NULL 4 100.00 NULL 2343s +2 SUBQUERY m12 NULL ALL NULL NULL NULL NULL 4 100.00 NULL 2343s +2 SUBQUERY m13 NULL ALL NULL NULL NULL NULL 4 100.00 NULL 2343s +2 SUBQUERY m14 NULL ALL NULL NULL NULL NULL 4 100.00 NULL 2343s +2 SUBQUERY m15 NULL ALL NULL NULL NULL NULL 4 100.00 NULL 2343s +2 SUBQUERY m16 NULL ALL NULL NULL NULL NULL 4 100.00 NULL 2343s +2 SUBQUERY m17 NULL ALL NULL NULL NULL NULL 4 100.00 NULL 2343s +2 SUBQUERY m18 NULL ALL NULL NULL NULL NULL 4 100.00 NULL 2343s +2 SUBQUERY m19 NULL ALL NULL NULL NULL NULL 4 100.00 NULL 2343s Warnings: 2343s Note 1003 /* select#1 */ select `test`.`s00`.`a` AS `a`,`test`.`s00`.`b` AS `b`,`test`.`s01`.`a` AS `a`,`test`.`s01`.`b` AS `b`,`test`.`s02`.`a` AS `a`,`test`.`s02`.`b` AS `b`,`test`.`s03`.`a` AS `a`,`test`.`s03`.`b` AS `b`,`test`.`s04`.`a` AS `a`,`test`.`s04`.`b` AS `b`,`test`.`s05`.`a` AS `a`,`test`.`s05`.`b` AS `b`,`test`.`s06`.`a` AS `a`,`test`.`s06`.`b` AS `b`,`test`.`s07`.`a` AS `a`,`test`.`s07`.`b` AS `b`,`test`.`s08`.`a` AS `a`,`test`.`s08`.`b` AS `b`,`test`.`s09`.`a` AS `a`,`test`.`s09`.`b` AS `b`,`test`.`s10`.`a` AS `a`,`test`.`s10`.`b` AS `b`,`test`.`s11`.`a` AS `a`,`test`.`s11`.`b` AS `b`,`test`.`s12`.`a` AS `a`,`test`.`s12`.`b` AS `b`,`test`.`s13`.`a` AS `a`,`test`.`s13`.`b` AS `b`,`test`.`s14`.`a` AS `a`,`test`.`s14`.`b` AS `b`,`test`.`s15`.`a` AS `a`,`test`.`s15`.`b` AS `b`,`test`.`s16`.`a` AS `a`,`test`.`s16`.`b` AS `b`,`test`.`s17`.`a` AS `a`,`test`.`s17`.`b` AS `b`,`test`.`s18`.`a` AS `a`,`test`.`s18`.`b` AS `b`,`test`.`s19`.`a` AS `a`,`test`.`s19`.`b` AS `b`,`test`.`s20`.`a` AS `a`,`test`.`s20`.`b` AS `b`,`test`.`s21`.`a` AS `a`,`test`.`s21`.`b` AS `b`,`test`.`s22`.`a` AS `a`,`test`.`s22`.`b` AS `b`,`test`.`s23`.`a` AS `a`,`test`.`s23`.`b` AS `b`,`test`.`s24`.`a` AS `a`,`test`.`s24`.`b` AS `b`,`test`.`s25`.`a` AS `a`,`test`.`s25`.`b` AS `b`,`test`.`s26`.`a` AS `a`,`test`.`s26`.`b` AS `b`,`test`.`s27`.`a` AS `a`,`test`.`s27`.`b` AS `b`,`test`.`s28`.`a` AS `a`,`test`.`s28`.`b` AS `b`,`test`.`s29`.`a` AS `a`,`test`.`s29`.`b` AS `b`,`test`.`s30`.`a` AS `a`,`test`.`s30`.`b` AS `b`,`test`.`s31`.`a` AS `a`,`test`.`s31`.`b` AS `b`,`test`.`s32`.`a` AS `a`,`test`.`s32`.`b` AS `b`,`test`.`s33`.`a` AS `a`,`test`.`s33`.`b` AS `b`,`test`.`s34`.`a` AS `a`,`test`.`s34`.`b` AS `b`,`test`.`s35`.`a` AS `a`,`test`.`s35`.`b` AS `b`,`test`.`s36`.`a` AS `a`,`test`.`s36`.`b` AS `b`,`test`.`s37`.`a` AS `a`,`test`.`s37`.`b` AS `b`,`test`.`s38`.`a` AS `a`,`test`.`s38`.`b` AS `b`,`test`.`s39`.`a` AS `a`,`test`.`s39`.`b` AS `b`,`test`.`s40`.`a` AS `a`,`test`.`s40`.`b` AS `b`,`test`.`s41`.`a` AS `a`,`test`.`s41`.`b` AS `b`,`test`.`s42`.`a` AS `a`,`test`.`s42`.`b` AS `b`,`test`.`s43`.`a` AS `a`,`test`.`s43`.`b` AS `b`,`test`.`s44`.`a` AS `a`,`test`.`s44`.`b` AS `b`,`test`.`s45`.`a` AS `a`,`test`.`s45`.`b` AS `b`,`test`.`s46`.`a` AS `a`,`test`.`s46`.`b` AS `b`,`test`.`s47`.`a` AS `a`,`test`.`s47`.`b` AS `b`,`test`.`s48`.`a` AS `a`,`test`.`s48`.`b` AS `b`,`test`.`s49`.`a` AS `a`,`test`.`s49`.`b` AS `b` from `test`.`t1` `s00` join `test`.`t1` `s01` join `test`.`t1` `s02` join `test`.`t1` `s03` join `test`.`t1` `s04` join `test`.`t1` `s05` join `test`.`t1` `s06` join `test`.`t1` `s07` join `test`.`t1` `s08` join `test`.`t1` `s09` join `test`.`t1` `s10` join `test`.`t1` `s11` join `test`.`t1` `s12` join `test`.`t1` `s13` join `test`.`t1` `s14` join `test`.`t1` `s15` join `test`.`t1` `s16` join `test`.`t1` `s17` join `test`.`t1` `s18` join `test`.`t1` `s19` join `test`.`t1` `s20` join `test`.`t1` `s21` join `test`.`t1` `s22` join `test`.`t1` `s23` join `test`.`t1` `s24` join `test`.`t1` `s25` join `test`.`t1` `s26` join `test`.`t1` `s27` join `test`.`t1` `s28` join `test`.`t1` `s29` join `test`.`t1` `s30` join `test`.`t1` `s31` join `test`.`t1` `s32` join `test`.`t1` `s33` join `test`.`t1` `s34` join `test`.`t1` `s35` join `test`.`t1` `s36` join `test`.`t1` `s37` join `test`.`t1` `s38` join `test`.`t1` `s39` join `test`.`t1` `s40` join `test`.`t1` `s41` join `test`.`t1` `s42` join `test`.`t1` `s43` join `test`.`t1` `s44` join `test`.`t1` `s45` join `test`.`t1` `s46` join `test`.`t1` `s47` join `test`.`t1` `s48` join `test`.`t1` `s49` where (`test`.`s00`.`a`,`test`.`s00`.`a` in ( (/* select#2 */ select `test`.`m00`.`a` from `test`.`t1` `m00` join `test`.`t1` `m01` join `test`.`t1` `m02` join `test`.`t1` `m03` join `test`.`t1` `m04` join `test`.`t1` `m05` join `test`.`t1` `m06` join `test`.`t1` `m07` join `test`.`t1` `m08` join `test`.`t1` `m09` join `test`.`t1` `m10` join `test`.`t1` `m11` join `test`.`t1` `m12` join `test`.`t1` `m13` join `test`.`t1` `m14` join `test`.`t1` `m15` join `test`.`t1` `m16` join `test`.`t1` `m17` join `test`.`t1` `m18` join `test`.`t1` `m19` where true ), (`test`.`s00`.`a` in on where ((`test`.`s00`.`a` = ``.`a`))))) 2343s select * from 2343s 2343s mysqltest: Result content mismatch 2343s 2343s 2343s The result from queries just before the failure was: 2343s EXPLAIN FORMAT=tree SELECT * FROM t1 WHERE EXISTS ( SELECT alias1.f2 FROM t2 LEFT JOIN t1 ON 1 LEFT JOIN t1 AS alias1 ON 1 ); 2343s EXPLAIN 2343s -> Nested loop inner join (cost=12.4 rows=54) 2343s -> Constant row from (cost=6.72..6.72 rows=1) 2343s -> Materialize with deduplication (cost=6.65..6.65 rows=18) 2343s -> Nested loop left join (cost=4.85 rows=18) 2343s -> Nested loop left join (cost=1.55 rows=6) 2343s -> Table scan on t2 (cost=0.45 rows=2) 2343s -> Table scan on t1 (cost=0.4 rows=3) 2343s -> Table scan on alias1 (cost=0.3 rows=3) 2343s -> Table scan on t1 (cost=0.55 rows=3) 2343s 2343s SELECT * FROM t1 WHERE EXISTS ( SELECT alias1.f2 FROM t2 LEFT JOIN t1 ON 1 LEFT JOIN t1 AS alias1 ON 1 ); 2343s f1 f2 2343s 08:35:24 X 2343s 11:22:33 Q 2343s 14:51:13 S 2343s DROP TABLE t1, t2; 2343s set optimizer_switch=default; 2343s set optimizer_switch=default; 2343s safe_process[51308]: Child process: 51309, exit: 1 2343s 2343s - the logfile can be found in '/tmp/tmp.S4l2H0nLf2/var/log/main.subquery_sj_mat_bka_nobnl/subquery_sj_mat_bka_nobnl.log' 2343s 2343s Retrying test main.subquery_sj_mat_bka_nobnl, attempt(2/3). 2343s 2344s [ 83%] main.subquery_all_bka w3 [ pass ] 13720 2345s [ 83%] main.select_icp_mrr_bka_nobnl w4 [ pass ] 7045 2351s [ 83%] main.ctype_uca w2 [ pass ] 9239 2352s [ 83%] main.subquery_sj_mat_bka_nobnl w1 [ retry-pass ] 7679 2352s Retrying test main.subquery_sj_mat_bka_nobnl, attempt(3/3). 2352s 2352s [ 83%] main.select_none w4 [ pass ] 6505 2358s [ 83%] main.subquery_all_bka_nobnl w3 [ pass ] 13500 2358s [ 83%] main.subquery_antijoin w3 [ pass ] 455 2360s [ 83%] main.select_none_bka w4 [ pass ] 7121 2360s [ 83%] main.subquery_sj_mat_bka_nobnl w1 [ retry-pass ] 8057 2361s [ 83%] main.ctype_ucs w2 [ pass ] 5649 2361s [ 83%] main.subquery_bugs w3 [ pass ] 2101 2361s [ 83%] main.subquery_exists w3 [ pass ] 76 2361s [ 83%] main.subquery_hypergraph w3 [ skipped ] Test requires binaries built with WITH_HYPERGRAPH_OPTIMIZER=ON 2363s [ 83%] main.ctype_ujis_ucs2 w2 [ pass ] 2125 2363s [ 83%] main.subquery_mat w3 [ pass ] 1772 2364s [ 83%] main.ctype_unicode900 w2 [ pass ] 798 2365s [ 84%] main.ctype_unicode900_as_ci w2 [ pass ] 596 2365s [ 84%] main.subquery_mat_all w3 [ pass ] 1754 2366s [ 84%] main.ctype_unicode900_as_cs w2 [ pass ] 871 2366s [ 84%] main.subquery_mat_mixed_types w3 [ pass ] 648 2367s [ 84%] main.select_none_bka_nobnl w4 [ pass ] 7008 2367s [ 84%] main.ctype_utf16 w2 [ pass ] 830 2367s [ 84%] main.select_safe w4 [ pass ] 191 2368s [ 84%] main.subquery_sj_mat_nosj w1 [ pass ] 7546 2368s [ 84%] main.ctype_utf16_uca w2 [ pass ] 602 2368s [ 84%] main.subquery_mat_none w3 [ pass ] 1582 2369s [ 84%] main.ctype_utf16le w2 [ pass ] 940 2371s [ 84%] main.ctype_utf32 w2 [ pass ] 830 2371s [ 84%] main.ctype_utf32_uca w2 [ pass ] 653 2372s [ 84%] main.ctype_utf8mb4_heap w2 [ pass ] 748 2373s [ 84%] main.ctype_utf8mb4_uca w2 [ pass ] 238 2375s [ 85%] main.subquery_sj_none w1 [ pass ] 6989 2377s [ 85%] main.sensitive_variables_upgrade w4 [ pass ] 7039 2378s [ 85%] main.datadir_permission w2 [ pass ] 4940 2378s [ 85%] main.server_offline_1 w4 [ pass ] 118 2379s [ 85%] main.server_offline_2 w4 [ pass ] 135 2379s [ 85%] main.date_formats w2 [ pass ] 185 2379s [ 85%] main.server_offline_3 w4 [ pass ] 23 2379s [ 85%] main.dd_column_and_index_name_collation w2 [ pass ] 66 2379s [ 85%] main.dd_is_compatibility_ci w2 [ skipped ] Test requires 'case_insensitive_file_system' 2380s [ 85%] main.server_offline_5 w4 [ pass ] 661 2381s [ 85%] main.subquery_nomat_nosj w3 [ pass ] 12679 2382s [ 85%] main.subquery_sj_none_bka w1 [ pass ] 6529 2389s [ 85%] main.subquery_sj_none_bka_nobnl w1 [ pass ] 6107 2389s [ 85%] main.subquery_table_to_derived w1 [ pass ] 144 2389s [ 86%] main.subselect w1 [ pass ] 61 2390s [ 86%] main.subselect_innodb w1 [ pass ] 551 2391s [ 86%] main.sum_distinct w1 [ pass ] 153 2391s [ 86%] main.server_uuid w4 [ pass ] 10750 2391s [ 86%] main.show_processlist_state w4 [ pass ] 1 2391s [ 86%] main.synchronization w1 [ pass ] 273 2391s [ 86%] main.show_profile w4 [ pass ] 1 2392s [ 86%] main.show_variables w4 [ pass ] 40 2393s [ 86%] main.subquery_nomat_nosj_bka w3 [ pass ] 11477 2396s [ 86%] main.dd_is_compatibility_cs w2 [ pass ] 16063 2396s [ 86%] main.dd_is_concurrency w2 [ skipped ] Test requires 'have_debug_sync' 2396s [ 86%] main.dd_is_gcov w2 [ pass ] 58 2396s [ 86%] main.dd_is_view_usage w2 [ pass ] 176 2397s [ 86%] main.dd_stages w2 [ pass ] 149 2397s [ 86%] main.dd_string w2 [ pass ] 102 2397s [ 87%] main.dd_upgrade_ci w2 [ skipped ] Test requires 'case_insensitive_file_system' 2397s [ 87%] main.sys_accounts_auth_upgrade w1 [ pass ] 6131 2398s [ 87%] main.dd_upgrade_error_ci w2 [ skipped ] Test requires 'case_insensitive_file_system' 2401s [ 87%] main.system_mysql_db w1 [ pass ] 9 2401s [ 87%] main.system_mysql_db_refs w1 [ pass ] 135 2404s [ 87%] main.subquery_nomat_nosj_bka_nobnl w3 [ pass ] 10710 2405s [ 87%] main.dd_upgrade_error_cs w2 [ pass ] 7619 2405s [ 87%] main.table_lock_skip_lock_nowait w1 [ pass ] 4069 2406s [ 87%] main.table_value_constructor w1 [ pass ] 342 2406s [ 87%] main.table_value_constructor_hypergraph w1 [ skipped ] Test requires binaries built with WITH_HYPERGRAPH_OPTIMIZER=ON 2406s [ 87%] main.dd_view_columns w2 [ pass ] 516 2407s [ 87%] main.tablelock w1 [ pass ] 118 2407s [ 87%] main.tablesample w1 [ pass ] 4 2407s [ 87%] main.temporal_literal w1 [ pass ] 281 2407s [ 88%] main.ddl_i18n_koi8r w2 [ pass ] 962 2408s [ 88%] main.temptable w1 [ pass ] 745 2409s [ 88%] main.temptable_256_fields w1 [ pass ] 16 2409s [ 88%] main.shutdown w4 [ pass ] 16679 2409s [ 88%] main.ddl_i18n_utf8 w2 [ pass ] 998 2409s [ 88%] main.temptable_no_pad_collation w1 [ pass ] 89 2409s [ 88%] main.thread_cache_size w1 [ pass ] 9 2410s [ 88%] main.signal w4 [ pass ] 745 2410s [ 88%] main.signal_demo1 w4 [ pass ] 146 2410s [ 88%] main.signal_demo2 w4 [ pass ] 16 2410s [ 88%] main.time_truncate_fractional w1 [ pass ] 857 2411s [ 88%] main.signal_demo3 w4 [ pass ] 21 2411s [ 88%] main.signal_sqlmode w4 [ pass ] 19 2412s [ 88%] main.time_truncate_fractional_strict w1 [ pass ] 853 2415s [ 88%] main.time_zone w1 [ skipped ] Test requires 'have_met_timezone' 2415s [ 89%] main.deadlock_innodb w2 [ pass ] 6138 2415s [ 89%] main.debug_sync w2 [ skipped ] Test requires 'have_debug_sync' 2416s [ 89%] main.default w2 [ pass ] 203 2417s [ 89%] main.subquery_none w3 [ pass ] 12164 2417s [ 89%] main.delete w2 [ pass ] 1267 2418s [ 89%] main.time_zone2 w1 [ pass ] 182 2419s [ 89%] main.sigusr1 w4 [ pass ] 7879 2420s [ 89%] main.time_zone4 w1 [ pass ] 1 2421s [ 89%] main.deprecate_eof w2 [ pass ] 3010 2421s [ 89%] main.deprecated_features w2 [ pass ] 270 2421s [ 89%] main.derived_ci w2 [ skipped ] Test requires 'case_insensitive_file_system' 2422s [ 89%] main.skip_scan w4 [ pass ] 2366 2422s [ 89%] main.skip_scan_hypergraph w4 [ skipped ] Test requires binaries built with WITH_HYPERGRAPH_OPTIMIZER=ON 2423s [ 89%] main.derived_condition_pushdown w2 [ pass ] 881 2423s [ 90%] main.sp-big w4 [ pass ] 1313 2424s [ 90%] main.derived_correlated w2 [ pass ] 828 2424s [ 90%] main.time_zone_dst w1 [ pass ] 36 2424s [ 90%] main.derived_correlated_hypergraph w2 [ skipped ] Test requires binaries built with WITH_HYPERGRAPH_OPTIMIZER=ON 2424s [ 90%] main.sp-bugs w4 [ pass ] 277 2424s [ 90%] main.derived_cs w2 [ pass ] 2 2424s [ 90%] main.sp-destruct w4 [ pass ] 16 2424s [ 90%] main.derived_limit w2 [ pass ] 39 2425s [ 90%] main.sp-dynamic w4 [ pass ] 252 2426s [ 90%] main.desc_index_innodb w2 [ pass ] 852 2426s [ 90%] main.dictionary_timestamp w2 [ pass ] 202 2426s [ 90%] main.sp-error w4 [ pass ] 1210 2427s [ 90%] main.time_zone_grant w1 [ pass ] 86 2427s [ 90%] main.sp-external w4 [ pass ] 542 2427s [ 90%] main.dirty_close w2 [ pass ] 1067 2427s [ 91%] main.time_zone_with_dst w1 [ pass ] 109 2427s [ 91%] main.sp-fib w4 [ pass ] 53 2428s [ 91%] main.disconnect_on_expired_password_default w2 [ pass ] 105 2428s [ 91%] main.timestamps_in_priv_tables w1 [ pass ] 200 2429s [ 91%] main.sp-lock w4 [ pass ] 1339 2429s [ 91%] main.distinct w2 [ pass ] 1103 2429s [ 91%] main.subquery_none_bka w3 [ pass ] 12270 2429s [ 91%] main.sp-no-code w4 [ pass ] 1 2429s [ 91%] main.distinct_innodb w2 [ pass ] 116 2430s [ 91%] main.dollar_identifier w2 [ pass ] 117 2430s [ 91%] main.sp-prelocking w4 [ pass ] 415 2430s [ 91%] main.sp-prelocking_cs w4 [ pass ] 54 2431s [ 91%] main.drop w2 [ pass ] 702 2431s [ 91%] main.sp-security w4 [ pass ] 541 2431s [ 92%] main.empty_table w2 [ pass ] 25 2432s [ 92%] main.sp-ucs2 w4 [ pass ] 68 2432s [ 92%] main.endspace w2 [ pass ] 203 2432s [ 92%] main.type_nchar w4 [ pass ] 88 2432s [ 92%] main.engine_attribute w2 [ pass ] 284 2433s [ 92%] main.errors w2 [ pass ] 310 2433s [ 92%] main.type_newdecimal w4 [ pass ] 1321 2434s [ 92%] main.events_1 w2 [ pass ] 382 2434s [ 92%] main.type_ranges w4 [ pass ] 372 2434s [ 92%] main.events_2 w2 [ pass ] 453 2434s [ 92%] main.type_set w4 [ pass ] 157 2435s [ 92%] main.type_string w4 [ pass ] 35 2436s [ 92%] main.events_and_binlog w2 [ pass ] 1011 2436s [ 92%] main.tmpdir w1 [ pass ] 8086 2437s [ 92%] main.trans_read_only w1 [ pass ] 114 2437s [ 93%] main.events_and_binlog_format_row w2 [ pass ] 1042 2437s [ 93%] main.events_grant w2 [ pass ] 153 2439s [ 93%] main.trigger-trans w1 [ pass ] 2336 2441s [ 93%] main.events_logs_tests w2 [ pass ] 3157 2441s [ 93%] main.events_microsec w2 [ pass ] 5 2441s [ 93%] main.user_account_password_lock w2 [ pass ] 184 2442s [ 93%] main.user_comment w2 [ pass ] 106 2442s [ 93%] main.subquery_none_bka_nobnl w3 [ pass ] 12283 2444s [ 93%] main.subquery_scalar_to_derived w3 [ pass ] 1398 2444s [ 93%] main.trigger w1 [ pass ] 4781 2445s [ 93%] main.subquery_scalar_to_derived_correlated w3 [ pass ] 829 2445s [ 93%] main.type_temporal_fractional w4 [ pass ] 9926 2446s [ 93%] main.type_time w4 [ pass ] 442 2446s [ 93%] main.trigger_before_not_null w1 [ pass ] 1148 2446s [ 94%] main.type_uint w4 [ pass ] 19 2447s [ 94%] main.type_varchar w4 [ pass ] 522 2447s [ 94%] main.trigger_multiple w1 [ pass ] 605 2447s [ 94%] main.user_if_exists w2 [ pass ] 4721 2447s [ 94%] main.truncate w1 [ pass ] 207 2447s [ 94%] main.type_year w4 [ pass ] 280 2447s [ 94%] main.user_limits w2 [ pass ] 66 2447s [ 94%] main.truncate_coverage w1 [ skipped ] Test requires 'have_debug_sync' 2448s [ 94%] main.truth_value_transform w1 [ pass ] 18 2448s [ 94%] main.type_binary w1 [ pass ] 284 2449s [ 94%] main.type_bit_innodb w1 [ pass ] 218 2449s [ 94%] main.user_lock w2 [ pass ] 1354 2450s [ 94%] main.user_password_history w2 [ pass ] 351 2450s [ 94%] main.type_blob w1 [ pass ] 745 2450s [ 94%] main.user_var-binlog w2 [ pass ] 138 2451s [ 95%] main.user_var w2 [ pass ] 685 2451s [ 95%] main.type_date w1 [ pass ] 769 2451s [ 95%] main.using_hypergraph_optimizer w2 [ skipped ] Test requires binaries built with WITH_HYPERGRAPH_OPTIMIZER=ON 2452s [ 95%] main.varbinary w2 [ pass ] 180 2452s [ 95%] main.variables-win w2 [ skipped ] Need windows 2452s [ 95%] main.subquery_sj_all w3 [ pass ] 6754 2452s [ 95%] main.type_datetime w1 [ pass ] 950 2452s [ 95%] main.variables w2 [ pass ] 290 2452s [ 95%] main.variables_community w2 [ pass ] 2 2453s [ 95%] main.variables_dynamic_privs w2 [ pass ] 29 2453s [ 95%] main.type_decimal w1 [ pass ] 724 2454s [ 95%] main.type_enum w1 [ pass ] 836 2456s [ 95%] main.type_float w1 [ pass ] 1330 2456s [ 95%] main.view_alias w1 [ pass ] 136 2457s [ 96%] main.view_alias_bug32695103 w1 [ pass ] 36 2459s [ 96%] main.view_grant w1 [ pass ] 2134 2459s [ 96%] main.subquery_sj_all_bka w3 [ pass ] 6866 2460s [ 96%] main.view w2 [ pass ] 6487 2460s [ 96%] main.window_functions_interesting_orders w2 [ skipped ] Test requires binaries built with WITH_HYPERGRAPH_OPTIMIZER=ON 2460s [ 96%] main.window_jsonaggs w2 [ pass ] 91 2461s [ 96%] main.window_min_max w2 [ pass ] 352 2461s [ 96%] main.window_std_var w2 [ pass ] 340 2462s [ 96%] main.window_std_var_optimized w2 [ pass ] 316 2462s [ 96%] main.udf_bug35242734 w4 [ pass ] 14379 2462s [ 96%] main.windows w2 [ skipped ] Need windows 2462s [ 96%] main.with_explain w2 [ pass ] 20 2462s [ 96%] main.unary_query_term w4 [ pass ] 194 2462s [ 96%] main.with_grant w2 [ pass ] 23 2463s [ 96%] main.undo_tablespace w4 [ pass ] 291 2463s [ 97%] main.unique_option_prefixes w4 [ pass ] 7 2464s [ 97%] main.with_non_recursive w2 [ pass ] 772 2465s [ 97%] main.with_non_recursive_bugs w2 [ pass ] 687 2465s [ 97%] main.with_recursive w2 [ pass ] 447 2465s [ 97%] main.unix_wait_timeout w4 [ pass ] 2011 2466s [ 97%] main.subquery_sj_all_bka_nobnl w3 [ pass ] 6115 2466s [ 97%] main.with_recursive_bugs w2 [ pass ] 166 2467s [ 97%] main.wait_timeout w1 [ pass ] 8071 2468s [ 97%] main.warnings_engine_disabled w1 [ pass ] 2 2468s [ 97%] main.window_bitwise_ops w1 [ pass ] 187 2468s [ 97%] main.unsafe_binlog_innodb w4 [ pass ] 2280 2468s [ 97%] main.upd_del_single_to_multi w4 [ pass ] 143 2470s [ 97%] main.update w4 [ pass ] 1053 2470s [ 97%] main.upgrade w4 [ pass ] 164 2470s [ 98%] main.with_recursive_innodb_tmp_table w2 [ pass ] 4438 2470s [ 98%] main.with_recursive_solver w4 [ pass ] 20 2471s [ 98%] main.with_recursive_kill w2 [ skipped ] Test requires 'have_debug_sync' 2471s [ 98%] main.window_functions w1 [ pass ] 3031 2473s [ 98%] main.subquery_sj_dupsweed w3 [ pass ] 6652 2473s [ 98%] main.window_functions_bugs w1 [ pass ] 1119 2474s [ 98%] main.window_functions_explain w1 [ pass ] 614 2474s [ 98%] main.window_functions_in2exists w1 [ pass ] 44 2474s [ 98%] main.window_functions_in2exists_hypergraph w1 [ skipped ] Test requires binaries built with WITH_HYPERGRAPH_OPTIMIZER=ON 2474s [ 98%] main.year-csv w1 [ pass ] 233 2475s [ 98%] main.year-innodb w1 [ pass ] 363 2476s [ 98%] main.year-memory w1 [ pass ] 213 2476s [ 98%] main.year-merge w1 [ pass ] 17 2479s [ 98%] main.subquery_sj_dupsweed_bka w3 [ pass ] 6312 2482s [ 98%] main.wl14965 w4 [ pass ] 11422 2483s [ 99%] main.subquery_sj_dupsweed_bka_nobnl w1 [ pass ] 6513 2485s [ 99%] main.xa_applier_crash_mdl w4 [ pass ] 89 2486s [ 99%] main.subquery_sj_firstmatch w3 [ pass ] 6802 2489s [ 99%] main.xa_mdl_backup w2 [ pass ] 18065 2489s [ 99%] main.xml w2 [ pass ] 58 2490s [ 99%] main.xml_report_invalid_chars w2 [ skipped ] Characters replaced in --xml-report: ' " < > & 2490s [ 99%] main.subquery_sj_firstmatch_bka w1 [ pass ] 6727 2493s [ 99%] main.subquery_sj_firstmatch_bka_nobnl w3 [ pass ] 5986 2497s [ 99%] main.xa_detach_on_prepare_off w2 [ pass ] 6989 2504s [ 99%] main.xa_default w4 [ pass ] 18600 2507s [ 99%] main.archive_plugin w4 [ skipped ] archive plugin not available 2508s [ 99%] main.blackhole_plugin w4 [ skipped ] blackhole plugin not available; 2515s [ 99%] main.events_read_only w4 [ pass ] 4265 2519s [ 99%] main.log_backtrace w4 [ pass ] 1817 2519s [100%] shutdown_report w0 [ pass ] 2519s ------------------------------------------------------------------------------ 2519s The servers were restarted 182 times 2519s The servers were reinitialized 6 times 2519s Spent 2575.986 of 883 seconds executing testcases 2519s 2519s Completed: Failed 1/1090 tests, 99.91% were successful. 2519s 2519s Unstable test(s)(failures/attempts): main.subquery_sj_mat_bka_nobnl(1/3) 2519s 2519s The log files in var/log may give you some hint of what went wrong. 2519s 2519s If you want to report this error, please read first the documentation 2519s at http://dev.mysql.com/doc/mysql/en/mysql-test-suite.html 2519s 2519s 351 tests were skipped, 104 by the test itself. 2519s 2519s mysql-test-run: WARNING: There are failures due to unstable test cases. 2519s However, the tests are not hard-failing. 2519s run: OK 2520s autopkgtest [16:28:23]: test upstream: -----------------------] 2521s upstream PASS 2521s autopkgtest [16:28:24]: test upstream: - - - - - - - - - - results - - - - - - - - - - 2521s autopkgtest [16:28:24]: @@@@@@@@@@@@@@@@@@@@ summary 2521s smoke PASS 2521s upstream PASS 2540s nova [W] Using flock in prodstack6-s390x 2540s Creating nova instance adt-plucky-s390x-mysql-8.4-20250315-154623-juju-7f2275-prod-proposed-migration-environment-2-4120a1ef-f5fe-4555-b1ea-716cfb556434 from image adt/ubuntu-plucky-s390x-server-20250315.img (UUID 3d3557fa-fd0f-4bba-9b89-8d5964e09f61)... 2540s nova [W] Timed out waiting for f78eaa96-cab5-4bb8-9186-ff182c268016 to get deleted. 2540s nova [W] Using flock in prodstack6-s390x 2540s Creating nova instance adt-plucky-s390x-mysql-8.4-20250315-154623-juju-7f2275-prod-proposed-migration-environment-2-4120a1ef-f5fe-4555-b1ea-716cfb556434 from image adt/ubuntu-plucky-s390x-server-20250315.img (UUID 3d3557fa-fd0f-4bba-9b89-8d5964e09f61)... 2540s nova [W] Timed out waiting for 35c1217e-f195-4e26-93d9-348c4ab4731b to get deleted.