Host, Cluster, Keyspace and Table names not displayed for some Cassandra alarms (4306093)

Starting with the release of Foglight Cartridge for Cassandra 5.9.5.21 alarms email notification subject was updated to include Host, Cluster, Keyspace and Table information in the following format:

@Severity@ alarm for @DBType@ cluster @Cluster@ instance @InstanceName@ on host @Hostname@ (keyspace @Keyspace@ table @Table@) was generated: @AlarmMessage@)

For some alarms "n/a" values are displayed for the new variables; for example:

• Cassandra Node PendingCompactions: Warning alarm for Cassandra cluster cluster_name instance instance_name on host 172.27.0.4 (keyspace n/a table n/a) was generated: There are 0.00 pending compactions...
• Cassandra JVM OS UsedPhysicalMemSizePct: Fatal alarm for Cassandra cluster n/a instance instance_name on host 172.27.0.4 (keyspace n/a table n/a) was generated: The percent of used OS physical memory reported by the Cassandra JVM...

For alarms that had the email notification subject previously edited, the new format may not be used.

WORKAROUND

If the default or alarms level email notification subjects were previously modified from databases administration, variables may need to be reset for the new email subject format to be used.

Custom email subjects can still be used for all or specific alarms.

To reset the default email settings: How to Reset or Remove the Default Email settings for the Database Agents? (189303)

STATUS

Issue fixed in version 6.0.0.10. The latest version of the Foglight Cartridge for Cassandra can be downloaded here.