We are installing appian 7.1 on windows 32 bit with MySQL 5.6, we are following

mohanp over 11 years ago

We are installing appian 7.1 on windows 32 bit with MySQL 5.6, we are following installation documentation and did all the required changes. we are getting following error while starting Jboss..
ERROR liquibase - Error executing SQL INSERT INTO `DATABASECHANGELOGLOCK` (`ID`, `LOCKED`) VALUES (1, 0)
java.sql.SQLException: 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.

Need urgent help on this..Thanks..!!...

Discussion posts and replies are publicly visible

0 Sathya Srinivasan
Appian Employee
over 11 years ago

Seems like a MYSQL issue.
See dev.mysql.com/.../binary-log-mixed.html
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 mohanp over 11 years ago

Sathya Thanks for your response..problem has been resolved now..deleting the table named as databasechangeloglock and restarting jboss again works fine..i got this solution at below link..
forum.liquibase.org/.../message-regarding-an-empty-result-set-for-databasechangeloglock
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Medhat Galal
Appian Employee
over 11 years ago

Is the 32 bit windows used for development purposes?
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel