<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
Hello list,<br>
<br>
I have a problem with a mapserver oracle spatial laye: when dynamically
adding a oraclespatial layer with this kind of query:<br>
GEOM FROM (<br>
SELECT<br>
GEO.GEOM, A.*, ID as UNIQUEID<br>
FROM<br>
MAILLES_CIEM GEO ,<br>
(<br>
SELECT<br>
C0.code_geom,<br>
C0.label_metric LT,<br>
C0.valeur VT<br>
FROM<br>
SIH_CARTE_SIG C0<br>
WHERE<br>
1 = 1<br>
and session_id = 'b5b89cbf8a613059c7c41b9796c66c44'<br>
and NUM_COUCHE = '466533b224b29'<br>
and C0.rang = 0<br>
) A<br>
WHERE<br>
1 = 1<br>
and A.code_geom = GEO.CODECIEM<br>
and trim(GEO.CODECIEM) is not null<br>
ORDER BY<br>
GEO.CODECIEM) USING UNIQUE UNIQUEID NONE<br>
<br>
<br>
any mapserver operation leads to mapserver crash. Has anyone faced this
situation?<br>
<br>
<br>
Here is the output of gdb, when performing a $layer->whichShapes().<br>
<br>
_gdb output_<br>
<tt><small>#0 0xb7b7b2ac in free () from /lib/tls/libc.so.6<br>
#1 0xb7b7ccff in malloc () from /lib/tls/libc.so.6<br>
#2 0xb70101d1 in msOracleSpatialLayerWhichShapes ()<br>
from /usr/lib/php5/20060613+lfs/php_mapscript.so<br>
#3 0xb70040e5 in msLayerWhichShapes ()<br>
from /usr/lib/php5/20060613+lfs/php_mapscript.so<br>
#4 0xb6fc87cf in layerObj_whichShapes ()<br>
from /usr/lib/php5/20060613+lfs/php_mapscript.so<br>
#5 0xb6fbb453 in php3_ms_lyr_whichShapes ()<br>
from /usr/lib/php5/20060613+lfs/php_mapscript.so<br>
#6 0xb752972f in execute () from /usr/lib/apache2/modules/libphp5.so<br>
#7 0xb7519128 in execute () from /usr/lib/apache2/modules/libphp5.so<br>
#8 0xb7529111 in execute () from /usr/lib/apache2/modules/libphp5.so<br>
#9 0xb7519128 in execute () from /usr/lib/apache2/modules/libphp5.so<br>
#10 0xb7529111 in execute () from /usr/lib/apache2/modules/libphp5.so<br>
#11 0xb7519128 in execute () from /usr/lib/apache2/modules/libphp5.so<br>
#12 0xb7529111 in execute () from /usr/lib/apache2/modules/libphp5.so<br>
#13 0xb7519128 in execute () from /usr/lib/apache2/modules/libphp5.so<br>
#14 0xb7529111 in execute () from /usr/lib/apache2/modules/libphp5.so<br>
#15 0xb7519128 in execute () from /usr/lib/apache2/modules/libphp5.so</small></tt><br>
<br>
apache.err (mapserver v4.8):<br>
<tt><small>*** glibc detected *** corrupted double-linked list:
0x08f74d30 ***<br>
[Fri Jun 01 16:34:24 2007] [notice] child pid 11105 exit signal Aborted
(6)</small></tt><br>
<br>
<br>
apache.err (mapserver v4.10):<br>
<tt><small>*** glibc detected *** malloc(): memory corruption:
0x08ebe720 ***<br>
[Fri Jun 01 12:20:01 2007] [notice] child pid 1977 exit signal Aborted
(6)<br>
</small></tt><br>
<br>
<br>
<br>
Best regards,<br>
Damien Corpataux<br>
<br>
<br>
<div class="moz-signature">-- <br>
<style>
<!--
.signature {
font-family:verdana,helvetica,sans-serif;
font-size:0.8em;
line-height: 1.25em;
color: #9999BB;
width: 27em;
}
.signature div {
padding: 0.22em;
margin-bottom: 0.5em;
margin-top: 0.5em;
border-bottom: 1px dotted lightgray;
background-color: #FCFCFF;
}
.signature .attention {
background-color: #FFFAFA;
color: #FFBBBB;
font-size: 0.8em;
font-weight: bold;
}
.header {
}
-->
</style>
<div class="signature">
<div> <span style="font-weight: bold;">Camptocamp SA</span><br>
Damien Corpataux<br>
PSE A<br>
CH-1015 Lausanne<br>
</div>
<div> +41 21 619 10 22 <span class="header">(Direct)</span><br>
+41 21 619 10 10 <span class="header">(Centrale)</span><br>
+41 21 619 10 00 <span class="header">(Fax)</span><br>
</div>
<div style="color: rgb(102, 204, 102);"> <span
style="position: relative; top: -3px; font-family: Webdings; font-size: 24pt;">P</span>
<span style="">Please consider the environment <br>
Do you really need to print this email?</span>
</div>
</div>
</div>
</body>
</html>