Rebalancing stuck in 0%

Moderator: NorbertKrupa

Post Reply
chenshaulian
Intermediate
Intermediate
Posts: 51
Joined: Wed Sep 09, 2015 9:34 am

Rebalancing stuck in 0%

Post by chenshaulian » Mon Mar 21, 2016 11:26 am

I add 10 nodes to my 10 nodes cluster (7.1.1-10)
After 26 hours (50TB) the rebalance have only 1 more table (form 156 tables) of 22TB.

select * from REBALANCE_TABLE_STATUS
Image

But I see that the rebalance doesn't run, I see that the rebalance separated_percen is 0% and in locks table I'm getting:

Image

And in session table I see that the statement_id is null were the current_statement is "select rebalance_cluster();"

Do you know why the rebalancing doesn't run?

User avatar
JimKnicely
Site Admin
Site Admin
Posts: 1825
Joined: Sat Jan 21, 2012 4:58 am
Contact:

Re: Rebalancing stuck in 0%

Post by JimKnicely » Wed Mar 23, 2016 3:05 am

Hmm... Maybe try adding several nodes at a time? You say 50 TB, is that raw db size? You might have many, many projections and that means a lot of data needs to be redistributed.
Jim Knicely

Image

Note: I work for Vertica. My views, opinions, and thoughts expressed here do not represent those of my employer.

chenshaulian
Intermediate
Intermediate
Posts: 51
Joined: Wed Sep 09, 2015 9:34 am

Re: Rebalancing stuck in 0%

Post by chenshaulian » Wed Mar 23, 2016 8:23 am

Ok... after 3 days (74 hours) all tables are rebalanced... done

User avatar
JimKnicely
Site Admin
Site Admin
Posts: 1825
Joined: Sat Jan 21, 2012 4:58 am
Contact:

Re: Rebalancing stuck in 0%

Post by JimKnicely » Wed Mar 23, 2016 10:13 am

You mean all "projections" are re-balanced :)
Jim Knicely

Image

Note: I work for Vertica. My views, opinions, and thoughts expressed here do not represent those of my employer.

chenshaulian
Intermediate
Intermediate
Posts: 51
Joined: Wed Sep 09, 2015 9:34 am

Re: Rebalancing stuck in 0%

Post by chenshaulian » Wed Mar 23, 2016 12:21 pm

You right... sorry... all projections are re-balanced :)

Post Reply

Return to “Vertica Database Administration”