Bug #107004 ndbd service cannot startup

• Submitted: 13 Apr 2022 10:03
• Modified: 22 Apr 2022 10:20
• Reporter: Claudio Eros Beccalossi
• Status: Can't repeat
• Category: MySQL Cluster: Cluster (NDB) storage engine
• Severity: S2 (Serious)
• Version: mysql-5.7.30 ndb-7.6.14
• OS: Red Hat (Red Hat Enterprise Linux Server release 7.8 )
• Assigned to: MySQL Verification Team
• CPU Architecture: x86

[13 Apr 2022 10:03] Claudio Eros Beccalossi

Description:
After a power off all server,  ndb does not complete correctly start-up signalling
continuously

2022-04-08 10:48:40 [ndbd] INFO     -- LDM instance 1: Restored T760F5 LCP 1 rows, 1 row operations, 29 millis, 34 row operations/sec)
/export/home2/pb2/build/sb_1-38579739-1585554448.43/rpm/BUILD/mysql-cluster-com-7.6.14/mysql-cluster-com-7.6.14/storage/ndb/src/kernel/blocks/dbtup/DbtupRouti
nes.cpp:718: require((srcBytes <= max_var_size)) failed
2022-04-08 10:48:41 [ndbd] INFO     -- Received signal 6. Running error handler.
2022-04-08 10:48:41 [ndbd] INFO     -- Signal 6 received; Aborted
2022-04-08 10:48:41 [ndbd] INFO     -- /export/home2/pb2/build/sb_1-38579739-1585554448.43/rpm/BUILD/mysql-cluster-com-7.6.14/mysql-cluster-com-7.6.14/storage/ndb/src/kernel/ndbd.cpp
2022-04-08 10:48:41 [ndbd] INFO     -- Error handler signal restarting system
2022-04-08 10:48:41 [ndbd] INFO     -- Angel detected startup failure, count: 1
2022-04-08 10:48:41 [ndbd] ALERT    -- Node 4: Forced node shutdown completed, restarting. Occured during startphase 4. Initiated by signal 6. Caused by error 6000: 'Error OS signal received(Internal error, programming error or missing error message, please report a bug). Temporary error, restart node'.

ndb service start up only after restoredb whith ndb-restore 

How to repeat:
power off and then power on all server

[13 Apr 2022 13:34] MySQL Verification Team

Hi,

I cannot reproduce this. I can shutdown and start multiple times without a problem. I can pull powercable out to have it unsafely shutdown and it is still working ok.

You might want to contact our MySQL Support to check your procedures/config but as for this issue I cannot reproduce it.

[20 Apr 2022 15:42] Claudio Eros Beccalossi

I would like to contact if possible your MySQL Support to check our procedures/config because our customer was not satisfied with the response obtained claiming that with the previous version of mysql (mysql-5.6.21 ndb-7.3.7) and operating system (Red Hat Enterprise Linux Server release 6.9 (Santiago))the problem did not arise

[20 Apr 2022 15:52] MySQL Verification Team

Hi,

Our MySQL Support team will be happy to review all your procedures, config, and setup in whole and help you properly configure and run your system.

https://www.mysql.com/products/

kind regards

[22 Apr 2022 10:20] Claudio Eros Beccalossi

Hi,
in order to redo the test which logs do you recommend to collect and if possible which logs to enable for help in a troubleshooting 

Thank's in advance