spark出现BINLOG_FORMAT = STATEMENT
错误解决:
Caused by: java.sql.SQLException: Cannot execute statement: impossible to write to binary log since BINLOG_FORMAT = STATEMENT and at least one table uses a storage engine limited to row-based logging. InnoDB is limited to row-logging when transaction isolation level is READ COMMITTED or READ UNCOMMITTED.
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:957)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3878)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3814)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2478)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2625)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2551)
at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1861)
at com.mysql.jdbc.PreparedStatement.executeUpdateInternal(PreparedStatement.java:2073)
at com.mysql.jdbc.PreparedStatement.executeBatchSerially(PreparedStatement.java:1751)
... 15 more
注意:如果出现以上mysql的错误,那么我们可以在sqlyog当中直接执行这一句即可
SET GLOBAL binlog_format=mixed;
最新文章
- Java IO 之 InputStream源码
- Core Java Volume I — 3.5. Operators
- 非阻塞式socket的select()用法
- ScrollView嵌套ListView嵌套GridView的上下拉以及加载更多
- java_小技巧
- getsockname和getpeername函数
- Windows消息机制(转)1
- Python3.5入门学习记录-条件控制
- BZOJ 3498 PA2009 Cakes(三元环处理)
- Hibernate配置文件的hbm2ddl.auto属性
- 浅谈如何让 Bootstrap 3兼容IE8浏览器
- 安装Navicat for MySQL
- TensorFlow从1到2(六)结构化数据预处理和心脏病预测
- gitlab安装后吃内存的解决办法
- 趋势:flex和grid使布局更简单
- 万维网(WWW)
- 如何使用maven优雅地管理项目版本号
- 剑指offer(19)顺时针打印矩阵
- idea 未实现接口红线提示,重复代码波浪线提示,自动换行,控制台输出内容自动换行
- linux shell实现 URL 编码/解码方法