MySQL warnings after storage adjustment
Closed, DuplicatePublic
Actions

Assigned To

None

Authored By

	joshuaspence
	Nov 3 2014, 12:22 AM

Description

I'm getitng the follow warnings showing up very frequently in our MySQL logs after running ./bin/storage adjust:

141102 19:21:15 [Warning] Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. INSERT... ON DUPLICATE KEY UPDATE  on a table with more than one UNIQUE KEY is unsafe Statement: INSERT INTO `repository_statusmessage`
          (repositoryID, statusType, statusCode, parameters, epoch)
          VALUES (359, 'init', 'working', '{\"message\":\"Updating the working copy for repository \'CI\'.\"}', 1414974075)
          ON DUPLICATE KEY UPDATE
            statusCode = VALUES(statusCode),
            parameters = VALUES(parameters),
            epoch = VALUES(epoch)
141102 19:21:15 [Warning] Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. INSERT... ON DUPLICATE KEY UPDATE  on a table with more than one UNIQUE KEY is unsafe Statement: INSERT INTO `repository_statusmessage`
          (repositoryID, statusType, statusCode, parameters, epoch)
          VALUES (364, 'init', 'working', '{\"message\":\"Updating the working copy for repository \'VMM\'.\"}', 1414974075)
          ON DUPLICATE KEY UPDATE
            statusCode = VALUES(statusCode),
            parameters = VALUES(parameters),
            epoch = VALUES(epoch)