O+M 2024-05-20

[hkdctol]

As part of day-to-day operation of Data.gov, there are many Operation and Maintenance (O&M) responsibilities. Instead of having the entire team watching notifications and risking some notifications slipping through the cracks, we have created an O&M Triage role. One person on the team is assigned the Triage role which rotates each sprint. This is not meant to be a 24/7 responsibility, only East Coast business hours. If you are unavailable, please note when you will be unavailable in Slack and ask for someone to take on the role for that time.

Check the O&M Rotation Schedule for future planning.

Acceptance criteria

You are responsible for all O&M responsibilities this week. We've highlighted a few so they're not forgotten. You can copy each checklist into your daily report.

Daily Checklist

• [x] Check Production State/Actions

  Note: Catalog Auto Tasks You will need to update the chart values manually. Click the Action link in each issue and grab the values from monitor task output and check runtime.

• [x] Check auto generated O&M tickets from no status column
• [x] Check Harvesting Emails
• [x] New Relic Alerts Triaged
• [x] Triage DMARC Report from Google

Weekly Checklist

• [x] DB-Solr Sync
• [x] Audit Log (more info on AU-3 and AU-6 Log auditing)
• [x] Tracking Update
  • NOTE: This job will consistently timeout, but it is processing results ((more details)[https://github.com/GSA/data.gov/issues/4345])
• [x] Check Catalog Solr
• [x] Catalog Dupe Check
• [x] Check user management requests

Monthly Checklist

• [x] Invicti Scan

ad-hoc checklist

• [x] audit/review applications on cloud foundry and determine what can be stopped and/or deleted.

Reference

• Watch for user email requests
• Watch in #datagov-alerts and Vulnerable dependency notifications (daily email reports) for critical alerts.
• Monitor and improve Data.gov O&M Dashboard
• Update and revise Data.gov O&M Tasks

[Jin-Sun-tts]

catalog-fetch constantly crashing due to solr error.

2024-05-20T09:19:17.10-0400 [APP/PROC/WEB/3] ERR ckan.lib.search.common.SearchIndexError: Solr returned an error: Solr responded with an error (HTTP 400): [Reason: Error:[doc=0e4a1d3078ff068641f1cea20231812bc4d66124] Unknown operation for the an atomic update: fn]

There were total 7 stuck jobs. stopped the DOJ one, see following error in the catalog-fetch log:

2024-05-20T10:14:51.12-0400 [APP/PROC/WEB/0] ERR raise ParentNotHarvestedException('Unable to find parent dataset. Raising error to allow re-run later')
   2024-05-20T10:14:51.12-0400 [APP/PROC/WEB/0] ERR ckanext.datajson.exceptions.ParentNotHarvestedException: Unable to find parent dataset. Raising error to allow re-run later

This above error crash the catalog-fetch process, it is daily job, @hkdctol FYI. for now we just changed the frequency of this harvest source hhs-cas-json to Manualto avoid blocking other harvest jobs.

[FuhuXia]

In ticket https://github.com/GSA/data.gov/issues/4223 we list ParentNotHarvestedException is one of scenario that cause catalog-fetch to crash. It is noticed that this error become a bigger issue for the past a few weeks, blocking system-wide harvest jobs. We need either tell agencies to fix their sources, or we need to fix the code that catalog-fetch does not crash on this error.

[Jin-Sun-tts]

This morning the catalog-fetch crashing again, samilar errors reported like yesterday, also found ParentNotHarvestedException error for dot-socrata-data-json harvest source:

   2024-05-21T09:56:07.47-0400 [APP/PROC/WEB/1] ERR raise ParentNotHarvestedException('Unable to find parent dataset. Raising error to allow re-run later')
   2024-05-21T09:56:07.47-0400 [APP/PROC/WEB/1] ERR ckanext.datajson.exceptions.ParentNotHarvestedException: Unable to find parent dataset. Raising error to allow re-run later

This is daily job too, we may need to fix the code that catalog-fetch does not crash on this error.

[Jin-Sun-tts]

catalog-fetch constantly crashing due to solr errors. Restart solar leader did not help.

Rebuild individual index has no issue.

Manually stopped 13 running jobs and scaled the catalog-fetch to 1, re-harvest one by one and try to reproduce this issue.

So far the doj-json harvesting reported same solr error, continue testing to narrow down the resource could cause this issu.

[Jin-Sun-tts]

Thursday 05/23

https://github.com/GSA/data.gov/

Check Catalog Auto Tasks

Check Harvesting Emails

• [x] Catalog:

• [x] DB-Solr Sync:
  4 packages need to be removed from Solr 0 packages need to be updated/added to Solr 974 packages without harvest_object need to be mannually deleted Finished 528s

---

The catalog-fetch service is frequently crashing due to the following issues:

• Solr errors occurring during doj-json harvesting.

ERR ckan.lib.search.common.SearchIndexError: Solr returned an error: Solr responded with an error (HTTP 400): [Reason: Error:[doc=0e4a1d3078ff068641f1cea20231812bc4d66124] Unknown operation for the an atomic update: fn]

• ParentNotHarvestedException errors encountered during dot-socrata-data-json and hhs-cas-json harvesting.

   2024-05-21T09:56:07.47-0400 [APP/PROC/WEB/1] ERR raise ParentNotHarvestedException('Unable to find parent dataset. Raising error to allow re-run later')
   2024-05-21T09:56:07.47-0400 [APP/PROC/WEB/1] ERR ckanext.datajson.exceptions.ParentNotHarvestedException: Unable to find parent dataset. Raising error to allow re-run later

We just set dot-socrata-data-json and hhs-cas-json frequency to Manual for now to avoid blocking other harvest jobs.

[FuhuXia]

Prod catalog-gather ProxyError error was reported for multiple harvest sources. Doing some troubleshooting steps, including restarting app proxy-gsa-datagov-prod-catalog-gather in space prod-egress. Evenually the issue is resolved, most likely thanks to the app restart.