Uploaded image for project: 'Debezium'
  1. Debezium
  2. DBZ-5800

ReplicationConnectionIT test fails

    XMLWordPrintable

Details

    • Bug
    • Resolution: Done
    • Major
    • 2.1.0.Beta1
    • 1.9.7.Final, 2.0.0.Final
    • postgresql-connector
    • None
    • False
    • None
    • False

    Description

      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
      

      Attachments

        Activity

          People

            Unassigned Unassigned
            ccranfor@redhat.com Chris Cranford
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: