MySQL Error 3991 – ER_RPL_ASYNC_RECONNECT_AUTO_POSITION_OFF

MySQL Error Message

Failed to enable Asynchronous Replication Connection
Failover feature. The CHANGE REPLICATION SOURCE TO
SOURCE_CONNECTION_AUTO_FAILOVER = 1 can only be set when
SOURCE_AUTO_POSITION option of CHANGE REPLICATION SOURCE TO is
enabled.

Reason for the Error

ER_RPL_ASYNC_RECONNECT_AUTO_POSITION_OFF
was added in 8.0.22.