MySQL Forums
Forum List  »  NDB clusters

Cluster index oddities
Posted by: Joseph Crosby
Date: November 14, 2017 11:05AM

Good day,

A few days ago we had an app issue that yelled:
2017-Nov-10 01:16:08.237019: Got temporary error 785 ‘Schema object is busy with another schema transaction’ from NDBCLUSTER

While investigating I discovered the only thing happening in the cluster at that time was the following:
ndb_50_cluster.log.2:2017-11-10 01:16:06 [MgmtSrvr] INFO -- Node 1: index-build table 16 index: 67 processed 0 rows
ndb_50_cluster.log.2:2017-11-10 01:16:06 [MgmtSrvr] INFO -- Node 2: index-build table 16 index: 67 processed 0 rows
ndb_50_cluster.log.2:2017-11-10 01:16:06 [MgmtSrvr] INFO -- Node 3: index-build table 16 index: 67 processed 0 rows
ndb_50_cluster.log.2:2017-11-10 01:16:06 [MgmtSrvr] INFO -- Node 4: index-build table 16 index: 67 processed 0 rows

These entries run until:

ndb_50_cluster.log.2:2017-11-10 01:16:19 [MgmtSrvr] INFO -- Node 1: index-build table 240 index: 283 processed 0 rows
ndb_50_cluster.log.2:2017-11-10 01:16:19 [MgmtSrvr] INFO -- Node 2: index-build table 240 index: 283 processed 0 rows
ndb_50_cluster.log.2:2017-11-10 01:16:19 [MgmtSrvr] INFO -- Node 3: index-build table 240 index: 283 processed 0 rows
ndb_50_cluster.log.2:2017-11-10 01:16:19 [MgmtSrvr] INFO -- Node 4: index-build table 240 index: 283 processed 0 rows



My questions seem to be:

1) Does index-build relate to the rebuilding of indexes? I can't find anything online.

2) And if it does why would NDB decided to rebuild them on its own? I cannot find any mention of this in a conf file or any user input.


I'm running on the assumption that something caused an index build of the cluster which in turn caused our app to fail out because the Database/Tables it was trying to access were busy. But some verification would be greatly appreciated.

Options: ReplyQuote


Subject
Views
Written By
Posted
Cluster index oddities
1121
November 14, 2017 11:05AM
565
November 15, 2017 07:32AM
547
November 15, 2017 08:32AM
502
November 15, 2017 12:44PM
541
November 15, 2017 08:44AM
515
November 15, 2017 12:50PM
456
December 12, 2017 05:58AM


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.