[Bug 295700] After upgrade to 4.8.1: QMYSQL3 is unable to execute statement due to BINLOG_FORMAT = STATEMENT

[Jonathan Marten]

https://bugs.kde.org/show_bug.cgi?id=295700

Jonathan Marten <jjm at keelhaul.me.uk> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|RESOLVED                    |REOPENED
                 CC|                            |jjm at keelhaul.me.uk
         Resolution|FIXED                       |---
     Ever confirmed|0                           |1

--- Comment #6 from Jonathan Marten <jjm at keelhaul.me.uk> ---
Reopening this bug because it appears that the change to the config file above
does not work with older MySQL versions:

$ /usr/sbin/mysqld --version
/usr/sbin/mysqld  Ver 5.1.61-log for pc-linux-gnu on i686 (Gentoo Linux
mysql-5.1.61)

$ cat /home/jjm/.local/share/akonadi/db_data/mysql.err 
120415 21:18:14 [ERROR] You need to use --log-bin to make --binlog-format work.
120415 21:18:14 [ERROR] Aborting

120415 21:18:14 [Note] /usr/sbin/mysqld: Shutdown complete

$ tail -7 /home/jjm/.local/share/akonadi/mysql.conf
# we are not using the binlog, but some users seem to have it enabled
nevertheless
# in combination with our transaction isolation level and older mysql versions
this can causes errors
# due to incompatible log formats (see e.g. bug 295700).
binlog_format=mixed

[client]
default-character-set=utf8
$

Removing the "binlog_format=mixed" line from mysql.conf allows MySQL and
therefore Akonadi to start.

-- 
You are receiving this mail because:
You are the assignee for the bug.