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

[Gerry Creager N5JXS]

I've often had more than 10 outstanding postgis requests up.  What sort 
of machine, memory, etc?  Sounds like a resources issue.  Have you run 
'top' and seen what is going on?

gerry

Sunny Leung wrote:
> 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
> 
> 
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users

-- 
Gerry Creager -- gerry.creager at tamu.edu
Network Engineering -- AATLT, Texas A&M University	
Cell: 979.229.5301 Office: 979.458.4020 FAX: 979.847.8578
Page: 979.228.0173
Office: 903A Eller Bldg, TAMU, College Station, TX 77843