Re: Paxos table gets larger when using 'IF NOT EXISTS'

2014-06-02 Thread Frederick Haebin Na
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

Re: Paxos table gets larger when using 'IF NOT EXISTS'

2014-06-02 Thread Frederick Haebin Na
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

Re: Paxos table gets larger when using 'IF NOT EXISTS'

2014-06-02 Thread Frederick Haebin Na
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

Re: Paxos table gets larger when using 'IF NOT EXISTS'

2014-06-02 Thread Frederick Haebin Na
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

Paxos table gets larger when using 'IF NOT EXISTS'

2014-06-02 Thread Frederick Haebin Na
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