Bug #105293 Column 'sys_opt_status' cannot be null
Submitted: 22 Oct 2021 9:31 Modified: 26 Nov 2021 12:35
Reporter: 军 董 Email Updates:
Status: Can't repeat Impact on me:
None 
Category:MySQL Server Severity:S3 (Non-critical)
Version:5.7.24 OS:Any
Assigned to: CPU Architecture:Any

[22 Oct 2021 9:31] 军 董 
Description:
tcpdump info：
e....update bi_so_status set sys_opt_status = 2
		 WHERE yn = 1 and
			id in(
			
				2503280235
			
			)/......#23000Column 'sys_opt_status' cannot be null	

mybatis-spring1.3.0
mysql-connector-java-5.1.39

How to repeat:
The database is updated normally after restarting, and an error occurs after running for a period of time, and the trigger condition is uncertain
[22 Oct 2021 14:15] MySQL Verification Team 
Thank you for the bug report. Same issue using mysql client or just with java? , Please check with 5.7.36 (5.7.24 is quite older).
[23 Oct 2021 1:37] 军 董 
During the test, no problems were found in mysql client. We checked the program and upgraded the version. Mysql Server was also upgraded from 5.7.21 to 5.7.24, but there was no solution. This problem is completely restored every time the database is restarted. The program enables debug, and tcpdump outputs logs with assigned fields. This problem has been plaguing for many days.
[25 Oct 2021 13:05] MySQL Verification Team 
Hi Mr. 军 董,

We are sorry, but you are using a very old release of the version 5.7. Please, upgrade to the latest release, which is 5.7.36.

If you still observe the same error with 5.7.36, then, please send us the rows which would enable us to repeat the bug.

Until you have performed all other tasks, we should be waiting on your feedback.
[26 Nov 2021 1:00] Bugs System 
No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".