Bug #85962 useless error spamming the logs [ERROR] Got error 203 when reading table
Submitted: 16 Apr 2017 6:19
Reporter: Shane Bester (Platinum Quality Contributor) Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Server: Locking Severity:S4 (Feature request)
Version:8.0.2 OS:Any
Assigned to: CPU Architecture:Any

[16 Apr 2017 6:19] Shane Bester
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.