Mapserver + oracle spatial

[Damien Corpataux]

Hello list,

I have a problem with a mapserver oracle spatial laye: when dynamically
adding a oraclespatial layer with this kind of query:
GEOM FROM (
SELECT
    GEO.GEOM, A.*, ID as UNIQUEID
FROM
    MAILLES_CIEM GEO ,
    (
        SELECT
            C0.code_geom,
            C0.label_metric LT,
            C0.valeur VT
        FROM
            SIH_CARTE_SIG C0
        WHERE
            1 = 1
            and session_id = 'b5b89cbf8a613059c7c41b9796c66c44'
            and NUM_COUCHE = '466533b224b29'
            and C0.rang = 0
    ) A
WHERE
    1 = 1
    and A.code_geom = GEO.CODECIEM
    and trim(GEO.CODECIEM) is not null
ORDER BY
    GEO.CODECIEM) USING UNIQUE UNIQUEID NONE


any mapserver operation leads to mapserver crash. Has anyone faced this
situation?


Here is the output of gdb, when performing a $layer->whichShapes().

_gdb output_
#0  0xb7b7b2ac in free () from /lib/tls/libc.so.6
#1  0xb7b7ccff in malloc () from /lib/tls/libc.so.6
#2  0xb70101d1 in msOracleSpatialLayerWhichShapes ()
   from /usr/lib/php5/20060613+lfs/php_mapscript.so
#3  0xb70040e5 in msLayerWhichShapes ()
   from /usr/lib/php5/20060613+lfs/php_mapscript.so
#4  0xb6fc87cf in layerObj_whichShapes ()
   from /usr/lib/php5/20060613+lfs/php_mapscript.so
#5  0xb6fbb453 in php3_ms_lyr_whichShapes ()
   from /usr/lib/php5/20060613+lfs/php_mapscript.so
#6  0xb752972f in execute () from /usr/lib/apache2/modules/libphp5.so
#7  0xb7519128 in execute () from /usr/lib/apache2/modules/libphp5.so
#8  0xb7529111 in execute () from /usr/lib/apache2/modules/libphp5.so
#9  0xb7519128 in execute () from /usr/lib/apache2/modules/libphp5.so
#10 0xb7529111 in execute () from /usr/lib/apache2/modules/libphp5.so
#11 0xb7519128 in execute () from /usr/lib/apache2/modules/libphp5.so
#12 0xb7529111 in execute () from /usr/lib/apache2/modules/libphp5.so
#13 0xb7519128 in execute () from /usr/lib/apache2/modules/libphp5.so
#14 0xb7529111 in execute () from /usr/lib/apache2/modules/libphp5.so
#15 0xb7519128 in execute () from /usr/lib/apache2/modules/libphp5.so

apache.err (mapserver v4.8):
*** glibc detected *** corrupted double-linked list: 0x08f74d30 ***
[Fri Jun 01 16:34:24 2007] [notice] child pid 11105 exit signal Aborted (6)


apache.err (mapserver v4.10):
*** glibc detected *** malloc(): memory corruption: 0x08ebe720 ***
[Fri Jun 01 12:20:01 2007] [notice] child pid 1977 exit signal Aborted (6)




Best regards,
Damien Corpataux


-- 
Camptocamp SA
Damien Corpataux
PSE A
CH-1015 Lausanne
+41 21 619 10 22 (Direct)
+41 21 619 10 10 (Centrale)
+41 21 619 10 00 (Fax)
P Please consider the environment
Do you really need to print this email?
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/mapserver-users/attachments/20070605/044f0e6a/attachment.htm>