On Mar 21, 2007, at 10:36 AM, Jaswinder Kaur wrote: > Does anyone has any suggestion ? > > Date: Mon, 19 Mar 2007 17:56:44 -0700 > From: "Jaswinder Kaur" <[EMAIL PROTECTED]> > Subject: Re: [Resin-interest] Persistent store - issue with select > query > To: resin-interest@caucho.com > Message-ID: > <[EMAIL PROTECTED]> > Content-Type: text/plain; charset="iso-8859-1" > >> Hello >> I am running into 2 issues with resin upgrade. >> 1. The following query is executing around 7 times more on >> server 2 than server 1. >> SELECT ACCESS_TIME, DATA FROM SRUN_SERVER2 WHERE ID= ? >> 2. The srun*.db file keeps increasing in size? >> >> >> The specifics: We are using resin-pro 3.0.21 and jdk 1.4.2_03. >> There are two servers in the farm that are using cluster store for >> the sessions. Below is a snippet of resin.conf.
There were a number of distributed session fixes between 3.0.21 and 3.0.23. 3.1 has some additional distributed session fixes. -- Scott >> >> <http server-id="server1" host="server1" port="80"/> >> <http server-id="server2" host="server2" port="80"/> >> >> <http server-id="server1" host="server1" port="443"> >> <openssl> >> ..... >> </openssl> >> </http> >> <http server-id="server2" host="server2" port="443"> >> <openssl> >> ..... >> </openssl> >> </http> >> >> <cluster> >> <srun server-id="server1" host="server1" port="6802"/> >> <srun server-id="server2" host="server2" port="6802"/> >> </cluster> >> <persistent-store type="cluster"> >> <init path="cluster"/> >> </persistent-store> >> <web-app id="/"> >> <session-config cookie-domain="vsp.com"> >> <use-persistent-store/> >> </session-config> >> </web-app> >> >> The problems that we are experiencing could they be related to >> the above configuration or resin itself? >> >> Thank you in advance. >> >> > > ====================================================================== > ======== > "Attention: This message is intended only for the individual to > whom it is addressed and may contain information that is > confidential or privileged. If you are not the intended recipient, > or the employee or person responsible for delivering it to the > intended recipient, you are hereby notified that any dissemination, > distribution, copying or use is strictly prohibited. If you have > received this communication in error, please notify the sender and > destroy or delete this communication immediately." > ====================================================================== > ======== > > > > _______________________________________________ > 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