GenerateChangeLog failed for one MySQL database

General Discussion
1

Hi, I have tried to generate change log for my MySQL schema but getting the below exception. I have tried the below things.
1.removed table names with more than 30 char length.
2. Removed all views and tried.
3. Used --diffType

my command is below:

    liquibase --changeLogFile=genChangeLog_MySchema.mysql.sql \
    --logLevel=debug \
    --logFile=MySchema1.log  \
    --includeSchema=true \
    --includeTablespace=true  \
    --diffTypes=tables,columns,indexes,foreignkeys,primarykeys,uniqueconstraints \
    generateChangeLog

I am using version 4.1.1 and openjdk 11.0.8.
Any help to solve this will be appreciated.

SEVERE [liquibase.integration] Unexpected error running Liquibase: java.lang.StringIndexOutOfBoundsException: begin 1, end 0, length 1
liquibase.exception.LiquibaseException: liquibase.command.CommandExecutionException: java.lang.StringIndexOutOfBoundsException: begin 1, end 0, length 1
	at liquibase.integration.commandline.CommandLineUtils.doGenerateChangeLog(CommandLineUtils.java:251)
	at liquibase.integration.commandline.Main.doMigration(Main.java:1518)
	at liquibase.integration.commandline.Main$1.lambda$run$0(Main.java:361)
	at liquibase.Scope.lambda$child$0(Scope.java:160)
	at liquibase.Scope.child(Scope.java:169)
	at liquibase.Scope.child(Scope.java:159)
	at liquibase.Scope.child(Scope.java:138)
	at liquibase.Scope.child(Scope.java:222)
	at liquibase.Scope.child(Scope.java:226)
	at liquibase.integration.commandline.Main$1.run(Main.java:360)
	at liquibase.integration.commandline.Main$1.run(Main.java:193)
	at liquibase.Scope.child(Scope.java:169)
	at liquibase.Scope.child(Scope.java:145)
	at liquibase.integration.commandline.Main.run(Main.java:193)
	at liquibase.integration.commandline.Main.main(Main.java:156)
Caused by: liquibase.command.CommandExecutionException: java.lang.StringIndexOutOfBoundsException: begin 1, end 0, length 1
	at liquibase.command.AbstractCommand.execute(AbstractCommand.java:24)
	at liquibase.integration.commandline.CommandLineUtils.doGenerateChangeLog(CommandLineUtils.java:249)
	... 14 more

Thanks

2

Hi @adarshg2,

Do you have views in your mysql database? If so, you may be running into this issue.

If this is the issue you can:

  • Delete views from your database if this is an option OR
  • use a Pro license, I believe that will take care of stored logic.

Hope that helps!

Ronak