Skip to content

Tests fail to run: sqlite3.OperationalError: no such column: "systems" - should this be a string literal in single-quotes?

===>  Testing for py311-icet-3.0
===>   py311-icet-3.0 depends on package: py311-pytest>=7,1 - found
===>   py311-icet-3.0 depends on file: /usr/local/bin/python3.11 - found
cd /usr/ports/science/py-icet/work-py311/icet-769b5db248baa5146bdb294e963e061cf2dfd228 && /usr/bin/env -i HOME=/usr/ports/science/py-icet/work-py311  MACHINE_ARCH=amd64  PWD="${PWD}"  GIT_CEILING_DIRECTORIES=/usr/ports/science/py-icet/work-py311  __MAKE_CONF=/nonexistent OSVERSION=1402501 PATH=/usr/local/libexec/ccache:/usr/ports/science/py-icet/work-py311/.bin:/home/yuri/bin:/sbin:/bin:/usr/sbin:/usr/bin:/usr/local/sbin:/usr/local/bin TERM=xterm-256color XDG_DATA_HOME=/usr/ports/science/py-icet/work-py311  XDG_CONFIG_HOME=/usr/ports/science/py-icet/work-py311  XDG_CACHE_HOME=/usr/ports/science/py-icet/work-py311/.cache  HOME=/usr/ports/science/py-icet/work-py311 PATH=/usr/local/libexec/ccache:/usr/ports/science/py-icet/work-py311/.bin:/home/yuri/bin:/sbin:/bin:/usr/sbin:/usr/bin:/usr/local/sbin:/usr/local/bin PKG_CONFIG_LIBDIR=/usr/ports/science/py-icet/work-py311/.pkgconfig:/usr/local/libdata/pkgconfig:/usr/local/share/pkgconfig:/usr/libdata/pkgconfig MK_DEBUG_FILES=no MK_KERNEL_SYMBOLS=no SHELL=/bin/sh NO_LINT=YES PREFIX=/usr/local  LOCALBASE=/usr/local  CC="cc" CFLAGS="-O2 -pipe  -fstack-protector-strong -fno-strict-aliasing "  CPP="cpp" CPPFLAGS=""  LDFLAGS=" -fstack-protector-strong " LIBS=""  CXX="c++" CXXFLAGS="-O2 -pipe -fstack-protector-strong -fno-strict-aliasing  " CCACHE_DIR="/tmp/.ccache" BSD_INSTALL_PROGRAM="install  -s -m 555"  BSD_INSTALL_LIB="install  -s -m 0644"  BSD_INSTALL_SCRIPT="install  -m 555"  BSD_INSTALL_DATA="install  -m 0644"  BSD_INSTALL_MAN="install  -m 444" PYTHONPATH=/usr/ports/science/py-icet/work-py311/stage/usr/local/lib/python3.11/site-packages /usr/local/bin/python3.11 -m pytest -k '' -rs -v -o addopts= 
Test session starts (platform: freebsd14, Python 3.11.11, pytest 8.1.1, pytest-sugar 1.0.0)
cachedir: .pytest_cache
hypothesis profile 'default' -> database=DirectoryBasedExampleDatabase(PosixPath('/usr/ports/science/py-icet/work-py311/icet-769b5db248baa5146bdb294e963e061cf2dfd228/.hypothesis/examples'))
rootdir: /usr/ports/science/py-icet/work-py311/icet-769b5db248baa5146bdb294e963e061cf2dfd228
configfile: pyproject.toml
plugins: time-machine-2.11.0, flaky-3.8.1, aspectlib-2.0.0, hypothesis-6.123.2, xdist-3.6.1, sugar-1.0.0, rerunfailures-11.1.2, cov-5.0.0, mock-3.10.0, instafail-0.5.0, subtests-0.12.1, asyncio-0.23.8, subprocess-1.5.2, timeout-2.1.0, anyio-4.7.0
asyncio: mode=Mode.STRICT
collecting 0 items / 1 error                                                                                                                                                                                                                                                  
―――――――――――――――――――――――――――――――――――――――――――――――――――――――――――――――――――――――――――――――――――――――――――――――― ERROR collecting examples/advanced_topics/test_cluster_vector_correlation.py ―――――――――――――――――――――――――――――――――――――――――――――――――――――――――――――――――――――――――――――――――――――――――――――――――
examples/advanced_topics/test_cluster_vector_correlation.py:86: in <module>
    for row in db.select('id<=10'):
/usr/local/lib/python3.11/site-packages/ase/parallel.py:302: in new_generator
    for result in generator(*args, **kwargs):
/usr/local/lib/python3.11/site-packages/ase/db/core.py:519: in select
    for row in self._select(keys, cmps, explain=explain,
/usr/local/lib/python3.11/site-packages/ase/db/sqlite.py:688: in _select
    with self.managed_connection() as con:
/usr/local/lib/python3.11/contextlib.py:137: in __enter__
    return next(self.gen)
/usr/local/lib/python3.11/site-packages/ase/db/sqlite.py:193: in managed_connection
    self._initialize(con)
/usr/local/lib/python3.11/site-packages/ase/db/sqlite.py:214: in _initialize
    cur = con.execute(
E   sqlite3.OperationalError: no such column: "systems" - should this be a string literal in single-quotes?
collected 806 items / 1 error / 1 skipped                                                                                                                                                                                                                                     

=========================================================================================================================== short test summary info ===========================================================================================================================
SKIPPED [1] tests/unittest/test_icet/tools/test_ground_state_finder.py:45: unittest.case.SkipTest: no mip module
!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!! Interrupted: 1 error during collection !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

Version: 3.0

Python-3.11

FreeBSD 14.2

To upload designs, you'll need to enable LFS and have an admin enable hashed storage. More information