SNMP Trap: Database Usage¶
A trap is generated when the transaction and cache collections exceed usage thresholds.
Identification
The originating IP / hostname is used to identify the system generating the traps
The NMS is responsible for associating traps with each managed system, along with clearing of alarms and escalation to the relevant system operator
The trap OID is generic for various SNMP events monitored by the VOSS Automate system
The SNMP system name is included as part of the variable binding to assist identification:
.iso.org.dod.internet.mgmt.mib-2.system.sysName.0 = standalone
Trap OID
.iso.org.dod.internet.mgmt.mib-2.dismanEventMIB.dismanEventMIBNotificationPrefix. dismanEventMIBNotifications.mteTriggerFired
Severity Messages:
Info : WARN: Database transaction count returned to normal,
INFO: Database transaction size returned to normal,
INFO: Database cache size returned to normal
Critical : WARN: Database cache size exceeded threshold,
WARN: Database transaction size exceeded threshold,
WARN: Database transaction count exceeded threshold
Variable Bindings - DB cache size¶
WARN
.iso.org.dod.internet.mgmt.mib-2.system.sysUpTime.0 = 2 minutes (12065)
snmpTrapOID = mteTriggerFired
.iso.org.dod.internet.mgmt.mib-2.dismanEventMIB.dismanEventMIBNotificationPrefix. dismanEventMIBNotificationObjects.mteHotTrigger.0 = ‘WARN: Database cache size exceeded threshold’
.iso.org.dod.internet.mgmt.mib-2.dismanEventMIB.dismanEventMIBNotificationPrefix. dismanEventMIBNotificationObjects.mteHotContextName.0 = ‘size: 14960011111’
.iso.org.dod.internet.mgmt.mib-2.dismanEventMIB.dismanEventMIBNotificationPrefix. dismanEventMIBNotificationObjects.mteHotValue.0 = 1
.iso.org.dod.internet.mgmt.mib-2.system.sysName.0 = standalone
INFO
.iso.org.dod.internet.mgmt.mib-2.system.sysUpTime.0 = 2 minutes (12065)
snmpTrapOID = mteTriggerFired
.iso.org.dod.internet.mgmt.mib-2.dismanEventMIB.dismanEventMIBNotificationPrefix. dismanEventMIBNotificationObjects.mteHotTrigger.0 = ‘INFO: Database cache size returned to normal’
.iso.org.dod.internet.mgmt.mib-2.dismanEventMIB.dismanEventMIBNotificationPrefix. dismanEventMIBNotificationObjects.mteHotContextName.0 = ‘The cache size returned to normal’
.iso.org.dod.internet.mgmt.mib-2.dismanEventMIB.dismanEventMIBNotificationPrefix. dismanEventMIBNotificationObjects.mteHotValue.0 = 0
.iso.org.dod.internet.mgmt.mib-2.system.sysName.0 = standalone
Variable Bindings - DB transaction size¶
WARN
.iso.org.dod.internet.mgmt.mib-2.system.sysUpTime.0 = 2 minutes (12065)
snmpTrapOID = mteTriggerFired
.iso.org.dod.internet.mgmt.mib-2.dismanEventMIB.dismanEventMIBNotificationPrefix. dismanEventMIBNotificationObjects.mteHotTrigger.0 = ‘WARN: Database transaction size exceeded threshold’
.iso.org.dod.internet.mgmt.mib-2.dismanEventMIB.dismanEventMIBNotificationPrefix. dismanEventMIBNotificationObjects.mteHotContextName.0 = ‘size: 23353681111’
.iso.org.dod.internet.mgmt.mib-2.dismanEventMIB.dismanEventMIBNotificationPrefix. dismanEventMIBNotificationObjects.mteHotValue.0 = 1
.iso.org.dod.internet.mgmt.mib-2.system.sysName.0 = standalone
INFO:
.iso.org.dod.internet.mgmt.mib-2.system.sysUpTime.0 = 2 minutes (12065)
snmpTrapOID = mteTriggerFired
.iso.org.dod.internet.mgmt.mib-2.dismanEventMIB.dismanEventMIBNotificationPrefix. dismanEventMIBNotificationObjects.mteHotTrigger.0 = ‘INFO: Database transaction size returned to normal’
.iso.org.dod.internet.mgmt.mib-2.dismanEventMIB.dismanEventMIBNotificationPrefix. dismanEventMIBNotificationObjects.mteHotContextName.0 = ‘The transaction size returned to normal’
.iso.org.dod.internet.mgmt.mib-2.dismanEventMIB.dismanEventMIBNotificationPrefix. dismanEventMIBNotificationObjects.mteHotValue.0 = 0
.iso.org.dod.internet.mgmt.mib-2.system.sysName.0 = standalone
Variable Bindings - DB transaction count¶
WARN
.iso.org.dod.internet.mgmt.mib-2.system.sysUpTime.0 = 2 minutes (12065)
snmpTrapOID = mteTriggerFired
.iso.org.dod.internet.mgmt.mib-2.dismanEventMIB.dismanEventMIBNotificationPrefix. dismanEventMIBNotificationObjects.mteHotTrigger.0 = ‘WARN: Database transaction count exceeded threshold’
.iso.org.dod.internet.mgmt.mib-2.dismanEventMIB.dismanEventMIBNotificationPrefix. dismanEventMIBNotificationObjects.mteHotContextName.0 = ‘count: 500001’
.iso.org.dod.internet.mgmt.mib-2.dismanEventMIB.dismanEventMIBNotificationPrefix. dismanEventMIBNotificationObjects.mteHotValue.0 = 1
.iso.org.dod.internet.mgmt.mib-2.system.sysName.0 = standalone
INFO
.iso.org.dod.internet.mgmt.mib-2.system.sysUpTime.0 = 2 minutes (12065)
snmpTrapOID = mteTriggerFired
.iso.org.dod.internet.mgmt.mib-2.dismanEventMIB.dismanEventMIBNotificationPrefix. dismanEventMIBNotificationObjects.mteHotTrigger.0 = ‘WARN: Database transaction count returned to normal’
.iso.org.dod.internet.mgmt.mib-2.dismanEventMIB.dismanEventMIBNotificationPrefix. dismanEventMIBNotificationObjects.mteHotContextName.0 = ‘The transaction count returned to normal’
.iso.org.dod.internet.mgmt.mib-2.dismanEventMIB.dismanEventMIBNotificationPrefix. dismanEventMIBNotificationObjects.mteHotValue.0 = 0
.iso.org.dod.internet.mgmt.mib-2.system.sysName.0 = standalone
Example: WARN: Database transaction size exceeded threshold¶
Notification message from (1, 3, 6, 1, 6, 1, 1):('192.29.22.122', 11776):
Var-binds:
1.3.6.1.2.1.1.3.0 = 27396043
1.3.6.1.6.3.1.1.4.1.0 = 1.3.6.1.2.1.88.2.0.1
1.3.6.1.2.1.88.2.1.1.0 = WARN: Database transaction size exceeded threshold
1.3.6.1.2.1.88.2.1.3.0 = size: 22574836480
1.3.6.1.2.1.88.2.1.5.0 = 1
1.3.6.1.2.1.1.5.0 = UN1-192.29.22.122
Resolution:
The following commands can be used to resolve this:
voss transaction delete <days> [limit <number>]
voss transaction archive <days>