rely on indexes more for missing project detection, and be a little safer about nulls and invalid versions. Also, increase logging in certain targeted places for debugging.