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
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:
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?
Rebalancing stuck in 0%
Moderator: NorbertKrupa
- JimKnicely
- Site Admin
- Posts: 1825
- Joined: Sat Jan 21, 2012 4:58 am
- Contact:
Re: Rebalancing stuck in 0%
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
Note: I work for Vertica. My views, opinions, and thoughts expressed here do not represent those of my employer.
Note: I work for Vertica. My views, opinions, and thoughts expressed here do not represent those of my employer.
-
- Intermediate
- Posts: 51
- Joined: Wed Sep 09, 2015 9:34 am
Re: Rebalancing stuck in 0%
Ok... after 3 days (74 hours) all tables are rebalanced... done
- JimKnicely
- Site Admin
- Posts: 1825
- Joined: Sat Jan 21, 2012 4:58 am
- Contact:
Re: Rebalancing stuck in 0%
You mean all "projections" are re-balanced
Jim Knicely
Note: I work for Vertica. My views, opinions, and thoughts expressed here do not represent those of my employer.
Note: I work for Vertica. My views, opinions, and thoughts expressed here do not represent those of my employer.
-
- Intermediate
- Posts: 51
- Joined: Wed Sep 09, 2015 9:34 am
Re: Rebalancing stuck in 0%
You right... sorry... all projections are re-balanced