Unfortunately, when this occurs, the gateway web is not accessible so the thread dump is not possible at the time of the crash. which is why only the wrapper logs were sent. The attached thread dump is for right now when the memory is just high but no crash.
Yes the same problem was encountered with previous ignition versions as well when it was decided to stick with factorysql. The thing is factorytalk OPC server memory remains stable and the same OPC server was working with factorysql for many years without any issues.
Today the memory is already close to 1 GB and I can see that randomly the fsql-thread-1 to 5 are going into blocked or blocking some times and then they clear.
ThreadDump.txt (46.1 KB)