2018-09-12 21:25:05 140193062299392 [Warning] Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement is unsafe because it uses a system function that may return a different value on the slave Statement: Update sum0028.summarytabledefinition SET LastExecOn = sysdate() WHERE updatefilename = 'SE041SumTADemoWeek'
2018-09-12 21:25:05 140193041082112 [Warning] Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement is unsafe because it uses a system function that may return a different value on the slave Statement: Update sum0028.summarytabledefinition SET LastExecOn = sysdate() WHERE updatefilename = 'SE041SumTA'
2018-09-12 21:25:05 140193055328000 [Warning] Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement is unsafe because it uses a system function that may return a different value on the slave Statement: Update sum0028.summarytabledefinition SET LastExecOn = sysdate() WHERE updatefilename = 'SE041SumTA'
2018-09-12 21:25:05 140193058359040 [Warning] 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 Statement: insert ignore into sum0029.sumdate select * from sum0000.sumdate
2018-09-12 21:25:05 140193058359040 [Warning] Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statements writing to a table with an auto-increment column after selecting from another table are unsafe because the order in which rows are retrieved determines what (if any) rows will be written. This order cannot be predicted and may differ on master and the slave Statement: insert ignore into sum0029.sumdate select * from sum0000.sumdate
2018-09-12 21:25:06 140193061693184 [Warning] Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement is unsafe because it uses a system function that may return a different value on the slave Statement: Update sum0020.summarytabledefinition SET LastExecOn = sysdate() WHERE updatefilename = 'SE041PDP_Summary'
2018-09-12 21:25:06 140193058359040 [Warning] 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 Statement: INSERT ignore INTO sum0029.summarytabledefinition select * from sum0000.summarytabledefinition
2018-09-12 21:25:06 140193039869696 [Warning] Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement is unsafe because it uses a system function that may return a different value on the slave Statement: Update sum0028.summarytabledefinition SET LastExecOn = sysdate() WHERE updatefilename = 'SE041SumTADemoMonth'
2018-09-12 21:25:06 140193151182592 [Warning] Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. The statement is unsafe because it uses a LIMIT clause. This is unsafe because the set of rows included cannot be predicted Statement: INSERT IGNORE INTO sum0028.tmp_yearsumrecid_770889 (recid) select stw.recid from sum0028.sumtayear_770889 stw , sum0028.sumdemostate_770889 sds, sum0028.sumdemo_770889 sd where stw.sumrouteid = sds.sumrouteid and stw.sumarupdt = '0' and sds.sumdemoid = sd.recid and sd.status = '1' order by stw.recid limit 200
2018-09-12 21:25:06 140193058359040 [Warning] Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statements writing to a table with an auto-increment column after selecting from another table are unsafe because the order in which rows are retrieved determines what (if any) rows will be written. This order cannot be predicted and may differ on master and the slave Statement: INSERT ignore INTO sum0029.summarytabledefinition select * from sum0000.summarytabledefinition
2018-09-12 21:25:06 140193151182592 [Warning] 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 Statement: INSERT IGNORE INTO sum0028.tmp_yearsumrecid_770889 (recid) select stw.recid from sum0028.sumtayear_770889 stw , sum0028.sumdemostate_770889 sds, sum0028.sumdemo_770889 sd where stw.sumrouteid = sds.sumrouteid and stw.sumarupdt = '0' and sds.sumdemoid = sd.recid and sd.status = '1' order by stw.recid limit 200
2018-09-12 21:25:06 140193068058368 [Warning] Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement is unsafe because it uses a system function that may return a different value on the slave Statement: Update sum0028.summarytabledefinition SET LastExecOn = sysdate() WHERE updatefilename = 'SE041SumTA'
2018-09-12 21:25:06 140193039566592 [Warning] 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 Statement: INSERT ignore sum0028.sumdate_768151 SELECT * FROM sum0028.sumdate
2018-09-12 21:25:06 140193039566592 [Warning] Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statements writing to a table with an auto-increment column after selecting from another table are unsafe because the order in which rows are retrieved determines what (if any) rows will be written. This order cannot be predicted and may differ on master and the slave Statement: INSERT ignore sum0028.sumdate_768151 SELECT * FROM sum0028.sumdate
2018-09-12 21:25:06 140193063208704 [Warning] Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. The statement is unsafe because it uses a LIMIT clause. This is unsafe because the set of rows included cannot be predicted Statement: INSERT IGNORE INTO sum0028.tmp_yearsumrecid_767947 (recid) select stw.recid from sum0028.sumtayear_767947 stw , sum0028.sumdemostate_767947 sds, sum0028.sumdemo_767947 sd where stw.sumrouteid = sds.sumrouteid and stw.sumarupdt = '0' and sds.sumdemoid = sd.recid and sd.status = '1' order by stw.recid limit 200
2018-09-12 21:25:06 140193063208704 [Warning] 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 Statement: INSERT IGNORE INTO sum0028.tmp_yearsumrecid_767947 (recid) select stw.recid from sum0028.sumtayear_767947 stw , sum0028.sumdemostate_767947 sds, sum0028.sumdemo_767947 sd where stw.sumrouteid = sds.sumrouteid and stw.sumarupdt = '0' and sds.sumdemoid = sd.recid and sd.status = '1' order by stw.recid limit 200
2018-09-12 21:25:08 140193058965248 [Warning] Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement is unsafe because it uses a system function that may return a different value on the slave Statement: Update sum0028.summarytabledefinition SET LastExecOn = sysdate() WHERE updatefilename = 'SE041SumTA'
2018-09-12 21:25:08 140193151182592 [Warning] Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement is unsafe because it uses a system function that may return a different value on the slave Statement: Update sum0028.summarytabledefinition SET LastExecOn = sysdate() WHERE updatefilename = 'SE041SumTADemoYear'
2018-09-12 21:25:08 140193044113152 [Warning] 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 Statement: INSERT ignore sum0020.sumdate_676107 SELECT * FROM sum0020.sumdate
2018-09-12 21:25:08 140193044113152 [Warning] Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statements writing to a table with an auto-increment column after selecting from another table are unsafe because the order in which rows are retrieved determines what (if any) rows will be written. This order cannot be predicted and may differ on master and the slave Statement: INSERT ignore sum0020.sumdate_676107 SELECT * FROM sum0020.sumdate
2018-09-12 21:25:09 140193063208704 [Warning] Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement is unsafe because it uses a system function that may return a different value on the slave Statement: Update sum0028.summarytabledefinition SET LastExecOn = sysdate() WHERE updatefilename = 'SE041SumTADemoYear'
2018-09-12 21:25:09 140193060480768 [Warning] Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. The statement is unsafe because it uses a LIMIT clause. This is unsafe because the set of rows included cannot be predicted Statement: INSERT IGNORE INTO sum0028.tmp_yearsumrecid_767899 (recid) select stw.recid from sum0028.sumtayear_767899 stw , sum0028.sumdemostate_767899 sds, sum0028.sumdemo_767899 sd where stw.sumrouteid = sds.sumrouteid and stw.sumarupdt = '0' and sds.sumdemoid = sd.recid and sd.status = '1' order by stw.recid limit 200
2018-09-12 21:25:09 140193060480768 [Warning] 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 Statement: INSERT IGNORE INTO sum0028.tmp_yearsumrecid_767899 (recid) select stw.recid from sum0028.sumtayear_767899 stw , sum0028.sumdemostate_767899 sds, sum0028.sumdemo_767899 sd where stw.sumrouteid = sds.sumrouteid and stw.sumarupdt = '0' and sds.sumdemoid = sd.recid and sd.status = '1' order by stw.recid limit 200
2018-09-12 21:25:11 140193060480768 [Warning] Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement is unsafe because it uses a system function that may return a different value on the slave Statement: Update sum0028.summarytabledefinition SET LastExecOn = sysdate() WHERE updatefilename = 'SE041SumTADemoYear'
2018-09-12 21:25:11 140193038960384 [Warning] Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. The statement is unsafe because it uses a LIMIT clause. This is unsafe because the set of rows included cannot be predicted Statement: INSERT IGNORE INTO sum0028.tmp_monthsumrecid_767904 (recid) select stw.recid from sum0028.sumtamonth_767904 stw , sum0028.sumdemostate_767904 sds, sum0028.sumdemo_767904 sd where stw.sumrouteid = sds.sumrouteid and stw.sumarupdt = '0' and sds.sumdemoid = sd.recid and sd.status = '1' order by stw.recid limit 200
2018-09-12 21:25:11 140193038960384 [Warning] 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 Statement: INSERT IGNORE INTO sum0028.tmp_monthsumrecid_767904 (recid) select stw.recid from sum0028.sumtamonth_767904 stw , sum0028.sumdemostate_767904 sds, sum0028.sumdemo_767904 sd where stw.sumrouteid = sds.sumrouteid and stw.sumarupdt = '0' and sds.sumdemoid = sd.recid and sd.status = '1' order by stw.recid limit 200
2018-09-12 21:25:11 140193057449728 [Warning] Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. The statement is unsafe because it uses a LIMIT clause. This is unsafe because the set of rows included cannot be predicted Statement: INSERT IGNORE INTO sum0028.tmp_yearsumrecid_768149 (recid) select stw.recid from sum0028.sumtayear_768149 stw , sum0028.sumdemostate_768149 sds, sum0028.sumdemo_768149 sd where stw.sumrouteid = sds.sumrouteid and stw.sumarupdt = '0' and sds.sumdemoid = sd.recid and sd.status = '1' order by stw.recid limit 200
2018-09-12 21:25:11 140193057449728 [Warning] 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 Statement: INSERT IGNORE INTO sum0028.tmp_yearsumrecid_768149 (recid) select stw.recid from sum0028.sumtayear_768149 stw , sum0028.sumdemostate_768149 sds, sum0028.sumdemo_768149 sd where stw.sumrouteid = sds.sumrouteid and stw.sumarupdt = '0' and sds.sumdemoid = sd.recid and sd.status = '1' order by stw.recid limit 200
2018-09-12 21:25:11 140193066239744 [Note] Suppressing warnings of type 'Statement is unsafe because it uses a system function that may return a different value on the slave' for up to 300 seconds because of flooding
2018-09-12 21:25:11 140193050478336 [Note] Suppressing warnings of type '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' for up to 300 seconds because of flooding
2018-09-12 21:25:11 140193050478336 [Warning] Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statements writing to a table with an auto-increment column after selecting from another table are unsafe because the order in which rows are retrieved determines what (if any) rows will be written. This order cannot be predicted and may differ on master and the slave Statement: INSERT ignore into sum0028.sumdate_768151 SELECT * FROM sum0028.sumdate
2018-09-12 21:25:15 140193062299392 [Warning] Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. The statement is unsafe because it uses a LIMIT clause. This is unsafe because the set of rows included cannot be predicted Statement: INSERT IGNORE INTO sum0028.tmp_yearsumrecid_770351 (recid) select stw.recid from sum0028.sumtayear_770351 stw , sum0028.sumdemostate_770351 sds, sum0028.sumdemo_770351 sd where stw.sumrouteid = sds.sumrouteid and stw.sumarupdt = '0' and sds.sumdemoid = sd.recid and sd.status = '1' order by stw.recid limit 200
2018-09-12 21:25:15 140193039869696 [Warning] Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. The statement is unsafe because it uses a LIMIT clause. This is unsafe because the set of rows included cannot be predicted Statement: INSERT IGNORE INTO sum0028.tmp_yearsumrecid_769921 (recid) select stw.recid from sum0028.sumtayear_769921 stw , sum0028.sumdemostate_769921 sds, sum0028.sumdemo_769921 sd where stw.sumrouteid = sds.sumrouteid and stw.sumarupdt = '0' and sds.sumdemoid = sd.recid and sd.status = '1' order by stw.recid limit 200
2018-09-12 21:25:18 140193063208704 [Warning] Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. The statement is unsafe because it uses a LIMIT clause. This is unsafe because the set of rows included cannot be predicted Statement: INSERT IGNORE INTO sum0028.tmp_yearsumrecid_767904 (recid) select stw.recid from sum0028.sumtayear_767904 stw , sum0028.sumdemostate_767904 sds, sum0028.sumdemo_767904 sd where stw.sumrouteid = sds.sumrouteid and stw.sumarupdt = '0' and sds.sumdemoid = sd.recid and sd.status = '1' order by stw.recid limit 200
2018-09-12 21:25:18 140193151182592 [Warning] Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. The statement is unsafe because it uses a LIMIT clause. This is unsafe because the set of rows included cannot be predicted Statement: INSERT IGNORE INTO sum0028.tmp_yearsumrecid_770340 (recid) select stw.recid from sum0028.sumtayear_770340 stw , sum0028.sumdemostate_770340 sds, sum0028.sumdemo_770340 sd where stw.sumrouteid = sds.sumrouteid and stw.sumarupdt = '0' and sds.sumdemoid = sd.recid and sd.status = '1' order by stw.recid limit 200
2018-09-12 21:25:18 140193058359040 [Warning] Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statements writing to a table with an auto-increment column after selecting from another table are unsafe because the order in which rows are retrieved determines what (if any) rows will be written. This order cannot be predicted and may differ on master and the slave Statement: insert ignore into sum0029.sumdate select * from sum0000.sumdate
2018-09-12 21:25:18 140193058359040 [Warning] Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statements writing to a table with an auto-increment column after selecting from another table are unsafe because the order in which rows are retrieved determines what (if any) rows will be written. This order cannot be predicted and may differ on master and the slave Statement: INSERT ignore INTO sum0029.summarytabledefinition select * from sum0000.summarytabledefinition
2018-09-12 21:25:19 140193068058368 [Note] Suppressing warnings of type 'The statement is unsafe because it uses a LIMIT clause. This is unsafe because the set of rows included cannot be predicted' for up to 300 seconds because of flooding
2018-09-12 21:25:19 140193060177664 [Warning] Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statements writing to a table with an auto-increment column after selecting from another table are unsafe because the order in which rows are retrieved determines what (if any) rows will be written. This order cannot be predicted and may differ on master and the slave Statement: INSERT ignore sum0020.sumdate_701865 SELECT * FROM sum0020.sumdate
2018-09-12 21:25:19 140193058359040 [Warning] Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statements writing to a table with an auto-increment column after selecting from another table are unsafe because the order in which rows are retrieved determines what (if any) rows will be written. This order cannot be predicted and may differ on master and the slave Statement: insert ignore into sum0029.sumdate select * from sum0000.sumdate
2018-09-12 21:25:21 140193058359040 [Note] Suppressing warnings of type 'Statements writing to a table with an auto-increment column after selecting from another table are unsafe because the order in which rows are retrieved determines what (if any) rows will be written. This order cannot be predicted and may differ on master and the slave' for up to 300 seconds because of flooding
2018-09-12 21:30:05 140193053812480 [Note] Suppressed 1487 unsafe warnings during the last 301 seconds
2018-09-12 21:30:05 140193053812480 [Warning] Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement is unsafe because it uses a system function that may return a different value on the slave Statement: Update sum0005.summarytabledefinition SET LastExecOn = sysdate() WHERE updatefilename = 'SE041SumTADemoMonth'
2018-09-12 21:30:05 140193060177664 [Warning] Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. The statement is unsafe because it uses a LIMIT clause. This is unsafe because the set of rows included cannot be predicted Statement: INSERT IGNORE INTO sum0028.tmp_yearsumrecid_767904 (recid) select stw.recid from sum0028.sumtayear_767904 stw , sum0028.sumdemostate_767904 sds, sum0028.sumdemo_767904 sd where stw.sumrouteid = sds.sumrouteid and stw.sumarupdt = '0' and sds.sumdemoid = sd.recid and sd.status = '1' order by stw.recid limit 200
2018-09-12 21:30:05 140193060177664 [Warning] 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 Statement: INSERT IGNORE INTO sum0028.tmp_yearsumrecid_767904 (recid) select stw.recid from sum0028.sumtayear_767904 stw , sum0028.sumdemostate_767904 sds, sum0028.sumdemo_767904 sd where stw.sumrouteid = sds.sumrouteid and stw.sumarupdt = '0' and sds.sumdemoid = sd.recid and sd.status = '1' order by stw.recid limit 200
2018-09-12 21:30:05 140193046537984 [Warning] Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. The statement is unsafe because it uses a LIMIT clause. This is unsafe because the set of rows included cannot be predicted Statement: INSERT IGNORE INTO sum0028.tmp_yearsumrecid_770708 (recid) select stw.recid from sum0028.sumtayear_770708 stw , sum0028.sumdemostate_770708 sds, sum0028.sumdemo_770708 sd where stw.sumrouteid = sds.sumrouteid and stw.sumarupdt = '0' and sds.sumdemoid = sd.recid and sd.status = '1' order by stw.recid limit 200
2018-09-12 21:30:05 140193046537984 [Warning] 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 Statement: INSERT IGNORE INTO sum0028.tmp_yearsumrecid_770708 (recid) select stw.recid from sum0028.sumtayear_770708 stw , sum0028.sumdemostate_770708 sds, sum0028.sumdemo_770708 sd where stw.sumrouteid = sds.sumrouteid and stw.sumarupdt = '0' and sds.sumdemoid = sd.recid and sd.status = '1' order by stw.recid limit 200
2018-09-12 21:30:06 140193060177664 [Warning] Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement is unsafe because it uses a system function that may return a different value on the slave Statement: Update sum0028.summarytabledefinition SET LastExecOn = sysdate() WHERE updatefilename = 'SE041SumTADemoYear'
2018-09-12 21:30:06 140193041082112 [Warning] Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. The statement is unsafe because it uses a LIMIT clause. This is unsafe because the set of rows included cannot be predicted Statement: INSERT IGNORE INTO sum0005.tmp_yearsumrecid_757549 (recid) select stw.recid from sum0005.sumtayear_757549 stw , sum0005.sumdemostate_757549 sds, sum0005.sumdemo_757549 sd where stw.sumrouteid = sds.sumrouteid and stw.sumarupdt = '0' and sds.sumdemoid = sd.recid and sd.status = '1' order by stw.recid limit 1000
2018-09-12 21:30:06 140193041082112 [Warning] 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 Statement: INSERT IGNORE INTO sum0005.tmp_yearsumrecid_757549 (recid) select stw.recid from sum0005.sumtayear_757549 stw , sum0005.sumdemostate_757549 sds, sum0005.sumdemo_757549 sd where stw.sumrouteid = sds.sumrouteid and stw.sumarupdt = '0' and sds.sumdemoid = sd.recid and sd.status = '1' order by stw.recid limit 1000
2018-09-12 21:30:07 140193063208704 [Warning] Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement is unsafe because it uses a system function that may return a different value on the slave Statement: Update sum0028.summarytabledefinition SET LastExecOn = sysdate() WHERE updatefilename = 'SE041SumTA'
2018-09-12 21:30:07 140193062299392 [Warning] Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement is unsafe because it uses a system function that may return a different value on the slave Statement: Update sum0006.summarytabledefinition SET LastExecOn = sysdate() WHERE updatefilename = 'SE041SumTADemo'
2018-09-12 21:30:07 140193046537984 [Warning] Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement is unsafe because it uses a system function that may return a different value on the slave Statement: Update sum0028.summarytabledefinition SET LastExecOn = sysdate() WHERE updatefilename = 'SE041SumTADemoYear'
2018-09-12 21:30:07 140193058965248 [Warning] Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. The statement is unsafe because it uses a LIMIT clause. This is unsafe because the set of rows included cannot be predicted Statement: INSERT IGNORE INTO sum0028.tmp_monthsumrecid_768151 (recid) select stw.recid from sum0028.sumtamonth_768151 stw , sum0028.sumdemostate_768151 sds, sum0028.sumdemo_768151 sd where stw.sumrouteid = sds.sumrouteid and stw.sumarupdt = '0' and sds.sumdemoid = sd.recid and sd.status = '1' order by stw.recid limit 200
2018-09-12 21:30:07 140193058965248 [Warning] 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 Statement: INSERT IGNORE INTO sum0028.tmp_monthsumrecid_768151 (recid) select stw.recid from sum0028.sumtamonth_768151 stw , sum0028.sumdemostate_768151 sds, sum0028.sumdemo_768151 sd where stw.sumrouteid = sds.sumrouteid and stw.sumarupdt = '0' and sds.sumdemoid = sd.recid and sd.status = '1' order by stw.recid limit 200
2018-09-12 21:30:08 140193151485696 [Warning] Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement is unsafe because it uses a system function that may return a different value on the slave Statement: Update sum0028.summarytabledefinition SET LastExecOn = sysdate() WHERE updatefilename = 'SE041SumTA'
2018-09-12 21:30:08 140193066239744 [Warning] Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement is unsafe because it uses a system function that may return a different value on the slave Statement: Update sum0029.summarytabledefinition SET LastExecOn = sysdate() WHERE updatefilename = 'SE041PDPD_Summary'
2018-09-12 21:30:08 140193058965248 [Warning] Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement is unsafe because it uses a system function that may return a different value on the slave Statement: Update sum0028.summarytabledefinition SET LastExecOn = sysdate() WHERE updatefilename = 'SE041SumTADemoMonth'
2018-09-12 21:30:08 140193042597632 [Warning] 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 Statement: INSERT ignore sum0028.sumdate_770206 SELECT * FROM sum0028.sumdate
2018-09-12 21:30:08 140193042597632 [Warning] Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statements writing to a table with an auto-increment column after selecting from another table are unsafe because the order in which rows are retrieved determines what (if any) rows will be written. This order cannot be predicted and may differ on master and the slave Statement: INSERT ignore sum0028.sumdate_770206 SELECT * FROM sum0028.sumdate
2018-09-12 21:30:09 140193055328000 [Warning] Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. The statement is unsafe because it uses a LIMIT clause. This is unsafe because the set of rows included cannot be predicted Statement: INSERT IGNORE INTO sum0006.tmp_sumrecid_809297 (recid) select stw.recid from sum0006.sumtaweek_809297 stw , sum0006.sumdemostate_809297 sds, sum0006.sumdemo_809297 sd where stw.sumrouteid = sds.sumrouteid and stw.sumarupdt = '0' and sds.sumdemoid = sd.recid and sd.status = '1' order by stw.recid limit 1000
2018-09-12 21:30:09 140193055328000 [Warning] 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 Statement: INSERT IGNORE INTO sum0006.tmp_sumrecid_809297 (recid) select stw.recid from sum0006.sumtaweek_809297 stw , sum0006.sumdemostate_809297 sds, sum0006.sumdemo_809297 sd where stw.sumrouteid = sds.sumrouteid and stw.sumarupdt = '0' and sds.sumdemoid = sd.recid and sd.status = '1' order by stw.recid limit 1000
2018-09-12 21:30:09 140193055328000 [Warning] Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement is unsafe because it uses a system function that may return a different value on the slave Statement: Update sum0006.summarytabledefinition SET LastExecOn = sysdate() WHERE updatefilename = 'SE041SumTADemoWeek'
2018-09-12 21:30:09 140193041082112 [Warning] Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement is unsafe because it uses a system function that may return a different value on the slave Statement: Update sum0005.summarytabledefinition SET LastExecOn = sysdate() WHERE updatefilename = 'SE041SumTADemoYear'
2018-09-12 21:30:10 140193038354176 [Warning] Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. The statement is unsafe because it uses a LIMIT clause. This is unsafe because the set of rows included cannot be predicted Statement: INSERT IGNORE INTO sum0028.tmp_sumrecid_772408 (recid) select stw.recid from sum0028.sumtaweek_772408 stw , sum0028.sumdemostate_772408 sds, sum0028.sumdemo_772408 sd where stw.sumrouteid = sds.sumrouteid and stw.sumarupdt = '0' and sds.sumdemoid = sd.recid and sd.status = '1' order by stw.recid limit 200
2018-09-12 21:30:10 140193038354176 [Warning] 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 Statement: INSERT IGNORE INTO sum0028.tmp_sumrecid_772408 (recid) select stw.recid from sum0028.sumtaweek_772408 stw , sum0028.sumdemostate_772408 sds, sum0028.sumdemo_772408 sd where stw.sumrouteid = sds.sumrouteid and stw.sumarupdt = '0' and sds.sumdemoid = sd.recid and sd.status = '1' order by stw.recid limit 200
2018-09-12 21:30:11 140193058359040 [Warning] 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 Statement: insert ignore into sum0028.sumdate select * from sum0000.sumdate
2018-09-12 21:30:11 140193058359040 [Warning] Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statements writing to a table with an auto-increment column after selecting from another table are unsafe because the order in which rows are retrieved determines what (if any) rows will be written. This order cannot be predicted and may differ on master and the slave Statement: insert ignore into sum0028.sumdate select * from sum0000.sumdate
2018-09-12 21:30:11 140193061693184 [Note] Suppressing warnings of type 'Statement is unsafe because it uses a system function that may return a different value on the slave' for up to 300 seconds because of flooding
2018-09-12 21:30:12 140193053812480 [Warning] Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. The statement is unsafe because it uses a LIMIT clause. This is unsafe because the set of rows included cannot be predicted Statement: INSERT IGNORE INTO sum0028.tmp_monthsumrecid_769923 (recid) select stw.recid from sum0028.sumtamonth_769923 stw , sum0028.sumdemostate_769923 sds, sum0028.sumdemo_769923 sd where stw.sumrouteid = sds.sumrouteid and stw.sumarupdt = '0' and sds.sumdemoid = sd.recid and sd.status = '1' order by stw.recid limit 200
2018-09-12 21:30:12 140193053812480 [Warning] 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 Statement: INSERT IGNORE INTO sum0028.tmp_monthsumrecid_769923 (recid) select stw.recid from sum0028.sumtamonth_769923 stw , sum0028.sumdemostate_769923 sds, sum0028.sumdemo_769923 sd where stw.sumrouteid = sds.sumrouteid and stw.sumarupdt = '0' and sds.sumdemoid = sd.recid and sd.status = '1' order by stw.recid limit 200
2018-09-12 21:30:12 140193058359040 [Note] Suppressing warnings of type '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' for up to 300 seconds because of flooding
2018-09-12 21:30:12 140193058359040 [Warning] Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statements writing to a table with an auto-increment column after selecting from another table are unsafe because the order in which rows are retrieved determines what (if any) rows will be written. This order cannot be predicted and may differ on master and the slave Statement: INSERT ignore INTO sum0028.summarytabledefinition select * from sum0000.summarytabledefinition
2018-09-12 21:30:13 140193043810048 [Warning] Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statements writing to a table with an auto-increment column after selecting from another table are unsafe because the order in which rows are retrieved determines what (if any) rows will be written. This order cannot be predicted and may differ on master and the slave Statement: INSERT ignore sum0028.sumdate_769921 SELECT * FROM sum0028.sumdate
2018-09-12 21:30:14 140193069270784 [Warning] Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. The statement is unsafe because it uses a LIMIT clause. This is unsafe because the set of rows included cannot be predicted Statement: INSERT IGNORE INTO sum0006.tmp_monthsumrecid_809297 (recid) select stw.recid from sum0006.sumtamonth_809297 stw , sum0006.sumdemostate_809297 sds, sum0006.sumdemo_809297 sd where stw.sumrouteid = sds.sumrouteid and stw.sumarupdt = '0' and sds.sumdemoid = sd.recid and sd.status = '1' order by stw.recid limit 1000
2018-09-12 21:30:14 140193039566592 [Warning] Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statements writing to a table with an auto-increment column after selecting from another table are unsafe because the order in which rows are retrieved determines what (if any) rows will be written. This order cannot be predicted and may differ on master and the slave Statement: INSERT ignore sum0020.sumdate_676107 SELECT * FROM sum0020.sumdate
2018-09-12 21:30:15 140193047447296 [Warning] Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statements writing to a table with an auto-increment column after selecting from another table are unsafe because the order in which rows are retrieved determines what (if any) rows will be written. This order cannot be predicted and may differ on master and the slave Statement: INSERT ignore sum0028.sumdate_770351 SELECT * FROM sum0028.sumdate
2018-09-12 21:30:16 140193046537984 [Warning] Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. The statement is unsafe because it uses a LIMIT clause. This is unsafe because the set of rows included cannot be predicted Statement: INSERT IGNORE INTO sum0028.tmp_monthsumrecid_768149 (recid) select stw.recid from sum0028.sumtamonth_768149 stw , sum0028.sumdemostate_768149 sds, sum0028.sumdemo_768149 sd where stw.sumrouteid = sds.sumrouteid and stw.sumarupdt = '0' and sds.sumdemoid = sd.recid and sd.status = '1' order by stw.recid limit 200
2018-09-12 21:30:16 140193055328000 [Note] Suppressing warnings of type 'The statement is unsafe because it uses a LIMIT clause. This is unsafe because the set of rows included cannot be predicted' for up to 300 seconds because of flooding
2018-09-12 21:30:18 140193060177664 [Warning] Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statements writing to a table with an auto-increment column after selecting from another table are unsafe because the order in which rows are retrieved determines what (if any) rows will be written. This order cannot be predicted and may differ on master and the slave Statement: INSERT ignore sum0020.sumdate_701865 SELECT * FROM sum0020.sumdate
2018-09-12 21:30:19 140193058965248 [Warning] Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statements writing to a table with an auto-increment column after selecting from another table are unsafe because the order in which rows are retrieved determines what (if any) rows will be written. This order cannot be predicted and may differ on master and the slave Statement: INSERT ignore sum0029.sumdate_772411 SELECT * FROM sum0029.sumdate
2018-09-12 21:30:21 140193058359040 [Warning] Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statements writing to a table with an auto-increment column after selecting from another table are unsafe because the order in which rows are retrieved determines what (if any) rows will be written. This order cannot be predicted and may differ on master and the slave Statement: insert ignore into sum0028.sumdate select * from sum0000.sumdate
2018-09-12 21:30:21 140193058359040 [Note] Suppressing warnings of type 'Statements writing to a table with an auto-increment column after selecting from another table are unsafe because the order in which rows are retrieved determines what (if any) rows will be written. This order cannot be predicted and may differ on master and the slave' for up to 300 seconds because of flooding