Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
2.5.5
-
None
-
MariaDB 10.3.25
Description
With MaxScale, inside a transaction the select statements get routed to slave causing uncommited rows not to show up.
MariaDB [db]> start transaction;
|
Query OK, 0 rows affected (0.000 sec)
|
|
MariaDB [db]> insert into audit set event = 'BLAAAP', details = 'This is a test', created = 0;
|
Query OK, 1 row affected (0.001 sec)
|
|
MariaDB [db]> select * from audit where event = 'BLAAAP';
|
Empty set (0.001 sec)
|
|
MariaDB [db]> select * from audit where event = 'BLAAAP' for update;
|
+---------+---------+--------+----------------+------------+---------+
|
| id | user_id | event | details | ip_address | created |
|
+---------+---------+--------+----------------+------------+---------+
|
| 2051146 | NULL | BLAAAP | This is a test | NULL | 0 |
|
+---------+---------+--------+----------------+------------+---------+
|
1 row in set (0.001 sec)
|
|