error code 1592 Unsafe statement written to the binary log using statement...
来源:互联网 发布:诺基亚软件下载专区 编辑:程序博客网 时间:2024/05/21 17:09
今天发现这样的警告
Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. INSERT IGNORE... SELECT is unsafe because the order in which rows are retrieved by the SELECT determines which (if any) rows are ignored. This order cannot be predicted and may differ on master and the slave.
原始语句是这样的
insert ignore into t_vehicleinfo_attr_stat(stat_type,attribute_value) select distinct 6,VehicleLogo_ from t_vehicleinfo where AccessTime_>= NAME_CONST('v_start_date',_latin1'2015-10-01 00:00:00' COLLATE 'latin1_swedish_ci') and AccessTime_< NAME_CONST('v_end_date',_latin1'2015-11-01 00:00:00' COLLATE 'latin1_swedish_ci') ;
说明
警告中原因说的很清楚,是因为在BINGLOG_FORMAT为STATEMENT的情况下,使用了INSERT IGNORE ... SELECT语句。这样的语句是不安全的,因为主库SLEECT
查询出的结果顺序可能和备库查询出来的不一样,前面的会插入,后面的会被忽略,这可能会导致结果可能不一样。
处理的方式,要么修改语句,将BINLOG_FORMAT改为MIXED或者ROW.
其他语句也可能会报这样的错,如果他们也是不安全的。
0 0
- error code 1592 Unsafe statement written to the binary log using statement...
- Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. S
- Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT.
- Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. S
- Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT.
- Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT.
- [Warning] Unsafe statement written to the binary log using statement format since 错误
- Last_Error: Error executing row event: 'Cannot execute statement: impossible to write to binary log
- ERROR 1665 (HY000): Cannot execute statement: impossible to write to binary log since BINLOG_FORMAT
- 15.13 The using statement
- Using the Switch Statement
- impossible to write to binary log since statement is in row format and BINLOG_FORMAT = STATEMENT
- Cannot execute statement: impossible to write to binary log since BINLOG_FORMAT = STATEMENT…
- [Error]Namespace declaration statement has to be the very first statement in the script
- [MySQL复制异常]Cannot execute statement: impossible to write to binary log since statement is in row for
- [MySQL复制异常]Cannot execute statement: impossible to write to binary log since statement is in row for
- mysql 警告提示Unsafe statement .The statement is unsafe because it uses a LIMIT clause
- Cause: java.sql.SQLException: Cannot execute statement: impossible to write to binary log
- java代理机制
- 【AMPPZ2014】【BZOJ4152】The Captain
- windows10任务管理器磁盘占用100%问题解决
- 宏、函数、宏函数的区别
- 程序设计原则
- error code 1592 Unsafe statement written to the binary log using statement...
- Hibernate_hibernate.cfg.xml加载流程源码分析
- 模板特化和偏特化
- ViewPager的切换动画
- RC充电计算
- Android教程 -08 ToolBar的使用和主题的介绍
- [leetcode] 52. N-Queens II
- nginx配置入门
- C++进行CGI的WEB编程