[FINERACT-763] Travis CI builds are suddenly failing with a weird error

• Type: Bug
• Status: Resolved
• Priority: Critical
• Resolution: Fixed
• Fix Version/s: 1.4.0
• Assignee: Michael Vorburger
• Reporter: Michael Vorburger
• Created: 12/Jun/19 15:51
• Updated: 08/May/20 19:52
• Resolved: 12/Jun/19 19:16

Description

While having a closer look at the build failures of https://github.com/apache/fineract/pull/582, I noticed that the first time, in Build #162, it seems to have failed in the license test build step just due to `Could not GET 'https://jcenter.bintray.com/junit/junit/4.12/junit-4.12.jar'. Received status code 504 from server: Gateway Time-out` - but had clearly managed to do the initial build steps which set the password of the root user for the test database.

The second time (after I added the amended README to this PR), in Build #167 it fails early when it tries to set the mysql password like this:

$ echo "USE mysql;\nUPDATE user SET password=PASSWORD('mysql') WHERE user='root';\nFLUSH PRIVILEGES;\n" | mysql -u root
PAGER set to stdout
ERROR 1054 (42S22) at line 1: Unknown column 'password' in 'field list'
The command "echo "USE mysql;
UPDATE user SET password=PASSWORD('mysql') WHERE user='root';
FLUSH PRIVILEGES;
" | mysql -u root" failed and exited with 1 during .
Your build has been stopped.

What's noteworthy is that Build #162 ran with Build dist: trusty whereas Build #167 ran under Build dist: xenial ...

... this must be related to https://changelog.travis-ci.com/xenial-as-the-default-build-environment-99476

Issue Links

• blocks: FINERACT-761 Use of (unmaintained) Drizzle JDBC driver in Fineract Build (not run-time) prevents upgrading Flyway <- Gradle
• links to: GitHub Pull Request #585