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. 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
