Details
-
Task
-
Status: Closed (View Workflow)
-
Blocker
-
Resolution: Cannot Reproduce
-
None
Description
Hi,
For this exercise I used virtualbox, 3 nodes and maxscale on 1 node. I do not think maxscale has to do with it but it is an easy way to make it run on multiple nodes. I used the training VM's from https://downloads.mariadb.com/training/courses/mariadb-enterprise-cluster/OS-Images/.
Steps to reproduce:
- Install a cluster. I used a 3-node cluster
- Install maxscale using the configuration attached. I used a readconnroute router that only routes to the slave. This means that the traffic will be round-robinned between the nodes that do not have wsrep_local_index set to 1.
- Install sysbench
- Run sysbench to mascale
In most cases the cluster locked up after 10 seconds, in another case it took a couple of minutes. The sysbench command used:
sysbench --db-driver=mysql --test=/usr/share/sysbench/tests/include/oltp_legacy/oltp.lua --mysql-user=galera --mysql-password=galera --mysql-db=test --oltp-table-size=25000 --report-interval=5 --max-requests=0 --time=300 --num-threads=5 run --mysql-host=galera4 --mysql-port=4006
In the processlist of galera2 you will find a wsrep thread that is locked by something:
2 | system user | | NULL | Sleep | 3317 | Update_rows_log_event::find_row(129056) | UPDATE sbtest1 SET c='21925224570-87741851440-47847350341-42585377753-88509468277-36281519091-414733 | 0.000 |
On the other nodes you see threads waiting on COMMIT.
I am still waiting for the error logs, is there any other information you need?
Thanks,
Michaël