Store and forward issue Ignition 8.0.16:

Ignition
1

Hello all,
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:

image
image1431×836 31.6 KB

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.

Regards,
Mat.

2

Possibly corrupted files in MySQL for that table? Look at your MySQL logs.

ps. Having Ignition, MySQL, and Rockwell Software all on the same server is a recipe for disaster.

3

Hahahaha. I’d say Rockwell Software and anything else.

1 Like
4

I’ve had Ignition, MySQL, and Rockwell (Studio 5000) installed on the same box several times with no issues.

5

Potentially, since most the time upgrading RWS versions ends in something breaking and the need to reinstall the entire suite again is many reboots etc.

6

Yes I have run this setup for well over a year with zero issues. In fact the MySQL setup ran with zero issues for 6 years.

7

Thanks pturmel for the suggestion with the DB logs.

One interesting tid bit is that the trends are approx 8-9 hours delayed, as in, the trend data is eventually written to the DB, the data is not being lost, it just takes about 8-9 hours to finally get into the DB.

Thanks,
Mat.