Hi there,
I'm running ESET Remote Administrator on a Gcloud instance and the database uses GCloud SQL. Everything worked for a few weeks but without any kind of changes on our side the remote administrator fails now to show an kind of data.
I can login but I can view any data related to reports, machines, configurations...
Looking at the errors I get:
- Error while generating report on each graph of the dashboard
- CCleanupModule: Failed to process cleanup task request with: [MySQL][ODBC 5.3(w) Driver][mysqld-5.6.29-google-log]When @@GLOBAL.ENFORCE_GTID_CONSISTENCY = 1, the statements CREATE TEMPORARY TABLE and DROP TEMPORARY TABLE can be executed in a non-transactional context only, and require that AUTOCOMMIT = 1. These statements are also not allowed in a function or trigger because functions and triggers are also considered to be multi-statement transactions.
- CCleanupModule: [MySQL][ODBC 5.3(w) Driver][mysqld-5.6.29-google-log]When @@GLOBAL.ENFORCE_GTID_CONSISTENCY = 1, the statements CREATE TEMPORARY TABLE and DROP TEMPORARY TABLE can be executed in a non-transactional context only, and require that AUTOCOMMIT = 1. These statements are also not allowed in a function or trigger because functions and triggers are also considered to be multi-statement transactions.
On every page load. By default GCloud SQL uses ENFORCE_GTID_CONSISTENCY for replication which prevents the use of, for example, temp tables.
Is there any workaround? I don't think I can disable that "feature" without downgrading to another version of MySQL. I'm sharing that database with another tool and that's why I was trying to don't downgrade. I would prefer to always use the latest stable versions.
Cheers