why would i be seeing this warning message in the gateway console a few times every hour?
does anyone think this is because I have FactorySQL and Ignition setup to write to the same database alert table?
That sounds like the most likely scenario. If Ignition is getting deadlock errors that means that something else is locking the table. It’s unusual for anything to be using that table, but if you are using both FactorySQL and Ignition with the same table, it is likely the problem.