Daily checklist: Daily Checklist 03/03/2025 - 07/03/2025

[rosemaryjoconnor]

Every day

• monitor the index switch

• openstdout in step k. Check index and update collection alias

  • scroll to bottom and record Current#, NEW#, DIFF# values

• all scheduled jobs for the day completed successfully (raise on Slack if not)

• assertions sync has run - check user assertion counts are in DQ Profile using query:
  https://biocache.ala.org.au/occurrences/search?q=

  

• Images processing

  • Images uploads: https://images.ala.org.au/admin/batchUploads
  • batch uploads progressing and not stalled - take note of the lastUpdated field in a loading batch

• DAG runs - ensure no clusters are long-running (ie > 24 hours)

  • In Airflow - select Browse->Dag Runs and filter on running state
    

• clear biocache cache (has to be done after assertion sync and index successfully switched)

  • biocache admin: https://biocache.ala.org.au/admin

Raise any issues on the data management internal channel

• Monday
• Tuesday
• Wednesday
• Thursday
• Friday

Once a week (whenever)

Sensitive data check

• Run SDS script found in: Report-SDS-Information-Prod
• Commit new report to GitHub SDS Information report

Manual Index Switch

If manual index switch is needed run DAG Update-Collection-Alias

Job Schedule

Scheduled jobs - Github config

Daily

Time	Job	Job Name
3am	Index to SOLR
7am	OBIS	dp5183-obis-weekly

Weekly

Day	Time	Job	DR	Job Name
Mon	12am	BIS Weeds	dr27665	dr27665-BISFetcher-weekly
Mon	7am	iNaturalist	dr1411	dr1411-inaturalist-weekly
Mon	7pm	FeralScan	dr19813	dr19813-feralscan-weekly
Tue	12am	Mel AVH	dr13282	dr13282-mel-avh-weekly
Tue	9am	cPlatypus	dr7973	dr7973-cplatypus-weekly
Tue	9am	APII	dr413	dr413-apii-weekly
Tue	9am	Butterflies Aust	dr16457	dr16457-butterflies-weekly
Tue	5pm	Biocollect	dp3903	dp3903-biocollect-weekly
Tue	8pm	Bionet	dr368	dr368-bionet-weekly
Wed	12am	Perth AVH	dr15863	dr15863-perth-avh-weekly
Wed	8am	Questagame	dr1902	dr1902-questagame-weekly
Wed	9am	NatureMapr	dr19123	dr19123-naturemapr-weekly
Wed	1pm	QM	dr344	dr344-QM-weekly
Thu	12am	CANB AVH	dr15860	dr15860-canb-avh-weekly
Thu	12.25am	CNS AVH	dr15867	dr15867-cns-avh-weekly
Thu	12.40am	JCT AVH	dr15868	dr15868-jct-avh-weekly

Monthly

Day	Time	Job	DR	Job Name
First Thu	5.15pm	Museums Victoria	dr342	dr342-MV-monthly
First Wed	9am	TurtleSat	dr26141	dr26141-turtleSat-monthly
First Wed	9am	UC Genomics	dr25075	dr25075-UCGenomics-monthly
5th	12am	UniMelb AVH	dr13282	dr13282-melu-avh-monthly
5th	12am	Hobart AVH	dr10574	dr10574-ho-avh-monthly
6th	12am	Allan Herbarium	dr27654	dr27654-chr-avh-monthly
6th	12.01am	WELT AVH	dr26642	dr26642-welt-avh-monthly
6th	12.15am	Auckland Museum Botanical	dr26650	dr26650-ak-avh-monthly
6th	12.45am	NZ PDD	dr26651	dr26651-pdd-avh-monthly
19th	12am	NSW AVH	dr15861	dr15861-nsw-avh-monthly
20th	12am	BRI AVH	dr2287	dr2287-bri-avh-monthly
21st	12am	AD AVH	dr15865	dr15865-ad-avh-monthly

[rosemaryjoconnor]

03/03/2025

Preingestion

• BIS Weeds: dr27665
• iNaturalist: dr1411
• Feralscan evening

[rosemaryjoconnor]

04/03/2025

Index failed

     SEVERE- RECORD ID:0d4f0032-0e4b-49e5-b08f-bfa9fb8e939c - There are 5 fields which are missing in the new records. Here is the list: {'imageIDsCount', 'imageIDs', 'multimediaCount', 'multimedia', 'imageID'}
     Questagame record: https://biocache.ala.org.au/occurrences/0d4f0032-0e4b-49e5-b08f-bfa9fb8e939c

OBIS failed

SLF4J: Actual binding is of type [org.slf4j.impl.Log4jLoggerFactory]
which: no yq in (/usr/lib64/qt-3.3/bin:/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/opt/aws/puppet/bin/)
Command exiting with ret '1'

ERROR: Please install yq debian/ubuntu package (not the snap package), see https://github.com/mikefarah/yq