Started by user Stefan
Building in workspace /var/lib/jenkins/workspace/vps-db-migrate-develop
 > git rev-parse --is-inside-work-tree # timeout=10
Fetching changes from the remote Git repository
 > git config remote.origin.url https://github.com/irewind/vps-db-migrate.git # timeout=10
Fetching upstream changes from https://github.com/irewind/vps-db-migrate.git
 > git --version # timeout=10
using .gitcredentials to set credentials
 > git config --local credential.username stefanAlexandru # timeout=10
 > git config --local credential.helper store --file=/tmp/git2939696447128874808.credentials # timeout=10
 > git -c core.askpass=true fetch --tags --progress https://github.com/irewind/vps-db-migrate.git +refs/heads/*:refs/remotes/origin/*
 > git config --local --remove-section credential # timeout=10
 > git rev-parse refs/remotes/origin/develop^{commit} # timeout=10
 > git rev-parse refs/remotes/origin/origin/develop^{commit} # timeout=10
Checking out Revision a6e7f1870b2e0dbc640b793e3cc22e967625590f (refs/remotes/origin/develop)
 > git config core.sparsecheckout # timeout=10
 > git checkout -f a6e7f1870b2e0dbc640b793e3cc22e967625590f
 > git rev-list a6e7f1870b2e0dbc640b793e3cc22e967625590f # timeout=10
[vps-db-migrate-develop] $ /bin/sh -xe /tmp/hudson8896574638090178399.sh
+ export JAVA_HOME=/usr/lib/jvm/java-8-oracle/
+ export HOST=develop-irewind-com-2
+ export GRADLE_HOME=/opt/gradle-2.11
+ export PATH=/usr/lib/jvm/java-8-oracle/bin:/usr/lib/jvm/java-8-oracle/bin:/usr/local/bin:/usr/bin:/bin:/usr/local/games:/usr/games:/opt/gradle-2.11/bin
+ cd /var/lib/jenkins/workspace/vps-db-migrate-develop
+ chmod -R 777 .
+ cat
+ gradle clean flywayRepair -i
Starting Build
Settings evaluated using settings file '/master/settings.gradle'.
Projects loaded. Root project using build file '/var/lib/jenkins/workspace/vps-db-migrate-develop/build.gradle'.
Included projects: [root project 'vps-db-migrate-develop']
Evaluating root project 'vps-db-migrate-develop' using build file '/var/lib/jenkins/workspace/vps-db-migrate-develop/build.gradle'.
All projects evaluated.
Selected primary task 'clean' from project :
Selected primary task 'flywayRepair' from project :
Tasks to be executed: [task ':clean', task ':compileJava', task ':processResources', task ':classes', task ':compileTestJava', task ':processTestResources', task ':testClasses', task ':flywayRepair']
:clean (Thread[main,5,main]) started.
:clean
Executing task ':clean' (up-to-date check took 0.001 secs) due to:
  Task has not declared any outputs.
:clean (Thread[main,5,main]) completed. Took 0.014 secs.
:compileJava (Thread[main,5,main]) started.
:compileJava
file or directory '/var/lib/jenkins/workspace/vps-db-migrate-develop/src/main/java', not found
Skipping task ':compileJava' as it has no source files.
:compileJava UP-TO-DATE
:compileJava (Thread[main,5,main]) completed. Took 0.067 secs.
:processResources (Thread[main,5,main]) started.
:processResources
Executing task ':processResources' (up-to-date check took 0.128 secs) due to:
  Output file /var/lib/jenkins/workspace/vps-db-migrate-develop/gradle_build/resources/main has changed.
  Output file /var/lib/jenkins/workspace/vps-db-migrate-develop/gradle_build/resources/main/db/migration/PV-19.0-composition-profiles-alter.sql has been removed.
  Output file /var/lib/jenkins/workspace/vps-db-migrate-develop/gradle_build/resources/main/db/migration/PV-21.4-security-templates.sql has been removed.
:processResources (Thread[main,5,main]) completed. Took 0.338 secs.
:classes (Thread[main,5,main]) started.
:classes
Skipping task ':classes' as it has no actions.
:classes (Thread[main,5,main]) completed. Took 0.005 secs.
:compileTestJava (Thread[main,5,main]) started.
:compileTestJava
file or directory '/var/lib/jenkins/workspace/vps-db-migrate-develop/src/test/java', not found
Skipping task ':compileTestJava' as it has no source files.
:compileTestJava UP-TO-DATE
:compileTestJava (Thread[main,5,main]) completed. Took 0.003 secs.
:processTestResources (Thread[main,5,main]) started.
:processTestResources
file or directory '/var/lib/jenkins/workspace/vps-db-migrate-develop/src/test/resources', not found
Skipping task ':processTestResources' as it has no source files.
:processTestResources UP-TO-DATE
:processTestResources (Thread[main,5,main]) completed. Took 0.002 secs.
:testClasses (Thread[main,5,main]) started.
:testClasses
Skipping task ':testClasses' as it has no actions.
:testClasses UP-TO-DATE
:testClasses (Thread[main,5,main]) completed. Took 0.0 secs.
:flywayRepair (Thread[main,5,main]) started.
:flywayRepair
Executing task ':flywayRepair' (up-to-date check took 0.0 secs) due to:
  Task has not declared any outputs.
Flyway 3.2.1 by Boxfuse
Database: jdbc:mysql://develop-irewind-com-2/video_processor_secured_standalone?zeroDateTimeBehavior=convertToNull&characterEncoding=utf8&useCompression=true (MySQL 5.5)
Metadata table `video_processor_secured_standalone`.`schema_version` successfully repaired (execution time 00:00.140s).
Manual cleanup of the remaining effects the failed migration may still be required.
:flywayRepair (Thread[main,5,main]) completed. Took 0.998 secs.

BUILD SUCCESSFUL

Total time: 6.197 secs
Stopped 0 compiler daemon(s).

This build could be faster, please consider using the Gradle Daemon: https://docs.gradle.org/2.11/userguide/gradle_daemon.html
+ gradle clean flywayMigrate -i
Starting Build
Settings evaluated using settings file '/master/settings.gradle'.
Projects loaded. Root project using build file '/var/lib/jenkins/workspace/vps-db-migrate-develop/build.gradle'.
Included projects: [root project 'vps-db-migrate-develop']
Evaluating root project 'vps-db-migrate-develop' using build file '/var/lib/jenkins/workspace/vps-db-migrate-develop/build.gradle'.
All projects evaluated.
Selected primary task 'clean' from project :
Selected primary task 'flywayMigrate' from project :
Tasks to be executed: [task ':clean', task ':compileJava', task ':processResources', task ':classes', task ':compileTestJava', task ':processTestResources', task ':testClasses', task ':flywayMigrate']
:clean (Thread[main,5,main]) started.
:clean
Executing task ':clean' (up-to-date check took 0.001 secs) due to:
  Task has not declared any outputs.
:clean (Thread[main,5,main]) completed. Took 0.011 secs.
:compileJava (Thread[main,5,main]) started.
:compileJava
file or directory '/var/lib/jenkins/workspace/vps-db-migrate-develop/src/main/java', not found
Skipping task ':compileJava' as it has no source files.
:compileJava UP-TO-DATE
:compileJava (Thread[main,5,main]) completed. Took 0.022 secs.
:processResources (Thread[main,5,main]) started.
:processResources
Executing task ':processResources' (up-to-date check took 0.114 secs) due to:
  Output file /var/lib/jenkins/workspace/vps-db-migrate-develop/gradle_build/resources/main has changed.
  Output file /var/lib/jenkins/workspace/vps-db-migrate-develop/gradle_build/resources/main/db/migration/PV-19.0-composition-profiles-alter.sql has been removed.
  Output file /var/lib/jenkins/workspace/vps-db-migrate-develop/gradle_build/resources/main/db/migration/PV-21.4-security-templates.sql has been removed.
:processResources (Thread[main,5,main]) completed. Took 0.251 secs.
:classes (Thread[main,5,main]) started.
:classes
Skipping task ':classes' as it has no actions.
:classes (Thread[main,5,main]) completed. Took 0.001 secs.
:compileTestJava (Thread[main,5,main]) started.
:compileTestJava
file or directory '/var/lib/jenkins/workspace/vps-db-migrate-develop/src/test/java', not found
Skipping task ':compileTestJava' as it has no source files.
:compileTestJava UP-TO-DATE
:compileTestJava (Thread[main,5,main]) completed. Took 0.003 secs.
:processTestResources (Thread[main,5,main]) started.
:processTestResources
file or directory '/var/lib/jenkins/workspace/vps-db-migrate-develop/src/test/resources', not found
Skipping task ':processTestResources' as it has no source files.
:processTestResources UP-TO-DATE
:processTestResources (Thread[main,5,main]) completed. Took 0.006 secs.
:testClasses (Thread[main,5,main]) started.
:testClasses
Skipping task ':testClasses' as it has no actions.
:testClasses UP-TO-DATE
:testClasses (Thread[main,5,main]) completed. Took 0.003 secs.
:flywayMigrate (Thread[main,5,main]) started.
:flywayMigrate
Executing task ':flywayMigrate' (up-to-date check took 0.0 secs) due to:
  Task has not declared any outputs.
Flyway 3.2.1 by Boxfuse
Database: jdbc:mysql://develop-irewind-com-2/video_processor_secured_standalone?zeroDateTimeBehavior=convertToNull&characterEncoding=utf8&useCompression=true (MySQL 5.5)
Validated 67 migrations (execution time 00:00.089s)
Current version of schema `video_processor_secured_standalone`: 22.2
Migrating schema `video_processor_secured_standalone` to version 22.3 - acl-migration-oid-with-location-as-parent
DB: Unknown column 'entity.locatlocationion_id' in 'on clause' (SQL State: 42S22 - Error Code: 1054)
Migration of schema `video_processor_secured_standalone` to version 22.3 failed! Please restore backups and roll back database and code!
:flywayMigrate FAILED
:flywayMigrate (Thread[main,5,main]) completed. Took 2 mins 31.236 secs.

FAILURE: Build failed with an exception.

* What went wrong:
Execution failed for task ':flywayMigrate'.
> Error occurred while executing flywayMigrate

  Migration PV-22.3-acl-migration-oid-with-location-as-parent.sql failed
  ----------------------------------------------------------------------
  SQL State  : 42S22
  Error Code : 1054
  Message    : Unknown column 'entity.locatlocationion_id' in 'on clause'
  Location   : db/migration/PV-22.3-acl-migration-oid-with-location-as-parent.sql (/var/lib/jenkins/workspace/vps-db-migrate-develop/gradle_build/resources/main/db/migration/PV-22.3-acl-migration-oid-with-location-as-parent.sql)
  Line       : 204
  Statement  : INSERT INTO `acl_object_identity`(`object_id_class`, `object_id_identity`, `parent_object`, `entries_inheriting`)
  SELECT class.id, entity.id, parent.id, 1 FROM `acl_class` AS class, `irw_sessions` AS entity
  INNER JOIN `acl_object_identity` AS parent
  ON parent.object_id_identity=entity.locatlocationion_id
    AND parent.object_id_class=(SELECT location.id FROM `acl_class` AS location
                                WHERE location.class='com.irewind.processor.app.domain.jpa.Location')
  WHERE class.class = 'com.irewind.processor.app.domain.jpa.Session'

  Unknown column 'entity.locatlocationion_id' in 'on clause'

* Try:
Run with --stacktrace option to get the stack trace. Run with --debug option to get more log output.

BUILD FAILED

Total time: 2 mins 36.651 secs
Stopped 0 compiler daemon(s).
Build step 'Execute shell' marked build as failure
Sending e-mails to: dragos.repta@dc-tech.ro micu.adrian@dc-tech.ro
Notifying upstream projects of job completion
Finished: FAILURE