On 7/22/22 14:17, 王伟(学弈) wrote:
> On 7/22/22 18:06, Tomas Vondra wrote:
>> Which PG14 version / commit is this, exactly? What sysbench parameters
>> did you use, how likely is hitting the issue?
> PG_VERSION is '14beta2'.
> The head commit id is 'e1c1c30f635390b6a3ae4993e8cac213a33e6e3f'.
Why not current REL_14_STABLE? 14beta2 is pretty old, and while I
haven't checked, perhaps this was already fixed since then.
> I have run these sysbench commands for couple of days, but only two times to hit the issue.
> These sysbench commands are:
> prepare:
>
sysbench --tables=10 --table-size=1000000 --db-ps-mode=auto --pgsql-password=* --time=72000 --db-driver=pgsql --pgsql-port=*
>
--threads=50 --thread-init-timeout=3000 --report-interval=5 --pgsql-user=* --pgsql-host=* --pgsql-db=* --events=0 --pgsql-ignore-errors="PX000,58M01"
> ./src/lua/oltp_insert.lua prepare
> parallel execution:
>
sysbench --tables=10 --table-size=1000000 --db-ps-mode=auto --pgsql-password=* --time=72000 --db-driver=pgsql --pgsql-port=*
> --threads=50 --thread-init-timeout=3000 --report-interval=5 --pgsql-user=* --pgsql-host=*
> --pgsql-db=* --events=0 --pgsql-ignore-errors="PX000,58M01"
> ./src/lua/oltp_insert.lua run
>
sysbench --tables=10 --table-size=1000000 --db-ps-mode=auto --pgsql-password=* --time=72000 --db-driver=pgsql --pgsql-port=*
>
--threads=50 --thread-init-timeout=3000 --report-interval=5 --pgsql-user=* --pgsql-host=*--pgsql-db=* --events=0 --pgsql-ignore-errors="PX000,58M01"
> ./src/lua/oltp_delete.lua run
>
sysbench --tables=10 --table-size=1000000 --db-ps-mode=auto --pgsql-password=* --time=72000 --db-driver=pgsql --pgsql-port=*
> --threads=50 --thread-init-timeout=3000 --report-interval=5 --pgsql-user=* --pgsql-host=*
> --pgsql-db=* --events=0 --pgsql-ignore-errors="PX000,58M01" ./src/lua/oltp_read_write.lua run
>
sysbench --tables=10 --table-size=1000000 --db-ps-mode=auto --pgsql-password=* --time=72000 --db-driver=pgsql --pgsql-port=*
> --threads=50 --thread-init-timeout=3000 --report-interval=5 --pgsql-user=* --pgsql-host=*
> --pgsql-db=* --events=0 --pgsql-ignore-errors="PX000,58M01" ./src/lua/oltp_update_index.lua run
>
Thanks. Not sure I'll be able to do such long sysbench runs, though. Can
you try reproducing this with current REL_14_STABLE? I wonder if dumping
the WAL (using pg_waldump) might tell us more about what happened.
regards
--
Tomas Vondra
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company