store | blogs | forums | twitter | facebook | wiki | downloads | support portal
Atomic Secure Linux
It is currently Mon Oct 20, 2014 11:43 pm

» Feed - Atomicorp

All times are UTC - 5 hours [ DST ]




Post new topic Reply to topic  [ 2 posts ] 
Author Message
 Post subject: mysql errors from asl_db_rotate job
Unread postPosted: Thu May 12, 2011 4:40 am 
Offline
Forum Regular
Forum Regular

Joined: Tue Jul 15, 2008 2:38 pm
Posts: 778
Location: Sweden
Since about a week I've been getting quite a lot of errors like this in mysql.log

Code:
Statement may not be safe to log in statement format. Statement: DELETE FROM data WHERE id='1613976' AND server_id='1' LIMIT 1


It looks like they come from /var/asl/bin/asl_db_rotate

They don't look serious, but they keep filling up the logs. Anyway I can get rid of these?


Top
 Profile  
 
 Post subject: Re: mysql errors from asl_db_rotate job
Unread postPosted: Thu May 12, 2011 5:37 am 
Offline
Forum Regular
Forum Regular

Joined: Tue Jul 15, 2008 2:38 pm
Posts: 778
Location: Sweden
I love answering my own questions...

Adding
Code:
binlog-format=ROW

to my.cnf removes the errors.


Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 2 posts ] 

» Feed - Atomicorp

All times are UTC - 5 hours [ DST ]


Who is online

Users browsing this forum: No registered users and 2 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  
Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group