Hi Sumedha, On Mon, Apr 23, 2012 at 8:14 PM, Sumedha Rubasinghe <[email protected]>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? > Since Carbon data sources are used, it has to be only a single connection pool. And also, since the connections come to a stable count at the end, it is unlikely that it is a connection leak. Also, it is not only data services that access databases in Manager, there are other JDBC code that access those DBs, so that may explain the increase the number of connections created at first. Prabath is further looking into this. Cheers, Anjana. > > > > On Mon, Apr 23, 2012 at 4:51 PM, Prabath Abeysekera <[email protected]>wrote: > >> >> >> On Mon, Apr 23, 2012 at 4:40 PM, Anjana Fernando <[email protected]> wrote: >> >>> Hi, >>> >>> On Mon, Apr 23, 2012 at 4:29 PM, Muhammed Shariq <[email protected]>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 <[email protected]>wrote: >>>> >>>>> Hi Shariq, >>>>> >>>>> On Mon, Apr 23, 2012 at 2:27 PM, Muhammed Shariq <[email protected]>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 < >>>>>> [email protected]> 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 < >>>>>>> [email protected]> 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 < >>>>>>>> [email protected]> 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: [email protected] >>>>>>>>> >>>>>>>>> Lean . Enterprise . Middleware >>>>>>>>> >>>>>>>>> >>>>>>>>> _______________________________________________ >>>>>>>>> Dev mailing list >>>>>>>>> [email protected] >>>>>>>>> http://wso2.org/cgi-bin/mailman/listinfo/dev >>>>>>>>> >>>>>>>>> >>>>>>>> >>>>>>>> >>>>>>>> -- >>>>>>>> /sumedha >>>>>>>> +94 773017743 >>>>>>>> >>>>>>> >>>>>>> >>>>>>> >>>>>>> -- >>>>>>> Dimuthu Leelarathne >>>>>>> Technical Lead >>>>>>> >>>>>>> WSO2, Inc. (http://wso2.com) >>>>>>> email: [email protected] >>>>>>> >>>>>>> Lean . Enterprise . Middleware >>>>>>> >>>>>>> >>>>>>> _______________________________________________ >>>>>>> Dev mailing list >>>>>>> [email protected] >>>>>>> http://wso2.org/cgi-bin/mailman/listinfo/dev >>>>>>> >>>>>>> >>>>>> >>>>>> >>>>>> -- >>>>>> Thanks, >>>>>> Shariq. >>>>>> Phone: +94 777 202 225 >>>>>> >>>>>> >>>>>> _______________________________________________ >>>>>> Dev mailing list >>>>>> [email protected] >>>>>> 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 >>> [email protected] >>> http://wso2.org/cgi-bin/mailman/listinfo/dev >>> >>> >> >> >> -- >> Prabath Abeysekara >> Software Engineer >> WSO2 Inc. >> Email: [email protected] <[email protected]> >> Mobile: +94774171471 >> >> <http://harshana05.blogspot.com/> >> >> >> _______________________________________________ >> Dev mailing list >> [email protected] >> http://wso2.org/cgi-bin/mailman/listinfo/dev >> >> > > > -- > /sumedha > +94 773017743 > -- *Anjana Fernando* Senior Software Engineer WSO2 Inc. | http://wso2.com lean . enterprise . middleware
_______________________________________________ Dev mailing list [email protected] http://wso2.org/cgi-bin/mailman/listinfo/dev
