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] startup.mode not supported specific #8771

Open
3 tasks done
Quilian opened this issue Feb 20, 2025 · 0 comments
Open
3 tasks done

[Bug] [Oracle-CDC] startup.mode not supported specific #8771

Quilian opened this issue Feb 20, 2025 · 0 comments

Comments

@Quilian
Copy link

Quilian commented Feb 20, 2025

Search before asking

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

What happened

根据官网文档描述,Oracle-cdc配置了startup.mode = specific ,但是启动的时候报错:the value(SPECIFIC) must be one of the optionValues([INITIAL, LATEST])

SeaTunnel Version

2.3.9

SeaTunnel Config

env{
  execution.parallelism = 1
  job.mode = "STREAMING"
  checkpoint.interval =1000
}
source {
  Oracle-CDC {
      username = "xx"
      password = "xxx"
      database-names = ["db1"]
      schema-names = ["sc1"]
      table-names = ["db1.sc1.table1"]
      startup.mode = specific
      startup.specific-offset.file = "/OSdata/oradata_ncdb/db1/redo03.log"
      startup.specific-offset.pos = 14316
      connect.timeout.ms = 60000
      connect.max-retries = 5
      base-url = "jdbc:oracle:thin:@xx.xxx.xxx.xx:xxxx:db1"
    }
}
sink {
  Doris {
      fenodes = "xx.xxx.xx.xxx:xxxx"
      username = xxx
      password = "xxxxx"
      database = "xxx"
      #table = "xxxx"
      sink.enable-2pc = "false"
      sink.label-prefix = "xxx_111"
      sink.enable-delete = "true"
      doris.config = {
            format="json"
            read_json_by_line="true"
        }
    }
}

Running Command

bin/seatunnel.sh -c xx.template -n jobname --async

Error Exception

2025-02-20 15:05:13,055 ERROR [o.a.s.c.s.SeaTunnel           ] [main] - Exception StackTrace:org.apache.seatunnel.core.starter.exception.CommandExecuteException: SeaTunnel job executed failed
        at org.apache.seatunnel.core.starter.seatunnel.command.ClientExecuteCommand.execute(ClientExecuteCommand.java:228)
        at org.apache.seatunnel.core.starter.SeaTunnel.run(SeaTunnel.java:40)
        at org.apache.seatunnel.core.starter.seatunnel.SeaTunnelClient.main(SeaTunnelClient.java:34)
Caused by: org.apache.seatunnel.api.table.factory.FactoryException: ErrorCode:[API-06], ErrorDescription:[Factory initialize failed] - Unable to create a source for identifier 'Oracle-CDC'.
        at org.apache.seatunnel.api.table.factory.FactoryUtil.restoreAndPrepareSource(FactoryUtil.java:119)
        at org.apache.seatunnel.api.table.factory.FactoryUtil.createAndPrepareSource(FactoryUtil.java:68)
        at org.apache.seatunnel.engine.core.parse.MultipleTableJobConfigParser.parseSource(MultipleTableJobConfigParser.java:404)
        at org.apache.seatunnel.engine.core.parse.MultipleTableJobConfigParser.parse(MultipleTableJobConfigParser.java:236)
        at org.apache.seatunnel.engine.client.job.ClientJobExecutionEnvironment.getLogicalDag(ClientJobExecutionEnvironment.java:123)
        at org.apache.seatunnel.engine.client.job.ClientJobExecutionEnvironment.execute(ClientJobExecutionEnvironment.java:191)
        at org.apache.seatunnel.core.starter.seatunnel.command.ClientExecuteCommand.execute(ClientExecuteCommand.java:165)
        ... 2 more
Caused by: org.apache.seatunnel.api.configuration.util.OptionValidationException: ErrorCode:[API-02], ErrorDescription:[Option item validate failed] - These options('startup.mode') are SingleChoiceOption, the value(SPECIFIC) must be one of the optionValues([INITIAL, LATEST]).
        at org.apache.seatunnel.api.configuration.util.ConfigValidator.validateSingleChoice(ConfigValidator.java:89)
        at org.apache.seatunnel.api.configuration.util.ConfigValidator.validate(ConfigValidator.java:64)
        at org.apache.seatunnel.api.table.factory.FactoryUtil.createAndPrepareSource(FactoryUtil.java:129)
        at org.apache.seatunnel.api.table.factory.FactoryUtil.restoreAndPrepareSource(FactoryUtil.java:91)
        ... 8 more

Zeta or Flink or Spark Version

zeta

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

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

No branches or pull requests

2 participants