0s autopkgtest [01:29:38]: starting date and time: 2024-06-08 01:29:38+0000 0s autopkgtest [01:29:38]: git checkout: 433ed4cb Merge branch 'skia/nova_flock' into 'ubuntu/5.34+prod' 0s autopkgtest [01:29:38]: host juju-7f2275-prod-proposed-migration-environment-2; command line: /home/ubuntu/autopkgtest/runner/autopkgtest --output-dir /tmp/autopkgtest-work.3pi_rg3u/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@bos02-ppc64el-17.secgroup --name adt-oracular-ppc64el-python-sql-20240608-012938-juju-7f2275-prod-proposed-migration-environment-2-7306cb81-e4bb-49d2-8dc5-cb7e01fa4d2f --image adt/ubuntu-oracular-ppc64el-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://ftpmaster.internal/ubuntu/ 184s autopkgtest [01:32:42]: testbed dpkg architecture: ppc64el 185s autopkgtest [01:32:43]: testbed apt version: 2.9.3 185s autopkgtest [01:32:43]: @@@@@@@@@@@@@@@@@@@@ test bed setup 186s Get:1 http://ftpmaster.internal/ubuntu oracular-proposed InRelease [110 kB] 186s Get:2 http://ftpmaster.internal/ubuntu oracular-proposed/universe Sources [339 kB] 186s Get:3 http://ftpmaster.internal/ubuntu oracular-proposed/main Sources [44.3 kB] 186s Get:4 http://ftpmaster.internal/ubuntu oracular-proposed/restricted Sources [7972 B] 186s Get:5 http://ftpmaster.internal/ubuntu oracular-proposed/multiverse Sources [2864 B] 186s Get:6 http://ftpmaster.internal/ubuntu oracular-proposed/main ppc64el Packages [54.3 kB] 186s Get:7 http://ftpmaster.internal/ubuntu oracular-proposed/restricted ppc64el Packages [1860 B] 186s Get:8 http://ftpmaster.internal/ubuntu oracular-proposed/universe ppc64el Packages [303 kB] 186s Get:9 http://ftpmaster.internal/ubuntu oracular-proposed/multiverse ppc64el Packages [1768 B] 186s Fetched 866 kB in 1s (852 kB/s) 187s Reading package lists... 189s Reading package lists... 189s Building dependency tree... 189s Reading state information... 189s Calculating upgrade... 189s The following packages will be upgraded: 189s debianutils libheif-plugin-aomdec libheif-plugin-aomenc 189s libheif-plugin-libde265 libheif1 libnetplan1 netplan-generator netplan.io 189s python3-netplan 190s 9 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 190s Need to get 731 kB of archives. 190s After this operation, 5120 B of additional disk space will be used. 190s Get:1 http://ftpmaster.internal/ubuntu oracular/main ppc64el debianutils ppc64el 5.18 [90.5 kB] 190s Get:2 http://ftpmaster.internal/ubuntu oracular/main ppc64el netplan-generator ppc64el 1.0-3ubuntu1 [59.3 kB] 190s Get:3 http://ftpmaster.internal/ubuntu oracular/main ppc64el python3-netplan ppc64el 1.0-3ubuntu1 [21.8 kB] 190s Get:4 http://ftpmaster.internal/ubuntu oracular/main ppc64el netplan.io ppc64el 1.0-3ubuntu1 [66.6 kB] 190s Get:5 http://ftpmaster.internal/ubuntu oracular/main ppc64el libnetplan1 ppc64el 1.0-3ubuntu1 [138 kB] 190s Get:6 http://ftpmaster.internal/ubuntu oracular/main ppc64el libheif-plugin-aomdec ppc64el 1.17.6-3 [10.2 kB] 190s Get:7 http://ftpmaster.internal/ubuntu oracular/main ppc64el libheif-plugin-aomenc ppc64el 1.17.6-3 [16.6 kB] 190s Get:8 http://ftpmaster.internal/ubuntu oracular/main ppc64el libheif1 ppc64el 1.17.6-3 [320 kB] 190s Get:9 http://ftpmaster.internal/ubuntu oracular/main ppc64el libheif-plugin-libde265 ppc64el 1.17.6-3 [8484 B] 190s Fetched 731 kB in 1s (1059 kB/s) 191s (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 ... 72602 files and directories currently installed.) 191s Preparing to unpack .../debianutils_5.18_ppc64el.deb ... 191s Unpacking debianutils (5.18) over (5.17build1) ... 191s Setting up debianutils (5.18) ... 191s (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 ... 72602 files and directories currently installed.) 191s Preparing to unpack .../0-netplan-generator_1.0-3ubuntu1_ppc64el.deb ... 191s Adding 'diversion of /lib/systemd/system-generators/netplan to /lib/systemd/system-generators/netplan.usr-is-merged by netplan-generator' 191s Unpacking netplan-generator (1.0-3ubuntu1) over (1.0-2ubuntu1) ... 191s Preparing to unpack .../1-python3-netplan_1.0-3ubuntu1_ppc64el.deb ... 191s Unpacking python3-netplan (1.0-3ubuntu1) over (1.0-2ubuntu1) ... 191s Preparing to unpack .../2-netplan.io_1.0-3ubuntu1_ppc64el.deb ... 191s Unpacking netplan.io (1.0-3ubuntu1) over (1.0-2ubuntu1) ... 191s Preparing to unpack .../3-libnetplan1_1.0-3ubuntu1_ppc64el.deb ... 191s Unpacking libnetplan1:ppc64el (1.0-3ubuntu1) over (1.0-2ubuntu1) ... 191s Preparing to unpack .../4-libheif-plugin-aomdec_1.17.6-3_ppc64el.deb ... 191s Unpacking libheif-plugin-aomdec:ppc64el (1.17.6-3) over (1.17.6-1ubuntu4) ... 191s Preparing to unpack .../5-libheif-plugin-aomenc_1.17.6-3_ppc64el.deb ... 191s Unpacking libheif-plugin-aomenc:ppc64el (1.17.6-3) over (1.17.6-1ubuntu4) ... 191s Preparing to unpack .../6-libheif1_1.17.6-3_ppc64el.deb ... 191s Unpacking libheif1:ppc64el (1.17.6-3) over (1.17.6-1ubuntu4) ... 191s Preparing to unpack .../7-libheif-plugin-libde265_1.17.6-3_ppc64el.deb ... 191s Unpacking libheif-plugin-libde265:ppc64el (1.17.6-3) over (1.17.6-1ubuntu4) ... 191s Setting up libnetplan1:ppc64el (1.0-3ubuntu1) ... 191s Setting up python3-netplan (1.0-3ubuntu1) ... 191s Setting up netplan-generator (1.0-3ubuntu1) ... 191s Removing 'diversion of /lib/systemd/system-generators/netplan to /lib/systemd/system-generators/netplan.usr-is-merged by netplan-generator' 191s Setting up netplan.io (1.0-3ubuntu1) ... 191s Setting up libheif-plugin-aomdec:ppc64el (1.17.6-3) ... 191s Setting up libheif-plugin-libde265:ppc64el (1.17.6-3) ... 191s Setting up libheif1:ppc64el (1.17.6-3) ... 191s Setting up libheif-plugin-aomenc:ppc64el (1.17.6-3) ... 191s Processing triggers for libc-bin (2.39-0ubuntu8.1) ... 191s Processing triggers for man-db (2.12.1-1) ... 193s Processing triggers for dbus (1.14.10-4ubuntu4) ... 193s Reading package lists... 193s Building dependency tree... 193s Reading state information... 193s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 194s Hit:1 http://ftpmaster.internal/ubuntu oracular-proposed InRelease 194s Hit:2 http://ftpmaster.internal/ubuntu oracular InRelease 194s Hit:3 http://ftpmaster.internal/ubuntu oracular-updates InRelease 194s Hit:4 http://ftpmaster.internal/ubuntu oracular-security InRelease 195s Reading package lists... 195s Reading package lists... 195s Building dependency tree... 195s Reading state information... 195s Calculating upgrade... 195s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 195s Reading package lists... 196s Building dependency tree... 196s Reading state information... 196s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 199s autopkgtest [01:32:57]: testbed running kernel: Linux 6.8.0-31-generic #31-Ubuntu SMP Sat Apr 20 00:05:55 UTC 2024 199s autopkgtest [01:32:57]: @@@@@@@@@@@@@@@@@@@@ apt-source python-sql 201s Get:1 http://ftpmaster.internal/ubuntu oracular/universe python-sql 1.4.0-1 (dsc) [2334 B] 201s Get:2 http://ftpmaster.internal/ubuntu oracular/universe python-sql 1.4.0-1 (tar) [32.6 kB] 201s Get:3 http://ftpmaster.internal/ubuntu oracular/universe python-sql 1.4.0-1 (asc) [506 B] 201s Get:4 http://ftpmaster.internal/ubuntu oracular/universe python-sql 1.4.0-1 (diff) [25.3 kB] 201s gpgv: Signature made Fri Sep 9 18:56:46 2022 UTC 201s gpgv: using RSA key AC297E5C46B9D0B61C717681D6D09BE48405BBF6 201s gpgv: Can't check signature: No public key 201s dpkg-source: warning: cannot verify inline signature for ./python-sql_1.4.0-1.dsc: no acceptable signature found 201s autopkgtest [01:32:59]: testing package python-sql version 1.4.0-1 201s autopkgtest [01:32:59]: build not needed 202s autopkgtest [01:33:00]: test command1: preparing testbed 203s Reading package lists... 203s Building dependency tree... 203s Reading state information... 203s Starting pkgProblemResolver with broken count: 0 203s Starting 2 pkgProblemResolver with broken count: 0 203s Done 204s The following additional packages will be installed: 204s python3-sql 204s Suggested packages: 204s python3-apsw python3-mysql.connector python3-psycopg2 204s The following NEW packages will be installed: 204s autopkgtest-satdep python3-sql 204s 0 upgraded, 2 newly installed, 0 to remove and 0 not upgraded. 204s Need to get 27.8 kB/28.5 kB of archives. 204s After this operation, 194 kB of additional disk space will be used. 204s Get:1 /tmp/autopkgtest.W6p1iy/1-autopkgtest-satdep.deb autopkgtest-satdep ppc64el 0 [712 B] 204s Get:2 http://ftpmaster.internal/ubuntu oracular/universe ppc64el python3-sql all 1.4.0-1 [27.8 kB] 204s Fetched 27.8 kB in 0s (100 kB/s) 204s Selecting previously unselected package python3-sql. 204s (Reading database ... (Reading database ... 5% (Reading database ... 10% (Reading database ... 15% (Reading database ... 20% (Reading database ... 25% (Reading database ... 30% (Reading database ... 35% (Reading database ... 40% (Reading database ... 45% (Reading database ... 50% (Reading database ... 55% (Reading database ... 60% (Reading database ... 65% (Reading database ... 70% (Reading database ... 75% (Reading database ... 80% (Reading database ... 85% (Reading database ... 90% (Reading database ... 95% (Reading database ... 100% (Reading database ... 72602 files and directories currently installed.) 204s Preparing to unpack .../python3-sql_1.4.0-1_all.deb ... 204s Unpacking python3-sql (1.4.0-1) ... 204s Selecting previously unselected package autopkgtest-satdep. 204s Preparing to unpack .../1-autopkgtest-satdep.deb ... 204s Unpacking autopkgtest-satdep (0) ... 204s Setting up python3-sql (1.4.0-1) ... 205s Setting up autopkgtest-satdep (0) ... 207s (Reading database ... 72640 files and directories currently installed.) 207s Removing autopkgtest-satdep (0) ... 207s autopkgtest [01:33:05]: test command1: cd "$ADTTMP" ; python3 -c "import sql ; print(sql.__version__)" 207s autopkgtest [01:33:05]: test command1: [----------------------- 207s 1.4.0 208s autopkgtest [01:33:06]: test command1: -----------------------] 208s command1 PASS 208s autopkgtest [01:33:06]: test command1: - - - - - - - - - - results - - - - - - - - - - 209s autopkgtest [01:33:07]: test run-testsuite3: preparing testbed 210s Reading package lists... 210s Building dependency tree... 210s Reading state information... 210s Starting pkgProblemResolver with broken count: 0 210s Starting 2 pkgProblemResolver with broken count: 0 210s Done 210s The following additional packages will be installed: 210s python3-iniconfig python3-packaging python3-pluggy python3-pytest 210s The following NEW packages will be installed: 210s autopkgtest-satdep python3-iniconfig python3-packaging python3-pluggy 210s python3-pytest 210s 0 upgraded, 5 newly installed, 0 to remove and 0 not upgraded. 210s Need to get 318 kB/319 kB of archives. 210s After this operation, 1585 kB of additional disk space will be used. 210s Get:1 /tmp/autopkgtest.W6p1iy/2-autopkgtest-satdep.deb autopkgtest-satdep ppc64el 0 [712 B] 211s Get:2 http://ftpmaster.internal/ubuntu oracular/universe ppc64el python3-iniconfig all 1.1.1-2 [6024 B] 211s Get:3 http://ftpmaster.internal/ubuntu oracular/main ppc64el python3-packaging all 24.0-1 [41.1 kB] 211s Get:4 http://ftpmaster.internal/ubuntu oracular/universe ppc64el python3-pluggy all 1.5.0-1 [21.0 kB] 211s Get:5 http://ftpmaster.internal/ubuntu oracular-proposed/universe ppc64el python3-pytest all 8.2.2-1ubuntu1 [250 kB] 211s Fetched 318 kB in 0s (651 kB/s) 211s Selecting previously unselected package python3-iniconfig. 211s (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 ... 72640 files and directories currently installed.) 211s Preparing to unpack .../python3-iniconfig_1.1.1-2_all.deb ... 211s Unpacking python3-iniconfig (1.1.1-2) ... 211s Selecting previously unselected package python3-packaging. 211s Preparing to unpack .../python3-packaging_24.0-1_all.deb ... 211s Unpacking python3-packaging (24.0-1) ... 211s Selecting previously unselected package python3-pluggy. 211s Preparing to unpack .../python3-pluggy_1.5.0-1_all.deb ... 211s Unpacking python3-pluggy (1.5.0-1) ... 211s Selecting previously unselected package python3-pytest. 211s Preparing to unpack .../python3-pytest_8.2.2-1ubuntu1_all.deb ... 211s Unpacking python3-pytest (8.2.2-1ubuntu1) ... 211s Selecting previously unselected package autopkgtest-satdep. 211s Preparing to unpack .../2-autopkgtest-satdep.deb ... 211s Unpacking autopkgtest-satdep (0) ... 211s Setting up python3-iniconfig (1.1.1-2) ... 212s Setting up python3-packaging (24.0-1) ... 212s Setting up python3-pluggy (1.5.0-1) ... 212s Setting up python3-pytest (8.2.2-1ubuntu1) ... 212s Setting up autopkgtest-satdep (0) ... 212s Processing triggers for man-db (2.12.1-1) ... 215s (Reading database ... 72804 files and directories currently installed.) 215s Removing autopkgtest-satdep (0) ... 215s autopkgtest [01:33:13]: test run-testsuite3: [----------------------- 216s ============================= test session starts ============================== 216s platform linux -- Python 3.12.3, pytest-8.2.2, pluggy-1.5.0 216s rootdir: /tmp/autopkgtest.W6p1iy/autopkgtest_tmp 216s collected 167 items 216s 216s test/tests/test_aggregate.py .......... [ 5%] 216s test/tests/test_alias.py . [ 6%] 216s test/tests/test_as.py ... [ 8%] 216s test/tests/test_cast.py .. [ 9%] 216s test/tests/test_collate.py ... [ 11%] 216s test/tests/test_column.py .. [ 12%] 216s test/tests/test_combining_query.py .. [ 13%] 216s test/tests/test_conditionals.py ........ [ 18%] 216s test/tests/test_delete.py ..... [ 21%] 216s test/tests/test_for.py .. [ 22%] 216s test/tests/test_functions.py ............. [ 30%] 216s test/tests/test_insert.py .......... [ 36%] 216s test/tests/test_join.py .... [ 38%] 216s test/tests/test_lateral.py .. [ 40%] 216s test/tests/test_literal.py .. [ 41%] 216s test/tests/test_operators.py ..................................... [ 63%] 216s test/tests/test_order.py ...... [ 67%] 216s test/tests/test_select.py ............................. [ 84%] 216s test/tests/test_table.py .... [ 86%] 216s test/tests/test_update.py ........ [ 91%] 216s test/tests/test_values.py .... [ 94%] 216s test/tests/test_window.py ...... [ 97%] 216s test/tests/test_with.py .... [100%] 216s 216s ============================= 167 passed in 0.30s ============================== 216s autopkgtest [01:33:14]: test run-testsuite3: -----------------------] 217s autopkgtest [01:33:15]: test run-testsuite3: - - - - - - - - - - results - - - - - - - - - - 217s run-testsuite3 PASS 217s autopkgtest [01:33:15]: @@@@@@@@@@@@@@@@@@@@ summary 217s command1 PASS 217s run-testsuite3 PASS 229s nova [W] Using flock in scalingstack-bos02-ppc64el 229s flock: timeout while waiting to get lock 229s Creating nova instance adt-oracular-ppc64el-python-sql-20240608-012938-juju-7f2275-prod-proposed-migration-environment-2-7306cb81-e4bb-49d2-8dc5-cb7e01fa4d2f from image adt/ubuntu-oracular-ppc64el-server-20240607.img (UUID 2e7ff4dd-25ad-4882-8618-1243d2d4ac8e)...