· 6 years ago · Mar 13, 2019, 07:56 AM
12019-03-08 15:42:43.026 INFO 26884 --- [ main] o.h.e.t.j.p.i.JtaPlatformInitiator : HHH000490: Using JtaPlatform implementation: [org.hibernate.engine.transaction.jta.platform.internal.NoJtaPlatform]
2Hibernate: CREATE TABLE IF NOT EXISTS `User` (
3 `id` INT NOT NULL AUTO_INCREMENT,
4 `username` VARCHAR(255) NOT NULL,
5 `password` VARCHAR(255) NOT NULL,
6 `totp_secret` BINARY(128) DEFAULT NULL,
7 `email` VARCHAR(255) DEFAULT NULL,
8 `verified` BOOLEAN DEFAULT FALSE NOT NULL,
9 `locked` BOOLEAN DEFAULT FALSE NOT NULL,
10 `creation_time` DATETIME NOT NULL,
11 PRIMARY KEY (`id`)
12)
13Hibernate:
14
15CREATE INDEX user_username
16 ON `User` (`username`)
172019-03-08 15:42:43.170 WARN 26884 --- [ main] o.h.engine.jdbc.spi.SqlExceptionHelper : SQL Error: 1061, SQLState: 42000
182019-03-08 15:42:43.170 ERROR 26884 --- [ main] o.h.engine.jdbc.spi.SqlExceptionHelper : Duplicate key name 'user_username'
192019-03-08 15:42:43.172 WARN 26884 --- [ main] ConfigServletWebServerApplicationContext : Exception encountered during context initialization - cancelling refresh attempt: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'auth1' defined in URL [jar:file:/home/huangy/Dropbox/School/EECS%20395/auth1/target/auth1-0.1-SNAPSHOT.jar!/BOOT-INF/classes!/org/auth1/auth1/core/Auth1.class]: Bean instantiation via constructor failed; nested exception is org.springframework.beans.BeanInstantiationException: Failed to instantiate [org.auth1.auth1.core.Auth1]: Constructor threw exception; nested exception is org.hibernate.exception.SQLGrammarException: could not execute statement
202019-03-08 15:42:43.176 INFO 26884 --- [ main] o.apache.catalina.core.StandardService : Stopping service [Tomcat]
212019-03-08 15:42:43.198 INFO 26884 --- [ main] ConditionEvaluationReportLoggingListener :
22
23Error starting ApplicationContext. To display the conditions report re-run your application with 'debug' enabled.
242019-03-08 15:42:43.209 ERROR 26884 --- [ main] o.s.boot.SpringApplication : Application run failed
25
26org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'auth1' defined in URL [jar:file:/home/huangy/Dropbox/School/EECS%20395/auth1/target/auth1-0.1-SNAPSHOT.jar!/BOOT-INF/classes!/org/auth1/auth1/core/Auth1.class]: Bean instantiation via constructor failed; nested exception is org.springframework.beans.BeanInstantiationException: Failed to instantiate [org.auth1.auth1.core.Auth1]: Constructor threw exception; nested exception is org.hibernate.exception.SQLGrammarException: could not execute statement
27 at org.springframework.beans.factory.support.ConstructorResolver.instantiate(ConstructorResolver.java:304) ~[spring-beans-5.1.4.RELEASE.jar!/:5.1.4.RELEASE]
28 at org.springframework.beans.factory.support.ConstructorResolver.autowireConstructor(ConstructorResolver.java:285) ~[spring-beans-5.1.4.RELEASE.jar!/:5.1.4.RELEASE]
29 at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.autowireConstructor(AbstractAutowireCapableBeanFactory.java:1308) ~[spring-beans-5.1.4.RELEASE.jar!/:5.1.4.RELEASE]
30 at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:1154) ~[spring-beans-5.1.4.RELEASE.jar!/:5.1.4.RELEASE]
31 at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:538) ~[spring-beans-5.1.4.RELEASE.jar!/:5.1.4.RELEASE]
32 at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:498) ~[spring-beans-5.1.4.RELEASE.jar!/:5.1.4.RELEASE]
33 at org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:320) ~[spring-beans-5.1.4.RELEASE.jar!/:5.1.4.RELEASE]
34 at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:222) ~[spring-beans-5.1.4.RELEASE.jar!/:5.1.4.RELEASE]
35 at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:318) ~[spring-beans-5.1.4.RELEASE.jar!/:5.1.4.RELEASE]
36 at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:199) ~[spring-beans-5.1.4.RELEASE.jar!/:5.1.4.RELEASE]
37 at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:846) ~[spring-beans-5.1.4.RELEASE.jar!/:5.1.4.RELEASE]
38 at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:863) ~[spring-context-5.1.4.RELEASE.jar!/:5.1.4.RELEASE]
39 at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:546) ~[spring-context-5.1.4.RELEASE.jar!/:5.1.4.RELEASE]
40 at org.springframework.boot.web.servlet.context.ServletWebServerApplicationContext.refresh(ServletWebServerApplicationContext.java:142) ~[spring-boot-2.1.2.RELEASE.jar!/:2.1.2.RELEASE]
41 at org.springframework.boot.SpringApplication.refresh(SpringApplication.java:775) ~[spring-boot-2.1.2.RELEASE.jar!/:2.1.2.RELEASE]
42 at org.springframework.boot.SpringApplication.refreshContext(SpringApplication.java:397) ~[spring-boot-2.1.2.RELEASE.jar!/:2.1.2.RELEASE]
43 at org.springframework.boot.SpringApplication.run(SpringApplication.java:316) ~[spring-boot-2.1.2.RELEASE.jar!/:2.1.2.RELEASE]
44 at org.springframework.boot.SpringApplication.run(SpringApplication.java:1260) ~[spring-boot-2.1.2.RELEASE.jar!/:2.1.2.RELEASE]
45 at org.springframework.boot.SpringApplication.run(SpringApplication.java:1248) ~[spring-boot-2.1.2.RELEASE.jar!/:2.1.2.RELEASE]
46 at org.auth1.auth1.Application.main(Application.java:17) ~[classes!/:0.1-SNAPSHOT]
47 at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[na:na]
48 at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[na:na]
49 at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[na:na]
50 at java.base/java.lang.reflect.Method.invoke(Method.java:566) ~[na:na]
51 at org.springframework.boot.loader.MainMethodRunner.run(MainMethodRunner.java:48) ~[auth1-0.1-SNAPSHOT.jar:0.1-SNAPSHOT]
52 at org.springframework.boot.loader.Launcher.launch(Launcher.java:87) ~[auth1-0.1-SNAPSHOT.jar:0.1-SNAPSHOT]
53 at org.springframework.boot.loader.Launcher.launch(Launcher.java:50) ~[auth1-0.1-SNAPSHOT.jar:0.1-SNAPSHOT]
54 at org.springframework.boot.loader.JarLauncher.main(JarLauncher.java:51) ~[auth1-0.1-SNAPSHOT.jar:0.1-SNAPSHOT]
55Caused by: org.springframework.beans.BeanInstantiationException: Failed to instantiate [org.auth1.auth1.core.Auth1]: Constructor threw exception; nested exception is org.hibernate.exception.SQLGrammarException: could not execute statement
56 at org.springframework.beans.BeanUtils.instantiateClass(BeanUtils.java:184) ~[spring-beans-5.1.4.RELEASE.jar!/:5.1.4.RELEASE]
57 at org.springframework.beans.factory.support.SimpleInstantiationStrategy.instantiate(SimpleInstantiationStrategy.java:117) ~[spring-beans-5.1.4.RELEASE.jar!/:5.1.4.RELEASE]
58 at org.springframework.beans.factory.support.ConstructorResolver.instantiate(ConstructorResolver.java:300) ~[spring-beans-5.1.4.RELEASE.jar!/:5.1.4.RELEASE]
59 ... 27 common frames omitted
60Caused by: org.hibernate.exception.SQLGrammarException: could not execute statement
61 at org.hibernate.exception.internal.SQLExceptionTypeDelegate.convert(SQLExceptionTypeDelegate.java:63) ~[hibernate-core-5.4.1.Final.jar!/:5.4.1.Final]
62 at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:42) ~[hibernate-core-5.4.1.Final.jar!/:5.4.1.Final]
63 at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:113) ~[hibernate-core-5.4.1.Final.jar!/:5.4.1.Final]
64 at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:99) ~[hibernate-core-5.4.1.Final.jar!/:5.4.1.Final]
65 at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.executeUpdate(ResultSetReturnImpl.java:178) ~[hibernate-core-5.4.1.Final.jar!/:5.4.1.Final]
66 at org.hibernate.engine.query.spi.NativeSQLQueryPlan.performExecuteUpdate(NativeSQLQueryPlan.java:107) ~[hibernate-core-5.4.1.Final.jar!/:5.4.1.Final]
67 at org.hibernate.internal.SessionImpl.executeNativeUpdate(SessionImpl.java:1633) ~[hibernate-core-5.4.1.Final.jar!/:5.4.1.Final]
68 at org.hibernate.query.internal.NativeQueryImpl.doExecuteUpdate(NativeQueryImpl.java:295) ~[hibernate-core-5.4.1.Final.jar!/:5.4.1.Final]
69 at org.hibernate.query.internal.AbstractProducedQuery.executeUpdate(AbstractProducedQuery.java:1618) ~[hibernate-core-5.4.1.Final.jar!/:5.4.1.Final]
70 at java.base/java.util.stream.ForEachOps$ForEachOp$OfRef.accept(ForEachOps.java:183) ~[na:na]
71 at java.base/java.util.stream.ReferencePipeline$3$1.accept(ReferencePipeline.java:195) ~[na:na]
72 at java.base/java.util.Spliterators$ArraySpliterator.forEachRemaining(Spliterators.java:948) ~[na:na]
73 at java.base/java.util.stream.AbstractPipeline.copyInto(AbstractPipeline.java:484) ~[na:na]
74 at java.base/java.util.stream.AbstractPipeline.wrapAndCopyInto(AbstractPipeline.java:474) ~[na:na]
75 at java.base/java.util.stream.ForEachOps$ForEachOp.evaluateSequential(ForEachOps.java:150) ~[na:na]
76 at java.base/java.util.stream.ForEachOps$ForEachOp$OfRef.evaluateSequential(ForEachOps.java:173) ~[na:na]
77 at java.base/java.util.stream.AbstractPipeline.evaluate(AbstractPipeline.java:234) ~[na:na]
78 at java.base/java.util.stream.ReferencePipeline.forEach(ReferencePipeline.java:497) ~[na:na]
79 at org.auth1.auth1.model.DatabaseManager.initializeDatabase(DatabaseManager.java:47) ~[classes!/:0.1-SNAPSHOT]
80 at org.auth1.auth1.core.Auth1.<init>(Auth1.java:18) ~[classes!/:0.1-SNAPSHOT]
81 at java.base/jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) ~[na:na]
82 at java.base/jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62) ~[na:na]
83 at java.base/jdk.internal.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) ~[na:na]
84 at java.base/java.lang.reflect.Constructor.newInstance(Constructor.java:490) ~[na:na]
85 at org.springframework.beans.BeanUtils.instantiateClass(BeanUtils.java:172) ~[spring-beans-5.1.4.RELEASE.jar!/:5.1.4.RELEASE]
86 ... 29 common frames omitted
87Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Duplicate key name 'user_username'
88 at java.base/jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) ~[na:na]
89 at java.base/jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62) ~[na:na]
90 at java.base/jdk.internal.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) ~[na:na]
91 at java.base/java.lang.reflect.Constructor.newInstance(Constructor.java:490) ~[na:na]
92 at com.mysql.jdbc.Util.handleNewInstance(Util.java:425) ~[mysql-connector-java-5.1.47.jar!/:5.1.47]
93 at com.mysql.jdbc.Util.getInstance(Util.java:408) ~[mysql-connector-java-5.1.47.jar!/:5.1.47]
94 at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:944) ~[mysql-connector-java-5.1.47.jar!/:5.1.47]
95 at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3978) ~[mysql-connector-java-5.1.47.jar!/:5.1.47]
96 at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3914) ~[mysql-connector-java-5.1.47.jar!/:5.1.47]
97 at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2530) ~[mysql-connector-java-5.1.47.jar!/:5.1.47]
98 at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2683) ~[mysql-connector-java-5.1.47.jar!/:5.1.47]
99 at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2495) ~[mysql-connector-java-5.1.47.jar!/:5.1.47]
100 at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1903) ~[mysql-connector-java-5.1.47.jar!/:5.1.47]
101 at com.mysql.jdbc.PreparedStatement.executeUpdateInternal(PreparedStatement.java:2124) ~[mysql-connector-java-5.1.47.jar!/:5.1.47]
102 at com.mysql.jdbc.PreparedStatement.executeUpdateInternal(PreparedStatement.java:2058) ~[mysql-connector-java-5.1.47.jar!/:5.1.47]
103 at com.mysql.jdbc.PreparedStatement.executeLargeUpdate(PreparedStatement.java:5158) ~[mysql-connector-java-5.1.47.jar!/:5.1.47]
104 at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2043) ~[mysql-connector-java-5.1.47.jar!/:5.1.47]
105 at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.executeUpdate(ResultSetReturnImpl.java:175) ~[hibernate-core-5.4.1.Final.jar!/:5.4.1.Final]
106 ... 49 common frames omitted