HI, On Mon, Apr 23, 2012 at 5:24 PM, Amila Maha Arachchi <[email protected]>wrote:
> Also, I saw SupunM has mentioned this is occurring in stratos AS packs as > well (he has commented in the Jira). So I guess we can remove the billing > component from the equation because it is not included in the Stratos-AS. > It contains usage agent, throttling agent (not using the billing db AFAIK) > and BAM data publisher. > > Supun, are you getting the same error reported in the jira STRATOS-2021? > yep same error AFAIR. but I got that only once when starting stratos AS for the first time. Next time I didn't get see that error. thanks, > > And, how about comparing the datasource.properties file also? > > AmilaM. > > > On Mon, Apr 23, 2012 at 5:13 PM, Amila Maha Arachchi <[email protected]>wrote: > >> Hi Shariq, >> >> I dont think increasing the max connections is the correct solution for >> this. If we take a 1.5.2 pack, it starts without this issue. So what I feel >> is, some commit from branch to trunk is missing. >> >> I faintly remember seen this error while we were working for 1.5.1 >> release (it was there in the initial days). But I dont remember the fix or >> the reason for this. >> >> Also, billing components are having the same code as in 1.5.2 branch. So >> its better if you can compare the .dbs with the branch and the other >> components using the billing db (usage component, bam summary generators, I >> know throttling is not having the same code and there is a jira for it. But >> the changes in the throttling code is very minimal). >> >> Thanks, >> AmilaM. >> >> 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 >>> >>> >> >> >> -- >> *Amila Maharachchi* >> Senior Software Engineer; WSO2, Inc.; http://wso2.com >> >> Blog: http://maharachchi.blogspot.com >> Mobile: +94719371446 >> >> >> > > > -- > *Amila Maharachchi* > Senior Software Engineer; WSO2, Inc.; http://wso2.com > > Blog: http://maharachchi.blogspot.com > Mobile: +94719371446 > > > -- Supun Malinga, Software Engineer, WSO2 Inc. http://wso2.com http://wso2.org email - [email protected] <[email protected]> mobile - 071 56 91 321
_______________________________________________ Dev mailing list [email protected] http://wso2.org/cgi-bin/mailman/listinfo/dev
