Forum OpenACS Development: Re: PL/SQL: acs_permission__grant_permission lock problem

Collapse
5: Re: PL/SQL: acs_permission__grant_permission lock problem (response to 4)
Posted by Gustaf Neumann on 07/27/15 12:40 PM
This looks fine, although i would recommend to remove the "select count(*)..." from acs_permission__grant_permission, since these two operations smell after a race condition. In most cases, the count() should return 0, and since the EXCEPTION deals with the the duplicate case anyhow, i see no reason for the count().

-g

Collapse
6: Re: PL/SQL: acs_permission__grant_permission lock problem (response to 5)
Posted by Antonio Pisano on 07/27/15 02:58 PM
I have removed count from grant proc and committed changes. I've seen there is some work going on in acs-kernel, so my upgrade became from 5.9.0d5 to 5.9.0d6

Please let me know about any possible issue.

All the best