Bug #66140 1592 Unsafe statement written to the binary log using statement format
Submitted: 1 Aug 2012 11:36 Modified: 1 Sep 2012 13:37
Reporter: Mark Rouse Email Updates:
Status: No Feedback Impact on me:
None 
Category:MySQL Server: Errors Severity:S3 (Non-critical)
Version:5.5.20 Server OS:Windows (Win7 64-bit)
Assigned to: CPU Architecture:Any
Tags: CURRENT_USER(), warnings

[1 Aug 2012 11:36] Mark Rouse
Description:
I have put together a stored procedure that uses the CURRENT_USER() function in the select query (which is part of my insert into statement) and when it runs, I get the following warning:

1592 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.

I don't have replication setup and not using it.  I only have 1 server.

How to repeat:
Write any stored procedure that uses the CURRENT_USER() to perhaps update a column in a specified table.
[1 Aug 2012 13:37] Valeriy Kravchuk
Please, check if the same problem still happens with a newer version, 5.5.24 at least. If it does, please, send your my.cnf file content.
[1 Aug 2012 13:38] Valeriy Kravchuk
Sorry, my.ini (I had not noted initially that you are on Windows).
[2 Sep 2012 1:00] Bugs System
No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".