Get Instant Solutions for Kubernetes, Databases, Docker and more
When encountering the error 1172: "Statement not allowed in transaction" in MySQL, the user should:
SET global general_log = 1;
SET global log_output = 'table';
After identifying the problematic query, disable the log:SET global general_log = 0;
SHOW TRIGGERS LIKE 'your
table
name';
5. Review the MySQL version-specific documentation to ensure that the statements you are executing within the transaction are supported in your version of MySQL.
(Perfect for DevOps & SREs)
(Perfect for DevOps & SREs)
Get Instant Solutions for Kubernetes, Databases, Docker and more
Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.
Block quote
Ordered list
Unordered list
Bold text
Emphasis
Superscript
Subscript
(Perfect for DevOps & SREs)
(Perfect for DevOps & SREs)