No errors but not capturing events

[thiagoananias]

Hello!

i'am using Kafka with Kubernetes (https://github.com/confluentinc/cp-helm-charts)

And i configured the plugin with success because the Kafka Connect process executes with no error and the status is running! (When i misconfig the connection os user name it gives error)

curl --location --request POST 'http://kafka-confluent-cp-kafka-connect.kafka.svc.cluster.local:8083/connectors' \
--header 'Content-Type: application/json' \
--data-raw '{
    "name": "oracle-cdc-final",
    "config": {
        "connector.class": "com.ecer.kafka.connect.oracle.OracleSourceConnector",
        "db.hostname": "HOST",
        "db.port": "1521",
        "db.user": "user",
        "db.user.password": "pass",
        "db.name.alias": "KAFKAPOC",
        "db.name": "KAFKAPOC",
        "db.fetch.size": "1",
        "tasks.max": "1",
        "topic": "cdc-oracle",
        "table.whitelist": "MY_SCHEMA.MY_TABLE",
        "table.blacklist": "",
        "parse.dml.data": "true",
        "reset.offset": "true",
        "multitenant": "false"
    }
}'

But the problem is... nothing happens, no data comes into the topic 'cdc-oracle'

1. The data that is already there should come right? Because i put "reset.offset" = true
2. I insert data on the table after the agent is running but it also does not reflects on the topic

Regards

[thiagoananias]

I'm using Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production

[thiagoananias]

After a 30 minutes running without feedback it chashes with this erros

org.apache.kafka.connect.errors.ConnectException: Error at database tier, Please check : java.sql.SQLException: ORA-04036: PGA memory used by the instance exceeds PGA_AGGREGATE_LIMIT\n\n\tat com.ecer.kafka.connect.oracle.OracleSourceTask.start(OracleSourceTask.java:219)\n\tat org.apache.kafka.connect.runtime.WorkerSourceTask.execute(WorkerSourceTask.java:232)\n\tat org.apache.kafka.connect.runtime.WorkerTask.doRun(WorkerTask.java:185)\n\tat org.apache.kafka.connect.runtime.WorkerTask.run(WorkerTask.java:235)\n\tat java.base/java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:515)\n\tat java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264)\n\tat java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128)\n\tat java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628)\n\tat java.base/java.lang.Thread.run(Thread.java:834)\n