Search

๋ฐฑ์—”๋“œ ์„œ๋ฒ„ ์‹คํ–‰๋กœ๊ทธ

. ____ _ __ _ _ /\\ / ___'_ __ _ _(_)_ __ __ _ \ \ \ \ ( ( )\___ | '_ | '_| | '_ \/ _` | \ \ \ \ \\/ ___)| |_)| | | | | || (_| | ) ) ) ) ' |____| .__|_| |_|_| |_\__, | / / / / =========|_|==============|___/=/_/_/_/ :: Spring Boot :: (v3.2.0) 2025-09-05T15:29:12.786+09:00 INFO 22305 --- [krules-backend] [ main] com.krules.KrulesApplication : Starting KrulesApplication v0.0.1-SNAPSHOT using Java 17.0.16 with PID 22305 (/root/k-rules/back/deploy/APP.war started by root in /root/k-rules/back/deploy) 2025-09-05T15:29:12.791+09:00 DEBUG 22305 --- [krules-backend] [ main] com.krules.KrulesApplication : Running with Spring Boot v3.2.0, Spring v6.1.1 2025-09-05T15:29:12.792+09:00 INFO 22305 --- [krules-backend] [ main] com.krules.KrulesApplication : No active profile set, falling back to 1 default profile: "default" 2025-09-05T15:29:14.056+09:00 INFO 22305 --- [krules-backend] [ main] .s.d.r.c.RepositoryConfigurationDelegate : Bootstrapping Spring Data JPA repositories in DEFAULT mode. 2025-09-05T15:29:14.127+09:00 INFO 22305 --- [krules-backend] [ main] .s.d.r.c.RepositoryConfigurationDelegate : Finished Spring Data repository scanning in 63 ms. Found 4 JPA repository interfaces. 2025-09-05T15:29:14.747+09:00 INFO 22305 --- [krules-backend] [ main] o.s.b.w.embedded.tomcat.TomcatWebServer : Tomcat initialized with port 8080 (http) 2025-09-05T15:29:14.757+09:00 INFO 22305 --- [krules-backend] [ main] o.apache.catalina.core.StandardService : Starting service [Tomcat] 2025-09-05T15:29:14.757+09:00 INFO 22305 --- [krules-backend] [ main] o.apache.catalina.core.StandardEngine : Starting Servlet engine: [Apache Tomcat/10.1.16] 2025-09-05T15:29:14.828+09:00 INFO 22305 --- [krules-backend] [ main] o.a.c.c.C.[Tomcat].[localhost].[/api] : Initializing Spring embedded WebApplicationContext 2025-09-05T15:29:14.829+09:00 INFO 22305 --- [krules-backend] [ main] w.s.c.ServletWebServerApplicationContext : Root WebApplicationContext: initialization completed in 1939 ms 2025-09-05T15:29:14.962+09:00 INFO 22305 --- [krules-backend] [ main] o.hibernate.jpa.internal.util.LogHelper : HHH000204: Processing PersistenceUnitInfo [name: default] 2025-09-05T15:29:15.019+09:00 INFO 22305 --- [krules-backend] [ main] org.hibernate.Version : HHH000412: Hibernate ORM core version 6.3.1.Final 2025-09-05T15:29:16.341+09:00 INFO 22305 --- [krules-backend] [ main] o.h.c.internal.RegionFactoryInitiator : HHH000026: Second-level cache disabled 2025-09-05T15:29:16.598+09:00 INFO 22305 --- [krules-backend] [ main] o.s.o.j.p.SpringPersistenceUnitInfo : No LoadTimeWeaver setup: ignoring JPA class transformer 2025-09-05T15:29:16.624+09:00 WARN 22305 --- [krules-backend] [ main] com.zaxxer.hikari.HikariConfig : HikariPool-1 - idleTimeout has been set but has no effect because the pool is operating as a fixed size pool. 2025-09-05T15:29:16.624+09:00 INFO 22305 --- [krules-backend] [ main] com.zaxxer.hikari.HikariDataSource : HikariPool-1 - Starting... 2025-09-05T15:29:16.776+09:00 INFO 22305 --- [krules-backend] [ main] com.zaxxer.hikari.pool.HikariPool : HikariPool-1 - Added connection com.mysql.cj.jdbc.ConnectionImpl@3ff8a3ad 2025-09-05T15:29:16.778+09:00 INFO 22305 --- [krules-backend] [ main] com.zaxxer.hikari.HikariDataSource : HikariPool-1 - Start completed. 2025-09-05T15:29:17.803+09:00 INFO 22305 --- [krules-backend] [ main] o.h.e.t.j.p.i.JtaPlatformInitiator : HHH000489: No JTA platform available (set 'hibernate.transaction.jta.platform' to enable JTA platform integration) 2025-09-05T15:29:17.846+09:00 DEBUG 22305 --- [krules-backend] [ main] org.hibernate.SQL : create table user_votes ( id bigint not null auto_increment, voted_at datetime(6), user_id bigint not null, vote_id bigint not null, vote_option_id bigint not null, primary key (id) ) engine=InnoDB Hibernate: create table user_votes ( id bigint not null auto_increment, voted_at datetime(6), user_id bigint not null, vote_id bigint not null, vote_option_id bigint not null, primary key (id) ) engine=InnoDB 2025-09-05T15:29:17.861+09:00 DEBUG 22305 --- [krules-backend] [ main] org.hibernate.SQL : create table users ( id bigint not null auto_increment, created_at datetime(6), email varchar(255) not null, password varchar(255) not null, role enum ('USER','ADMIN') not null, updated_at datetime(6), username varchar(255) not null, primary key (id) ) engine=InnoDB Hibernate: create table users ( id bigint not null auto_increment, created_at datetime(6), email varchar(255) not null, password varchar(255) not null, role enum ('USER','ADMIN') not null, updated_at datetime(6), username varchar(255) not null, primary key (id) ) engine=InnoDB 2025-09-05T15:29:17.872+09:00 DEBUG 22305 --- [krules-backend] [ main] org.hibernate.SQL : create table vote_options ( id bigint not null auto_increment, created_at datetime(6), option_text varchar(255) not null, vote_count integer, vote_id bigint not null, primary key (id) ) engine=InnoDB Hibernate: create table vote_options ( id bigint not null auto_increment, created_at datetime(6), option_text varchar(255) not null, vote_count integer, vote_id bigint not null, primary key (id) ) engine=InnoDB 2025-09-05T15:29:17.882+09:00 DEBUG 22305 --- [krules-backend] [ main] org.hibernate.SQL : create table votes ( id bigint not null auto_increment, created_at datetime(6), description TEXT, end_date datetime(6), is_active bit, start_date datetime(6), title varchar(255) not null, updated_at datetime(6), created_by bigint not null, primary key (id) ) engine=InnoDB Hibernate: create table votes ( id bigint not null auto_increment, created_at datetime(6), description TEXT, end_date datetime(6), is_active bit, start_date datetime(6), title varchar(255) not null, updated_at datetime(6), created_by bigint not null, primary key (id) ) engine=InnoDB 2025-09-05T15:29:17.893+09:00 DEBUG 22305 --- [krules-backend] [ main] org.hibernate.SQL : alter table user_votes drop index UK5e0ef02sonr8e01mx6jbc5q7f Hibernate: alter table user_votes drop index UK5e0ef02sonr8e01mx6jbc5q7f 2025-09-05T15:29:17.910+09:00 DEBUG 22305 --- [krules-backend] [ main] org.hibernate.SQL : alter table user_votes add constraint UK5e0ef02sonr8e01mx6jbc5q7f unique (user_id, vote_id) Hibernate: alter table user_votes add constraint UK5e0ef02sonr8e01mx6jbc5q7f unique (user_id, vote_id) 2025-09-05T15:29:17.921+09:00 DEBUG 22305 --- [krules-backend] [ main] org.hibernate.SQL : alter table users drop index UK_6dotkott2kjsp8vw4d0m25fb7 Hibernate: alter table users drop index UK_6dotkott2kjsp8vw4d0m25fb7 2025-09-05T15:29:17.922+09:00 DEBUG 22305 --- [krules-backend] [ main] org.hibernate.SQL : alter table users add constraint UK_6dotkott2kjsp8vw4d0m25fb7 unique (email) Hibernate: alter table users add constraint UK_6dotkott2kjsp8vw4d0m25fb7 unique (email) 2025-09-05T15:29:17.932+09:00 DEBUG 22305 --- [krules-backend] [ main] org.hibernate.SQL : alter table users drop index UK_r43af9ap4edm43mmtq01oddj6 Hibernate: alter table users drop index UK_r43af9ap4edm43mmtq01oddj6 2025-09-05T15:29:17.933+09:00 DEBUG 22305 --- [krules-backend] [ main] org.hibernate.SQL : alter table users add constraint UK_r43af9ap4edm43mmtq01oddj6 unique (username) Hibernate: alter table users add constraint UK_r43af9ap4edm43mmtq01oddj6 unique (username) 2025-09-05T15:29:17.943+09:00 DEBUG 22305 --- [krules-backend] [ main] org.hibernate.SQL : alter table user_votes add constraint FK7sg00sr5h4395xrgufxvsmagv foreign key (user_id) references users (id) Hibernate: alter table user_votes add constraint FK7sg00sr5h4395xrgufxvsmagv foreign key (user_id) references users (id) 2025-09-05T15:29:17.969+09:00 DEBUG 22305 --- [krules-backend] [ main] org.hibernate.SQL : alter table user_votes add constraint FK9d370dd96dsbj6qwlpx3b0837 foreign key (vote_id) references votes (id) Hibernate: alter table user_votes add constraint FK9d370dd96dsbj6qwlpx3b0837 foreign key (vote_id) references votes (id) 2025-09-05T15:29:17.997+09:00 DEBUG 22305 --- [krules-backend] [ main] org.hibernate.SQL : alter table user_votes add constraint FK6jejn6mad7bdox1orjl7tluf2 foreign key (vote_option_id) references vote_options (id) Hibernate: alter table user_votes add constraint FK6jejn6mad7bdox1orjl7tluf2 foreign key (vote_option_id) references vote_options (id) 2025-09-05T15:29:18.033+09:00 DEBUG 22305 --- [krules-backend] [ main] org.hibernate.SQL : alter table vote_options add constraint FKl2akx1lll3m5b004q80729oui foreign key (vote_id) references votes (id) Hibernate: alter table vote_options add constraint FKl2akx1lll3m5b004q80729oui foreign key (vote_id) references votes (id) 2025-09-05T15:29:18.065+09:00 DEBUG 22305 --- [krules-backend] [ main] org.hibernate.SQL : alter table votes add constraint FKdvr1g3bogkvm0llp7w0a8fa29 foreign key (created_by) references users (id) Hibernate: alter table votes add constraint FKdvr1g3bogkvm0llp7w0a8fa29 foreign key (created_by) references users (id) 2025-09-05T15:29:18.094+09:00 INFO 22305 --- [krules-backend] [ main] j.LocalContainerEntityManagerFactoryBean : Initialized JPA EntityManagerFactory for persistence unit 'default' 2025-09-05T15:29:18.471+09:00 DEBUG 22305 --- [krules-backend] [ main] c.krules.config.JwtAuthenticationFilter : Filter 'jwtAuthenticationFilter' configured for use 2025-09-05T15:29:18.624+09:00 INFO 22305 --- [krules-backend] [ main] o.s.d.j.r.query.QueryEnhancerFactory : Hibernate is in classpath; If applicable, HQL parser will be used. 2025-09-05T15:29:19.184+09:00 WARN 22305 --- [krules-backend] [ main] JpaBaseConfiguration$JpaWebConfiguration : spring.jpa.open-in-view is enabled by default. Therefore, database queries may be performed during view rendering. Explicitly configure spring.jpa.open-in-view to disable this warning 2025-09-05T15:29:19.539+09:00 INFO 22305 --- [krules-backend] [ main] o.s.s.web.DefaultSecurityFilterChain : Will secure any request with [org.springframework.security.web.session.DisableEncodeUrlFilter@2265a052, org.springframework.security.web.context.request.async.WebAsyncManagerIntegrationFilter@341c8f67, org.springframework.security.web.context.SecurityContextHolderFilter@373e09c7, org.springframework.security.web.header.HeaderWriterFilter@5a36a405, org.springframework.web.filter.CorsFilter@72090715, org.springframework.security.web.authentication.logout.LogoutFilter@6d17cd8b, com.krules.config.JwtAuthenticationFilter@63541cd4, org.springframework.security.web.savedrequest.RequestCacheAwareFilter@2a7b4b19, org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter@26415b5e, org.springframework.security.web.authentication.AnonymousAuthenticationFilter@25bc36, org.springframework.security.web.session.SessionManagementFilter@60bd11f7, org.springframework.security.web.access.ExceptionTranslationFilter@3520d2db, org.springframework.security.web.access.intercept.AuthorizationFilter@430abcad] 2025-09-05T15:29:19.971+09:00 INFO 22305 --- [krules-backend] [ main] o.s.b.w.embedded.tomcat.TomcatWebServer : Tomcat started on port 8080 (http) with context path '/api' 2025-09-05T15:29:20.006+09:00 INFO 22305 --- [krules-backend] [ main] com.krules.KrulesApplication : Started KrulesApplication in 7.852 seconds (process running for 8.546)
SQL
๋ณต์‚ฌ