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
615
September 28, 2017 03:46AM
255
September 28, 2017 03:50AM
324
September 28, 2017 03:17PM
367
October 02, 2017 01:56AM
262
October 02, 2017 06:39AM
233
October 04, 2017 03:49AM
Re: Wait LCP to ensure durability
229
November 22, 2017 01:07AM
200
November 22, 2017 01:35AM
183
November 22, 2017 02:23AM
238
November 22, 2017 03:30AM
260
November 25, 2017 07:33AM
207
November 27, 2017 04:28AM
183
November 27, 2017 08:44AM
190
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.