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
758
September 28, 2017 03:46AM
326
September 28, 2017 03:50AM
417
September 28, 2017 03:17PM
488
October 02, 2017 01:56AM
339
October 02, 2017 06:39AM
309
October 04, 2017 03:49AM
Re: Wait LCP to ensure durability
313
November 22, 2017 01:07AM
278
November 22, 2017 01:35AM
249
November 22, 2017 02:23AM
312
November 22, 2017 03:30AM
330
November 25, 2017 07:33AM
272
November 27, 2017 04:28AM
242
November 27, 2017 08:44AM
261
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.