For the complete documentation index, see llms.txt. This page is also available as Markdown.

Error 1785: When @@GLOBAL.ENFORCE_GTID_CONSISTENCY = 1, updates to non-transactional tables can only

Error Code
SQLSTATE
Error
Description

1785

HY000

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.

Possible Causes and Solutions

This page is licensed: CC BY-SA / Gnu FDL

spinner

Last updated

Was this helpful?