Upon starting the application server after a fresh installation of Appian with MySQL as the primary database, an error similar to the following is printed to the console and written to the application server log:
ERROR liquibase - Error executing SQL UPDATE `DATABASECHANGELOG` SET `TAG` = '126.96.36.199' WHERE DATEEXECUTED = (SELECT MAX(DATEEXECUTED) FROM (SELECT DATEEXECUTED FROM `DATABASECHANGELOG`) AS X)
java.sql.SQLException: You can't specify target table 'DATABASECHANGELOG' for update in FROM clause
After seeing the above error, the application server will ultimately fail to start up.
The particular version of MySQL hosting the primary database does not support the complex queries required for the initial configuration of the primary database.
Ensure that the version of MySQL being used is 5.6.x. Any future or prior version to that of MySQL is currently unsupported for Appian 16.1 and earlier.
Alternatively, Appian 16.2 and later supports MySQL 5.7.x. Upgrade to Appian 16.2 or later if downgrading your database is not feasible.
Refer to the System Requirements page for more information.
This article applies to Appian 16.1 and earlier using MySQL as an RDBMS that hosts the primary database.
Last Reviewed: February 2017
© 2020 Appian. All rights reserved.