Skip to content

Instantly share code, notes, and snippets.

Embed
What would you like to do?
C:\stamps>gradlew flywaymigrate -i
Starting Build
Settings evaluated using settings file 'C:\stamps\settings.gradle'.
Projects loaded. Root project using build file 'C:\stamps\build.gradle'.
Included projects: [root project 'stamps', project ':optimizer', project ':services']
Evaluating root project 'stamps' using build file 'C:\stamps\build.gradle'.
Configuring agent
Evaluating project ':optimizer' using build file 'C:\stamps\optimizer\build.gradle'.
Compiling build file 'C:\stamps\optimizer\build.gradle' using SubsetScriptTransformer.
Compiling build file 'C:\stamps\optimizer\build.gradle' using BuildScriptTransformer.
Configuring agent
Evaluating project ':services' using build file 'C:\stamps\services\build.gradle'.
Compiling build file 'C:\stamps\services\build.gradle' using SubsetScriptTransformer.
Compiling build file 'C:\stamps\services\build.gradle' using BuildScriptTransformer.
file or directory 'C:\stamps\services\src\main\resources\db\pendingmigration', not found
Configuring agent
All projects evaluated.
Selected primary task 'flywayMigrate' from project :
Tasks to be executed: [task ':optimizer:compileJava', task ':optimizer:processResources', task ':optimizer:classes', task ':optimizer:jar', task ':services:compileJava', task ':services:processResources', task ':services:classes', task ':services:compileTestJav
a', task ':services:processTestResources', task ':services:testClasses', task ':services:flywayMigrate']
:optimizer:compileJava (Thread[main,5,main]) started.
:optimizer:compileJava
Adding implicit managed exclusion rules to starter DefaultExternalModuleDependency{group='org.springframework.boot', name='spring-boot-starter-web', version='null', configuration='default'}
Adding implicit managed exclusion rules to starter DefaultExternalModuleDependency{group='org.springframework.boot', name='spring-boot-starter-data-jpa', version='null', configuration='default'}
Adding implicit managed exclusion rules to starter DefaultExternalModuleDependency{group='org.springframework.boot', name='spring-boot-starter-data-rest', version='null', configuration='default'}
Adding implicit managed exclusion rules to starter DefaultExternalModuleDependency{group='org.springframework.boot', name='spring-boot-starter-actuator', version='null', configuration='default'}
Adding implicit managed exclusion rules to starter DefaultExternalModuleDependency{group='org.springframework.boot', name='spring-boot-starter-websocket', version='null', configuration='default'}
Executing task ':optimizer:compileJava' (up-to-date check took 0.592 secs) due to:
Output file C:\stamps\optimizer\build\classes\main\com\mai\billetoptimizer\model\algorithm\search\cbp\ColorBinPack$StartTimeBin.class has changed.
Output file C:\stamps\optimizer\build\classes\main\com\mai\billetoptimizer\model\algorithm\search\cbp\ColorBinPack$TemporalBucket.class has changed.
Output file C:\stamps\optimizer\build\classes\main\com\mai\billetoptimizer\model\work\TaskList.class has changed.
All input files are considered out-of-date for incremental task ':optimizer:compileJava'.
Compiling with JDK Java compiler API.
Note: Some input files use or override a deprecated API.
Note: Recompile with -Xlint:deprecation for details.
Note: C:\stamps\optimizer\src\main\java\com\mai\billetoptimizer\util\NavigableSetMultimap.java uses unchecked or unsafe operations.
Note: Recompile with -Xlint:unchecked for details.
:optimizer:compileJava (Thread[main,5,main]) completed. Took 3.716 secs.
:optimizer:processResources (Thread[main,5,main]) started.
:optimizer:processResources
file or directory 'C:\stamps\optimizer\src\main\resources', not found
Skipping task ':optimizer:processResources' as it has no source files.
:optimizer:processResources UP-TO-DATE
:optimizer:processResources (Thread[main,5,main]) completed. Took 0.008 secs.
:optimizer:classes (Thread[main,5,main]) started.
:optimizer:classes
Skipping task ':optimizer:classes' as it has no actions.
:optimizer:classes (Thread[main,5,main]) completed. Took 0.006 secs.
:optimizer:jar (Thread[main,5,main]) started.
:optimizer:jar
Executing task ':optimizer:jar' (up-to-date check took 0.042 secs) due to:
Input file C:\stamps\optimizer\build\classes\main\com\mai\billetoptimizer\model\algorithm\search\cbp\ColorBinPack$StartTimeBin.class has changed.
Input file C:\stamps\optimizer\build\classes\main\com\mai\billetoptimizer\model\algorithm\search\cbp\ColorBinPack$TemporalBucket.class has changed.
Input file C:\stamps\optimizer\build\classes\main\com\mai\billetoptimizer\model\work\TaskList.class has changed.
:optimizer:jar (Thread[main,5,main]) completed. Took 0.28 secs.
:services:compileJava (Thread[main,5,main]) started.
:services:compileJava
Adding implicit managed exclusion rules to starter DefaultExternalModuleDependency{group='org.springframework.boot', name='spring-boot-starter-web', version='null', configuration='default'}
Adding implicit managed exclusion rules to starter DefaultExternalModuleDependency{group='org.springframework.boot', name='spring-boot-starter-data-jpa', version='null', configuration='default'}
Adding implicit managed exclusion rules to starter DefaultExternalModuleDependency{group='org.springframework.boot', name='spring-boot-starter-data-rest', version='null', configuration='default'}
Adding implicit managed exclusion rules to starter DefaultExternalModuleDependency{group='org.springframework.boot', name='spring-boot-starter-actuator', version='null', configuration='default'}
Executing task ':services:compileJava' (up-to-date check took 0.236 secs) due to:
Output file C:\stamps\services\build\classes\main\mil\navy\onr\stamps\db\dto\analysis\NmrsStudyOmShipclassWatchstationDetailsDTO.class has changed.
Output file C:\stamps\services\build\classes\main\mil\navy\onr\stamps\db\dto\analysis\NmrsStudyWatchstationMappingDTO.class has changed.
Output file C:\stamps\services\build\classes\main\mil\navy\onr\stamps\controller\analysis\OMAnalysisController.class has changed.
All input files are considered out-of-date for incremental task ':services:compileJava'.
Compiling with JDK Java compiler API.
Note: C:\stamps\services\src\main\java\mil\navy\onr\stamps\service\analysis\OmAnalysisServiceImpl.java uses unchecked or unsafe operations.
Note: Recompile with -Xlint:unchecked for details.
:services:compileJava (Thread[main,5,main]) completed. Took 1.951 secs.
:services:processResources (Thread[main,5,main]) started.
:services:processResources
Executing task ':services:processResources' (up-to-date check took 0.256 secs) due to:
Output file C:\stamps\services\build\resources\main\application.local.properties has changed.
Output file C:\stamps\services\build\resources\main\application.remote.properties has changed.
:services:processResources (Thread[main,5,main]) completed. Took 0.932 secs.
:services:classes (Thread[main,5,main]) started.
:services:classes
Skipping task ':services:classes' as it has no actions.
:services:classes (Thread[main,5,main]) completed. Took 0.002 secs.
:services:compileTestJava (Thread[main,5,main]) started.
:services:compileTestJava
Adding managed exclusion rule commons-logging:commons-logging to DefaultExternalModuleDependency{group='org.springframework.boot', name='spring-boot-starter-test', version='null', configuration='default'}
Adding implicit managed exclusion rules to starter DefaultExternalModuleDependency{group='org.springframework.boot', name='spring-boot-starter-test', version='null', configuration='default'}
Adding implicit managed exclusion rules to starter DefaultExternalModuleDependency{group='org.springframework.boot', name='spring-boot-starter-web', version='null', configuration='default'}
Adding implicit managed exclusion rules to starter DefaultExternalModuleDependency{group='org.springframework.boot', name='spring-boot-starter-data-jpa', version='null', configuration='default'}
Adding implicit managed exclusion rules to starter DefaultExternalModuleDependency{group='org.springframework.boot', name='spring-boot-starter-data-rest', version='null', configuration='default'}
Adding implicit managed exclusion rules to starter DefaultExternalModuleDependency{group='org.springframework.boot', name='spring-boot-starter-actuator', version='null', configuration='default'}
Executing task ':services:compileTestJava' (up-to-date check took 0.222 secs) due to:
No history is available.
All input files are considered out-of-date for incremental task ':services:compileTestJava'.
Compiling with JDK Java compiler API.
Note: C:\stamps\services\src\test\java\mil\navy\onr\stamps\service\analysis\OMAnalysisServiceTest.java uses unchecked or unsafe operations.
Note: Recompile with -Xlint:unchecked for details.
:services:compileTestJava (Thread[main,5,main]) completed. Took 0.726 secs.
:services:processTestResources (Thread[main,5,main]) started.
:services:processTestResources
file or directory 'C:\stamps\services\src\test\resources', not found
Skipping task ':services:processTestResources' as it has no source files.
:services:processTestResources UP-TO-DATE
:services:processTestResources (Thread[main,5,main]) completed. Took 0.007 secs.
:services:testClasses (Thread[main,5,main]) started.
:services:testClasses
Skipping task ':services:testClasses' as it has no actions.
:services:testClasses (Thread[main,5,main]) completed. Took 0.001 secs.
:services:flywayMigrate (Thread[main,5,main]) started.
:services:flywayMigrate
Executing task ':services:flywayMigrate' (up-to-date check took 0.001 secs) due to:
Task has not declared any outputs.
Adding managed exclusion rule commons-logging:commons-logging to DefaultExternalModuleDependency{group='org.springframework.boot', name='spring-boot-starter-test', version='null', configuration='default'}
Adding implicit managed exclusion rules to starter DefaultExternalModuleDependency{group='org.springframework.boot', name='spring-boot-starter-test', version='null', configuration='default'}
Adding implicit managed exclusion rules to starter DefaultExternalModuleDependency{group='org.springframework.boot', name='spring-boot-starter-web', version='null', configuration='default'}
Adding implicit managed exclusion rules to starter DefaultExternalModuleDependency{group='org.springframework.boot', name='spring-boot-starter-data-jpa', version='null', configuration='default'}
Adding implicit managed exclusion rules to starter DefaultExternalModuleDependency{group='org.springframework.boot', name='spring-boot-starter-data-rest', version='null', configuration='default'}
Adding implicit managed exclusion rules to starter DefaultExternalModuleDependency{group='org.springframework.boot', name='spring-boot-starter-actuator', version='null', configuration='default'}
Adding implicit managed exclusion rules to starter DefaultExternalModuleDependency{group='org.springframework.boot', name='spring-boot-starter-tomcat', version='null', configuration='default'}
Flyway 3.2.1 by Boxfuse
Database: jdbc:postgresql://localhost:5432/stamps?autoReconnect=true (PostgreSQL 9.5)
Validated 269 migrations (execution time 00:00.244s)
Creating Metadata table: "public"."schema_version"
Current version of schema "public": << Empty Schema >>
outOfOrder mode is active. Migration of schema "public" may not be reproducible.
Migrating schema "public" to version 1.0.01 - DDLAddedTheUUIDOSSPExtensionLibrary
Migrating schema "public" to version 1.1.01 - DDLInitialDBCreationScriptsStartingWithDSBEAMigration
Migrating schema "public" to version 1.1.02 - DDLFixGroupingDamageStateColumn
Migrating schema "public" to version 1.1.03 - DDLFixGroupingDamageStateUpdateColumns
Migrating schema "public" to version 1.1.04 - DDLFixDomainPersonOrganizationUpdateColumns
Migrating schema "public" to version 1.1.05 - DDLFixGroupingApprovalStatusUpdateColumns
Migrating schema "public" to version 1.1.06 - DDLFixScenarioShipScenarioUpdateColumns
Migrating schema "public" to version 1.1.07 - DDLFixShipShipUpdateColumns
Migrating schema "public" to version 1.1.08 - DDLAddEquipmentShipEquipmentInheritedConstrant
Migrating schema "public" to version 1.1.09 - DMLInsertShipOrganizationalUnits
Migrating schema "public" to version 1.1.10 - DMLInsertShipClasses
Migrating schema "public" to version 1.1.11 - DMLInsertShips
Migrating schema "public" to version 1.1.12 - DDLCreateTransitShipTransitPathView
Migrating schema "public" to version 1.1.13 - DDLCreateShipShipCompartmentBoundaryShipCompartmentTable
Migrating schema "public" to version 1.1.14 - DDLModifyShipCompartmentTableDropShipId
Migrating schema "public" to version 1.1.15 - DDLModifyScenarioScenarioEventTableToRemoveScheduleRelatedFields
Migrating schema "public" to version 1.1.16 - DDLCreateScenarioScenarioEquipmentEventTable
Migrating schema "public" to version 1.1.17 - DDLCreateScenarioScenarioShipCompartmentEventTable
Migrating schema "public" to version 1.1.18 - DDLCreateTrainingPQSSchemaAndTable
Migrating schema "public" to version 1.1.19 - DDLCreateRoleRoleTableAndSchema
Migrating schema "public" to version 1.1.20 - DDLModifyShipShipLocationTableFields
Migrating schema "public" to version 1.1.21 - DDLModifyShipShipCompartmentTableFields
Migrating schema "public" to version 1.1.22 - DDLCreateBilletBilletAndCrewTableAndSchema
Migrating schema "public" to version 1.1.23 - DDLCreateWorkItemStateTables
Migrating schema "public" to version 1.1.24 - DDLCreateBilletCrewMemberConfigurationBilletConditionShipLocationTable
DB: identifier "crewconfiguration_billet__conditionshiplocation_crewconfiguration_billet_id_fkey" will be truncated to "crewconfiguration_billet__conditionshiplocation_crewconfigurati" (SQL State: 42622 - Error Code: 0)
DB: identifier "crewconfiguration_billet__conditionshiplocation_condition_id_fkey" will be truncated to "crewconfiguration_billet__conditionshiplocation_condition_id_fk" (SQL State: 42622 - Error Code: 0)
DB: identifier "crewconfiguration_billet__conditionshiplocation_shiplocation_id_fkey" will be truncated to "crewconfiguration_billet__conditionshiplocation_shiplocation_id" (SQL State: 42622 - Error Code: 0)
Migrating schema "public" to version 1.1.25 - DDLModifyBilletCrewConfigurationBilletTable
Migrating schema "public" to version 1.1.26 - DDLModifyShipShipLocationTableAddCoordinates
Migrating schema "public" to version 1.1.27 - DDLCreateShipWatchAndWatchStationTables
Migrating schema "public" to version 1.1.28 - DDLCreateEventEventTableAndModifiedEventEventToAddFields
Migrating schema "public" to version 1.1.29 - DDLCreateTableBilletCrewConfigurationBilletWatchStationAssignment
DB: identifier "crewconfiguration_billet__watchstationassignment_condition_id_fkey" will be truncated to "crewconfiguration_billet__watchstationassignment_condition_id_f" (SQL State: 42622 - Error Code: 0)
DB: identifier "crewconfiguration_billet__watchstationassignment_crewconfiguration_billet_id_fkey" will be truncated to "crewconfiguration_billet__watchstationassignment_crewconfigurat" (SQL State: 42622 - Error Code: 0)
DB: identifier "crewconfiguration_billet__watchstationassignment_watchstation_id" will be truncated to "crewconfiguration_billet__watchstationassignment_watchstation_i" (SQL State: 42622 - Error Code: 0)
Migrating schema "public" to version 1.1.30 - DDLAlterTableScenarioScenario
Migrating schema "public" to version 1.1.31 - DDLAlterScenarioScenarioEventTable
Migrating schema "public" to version 1.1.32 - DMLInsertShipDepartmentDivisionWorkcenter
Migrating schema "public" to version 1.1.33 - DDLCreatePQSSectionTable
Migrating schema "public" to version 1.1.34 - DDLAlterBilletCrewConfigurationBilletWatchStationAssignment
Migrating schema "public" to version 1.1.35 - DMLInsertPQS
Migrating schema "public" to version 1.1.36 - DDLAlterTableBilletCrewConfigurationBilletWatchStationAssignmentShipWatchStationConstraint
Migrating schema "public" to version 1.1.37 - DDLAlterTableScenarioScenarioEventAddColumn
Migrating schema "public" to version 1.1.38 - DDLCreateTableEquipmentEquipmentEventProcedure
Migrating schema "public" to version 1.1.39 - DDLCreateTableEquipmentEquipmentProcedureWorkItem
Migrating schema "public" to version 1.1.40 - DDLCreateTableScenarioContainmentEvent
Migrating schema "public" to version 1.1.41 - DDLAlterTableScenarioScenarioEquipmentEventChangeConstraint
Migrating schema "public" to version 1.1.42 - DDLAlterTableScenarioScenarioCompartmentEventChangeConstraint
Migrating schema "public" to version 1.1.43 - DDLAlterShipCompartmentTableAddNewFields
Migrating schema "public" to version 1.1.44 - DDLAlterShipShipCompartmentTableRemovedFieldsInheritFromShipCompartmentTable
Migrating schema "public" to version 1.1.45 - DDLAlterShipCompartmentAndShipShipCompartmentTablesAddedFields
Migrating schema "public" to version 1.1.46 - DMLShipCompartmentInsert
Migrating schema "public" to version 1.1.47 - DDLAlterShipCompartmentTableRemovedFields
Migrating schema "public" to version 1.1.48 - DDLAddCompartmentNumberColumn
Migrating schema "public" to version 1.1.49 - DDLAddBilletSequenceNumberToBilletTable
Migrating schema "public" to version 1.1.50 - DMLInsertDDG1000Billets
Migrating schema "public" to version 1.1.51 - DDLCreateTableSimulationScenario
DB: identifier "simulation_event__workitem_simulation_predecessor_workitem_id_fkey" will be truncated to "simulation_event__workitem_simulation_predecessor_workitem_id_f" (SQL State: 42622 - Error Code: 0)
DB: identifier "simulationcompartmenteventsignal_simulationcompartmentevent_id_fkey" will be truncated to "simulationcompartmenteventsignal_simulationcompartmentevent_id_" (SQL State: 42622 - Error Code: 0)
Migrating schema "public" to version 1.1.52 - DDLAlterAndDropScenarioTables
Migrating schema "public" to version 1.1.53 - DMLReinsertDDG1000Billets
Migrating schema "public" to version 1.1.54 - DDLAlterTableScenarioShipScenario
Migrating schema "public" to version 1.1.55 - DDLAlterSimulationTablesRename
Migrating schema "public" to version 1.1.56 - DDLAlterTableSimulationShipSimulationAddShipId
Migrating schema "public" to version 1.1.57 - DDLAlterTablesWorkWorkCatalystWorkItem
Migrating schema "public" to version 1.1.58 - DDLAlterTableShipShipWatchStationAddShipLocation
Migrating schema "public" to version 1.1.59 - DDLAlterTableSimulationSimulation EventAddColumns
Migrating schema "public" to version 1.1.60 - DMLInsertWatchAndWatchStations
Migrating schema "public" to version 1.1.61 - AlterAndCreateTablesForBilletShipCrewConfiguration
Migrating schema "public" to version 1.1.62 - DMLInsertRoleRoleData
Migrating schema "public" to version 1.1.63 - DMLInsertBilletCrewGroupData
Migrating schema "public" to version 1.1.64 - DMLInsertBilletCrewGroupRoleData
Migrating schema "public" to version 1.1.65 - DMLInsertBilletCrewConfigurationData
Migrating schema "public" to version 1.1.66 - DMLInsertShipCrewConfigurationBilletData
Migrating schema "public" to version 1.1.67 - DMLInsertItemStateWatchCondition
Migrating schema "public" to version 1.1.68 - DMLInsertBilletShipCrewConfigurationBilletWatchStationAssignmentData
Migrating schema "public" to version 1.1.69 - DDLCreatedViewBilletShipCrewConfigurationView
Migrating schema "public" to version 1.1.70 - DDLCreateCareerFieldandRelatedTables
Migrating schema "public" to version 1.1.71 - DDLCreateDesignatorTablesAndInsertData
Migrating schema "public" to version 1.1.72 - DDLCreateRankTables
Migrating schema "public" to version 1.1.73 - DMLUpdateCrewConfigurationRankCareerfieldPaygrade
Migrating schema "public" to version 1.1.74 - DDLAlterBilletShipCrewConfigurationViewToAddId
Migrating schema "public" to version 1.1.75 - DMLInsertTransitMap
Migrating schema "public" to version 1.1.76 - DMLInsertNodeTypes
Migrating schema "public" to version 1.1.77 - DMLInsertTransitNodeCoords
Migrating schema "public" to version 1.1.78 - DMLInsertTransitNodes
Migrating schema "public" to version 1.1.79 - DMLInsertTransitNodeAssocs
Migrating schema "public" to version 1.1.80 - DMLInsertMapAssocs
Migrating schema "public" to version 1.1.81 - DDLRenameDupNodeDelimiters
Migrating schema "public" to version 1.1.82 - DDLAlterShipTransitPathView
Migrating schema "public" to version 1.1.83 - DDLCreateShipShipCompartmentBoundaryView
Migrating schema "public" to version 1.1.84 - DDLAlterShipShipCompartmentBoundaryViewFixColumnName
Migrating schema "public" to version 1.1.85 - DDLAlterSimulationSimulationShipEquipmentEventRenameAlterConstrant
Migrating schema "public" to version 1.1.86 - DDLCreateSimulationSimulationEventDetailView
Migrating schema "public" to version 1.1.87 - DDLAlterSimulationSimulationShipEquipmentDamageEventRenameAlterConstrant
Migrating schema "public" to version 1.1.88 - DDLCreateSimulationSimulationDamageEventDetailView
Migrating schema "public" to version 1.1.89 - DDLCreateSimulationSimulationDamageEventDetailView
Migrating schema "public" to version 1.1.90 - DMLClearOldTransitMapData
Migrating schema "public" to version 1.1.91 - DMLCreateShipBoundaries
Migrating schema "public" to version 1.1.92 - DMLInsertTransitNodeTypes
Migrating schema "public" to version 1.1.93 - DMLInsertTransitNodes
Migrating schema "public" to version 1.1.94 - DMLInsertTransitNodeAssociations
Migrating schema "public" to version 1.1.95 - DMLInsertMapTransitNodeAssociations
Migrating schema "public" to version 1.2.1460662468 - DDLModifyBilletBilletTables
Migrating schema "public" to version 1.2.1460663154 - DDLAddedBilletBilletPqsSectionTable
Migrating schema "public" to version 1.2.1460665927 - DDLDropRoleRolePqsAddRoleRolePqsSectionTable
Migrating schema "public" to version 1.2.1460666135 - DDLDropBilletShipCrewConfigurationBilletPqsTableAddShipCrewConfigurationBilletPqsSectionTable
DB: identifier "crewconfiguration_billet__pqssection_crewconfiguration_billet_id_fkey" will be truncated to "crewconfiguration_billet__pqssection_crewconfiguration_billet_i" (SQL State: 42622 - Error Code: 0)
Migrating schema "public" to version 1.2.1460666905 - DMLUpdateBilletBilletCareerFieldAndPayGradeFields
Migrating schema "public" to version 1.2.1460667130 - DDLModifyBilletBilletSetCareerFieldAndPayGradeFieldsToNotNull
Migrating schema "public" to version 1.2.1460730855 - DDLModifyBilletBilletPqsSectionTableAddFields
Migrating schema "public" to version 1.2.1460745097 - DDLCreateBilletCrewGroupRolesView
Migrating schema "public" to version 1.2.1460757147 - DDLModifyBilletCrewGroupRoleTable
Migrating schema "public" to version 1.2.1460849773 - DDLCreateSimulationSignalView
Migrating schema "public" to version 1.2.1460912691 - DDLCreateEquipmentShipEquipmentView
Migrating schema "public" to version 1.2.1461075766 - DDLModifiedEquipmentShipEquipmentDetailView
Migrating schema "public" to version 1.2.1461089249 - DDLDropAndCreateSimulationSignalTablesAndView
Migrating schema "public" to version 1.2.1461089340 - DDLCreateRuleRuleTables
Migrating schema "public" to version 1.2.1461089404 - DDLCreateSimulationRuleTables
Migrating schema "public" to version 1.2.1461090650 - DDLDropEquipmentShipEquipmentDetailView
Migrating schema "public" to version 1.2.1461090652 - DDLDropViewCreateEquipmentShipEquipmentDetailView
DB: view "shipequipmentdetail_view" does not exist, skipping
Migrating schema "public" to version 1.2.1461090656 - DDLAlterEquipmentShipEquipmentTableAddShipLocationColumn
Migrating schema "public" to version 1.2.1461104069 - DDLAlterEquipmentShipEquipmentView
Migrating schema "public" to version 1.2.1461111555 - DDLAlterSimulationShipEquipmentAndCompartmentSignalTablesAddSimulationColumn
Migrating schema "public" to version 1.2.1461111766 - DDLAlterSimulationShipEquipmentAndCompartmentSignalViewsAddSimulationColumn
Migrating schema "public" to version 1.2.1461161707 - DDLCreateEquipmentShipEquipmentDetailView
Migrating schema "public" to version 1.2.1461163671 - DDLRecreateSimulationEventDetailViewAndEquipmentShipEquipmentDetailView
Migrating schema "public" to version 1.2.1461179668 - DMLInsertEquipmentEquipmentTypeDataFromOarsDatabase
Migrating schema "public" to version 1.2.1461181042 - DMLInsertEquipmentEquipmentDataFromSkedDatabase
Migrating schema "public" to version 1.2.1461187748 - DMLInsertShipCompartmentAndShipShipCompartmentDataFromSkedDatabase
Migrating schema "public" to version 1.2.1461191219 - DMLInsertEquipmentShipLocationDataFromSkedDatabase
Migrating schema "public" to version 1.2.1461192478 - DMLInsertEquipmentShipSystemDataFromSkedDatabase
Migrating schema "public" to version 1.2.1461192817 - DMLInsertEquipmentShipSystemShipEquipmentDataFromSkedDatabase
Migrating schema "public" to version 1.2.1461194656 - DMLInsertLocationCoordinateAndUpdateShipLocationCoordinateDataFromDSBEALocation
Migrating schema "public" to version 1.2.1461285495 - DDLAlterSimulationEventDetailViewAddedEventType
Migrating schema "public" to version 1.2.1461338216 - DMLInsertRuleRuleCategoryData
Migrating schema "public" to version 1.2.1461339147 - DMLInsertRuleRuleTypeData
Migrating schema "public" to version 1.2.1461345882 - DMLInsertGroupingDamageTypeEquipmentDamageTypeAndCompartmentDamageTypeData
Migrating schema "public" to version 1.2.1461606311 - DDLAlterTableRuleRuleDropNameColumn
Migrating schema "public" to version 1.2.1461648496 - DDLDropDamageCategoryTableAddDamageTypeToSimulationEventDamage
Migrating schema "public" to version 1.2.1461680688 - DDLCreateWorkItemByWorkCatalystView
Migrating schema "public" to version 1.2.1461682925 - DDLCreateWorkItemStatesByGroupView
Migrating schema "public" to version 1.2.1461697755 - DDLAlterTableWorkWorkCatalystWorkItemChangeConstraintOnPredecessorWorkItemId
Migrating schema "public" to version 1.2.1461861847 - DDLCreateTableWorkExecutionTask
Migrating schema "public" to version 1.2.1461861940 - DDLDropTableSimulationSimulationEventWorkItemAndCreateTableSimulationSimulationEventExecutionTask
DB: identifier "simulation_event__executiontask_simulation_predecessor_workitem_id_f" will be truncated to "simulation_event__executiontask_simulation_predecessor_workitem" (SQL State: 42622 - Error Code: 0)
Migrating schema "public" to version 1.2.1462551098 - DDLAlterSimulationSimulationShipEquipmentSignalsViewAddedEquipmentDescriptionAndName
Migrating schema "public" to version 1.2.1462553906 - DDLCreateTableLocationReferenceLocation
Migrating schema "public" to version 1.2.1462554252 - DMLInsertLocationReferenceLocationDataFromDSBEAForExecutionTask
Migrating schema "public" to version 1.2.1462554430 - DDLAlterTableWorkExecutionTaskAddDSBEATaskFields
Migrating schema "public" to version 1.2.1462554701 - DDLAlterTableSimulationShipSimulationAddedShipCrewConfigurationId
Migrating schema "public" to version 1.2.1462559733 - DDLCreateTableGroupingExecutionTaskType
Migrating schema "public" to version 1.2.1462559789 - DDLAlterTableWorkExecutionTaskAddDescriptionAndType
Migrating schema "public" to version 1.2.1462560135 - DMLInsertGroupingExecutionTaskTypeFromDSBEA
Migrating schema "public" to version 1.2.1462562233 - DMLInsertWorkWorkItemFromDSBEA
Migrating schema "public" to version 1.2.1462562294 - DMLInsertWorkExecutionTaskFromDSBEA
Migrating schema "public" to version 1.2.1462596304 - DMLInsertWorkWorkCatalystFromDSBEA
Migrating schema "public" to version 1.2.1462596633 - DMLInsertEventEventTypeFromDSBEA
Migrating schema "public" to version 1.2.1462597112 - DMLInsertEventEventFromDSBEA
Migrating schema "public" to version 1.2.1462597549 - DMLInsertWorkCatalystWorkItemFromDSBEA
Migrating schema "public" to version 1.2.1462598116 - DMLUpdateWorkCatalystWorkItemPredecessorWorkItemId
Migrating schema "public" to version 1.2.1462811966 - DDLCreateFunctionPublicGetTableDependency
Migrating schema "public" to version 1.2.1463107539 - DDLCreateTableWorkWorkCatalystWorkItemRole
Migrating schema "public" to version 1.2.1463107776 - DDLCreateTableWorkWorkCatalystRole
Migrating schema "public" to version 1.2.1463109120 - DMLInsertWorkWorkCatalystWorkItemRoleFromDSBEA
Migrating schema "public" to version 1.2.1463452243 - DDLCreateTableGroupingConfoundedType
Migrating schema "public" to version 1.2.1463452516 - DDLCreateTableSimulationConfoundedShipCompartment
Migrating schema "public" to version 1.2.1463452976 - DMLInsertDataIntoTableGroupingConfoundedType
Migrating schema "public" to version 1.2.1463600611 - DDLCreateLibraryMilitaryCombatInjuryScaleTable
Migrating schema "public" to version 1.2.1463600720 - DDLCreateLibraryInjuryImpactTable
Migrating schema "public" to version 1.2.1463600723 - DDLCreateLibraryInjuryImparimentTable
Migrating schema "public" to version 1.2.1463600833 - DDLCreateLibraryMilitaryCombatInjuryScaleInjuryImpairmentTable
DB: identifier "militarycombatinjuryscaleinjuryimpairment_militarycombatinjuryscale_id_fkey" will be truncated to "militarycombatinjuryscaleinjuryimpairment_militarycombatinjurys" (SQL State: 42622 - Error Code: 0)
DB: identifier "militarycombatinjuryscaleinjuryimpairment_injuryimpairment_id_fkey" will be truncated to "militarycombatinjuryscaleinjuryimpairment_injuryimpairment_id_f" (SQL State: 42622 - Error Code: 0)
Migrating schema "public" to version 1.2.1463602392 - DMLInsertDataIntoLibraryMilitaryCombatInjuryScaleFromDSBEA
Migrating schema "public" to version 1.2.1463603136 - DMLInsertDataIntoLibraryInjuryImpactFromDSBEA
Migrating schema "public" to version 1.2.1463605639 - DMLInsertDataIntoLibraryInjuryImpairmentFromDSBEA
Migrating schema "public" to version 1.2.1463616057 - DMLInsertDataIntoLibraryMilitaryCombatInjuryScaleInjuryImpairmentFromDSBEA
Migrating schema "public" to version 1.2.1463640177 - DDLCreateGroupingDispositionTypeTable
Migrating schema "public" to version 1.2.1463640235 - DDLCreateSimulationSimulationShipCrewTable
Migrating schema "public" to version 1.2.1463640486 - DMLInsertDataIntoGroupingDispositionTypeFromDSBEA
Migrating schema "public" to version 1.2.1463640911 - DDLCreateRoleRoleMilitaryCombatInjuryScaleTable
Migrating schema "public" to version 1.2.1463717622 - DMLInsertRoleRoleMilitaryCombatInjuryScaleFromDSBEA
Migrating schema "public" to version 1.2.1464021280 - DMLUpdateShipCompartmentDescriptionToMatchDSBEACompartmentDescription
Migrating schema "public" to version 1.2.1465311034 - DDLCreateBillet.ShipCrewConfigurationBilletRoleTable
Migrating schema "public" to version 1.2.1465312012 - DDLCreateSimulationSimulationCrewDetailView
Migrating schema "public" to version 1.2.1465333730 - DDLModifiySimulationSimulationCrewDetailViewAddedShipCrewConfigurationId
Migrating schema "public" to version 1.2.1465388801 - DMLInsertDataIntoBilletShipCrewConfigurationBilletRoleFromDSBEA
Migrating schema "public" to version 1.2.1465426142 - DMLInsertDataIntoGroupingDispositionTypeTable
Migrating schema "public" to version 1.2.1465426332 - DDLModifiyLibraryMilitaryCombatInjuryScaleTableAddedViableForDuty
Migrating schema "public" to version 1.2.1465426578 - DDLCreateBilletShipCrewConfigurationDetailView
Migrating schema "public" to version 1.2.1465427829 - DMLInsertDataIntoMilitaryCombatInjuryScaleTable
Migrating schema "public" to version 1.2.1465487625 - DDLModifiyBilletShipCrewConfigurationDetailViewAddedId
Migrating schema "public" to version 1.2.1465492115 - DDLModifiySimulationSimulationCrewDetailViewAddedId
Migrating schema "public" to version 1.2.1465492124 - DDLCreateTableLibraryPeriodicityTable
Migrating schema "public" to version 1.2.1465492125 - DDLModifiyShipCompartmentTableAddedDeleted
Migrating schema "public" to version 1.2.1465492126 - DDLCreateShipShipClassCompartmentTable
Migrating schema "public" to version 1.2.1465492127 - DDLCreateShipShipStateTable
Migrating schema "public" to version 1.2.1465492128 - CreateShipShipStatePeriodTable
Migrating schema "public" to version 1.2.1465492145 - CreateFMSchemaAndTables
Migrating schema "public" to version 1.2.1465492150 - CreateAnalysisSchemaAndTables
Migrating schema "public" to version 1.2.1465505094 - DDLModifiyAnalysisStudyAddDescriptionColumn
Migrating schema "public" to version 1.2.1465505770 - DDLModifiyShipWatchStationAddNMRSWatchStationIdColumn
Migrating schema "public" to version 1.2.1465507483 - DDLCreateOMShipClassStudyTable
Migrating schema "public" to version 1.2.1465511102 - DMLDeleteDuplicateMCISCodesFromLibraryMilitaryCombatInjuryScale
Migrating schema "public" to version 1.2.1465512562 - DDLCreateSimulationSimulationCrewInjuryDetailView
Migration of schema "public" to version 1.2.1465512562 failed! Changes successfully rolled back.
:services:flywayMigrate FAILED
:services:flywayMigrate (Thread[main,5,main]) completed. Took 9.849 secs.
FAILURE: Build failed with an exception.
* What went wrong:
Execution failed for task ':services:flywayMigrate'.
> Error occurred while executing flywayMigrate
Migration V1_2.1465512562__DDLCreateSimulationSimulationCrewInjuryDetailView.sql failed
---------------------------------------------------------------------------------------
SQL State : 42883
Error Code : 0
Message : ERROR: function uuid_generate_v4() does not exist
Hint: No function matches the given name and argument types. You might need to add explicit type casts.
Position: 79
Location : db/migration/V1_2.1465512562__DDLCreateSimulationSimulationCrewInjuryDetailView.sql (C:\stamps\services\build\resources\main\db\migration\V1_2.1465512562__DDLCreateSimulationSimulationCrewInjuryDetailView.sql)
Line : 1
Statement : CREATE OR REPLACE VIEW simulation.simulationcrewinjurydetail_view AS
SELECT uuid_generate_v4() AS id,
sccb.crewconfiguration_id AS shipcrewconfiguration_id,
sccb.id AS crew_id,
sss.id as simulation_id,
CASE
WHEN ssc.iteration IS NULL THEN 0
ELSE ssc.iteration
END AS iteration,
CASE
WHEN mcis.mcis_code IS NULL THEN 0
ELSE mcis.mcis_code
END AS mcisinjury,
CASE
WHEN dt.name IS NULL THEN 'Available'::character varying
ELSE dt.name
END AS finaldisposition,
CASE
WHEN ssc.time_of_disposition_in_seconds IS NULL THEN 0::bigint
ELSE ssc.time_of_disposition_in_seconds
END AS timeoffinaldisposition
FROM
billet.shipcrewconfiguration_billet sccb
join simulation.shipsimulation sss on sccb.crewconfiguration_id = sss.shipcrewconfiguration_id
left join simulation.simulation_shipcrew ssc ON sccb.id = ssc.shipcrewbillet_id
left join library.militarycombatinjuryscale mcis ON ssc.militarycombatinjuryscale_id = mcis.id
left join "grouping".dispositiontype dt ON ssc.dispositiontype_id = dt.id
ERROR: function uuid_generate_v4() does not exist
Hint: No function matches the given name and argument types. You might need to add explicit type casts.
Position: 79
* Try:
Run with --stacktrace option to get the stack trace. Run with --debug option to get more log output.
BUILD FAILED
Total time: 21.108 secs
Stopped 0 compiler daemon(s).
C:\stamps>
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
You can’t perform that action at this time.