Opened 11 years ago
Closed 11 years ago
#164 closed (fixed)
the interface table in the database should have a last_updated field
Reported by: | chaos@bbn.com | Owned by: | somebody |
---|---|---|---|
Priority: | major | Milestone: | |
Component: | Database | Version: | |
Keywords: | Cc: | ||
Dependencies: |
Description
Some aggregates report ephemeral interfaces which were created to support experiments, and physical interfaces on resources may change over time.
The database should record last_updated for interface entries, and gmoc.py lookup should ignore old interfaces when reporting data, the same way it ignores old records of other types.
Change History (2)
comment:1 Changed 11 years ago by
comment:2 Changed 11 years ago by
Resolution: | → fixed |
---|---|
Status: | new → closed |
This has been resolved. The only issue is that Mitch has a dataset he's been using for testing on gmoc-db2, which does not yet have the last_updated column of interfaces. So whenever he restores from that dataset, it's necessary to reapply this fix.
However, he doesn't plan to do any more restores using that dataset, and that's peripheral to this ticket anyway. Closing.
This is higher priority than it might seem because, at the moment, there are a large number (approximately 300,000/host) of ephemeral interfaces for each ExoGENI worker node, due to experiments which have been run on those hosts. Because of the need to do over 2 million sequential downloads, it takes about 2 hours to download an ExoGENI site, which is probably too slow even for GEC16 purposes.