MySQL Forums
Forum List  »  NDB clusters

Re: Error 1064 Duplicate entry 'ndbcluster-96' for key 'tables.engine'
Posted by: Tony Soprano
Date: January 19, 2024 08:21AM

Hi mr.Patricio thank you for your precious answer.
i use the SELECT but no rows with id 96, and no duplicate entry in here.

there are many duplicate tables_name i dunno if this is normal

i tried then to create a new table but i receive again same error and here the logs:
2024-01-19T14:11:38.283939Z 21749 [Note] [MY-010865] [Server] NDB: Creating table ''
2024-01-19T14:11:38.459855Z 21749 [Note] [MY-010865] [Server] NDB: Created event 'REPL$db_test/aaa' for table '' in NDB
2024-01-19T14:11:38.477286Z 2 [Note] [MY-010866] [Server] NDB Binlog: Reloaded metadata cache
2024-01-19T14:11:38.718867Z 2 [Note] [MY-010866] [Server] NDB Binlog: Reloaded metadata cache

Another curiosity into logs, since the upgrade of only musqld node12 to mysqlv8.0.34 while all other nodes stick on 8.0.33 appear this every minute:
2024-01-19T14:11:57.416669Z 0 [Note] [MY-010865] [Server] NDB: Validating excluded objects
2024-01-19T14:11:57.534907Z 0 [Note] [MY-010866] [Server] NDB Metadata: Failed to submit table 'mysql.ndb_apply_status' for synchronization

I found already online this is a known bug should not log this every minute but before upgrade doesnt show to me.
Could this be related?

I'll try in this days to create a staging env and replicate the ndbcluster and lets see if error still there.

Edited 1 time(s). Last edit at 01/19/2024 08:26AM by Tony Soprano.

Options: ReplyQuote

Sorry, only registered users may post in this forum.

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.