List:Cluster« Previous MessageNext Message »
From:Hendrik Woltersdorf Date:June 26 2012 11:36am
Subject:Re: Re: error 4720 by replicating ndbcluster into InnoDB
View as plain text  
magnus blaudd <magnus.blaudd@stripped> schrieb am 26.06.2012 13:27:23:

> magnus blaudd <magnus.blaudd@oracle.com>
> 26.06.2012 13:27
>
> An
>
> cluster@strippedql.com
>
> Kopie
>
> Thema
>
> Re: error 4720 by replicating ndbcluster into InnoDB
>
> On 2012-06-26 12:27, Hendrik Woltersdorf wrote:
> > Hi,
> >
> > today I did set up a replication from a MySQL cluster (7.1.18) into
another
> > non-Cluster MySQL server (using the same cluster binaries).
> >
> > Now I am getting every second this message in the slave server log:
> >
> > "[Warning] create index stats tables failed: error 4720 line 403"
> >
> > How do I get rid of this?
>
> Hi Henrik,
>
> sounds like the mysqld on the non-Cluster MySQL Server is trying to
> create tables for maintaining statistics about the tables where
> engine=NDB but creation of those tables fails because you have no NDB on
> the slave.
>
> Have you disabled ndbcluster on slave mysqld?
>
> If that does not help, try starting the slave mysqld with
> --ndb-index-stat-enable=false and see if that helps.
>
> No other complaints about no NDB on the slave mysqld?
>
>
>
> --
> - Magnus
>
>
>
> --
> MySQL Cluster Mailing List
> For list archives: http://lists.mysql.com/cluster
> To unsubscribe:    http://lists.mysql.com/cluster
>
As written in my second mail: I got this error from a ndbcluster SQL node,
but only from one of two.
I restartet first this SQL node with --ndb-index-stat-enable=false.
Then I did not get this error any more, but "ERROR 1296 (HY000): Got error
157 'Unknown error code' from NDBCLUSTER" when I tried to select data from
a test table (with engine=ndbcluster).

Now I restartet the whole cluster. That helped.

regards

Hendrik Woltersdorf
XCOM AG
Tel.: 0375/27008-580
Tel. mobil: 015222999584
Email: Hendrik.Woltersdorf@stripped



*** XCOM AG Legal Disclaimer ***

Diese E-Mail einschliesslich ihrer Anhaenge ist vertraulich und ist allein
für den Gebrauch durch den vorgesehenen Empfaenger bestimmt. Dritten ist
das Lesen, Verteilen oder Weiterleiten dieser E-Mail untersagt. Wir bitten,
eine fehlgeleitete E-Mail unverzueglich vollstaendig zu loeschen und uns
eine Nachricht zukommen zu lassen.

This email may contain material that is confidential and for the sole use
of the intended recipient. Any review, distribution by others or forwarding
without express permission is strictly prohibited. If you are not the
intended recipient, please contact the sender and delete all copies.

Hauptsitz: Bahnstrasse 37, D-47877 Willich, USt-IdNr.: DE 812 885 664
Kommunikation: Telefon +49 2154 9209-70, Telefax +49 2154 9209-900,
www.xcom.de
Handelsregister: Amtsgericht Krefeld, HRB 10340
Vorstand: Matthias Albrecht, Dirk Franzmeyer, Marco Marty, Dirk Werner
Vorsitzender des Aufsichtsrates: Stefan H. Tarach
Thread
error 4720 by replicating ndbcluster into InnoDBHendrik Woltersdorf26 Jun
  • Re: error 4720 by replicating ndbcluster into InnoDBmagnus blaudd26 Jun
    • Re: Re: error 4720 by replicating ndbcluster into InnoDBHendrik Woltersdorf26 Jun