[opencms-dev] Urgent Opencms hangs Oracle 9IAS 9.0.3

[Dariush]

Hi Juan,
maybe your problem is connected with connection closing from connPool.
In this case connections are not closed successfully.
You don't see errors on Oracle Db, but only many threads on 9IAS because 
each of them waits for new available connections, but no more connections 
will be available due to the error closing them.

P.S. Are you able to reproduce the scenario that hangs ORA9IAS?

Dariush.


---------- Original Message -----------
From: Juan David Ayllón Burguillo <jdayllon at gmail.com>
To: The OpenCms mailing list <opencms-dev at opencms.org>
Sent: Thu, 21 Oct 2004 12:45:09 +0200
Subject: Re: [opencms-dev] Urgent Opencms hangs Oracle 9IAS 9.0.3

> Hi!
> 
>   I don't explain very well my problem, my poor english maybe te
> problem :-(, i have been talking with my DBA but he says that Oracle
> app's didn't give any java error or similar in the moment of hang.
> 
> We only see in "ps" that there are about 300% more of "HTTPD" process
> and it doesn't respond to any request, we need to stop entire Oracle
> 9IAS, anything in it responds.
> 
> Thanks in advance.
> 
> On Thu, 21 Oct 2004 11:30:45 +0100, Dariush <dariush at eximia.it> wrote:
> > Hi Alex,
> > my datasource implementation doesn't substitute at all the default 
connpool,
> > but it's an alternative.
> > Simply, you can decide to use it or not (setting 
useDataSource=true/false).
> > If you decide to use DataSource, OpenCms  instantiates DataSourceDriver
> > instead of CmsDriver.
> > If you want the default connPool, you set useDataSource=false.
> > 
> > Moreover, like the default connPool, U need 3 different datasources and
> > their name is the same of orig connPool (for example oracleOci,
> > oracleOcionline, oracleOcibackup).
> > 
> > - For the shell, it can be forced to use connPool even if 
useDataSource=true
> > in opencms.properties
> > 
> > - For setup, simply I think that you should mantain the actual one and 
give
> > the opportunity, in production env, to make it possibile to switch to an
> > external datasource, especially using Oracle, modifying the
> > opencms.properties directly.
> > 
> > Dariush.
> > 
> > 
> > 
> > 
> > ---------- Original Message -----------
> > From: "Alexander Kandzior" <alex at opencms.org>
> > To: "'The OpenCms mailing list'" <opencms-dev at opencms.org>
> > Sent: Thu, 21 Oct 2004 11:13:36 +0200
> > Subject: RE: [opencms-dev] Urgent Opencms hangs Oracle 9IAS 9.0.3
> > 
> > > Especially as all servlet engines nowadays provide Connection Pools,
> > > I find it a bit odd that OpenCMS needs to manage connections on its 
own.
> > >
> > >       Alex ? Any plans on this ?
> > >
> > > For 6 we did replace the self-developed pool with the DBCP from
> > > Apache Jarkarta, which also Tomcat uses for it's own pool (i.e. we
> > > use the same pool that the Tomcat uses for it's datasources).
> > >
> > > There are 2 issues to take into consideration before replacing the 
current
> > > implementation:
> > >
> > > 1) The OpenCms shell runs outside the servlet container. I don't
> > > want to loose this functionality. How do we run the shell if the DB
> > > configuration is only available in the servlet container?
> > >
> > > 2) The setup wizard. Currently the DB configuration is written by
> > > the setup wizard. AFAIK there's no standard way to write a
> > > datasource configuration during servlet container runtime. I don't
> > > want to have the configuration done manually by default, since
> > > apparently even in the current state the setup is an issue for many
> > > people. How do we do the setup wizard with datasources?
> > >
> > > A way to go (for 6.0) could be to have an alternative pool 
implementation
> > > that relys on datasources. This could be configured manually after
> > > (or before?) the setup wizard runs. The pool itself can already be
> > > configured in
> > > 6.0, maybe we would require some slight changes.
> > >
> > > Best Regards,
> > > Alex.
> > >
> > > Alexander Kandzior
> > > Alkacon Software - The OpenCms Experts
> > > http://www.alkacon.com <http://www.alkacon.com/>
> > >
> > > _______________________________________________
> > > 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
> > ------- End of Original Message -------
> > 
> > 
> > 
> > 
> > _______________________________________________
> > 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
> >
> 
> -- 
> Juan David Ayllón Burguillo
> 
> _______________________________________________
> 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
------- End of Original Message -------