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
2111
September 28, 2017 03:46AM
898
September 28, 2017 03:50AM
1062
September 28, 2017 03:17PM
1707
October 02, 2017 01:56AM
982
October 02, 2017 06:39AM
997
October 04, 2017 03:49AM
Re: Wait LCP to ensure durability
1147
November 22, 2017 01:07AM
972
November 22, 2017 01:35AM
950
November 22, 2017 02:23AM
938
November 22, 2017 03:30AM
1001
November 25, 2017 04:16AM
913
November 25, 2017 07:33AM
1074
November 26, 2017 08:06AM
869
November 27, 2017 04:28AM
821
November 27, 2017 08:44AM
847
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.