First off, I know FSQL is old school, but it’s not up to me what version of what we run
This afternoon we had a communication failure knock out many sites we have. All these sites have alarms configured, and they all generated the proper alarm except for 1 site. The FSQL log facility had only 1 entry in it, at the time of the failure. I’ve recreated the log here:
Error executing update query: Deadlock found when trying to get lock; try restarting transaction
at FactorySQL.LocalDbOperationProvider.ExecuteParameterNonQuery(DBConnectionID ConnectionID, String Query, IDbDataParameter Parameters, Int32 Timeout)
at FactorySQL.Alerting.EnhancedAlertLogTable.InsertChangeInDB(blah, blah)
MySql.Data.MySqlClient.MySqlClient.MySqlException: Deadlock found when trying to get lock; try restarting transaction
at MySql.Data.MySqlClient.NativeDriver.ReadResult(blah, blah)
It looks like the error could have come from MySQL, but the MySQL logs don’t show anything around that time.
Anyone have any ideas on how to track down the root cause and/or ensure that the issue won’t happen again? (It makes me look bad when obviously all the sites are down but there is still one green dot on the map )
As an aside, I couldn’t select the log text from the log viewer, so I couldn’t copy paste it here. Also, when I tried to Export To File the log, it just created a 3 line XML file with none of the logging information. Are there tricks to getting the log data out from the log viewer without retyping it all?
Thanks in advance!