You are not logged in.
Hi @ab,
I have the secBusy error (code = 5) when storing in a local SQLite3 table (no external mapping) the notified changes in OnUpdateEventLog and the system is under high load. The local table it is in the main REST server together to external tables. I need notify to an third party external process the changes on some tables. Is there another way ?
Any suggestion I will appreciate you.
TIA.
Esteban
Offline
The current Sqlite3 use in mORMot expects exclusive access on the physical file.
Ensure a single process and thread open the Sqlite3 local file.
Then you shouldn't have any secBusy error.
Online
Thanks @ab, I see that TSQLRecordHistory can compliance my requirements but I would need that the record ID and the table name fields exists explicitly in the table, this is for external services that can read and delete the records. Can you add this fields ? I really would appreciate this feature.
Thanks.
Last edited by EMartin (2017-11-08 13:31:57)
Esteban
Offline
@ab with TSQLRecordHistory the error still persists, how I must to configure the TSQLRestServerDB for ensure a single process open the associated SQLite3 database ? I have to define all "AcquireExecutionMode" to same value ? What would be those value ?
Sorry for many questions but I am confusing.
Thanks.
Esteban
Offline
I know, but for third party external processes accessing with JSON REST this values are not works.
Esteban
Offline
Solved busy error but still I need the fields, maybe de JSONEncode, in DoTrackChanges local procedure, can be moved as virtual function. What think you about this ?
Thanks.
Esteban
Offline