Description:
after adding skip locked and nowait to my grammar, error log is containing useless spam:
Version: '8.0.2-dmr' socket: '' port: 3306 (Built on 2017/04/09)
2017-04-16T06:03:19.798249Z 0 [Note] InnoDB: Buffer pool(s) load completed at 170416 8:03:19
2017-04-16T06:04:32.540410Z 11 [ERROR] Got error 203 when reading table '.\test\t0042'
2017-04-16T06:04:33.491464Z 10 [ERROR] Got error 203 when reading table '.\test\t0029'
2017-04-16T06:05:42.149132Z 12 [ERROR] Got error 203 when reading table '.\test\t0016'
2017-04-16T06:05:43.682327Z 11 [ERROR] Got error 203 when reading table '.\test\t0023'
2017-04-16T06:06:02.960775Z 12 [ERROR] Got error 203 when reading table '.\test\t0035'
2017-04-16T06:06:09.170063Z 13 [ERROR] Got error 203 when reading table '.\test\t0042'
2017-04-16T06:07:07.821405Z 10 [ERROR] Got error 203 when reading table '.\test\t0002'
2017-04-16T06:07:51.390897Z 11 [ERROR] Got error 203 when reading table '.\test\t0035'
2017-04-16T06:09:13.280581Z 11 [ERROR] Got error 203 when reading table '.\test\t0012'
2017-04-16T06:09:14.249636Z 11 [ERROR] Got error 203 when reading table '.\test\t0035'
2017-04-16T06:09:23.996194Z 13 [ERROR] Got error 203 when reading table '.\test\t0023'
2017-04-16T06:11:45.452771Z 12 [ERROR] Got error 203 when reading table '.\test\t0024'
2017-04-16T06:11:48.390939Z 12 [ERROR] Got error 203 when reading table '.\test\t0023'
2017-04-16T06:12:30.877369Z 13 [ERROR] Got error 203 when reading table '.\test\t0002'
2017-04-16T06:14:30.320991Z 10 [ERROR] Got error 203 when reading table '.\test\t0002'
2017-04-16T06:15:27.469261Z 12 [ERROR] Got error 203 when reading table '.\test\t0000'
2017-04-16T06:15:33.647615Z 13 [ERROR] Got error 203 when reading table '.\test\t0023'
2017-04-16T06:16:09.341656Z 12 [ERROR] Got error 203 when reading table '.\test\t0023'
Tests expect to hit this sometimes :
3572 Do not wait for lock.
MySQL error code 203: Do not wait for lock
How to repeat:
random tests with skip locked and nowait.
Suggested fix:
Don't print these contextless messages into error log if not needed.