In this post, you’ll learn more about the MariaDB Error 1785 ER_GTID_UNSAFE_NON_TRANSACTIONAL_TABLE with the details of the error message and why you receive this error
Maria DB Error Description
MariaDB Error 1785 – ER_GTID_UNSAFE_NON_TRANSACTIONAL_TABLE with the sqlState HY000
Error Description for the MariaDB Error ER_GTID_UNSAFE_NON_TRANSACTIONAL_TABLE
When @@GLOBAL.ENFORCE_GTID_CONSISTENCY = 1, updates to non-transactional tables can only be done in either autocommitted statements or single-statement transactions, and never in the same statement as updates to transactional tables.