[mapserver-users] Problem big filteritem (apache crash)

[Fawcett, David]

If you take the query that MapServer is creating and run it directly
against Oracle, does it work?  
 
I seem to remember that Oracle has a limit on the number or elements or
characters allowed in IN statements.  The limit is 1000 'expressions' in
an IN condition.  
 
If you care to RTM:
http://download.oracle.com/docs/cd/B19306_01/server.102/b14200/expressio
ns014.htm#i1033664
 
You are going to have to come up with another way to write your filter
query.
 
David.
 
 
-----Original Message-----
From: mapserver-users-bounces at lists.osgeo.org
[mailto:mapserver-users-bounces at lists.osgeo.org] On Behalf Of I-Real -
Rob ter Haar
Sent: Wednesday, September 16, 2009 4:16 AM
To: mapserver
Subject: [mapserver-users] Problem big filteritem (apache crash)



	Hello All,
	
	I have a problem with a filteritem witch contains +/- 11000
characters. This are id's of points which I would show on a map. When I
called the page apache crasht. And in the coredump I see the following:
	
	#0  0x00cf15bc in mempcpy () from /lib/libc.so.6
	No symbol table info available.
	#1  0x00ce6558 in _IO_default_xsputn_internal () from
/lib/libc.so.6
	No symbol table info available.
	#2  0x00cc2bd8 in vfprintf () from /lib/libc.so.6
	No symbol table info available.
	#3  0x00cdbd4c in vsprintf () from /lib/libc.so.6
	No symbol table info available.
	#4  0x00cc853e in sprintf () from /lib/libc.so.6
	No symbol table info available.
	#5  0x070fa3f5 in msOracleSpatialLayerWhichShapes
(layer=0x36393639, rect=
	      {minx = 1.7223872351905284e-47, miny =
1.1808818690463142e-95, maxx = 2.0056059668611313e-76, maxy =
2.7151806783827087e-33}) at maporaclespatial.c:670
	        success = <value optimized out>
	        i = -1081417209
	        function = 959197241
	        version = 909716537
	        query_str = "SELECT LOCATIEID, alarm_actief, NAAM, SHAPE
FROM (SELECT L.LOCATIEID AS LOCATIEID, LG.SHAPE, L.NAAM AS NAAM,
L.ADRES, L.PLAATS, alarm.NAAM Laatste_alarm,
unixts_to_date(Alarm.TIJDSTIP_HOOG) Actief_sin"...
	        table_name =
",4992,4993,4994,4995,4996,4997,4998,4999,5000,5001,5002,5003,5035,5036,
5037,5038,5039,5040,5041,5042,5043,5044,5045,5046,5047,5048,5049,5050,50
51,5052,5053,5054,5055,5056,5113,5396,5546,5547,5548,5549"...
	        geom_column_name =
",9647,9648,9649,9654,9655,9656,9657,9658,9659,9660,9661,9662,9663,9664,
9665,9669,9670,9671,9672,9688"
	        unique =
",9624,9625,9626,9627,9628,9629,9630,9631,9632,9633,9634,9635,9636,9637,
9641,9642,9643,9644,9645,9646"
	        srid =
",9604,9605,9606,9607,9608,9609,9610,9611,9612,9613,9614,9615,9616,9617,
9618,9619,9620,9621,9622,9623"
	        adtp = (OCIDefine *) 0x3836392c
	        items = (OCIDefine **) 0x93b5560
	        dthand = (msOracleSpatialDataHandler *) 0x938e930
	        hand = (msOracleSpatialHandler *) 0x9436080
	
	In the fields Table_name, geon_colomn_name, unique  and srid are
filled with the string I assign to FilterItem.
	
	Is this a bug or do I make a mistake?
	
	I use the mapscript (php) to assign the variables.
	
	Can anyone help me?
	
	Met vriendelijke groet,
	Rob ter Haar
	
	I-Real
	Postbus 593
	7000 AN Doetinchem
	T: +31 (0)314 366600
	F: +31 (0)314 363410
	E: r.terhaar at i-real.nl
	I: www.i-real.nl
	
	
	De informatie in dit e-mailbericht is uitsluitend bestemd voor
de geadresseerde.
	Verstrekking aan en gebruik door anderen is niet toegestaan.
	Door de elektronische verzending van het bericht, kunnen er geen
rechten worden ontleend aan de informatie. 




-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.osgeo.org/pipermail/mapserver-users/attachments/20090916/35b54cfe/attachment-0001.html