0s autopkgtest [00:54:47]: starting date and time: 2024-06-08 00:54:47+0000 0s autopkgtest [00:54:47]: git checkout: 433ed4cb Merge branch 'skia/nova_flock' into 'ubuntu/5.34+prod' 0s autopkgtest [00:54:47]: host juju-7f2275-prod-proposed-migration-environment-2; command line: /home/ubuntu/autopkgtest/runner/autopkgtest --output-dir /tmp/autopkgtest-work.ak9_p7bg/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@lcy02-105.secgroup --name adt-oracular-amd64-python-sql-20240608-005447-juju-7f2275-prod-proposed-migration-environment-2-f9b80488-aeb4-4151-853d-c08e0be24db7 --image adt/ubuntu-oracular-amd64-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/ 169s autopkgtest [00:57:36]: testbed dpkg architecture: amd64 170s autopkgtest [00:57:37]: testbed apt version: 2.9.3 170s autopkgtest [00:57:37]: @@@@@@@@@@@@@@@@@@@@ test bed setup 170s Get:1 http://ftpmaster.internal/ubuntu oracular-proposed InRelease [110 kB] 170s Get:2 http://ftpmaster.internal/ubuntu oracular-proposed/universe Sources [339 kB] 170s Get:3 http://ftpmaster.internal/ubuntu oracular-proposed/restricted Sources [7972 B] 170s Get:4 http://ftpmaster.internal/ubuntu oracular-proposed/multiverse Sources [2864 B] 170s Get:5 http://ftpmaster.internal/ubuntu oracular-proposed/main Sources [44.3 kB] 170s Get:6 http://ftpmaster.internal/ubuntu oracular-proposed/main i386 Packages [38.1 kB] 170s Get:7 http://ftpmaster.internal/ubuntu oracular-proposed/main amd64 Packages [66.4 kB] 170s Get:8 http://ftpmaster.internal/ubuntu oracular-proposed/restricted i386 Packages [9340 B] 170s Get:9 http://ftpmaster.internal/ubuntu oracular-proposed/restricted amd64 Packages [27.4 kB] 170s Get:10 http://ftpmaster.internal/ubuntu oracular-proposed/universe i386 Packages [126 kB] 170s Get:11 http://ftpmaster.internal/ubuntu oracular-proposed/universe amd64 Packages [315 kB] 170s Get:12 http://ftpmaster.internal/ubuntu oracular-proposed/multiverse i386 Packages [3368 B] 170s Get:13 http://ftpmaster.internal/ubuntu oracular-proposed/multiverse amd64 Packages [11.7 kB] 170s Fetched 1102 kB in 0s (4321 kB/s) 170s Reading package lists... 172s Reading package lists... 172s Building dependency tree... 172s Reading state information... 172s Calculating upgrade... 172s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 172s Reading package lists... 173s Building dependency tree... 173s Reading state information... 173s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 173s Hit:1 http://ftpmaster.internal/ubuntu oracular-proposed InRelease 173s Hit:2 http://ftpmaster.internal/ubuntu oracular InRelease 173s Hit:3 http://ftpmaster.internal/ubuntu oracular-updates InRelease 173s Hit:4 http://ftpmaster.internal/ubuntu oracular-security InRelease 175s Reading package lists... 175s Reading package lists... 175s Building dependency tree... 175s Reading state information... 176s Calculating upgrade... 176s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 176s Reading package lists... 176s Building dependency tree... 176s Reading state information... 177s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 177s autopkgtest [00:57:44]: testbed running kernel: Linux 6.8.0-31-generic #31-Ubuntu SMP PREEMPT_DYNAMIC Sat Apr 20 00:40:06 UTC 2024 177s autopkgtest [00:57:44]: @@@@@@@@@@@@@@@@@@@@ apt-source python-sql 178s Get:1 http://ftpmaster.internal/ubuntu oracular/universe python-sql 1.4.0-1 (dsc) [2334 B] 178s Get:2 http://ftpmaster.internal/ubuntu oracular/universe python-sql 1.4.0-1 (tar) [32.6 kB] 178s Get:3 http://ftpmaster.internal/ubuntu oracular/universe python-sql 1.4.0-1 (asc) [506 B] 178s Get:4 http://ftpmaster.internal/ubuntu oracular/universe python-sql 1.4.0-1 (diff) [25.3 kB] 178s gpgv: Signature made Fri Sep 9 18:56:46 2022 UTC 178s gpgv: using RSA key AC297E5C46B9D0B61C717681D6D09BE48405BBF6 178s gpgv: Can't check signature: No public key 178s dpkg-source: warning: cannot verify inline signature for ./python-sql_1.4.0-1.dsc: no acceptable signature found 178s autopkgtest [00:57:45]: testing package python-sql version 1.4.0-1 178s autopkgtest [00:57:45]: build not needed 178s autopkgtest [00:57:45]: test command1: preparing testbed 179s Reading package lists... 179s Building dependency tree... 179s Reading state information... 179s Starting pkgProblemResolver with broken count: 0 179s Starting 2 pkgProblemResolver with broken count: 0 179s Done 180s The following additional packages will be installed: 180s python3-sql 180s Suggested packages: 180s python3-apsw python3-mysql.connector python3-psycopg2 180s The following NEW packages will be installed: 180s autopkgtest-satdep python3-sql 180s 0 upgraded, 2 newly installed, 0 to remove and 0 not upgraded. 180s Need to get 27.8 kB/28.5 kB of archives. 180s After this operation, 194 kB of additional disk space will be used. 180s Get:1 /tmp/autopkgtest.tBrrlj/1-autopkgtest-satdep.deb autopkgtest-satdep amd64 0 [712 B] 180s Get:2 http://ftpmaster.internal/ubuntu oracular/universe amd64 python3-sql all 1.4.0-1 [27.8 kB] 180s Fetched 27.8 kB in 0s (862 kB/s) 180s Selecting previously unselected package python3-sql. 181s (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 ... 74365 files and directories currently installed.) 181s Preparing to unpack .../python3-sql_1.4.0-1_all.deb ... 181s Unpacking python3-sql (1.4.0-1) ... 181s Selecting previously unselected package autopkgtest-satdep. 181s Preparing to unpack .../1-autopkgtest-satdep.deb ... 181s Unpacking autopkgtest-satdep (0) ... 181s Setting up python3-sql (1.4.0-1) ... 181s Setting up autopkgtest-satdep (0) ... 183s (Reading database ... 74403 files and directories currently installed.) 183s Removing autopkgtest-satdep (0) ... 183s autopkgtest [00:57:50]: test command1: cd "$ADTTMP" ; python3 -c "import sql ; print(sql.__version__)" 183s autopkgtest [00:57:50]: test command1: [----------------------- 183s 1.4.0 184s autopkgtest [00:57:51]: test command1: -----------------------] 184s autopkgtest [00:57:51]: test command1: - - - - - - - - - - results - - - - - - - - - - 184s command1 PASS 184s autopkgtest [00:57:51]: test run-testsuite3: preparing testbed 185s Reading package lists... 185s Building dependency tree... 185s Reading state information... 185s Starting pkgProblemResolver with broken count: 0 185s Starting 2 pkgProblemResolver with broken count: 0 185s Done 186s The following additional packages will be installed: 186s python3-iniconfig python3-packaging python3-pluggy python3-pytest 186s The following NEW packages will be installed: 186s autopkgtest-satdep python3-iniconfig python3-packaging python3-pluggy 186s python3-pytest 186s 0 upgraded, 5 newly installed, 0 to remove and 0 not upgraded. 186s Need to get 318 kB/319 kB of archives. 186s After this operation, 1585 kB of additional disk space will be used. 186s Get:1 /tmp/autopkgtest.tBrrlj/2-autopkgtest-satdep.deb autopkgtest-satdep amd64 0 [716 B] 186s Get:2 http://ftpmaster.internal/ubuntu oracular/universe amd64 python3-iniconfig all 1.1.1-2 [6024 B] 186s Get:3 http://ftpmaster.internal/ubuntu oracular/main amd64 python3-packaging all 24.0-1 [41.1 kB] 186s Get:4 http://ftpmaster.internal/ubuntu oracular/universe amd64 python3-pluggy all 1.5.0-1 [21.0 kB] 186s Get:5 http://ftpmaster.internal/ubuntu oracular-proposed/universe amd64 python3-pytest all 8.2.2-1ubuntu1 [250 kB] 186s Fetched 318 kB in 0s (8716 kB/s) 186s Selecting previously unselected package python3-iniconfig. 186s (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 ... 74403 files and directories currently installed.) 186s Preparing to unpack .../python3-iniconfig_1.1.1-2_all.deb ... 186s Unpacking python3-iniconfig (1.1.1-2) ... 186s Selecting previously unselected package python3-packaging. 186s Preparing to unpack .../python3-packaging_24.0-1_all.deb ... 186s Unpacking python3-packaging (24.0-1) ... 186s Selecting previously unselected package python3-pluggy. 186s Preparing to unpack .../python3-pluggy_1.5.0-1_all.deb ... 186s Unpacking python3-pluggy (1.5.0-1) ... 186s Selecting previously unselected package python3-pytest. 186s Preparing to unpack .../python3-pytest_8.2.2-1ubuntu1_all.deb ... 186s Unpacking python3-pytest (8.2.2-1ubuntu1) ... 186s Selecting previously unselected package autopkgtest-satdep. 186s Preparing to unpack .../2-autopkgtest-satdep.deb ... 186s Unpacking autopkgtest-satdep (0) ... 186s Setting up python3-iniconfig (1.1.1-2) ... 187s Setting up python3-packaging (24.0-1) ... 187s Setting up python3-pluggy (1.5.0-1) ... 187s Setting up python3-pytest (8.2.2-1ubuntu1) ... 187s Setting up autopkgtest-satdep (0) ... 187s Processing triggers for man-db (2.12.1-1) ... 190s (Reading database ... 74567 files and directories currently installed.) 190s Removing autopkgtest-satdep (0) ... 190s autopkgtest [00:57:57]: test run-testsuite3: [----------------------- 191s ============================= test session starts ============================== 191s platform linux -- Python 3.12.3, pytest-8.2.2, pluggy-1.5.0 191s rootdir: /tmp/autopkgtest.tBrrlj/autopkgtest_tmp 191s collected 167 items 191s 191s test/tests/test_aggregate.py .......... [ 5%] 191s test/tests/test_alias.py . [ 6%] 191s test/tests/test_as.py ... [ 8%] 191s test/tests/test_cast.py .. [ 9%] 191s test/tests/test_collate.py ... [ 11%] 191s test/tests/test_column.py .. [ 12%] 191s test/tests/test_combining_query.py .. [ 13%] 191s test/tests/test_conditionals.py ........ [ 18%] 191s test/tests/test_delete.py ..... [ 21%] 191s test/tests/test_for.py .. [ 22%] 191s test/tests/test_functions.py ............. [ 30%] 191s test/tests/test_insert.py .......... [ 36%] 191s test/tests/test_join.py .... [ 38%] 191s test/tests/test_lateral.py .. [ 40%] 191s test/tests/test_literal.py .. [ 41%] 191s test/tests/test_operators.py ..................................... [ 63%] 191s test/tests/test_order.py ...... [ 67%] 191s test/tests/test_select.py ............................. [ 84%] 191s test/tests/test_table.py .... [ 86%] 191s test/tests/test_update.py ........ [ 91%] 191s test/tests/test_values.py .... [ 94%] 191s test/tests/test_window.py ...... [ 97%] 191s test/tests/test_with.py .... [100%] 191s 191s ============================= 167 passed in 0.23s ============================== 191s autopkgtest [00:57:58]: test run-testsuite3: -----------------------] 192s autopkgtest [00:57:59]: test run-testsuite3: - - - - - - - - - - results - - - - - - - - - - 192s run-testsuite3 PASS 192s autopkgtest [00:57:59]: @@@@@@@@@@@@@@@@@@@@ summary 192s command1 PASS 192s run-testsuite3 PASS 202s nova [W] Skipping flock for amd64 202s Creating nova instance adt-oracular-amd64-python-sql-20240608-005447-juju-7f2275-prod-proposed-migration-environment-2-f9b80488-aeb4-4151-853d-c08e0be24db7 from image adt/ubuntu-oracular-amd64-server-20240607.img (UUID d996b44c-1e10-4875-aeab-5b4c434d75a2)...