[Mapserver-users] PHP undef WAS: Memory Leak? Extention

Juanse georef at tie.cl
Fri Jan 31 13:03:35 EST 2003


Here is cloudy, no rain, high humidity, mild, some 22°C, no electricity or
phone/internet problems envisaged, and we are at tuple 169 after 24 hours of
process. We really need to increase speed. All 2322 tuples must be proceed
for next monday, so to create the pdf files to print before next friday, so
the Final Report ships to santiago and is there on monday. We foresee a 31
volumenes 7000 pages long document. Uff!

We are running redhat linux apache server over a PIII 750 MHz, 256 Mb Ram,
40 Gb HD. We have asssembled PostgreSQL/GIS with Mapserver and are scripting
with PHP.

The spatial backend have 15 tables. 1 of 88000 tuples, and the rest between
1.000 and 10.000 tuples. All are Gist indexed.

We will try now daniel morisette system() approach, in the mean time for any
other guru's opinion here goes the code:

<?php

set_time_limit(0);

dl("php_mapscript.so");
function navegar(&$map,$factor,$extension,$mapa_x,$mapa_y) {
        if(is_array($extension)) {
                if(!empty($extension["minx"])
                                && !empty($extension["miny"])
                                && !empty($extension["maxx"])
                                && !empty($extension["maxy"])
                                && !empty($mapa_x)
                                && !empty($mapa_y)
                   ) {
                        $punto = ms_newPointObj();
                        $pre_ext = ms_newRectObj();

$pre_ext->setextent($extension["minx"],$extension["miny"],$extension["maxx"]
,$extension["maxy"]);
                        $sal = $punto->setXY($mapa_x,$mapa_y);
                        $zoom = empty($factor) ? 1 : $factor;
                        $map->zoompoint($zoom,$punto,$map->width,
$map->height, $pre_ext);
                }
        }
}

$conexion = pg_connect("dbname=evidencia user=postgres password=pgsql");
$map = ms_newMapObj("eviden2.map");

$act = "select xmin(the_geom) as minx, xmax(the_geom) as maxx,
ymin(the_geom) as miny, ymax(the_geom) as maxy, gid from
titulosmerced_araucania where imagen is null and usurpada > 0 and gid > 0
order by gid ";
$resultado = pg_exec($conexion,$act);
for($i=0;$extension = pg_fetch_array($resultado,$i);$i++) {
    $capa = $map->getLayer(15);
    $titulo = $capa->getClass(0);
    $titulo->setexpression("\"". $extension["gid"] ."\"");

    $mapa_x = $map->width / 2;
    $mapa_y = $map->height / 2;
    navegar($map,$zoom,$extension,$mapa_x,$mapa_y);
    $img1 = $map->draw();
   $url_mapa = $img1->saveWebImage(MS_PNG, 0, 0, 0);
    $img = $map->drawScaleBar();
    $url_escala = $img->saveWebImage(MS_PNG, 0, 0, 0);
    $img = $map->drawReferenceMap();
    $url_referencia = $img->saveWebImage(MS_PNG, 0, 0, 0);
/*
    $img = $map->drawLegend();
    $url_leyenda = $img->saveWebImage(MS_PNG, 0, 0, 0);
*/
    $updt = "update titulosmerced_araucania set imagen='". $url_mapa . "',
escala='". $url_escala . "', referencia='" . $url_referencia . "' where
gid=".$extension["gid"] . "\n";
    pg_exec($conexion,$updt);
    echo $updt;
}
?>

After processing some 50 tuples, starting at 2 tuples per minute, the memory
is full and the process follows at less than one tuple per hour.

juanse
temuko-Chile



----- Original Message -----
From: Lowell Filak <lfilak at medinaco.org>
To: <mapserver-users at lists.gis.umn.edu>
Sent: Friday, January 31, 2003 2:09 PM
Subject: [Mapserver-users] PHP undef WAS: Memory Leak?


> I will have to forward that request back to the list for the PHP folks to
answer.
> Anyone who can help, please reply to germangutierrezg at yahoo.es .
> Thank you.
>
> The following message was sent by "Juanse" <georef at tie.cl> on Fri, 31 Jan
2003 10:40:56 -0300.
>
> > yes it is, but how to undef/close/destroyed? which command it is not in
the
> > docs.
> >
> >
> > juanse
> > temuko-chile
> >
> > ----- Original Message -----
> > From: Lowell Filak <lfilak at medinaco.org>
> > To: Juanse <georef at tie.cl>; Mapserver-Users
> > <mapserver-users at lists.gis.umn.edu>
> > Sent: Friday, January 31, 2003 10:38 AM
> > Subject: Re: [Mapserver-users] Memory Leak?
> >
> >
> > > Shot in the dark, but is there a possibility that after a map is
created
> > the mapObj is not being undef/closed/destroyed and that is the leak your
> > seeing?
> > > Lowell F.
> > >
> > > The following message was sent by "Juanse" <georef at tie.cl> on Fri, 31
Jan
> > 2003 10:27:27 -0300.
> > >
> > > > Hi everyone
> > > >
> > > > We have build this "mapmaker machine" scripting mapserver with php.
> > > >
> > > > The mapmaker machine need to do 2322 maps, comprised of a.- the map,
b
> > the
> > > > legend, c.- the reference map.
> > > > The application created the regional map (10 layers, 2 with thematic
> > clases)
> > > > then centers over the specified spot (center of each of 2322
polygons in
> > one
> > > > of the layers stored in postgresql).
> > > > Then mapserver render the 3 images (png) and stores the *.png files
in a
> > > > file and the file names in the speceified columns in the postgresql
> > table.
> > > >
> > > > if one check the process (top) the memory fill up after 90 spots,
and
> > then
> > > > the whole machine work very slowly (20 maps per night). At this
speed we
> > > > need more than a 100 days to finish?
> > > >
> > > > Is there any command to free mapserver from memory? Does mapserver
have
> > any
> > > > know memory leaks?
> > > >
> > > >
> > > > Juanse
> > > > temuko-Chile
> > > >
> > > >
> > > >
> > > > ---
> > > > Outgoing mail is certified Virus Free.
> > > > Checked by AVG anti-virus system (http://www.grisoft.com).
> > > > Version: 6.0.445 / Virus Database: 250 - Release Date: 21/01/03
> > > >
> > > > _______________________________________________
> > > > Mapserver-users mailing list
> > > > Mapserver-users at lists.gis.umn.edu
> > > > http://lists.gis.umn.edu/mailman/listinfo/mapserver-users
> > >
> >
> >
> > ---
> > Outgoing mail is certified Virus Free.
> > Checked by AVG anti-virus system (http://www.grisoft.com).
> > Version: 6.0.445 / Virus Database: 250 - Release Date: 21/01/03
>
> _______________________________________________
> Mapserver-users mailing list
> Mapserver-users at lists.gis.umn.edu
> http://lists.gis.umn.edu/mailman/listinfo/mapserver-users


---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.445 / Virus Database: 250 - Release Date: 21/01/03




More information about the mapserver-users mailing list