[postgis-devel] [PostGIS] #518: Postgres backend terminated by exception 0xC0000005
PostGIS
trac at osgeo.org
Tue May 4 08:13:04 PDT 2010
#518: Postgres backend terminated by exception 0xC0000005
------------------------------------------+---------------------------------
Reporter: loldrup | Owner: pramsey
Type: defect | Status: new
Priority: critical | Milestone:
Component: postgis | Version: 1.4.X
Keywords: backend terminated exception |
------------------------------------------+---------------------------------
We are running a postgis production installation ("PostgreSQL 8.4.2,
compiled by Visual C++ build 1400, 32-bit"
/ "POSTGIS="1.4.1" GEOS="3.2.0-CAPI-1.6.0" PROJ="Rel. 4.6.1, 21 August
2008" USE_STATS") on a window box, where the database dies a couple
of times per week with the following exception: 2010-05-03 14:43:03 CEST
10032 LOG: server process (PID 2492) was terminated by exception
0xC0000005
I have finally been able reproduce the error using JMeter configured with
5 connections. The error is triggered by two selects using
insersect with the same WKT polygon:
The 1. select:
SELECT AsText(force_2d(Envelope(Extent("geom"))))
FROM "schema"."mytable"
WHERE "geom" && GeometryFromText('POLYGON ((725024.0573763638
6188750.973059048, 725024.0573763638 6188753.700331775, 725026.7846490908
6188753.700331775, 725026.7846490908 6188750.973059048, 725024.0573763638
6188750.973059048))', 25832)
AND intersects("geom", GeometryFromText('POLYGON ((725024.0573763638
6188750.973059048, 725024.0573763638 6188753.700331775, 725026.7846490908
6188753.700331775, 725026.7846490908 6188750.973059048, 725024.0573763638
6188750.973059048))', 25832));
,and the second select:
SELECT "oid", "id", "geom"
FROM "schema"."mytable"
WHERE "geom" && GeometryFromText('POLYGON ((725024.0573763638
6188750.973059048, 725024.0573763638 6188753.700331775, 725026.7846490908
6188753.700331775, 725026.7846490908 6188750.973059048, 725024.0573763638
6188750.973059048))', 25832)
AND intersects("geometri", GeometryFromText('POLYGON ((725024.0573763638
6188750.973059048, 725024.0573763638 6188753.700331775, 725026.7846490908
6188753.700331775, 725026.7846490908 6188750.973059048, 725024.0573763638
6188750.973059048))', 25832));
I have created a stack-trace, but my installation does not contain any
symbols for postgis, but here it is:
Microsoft (R) Windows Debugger Version 6.12.0002.633 X86
Copyright (c) Microsoft Corporation. All rights reserved.
*** wait with pending attach
Symbol search path is:
c:\postgres8.4\symbols;SRV*c:\localsymbols*http://msdl.microsoft.com/download/symbols
Executable search path is:
ModLoad: 00400000 008b0000 C:\postgres8.4\bin\postgres.exe
ModLoad: 7c900000 7c9b2000 C:\WINDOWS\system32\ntdll.dll
ModLoad: 7c800000 7c8f6000 C:\WINDOWS\system32\kernel32.dll
ModLoad: 10000000 10034000 C:\postgres8.4\bin\SSLEAY32.dll
ModLoad: 002a0000 0039f000 C:\postgres8.4\bin\LIBEAY32.dll
ModLoad: 71ad0000 71ad9000 C:\WINDOWS\system32\WSOCK32.dll
ModLoad: 71ab0000 71ac7000 C:\WINDOWS\system32\WS2_32.dll
ModLoad: 77dd0000 77e6b000 C:\WINDOWS\system32\ADVAPI32.dll
ModLoad: 77e70000 77f02000 C:\WINDOWS\system32\RPCRT4.dll
ModLoad: 77fe0000 77ff1000 C:\WINDOWS\system32\Secur32.dll
ModLoad: 77c10000 77c68000 C:\WINDOWS\system32\msvcrt.dll
ModLoad: 71aa0000 71aa8000 C:\WINDOWS\system32\WS2HELP.dll
ModLoad: 77f10000 77f59000 C:\WINDOWS\system32\GDI32.dll
ModLoad: 7e410000 7e4a1000 C:\WINDOWS\system32\USER32.dll
ModLoad: 78130000 781cb000
C:\WINDOWS\WinSxS\x86_Microsoft.VC80.CRT_1fc8b3b9a1e18e3b_8.0.50727.
4053_x-ww_e6967989\MSVCR80.dll
ModLoad: 61cc0000 61cd3000 C:\postgres8.4\bin\libintl-8.dll
ModLoad: 66000000 660e8000 C:\postgres8.4\bin\libiconv-2.dll
ModLoad: 1c000000 1c09b000 C:\postgres8.4\bin\krb5_32.dll
ModLoad: 003b0000 003b7000 C:\postgres8.4\bin\comerr32.dll
ModLoad: 003c0000 003c8000 C:\postgres8.4\bin\k5sprt32.dll
ModLoad: 7c340000 7c396000 C:\postgres8.4\bin\MSVCR71.dll
ModLoad: 003d0000 003f1000 C:\postgres8.4\bin\gssapi32.dll
ModLoad: 00cb0000 00da1000 C:\postgres8.4\bin\libxml2.dll
ModLoad: 00db0000 00e89000 C:\postgres8.4\bin\iconv.dll
ModLoad: 00e90000 00ea3000 C:\postgres8.4\bin\zlib1.dll
ModLoad: 76f60000 76f8c000 C:\WINDOWS\system32\WLDAP32.dll
ModLoad: 76390000 763ad000 C:\WINDOWS\system32\IMM32.DLL
ModLoad: 71a50000 71a8f000 C:\WINDOWS\system32\mswsock.dll
ModLoad: 662b0000 66308000 C:\WINDOWS\system32\hnetcfg.dll
ModLoad: 71a90000 71a98000 C:\WINDOWS\System32\wshtcpip.dll
ModLoad: 6adc0000 6ae4f000 C:\postgres8.4\lib\postgis-1.4.dll
ModLoad: 70040000 700ad000 C:\postgres8.4\bin\libgeos_c-1.dll
ModLoad: 704c0000 70662000 C:\postgres8.4\bin\libgeos-3-2-0.dll
ModLoad: 040d0000 04109000 C:\postgres8.4\bin\libproj.dll
(efc.e7c): Break instruction exception - code 80000003 (first chance)
eax=7ffd5000 ebx=00000001 ecx=00000002 edx=00000003 esi=00000004
edi=00000005
eip=7c90120e esp=0413ffcc ebp=0413fff4 iopl=0 nv up ei pl zr na pe
nc
cs=001b ss=0023 ds=0023 es=0023 fs=0038 gs=0000
efl=00000246
ntdll!DbgBreakPoint:
7c90120e cc int 3
0:003> g
(efc.d64): Access violation - code c0000005 (first chance)
First chance exceptions are reported before any exception handling.
This exception may be expected and handled.
eax=0088ee74 ebx=03f7c238 ecx=00000001 edx=0000234c esi=03f8a000
edi=03f533c0
eip=6addae49 esp=00caf3e0 ebp=00caf488 iopl=0 nv up ei pl zr na pe
nc
cs=001b ss=0023 ds=0023 es=0023 fs=003b gs=0000
efl=00010246
*** ERROR: Symbol file could not be found. Defaulted to export symbols
for C:\postgres8.4\lib\postgis-1.4.dll -
postgis_1_4!GetPrepGeomCache+0x149:
6addae49 f3a5 rep movs dword ptr es:[edi],dword ptr [esi]
0:000> ~*k
. 0 Id: efc.d64 Suspend: 1 Teb: 7ffdf000 Unfrozen
ChildEBP RetAddr
WARNING: Stack unwind information not available. Following frames may be
wrong.
00caf488 6add7722 postgis_1_4!GetPrepGeomCache+0x149
00caf4f8 004dce39 postgis_1_4!intersects+0x102
00caf774 004dcea3 postgres!ExecMakeFunctionResult+0x459 [c:\pginstaller-
repo\postgres.windows\src\backend\executor\execqual.c @ 1686]
00caf798 004dc108 postgres!ExecEvalFunc+0x33 [c:\pginstaller-
repo\postgres.windows\src\backend\executor\execqual.c @ 2116]
00caf7bc 004dff9c postgres!ExecQual+0x38 [c:\pginstaller-
repo\postgres.windows\src\backend\executor\execqual.c @ 4909]
00caf7e0 004e97f7 postgres!ExecScan+0xac [c:\pginstaller-
repo\postgres.windows\src\backend\executor\execscan.c @ 131]
00caf7f0 004d84a9 postgres!ExecIndexScan+0x27 [c:\pginstaller-
repo\postgres.windows\src\backend\executor\nodeindexscan.c @ 159]
00caf800 004ec2d7 postgres!ExecProcNode+0xa9 [c:\pginstaller-
repo\postgres.windows\src\backend\executor\execprocnode.c @ 367]
00caf828 004d8529 postgres!ExecNestLoop+0x67 [c:\pginstaller-
repo\postgres.windows\src\backend\executor\nodenestloop.c @ 120]
00caf838 004ec2d7 postgres!ExecProcNode+0x129 [c:\pginstaller-
repo\postgres.windows\src\backend\executor\execprocnode.c @ 404]
00caf860 004d8529 postgres!ExecNestLoop+0x67 [c:\pginstaller-
repo\postgres.windows\src\backend\executor\nodenestloop.c @ 120]
00caf870 004ec2d7 postgres!ExecProcNode+0x129 [c:\pginstaller-
repo\postgres.windows\src\backend\executor\execprocnode.c @ 404]
00caf898 004d8529 postgres!ExecNestLoop+0x67 [c:\pginstaller-
repo\postgres.windows\src\backend\executor\nodenestloop.c @ 120]
00caf8a8 004ec2d7 postgres!ExecProcNode+0x129 [c:\pginstaller-
repo\postgres.windows\src\backend\executor\execprocnode.c @ 404]
00caf8d0 004d8529 postgres!ExecNestLoop+0x67 [c:\pginstaller-
repo\postgres.windows\src\backend\executor\nodenestloop.c @ 120]
00caf8e0 004ec2d7 postgres!ExecProcNode+0x129 [c:\pginstaller-
repo\postgres.windows\src\backend\executor\execprocnode.c @ 404]
00caf908 004d8529 postgres!ExecNestLoop+0x67 [c:\pginstaller-
repo\postgres.windows\src\backend\executor\nodenestloop.c @ 120]
00caf918 004ec2d7 postgres!ExecProcNode+0x129 [c:\pginstaller-
repo\postgres.windows\src\backend\executor\execprocnode.c @ 404]
00caf940 004d8529 postgres!ExecNestLoop+0x67 [c:\pginstaller-
repo\postgres.windows\src\backend\executor\nodenestloop.c @ 120]
00caf950 004ec2d7 postgres!ExecProcNode+0x129 [c:\pginstaller-
repo\postgres.windows\src\backend\executor\execprocnode.c @ 404]
00caf978 004d8529 postgres!ExecNestLoop+0x67 [c:\pginstaller-
repo\postgres.windows\src\backend\executor\nodenestloop.c @ 120]
00caf988 004ec2d7 postgres!ExecProcNode+0x129 [c:\pginstaller-
repo\postgres.windows\src\backend\executor\execprocnode.c @ 404]
00caf9b0 004d8529 postgres!ExecNestLoop+0x67 [c:\pginstaller-
repo\postgres.windows\src\backend\executor\nodenestloop.c @ 120]
00caf9c0 004e4142 postgres!ExecProcNode+0x129 [c:\pginstaller-
repo\postgres.windows\src\backend\executor\execprocnode.c @ 404]
00cafa04 004d8586 postgres!agg_retrieve_direct+0x62 [c:\pginstaller-
repo\postgres.windows\src\backend\executor\nodeagg.c @ 884]
00cafa14 004d71e3 postgres!ExecProcNode+0x186 [c:\pginstaller-
repo\postgres.windows\src\backend\executor\execprocnode.c @ 431]
00cafa70 004d763a postgres!ExecutePlan+0x93 [c:\pginstaller-
repo\postgres.windows\src\backend\executor\execmain.c @ 1504]
00cafa9c 005c996a postgres!standard_ExecutorRun+0x7a [c:\pginstaller-
repo\postgres.windows\src\backend\executor\execmain.c @ 314]
00cafac0 005c9f2f postgres!PortalRunSelect+0x6a [c:\pginstaller-
repo\postgres.windows\src\backend\tcop\pquery.c @ 954]
00cafb3c 005c5f92 postgres!PortalRun+0x14f [c:\pginstaller-
repo\postgres.windows\src\backend\tcop\pquery.c @ 782]
00cafbec 005c7a68 postgres!exec_execute_message+0x312 [c:\pginstaller-
repo\postgres.windows\src\backend\tcop\postgres.c @ 1935]
00cafcd0 00595544 postgres!PostgresMain+0xd38 [c:\pginstaller-
repo\postgres.windows\src\backend\tcop\postgres.c @ 3671]
00cafd20 00597fa4 postgres!BackendRun+0x204 [c:\pginstaller-
repo\postgres.windows\src\backend\postmaster\postmaster.c @ 3450]
00caff60 00504167 postgres!SubPostmasterMain+0x224 [c:\pginstaller-
repo\postgres.windows\src\backend\postmaster\postmaster.c @ 3941]
00caff7c 006ba55d postgres!main+0x177 [c:\pginstaller-
repo\postgres.windows\src\backend\main\main.c @ 165]
00caffc0 7c817077 postgres!__tmainCRTStartup+0x10f
[f:\sp\vctools\crt_bld\self_x86\crt\src\crtexe.c @ 597]
00cafff0 00000000 kernel32!BaseProcessStart+0x23
1 Id: efc.dac Suspend: 1 Teb: 7ffde000 Unfrozen
ChildEBP RetAddr
0164fecc 7c90d3aa ntdll!KiFastSystemCallRet
0164fed0 7c8314ae ntdll!ZwFsControlFile+0xc
0164ff14 0058955f kernel32!ConnectNamedPipe+0x52
0164ffb4 7c80b729 postgres!pg_signal_thread+0x9f [c:\pginstaller-
repo\postgres.windows\src\backend\port\win32\signal.c @ 275]
0164ffec 00000000 kernel32!BaseThreadStart+0x37
2 Id: efc.ed8 Suspend: 1 Teb: 7ffdd000 Unfrozen
ChildEBP RetAddr
03ecff2c 7c90df5a ntdll!KiFastSystemCallRet
03ecff30 7c8025db ntdll!ZwWaitForSingleObject+0xc
03ecff94 0058ab6b kernel32!WaitForSingleObjectEx+0xa8
03ecffb4 7c80b729 postgres!pg_timer_thread+0x2b [c:\pginstaller-
repo\postgres.windows\src\backend\port\win32\timer.c @ 51]
03ecffec 00000000 kernel32!BaseThreadStart+0x37
--
Ticket URL: <http://trac.osgeo.org/postgis/ticket/518>
PostGIS <http://trac.osgeo.org/postgis/>
The PostGIS Trac is used for bug, enhancement & task tracking, a user and developer wiki, and a view into the subversion code repository of PostGIS project.
More information about the postgis-devel
mailing list