http://localhost:8080/trac/ticket/521 <p> I don't know if these matter? </p> <p> I found them when hunting for 502 errors. </p> <pre class="wiki">grep "Unsafe statement written to the binary log" /var/log/daemon.log | wc -l 343 </pre><p> Some examples: </p> <pre class="wiki">Mar 16 09:28:20 puffin mysqld: 130316 9:28:20 [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: DELETE FROM notifications_event WHERE created &lt; 1363426040 AND eid &lt; (SELECT MIN(eid) FROM notifications_queue) </pre><pre class="wiki">Mar 16 05:52:12 puffin mysqld: 130316 5:52:12 [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 INTO notifications_queue (uid, mdid, send_method, sid, module, eid, send_interval, language, cron, created, conditions) SELECT DISTINCT s.uid, s.mdid, s.send_method, s.sid, s.module, 61233, s.send_interval, s.language, s.cron, 1363413132, s.conditions FROM notifications s LEFT JOIN notifications_fields f ON s.sid = f.sid WHERE (s.status = 1) AND (s.event_type = 'node') AND (s.send_interval &gt;= 0) AND ((f.field = 'nid' AND f.intval = 30718) OR (f.field = 'type' AND f.value = 'profile') OR (f.field = 'author' AND f.intval = 16908)) GROUP BY s.uid, s.mdid, s.send_method, s.sid, s.module, s.send_interval, s. </pre> en-us /trac/chrome/site/TransitionNetwork-Logo-Web-Small.jpg http://localhost:8080/trac/ticket/521 Trac 0.12.5 chris Sat, 16 Mar 2013 09:46:57 GMT http://localhost:8080/trac/ticket/521#comment:1 http://localhost:8080/trac/ticket/521#comment:1 <ul> <li><strong>hours</strong> changed from <em>0.0</em> to <em>0.1</em> </li> <li><strong>totalhours</strong> changed from <em>0.0</em> to <em>0.1</em> </li> </ul> Ticket jim Sat, 16 Mar 2013 11:38:20 GMT http://localhost:8080/trac/ticket/521#comment:2 http://localhost:8080/trac/ticket/521#comment:2 <ul> <li><strong>priority</strong> changed from <em>minor</em> to <em>trivial</em> </li> </ul> <p> They're only warnings, and refer to a operations in the messaging/notifications Drupal systems. </p> <p> This is trivial IMHO, but worth leaving a ticket open for. </p> Ticket ed Wed, 08 May 2013 16:44:02 GMT http://localhost:8080/trac/ticket/521#comment:3 http://localhost:8080/trac/ticket/521#comment:3 <ul> <li><strong>milestone</strong> set to <em>Maintenance</em> </li> </ul> Ticket