Does anyone else's Community CLI not work?

• 
  Hi jahmezz,
  
  When you say Flyway Community, do you mean Flyway Desktop, community edition?
  (There's a flyway cli community edition as well)
  
  I would not expect migrate to proceed without any config as it wouldn't have a target. I'd be happy to reproduce the test if you can please give us a little more detail.

  Peter_Laws April 12, 2024 07:40

  - 0 +
• 
  Yes. I have inherited a codebase and the upgrade database script runs this.
  
  

  powershell flyway -outOfOrder="true" migrate -url=jdbc:postgresql://${host}:${port}/${database} -locations=filesystem:./${MIGRATION_FOLDER} -user=${user} ${passwordSection}
  
  When I ran this, I saw no debug statements at all. Just a silent end of the program.
  
  But when I uninstalled Flyway Desktop Community and installed Flyway CLI for Windows, it showed me printed logs and completed the migration just fine.
  
  More information about things...
  
  1. The migrations folder was a simple child folder ./migration
  2. The DB is postgres at localhost:5432, username postgres, password postgres...
  3. The migration itself was ALTER TABLE add one column to the table.
  
  It just wouldn't run. But the CLI download would.

  jahmezz April 12, 2024 07:48

  - 0 +
• 
  Given it's PowerShell, you're most likely not seeing the debug output because the default PowerShell debug settings are to just silently continue without showing you anything. (source)
  
  Additionally if you add -X to the end of your command you'll enable flyways debug output, it still requires PS debug to be enabled, but you'll get a lot more info.
  
  One of the reasons you provide the application is to take care of these things for you.
  If you find an exception in your debug output, I'd be happy to take a look for you.

  Peter_Laws April 12, 2024 14:57

  - 0 +
• 
  EDIT: Your comments were right. The table name was wrong, causing the error. Debug output being on would have saved me. Thank you.
  
  Tried it again on another computer that had Flyway Desktop installed.
  
  Using Command Prompt...
  
  flyway -X migrate -url=jdbc:postgresql://localhost:5432/database -locations=filesystem:./migrations -user=postgres -password=postgres
  
  No output.
  
  Even doing flyway version has no output.
  
  flyway by itself outputs the help information.
  
  Here is screenshot of the Flyway Desktop About screen on my computer. https://postimg.cc/t17rPfSP
  
  The remaining database update to do was this...
  

  
  

  ALTER TABLE table

      ADD COLUMN column10 NOT NULL DEFAULT 0;
  
  After running flyway migrate, this does not apply. The flyway schema history remains unchanged.
  
  But as I mention in the first comment, after uninstalling Flyway Desktop and installing the CLI, it worked just fine.
  

  
  

  jahmezz April 13, 2024 08:16

  - 0 +
• 
  Excellent news jahmezz !
  
  The version of Flyway Desktop you have, where did you pull it down from please?
  I'd expect a slightly newer version to be available and want to check all our available sources are current.
  
  Thanks!

  Peter_Laws April 15, 2024 07:21

  - 0 +
• 
  I signed up for Flyway Community and followed the install wizard. I assume that I am using an outdated version because I installed it in late January.
  

  jahmezz April 15, 2024 09:10

  - 0 +

Add comment

Please sign in to leave a comment.