From: | Alexander Lakhin <exclusion(at)gmail(dot)com> |
---|---|
To: | Tender Wang <tndrwang(at)gmail(dot)com> |
Cc: | PostgreSQL mailing lists <pgsql-bugs(at)lists(dot)postgresql(dot)org> |
Subject: | Re: BUG #18385: Assert("strategy_delta >= 0") in BgBufferSync() fails due to race condition |
Date: | 2024-03-13 08:00:00 |
Message-ID: | 74affb73-113e-0300-dc43-ea73535c23b9@gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
Hi Tender Wang,
13.03.2024 09:50, Tender Wang wrote:
> Hi Alexander,
> I haven't been able to reproduce this issue on my machine(2 vCPU, 2GB memory).
>
> Can you reproduce this issue reliably on your machine?
Thanks for your attention to this issue!
On my 12-core workstation, where pgbench shows approximately 2500 tps,
`pgbench -t 10000 -c 40` failed on iterations 1, 1, 3:
...
number of transactions actually processed: 398639/400000
number of failed transactions: 0 (0.000%)
latency average = 15.931 ms
initial connection time = 56.806 ms
tps = 2510.845701 (without initial connection time)
pgbench: error: Run was aborted; the above results are incomplete.
...
The server built with gcc,
CPPFLAGS="-O0" ./configure --enable-debug --enable-cassert ...
I have also intensified bgwriter as follows:
rc = WaitLatch(MyLatch,
WL_LATCH_SET | WL_TIMEOUT | WL_EXIT_ON_PM_DEATH,
- BgWriterDelay /* ms */ , WAIT_EVENT_BGWRITER_MAIN);
+ 1 /* ms */ , WAIT_EVENT_BGWRITER_MAIN);
That is, I have the attached modification applied and the following in my
extra.config:
fsync = off
autovacuum = off
shared_buffers = '1MB'
Best regards,
Alexander
Attachment | Content-Type | Size |
---|---|---|
debug-18385.patch | text/x-patch | 1017 bytes |
From | Date | Subject | |
---|---|---|---|
Next Message | Laurenz Albe | 2024-03-13 08:44:16 | Re: BUG #18389: pg_database_owner not recognized with alter default privileges |
Previous Message | Kristo Marijo | 2024-03-13 07:16:53 | AW: BUG #18389: pg_database_owner not recognized with alter default privileges |