Opened 7 years ago

Closed 7 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 7 years ago by chaos@bbn.com

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.

comment:2 Changed 7 years ago by chaos@bbn.com

Resolution: fixed
Status: newclosed

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.

Note: See TracTickets for help on using tickets.