Symptoms

Crowd with a MySQL database generates an error similar to the following:

Binary logging not possible. Message: Transaction level 'READ-COMMITTED' in InnoDB is not safe for binlog mode 'STATEMENT'

Cause

You may encounter this problem if your Crowd MySQL database configuration has the following:

• Makes use of the InnoDB database storage engine (which is recommended)
  AND
• Uses MySQL's default binary logging format

Crowd uses the READ-COMMITTED transaction isolation level with MySQL, which currently only supports row-based binary logging. For more information about this, please refer to MySQL issue no. 40360.

Resolution

To overcome this problem, you must configure MySQL's binary logging format to use 'row-based' binary logging.