Skip to main content
  • EN

Hi all, 

 

I have a strange error message in FME Server. I try to create a sqlite file, but it says it is locked. This file did not exist before running the Workspace. Transaction starts at 0.

73	2021-12-2 16:37:35 | SQLite 3 Writer: Opening `\\fme-server******\resources\data\GIPOD\GIPOD_Beta_Token.sqlite' for write operation
74	2021-12-2 16:37:37 | SQLite 3 Writer: Failed to open database '\\fme-serve********\resources\data\GIPOD\GIPOD_Beta_Token.sqlite'. SQLite3 Engine error: `database is locked'
75	2021-12-2 16:37:37 | SQLITE3 writer: A fatal error has occurred. Check the logfile above for details
76	2021-12-2 16:37:37 | JSONExtractor (JSONQueryFactory): A fatal error has occurred. Check the logfile above for details
77	2021-12-2 16:37:37 | HTTPCaller_3 (HTTPFactory): A fatal error has occurred. Check the logfile above for details
78	2021-12-2 16:37:37 | AttributeKeeper (AttributeKeeperFactory): SQLITE3 writer: A fatal error has occurred. Check the logfile above for details
79	2021-12-2 16:37:37 | A fatal error has occurred. Check the logfile above for details
80	2021-12-2 16:37:37 | Bridge failed to output feature on tag `PYOUTPUT'
81	2021-12-2 16:37:37 | PythonCaller (PythonFactory): PythonFactory failed to process feature
82	2021-12-2 16:37:37 | PythonCaller (PythonFactory): A fatal error has occurred. Check the logfile above for details
83	2021-12-2 16:37:37 | Creator_XML_Creator (CreationFactory): A fatal error has occurred. Check the logfile above for details
84	2021-12-2 16:37:37 | SQLite 3 Writer: Aborting write operation
85	2021-12-2 16:37:37 | SQLite 3 Writer: Translation aborted -- rerun specifying "SQLite 3 Writer_START_TRANSACTION 0"

any thoughts?

 

best regards, 

Jelle

 

Do you have one writer or multiple writers accessing the same file?

Does this always fail? Can you create a dummy with a simple workspace only containing a Creator and a writer?

Do you have one writer or multiple writers accessing the same file?

Does this always fail? Can you create a dummy with a simple workspace only containing a Creator and a writer?

Hi Niels, thank you for your answer.

When I publish a simple Workspace with SQLite or GPKG Readers/Writers, I get similar messages. Could it possibly have to do with the installation of FME Server, or access to certain installation folders?

Hi Niels, thank you for your answer.

When I publish a simple Workspace with SQLite or GPKG Readers/Writers, I get similar messages. Could it possibly have to do with the installation of FME Server, or access to certain installation folders?

I get the same problem in Desktop Workbench, write a GPKG then use SQLExecutor to create a view and it errors with a read-only error.

Hi Niels, thank you for your answer.

When I publish a simple Workspace with SQLite or GPKG Readers/Writers, I get similar messages. Could it possibly have to do with the installation of FME Server, or access to certain installation folders?

My problem had to do with  https://www.sqlite.org/faq.html#q5: "But use caution: this locking mechanism might not work correctly if the database file is kept on an NFS filesystem. This is because fcntl() file locking is broken on many NFS implementations. You should avoid putting SQLite database files on NFS if multiple processes might try to access the file at the same time."

Hi Niels, thank you for your answer.

When I publish a simple Workspace with SQLite or GPKG Readers/Writers, I get similar messages. Could it possibly have to do with the installation of FME Server, or access to certain installation folders?

I'm using local disk, but thanks for the extra context.

Reply


Community Stats

30,163
Posts
114,502
Replies
37,817
Members
Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.