Re: null values injected while drop compact storage was executed

2024-05-14 Thread Matthias Pfau via user
This happened with versionĀ 3.11.10.

We were analyzing impact until now as this happened only on our production 
systems. There was probably not enough concurrency on our staging environments 
so it did not happen there.

We will start to write a reproducer and file an issue afterwards.

Thanks for the feedback Jeff and Scott!

Best,
Matthias



null values injected while drop compact storage was executed

2024-05-07 Thread Matthias Pfau via user
Hi there,
we just ran drop compact storage in order to prepare for the upgrade to version 
4.

We observed that column values have been written as null, if they where 
inserted while the drop compact storage statement was running. This just 
happened for the couple seconds the drop compact storage statement ran.

Did anyone else observe this? What are the proposed strategies to prevent data 
loss.

Best,
Matthias