Grouper Users - Open Discussion List

["Redman, Chad" <>]

Sounds like a query plan gone wrong. Are the statistics relatively recent?

If there is a large number of rows in the table, the row updates may need to 
be done in small batches. Depending on the database, large scale updates 
sometimes take long because it needs to archive the pre-changed data for a 
potential rollback.

-Chad


-----Original Message-----
From: 

 
[mailto:]
 On Behalf Of Jim Fox
Sent: Thursday, July 05, 2018 12:01 PM
To: 

Subject: [grouper-users] upgrade db from 28 to 29 seems to hang


I'm doing a database upgrade and at the end of the 28->29 step it runs the 
command

> update grouper_audit_entry set act_as_member_id=logged_in_member_id where 
> act_as_member_id is null and logged_in_member_id is not null;


which seems to just sit forever.  ( as in more than a day )

Could I skip this step for now and finish to conversion to version 30?  I 
could complete the update of the audit entries later.

Would that work?

Thanks,

Jim