I got the following error when i try to update any node.

I use google cloud sql with mysql 5.7. unfortunately we can't disable GTID_MODE with google cloud

here is the error message

PDOException: 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.: UPDATE {menu_links} SET menu_name=:db_update_placeholder_0, plid=:db_update_placeholder_1, link_path=:db_update_placeholder_2, router_path=:db_update_placeholder_3, hidden=:db_update_placeholder_4, external=:db_update_placeholder_5, has_children=:db_update_placeholder_6, expanded=:db_update_placeholder_7, weight=:db_update_placeholder_8, depth=:db_update_placeholder_9, p1=:db_update_placeholder_10, p2=:db_update_placeholder_11, p3=:db_update_placeholder_12, p4=:db_update_placeholder_13, p5=:db_update_placeholder_14, p6=:db_update_placeholder_15, p7=:db_update_placeholder_16, p8=:db_update_placeholder_17, p9=:db_update_placeholder_18, module=:db_update_placeholder_19, link_title=:db_update_placeholder_20, options=:db_update_placeholder_21, customized=:db_update_placeholder_22 WHERE (mlid = :db_condition_placeholder_0) ; Array ( [:db_update_placeholder_0] => book-toc-213 [:db_update_placeholder_1] => 599 [:db_update_placeholder_2] => node/12651 [:db_update_placeholder_3] => node/% [:db_update_placeholder_4] => 0 [:db_update_placeholder_5] => 0 [:db_update_placeholder_6] => 0 [:db_update_placeholder_7] => 0 [:db_update_placeholder_8] => 0 [:db_update_placeholder_9] => 3 [:db_update_placeholder_10] => 560 [:db_update_placeholder_11] => 599 [:db_update_placeholder_12] => 13016 [:db_update_placeholder_13] => 0 [:db_update_placeholder_14] => 0 [:db_update_placeholder_15] => 0 [:db_update_placeholder_16] => 0 [:db_update_placeholder_17] => 0 [:db_update_placeholder_18] => 0 [:db_update_placeholder_19] => book [:db_update_placeholder_20] => 31. Basic Information on Afghanistan [:db_update_placeholder_21] => a:1:{s:5:"alter";b:1;} [:db_update_placeholder_22] => 0 [:db_condition_placeholder_0] => 13016 ) in menu_link_save() (line 3268 of /var/www/html/includes/menu.inc).

Comments

meladawy created an issue. See original summary.

stefan.r’s picture

Category: Bug report » Support request
cilefen’s picture

@stefan.r Do you have the feeling this is a requirement to document?

joseph.olstad’s picture

looks like GTID_MODE has a scope of "Global"

So disabling it on your cloud would require a support request with your cloud provider.

meladawy’s picture

@joseph.olstad i tried this but its not possible in google cloud. i had to downgrad mysql from the second generation to the first generation mysql which doesn't support GTID

Version: 7.5 » 7.x-dev

Core issues are now filed against the dev versions where changes will be made. Document the specific release you are using in your issue comment. More information about choosing a version.