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

[Pavel Iacovlev]

If you use mapscript you can: Insert your "items" in a a separate
table and then just do a SELECT * FROM table where id in (SELECT id
from TABLE_WITH_YOUR_FILTER_IDS)

On Wed, Sep 16, 2009 at 12:16 PM, I-Real - Rob ter Haar
<r.terhaar at i-real.nl> wrote:
> 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,5051,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.
>
>
>
> _______________________________________________
> mapserver-users mailing list
> mapserver-users at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/mapserver-users
>
>



-- 
http://iap.md, The future is open