Intermittent crashes on brolga in join.sql test

Started by Thomas Munroabout 8 years ago2 messages
#1Thomas Munro
thomas.munro@enterprisedb.com
1 attachment(s)

Hi Andrew,

As mentioned over here, but probably lost in the noise of that thread:

/messages/by-id/CAEepm=2r1svRUfeR1c9Z4UegkPdMw4gxyok4jCWf-h7kdqHHAA@mail.gmail.com

... there is an intermittent crash in my new Parallel Hash code that
occurs only on your 32 bit Windows XP + Cygwin animal "brolga".
Unfortunately I haven't managed to come up with a theory to explain
this using only brain power and tea.

Would you mind trying to get a backtrace from that system? Either
from a regular make check failure, or perhaps it can be provoked by
running the attached script? I don't know anything about Cygwin
myself but I see that it's possible to get a core file that gdb can
load with "dumper":

https://stackoverflow.com/questions/320001/using-a-stackdump-from-cygwin-executable
https://cygwin.com/cygwin-ug-net/dumper.html

Thanks,

--
Thomas Munro
http://www.enterprisedb.com

Attachments:

lots-of-parallel-hash-rescans.shapplication/x-sh; name=lots-of-parallel-hash-rescans.shDownload
#2Andrew Dunstan
andrew.dunstan@2ndquadrant.com
In reply to: Thomas Munro (#1)
Re: Intermittent crashes on brolga in join.sql test

On 01/07/2018 03:51 PM, Thomas Munro wrote:

Hi Andrew,

As mentioned over here, but probably lost in the noise of that thread:

/messages/by-id/CAEepm=2r1svRUfeR1c9Z4UegkPdMw4gxyok4jCWf-h7kdqHHAA@mail.gmail.com

... there is an intermittent crash in my new Parallel Hash code that
occurs only on your 32 bit Windows XP + Cygwin animal "brolga".
Unfortunately I haven't managed to come up with a theory to explain
this using only brain power and tea.

Would you mind trying to get a backtrace from that system? Either
from a regular make check failure, or perhaps it can be provoked by
running the attached script? I don't know anything about Cygwin
myself but I see that it's possible to get a core file that gdb can
load with "dumper":

https://stackoverflow.com/questions/320001/using-a-stackdump-from-cygwin-executable
https://cygwin.com/cygwin-ug-net/dumper.html

Thanks,

This machine is now very old, and doesn't have gdb installed. The
chances of my getting a compatible one now are close to zero.

A better bet might be for me to revive my other 32 bit Cygwin instance,
cockatiel.

I'll look into that.

cheers

andrew

--
Andrew Dunstan https://www.2ndQuadrant.com
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services