natcap/taskgraph

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

phargogh opened this issue · 0 comments

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