search

prgrms-web-devcourse / Team-Meoguri-Linkocean-BE

팀 머구리의 링크 오션 벡엔드 입니다
http://team-meoguri-linkocean-fe.vercel.app/
2 stars 0 forks source link

V014__~ 쿼리 이슈 #35

Closed seunghan0421 closed 2 years ago

seunghan0421 commented 2 years ago

dev 환경설정 후 RDS에 flyway를 실시하니 다음과 같은 오류 메세지가 나왔습니다.

/Library/Java/JavaVirtualMachines/adoptopenjdk-11.jdk/Contents/Home/bin/java -XX:TieredStopAtLevel=1 -noverify -Dspring.profiles.active=dev -Dspring.output.ansi.enabled=always -Dcom.sun.management.jmxremote -Dspring.jmx.enabled=true -Dspring.liveBeansView.mbeanDomain -Dspring.application.admin.enabled=true -javaagent:/Users/hwangseunghan/Library/Application Support/JetBrains/Toolbox/apps/IDEA-U/ch-0/221.5921.22/IntelliJ IDEA.app/Contents/lib/idea_rt.jar=58854:/Users/hwangseunghan/Library/Application Support/JetBrains/Toolbox/apps/IDEA-U/ch-0/221.5921.22/IntelliJ IDEA.app/Contents/bin -Dfile.encoding=UTF-8 -classpath /Users/hwangseunghan/Dropbox/Mac/Documents/Team-Meoguri-Linkocean-BE/build/classes/java/main:/Users/hwangseunghan/Dropbox/Mac/Documents/Team-Meoguri-Linkocean-BE/build/resources/main:/Users/hwangseunghan/.gradle/caches/modules-2/files-2.1/org.projectlombok/lombok/1.18.24/13a394eed5c4f9efb2a6d956e2086f1d81e857d9/lombok-1.18.24.jar:/Users/hwangseunghan/.gradle/caches/modules-2/files-2.1/org.springframework.boot/spring-boot-starter-data-jpa/2.7.1/39e98264c195a06c8c29a63c24b6ce295ca10795/spring-boot-starter-data-jpa-2.7.1.jar:/Users/hwangseunghan/.gradle/caches/modules-2/files-2.1/org.springframework.boot/spring-boot-starter-web/2.7.1/29f47f503f9955b1a9746870aeaebdba448416d/spring-boot-starter-web-2.7.1.jar:/Users/hwangseunghan/.gradle/caches/modules-2/files-2.1/com.google.guava/guava/31.1-jre/60458f877d055d0c9114d9e1a2efb737b4bc282c/guava-31.1-jre.jar:/Users/hwangseunghan/.gradle/caches/modules-2/files-2.1/org.jsoup/jsoup/1.14.3/c43a81e18e6d0eb71951aa031d55d5c293c531a6/jsoup-1.14.3.jar:/Users/hwangseunghan/.gradle/caches/modules-2/files-2.1/com.h2database/h2/2.1.212/f3187885395bd0c0e0e83f96641bb630f368ee2f/h2-2.1.212.jar:/Users/hwangseunghan/.gradle/caches/modules-2/files-2.1/mysql/mysql-connector-java/8.0.29/16bfffda393ac4fe56f0985f1f035b37d3fc48f/mysql-connector-java-8.0.29.jar:/Users/hwangseunghan/.gradle/caches/modules-2/files-2.1/org.springframework.boot/spring-boot-starter-oauth2-client/2.7.1/2d056ae6acb30d971674e6ca200f8d5ded356401/spring-boot-starter-oauth2-client-2.7.1.jar:/Users/hwangseunghan/.gradle/caches/modules-2/files-2.1/org.springframework.boot/spring-boot-starter-thymeleaf/2.7.1/76b36fc78c80ca34832b670e6551845a0c76ce44/spring-boot-starter-thymeleaf-2.7.1.jar:/Users/hwangseunghan/.gradle/caches/modules-2/files-2.1/org.thymeleaf.extras/thymeleaf-extras-springsecurity5/3.0.4.RELEASE/88bb10bf73ce285208dd848e8eb17f897ebb02d4/thymeleaf-extras-springsecurity5-3.0.4.RELEASE.jar:/Users/hwangseunghan/.gradle/caches/modules-2/files-2.1/org.flywaydb/flyway-mysql/8.5.12/48f775b3c72792740bb4026ad6796b4f37f4b9d4/flyway-mysql-8.5.12.jar:/Users/hwangseunghan/.gradle/caches/modules-2/files-2.1/org.springframework.boot/spring-boot-starter-aop/2.7.1/e7c78497e3528ae3037c723259b4b0944994f03/spring-boot-starter-aop-2.7.1.jar:/Users/hwangseunghan/.gradle/caches/modules-2/files-2.1/org.springframework.boot/spring-boot-starter-jdbc/2.7.1/bba8a72a8042cec0b7961f11b0b3332724f5845e/spring-boot-starter-jdbc-2.7.1.jar:/Users/hwangseunghan/.gradle/caches/modules-2/files-2.1/jakarta.transaction/jakarta.transaction-api/1.3.3/c4179d48720a1e87202115fbed6089bdc4195405/jakarta.transaction-api-1.3.3.jar:/Users/hwangseunghan/.gradle/caches/modules-2/files-2.1/jakarta.persistence/jakarta.persistence-api/2.2.3/8f6ea5daedc614f07a3654a455660145286f024e/jakarta.persistence-api-2.2.3.jar:/Users/hwangseunghan/.gradle/caches/modules-2/files-2.1/org.hibernate/hibernate-core/5.6.9.Final/8ec2c7b13de2fbcb19feddfb3a30932bb6a8228a/hibernate-core-5.6.9.Final.jar:/Users/hwangseunghan/.gradle/caches/modules-2/files-2.1/org.springframework.data/spring-data-jpa/2.7.1/9cbefcab47d47a64afeca24b5fbe7328dd08ef9b/spring-data-jpa-2.7.1.jar:/Users/hwangseunghan/.gradle/caches/modules-2/files-2.1/org.springframework/spring-aspects/5.3.21/9e8271b86c5be0388c2c34f2c5c3d070af06cd2/spring-aspects-5.3.21.jar:/Users/hwangseunghan/.gradle/caches/modules-2/files-2.1/org.springframework.boot/spring-boot-starter-json/2.7.1/711889df8474d7f0271b1e25cd75a9249e0a4621/spring-boot-starter-json-2.7.1.jar:/Users/hwangseunghan/.gradle/caches/modules-2/files-2.1/org.springframework.boot/spring-boot-starter/2.7.1/48f7e04459ccc16d3532bfc486c1b6d629e6e0fc/spring-boot-starter-2.7.1.jar:/Users/hwangseunghan/.gradle/caches/modules-2/files-2.1/org.springframework.boot/spring-boot-starter-tomcat/2.7.1/c99fe94b685f1707907afb84ecb998ac13271ead/spring-boot-starter-tomcat-2.7.1.jar:/Users/hwangseunghan/.gradle/caches/modules-2/files-2.1/org.springframework/spring-webmvc/5.3.21/a62db425cc29c48e138846e706ca37acb138ca13/spring-webmvc-5.3.21.jar:/Users/hwangseunghan/.gradle/caches/modules-2/files-2.1/org.springframework/spring-web/5.3.21/317aadd37f70ba34ff93d068343e3110b5dcf2f/spring-web-5.3.21.jar:/Users/hwangseunghan/.gradle/caches/modules-2/files-2.1/com.google.guava/failureaccess/1.0.1/1dcf1de382a0bf95a3d8b0849546c88bac1292c9/failureaccess-1.0.1.jar:/Users/hwangseunghan/.gradle/caches/modules-2/files-2.1/com.google.guava/listenablefuture/9999.0-empty-to-avoid-conflict-with-guava/b421526c5f297295adef1c886e5246c39d4ac629/listenablefuture-9999.0-empty-to-avoid-conflict-with-guava.jar:/Users/hwangseunghan/.gradle/caches/modules-2/files-2.1/com.google.code.findbugs/jsr305/3.0.2/25ea2e8b0c338a877313bd4672d3fe056ea78f0d/jsr305-3.0.2.jar:/Users/hwangseunghan/.gradle/caches/modules-2/files-2.1/org.checkerframework/checker-qual/3.12.0/d5692f0526415fcc6de94bb5bfbd3afd9dd3b3e5/checker-qual-3.12.0.jar:/Users/hwangseunghan/.gradle/caches/modules-2/files-2.1/com.google.errorprone/error_prone_annotations/2.11.0/c5a0ace696d3f8b1c1d8cc036d8c03cc0cbe6b69/error_prone_annotations-2.11.0.jar:/Users/hwangseunghan/.gradle/caches/modules-2/files-2.1/com.google.j2objc/j2objc-annotations/1.3/ba035118bc8bac37d7eff77700720999acd9986d/j2objc-annotations-1.3.jar:/Users/hwangseunghan/.gradle/caches/modules-2/files-2.1/org.springframework.security/spring-security-oauth2-client/5.7.2/d41f66630e320055ea1fb287bf0ca941bf6058e5/spring-security-oauth2-client-5.7.2.jar:/Users/hwangseunghan/.gradle/caches/modules-2/files-2.1/org.springframework.security/spring-security-oauth2-jose/5.7.2/a252fbe76622ce0d1435ef2fb043149346923b4/spring-security-oauth2-jose-5.7.2.jar:/Users/hwangseunghan/.gradle/caches/modules-2/files-2.1/org.springframework.security/spring-security-config/5.7.2/aa69c37286d37ffe9a5534210692f986777d6f60/spring-security-config-5.7.2.jar:/Users/hwangseunghan/.gradle/caches/modules-2/files-2.1/org.springframework.security/spring-security-core/5.7.2/48cc4cec862ca88ea199f1c98a1b9a8ea5701467/spring-security-core-5.7.2.jar:/Users/hwangseunghan/.gradle/caches/modules-2/files-2.1/org.thymeleaf/thymeleaf-spring5/3.0.15.RELEASE/7170e1bcd1588d38c139f7048ebcc262676441c3/thymeleaf-spring5-3.0.15.RELEASE.jar:/Users/hwangseunghan/.gradle/caches/modules-2/files-2.1/org.thymeleaf.extras/thymeleaf-extras-java8time/3.0.4.RELEASE/36e7175ddce36c486fff4578b5af7bb32f54f5df/thymeleaf-extras-java8time-3.0.4.RELEASE.jar:/Users/hwangseunghan/.gradle/caches/modules-2/files-2.1/org.slf4j/slf4j-api/1.7.36/6c62681a2f655b49963a5983b8b0950a6120ae14/slf4j-api-1.7.36.jar:/Users/hwangseunghan/.gradle/caches/modules-2/files-2.1/org.flywaydb/flyway-core/8.5.13/659e5942926c38af7347b3e9f1f7658b22aa78b7/flyway-core-8.5.13.jar:/Users/hwangseunghan/.gradle/caches/modules-2/files-2.1/org.springframework/spring-aop/5.3.21/58ec4ff7a0ce30a1e2612f04ad0fb13ea806705/spring-aop-5.3.21.jar:/Users/hwangseunghan/.gradle/caches/modules-2/files-2.1/org.aspectj/aspectjweaver/1.9.7/158f5c255cd3e4408e795b79f7c3fbae9b53b7ca/aspectjweaver-1.9.7.jar:/Users/hwangseunghan/.gradle/caches/modules-2/files-2.1/com.zaxxer/HikariCP/4.0.3/107cbdf0db6780a065f895ae9d8fbf3bb0e1c21f/HikariCP-4.0.3.jar:/Users/hwangseunghan/.gradle/caches/modules-2/files-2.1/org.springframework/spring-jdbc/5.3.21/68f9b9a9b1541bdb40a7187f5eb96e3af6c27b40/spring-jdbc-5.3.21.jar:/Users/hwangseunghan/.gradle/caches/modules-2/files-2.1/org.hibernate.common/hibernate-commons-annotations/5.1.2.Final/e59ffdbc6ad09eeb33507b39ffcf287679a498c8/hibernate-commons-annotations-5.1.2.Final.jar:/Users/hwangseunghan/.gradle/caches/modules-2/files-2.1/org.jboss.logging/jboss-logging/3.4.3.Final/c4bd7e12a745c0e7f6cf98c45cdcdf482fd827ea/jboss-logging-3.4.3.Final.jar:/Users/hwangseunghan/.gradle/caches/modules-2/files-2.1/net.bytebuddy/byte-buddy/1.12.11/ebeebf10ea48f997da583cdb6ce861eee279a507/byte-buddy-1.12.11.jar:/Users/hwangseunghan/.gradle/caches/modules-2/files-2.1/antlr/antlr/2.7.7/83cd2cd674a217ade95a4bb83a8a14f351f48bd0/antlr-2.7.7.jar:/Users/hwangseunghan/.gradle/caches/modules-2/files-2.1/org.jboss/jandex/2.4.2.Final/1e1c385990b258ff1a24c801e84aebbacf70eb39/jandex-2.4.2.Final.jar:/Users/hwangseunghan/.gradle/caches/modules-2/files-2.1/com.fasterxml/classmate/1.5.1/3fe0bed568c62df5e89f4f174c101eab25345b6c/classmate-1.5.1.jar:/Users/hwangseunghan/.gradle/caches/modules-2/files-2.1/org.glassfish.jaxb/jaxb-runtime/2.3.6/1e6cd0e5d9f9919c8c8824fb4d310b09a978a60e/jaxb-runtime-2.3.6.jar:/Users/hwangseunghan/.gradle/caches/modules-2/files-2.1/org.springframework.data/spring-data-commons/2.7.1/ed6cd9f72f7712ea1a2c56c3affdba3c4f3948a8/spring-data-commons-2.7.1.jar:/Users/hwangseunghan/.gradle/caches/modules-2/files-2.1/org.springframework/spring-context/5.3.21/fe371c85f02b8c6690fc3b3d0950ef4f965db0cd/spring-context-5.3.21.jar:/Users/hwangseunghan/.gradle/caches/modules-2/files-2.1/org.springframework/spring-orm/5.3.21/388e8c494b667df092817bd1bf8e588643bcd253/spring-orm-5.3.21.jar:/Users/hwangseunghan/.gradle/caches/modules-2/files-2.1/org.springframework/spring-tx/5.3.21/13f4f564024d2f85502c151942307c3ca851a4f7/spring-tx-5.3.21.jar:/Users/hwangseunghan/.gradle/caches/modules-2/files-2.1/org.springframework/spring-beans/5.3.21/e3eae7e6d211381642a0b7507a5215e3ac1b32e1/spring-beans-5.3.21.jar:/Users/hwangseunghan/.gradle/caches/modules-2/files-2.1/org.springframework/spring-core/5.3.21/1b0c9be6b972e4c615f175c70fc32e80557e68e8/spring-core-5.3.21.jar:/Users/hwangseunghan/.gradle/caches/modules-2/files-2.1/com.fasterxml.jackson.datatype/jackson-datatype-jsr310/2.13.3/ad2f4c61aeb9e2a8bb5e4a3ed782cfddec52d972/jackson-datatype-jsr310-2.13.3.jar:/Users/hwangseunghan/.gradle/caches/modules-2/files-2.1/com.fasterxml.jackson.module/jackson-module-parameter-names/2.13.3/f71c4ecc1a403787c963f68bc619b78ce1d2687b/jackson-module-parameter-names-2.13.3.jar:/Users/hwangseunghan/.gradle/caches/modules-2/files-2.1/com.fasterxml.jackson.datatype/jackson-datatype-jdk8/2.13.3/d4884595d5aab5babdb00ddbd693b8fd36b5ec3c/jackson-datatype-jdk8-2.13.3.jar:/Users/hwangseunghan/.gradle/caches/modules-2/files-2.1/com.fasterxml.jackson.core/jackson-databind/2.13.3/56deb9ea2c93a7a556b3afbedd616d342963464e/jackson-databind-2.13.3.jar:/Users/hwangseunghan/.gradle/caches/modules-2/files-2.1/org.springframework.boot/spring-boot-starter-logging/2.7.1/461cf82dc10505f47d3ce2146bd01721177cde4a/spring-boot-starter-logging-2.7.1.jar:/Users/hwangseunghan/.gradle/caches/modules-2/files-2.1/org.springframework.boot/spring-boot-autoconfigure/2.7.1/923ad789b004e8cc17d67853b1e4d3db11946f0/spring-boot-autoconfigure-2.7.1.jar:/Users/hwangseunghan/.gradle/caches/modules-2/files-2.1/org.springframework.boot/spring-boot/2.7.1/8e49b8e7e9ea470a7772f489532264732ab206a2/spring-boot-2.7.1.jar:/Users/hwangseunghan/.gradle/caches/modules-2/files-2.1/jakarta.annotation/jakarta.annotation-api/1.3.5/59eb84ee0d616332ff44aba065f3888cf002cd2d/jakarta.annotation-api-1.3.5.jar:/Users/hwangseunghan/.gradle/caches/modules-2/files-2.1/org.yaml/snakeyaml/1.30/8fde7fe2586328ac3c68db92045e1c8759125000/snakeyaml-1.30.jar:/Users/hwangseunghan/.gradle/caches/modules-2/files-2.1/org.apache.tomcat.embed/tomcat-embed-websocket/9.0.64/2a5e4f1f04830f2bfd01108ddc59a451c4baef34/tomcat-embed-websocket-9.0.64.jar:/Users/hwangseunghan/.gradle/caches/modules-2/files-2.1/org.apache.tomcat.embed/tomcat-embed-core/9.0.64/2d91a06d1b93ba13a2cca9e9ea7c143a64037351/tomcat-embed-core-9.0.64.jar:/Users/hwangseunghan/.gradle/caches/modules-2/files-2.1/org.apache.tomcat.embed/tomcat-embed-el/9.0.64/227363669235feab54519102af723a54d1a7850e/tomcat-embed-el-9.0.64.jar:/Users/hwangseunghan/.gradle/caches/modules-2/files-2.1/org.springframework/spring-expression/5.3.21/ca8c5822fc528066ec717f1e74160a1575c43192/spring-expression-5.3.21.jar:/Users/hwangseunghan/.gradle/caches/modules-2/files-2.1/org.springframework.security/spring-security-oauth2-core/5.7.2/1596443a3268e749f4c3db4f6ba02b6e8261e677/spring-security-oauth2-core-5.7.2.jar:/Users/hwangseunghan/.gradle/caches/modules-2/files-2.1/org.springframework.security/spring-security-web/5.7.2/3933d4de5c80b8f6b4711207f2fcfac9020f8aed/spring-security-web-5.7.2.jar:/Users/hwangseunghan/.gradle/caches/modules-2/files-2.1/com.nimbusds/oauth2-oidc-sdk/9.35/7bfdf91bc4ae265f6c49a367bc0ed0e47d0e3a97/oauth2-oidc-sdk-9.35.jar:/Users/hwangseunghan/.gradle/caches/modules-2/files-2.1/com.nimbusds/nimbus-jose-jwt/9.22/bed63628cd31d8641c5a1b29609a965179ef91ec/nimbus-jose-jwt-9.22.jar:/Users/hwangseunghan/.gradle/caches/modules-2/files-2.1/org.springframework.security/spring-security-crypto/5.7.2/323a1844204fc8e05cead2bd75a9077121eba87e/spring-security-crypto-5.7.2.jar:/Users/hwangseunghan/.gradle/caches/modules-2/files-2.1/org.thymeleaf/thymeleaf/3.0.15.RELEASE/13e3296a03d8a597b734d832ed8656139bf9cdd8/thymeleaf-3.0.15.RELEASE.jar:/Users/hwangseunghan/.gradle/caches/modules-2/files-2.1/jakarta.xml.bind/jakarta.xml.bind-api/2.3.3/48e3b9cfc10752fba3521d6511f4165bea951801/jakarta.xml.bind-api-2.3.3.jar:/Users/hwangseunghan/.gradle/caches/modules-2/files-2.1/org.glassfish.jaxb/txw2/2.3.6/45db7b69a8f1ec2c21eb7d4fc0ee729f53c1addc/txw2-2.3.6.jar:/Users/hwangseunghan/.gradle/caches/modules-2/files-2.1/com.sun.istack/istack-commons-runtime/3.0.12/cbbe1a62b0cc6c85972e99d52aaee350153dc530/istack-commons-runtime-3.0.12.jar:/Users/hwangseunghan/.gradle/caches/modules-2/files-2.1/org.springframework/spring-jcl/5.3.21/b41a2888c0e708f9fd12cf9cc0c29cebbcab2e5e/spring-jcl-5.3.21.jar:/Users/hwangseunghan/.gradle/caches/modules-2/files-2.1/com.fasterxml.jackson.core/jackson-annotations/2.13.3/7198b3aac15285a49e218e08441c5f70af00fc51/jackson-annotations-2.13.3.jar:/Users/hwangseunghan/.gradle/caches/modules-2/files-2.1/com.fasterxml.jackson.core/jackson-core/2.13.3/a27014716e4421684416e5fa83d896ddb87002da/jackson-core-2.13.3.jar:/Users/hwangseunghan/.gradle/caches/modules-2/files-2.1/ch.qos.logback/logback-classic/1.2.11/4741689214e9d1e8408b206506cbe76d1c6a7d60/logback-classic-1.2.11.jar:/Users/hwangseunghan/.gradle/caches/modules-2/files-2.1/org.apache.logging.log4j/log4j-to-slf4j/2.17.2/17dd0fae2747d9a28c67bc9534108823d2376b46/log4j-to-slf4j-2.17.2.jar:/Users/hwangseunghan/.gradle/caches/modules-2/files-2.1/org.slf4j/jul-to-slf4j/1.7.36/ed46d81cef9c412a88caef405b58f93a678ff2ca/jul-to-slf4j-1.7.36.jar:/Users/hwangseunghan/.gradle/caches/modules-2/files-2.1/com.github.stephenc.jcip/jcip-annotations/1.0-1/ef31541dd28ae2cefdd17c7ebf352d93e9058c63/jcip-annotations-1.0-1.jar:/Users/hwangseunghan/.gradle/caches/modules-2/files-2.1/com.nimbusds/content-type/2.2/9a894bce7646dd4086652d85b88013229f23724b/content-type-2.2.jar:/Users/hwangseunghan/.gradle/caches/modules-2/files-2.1/net.minidev/json-smart/2.4.8/7c62f5f72ab05eb54d40e2abf0360a2fe9ea477f/json-smart-2.4.8.jar:/Users/hwangseunghan/.gradle/caches/modules-2/files-2.1/com.nimbusds/lang-tag/1.6/ba96ae591bf885f130a772794f07209e2bdb9fb5/lang-tag-1.6.jar:/Users/hwangseunghan/.gradle/caches/modules-2/files-2.1/org.attoparser/attoparser/2.0.5.RELEASE/a93ad36df9560de3a5312c1d14f69d938099fa64/attoparser-2.0.5.RELEASE.jar:/Users/hwangseunghan/.gradle/caches/modules-2/files-2.1/org.unbescape/unbescape/1.1.6.RELEASE/7b90360afb2b860e09e8347112800d12c12b2a13/unbescape-1.1.6.RELEASE.jar:/Users/hwangseunghan/.gradle/caches/modules-2/files-2.1/ch.qos.logback/logback-core/1.2.11/a01230df5ca5c34540cdaa3ad5efb012f1f1f792/logback-core-1.2.11.jar:/Users/hwangseunghan/.gradle/caches/modules-2/files-2.1/org.apache.logging.log4j/log4j-api/2.17.2/f42d6afa111b4dec5d2aea0fe2197240749a4ea6/log4j-api-2.17.2.jar:/Users/hwangseunghan/.gradle/caches/modules-2/files-2.1/net.minidev/accessors-smart/2.4.8/6e1bee5a530caba91893604d6ab41d0edcecca9a/accessors-smart-2.4.8.jar:/Users/hwangseunghan/.gradle/caches/modules-2/files-2.1/org.ow2.asm/asm/9.1/a99500cf6eea30535eeac6be73899d048f8d12a8/asm-9.1.jar:/Users/hwangseunghan/.gradle/caches/modules-2/files-2.1/com.sun.activation/jakarta.activation/1.2.2/74548703f9851017ce2f556066659438019e7eb5/jakarta.activation-1.2.2.jar com.meoguri.linkocean.LinkoceanApplication

  .   ____          _            __ _ _
 /\\ / ___'_ __ _ _(_)_ __  __ _ \ \ \ \
( ( )\___ | '_ | '_| | '_ \/ _` | \ \ \ \
 \\/  ___)| |_)| | | | | || (_| |  ) ) ) )
  '  |____| .__|_| |_|_| |_\__, | / / / /
 =========|_|==============|___/=/_/_/_/
 :: Spring Boot ::                (v2.7.1)

2022-07-26 22:54:34.078  INFO 54313 --- [           main] c.m.linkocean.LinkoceanApplication       : Starting LinkoceanApplication using Java 11.0.11 on hwangseunghan-ui-MacBookPro.local with PID 54313 (/Users/hwangseunghan/Dropbox/Mac/Documents/Team-Meoguri-Linkocean-BE/build/classes/java/main started by hwangseunghan in /Users/hwangseunghan/Dropbox/Mac/Documents/Team-Meoguri-Linkocean-BE)
2022-07-26 22:54:34.082  INFO 54313 --- [           main] c.m.linkocean.LinkoceanApplication       : The following 2 profiles are active: "oauth", "dev"
2022-07-26 22:54:35.045  INFO 54313 --- [           main] .s.d.r.c.RepositoryConfigurationDelegate : Bootstrapping Spring Data JPA repositories in DEFAULT mode.
2022-07-26 22:54:35.143  INFO 54313 --- [           main] .s.d.r.c.RepositoryConfigurationDelegate : Finished Spring Data repository scanning in 86 ms. Found 7 JPA repository interfaces.
2022-07-26 22:54:35.775  INFO 54313 --- [           main] o.s.b.w.embedded.tomcat.TomcatWebServer  : Tomcat initialized with port(s): 8080 (http)
2022-07-26 22:54:35.786  INFO 54313 --- [           main] o.apache.catalina.core.StandardService   : Starting service [Tomcat]
2022-07-26 22:54:35.787  INFO 54313 --- [           main] org.apache.catalina.core.StandardEngine  : Starting Servlet engine: [Apache Tomcat/9.0.64]
2022-07-26 22:54:35.909  INFO 54313 --- [           main] o.a.c.c.C.[Tomcat].[localhost].[/]       : Initializing Spring embedded WebApplicationContext
2022-07-26 22:54:35.910  INFO 54313 --- [           main] w.s.c.ServletWebServerApplicationContext : Root WebApplicationContext: initialization completed in 1767 ms
2022-07-26 22:54:36.070  INFO 54313 --- [           main] o.f.c.internal.license.VersionPrinter    : Flyway Community Edition 8.5.13 by Redgate
2022-07-26 22:54:36.070  INFO 54313 --- [           main] o.f.c.internal.license.VersionPrinter    : See what's new here: https://flywaydb.org/documentation/learnmore/releaseNotes#8.5.13
2022-07-26 22:54:36.070  INFO 54313 --- [           main] o.f.c.internal.license.VersionPrinter    : 
2022-07-26 22:54:36.484  INFO 54313 --- [           main] o.f.c.i.database.base.BaseDatabaseType   : Database: jdbc:mysql://linkocean-dev-rds.czvbgr7hie3i.ap-northeast-2.rds.amazonaws.com:3306/linkocean (MySQL 8.0)
2022-07-26 22:54:36.686  INFO 54313 --- [           main] o.f.core.internal.command.DbValidate     : Successfully validated 14 migrations (execution time 00:00.075s)
2022-07-26 22:54:36.795  INFO 54313 --- [           main] o.f.c.i.s.JdbcTableSchemaHistory         : Creating Schema History table `linkocean`.`flyway_schema_history` ...
2022-07-26 22:54:37.052  INFO 54313 --- [           main] o.f.core.internal.command.DbMigrate      : Current version of schema `linkocean`: << Empty Schema >>
2022-07-26 22:54:37.094  INFO 54313 --- [           main] o.f.core.internal.command.DbMigrate      : Migrating schema `linkocean` to version "001 - Create bookmark"
2022-07-26 22:54:37.355  INFO 54313 --- [           main] o.f.core.internal.command.DbMigrate      : Migrating schema `linkocean` to version "002 - Create bookmark tag"
2022-07-26 22:54:37.598  INFO 54313 --- [           main] o.f.core.internal.command.DbMigrate      : Migrating schema `linkocean` to version "003 - Create category"
2022-07-26 22:54:37.846  INFO 54313 --- [           main] o.f.core.internal.command.DbMigrate      : Migrating schema `linkocean` to version "004 - Create favorite category"
2022-07-26 22:54:38.094  INFO 54313 --- [           main] o.f.core.internal.command.DbMigrate      : Migrating schema `linkocean` to version "005 - Create follow"
2022-07-26 22:54:38.343  INFO 54313 --- [           main] o.f.core.internal.command.DbMigrate      : Migrating schema `linkocean` to version "006 - Create link metadata"
2022-07-26 22:54:38.580  INFO 54313 --- [           main] o.f.core.internal.command.DbMigrate      : Migrating schema `linkocean` to version "007 - Create notification"
2022-07-26 22:54:38.805  INFO 54313 --- [           main] o.f.core.internal.command.DbMigrate      : Migrating schema `linkocean` to version "008 - Create profile"
2022-07-26 22:54:39.032  INFO 54313 --- [           main] o.f.core.internal.command.DbMigrate      : Migrating schema `linkocean` to version "009 - Create reaction"
2022-07-26 22:54:39.257  INFO 54313 --- [           main] o.f.core.internal.command.DbMigrate      : Migrating schema `linkocean` to version "010 - Create tag"
2022-07-26 22:54:39.783  INFO 54313 --- [           main] o.f.core.internal.command.DbMigrate      : Migrating schema `linkocean` to version "011 - Create users"
2022-07-26 22:54:40.047  INFO 54313 --- [           main] o.f.core.internal.command.DbMigrate      : Migrating schema `linkocean` to version "012 - Add Foreign Option"
2022-07-26 22:54:41.330  INFO 54313 --- [           main] o.f.core.internal.command.DbMigrate      : Migrating schema `linkocean` to version "013 - ALTER reaction"
2022-07-26 22:54:41.626  INFO 54313 --- [           main] o.f.core.internal.command.DbMigrate      : Migrating schema `linkocean` to version "014 - ADD AUTO INCREMENT"
2022-07-26 22:54:41.993 ERROR 54313 --- [           main] o.f.core.internal.command.DbMigrate      : Migration of schema `linkocean` to version "014 - ADD AUTO INCREMENT" failed! Please restore backups and roll back database and code!
2022-07-26 22:54:42.154  WARN 54313 --- [           main] ConfigServletWebServerApplicationContext : Exception encountered during context initialization - cancelling refresh attempt: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'flywayInitializer' defined in class path resource [org/springframework/boot/autoconfigure/flyway/FlywayAutoConfiguration$FlywayConfiguration.class]: Invocation of init method failed; nested exception is org.flywaydb.core.internal.command.DbMigrate$FlywayMigrateException: Migration V014__ADD_AUTO_INCREMENT.sql failed
---------------------------------------------
SQL State  : 42000
Error Code : 1227
Message    : Access denied; you need (at least one of) the SUPER or SYSTEM_VARIABLES_ADMIN privilege(s) for this operation
Location   : db/migration/V014__ADD_AUTO_INCREMENT.sql (/Users/hwangseunghan/Dropbox/Mac/Documents/Team-Meoguri-Linkocean-BE/build/resources/main/db/migration/V014__ADD_AUTO_INCREMENT.sql)
Line       : 8
Statement  : SET
GLOBAL FOREIGN_KEY_CHECKS=0

2022-07-26 22:54:42.159  INFO 54313 --- [           main] o.apache.catalina.core.StandardService   : Stopping service [Tomcat]
2022-07-26 22:54:42.179  INFO 54313 --- [           main] ConditionEvaluationReportLoggingListener : 

Error starting ApplicationContext. To display the conditions report re-run your application with 'debug' enabled.
2022-07-26 22:54:42.219 ERROR 54313 --- [           main] o.s.boot.SpringApplication               : Application run failed

org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'flywayInitializer' defined in class path resource [org/springframework/boot/autoconfigure/flyway/FlywayAutoConfiguration$FlywayConfiguration.class]: Invocation of init method failed; nested exception is org.flywaydb.core.internal.command.DbMigrate$FlywayMigrateException: Migration V014__ADD_AUTO_INCREMENT.sql failed
---------------------------------------------
SQL State  : 42000
Error Code : 1227
Message    : Access denied; you need (at least one of) the SUPER or SYSTEM_VARIABLES_ADMIN privilege(s) for this operation
Location   : db/migration/V014__ADD_AUTO_INCREMENT.sql (/Users/hwangseunghan/Dropbox/Mac/Documents/Team-Meoguri-Linkocean-BE/build/resources/main/db/migration/V014__ADD_AUTO_INCREMENT.sql)
Line       : 8
Statement  : SET
GLOBAL FOREIGN_KEY_CHECKS=0

    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1804) ~[spring-beans-5.3.21.jar:5.3.21]
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:620) ~[spring-beans-5.3.21.jar:5.3.21]
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:542) ~[spring-beans-5.3.21.jar:5.3.21]
    at org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:335) ~[spring-beans-5.3.21.jar:5.3.21]
    at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:234) ~[spring-beans-5.3.21.jar:5.3.21]
    at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:333) ~[spring-beans-5.3.21.jar:5.3.21]
    at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:208) ~[spring-beans-5.3.21.jar:5.3.21]
    at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:322) ~[spring-beans-5.3.21.jar:5.3.21]
    at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:208) ~[spring-beans-5.3.21.jar:5.3.21]
    at org.springframework.context.support.AbstractApplicationContext.getBean(AbstractApplicationContext.java:1154) ~[spring-context-5.3.21.jar:5.3.21]
    at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:908) ~[spring-context-5.3.21.jar:5.3.21]
    at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:583) ~[spring-context-5.3.21.jar:5.3.21]
    at org.springframework.boot.web.servlet.context.ServletWebServerApplicationContext.refresh(ServletWebServerApplicationContext.java:147) ~[spring-boot-2.7.1.jar:2.7.1]
    at org.springframework.boot.SpringApplication.refresh(SpringApplication.java:734) ~[spring-boot-2.7.1.jar:2.7.1]
    at org.springframework.boot.SpringApplication.refreshContext(SpringApplication.java:408) ~[spring-boot-2.7.1.jar:2.7.1]
    at org.springframework.boot.SpringApplication.run(SpringApplication.java:308) ~[spring-boot-2.7.1.jar:2.7.1]
    at org.springframework.boot.SpringApplication.run(SpringApplication.java:1306) ~[spring-boot-2.7.1.jar:2.7.1]
    at org.springframework.boot.SpringApplication.run(SpringApplication.java:1295) ~[spring-boot-2.7.1.jar:2.7.1]
    at com.meoguri.linkocean.LinkoceanApplication.main(LinkoceanApplication.java:12) ~[main/:na]
Caused by: org.flywaydb.core.internal.command.DbMigrate$FlywayMigrateException: Migration V014__ADD_AUTO_INCREMENT.sql failed
---------------------------------------------
SQL State  : 42000
Error Code : 1227
Message    : Access denied; you need (at least one of) the SUPER or SYSTEM_VARIABLES_ADMIN privilege(s) for this operation
Location   : db/migration/V014__ADD_AUTO_INCREMENT.sql (/Users/hwangseunghan/Dropbox/Mac/Documents/Team-Meoguri-Linkocean-BE/build/resources/main/db/migration/V014__ADD_AUTO_INCREMENT.sql)
Line       : 8
Statement  : SET
GLOBAL FOREIGN_KEY_CHECKS=0

    at org.flywaydb.core.internal.command.DbMigrate.doMigrateGroup(DbMigrate.java:385) ~[flyway-core-8.5.13.jar:na]
    at org.flywaydb.core.internal.command.DbMigrate.lambda$applyMigrations$1(DbMigrate.java:275) ~[flyway-core-8.5.13.jar:na]
    at org.flywaydb.core.internal.jdbc.TransactionalExecutionTemplate.execute(TransactionalExecutionTemplate.java:55) ~[flyway-core-8.5.13.jar:na]
    at org.flywaydb.core.internal.command.DbMigrate.applyMigrations(DbMigrate.java:274) ~[flyway-core-8.5.13.jar:na]
    at org.flywaydb.core.internal.command.DbMigrate.migrateGroup(DbMigrate.java:247) ~[flyway-core-8.5.13.jar:na]
    at org.flywaydb.core.internal.command.DbMigrate.lambda$migrateAll$0(DbMigrate.java:141) ~[flyway-core-8.5.13.jar:na]
    at org.flywaydb.database.mysql.MySQLNamedLockTemplate.execute(MySQLNamedLockTemplate.java:58) ~[flyway-mysql-8.5.12.jar:na]
    at org.flywaydb.database.mysql.MySQLConnection.lock(MySQLConnection.java:152) ~[flyway-mysql-8.5.12.jar:na]
    at org.flywaydb.core.internal.schemahistory.JdbcTableSchemaHistory.lock(JdbcTableSchemaHistory.java:139) ~[flyway-core-8.5.13.jar:na]
    at org.flywaydb.core.internal.command.DbMigrate.migrateAll(DbMigrate.java:141) ~[flyway-core-8.5.13.jar:na]
    at org.flywaydb.core.internal.command.DbMigrate.migrate(DbMigrate.java:98) ~[flyway-core-8.5.13.jar:na]
    at org.flywaydb.core.Flyway$1.execute(Flyway.java:172) ~[flyway-core-8.5.13.jar:na]
    at org.flywaydb.core.Flyway$1.execute(Flyway.java:124) ~[flyway-core-8.5.13.jar:na]
    at org.flywaydb.core.FlywayExecutor.execute(FlywayExecutor.java:205) ~[flyway-core-8.5.13.jar:na]
    at org.flywaydb.core.Flyway.migrate(Flyway.java:124) ~[flyway-core-8.5.13.jar:na]
    at org.springframework.boot.autoconfigure.flyway.FlywayMigrationInitializer.afterPropertiesSet(FlywayMigrationInitializer.java:66) ~[spring-boot-autoconfigure-2.7.1.jar:2.7.1]
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1863) ~[spring-beans-5.3.21.jar:5.3.21]
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1800) ~[spring-beans-5.3.21.jar:5.3.21]
    ... 18 common frames omitted
Caused by: org.flywaydb.core.internal.sqlscript.FlywaySqlScriptException: Migration V014__ADD_AUTO_INCREMENT.sql failed
---------------------------------------------
SQL State  : 42000
Error Code : 1227
Message    : Access denied; you need (at least one of) the SUPER or SYSTEM_VARIABLES_ADMIN privilege(s) for this operation
Location   : db/migration/V014__ADD_AUTO_INCREMENT.sql (/Users/hwangseunghan/Dropbox/Mac/Documents/Team-Meoguri-Linkocean-BE/build/resources/main/db/migration/V014__ADD_AUTO_INCREMENT.sql)
Line       : 8
Statement  : SET
GLOBAL FOREIGN_KEY_CHECKS=0

    at org.flywaydb.core.internal.sqlscript.DefaultSqlScriptExecutor.handleException(DefaultSqlScriptExecutor.java:275) ~[flyway-core-8.5.13.jar:na]
    at org.flywaydb.core.internal.sqlscript.DefaultSqlScriptExecutor.executeStatement(DefaultSqlScriptExecutor.java:222) ~[flyway-core-8.5.13.jar:na]
    at org.flywaydb.core.internal.sqlscript.DefaultSqlScriptExecutor.execute(DefaultSqlScriptExecutor.java:126) ~[flyway-core-8.5.13.jar:na]
    at org.flywaydb.core.internal.resolver.sql.SqlMigrationExecutor.executeOnce(SqlMigrationExecutor.java:69) ~[flyway-core-8.5.13.jar:na]
    at org.flywaydb.core.internal.resolver.sql.SqlMigrationExecutor.lambda$execute$0(SqlMigrationExecutor.java:58) ~[flyway-core-8.5.13.jar:na]
    at org.flywaydb.core.internal.database.DefaultExecutionStrategy.execute(DefaultExecutionStrategy.java:27) ~[flyway-core-8.5.13.jar:na]
    at org.flywaydb.core.internal.resolver.sql.SqlMigrationExecutor.execute(SqlMigrationExecutor.java:57) ~[flyway-core-8.5.13.jar:na]
    at org.flywaydb.core.internal.command.DbMigrate.doMigrateGroup(DbMigrate.java:377) ~[flyway-core-8.5.13.jar:na]
    ... 35 common frames omitted
Caused by: java.sql.SQLSyntaxErrorException: Access denied; you need (at least one of) the SUPER or SYSTEM_VARIABLES_ADMIN privilege(s) for this operation
    at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:120) ~[mysql-connector-java-8.0.29.jar:8.0.29]
    at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122) ~[mysql-connector-java-8.0.29.jar:8.0.29]
    at com.mysql.cj.jdbc.StatementImpl.executeInternal(StatementImpl.java:763) ~[mysql-connector-java-8.0.29.jar:8.0.29]
    at com.mysql.cj.jdbc.StatementImpl.execute(StatementImpl.java:648) ~[mysql-connector-java-8.0.29.jar:8.0.29]
    at org.flywaydb.core.internal.jdbc.JdbcTemplate.executeStatement(JdbcTemplate.java:201) ~[flyway-core-8.5.13.jar:na]
    at org.flywaydb.core.internal.sqlscript.ParsedSqlStatement.execute(ParsedSqlStatement.java:95) ~[flyway-core-8.5.13.jar:na]
    at org.flywaydb.core.internal.sqlscript.DefaultSqlScriptExecutor.executeStatement(DefaultSqlScriptExecutor.java:210) ~[flyway-core-8.5.13.jar:na]
    ... 41 common frames omitted

Process finished with exit code 1

해당 쿼리를 작성하신 분 확인 부탁드릴게요!

ndy2 commented 2 years ago

혹시 위 아래로 있는

SET GLOBAL FOREIGN_KEY_CHECKS=0;

SET GLOBAL FOREIGN_KEY_CHECKS=1;

이 두 문장을 지워보시 겠어요?

seunghan0421 commented 2 years ago

내일 만나서 처리해볼게요.