Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Debug level does not work for enterprise option #2370

Closed
Me1gireesh opened this issue Apr 26, 2019 · 13 comments

Comments

@Me1gireesh
Copy link

commented Apr 26, 2019

Which version and edition of Flyway are you using?
If this is not the latest version, can you reproduce the issue with the latest one as well?

(Many bugs are fixed in newer releases and upgrading will often resolve the issue)

Which client are you using? (Command-line, Java API, Maven plugin, Gradle plugin)
Which database are you using (type & version)?
Which operating system are you using?
What did you do?

(Please include the content causing the issue, any relevant configuration settings, the SQL statement that failed (if relevant) and the command you ran.)

What did you expect to see?
What did you see instead?
@Me1gireesh

This comment has been minimized.

Copy link
Author

commented Apr 26, 2019

flyway -url="jdbc:oracle:thin:@LDAP://my_db,cn=ORACLECONTEXT,OU=TNSNAMES,O=APPS,dc=dell,dc=com" -user='Myuser' -password='mypassword' -target='20.0502.1.190426095216' -X migrate -locations=filesystem:/sbil/ci/jenkins-slave/workspace/database-migration-recompile/repo/source -enterprise -outOfOrder=true
[main] INFO org.flywaydb.core.internal.license.VersionPrinter - Flyway Enterprise Edition (trial) 5.2.4 by Boxfuse licensed to Dell until 2019-04-04
[main] ERROR org.flywaydb.core.internal.license.VersionPrinter - Your 30 day limited Flyway trial license has expired and is no longer valid. You must upgrade to a full Flyway Enterprise Edition license immediately to keep on using this software.
[main] INFO org.flywaydb.core.internal.database.DatabaseFactory - Database: jdbc:oracle:thin:@my_db,cn=ORACLECONTEXT,OU=TNSNAMES,O=APPS,dc=dell,dc=com (Oracle 12.1)
[main] INFO org.flywaydb.core.internal.command.DbValidate - Successfully validated 1 migration (execution time 00:00.107s)
[main] INFO org.flywaydb.core.internal.command.DbMigrate - Current version of schema "PROCESS_CICD": << Empty Schema >>
[main] WARN org.flywaydb.core.internal.command.DbMigrate - outOfOrder mode is active. Migration of schema "PROCESS_CICD" may not be reproducible.
[main] INFO org.flywaydb.core.internal.command.DbMigrate - Migrating schema "PROCESS_CICD" to version 20.0502.1.190426095216 - test
[main] INFO org.flywaydb.core.internal.command.DbMigrate - Successfully applied 1 migration to schema "PROCESS_CICD" (execution time 00:00.065s)

@Me1gireesh

This comment has been minimized.

Copy link
Author

commented Apr 26, 2019

We used to see the SQL script parsing and the execution output earlier while turning on the debug level (-X) . Please share some details around the same.

@axelfontaine

This comment has been minimized.

Copy link
Member

commented Apr 27, 2019

It appears no debug output is present. Are you 100% sure the -X was passed correctly? Please try again and let me know if the issue persists.

@Me1gireesh

This comment has been minimized.

Copy link
Author

commented Apr 27, 2019

The command used is as follows

flyway -url="jdbc:oracle:thin:@LDAP://my_db,cn=ORACLECONTEXT,OU=TNSNAMES,O=APPS,dc=dell,dc=com" -user='Myuser' -password='mypassword' -target='20.0502.1.190426095216' -X migrate -locations=filesystem:/sbil/ci/jenkins-slave/workspace/database-migration-recompile/repo/source -enterprise -outOfOrder=true

@Me1gireesh

This comment has been minimized.

Copy link
Author

commented Apr 27, 2019

I have added select statements in the callback statement whose output is expected on the console a the debug level is on, But nothing appears . However since the "Set serveroutput on" is set the dbms_output.put_line statements are printing on the console.

@Me1gireesh

This comment has been minimized.

Copy link
Author

commented Apr 27, 2019

Here's the complete output

url="jdbc:oracle:thin:@LDAP://my_db" -user='my_user' -password='my_user$123' -locations=filesystem:/sbil/ci/jenkins-slave/workspace/database-migration-recompile/repo/source -enterprise
[main] INFO org.flywaydb.core.internal.license.VersionPrinter - Flyway Enterprise Edition (trial) 5.2.4 by Boxfuse licensed to Dell until 2019-04-04
[main] ERROR org.flywaydb.core.internal.license.VersionPrinter - Your 30 day limited Flyway trial license has expired and is no longer valid. You must upgrade to a full Flyway Enterprise Edition license immediately to keep on using this software.
[main] INFO org.flywaydb.core.internal.database.DatabaseFactory - Database: jdbc:oracle:thin:@my_db (Oracle 12.1)
[main] INFO org.flywaydb.core.internal.schemahistory.JdbcTableSchemaHistory - Repair of failed migration in Schema History table "my_user"."FLYWAY_SCHEMA_HISTORY" not necessary. No failed migration detected.
[main] INFO org.flywaydb.core.internal.command.DbRepair - Successfully repaired schema history table "my_user"."FLYWAY_SCHEMA_HISTORY" (execution time 00:00.092s).

  • flyway -url="jdbc:oracle:thin:@my_db" -user='my_user' -password='my_user$123' -target='20.0502.1.190426095216' migrate -locations=filesystem:/sbil/ci/jenkins-slave/workspace/database-migration-recompile/repo/source -enterprise -outOfOrder=true -X
    [main] INFO org.flywaydb.core.internal.license.VersionPrinter - Flyway Enterprise Edition (trial) 5.2.4 by Boxfuse licensed to Dell until 2019-04-04
    [main] ERROR org.flywaydb.core.internal.license.VersionPrinter - Your 30 day limited Flyway trial license has expired and is no longer valid. You must upgrade to a full Flyway Enterprise Edition license immediately to keep on using this software.
    [main] INFO org.flywaydb.core.internal.database.DatabaseFactory - Database: jdbc:oracle:thin:@my_db (Oracle 12.1)
    [main] INFO org.flywaydb.core.internal.command.DbValidate - Successfully validated 1 migration (execution time 00:00.022s)
    [main] INFO org.flywaydb.core.internal.command.DbMigrate - Current version of schema "my_user": << Empty Schema >>
    [main] WARN org.flywaydb.core.internal.command.DbMigrate - outOfOrder mode is active. Migration of schema "my_user" may not be reproducible.
    [main] INFO org.flywaydb.core.internal.command.DbMigrate - Migrating schema "my_user" to version 20.0502.1.190426095216 - test
    [main] INFO org.flywaydb.core.internal.command.DbMigrate - Successfully applied 1 migration to schema "my_user" (execution time 00:02.373s)
    [main] INFO org.flywaydb.core.internal.callback.SqlScriptCallbackFactory - Executing SQL callback: afterMigrate - SDR
    [main] WARN org.flywaydb.core.internal.database.oracle.pro.SQLPlusSetSqlStatement - SP2-0158: unknown SET option "ON"
    [main] WARN org.flywaydb.core.internal.database.oracle.pro.SQLPlusSetSqlStatement - SP2-0158: unknown SET option "ON"
    [main] INFO org.flywaydb.core.internal.database.oracle.OracleSqlScriptExecutor - DB: PACKAGE : SDR : DMS_ENTITLEMENTS_UPGRADE_V18 : INVALID
    [main] INFO org.flywaydb.core.internal.database.oracle.OracleSqlScriptExecutor - DB: PACKAGE : SDR : DMS_COVERED_PRODUCTS_EXCLUSION : INVALID
    [main] INFO org.flywaydb.core.internal.database.oracle.OracleSqlScriptExecutor - DB: PACKAGE : SDR : DMS_HW_SW_ENTITLEMENTS_V24 : INVALID
    [main] INFO org.flywaydb.core.internal.database.oracle.OracleSqlScriptExecutor - DB: PACKAGE : SDR : MAINTENANCE_INSTRUCTION_API_V1 : INVALID
    [main] INFO org.flywaydb.core.internal.database.oracle.OracleSqlScriptExecutor - DB: PACKAGE : SDR : ONLINE_XFER_INS_ERR_LOG_API_V1 : INVALID
    [main] INFO org.flywaydb.core.internal.database.oracle.OracleSqlScriptExecutor - DB: PACKAGE : SDR : TRANSFER_INSTR_DETAIL_API_V1 : INVALID
    [main] INFO org.flywaydb.core.internal.database.oracle.OracleSqlScriptExecutor - DB: PACKAGE : SDR : TRANSFER_INSTRUCTION_DETAIL_V1 : INVALID
    [main] INFO org.flywaydb.core.internal.database.oracle.OracleSqlScriptExecutor - DB: PACKAGE : SDR : TRANSFER_INSTRUCTION_V1 : INVALID
    [main] INFO org.flywaydb.core.internal.database.oracle.OracleSqlScriptExecutor - DB: PACKAGE : SDR : DMS_COVERED_ITEMS_EXCLUSION_V4 : INVALID
    [main] INFO org.flywaydb.core.internal.database.oracle.OracleSqlScriptExecutor - DB: PACKAGE BODY : SDR : TRANSFER_INSTR_DETAIL_API_V1 : INVALID
    [main] INFO org.flywaydb.core.internal.database.oracle.OracleSqlScriptExecutor - DB: PACKAGE BODY : SDR : DMS_REL_INSTANCE : INVALID
    [main] INFO org.flywaydb.core.internal.database.oracle.OracleSqlScriptExecutor - DB: PACKAGE BODY : SDR : PROCESS_RANK_UPDATE_PKG : INVALID
    [main] INFO org.flywaydb.core.internal.database.oracle.OracleSqlScriptExecutor - DB: PACKAGE BODY : SDR : DMS_ANE_INSTANCE : INVALID
    [main] INFO org.flywaydb.core.internal.database.oracle.OracleSqlScriptExecutor - DB: PACKAGE BODY : SDR : ONLINE_XFER_INS_ERR_LOG_API_V1 : INVALID
    [main] INFO org.flywaydb.core.internal.database.oracle.OracleSqlScriptExecutor - DB: PACKAGE BODY : SDR : DMS_COVERED_ITEMS_EXCLUSION_V4 : INVALID
    [main] INFO org.flywaydb.core.internal.database.oracle.OracleSqlScriptExecutor - DB: PACKAGE BODY : SDR : FDL_CUST_PROD_COMP_API_V1 : INVALID
    [main] INFO org.flywaydb.core.internal.database.oracle.OracleSqlScriptExecutor - DB: PACKAGE BODY : SDR : MAINTENANCE_API : INVALID
    [main] INFO org.flywaydb.core.internal.database.oracle.OracleSqlScriptExecutor - DB: PACKAGE BODY : SDR : DMS_COVERED_PRODUCTS_EXCLUSION : INVALID
    [main] INFO org.flywaydb.core.internal.database.oracle.OracleSqlScriptExecutor - DB: PACKAGE BODY : SDR : DMS_HW_SW_ENTITLEMENTS_V24 : INVALID
    [main] INFO org.flywaydb.core.internal.database.oracle.OracleSqlScriptExecutor - DB: PACKAGE BODY : SDR : MAINTENANCE_INSTRUCTION_API_V1 : INVALID
    [main] INFO org.flywaydb.core.internal.database.oracle.OracleSqlScriptExecutor - DB: PACKAGE BODY : SDR : TRANSFER_INSTRUCTION_DETAIL_V1 : INVALID
    [main] INFO org.flywaydb.core.internal.database.oracle.OracleSqlScriptExecutor - DB: PACKAGE BODY : SDR : GROUP_LIST_HISTORY_API_V1_OLD : INVALID
    [main] INFO org.flywaydb.core.internal.database.oracle.OracleSqlScriptExecutor - DB: PACKAGE BODY : SDR : TRANSFER_INSTRUCTION_V1 : INVALID
    [main] INFO org.flywaydb.core.internal.database.oracle.OracleSqlScriptExecutor - DB: PACKAGE BODY : SDR : EMC_AE_HW_DATA_LOAD : INVALID
    [main] INFO org.flywaydb.core.internal.database.oracle.OracleSqlScriptExecutor - DB: PACKAGE BODY : SDR : DMS_ENTITLEMENTS_UPGRADE_V18 : INVALID
    [main] INFO org.flywaydb.core.internal.database.oracle.OracleSqlScriptExecutor - DB: PACKAGE BODY : SDR : CUSTOMER_PROD_COMP_API_V20 : INVALID
    [main] INFO org.flywaydb.core.internal.database.oracle.OracleSqlScriptExecutor - DB: PACKAGE BODY : SDR : EMC_ASSET_MAINTENANCE_API : INVALID
    [main] INFO org.flywaydb.core.internal.database.oracle.OracleSqlScriptExecutor - DB: PROCEDURE : SDR : TEST2 : INVALID
    [main] INFO org.flywaydb.core.internal.database.oracle.OracleSqlScriptExecutor - DB: PROCEDURE : SDR : CPPL_ASSET_HIST_SP : INVALID
    [main] INFO org.flywaydb.core.internal.database.oracle.OracleSqlScriptExecutor - DB: PROCEDURE : SDR : CPCMS_ASSET_HIST_SP : INVALID
    [main] INFO org.flywaydb.core.internal.database.oracle.OracleSqlScriptExecutor - DB: PROCEDURE : SDR : AUDIT_CLEANUP : INVALID
    [main] INFO org.flywaydb.core.internal.database.oracle.OracleSqlScriptExecutor - DB: PROCEDURE : SDR : CPCMS_ASSET_HIST_SP1 : INVALID
    [main] INFO org.flywaydb.core.internal.database.oracle.OracleSqlScriptExecutor - DB: PROCEDURE : SDR : CPR_ASSET_HIST_SP : INVALID
    [main] INFO org.flywaydb.core.internal.database.oracle.OracleSqlScriptExecutor - DB: PROCEDURE : SDR : AFT_TEST : INVALID
    [main] INFO org.flywaydb.core.internal.database.oracle.OracleSqlScriptExecutor - DB: PROCEDURE : SDR : LOAD_TAG_PERF : INVALID
    [main] INFO org.flywaydb.core.internal.database.oracle.OracleSqlScriptExecutor - DB: PROCEDURE : SDR : CPCR_ASSET_HIST_SP : INVALID
    [main] INFO org.flywaydb.core.internal.database.oracle.OracleSqlScriptExecutor - DB: PROCEDURE : SDR : PDR_SDR_RESYNCHING : INVALID
    [main] INFO org.flywaydb.core.internal.database.oracle.OracleSqlScriptExecutor - DB: PROCEDURE : SDR : ACP_ASSET_HIST_SP : INVALID
    [main] INFO org.flywaydb.core.internal.database.oracle.OracleSqlScriptExecutor - DB: PROCEDURE : SDR : CPA_ASSET_HIST_SP : INVALID
    [main] INFO org.flywaydb.core.internal.database.oracle.OracleSqlScriptExecutor - DB: PROCEDURE : SDR : CPI_ASSET_HIST_SP : INVALID
    [main] INFO org.flywaydb.core.internal.database.oracle.OracleSqlScriptExecutor - DB: PROCEDURE : SDR : ASSET_TRANS_HIST : INVALID
    [main] INFO org.flywaydb.core.internal.database.oracle.OracleSqlScriptExecutor - DB: VIEW : SDR : ITEM_ATTRIBUTE_VW : INVALID
    [main] INFO org.flywaydb.core.internal.database.oracle.OracleSqlScriptExecutor - DB: TRIGGER : SDR : CONTRACT_INSTRUCTION_BUR : INVALID
    [main] INFO org.flywaydb.core.internal.database.oracle.OracleSqlScriptExecutor - DB: TRIGGER : SDR : CONTRACT_INSTRUCTION_BDR : INVALID
    [main] INFO org.flywaydb.core.internal.database.oracle.OracleSqlScriptExecutor - DB: TRIGGER : SDR : CUSTOMER_CONTRACT_ATTR_BUR : INVALID
    [main] INFO org.flywaydb.core.internal.database.oracle.OracleSqlScriptExecutor - DB: TRIGGER : SDR : AGREEMENT_CONTRACT_BDR : INVALID
    [main] INFO org.flywaydb.core.internal.database.oracle.OracleSqlScriptExecutor - DB: TRIGGER : SDR : CUSTOMER_CONTRACT_ATTR_BDR : INVALID
    [main] INFO org.flywaydb.core.internal.database.oracle.OracleSqlScriptExecutor - DB: TRIGGER : SDR : CONTRACT_PRODUCT_COVERAGE_BDR : INVALID
    [main] INFO org.flywaydb.core.internal.database.oracle.OracleSqlScriptExecutor - DB: TRIGGER : SDR : CUSTOMER_CONTRACT_IDENT_BDR : INVALID
    [main] INFO org.flywaydb.core.internal.database.oracle.OracleSqlScriptExecutor - DB: TRIGGER : SDR : CUSTOMER_CONTRACT_IDENT_BUR : INVALID
    [main] INFO org.flywaydb.core.internal.database.oracle.OracleSqlScriptExecutor - DB: TRIGGER : SDR : MAINT_INSTR_ATTRIBUTE_BUR : INVALID
    [main] INFO org.flywaydb.core.internal.database.oracle.OracleSqlScriptExecutor - DB: TRIGGER : SDR : MAINT_INSTR_ATTRIBUTE_BDR : INVALID
    [main] INFO org.flywaydb.core.internal.database.oracle.OracleSqlScriptExecutor - DB: PACKAGE : GDOMINO : VI_CATEGORY_API_V1 : INVALID
    [main] INFO org.flywaydb.core.internal.database.oracle.OracleSqlScriptExecutor - DB: PACKAGE BODY : GDOMINO : VI_CATEGORY_API_V1 : INVALID
    [main] INFO org.flywaydb.core.internal.database.oracle.OracleSqlScriptExecutor - DB: TRIGGER : GDOMINO : VI_SKU_ATTRIBUTE_MAPPING_AIR : INVALID
    [main] INFO org.flywaydb.core.internal.database.oracle.OracleSqlScriptExecutor - DB: TRIGGER : GDOMINO : VI_SKU_ATTRIBUTE_MAPPING_AUR : INVALID
    [main] INFO org.flywaydb.core.internal.database.oracle.OracleSqlScriptExecutor - DB: TRIGGER : GDOMINO : VI_SKU_ATTRIBUTE_MAPPING_ADR : INVALID
    [main] INFO org.flywaydb.core.internal.database.oracle.OracleSqlScriptExecutor - DB: PACKAGE : SDI : GLOVIA_ITEMGMAS_API : INVALID
    [main] INFO org.flywaydb.core.internal.database.oracle.OracleSqlScriptExecutor - DB: PACKAGE BODY : SDI : NGAM_DATA_LOAD_INITIAL_PKG : INVALID
    [main] INFO org.flywaydb.core.internal.database.oracle.OracleSqlScriptExecutor - DB: PACKAGE BODY : SDI : GLOVIA_ITEMGMAS_API : INVALID
    [main] INFO org.flywaydb.core.internal.database.oracle.OracleSqlScriptExecutor - DB: PROCEDURE : SDI : PRC_LOAD_SDR_FROM_SIBEL : INVALID
    [main] INFO org.flywaydb.core.internal.database.oracle.OracleSqlScriptExecutor - DB: PROCEDURE : SDI : CMDM_LINK_NUM_PARTY_USUAGE_AUR : INVALID
    [main] INFO org.flywaydb.core.internal.database.oracle.OracleSqlScriptExecutor - DB: TRIGGER : SDI : GLOVIA_ITEMGMAS_AIR : INVALID
    [main] INFO org.flywaydb.core.internal.database.oracle.OracleSqlScriptExecutor - DB: TRIGGER : SDI : GLOVIA_ITEMGMAS_AUR : INVALID
    [main] INFO org.flywaydb.core.internal.database.oracle.OracleSqlScriptExecutor - DB: TRIGGER : SDI : SIEBEL_CX_GPMS_ACCOUNT_AUR_HST : INVALID
    [main] INFO org.flywaydb.core.internal.database.oracle.OracleSqlScriptExecutor - DB: TRIGGER : SDI : SIEBEL_CX_GPMS_ACCOUNT_AIR_HST : INVALID
    [main] INFO org.flywaydb.core.internal.database.oracle.OracleSqlScriptExecutor - DB: TRIGGER : SDI : TMP$$_FEED_STG_INSTRUCTION_0 : INVALID
    [main] INFO org.flywaydb.core.internal.database.oracle.OracleSqlScriptExecutor - DB: TRIGGER : SDI : TMP$$_FEED_STG_INSTRUCTION_1 : INVALID
    [main] INFO org.flywaydb.core.internal.database.oracle.OracleSqlScriptExecutor - DB: PACKAGE BODY : EMC : EMC_ANE_DATA_LOAD_SUSTAINING : INVALID
    [main] INFO org.flywaydb.core.internal.database.oracle.OracleSqlScriptExecutor - DB: PACKAGE BODY : EMC : EMC_CONTRACT_DATA_LOAD_SUSTAIN : INVALID
    [main] INFO org.flywaydb.core.internal.database.oracle.OracleSqlScriptExecutor - DB: PROCEDURE : EMC : PROC_MTL_ITEM_REVISIONS_TL : INVALID
    [main] INFO org.flywaydb.core.internal.database.oracle.OracleSqlScriptExecutor - DB: PROCEDURE : EMC : PROC_MTL_SYSTEM_ITEMS_TL : INVALID
    [main] INFO org.flywaydb.core.internal.database.oracle.OracleSqlScriptExecutor - DB: PROCEDURE : EMC : PROC_MTL_SYSTEM_ITEMS_B : INVALID
    [main] INFO org.flywaydb.core.internal.database.oracle.OracleSqlScriptExecutor - DB: PROCEDURE : EMC : PROC_MTL_ITEM_REVISIONS_B : INVALID
    [main] INFO org.flywaydb.core.internal.database.oracle.OracleSqlScriptExecutor - DB: PROCEDURE : EMC : PROC_MTL_ITEM_CATEGORIES : INVALID
    [main] INFO org.flywaydb.core.internal.database.oracle.OracleSqlScriptExecutor - DB: TRIGGER : EMC : AIC_SAP_CLASSIFICATIONS_BIR : INVALID
    [main] INFO org.flywaydb.core.internal.database.oracle.OracleSqlScriptExecutor - DB: TRIGGER : EMC : AIC_SAP_CLASSIFICATIONS_BUR : INVALID
@Me1gireesh

This comment has been minimized.

Copy link
Author

commented Apr 27, 2019

Usually, it shows the Jars getting loaded and here nothing is shown, Again is there something i'm doing wrong in the command?

flyway -url="jdbc:oracle:thin:@my_db" -user='my_user' -password='my_user$123' -target='20.0502.1.190426095216' migrate -locations=filesystem:my_file_path -enterprise -outOfOrder=true -X

@Me1gireesh

This comment has been minimized.

Copy link
Author

commented Apr 29, 2019

Hi, could you please guide us here on why the debug level is not getting enabled despite passing the argument.

@axelfontaine

This comment has been minimized.

Copy link
Member

commented Apr 30, 2019

Those quotes are unnecessary. Can you try again with

flyway -X -url=jdbc:oracle:thin:@my_db -user=my_user '-password=my_user$123' -target=20.0502.1.190426095216 migrate -locations=filesystem:my_file_path -enterprise -outOfOrder=true

@Me1gireesh

This comment has been minimized.

Copy link
Author

commented May 2, 2019

Hi,

I have figured out that with the -enterprise option the "-X" print debug level is not working,

This does not show the debug output
[ flyway-5.2.4]$ flyway -X -url="jdbc:oracle:thin:@my-db" -user='my_user' -password='my_user$123' -target='20.0502.1.190426095216' migrate -locations=filesystem:/sbil/ci/jenkins-slave/workspace/database-migration-recompile/repo/source -enterprise -outOfOrder=true

While when i try to use the pro and community option , at least it started to prin the debug output(even though it shows it doesn't support the oracle version)

[ flyway-5.2.4]$ flyway -X -url="jdbc:oracle:thin:@my-db" -user='my_user' -password='my_user$123' -target='20.0502.1.190426095216' migrate -locations=filesystem:/sbil/ci/jenkins-slave/workspace/database-migration-recompile/repo/source -pro -outOfOrder=true

[ flyway-5.2.4]$ flyway -X -url="jdbc:oracle:thin:@my-db" -user='my_user' -password='my_user$123' -target='20.0502.1.190426095216' migrate -locations=filesystem:/sbil/ci/jenkins-slave/workspace/database-migration-recompile/repo/source -community -outOfOrder=true

Below is the console output.
############################################

[ flyway-5.2.4]$ flyway -X -url="jdbc:oracle:thin:@my-db" -user='my_user' -password='my_user$123' -target='20.0502.1.190426095216' migrate  -locations=filesystem:/sbil/ci/jenkins-slave/workspace/database-migration-recompile/repo/source -enterprise -outOfOrder=true
[main] INFO org.flywaydb.core.internal.license.VersionPrinter - Flyway Enterprise Edition (trial) 5.2.4 by Boxfuse licensed to Dell until 2019-04-04
[main] ERROR org.flywaydb.core.internal.license.VersionPrinter - Your 30 day limited Flyway trial license has expired and is no longer valid. You must upgrade to a full Flyway Enterprise Edition license immediately to keep on using this software.
[main] INFO org.flywaydb.core.internal.database.DatabaseFactory - Database: jdbc:oracle:thin:@my_db (Oracle 12.1)
[main] INFO org.flywaydb.core.internal.command.DbValidate - Successfully validated 1 migration (execution time 00:00.104s)
[main] INFO org.flywaydb.core.internal.command.DbMigrate - Current version of schema "my_user": 20.0502.1.190426095216
[main] WARN org.flywaydb.core.internal.command.DbMigrate - outOfOrder mode is active. Migration of schema "my_user" may not be reproducible.
[main] INFO org.flywaydb.core.internal.command.DbMigrate - Schema "my_user" is up to date. No migration necessary.
[servicesbildevopadm@ausdlbilci2 flyway-5.2.4]$ flyway -X -url="jdbc:oracle:thin:@my-db" -user='my_user' -password='my_user$123' -target='20.0502.1.190426095216' migrate  -locations=filesystem:/sbil/ci/jenkins-slave/workspace/database-migration-recompile/repo/source -community -outOfOrder=true
DEBUG: Loading config file: /sbil/ci/bin/flyway-5.2.4/conf/flyway.conf
DEBUG: Unable to load config file: /home/servicesbildevopadm/flyway.conf
DEBUG: Unable to load config file: /sbil/ci/bin/flyway-5.2.4/flyway.conf
DEBUG: Using configuration:
DEBUG: flyway.baselineOnMigrate -> true
DEBUG: flyway.locations -> filesystem:/sbil/ci/jenkins-slave/workspace/database-migration-recompile/repo/source
DEBUG: flyway.outOfOrder -> true
DEBUG: flyway.password -> ****************
DEBUG: flyway.oracle.sqlplus -> true
DEBUG: flyway.table -> FLYWAY_SCHEMA_HISTORY
DEBUG: flyway.schemas -> my_user
DEBUG: flyway.target -> 20.0502.1.190426095216
DEBUG: flyway.url -> jdbc:oracle:thin:@my_db
DEBUG: flyway.user -> my_user
DEBUG: flyway.licenseKey -> FL01651DD2B9088E523126E738D02D5B0A2B594CDE40D0F0A842309E3EAA75F219B212A1D8F1D322A8BCF830AD02AFA4CB9116C9774949079C756EB57BB6D3CCC87A733C9A09A98CC85C9868314AFF75E23570A6B429F2FFFC7AE88824555190379531BD0D7256031AE5BDABBB173719CBD404450F8547EAFD89DDCB3FFF965B5E017019A23418C927537002AAAA4BBBF60297D90C028E6371F7B62A76DD90643C58A918B681A00DBDAAA0F535CA0CE29781A34BCF535C10C9C4C58DCF8052733F7A5F8FF618DA45A6ABF14D33699057C3091ED00C23772EE092912265E14C50390600E8E7B5392B075DDDAF0823E3A4C464DB6FDDABB262393FD5677763118DD879
DEBUG: flyway.jarDirs -> /sbil/ci/bin/flyway-5.2.4/jars
DEBUG: Adding location to classpath: /sbil/ci/bin/flyway-5.2.4/drivers/derby-10.14.2.0.jar
DEBUG: Adding location to classpath: /sbil/ci/bin/flyway-5.2.4/drivers/derbyclient-10.14.2.0.jar
DEBUG: Adding location to classpath: /sbil/ci/bin/flyway-5.2.4/drivers/h2-1.4.197.jar
DEBUG: Adding location to classpath: /sbil/ci/bin/flyway-5.2.4/drivers/hsqldb-2.4.1.jar
DEBUG: Adding location to classpath: /sbil/ci/bin/flyway-5.2.4/drivers/mssql-jdbc-7.0.0.jre8.jar
DEBUG: Adding location to classpath: /sbil/ci/bin/flyway-5.2.4/drivers/jtds-1.3.1.jar
DEBUG: Adding location to classpath: /sbil/ci/bin/flyway-5.2.4/drivers/mysql-connector-java-8.0.12.jar
DEBUG: Adding location to classpath: /sbil/ci/bin/flyway-5.2.4/drivers/jna-4.5.2.jar
DEBUG: Adding location to classpath: /sbil/ci/bin/flyway-5.2.4/drivers/jna-platform-4.5.2.jar
DEBUG: Adding location to classpath: /sbil/ci/bin/flyway-5.2.4/drivers/mariadb-java-client-2.3.0.jar
DEBUG: Adding location to classpath: /sbil/ci/bin/flyway-5.2.4/drivers/postgresql-42.2.5.jre6.jar
DEBUG: Adding location to classpath: /sbil/ci/bin/flyway-5.2.4/drivers/sqlite-jdbc-3.23.1.jar
DEBUG: Adding location to classpath: /sbil/ci/bin/flyway-5.2.4/drivers/ojdbc7_g.jar
ERROR: Unexpected error
org.flywaydb.core.internal.license.FlywayProUpgradeRequiredException: Flyway Pro Edition or Flyway Enterprise Edition upgrade required: oracle.sqlplus is not supported by Flyway Community Edition.
        at org.flywaydb.core.api.configuration.ClassicConfiguration.setOracleSqlplus(ClassicConfiguration.java:1461)
        at org.flywaydb.core.api.configuration.ClassicConfiguration.configure(ClassicConfiguration.java:1773)
        at org.flywaydb.core.api.configuration.ClassicConfiguration.configure(ClassicConfiguration.java:1551)
        at org.flywaydb.core.api.configuration.FluentConfiguration.configuration(FluentConfiguration.java:1025)
        at org.flywaydb.commandline.Main.main(Main.java:105)
[servicesbildevopadm@ausdlbilci2 flyway-5.2.4]$ flyway -X -url="jdbc:oracle:thin:@my_db" -user='my_user' -password='my_user$123' -target='20.0502.1.190426095216' migrate  -locations=filesystem:/sbil/ci/jenkins-slave/workspace/database-migration-recompile/repo/source -pro -outOfOrder=true
DEBUG: Loading config file: /sbil/ci/bin/flyway-5.2.4/conf/flyway.conf
DEBUG: Unable to load config file: /home/servicesbildevopadm/flyway.conf
DEBUG: Unable to load config file: /sbil/ci/bin/flyway-5.2.4/flyway.conf
DEBUG: Using configuration:
DEBUG: flyway.baselineOnMigrate -> true
DEBUG: flyway.locations -> filesystem:/sbil/ci/jenkins-slave/workspace/database-migration-recompile/repo/source
DEBUG: flyway.outOfOrder -> true
DEBUG: flyway.password -> ****************
DEBUG: flyway.oracle.sqlplus -> true
DEBUG: flyway.table -> FLYWAY_SCHEMA_HISTORY
DEBUG: flyway.schemas -> my_user
DEBUG: flyway.target -> 20.0502.1.190426095216
DEBUG: flyway.url -> jdbc:oracle:thin:@my_db
DEBUG: flyway.user -> my_user
DEBUG: flyway.licenseKey -> FL01651DD2B9088E523126E738D02D5B0A2B594CDE40D0F0A842309E3EAA75F219B212A1D8F1D322A8BCF830AD02AFA4CB9116C9774949079C756EB57BB6D3CCC87A733C9A09A98CC85C9868314AFF75E23570A6B429F2FFFC7AE88824555190379531BD0D7256031AE5BDABBB173719CBD404450F8547EAFD89DDCB3FFF965B5E017019A23418C927537002AAAA4BBBF60297D90C028E6371F7B62A76DD90643C58A918B681A00DBDAAA0F535CA0CE29781A34BCF535C10C9C4C58DCF8052733F7A5F8FF618DA45A6ABF14D33699057C3091ED00C23772EE092912265E14C50390600E8E7B5392B075DDDAF0823E3A4C464DB6FDDABB262393FD5677763118DD879
DEBUG: flyway.jarDirs -> /sbil/ci/bin/flyway-5.2.4/jars
DEBUG: Adding location to classpath: /sbil/ci/bin/flyway-5.2.4/drivers/derby-10.14.2.0.jar
DEBUG: Adding location to classpath: /sbil/ci/bin/flyway-5.2.4/drivers/derbyclient-10.14.2.0.jar
DEBUG: Adding location to classpath: /sbil/ci/bin/flyway-5.2.4/drivers/h2-1.4.197.jar
DEBUG: Adding location to classpath: /sbil/ci/bin/flyway-5.2.4/drivers/hsqldb-2.4.1.jar
DEBUG: Adding location to classpath: /sbil/ci/bin/flyway-5.2.4/drivers/mssql-jdbc-7.0.0.jre8.jar
DEBUG: Adding location to classpath: /sbil/ci/bin/flyway-5.2.4/drivers/jtds-1.3.1.jar
DEBUG: Adding location to classpath: /sbil/ci/bin/flyway-5.2.4/drivers/mysql-connector-java-8.0.12.jar
DEBUG: Adding location to classpath: /sbil/ci/bin/flyway-5.2.4/drivers/jna-4.5.2.jar
DEBUG: Adding location to classpath: /sbil/ci/bin/flyway-5.2.4/drivers/jna-platform-4.5.2.jar
DEBUG: Adding location to classpath: /sbil/ci/bin/flyway-5.2.4/drivers/mariadb-java-client-2.3.0.jar
DEBUG: Adding location to classpath: /sbil/ci/bin/flyway-5.2.4/drivers/postgresql-42.2.5.jre6.jar
DEBUG: Adding location to classpath: /sbil/ci/bin/flyway-5.2.4/drivers/sqlite-jdbc-3.23.1.jar
DEBUG: Adding location to classpath: /sbil/ci/bin/flyway-5.2.4/drivers/ojdbc7_g.jar
Flyway Pro Edition (trial) 5.2.4 by Boxfuse licensed to Dell until 2019-04-04
ERROR: Your 30 day limited Flyway trial license has expired and is no longer valid. You must upgrade to a full Flyway Pro Edition license immediately to keep on using this software.
Database: jdbc:oracle:thin:@my_db (Oracle 12.1)
DEBUG: Driver  : Oracle JDBC driver 12.1.0.1.0
DEBUG: Memory usage: 31 of 117M
ERROR: Unexpected error
org.flywaydb.core.internal.license.FlywayEnterpriseUpgradeRequiredException: Flyway Enterprise Edition or Oracle upgrade required: Oracle 12.1 is past regular support by Oracle and no longer supported by Flyway Pro Edition, but still supported by Flyway Enterprise Edition.
        at org.flywaydb.core.internal.database.base.Database.ensureDatabaseIsCompatibleWithFlywayEdition(Database.java:162)
        at org.flywaydb.core.internal.database.oracle.OracleDatabase.ensureSupported(OracleDatabase.java:118)
        at org.flywaydb.core.internal.database.DatabaseFactory.createDatabase(DatabaseFactory.java:97)
        at org.flywaydb.core.Flyway.execute(Flyway.java:1670)
        at org.flywaydb.core.Flyway.migrate(Flyway.java:1356)
        at org.flywaydb.commandline.Main.executeOperation(Main.java:161)
        at org.flywaydb.commandline.Main.main(Main.java:108)
[servicesbildevopadm@ausdlbilci2 flyway-5.2.4]$ flyway -X -url="jdbc:oracle:thin:@my_db" -user='my_user' -password='my_user$123' -target='20.0502.1.190426095216' migrate  -locations=filesystem:/sbil/ci/jenkins-slave/workspace/database-migration-recompile/repo/source -enterprise -outOfOrder=true
[main] INFO org.flywaydb.core.internal.license.VersionPrinter - Flyway Enterprise Edition (trial) 5.2.4 by Boxfuse licensed to Dell until 2019-04-04
[main] ERROR org.flywaydb.core.internal.license.VersionPrinter - Your 30 day limited Flyway trial license has expired and is no longer valid. You must upgrade to a full Flyway Enterprise Edition license immediately to keep on using this software.
[main] INFO org.flywaydb.core.internal.database.DatabaseFactory - Database: jdbc:oracle:thin:@my_db (Oracle 12.1)
[main] INFO org.flywaydb.core.internal.command.DbValidate - Successfully validated 1 migration (execution time 00:00.088s)
[main] INFO org.flywaydb.core.internal.command.DbMigrate - Current version of schema "my_user": 20.0502.1.190426095216
[main] WARN org.flywaydb.core.internal.command.DbMigrate - outOfOrder mode is active. Migration of schema "my_user" may not be reproducible.
[main] INFO org.flywaydb.core.internal.command.DbMigrate - Schema "my_user" is up to date. No migration necessary.

@Me1gireesh Me1gireesh changed the title Debug level does not show the SQL execution steps Debug level does not work for enterprise option May 2, 2019

@axelfontaine

This comment has been minimized.

Copy link
Member

commented May 2, 2019

Hmmm I believe this is due to the SLF4J issue we discussed previously. Expect this to be fixed as part of 6.0.0.

@Me1gireesh

This comment has been minimized.

Copy link
Author

commented May 3, 2019

Yes, I, tied to remove the slf4j-api-1.7.26.jar and slf4j-simple-1.7.2.jar from flyway-5.2.4/lib/enterprise and the debug level -X works fine. Is there a workaround for this, to get the debug level on passing any parameters ?

axelfontaine pushed a commit to flyway/flywaydb.org that referenced this issue Jun 5, 2019
@axelfontaine

This comment has been minimized.

Copy link
Member

commented Jun 5, 2019

This was fixed as part of 6.0.0-beta2

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
2 participants
You can’t perform that action at this time.