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


Data not replicating over nodea — Vertica Forum

Data not replicating over nodea

So i have a very unreasonable question. I loaded the VMart database on a three node cluster. Its working fine and i can see the database and hosts in MC. Now, when i insert a data row in the employee dimension table on node B, it does not get replicated on nodes A and C. Also if i just exit the vsql client on node B and then again query for that specific data row, i can not find it. Why is this happening?

Comments

  • Hi Anmol,

    Just want to ask a simple question, did you perform commit after insert?
    Because if COMMIT is not done then the data will be lost once you log out that session.
  • Hi Shobhit,

    Unfortunately i did not. Now that i have done it, i can see the data replicated across nodes.
    Thank you very much :)

Leave a Comment

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