Re: Postgres 9.0 crash on win7 - Mailing list pgsql-bugs
| From | Andrea Peri 2007 |
|---|---|
| Subject | Re: Postgres 9.0 crash on win7 |
| Date | |
| Msg-id | 4CA8B477.7080707@gmail.com Whole thread Raw |
| In response to | Postgres 9.0 crash on win7 (Andrea Peri <aperi2007@gmail.com>) |
| List | pgsql-bugs |
>Truly, the most helpful thing at this point would be to collect a backtrace showing where in the postgresql server it crashed. >There are instructions on how to do that here: >http://wiki.postgresql.org/wiki/Getting_a_stack_trace_of_a_running_PostgreSQL_backend_on_Windows > > >In your case, as the backend is crashing you will want to use windbg or Visual Studio Express Edition to >collect the crash data; process explorer will not be enough. Hi, I collect the trace information of the crash using windbg. If get two set of trace, the first is when postgres start in the windbg session. --- the first set --- *** wait with pending attach Symbol search path is: C:\Program Files (x86)\PostgreSQL\9.0\symbols;SRV*c:\localsymbols*http://msdl.microsoft.com/download/symbols Executable search path is: ModLoad: 00000000`003f0000 00000000`008f6000 C:\Program Files (x86)\PostgreSQL\9.0\bin\postgres.exe ModLoad: 00000000`77940000 00000000`77aeb000 C:\Windows\SYSTEM32\ntdll.dll ModLoad: 00000000`77b20000 00000000`77ca0000 ntdll.dll ModLoad: 00000000`73dc0000 00000000`73dff000 C:\Windows\SYSTEM32\wow64.dll ModLoad: 00000000`73d60000 00000000`73dbc000 C:\Windows\SYSTEM32\wow64win.dll ModLoad: 00000000`73d50000 00000000`73d58000 C:\Windows\SYSTEM32\wow64cpu.dll ModLoad: 00000000`76af0000 00000000`76bf0000 KERNEL32.dll ModLoad: 00000000`77640000 00000000`77686000 KERNELBASE.dll ModLoad: 00000000`10000000 00000000`10033000 SSLEAY32.dll ModLoad: 00000000`00140000 00000000`0023e000 LIBEAY32.dll ModLoad: 00000000`739f0000 00000000`739f7000 WSOCK32.dll ModLoad: 00000000`771b0000 00000000`771e5000 WS2_32.dll ModLoad: 00000000`756f0000 00000000`7579c000 msvcrt.dll ModLoad: 00000000`76bf0000 00000000`76ce0000 RPCRT4.dll ModLoad: 00000000`75690000 00000000`756f0000 SspiCli.dll ModLoad: 00000000`75680000 00000000`7568c000 CRYPTBASE.dll ModLoad: 00000000`77700000 00000000`77719000 SECHOST.dll ModLoad: 00000000`775a0000 00000000`775a6000 NSI.dll ModLoad: 00000000`77110000 00000000`771a0000 GDI32.dll ModLoad: 00000000`757a0000 00000000`758a0000 USER32.dll ModLoad: 00000000`77310000 00000000`773b0000 ADVAPI32.dll ModLoad: 00000000`771a0000 00000000`771aa000 LPK.dll ModLoad: 00000000`76fe0000 00000000`7707d000 USP10.dll ModLoad: 00000000`734a0000 00000000`73543000 MSVCR90.dll ModLoad: 00000000`61cc0000 00000000`61cd3000 libintl-8.dll ModLoad: 00000000`66000000 00000000`660e7000 libiconv-2.dll ModLoad: 00000000`002c0000 00000000`003b1000 libxml2.dll ModLoad: 00000000`00d90000 00000000`00e69000 iconv.dll ModLoad: 00000000`003c0000 00000000`003d3000 zlib1.dll ModLoad: 00000000`735d0000 00000000`735d8000 Secur32.dll ModLoad: 00000000`76f90000 00000000`76fd5000 WLDAP32.dll ModLoad: 00000000`76f30000 00000000`76f90000 IMM32.dll ModLoad: 00000000`76500000 00000000`765cc000 MSCTF.dll ModLoad: 00000000`735f0000 00000000`7362c000 MSWSOCK.dll ModLoad: 00000000`73490000 00000000`73496000 WSHIP6.dll ModLoad: 00000000`735e0000 00000000`735e5000 WSHTCPIP.dll (ec0.fe4): Break instruction exception - code 80000003 (first chance) ntdll!DbgBreakPoint: 00000000`7798f190 cc int 3 0:003> ~*k 0 Id: ec0.66c Suspend: 1 Teb: 00000000`7efdb000 Unfrozen Child-SP RetAddr Call Site 00000000`0013e6b8 00000000`73d5282c wow64cpu!CpupSyscallStub+0x9 00000000`0013e6c0 00000000`73dcd07e wow64cpu!WaitForMultipleObjects32+0x32 00000000`0013e780 00000000`73dcc549 wow64!RunCpuSimulation+0xa 00000000`0013e7d0 00000000`779884c8 wow64!Wow64LdrpInitialize+0x429 00000000`0013ed20 00000000`77987623 ntdll!LdrpInitializeProcess+0x17e2 00000000`0013f220 00000000`7797308e ntdll! ?? ::FNODOBFM::`string'+0x2bea0 00000000`0013f290 00000000`00000000 ntdll!LdrInitializeThunk+0xe 1 Id: ec0.868 Suspend: 1 Teb: 00000000`7efad000 Unfrozen Child-SP RetAddr Call Site 00000000`01e6eca8 00000000`73d52932 wow64cpu!CpupSyscallStub+0x9 00000000`01e6ecb0 00000000`73dcd07e wow64cpu!DeviceIoctlFileFault+0x31 00000000`01e6ed70 00000000`73dcc549 wow64!RunCpuSimulation+0xa 00000000`01e6edc0 00000000`779bd177 wow64!Wow64LdrpInitialize+0x429 00000000`01e6f310 00000000`7797308e ntdll! ?? ::FNODOBFM::`string'+0x2bfe4 00000000`01e6f380 00000000`00000000 ntdll!LdrInitializeThunk+0xe 2 Id: ec0.a50 Suspend: 1 Teb: 00000000`7efaa000 Unfrozen Child-SP RetAddr Call Site 00000000`01fded28 00000000`73d52bcd wow64cpu!CpupSyscallStub+0x9 00000000`01fded30 00000000`73dcd07e wow64cpu!Thunk0ArgReloadState+0x1a 00000000`01fdedf0 00000000`73dcc549 wow64!RunCpuSimulation+0xa 00000000`01fdee40 00000000`779bd177 wow64!Wow64LdrpInitialize+0x429 00000000`01fdf390 00000000`7797308e ntdll! ?? ::FNODOBFM::`string'+0x2bfe4 00000000`01fdf400 00000000`00000000 ntdll!LdrInitializeThunk+0xe # 3 Id: ec0.fe4 Suspend: 1 Teb: 00000000`7efd8000 Unfrozen Child-SP RetAddr Call Site 00000000`019cfc58 00000000`77a38638 ntdll!DbgBreakPoint 00000000`019cfc60 00000000`779a39cb ntdll!DbgUiRemoteBreakin+0x38 00000000`019cfc90 00000000`00000000 ntdll!RtlUserThreadStart+0x25 The second set is when PG9 crash during execution of script sql and windbg intercept the crash -- the second set --- *** wait with pending attach Symbol search path is: C:\Program Files (x86)\PostgreSQL\9.0\symbols;SRV*c:\localsymbols*http://msdl.microsoft.com/download/symbols Executable search path is: ModLoad: 00000000`003f0000 00000000`008f6000 C:\Program Files (x86)\PostgreSQL\9.0\bin\postgres.exe ModLoad: 00000000`77940000 00000000`77aeb000 C:\Windows\SYSTEM32\ntdll.dll ModLoad: 00000000`77b20000 00000000`77ca0000 ntdll.dll ModLoad: 00000000`73dc0000 00000000`73dff000 C:\Windows\SYSTEM32\wow64.dll ModLoad: 00000000`73d60000 00000000`73dbc000 C:\Windows\SYSTEM32\wow64win.dll ModLoad: 00000000`73d50000 00000000`73d58000 C:\Windows\SYSTEM32\wow64cpu.dll ModLoad: 00000000`76af0000 00000000`76bf0000 KERNEL32.dll ModLoad: 00000000`77640000 00000000`77686000 KERNELBASE.dll ModLoad: 00000000`10000000 00000000`10033000 SSLEAY32.dll ModLoad: 00000000`00140000 00000000`0023e000 LIBEAY32.dll ModLoad: 00000000`739f0000 00000000`739f7000 WSOCK32.dll ModLoad: 00000000`771b0000 00000000`771e5000 WS2_32.dll ModLoad: 00000000`756f0000 00000000`7579c000 msvcrt.dll ModLoad: 00000000`76bf0000 00000000`76ce0000 RPCRT4.dll ModLoad: 00000000`75690000 00000000`756f0000 SspiCli.dll ModLoad: 00000000`75680000 00000000`7568c000 CRYPTBASE.dll ModLoad: 00000000`77700000 00000000`77719000 SECHOST.dll ModLoad: 00000000`775a0000 00000000`775a6000 NSI.dll ModLoad: 00000000`77110000 00000000`771a0000 GDI32.dll ModLoad: 00000000`757a0000 00000000`758a0000 USER32.dll ModLoad: 00000000`77310000 00000000`773b0000 ADVAPI32.dll ModLoad: 00000000`771a0000 00000000`771aa000 LPK.dll ModLoad: 00000000`76fe0000 00000000`7707d000 USP10.dll ModLoad: 00000000`734a0000 00000000`73543000 MSVCR90.dll ModLoad: 00000000`61cc0000 00000000`61cd3000 libintl-8.dll ModLoad: 00000000`66000000 00000000`660e7000 libiconv-2.dll ModLoad: 00000000`002c0000 00000000`003b1000 libxml2.dll ModLoad: 00000000`00d90000 00000000`00e69000 iconv.dll ModLoad: 00000000`003c0000 00000000`003d3000 zlib1.dll ModLoad: 00000000`735d0000 00000000`735d8000 Secur32.dll ModLoad: 00000000`76f90000 00000000`76fd5000 WLDAP32.dll ModLoad: 00000000`76f30000 00000000`76f90000 IMM32.dll ModLoad: 00000000`76500000 00000000`765cc000 MSCTF.dll ModLoad: 00000000`735f0000 00000000`7362c000 MSWSOCK.dll ModLoad: 00000000`73490000 00000000`73496000 WSHIP6.dll ModLoad: 00000000`735e0000 00000000`735e5000 WSHTCPIP.dll (ec0.fe4): Break instruction exception - code 80000003 (first chance) ntdll!DbgBreakPoint: 00000000`7798f190 cc int 3 0:003> ~*k 0 Id: ec0.66c Suspend: 1 Teb: 00000000`7efdb000 Unfrozen Child-SP RetAddr Call Site 00000000`0013e6b8 00000000`73d5282c wow64cpu!CpupSyscallStub+0x9 00000000`0013e6c0 00000000`73dcd07e wow64cpu!WaitForMultipleObjects32+0x32 00000000`0013e780 00000000`73dcc549 wow64!RunCpuSimulation+0xa 00000000`0013e7d0 00000000`779884c8 wow64!Wow64LdrpInitialize+0x429 00000000`0013ed20 00000000`77987623 ntdll!LdrpInitializeProcess+0x17e2 00000000`0013f220 00000000`7797308e ntdll! ?? ::FNODOBFM::`string'+0x2bea0 00000000`0013f290 00000000`00000000 ntdll!LdrInitializeThunk+0xe 1 Id: ec0.868 Suspend: 1 Teb: 00000000`7efad000 Unfrozen Child-SP RetAddr Call Site 00000000`01e6eca8 00000000`73d52932 wow64cpu!CpupSyscallStub+0x9 00000000`01e6ecb0 00000000`73dcd07e wow64cpu!DeviceIoctlFileFault+0x31 00000000`01e6ed70 00000000`73dcc549 wow64!RunCpuSimulation+0xa 00000000`01e6edc0 00000000`779bd177 wow64!Wow64LdrpInitialize+0x429 00000000`01e6f310 00000000`7797308e ntdll! ?? ::FNODOBFM::`string'+0x2bfe4 00000000`01e6f380 00000000`00000000 ntdll!LdrInitializeThunk+0xe 2 Id: ec0.a50 Suspend: 1 Teb: 00000000`7efaa000 Unfrozen Child-SP RetAddr Call Site 00000000`01fded28 00000000`73d52bcd wow64cpu!CpupSyscallStub+0x9 00000000`01fded30 00000000`73dcd07e wow64cpu!Thunk0ArgReloadState+0x1a 00000000`01fdedf0 00000000`73dcc549 wow64!RunCpuSimulation+0xa 00000000`01fdee40 00000000`779bd177 wow64!Wow64LdrpInitialize+0x429 00000000`01fdf390 00000000`7797308e ntdll! ?? ::FNODOBFM::`string'+0x2bfe4 00000000`01fdf400 00000000`00000000 ntdll!LdrInitializeThunk+0xe # 3 Id: ec0.fe4 Suspend: 1 Teb: 00000000`7efd8000 Unfrozen Child-SP RetAddr Call Site 00000000`019cfc58 00000000`77a38638 ntdll!DbgBreakPoint 00000000`019cfc60 00000000`779a39cb ntdll!DbgUiRemoteBreakin+0x38 00000000`019cfc90 00000000`00000000 ntdll!RtlUserThreadStart+0x25 0:003> G ModLoad: 00000000`6e610000 00000000`6e637000 C:\Program Files (x86)\PostgreSQL\9.0\lib\plpgsql.dll ModLoad: 00000000`68f00000 00000000`68f7a000 C:\Program Files (x86)\PostgreSQL\9.0\lib\postgis-1.5.dll ModLoad: 00000000`70040000 00000000`700ad000 C:\Program Files (x86)\PostgreSQL\9.0\bin\libgeos_c-1.dll ModLoad: 00000000`68280000 00000000`68422000 C:\Program Files (x86)\PostgreSQL\9.0\bin\libgeos-3-2-2.dll ModLoad: 00000000`70f40000 00000000`71055000 C:\Program Files (x86)\PostgreSQL\9.0\bin\libxml2-2.dll ModLoad: 00000000`01090000 00000000`010c9000 C:\Program Files (x86)\PostgreSQL\9.0\bin\libproj.dll ntdll!NtTerminateProcess+0xa: 00000000`7799017a c3 ret 0:000> ~*k . 0 Id: ec0.66c Suspend: 0 Teb: 00000000`7efdb000 Unfrozen Child-SP RetAddr Call Site 00000000`0013ddc8 00000000`73dd601a ntdll!NtTerminateProcess+0xa 00000000`0013ddd0 00000000`73dccf87 wow64!whNtTerminateProcess+0x46 00000000`0013de00 00000000`73d5276d wow64!Wow64SystemServiceEx+0xd7 00000000`0013e6c0 00000000`73dcd07e wow64cpu!TurboDispatchJumpAddressEnd+0x24 00000000`0013e780 00000000`73dcc549 wow64!RunCpuSimulation+0xa 00000000`0013e7d0 00000000`779884c8 wow64!Wow64LdrpInitialize+0x429 00000000`0013ed20 00000000`77987623 ntdll!LdrpInitializeProcess+0x17e2 00000000`0013f220 00000000`7797308e ntdll! ?? ::FNODOBFM::`string'+0x2bea0 00000000`0013f290 00000000`00000000 ntdll!LdrInitializeThunk+0xe ------------------------------------------------------------------------------------ I hope to have executed exactly as needed the instruction of http://wiki.postgresql.org/wiki/Getting_a_stack_trace_of_a_running_PostgreSQL_backend_on_Windows#Remote_debugging_with_windbg.exe Regards, Andrea Peri.
pgsql-bugs by date: