Question
Commonwealth Bank of Australia
AU
Last activity: 31 Jul 2017 20:35 EDT
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
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***