Skip to content

Storing the taskgraph db on a Windows mounted network drive causes a failure #103

@phargogh

Description

@phargogh

A user on the forums reported an issue where taskgraph's database was repeatedly locked, and then the model ultimately failed with a cryptic error mentioning the URI authority:

Traceback (most recent call last):
  File "natcap\invest\utils.py", line 164, in prepare_workspace
  File "invest\cli.py", line 470, in main
  File "natcap\invest\pollination.py", line 536, in execute
  File "taskgraph\Task.py", line 336, in __init__
  File "retrying.py", line 49, in wrapped_f
  File "retrying.py", line 212, in call
  File "retrying.py", line 247, in get
  File "six.py", line 719, in reraise
  File "retrying.py", line 200, in call
  File "taskgraph\Task.py", line 1561, in _execute_sqlite
sqlite3.OperationalError: invalid uri authority: ags-fs-profiles

This appears to ultimately be occurring because the user has mounted a network location on Windows but not given it a drive letter. In this case, SQLite can't handle the path because it isn't a valid location. It'd be wise for us to handle this case.

logfile:
InVEST-natcap.invest.pollination-log-2024-05-06--14_39_00.txt

Metadata

Metadata

Assignees

No one assigned

    Labels

    bugSomething isn't working

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions