Title
#users-public
Newskooler

Newskooler

08/19/2022, 2:57 PM
I am having an issue: When I insert large amounts of data (millions of rows) into a table, the QDB instance at some point freezes… It’s happening on version 6.4.2 The data is OOO (I try to make it ordered), so I suspect this may be it…. I insert via ILP. Not sure what more I can share to debug this. Does anyone else experience similar issues?
3:11 PM
I can confirm that QDB - when presented with a large table and when it needs to insert O3 data, things get messier than then should be. I believe there is a bug here, but am struggling to pinpoint it ;/ It has happed to me before. Once I removed the o3 insert form the equation, I don’t get any issues.
Nicolas Hourcard

Nicolas Hourcard

08/19/2022, 3:19 PM
hey Stelian, what is your commit lag configuration ?
Newskooler

Newskooler

08/19/2022, 4:01 PM
it’s 3,000,000. (I believe that’s 3s).
Nicolas Hourcard

Nicolas Hourcard

08/19/2022, 4:03 PM
1000 is one second
4:04 PM
if you have high throuhgput 3,000,000 is too high
Newskooler

Newskooler

08/19/2022, 4:12 PM
3,000,000 is 1 second indeed. I verified that.