I checked the sessions from v$session Oracle view. During the time
geoserver was not working correctly I verified that the connections were
opened and INACTIVE on Oracle DB.
Mauro
2013/2/4 Vince Lotito <[email protected]>
> How are you checking oracle's connections?
>
> Vince
>
> Sent from my iPad
>
> On Feb 4, 2013, at 8:49 AM, "[email protected]" <
> [email protected]> wrote:
>
> Hello Andrea,
>
> the option "validate connections" is already checked.
> I am sure the DB does not close connections because I verified that during
> this strange behaviour connections still were there.
> No automatic process is scheduled on the database to kill sessions after a
> certain period of time and no firewall can also do it because the DB and
> the Geoserver are on the same subnet.
>
> What can I do or check to avoid this?
> Thanks
>
> Mauro
>
>
>
> 2013/2/4 Andrea Aime <[email protected]>
>
>> On Mon, Feb 4, 2013 at 12:45 PM, [email protected] <
>> [email protected]> wrote:
>>
>>> I often encounter the following error during which I cannot use
>>> geoserver anymore.
>>> On the database side, I still can view my connections in INACTIVE status.
>>> After few minutes, Geoserver come back to work correctly.
>>>
>>
>> Your Oracle database is closing connections that GeoSever is trying to
>> pool, either
>> because it is set so, or because it has been restarted, or because it is
>> configured to drop
>> them after a certain timeout.
>>
>> The easiest fix is to enable the connection validation in your datastore
>> configuration panel
>>
>> Cheers
>> Andrea
>>
>> --
>> ==
>> Our support, Your Success! Visit http://opensdi.geo-solutions.it for
>> more information.
>> ==
>>
>> Ing. Andrea Aime
>> @geowolf
>> Technical Lead
>>
>> GeoSolutions S.A.S.
>> Via Poggio alle Viti 1187
>> 55054 Massarosa (LU)
>> Italy
>> phone: +39 0584 962313
>> fax: +39 0584 1660272
>> mob: +39 339 8844549
>>
>> http://www.geo-solutions.it
>> http://twitter.com/geosolutions_it
>>
>> -------------------------------------------------------
>>
>
>
>
> --
> Mauro Bagazzi
> SardegnaIT srl
> Viale Trieste 186, Cagliari
> Telefono : +39-0706064365
> E-mail: <[email protected]>
> Skype: mauro.bagazzi
>
>
> ------------------------------------------------------------------------------
> Everyone hates slow websites. So do we.
> Make your web apps faster with AppDynamics
> Download AppDynamics Lite for free today:
> http://p.sf.net/sfu/appdyn_d2d_jan
>
> _______________________________________________
> Geoserver-users mailing list
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/geoserver-users
>
>
--
Mauro Bagazzi
SardegnaIT srl
Viale Trieste 186, Cagliari
Telefono : +39-0706064365
E-mail: <[email protected]>
Skype: mauro.bagazzi
------------------------------------------------------------------------------
Everyone hates slow websites. So do we.
Make your web apps faster with AppDynamics
Download AppDynamics Lite for free today:
http://p.sf.net/sfu/appdyn_d2d_jan
_______________________________________________
Geoserver-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/geoserver-users
