Hi there - we have an Ignition instance that was recently migrated from an old computer, and everything seemed to be working well for the first couple of months. However, we are seeing a status message under the 'Store and Forward' section stating that there are thousands of items quarantined. When looking at the details, there is a message stating "The user specified as a definer ('mysql.infoschema'@'localhost') does not exist". I tried looking this up in the forums here and elsewhere online, but am not coming up with much so far.
The database connection itself is working normally, so we're not sure if we need to create this user in MySQL for this store and forward function, or if we can change the user to what we're using for the database connection? Or if there's something else we need to do to resolve this. Has anyone run into this before, or have any pointers to help? Thank you so much for any help!
Look in the database connection settings. There's a specific username and password defined, that the Gateway will use to connect to your DB. That's where that username is coming from.
Also... the use of localhost in that error message suggests you're running your DB and Ignition Gateway on the same host. This is generally not advisable, because database engines love to consume all available memory and processing power on a system as they grow over time, leaving none for Ignition. It may not be a problem today, but may be something to consider changing in the future.
It turns out this may have resulted from migrating a sql data dump from a computer running MySQL 5.7, to another running MySQL 8.0. Running the mysqld upgrade option on the data directory fixed the issue, and we seem to be back in business. Just in case anyone else runs into this same situation - hope it helps.
Thank you,