[Building Sakai] OSP matrix slow loading

[Steve Swinsburg]

Hi Prabhu,

I'm great thanks, but this one is best for an OSP person. Chris or Noah perhaps?

cheers,
Steve

On 19/05/2013, at 3:47 AM, prabhu <prabhu142003 at gmail.com> wrote:

> Hi Steve,
>               How are you?
> 
> I am using sakai 2.8.2. When the user click on the Matrix, it takes about a 1 minute to show up when it is being accessed by a single user. But when 10 users access the same matrix cell it takes much more time to show up.
>       When I looked at the log I found these errors
> 
> 2013-05-17 13:33:28,709  WARN http-8080-Processor20 org.sakaiproject.metaobj.security.impl.sakai.AgentManager - Unable to find user: a6d8f030-9c32-4b74-a061-f05558f613cf org.sakaiproject.exception.IdUnusedException id=a6d8f030-9c32-4b74-a061-f05558f613cf
> 
> 2013-05-17 13:33:28,711  WARN http-8080-Processor20 org.sakaiproject.metaobj.security.impl.sakai.AgentManager - Unable to find user: 00978d2b-27c7-4ced-a1d8-346d834456fb org.sakaiproject.exception.IdUnusedException id=00978d2b-27c7-4ced-a1d 8-346d834456fb
> 
> 2013-05-17 13:33:28,712  WARN http-8080-Processor20 org.sakaiproject.metaobj.security.impl.sakai.AgentManager - Unable to find user: 439bbfda-540e-4b40-b95e-8250b2283049 org.sakaiproject.exception.IdUnusedException id=439bbfda-540e-4b40-b95e-8250b2283049
> 
> 2013-05-17 13:33:28,716  WARN http-8080-Processor20 org.sakaiproject.metaobj.security.impl.sakai.AgentManager - Unable to find user: 7881167f-0660-4e70-b4ba-7f9bd6b23200 org.sakaiproject.exception.IdUnusedException id=7881167f-0660-4e70-b4ba-7f9bd6b23200
> 
> 
> Then I looked into the sakai users list and searched for these Internal ID's. But no user was found. But when searched in the Matrix Cell of the Database I saw that there is something which belongs to these users.
> 
> When I tried to delete that data, I am getting the following response..
> 
> Error:
> SQL query:
> 
> DELETE FROM `sau1`.`osp_matrix` WHERE `osp_matrix`.`id` = '2A9FF540BB63447C645FC9C852DFA4B4'
> 
> MySQL said: 
> 
> #1451 - Cannot delete or update a parent row: a foreign key constraint fails (`sau1`.`osp_matrix_cell`, CONSTRAINT `FK8C1D366D2D955C` FOREIGN KEY (`matrix_id`) REFERENCES `osp_matrix` (`id`)) 
> 
> 
> How can I get rid of this?
> 
> 
> 
> 
> 
> --
> -----------------------------------------------------------------------------------------------------------------------------------------------
> 
> Regards:
> 
> Prabhu Janakaraj,
> Consultant Linux and Networking - Training and Deployment,
> Skype: prabhu.j4
> Handphone: 091 9790 382 999

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://collab.sakaiproject.org/pipermail/sakai-dev/attachments/20130519/c1dc1579/attachment.html