My site is down and I have absolutely no idea what to do.
I was trying to add a role to the service account but somehow seem to have removed ALL permissions (I think)
How can I fix this? I don't understand how I broke it and I have no idea how to fix it.
Can you post the content/output of your log?
I confirmed that the service account had no permissions and after a couple of hours I managed to find a set of roles that allowed the site to run again. It probably has way too many permissions now but at least it's working.
I'm amazed at how bad the Service Accounts/Persmissions UI is. I have no idea how I managed to delete all the permissions. Then to make things worse, the same UI doesn't seem to be able to add most back - I had to resort to the command line to add roles/cloudsql.client for example.
So, in short, I'm back up but still have a lot of crap to restore. Really unimpressed with Google Cloud UI and Docs in this area.