2642
93%
master: 94%

Ran 09 Mar 2020 06:06PM UTC

Jobs 1

Files 545

Run time 2min

Badge

Embed ▾

pending completion

Build # 2642

Build Type

Pull #962

travis-ci

Committed by

web-flow

Commit Message

Fix Postgresql migration script for non-admin users

The original file was dumped from a Postgres install on a developer machine (mine) that was created with a user having admin rights. This resulted in some statements being included that require admin capabilities to execute. This would fail for uses running on shared posgresql instances as non-admin users. We've known about this but avoided fixing it for fear of breaking existing users who had already installed and had `flyway_schema_history` tables with values.

At this point this is affecting more users than not so fixing it has value going forward.

For users that have already installed there are two options:
1. Set `spring.flyway.baseline-version=3.3.0` which will cause the system to skip evaluating the initial migration state
2. Update flyway schema history to have the new correct checksum: `update flyway_schema_history set checksum = -1400680873 where installed_rank = 1;`

Both of these options have been tested and work.

This should unblock new users from adopting Genie with non-admin installs of postgres.

New migration script tested against non-admin user on Postgres 12.

Should fix #767

Pull Request Pull Request #962: Fix Postgresql migration script for non-admin users

Run Details

13274 of 14297 relevant lines covered (92.84%)

0.93 hits per line

Uncovered Existing Lines

Lines	Coverage	∆	File
1	90.63	-3.13%	genie-agent/src/main/java/com/netflix/genie/agent/cli/HeartBeatCommand.java

Jobs

ID	Job ID	Ran	Files	Coverage
1	2642.1	09 Mar 2020 06:06PM UTC	545	92.84	Travis Job 2642.1

Netflix / genie / 2642
93%
master: 94%

README BADGES
x

Markdown

Textile

RDoc

HTML

Rst

Uncovered Existing Lines

Jobs

Source Files on build 2642

Netflix / genie / 2642 93% master: 94%

README BADGES x

Markdown

Textile

RDoc

HTML

Rst

Uncovered Existing Lines

Jobs

Source Files on build 2642

Netflix / genie / 2642
93%
master: 94%

README BADGES
x