Oracle’s preferred method for MySQL HA is to use GTID based replication. To enable GTID based replication, two things need to be added to the /etc/my.cnf file12enforce_gtid_consistency = ONgtid_mode = ON
The oro_search_index_text table is MyISAM. Updates to a MyISAM table have certain restrictions when using GTIDs.
The install script will break when the target database is set up for GTID based replication. The specific error is:12An exception occurred while executing 'INSERT INTO oro_search_index_text (field, value, item_id) VALUES (?, ?, ?)' with params ["name", "default", 1]:SQLSTATE[HY000]: General error: 1785 Statement violates GTID consistency: 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.
Running this statement outside a transaction (or in autocommit mode) should solve this.
You must be logged in to reply to this topic.