On Wed, 15 Oct 2025 at 04:51, Yuri Zamyatin <yuri(at)yrz(dot)am> wrote:
> To cause the segfault, these queries were launched simultaneously.
>
> > -- in 2 parallel infinite loops
> > with ids as (select (118998526-random()*100000)::int id from generate_series(1,10000))
> > update tcv_scene_datas set id=id where cv_scene_id in(select id from ids);
> > with ids as (select (118998526-random()*100000)::int id from generate_series(1,10000))
> > update tcv_scenes set id=id where id in(select id from ids);
Are you able to mock this up using the schema and some test data then
share the script to populate the database?
David