Installation Database Error: Impossible to write to binary log since BINLOG_FORMAT = STATEMENT

doc_answered
installation
9.1.x
help

#1

Hi, I am trying to install the latest OwnCloud 9.1.0 on my server. I attempted to configure the database for MySQL/MariaDB. (Username, database name, etc were all good.)

I received the following error from OwnCloud:

An exception occured whiel executing 'INSERT INTO' oc_users' ('uid', 'password') VALUES(?,?)' with params [something something]: SQLSTATE[HY000]: General Error: 1665 Cannot execute statement: impossible to write to binary log since BINLOG_FORMAT = STATEMENT and at least one table uses a storage engine limited to row-based logging. InnoDB is limited to row-logging when transaction isolation level is READ COMMITTED or READ UNCOMMITTED.

My server administrator gave me the following replies:

After looking at the install instructions on this, it doesn't look like it's going to be supported here as the following is needed and cannot be changed due to other ecommerce software needs. :confused:

Database Requirements for MySQL / MariaDB¶

The following is currently required if you’re running ownCloud together with a MySQL / MariaDB database:

Disabled or BINLOG_FORMAT = MIXED configured Binary Logging

Maybe I'm reading their site wrong, and it's not required, but the error you presented showed from a quick search that they need a specific bin log format, which would break all sites using innodb, including your forums. That's not something that will be changed as it's needed for innodb configs, recovery, etc.

Can someone advise or provide a workaround solution?


#2

Hi,

there is no fix / workaround available. ownCloud requires that setting as documented at various places:

https://doc.owncloud.org/server/9.1/admin_manual/installation/system_requirements.html#database-requirements-for-mysql-mariadb

https://doc.owncloud.org/server/9.1/admin_manual/configuration_database/linux_database_configuration.html#db-binlog-label

and so on.

However the statement of the support that it will break your site is most likely wrong. Binary logging is no requirement for running any websites / forums and not even enabled by default on most environments out there.

And even setting the binary log to mixed would also only break something if "replication" to multiple MySQL / MariaDB instances (clustering) is in use.


#3

A good overview over the Binary Log topic is also given here:

https://mariadb.com/kb/en/mariadb/binary-log/


#4

Thanks for the response.