Unsupported Database: MySQL 8.0 #3885
Labels
Comments
|
Hi @vifeng , |
|
thank you I did try that (of course) but no chances there. Unfortunately my free trial google account is now finished so I can no longer test anything.. |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
Which version and edition of Flyway are you using?
Flyway Community 8.2.1
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)
Gradle Version: 8.2.1 plugin
and
Flyway OSS Edition 10.11.1 by Redgate in command line
Which database are you using? (Type & version)
Mysql on google cloud sql MySQL 8.0.31
Which operating system are you using?
Mac, later i will be using docker with linux
What did you do?
I'm a beguinner working on my own, thank you for your comprehension and being very clear.
I was on h2 and migrated to gcp mysql. I had trouble with the no database found error when running
flyway cleanorgradle flywayCleanit has been corrected and is running ok (thanks to issue 3722 and issue 3355). I also use a/Users/.../[project]/flyway.confto connect to the database. Since this problem has been cleared I rungradle bootRunand it doesn't work.build.gradle.kts
plugins { id("java") id("org.springframework.boot") version "3.2.5" id("io.spring.dependency-management") version "1.1.4" id("org.asciidoctor.jvm.convert") version "3.3.2" id("com.diffplug.spotless") version "6.25.0" id("org.flywaydb.flyway") version "10.11.1" } dependencyManagement { imports { mavenBom(org.springframework.boot.gradle.plugin.SpringBootPlugin.BOM_COORDINATES) } } group = "com.vf" version = "0.0.1-SNAPSHOT" java { sourceCompatibility = JavaVersion.VERSION_17 } springBoot { mainClass.set("com.vf.eventhubserver.EventhubServerApplication") } configurations { compileOnly { extendsFrom(configurations.annotationProcessor.get()) } } repositories { mavenCentral() maven { url = uri("https://download.red-gate.com/maven/release") } } buildscript { repositories { mavenCentral() } dependencies { classpath("org.flywaydb:flyway-mysql:10.11.1") } } val snippetsDir by extra { file("build/generated-snippets") } val asciidoctorExt by configurations.creating dependencies { implementation(platform("com.google.cloud:spring-cloud-gcp-dependencies:4.1.4")) implementation("com.google.cloud:spring-cloud-gcp-starter-sql-mysql") implementation("com.google.cloud:google-cloud-secretmanager") implementation ("mysql:mysql-connector-java:8.0.31") implementation("org.flywaydb:flyway-core:10.11.1") implementation ("com.google.code.findbugs:jsr305:3.0.2") implementation("org.springframework.data:spring-data-rest-hal-explorer") asciidoctorExt("org.springframework.restdocs:spring-restdocs-asciidoctor") implementation("org.springframework.boot:spring-boot-starter-actuator") implementation("org.springframework.boot:spring-boot-starter-data-jpa") implementation("org.springframework.boot:spring-boot-starter-validation") implementation("org.springframework.boot:spring-boot-starter-web") implementation("org.springframework.boot:spring-boot-starter-webflux") implementation("org.springframework.session:spring-session-core") implementation ("org.mapstruct:mapstruct:1.5.5.Final") annotationProcessor ("org.mapstruct:mapstruct-processor:1.5.5.Final") implementation("org.springframework.boot:spring-boot-devtools") // runtimeOnly("com.h2database:h2") testImplementation("org.springframework.boot:spring-boot-starter-test") testImplementation("io.projectreactor:reactor-test") testImplementation("org.springframework.restdocs:spring-restdocs-mockmvc") testAnnotationProcessor("org.mapstruct:mapstruct-processor:1.5.5.Final") } spotless { java { target("src/**/*.java") googleJavaFormat() removeUnusedImports() } } asciidoctorj { fatalWarnings(listOf(missingIncludes())) } tasks.withType().configureEach{ options.encoding = "UTF-8" } tasks.withType().configureEach{ options.encoding = "UTF-8" } tasks.test { systemProperty("file.encoding", "UTF-8") useJUnitPlatform() outputs.dir(snippetsDir) } tasks.asciidoctor { inputs.dir(snippetsDir) configurations(listOf(asciidoctorExt)) dependsOn("test") attributes(mapOf("snippets" to snippetsDir)) outputOptions{ backends ("html5") } options(mapOf("doctype" to "book")) } tasks.jar { dependsOn("asciidoctor") from ("${snippetsDir}/html5") { into ("static/docs") } } // A custom task to delete all the files and folders generated by Gradle tasks.register("clearAll") { delete("bin") delete (".classpath") delete (".gradle") delete (".nb-gradle") delete (".project") delete (".settings") // delete (".vscode") delete (".DS_Store") delete (".idea") dependsOn(tasks.clean) }What did you expect to see?
I expected
gradle bootRunto work as before (just well!).What did you see instead? And what is your understanding of the situation:
I understand my connector and core versions are not compatible. But the doc says it's ok for 8.0 I that's what i have. I have tried several version without any luck. So what version should I use and above all, where/how do I find this info ? I really looked into your doc, nothing (same for the buildscript by the way.) I also looked into maven central i haven't find anything about compatibility. I would very much appreciate your answer so I would know for the futur.
error trace :
I would gladly provide anything relevant other file or the build --scan
(this has been posted on your forum without luck yet)
The text was updated successfully, but these errors were encountered: