Mysql 5.7.17 crashes on Update query

[Ritesh Sharma]

Hi GUys,

I have MYSQL 5.7.17 installed on Windows server 2012 R2.

Workbench 6.3.8

When I run the below query the MYSQL.exe on the server crashes:

UPDATE `kpi`.`bed_board` SET `BED_STATUS`='VACANT' WHERE `SR_NO`='22'.

The log do not give any information please see below the last lines of the logs when mysql crashed.


11:15:31 UPDATE `kpi`.`bed_board` SET `BED_STATUS`='VACANT' WHERE `SR_NO`='22' Error Code: 1175. You are using safe update mode and you tried to update a table without a WHERE that uses a KEY column To disable safe mode, toggle the option in Preferences -> SQL Editor and reconnect. 0.296 sec

Regards,
RVS