0s autopkgtest [13:19:19]: starting date and time: 2024-06-08 13:19:19+0000 0s autopkgtest [13:19:19]: git checkout: 433ed4cb Merge branch 'skia/nova_flock' into 'ubuntu/5.34+prod' 0s autopkgtest [13:19:19]: host juju-7f2275-prod-proposed-migration-environment-2; command line: /home/ubuntu/autopkgtest/runner/autopkgtest --output-dir /tmp/autopkgtest-work.j3wkql2r/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@bos03-arm64-55.secgroup --name adt-oracular-arm64-python-sql-20240608-131919-juju-7f2275-prod-proposed-migration-environment-2-dee3c315-5211-42b2-bce6-e216cb1abb97 --image adt/ubuntu-oracular-arm64-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/ 791s autopkgtest [13:32:30]: testbed dpkg architecture: arm64 791s autopkgtest [13:32:30]: testbed apt version: 2.9.3 791s autopkgtest [13:32:30]: @@@@@@@@@@@@@@@@@@@@ test bed setup 792s Get:1 http://ftpmaster.internal/ubuntu oracular-proposed InRelease [110 kB] 793s Get:2 http://ftpmaster.internal/ubuntu oracular-proposed/multiverse Sources [2420 B] 793s Get:3 http://ftpmaster.internal/ubuntu oracular-proposed/main Sources [44.2 kB] 793s Get:4 http://ftpmaster.internal/ubuntu oracular-proposed/restricted Sources [7972 B] 793s Get:5 http://ftpmaster.internal/ubuntu oracular-proposed/universe Sources [338 kB] 793s Get:6 http://ftpmaster.internal/ubuntu oracular-proposed/main arm64 Packages [67.9 kB] 793s Get:7 http://ftpmaster.internal/ubuntu oracular-proposed/restricted arm64 Packages [31.8 kB] 793s Get:8 http://ftpmaster.internal/ubuntu oracular-proposed/universe arm64 Packages [306 kB] 793s Get:9 http://ftpmaster.internal/ubuntu oracular-proposed/multiverse arm64 Packages [9556 B] 793s Fetched 918 kB in 1s (756 kB/s) 793s Reading package lists... 796s Reading package lists... 796s Building dependency tree... 796s Reading state information... 796s Calculating upgrade... 797s The following packages will be upgraded: 797s bash 798s 1 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 798s Need to get 781 kB of archives. 798s After this operation, 0 B of additional disk space will be used. 798s Get:1 http://ftpmaster.internal/ubuntu oracular/main arm64 bash arm64 5.2.21-2.1ubuntu1 [781 kB] 799s Fetched 781 kB in 1s (753 kB/s) 799s (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 ... 78200 files and directories currently installed.) 799s Preparing to unpack .../bash_5.2.21-2.1ubuntu1_arm64.deb ... 799s Unpacking bash (5.2.21-2.1ubuntu1) over (5.2.21-2ubuntu5) ... 799s Setting up bash (5.2.21-2.1ubuntu1) ... 799s update-alternatives: using /usr/share/man/man7/bash-builtins.7.gz to provide /usr/share/man/man7/builtins.7.gz (builtins.7.gz) in auto mode 799s Processing triggers for debianutils (5.18) ... 799s Processing triggers for install-info (7.1-3build2) ... 799s Processing triggers for man-db (2.12.1-1) ... 801s Reading package lists... 801s Building dependency tree... 801s Reading state information... 801s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 802s Hit:1 http://ftpmaster.internal/ubuntu oracular InRelease 802s Hit:2 http://ftpmaster.internal/ubuntu oracular-updates InRelease 802s Hit:3 http://ftpmaster.internal/ubuntu oracular-security InRelease 802s Hit:4 http://ftpmaster.internal/ubuntu oracular-proposed InRelease 805s Reading package lists... 805s Reading package lists... 805s Building dependency tree... 805s Reading state information... 805s Calculating upgrade... 806s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 806s Reading package lists... 806s Building dependency tree... 806s Reading state information... 807s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 810s autopkgtest [13:32:49]: testbed running kernel: Linux 6.8.0-31-generic #31-Ubuntu SMP PREEMPT_DYNAMIC Sat Apr 20 02:32:42 UTC 2024 810s autopkgtest [13:32:49]: @@@@@@@@@@@@@@@@@@@@ apt-source python-sql 813s Get:1 http://ftpmaster.internal/ubuntu oracular/universe python-sql 1.4.0-1 (dsc) [2334 B] 813s Get:2 http://ftpmaster.internal/ubuntu oracular/universe python-sql 1.4.0-1 (tar) [32.6 kB] 813s Get:3 http://ftpmaster.internal/ubuntu oracular/universe python-sql 1.4.0-1 (asc) [506 B] 813s Get:4 http://ftpmaster.internal/ubuntu oracular/universe python-sql 1.4.0-1 (diff) [25.3 kB] 813s gpgv: Signature made Fri Sep 9 18:56:46 2022 UTC 813s gpgv: using RSA key AC297E5C46B9D0B61C717681D6D09BE48405BBF6 813s gpgv: Can't check signature: No public key 813s dpkg-source: warning: cannot verify inline signature for ./python-sql_1.4.0-1.dsc: no acceptable signature found 813s autopkgtest [13:32:52]: testing package python-sql version 1.4.0-1 813s autopkgtest [13:32:52]: build not needed 814s autopkgtest [13:32:53]: test command1: preparing testbed 815s Reading package lists... 815s Building dependency tree... 815s Reading state information... 815s Starting pkgProblemResolver with broken count: 0 815s Starting 2 pkgProblemResolver with broken count: 0 815s Done 816s The following additional packages will be installed: 816s python3-sql 816s Suggested packages: 816s python3-apsw python3-mysql.connector python3-psycopg2 816s The following NEW packages will be installed: 816s autopkgtest-satdep python3-sql 816s 0 upgraded, 2 newly installed, 0 to remove and 0 not upgraded. 816s Need to get 27.8 kB/28.5 kB of archives. 816s After this operation, 194 kB of additional disk space will be used. 816s Get:1 /tmp/autopkgtest.d7tswY/1-autopkgtest-satdep.deb autopkgtest-satdep arm64 0 [704 B] 818s Get:2 http://ftpmaster.internal/ubuntu oracular/universe arm64 python3-sql all 1.4.0-1 [27.8 kB] 819s Fetched 27.8 kB in 2s (13.2 kB/s) 819s Selecting previously unselected package python3-sql. 819s (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 ... 78200 files and directories currently installed.) 819s Preparing to unpack .../python3-sql_1.4.0-1_all.deb ... 819s Unpacking python3-sql (1.4.0-1) ... 819s Selecting previously unselected package autopkgtest-satdep. 820s Preparing to unpack .../1-autopkgtest-satdep.deb ... 820s Unpacking autopkgtest-satdep (0) ... 820s Setting up python3-sql (1.4.0-1) ... 820s Setting up autopkgtest-satdep (0) ... 824s (Reading database ... 78238 files and directories currently installed.) 824s Removing autopkgtest-satdep (0) ... 825s autopkgtest [13:33:04]: test command1: cd "$ADTTMP" ; python3 -c "import sql ; print(sql.__version__)" 825s autopkgtest [13:33:04]: test command1: [----------------------- 825s 1.4.0 826s autopkgtest [13:33:05]: test command1: -----------------------] 826s autopkgtest [13:33:05]: test command1: - - - - - - - - - - results - - - - - - - - - - 826s command1 PASS 826s autopkgtest [13:33:05]: test run-testsuite3: preparing testbed 828s Reading package lists... 828s Building dependency tree... 828s Reading state information... 828s Starting pkgProblemResolver with broken count: 0 828s Starting 2 pkgProblemResolver with broken count: 0 828s Done 829s The following additional packages will be installed: 829s python3-iniconfig python3-packaging python3-pluggy python3-pytest 829s The following NEW packages will be installed: 829s autopkgtest-satdep python3-iniconfig python3-packaging python3-pluggy 829s python3-pytest 829s 0 upgraded, 5 newly installed, 0 to remove and 0 not upgraded. 829s Need to get 318 kB/319 kB of archives. 829s After this operation, 1585 kB of additional disk space will be used. 829s Get:1 /tmp/autopkgtest.d7tswY/2-autopkgtest-satdep.deb autopkgtest-satdep arm64 0 [712 B] 829s Get:2 http://ftpmaster.internal/ubuntu oracular/universe arm64 python3-iniconfig all 1.1.1-2 [6024 B] 829s Get:3 http://ftpmaster.internal/ubuntu oracular/main arm64 python3-packaging all 24.0-1 [41.1 kB] 829s Get:4 http://ftpmaster.internal/ubuntu oracular/universe arm64 python3-pluggy all 1.5.0-1 [21.0 kB] 829s Get:5 http://ftpmaster.internal/ubuntu oracular-proposed/universe arm64 python3-pytest all 8.2.2-1ubuntu1 [250 kB] 830s Fetched 318 kB in 1s (539 kB/s) 830s Selecting previously unselected package python3-iniconfig. 830s (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 ... 78238 files and directories currently installed.) 830s Preparing to unpack .../python3-iniconfig_1.1.1-2_all.deb ... 830s Unpacking python3-iniconfig (1.1.1-2) ... 830s Selecting previously unselected package python3-packaging. 830s Preparing to unpack .../python3-packaging_24.0-1_all.deb ... 830s Unpacking python3-packaging (24.0-1) ... 830s Selecting previously unselected package python3-pluggy. 830s Preparing to unpack .../python3-pluggy_1.5.0-1_all.deb ... 830s Unpacking python3-pluggy (1.5.0-1) ... 830s Selecting previously unselected package python3-pytest. 831s Preparing to unpack .../python3-pytest_8.2.2-1ubuntu1_all.deb ... 831s Unpacking python3-pytest (8.2.2-1ubuntu1) ... 831s Selecting previously unselected package autopkgtest-satdep. 831s Preparing to unpack .../2-autopkgtest-satdep.deb ... 831s Unpacking autopkgtest-satdep (0) ... 831s Setting up python3-iniconfig (1.1.1-2) ... 831s Setting up python3-packaging (24.0-1) ... 831s Setting up python3-pluggy (1.5.0-1) ... 831s Setting up python3-pytest (8.2.2-1ubuntu1) ... 832s Setting up autopkgtest-satdep (0) ... 832s Processing triggers for man-db (2.12.1-1) ... 835s (Reading database ... 78402 files and directories currently installed.) 835s Removing autopkgtest-satdep (0) ... 836s autopkgtest [13:33:15]: test run-testsuite3: [----------------------- 836s ============================= test session starts ============================== 836s platform linux -- Python 3.12.3, pytest-8.2.2, pluggy-1.5.0 836s rootdir: /tmp/autopkgtest.d7tswY/autopkgtest_tmp 836s collected 167 items 836s 836s test/tests/test_aggregate.py .......... [ 5%] 836s test/tests/test_alias.py . [ 6%] 836s test/tests/test_as.py ... [ 8%] 836s test/tests/test_cast.py .. [ 9%] 836s test/tests/test_collate.py ... [ 11%] 836s test/tests/test_column.py .. [ 12%] 836s test/tests/test_combining_query.py .. [ 13%] 836s test/tests/test_conditionals.py ........ [ 18%] 836s test/tests/test_delete.py ..... [ 21%] 836s test/tests/test_for.py .. [ 22%] 836s test/tests/test_functions.py ............. [ 30%] 836s test/tests/test_insert.py .......... [ 36%] 836s test/tests/test_join.py .... [ 38%] 836s test/tests/test_lateral.py .. [ 40%] 836s test/tests/test_literal.py .. [ 41%] 836s test/tests/test_operators.py ..................................... [ 63%] 836s test/tests/test_order.py ...... [ 67%] 836s test/tests/test_select.py ............................. [ 84%] 836s test/tests/test_table.py .... [ 86%] 836s test/tests/test_update.py ........ [ 91%] 836s test/tests/test_values.py .... [ 94%] 836s test/tests/test_window.py ...... [ 97%] 836s test/tests/test_with.py .... [100%] 836s 836s ============================= 167 passed in 0.22s ============================== 837s autopkgtest [13:33:16]: test run-testsuite3: -----------------------] 837s autopkgtest [13:33:16]: test run-testsuite3: - - - - - - - - - - results - - - - - - - - - - 837s run-testsuite3 PASS 837s autopkgtest [13:33:16]: @@@@@@@@@@@@@@@@@@@@ summary 837s command1 PASS 837s run-testsuite3 PASS 932s nova [W] Skipping flock in bos03-arm64 932s Creating nova instance adt-oracular-arm64-python-sql-20240608-131919-juju-7f2275-prod-proposed-migration-environment-2-dee3c315-5211-42b2-bce6-e216cb1abb97 from image adt/ubuntu-oracular-arm64-server-20240608.img (UUID 22fa5d69-8269-442f-bb5d-fd1454f7b08f)...