While trying to test robustness of system, we took down MySQL for a moment then brought it back up. This is with a Kepware -> FSQL -> FPMI implementation. We wanted to see what would happen to the system.
After return of the database, we could no longer write to any tags - reads seemed OK, but write errors. We restarted the FPMI gateway, but that didn’t help. We disabled, then re-enabled, SQLTags in FSQL and that seemed to solve it. I know there is caching in FSQL if the Database goes away, but could you describe how SQLTags should behave with a database shutdown/restart? I don’t know the designed behaviour, so I can’t put what we are seeing in context. I also couldn’t find info in any of the logs related to the DB down event. Any ideas on where I should look?