arctos icon indicating copy to clipboard operation
arctos copied to clipboard

higher taxonomy not showing in FLAT

Open DerekSikes opened this issue 10 months ago • 5 comments

Issue Documentation is http://handbook.arctosdb.org/how_to/How-to-Use-Issues-in-Arctos.html

Describe the bug A clear and concise description of what the bug is. First noticed this last Friday, clicked cache refresh for some records, on Monday, noticing it with other records.

See attached data - all these columns should have taxonomic names in them but are null:

phylum phylclass superorder phylorder

ArctosData5K3SlJvjAG.csv

I also can't find these records via a search on order = Ephemeroptera Accession = osf

Not sure how many other records have lost their higher taxonomy in FLAT but this problem is worrying because just repairing the lost data only fixes the symptoms - how do we prevent random loss of higher taxonomy from ever happening again?

Expected behavior A clear and concise description of what you expected to happen.

Searching on higher taxonomy will find records that have that higher taxonomy.

Screenshot 2024-04-22 at 1 17 26 PM

Additional context Add any other context about the problem here.

Priority Please assign a priority-label. Unprioritized issues get sent into a black hole of despair. high

DerekSikes avatar Apr 22 '24 21:04 DerekSikes

Uploading Screenshot 2024-04-22 at 1.23.59 PM.jpg…

DerekSikes avatar Apr 22 '24 21:04 DerekSikes

Merging with https://github.com/ArctosDB/arctos/issues/7695.

how do we prevent random loss of higher taxonomy from ever happening again

Hire a QA engineer and give them whatever resources they need. (But nothing has been "lost," it's just missing from the cache.)

dustymc avatar Apr 22 '24 21:04 dustymc

This is a serious problem. As serious as a personnel database that sometimes nulls out the last names of people. I would like (and I'm sure all users and potential users too) to know - why this happens? how often does it happen? what percent of records are affected? etc.

On a daily basis we make many higher-taxonomy-based queries the results of which could be used in a publication, or report, and to have no way to know that the results are reliable is very troubling. I really would like to see an answer that yields some sort of a solution rather than "we can't do this with available resources."

DerekSikes avatar Apr 22 '24 23:04 DerekSikes

Search is still failing: https://arctos.database.museum/search.cfm?phylorder=Ephemeroptera&accn_number=osf

DerekSikes avatar Apr 23 '24 18:04 DerekSikes

When will the higher taxonomy be fixed? I just got a request for a report from the National Park Service and need to tell them when they can expect it. Thanks.

DerekSikes avatar Apr 25 '24 22:04 DerekSikes

i think this was updated a few days ago but working now Firefox_Screenshot_2024-05-07T03-06-15 343Z

mkoo avatar May 07 '24 03:05 mkoo