Opened 10 years ago

Closed 10 years ago

#164 closed (fixed)

the interface table in the database should have a last_updated field

Reported by: Owned by: somebody
Priority: major Milestone:
Component: Database Version:
Keywords: Cc:


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 lookup should ignore old interfaces when reporting data, the same way it ignores old records of other types.

Change History (2)

comment:1 Changed 10 years ago by

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 10 years ago by

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.