Configuration error: Error: Could not alloc node id at 172.xx.xx.2 port 1186: Connection done from wrong host ip 172.xx.x.4

Im running in datanode 2 ndb_restorebut it get me error.

[root@a5aabaf20dc3 /]# ndb_restore --ndb-connectstring=172.xx.xx.2:1186 \ >                    --nodeid=2 --backupid=1 \ >                    --backup_path=/var/lib/mysql-cluster/BACKUP/BACKUP-1 \ >                    --restore_data --disable-indexes Nodeid = 2 Backup Id = 1 backup path = /var/lib/mysql-cluster/BACKUP/BACKUP-1 Configuration error: Error: Could not alloc node id at 172.xx.xx.2 port 1186: Connection done from wrong host ip 172.xx.x.4. 

also tried --ndb-connectstring "nodeid=2,172.xx.xx.2:1186" and with out port as well as with out --ndb-connectstring at all. nothing made it better

Cluster Configuration --------------------- [ndbd(NDB)] 4 node(s) id=2    @172.xx.xx.4  (mysql-8.0.21 ndb-8.0.21, Nodegroup: 0, *) id=3    @172.xx.xx.3  (mysql-8.0.21 ndb-8.0.21, Nodegroup: 0) id=4    @172.xx.xx.8  (mysql-8.0.21 ndb-8.0.21, Nodegroup: 1) id=5    @172.xx.x.9  (mysql-8.0.21 ndb-8.0.21, Nodegroup: 1)  [ndb_mgmd(MGM)] 1 node(s) id=1    @172.xx.xx.2  (mysql-8.0.21 ndb-8.0.21)  [mysqld(API)]   2 node(s) id=101  @172.xx.xx.5  (mysql-8.0.21 ndb-8.0.21) id=102 (@172.xx.xx.6  (mysql-8.0.21 ndb-8.0.21) 

anyone have idea whats wrong?

Which main problems could arise from adding a number to a domain name?

Consider the domains star.com and star1.com.

What could be the problems with adding number as in the second example?


I can think about the following, I speak Hebrew and in Hebrew I could say:

star one dot com סטאר וואן דוט קום 

I could also say:

star ehad dot com סטאר אחד דוט קום 

(ehad in Hebrew means one).

Either of the Hebrew phrases might confuse a listener (vocally); the listener might not be sure if either "one" or "ehad" would mean an actual number 1.

Whaty could be the cause of postgres functions losing or swapping values from a CTE?

I have a number of functions which are generally in this shape:

RETURN QUERY with cte1 as (    select a, b, c, d, e    from [some_table]    where [some_condition] ), cte2 as (     select x, y, z     from [big_table]     where [bunch_of_conditions] ) select foo.x, foo.y, bar.a, bar.b, bar.c, bar.d from cte2 foo join cte1 bar on foo.z = bar.a 

I have seen occasions where the values of bar.b and bar.d are swapped, and on others no values are returned – upon investigation, because bar.a contains only nulls.

In all cases, when I take the code out of the functions, it always runs correctly. In each case where it goes wrong, there is nothing I can point to which causes the glitch, and usually it goes away for no obvious reason. This is all running in pgAdmin under Windows 10, and the behaviour persists through stopping pgAdmin, and/or rebooting the PC.

The db where this happens is running on AWS, and I don’t have access to stop/restart that server.

It suggests to me that the problem is happening at the AWS and/or postgres server end, but that may or may not be correct.

Possibly also relevant, we have also seen cases where queries run exceptionally slowly (45 minutes instead of less that one second, being one example today).

In each case of the swap or the slowdown, it eventually returns to normal behaviour without any obvious intervention from me. I’m still experiencing the null value which should be populated.

Has anyone seen behaviour like this? Any ideas what could be causing it, or how to remedy it?

Could a slow website cause visitors from a Facebook ads campaign to bounce?

I have a website with traffic problems. The web site sells a product in Spanish.

I recently created a Facebook ads campaign, and it got 96 visits. But Google Analytics only registered 9 visits. I think my website could be slow and people are bouncing. Could this be the case?

I am using WordPress and the Profitbuiler plugin to create the page.

GraphicsGrid $\to$ Beep “The shared stylesheet “Stylesheet-review-topics.nb” could not be \ found. The default stylesheet will be used instead.”

12.0.0 for Microsoft Windows (64-bit) (April 6, 2019)

I have a notebook in which using GraphicsGrid causes a beep "The shared stylesheet "Stylesheet-review-topics.nb" could not be found. The default stylesheet will be used instead."

I copied the entire content of the notebook to a new one, set the style sheet to the one shown, and saved over the original notebook. Same thing happens. I created a new notebook and set the style sheet to the one shown, and it does not beep. My notebooks are fairly large, and I really don’t want to spend a lot of time untangling what amounts to a nuisance. I also doing like being annoyed.

This kind of think happens from time to time, and I’m never sure why. Any ideas?

could I use something like a magic amulet while it’s not on my neck? [duplicate]

What is defined as ‘worn’? Does an amulet or ring have to be on my neck or finger specifically or do I just have to be carrying it somewhere on my body or even in my backpack? For instance, if I had a Clockwork Amulet on my belt, does that constitute as me ‘wearing’ it so I could use it?

Are there any 3rd level spells a Lore Bard could pick at 6th character level to provide food and water to the party?

Just as the title says. I play a Bard, College of Lore. At 6th character level I will be able to pick up two spells, of up to 3rd spell level, from any class. I know we will be on the long-term adventure with no easy way to get food and drinks. Goodberries could make it much easier for us, but I do not want to "waste" a 3rd level spell known for a 1st level spell if there is something of more power available to me.

Preference is for material from Player’s Handbook and Xanathar’s Guide To Everything as it is automatically allowed. If there are multiple spells that meet the requirement, the one with the widest utility wins. If there are none, the highest level and biggest utility are the factor.