[mapserver-users] Sporadically "Cannot create OCI handlers"

[Stephan Holl]

Hello,

"Eichner, Andreas - SID-NLKM" <Andreas.Eichner at sid.sachsen.de>,
[20111026 - 12:18:24]

> > @Andreas: I tried without close_connection=defer, and the 
> > error doesn't occur anymore. So it seems like it is solved, 
> > but as you said, kinda hard to debug. The mapserver version 
> > is 5.6.3 and it supports fastcgi. 
> 
> Opening an Oracle connection is rather slow compared to the time MS
> renders the data. Without this option a fresh connection to the DB is
> created for every request and may be even for every layer using such a
> connection. Things tend to be rather slow so I don't think the problem
> is solved. Disabling the option just helps to locate the source of the
> error.
> Do you _use_ FastCGI or only the plain CGI method? I just talked to a
> colleague and he told me that this problem disappeared with MS v6.0.1
> and so seems to be solved there. So you might want to give it a try.

What we have discovered is that FastCGI offers several parameters to
control exactly the allowed connections within a FastCGI-processes.
'Playing' with this parameters made the problem nearly completely
disappear.  Depending on your FastCGI-implementation the relevant
parameter-names my differ.

HTH

	Stephan
-- 
Stephan Holl <stephan.holl at intevation.de> | Tel.: +49 (0)541-33 508 3663
Intevation GmbH, Neuer Graben 17, 49074 OS  |  AG Osnabrück - HR B 18998
Geschäftsführer:  Frank Koormann, Bernhard Reiter, Dr. Jan-Oliver Wagner
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 198 bytes
Desc: not available
URL: <http://lists.osgeo.org/pipermail/mapserver-users/attachments/20111026/703c7189/attachment.sig>