[postgis-users] psql crashes if bbox is too big

[Sunny Leung]

Follow up onto my problem.

I notice each time a request to the WMS to the postgis datastore, a 
postgres process appear in the server ps list. Below is a capture from top:
2633 postgres   9   0  2100 2100  1700 S     0.0  0.2   0:00 postmaster
2635 postgres   9   0  2060 2060  1664 S     0.0  0.2   0:00 postmaster
2637 postgres   9   0  2092 2092  1668 S     0.0  0.2   0:00 postmaster
3842 postgres   9   0  5072 5072  3616 S     0.0  0.4   0:00 postmaster
3844 postgres   9   0  4852 4852  3596 S     0.0  0.4   0:00 postmaster
3846 postgres   9   0  5044 5044  3596 S     0.0  0.4   0:00 postmaster
3848 postgres   9   0  4852 4852  3596 S     0.0  0.4   0:00 postmaster
3852 postgres   9   0  5048 5048  3596 S     0.0  0.4   0:00 postmaster
3854 postgres   9   0  4856 4856  3596 S     0.0  0.4   0:00 postmaster
3856 postgres   9   0  5048 5048  3596 S     0.0  0.4   0:00 postmaster
3858 postgres   9   0  4856 4856  3596 S     0.0  0.4   0:00 postmaster
3863 postgres   9   0  5048 5048  3596 S     0.0  0.4   0:00 postmaster
3865 postgres   9   0  4860 4860  3600 S     0.0  0.4   0:00 postmaster
3867 postgres   9   0  5052 5052  3600 S     0.0  0.4   0:00 postmaster
3869 postgres   9   0  4860 4860  3600 S     0.0  0.4   0:00 postmaster
3871 postgres   9   0  5052 5052  3600 S     0.0  0.4   0:00 postmaster
3873 postgres   9   0  4860 4860  3600 S     0.0  0.4   0:00 postmaster
3876 postgres   9   0  5052 5052  3600 S     0.0  0.4   0:00 postmaster
3878 postgres   9   0  4860 4860  3600 S     0.0  0.4   0:00 postmaster
3880 postgres   9   0  5052 5052  3600 S     0.0  0.4   0:00 postmaster

I suspect the postgres crashes because of the increase number of 
postgres processes created in the server. After about 10 request to the 
WMS, the postgres crashes.

Is this a configuraiton problem, how can I solve it. Thank you very much.

Best regards,

Sunny Leung


Sunny Leung wrote:

> Dear all,
>
> I have converted a couple of shapefiles to postgis. Currently, I am 
> using geoserver WMS to draw the map from the postgis datastore. I 
> observed, if my bbox is larger than the mapping data itself, the psql 
> server crashes.
>
> I observed the following error messages:
> "psql: could not send startup packet: Broken pipe"
>
> In order to recover the problem, I have to restart the postgres server 
> but the problem reappear if I use a bbox larger than the map data itself.
>
> Would someone give me some directions as to what causes this problem 
> and how this can be resolved. Thank you very much.
>
> Best regards,
>
> Sunny Leung
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users