0s autopkgtest [02:41:41]: starting date and time: 2024-06-08 02:41:41+0000 0s autopkgtest [02:41:41]: git checkout: 433ed4cb Merge branch 'skia/nova_flock' into 'ubuntu/5.34+prod' 0s autopkgtest [02:41:41]: host juju-7f2275-prod-proposed-migration-environment-2; command line: /home/ubuntu/autopkgtest/runner/autopkgtest --output-dir /tmp/autopkgtest-work.f9g9l4sl/out --timeout-copy=6000 --setup-commands /home/ubuntu/autopkgtest-cloud/worker-config-production/setup-canonical.sh --apt-pocket=proposed=src:pytest,src:astropy --apt-upgrade python-sql --timeout-short=300 --timeout-copy=20000 --timeout-build=20000 '--env=ADT_TEST_TRIGGERS=pytest/8.2.2-1ubuntu1 astropy/6.0.1-4' -- ssh -s /home/ubuntu/autopkgtest/ssh-setup/nova -- --flavor autopkgtest --security-groups autopkgtest-juju-7f2275-prod-proposed-migration-environment-2@bos01-s390x-5.secgroup --name adt-oracular-s390x-python-sql-20240608-024141-juju-7f2275-prod-proposed-migration-environment-2-76e003fe-1d15-49d4-ad10-66885821fbd2 --image adt/ubuntu-oracular-s390x-server --keyname testbed-juju-7f2275-prod-proposed-migration-environment-2 --net-id=net_prod-proposed-migration -e TERM=linux -e ''"'"'http_proxy=http://squid.internal:3128'"'"'' -e ''"'"'https_proxy=http://squid.internal:3128'"'"'' -e ''"'"'no_proxy=127.0.0.1,127.0.1.1,login.ubuntu.com,localhost,localdomain,novalocal,internal,archive.ubuntu.com,ports.ubuntu.com,security.ubuntu.com,ddebs.ubuntu.com,changelogs.ubuntu.com,keyserver.ubuntu.com,launchpadlibrarian.net,launchpadcontent.net,launchpad.net,10.24.0.0/24,keystone.ps5.canonical.com,objectstorage.prodstack5.canonical.com'"'"'' --mirror=http://us.ports.ubuntu.com/ubuntu-ports/ 135s autopkgtest [02:43:56]: testbed dpkg architecture: s390x 135s autopkgtest [02:43:56]: testbed apt version: 2.9.3 135s autopkgtest [02:43:56]: @@@@@@@@@@@@@@@@@@@@ test bed setup 136s Get:1 http://ftpmaster.internal/ubuntu oracular-proposed InRelease [110 kB] 136s Get:2 http://ftpmaster.internal/ubuntu oracular-proposed/multiverse Sources [2864 B] 136s Get:3 http://ftpmaster.internal/ubuntu oracular-proposed/restricted Sources [7972 B] 136s Get:4 http://ftpmaster.internal/ubuntu oracular-proposed/main Sources [44.3 kB] 136s Get:5 http://ftpmaster.internal/ubuntu oracular-proposed/universe Sources [333 kB] 136s Get:6 http://ftpmaster.internal/ubuntu oracular-proposed/main s390x Packages [47.8 kB] 136s Get:7 http://ftpmaster.internal/ubuntu oracular-proposed/restricted s390x Packages [1860 B] 136s Get:8 http://ftpmaster.internal/ubuntu oracular-proposed/universe s390x Packages [258 kB] 136s Get:9 http://ftpmaster.internal/ubuntu oracular-proposed/multiverse s390x Packages [1768 B] 137s Fetched 808 kB in 1s (1012 kB/s) 137s Reading package lists... 139s Reading package lists... 139s Building dependency tree... 139s Reading state information... 140s Calculating upgrade... 140s The following packages will be upgraded: 140s debianutils libheif-plugin-aomdec libheif-plugin-aomenc 140s libheif-plugin-libde265 libheif1 libnetplan1 liburcu8t64 netplan-generator 140s netplan.io python3-netplan 140s 10 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 140s Need to get 758 kB of archives. 140s After this operation, 48.1 kB disk space will be freed. 140s Get:1 http://ftpmaster.internal/ubuntu oracular/main s390x debianutils s390x 5.18 [90.2 kB] 141s Get:2 http://ftpmaster.internal/ubuntu oracular/main s390x netplan-generator s390x 1.0-3ubuntu1 [59.2 kB] 141s Get:3 http://ftpmaster.internal/ubuntu oracular/main s390x python3-netplan s390x 1.0-3ubuntu1 [22.9 kB] 141s Get:4 http://ftpmaster.internal/ubuntu oracular/main s390x netplan.io s390x 1.0-3ubuntu1 [65.8 kB] 141s Get:5 http://ftpmaster.internal/ubuntu oracular/main s390x libnetplan1 s390x 1.0-3ubuntu1 [125 kB] 141s Get:6 http://ftpmaster.internal/ubuntu oracular/main s390x libheif-plugin-aomdec s390x 1.17.6-3 [10.1 kB] 141s Get:7 http://ftpmaster.internal/ubuntu oracular/main s390x libheif-plugin-aomenc s390x 1.17.6-3 [15.1 kB] 141s Get:8 http://ftpmaster.internal/ubuntu oracular/main s390x libheif1 s390x 1.17.6-3 [295 kB] 141s Get:9 http://ftpmaster.internal/ubuntu oracular/main s390x libheif-plugin-libde265 s390x 1.17.6-3 [8172 B] 141s Get:10 http://ftpmaster.internal/ubuntu oracular/main s390x liburcu8t64 s390x 0.14.0-4 [66.5 kB] 141s Fetched 758 kB in 1s (1225 kB/s) 141s (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 ... 54607 files and directories currently installed.) 141s Preparing to unpack .../debianutils_5.18_s390x.deb ... 141s Unpacking debianutils (5.18) over (5.17build1) ... 141s Setting up debianutils (5.18) ... 142s (Reading database ... (Reading database ... 5% (Reading database ... 10% (Reading database ... 15% (Reading database ... 20% (Reading database ... 25% (Reading database ... 30% (Reading database ... 35% (Reading database ... 40% (Reading database ... 45% (Reading database ... 50% (Reading database ... 55% (Reading database ... 60% (Reading database ... 65% (Reading database ... 70% (Reading database ... 75% (Reading database ... 80% (Reading database ... 85% (Reading database ... 90% (Reading database ... 95% (Reading database ... 100% (Reading database ... 54607 files and directories currently installed.) 142s Preparing to unpack .../0-netplan-generator_1.0-3ubuntu1_s390x.deb ... 142s Adding 'diversion of /lib/systemd/system-generators/netplan to /lib/systemd/system-generators/netplan.usr-is-merged by netplan-generator' 142s Unpacking netplan-generator (1.0-3ubuntu1) over (1.0-2ubuntu1) ... 142s Preparing to unpack .../1-python3-netplan_1.0-3ubuntu1_s390x.deb ... 142s Unpacking python3-netplan (1.0-3ubuntu1) over (1.0-2ubuntu1) ... 142s Preparing to unpack .../2-netplan.io_1.0-3ubuntu1_s390x.deb ... 142s Unpacking netplan.io (1.0-3ubuntu1) over (1.0-2ubuntu1) ... 142s Preparing to unpack .../3-libnetplan1_1.0-3ubuntu1_s390x.deb ... 142s Unpacking libnetplan1:s390x (1.0-3ubuntu1) over (1.0-2ubuntu1) ... 142s Preparing to unpack .../4-libheif-plugin-aomdec_1.17.6-3_s390x.deb ... 142s Unpacking libheif-plugin-aomdec:s390x (1.17.6-3) over (1.17.6-1ubuntu4) ... 142s Preparing to unpack .../5-libheif-plugin-aomenc_1.17.6-3_s390x.deb ... 142s Unpacking libheif-plugin-aomenc:s390x (1.17.6-3) over (1.17.6-1ubuntu4) ... 142s Preparing to unpack .../6-libheif1_1.17.6-3_s390x.deb ... 142s Unpacking libheif1:s390x (1.17.6-3) over (1.17.6-1ubuntu4) ... 142s Preparing to unpack .../7-libheif-plugin-libde265_1.17.6-3_s390x.deb ... 142s Unpacking libheif-plugin-libde265:s390x (1.17.6-3) over (1.17.6-1ubuntu4) ... 142s Preparing to unpack .../8-liburcu8t64_0.14.0-4_s390x.deb ... 142s Unpacking liburcu8t64:s390x (0.14.0-4) over (0.14.0-3.1build1) ... 142s Setting up liburcu8t64:s390x (0.14.0-4) ... 142s Setting up libnetplan1:s390x (1.0-3ubuntu1) ... 142s Setting up python3-netplan (1.0-3ubuntu1) ... 142s Setting up netplan-generator (1.0-3ubuntu1) ... 142s Removing 'diversion of /lib/systemd/system-generators/netplan to /lib/systemd/system-generators/netplan.usr-is-merged by netplan-generator' 142s Setting up netplan.io (1.0-3ubuntu1) ... 142s Setting up libheif-plugin-aomdec:s390x (1.17.6-3) ... 142s Setting up libheif-plugin-libde265:s390x (1.17.6-3) ... 142s Setting up libheif1:s390x (1.17.6-3) ... 142s Setting up libheif-plugin-aomenc:s390x (1.17.6-3) ... 142s Processing triggers for libc-bin (2.39-0ubuntu8.1) ... 142s Processing triggers for man-db (2.12.1-1) ... 143s Processing triggers for dbus (1.14.10-4ubuntu4) ... 143s Reading package lists... 143s Building dependency tree... 143s Reading state information... 144s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 144s Hit:1 http://ftpmaster.internal/ubuntu oracular-proposed InRelease 144s Hit:2 http://ftpmaster.internal/ubuntu oracular InRelease 144s Hit:3 http://ftpmaster.internal/ubuntu oracular-updates InRelease 144s Hit:4 http://ftpmaster.internal/ubuntu oracular-security InRelease 146s Reading package lists... 146s Reading package lists... 146s Building dependency tree... 146s Reading state information... 146s Calculating upgrade... 147s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 147s Reading package lists... 147s Building dependency tree... 147s Reading state information... 147s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 150s autopkgtest [02:44:11]: testbed running kernel: Linux 6.8.0-31-generic #31-Ubuntu SMP Sat Apr 20 00:14:26 UTC 2024 150s autopkgtest [02:44:11]: @@@@@@@@@@@@@@@@@@@@ apt-source python-sql 152s Get:1 http://ftpmaster.internal/ubuntu oracular/universe python-sql 1.4.0-1 (dsc) [2334 B] 152s Get:2 http://ftpmaster.internal/ubuntu oracular/universe python-sql 1.4.0-1 (tar) [32.6 kB] 152s Get:3 http://ftpmaster.internal/ubuntu oracular/universe python-sql 1.4.0-1 (asc) [506 B] 152s Get:4 http://ftpmaster.internal/ubuntu oracular/universe python-sql 1.4.0-1 (diff) [25.3 kB] 152s gpgv: Signature made Fri Sep 9 18:56:46 2022 UTC 152s gpgv: using RSA key AC297E5C46B9D0B61C717681D6D09BE48405BBF6 152s gpgv: Can't check signature: No public key 152s dpkg-source: warning: cannot verify inline signature for ./python-sql_1.4.0-1.dsc: no acceptable signature found 152s autopkgtest [02:44:13]: testing package python-sql version 1.4.0-1 152s autopkgtest [02:44:13]: build not needed 153s autopkgtest [02:44:14]: test command1: preparing testbed 154s Reading package lists... 154s Building dependency tree... 154s Reading state information... 154s Starting pkgProblemResolver with broken count: 0 154s Starting 2 pkgProblemResolver with broken count: 0 154s Done 155s The following additional packages will be installed: 155s python3-sql 155s Suggested packages: 155s python3-apsw python3-mysql.connector python3-psycopg2 155s The following NEW packages will be installed: 155s autopkgtest-satdep python3-sql 155s 0 upgraded, 2 newly installed, 0 to remove and 0 not upgraded. 155s Need to get 27.8 kB/28.5 kB of archives. 155s After this operation, 194 kB of additional disk space will be used. 155s Get:1 /tmp/autopkgtest.djjK1H/1-autopkgtest-satdep.deb autopkgtest-satdep s390x 0 [712 B] 155s Get:2 http://ftpmaster.internal/ubuntu oracular/universe s390x python3-sql all 1.4.0-1 [27.8 kB] 155s Fetched 27.8 kB in 0s (127 kB/s) 155s Selecting previously unselected package python3-sql. 155s (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 ... 54607 files and directories currently installed.) 155s Preparing to unpack .../python3-sql_1.4.0-1_all.deb ... 155s Unpacking python3-sql (1.4.0-1) ... 155s Selecting previously unselected package autopkgtest-satdep. 155s Preparing to unpack .../1-autopkgtest-satdep.deb ... 155s Unpacking autopkgtest-satdep (0) ... 155s Setting up python3-sql (1.4.0-1) ... 156s Setting up autopkgtest-satdep (0) ... 158s (Reading database ... 54645 files and directories currently installed.) 158s Removing autopkgtest-satdep (0) ... 159s autopkgtest [02:44:20]: test command1: cd "$ADTTMP" ; python3 -c "import sql ; print(sql.__version__)" 159s autopkgtest [02:44:20]: test command1: [----------------------- 159s 1.4.0 159s autopkgtest [02:44:20]: test command1: -----------------------] 160s command1 PASS 160s autopkgtest [02:44:21]: test command1: - - - - - - - - - - results - - - - - - - - - - 160s autopkgtest [02:44:21]: test run-testsuite3: preparing testbed 162s Reading package lists... 162s Building dependency tree... 162s Reading state information... 162s Starting pkgProblemResolver with broken count: 0 162s Starting 2 pkgProblemResolver with broken count: 0 162s Done 162s The following additional packages will be installed: 162s python3-iniconfig python3-packaging python3-pluggy python3-pytest 162s The following NEW packages will be installed: 162s autopkgtest-satdep python3-iniconfig python3-packaging python3-pluggy 162s python3-pytest 162s 0 upgraded, 5 newly installed, 0 to remove and 0 not upgraded. 162s Need to get 318 kB/319 kB of archives. 162s After this operation, 1585 kB of additional disk space will be used. 162s Get:1 /tmp/autopkgtest.djjK1H/2-autopkgtest-satdep.deb autopkgtest-satdep s390x 0 [712 B] 163s Get:2 http://ftpmaster.internal/ubuntu oracular/universe s390x python3-iniconfig all 1.1.1-2 [6024 B] 163s Get:3 http://ftpmaster.internal/ubuntu oracular/main s390x python3-packaging all 24.0-1 [41.1 kB] 163s Get:4 http://ftpmaster.internal/ubuntu oracular/universe s390x python3-pluggy all 1.5.0-1 [21.0 kB] 163s Get:5 http://ftpmaster.internal/ubuntu oracular-proposed/universe s390x python3-pytest all 8.2.2-1ubuntu1 [250 kB] 163s Fetched 318 kB in 1s (609 kB/s) 163s Selecting previously unselected package python3-iniconfig. 163s (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 ... 54645 files and directories currently installed.) 163s Preparing to unpack .../python3-iniconfig_1.1.1-2_all.deb ... 163s Unpacking python3-iniconfig (1.1.1-2) ... 163s Selecting previously unselected package python3-packaging. 163s Preparing to unpack .../python3-packaging_24.0-1_all.deb ... 163s Unpacking python3-packaging (24.0-1) ... 163s Selecting previously unselected package python3-pluggy. 163s Preparing to unpack .../python3-pluggy_1.5.0-1_all.deb ... 163s Unpacking python3-pluggy (1.5.0-1) ... 163s Selecting previously unselected package python3-pytest. 163s Preparing to unpack .../python3-pytest_8.2.2-1ubuntu1_all.deb ... 163s Unpacking python3-pytest (8.2.2-1ubuntu1) ... 163s Selecting previously unselected package autopkgtest-satdep. 163s Preparing to unpack .../2-autopkgtest-satdep.deb ... 163s Unpacking autopkgtest-satdep (0) ... 163s Setting up python3-iniconfig (1.1.1-2) ... 164s Setting up python3-packaging (24.0-1) ... 164s Setting up python3-pluggy (1.5.0-1) ... 164s Setting up python3-pytest (8.2.2-1ubuntu1) ... 165s Setting up autopkgtest-satdep (0) ... 165s Processing triggers for man-db (2.12.1-1) ... 167s (Reading database ... 54809 files and directories currently installed.) 167s Removing autopkgtest-satdep (0) ... 168s autopkgtest [02:44:29]: test run-testsuite3: [----------------------- 168s ============================= test session starts ============================== 168s platform linux -- Python 3.12.3, pytest-8.2.2, pluggy-1.5.0 168s rootdir: /tmp/autopkgtest.djjK1H/autopkgtest_tmp 168s collected 167 items 168s 168s test/tests/test_aggregate.py .......... [ 5%] 168s test/tests/test_alias.py . [ 6%] 168s test/tests/test_as.py ... [ 8%] 168s test/tests/test_cast.py .. [ 9%] 168s test/tests/test_collate.py ... [ 11%] 168s test/tests/test_column.py .. [ 12%] 168s test/tests/test_combining_query.py .. [ 13%] 168s test/tests/test_conditionals.py ........ [ 18%] 168s test/tests/test_delete.py ..... [ 21%] 168s test/tests/test_for.py .. [ 22%] 168s test/tests/test_functions.py ............. [ 30%] 168s test/tests/test_insert.py .......... [ 36%] 168s test/tests/test_join.py .... [ 38%] 168s test/tests/test_lateral.py .. [ 40%] 168s test/tests/test_literal.py .. [ 41%] 168s test/tests/test_operators.py ..................................... [ 63%] 168s test/tests/test_order.py ...... [ 67%] 169s test/tests/test_select.py ............................. [ 84%] 169s test/tests/test_table.py .... [ 86%] 169s test/tests/test_update.py ........ [ 91%] 169s test/tests/test_values.py .... [ 94%] 169s test/tests/test_window.py ...... [ 97%] 169s test/tests/test_with.py .... [100%] 169s 169s ============================= 167 passed in 0.27s ============================== 169s autopkgtest [02:44:30]: test run-testsuite3: -----------------------] 169s run-testsuite3 PASS 169s autopkgtest [02:44:30]: test run-testsuite3: - - - - - - - - - - results - - - - - - - - - - 170s autopkgtest [02:44:31]: @@@@@@@@@@@@@@@@@@@@ summary 170s command1 PASS 170s run-testsuite3 PASS 184s nova [W] Using flock in scalingstack-bos01-s390x 184s Creating nova instance adt-oracular-s390x-python-sql-20240608-024141-juju-7f2275-prod-proposed-migration-environment-2-76e003fe-1d15-49d4-ad10-66885821fbd2 from image adt/ubuntu-oracular-s390x-server-20240607.img (UUID 7eeb2415-a1eb-49f2-b205-8690074843ed)...