Quantcast

Sonar fails when oracle reboots

classic Classic list List threaded Threaded
4 messages Options
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Sonar fails when oracle reboots

dmatag

Hello.

My Sonar fails when Oracle restarts and I have to reboot Tomcat (where sonar.war is located).

Do you know how to configure my pool settings for Oracle 11 reboots don't break Sonar? This is what I have:

#----- Connection pool settings
sonar.jdbc.maxActive:                                      10
sonar.jdbc.maxIdle:                                           3
sonar.jdbc.minIdle:                                            0
sonar.jdbc.maxWait:                                    5000
sonar.jdbc.minEvictableIdleTimeMillis:        180000
sonar.jdbc.timeBetweenEvictionRunsMillis:  30000


Many thanks!!
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: Sonar fails when oracle reboots

Patroklos Papapetrou
Hi David
I think you are facing the issue discussed here
and here 
and I am afraid that Oracle driver doesn't support auto reconnect but you can vote for the relevant issue

Regards


2012/6/25 David Mata <[hidden email]>

Hello.

My Sonar fails when Oracle restarts and I have to reboot Tomcat (where sonar.war is located).

Do you know how to configure my pool settings for Oracle 11 reboots don't break Sonar? This is what I have:

#----- Connection pool settings
sonar.jdbc.maxActive:                                      10
sonar.jdbc.maxIdle:                                           3
sonar.jdbc.minIdle:                                            0
sonar.jdbc.maxWait:                                    5000
sonar.jdbc.minEvictableIdleTimeMillis:        180000
sonar.jdbc.timeBetweenEvictionRunsMillis:  30000


Many thanks!!

Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Antwort: [sonar-user] Sonar fails when oracle reboots

Andreas Schilling
In reply to this post by dmatag
hi David!

we experienced the same problem, there was a thread on this mailinglist some weeks ago.
There already is an issue registered here:
http://jira.codehaus.org/browse/SONAR-3542

So, the Sonar-guys will take care of that :-)

Kind regards,

Andreas Schilling
CAE Processes & Data Management
-------------------------------------------------------------------
Dipl. Inf. Andreas Schilling
Senior Software Architect

TWT GmbH
Science & Innovation
Bernhäuser Str. 40 - 42
73765 Neuhausen

Tel: +49 - 7158 - 17 15 - 673
E-Mail: [hidden email]
--------------------------------------------------------------------
www.twt-gmbh.de
--------------------------------------------------------------------
Geschäftsführung: Dimitrios Vartziotis, Joachim Laicher (stv.)
Registergericht: Amtsgericht Stuttgart, HRB Nr. 212778
Umsatzsteuer: ID-Nr.: DE147841145
--------------------------------------------------------------------




Von:        David Mata <[hidden email]>
An:        [hidden email]
Datum:        25.06.2012 14:04
Betreff:        [sonar-user] Sonar fails when oracle reboots





Hello.

My Sonar fails when Oracle restarts and I have to reboot Tomcat (where sonar.war is located).

Do you know how to configure my pool settings for Oracle 11 reboots don't break Sonar? This is what I have:

#----- Connection pool settings
sonar.jdbc.maxActive:                                      10
sonar.jdbc.maxIdle:                                           3
sonar.jdbc.minIdle:                                            0
sonar.jdbc.maxWait:                                    5000
sonar.jdbc.minEvictableIdleTimeMillis:        180000
sonar.jdbc.timeBetweenEvictionRunsMillis:  30000


Many thanks!!
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: Antwort: [sonar-user] Sonar fails when oracle reboots

dmatag
Thank you all!!

Meanwhile, I'll try a secure Jenkins stop before reboot oracle.


On Mon, Jun 25, 2012 at 2:10 PM, Andreas Schilling <[hidden email]> wrote:
hi David!

we experienced the same problem, there was a thread on this mailinglist some weeks ago.
There already is an issue registered here:
http://jira.codehaus.org/browse/SONAR-3542

So, the Sonar-guys will take care of that :-)

Kind regards,

Andreas Schilling
CAE Processes & Data Management
-------------------------------------------------------------------
Dipl. Inf. Andreas Schilling
Senior Software Architect

TWT GmbH
Science & Innovation
Bernhäuser Str. 40 - 42
73765 Neuhausen

Tel: <a href="tel:%2B49%20-%207158%20-%2017%2015%20-%20673" value="+4971581715673" target="_blank">+49 - 7158 - 17 15 - 673
E-Mail: [hidden email]
--------------------------------------------------------------------
www.twt-gmbh.de
--------------------------------------------------------------------
Geschäftsführung: Dimitrios Vartziotis, Joachim Laicher (stv.)
Registergericht: Amtsgericht Stuttgart, HRB Nr. 212778
Umsatzsteuer: ID-Nr.: DE147841145
--------------------------------------------------------------------




Von:        David Mata <[hidden email]>
An:        [hidden email]
Datum:        25.06.2012 14:04
Betreff:        [sonar-user] Sonar fails when oracle reboots





Hello.

My Sonar fails when Oracle restarts and I have to reboot Tomcat (where sonar.war is located).

Do you know how to configure my pool settings for Oracle 11 reboots don't break Sonar? This is what I have:

#----- Connection pool settings
sonar.jdbc.maxActive:                                      10
sonar.jdbc.maxIdle:                                           3
sonar.jdbc.minIdle:                                            0
sonar.jdbc.maxWait:                                    5000
sonar.jdbc.minEvictableIdleTimeMillis:        180000
sonar.jdbc.timeBetweenEvictionRunsMillis:  30000


Many thanks!!



--
/******************************************/
DAVID MATA GÓRRIZ
Correos personales:
      [hidden email]
      [hidden email]
-----------------------------
Loading...