1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

XF 1.5 Statement violates GTID consistency

Discussion in 'XenForo Questions and Support' started by CrispinP, Sep 13, 2016.

  1. CrispinP

    CrispinP Active Member

    Hi folks,


    I recently reinstalled my QA server and put mysql57 on there (my prod has 5.6).
    I am now getting the following error whenever I try create a thread or resource.

    Mysqli statement execute error : 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.

    I've turned off GTID in the my.cnf and restarted mySQL but to no avail.

    Any clues as to how to get this to work?

    This DB is a restore from prod in both code and DB.

    Full error:
    upload_2016-9-13_23-16-14.png




    Thanks
    Crispin
     
  2. Mike

    Mike XenForo Developer Staff Member

    It sounds like GTIDs are still on. There are a couple options surrounding this: https://dev.mysql.com/doc/refman/5.7/en/replication-options-gtids.html Make sure you set both of them off and confirm that they're off when the server is running (via SHOW VARIABLES).
     
  3. CrispinP

    CrispinP Active Member

    So that's the odd thing - they were on (by default apparently) and I turned them off.

    I set them off with the @globalthingymagig as well as in the my.cnf. A reboot and it still shows as off.


    upload_2016-9-14_19-40-13.png
     
  4. Mike

    Mike XenForo Developer Staff Member

    I assume you're still having the problem. Just to confirm then, what about enforce_gtid_consistency?
     
    CrispinP likes this.
  5. CrispinP

    CrispinP Active Member

    Perfect! Thanks for the tip. Setting that off and/or editing the my.cnf and setting it to zero there works.

    So, if this was a default install of 5.7.13, is there going to be fun to be had with new users who install this and XF?
    My prod version is 5.5 and it has none of this listed.

    Thanks again.
     
  6. shri

    shri Member

    Same issues on Google Cloud SQL Gen 2 - And cannot change that setting. :)
     

Share This Page