We are currently experiencing a problem when we restart where the ConnectionPools to Oracle take a long time to be established and cause a long delay for our production machine to start. It almost feels like the old ConnectionPools have to timeout, even though we have shut the entire Resin instance down and restarted the entire JVM.
When I saw your post below I got excited because it's very similar to the issue we are having, but we don't have the SQLRecoverableException anywhere that I am seeing. Also it's not really undeterministic -- it always happens. How long the connections to Oracle take are sort of random, but it's way too long. When I went into /resin-admin/ I see that this is implicitly being set: <jvm-arg>-Djava.security.egd=/dev/urandom</jvm-arg> So adding your argument won't help us. Any other ideas on what could cause resin-4.0.18 to take so darn long to fire up as regards connection to Oracle 11g? Thanks, -a > -----Original Message----- > From: resin-interest-boun...@caucho.com [mailto:resin-interest- > boun...@caucho.com] On Behalf Of Daniel López > Sent: Wednesday, September 28, 2011 10:13 AM > To: General Discussion for the Resin application server > Subject: Re: [Resin-interest] Something interesting for People using Resin > with Oracle > > Good to know Alan, thanks. > > Who would have thought servers accessing databases might be located in > dedicated machines? Way to go, Oracle! :D > > S! > D. > > > El 28/09/2011 16:19, Alan Wright escribió: > > At the same time as upgrading to Resin 4 we are upgrading to Oracle 11gR2. > > > > Starting/stopping resin was very non-deterministic seeming to hang > > sometimes during application startup with references to connection > > timeouts in the error logs. > > > > SQLRecoverableException: IO Error: Connection reset > > > > The problem was traced to a drying up of the "entropy poll" preventing > > oracle jdbc from allocating connections until the pool was replenished > > > > The following article explains in full > > > > http://www.usn-it.de/index.php/2009/02/20/oracle-11g-jdbc-driver-hangs > > -blocked-by-devrandom-entropy-pool-empty > > > > The solution was to add the following to resin.xml > > > > <!-- Deal with problems associated with 11G JDBC driver new connection > > requires random number but generator uses entropy pool filled by > > random user actions - server has no connected user so entropy pool > > often empty.... --> > > > > > > <jvm-arg>-Djava.security.egd=file:///dev/urandom</jvm-arg> > > > > > > > > Hope this helps someone. > > > > Alan > > > > > > > > > -- > ------------------------------------------- > Daniel Lopez Janariz (d.lo...@uib.es) > Web Services > Centre for Information and Technology > Balearic Islands University > (SPAIN) > ------------------------------------------- > > > _______________________________________________ > resin-interest mailing list > resin-interest@caucho.com > http://maillist.caucho.com/mailman/listinfo/resin-interest _______________________________________________ resin-interest mailing list resin-interest@caucho.com http://maillist.caucho.com/mailman/listinfo/resin-interest
