FusionAuth
    • Home
    • Categories
    • Recent
    • Popular
    • Pricing
    • Contact us
    • Docs
    • Login
    1. Home
    2. becharam
    B
    • Profile
    • Following 0
    • Followers 0
    • Topics 1
    • Posts 1
    • Best 0
    • Controversial 0
    • Groups 0

    becharam

    @becharam

    0
    Reputation
    1
    Profile views
    1
    Posts
    0
    Followers
    0
    Following
    Joined Last Online

    becharam Unfollow Follow

    Latest posts made by becharam

    • 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:37

      Error 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

      posted in Q&A
      B
      becharam