SQL error on request_frequencies Table
-
I had a problem with fusion and the server stopped working. The last log I found was this one:
Caused by: org.postgresql.util.PSQLException: ERROR: duplicate key value violates unique constraint "request_frequencies_uk_1"
Detail: Key (tenants_id, type, request_id)=(74eeee80-d400-4540-a377-de1e4a7239dc, 0, 94159bc9-4b03-4735-ae23-0ab33745e82b) already exists.
11:37Error updating database. Cause: org.postgresql.util.PSQLException: ERROR: duplicate key value violates unique constraint "request_frequencies_uk_1"
Detail: Key (tenants_id, type, request_id)=(74eeee80-d400-4540-a377-de1e4a7239dc, 0, 94159bc9-4b03-4735-ae23-0ab33745e82b) already exists.
The error may exist in io/fusionauth/api/domain/RequestFrequencyMapper.xml
The error may involve defaultParameterMap
The error occurred while setting parameters
SQL: INSERT INTO request_frequencies (count, last_update_instant, request_id, tenants_id, type) VALUES (?, ?, ?, ?, ?)
Cause: org.postgresql.util.PSQLException: ERROR: duplicate key value violates unique constraint "request_frequencies_uk_1"
Detail: Key (tenants_id, type, request_id)=(74eeee80-d400-4540-a377-de1e4a7239dc, 0, 94159bc9-4b03-4735-ae23-0ab33745e82b) already exists.
There is no error pointing to a memory overload, and I am not sure why the server stopped.
Any help on why the server might have stopped would be appreciated
-
@becharam What version of FusionAuth and postgresql/mysql are you running?
-
@becharam said in SQL error on request_frequencies Table:
I had a problem with fusion and the server stopped working. The last log I found was this one:
Caused by: org.postgresql.util.PSQLException: ERROR: duplicate key value violates unique constraint "request_frequencies_uk_1"
Detail: Key (tenants_id, type, request_id)=(74eeee80-d400-4540-a377-de1e4a7239dc, 0, 94159bc9-4b03-4735-ae23-0ab33745e82b) already exists.
11:37Error updating database. Cause: org.postgresql.util.PSQLException: ERROR: duplicate key value violates unique constraint "request_frequencies_uk_1"
Detail: Key (tenants_id, type, request_id)=(74eeee80-d400-4540-a377-de1e4a7239dc, 0, 94159bc9-4b03-4735-ae23-0ab33745e82b) already exists.
The error may exist in io/fusionauth/api/domain/RequestFrequencyMapper.xml
The error may involve defaultParameterMap
The error occurred while setting parameters
SQL: INSERT INTO request_frequencies (count, last_update_instant, request_id, tenants_id, type) VALUES (?, ?, ?, ?, ?)
Cause: org.postgresql.util.PSQLException: ERROR: duplicate key value violates unique constraint "request_frequencies_uk_1"
Detail: Key (tenants_id, type, request_id)=(74eeee80-d400-4540-a377-de1e4a7239dc, 0, 94159bc9-4b03-4735-ae23-0ab33745e82b) already exists.
There is no error pointing to a memory overload, and I am not sure why the server stopped.
Any help on why the server might have stopped would be appreciated
Facing same issue here. Help is appreciated.
-
@langnerfrancesco What version of FusionAuth are you using?
What version of postgresql?
