Using node-red-node-sqlite: error are uncaught by CATCH node

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

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.