Re: 9.1Beta1 - Repeatable Crash on Windows

On Mon, May 9, 2011 at 5:55 PM, Greg Smith <greg(at)2ndquadrant(dot)com> wrote:
> But if you can
> spare some time to dig further, the instructions at
> http://wiki.postgresql.org/wiki/Getting_a_stack_trace_of_a_running_PostgreSQL_backend_on_Windows
> go over how to trace into where it's actually failing at yourself.  If you
> run PostgreSQL on Windows, that's good defensive practice to fit in on a day
> it's not an emergency to do so.  (The same is true of any platform, it just
> takes more time to setup on Windows)

These following is the stack trace taken using the instruction for
"Getting a stack trace of a repeatable backend crash."

0:003> G
(4ac.158): Access violation - code c0000005 (first chance)
First chance exceptions are reported before any exception handling.
This exception may be expected and handled.
eax=ffffffff ebx=fffffff4 ecx=ffffffff edx=fffffffd esi=00000000 edi=00000000
eip=0063b890 esp=00d4f614 ebp=00d4f7c0 iopl=0 nv up ei ng nz na pe cy
cs=001b ss=0023 ds=0023 es=0023 fs=003b gs=0000 efl=00010287
postgres!datebsearch+0x30:
0063b890 0fbe0c97 movsx ecx,byte ptr [edi+edx*4] ds:0023:fffffff4=??
0:000> ~*k

. 0 Id: 4ac.158 Suspend: 1 Teb: 7ffdf000 Unfrozen
ChildEBP RetAddr
00d4f620 0063d738 postgres!datebsearch+0x30
[c:\pginstaller-repo\postgres.windows\src\backend\utils\adt\datetime.c
@ 3579]
00d4f634 0063e824 postgres!DecodeSpecial+0x38
[c:\pginstaller-repo\postgres.windows\src\backend\utils\adt\datetime.c
@ 2789]
00d4f688 006a62a9 postgres!DecodeDateTime+0x654
[c:\pginstaller-repo\postgres.windows\src\backend\utils\adt\datetime.c
@ 1173]
00d4f818 006df4ce postgres!timestamp_in+0x79
[c:\pginstaller-repo\postgres.windows\src\backend\utils\adt\timestamp.c
@ 161]
00d4fa3c 006e0fc3 postgres!InputFunctionCall+0xae
[c:\pginstaller-repo\postgres.windows\src\backend\utils\fmgr\fmgr.c @
1909]
00d4fa7c 005b66f7 postgres!OidInputFunctionCall+0x33
[c:\pginstaller-repo\postgres.windows\src\backend\utils\fmgr\fmgr.c @
2041]
00d4fa98 005a4d3d postgres!stringTypeDatum+0x27
[c:\pginstaller-repo\postgres.windows\src\backend\parser\parse_type.c
@ 586]
00d4fad4 005a437e postgres!coerce_type+0x16d
[c:\pginstaller-repo\postgres.windows\src\backend\parser\parse_coerce.c
@ 253]
00d4fb08 005a915a postgres!coerce_to_target_type+0x4e
[c:\pginstaller-repo\postgres.windows\src\backend\parser\parse_coerce.c
@ 90]
00d4fb40 005aaa96 postgres!transformTypeCast+0x6a
[c:\pginstaller-repo\postgres.windows\src\backend\parser\parse_expr.c
@ 2105]
00d4fb58 005b5abc postgres!transformExpr+0x326
[c:\pginstaller-repo\postgres.windows\src\backend\parser\parse_expr.c
@ 187]
00d4fb7c 00585ac4 postgres!transformTargetList+0xdc
[c:\pginstaller-repo\postgres.windows\src\backend\parser\parse_target.c
@ 166]
00d4fb9c 00586187 postgres!transformSelectStmt+0x74
[c:\pginstaller-repo\postgres.windows\src\backend\parser\analyze.c @
903]
00d4fbb0 00586317 postgres!transformStmt+0xa7
[c:\pginstaller-repo\postgres.windows\src\backend\parser\analyze.c @
187]
00d4fbc4 0060fc4e postgres!parse_analyze+0x37
[c:\pginstaller-repo\postgres.windows\src\backend\parser\analyze.c @
97]
00d4fc70 006105e5 postgres!exec_simple_query+0x28e
[c:\pginstaller-repo\postgres.windows\src\backend\tcop\postgres.c @
945]
00d4fcf4 005ca54c postgres!PostgresMain+0x575
[c:\pginstaller-repo\postgres.windows\src\backend\tcop\postgres.c @
3926]
00d4fd14 005cd27a postgres!BackendRun+0x19c
[c:\pginstaller-repo\postgres.windows\src\backend\postmaster\postmaster.c
@ 3600]
00d4ff64 00527b1b postgres!SubPostmasterMain+0x30a
[c:\pginstaller-repo\postgres.windows\src\backend\postmaster\postmaster.c
@ 4096]
00d4ff7c 0071270d postgres!main+0x1fb
[c:\pginstaller-repo\postgres.windows\src\backend\main\main.c @ 176]
00d4ffc0 7c817077 postgres!__tmainCRTStartup+0x10f
[f:\dd\vctools\crt_bld\self_x86\crt\src\crtexe.c @ 586]
00d4fff0 00000000 kernel32!BaseProcessStart+0x23

1 Id: 4ac.294 Suspend: 1 Teb: 7ffde000 Unfrozen
ChildEBP RetAddr
018bfecc 7c90d3aa ntdll!KiFastSystemCallRet
018bfed0 7c8314ae ntdll!ZwFsControlFile+0xc
018bff14 005bd337 kernel32!ConnectNamedPipe+0x52
018bffb4 7c80b729 postgres!pg_signal_thread+0x97
[c:\pginstaller-repo\postgres.windows\src\backend\port\win32\signal.c
@ 275]
018bffec 00000000 kernel32!BaseThreadStart+0x37

2 Id: 4ac.528 Suspend: 1 Teb: 7ffdd000 Unfrozen
ChildEBP RetAddr
0473ff2c 7c90df5a ntdll!KiFastSystemCallRet
0473ff30 7c8025db ntdll!NtWaitForSingleObject+0xc
0473ff94 005be98b kernel32!WaitForSingleObjectEx+0xa8
0473ffb4 7c80b729 postgres!pg_timer_thread+0x2b
[c:\pginstaller-repo\postgres.windows\src\backend\port\win32\timer.c @
51]
0473ffec 00000000 kernel32!BaseThreadStart+0x37

--
Regards,
Richard Broersma Jr.