Julian Menzler

We have the CI stage `clangRelWithDebInfoThreadSanitizer`, which runs `hyriseSystemTest`, and thus `StressTest.*`. Why does/did the CI not bring up this issue?

True. I did not read thoroughly enough, sorry.

Master vs. Master w/o SemiJoinReductionRule - click to expand Configuration Overview - click to expand ```diff +Configuration Overview---------------------------------------------+------------------------------------------------+ | Parameter | join_order_master.json | join_order_disabled_semi_join_reduction.json | +------------------+------------------------------------------------+------------------------------------------------+ | GIT-HASH | 54c2c122957f77ac0606ca2f031dd9d8ba76f9f8-dirty...

Master vs. Master w/ PRIMARY KEY constraints - click to expand Configuration Overview - click to expand ```diff +Configuration Overview---------------------------------------------+------------------------------------------------+ | Parameter | join_order_master.json | job_constraints.json | +------------------+------------------------------------------------+------------------------------------------------+ | GIT-HASH...

Master vs. Master w/ PRIMARY KEY constraints w/o ColumnPruningRule semi join reformulation - click to expand Configuration Overview - click to expand ```diff +Configuration Overview---------------------------------------------+---------------------------------------------------+ | Parameter | join_order_master.json |...

Interesting JOB queries from **Master vs. Master w/o SemiJoinReductionRule**: ```diff +---------++----------+----------+---------++----------+----------+--------+---------+ | Item || Latency (ms/iter) | Change || Throughput (iter/s) | Change | p-value | | || old |...

Interesting. But, how is that a problem for us? (apart from benchmark comparisons with other databases)

#2340 fixed this issue partially since it enables the scheduler for SQLite tests (#2014).

Reference: https://man7.org/linux/man-pages/man2/mlockall.2.html > mlockall() locks all pages mapped into the address space of the calling process. This includes the pages of the code, data, and stack segment, as well as...

This makes total sense for servers with hundreds of gigabytes of RAM. But, for all other machines, we will probably end up with failures across the board. Therefore, I would...