DuckDB unable to read data - no lock on file

[michael-layfer]

Using a DuckDB on a shared storage (NFS) I am unable to query the data. I can see the tables and metadata but when executing a select statement I am hitting this error:

SQL Error [67108864]: Query failed (#20250515_102353_00010_dqcgj): IO Error: Could not set lock on file "/storage/my_db.duckdb": Conflicting lock is held in PID 0. See also https://duckdb.org/docs/connect/concurrency

I have reduced the number of Trino workers to 1 to eliminate the risk of any bad worker locking the file, but no change.