Hello,
Thanks for your reply. I will be able to do the changes only on Friday. I will get back to you.
Regards,
PS: In the meanwhile, as we need to fix the problem ASAP, I wrote two separate lua scripts that run in the background, using another sqlite3 db:
-
Script ‘one’ continuously (every 5 seconds) reads each of the modbus calls and stores data in an sqlite3 table (named ‘read_data’). It also runs a sampling every 5 minutes to enqueue the latest (not older than 3 minutes) read data into another table (called ‘rest_queue’)
-
Script ‘two’ continuously (every 5 seconds) tries to send unsent data in table ‘rest_queue’ using REST API calls, effectively implementing a FIFO queue pattern.