GET 24/7 LIVE HELP NOW

Announcement

Announcement Module
Collapse
No announcement yet.

Node crashed without reason

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

  • Node crashed without reason

    Hi,

    I have often this warning :
    130604 10:06:14 [Warning] WSREP: SQL statement was ineffective: COMMIT
    => Skipping replication

    And suddenly
    130604 10:13:38 mysqld_safe Number of processes running now: 0
    130604 10:13:38 mysqld_safe WSREP: not restarting wsrep node automatically
    130604 10:13:38 mysqld_safe mysqld from pid file /datas/mysql/p2-mysql01.pid ended

    Can you explain me what is the problem ?

    Thanks for your help

    Best regards

    Azigui

  • #2
    Hi everybody,
    I resolved my pb.
    I comment the both directives auto_increment_increment=3 and auto_increment_offset=2 and I let wsrep_auto_increment_control
    I modify the binlog_format's value in ROW instead of STATEMENT.
    Since I didn't have errors.

    Best regards,
    Azigui

    Comment

    Working...
    X