Primärschlüsselfehler im AlertController
Im Logfile ist mehrfach ein Primärschlüsselfehler zu sehen:
app_1 | 14:50:00.681 [http-nio-8080-exec-16] WARN o.h.e.jdbc.spi.SqlExceptionHelper - SQL Error: 23505, SQLState: 23505
app_1 | 14:50:00.682 [http-nio-8080-exec-16] ERROR o.h.e.jdbc.spi.SqlExceptionHelper - Unique index or primary key violation: "PRIMARY KEY ON PUBLIC.ALERT(ID) ( /* key:83 */ CAST(83 AS BIGINT), TIMESTAMP '2022-06-29 06:22:44.883', 'Siemens', '', '', CAST(7791 AS BIGINT), FALSE)"; SQL statement:
app_1 | insert into alert (last_processed, lastname, place_id, place_name, uid, wants_html, id) values (?, ?, ?, ?, ?, ?, ?) [23505-214]
app_1 | 14:50:00.682 [http-nio-8080-exec-16] ERROR n.g.m.controller.AlertController - could not execute statement; SQL [n/a]; constraint ["PRIMARY KEY ON PUBLIC.ALERT(ID) ( /* key:83 */ CAST(83 AS BIGINT), TIMESTAMP '2022-06-29 06:22:44.883', 'Siemens', '', '', CAST(7791 AS BIGINT), FALSE)"; SQL statement:
app_1 | insert into alert (last_processed, lastname, place_id, place_name, uid, wants_html, id) values (?, ?, ?, ?, ?, ?, ?) [23505-214]]; nested exception is org.hibernate.exception.ConstraintViolationException: could not execute statement