0s autopkgtest [05:58:51]: starting date and time: 2024-07-21 05:58:51+0000 0s autopkgtest [05:58:51]: git checkout: fd3bed09 nova: allow more retries for quota issues 0s autopkgtest [05:58:51]: host juju-7f2275-prod-proposed-migration-environment-2; command line: /home/ubuntu/autopkgtest/runner/autopkgtest --output-dir /tmp/autopkgtest-work.x_al2af6/out --timeout-copy=6000 --setup-commands /home/ubuntu/autopkgtest-cloud/worker-config-production/setup-canonical.sh --apt-pocket=proposed=src:python3-defaults,src:python3-stdlib-extensions --apt-upgrade sqlparse --timeout-short=300 --timeout-copy=20000 --timeout-build=20000 '--env=ADT_TEST_TRIGGERS=python3-defaults/3.12.4-1 python3-stdlib-extensions/3.12.4-2' -- ssh -s /home/ubuntu/autopkgtest/ssh-setup/nova -- --flavor autopkgtest --security-groups autopkgtest-juju-7f2275-prod-proposed-migration-environment-2@bos02-s390x-8.secgroup --name adt-oracular-s390x-sqlparse-20240721-055850-juju-7f2275-prod-proposed-migration-environment-2-0706e5cc-1c60-4a10-8367-08ab0b954e09 --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://ftpmaster.internal/ubuntu/ 123s autopkgtest [06:00:54]: testbed dpkg architecture: s390x 123s autopkgtest [06:00:54]: testbed apt version: 2.9.6 123s autopkgtest [06:00:54]: @@@@@@@@@@@@@@@@@@@@ test bed setup 124s Get:1 http://ftpmaster.internal/ubuntu oracular-proposed InRelease [126 kB] 124s Get:2 http://ftpmaster.internal/ubuntu oracular-proposed/main Sources [62.2 kB] 124s Get:3 http://ftpmaster.internal/ubuntu oracular-proposed/restricted Sources [8548 B] 124s Get:4 http://ftpmaster.internal/ubuntu oracular-proposed/universe Sources [407 kB] 124s Get:5 http://ftpmaster.internal/ubuntu oracular-proposed/multiverse Sources [4724 B] 124s Get:6 http://ftpmaster.internal/ubuntu oracular-proposed/main s390x Packages [101 kB] 124s Get:7 http://ftpmaster.internal/ubuntu oracular-proposed/main s390x c-n-f Metadata [2112 B] 124s Get:8 http://ftpmaster.internal/ubuntu oracular-proposed/restricted s390x Packages [1368 B] 124s Get:9 http://ftpmaster.internal/ubuntu oracular-proposed/restricted s390x c-n-f Metadata [120 B] 124s Get:10 http://ftpmaster.internal/ubuntu oracular-proposed/universe s390x Packages [464 kB] 124s Get:11 http://ftpmaster.internal/ubuntu oracular-proposed/universe s390x c-n-f Metadata [8372 B] 124s Get:12 http://ftpmaster.internal/ubuntu oracular-proposed/multiverse s390x Packages [2744 B] 124s Get:13 http://ftpmaster.internal/ubuntu oracular-proposed/multiverse s390x c-n-f Metadata [120 B] 125s Fetched 1188 kB in 1s (1527 kB/s) 125s Reading package lists... 127s Reading package lists... 127s Building dependency tree... 127s Reading state information... 127s Calculating upgrade... 127s The following packages will be upgraded: 127s libpython3-stdlib python3 python3-gdbm python3-minimal 127s 4 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 127s Need to get 79.4 kB of archives. 127s After this operation, 26.6 kB of additional disk space will be used. 127s Get:1 http://ftpmaster.internal/ubuntu oracular-proposed/main s390x python3-minimal s390x 3.12.4-1 [27.1 kB] 128s Get:2 http://ftpmaster.internal/ubuntu oracular-proposed/main s390x python3 s390x 3.12.4-1 [24.0 kB] 128s Get:3 http://ftpmaster.internal/ubuntu oracular-proposed/main s390x libpython3-stdlib s390x 3.12.4-1 [9826 B] 128s Get:4 http://ftpmaster.internal/ubuntu oracular-proposed/main s390x python3-gdbm s390x 3.12.4-2 [18.5 kB] 128s Fetched 79.4 kB in 0s (237 kB/s) 128s (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 ... 54753 files and directories currently installed.) 128s Preparing to unpack .../python3-minimal_3.12.4-1_s390x.deb ... 128s Unpacking python3-minimal (3.12.4-1) over (3.12.3-0ubuntu1) ... 128s Setting up python3-minimal (3.12.4-1) ... 128s (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 ... 54753 files and directories currently installed.) 128s Preparing to unpack .../python3_3.12.4-1_s390x.deb ... 128s Unpacking python3 (3.12.4-1) over (3.12.3-0ubuntu1) ... 128s Preparing to unpack .../libpython3-stdlib_3.12.4-1_s390x.deb ... 128s Unpacking libpython3-stdlib:s390x (3.12.4-1) over (3.12.3-0ubuntu1) ... 128s Preparing to unpack .../python3-gdbm_3.12.4-2_s390x.deb ... 128s Unpacking python3-gdbm:s390x (3.12.4-2) over (3.12.3-0ubuntu1) ... 128s Setting up libpython3-stdlib:s390x (3.12.4-1) ... 128s Setting up python3 (3.12.4-1) ... 128s Setting up python3-gdbm:s390x (3.12.4-2) ... 128s Processing triggers for man-db (2.12.1-2) ... 129s Reading package lists... 129s Building dependency tree... 129s Reading state information... 129s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 130s Hit:1 http://ftpmaster.internal/ubuntu oracular-proposed InRelease 130s Hit:2 http://ftpmaster.internal/ubuntu oracular InRelease 130s Hit:3 http://ftpmaster.internal/ubuntu oracular-updates InRelease 130s Hit:4 http://ftpmaster.internal/ubuntu oracular-security InRelease 131s Reading package lists... 131s Reading package lists... 131s Building dependency tree... 131s Reading state information... 131s Calculating upgrade... 131s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 131s Reading package lists... 131s Building dependency tree... 131s Reading state information... 132s 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. 134s autopkgtest [06:01:05]: testbed running kernel: Linux 6.8.0-31-generic #31-Ubuntu SMP Sat Apr 20 00:14:26 UTC 2024 135s autopkgtest [06:01:06]: @@@@@@@@@@@@@@@@@@@@ apt-source sqlparse 137s Get:1 http://ftpmaster.internal/ubuntu oracular/main sqlparse 0.5.0-1 (dsc) [2326 B] 137s Get:2 http://ftpmaster.internal/ubuntu oracular/main sqlparse 0.5.0-1 (tar) [83.5 kB] 137s Get:3 http://ftpmaster.internal/ubuntu oracular/main sqlparse 0.5.0-1 (diff) [5448 B] 137s gpgv: Signature made Sun May 12 17:48:15 2024 UTC 137s gpgv: using RSA key AC0A4FF12611B6FCCF01C111393587D97D86500B 137s gpgv: Can't check signature: No public key 137s dpkg-source: warning: cannot verify inline signature for ./sqlparse_0.5.0-1.dsc: no acceptable signature found 137s autopkgtest [06:01:08]: testing package sqlparse version 0.5.0-1 137s autopkgtest [06:01:08]: build not needed 138s autopkgtest [06:01:09]: test pybuild-autopkgtest: preparing testbed 139s Reading package lists... 139s Building dependency tree... 139s Reading state information... 139s Starting pkgProblemResolver with broken count: 0 139s Starting 2 pkgProblemResolver with broken count: 0 139s Done 140s The following additional packages will be installed: 140s autoconf automake autopoint autotools-dev build-essential cpp cpp-13 140s cpp-13-s390x-linux-gnu cpp-s390x-linux-gnu debhelper debugedit dh-autoreconf 140s dh-python dh-strip-nondeterminism docutils-common dwz g++ g++-13 140s g++-13-s390x-linux-gnu g++-s390x-linux-gnu gcc gcc-13 gcc-13-base 140s gcc-13-s390x-linux-gnu gcc-s390x-linux-gnu gettext intltool-debian 140s libarchive-zip-perl libasan8 libatomic1 libcc1-0 libdebhelper-perl 140s libfile-stripnondeterminism-perl libgcc-13-dev libgomp1 libisl23 libitm1 140s libjs-jquery libjs-sphinxdoc libjs-underscore libjson-perl libmpc3 140s libstdc++-13-dev libtool libubsan1 m4 po-debconf pybuild-plugin-autopkgtest 140s pybuild-plugin-pyproject python-sqlparse-doc python3-alabaster python3-all 140s python3-build python3-defusedxml python3-docutils python3-hatchling 140s python3-imagesize python3-iniconfig python3-installer python3-packaging 140s python3-pathspec python3-pluggy python3-pyproject-hooks python3-pytest 140s python3-roman python3-snowballstemmer python3-sphinx python3-sqlparse 140s python3-toml python3-trove-classifiers python3-wheel sgml-base sphinx-common 140s sqlformat xml-core 140s Suggested packages: 140s autoconf-archive gnu-standards autoconf-doc cpp-doc gcc-13-locales 140s cpp-13-doc dh-make flit gcc-13-doc gcc-multilib manpages-dev flex bison gdb 140s gcc-doc gdb-s390x-linux-gnu gettext-doc libasprintf-dev libgettextpo-dev 140s libstdc++-13-doc libtool-doc gfortran | fortran95-compiler gcj-jdk m4-doc 140s libmail-box-perl python3-pip python3-venv python-build-doc docutils-doc 140s fonts-linuxlibertine | ttf-linux-libertine texlive-lang-french 140s texlive-latex-base texlive-latex-recommended python-installer-doc 140s python3-stemmer dvipng dvisvgm fonts-freefont-otf imagemagick-6.q16 latexmk 140s libjs-mathjax python3-lib2to3 python3-sphinx-rtd-theme sphinx-doc tex-gyre 140s texlive-fonts-recommended texlive-latex-extra texlive-plain-generic 140s sgml-base-doc 140s Recommended packages: 140s libarchive-cpio-perl javascript-common libjson-xs-perl libltdl-dev 140s libmail-sendmail-perl libpaper-utils python3-pil 140s The following NEW packages will be installed: 140s autoconf automake autopkgtest-satdep autopoint autotools-dev build-essential 140s cpp cpp-13 cpp-13-s390x-linux-gnu cpp-s390x-linux-gnu debhelper debugedit 140s dh-autoreconf dh-python dh-strip-nondeterminism docutils-common dwz g++ 140s g++-13 g++-13-s390x-linux-gnu g++-s390x-linux-gnu gcc gcc-13 gcc-13-base 140s gcc-13-s390x-linux-gnu gcc-s390x-linux-gnu gettext intltool-debian 140s libarchive-zip-perl libasan8 libatomic1 libcc1-0 libdebhelper-perl 140s libfile-stripnondeterminism-perl libgcc-13-dev libgomp1 libisl23 libitm1 140s libjs-jquery libjs-sphinxdoc libjs-underscore libjson-perl libmpc3 140s libstdc++-13-dev libtool libubsan1 m4 po-debconf pybuild-plugin-autopkgtest 140s pybuild-plugin-pyproject python-sqlparse-doc python3-alabaster python3-all 140s python3-build python3-defusedxml python3-docutils python3-hatchling 140s python3-imagesize python3-iniconfig python3-installer python3-packaging 140s python3-pathspec python3-pluggy python3-pyproject-hooks python3-pytest 140s python3-roman python3-snowballstemmer python3-sphinx python3-sqlparse 140s python3-toml python3-trove-classifiers python3-wheel sgml-base sphinx-common 140s sqlformat xml-core 140s 0 upgraded, 76 newly installed, 0 to remove and 0 not upgraded. 140s Need to get 53.4 MB/53.4 MB of archives. 140s After this operation, 172 MB of additional disk space will be used. 140s Get:1 /tmp/autopkgtest.KnQ55K/1-autopkgtest-satdep.deb autopkgtest-satdep s390x 0 [820 B] 140s Get:2 http://ftpmaster.internal/ubuntu oracular/main s390x sgml-base all 1.31 [11.4 kB] 140s Get:3 http://ftpmaster.internal/ubuntu oracular/main s390x m4 s390x 1.4.19-4build1 [256 kB] 140s Get:4 http://ftpmaster.internal/ubuntu oracular/main s390x autoconf all 2.71-3 [339 kB] 140s Get:5 http://ftpmaster.internal/ubuntu oracular/main s390x autotools-dev all 20220109.1 [44.9 kB] 140s Get:6 http://ftpmaster.internal/ubuntu oracular/main s390x automake all 1:1.16.5-1.3ubuntu1 [558 kB] 140s Get:7 http://ftpmaster.internal/ubuntu oracular/main s390x autopoint all 0.22.5-1 [616 kB] 140s Get:8 http://ftpmaster.internal/ubuntu oracular/main s390x gcc-13-base s390x 13.3.0-3ubuntu1 [50.8 kB] 140s Get:9 http://ftpmaster.internal/ubuntu oracular/main s390x libisl23 s390x 0.26-3build1 [713 kB] 140s Get:10 http://ftpmaster.internal/ubuntu oracular/main s390x libmpc3 s390x 1.3.1-1build1 [58.4 kB] 140s Get:11 http://ftpmaster.internal/ubuntu oracular/main s390x cpp-13-s390x-linux-gnu s390x 13.3.0-3ubuntu1 [8777 kB] 141s Get:12 http://ftpmaster.internal/ubuntu oracular/main s390x cpp-13 s390x 13.3.0-3ubuntu1 [1026 B] 141s Get:13 http://ftpmaster.internal/ubuntu oracular/main s390x cpp-s390x-linux-gnu s390x 4:13.3.0-2ubuntu2 [5388 B] 141s Get:14 http://ftpmaster.internal/ubuntu oracular/main s390x cpp s390x 4:13.3.0-2ubuntu2 [22.4 kB] 141s Get:15 http://ftpmaster.internal/ubuntu oracular/main s390x libcc1-0 s390x 14.1.0-4ubuntu2 [50.6 kB] 141s Get:16 http://ftpmaster.internal/ubuntu oracular/main s390x libgomp1 s390x 14.1.0-4ubuntu2 [150 kB] 141s Get:17 http://ftpmaster.internal/ubuntu oracular/main s390x libitm1 s390x 14.1.0-4ubuntu2 [30.9 kB] 141s Get:18 http://ftpmaster.internal/ubuntu oracular/main s390x libatomic1 s390x 14.1.0-4ubuntu2 [9428 B] 141s Get:19 http://ftpmaster.internal/ubuntu oracular/main s390x libasan8 s390x 14.1.0-4ubuntu2 [2965 kB] 141s Get:20 http://ftpmaster.internal/ubuntu oracular/main s390x libubsan1 s390x 14.1.0-4ubuntu2 [1184 kB] 141s Get:21 http://ftpmaster.internal/ubuntu oracular/main s390x libgcc-13-dev s390x 13.3.0-3ubuntu1 [997 kB] 141s Get:22 http://ftpmaster.internal/ubuntu oracular/main s390x gcc-13-s390x-linux-gnu s390x 13.3.0-3ubuntu1 [17.1 MB] 141s Get:23 http://ftpmaster.internal/ubuntu oracular/main s390x gcc-13 s390x 13.3.0-3ubuntu1 [482 kB] 141s Get:24 http://ftpmaster.internal/ubuntu oracular/main s390x gcc-s390x-linux-gnu s390x 4:13.3.0-2ubuntu2 [1204 B] 141s Get:25 http://ftpmaster.internal/ubuntu oracular/main s390x gcc s390x 4:13.3.0-2ubuntu2 [5014 B] 141s Get:26 http://ftpmaster.internal/ubuntu oracular/main s390x libstdc++-13-dev s390x 13.3.0-3ubuntu1 [2525 kB] 141s Get:27 http://ftpmaster.internal/ubuntu oracular/main s390x g++-13-s390x-linux-gnu s390x 13.3.0-3ubuntu1 [10.2 MB] 142s Get:28 http://ftpmaster.internal/ubuntu oracular/main s390x g++-13 s390x 13.3.0-3ubuntu1 [16.0 kB] 142s Get:29 http://ftpmaster.internal/ubuntu oracular/main s390x g++-s390x-linux-gnu s390x 4:13.3.0-2ubuntu2 [956 B] 142s Get:30 http://ftpmaster.internal/ubuntu oracular/main s390x g++ s390x 4:13.3.0-2ubuntu2 [1080 B] 142s Get:31 http://ftpmaster.internal/ubuntu oracular/main s390x build-essential s390x 12.10ubuntu1 [4930 B] 142s Get:32 http://ftpmaster.internal/ubuntu oracular/main s390x libdebhelper-perl all 13.16ubuntu2 [92.9 kB] 142s Get:33 http://ftpmaster.internal/ubuntu oracular/main s390x libtool all 2.4.7-7build1 [166 kB] 142s Get:34 http://ftpmaster.internal/ubuntu oracular/main s390x dh-autoreconf all 20 [16.1 kB] 142s Get:35 http://ftpmaster.internal/ubuntu oracular/main s390x libarchive-zip-perl all 1.68-1 [90.2 kB] 142s Get:36 http://ftpmaster.internal/ubuntu oracular/main s390x libfile-stripnondeterminism-perl all 1.14.0-1 [20.1 kB] 142s Get:37 http://ftpmaster.internal/ubuntu oracular/main s390x dh-strip-nondeterminism all 1.14.0-1 [5058 B] 142s Get:38 http://ftpmaster.internal/ubuntu oracular/main s390x debugedit s390x 1:5.0-6 [49.9 kB] 142s Get:39 http://ftpmaster.internal/ubuntu oracular/main s390x dwz s390x 0.15-1build6 [122 kB] 142s Get:40 http://ftpmaster.internal/ubuntu oracular/main s390x gettext s390x 0.22.5-1 [989 kB] 142s Get:41 http://ftpmaster.internal/ubuntu oracular/main s390x intltool-debian all 0.35.0+20060710.6 [23.2 kB] 142s Get:42 http://ftpmaster.internal/ubuntu oracular/main s390x po-debconf all 1.0.21+nmu1 [233 kB] 142s Get:43 http://ftpmaster.internal/ubuntu oracular/main s390x debhelper all 13.16ubuntu2 [869 kB] 142s Get:44 http://ftpmaster.internal/ubuntu oracular/universe s390x dh-python all 6.20240603 [112 kB] 142s Get:45 http://ftpmaster.internal/ubuntu oracular/main s390x xml-core all 0.19 [20.3 kB] 142s Get:46 http://ftpmaster.internal/ubuntu oracular/main s390x docutils-common all 0.20.1+dfsg-3 [132 kB] 142s Get:47 http://ftpmaster.internal/ubuntu oracular/main s390x libjs-jquery all 3.6.1+dfsg+~3.5.14-1 [328 kB] 142s Get:48 http://ftpmaster.internal/ubuntu oracular/main s390x libjs-underscore all 1.13.4~dfsg+~1.11.4-3 [118 kB] 142s Get:49 http://ftpmaster.internal/ubuntu oracular/main s390x libjs-sphinxdoc all 7.3.7-3 [154 kB] 142s Get:50 http://ftpmaster.internal/ubuntu oracular/main s390x libjson-perl all 4.10000-1 [81.9 kB] 142s Get:51 http://ftpmaster.internal/ubuntu oracular/universe s390x pybuild-plugin-autopkgtest all 6.20240603 [1748 B] 142s Get:52 http://ftpmaster.internal/ubuntu oracular/main s390x python3-packaging all 24.1-1 [41.4 kB] 142s Get:53 http://ftpmaster.internal/ubuntu oracular/universe s390x python3-pyproject-hooks all 1.1.0-2 [9916 B] 142s Get:54 http://ftpmaster.internal/ubuntu oracular/universe s390x python3-toml all 0.10.2-1 [16.5 kB] 142s Get:55 http://ftpmaster.internal/ubuntu oracular/universe s390x python3-wheel all 0.43.0-1 [53.5 kB] 142s Get:56 http://ftpmaster.internal/ubuntu oracular/universe s390x python3-build all 1.2.1-1 [29.7 kB] 142s Get:57 http://ftpmaster.internal/ubuntu oracular/universe s390x python3-installer all 0.7.0+dfsg1-3 [17.4 kB] 142s Get:58 http://ftpmaster.internal/ubuntu oracular/universe s390x pybuild-plugin-pyproject all 6.20240603 [1732 B] 142s Get:59 http://ftpmaster.internal/ubuntu oracular/main s390x python-sqlparse-doc all 0.5.0-1 [45.8 kB] 142s Get:60 http://ftpmaster.internal/ubuntu oracular-proposed/main s390x python3-all s390x 3.12.4-1 [884 B] 142s Get:61 http://ftpmaster.internal/ubuntu oracular/main s390x python3-defusedxml all 0.7.1-2 [42.0 kB] 142s Get:62 http://ftpmaster.internal/ubuntu oracular/main s390x python3-roman all 3.3-3 [9632 B] 142s Get:63 http://ftpmaster.internal/ubuntu oracular/main s390x python3-docutils all 0.20.1+dfsg-3 [393 kB] 142s Get:64 http://ftpmaster.internal/ubuntu oracular/universe s390x python3-pathspec all 0.12.1-1 [24.5 kB] 142s Get:65 http://ftpmaster.internal/ubuntu oracular/universe s390x python3-pluggy all 1.5.0-1 [21.0 kB] 142s Get:66 http://ftpmaster.internal/ubuntu oracular/universe s390x python3-trove-classifiers all 2024.4.10-1 [10.6 kB] 142s Get:67 http://ftpmaster.internal/ubuntu oracular/universe s390x python3-hatchling all 1.25.0-1 [54.8 kB] 142s Get:68 http://ftpmaster.internal/ubuntu oracular/main s390x python3-imagesize all 1.4.1-1 [6844 B] 142s Get:69 http://ftpmaster.internal/ubuntu oracular/universe s390x python3-iniconfig all 1.1.1-2 [6024 B] 142s Get:70 http://ftpmaster.internal/ubuntu oracular/universe s390x python3-pytest all 7.4.4-1 [305 kB] 142s Get:71 http://ftpmaster.internal/ubuntu oracular/main s390x python3-snowballstemmer all 2.2.0-4build1 [59.8 kB] 142s Get:72 http://ftpmaster.internal/ubuntu oracular/main s390x sphinx-common all 7.3.7-3 [773 kB] 142s Get:73 http://ftpmaster.internal/ubuntu oracular/main s390x python3-alabaster all 0.7.16-0.1 [18.5 kB] 142s Get:74 http://ftpmaster.internal/ubuntu oracular/main s390x python3-sphinx all 7.3.7-3 [574 kB] 142s Get:75 http://ftpmaster.internal/ubuntu oracular/main s390x python3-sqlparse all 0.5.0-1 [32.4 kB] 142s Get:76 http://ftpmaster.internal/ubuntu oracular/universe s390x sqlformat all 0.5.0-1 [3860 B] 143s Fetched 53.4 MB in 2s (21.6 MB/s) 143s Selecting previously unselected package sgml-base. 143s (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 ... 54756 files and directories currently installed.) 143s Preparing to unpack .../00-sgml-base_1.31_all.deb ... 143s Unpacking sgml-base (1.31) ... 143s Selecting previously unselected package m4. 143s Preparing to unpack .../01-m4_1.4.19-4build1_s390x.deb ... 143s Unpacking m4 (1.4.19-4build1) ... 143s Selecting previously unselected package autoconf. 143s Preparing to unpack .../02-autoconf_2.71-3_all.deb ... 143s Unpacking autoconf (2.71-3) ... 143s Selecting previously unselected package autotools-dev. 143s Preparing to unpack .../03-autotools-dev_20220109.1_all.deb ... 143s Unpacking autotools-dev (20220109.1) ... 143s Selecting previously unselected package automake. 143s Preparing to unpack .../04-automake_1%3a1.16.5-1.3ubuntu1_all.deb ... 143s Unpacking automake (1:1.16.5-1.3ubuntu1) ... 143s Selecting previously unselected package autopoint. 143s Preparing to unpack .../05-autopoint_0.22.5-1_all.deb ... 143s Unpacking autopoint (0.22.5-1) ... 143s Selecting previously unselected package gcc-13-base:s390x. 143s Preparing to unpack .../06-gcc-13-base_13.3.0-3ubuntu1_s390x.deb ... 143s Unpacking gcc-13-base:s390x (13.3.0-3ubuntu1) ... 143s Selecting previously unselected package libisl23:s390x. 143s Preparing to unpack .../07-libisl23_0.26-3build1_s390x.deb ... 143s Unpacking libisl23:s390x (0.26-3build1) ... 143s Selecting previously unselected package libmpc3:s390x. 143s Preparing to unpack .../08-libmpc3_1.3.1-1build1_s390x.deb ... 143s Unpacking libmpc3:s390x (1.3.1-1build1) ... 143s Selecting previously unselected package cpp-13-s390x-linux-gnu. 143s Preparing to unpack .../09-cpp-13-s390x-linux-gnu_13.3.0-3ubuntu1_s390x.deb ... 143s Unpacking cpp-13-s390x-linux-gnu (13.3.0-3ubuntu1) ... 143s Selecting previously unselected package cpp-13. 143s Preparing to unpack .../10-cpp-13_13.3.0-3ubuntu1_s390x.deb ... 143s Unpacking cpp-13 (13.3.0-3ubuntu1) ... 143s Selecting previously unselected package cpp-s390x-linux-gnu. 143s Preparing to unpack .../11-cpp-s390x-linux-gnu_4%3a13.3.0-2ubuntu2_s390x.deb ... 143s Unpacking cpp-s390x-linux-gnu (4:13.3.0-2ubuntu2) ... 143s Selecting previously unselected package cpp. 143s Preparing to unpack .../12-cpp_4%3a13.3.0-2ubuntu2_s390x.deb ... 143s Unpacking cpp (4:13.3.0-2ubuntu2) ... 143s Selecting previously unselected package libcc1-0:s390x. 143s Preparing to unpack .../13-libcc1-0_14.1.0-4ubuntu2_s390x.deb ... 143s Unpacking libcc1-0:s390x (14.1.0-4ubuntu2) ... 143s Selecting previously unselected package libgomp1:s390x. 143s Preparing to unpack .../14-libgomp1_14.1.0-4ubuntu2_s390x.deb ... 143s Unpacking libgomp1:s390x (14.1.0-4ubuntu2) ... 143s Selecting previously unselected package libitm1:s390x. 143s Preparing to unpack .../15-libitm1_14.1.0-4ubuntu2_s390x.deb ... 143s Unpacking libitm1:s390x (14.1.0-4ubuntu2) ... 143s Selecting previously unselected package libatomic1:s390x. 143s Preparing to unpack .../16-libatomic1_14.1.0-4ubuntu2_s390x.deb ... 143s Unpacking libatomic1:s390x (14.1.0-4ubuntu2) ... 143s Selecting previously unselected package libasan8:s390x. 143s Preparing to unpack .../17-libasan8_14.1.0-4ubuntu2_s390x.deb ... 143s Unpacking libasan8:s390x (14.1.0-4ubuntu2) ... 143s Selecting previously unselected package libubsan1:s390x. 143s Preparing to unpack .../18-libubsan1_14.1.0-4ubuntu2_s390x.deb ... 143s Unpacking libubsan1:s390x (14.1.0-4ubuntu2) ... 143s Selecting previously unselected package libgcc-13-dev:s390x. 143s Preparing to unpack .../19-libgcc-13-dev_13.3.0-3ubuntu1_s390x.deb ... 143s Unpacking libgcc-13-dev:s390x (13.3.0-3ubuntu1) ... 143s Selecting previously unselected package gcc-13-s390x-linux-gnu. 143s Preparing to unpack .../20-gcc-13-s390x-linux-gnu_13.3.0-3ubuntu1_s390x.deb ... 143s Unpacking gcc-13-s390x-linux-gnu (13.3.0-3ubuntu1) ... 144s Selecting previously unselected package gcc-13. 144s Preparing to unpack .../21-gcc-13_13.3.0-3ubuntu1_s390x.deb ... 144s Unpacking gcc-13 (13.3.0-3ubuntu1) ... 144s Selecting previously unselected package gcc-s390x-linux-gnu. 144s Preparing to unpack .../22-gcc-s390x-linux-gnu_4%3a13.3.0-2ubuntu2_s390x.deb ... 144s Unpacking gcc-s390x-linux-gnu (4:13.3.0-2ubuntu2) ... 144s Selecting previously unselected package gcc. 144s Preparing to unpack .../23-gcc_4%3a13.3.0-2ubuntu2_s390x.deb ... 144s Unpacking gcc (4:13.3.0-2ubuntu2) ... 144s Selecting previously unselected package libstdc++-13-dev:s390x. 144s Preparing to unpack .../24-libstdc++-13-dev_13.3.0-3ubuntu1_s390x.deb ... 144s Unpacking libstdc++-13-dev:s390x (13.3.0-3ubuntu1) ... 144s Selecting previously unselected package g++-13-s390x-linux-gnu. 144s Preparing to unpack .../25-g++-13-s390x-linux-gnu_13.3.0-3ubuntu1_s390x.deb ... 144s Unpacking g++-13-s390x-linux-gnu (13.3.0-3ubuntu1) ... 144s Selecting previously unselected package g++-13. 144s Preparing to unpack .../26-g++-13_13.3.0-3ubuntu1_s390x.deb ... 144s Unpacking g++-13 (13.3.0-3ubuntu1) ... 144s Selecting previously unselected package g++-s390x-linux-gnu. 144s Preparing to unpack .../27-g++-s390x-linux-gnu_4%3a13.3.0-2ubuntu2_s390x.deb ... 144s Unpacking g++-s390x-linux-gnu (4:13.3.0-2ubuntu2) ... 144s Selecting previously unselected package g++. 144s Preparing to unpack .../28-g++_4%3a13.3.0-2ubuntu2_s390x.deb ... 144s Unpacking g++ (4:13.3.0-2ubuntu2) ... 144s Selecting previously unselected package build-essential. 144s Preparing to unpack .../29-build-essential_12.10ubuntu1_s390x.deb ... 144s Unpacking build-essential (12.10ubuntu1) ... 144s Selecting previously unselected package libdebhelper-perl. 144s Preparing to unpack .../30-libdebhelper-perl_13.16ubuntu2_all.deb ... 144s Unpacking libdebhelper-perl (13.16ubuntu2) ... 144s Selecting previously unselected package libtool. 144s Preparing to unpack .../31-libtool_2.4.7-7build1_all.deb ... 144s Unpacking libtool (2.4.7-7build1) ... 144s Selecting previously unselected package dh-autoreconf. 144s Preparing to unpack .../32-dh-autoreconf_20_all.deb ... 144s Unpacking dh-autoreconf (20) ... 144s Selecting previously unselected package libarchive-zip-perl. 144s Preparing to unpack .../33-libarchive-zip-perl_1.68-1_all.deb ... 144s Unpacking libarchive-zip-perl (1.68-1) ... 144s Selecting previously unselected package libfile-stripnondeterminism-perl. 144s Preparing to unpack .../34-libfile-stripnondeterminism-perl_1.14.0-1_all.deb ... 144s Unpacking libfile-stripnondeterminism-perl (1.14.0-1) ... 144s Selecting previously unselected package dh-strip-nondeterminism. 144s Preparing to unpack .../35-dh-strip-nondeterminism_1.14.0-1_all.deb ... 144s Unpacking dh-strip-nondeterminism (1.14.0-1) ... 144s Selecting previously unselected package debugedit. 144s Preparing to unpack .../36-debugedit_1%3a5.0-6_s390x.deb ... 144s Unpacking debugedit (1:5.0-6) ... 144s Selecting previously unselected package dwz. 144s Preparing to unpack .../37-dwz_0.15-1build6_s390x.deb ... 144s Unpacking dwz (0.15-1build6) ... 144s Selecting previously unselected package gettext. 144s Preparing to unpack .../38-gettext_0.22.5-1_s390x.deb ... 144s Unpacking gettext (0.22.5-1) ... 144s Selecting previously unselected package intltool-debian. 144s Preparing to unpack .../39-intltool-debian_0.35.0+20060710.6_all.deb ... 144s Unpacking intltool-debian (0.35.0+20060710.6) ... 144s Selecting previously unselected package po-debconf. 144s Preparing to unpack .../40-po-debconf_1.0.21+nmu1_all.deb ... 144s Unpacking po-debconf (1.0.21+nmu1) ... 144s Selecting previously unselected package debhelper. 144s Preparing to unpack .../41-debhelper_13.16ubuntu2_all.deb ... 144s Unpacking debhelper (13.16ubuntu2) ... 145s Selecting previously unselected package dh-python. 145s Preparing to unpack .../42-dh-python_6.20240603_all.deb ... 145s Unpacking dh-python (6.20240603) ... 145s Selecting previously unselected package xml-core. 145s Preparing to unpack .../43-xml-core_0.19_all.deb ... 145s Unpacking xml-core (0.19) ... 145s Selecting previously unselected package docutils-common. 145s Preparing to unpack .../44-docutils-common_0.20.1+dfsg-3_all.deb ... 145s Unpacking docutils-common (0.20.1+dfsg-3) ... 145s Selecting previously unselected package libjs-jquery. 145s Preparing to unpack .../45-libjs-jquery_3.6.1+dfsg+~3.5.14-1_all.deb ... 145s Unpacking libjs-jquery (3.6.1+dfsg+~3.5.14-1) ... 145s Selecting previously unselected package libjs-underscore. 145s Preparing to unpack .../46-libjs-underscore_1.13.4~dfsg+~1.11.4-3_all.deb ... 145s Unpacking libjs-underscore (1.13.4~dfsg+~1.11.4-3) ... 145s Selecting previously unselected package libjs-sphinxdoc. 145s Preparing to unpack .../47-libjs-sphinxdoc_7.3.7-3_all.deb ... 145s Unpacking libjs-sphinxdoc (7.3.7-3) ... 145s Selecting previously unselected package libjson-perl. 145s Preparing to unpack .../48-libjson-perl_4.10000-1_all.deb ... 145s Unpacking libjson-perl (4.10000-1) ... 145s Selecting previously unselected package pybuild-plugin-autopkgtest. 145s Preparing to unpack .../49-pybuild-plugin-autopkgtest_6.20240603_all.deb ... 145s Unpacking pybuild-plugin-autopkgtest (6.20240603) ... 145s Selecting previously unselected package python3-packaging. 145s Preparing to unpack .../50-python3-packaging_24.1-1_all.deb ... 145s Unpacking python3-packaging (24.1-1) ... 145s Selecting previously unselected package python3-pyproject-hooks. 145s Preparing to unpack .../51-python3-pyproject-hooks_1.1.0-2_all.deb ... 145s Unpacking python3-pyproject-hooks (1.1.0-2) ... 145s Selecting previously unselected package python3-toml. 145s Preparing to unpack .../52-python3-toml_0.10.2-1_all.deb ... 145s Unpacking python3-toml (0.10.2-1) ... 145s Selecting previously unselected package python3-wheel. 145s Preparing to unpack .../53-python3-wheel_0.43.0-1_all.deb ... 145s Unpacking python3-wheel (0.43.0-1) ... 145s Selecting previously unselected package python3-build. 145s Preparing to unpack .../54-python3-build_1.2.1-1_all.deb ... 145s Unpacking python3-build (1.2.1-1) ... 145s Selecting previously unselected package python3-installer. 145s Preparing to unpack .../55-python3-installer_0.7.0+dfsg1-3_all.deb ... 145s Unpacking python3-installer (0.7.0+dfsg1-3) ... 145s Selecting previously unselected package pybuild-plugin-pyproject. 145s Preparing to unpack .../56-pybuild-plugin-pyproject_6.20240603_all.deb ... 145s Unpacking pybuild-plugin-pyproject (6.20240603) ... 145s Selecting previously unselected package python-sqlparse-doc. 145s Preparing to unpack .../57-python-sqlparse-doc_0.5.0-1_all.deb ... 145s Unpacking python-sqlparse-doc (0.5.0-1) ... 145s Selecting previously unselected package python3-all. 145s Preparing to unpack .../58-python3-all_3.12.4-1_s390x.deb ... 145s Unpacking python3-all (3.12.4-1) ... 145s Selecting previously unselected package python3-defusedxml. 145s Preparing to unpack .../59-python3-defusedxml_0.7.1-2_all.deb ... 145s Unpacking python3-defusedxml (0.7.1-2) ... 145s Selecting previously unselected package python3-roman. 145s Preparing to unpack .../60-python3-roman_3.3-3_all.deb ... 145s Unpacking python3-roman (3.3-3) ... 145s Selecting previously unselected package python3-docutils. 145s Preparing to unpack .../61-python3-docutils_0.20.1+dfsg-3_all.deb ... 145s Unpacking python3-docutils (0.20.1+dfsg-3) ... 145s Selecting previously unselected package python3-pathspec. 145s Preparing to unpack .../62-python3-pathspec_0.12.1-1_all.deb ... 145s Unpacking python3-pathspec (0.12.1-1) ... 145s Selecting previously unselected package python3-pluggy. 145s Preparing to unpack .../63-python3-pluggy_1.5.0-1_all.deb ... 145s Unpacking python3-pluggy (1.5.0-1) ... 145s Selecting previously unselected package python3-trove-classifiers. 145s Preparing to unpack .../64-python3-trove-classifiers_2024.4.10-1_all.deb ... 145s Unpacking python3-trove-classifiers (2024.4.10-1) ... 145s Selecting previously unselected package python3-hatchling. 145s Preparing to unpack .../65-python3-hatchling_1.25.0-1_all.deb ... 145s Unpacking python3-hatchling (1.25.0-1) ... 145s Selecting previously unselected package python3-imagesize. 145s Preparing to unpack .../66-python3-imagesize_1.4.1-1_all.deb ... 145s Unpacking python3-imagesize (1.4.1-1) ... 145s Selecting previously unselected package python3-iniconfig. 145s Preparing to unpack .../67-python3-iniconfig_1.1.1-2_all.deb ... 145s Unpacking python3-iniconfig (1.1.1-2) ... 145s Selecting previously unselected package python3-pytest. 145s Preparing to unpack .../68-python3-pytest_7.4.4-1_all.deb ... 145s Unpacking python3-pytest (7.4.4-1) ... 145s Selecting previously unselected package python3-snowballstemmer. 145s Preparing to unpack .../69-python3-snowballstemmer_2.2.0-4build1_all.deb ... 145s Unpacking python3-snowballstemmer (2.2.0-4build1) ... 145s Selecting previously unselected package sphinx-common. 145s Preparing to unpack .../70-sphinx-common_7.3.7-3_all.deb ... 145s Unpacking sphinx-common (7.3.7-3) ... 145s Selecting previously unselected package python3-alabaster. 145s Preparing to unpack .../71-python3-alabaster_0.7.16-0.1_all.deb ... 145s Unpacking python3-alabaster (0.7.16-0.1) ... 145s Selecting previously unselected package python3-sphinx. 145s Preparing to unpack .../72-python3-sphinx_7.3.7-3_all.deb ... 145s Unpacking python3-sphinx (7.3.7-3) ... 145s Selecting previously unselected package python3-sqlparse. 145s Preparing to unpack .../73-python3-sqlparse_0.5.0-1_all.deb ... 145s Unpacking python3-sqlparse (0.5.0-1) ... 145s Selecting previously unselected package sqlformat. 145s Preparing to unpack .../74-sqlformat_0.5.0-1_all.deb ... 145s Unpacking sqlformat (0.5.0-1) ... 145s Selecting previously unselected package autopkgtest-satdep. 145s Preparing to unpack .../75-1-autopkgtest-satdep.deb ... 145s Unpacking autopkgtest-satdep (0) ... 145s Setting up dh-python (6.20240603) ... 145s Setting up python3-iniconfig (1.1.1-2) ... 146s Setting up python3-defusedxml (0.7.1-2) ... 146s Setting up libarchive-zip-perl (1.68-1) ... 146s Setting up python3-alabaster (0.7.16-0.1) ... 146s Setting up libdebhelper-perl (13.16ubuntu2) ... 146s Setting up m4 (1.4.19-4build1) ... 146s Setting up python3-all (3.12.4-1) ... 146s Setting up libgomp1:s390x (14.1.0-4ubuntu2) ... 146s Setting up python3-wheel (0.43.0-1) ... 146s Setting up python3-roman (3.3-3) ... 146s Setting up autotools-dev (20220109.1) ... 146s Setting up python3-packaging (24.1-1) ... 146s Setting up python3-sqlparse (0.5.0-1) ... 146s Setting up gcc-13-base:s390x (13.3.0-3ubuntu1) ... 146s Setting up python3-pyproject-hooks (1.1.0-2) ... 146s Setting up python3-snowballstemmer (2.2.0-4build1) ... 147s Setting up libmpc3:s390x (1.3.1-1build1) ... 147s Setting up libatomic1:s390x (14.1.0-4ubuntu2) ... 147s Setting up autopoint (0.22.5-1) ... 147s Setting up python3-toml (0.10.2-1) ... 147s Setting up python3-installer (0.7.0+dfsg1-3) ... 147s Setting up autoconf (2.71-3) ... 147s Setting up python3-pluggy (1.5.0-1) ... 147s Setting up libubsan1:s390x (14.1.0-4ubuntu2) ... 147s Setting up dwz (0.15-1build6) ... 147s Setting up python3-trove-classifiers (2024.4.10-1) ... 147s Setting up libasan8:s390x (14.1.0-4ubuntu2) ... 147s Setting up libjson-perl (4.10000-1) ... 147s Setting up debugedit (1:5.0-6) ... 147s Setting up sgml-base (1.31) ... 147s Setting up libjs-jquery (3.6.1+dfsg+~3.5.14-1) ... 147s Setting up libisl23:s390x (0.26-3build1) ... 147s Setting up python3-build (1.2.1-1) ... 147s Setting up python3-pathspec (0.12.1-1) ... 148s Setting up libcc1-0:s390x (14.1.0-4ubuntu2) ... 148s Setting up libitm1:s390x (14.1.0-4ubuntu2) ... 148s Setting up libjs-underscore (1.13.4~dfsg+~1.11.4-3) ... 148s Setting up python3-imagesize (1.4.1-1) ... 148s Setting up automake (1:1.16.5-1.3ubuntu1) ... 148s update-alternatives: using /usr/bin/automake-1.16 to provide /usr/bin/automake (automake) in auto mode 148s Setting up libfile-stripnondeterminism-perl (1.14.0-1) ... 148s Setting up gettext (0.22.5-1) ... 148s Setting up sqlformat (0.5.0-1) ... 148s Setting up pybuild-plugin-pyproject (6.20240603) ... 148s Setting up python3-pytest (7.4.4-1) ... 148s Setting up intltool-debian (0.35.0+20060710.6) ... 148s Setting up cpp-13-s390x-linux-gnu (13.3.0-3ubuntu1) ... 148s Setting up libjs-sphinxdoc (7.3.7-3) ... 148s Setting up dh-strip-nondeterminism (1.14.0-1) ... 148s Setting up libgcc-13-dev:s390x (13.3.0-3ubuntu1) ... 148s Setting up xml-core (0.19) ... 148s Setting up python3-hatchling (1.25.0-1) ... 148s Setting up libstdc++-13-dev:s390x (13.3.0-3ubuntu1) ... 148s Setting up cpp-13 (13.3.0-3ubuntu1) ... 148s Setting up cpp-s390x-linux-gnu (4:13.3.0-2ubuntu2) ... 148s Setting up po-debconf (1.0.21+nmu1) ... 148s Setting up python-sqlparse-doc (0.5.0-1) ... 148s Setting up gcc-13-s390x-linux-gnu (13.3.0-3ubuntu1) ... 148s Setting up gcc-s390x-linux-gnu (4:13.3.0-2ubuntu2) ... 148s Setting up g++-13-s390x-linux-gnu (13.3.0-3ubuntu1) ... 148s Setting up sphinx-common (7.3.7-3) ... 148s Setting up gcc-13 (13.3.0-3ubuntu1) ... 148s Setting up cpp (4:13.3.0-2ubuntu2) ... 148s Setting up g++-13 (13.3.0-3ubuntu1) ... 148s Setting up libtool (2.4.7-7build1) ... 148s Setting up g++-s390x-linux-gnu (4:13.3.0-2ubuntu2) ... 148s Setting up gcc (4:13.3.0-2ubuntu2) ... 148s Setting up dh-autoreconf (20) ... 148s Setting up g++ (4:13.3.0-2ubuntu2) ... 148s update-alternatives: using /usr/bin/g++ to provide /usr/bin/c++ (c++) in auto mode 148s Setting up build-essential (12.10ubuntu1) ... 148s Setting up debhelper (13.16ubuntu2) ... 148s Setting up pybuild-plugin-autopkgtest (6.20240603) ... 148s Processing triggers for libc-bin (2.39-0ubuntu9) ... 148s Processing triggers for man-db (2.12.1-2) ... 149s Processing triggers for install-info (7.1-3build2) ... 149s Processing triggers for sgml-base (1.31) ... 149s Setting up docutils-common (0.20.1+dfsg-3) ... 149s Processing triggers for sgml-base (1.31) ... 149s Setting up python3-docutils (0.20.1+dfsg-3) ... 150s Setting up python3-sphinx (7.3.7-3) ... 151s Setting up autopkgtest-satdep (0) ... 154s (Reading database ... 58728 files and directories currently installed.) 154s Removing autopkgtest-satdep (0) ... 154s autopkgtest [06:01:25]: test pybuild-autopkgtest: pybuild-autopkgtest 154s autopkgtest [06:01:25]: test pybuild-autopkgtest: [----------------------- 155s pybuild-autopkgtest 155s I: pybuild base:311: cd /tmp/autopkgtest.KnQ55K/autopkgtest_tmp/build; python3.12 -m pytest -v 155s ============================= test session starts ============================== 155s platform linux -- Python 3.12.4, pytest-7.4.4, pluggy-1.5.0 -- /usr/bin/python3.12 155s cachedir: .pytest_cache 155s rootdir: /tmp/autopkgtest.KnQ55K/autopkgtest_tmp/build 156s collecting ... collected 454 items 156s 156s tests/test_cli.py::test_cli_main_empty PASSED [ 0%] 156s tests/test_cli.py::test_parser_empty PASSED [ 0%] 156s tests/test_cli.py::test_main_help PASSED [ 0%] 156s tests/test_cli.py::test_valid_args PASSED [ 0%] 156s tests/test_cli.py::test_invalid_choice PASSED [ 1%] 156s tests/test_cli.py::test_invalid_args PASSED [ 1%] 156s tests/test_cli.py::test_invalid_infile PASSED [ 1%] 156s tests/test_cli.py::test_invalid_outfile PASSED [ 1%] 156s tests/test_cli.py::test_stdout PASSED [ 1%] 156s tests/test_cli.py::test_script PASSED [ 2%] 156s tests/test_cli.py::test_encoding_stdout[encoding_utf8.sql-utf-8] PASSED [ 2%] 156s tests/test_cli.py::test_encoding_stdout[encoding_gbk.sql-gbk] PASSED [ 2%] 156s tests/test_cli.py::test_encoding_output_file[encoding_utf8.sql-utf-8] PASSED [ 2%] 156s tests/test_cli.py::test_encoding_output_file[encoding_gbk.sql-gbk] PASSED [ 3%] 156s tests/test_cli.py::test_encoding_stdin[encoding_utf8.sql-utf-8] PASSED [ 3%] 156s tests/test_cli.py::test_encoding_stdin[encoding_gbk.sql-gbk] PASSED [ 3%] 156s tests/test_cli.py::test_encoding PASSED [ 3%] 156s tests/test_format.py::TestFormat::test_keywordcase PASSED [ 3%] 156s tests/test_format.py::TestFormat::test_keywordcase_invalid_option PASSED [ 4%] 156s tests/test_format.py::TestFormat::test_identifiercase PASSED [ 4%] 156s tests/test_format.py::TestFormat::test_identifiercase_invalid_option PASSED [ 4%] 156s tests/test_format.py::TestFormat::test_identifiercase_quotes PASSED [ 4%] 156s tests/test_format.py::TestFormat::test_strip_comments_single PASSED [ 5%] 156s tests/test_format.py::TestFormat::test_strip_comments_invalid_option PASSED [ 5%] 156s tests/test_format.py::TestFormat::test_strip_comments_multi PASSED [ 5%] 156s tests/test_format.py::TestFormat::test_strip_comments_preserves_linebreak PASSED [ 5%] 156s tests/test_format.py::TestFormat::test_strip_ws PASSED [ 5%] 156s tests/test_format.py::TestFormat::test_strip_ws_invalid_option PASSED [ 6%] 156s tests/test_format.py::TestFormat::test_preserve_ws PASSED [ 6%] 156s tests/test_format.py::TestFormat::test_notransform_of_quoted_crlf PASSED [ 6%] 156s tests/test_format.py::TestFormatReindentAligned::test_basic PASSED [ 6%] 156s tests/test_format.py::TestFormatReindentAligned::test_joins PASSED [ 7%] 156s tests/test_format.py::TestFormatReindentAligned::test_case_statement PASSED [ 7%] 156s tests/test_format.py::TestFormatReindentAligned::test_case_statement_with_between PASSED [ 7%] 156s tests/test_format.py::TestFormatReindentAligned::test_group_by PASSED [ 7%] 156s tests/test_format.py::TestFormatReindentAligned::test_group_by_subquery PASSED [ 7%] 156s tests/test_format.py::TestFormatReindentAligned::test_window_functions PASSED [ 8%] 156s tests/test_format.py::TestSpacesAroundOperators::test_basic PASSED [ 8%] 156s tests/test_format.py::TestSpacesAroundOperators::test_bools PASSED [ 8%] 156s tests/test_format.py::TestSpacesAroundOperators::test_nested PASSED [ 8%] 156s tests/test_format.py::TestSpacesAroundOperators::test_wildcard_vs_mult PASSED [ 9%] 156s tests/test_format.py::TestFormatReindent::test_option PASSED [ 9%] 156s tests/test_format.py::TestFormatReindent::test_stmts PASSED [ 9%] 156s tests/test_format.py::TestFormatReindent::test_keywords PASSED [ 9%] 156s tests/test_format.py::TestFormatReindent::test_keywords_between PASSED [ 9%] 156s tests/test_format.py::TestFormatReindent::test_parenthesis PASSED [ 10%] 156s tests/test_format.py::TestFormatReindent::test_where PASSED [ 10%] 156s tests/test_format.py::TestFormatReindent::test_join PASSED [ 10%] 156s tests/test_format.py::TestFormatReindent::test_identifier_list PASSED [ 10%] 156s tests/test_format.py::TestFormatReindent::test_identifier_list_with_wrap_after PASSED [ 11%] 156s tests/test_format.py::TestFormatReindent::test_identifier_list_comment_first PASSED [ 11%] 156s tests/test_format.py::TestFormatReindent::test_identifier_list_with_functions PASSED [ 11%] 156s tests/test_format.py::TestFormatReindent::test_long_identifier_list_with_functions PASSED [ 11%] 156s tests/test_format.py::TestFormatReindent::test_case PASSED [ 11%] 156s tests/test_format.py::TestFormatReindent::test_case2 PASSED [ 12%] 156s tests/test_format.py::TestFormatReindent::test_nested_identifier_list PASSED [ 12%] 156s tests/test_format.py::TestFormatReindent::test_duplicate_linebreaks PASSED [ 12%] 156s tests/test_format.py::TestFormatReindent::test_keywordfunctions PASSED [ 12%] 156s tests/test_format.py::TestFormatReindent::test_identifier_and_functions PASSED [ 12%] 156s tests/test_format.py::TestFormatReindent::test_insert_values PASSED [ 13%] 156s tests/test_format.py::TestOutputFormat::test_python PASSED [ 13%] 156s tests/test_format.py::TestOutputFormat::test_python_multiple_statements PASSED [ 13%] 156s tests/test_format.py::TestOutputFormat::test_python_multiple_statements_with_formatting XFAIL [ 13%] 156s tests/test_format.py::TestOutputFormat::test_php PASSED [ 14%] 156s tests/test_format.py::TestOutputFormat::test_sql PASSED [ 14%] 156s tests/test_format.py::TestOutputFormat::test_invalid_option PASSED [ 14%] 156s tests/test_format.py::test_format_column_ordering PASSED [ 14%] 156s tests/test_format.py::test_truncate_strings PASSED [ 14%] 156s tests/test_format.py::test_truncate_strings_invalid_option2[bar] PASSED [ 15%] 156s tests/test_format.py::test_truncate_strings_invalid_option2[-1] PASSED [ 15%] 156s tests/test_format.py::test_truncate_strings_invalid_option2[0] PASSED [ 15%] 156s tests/test_format.py::test_truncate_strings_doesnt_truncate_identifiers[select verrrylongcolumn from foo] PASSED [ 15%] 156s tests/test_format.py::test_truncate_strings_doesnt_truncate_identifiers[select "verrrylongcolumn" from "foo"] PASSED [ 16%] 156s tests/test_format.py::test_having_produces_newline PASSED [ 16%] 156s tests/test_format.py::test_format_right_margin_invalid_option[ten] PASSED [ 16%] 156s tests/test_format.py::test_format_right_margin_invalid_option[2] PASSED [ 16%] 156s tests/test_format.py::test_format_right_margin XFAIL (Needs fixing) [ 16%] 156s tests/test_format.py::test_format_json_ops PASSED [ 17%] 156s tests/test_grouping.py::test_grouping_parenthesis PASSED [ 17%] 156s tests/test_grouping.py::test_grouping_comments PASSED [ 17%] 156s tests/test_grouping.py::test_grouping_assignment[foo := 1;] PASSED [ 17%] 156s tests/test_grouping.py::test_grouping_assignment[foo := 1] PASSED [ 18%] 156s tests/test_grouping.py::test_grouping_typed_literal[x > DATE '2020-01-01'] PASSED [ 18%] 156s tests/test_grouping.py::test_grouping_typed_literal[x > TIMESTAMP '2020-01-01 00:00:00'] PASSED [ 18%] 156s tests/test_grouping.py::test_compare_expr[select a from b where c < d + e-Identifier-Identifier] PASSED [ 18%] 156s tests/test_grouping.py::test_compare_expr[select a from b where c < d + interval '1 day'-Identifier-TypedLiteral] PASSED [ 18%] 156s tests/test_grouping.py::test_compare_expr[select a from b where c < d + interval '6' month-Identifier-TypedLiteral] PASSED [ 19%] 156s tests/test_grouping.py::test_compare_expr[select a from b where c < current_timestamp - interval '1 day'-Token-TypedLiteral] PASSED [ 19%] 156s tests/test_grouping.py::test_grouping_identifiers PASSED [ 19%] 156s tests/test_grouping.py::test_simple_identifiers[1 as f] PASSED [ 19%] 156s tests/test_grouping.py::test_simple_identifiers[foo as f] PASSED [ 20%] 156s tests/test_grouping.py::test_simple_identifiers[foo f] PASSED [ 20%] 156s tests/test_grouping.py::test_simple_identifiers[1/2 as f] PASSED [ 20%] 156s tests/test_grouping.py::test_simple_identifiers[1/2 f] PASSED [ 20%] 156s tests/test_grouping.py::test_simple_identifiers[1<2 as f] PASSED [ 20%] 156s tests/test_grouping.py::test_simple_identifiers[1<2 f] PASSED [ 21%] 156s tests/test_grouping.py::test_group_identifier_list[foo, bar] PASSED [ 21%] 156s tests/test_grouping.py::test_group_identifier_list[sum(a), sum(b)] PASSED [ 21%] 156s tests/test_grouping.py::test_group_identifier_list[sum(a) as x, b as y] PASSED [ 21%] 156s tests/test_grouping.py::test_group_identifier_list[sum(a)::integer, b] PASSED [ 22%] 156s tests/test_grouping.py::test_group_identifier_list[sum(a)/count(b) as x, y] PASSED [ 22%] 156s tests/test_grouping.py::test_group_identifier_list[sum(a)::integer as x, y] PASSED [ 22%] 156s tests/test_grouping.py::test_group_identifier_list[sum(a)::integer/count(b) as x, y] PASSED [ 22%] 156s tests/test_grouping.py::test_grouping_identifier_wildcard PASSED [ 22%] 156s tests/test_grouping.py::test_grouping_identifier_name_wildcard PASSED [ 23%] 156s tests/test_grouping.py::test_grouping_identifier_invalid PASSED [ 23%] 156s tests/test_grouping.py::test_grouping_identifier_invalid_in_middle PASSED [ 23%] 156s tests/test_grouping.py::test_grouping_identifer_as[foo as (select *)] PASSED [ 23%] 156s tests/test_grouping.py::test_grouping_identifer_as[foo as(select *)] PASSED [ 24%] 156s tests/test_grouping.py::test_grouping_identifier_as_invalid PASSED [ 24%] 156s tests/test_grouping.py::test_grouping_identifier_function PASSED [ 24%] 156s tests/test_grouping.py::test_grouping_operation[foo+100] PASSED [ 24%] 156s tests/test_grouping.py::test_grouping_operation[foo + 100] PASSED [ 24%] 156s tests/test_grouping.py::test_grouping_operation[foo*100] PASSED [ 25%] 156s tests/test_grouping.py::test_grouping_identifier_list PASSED [ 25%] 156s tests/test_grouping.py::test_grouping_identifier_list_subquery PASSED [ 25%] 156s tests/test_grouping.py::test_grouping_identifier_list_case PASSED [ 25%] 156s tests/test_grouping.py::test_grouping_identifier_list_other PASSED [ 25%] 156s tests/test_grouping.py::test_grouping_identifier_list_with_inline_comments PASSED [ 26%] 156s tests/test_grouping.py::test_grouping_identifiers_with_operators PASSED [ 26%] 156s tests/test_grouping.py::test_grouping_identifier_list_with_order PASSED [ 26%] 156s tests/test_grouping.py::test_grouping_nested_identifier_with_order PASSED [ 26%] 156s tests/test_grouping.py::test_grouping_where PASSED [ 27%] 156s tests/test_grouping.py::test_grouping_where_union[select 1 where 1 = 2 union select 2] PASSED [ 27%] 156s tests/test_grouping.py::test_grouping_where_union[select 1 where 1 = 2 union all select 2] PASSED [ 27%] 156s tests/test_grouping.py::test_returning_kw_ends_where_clause PASSED [ 27%] 156s tests/test_grouping.py::test_into_kw_ends_where_clause PASSED [ 27%] 156s tests/test_grouping.py::test_grouping_typecast[select foo::integer from bar-integer] PASSED [ 28%] 156s tests/test_grouping.py::test_grouping_typecast[select (current_database())::information_schema.sql_identifier-information_schema.sql_identifier] PASSED [ 28%] 156s tests/test_grouping.py::test_grouping_alias PASSED [ 28%] 156s tests/test_grouping.py::test_grouping_alias_case PASSED [ 28%] 156s tests/test_grouping.py::test_grouping_alias_ctas PASSED [ 29%] 156s tests/test_grouping.py::test_grouping_subquery_no_parens PASSED [ 29%] 156s tests/test_grouping.py::test_grouping_alias_returns_none[foo.bar] PASSED [ 29%] 156s tests/test_grouping.py::test_grouping_alias_returns_none[x, y] PASSED [ 29%] 156s tests/test_grouping.py::test_grouping_alias_returns_none[x > y] PASSED [ 29%] 156s tests/test_grouping.py::test_grouping_alias_returns_none[x / y] PASSED [ 30%] 156s tests/test_grouping.py::test_grouping_idlist_function PASSED [ 30%] 156s tests/test_grouping.py::test_grouping_comparison_exclude PASSED [ 30%] 156s tests/test_grouping.py::test_grouping_function PASSED [ 30%] 156s tests/test_grouping.py::test_grouping_function_not_in PASSED [ 31%] 156s tests/test_grouping.py::test_grouping_varchar PASSED [ 31%] 156s tests/test_grouping.py::test_statement_get_type PASSED [ 31%] 156s tests/test_grouping.py::test_identifier_with_operators PASSED [ 31%] 156s tests/test_grouping.py::test_identifier_with_op_trailing_ws PASSED [ 31%] 156s tests/test_grouping.py::test_identifier_with_string_literals PASSED [ 32%] 156s tests/test_grouping.py::test_identifier_consumes_ordering PASSED [ 32%] 156s tests/test_grouping.py::test_comparison_with_keywords PASSED [ 32%] 156s tests/test_grouping.py::test_comparison_with_floats PASSED [ 32%] 156s tests/test_grouping.py::test_comparison_with_parenthesis PASSED [ 33%] 156s tests/test_grouping.py::test_comparison_with_strings[=] PASSED [ 33%] 156s tests/test_grouping.py::test_comparison_with_strings[!=] PASSED [ 33%] 156s tests/test_grouping.py::test_comparison_with_strings[>] PASSED [ 33%] 156s tests/test_grouping.py::test_comparison_with_strings[<] PASSED [ 33%] 156s tests/test_grouping.py::test_comparison_with_strings[<=] PASSED [ 34%] 156s tests/test_grouping.py::test_comparison_with_strings[>=] PASSED [ 34%] 156s tests/test_grouping.py::test_comparison_with_strings[~] PASSED [ 34%] 156s tests/test_grouping.py::test_comparison_with_strings[~~] PASSED [ 34%] 156s tests/test_grouping.py::test_comparison_with_strings[!~~] PASSED [ 35%] 156s tests/test_grouping.py::test_comparison_with_strings[LIKE] PASSED [ 35%] 156s tests/test_grouping.py::test_comparison_with_strings[NOT LIKE] PASSED [ 35%] 156s tests/test_grouping.py::test_comparison_with_strings[ILIKE] PASSED [ 35%] 156s tests/test_grouping.py::test_comparison_with_strings[NOT ILIKE] PASSED [ 35%] 156s tests/test_grouping.py::test_like_and_ilike_comparison PASSED [ 36%] 156s tests/test_grouping.py::test_comparison_with_functions PASSED [ 36%] 156s tests/test_grouping.py::test_comparison_with_typed_literal PASSED [ 36%] 156s tests/test_grouping.py::test_forloops[FOR] PASSED [ 36%] 156s tests/test_grouping.py::test_forloops[FOREACH] PASSED [ 37%] 156s tests/test_grouping.py::test_nested_for PASSED [ 37%] 156s tests/test_grouping.py::test_begin PASSED [ 37%] 156s tests/test_grouping.py::test_keyword_followed_by_parenthesis PASSED [ 37%] 156s tests/test_grouping.py::test_nested_begin PASSED [ 37%] 156s tests/test_grouping.py::test_aliased_column_without_as PASSED [ 38%] 156s tests/test_grouping.py::test_qualified_function PASSED [ 38%] 156s tests/test_grouping.py::test_aliased_function_without_as PASSED [ 38%] 156s tests/test_grouping.py::test_aliased_literal_without_as PASSED [ 38%] 156s tests/test_grouping.py::test_grouping_as_cte PASSED [ 38%] 156s tests/test_grouping.py::test_grouping_create_table PASSED [ 39%] 156s tests/test_keywords.py::TestSQLREGEX::test_float_numbers[1.0] PASSED [ 39%] 156s tests/test_keywords.py::TestSQLREGEX::test_float_numbers[-1.0] PASSED [ 39%] 156s tests/test_keywords.py::TestSQLREGEX::test_float_numbers[1.] PASSED [ 39%] 156s tests/test_keywords.py::TestSQLREGEX::test_float_numbers[-1.] PASSED [ 40%] 156s tests/test_keywords.py::TestSQLREGEX::test_float_numbers[.1] PASSED [ 40%] 156s tests/test_keywords.py::TestSQLREGEX::test_float_numbers[-.1] PASSED [ 40%] 156s tests/test_parse.py::test_parse_tokenize PASSED [ 40%] 156s tests/test_parse.py::test_parse_multistatement PASSED [ 40%] 156s tests/test_parse.py::test_parse_newlines[select\n*from foo;] PASSED [ 41%] 156s tests/test_parse.py::test_parse_newlines[select\r\n*from foo] PASSED [ 41%] 156s tests/test_parse.py::test_parse_newlines[select\r*from foo] PASSED [ 41%] 156s tests/test_parse.py::test_parse_newlines[select\r\n*from foo\n] PASSED [ 41%] 156s tests/test_parse.py::test_parse_within PASSED [ 42%] 156s tests/test_parse.py::test_parse_child_of PASSED [ 42%] 156s tests/test_parse.py::test_parse_has_ancestor PASSED [ 42%] 156s tests/test_parse.py::test_parse_float[.5] PASSED [ 42%] 156s tests/test_parse.py::test_parse_float[.51] PASSED [ 42%] 156s tests/test_parse.py::test_parse_float[1.5] PASSED [ 43%] 156s tests/test_parse.py::test_parse_float[12.5] PASSED [ 43%] 156s tests/test_parse.py::test_parse_placeholder[select * from foo where user = ?-?] PASSED [ 43%] 156s tests/test_parse.py::test_parse_placeholder[select * from foo where user = :1-:1] PASSED [ 43%] 156s tests/test_parse.py::test_parse_placeholder[select * from foo where user = :name-:name] PASSED [ 44%] 156s tests/test_parse.py::test_parse_placeholder[select * from foo where user = %s-%s] PASSED [ 44%] 156s tests/test_parse.py::test_parse_placeholder[select * from foo where user = $a-$a] PASSED [ 44%] 156s tests/test_parse.py::test_parse_modulo_not_placeholder PASSED [ 44%] 156s tests/test_parse.py::test_parse_access_symbol PASSED [ 44%] 156s tests/test_parse.py::test_parse_square_brackets_notation_isnt_too_greedy PASSED [ 45%] 156s tests/test_parse.py::test_parse_square_brackets_notation_isnt_too_greedy2 PASSED [ 45%] 156s tests/test_parse.py::test_parse_keyword_like_identifier PASSED [ 45%] 156s tests/test_parse.py::test_parse_function_parameter PASSED [ 45%] 156s tests/test_parse.py::test_parse_function_param_single_literal PASSED [ 46%] 156s tests/test_parse.py::test_parse_nested_function PASSED [ 46%] 156s tests/test_parse.py::test_parse_casted_params PASSED [ 46%] 156s tests/test_parse.py::test_parse_div_operator PASSED [ 46%] 156s tests/test_parse.py::test_quoted_identifier PASSED [ 46%] 156s tests/test_parse.py::test_valid_identifier_names[foo] PASSED [ 47%] 156s tests/test_parse.py::test_valid_identifier_names[_foo] PASSED [ 47%] 156s tests/test_parse.py::test_valid_identifier_names[1_data] PASSED [ 47%] 156s tests/test_parse.py::test_valid_identifier_names[\u696d\u8005\u540d\u7a31] PASSED [ 47%] 156s tests/test_parse.py::test_psql_quotation_marks PASSED [ 48%] 156s tests/test_parse.py::test_double_precision_is_builtin PASSED [ 48%] 156s tests/test_parse.py::test_placeholder[?] PASSED [ 48%] 156s tests/test_parse.py::test_placeholder[:1] PASSED [ 48%] 156s tests/test_parse.py::test_placeholder[:foo] PASSED [ 48%] 156s tests/test_parse.py::test_placeholder[%s] PASSED [ 49%] 156s tests/test_parse.py::test_placeholder[%(foo)s] PASSED [ 49%] 156s tests/test_parse.py::test_scientific_numbers[6.67428E-8-expected0] PASSED [ 49%] 156s tests/test_parse.py::test_scientific_numbers[1.988e33-expected1] PASSED [ 49%] 156s tests/test_parse.py::test_scientific_numbers[1e-12-expected2] PASSED [ 50%] 156s tests/test_parse.py::test_scientific_numbers[e1-None] PASSED [ 50%] 156s tests/test_parse.py::test_single_quotes_are_strings PASSED [ 50%] 156s tests/test_parse.py::test_double_quotes_are_identifiers PASSED [ 50%] 156s tests/test_parse.py::test_single_quotes_with_linebreaks PASSED [ 50%] 156s tests/test_parse.py::test_sqlite_identifiers PASSED [ 51%] 156s tests/test_parse.py::test_simple_1d_array_index PASSED [ 51%] 156s tests/test_parse.py::test_2d_array_index PASSED [ 51%] 156s tests/test_parse.py::test_array_index_function_result PASSED [ 51%] 156s tests/test_parse.py::test_schema_qualified_array_index PASSED [ 51%] 156s tests/test_parse.py::test_aliased_array_index PASSED [ 52%] 156s tests/test_parse.py::test_array_literal PASSED [ 52%] 156s tests/test_parse.py::test_typed_array_definition PASSED [ 52%] 156s tests/test_parse.py::test_single_line_comments[select 1 -- foo] PASSED [ 52%] 156s tests/test_parse.py::test_single_line_comments[select 1 # foo] PASSED [ 53%] 156s tests/test_parse.py::test_names_and_special_names[foo] PASSED [ 53%] 156s tests/test_parse.py::test_names_and_special_names[@foo] PASSED [ 53%] 156s tests/test_parse.py::test_names_and_special_names[#foo] PASSED [ 53%] 156s tests/test_parse.py::test_names_and_special_names[##foo] PASSED [ 53%] 156s tests/test_parse.py::test_get_token_at_offset PASSED [ 54%] 156s tests/test_parse.py::test_pprint PASSED [ 54%] 156s tests/test_parse.py::test_wildcard_multiplication PASSED [ 54%] 156s tests/test_parse.py::test_stmt_tokens_parents PASSED [ 54%] 156s tests/test_parse.py::test_dbldollar_as_literal[$$foo$$-True] PASSED [ 55%] 156s tests/test_parse.py::test_dbldollar_as_literal[$_$foo$_$-True] PASSED [ 55%] 156s tests/test_parse.py::test_dbldollar_as_literal[$token$ foo $token$-True] PASSED [ 55%] 156s tests/test_parse.py::test_dbldollar_as_literal[$_$ foo $token$bar$token$ baz$_$-True] PASSED [ 55%] 156s tests/test_parse.py::test_dbldollar_as_literal[$A$ foo $B$-False] PASSED [ 55%] 156s tests/test_parse.py::test_non_ascii PASSED [ 56%] 156s tests/test_parse.py::test_get_real_name PASSED [ 56%] 156s tests/test_parse.py::test_from_subquery PASSED [ 56%] 156s tests/test_parse.py::test_parenthesis PASSED [ 56%] 156s tests/test_parse.py::test_configurable_keywords PASSED [ 57%] 156s tests/test_parse.py::test_configurable_regex PASSED [ 57%] 156s tests/test_parse.py::test_json_operators[->] PASSED [ 57%] 156s tests/test_parse.py::test_json_operators[->>] PASSED [ 57%] 156s tests/test_parse.py::test_json_operators[#>] PASSED [ 57%] 156s tests/test_parse.py::test_json_operators[#>>] PASSED [ 58%] 156s tests/test_parse.py::test_json_operators[@>] PASSED [ 58%] 156s tests/test_parse.py::test_json_operators[<@] PASSED [ 58%] 156s tests/test_parse.py::test_json_operators[||] PASSED [ 58%] 156s tests/test_parse.py::test_json_operators[-] PASSED [ 59%] 156s tests/test_parse.py::test_json_operators[#-] PASSED [ 59%] 156s tests/test_regressions.py::test_issue9 PASSED [ 59%] 156s tests/test_regressions.py::test_issue13 PASSED [ 59%] 156s tests/test_regressions.py::test_issue26[--hello] PASSED [ 59%] 156s tests/test_regressions.py::test_issue26[-- hello] PASSED [ 60%] 156s tests/test_regressions.py::test_issue26[--hello\n] PASSED [ 60%] 156s tests/test_regressions.py::test_issue26[--] PASSED [ 60%] 156s tests/test_regressions.py::test_issue26[--\n] PASSED [ 60%] 156s tests/test_regressions.py::test_issue34[create] PASSED [ 61%] 156s tests/test_regressions.py::test_issue34[CREATE] PASSED [ 61%] 156s tests/test_regressions.py::test_issue35 PASSED [ 61%] 156s tests/test_regressions.py::test_issue38 PASSED [ 61%] 156s tests/test_regressions.py::test_issue39 PASSED [ 61%] 156s tests/test_regressions.py::test_issue40 PASSED [ 62%] 156s tests/test_regressions.py::test_issue78[get_name-z-select x.y::text as z from foo] PASSED [ 62%] 156s tests/test_regressions.py::test_issue78[get_name-z-select x.y::text as "z" from foo] PASSED [ 62%] 156s tests/test_regressions.py::test_issue78[get_name-z-select x."y"::text as z from foo] PASSED [ 62%] 156s tests/test_regressions.py::test_issue78[get_name-z-select x."y"::text as "z" from foo] PASSED [ 62%] 156s tests/test_regressions.py::test_issue78[get_name-z-select "x".y::text as z from foo] PASSED [ 63%] 156s tests/test_regressions.py::test_issue78[get_name-z-select "x".y::text as "z" from foo] PASSED [ 63%] 156s tests/test_regressions.py::test_issue78[get_name-z-select "x"."y"::text as z from foo] PASSED [ 63%] 156s tests/test_regressions.py::test_issue78[get_name-z-select "x"."y"::text as "z" from foo] PASSED [ 63%] 156s tests/test_regressions.py::test_issue78[get_real_name-y-select x.y::text as z from foo] PASSED [ 64%] 156s tests/test_regressions.py::test_issue78[get_real_name-y-select x.y::text as "z" from foo] PASSED [ 64%] 156s tests/test_regressions.py::test_issue78[get_real_name-y-select x."y"::text as z from foo] PASSED [ 64%] 156s tests/test_regressions.py::test_issue78[get_real_name-y-select x."y"::text as "z" from foo] PASSED [ 64%] 156s tests/test_regressions.py::test_issue78[get_real_name-y-select "x".y::text as z from foo] PASSED [ 64%] 156s tests/test_regressions.py::test_issue78[get_real_name-y-select "x".y::text as "z" from foo] PASSED [ 65%] 156s tests/test_regressions.py::test_issue78[get_real_name-y-select "x"."y"::text as z from foo] PASSED [ 65%] 156s tests/test_regressions.py::test_issue78[get_real_name-y-select "x"."y"::text as "z" from foo] PASSED [ 65%] 156s tests/test_regressions.py::test_issue78[get_parent_name-x-select x.y::text as z from foo] PASSED [ 65%] 156s tests/test_regressions.py::test_issue78[get_parent_name-x-select x.y::text as "z" from foo] PASSED [ 66%] 156s tests/test_regressions.py::test_issue78[get_parent_name-x-select x."y"::text as z from foo] PASSED [ 66%] 156s tests/test_regressions.py::test_issue78[get_parent_name-x-select x."y"::text as "z" from foo] PASSED [ 66%] 156s tests/test_regressions.py::test_issue78[get_parent_name-x-select "x".y::text as z from foo] PASSED [ 66%] 156s tests/test_regressions.py::test_issue78[get_parent_name-x-select "x".y::text as "z" from foo] PASSED [ 66%] 156s tests/test_regressions.py::test_issue78[get_parent_name-x-select "x"."y"::text as z from foo] PASSED [ 67%] 156s tests/test_regressions.py::test_issue78[get_parent_name-x-select "x"."y"::text as "z" from foo] PASSED [ 67%] 156s tests/test_regressions.py::test_issue78[get_alias-z-select x.y::text as z from foo] PASSED [ 67%] 156s tests/test_regressions.py::test_issue78[get_alias-z-select x.y::text as "z" from foo] PASSED [ 67%] 156s tests/test_regressions.py::test_issue78[get_alias-z-select x."y"::text as z from foo] PASSED [ 68%] 156s tests/test_regressions.py::test_issue78[get_alias-z-select x."y"::text as "z" from foo] PASSED [ 68%] 156s tests/test_regressions.py::test_issue78[get_alias-z-select "x".y::text as z from foo] PASSED [ 68%] 156s tests/test_regressions.py::test_issue78[get_alias-z-select "x".y::text as "z" from foo] PASSED [ 68%] 156s tests/test_regressions.py::test_issue78[get_alias-z-select "x"."y"::text as z from foo] PASSED [ 68%] 156s tests/test_regressions.py::test_issue78[get_alias-z-select "x"."y"::text as "z" from foo] PASSED [ 69%] 156s tests/test_regressions.py::test_issue78[get_typecast-text-select x.y::text as z from foo] PASSED [ 69%] 156s tests/test_regressions.py::test_issue78[get_typecast-text-select x.y::text as "z" from foo] PASSED [ 69%] 156s tests/test_regressions.py::test_issue78[get_typecast-text-select x."y"::text as z from foo] PASSED [ 69%] 156s tests/test_regressions.py::test_issue78[get_typecast-text-select x."y"::text as "z" from foo] PASSED [ 70%] 156s tests/test_regressions.py::test_issue78[get_typecast-text-select "x".y::text as z from foo] PASSED [ 70%] 156s tests/test_regressions.py::test_issue78[get_typecast-text-select "x".y::text as "z" from foo] PASSED [ 70%] 156s tests/test_regressions.py::test_issue78[get_typecast-text-select "x"."y"::text as z from foo] PASSED [ 70%] 156s tests/test_regressions.py::test_issue78[get_typecast-text-select "x"."y"::text as "z" from foo] PASSED [ 70%] 156s tests/test_regressions.py::test_issue83 PASSED [ 71%] 156s tests/test_regressions.py::test_comment_encoding_when_reindent PASSED [ 71%] 156s tests/test_regressions.py::test_parse_sql_with_binary PASSED [ 71%] 156s tests/test_regressions.py::test_dont_alias_keywords PASSED [ 71%] 156s tests/test_regressions.py::test_format_accepts_encoding PASSED [ 72%] 156s tests/test_regressions.py::test_stream PASSED [ 72%] 156s tests/test_regressions.py::test_issue90 PASSED [ 72%] 156s tests/test_regressions.py::test_except_formatting PASSED [ 72%] 156s tests/test_regressions.py::test_null_with_as PASSED [ 72%] 156s tests/test_regressions.py::test_issue190_open_file PASSED [ 73%] 156s tests/test_regressions.py::test_issue193_splitting_function PASSED [ 73%] 156s tests/test_regressions.py::test_issue194_splitting_function PASSED [ 73%] 156s tests/test_regressions.py::test_issue186_get_type PASSED [ 73%] 156s tests/test_regressions.py::test_issue212_py2unicode PASSED [ 74%] 156s tests/test_regressions.py::test_issue213_leadingws PASSED [ 74%] 156s tests/test_regressions.py::test_issue227_gettype_cte PASSED [ 74%] 156s tests/test_regressions.py::test_issue207_runaway_format PASSED [ 74%] 156s tests/test_regressions.py::test_token_next_doesnt_ignore_skip_cm PASSED [ 74%] 156s tests/test_regressions.py::test_issue284_as_grouping[SELECT x AS] PASSED [ 75%] 156s tests/test_regressions.py::test_issue284_as_grouping[AS] PASSED [ 75%] 156s tests/test_regressions.py::test_issue315_utf8_by_default PASSED [ 75%] 156s tests/test_regressions.py::test_issue322_concurrently_is_keyword PASSED [ 75%] 156s tests/test_regressions.py::test_issue359_index_error_assignments[SELECT @min_price:=MIN(price), @max_price:=MAX(price) FROM shop;] PASSED [ 75%] 156s tests/test_regressions.py::test_issue359_index_error_assignments[SELECT @min_price:=MIN(price), @max_price:=MAX(price) FROM shop] PASSED [ 76%] 156s tests/test_regressions.py::test_issue469_copy_as_psql_command PASSED [ 76%] 156s tests/test_regressions.py::test_issue484_comments_and_newlines XFAIL [ 76%] 156s tests/test_regressions.py::test_issue485_split_multi PASSED [ 76%] 156s tests/test_regressions.py::test_issue489_tzcasts PASSED [ 77%] 156s tests/test_regressions.py::test_issue562_tzcasts PASSED [ 77%] 156s tests/test_regressions.py::test_as_in_parentheses_indents PASSED [ 77%] 156s tests/test_regressions.py::test_format_invalid_where_clause PASSED [ 77%] 156s tests/test_regressions.py::test_splitting_at_and_backticks_issue588 PASSED [ 77%] 156s tests/test_regressions.py::test_comment_between_cte_clauses_issue632 PASSED [ 78%] 156s tests/test_regressions.py::test_copy_issue672 PASSED [ 78%] 156s tests/test_regressions.py::test_primary_key_issue740 PASSED [ 78%] 156s tests/test_regressions.py::test_max_recursion PASSED [ 78%] 156s tests/test_split.py::test_split_semicolon PASSED [ 79%] 156s tests/test_split.py::test_split_backslash PASSED [ 79%] 156s tests/test_split.py::test_split_create_function[function.sql] PASSED [ 79%] 156s tests/test_split.py::test_split_create_function[function_psql.sql] PASSED [ 79%] 156s tests/test_split.py::test_split_create_function[function_psql2.sql] PASSED [ 79%] 156s tests/test_split.py::test_split_create_function[function_psql3.sql] PASSED [ 80%] 156s tests/test_split.py::test_split_create_function[function_psql4.sql] PASSED [ 80%] 156s tests/test_split.py::test_split_dashcomments PASSED [ 80%] 156s tests/test_split.py::test_split_dashcomments_eol[select foo; -- comment\n] PASSED [ 80%] 156s tests/test_split.py::test_split_dashcomments_eol[select foo; -- comment\r] PASSED [ 81%] 156s tests/test_split.py::test_split_dashcomments_eol[select foo; -- comment\r\n] PASSED [ 81%] 156s tests/test_split.py::test_split_dashcomments_eol[select foo; -- comment] PASSED [ 81%] 156s tests/test_split.py::test_split_begintag PASSED [ 81%] 156s tests/test_split.py::test_split_begintag_2 PASSED [ 81%] 156s tests/test_split.py::test_split_dropif PASSED [ 82%] 156s tests/test_split.py::test_split_comment_with_umlaut PASSED [ 82%] 156s tests/test_split.py::test_split_comment_end_of_line PASSED [ 82%] 156s tests/test_split.py::test_split_casewhen PASSED [ 82%] 156s tests/test_split.py::test_split_casewhen_procedure PASSED [ 83%] 156s tests/test_split.py::test_split_cursor_declare PASSED [ 83%] 156s tests/test_split.py::test_split_if_function PASSED [ 83%] 156s tests/test_split.py::test_split_stream PASSED [ 83%] 156s tests/test_split.py::test_split_encoding_parsestream PASSED [ 83%] 156s tests/test_split.py::test_split_unicode_parsestream PASSED [ 84%] 156s tests/test_split.py::test_split_simple PASSED [ 84%] 156s tests/test_split.py::test_split_ignores_empty_newlines PASSED [ 84%] 156s tests/test_split.py::test_split_quotes_with_new_line PASSED [ 84%] 156s tests/test_split.py::test_split_mysql_handler_for PASSED [ 85%] 156s tests/test_split.py::test_split_strip_semicolon[select * from foo;-expected0] PASSED [ 85%] 156s tests/test_split.py::test_split_strip_semicolon[select * from foo-expected1] PASSED [ 85%] 156s tests/test_split.py::test_split_strip_semicolon[select * from foo; select * from bar;-expected2] PASSED [ 85%] 156s tests/test_split.py::test_split_strip_semicolon[ select * from foo;\n\nselect * from bar;\n\n\n\n-expected3] PASSED [ 85%] 156s tests/test_split.py::test_split_strip_semicolon[select * from foo\n\n; bar-expected4] PASSED [ 86%] 156s tests/test_split.py::test_split_strip_semicolon_procedure PASSED [ 86%] 156s tests/test_split.py::test_split_go[USE foo;\nGO\nSELECT 1;\nGO-4] PASSED [ 86%] 156s tests/test_split.py::test_split_go[SELECT * FROM foo;\nGO-2] PASSED [ 86%] 156s tests/test_split.py::test_split_go[USE foo;\nGO 2\nSELECT 1;-3] PASSED [ 87%] 156s tests/test_tokenize.py::test_tokenize_simple PASSED [ 87%] 156s tests/test_tokenize.py::test_tokenize_backticks PASSED [ 87%] 156s tests/test_tokenize.py::test_tokenize_linebreaks[foo\nbar\n] PASSED [ 87%] 156s tests/test_tokenize.py::test_tokenize_linebreaks[foo\rbar\r] PASSED [ 87%] 156s tests/test_tokenize.py::test_tokenize_linebreaks[foo\r\nbar\r\n] PASSED [ 88%] 156s tests/test_tokenize.py::test_tokenize_linebreaks[foo\r\nbar\n] PASSED [ 88%] 156s tests/test_tokenize.py::test_tokenize_inline_keywords PASSED [ 88%] 156s tests/test_tokenize.py::test_tokenize_negative_numbers PASSED [ 88%] 156s tests/test_tokenize.py::test_token_str PASSED [ 88%] 156s tests/test_tokenize.py::test_token_repr PASSED [ 89%] 156s tests/test_tokenize.py::test_token_flatten PASSED [ 89%] 156s tests/test_tokenize.py::test_tokenlist_repr PASSED [ 89%] 156s tests/test_tokenize.py::test_single_quotes PASSED [ 89%] 156s tests/test_tokenize.py::test_tokenlist_first PASSED [ 90%] 156s tests/test_tokenize.py::test_tokenlist_token_matching PASSED [ 90%] 156s tests/test_tokenize.py::test_stream_simple PASSED [ 90%] 156s tests/test_tokenize.py::test_stream_error PASSED [ 90%] 156s tests/test_tokenize.py::test_parse_join[JOIN] PASSED [ 90%] 156s tests/test_tokenize.py::test_parse_join[LEFT JOIN] PASSED [ 91%] 156s tests/test_tokenize.py::test_parse_join[LEFT OUTER JOIN] PASSED [ 91%] 156s tests/test_tokenize.py::test_parse_join[FULL OUTER JOIN] PASSED [ 91%] 156s tests/test_tokenize.py::test_parse_join[NATURAL JOIN] PASSED [ 91%] 156s tests/test_tokenize.py::test_parse_join[CROSS JOIN] PASSED [ 92%] 156s tests/test_tokenize.py::test_parse_join[STRAIGHT JOIN] PASSED [ 92%] 156s tests/test_tokenize.py::test_parse_join[INNER JOIN] PASSED [ 92%] 156s tests/test_tokenize.py::test_parse_join[LEFT INNER JOIN] PASSED [ 92%] 156s tests/test_tokenize.py::test_parse_union PASSED [ 92%] 156s tests/test_tokenize.py::test_parse_endifloop[END IF] PASSED [ 93%] 156s tests/test_tokenize.py::test_parse_endifloop[END IF] PASSED [ 93%] 156s tests/test_tokenize.py::test_parse_endifloop[END\t\nIF] PASSED [ 93%] 156s tests/test_tokenize.py::test_parse_endifloop[END LOOP] PASSED [ 93%] 156s tests/test_tokenize.py::test_parse_endifloop[END LOOP] PASSED [ 94%] 156s tests/test_tokenize.py::test_parse_endifloop[END\t\nLOOP] PASSED [ 94%] 156s tests/test_tokenize.py::test_parse_nulls[NULLS FIRST] PASSED [ 94%] 156s tests/test_tokenize.py::test_parse_nulls[NULLS LAST] PASSED [ 94%] 156s tests/test_tokenize.py::test_parse_identifiers[foo] PASSED [ 94%] 156s tests/test_tokenize.py::test_parse_identifiers[Foo] PASSED [ 95%] 156s tests/test_tokenize.py::test_parse_identifiers[FOO] PASSED [ 95%] 156s tests/test_tokenize.py::test_parse_identifiers[v$name] PASSED [ 95%] 156s tests/test_tokenize.py::test_parse_group_by PASSED [ 95%] 156s tests/test_tokenize.py::test_parse_order_by PASSED [ 96%] 156s tests/test_tokenize.py::test_parse_window_as PASSED [ 96%] 156s tests/test_tokenize.py::test_like_and_ilike_parsed_as_comparisons[LIKE] PASSED [ 96%] 156s tests/test_tokenize.py::test_like_and_ilike_parsed_as_comparisons[ILIKE] PASSED [ 96%] 156s tests/test_tokenize.py::test_like_and_ilike_parsed_as_comparisons[NOT LIKE] PASSED [ 96%] 156s tests/test_tokenize.py::test_like_and_ilike_parsed_as_comparisons[NOT ILIKE] PASSED [ 97%] 156s tests/test_tokenize.py::test_like_and_ilike_parsed_as_comparisons[NOT LIKE] PASSED [ 97%] 156s tests/test_tokenize.py::test_like_and_ilike_parsed_as_comparisons[NOT ILIKE] PASSED [ 97%] 156s tests/test_tokenize.py::test_near_like_and_ilike_parsed_appropriately[LIKEaaa] PASSED [ 97%] 156s tests/test_tokenize.py::test_near_like_and_ilike_parsed_appropriately[bILIKE] PASSED [ 98%] 156s tests/test_tokenize.py::test_near_like_and_ilike_parsed_appropriately[aaILIKEbb] PASSED [ 98%] 156s tests/test_tokenize.py::test_near_like_and_ilike_parsed_appropriately[NOTLIKE] PASSED [ 98%] 156s tests/test_tokenize.py::test_near_like_and_ilike_parsed_appropriately[NOTILIKE] PASSED [ 98%] 156s tests/test_tokenize.py::test_parse_tzcast[AT TIME ZONE 'UTC'] PASSED [ 98%] 156s tests/test_tokenize.py::test_cli_commands PASSED [ 99%] 156s tests/test_utils.py::test_remove_quotes[None-None] PASSED [ 99%] 156s tests/test_utils.py::test_remove_quotes['foo'-foo] PASSED [ 99%] 156s tests/test_utils.py::test_remove_quotes["foo"-foo] PASSED [ 99%] 156s tests/test_utils.py::test_remove_quotes[`foo`-foo] PASSED [100%] 156s 156s ======================== 451 passed, 3 xfailed in 1.22s ======================== 157s autopkgtest [06:01:28]: test pybuild-autopkgtest: -----------------------] 157s pybuild-autopkgtest PASS 157s autopkgtest [06:01:28]: test pybuild-autopkgtest: - - - - - - - - - - results - - - - - - - - - - 157s autopkgtest [06:01:28]: @@@@@@@@@@@@@@@@@@@@ summary 157s pybuild-autopkgtest PASS 169s nova [W] Using flock in scalingstack-bos02-s390x 169s Creating nova instance adt-oracular-s390x-sqlparse-20240721-055850-juju-7f2275-prod-proposed-migration-environment-2-0706e5cc-1c60-4a10-8367-08ab0b954e09 from image adt/ubuntu-oracular-s390x-server-20240721.img (UUID 2c54d233-9ef1-4124-a296-a1ab6c4e4b77)...