'The cook failed to start due to java.net.SocketException: Broken pipe' error

Issue

When attempting to connect to the database on macOS, the connection fails with the following error:

java.rmi.ConnectIOException: error during JRMP connection establishment; nested exception is:
java.net.SocketException: Broken pipe

Cause

This issue is caused by ESET blocking the remote process needed to establish a connection to the database (see discussions in DBE-21838 and linked tickets).

Solution

Updating to ESET version 8.1.200.0 or later has been reported to resolve this problem. If the issue continues, try temporarily disabling ESET and contact ESET support.

Alternatively, try adding the -Djava.net.preferIPv4Stack=true option to the VM options field in the Advanced tab of your data source properties (right-click the data source > Properties > Advanced tab): {width=70%}