Is there a way to put messages like 'Error Code: 1205. Lock wait timeout exceeded; try restarting transaction' into error.log in MySQL?

MySQL: 5.7.26

| log_error            | /var/log/mysql/error.lo  |
| log_error_verbosity  | 3                        |
| log_output           | FILE                     |

I've tried to change log_error_verbosity and log_warnings , I see the error message in cli (triggered it with transaction in another window), but not in error log.

  • See if log_warnings provides what you need. – Rick James May 22 '19 at 16:43

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.