[CASSANDRA-12242] Could not create trigger

• Type: Bug
• Status: Resolved
• Priority: Normal
• Resolution: Not A Bug
• Component/s: Legacy/CQL
• Severity: Normal
• Since Version: 2.2.6
• Assignee: Unassigned
• Reporter: RocWay Li
• Created: 20/Jul/16 08:17
• Updated: 16/Apr/19 09:30
• Resolved: 22/Jul/16 12:37

Description

I tried cassandra 2.2.6 and 3.7, both of them could not create triggers.
It reports that the trigger class doesn't exist. But it actually does and is at the right directory, the conf/triggers.

I debugged the source code, and I found that SEPWorker is used to create triggers, but it's thread is not a secure thread, which should be managed by cassandra's SecurityManager and belongs to SecurityThreadGroup.

When security validation failed, an exception will be thrown. That's direct cause for creating triggers failed.