We're currently down right now due to this...
This morning Ignition was found to be running super slow. CPU usage on the server was basically maxed out (memory and drive space were fine). We did a net stop ignition / net start ignition but right now I've been stuck indefinitely on the "Ignition Gateway is Starting" screen.
clearly something is wrong. Please see the attached log file.
Prior to the shutdown we did check connectivity to our SQL DB and it seemed OK. Not sure why the log is showing repeated activity with sqllite (we use MSSQL BTW).
I really could use some guidance... any feedback would be great! log file.txt (8.7 MB)
SQLite is the internal configuration db for Ignition. If this is a mission critical issue, you need to contact Support. This forum is not an official support venue.
Thank you both for your responses. FYI I deleted the system_logs.idb but still was stuck in the "Ignition Gateway is Starting" loop. In the end I decided to just nuke the existing installation and reinstall. Thank goodness for backups! The newly installed instance seems to be working great; CPU usage is ~20% and it's obvious that client connections are running faster than before. Frankly the reinstallation was very fast so this was probably a better option overall considering the amount of time spent trying to troubleshoot. Again thank you for your help!
nminchin - by "restarted service" you mean doing net stop ignition / net start ignition? If so then yes, I absolutely was doing this with no avail.
jespinmartin1 - I'm pretty sure I was running 8.1.1 so maybe that's part of the issue. I took advantage of this situation to upgrade to the latest version, so that's good!
Speaking of malformed internal db: Could this happen with an abrupt power loss on the server? It turns out we DID have a blackout late last week and I do recall noticing the system starting to run really slow after that. It was at an absolute crawl yesterday which is why I attempted to restart the Ignition server and then found it wouldn't restart.