Can't allocate nodeid for APIMySQL NDB Cluster on FreeBSD 7.1Need help to configure MySql-Cluster with two hostsMysql cluster strange behaviourUnable to connect to MySQL cluster databaseMySQL Cluster Failover doesn't workMySQL Cluster SQL Node not synchronizingmysql cluster node lost connection shutdownWhen trying to delete a table from NDB Cluster, I get the error “4243: Index not found”Benchmark MySQL Cluster using flexAsynch: No free node id found for mysqld(API)?The ndb_mgmd daemon does not start

Why are the 2nd/3rd singular forms of present of « potere » irregular?

What does "rf" mean in "rfkill"?

Where did the extra Pym particles come from in Endgame?

Illegal assignment from SObject to Contact

Packing rectangles: Does rotation ever help?

A question regarding using the definite article

Pulling the rope with one hand is as heavy as with two hands?

A non-technological, repeating, visible object in the sky, holding its position in the sky for hours

Pawn Sacrifice Justification

Is it possible to Ready a spell to be cast just before the start of your next turn by having the trigger be an ally's attack?

What's the metal clinking sound at the end of credits in Avengers: Endgame?

Can solid acids and bases have pH values? If not, how are they classified as acids or bases?

How to stop co-workers from teasing me because I know Russian?

Why is the origin of “threshold” uncertain?

How to replace the "space symbol" (squat-u) in listings?

Can fracking help reduce CO2?

When did stoichiometry begin to be taught in U.S. high schools?

When and why did journal article titles become descriptive, rather than creatively allusive?

When India mathematicians did know Euclid's Elements?

Was it really necessary for the Lunar Module to have 2 stages?

Toggle Overlays shortcut?

Why is current rating for multicore cable lower than single core with the same cross section?

Past Perfect Tense

How to set the font color of quantity objects (Version 11.3 vs version 12)?



Can't allocate nodeid for API


MySQL NDB Cluster on FreeBSD 7.1Need help to configure MySql-Cluster with two hostsMysql cluster strange behaviourUnable to connect to MySQL cluster databaseMySQL Cluster Failover doesn't workMySQL Cluster SQL Node not synchronizingmysql cluster node lost connection shutdownWhen trying to delete a table from NDB Cluster, I get the error “4243: Index not found”Benchmark MySQL Cluster using flexAsynch: No free node id found for mysqld(API)?The ndb_mgmd daemon does not start






.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty height:90px;width:728px;box-sizing:border-box;








1















I'm running a pretty minimal MySQL cluster with configuration pretty much taken straight from the documentation. The data nodes are connecting fine, but the management server refuses to accept the API nodes. Here's what happens:



INFO -- Node 2: Initial start, waiting for 3 to connect, nodes [ all: 2 and 3 connected: 2 no-wait: ]
INFO -- Node 3: Initial start, waiting for 2 to connect, nodes [ all: 2 and 3 connected: 3 no-wait: ]
WARNING -- Failed to allocate nodeid for API at 10.0.42.2. Returned error: 'No free node id found for mysqld(API).'
WARNING -- Failed to allocate nodeid for API at 127.0.0.1. Returned error: 'No free node id found for mysqld(API).'


show from ndb_mgm outputs this:



Connected to Management Server at: localhost:1186
Cluster Configuration
---------------------
[ndbd(NDB)] 2 node(s)
id=2 @127.0.0.1 (mysql-5.6.14 ndb-7.3.3, starting, Nodegroup: 0)
id=3 @10.0.42.2 (mysql-5.6.14 ndb-7.3.3, starting, Nodegroup: 0)

[ndb_mgmd(MGM)] 1 node(s)
id=1 @127.0.1.1 (mysql-5.6.14 ndb-7.3.3)

[mysqld(API)] 2 node(s)
id=4 (not connected, accepting connect from any host)
id=5 (not connected, accepting connect from any host)


Here's my.cnf--nothing particularly interesting:



[mysqld]

sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES

language=english

ndbcluster

[mysql_cluster]
ndb-connectstring=localhost


The only API-related configuration in config.ini is this:



[mysqld]
[mysqld]


There's no [mysqld default] section. I've tried setting hostnames.



I've tried both ndbd --reload and ndbd --initial, with appropriate restarts.



Update



It looks as though neither data node is listening on port 2202 based on the output of netstat -nl. Since neither is listening, they can't connect to each other, and the cluster is never ready for API nodes to join. What could be preventing this?










share|improve this question






























    1















    I'm running a pretty minimal MySQL cluster with configuration pretty much taken straight from the documentation. The data nodes are connecting fine, but the management server refuses to accept the API nodes. Here's what happens:



    INFO -- Node 2: Initial start, waiting for 3 to connect, nodes [ all: 2 and 3 connected: 2 no-wait: ]
    INFO -- Node 3: Initial start, waiting for 2 to connect, nodes [ all: 2 and 3 connected: 3 no-wait: ]
    WARNING -- Failed to allocate nodeid for API at 10.0.42.2. Returned error: 'No free node id found for mysqld(API).'
    WARNING -- Failed to allocate nodeid for API at 127.0.0.1. Returned error: 'No free node id found for mysqld(API).'


    show from ndb_mgm outputs this:



    Connected to Management Server at: localhost:1186
    Cluster Configuration
    ---------------------
    [ndbd(NDB)] 2 node(s)
    id=2 @127.0.0.1 (mysql-5.6.14 ndb-7.3.3, starting, Nodegroup: 0)
    id=3 @10.0.42.2 (mysql-5.6.14 ndb-7.3.3, starting, Nodegroup: 0)

    [ndb_mgmd(MGM)] 1 node(s)
    id=1 @127.0.1.1 (mysql-5.6.14 ndb-7.3.3)

    [mysqld(API)] 2 node(s)
    id=4 (not connected, accepting connect from any host)
    id=5 (not connected, accepting connect from any host)


    Here's my.cnf--nothing particularly interesting:



    [mysqld]

    sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES

    language=english

    ndbcluster

    [mysql_cluster]
    ndb-connectstring=localhost


    The only API-related configuration in config.ini is this:



    [mysqld]
    [mysqld]


    There's no [mysqld default] section. I've tried setting hostnames.



    I've tried both ndbd --reload and ndbd --initial, with appropriate restarts.



    Update



    It looks as though neither data node is listening on port 2202 based on the output of netstat -nl. Since neither is listening, they can't connect to each other, and the cluster is never ready for API nodes to join. What could be preventing this?










    share|improve this question


























      1












      1








      1








      I'm running a pretty minimal MySQL cluster with configuration pretty much taken straight from the documentation. The data nodes are connecting fine, but the management server refuses to accept the API nodes. Here's what happens:



      INFO -- Node 2: Initial start, waiting for 3 to connect, nodes [ all: 2 and 3 connected: 2 no-wait: ]
      INFO -- Node 3: Initial start, waiting for 2 to connect, nodes [ all: 2 and 3 connected: 3 no-wait: ]
      WARNING -- Failed to allocate nodeid for API at 10.0.42.2. Returned error: 'No free node id found for mysqld(API).'
      WARNING -- Failed to allocate nodeid for API at 127.0.0.1. Returned error: 'No free node id found for mysqld(API).'


      show from ndb_mgm outputs this:



      Connected to Management Server at: localhost:1186
      Cluster Configuration
      ---------------------
      [ndbd(NDB)] 2 node(s)
      id=2 @127.0.0.1 (mysql-5.6.14 ndb-7.3.3, starting, Nodegroup: 0)
      id=3 @10.0.42.2 (mysql-5.6.14 ndb-7.3.3, starting, Nodegroup: 0)

      [ndb_mgmd(MGM)] 1 node(s)
      id=1 @127.0.1.1 (mysql-5.6.14 ndb-7.3.3)

      [mysqld(API)] 2 node(s)
      id=4 (not connected, accepting connect from any host)
      id=5 (not connected, accepting connect from any host)


      Here's my.cnf--nothing particularly interesting:



      [mysqld]

      sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES

      language=english

      ndbcluster

      [mysql_cluster]
      ndb-connectstring=localhost


      The only API-related configuration in config.ini is this:



      [mysqld]
      [mysqld]


      There's no [mysqld default] section. I've tried setting hostnames.



      I've tried both ndbd --reload and ndbd --initial, with appropriate restarts.



      Update



      It looks as though neither data node is listening on port 2202 based on the output of netstat -nl. Since neither is listening, they can't connect to each other, and the cluster is never ready for API nodes to join. What could be preventing this?










      share|improve this question
















      I'm running a pretty minimal MySQL cluster with configuration pretty much taken straight from the documentation. The data nodes are connecting fine, but the management server refuses to accept the API nodes. Here's what happens:



      INFO -- Node 2: Initial start, waiting for 3 to connect, nodes [ all: 2 and 3 connected: 2 no-wait: ]
      INFO -- Node 3: Initial start, waiting for 2 to connect, nodes [ all: 2 and 3 connected: 3 no-wait: ]
      WARNING -- Failed to allocate nodeid for API at 10.0.42.2. Returned error: 'No free node id found for mysqld(API).'
      WARNING -- Failed to allocate nodeid for API at 127.0.0.1. Returned error: 'No free node id found for mysqld(API).'


      show from ndb_mgm outputs this:



      Connected to Management Server at: localhost:1186
      Cluster Configuration
      ---------------------
      [ndbd(NDB)] 2 node(s)
      id=2 @127.0.0.1 (mysql-5.6.14 ndb-7.3.3, starting, Nodegroup: 0)
      id=3 @10.0.42.2 (mysql-5.6.14 ndb-7.3.3, starting, Nodegroup: 0)

      [ndb_mgmd(MGM)] 1 node(s)
      id=1 @127.0.1.1 (mysql-5.6.14 ndb-7.3.3)

      [mysqld(API)] 2 node(s)
      id=4 (not connected, accepting connect from any host)
      id=5 (not connected, accepting connect from any host)


      Here's my.cnf--nothing particularly interesting:



      [mysqld]

      sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES

      language=english

      ndbcluster

      [mysql_cluster]
      ndb-connectstring=localhost


      The only API-related configuration in config.ini is this:



      [mysqld]
      [mysqld]


      There's no [mysqld default] section. I've tried setting hostnames.



      I've tried both ndbd --reload and ndbd --initial, with appropriate restarts.



      Update



      It looks as though neither data node is listening on port 2202 based on the output of netstat -nl. Since neither is listening, they can't connect to each other, and the cluster is never ready for API nodes to join. What could be preventing this?







      mysql mysql-cluster






      share|improve this question















      share|improve this question













      share|improve this question




      share|improve this question








      edited Jan 4 '14 at 20:38







      Zenexer

















      asked Jan 4 '14 at 20:26









      ZenexerZenexer

      321616




      321616




















          2 Answers
          2






          active

          oldest

          votes


















          0














          Looks like the problem was that I was mixing localhost, LAN, and internet IP addresses. All of the servers need to be able to reach each other with the IP addresses that management server resolves. You can use [tcp] to override this, but it's far too messy.






          share|improve this answer






























            -1














            You have a typo in your file. Address 127.0.1.1 is wrong for the loopback address or localhost.
            It should be 127.0.0.1.






            share|improve this answer




















            • 1





              127.0.0.0/8 are all loopback addresses. That is, 127.*.*.* will work as a loopback address, not just 127.0.0.1.

              – Zenexer
              Jan 29 '15 at 2:45











            • I never knew that! Cool tip

              – Alan
              Apr 3 at 14:47











            Your Answer








            StackExchange.ready(function()
            var channelOptions =
            tags: "".split(" "),
            id: "2"
            ;
            initTagRenderer("".split(" "), "".split(" "), channelOptions);

            StackExchange.using("externalEditor", function()
            // Have to fire editor after snippets, if snippets enabled
            if (StackExchange.settings.snippets.snippetsEnabled)
            StackExchange.using("snippets", function()
            createEditor();
            );

            else
            createEditor();

            );

            function createEditor()
            StackExchange.prepareEditor(
            heartbeatType: 'answer',
            autoActivateHeartbeat: false,
            convertImagesToLinks: true,
            noModals: true,
            showLowRepImageUploadWarning: true,
            reputationToPostImages: 10,
            bindNavPrevention: true,
            postfix: "",
            imageUploader:
            brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
            contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
            allowUrls: true
            ,
            onDemand: true,
            discardSelector: ".discard-answer"
            ,immediatelyShowMarkdownHelp:true
            );



            );













            draft saved

            draft discarded


















            StackExchange.ready(
            function ()
            StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fserverfault.com%2fquestions%2f565073%2fcant-allocate-nodeid-for-api%23new-answer', 'question_page');

            );

            Post as a guest















            Required, but never shown

























            2 Answers
            2






            active

            oldest

            votes








            2 Answers
            2






            active

            oldest

            votes









            active

            oldest

            votes






            active

            oldest

            votes









            0














            Looks like the problem was that I was mixing localhost, LAN, and internet IP addresses. All of the servers need to be able to reach each other with the IP addresses that management server resolves. You can use [tcp] to override this, but it's far too messy.






            share|improve this answer



























              0














              Looks like the problem was that I was mixing localhost, LAN, and internet IP addresses. All of the servers need to be able to reach each other with the IP addresses that management server resolves. You can use [tcp] to override this, but it's far too messy.






              share|improve this answer

























                0












                0








                0







                Looks like the problem was that I was mixing localhost, LAN, and internet IP addresses. All of the servers need to be able to reach each other with the IP addresses that management server resolves. You can use [tcp] to override this, but it's far too messy.






                share|improve this answer













                Looks like the problem was that I was mixing localhost, LAN, and internet IP addresses. All of the servers need to be able to reach each other with the IP addresses that management server resolves. You can use [tcp] to override this, but it's far too messy.







                share|improve this answer












                share|improve this answer



                share|improve this answer










                answered Jan 4 '14 at 21:43









                ZenexerZenexer

                321616




                321616























                    -1














                    You have a typo in your file. Address 127.0.1.1 is wrong for the loopback address or localhost.
                    It should be 127.0.0.1.






                    share|improve this answer




















                    • 1





                      127.0.0.0/8 are all loopback addresses. That is, 127.*.*.* will work as a loopback address, not just 127.0.0.1.

                      – Zenexer
                      Jan 29 '15 at 2:45











                    • I never knew that! Cool tip

                      – Alan
                      Apr 3 at 14:47















                    -1














                    You have a typo in your file. Address 127.0.1.1 is wrong for the loopback address or localhost.
                    It should be 127.0.0.1.






                    share|improve this answer




















                    • 1





                      127.0.0.0/8 are all loopback addresses. That is, 127.*.*.* will work as a loopback address, not just 127.0.0.1.

                      – Zenexer
                      Jan 29 '15 at 2:45











                    • I never knew that! Cool tip

                      – Alan
                      Apr 3 at 14:47













                    -1












                    -1








                    -1







                    You have a typo in your file. Address 127.0.1.1 is wrong for the loopback address or localhost.
                    It should be 127.0.0.1.






                    share|improve this answer















                    You have a typo in your file. Address 127.0.1.1 is wrong for the loopback address or localhost.
                    It should be 127.0.0.1.







                    share|improve this answer














                    share|improve this answer



                    share|improve this answer








                    edited Jan 6 '15 at 18:53









                    Andrew Schulman

                    6,437102241




                    6,437102241










                    answered Jan 6 '15 at 18:39









                    user262664user262664

                    1




                    1







                    • 1





                      127.0.0.0/8 are all loopback addresses. That is, 127.*.*.* will work as a loopback address, not just 127.0.0.1.

                      – Zenexer
                      Jan 29 '15 at 2:45











                    • I never knew that! Cool tip

                      – Alan
                      Apr 3 at 14:47












                    • 1





                      127.0.0.0/8 are all loopback addresses. That is, 127.*.*.* will work as a loopback address, not just 127.0.0.1.

                      – Zenexer
                      Jan 29 '15 at 2:45











                    • I never knew that! Cool tip

                      – Alan
                      Apr 3 at 14:47







                    1




                    1





                    127.0.0.0/8 are all loopback addresses. That is, 127.*.*.* will work as a loopback address, not just 127.0.0.1.

                    – Zenexer
                    Jan 29 '15 at 2:45





                    127.0.0.0/8 are all loopback addresses. That is, 127.*.*.* will work as a loopback address, not just 127.0.0.1.

                    – Zenexer
                    Jan 29 '15 at 2:45













                    I never knew that! Cool tip

                    – Alan
                    Apr 3 at 14:47





                    I never knew that! Cool tip

                    – Alan
                    Apr 3 at 14:47

















                    draft saved

                    draft discarded
















































                    Thanks for contributing an answer to Server Fault!


                    • Please be sure to answer the question. Provide details and share your research!

                    But avoid


                    • Asking for help, clarification, or responding to other answers.

                    • Making statements based on opinion; back them up with references or personal experience.

                    To learn more, see our tips on writing great answers.




                    draft saved


                    draft discarded














                    StackExchange.ready(
                    function ()
                    StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fserverfault.com%2fquestions%2f565073%2fcant-allocate-nodeid-for-api%23new-answer', 'question_page');

                    );

                    Post as a guest















                    Required, but never shown





















































                    Required, but never shown














                    Required, but never shown












                    Required, but never shown







                    Required, but never shown

































                    Required, but never shown














                    Required, but never shown












                    Required, but never shown







                    Required, but never shown







                    Popular posts from this blog

                    Wikipedia:Vital articles Мазмуну Biography - Өмүр баян Philosophy and psychology - Философия жана психология Religion - Дин Social sciences - Коомдук илимдер Language and literature - Тил жана адабият Science - Илим Technology - Технология Arts and recreation - Искусство жана эс алуу History and geography - Тарых жана география Навигация менюсу

                    Bruxelas-Capital Índice Historia | Composición | Situación lingüística | Clima | Cidades irmandadas | Notas | Véxase tamén | Menú de navegacióneO uso das linguas en Bruxelas e a situación do neerlandés"Rexión de Bruxelas Capital"o orixinalSitio da rexiónPáxina de Bruselas no sitio da Oficina de Promoción Turística de Valonia e BruxelasMapa Interactivo da Rexión de Bruxelas-CapitaleeWorldCat332144929079854441105155190212ID28008674080552-90000 0001 0666 3698n94104302ID540940339365017018237

                    What should I write in an apology letter, since I have decided not to join a company after accepting an offer letterShould I keep looking after accepting a job offer?What should I do when I've been verbally told I would get an offer letter, but still haven't gotten one after 4 weeks?Do I accept an offer from a company that I am not likely to join?New job hasn't confirmed starting date and I want to give current employer as much notice as possibleHow should I address my manager in my resignation letter?HR delayed background verification, now jobless as resignedNo email communication after accepting a formal written offer. How should I phrase the call?What should I do if after receiving a verbal offer letter I am informed that my written job offer is put on hold due to some internal issues?Should I inform the current employer that I am about to resign within 1-2 weeks since I have signed the offer letter and waiting for visa?What company will do, if I send their offer letter to another company