Skip to main content
Solved

SQLite file locked on FME_SHAREDRESOURCES_DATA

  • December 2, 2021
  • 5 replies
  • 246 views
jelle
Contributor
Forum|alt.badge.img+21
  • jelleContributor
  • Contributor
  • 122 replies

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

 

Best answer by jelle

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

This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.

5 replies

nielsgerrits
VIP
Forum|alt.badge.img+60
  • nielsgerritsVIP
  • 2938 replies
  • December 3, 2021

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?

Buckle your seatbelt Dorothy, cause Kansas is going bye-bye...
jelle
Contributor
Forum|alt.badge.img+21
  • jelleContributor
  • Author
  • Contributor
  • 122 replies
  • December 9, 2021

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
Supporter
Forum|alt.badge.img+19
  • bruceharoldSupporter
  • Supporter
  • 344 replies
  • December 14, 2022

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
Contributor
Forum|alt.badge.img+21
  • jelleContributor
  • Author
  • Contributor
  • 122 replies
  • Best Answer
  • December 15, 2022

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
Supporter
Forum|alt.badge.img+19
  • bruceharoldSupporter
  • Supporter
  • 344 replies
  • December 15, 2022

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.

Community Stats

32,066
Posts
121,745
Replies
39,692
Members

Latest FME

Terms & ConditionsCookie settingsAccessibility statement
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.