Newer MySQL versions may error if committing a transaction when not in one #4381
Description
Describe the bug
Inside of a plugin, if you attempt to commit a transation between a database start when you have lost the beginning of the transaction, you will receive a FATAL PDOException which results in the disabling of the plugin. Cacti should not allow this to happen.
To Reproduce
Steps to reproduce the behavior:
-
In a plugin, start a transaction
-
Sleep inside of that transaction
-
Quickly restart the database server
-
Commit the transaction after the restart
-
Note the error in the Cacti log and that the plugin has been disabled.
Expected behavior
Cacti should not fail under this circumstance.