Really sorry, all.
I should have thoroughly investigated before I post email to the thread.
Okay, paxos rows are set with paxosTtl which defaults to max(3 * 3600,
GC_GRACE_SECONDS).
So, I have to wait 10 days to see the data removal with default
configuration.
Thank you.
Haebin
2014-06-03 12
Again, sorry for spamming.
I found out that there is no delete query for system.paxos. (2.0.6 code
base, I'm using 2.0.7, tho.)
Holy cow.
So, It does not get deleted?
Is this correct?
Thanks.
Haebin
2014-06-03 12:07 GMT+09:00 Frederick Haebin Na :
> Sorry for spamming, folks.
>
> Okay, I fou
Sorry for spamming, folks.
Okay, I found out why it is growing.
system.paxos row count is actually 3% greater than the data table.
It may be caused by re-insertion of some data range.
My ultimate question now would be why the paxos rows are not getting
removed after the transaction.
There is hi
Sorry, I found out what are in the system.paxos.
select * from system.paxos limit 1;
| row_key | cf_id | in_porgress_ballot | most_recent_commit |
most_recent_commit_at | proposal | proposal_ballot |
I will investigate more on why it is growing continuously.
If anyone have an idea why it is like
Hello all,
We are trying to migrate data with 'INSERT IF NOT EXISTS' clause.
Yet, strange thing is that the system.paxos table gets larger like 100GB
which is equal to the size of the data table.
Does anyone know what is happening here?
What does system.paxos table store?
Thank you.
Haebin