Improve connection error messages

When metadata is synced, the metadata connection is marked as `critical` and Citus throws
```C
ereport(ERROR, (errmsg("failure on connection marked as essential: %s:%d",
connection->hostname, connection->port)));
```

Which is not useful at all. We should improve the error message by probably getting the actual error message.