[Building Sakai] OSP matrix slow loading

[Noah Botimer]

Prabhu,

There is no way in the UI to delete individual users' matrices. If you have real data for that matrix (definition, scaffolding), you will have to delete rows in the database. The easiest way to do that would be to update the foreign key constraints to cascade deletes. There are a bunch of them, but they will be easy to find (try to delete and if it fails, update the constraint).

Because these are not usually set to cascade, they should be set back to restrict when done.

You could also do queries to identify the user cells, etc., and delete them by hand rather than using the cascade. This would certainly help you familiarize more with the tables.

Note that you will have to be quite careful to not delete data you want to keep. I would consider other options like profiling to see if you can identify the performance issue -- whether it is from missing users, retrieving extra data, excessive looping, or something else.

Thanks,
-Noah

On May 18, 2013, at 5:49 PM, Steve Swinsburg wrote:

> 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/20130520/61030cce/attachment.html