JDBCProductIndex eventsUpdated leaves empty events

[jmfee-usgs]

When a delete product is received after an event has been archived, the eventsUpdated method does not set event attributes which prevents archiving.
https://github.com/usgs/pdl/blob/master/src/gov/usgs/earthquake/indexer/JDBCProductIndex.java#L2048

The method should set event attributes (lat/lon/time/etc) based on the deleted product, rather than leaving the event record empty. Check whether event has event-like attributes (lat/lon/time) then update everything if possible.

[jmfee-usgs]

I used the following queryies to (manually) remove problem events from realtime indexes:

-- Events without products
DELETE e
FROM event e
LEFT JOIN productSummary p ON (p.eventid = e.id)
WHERE
  p.id is NULL;


-- Products without events
DELETE p
FROM productSummary p
LEFT JOIN event e ON (e.id = p.eventid)
WHERE
  p.eventid IS NOT NULL
  AND e.id is NULL;


-- Events created using deleted products
DELETE e, p
FROM event e
JOIN productSummary p ON (p.eventid = e.id)
WHERE
  e.updated IS NULL
  AND e.source IS NULL
  AND e.sourceCode IS NULL
  AND e.eventTime IS NULL
  AND e.latitude IS NULL
  AND e.longitude IS NULL
  AND e.depth IS NULL
  AND e.magnitude IS NULL
  AND (e.status IS NULL OR e.status='DELETE');