Solved

SQLite file locked on FME_SHAREDRESOURCES_DATA

  • 2 December 2021
  • 5 replies
  • 25 views
jelle
Rank
Badge +11

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

 

icon

Best answer by jelle 15 December 2022, 08:40

View original

5 replies

nielsgerrits
Rank
Userlevel 6
Badge +33

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?

jelle
Rank
Badge +11

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?

bruceharold
Rank
Badge +16

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.

jelle
Rank
Badge +11

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."

bruceharold
Rank
Badge +16

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

28,731
Posts
109,530
Replies
36,566
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.