Mysql 5.7.17 crashes on Update query
Posted by: Ritesh Sharma
Date: August 23, 2017 12:46AM

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


Options: ReplyQuote

Written By
Mysql 5.7.17 crashes on Update query
August 23, 2017 12:46AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.