Hi Ravi,
Was able to sort it out. This may help someone else's too.
Error occured only during viewing student submissions. That is also occuered when viewing course with large numbers of students. Generally 150/200+.
There is a setting to in Assingnment plugin to limit number of student submissions per page. In our case it has been set to default value which was unlimited. Due to that reason it was executing much bigger query and db server cpu usage goes to maximum.
Simple workaround is to set the limit 100 submissions per page and works fine without any issue.
Thanks for your time. Hope this will help someone
Was able to sort it out. This may help someone else's too.
Error occured only during viewing student submissions. That is also occuered when viewing course with large numbers of students. Generally 150/200+.
There is a setting to in Assingnment plugin to limit number of student submissions per page. In our case it has been set to default value which was unlimited. Due to that reason it was executing much bigger query and db server cpu usage goes to maximum.
Simple workaround is to set the limit 100 submissions per page and works fine without any issue.
Thanks for your time. Hope this will help someone