解决 "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. Statement is unsafe because it accesses a non-transactional table after accessing a transactional table within the same transaction."

To solve this issue, set binlog_format as mixed:

FLUSH TABLES WITH READ LOCK;

FLUSH LOGS; 

SET GLOBAL binlog_format = 'MIXED'; 

FLUSH LOGS; 

UNLOCK TABLES;

 

奇怪的是,本地直接执行的代码没有这个问题, 放到django-celery中去就报这个错误