From: | Craig Ringer <craig(at)2ndquadrant(dot)com> |
---|---|
To: | MauMau <maumau307(at)gmail(dot)com>, pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: [9.4 bug] The database server hangs with write-heavy workload on Windows |
Date: | 2014-10-10 04:51:25 |
Message-ID: | 543765CD.9030105@2ndquadrant.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
On 10/10/2014 04:16 AM, MauMau wrote:
> From: "Craig Ringer" <craig(at)2ndquadrant(dot)com>
>> It'd be interesting and useful to run this test on a debug build of
>> PostgreSQL, i.e. one compiled against the debug version of the C library
>> and with full debuginfo not just minimal .pdb.
>
> Although I'm not sure the user can do this now, I'll ask him anyway.
It sounds like they've produced a test case, so they should be able to
with a bit of luck.
Or even better, send you the test case.
>> How were the stacks captured - what tool?
>
> According to his mail, Windbg or userdump.exe. I'll ask him about this.
Thanks. The stack trace looks fairly sane, i.e. there's nothing
obviously out of whack at a glance, but I tend to get more informative
traces from Visual Studio debugging sessions.
Your next step here really needs to be to make this reproducible against
a debug build. Then see if reverting the xlog scalability work actually
changes the behaviour, given that you hypothesised that it could be
involved.
As I said off-list, if you can narrow the test case down to something
that can be reproduced more quickly, you could also git-bisect to seek
the commit at fault. Even if the test case takes an hour, that's still
viable:
$ git bisect start
$ git bisect bad
$ git bisect good REL9_3_RC1
Bisecting: a merge base must be tested
[e472b921406407794bab911c64655b8b82375196] Avoid deadlocks during
insertion into SP-GiST indexes.
$ git bisect good
Bisecting: 1026 revisions left to test after this (roughly 10 steps)
...
Thanks to the magic of binary search.
--
Craig Ringer http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services
From | Date | Subject | |
---|---|---|---|
Next Message | Kyotaro HORIGUCHI | 2014-10-10 06:48:56 | Re: Escaping from blocked send() reprised. |
Previous Message | Amit Kapila | 2014-10-10 04:43:03 | Re: Wait free LW_SHARED acquisition - v0.9 |