What do I need to do to my database?

Matthew Murphy March 31, 2014
After a very long time (right after testing database connection and it works) I press next...

Sorry, we had some technical problems during your last operation.

Technical details

Log's referral number: a6bdf2ef-1c06-4325-bae3-758fe51cf4c0

Cause

Referer URL: http://173.166.254.97:8080/secure/SetupDatabase.jspa

com.opensymphony.module.propertyset.PropertyImplementationException: while inserting: [GenericEntity:OSPropertyEntry][id,10017][entityId,1][propertyKey,jira.i18n.language.index][type,5][entityName,jira.properties] (SQL Exception while executing the following:INSERT INTO propertyentry (ID, ENTITY_NAME, ENTITY_ID, PROPERTY_KEY, propertytype) VALUES (?, ?, ?, ?, ?) (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.))

1 answer

0 votes
Matthew Murphy March 31, 2014

Adding binlog_format=ROW to /etc/mysql/my.conf along with the other binlog settings got me past this error.

Suggest an answer

Log in or Sign up to answer