Internal Errigal Collaboration Wiki

This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong.

=====MonthlyNetIdentifierCountIsZero=====

**Level:** Major :!:


**Purpose:** This alert tells us that the network identifier count query returned 0 results. This is used for billing purposes

**Scenario:** This watchdog runs this query and alerts us if the result is 0 <WRAP center round box 60%>
SELECT IF(DAY(NOW()) = 1, 1, (SELECT  COUNT(*) FROM stats_network_identifier_node_count WHERE MONTH(date) = MONTH(NOW()) AND YEAR(date) = YEAR(NOW()))) as 'count(*)';
</WRAP>


**Resolution:** Check the cronjob to see if this executed at the right time <WRAP center round box 60%>
0 0 1 * * /home/scotty/script/network_element_count_stats/populate_ne_count_stats.sh  > /home/scotty/script/network_element_count_stats/ne_populate_stats.out 2>&1
</WRAP>
This is supposed to run at 00:00 on the first of the month but sometimes it may run an hour before.

**Manual Action Steps:** If this happens check the crontab, there may not be a CRON_TZ variable set and cron may be using a different timezone than the server. If this is the case set this to be the same timezone and restart the cron service.

**Auto Clear:** This will auto clear once the result is not 0

Sidebar

Internal Errigal Collaboration Wiki

User Tools

Site Tools

Page Tools