MySQL Forums
Forum List  »  NDB clusters

Re: Error with "Read Backup"
Posted by: Mikael Ronström
Date: August 31, 2017 03:15AM

I took a look at the bug report and downloaded the ndb error report.
I also looked in the code to see where the error could come from.

The only reason for the bug that I can see so far is that
for some reason the MySQL Server decides to do both an Add partition
and alter the READ BACKUP flag at the same time. This will generate
the error you get.

Obviously from SQL you haven't asked for an add partition, so this would
be a bug in the storage engine if it did.

The reason I am suspecting this is also that I noted that in the configuration
you have set NoOfFragmentLogParts=8. This is normally only done when you want
to have 8 LDM threads. In your config you have only 4 LDM threads (derived from
MaxNoOfExecutionThreads=8.

If you have changed the config recently in this aspect I would expect that you
hit this bug for older tables and not for newer tables.

You can try and see what happens if you execute the following command on the
faulty tables.

ALTER TABLE <tablename>, algorithm=inplace REORGANIZE PARTITIONS;
and after that the failing command again.

Options: ReplyQuote


Subject
Views
Written By
Posted
1012
August 29, 2017 03:25PM
537
August 29, 2017 03:50PM
465
August 30, 2017 08:52AM
Re: Error with "Read Backup"
551
August 31, 2017 03:15AM
496
August 31, 2017 04:30AM
579
August 31, 2017 10:52AM
541
August 31, 2017 12:41PM
606
August 31, 2017 01:57PM
618
August 31, 2017 02:00PM
577
August 31, 2017 04:37PM
563
August 31, 2017 04:59PM


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.