sqlite+aiosqlite implementation cannot open database file

[agherasim]

Describe the bug
When referencing a sqlite database using the aiosqlite driver, the file cannot be loaded due to mixup between DB url and expected filesystem path for aiosqlite.connect method.

Using configuration sqlite+aiosqlite:///./sessions.db results in sqlite3.OperationalError: unable to open database file despite correct file path and permissions.

To Reproduce
Steps to reproduce the behavior:

1. Install google-adk v1.21.0
2. Configure DatabaseSessionService with url sqlite+aiosqlite:///./sessions.db
3. Run a fastapi instance and request a new session
4. Provide error or stacktrace

  File "/Users/<path_redacted>/.venv/lib/python3.13/site-packages/google/adk/sessions/sqlite_session_service.py", line 131, in create_session
    async with self._get_db_connection() as db:
               ~~~~~~~~~~~~~~~~~~~~~~~^^
  File "/opt/homebrew/Cellar/python@3.13/3.13.0_1/Frameworks/Python.framework/Versions/3.13/lib/python3.13/contextlib.py", line 214, in __aenter__
    return await anext(self.gen)
           ^^^^^^^^^^^^^^^^^^^^^
  File "/Users/<path_redacted>/.venv/lib/python3.13/site-packages/google/adk/sessions/sqlite_session_service.py", line 418, in _get_db_connection
    async with aiosqlite.connect(self._db_path) as db:
               ~~~~~~~~~~~~~~~~~^^^^^^^^^^^^^^^
  File "/Users/<path_redacted>/.venv/lib/python3.13/site-packages/aiosqlite/core.py", line 154, in __aenter__
    return await self
           ^^^^^^^^^^
  File "/Users/<path_redacted>/.venv/lib/python3.13/site-packages/aiosqlite/core.py", line 141, in _connect
    self._connection = await future
                       ^^^^^^^^^^^^
  File "/Users/<path_redacted>/.venv/lib/python3.13/site-packages/aiosqlite/core.py", line 65, in _connection_worker_thread
    result = function()
  File "/Users/<path_redacted>/.venv/lib/python3.13/site-packages/aiosqlite/core.py", line 455, in connector
    return sqlite3.connect(loc, **kwargs)
           ~~~~~~~~~~~~~~~^^^^^^^^^^^^^^^
sqlite3.OperationalError: unable to open database file

Expected behavior
The DB file should be created (if missing) and a new session should be created and stored.

Desktop (please complete the following information):

• OS: macOS
• Python version(python -V): Python 3.13.0
• ADK version(pip show google-adk): v1.21.0

[agherasim]

Reference configuration documentation https://google.github.io/adk-docs/sessions/session/#sessionservice-implementations

[wuliang229]

I tested locally on my Mac and I didn't encounter your issue. Could you provide the steps to reproduce?

Here are my setup:

uv venv venv1 --python 3.13 --clear

source venv1/bin/activate

uv pip install google-adk==1.21.0

uv run main.py

In my main.py, the code is:

import asyncio

from google.adk.agents import LlmAgent
from google.adk.apps import App
from google.adk.runners import Runner
from google.adk.sessions import DatabaseSessionService
from google.genai import types


async def run_prompt(runner, session, new_message: str):
  content = types.Content(
      role='user', parts=[types.Part.from_text(text=new_message)]
  )
  print('** User says:', content.model_dump(exclude_none=True))
  async for event in runner.run_async(
      user_id='user1',
      session_id=session.id,
      new_message=content,
  ):
    if event.content.parts and event.content.parts[0].text:
      print(f'** {event.author}: {event.content.parts[0].text}')


async def main():
  my_agent = LlmAgent(
      model='gemini-2.5-flash-lite',
      name='Agent',
      description='Agent',
  )

  my_app = App(
      name='my_app',
      root_agent=my_agent,
  )

  db_url = 'sqlite+aiosqlite:///./my_agent_data.db'
  session_service = DatabaseSessionService(db_url=db_url)

  my_runner = Runner(
      app=my_app,
      session_service=session_service,
  )

  my_session = await session_service.create_session(
      app_name='research_app_compacting', user_id='user1'
  )

  await run_prompt(my_runner, my_session, 'Hi')


if __name__ == '__main__':
  asyncio.run(main())