Thanks for the answers. I apologize for posting again in a new thread, comments are deleted automatically.
Chenhao Qu, as you mentioned, a page can be reconciled again for eviction. I am speaking about pages that have same write generation number as before, meaning of course the same K/V pairs and, and they are dirty again as you explained.
1)If a checkpoint reconciles a page and it stays in memory as is, will a future reader for a key that was updated (and it needs the original value) get it from the same old cell page in the memory or from someplace else?(HS?) In other words are page cells that were updated in reconciliation and stayed in mem are accessible for readers?
2) I see that for in the same scenario, in the first reconciliation the page state is WT_REF_MEM, and the rec_result is 0, and in the second time for the same page the page state is WT_REF_LOCKED and the rec_result is WT_PM_REC_REPLACE. Can you shed some light for this values meaning - why the ref was not locked in the first time and changed for the second time, and what the rec_result value means?
Again, much appreciate your answers, they are big help for me.
Matan.