Question
Orange Business Services
IN
Posted: May 27, 2023
Last activity: Aug 5, 2023
Last activity: 5 Aug 2023 8:54 EDT
Server issue
cannot validate (ORACLE.PR_DATA_STREAM_NODES_PK) - primary key violated
cannot validate (ORACLE.PR_DATA_STREAM_NODES_PK) - primary key violated
@purellaS16594611 Does this occur during a specific scenario, or is this just visible in the logs? The 'primary key violation' is usually raised when you're doing an insert (or update) operation where the key value already exists. The database table referenced contains metadata about the Kafka cluster.
In any case, this requires some more information in order to provide a helpful answer. To factor our the most frequent issues, I would take a look at the reference documentation.
@BasRulesMatter! hi, We are on 8.7.5 and we experienced the same problem after which the stream pods restarted.
Would you happen to know what might have caused this? I can safely say that we were not doing anything heavy/custom on the environment.
Error : 2023-08-02 10:47:10.664 UTC [164920]: [1-1] db=pega_prod,user=pega_admin ERROR: duplicate key value violates unique constraint "pr_data_stream_nodes_pk"
@PiyushT I suppose it's worth checking with the Pega query runner where the duplicate key value would be, with a query like this:
SELECT key, COUNT (key)
FROM database table
GROUP BY key
HAVING COUNT(key)>1;
I did however find this post: https://support.pega.com/discussion/frequent-duplicate-key-value-violates-unique-constraint-error-database that is basically saying, this is expected behaviour due to the functioning of an internal API. But with regards to that, maybe it's good to contact a Pega SME to determine if this has further implication when it is raised for this particular table.
Support Doc
Question
Support Doc
Question
Question
Question
Question
Question Solved
Question
Question Solved
Pega Collaboration Center has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.