1、报错报文:
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
由于数据库重启,实现数据库主备同步的时候,owncloud出现了异常,浏览器F12查看报错500,具体报错内容红字
解决方法:
找到数据表,右键进入命令列介面,依次输入以下三个命令即可
mysql> STOP SLAVE;
mysql> SET GLOBAL binlog_format=ROW;
mysql> START SLAVE;
2、页面打开提示504
原因:程序挂掉了 (ps aux)
处理:执行nohup 语句报错 Permission denied
sudo chmod -R 777 ./***.sh
重启成功即可