The main question - is it possible to use HandlerSocket together with PXC? I've noticed that during high load writing socket crashes rather frequently with the error HNDSOCK unlock tables: commit failed.
Asked
Active
Viewed 313 times
1
-
Is there an error message associated with the crashes? More information in general would be helpful. – G-Nugget Dec 05 '13 at 23:00
-
The only string with error was near the end of logs: HNDSOCK unlock tables: commit failed – Lisio Dec 05 '13 at 23:02
-
For testing purpose I use 3 VMs, 2 of them with PXC and the 3rd with Galera Arbitrator. The script opens two connections for writing to both servers, writes about 100k rows to the first server, than 100k rows to another one and dies. After several executions HS's socket for writing disappears on one of the servers in nearly random manner and never reopened. – Lisio Dec 05 '13 at 23:14
1 Answers
0
I checked with our PXC developer, who said he hasn't tested HandlerSocket with PXC, but pointed out that there is an existing bug report where it crashes with handlersocket, "so safe to say it is not supported with PXC." Yet, that is. But you can check on the PXC forums to get the latest info - that is here he fields questions and the best place to message him. http://www.percona.com/forums/questions-discussions/percona-xtradb-cluster
Tom Diederich
- 1
- 3