Antwort: Re: [opencms-dev] Problem for (re)starting OpenCms

[Thomas.Breder at sbroker.de]

Hi Niklas,

we are using an Oracle 9 DB, too. And we have the same problems. Will you
share your new version of OpenCms with us, so that we can help you testing?

Mit freundlichen Grüßen

Thomas Breder

____________________________________________________

S Broker AG
Information Technology

Tel.: +49 (0)203/289-2120 (Duisburg)
Tel.: +49 (0)611/2044-2120 (Wiesbaden)
Fax: +49 (0)203/289-2099 (Duisburg)
thomas.breder at sbroker.de



|---------+----------------------------->
|         |           Niklas Eklund     |
|         |           <niklas at curalia.se|
|         |           >                 |
|         |           Gesendet von:     |
|         |           opencms-dev-admin@|
|         |           opencms.org       |
|         |                             |
|         |                             |
|         |           14.07.2003 13:31  |
|         |           Bitte antworten an|
|         |           opencms-dev       |
|         |                             |
|---------+----------------------------->
  >------------------------------------------------------------------------------------------------------------------------------|
  |                                                                                                                              |
  |       An:       opencms-dev at opencms.org                                                                                      |
  |       Kopie:                                                                                                                 |
  |       Thema:    Re: [opencms-dev] Problem for (re)starting OpenCms                                                           |
  >------------------------------------------------------------------------------------------------------------------------------|




Brendon et al,

I've had the same, or similar maybe, problem (with Oracle 9) as well and
traced it to some sort of deadlock in the java.sql.DriverManager. The
system frooze with a couple of threads waiting in
DriverManager.getConnection() and another in DriverManager.getDrivers().
The call to getDrivers() is done by the Oracle driver in it's connect()
method()...
After searching (for "DriverManager") at Sun's Java bugparade it was
clear that there is a problem with the DriverManager class and that Sun
treats this as "Not a bug", and the only workaround seems to be to use
the new DataSource paradigm instead.
Since the pool already seems to be thrown out in the development branch,
this will be resolved in the future. I ended up replacing the calls (all
239 of them ;) to DriverManager.getConnection() with another static
method call that uses a DataSource type pool configured in tomcat. This
seems to work for us, but haven't yet been thorougly tested...

Regards,

  Niklas

Brendon Price wrote:
> Hi all,
>
> We had also encountered this problem previously and had spent several
days
> trying to resolve the issue. In the end we added extensive debug code to
the
> connection pool code of opencms. It appeared that the code hangs on the
> re-establishment of the connections in the connection pool. This is the
> point at which it times out the connections and re-estabilshes them. We
> could get the product to break every 2 minutes by reducing the timeout of
> connections down to 2 minutes.
>
> In the end it was it appeared that the code fails within the JDBC
connection
> creation. In the end we found an article that suggested we increase the
> number of file handles available to the Oracle 9i process (our DB). Once
we
> did this our problem disappeared, however I think there is something else
at
> work here that means we may have just hidden the symptoms of the real
> problem.
>
> We made a changes to the
> /etc/sysctl.conf
> file and increased the number of file handles by adding the line
>
> fs.file-max=32768
>
> After a restart of the whole machine, the problem did not occur again,
even
> with our previous test case (that failed every 2 minutes).
>
> I hope this helps.
>
> Regards
> Brendon
>
>
> -----Original Message-----
> From: Nicolas Delsaux
> To: opencms-dev at opencms.org
> Sent: 11/07/2003 9:40 p.m.
> Subject: Re: [opencms-dev] Problem for (re)starting OpenCms
>
> On Fri, 11 Jul 2003 10:23:54 +0200 (CEST), Joachim Arrasz
> <info at arrasz.de>
> wrote:
>
>
>>Hy Nicolas,
>>
>>what was your solution to this crazy thing?
>>How we can configurate Opencms to do that NOT?
>
>
> I've not yet found any kind of solution; In fact, the problem is
> currently
> being corrected by a Tomcat restart each night.
> But, if anybody can have any idea on that problem, I'm willing to apply
> it
> as soon as possible.
>
>>thanx in advance
>>
>>Achim
>
>
>


_______________________________________________
This mail is send to you from the opencms-dev mailing list
To change your list options, or to unsubscribe from the list, please visit
http://mail.opencms.org/mailman/listinfo/opencms-dev




* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
S Broker AG * Beekstraße 38-42 * 47051 Duisburg
service at sbroker.de * www.sbroker.de

Sitz Wiesbaden * Amtsgericht Wiesbaden * HRB 20591 * BLZ 300 301 00

Vorstand:
Klaus Schöniger (Sprecher)
Dr. Raoul G. Wild
Karl-Martin im Brahm

Vorsitzender des Aufsichtsrats:
Dr. Harald Quensen

Diese E-Mail enthält vertrauliche und/oder rechtlich geschützte
Informationen. Wenn Sie nicht der richtige Adressat sind oder diese
E-Mail irrtümlich erhalten haben, informieren Sie bitte sofort den
Absender und vernichten Sie diese Mail. Das unerlaubte Kopieren
sowie die unbefugte Weitergabe dieser Mail ist nicht gestattet.