Hi, On Mon, Apr 23, 2012 at 8:14 PM, Sumedha Rubasinghe <sume...@wso2.com>wrote:
> But if a connection leak has occurred, it has to come from DS code. > Are all data services using the same connection pool or are there separate > ones? > The reason behind this issue is that multiple datasource references are getting created (thereby creating multiple connection pools) at run time whenever we look up for a particular carbon datasource. I've done a temporary fix upon this by enabling sharing of the same datasource per dataservice configuration, when used with carbon datasources(This option is already there for inline datasources). However, this fix too would have a few issues such as whenever the properties of a particular carbon datasource are updated, those updates will not be reflected until the dataservice is redeployed, etc. But we're hoping to fix all the aforementioned limitations (together with some other limitations that were already reported) in the new datasource component that we'll be implemented targeting the upcoming release. > > > > On Mon, Apr 23, 2012 at 4:51 PM, Prabath Abeysekera <praba...@wso2.com>wrote: > >> >> >> On Mon, Apr 23, 2012 at 4:40 PM, Anjana Fernando <anj...@wso2.com> wrote: >> >>> Hi, >>> >>> On Mon, Apr 23, 2012 at 4:29 PM, Muhammed Shariq <sha...@wso2.com>wrote: >>> >>>> Hi Anjana, >>>> >>>> IIRC there was an issue in Alpha2 packs where there was an NPE thrown >>>> when deploying .dbs files, so this issue did not surface. By monitoring >>>> via SHOW >>>> PROCESSLIST, there seem a burst of processes trying to connect to the >>>> billing database (that's the DB all the .dbs files access). Basically there >>>> are a numer of .dbs files deployed during the server startup, hence the >>>> sudden increase. >>>> >>>> However by increasing the max_connections to 1000 I was able to get rid >>>> of this issue, (hope 1000 is an acceptable number ?), previously it was set >>>> to 150. So if 1000 as max_connections is acceptable, we can consider this >>>> issue fixed. >>>> >>> >>> 1000 is too much, there is no reason for that much of connections to be >>> created and persisted. Anyways, does the connections get released after the >>> startup, which can be observed by SHOW PROCESSLIST. >>> >> >> I too have a feeling that you would probably need to double check the >> database access implementation and see whether the connections are properly >> closed after the interactions with the database. Though it's not something >> unusual to see this parameter being increased to higher values in a >> production level MySQL instances to allow higher number of connections, I >> don't really think it's the best option we have upon the reported issue as >> ideally there shouldn't be that many connections opened at the server >> startup. >> >> >>> >>> Cheers, >>> Anjana. >>> >>> >>>> >>>> >>>> On Mon, Apr 23, 2012 at 3:25 PM, Anjana Fernando <anj...@wso2.com>wrote: >>>> >>>>> Hi Shariq, >>>>> >>>>> On Mon, Apr 23, 2012 at 2:27 PM, Muhammed Shariq <sha...@wso2.com>wrote: >>>>> >>>>>> This issue is there in Alpha4 packs as well. I had a chat with >>>>>> PrabathA about this learnt that increasing the number connections could >>>>>> resolve the issue. I tried increasing the connection properties as >>>>>> follows, >>>>>> but still no luck >>>>>> >>>>> >>>>> Did this properly work in Alpha2? .. if so, can you please check if >>>>> there any configuration related changes happen between builds. Basically >>>>> run Alpha2 again, against the same MySQL instance and see if it works. And >>>>> also as Prabath said, run "SHOW PROCESSLIST" and monitor the number of >>>>> connections being created. >>>>> >>>>> Cheers, >>>>> Anjana. >>>>> >>>>> >>>>>> >>>>>> synapse.datasources.stratos_ds.maxActive=*300* >>>>>> synapse.datasources.stratos_ds.minIdle=*50* >>>>>> >>>>>> >>>>>> On Mon, Apr 23, 2012 at 2:14 PM, Dimuthu Leelarathne < >>>>>> dimut...@wso2.com> wrote: >>>>>> >>>>>>> Hi Sumedha, >>>>>>> >>>>>>> The server is up because the mysql-query-browser connects. >>>>>>> >>>>>>> thanks, >>>>>>> dimuthu >>>>>>> >>>>>>> >>>>>>> On Mon, Apr 23, 2012 at 2:08 PM, Sumedha Rubasinghe < >>>>>>> sume...@wso2.com> wrote: >>>>>>> >>>>>>>> MySQL service is not available when the server boots up. >>>>>>>> Try connecting to MySQL from command line. >>>>>>>> >>>>>>>> Another thing is to observe the time to connect (if the MySQL is >>>>>>>> responding too slow). >>>>>>>> >>>>>>>> >>>>>>>> >>>>>>>> On Mon, Apr 23, 2012 at 2:04 PM, Dimuthu Leelarathne < >>>>>>>> dimut...@wso2.com> wrote: >>>>>>>> >>>>>>>>> Hi Anjana, >>>>>>>>> >>>>>>>>> Any idea how to overcome this issue we are facing? >>>>>>>>> >>>>>>>>> https://wso2.org/jira/browse/STRATOS-2021 >>>>>>>>> >>>>>>>>> According to stack overflow, this seems to be a timeout issue. But >>>>>>>>> this error comes on the first startup of the server. >>>>>>>>> >>>>>>>>> thanks, >>>>>>>>> dimuthu >>>>>>>>> -- >>>>>>>>> Dimuthu Leelarathne >>>>>>>>> Technical Lead >>>>>>>>> >>>>>>>>> WSO2, Inc. (http://wso2.com) >>>>>>>>> email: dimut...@wso2.com >>>>>>>>> >>>>>>>>> Lean . Enterprise . Middleware >>>>>>>>> >>>>>>>>> >>>>>>>>> _______________________________________________ >>>>>>>>> Dev mailing list >>>>>>>>> Dev@wso2.org >>>>>>>>> http://wso2.org/cgi-bin/mailman/listinfo/dev >>>>>>>>> >>>>>>>>> >>>>>>>> >>>>>>>> >>>>>>>> -- >>>>>>>> /sumedha >>>>>>>> +94 773017743 >>>>>>>> >>>>>>> >>>>>>> >>>>>>> >>>>>>> -- >>>>>>> Dimuthu Leelarathne >>>>>>> Technical Lead >>>>>>> >>>>>>> WSO2, Inc. (http://wso2.com) >>>>>>> email: dimut...@wso2.com >>>>>>> >>>>>>> Lean . Enterprise . Middleware >>>>>>> >>>>>>> >>>>>>> _______________________________________________ >>>>>>> Dev mailing list >>>>>>> Dev@wso2.org >>>>>>> http://wso2.org/cgi-bin/mailman/listinfo/dev >>>>>>> >>>>>>> >>>>>> >>>>>> >>>>>> -- >>>>>> Thanks, >>>>>> Shariq. >>>>>> Phone: +94 777 202 225 >>>>>> >>>>>> >>>>>> _______________________________________________ >>>>>> Dev mailing list >>>>>> Dev@wso2.org >>>>>> http://wso2.org/cgi-bin/mailman/listinfo/dev >>>>>> >>>>>> >>>>> >>>>> >>>>> -- >>>>> *Anjana Fernando* >>>>> Senior Software Engineer >>>>> WSO2 Inc. | http://wso2.com >>>>> lean . enterprise . middleware >>>>> >>>> >>>> >>>> >>>> -- >>>> Thanks, >>>> Shariq. >>>> Phone: +94 777 202 225 >>>> >>>> >>> >>> >>> -- >>> *Anjana Fernando* >>> Senior Software Engineer >>> WSO2 Inc. | http://wso2.com >>> lean . enterprise . middleware >>> >>> _______________________________________________ >>> Dev mailing list >>> Dev@wso2.org >>> http://wso2.org/cgi-bin/mailman/listinfo/dev >>> >>> >> >> >> -- >> Prabath Abeysekara >> Software Engineer >> WSO2 Inc. >> Email: praba...@wso2.com <harsha...@wso2.com> >> Mobile: +94774171471 >> >> <http://harshana05.blogspot.com/> >> >> >> _______________________________________________ >> Dev mailing list >> Dev@wso2.org >> http://wso2.org/cgi-bin/mailman/listinfo/dev >> >> > > > -- > /sumedha > +94 773017743 > Regards, Prabath -- Prabath Abeysekara Software Engineer WSO2 Inc. Email: praba...@wso2.com <harsha...@wso2.com> Mobile: +94774171471 <http://harshana05.blogspot.com/>
_______________________________________________ Dev mailing list Dev@wso2.org http://wso2.org/cgi-bin/mailman/listinfo/dev
