Failed to open log file mysql-bin000139 errno 2

The error message "Failed to open log (file './mysql-bin.000139', errno 2)" indicates that MySQL is unable to open the specified log file.

The "errno 2" part of the message refers to the specific error number, which in this case is "No such file or directory". This means that the log file './mysql-bin.000139' does not exist in the specified location.

To resolve this issue, you can try the following steps:

1. Check if the log file './mysql-bin.000139' actually exists in the specified location. Make sure the path and filename are correct.

2. Ensure that the MySQL user has the necessary permissions to access and read the log file. Check the file permissions and ownership.

3. If the log file does not exist, it might have been deleted or moved. In this case, you can try to locate a backup of the log file or check if there are any other log files available for recovery.

4. If you have a MySQL replication setup, it's possible that the log file is being streamed from another server. Ensure that the replication configuration is correct and that the log file is accessible from the replication source.

If none of these steps resolve the issue, you may need to seek further assistance or consult the MySQL documentation for more specific troubleshooting steps