Hello,
We have geoserver 1.7.7 runnen with 5 oracle connection (OCI) to 1 database (5 different schema’s).
The connections are dropped at some point (we don’t no when this happens).
Is this a problem with geoserver or with Oracle?
Met vriendelijke groet,
Lucas Heezen
Covadis b.v.
t: 026 3616600
Geograaf 12
f: 026 3612317
6921 EW Duiven
On Wed, Feb 8, 2012 at 5:01 PM, Lucas Heezen - Covadis <heezen@anonymised.com.4103…> wrote:
Hello,
We have geoserver 1.7.7 runnen with 5 oracle connection (OCI) to 1 database (5 different schema’s).
The connections are dropped at some point (we don’t no when this happens).
Is this a problem with geoserver or with Oracle?
Uh, old old GeoServer. GeoServer does not drop connections, but Oracle likes to close connections
that are pooled and had been up for a long time.
In current GeoServer versions we have a “validation connection” flag that makes the connection
pool check if the DBMS dropped the connection before using it, but I don’t remeber if that was
available in 1.7.7
Cheers
Andrea
Ing. Andrea Aime
GeoSolutions S.A.S.
Tech lead
Via Poggio alle Viti 1187
55054 Massarosa (LU)
Italy
phone: +39 0584 962313
fax: +39 0584 962313
mob: +39 339 8844549
http://www.geo-solutions.it
http://geo-solutions.blogspot.com/
http://www.youtube.com/user/GeoSolutionsIT
http://www.linkedin.com/in/andreaaime
http://twitter.com/geowolf
Hello Andrea,
We can’t just upgrade, to bad.
But I found a PID log file:
Met vriendelijke groet,
Lucas Heezen
Covadis b.v.
t: 026 3616600
Geograaf 12
f: 026 3612317
6921 EW Duiven
Van: andrea.aime@anonymised.com [mailto:andrea.aime@anonymised.com] Namens Andrea Aime
Verzonden: woensdag 8 februari 2012 17:32
Aan: Lucas Heezen - Covadis
CC: geoserver-users@lists.sourceforge.net
Onderwerp: Re: [Geoserver-users] Oracle Connections lost
On Wed, Feb 8, 2012 at 5:01 PM, Lucas Heezen - Covadis <heezen@anonymised.com> wrote:
Hello,
We have geoserver 1.7.7 runnen with 5 oracle connection (OCI) to 1 database (5 different schema’s).
The connections are dropped at some point (we don’t no when this happens).
Is this a problem with geoserver or with Oracle?
Uh, old old GeoServer. GeoServer does not drop connections, but Oracle likes to close connections
that are pooled and had been up for a long time.
In current GeoServer versions we have a “validation connection” flag that makes the connection
pool check if the DBMS dropped the connection before using it, but I don’t remeber if that was
available in 1.7.7
Cheers
Andrea
Ing. Andrea Aime
GeoSolutions S.A.S.
Tech lead
Via Poggio alle Viti 1187
55054 Massarosa (LU)
Italy
phone: +39 0584 962313
fax: +39 0584 962313
mob: +39 339 8844549
http://www.geo-solutions.it
http://geo-solutions.blogspot.com/
http://www.youtube.com/user/GeoSolutionsIT
http://www.linkedin.com/in/andreaaime
http://twitter.com/geowolf
On Fri, Feb 10, 2012 at 11:58 AM, Lucas Heezen - Covadis <heezen@…4103…> wrote:
OS: Windows Server 2003 family Build 3790 Service Pack 2
CPU:total 1 (1 cores per cpu, 1 threads per core) family 6 model 44 stepping 2, cmov, cx8, fxsr, mmx, sse, sse2, sse3, ssse3, sse4.1, sse4.2, popcnt
Memory: 4k page, physical 3145120k(1980048k free), swap 6131212k(4437104k free)
vm_info: Java HotSpot™ Client VM (20.1-b02) for windows-x86 JRE (1.6.0_26-b03), built on May 4 2011 00:50:59 by “java_re” with MS VC++ 7.1 (VS2003)
time: Fri Feb 10 10:05:44 2012
elapsed time: 85382 seconds
Does this say anything?
That you are using OCI, which relies on native code, that crashed.
Try to use the thin driver (pure java), it’s generally more stable
Cheers
Andrea
Ing. Andrea Aime
GeoSolutions S.A.S.
Tech lead
Via Poggio alle Viti 1187
55054 Massarosa (LU)
Italy
phone: +39 0584 962313
fax: +39 0584 962313
mob: +39 339 8844549
http://www.geo-solutions.it
http://geo-solutions.blogspot.com/
http://www.youtube.com/user/GeoSolutionsIT
http://www.linkedin.com/in/andreaaime
http://twitter.com/geowolf
Okay,
How do i use the thin driver?
Met vriendelijke groet,
Lucas Heezen
Covadis b.v.
t: 026 3616600
Geograaf 12
f: 026 3612317
6921 EW Duiven
Van: andrea.aime@anonymised.com [mailto:andrea.aime@anonymised.com] Namens Andrea Aime
Verzonden: vrijdag 10 februari 2012 12:19
Aan: Lucas Heezen - Covadis
CC: geoserver-users@lists.sourceforge.net
Onderwerp: Re: [Geoserver-users] Oracle Connections lost
On Fri, Feb 10, 2012 at 11:58 AM, Lucas Heezen - Covadis <heezen@anonymised.com> wrote:
OS: Windows Server 2003 family Build 3790 Service Pack 2
CPU:total 1 (1 cores per cpu, 1 threads per core) family 6 model 44 stepping 2, cmov, cx8, fxsr, mmx, sse, sse2, sse3, ssse3, sse4.1, sse4.2, popcnt
Memory: 4k page, physical 3145120k(1980048k free), swap 6131212k(4437104k free)
vm_info: Java HotSpot™ Client VM (20.1-b02) for windows-x86 JRE (1.6.0_26-b03), built on May 4 2011 00:50:59 by “java_re” with MS VC++ 7.1 (VS2003)
time: Fri Feb 10 10:05:44 2012
elapsed time: 85382 seconds
Does this say anything?
That you are using OCI, which relies on native code, that crashed.
Try to use the thin driver (pure java), it’s generally more stable
Cheers
Andrea
Ing. Andrea Aime
GeoSolutions S.A.S.
Tech lead
Via Poggio alle Viti 1187
55054 Massarosa (LU)
Italy
phone: +39 0584 962313
fax: +39 0584 962313
mob: +39 339 8844549
http://www.geo-solutions.it
http://geo-solutions.blogspot.com/
http://www.youtube.com/user/GeoSolutionsIT
http://www.linkedin.com/in/andreaaime
http://twitter.com/geowolf
On Fri, Feb 10, 2012 at 5:18 PM, Lucas Heezen - Covadis <heezen@anonymised.com…4103…> wrote:
Okay,
How do i use the thin driver?
When setting up the oracle data store, use “Oracle” instead of “Oracle OCI”
Cheers
Andrea
Ing. Andrea Aime
GeoSolutions S.A.S.
Tech lead
Via Poggio alle Viti 1187
55054 Massarosa (LU)
Italy
phone: +39 0584 962313
fax: +39 0584 962313
mob: +39 339 8844549
http://www.geo-solutions.it
http://geo-solutions.blogspot.com/
http://www.youtube.com/user/GeoSolutionsIT
http://www.linkedin.com/in/andreaaime
http://twitter.com/geowolf