Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 6 Current »

E-Mail Message:

Text

Picture

Labels
alertname = OTCS-clusterRunAvgTime
HID = OTCS0905
clusterDisplayName = DEV FE01
clusterIndex = 3
clusterinstanceDisplayName = OTCS0801FE02
env = DEV
instance = localhost:10105
job = OTCS_DEV
severity = critical
team = otcs
Annotations
description = Content Server Cluster High Avg Request Time over 30s VALUE = 130.234 LABELS: map[__name__:clusterRunAvgTime clusterDisplayName:DEV FE01 clusterIndex:3 clusterinstanceDisplayName:OTCS0801FE02 env:DEV instance:localhost:10105 job:OTCS_DEV] Help: https://handel.atlassian.net/wiki/spaces/HITID/pages/720699609/OTCS0905+Content+Server+Cluster+High+Avg+Request+Time
summary = Content Server Cluster has High Avg Request Time (instance localhost:10105)

Applies to

System

Version

Approved

opentext Content Server

16.x

Yes

opentext Content Server

20.x

Yes

opentext Content Server

22.x

Yes

Summary

The Content Server has a high Average Request Time. All Request are Very Slow. Usualy the Thread count going up.

Sources of Errors

  1. 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)

  2. To many request from the Clients

    1. Waiting Waiting…

  • No labels