Error collecting changes for VCS repository
I've been trying to get TeamCity to detect changes in my repo, but i'm having trouble getting it to work. I get the following errors in TeamCity after i push new changes to my repo:
Error collecting changes for VCS repository '"my repo here"'
jetbrains.buildServer.serverSide.db.UnexpectedDBException: Unexpected exception SQLException: SQL error when doing 'DML query'
SQL query: SQL DML: insert into vcs_history (modification_id, user_name, description, change_date, vcs_root_id, version, display_version, changes_count, register_date) values (?, ?, ?, ?, ?, ?, ?, ?, ?) | PARAMETERS: 14, "ME", "app not APP\n", 1504605932000, 2, "cb906a606551ef1275a59f5b3918847524dc7fe6", "cb906a606551ef1275a59f5b3918847524dc7fe6", 1, 1504607230094
SQLexception:Cannotexecutestatement:impossibletowritetobinarylogsinceBINLOG_FORMAT=STATEMENTandatleastonetableusesastorageenginelimitedtorow-basedlogging. InnoDB islimitedtorow-loggingwhentransactionisolationlevelisREADCOMMITTEDorREADUNCOMMITTED.
I already tried the following on the MySQL server:
SET GLOBAL binlog_format = 'MIXED'; But that doesn't seem to have done anything.
Any ideas?
Please sign in to leave a comment.
I fixed it. i THOUGHT i had set the binlog_format to mixed. Turns out i didn't, and when i actually set it to mixed it worked.