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

TransactionMetadataIT is unstable for Db2

XMLWordPrintable

    • Icon: Task Task
    • Resolution: Done
    • Icon: Major Major
    • 2.2.0.Alpha2
    • 2.0.0.Alpha1
    • db2-connector
    • None

      I've noticed lately that TransactionMetadataIT for DB2 has been experiencing some stability issues, as shown in this log snippet:

      2022-05-19 21:41:36,432 INFO   SchemaHistoryTopicIT||test  Starting test io.debezium.connector.db2.TransactionMetadataIT#transactionMetadata   [io.debezium.connector.db2.TransactionMetadataIT]
      2022-05-19 21:41:36,614 WARN   TransactionMetadataIT||test  The worker has been configured with one or more internal converter properties ([internal.key.converter, internal.value.converter]). Support for these properties was deprecated in version 2.0 and removed in version 3.0, and specifying them will have no effect. Instead, an instance of the JsonConverter with schemas.enable set to false will be used. For more information, please visit http://kafka.apache.org/documentation/#upgrade and consult the upgrade notesfor the 3.0 release.   [org.apache.kafka.connect.runtime.WorkerConfig]
      2022-05-19 21:41:36,614 WARN   TransactionMetadataIT||test  Variables cannot be used in the 'plugin.path' property, since the property is used by plugin scanning before the config providers that replace the variables are initialized. The raw value 'null' was used for plugin scanning, as opposed to the transformed value 'null', and this may cause unexpected results.   [org.apache.kafka.connect.runtime.WorkerConfig]
      2022-05-19 21:41:36,615 INFO   TransactionMetadataIT||engine  Starting Db2ConnectorTask with configuration:   [io.debezium.connector.common.BaseSourceTask]
      2022-05-19 21:41:36,615 INFO   TransactionMetadataIT||engine     connector.class = io.debezium.connector.db2.Db2Connector   [io.debezium.connector.common.BaseSourceTask]
      2022-05-19 21:41:36,615 INFO   TransactionMetadataIT||engine     database.history.file.filename = /home/runner/work/debezium/debezium/db2/target/data/file-db-history-connect.txt   [io.debezium.connector.common.BaseSourceTask]
      2022-05-19 21:41:36,615 INFO   TransactionMetadataIT||engine     database.dbname = testdb   [io.debezium.connector.common.BaseSourceTask]
      2022-05-19 21:41:36,615 INFO   TransactionMetadataIT||engine     database.user = db2inst1   [io.debezium.connector.common.BaseSourceTask]
      2022-05-19 21:41:36,615 INFO   TransactionMetadataIT||engine     offset.storage = org.apache.kafka.connect.storage.FileOffsetBackingStore   [io.debezium.connector.common.BaseSourceTask]
      2022-05-19 21:41:36,615 INFO   TransactionMetadataIT||engine     database.server.name = testdb   [io.debezium.connector.common.BaseSourceTask]
      2022-05-19 21:41:36,615 INFO   TransactionMetadataIT||engine     offset.flush.timeout.ms = 5000   [io.debezium.connector.common.BaseSourceTask]
      2022-05-19 21:41:36,615 INFO   TransactionMetadataIT||engine     include.schema.changes = false   [io.debezium.connector.common.BaseSourceTask]
      2022-05-19 21:41:36,615 INFO   TransactionMetadataIT||engine     provide.transaction.metadata = true   [io.debezium.connector.common.BaseSourceTask]
      2022-05-19 21:41:36,615 INFO   TransactionMetadataIT||engine     database.port = 50000   [io.debezium.connector.common.BaseSourceTask]
      2022-05-19 21:41:36,615 INFO   TransactionMetadataIT||engine     offset.flush.interval.ms = 0   [io.debezium.connector.common.BaseSourceTask]
      2022-05-19 21:41:36,615 INFO   TransactionMetadataIT||engine     internal.key.converter = org.apache.kafka.connect.json.JsonConverter   [io.debezium.connector.common.BaseSourceTask]
      2022-05-19 21:41:36,615 INFO   TransactionMetadataIT||engine     offset.storage.file.filename = /home/runner/work/debezium/debezium/db2/target/data/file-connector-offsets.txt   [io.debezium.connector.common.BaseSourceTask]
      2022-05-19 21:41:36,615 INFO   TransactionMetadataIT||engine     database.hostname = localhost   [io.debezium.connector.common.BaseSourceTask]
      2022-05-19 21:41:36,615 INFO   TransactionMetadataIT||engine     database.password = ********   [io.debezium.connector.common.BaseSourceTask]
      2022-05-19 21:41:36,615 INFO   TransactionMetadataIT||engine     name = testing-connector   [io.debezium.connector.common.BaseSourceTask]
      2022-05-19 21:41:36,615 INFO   TransactionMetadataIT||engine     internal.value.converter = org.apache.kafka.connect.json.JsonConverter   [io.debezium.connector.common.BaseSourceTask]
      2022-05-19 21:41:36,615 INFO   TransactionMetadataIT||engine     value.converter = org.apache.kafka.connect.json.JsonConverter   [io.debezium.connector.common.BaseSourceTask]
      2022-05-19 21:41:36,615 INFO   TransactionMetadataIT||engine     key.converter = org.apache.kafka.connect.json.JsonConverter   [io.debezium.connector.common.BaseSourceTask]
      2022-05-19 21:41:36,615 INFO   TransactionMetadataIT||engine     database.history = io.debezium.relational.history.FileDatabaseHistory   [io.debezium.connector.common.BaseSourceTask]
      2022-05-19 21:41:36,615 INFO   TransactionMetadataIT||engine     snapshot.mode = initial   [io.debezium.connector.common.BaseSourceTask]
      2022-05-19 21:41:36,638 INFO   TransactionMetadataIT||engine  No previous offsets found   [io.debezium.connector.common.BaseSourceTask]
      2022-05-19 21:41:36,638 INFO   TransactionMetadataIT||engine  Requested thread factory for connector Db2Connector, id = testdb named = change-event-source-coordinator   [io.debezium.util.Threads]
      2022-05-19 21:41:36,639 INFO   TransactionMetadataIT||engine  Creating thread debezium-db2connector-testdb-change-event-source-coordinator   [io.debezium.util.Threads]
      2022-05-19 21:41:36,645 INFO   DB2_Server|testdb|snapshot  Metrics registered   [io.debezium.pipeline.ChangeEventSourceCoordinator]
      2022-05-19 21:41:36,645 INFO   DB2_Server|testdb|snapshot  Context created   [io.debezium.pipeline.ChangeEventSourceCoordinator]
      2022-05-19 21:41:36,645 INFO   DB2_Server|testdb|snapshot  No previous offset has been found   [io.debezium.connector.db2.Db2SnapshotChangeEventSource]
      2022-05-19 21:41:36,645 INFO   DB2_Server|testdb|snapshot  According to the connector configuration both schema and data will be snapshotted   [io.debezium.connector.db2.Db2SnapshotChangeEventSource]
      2022-05-19 21:41:36,645 INFO   DB2_Server|testdb|snapshot  Snapshot step 1 - Preparing   [io.debezium.relational.RelationalSnapshotChangeEventSource]
      2022-05-19 21:41:36,645 INFO   DB2_Server|testdb|snapshot  Snapshot step 2 - Determining captured tables   [io.debezium.relational.RelationalSnapshotChangeEventSource]
      2022-05-19 21:41:36,653 INFO   DB2_Server|testdb|snapshot  Adding table DB2INST1.TABLEA to the list of capture schema tables   [io.debezium.relational.RelationalSnapshotChangeEventSource]
      2022-05-19 21:41:36,653 INFO   DB2_Server|testdb|snapshot  Adding table DB2INST1.TABLEB to the list of capture schema tables   [io.debezium.relational.RelationalSnapshotChangeEventSource]
      2022-05-19 21:41:36,653 INFO   DB2_Server|testdb|snapshot  Snapshot step 3 - Locking captured tables [DB2INST1.TABLEA, DB2INST1.TABLEB]   [io.debezium.relational.RelationalSnapshotChangeEventSource]
      2022-05-19 21:41:36,654 INFO   DB2_Server|testdb|snapshot  Executing schema locking   [io.debezium.connector.db2.Db2SnapshotChangeEventSource]
      2022-05-19 21:41:36,654 INFO   DB2_Server|testdb|snapshot  Locking table DB2INST1.TABLEA   [io.debezium.connector.db2.Db2SnapshotChangeEventSource]
      2022-05-19 21:41:36,656 INFO   DB2_Server|testdb|snapshot  Locking table DB2INST1.TABLEB   [io.debezium.connector.db2.Db2SnapshotChangeEventSource]
      2022-05-19 21:41:36,663 INFO   DB2_Server|testdb|snapshot  Snapshot step 4 - Determining snapshot offset   [io.debezium.relational.RelationalSnapshotChangeEventSource]
      2022-05-19 21:41:36,663 INFO   DB2_Server|testdb|snapshot  Snapshot step 5 - Reading structure of captured tables   [io.debezium.relational.RelationalSnapshotChangeEventSource]
      2022-05-19 21:41:36,663 INFO   DB2_Server|testdb|snapshot  Reading structure of schema 'DB2INST1'   [io.debezium.connector.db2.Db2SnapshotChangeEventSource]
      2022-05-19 21:41:36,669 INFO   DB2_Server|testdb|snapshot  Snapshot step 6 - Persisting schema history   [io.debezium.relational.RelationalSnapshotChangeEventSource]
      2022-05-19 21:41:36,671 INFO   DB2_Server|testdb|snapshot  Schema locks released.   [io.debezium.connector.db2.Db2SnapshotChangeEventSource]
      2022-05-19 21:41:36,671 INFO   DB2_Server|testdb|snapshot  Snapshot step 7 - Snapshotting data   [io.debezium.relational.RelationalSnapshotChangeEventSource]
      2022-05-19 21:41:36,671 INFO   DB2_Server|testdb|snapshot  Snapshotting contents of 2 tables while still in transaction   [io.debezium.relational.RelationalSnapshotChangeEventSource]
      2022-05-19 21:41:36,671 INFO   DB2_Server|testdb|snapshot  Exporting data from table 'DB2INST1.TABLEA' (1 of 2 tables)   [io.debezium.relational.RelationalSnapshotChangeEventSource]
      2022-05-19 21:41:36,671 INFO   DB2_Server|testdb|snapshot  	 For table 'DB2INST1.TABLEA' using select statement: 'SELECT "ID", "COLA" FROM DB2INST1.TABLEA'   [io.debezium.relational.RelationalSnapshotChangeEventSource]
      2022-05-19 21:41:36,674 INFO   DB2_Server|testdb|snapshot  	 Finished exporting 1 records for table 'DB2INST1.TABLEA'; total duration '00:00:00.003'   [io.debezium.relational.RelationalSnapshotChangeEventSource]
      2022-05-19 21:41:36,674 INFO   DB2_Server|testdb|snapshot  Exporting data from table 'DB2INST1.TABLEB' (2 of 2 tables)   [io.debezium.relational.RelationalSnapshotChangeEventSource]
      2022-05-19 21:41:36,674 INFO   DB2_Server|testdb|snapshot  	 For table 'DB2INST1.TABLEB' using select statement: 'SELECT "ID", "COLB" FROM DB2INST1.TABLEB'   [io.debezium.relational.RelationalSnapshotChangeEventSource]
      2022-05-19 21:41:36,677 INFO   DB2_Server|testdb|snapshot  	 Finished exporting 0 records for table 'DB2INST1.TABLEB'; total duration '00:00:00.003'   [io.debezium.relational.RelationalSnapshotChangeEventSource]
      2022-05-19 21:41:36,677 INFO   DB2_Server|testdb|snapshot  Snapshot - Final stage   [io.debezium.pipeline.source.AbstractSnapshotChangeEventSource]
      2022-05-19 21:41:36,677 INFO   DB2_Server|testdb|snapshot  Snapshot ended with SnapshotResult [status=COMPLETED, offset=Db2OffsetContext [sourceInfoSchema=Schema{io.debezium.connector.db2.Source:STRUCT}, sourceInfo=SourceInfo [serverName=testdb, changeLsn=NULL, commitLsn=NULL, snapshot=FALSE, sourceTime=2022-05-19T21:41:36.674Z], snapshotCompleted=true, eventSerialNo=1]]   [io.debezium.pipeline.ChangeEventSourceCoordinator]
      2022-05-19 21:41:36,677 INFO   DB2_Server|testdb|streaming  Connected metrics set to 'true'   [io.debezium.pipeline.ChangeEventSourceCoordinator]
      2022-05-19 21:41:36,677 INFO   DB2_Server|testdb|streaming  Starting streaming   [io.debezium.pipeline.ChangeEventSourceCoordinator]
      2022-05-19 21:41:36,678 INFO   DB2_Server|testdb|streaming  Last position recorded in offsets is NULL(NULL)[1]   [io.debezium.connector.db2.Db2StreamingChangeEventSource]
      2022-05-19 21:41:36,678 WARN   DB2_Server|testdb|streaming  No maximum LSN recorded in the database; please ensure that the DB2 Agent is running   [io.debezium.connector.db2.Db2StreamingChangeEventSource]
      Consumed record 1 / 1 (0 more)
      {"sourcePartition" : {"server" : "testdb"}, "sourceOffset" : {"commit_lsn" : "NULL", "snapshot" : "true", "snapshot_completed" : "true"}, "topic" : "testdb.DB2INST1.TABLEA", "kafkaPartition" : null, "key" : {"ID" : "1"}, "value" : {"before" : null, "after" : {"ID" : "1", "COLA" : "a"}, "source" : {"version" : "2.0.0-SNAPSHOT", "connector" : "db2", "name" : "testdb", "ts_ms" : "1652996496674", "snapshot" : "last", "db" : "testdb", "sequence" : null, "schema" : "DB2INST1", "table" : "TABLEA", "change_lsn" : null, "commit_lsn" : null}, "op" : "r", "ts_ms" : "1652996496674", "transaction" : null}}
      2022-05-19 21:41:37,178 WARN   DB2_Server|testdb|streaming  No maximum LSN recorded in the database; please ensure that the DB2 Agent is running   [io.debezium.connector.db2.Db2StreamingChangeEventSource]
      2022-05-19 21:41:37,678 WARN   DB2_Server|testdb|streaming  No maximum LSN recorded in the database; please ensure that the DB2 Agent is running   [io.debezium.connector.db2.Db2StreamingChangeEventSource]
      2022-05-19 21:41:38,178 WARN   DB2_Server|testdb|streaming  No maximum LSN recorded in the database; please ensure that the DB2 Agent is running   [io.debezium.connector.db2.Db2StreamingChangeEventSource]
      2022-05-19 21:41:38,678 WARN   DB2_Server|testdb|streaming  No maximum LSN recorded in the database; please ensure that the DB2 Agent is running   [io.debezium.connector.db2.Db2StreamingChangeEventSource]
      2022-05-19 21:41:39,178 WARN   DB2_Server|testdb|streaming  No maximum LSN recorded in the database; please ensure that the DB2 Agent is running   [io.debezium.connector.db2.Db2StreamingChangeEventSource]
      2022-05-19 21:41:39,678 WARN   DB2_Server|testdb|streaming  No maximum LSN recorded in the database; please ensure that the DB2 Agent is running   [io.debezium.connector.db2.Db2StreamingChangeEventSource]
      2022-05-19 21:41:40,178 WARN   DB2_Server|testdb|streaming  No maximum LSN recorded in the database; please ensure that the DB2 Agent is running   [io.debezium.connector.db2.Db2StreamingChangeEventSource]
      2022-05-19 21:41:40,688 WARN   DB2_Server|testdb|streaming  No maximum LSN recorded in the database; please ensure that the DB2 Agent is running   [io.debezium.connector.db2.Db2StreamingChangeEventSource]
      2022-05-19 21:41:41,178 WARN   DB2_Server|testdb|streaming  No maximum LSN recorded in the database; please ensure that the DB2 Agent is running   [io.debezium.connector.db2.Db2StreamingChangeEventSource]
      2022-05-19 21:41:41,678 WARN   DB2_Server|testdb|streaming  No maximum LSN recorded in the database; please ensure that the DB2 Agent is running   [io.debezium.connector.db2.Db2StreamingChangeEventSource]
      2022-05-19 21:41:42,178 WARN   DB2_Server|testdb|streaming  No maximum LSN recorded in the database; please ensure that the DB2 Agent is running   [io.debezium.connector.db2.Db2StreamingChangeEventSource]
      2022-05-19 21:41:42,678 WARN   DB2_Server|testdb|streaming  No maximum LSN recorded in the database; please ensure that the DB2 Agent is running   [io.debezium.connector.db2.Db2StreamingChangeEventSource]
      2022-05-19 21:41:43,178 WARN   DB2_Server|testdb|streaming  No maximum LSN recorded in the database; please ensure that the DB2 Agent is running   [io.debezium.connector.db2.Db2StreamingChangeEventSource]
      2022-05-19 21:41:43,678 WARN   DB2_Server|testdb|streaming  No maximum LSN recorded in the database; please ensure that the DB2 Agent is running   [io.debezium.connector.db2.Db2StreamingChangeEventSource]
      2022-05-19 21:41:44,178 WARN   DB2_Server|testdb|streaming  No maximum LSN recorded in the database; please ensure that the DB2 Agent is running   [io.debezium.connector.db2.Db2StreamingChangeEventSource]
      2022-05-19 21:41:44,678 WARN   DB2_Server|testdb|streaming  No maximum LSN recorded in the database; please ensure that the DB2 Agent is running   [io.debezium.connector.db2.Db2StreamingChangeEventSource]
      2022-05-19 21:41:45,178 WARN   DB2_Server|testdb|streaming  No maximum LSN recorded in the database; please ensure that the DB2 Agent is running   [io.debezium.connector.db2.Db2StreamingChangeEventSource]
      2022-05-19 21:41:45,678 WARN   DB2_Server|testdb|streaming  No maximum LSN recorded in the database; please ensure that the DB2 Agent is running   [io.debezium.connector.db2.Db2StreamingChangeEventSource]
      2022-05-19 21:41:46,178 WARN   DB2_Server|testdb|streaming  No maximum LSN recorded in the database; please ensure that the DB2 Agent is running   [io.debezium.connector.db2.Db2StreamingChangeEventSource]
      2022-05-19 21:41:46,678 WARN   DB2_Server|testdb|streaming  No maximum LSN recorded in the database; please ensure that the DB2 Agent is running   [io.debezium.connector.db2.Db2StreamingChangeEventSource]
      2022-05-19 21:41:47,178 WARN   DB2_Server|testdb|streaming  No maximum LSN recorded in the database; please ensure that the DB2 Agent is running   [io.debezium.connector.db2.Db2StreamingChangeEventSource]
      2022-05-19 21:41:47,678 WARN   DB2_Server|testdb|streaming  No maximum LSN recorded in the database; please ensure that the DB2 Agent is running   [io.debezium.connector.db2.Db2StreamingChangeEventSource]
      2022-05-19 21:41:48,178 WARN   DB2_Server|testdb|streaming  No maximum LSN recorded in the database; please ensure that the DB2 Agent is running   [io.debezium.connector.db2.Db2StreamingChangeEventSource]
      2022-05-19 21:41:48,678 WARN   DB2_Server|testdb|streaming  No maximum LSN recorded in the database; please ensure that the DB2 Agent is running   [io.debezium.connector.db2.Db2StreamingChangeEventSource]
      2022-05-19 21:41:49,178 WARN   DB2_Server|testdb|streaming  No maximum LSN recorded in the database; please ensure that the DB2 Agent is running   [io.debezium.connector.db2.Db2StreamingChangeEventSource]
      2022-05-19 21:41:49,678 WARN   DB2_Server|testdb|streaming  No maximum LSN recorded in the database; please ensure that the DB2 Agent is running   [io.debezium.connector.db2.Db2StreamingChangeEventSource]
      2022-05-19 21:41:50,178 WARN   DB2_Server|testdb|streaming  No maximum LSN recorded in the database; please ensure that the DB2 Agent is running   [io.debezium.connector.db2.Db2StreamingChangeEventSource]
      2022-05-19 21:41:50,678 WARN   DB2_Server|testdb|streaming  No maximum LSN recorded in the database; please ensure that the DB2 Agent is running   [io.debezium.connector.db2.Db2StreamingChangeEventSource]
      2022-05-19 21:41:51,178 WARN   DB2_Server|testdb|streaming  No maximum LSN recorded in the database; please ensure that the DB2 Agent is running   [io.debezium.connector.db2.Db2StreamingChangeEventSource]
      2022-05-19 21:41:51,678 WARN   DB2_Server|testdb|streaming  No maximum LSN recorded in the database; please ensure that the DB2 Agent is running   [io.debezium.connector.db2.Db2StreamingChangeEventSource]
      2022-05-19 21:41:52,178 WARN   DB2_Server|testdb|streaming  No maximum LSN recorded in the database; please ensure that the DB2 Agent is running   [io.debezium.connector.db2.Db2StreamingChangeEventSource]
      2022-05-19 21:41:52,678 WARN   DB2_Server|testdb|streaming  No maximum LSN recorded in the database; please ensure that the DB2 Agent is running   [io.debezium.connector.db2.Db2StreamingChangeEventSource]
      2022-05-19 21:41:53,178 WARN   DB2_Server|testdb|streaming  No maximum LSN recorded in the database; please ensure that the DB2 Agent is running   [io.debezium.connector.db2.Db2StreamingChangeEventSource]
      2022-05-19 21:41:53,678 WARN   DB2_Server|testdb|streaming  No maximum LSN recorded in the database; please ensure that the DB2 Agent is running   [io.debezium.connector.db2.Db2StreamingChangeEventSource]
      2022-05-19 21:41:54,178 WARN   DB2_Server|testdb|streaming  No maximum LSN recorded in the database; please ensure that the DB2 Agent is running   [io.debezium.connector.db2.Db2StreamingChangeEventSource]
      2022-05-19 21:41:54,678 WARN   DB2_Server|testdb|streaming  No maximum LSN recorded in the database; please ensure that the DB2 Agent is running   [io.debezium.connector.db2.Db2StreamingChangeEventSource]
      2022-05-19 21:41:55,178 WARN   DB2_Server|testdb|streaming  No maximum LSN recorded in the database; please ensure that the DB2 Agent is running   [io.debezium.connector.db2.Db2StreamingChangeEventSource]
      2022-05-19 21:41:55,678 WARN   DB2_Server|testdb|streaming  No maximum LSN recorded in the database; please ensure that the DB2 Agent is running   [io.debezium.connector.db2.Db2StreamingChangeEventSource]
      2022-05-19 21:41:56,178 WARN   DB2_Server|testdb|streaming  No maximum LSN recorded in the database; please ensure that the DB2 Agent is running   [io.debezium.connector.db2.Db2StreamingChangeEventSource]
      2022-05-19 21:41:56,678 WARN   DB2_Server|testdb|streaming  No maximum LSN recorded in the database; please ensure that the DB2 Agent is running   [io.debezium.connector.db2.Db2StreamingChangeEventSource]
      2022-05-19 21:41:57,178 WARN   DB2_Server|testdb|streaming  No maximum LSN recorded in the database; please ensure that the DB2 Agent is running   [io.debezium.connector.db2.Db2StreamingChangeEventSource]
      2022-05-19 21:41:57,678 WARN   DB2_Server|testdb|streaming  No maximum LSN recorded in the database; please ensure that the DB2 Agent is running   [io.debezium.connector.db2.Db2StreamingChangeEventSource]
      2022-05-19 21:41:58,178 WARN   DB2_Server|testdb|streaming  No maximum LSN recorded in the database; please ensure that the DB2 Agent is running   [io.debezium.connector.db2.Db2StreamingChangeEventSource]
      2022-05-19 21:41:58,678 WARN   DB2_Server|testdb|streaming  No maximum LSN recorded in the database; please ensure that the DB2 Agent is running   [io.debezium.connector.db2.Db2StreamingChangeEventSource]
      2022-05-19 21:41:59,178 WARN   DB2_Server|testdb|streaming  No maximum LSN recorded in the database; please ensure that the DB2 Agent is running   [io.debezium.connector.db2.Db2StreamingChangeEventSource]
      2022-05-19 21:41:59,678 WARN   DB2_Server|testdb|streaming  No maximum LSN recorded in the database; please ensure that the DB2 Agent is running   [io.debezium.connector.db2.Db2StreamingChangeEventSource]
      2022-05-19 21:42:00,178 WARN   DB2_Server|testdb|streaming  No maximum LSN recorded in the database; please ensure that the DB2 Agent is running   [io.debezium.connector.db2.Db2StreamingChangeEventSource]
      2022-05-19 21:42:00,678 WARN   DB2_Server|testdb|streaming  No maximum LSN recorded in the database; please ensure that the DB2 Agent is running   [io.debezium.connector.db2.Db2StreamingChangeEventSource]
      2022-05-19 21:42:01,178 WARN   DB2_Server|testdb|streaming  No maximum LSN recorded in the database; please ensure that the DB2 Agent is running   [io.debezium.connector.db2.Db2StreamingChangeEventSource]
      2022-05-19 21:42:01,678 WARN   DB2_Server|testdb|streaming  No maximum LSN recorded in the database; please ensure that the DB2 Agent is running   [io.debezium.connector.db2.Db2StreamingChangeEventSource]
      2022-05-19 21:42:02,178 WARN   DB2_Server|testdb|streaming  No maximum LSN recorded in the database; please ensure that the DB2 Agent is running   [io.debezium.connector.db2.Db2StreamingChangeEventSource]
      2022-05-19 21:42:02,678 WARN   DB2_Server|testdb|streaming  No maximum LSN recorded in the database; please ensure that the DB2 Agent is running   [io.debezium.connector.db2.Db2StreamingChangeEventSource]
      2022-05-19 21:42:03,178 WARN   DB2_Server|testdb|streaming  No maximum LSN recorded in the database; please ensure that the DB2 Agent is running   [io.debezium.connector.db2.Db2StreamingChangeEventSource]
      2022-05-19 21:42:03,694 WARN   DB2_Server|testdb|streaming  No maximum LSN recorded in the database; please ensure that the DB2 Agent is running   [io.debezium.connector.db2.Db2StreamingChangeEventSource]
      2022-05-19 21:42:04,178 WARN   DB2_Server|testdb|streaming  No maximum LSN recorded in the database; please ensure that the DB2 Agent is running   [io.debezium.connector.db2.Db2StreamingChangeEventSource]
      2022-05-19 21:42:04,678 WARN   DB2_Server|testdb|streaming  No maximum LSN recorded in the database; please ensure that the DB2 Agent is running   [io.debezium.connector.db2.Db2StreamingChangeEventSource]
      2022-05-19 21:42:05,178 WARN   DB2_Server|testdb|streaming  No maximum LSN recorded in the database; please ensure that the DB2 Agent is running   [io.debezium.connector.db2.Db2StreamingChangeEventSource]
      2022-05-19 21:42:05,678 WARN   DB2_Server|testdb|streaming  No maximum LSN recorded in the database; please ensure that the DB2 Agent is running   [io.debezium.connector.db2.Db2StreamingChangeEventSource]
      2022-05-19 21:42:06,178 WARN   DB2_Server|testdb|streaming  No maximum LSN recorded in the database; please ensure that the DB2 Agent is running   [io.debezium.connector.db2.Db2StreamingChangeEventSource]
      2022-05-19 21:42:06,678 WARN   DB2_Server|testdb|streaming  No maximum LSN recorded in the database; please ensure that the DB2 Agent is running   [io.debezium.connector.db2.Db2StreamingChangeEventSource]
      2022-05-19 21:42:07,178 WARN   DB2_Server|testdb|streaming  No maximum LSN recorded in the database; please ensure that the DB2 Agent is running   [io.debezium.connector.db2.Db2StreamingChangeEventSource]
      2022-05-19 21:42:07,678 WARN   DB2_Server|testdb|streaming  No maximum LSN recorded in the database; please ensure that the DB2 Agent is running   [io.debezium.connector.db2.Db2StreamingChangeEventSource]
      2022-05-19 21:42:08,182 WARN   DB2_Server|testdb|streaming  No maximum LSN recorded in the database; please ensure that the DB2 Agent is running   [io.debezium.connector.db2.Db2StreamingChangeEventSource]
      2022-05-19 21:42:08,678 WARN   DB2_Server|testdb|streaming  No maximum LSN recorded in the database; please ensure that the DB2 Agent is running   [io.debezium.connector.db2.Db2StreamingChangeEventSource]
      2022-05-19 21:42:09,178 WARN   DB2_Server|testdb|streaming  No maximum LSN recorded in the database; please ensure that the DB2 Agent is running   [io.debezium.connector.db2.Db2StreamingChangeEventSource]
      2022-05-19 21:42:09,678 WARN   DB2_Server|testdb|streaming  No maximum LSN recorded in the database; please ensure that the DB2 Agent is running   [io.debezium.connector.db2.Db2StreamingChangeEventSource]
      2022-05-19 21:42:10,178 WARN   DB2_Server|testdb|streaming  No maximum LSN recorded in the database; please ensure that the DB2 Agent is running   [io.debezium.connector.db2.Db2StreamingChangeEventSource]
      2022-05-19 21:42:10,678 WARN   DB2_Server|testdb|streaming  No maximum LSN recorded in the database; please ensure that the DB2 Agent is running   [io.debezium.connector.db2.Db2StreamingChangeEventSource]
      2022-05-19 21:42:11,178 WARN   DB2_Server|testdb|streaming  No maximum LSN recorded in the database; please ensure that the DB2 Agent is running   [io.debezium.connector.db2.Db2StreamingChangeEventSource]
      2022-05-19 21:42:11,678 WARN   DB2_Server|testdb|streaming  No maximum LSN recorded in the database; please ensure that the DB2 Agent is running   [io.debezium.connector.db2.Db2StreamingChangeEventSource]
      2022-05-19 21:42:12,180 WARN   DB2_Server|testdb|streaming  No maximum LSN recorded in the database; please ensure that the DB2 Agent is running   [io.debezium.connector.db2.Db2StreamingChangeEventSource]
      2022-05-19 21:42:12,678 WARN   DB2_Server|testdb|streaming  No maximum LSN recorded in the database; please ensure that the DB2 Agent is running   [io.debezium.connector.db2.Db2StreamingChangeEventSource]
      2022-05-19 21:42:13,178 WARN   DB2_Server|testdb|streaming  No maximum LSN recorded in the database; please ensure that the DB2 Agent is running   [io.debezium.connector.db2.Db2StreamingChangeEventSource]
      2022-05-19 21:42:13,678 WARN   DB2_Server|testdb|streaming  No maximum LSN recorded in the database; please ensure that the DB2 Agent is running   [io.debezium.connector.db2.Db2StreamingChangeEventSource]
      2022-05-19 21:42:14,178 WARN   DB2_Server|testdb|streaming  No maximum LSN recorded in the database; please ensure that the DB2 Agent is running   [io.debezium.connector.db2.Db2StreamingChangeEventSource]
      2022-05-19 21:42:14,678 WARN   DB2_Server|testdb|streaming  No maximum LSN recorded in the database; please ensure that the DB2 Agent is running   [io.debezium.connector.db2.Db2StreamingChangeEventSource]
      2022-05-19 21:42:15,178 WARN   DB2_Server|testdb|streaming  No maximum LSN recorded in the database; please ensure that the DB2 Agent is running   [io.debezium.connector.db2.Db2StreamingChangeEventSource]
      2022-05-19 21:42:15,678 WARN   DB2_Server|testdb|streaming  No maximum LSN recorded in the database; please ensure that the DB2 Agent is running   [io.debezium.connector.db2.Db2StreamingChangeEventSource]
      2022-05-19 21:42:16,178 WARN   DB2_Server|testdb|streaming  No maximum LSN recorded in the database; please ensure that the DB2 Agent is running   [io.debezium.connector.db2.Db2StreamingChangeEventSource]
      2022-05-19 21:42:16,678 WARN   DB2_Server|testdb|streaming  No maximum LSN recorded in the database; please ensure that the DB2 Agent is running   [io.debezium.connector.db2.Db2StreamingChangeEventSource]
      2022-05-19 21:42:17,178 WARN   DB2_Server|testdb|streaming  No maximum LSN recorded in the database; please ensure that the DB2 Agent is running   [io.debezium.connector.db2.Db2StreamingChangeEventSource]
      2022-05-19 21:42:17,678 WARN   DB2_Server|testdb|streaming  No maximum LSN recorded in the database; please ensure that the DB2 Agent is running   [io.debezium.connector.db2.Db2StreamingChangeEventSource]
      2022-05-19 21:42:18,178 WARN   DB2_Server|testdb|streaming  No maximum LSN recorded in the database; please ensure that the DB2 Agent is running   [io.debezium.connector.db2.Db2StreamingChangeEventSource]
      2022-05-19 21:42:18,678 WARN   DB2_Server|testdb|streaming  No maximum LSN recorded in the database; please ensure that the DB2 Agent is running   [io.debezium.connector.db2.Db2StreamingChangeEventSource]
      2022-05-19 21:42:19,178 WARN   DB2_Server|testdb|streaming  No maximum LSN recorded in the database; please ensure that the DB2 Agent is running   [io.debezium.connector.db2.Db2StreamingChangeEventSource]
      2022-05-19 21:42:19,678 WARN   DB2_Server|testdb|streaming  No maximum LSN recorded in the database; please ensure that the DB2 Agent is running   [io.debezium.connector.db2.Db2StreamingChangeEventSource]
      2022-05-19 21:42:20,178 WARN   DB2_Server|testdb|streaming  No maximum LSN recorded in the database; please ensure that the DB2 Agent is running   [io.debezium.connector.db2.Db2StreamingChangeEventSource]
      2022-05-19 21:42:20,678 WARN   DB2_Server|testdb|streaming  No maximum LSN recorded in the database; please ensure that the DB2 Agent is running   [io.debezium.connector.db2.Db2StreamingChangeEventSource]
      2022-05-19 21:42:21,178 WARN   DB2_Server|testdb|streaming  No maximum LSN recorded in the database; please ensure that the DB2 Agent is running   [io.debezium.connector.db2.Db2StreamingChangeEventSource]
      2022-05-19 21:42:21,678 WARN   DB2_Server|testdb|streaming  No maximum LSN recorded in the database; please ensure that the DB2 Agent is running   [io.debezium.connector.db2.Db2StreamingChangeEventSource]
      2022-05-19 21:42:22,178 WARN   DB2_Server|testdb|streaming  No maximum LSN recorded in the database; please ensure that the DB2 Agent is running   [io.debezium.connector.db2.Db2StreamingChangeEventSource]
      2022-05-19 21:42:22,678 WARN   DB2_Server|testdb|streaming  No maximum LSN recorded in the database; please ensure that the DB2 Agent is running   [io.debezium.connector.db2.Db2StreamingChangeEventSource]
      2022-05-19 21:42:23,178 WARN   DB2_Server|testdb|streaming  No maximum LSN recorded in the database; please ensure that the DB2 Agent is running   [io.debezium.connector.db2.Db2StreamingChangeEventSource]
      2022-05-19 21:42:23,678 WARN   DB2_Server|testdb|streaming  No maximum LSN recorded in the database; please ensure that the DB2 Agent is running   [io.debezium.connector.db2.Db2StreamingChangeEventSource]
      2022-05-19 21:42:24,178 WARN   DB2_Server|testdb|streaming  No maximum LSN recorded in the database; please ensure that the DB2 Agent is running   [io.debezium.connector.db2.Db2StreamingChangeEventSource]
      2022-05-19 21:42:24,678 WARN   DB2_Server|testdb|streaming  No maximum LSN recorded in the database; please ensure that the DB2 Agent is running   [io.debezium.connector.db2.Db2StreamingChangeEventSource]
      2022-05-19 21:42:25,178 WARN   DB2_Server|testdb|streaming  No maximum LSN recorded in the database; please ensure that the DB2 Agent is running   [io.debezium.connector.db2.Db2StreamingChangeEventSource]
      2022-05-19 21:42:25,678 WARN   DB2_Server|testdb|streaming  No maximum LSN recorded in the database; please ensure that the DB2 Agent is running   [io.debezium.connector.db2.Db2StreamingChangeEventSource]
      2022-05-19 21:42:26,178 WARN   DB2_Server|testdb|streaming  No maximum LSN recorded in the database; please ensure that the DB2 Agent is running   [io.debezium.connector.db2.Db2StreamingChangeEventSource]
      2022-05-19 21:42:26,678 WARN   DB2_Server|testdb|streaming  No maximum LSN recorded in the database; please ensure that the DB2 Agent is running   [io.debezium.connector.db2.Db2StreamingChangeEventSource]
      2022-05-19 21:42:27,178 WARN   DB2_Server|testdb|streaming  No maximum LSN recorded in the database; please ensure that the DB2 Agent is running   [io.debezium.connector.db2.Db2StreamingChangeEventSource]
      2022-05-19 21:42:27,678 WARN   DB2_Server|testdb|streaming  No maximum LSN recorded in the database; please ensure that the DB2 Agent is running   [io.debezium.connector.db2.Db2StreamingChangeEventSource]
      2022-05-19 21:42:28,178 WARN   DB2_Server|testdb|streaming  No maximum LSN recorded in the database; please ensure that the DB2 Agent is running   [io.debezium.connector.db2.Db2StreamingChangeEventSource]
      2022-05-19 21:42:28,678 WARN   DB2_Server|testdb|streaming  No maximum LSN recorded in the database; please ensure that the DB2 Agent is running   [io.debezium.connector.db2.Db2StreamingChangeEventSource]
      2022-05-19 21:42:29,178 WARN   DB2_Server|testdb|streaming  No maximum LSN recorded in the database; please ensure that the DB2 Agent is running   [io.debezium.connector.db2.Db2StreamingChangeEventSource]
      2022-05-19 21:42:29,678 WARN   DB2_Server|testdb|streaming  No maximum LSN recorded in the database; please ensure that the DB2 Agent is running   [io.debezium.connector.db2.Db2StreamingChangeEventSource]
      2022-05-19 21:42:30,178 WARN   DB2_Server|testdb|streaming  No maximum LSN recorded in the database; please ensure that the DB2 Agent is running   [io.debezium.connector.db2.Db2StreamingChangeEventSource]
      2022-05-19 21:42:30,678 WARN   DB2_Server|testdb|streaming  No maximum LSN recorded in the database; please ensure that the DB2 Agent is running   [io.debezium.connector.db2.Db2StreamingChangeEventSource]
      2022-05-19 21:42:31,178 WARN   DB2_Server|testdb|streaming  No maximum LSN recorded in the database; please ensure that the DB2 Agent is running   [io.debezium.connector.db2.Db2StreamingChangeEventSource]
      2022-05-19 21:42:31,678 WARN   DB2_Server|testdb|streaming  No maximum LSN recorded in the database; please ensure that the DB2 Agent is running   [io.debezium.connector.db2.Db2StreamingChangeEventSource]
      2022-05-19 21:42:32,178 WARN   DB2_Server|testdb|streaming  No maximum LSN recorded in the database; please ensure that the DB2 Agent is running   [io.debezium.connector.db2.Db2StreamingChangeEventSource]
      2022-05-19 21:42:32,678 WARN   DB2_Server|testdb|streaming  No maximum LSN recorded in the database; please ensure that the DB2 Agent is running   [io.debezium.connector.db2.Db2StreamingChangeEventSource]
      2022-05-19 21:42:33,178 WARN   DB2_Server|testdb|streaming  No maximum LSN recorded in the database; please ensure that the DB2 Agent is running   [io.debezium.connector.db2.Db2StreamingChangeEventSource]
      2022-05-19 21:42:33,678 WARN   DB2_Server|testdb|streaming  No maximum LSN recorded in the database; please ensure that the DB2 Agent is running   [io.debezium.connector.db2.Db2StreamingChangeEventSource]
      2022-05-19 21:42:34,178 WARN   DB2_Server|testdb|streaming  No maximum LSN recorded in the database; please ensure that the DB2 Agent is running   [io.debezium.connector.db2.Db2StreamingChangeEventSource]
      2022-05-19 21:42:34,678 WARN   DB2_Server|testdb|streaming  No maximum LSN recorded in the database; please ensure that the DB2 Agent is running   [io.debezium.connector.db2.Db2StreamingChangeEventSource]
      2022-05-19 21:42:35,178 WARN   DB2_Server|testdb|streaming  No maximum LSN recorded in the database; please ensure that the DB2 Agent is running   [io.debezium.connector.db2.Db2StreamingChangeEventSource]
      2022-05-19 21:42:35,678 WARN   DB2_Server|testdb|streaming  No maximum LSN recorded in the database; please ensure that the DB2 Agent is running   [io.debezium.connector.db2.Db2StreamingChangeEventSource]
      2022-05-19 21:42:36,178 WARN   DB2_Server|testdb|streaming  No maximum LSN recorded in the database; please ensure that the DB2 Agent is running   [io.debezium.connector.db2.Db2StreamingChangeEventSource]
      2022-05-19 21:42:36,678 WARN   DB2_Server|testdb|streaming  No maximum LSN recorded in the database; please ensure that the DB2 Agent is running   [io.debezium.connector.db2.Db2StreamingChangeEventSource]
      2022-05-19 21:42:37,178 WARN   DB2_Server|testdb|streaming  No maximum LSN recorded in the database; please ensure that the DB2 Agent is running   [io.debezium.connector.db2.Db2StreamingChangeEventSource]
      2022-05-19 21:42:37,678 WARN   DB2_Server|testdb|streaming  No maximum LSN recorded in the database; please ensure that the DB2 Agent is running   [io.debezium.connector.db2.Db2StreamingChangeEventSource]
      2022-05-19 21:42:38,178 WARN   DB2_Server|testdb|streaming  No maximum LSN recorded in the database; please ensure that the DB2 Agent is running   [io.debezium.connector.db2.Db2StreamingChangeEventSource]
      2022-05-19 21:42:38,678 WARN   DB2_Server|testdb|streaming  No maximum LSN recorded in the database; please ensure that the DB2 Agent is running   [io.debezium.connector.db2.Db2StreamingChangeEventSource]
      2022-05-19 21:42:39,178 WARN   DB2_Server|testdb|streaming  No maximum LSN recorded in the database; please ensure that the DB2 Agent is running   [io.debezium.connector.db2.Db2StreamingChangeEventSource]
      2022-05-19 21:42:39,680 WARN   DB2_Server|testdb|streaming  No maximum LSN recorded in the database; please ensure that the DB2 Agent is running   [io.debezium.connector.db2.Db2StreamingChangeEventSource]
      2022-05-19 21:42:40,178 WARN   DB2_Server|testdb|streaming  No maximum LSN recorded in the database; please ensure that the DB2 Agent is running   [io.debezium.connector.db2.Db2StreamingChangeEventSource]
      2022-05-19 21:42:40,678 WARN   DB2_Server|testdb|streaming  No maximum LSN recorded in the database; please ensure that the DB2 Agent is running   [io.debezium.connector.db2.Db2StreamingChangeEventSource]
      2022-05-19 21:42:41,178 WARN   DB2_Server|testdb|streaming  No maximum LSN recorded in the database; please ensure that the DB2 Agent is running   [io.debezium.connector.db2.Db2StreamingChangeEventSource]
      2022-05-19 21:42:41,677 WARN   DB2_Server|testdb|streaming  No maximum LSN recorded in the database; please ensure that the DB2 Agent is running   [io.debezium.connector.db2.Db2StreamingChangeEventSource]
      2022-05-19 21:42:42,177 WARN   DB2_Server|testdb|streaming  No maximum LSN recorded in the database; please ensure that the DB2 Agent is running   [io.debezium.connector.db2.Db2StreamingChangeEventSource]
      2022-05-19 21:42:42,678 WARN   DB2_Server|testdb|streaming  No maximum LSN recorded in the database; please ensure that the DB2 Agent is running   [io.debezium.connector.db2.Db2StreamingChangeEventSource]
      2022-05-19 21:42:43,178 WARN   DB2_Server|testdb|streaming  No maximum LSN recorded in the database; please ensure that the DB2 Agent is running   [io.debezium.connector.db2.Db2StreamingChangeEventSource]
      2022-05-19 21:42:43,678 WARN   DB2_Server|testdb|streaming  No maximum LSN recorded in the database; please ensure that the DB2 Agent is running   [io.debezium.connector.db2.Db2StreamingChangeEventSource]
      2022-05-19 21:42:44,178 WARN   DB2_Server|testdb|streaming  No maximum LSN recorded in the database; please ensure that the DB2 Agent is running   [io.debezium.connector.db2.Db2StreamingChangeEventSource]
      2022-05-19 21:42:44,678 WARN   DB2_Server|testdb|streaming  No maximum LSN recorded in the database; please ensure that the DB2 Agent is running   [io.debezium.connector.db2.Db2StreamingChangeEventSource]
      2022-05-19 21:42:45,178 WARN   DB2_Server|testdb|streaming  No maximum LSN recorded in the database; please ensure that the DB2 Agent is running   [io.debezium.connector.db2.Db2StreamingChangeEventSource]
      2022-05-19 21:42:45,678 WARN   DB2_Server|testdb|streaming  No maximum LSN recorded in the database; please ensure that the DB2 Agent is running   [io.debezium.connector.db2.Db2StreamingChangeEventSource]
      2022-05-19 21:42:46,178 WARN   DB2_Server|testdb|streaming  No maximum LSN recorded in the database; please ensure that the DB2 Agent is running   [io.debezium.connector.db2.Db2StreamingChangeEventSource]
      2022-05-19 21:42:46,678 WARN   DB2_Server|testdb|streaming  No maximum LSN recorded in the database; please ensure that the DB2 Agent is running   [io.debezium.connector.db2.Db2StreamingChangeEventSource]
      2022-05-19 21:42:47,178 WARN   DB2_Server|testdb|streaming  No maximum LSN recorded in the database; please ensure that the DB2 Agent is running   [io.debezium.connector.db2.Db2StreamingChangeEventSource]
      2022-05-19 21:42:47,678 WARN   DB2_Server|testdb|streaming  No maximum LSN recorded in the database; please ensure that the DB2 Agent is running   [io.debezium.connector.db2.Db2StreamingChangeEventSource]
      2022-05-19 21:42:48,178 WARN   DB2_Server|testdb|streaming  No maximum LSN recorded in the database; please ensure that the DB2 Agent is running   [io.debezium.connector.db2.Db2StreamingChangeEventSource]
      2022-05-19 21:42:48,678 WARN   DB2_Server|testdb|streaming  No maximum LSN recorded in the database; please ensure that the DB2 Agent is running   [io.debezium.connector.db2.Db2StreamingChangeEventSource]
      2022-05-19 21:42:49,178 WARN   DB2_Server|testdb|streaming  No maximum LSN recorded in the database; please ensure that the DB2 Agent is running   [io.debezium.connector.db2.Db2StreamingChangeEventSource]
      2022-05-19 21:42:49,678 WARN   DB2_Server|testdb|streaming  No maximum LSN recorded in the database; please ensure that the DB2 Agent is running   [io.debezium.connector.db2.Db2StreamingChangeEventSource]
      2022-05-19 21:42:50,118 INFO   ||  Connection gracefully closed   [io.debezium.jdbc.JdbcConnection]
      2022-05-19 21:42:50,118 INFO   TransactionMetadataIT||test  Stopping the connector   [io.debezium.connector.db2.TransactionMetadataIT]
      2022-05-19 21:42:50,118 INFO   TransactionMetadataIT||test  Stopping the engine   [io.debezium.connector.db2.TransactionMetadataIT]
      2022-05-19 21:42:50,118 INFO   TransactionMetadataIT||test  Stopping the embedded engine   [io.debezium.embedded.EmbeddedEngine]
      2022-05-19 21:42:50,118 INFO   TransactionMetadataIT||test  Waiting for PT5M for connector to stop   [io.debezium.embedded.EmbeddedEngine]
      2022-05-19 21:42:50,178 WARN   DB2_Server|testdb|streaming  No maximum LSN recorded in the database; please ensure that the DB2 Agent is running   [io.debezium.connector.db2.Db2StreamingChangeEventSource]
      2022-05-19 21:42:50,292 INFO   TransactionMetadataIT||engine  Stopping the task and engine   [io.debezium.embedded.EmbeddedEngine]
      2022-05-19 21:42:50,292 INFO   TransactionMetadataIT||engine  Stopping down connector   [io.debezium.connector.common.BaseSourceTask]
      2022-05-19 21:42:50,678 INFO   DB2_Server|testdb|streaming  Finished streaming   [io.debezium.pipeline.ChangeEventSourceCoordinator]
      2022-05-19 21:42:50,678 INFO   DB2_Server|testdb|streaming  Connected metrics set to 'false'   [io.debezium.pipeline.ChangeEventSourceCoordinator]
      2022-05-19 21:42:50,679 ERROR  TransactionMetadataIT||engine  Exception while closing JDBC connection   [io.debezium.connector.db2.Db2ConnectorTask]
      com.ibm.db2.jcc.am.SqlException: [jcc][t4][10251][10308][4.26.14] java.sql.Connection.close() requested while a transaction is in progress on the connection.
      The transaction remains active, and the connection cannot be closed. ERRORCODE=-4471, SQLSTATE=null
      	at com.ibm.db2.jcc.am.b7.a(b7.java:794)
      	at com.ibm.db2.jcc.am.b7.a(b7.java:66)
      	at com.ibm.db2.jcc.am.b7.a(b7.java:133)
      	at com.ibm.db2.jcc.am.Connection.checkForTransactionInProgress(Connection.java:1484)
      	at com.ibm.db2.jcc.t4.b.checkForTransactionInProgress(b.java:7581)
      	at com.ibm.db2.jcc.am.Connection.closeResourcesX(Connection.java:1507)
      	at com.ibm.db2.jcc.am.Connection.closeX(Connection.java:1493)
      	at com.ibm.db2.jcc.am.Connection.close(Connection.java:1470)
      	at io.debezium.jdbc.JdbcConnection.lambda$doClose$3(JdbcConnection.java:955)
      	at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264)
      	at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1136)
      	at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:635)
      	at java.base/java.lang.Thread.run(Thread.java:833)
      2022-05-19 21:42:50,679 INFO   ||  Connection gracefully closed   [io.debezium.jdbc.JdbcConnection]
      2022-05-19 21:42:50,681 INFO   TransactionMetadataIT||test  Interrupting the engine   [io.debezium.connector.db2.TransactionMetadataIT]
      2022-05-19 21:42:50,681 INFO   TransactionMetadataIT||engine  Connector 'io.debezium.connector.db2.Db2Connector' completed normally.   [io.debezium.connector.db2.TransactionMetadataIT]
      2022-05-19 21:42:50,682 INFO   TransactionMetadataIT||test  Test io.debezium.connector.db2.TransactionMetadataIT#transactionMetadata failed   [io.debezium.connector.db2.TransactionMetadataIT]
      Error:  Tests run: 1, Failures: 0, Errors: 1, Skipped: 0, Time elapsed: 74.25 s <<< FAILURE! - in io.debezium.connector.db2.TransactionMetadataIT
      Error:  io.debezium.connector.db2.TransactionMetadataIT.transactionMetadata  Time elapsed: 74.247 s  <<< ERROR!
      java.sql.SQLException: ASNCAP server did not start.
      	at io.debezium.connector.db2.util.TestHelper.enableDbCdc(TestHelper.java:139)
      	at io.debezium.connector.db2.TransactionMetadataIT.transactionMetadata(TransactionMetadataIT.java:77)
      	at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      	at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:77)
      	at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
      	at java.base/java.lang.reflect.Method.invoke(Method.java:568)
      	at org.junit.runners.model.FrameworkMethod$1.runReflectiveCall(FrameworkMethod.java:59)
      	at org.junit.internal.runners.model.ReflectiveCallable.run(ReflectiveCallable.java:12)
      	at org.junit.runners.model.FrameworkMethod.invokeExplosively(FrameworkMethod.java:56)
      	at org.junit.internal.runners.statements.InvokeMethod.evaluate(InvokeMethod.java:17)
      	at org.junit.internal.runners.statements.RunBefores.evaluate(RunBefores.java:26)
      	at org.junit.internal.runners.statements.RunAfters.evaluate(RunAfters.java:27)
      	at org.junit.rules.TestWatcher$1.evaluate(TestWatcher.java:61)
      	at org.junit.runners.ParentRunner$3.evaluate(ParentRunner.java:306)
      	at org.junit.runners.BlockJUnit4ClassRunner$1.evaluate(BlockJUnit4ClassRunner.java:100)
      	at org.junit.runners.ParentRunner.runLeaf(ParentRunner.java:366)
      	at org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:103)
      	at org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:63)
      	at org.junit.runners.ParentRunner$4.run(ParentRunner.java:331)
      	at org.junit.runners.ParentRunner$1.schedule(ParentRunner.java:79)
      	at org.junit.runners.ParentRunner.runChildren(ParentRunner.java:329)
      	at org.junit.runners.ParentRunner.access$100(ParentRunner.java:66)
      	at org.junit.runners.ParentRunner$2.evaluate(ParentRunner.java:293)
      	at org.junit.runners.ParentRunner$3.evaluate(ParentRunner.java:306)
      	at org.junit.runners.ParentRunner.run(ParentRunner.java:413)
      	at org.apache.maven.surefire.junit4.JUnit4Provider.execute(JUnit4Provider.java:377)
      	at org.apache.maven.surefire.junit4.JUnit4Provider.executeWithRerun(JUnit4Provider.java:284)
      	at org.apache.maven.surefire.junit4.JUnit4Provider.executeTestSet(JUnit4Provider.java:248)
      	at org.apache.maven.surefire.junit4.JUnit4Provider.invoke(JUnit4Provider.java:167)
      	at org.apache.maven.surefire.booter.ForkedBooter.runSuitesInProcess(ForkedBooter.java:456)
      	at org.apache.maven.surefire.booter.ForkedBooter.execute(ForkedBooter.java:169)
      	at org.apache.maven.surefire.booter.ForkedBooter.run(ForkedBooter.java:595)
      	at org.apache.maven.surefire.booter.ForkedBooter.main(ForkedBooter.java:581)
      
      [INFO] 
      [INFO] Results:
      [INFO] 
      Error:  Errors: 
      Error:    TransactionMetadataIT.transactionMetadata:77 ยป SQL ASNCAP server did not start.
      

      Rerunning the GH action job for Db2 often fixes the failure but perhaps this is indicative of a race condition issue with the test case.

              vjuranek@redhat.com Vojtech Juranek
              ccranfor@redhat.com Chris Cranford
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

                Created:
                Updated:
                Resolved: