search

Spring-Framework-Java-Apps / twitterwall2

Twitterwall with spring:boot for heroku
https://thomaswoehlke.github.io/twitterwall2/
Apache License 2.0
0 stars 0 forks source link

fix SQL duplicate key value violates unique constraint Exception causing org.hibernate.exception.ConstraintViolationException #275

Closed phasenraum2010 closed 7 years ago

phasenraum2010 commented 7 years ago

Detail: Key (screen_name_unique)=(java) already exists. 2017-09-30 08:51:46.023 INFO 35345 --- [ main] o.w.t.b.s.p.i.StoreEntitiesProcessImpl : storeEntitiesProcess CREATE_TESTDATA_TWEETS_1506754245786 : could not execute statement; SQL [n/a]; constraint [unique_mention_screen_name_unique]; nested exception is org.hibernate.exception.ConstraintViolationException: could not execute statement 2017-09-30 08:51:56.837 ERROR 35345 --- [ main] o.h.engine.jdbc.spi.SqlExceptionHelper : ERROR: duplicate key value violates unique constraint "unique_mention_screen_name_unique" Detail: Key (screen_name_unique)=(java) already exists. 2017-09-30 08:51:56.838 INFO 35345 --- [ main] o.w.t.b.s.p.i.StoreEntitiesProcessImpl : storeEntitiesProcess CREATE_TESTDATA_TWEETS_1506754245786 : could not execute statement; SQL [n/a]; constraint [unique_mention_screen_name_unique]; nested exception is org.hibernate.exception.ConstraintViolationException: could not execute statement ERROR: 404 :: User not found. 2017-09-30 08:52:48.048 WARN 35345 --- [lTaskExecutor-1] o.w.t.b.s.r.impl.TwitterApiServiceImpl : Remote API Call getUserProfileForScreenName: ddhgcvdghvsdhg User not found : ddhgcvdghvsdhg ERROR: 404 :: User not found. 2017-09-30 08:52:55.875 WARN 35345 --- [lTaskExecutor-1] o.w.t.b.s.r.impl.TwitterApiServiceImpl : Remote API Call getUserProfileForScreenName: ddhgcvdghvsdhg User not found : ddhgcvdghvsdhg 2017-09-30 08:52:58.754 ERROR 35345 --- [lTaskExecutor-1] o.h.engine.jdbc.spi.SqlExceptionHelper : ERROR: duplicate key value violates unique constraint "unique_mention_screen_name_unique" Detail: Key (screen_name_unique)=(generalhospital) already exists. 2017-09-30 08:52:58.755 INFO 35345 --- [lTaskExecutor-1] o.w.t.b.s.p.i.StoreEntitiesProcessImpl : storeEntitiesProcess UPDATE_MENTIONS_FOR_USERS_1506754356664 : could not execute statement; SQL [n/a]; constraint [unique_mention_screen_name_unique]; nested exception is org.hibernate.exception.ConstraintViolationException: could not execute statement 2017-09-30 08:53:01.271 ERROR 35345 --- [lTaskExecutor-1] o.h.engine.jdbc.spi.SqlExceptionHelper : ERROR: duplicate key value violates unique constraint "unique_mention_screen_name_unique" Detail: Key (screen_name_unique)=(generalhospital) already exists. 2017-09-30 08:53:01.271 INFO 35345 --- [lTaskExecutor-1] o.w.t.b.s.p.i.StoreEntitiesProcessImpl : storeEntitiesProcess UPDATE_MENTIONS_FOR_USERS_1506754375536 : could not execute statement; SQL [n/a]; constraint [unique_mention_screen_name_unique]; nested exception is org.hibernate.exception.ConstraintViolationException: could not execute statement

phasenraum2010 commented 7 years ago

Wontfix because app works