We are having an issue with 3 environments that were shutdown unexpectedly when

Certified Lead Developer
We are having an issue with 3 environments that were shutdown unexpectedly when trying to connect to MySQL. When trying to restart jboss the primary DB cannot be initialized for what appears to be a mysql DATABASECHANGELOGLOCK issue i have come across in other forum posts.

"SQL UPDATE `DATABASECHANGELOGLOCK` SET `LOCKED` = 1, `LOCKEDBY` = 'hildev902.hil.us (192.168.#.###)', `LOCKGRANTED` = '2015-02-18 03:58:30.799' WHERE `ID` = 1 AND `LOCKED` = 0: 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.
"

The problem is that when I view the table I cannot find the entry listed in the log. For example LOCKEDBY` = 'hildev902.hil.us does not appear in the table. There is only one entry and it appears to be correct accordi...

server2_17.log

OriginalPostID-138771

OriginalPostID-138771

  Discussion posts and replies are publicly visible