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: [email protected]
[mailto:[email protected]] 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: [email protected]
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.
_______________________________________________
mapserver-users mailing list
[email protected]
http://lists.osgeo.org/mailman/listinfo/mapserver-users
