IBM Support

webMethods Knowlegebase : Database Failover Configuration Conflicts with AgileApps (1785912)

Troubleshooting


Problem

Configured database server in TEST to do automated failover.

It needs to be on for the high-availability failover.

By next day when trying to install a package, received the following error message:

"Statement violates GTID consistency: CREATE TEMPORARY TABLE and DROP TEMPORARY TABLE can only be executed outside transactional context. These statements are also not allowed in a function or trigger because functions and triggers are also considered to be multi-statement transactions. "

The GTID configuration was turned on in order to implement the automated database failover.

Is AgileApps not compatible with automated database failover for MySQL?

Are there some parameters the site needs to change in AgileApps?

If the DBA diables GTID, in case of a failover, to restore the master would require some down-time.

Document Location

Worldwide

[{"Line of Business":{"code":"","label":""},"Business Unit":{"code":"","label":""},"Product":{"code":"SSI42O","label":"IBM webMethods AgileApps SaaS"},"ARM Category":[{"code":"a8mKe00000000AQIAY","label":"webMethods AgileApps Cloud (LJP)"}],"ARM Case Number":"","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"All Version(s)"}]

Log InLog in to view more of this document

This document has the abstract of a technical article that is available to authorized users once you have logged on. Please use Log in button above to access the full document. After log in, if you do not have the right authorization for this document, there will be instructions on what to do next.

Document Information

Modified date:
20 March 2025

UID

ibm17204517

Page Feedback