Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

[Bug] [Oracle-cdc] oracle not support pdb mode #6594

Closed
2 of 3 tasks
Quilian opened this issue Mar 27, 2024 · 3 comments · May be fixed by #6647
Closed
2 of 3 tasks

[Bug] [Oracle-cdc] oracle not support pdb mode #6594

Quilian opened this issue Mar 27, 2024 · 3 comments · May be fixed by #6647

Comments

@Quilian
Copy link

Quilian commented Mar 27, 2024

Search before asking

  • I had searched in the issues and found no similar issues.

What happened

oracle数据库是19c版本,开启了CDB+PDB模式,根据官网oracle-cdc使用方法先创建了c##账号,并且使用CDB的表增量同步成功,但是使用PDB的表只能全量同步,增量同步失败,同步任务没有任何报错,正常运行。

SeaTunnel Version

2.3.4

SeaTunnel Config

env{
  execution.parallelism = 1
  job.mode = "STREAMING"
  checkpoint.interval =3000
  execution.checkpoint.interval = 10000
  #execution.checkpoint.data-uri = "hdfs://localhost:9000/checkpoint"
}
source {
  Oracle-CDC {
      username = "C##DBZUSER"
      password = "dbz"
      database-names = ["SJZT"]
      schema-names = ["TEST"]
      table-names = ["SJZT.TEST.TAB1"]
      debezium = {
        database.pdb.name=TEST
        }
      base-url = "jdbc:oracle:thin:system/oracle@10.10.xxx.x:1521/TEST"
      source.reader.close.timeout = 120000
    }
}


sink {
            Doris {
      fenodes = "10.10.xxx.xxx:8030"
      username = root
      password = "xxx"
      database = "test_db"
      sink.enable-2pc = "false"
      sink.label-prefix = "orms"
      sink.enable-delete = "true"
      doris.config = {
            format="json"
            read_json_by_line="true"
        }
    }
}

Running Command

使用集群模式:
../../bin/seatunnel.sh -c ./test-sjzt-table38-2.template

Error Exception

任务日志没有报错,集群日志没有报错,只是增量数据同步不成功。

Zeta or Flink or Spark Version

No response

Java or Scala Version

No response

Screenshots

No response

Are you willing to submit PR?

  • Yes I am willing to submit a PR!

Code of Conduct

@Quilian Quilian added the bug label Mar 27, 2024
@hailin0 hailin0 changed the title [Bug] [Oracle-cdc] oracle启动了CDB模式,PDB的表可以全量同步,但增量同步失败,同步任务不报错。 [Bug] [Oracle-cdc] oracle not support pdb Mar 27, 2024
@hailin0 hailin0 changed the title [Bug] [Oracle-cdc] oracle not support pdb [Bug] [Oracle-cdc] oracle not support pdb mode Mar 27, 2024
@Carl-Zhou-CN
Copy link
Member

I have located the problem and will fix it later

Copy link

github-actions bot commented May 4, 2024

This issue has been automatically marked as stale because it has not had recent activity for 30 days. It will be closed in next 7 days if no further activity occurs.

@github-actions github-actions bot added the stale label May 4, 2024
Copy link

This issue has been closed because it has not received response for too long time. You could reopen it if you encountered similar problems in the future.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

Successfully merging a pull request may close this issue.

3 participants