8月, 2017 | 十字螺丝钉的DBA日记

Atlas ERROR 1105 (07000): Proxy Warning – Syntax Forbidden

公司的一套老Atlas执行delete时报如下错误

mysql> delete from sdb_jos_order_js t ;
ERROR 1105 (07000): Proxy Warning - Syntax Forbidden

1 2	mysql> delete from sdb_jos_order_js t ; ERROR 1105 (07000): Proxy Warning - Syntax Forbidden

猜测atlas对删除全表的操作做了限制。尝试加上limit限制删除的条数，依然报错

mysql> delete from sdb_jos_order_js t limit 1;
ERROR 1105 (07000): Proxy Warning - Syntax Forbidden

1 2	mysql> delete from sdb_jos_order_js t limit 1; ERROR 1105 (07000): Proxy Warning - Syntax Forbidden

看来也可能是没有where条件造成的，添加伪where条件测试，删除成功。 [crayon-662cf7aa15cc00437324