Hi, we need the help of folks who are familiar oracle to get this sorted. Any thoughts ? regards Ramith
On Fri, Mar 6, 2015 at 8:04 PM, Pumudu Ruhunage <[email protected]> wrote: > Hi All, > > I'm facing a oracle database issue when trying to test mb in cluster > environment with oracle database. > Following are the steps i followed. > 1. Start two mb nodes (node A, node B) with clustering enabled. > 2. Subscribe to node A with queue subscription "MyQueue" with a jms client. > 3. Start publish 2000 messages to node B to "MyQueue" using a jms client. > 4. Attached error log appears while receiving messages. > > As a work around i changed number of processes to 2000 with this alter > statement[1]. Then it worked for 100,000 messages without throwing > exceptions but it took around 5 minutes to finished receiving messages > (There's a big performance drop when increase number of processes). > > Therefore, changing number of processes doesn't solve this issue. Is there > a proper fix for this issue ? > > I found a jira [2] related to api manager with the same issue. But it > didn't explain what's the exact fix(database configurations) for this issue. > > > [1] - alter system set processes=2000 scope=spfile; > [2] - https://wso2.org/jira/browse/APIMANAGER-2304 > > -- > Pumudu Ruhunage > Associate Software Engineer | WSO2 Inc > M: +94 779 664493 | http://wso2.com > > _______________________________________________ > Dev mailing list > [email protected] > http://wso2.org/cgi-bin/mailman/listinfo/dev > > -- Ramith Jayasinghe Technical Lead WSO2 Inc., http://wso2.com lean.enterprise.middleware E: [email protected] P: +94 777542851
_______________________________________________ Dev mailing list [email protected] http://wso2.org/cgi-bin/mailman/listinfo/dev
