fix SQL duplicate key value violates unique constraint Exception causing org.hibernate.exception.ConstraintViolationException #275
Description
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