article "Database Not Responding" Message Appears in Global Scan

This knowledge base article provides steps of one approach which may resolve a "Database Not Responding" (DNR) message in the Global Scan.

 

When a DNR message appears on the Global Scan page, check the uptime.log file for messages similar to the following line (numbers will likely be different from example):

 

011-03-29 11:40:48,873 ERROR (ProtocolHandler:79) - In command entities=168,169,171,175,176,177,179|commandType=query|commandQueryName=GET_GLOBAL_SCAN_ENTITIES

 

This type of message likely indicates that the Global Scan page is attempting to display recent performance data from an element that has been removed or deleted from up.time.  To verify this condition, run the following queries to see if there are entries in the entity_latest_data_sample table that do not correspond to an existing element in the entity table:

 

select host_id from entity_latest_data_sample where host_id not in (select entity_id from entity);

 

For each ID that is listed from the above query, run the following two queries (replace <ID> with the ID number).  The first query should return an empty set but the second should have one or more results.

 

select entity_id from entity where entity_id = <ID>;
select * from entity_latest_data_sample where host_id = <ID>;

 

To remove the erroneous performance data that is causing this issue, run the following delete statement.

 

delete from entity_latest_data_sample where host_id = <ID>;

 

Once the delete statement has been run for each of the ID's from the first query, view the GlobalScan page to verify that the issue has been resolved.

Related Articles


Understanding the Status of Services

RatingViews
article

This article explains the status of the services that are displayed in the GlobalScan panel

By: uptime Support | Date Created: 9-6-2007 | Last Modified: 6-28-2011 | Index: 213

  2937

Changing Global Scan Performance Thresholds

RatingViews
article

By: uptime Support | Date Created: 3-31-2006 | Last Modified: 8-9-2011 | Index: 063

  7059

Oracle database not responding in up.time interface

RatingViews
article

If you are seeing a Database Not Responding message in up.time GUI, with something similar to the following error: =================== Database is not responding ...

By: uptime Support | Date Created: 10-14-2009 | Last Modified: 8-13-2011 | Index: 436

  2822

Login screen returns Database not responding error after upgradin...

RatingViews
article

If you did not log out of the up.time UI before upgrading to up.time 6.0.1 (refer to step 6 of Upgrading and Applying up.time Service Packs), you may see the following error after attempting to...

By: uptime Support | Date Created: 12-21-2011 | Last Modified: 8-14-2013 | Index: 572

  2224

Linux or UNIX agent is not responding

RatingViews
article

By: uptime Support | Date Created: 10-25-2005 | Last Modified: 7-14-2011 | Index: 034

  5774

User Comments



No comments have been posted.

Copyright © 2021 IDERA, Inc.   Legal   Privacy Statement