rockers Posted March 31, 2015 Report Posted March 31, 2015 We have a web application which is used by 1000's of users. Suddenly from last one week a query is being fired millions of times daily from web application to oracle database, even without any requests to the web application. How to find out what is causing this issue?
Bheem Boy Posted April 1, 2015 Report Posted April 1, 2015 We have a web application which is used by 1000's of users. Suddenly from last one week a query is being fired millions of times daily from web application to oracle database, even without any requests to the web application. How to find out what is causing this issue? Check if there is any scheduler running that is causing it?. Take a thread dump and check the logs. Do you restart the application daily?
innovative Posted April 1, 2015 Report Posted April 1, 2015 logs monitor cheyyatame .. issue is vague ..ee koncham info tho cheppatam kastam .. eppudu app live vellindhi .. has evrything been going smooth ? from last one week emanna code changes ayyaka ee web app ki.. ila chala possibilities vuntay .. plz check logs/ stack trace
rockers Posted April 1, 2015 Author Report Posted April 1, 2015 Check if there is any scheduler running that is causing it?. Take a thread dump and check the logs. Do you restart the application daily? We have CRON job schedulers on another node with is not part of load balancer. In the webapp logs we do see query being printed as if it is initiatied by the user , but there are no users at that time logged in to the app.
rockers Posted April 1, 2015 Author Report Posted April 1, 2015 logs monitor cheyyatame .. issue is vague ..ee koncham info tho cheppatam kastam .. eppudu app live vellindhi .. has evrything been going smooth ? from last one week emanna code changes ayyaka ee web app ki.. ila chala possibilities vuntay .. plz check logs/ stack trace It went live 2 years back.. There are some code changes last week but that are related to CRON jobs .. which is another webapp and that is not part of load balancer. These requests are coming normal webapp as if it was initiated by user after checking logs.. but there are no users logged in at that time when these queries are being fired.
Recommended Posts