Re: Wait LCP to ensure durability

[Thomas Waibel]

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.