Orphan locks

[coatie]

Hello,

we make use of EA's security feature and I just got curious about the number of entries within t_seclocks. So I ran query below and it gave me a lot of results, means it seems that there are a lot of orphan locks.  Did I miss something wrt my query?

Code: [Select]

SELECT l.entityid, o.Object_id, o.Name, o.Package_Id, u.userlogin, l.timestamp
FROM t_seclocks l
LEFT OUTER JOIN t_object o on o.ea_guid = l.entityid
LEFT OUTER JOIN t_secuser u on u.userid = l.userid
WHERE o.Package_id is NULL

Markus

[Geert Bellekens]

Markus,

I wouldn't worry too much about that unless it is affecting EA's behavior in some way.
There's a good chance orphans like that are cleaned up when running a project integrity check.

Geert

[coatie]

Hi Geert,

no, integrity check does not consider that. So I guess I head for rephrasing the query to a DELETE...

Markus

[Geert Bellekens]

Hi Geert,

no, integrity check does not consider that. So I guess I head for rephrasing the query to a DELETE...

Markus

Why would you do that?
Are these locks an issue somehow?

Geert