MySQL Forums
Forum List  »  NDB clusters

Re: Wait LCP to ensure durability
Posted by: Thomas Waibel
Date: November 22, 2017 01:07AM

Dear Daniel & Stefan,

we are currently facing the same problem.
mysql-5.7.19 ndb-7.5.7

Log excerpt:
...
2017-11-21 22:35:33 [MgmtSrvr] ALERT -- Node 3: Node 6 declared dead due to missed heartbeat
...
2017-11-21 22:58:44 [MgmtSrvr] INFO -- Node 6: Start phase 0 completed
...
2017-11-21 22:59:03 [MgmtSrvr] INFO -- Node 6: Start phase 2 completed (node restart)
...
2017-11-21 22:59:05 [MgmtSrvr] INFO -- Node 6: Start phase 3 completed (node restart)
...
2017-11-21 22:59:05 [MgmtSrvr] INFO -- Node 6: Start phase 4 completed (node restart)
...
2017-11-22 01:11:35 [MgmtSrvr] INFO -- Node 6: Restore Database Off-line Completed on node 6
...
2017-11-22 02:24:30 [MgmtSrvr] INFO -- Node 6: Bring Database On-line Completed on node 6
...
2017-11-22 02:25:07 [MgmtSrvr] INFO -- Node 5: Make On-line Database recoverable by waiting for LCP Starting on node 6, LCP id 5030
...
2017-11-22 08:00:53 [MgmtSrvr] INFO -- Node 6: Data usage is 80%(14094445 32K pages of total 17530880)
2017-11-22 08:00:53 [MgmtSrvr] INFO -- Node 6: Index usage is 76%(15124216 8K pages of total 19661184)

We are still waiting for the LCP to complete...

How did you resolve your problem?

Best regards



Edited 1 time(s). Last edit at 11/22/2017 01:08AM by Thomas Waibel.

Options: ReplyQuote


Subject
Views
Written By
Posted
471
September 28, 2017 03:46AM
184
September 28, 2017 03:50AM
229
September 28, 2017 03:17PM
236
October 02, 2017 01:56AM
194
October 02, 2017 06:39AM
168
October 04, 2017 03:49AM
Re: Wait LCP to ensure durability
173
November 22, 2017 01:07AM
138
November 22, 2017 01:35AM
124
November 22, 2017 02:23AM
169
November 22, 2017 03:30AM
189
November 25, 2017 07:33AM
141
November 27, 2017 04:28AM
136
November 27, 2017 08:44AM
128
November 27, 2017 04:16PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.