-
Bug
-
Resolution: Done
-
Major
-
1.9.7.Final, 2.0.0.Final
-
None
-
False
-
None
-
False
-
-
See https://github.com/debezium/debezium/actions/runs/3378554023/jobs/5620244660
2022-11-02T15:12:27.2533851Z [ERROR] Tests run: 14, Failures: 0, Errors: 1, Skipped: 0, Time elapsed: 9.491 s <<< FAILURE! - in io.debezium.connector.postgresql.connection.ReplicationConnectionIT 2022-11-02T15:12:27.2535300Z [ERROR] io.debezium.connector.postgresql.connection.ReplicationConnectionIT.shouldReceiveAndDecodeIndividualChanges Time elapsed: 0.313 s <<< ERROR! 2022-11-02T15:12:27.2536574Z java.lang.RuntimeException: 2022-11-02T15:12:27.2537308Z org.postgresql.util.PSQLException: ERROR: cannot update table "table_without_pk" because it does not have a replica identity and publishes updates 2022-11-02T15:12:27.2538291Z Hint: To enable updating the table, set REPLICA IDENTITY using ALTER TABLE. 2022-11-02T15:12:27.2538983Z at io.debezium.connector.postgresql.TestHelper.execute(TestHelper.java:191) 2022-11-02T15:12:27.2540727Z at io.debezium.connector.postgresql.connection.ReplicationConnectionIT.insertLargeTestData(ReplicationConnectionIT.java:431) 2022-11-02T15:12:27.2542091Z at io.debezium.connector.postgresql.connection.ReplicationConnectionIT.shouldReceiveAndDecodeIndividualChanges(ReplicationConnectionIT.java:159) 2022-11-02T15:12:27.2543463Z at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method) 2022-11-02T15:12:27.2544339Z at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:77) 2022-11-02T15:12:27.2545822Z at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) 2022-11-02T15:12:27.2546542Z at java.base/java.lang.reflect.Method.invoke(Method.java:568) 2022-11-02T15:12:27.2547154Z at org.junit.runners.model.FrameworkMethod$1.runReflectiveCall(FrameworkMethod.java:59) 2022-11-02T15:12:27.2547867Z at org.junit.internal.runners.model.ReflectiveCallable.run(ReflectiveCallable.java:12) 2022-11-02T15:12:27.2548610Z at org.junit.runners.model.FrameworkMethod.invokeExplosively(FrameworkMethod.java:56) 2022-11-02T15:12:27.2549366Z at org.junit.internal.runners.statements.InvokeMethod.evaluate(InvokeMethod.java:17) 2022-11-02T15:12:27.2550100Z at org.junit.internal.runners.statements.RunBefores.evaluate(RunBefores.java:26) 2022-11-02T15:12:27.2550750Z at org.junit.runners.ParentRunner$3.evaluate(ParentRunner.java:306) 2022-11-02T15:12:27.2551379Z at org.junit.runners.BlockJUnit4ClassRunner$1.evaluate(BlockJUnit4ClassRunner.java:100) 2022-11-02T15:12:27.2552008Z at org.junit.runners.ParentRunner.runLeaf(ParentRunner.java:366) 2022-11-02T15:12:27.2552659Z at org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:103) 2022-11-02T15:12:27.2553369Z at org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:63) 2022-11-02T15:12:27.2553994Z at org.junit.runners.ParentRunner$4.run(ParentRunner.java:331) 2022-11-02T15:12:27.2554785Z at org.junit.runners.ParentRunner$1.schedule(ParentRunner.java:79) 2022-11-02T15:12:27.2555505Z at org.junit.runners.ParentRunner.runChildren(ParentRunner.java:329) 2022-11-02T15:12:27.2556233Z at org.junit.runners.ParentRunner.access$100(ParentRunner.java:66) 2022-11-02T15:12:27.2557394Z at org.junit.runners.ParentRunner$2.evaluate(ParentRunner.java:293) 2022-11-02T15:12:27.2557969Z at org.junit.runners.ParentRunner$3.evaluate(ParentRunner.java:306) 2022-11-02T15:12:27.2558531Z at org.junit.runners.ParentRunner.run(ParentRunner.java:413) 2022-11-02T15:12:27.2559172Z at org.apache.maven.surefire.junit4.JUnit4Provider.execute(JUnit4Provider.java:377) 2022-11-02T15:12:27.2559937Z at org.apache.maven.surefire.junit4.JUnit4Provider.executeWithRerun(JUnit4Provider.java:284) 2022-11-02T15:12:27.2560734Z at org.apache.maven.surefire.junit4.JUnit4Provider.executeTestSet(JUnit4Provider.java:248) 2022-11-02T15:12:27.2561459Z at org.apache.maven.surefire.junit4.JUnit4Provider.invoke(JUnit4Provider.java:167) 2022-11-02T15:12:27.2562377Z at org.apache.maven.surefire.booter.ForkedBooter.runSuitesInProcess(ForkedBooter.java:456) 2022-11-02T15:12:27.2563127Z at org.apache.maven.surefire.booter.ForkedBooter.execute(ForkedBooter.java:169) 2022-11-02T15:12:27.2563909Z at org.apache.maven.surefire.booter.ForkedBooter.run(ForkedBooter.java:595) 2022-11-02T15:12:27.2564582Z at org.apache.maven.surefire.booter.ForkedBooter.main(ForkedBooter.java:581) 2022-11-02T15:12:27.2565339Z Caused by: org.postgresql.util.PSQLException: ERROR: cannot update table "table_without_pk" because it does not have a replica identity and publishes updates 2022-11-02T15:12:27.2566015Z Hint: To enable updating the table, set REPLICA IDENTITY using ALTER TABLE. 2022-11-02T15:12:27.2566693Z at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2676) 2022-11-02T15:12:27.2567473Z at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2366) 2022-11-02T15:12:27.2568199Z at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:356) 2022-11-02T15:12:27.2568856Z at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:496) 2022-11-02T15:12:27.2569482Z at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:413) 2022-11-02T15:12:27.2570106Z at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:333) 2022-11-02T15:12:27.2570766Z at org.postgresql.jdbc.PgStatement.executeCachedSql(PgStatement.java:319) 2022-11-02T15:12:27.2571417Z at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:295) 2022-11-02T15:12:27.2572042Z at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:290) 2022-11-02T15:12:27.2572706Z at io.debezium.jdbc.JdbcConnection.executeWithoutCommitting(JdbcConnection.java:1440) 2022-11-02T15:12:27.2573414Z at io.debezium.connector.postgresql.TestHelper.execute(TestHelper.java:178) 2022-11-02T15:12:27.2573904Z ... 31 more