[Building Sakai] OSP matrix slow loading

[prabhu]

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<http://208.65.174.66:10000/phpmyadmin/url.php?url=http%3A%2F%2Fdev.mysql.com%2Fdoc%2Frefman%2F5.1%2Fen%2Fdelete.html&token=59f36329b3e08c311f93a007b5fc9d56>
FROM `sau1`.`osp_matrix` WHERE `osp_matrix`.`id`
=<http://208.65.174.66:10000/phpmyadmin/url.php?url=http%3A%2F%2Fdev.mysql.com%2Fdoc%2Frefman%2F5.1%2Fen%2Fcomparison-operators.html%23operator_equal&token=59f36329b3e08c311f93a007b5fc9d56>
'2A9FF540BB63447C645FC9C852DFA4B4'

*MySQL said: *[image:
Documentation]<http://208.65.174.66:10000/phpmyadmin/url.php?url=http%3A%2F%2Fdev.mysql.com%2Fdoc%2Frefman%2F5.1%2Fen%2Ferror-messages-server.html&token=59f36329b3e08c311f93a007b5fc9d56>
 #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/20130518/0cd3cdbd/attachment.html