Description of problem: The userid column in the group_users table is/should be a FK to the users table. There is no FK key constraint however. This can lead to data anomalies in which we have a userid in group_users and no corresponding user in the users table. We already have this situation in QA (cspserver1.db.dev.redhat.com), and it has resulted in NPEs in GateKeeper code. The following query will return the bad data: select G.userid from group_users G where G.userid not in ( select U.userid from users U ) Version-Release number of selected component (if applicable): How reproducible: Steps to Reproduce: 1. 2. 3. Actual results: Expected results: Additional info:
Here is the GateKeeper exception I found in the logs on cspserver2: 2008-06-27 10:22:58,402 ERROR [STDERR] java.lang.NullPointerException 2008-06-27 10:22:58,402 ERROR [STDERR] at com.jboss.gatekeeper.workflow.action.batch.ActiveEntitlementRuleAction.processActiveUserEntitlementsUpdate(ActiveEntitlementRuleAction.java:57) 2008-06-27 10:22:58,402 ERROR [STDERR] at com.jboss.gatekeeper.workflow.action.batch.ActiveEntitlementRuleAction.process(ActiveEntitlementRuleAction.java:43) 2008-06-27 10:22:58,402 ERROR [STDERR] at com.jboss.gatekeeper.workflow.action.batch.BaseProcessAction.execute(BaseProcessAction.java:34)
Superceded by Avalon. This component is no longer valid.