On Fri, May 14, 2021 at 8:36 PM Pengchengliu <pengcheng...@tju.edu.cn> wrote: > Did you use pgbench with the script sub_120.sql which I provide in > attachment?
yes > > Did you increase the number PGPROC_MAX_CACHED_SUBXIDS? Please don't change > any codes, now we just use the origin codes in PG13.2. > No, I have made no source code changes at all. That was my suggestion, for you to try - because if the problem is avoided by increasing PGPROC_MAX_CACHED_SUBXIDS (to say 128) then it probably indicates the overflow condition is affecting the xmin.xmax of the two snapshots such that it invalidates the condition that is asserted. I think one problem is that in your settings, you haven't set "max_worker_processes", yet have set "max_parallel_workers = 128". I'm finding no more than 8 parallel workers are actually active at any one time. On top of this, you've got pgbench running with 200 concurrent clients. So many queries are actually executing parallel plans without using parallel workers, as the workers can't actually be launched (and this is probably why I'm finding it hard to reproduce the issue, if the problem involves snapshot suboverflow and parallel workers). I find that the following settings improve the parallelism per query and the whole test runs very much faster: max_connections = 2000 parallel_setup_cost=0 parallel_tuple_cost=0 min_parallel_table_scan_size=0 max_parallel_workers_per_gather=4 max_parallel_workers = 100 max_worker_processes = 128 and adjust the pgbench command-line: pgbench -d postgres -p 33550 -n -r -f sub_120.sql -c 25 -j 25 -T 1800 Problem is, I still get no coredump when using this. Can you try these settings and let me know if the crash still happens if you use these settings? I also tried: max_connections = 2000 parallel_setup_cost=0 parallel_tuple_cost=0 min_parallel_table_scan_size=0 max_parallel_workers_per_gather=2 max_parallel_workers = 280 max_worker_processes = 300 and the pgbench command-line: pgbench -d postgres -p 33550 -n -r -f sub_120.sql -c 140 -j 140 -T 1800 - but I still get no coredump. Regards, Greg Nancarrow Fujitsu Australia
