I'm running a flow using SQLITE DB. It is simple et efficient enough.
When I start a long query on the database from an external program,
Like:( select count () from MESSAGES where sent = 0;)*
I have an error when node red flow tries to access the DB.
20/08/2024 09:32:56node: DB Commit Sendmsg : error
- "Error: SQLITE_BUSY: database is locked"*
The error is inherent to the way sqlite has been implemented and it is not an issue.
The issue is that that error is not caught by a CATCH node properly setup.
Did someone had same kind of issue ?
Thanks for any idea
Guy