Details
-
Bug
-
Status: Closed (View Workflow)
-
Critical
-
Resolution: Fixed
-
2.5, 21.06, 22.08
-
None
Description
I have maxscale (version 22.08.2) and 4 mariadb nodes (master and slaves).
The problem has appeared in one of mariadb replicas:
An attempt was made to binlog GTID 1-2-75990 which would create an out-of-order sequence number with existing GTID 1-1-75990, and gtid strict mode is enabled
|
I found a problem query:
UPDATE objects o,
|
(
|
SELECT newIndex, o_id FROM (SELECT @n := IF(@n = '2' - 1,@n + 2,@n + 1) AS newIndex, o_id
|
FROM objects,
|
(SELECT @n := -1) variable
|
WHERE o_id != '2142' AND o_parentId = '343' AND o_type IN ('object','variant','folder')
|
ORDER BY o_index, o_id='2142'
|
) tmp
|
) order_table
|
SET o.o_index = order_table.newIndex
|
WHERE o.o_id=order_table.o_id
|
So, as I understood, the problem is in using user-defined variable.
I found a bug https://jira.mariadb.org/browse/MXS-4269, but there are no comments and it is closed. How can I fix my problem?
What interesting, I had this error only on one of three replicas.
On one of them version 10.5.13, and on the other version 10.5.17. Could this be the reason?