ExposedSQLException: java.sql.BatchUpdateException: Batch entry 0 INSERT INTO users (avatar_url, discriminator, id, "n...

[sentry-io]

Sentry Issue: SITE-8

PSQLException: ERROR: duplicate key value violates unique constraint "pk_user_id"
  Detail: Key (id)=([REDACTED]) already exists.
    at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2433)
    at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2178)
    at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:479)
    at org.postgresql.jdbc.PgStatement.executeBatch(PgStatement.java:835)
    at org.postgresql.jdbc.PgPreparedStatement.executeBatch(PgPreparedStatement.java:1556)
...
(26 additional frame(s) were not displayed)

BatchUpdateException: Batch entry 0 INSERT INTO users (avatar_url, discriminator, id, "name", present) VALUES ('https://cdn.discordapp.com/avatars/[REDACTED].png', '[REDACTED]', [REDACTED], '[REDACTED]', 'TRUE')
RETURNING * was aborted: ERROR: duplicate key value violates unique constraint "pk_user_id"
  Detail: Key (id)=([REDACTED]) already exists.  Call getNextException to see other errors in the batch.
    at org.postgresql.jdbc.BatchResultHandler.handleError(BatchResultHandler.java:148)
    at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2179)
    at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:479)
    at org.postgresql.jdbc.PgStatement.executeBatch(PgStatement.java:835)
    at org.postgresql.jdbc.PgPreparedStatement.executeBatch(PgPreparedStatement.java:1556)
...
(26 additional frame(s) were not displayed)

ExposedSQLException: java.sql.BatchUpdateException: Batch entry 0 INSERT INTO users (avatar_url, discriminator, id, "name", present) VALUES ('https://cdn.discordapp.com/avatars/[REDACTED].png', '[REDACTED]', [REDACTED], '[REDACTED]', 'TRUE')
RETURNING * was aborted: ERROR: duplicate key value violates unique constraint "pk_user_id"
  Detail: Key (id)=([REDACTED]) already exists.  Call getNextException to see other errors in the batch.
    at com.kotlindiscord.database.User.setRoles(DataModels.kt)
    at com.kotlindiscord.site.routes.api.UsersKt$apiUsersPost$1$1$1.invoke(Users.kt:77)
    at com.kotlindiscord.site.routes.api.UsersKt$apiUsersPost$1$1$1.invoke(Users.kt)
    at com.kotlindiscord.site.routes.api.UsersKt$apiUsersPost$1$1.invokeSuspend(Users.kt:72)
    at com.kotlindiscord.site.routes.api.UsersKt$apiUsersPost$1$1.invoke(Users.kt)
...
(17 additional frame(s) were not displayed)

java.sql.BatchUpdateException: Batch entry 0 INSERT INTO users (avatar_url, discriminator, id, "name", present) VALUES ('https://cdn.discordapp.com/avatars/[REDACTED].png', '[REDACTED]', [REDACTED], '[REDACTED]', 'TRUE')
RETURNING * was aborted: ERROR: duplicate key value violates unique constraint "pk_user_id"
  Detail: Key (id)=([REDACTED]) already exists.  Call getNextException to see other errors in the batch.