Question
Pega 7.3 Ignite : java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (DATA_SCHEMA_USER.PRPC_IGNITE_SERVER_ADDR_PK)
Hi,
I'm getting below error when trying to bring up Pega-Ignite cluster on one of the server. There are 3 servers used in the cluster
ddress=server/XX.XX.XX.XX:5701, uuid=ca311f1b-2ddd-486e-a026-5ae397b1a7d0, mode=SERVER]
2017-07-27 16:01:38,994 [ent-worker-#41%PRPC%] [ ] [ ] [ ] (.util.ClusterMembershipManager) INFO - Members [3] {
2017-07-27 16:01:38,994 [ent-worker-#41%PRPC%] [ ] [ ] [ ] (.util.ClusterMembershipManager) INFO - Member: [name=pega_clustermgr_dev-01, address=server/XX.XX.XX.XX:5701, uuid=82700c57-64b4-41ac-8e1a-6fede94c0059, mode=SERVER] <== THIS node
2017-07-27 16:01:38,994 [ent-worker-#41%PRPC%] [ ] [ ] [ ] (.util.ClusterMembershipManager) INFO - Member: [name=pega_clustermgr_dev-01, address=server/XX.XX.XX.XX:5701, uuid=ed18112b-ef5d-4d62-9ccd-74cda4f66753, mode=SERVER]
2017-07-27 16:01:38,994 [ent-worker-#41%PRPC%] [ ] [ ] [ ] (.util.ClusterMembershipManager) INFO - Member: [address=server/XX.XX.XX.XX:5701, uuid=ca311f1b-2ddd-486e-a026-5ae397b1a7d0, mode=SERVER] <== NEW node
2017-07-27 16:01:38,994 [ent-worker-#41%PRPC%] [ ] [ ] [ ] (.util.ClusterMembershipManager) INFO - }
2017-07-27 16:02:06,934 [der-cleaner-#6%PRPC%] [ ] [ ] [ ] (internal.ClusterServiceJdbcDAO) INFO - Updating addresses into the database. Current Timestamp: 06:02:06.934
2017-07-27 16:11:07,005 [der-cleaner-#6%PRPC%] [ ] [ ] [ ] (internal.ClusterServiceJdbcDAO) INFO - Updating addresses into the database. Current Timestamp: 06:11:07.05
2017-07-27 16:13:07,041 [der-cleaner-#6%PRPC%] [ ] [ ] [ ] (internal.ClusterServiceJdbcDAO) INFO - Updating addresses into the database. Current Timestamp: 06:13:07.41
2017-07-27 16:13:07,078 [der-cleaner-#6%PRPC%] [ ] [ ] [ ] (internal.ClusterServiceJdbcDAO) ERROR - Failed to get registered addresses
java.sql.BatchUpdateException: ORA-00001: unique constraint (DATA_SCHEMA_USER.PRPC_IGNITE_SERVER_ADDR_PK) violated
at oracle.jdbc.driver.OraclePreparedStatement.executeBatch(OraclePreparedStatement.java:11190) ~[ojdbc7.jar:XX.XX.XX.XX]
at oracle.jdbc.driver.OracleStatementWrapper.executeBatch(OracleStatementWrapper.java:244) ~[ojdbc7.jar:XX.XX.XX.XX]
at com.pega.pegarules.configdbcp.dbcp.DelegatingStatement.executeBatch(DelegatingStatement.java:297) ~[prdbcp-7.3.0-77.jar:7.3.0-77]
at com.pega.platform.cluster.internal.ClusterServiceJdbcDAO.registerAddresses(ClusterServiceJdbcDAO.java:217) ~[cluster-impl.jar:?]
at com.pega.platform.cluster.internal.JdbcNodesProvider.registerAddresses(JdbcNodesProvider.java:98) ~[cluster-impl.jar:?]
at org.apache.ignite.spi.discovery.tcp.ServerImpl$IpFinderCleaner.cleanIpFinder(ServerImpl.java:1800) ~[ignite-core-1.7.0.jar:?]
at org.apache.ignite.spi.discovery.tcp.ServerImpl$IpFinderCleaner.body(ServerImpl.java:1719) ~[ignite-core-1.7.0.jar:?]
at org.apache.ignite.spi.IgniteSpiThread.run(IgniteSpiThread.java:62) ~[ignite-core-1.7.0.jar:?]
2017-07-27 16:13:07,078 [der-cleaner-#6%PRPC%] [ ] [ ] [ ] (internal.ClusterServiceJdbcDAO) ERROR - Failed to get registered addresses
java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (DATA_SCHEMA_USER.PRPC_IGNITE_SERVER_ADDR_PK) violated
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:450) ~[ojdbc7.jar:XX.XX.XX.XX]
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:399) ~[ojdbc7.jar:XX.XX.XX.XX]
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1017) ~[ojdbc7.jar:XX.XX.XX.XX]
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:655) ~[ojdbc7.jar:XX.XX.XX.XX]
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:249) ~[ojdbc7.jar:XX.XX.XX.XX]
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:566) ~[ojdbc7.jar:XX.XX.XX.XX]
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:215) ~[ojdbc7.jar:XX.XX.XX.XX]
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:58) ~[ojdbc7.jar:XX.XX.XX.XX]
at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:943) ~[ojdbc7.jar:XX.XX.XX.XX]
at oracle.jdbc.driver.OraclePreparedStatement.executeForRowsWithTimeout(OraclePreparedStatement.java:10932) ~[ojdbc7.jar:XX.XX.XX.XX]
at oracle.jdbc.driver.OraclePreparedStatement.executeBatch(OraclePreparedStatement.java:11043) ~[ojdbc7.jar:XX.XX.XX.XX]
at oracle.jdbc.driver.OracleStatementWrapper.executeBatch(OracleStatementWrapper.java:244) ~[ojdbc7.jar:XX.XX.XX.XX]
at com.pega.pegarules.configdbcp.dbcp.DelegatingStatement.executeBatch(DelegatingStatement.java:297) ~[prdbcp-7.3.0-77.jar:7.3.0-77]
at com.pega.platform.cluster.internal.ClusterServiceJdbcDAO.registerAddresses(ClusterServiceJdbcDAO.java:217) ~[cluster-impl.jar:?]
at com.pega.platform.cluster.internal.JdbcNodesProvider.registerAddresses(JdbcNodesProvider.java:98) ~[cluster-impl.jar:?]
at org.apache.ignite.spi.discovery.tcp.ServerImpl$IpFinderCleaner.cleanIpFinder(ServerImpl.java:1800) ~[ignite-core-1.7.0.jar:?]
at org.apache.ignite.spi.discovery.tcp.ServerImpl$IpFinderCleaner.body(ServerImpl.java:1719) ~[ignite-core-1.7.0.jar:?]
at org.apache.ignite.spi.IgniteSpiThread.run(IgniteSpiThread.java:62) ~[ignite-core-1.7.0.jar:?]
***Updated by moderator: Lochan to mask proprietary information***
Can you provide a bit more detail around the environment? You have 3 physical servers and on one of them you're trying to start one or more ignite servers? (Just to note, you should have ignite hosted on multiple servers for fault tolerance in case that server goes down)
Can you provide the configurations you're using for ignite?