Announcement

Announcement Module
Collapse
No announcement yet.

Cluster does not execute INSERT and UPDATE, many "wsrep in pre-commit stage"

Page Title Module
Move Remove Collapse
X
Conversation Detail Module
Collapse
  • Filter
  • Time
  • Show
Clear All
new posts

  • Cluster does not execute INSERT and UPDATE, many "wsrep in pre-commit stage"

    Hi,

    we have a cluster with 3 nodes. Everything worked fine until now. All nodes are up, but they do not execute INSERTs, UPDATEs. SELECTS are executed. How do we get the cluster back to work?

    Regards

    Martin

  • #2
    I did some more investigation. The "SHOW ENGINE INNODB STATUS" shows many locked tables. But still no idea what to do... We can access the servers without any problem.

    Comment


    • #3
      I stopped node 3 and restarted it. Now it makes a full SST (why?). This may take a while... A few queries have been executed, but now node 1 and 2 are still stuck.

      Comment


      • #4
        One of our programmers created a new table and inserted some data (5 MB). Does this lock the whole cluster??

        Comment


        • #5
          Ok, the cluster is still blocked. We have to take it down. What causes the cluster to fail like that?

          Comment


          • #6
            What kind of table was that? What is the "show create table tablename\G".
            You need to provide at least the output of
            Code:
            show status like 'ws%';
            and relevant error log parts to help you on that.

            Comment

            Working...
            X