[jira] [Commented] (FINERACT-763) Travis CI builds are suddenly failing with a weird error

["Petri Tuomola (Jira)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/FINERACT-763?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17102876#comment-17102876 ] 

Petri Tuomola commented on FINERACT-763:
----------------------------------------

I think this is because Xenial has MySQL 5.7 (instead of 5.5), and MySQL 5.7 has no 'password' column (the column is called 'authentication_string')

So to get this to work a) Fineract needs to work with MySQL 5.7 and the script needs to be updated to refer to the right column or b) MySQL in the image needs to be downgraded to 5.5.

> Travis CI builds are suddenly failing with a weird error
> --------------------------------------------------------
>
>                 Key: FINERACT-763
>                 URL: https://issues.apache.org/jira/browse/FINERACT-763
>             Project: Apache Fineract
>          Issue Type: Bug
>            Reporter: Michael Vorburger
>            Assignee: Michael Vorburger
>            Priority: Critical
>             Fix For: 1.4.0
>
>          Time Spent: 20m
>  Remaining Estimate: 0h
>
> 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:
> {noformat}
> $ 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.
> {noformat}
> What's noteworthy is that [Build #162|https://travis-ci.org/apache/fineract/builds/544611582#L6] ran with {{Build dist: trusty}} whereas [Build #167|https://travis-ci.org/apache/fineract/builds/544786072?utm_source=github_status] ran under {{Build dist: xenial}} ...
> ... this must be related to https://changelog.travis-ci.com/xenial-as-the-default-build-environment-99476



--
This message was sent by Atlassian Jira
(v8.3.4#803005)