E-Mail Message:

Labels
alertname = OTCS-clusterNumActiveThreads
HID = OTCS0902
clusterDisplayName = DEV FE01
clusterIndex = 3
clusterinstanceDisplayName = OTCS0801FE02
env = DEV
instance = localhost:10105
job = OTCS_DEV
severity = critical
team = otcs
Annotations
description = Content Server has les than 10 Threads available VALUE = 4 LABELS: map[clusterDisplayName:DEV FE01 clusterIndex:3 clusterinstanceDisplayName:OTCS0801FE02 env:DEV instance:localhost:10105 job:OTCS_DEV] Help: https://handel.atlassian.net/wiki/pages/resumedraft.action?draftId=714998035
summary = Content Server low Threads (instance localhost:10105)

Open

Applies to

Summary

The Content Server has a high usage of Threads. Shortly he can’t addional Task handel

Sources of Errors

1. Database not available

2. Database Locks of Tables

   1. Oracle Database

      1. Select for Database Lock

         select (select username from v$session where sid=a.sid) blocker, a.sid, ' is blocking ', (select username from v$session where sid=b.sid) blockee, b.sid from v$lock a, v$lock b where a.block = 1 and b.request > 0 and a.id1 = b.id1 and a.id2 = b.id2;

      2. Solution: → Contact your DB Admin he can Remove the Lock.

   2. SQL

      1. SQL Server Locks, Blocked Processes, and Two Easy Ways to Find Them | Diagram (wearediagram.com)

3. To many request from the Clients

   1. Waiting Waiting…