[MDEV-11701] The node doesn't commit query Created: 2017-01-02  Updated: 2019-12-12  Resolved: 2019-12-12

Status: Closed
Project: MariaDB Server
Component/s: Galera
Affects Version/s: 10.0.28-galera
Fix Version/s: N/A

Type: Bug Priority: Major
Reporter: Hamoon Mohammadian Pour Assignee: Jan Lindström (Inactive)
Resolution: Won't Fix Votes: 0
Labels: galera

Attachments: PNG File 1.png     PNG File 2.png     PNG File problem2.png    

 Description   

Hi all.
We use MariaDB-Galera-cluster 10.0.28 with 2 Nodes and one arbitrator.
Last day I saw one of node stuck on all (insert update delete) queries.
After this incident, our node arrived to maximum connection and stuck it.
Another node is working fine and execute all queries and replicating to this node, and doesn't have any warning or error log but this node stuck.
I checked error log and monitoring but I can't find why it happened.
PS: I restarted this node with kill -9 (because I could restart gracefully. Stuck in WSREP: Closing send monitor state) But after a few hours It happened again.
I'm sorry but my English is weak.

 Comments   
Comment by Hamoon Mohammadian Pour [ 2017-01-08 ]

Unfortunately the problem still exist.

Comment by Hamoon Mohammadian Pour [ 2017-01-09 ]

Our second node froze, some days after that our first node had frozen.
Now both servers has maximum connections and All connection stick on state such as query end, commit, sleep and not killed.

Comment by Hamoon Mohammadian Pour [ 2017-01-11 ]

I think it's a problem with "Query Cache".

Comment by Jan Lindström (Inactive) [ 2017-05-19 ]

Firstly, does this repeat with 10.0.30-galera, if it does we would need more information. Can you provide your configuration, show engine innodb status output from all nodes that you think are frozen, error logs from all nodes (do not edit them). If one of your nodes is frozen can you attach a debugger to that node and issue thread apply all bt and provide us that output.

Comment by Hamoon Mohammadian Pour [ 2017-08-12 ]

Mr.Lindström.
Since, I disabled Query Cache It has never happen again.

Comment by Jan Lindström (Inactive) [ 2019-12-12 ]

Support for 10.0-galera has ended.

Generated at Thu Feb 08 07:52:00 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.