I noticed that my vision trends are no longer showing historical data, rather they are plotting straight lines. All live data is working fine. I quickly checked that the MySQL DB was up and connected which it is. I then checked the store and forward page and it shows some strange statuses:
I pressed the retry button on the error but the buffer and cache remained full and nothing changed. I checked the store and forward status on one of my other tables in that same MySQL DB and it is working fine.
This occurred around the time that I rebooted the server a couple of times in order to reinstall some broken Rockwell software (Logix 5000 and FTV).
I have tried rebooting again, this didn’t work.
The DB is not over utilised, throughput at 50% max.
Since the DB is running with no errors and ignition is successfully connected to the DB I don’t know what to try next.
Any pointers would be very appreciated.