We're Moving!

The Vertica Forum is moving to a new OpenText Analytics Database (Vertica) Community.

Join us there to post discussion topics, learn about

product releases, share tips, access the blog, and much more.

Create My New Community Account Now


Mapping new Address - Fails in my setup — Vertica Forum

Mapping new Address - Fails in my setup

msanjibmsanjib Vertica Customer
edited August 2020 in General Discussion

Hi Team,
This is a nightmare for now to troubleshoot this issue. I have almost spent lot of time to figure out the reason for the failure. Any urgent help will be really appreciate, I am running out of time for a deadline.
I wanted to change the existing ip adresses of my setup ( network: 10.189.199/22 )to 3 new ip addresses (10.176.45.0/23).
I wanted use the re_ip with admintool. Generally it works but this time I am getting issue and almost no clue.
[Additional Info : These 3 vms are replicated from the primary site to disaster recovery site. Actually the idea, is that we want to use VM Ware storage level replication in active passive mode.]

Logs from adminTool.log

2020-08-09 13:37:03.618 admintools/18909:0x7f8b4b4ef740 [NodeState.transition] v_dummy_node0001=Preparing -> v_dummy_node0001=Prepared
2020-08-09 13:37:03.618 admintools/18909:0x7f8b4b4ef740 [NodeState.transition] v_dummy_node0002=Preparing -> v_dummy_node0002=Prepared
2020-08-09 13:37:03.618 admintools/18909:0x7f8b4b4ef740 [NodeState.transition] v_dummy_node0003=Preparing -> v_dummy_node0003=Prepared
2020-08-09 13:37:03.618 admintools/18909:0x7f8b4b4ef740 [NodeState.transition] v_dummy_node0002=Prepared -> v_dummy_node0002=OutOfDate
2020-08-09 13:37:03.618 admintools/18909:0x7f8b4b4ef740 [NodeState.transition] v_dummy_node0003=Prepared -> v_dummy_node0003=OutOfDate
2020-08-09 13:37:03.618 admintools/18909:0x7f8b4b4ef740 [NodeState.transition] v_dummy_node0001=Prepared -> v_dummy_node0001=RollingBack
2020-08-09 13:37:03.618 admintools/18909:0x7f8b4b4ef740 [NodeState.transition] v_dummy_node0002=OutOfDate -> v_dummy_node0002=RollingBack

2020-08-09 13:37:03.618 admintools/18909:0x7f8b4b4ef740 [NodeState.transition] v_dummy_node0003=OutOfDate -> v_dummy_node0003=RollingBack

As per my knowledge, the ssh connection goes fine, it read the input file , parse and then connect also. The issue is while updating the configuration file.
Please advise if there is any work around? I am just a learning Vertica and may be not knowing the internal of its working, however I will be interested.

I will also attach the full log if required.
Thanks in advance.
Regards,
SM

Answers

  • HibikiHibiki Vertica Employee Employee

    How did you shut down the cluster before changing the IP addresses? The status of node #2 and #3 was OutOfDate. It seems node #1 has the latest catalog and it hasn't been synced with the rest of nodes.

  • Jim_KnicelyJim_Knicely - Select Field - Administrator

    I think the key reason why node's 2 and 3 are probably out of date is:

    [Additional Info : These 3 vms are replicated from the primary site to disaster recovery site. Actually the idea, is that we want to use VM Ware storage level replication in active passive mode.]

    Per the Vertica doc (https://www.vertica.com/docs/10.0.x/HTML/Content/Authoring/SupportedPlatforms/Virtualization.htm):

  • HibikiHibiki Vertica Employee Employee

    Hi Jim,
    Thank you for your comment. Yes, that is why I wanted to know how to shut down the cluster.

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Emoji
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file