chunjun icon indicating copy to clipboard operation
chunjun copied to clipboard

[Bug] binlog-x => mysql-x 异常

Open yqwoe opened this issue 2 years ago • 0 comments

Search before asking

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

What happened

#820 #828 显示已经修复, 本地local模式下还是一样的问题。

create table source (
                        id INT,
                        nowdate STRING,
                        type STRING,
                        num STRING,
                        price STRING,
                        total STRING,
                        PRIMARY KEY (id) NOT ENFORCED
)WITH(
     'connector'='binlog-x',
     'url'='jdbc:mysql://localhost:3306/dlink',
     'host'='localhost',
     'port'='3306',
     'username'='root',
     'password'='123456',
     'table'='data_test',
     'cat'='insert,delete,update'
     );

create table sink (
                      `id` INT,
                      nowdate STRING,
                      type STRING,
                      num STRING,
                      price STRING,
                      total STRING,
                      PRIMARY KEY (id) NOT ENFORCED
)WITH(
     'connector'='mysql-x',
     'url'='jdbc:mysql://localhost:3307/code_starter',
     'schema'='code_starter',
     'username'='root',
     'password'='123456',
     'table-name'='data_test'
     );

insert into sink select * from source;

sh ./bin/chunjun-local.sh -job ./job.sql

What you expected to happen

2022-08-16 14:34:23,812 - 37396 ERROR [destination = example , address = localhost/127.0.0.1:3306 , EventParser] com.dtstack.chunjun.connector.binlog.listener.BinlogAlarmHandler:destination:example[com.alibaba.otter.canal.parse.exception.CanalParseException: com.googlecode.aviator.exception.ExpressionRuntimeException: Execute expression error Caused by: com.googlecode.aviator.exception.ExpressionRuntimeException: Execute expression error at com.googlecode.aviator.ClassExpression.execute(ClassExpression.java:59) at com.alibaba.otter.canal.filter.aviater.AviaterRegexFilter.filter(AviaterRegexFilter.java:74) at com.alibaba.otter.canal.parse.inbound.mysql.dbsync.LogEventConvert.parseRowsEventForTableMeta(LogEventConvert.java:451) at com.alibaba.otter.canal.parse.inbound.mysql.MysqlMultiStageCoprocessor$SimpleParserStage.onEvent(MysqlMultiStageCoprocessor.java:280) at com.alibaba.otter.canal.parse.inbound.mysql.MysqlMultiStageCoprocessor$SimpleParserStage.onEvent(MysqlMultiStageCoprocessor.java:246) at com.lmax.disruptor.BatchEventProcessor.processEvents(BatchEventProcessor.java:168) at com.lmax.disruptor.BatchEventProcessor.run(BatchEventProcessor.java:125) at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511) at java.util.concurrent.FutureTask.run(FutureTask.java:266) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) at java.lang.Thread.run(Thread.java:748) Caused by: java.lang.ExceptionInInitializerError at com.alibaba.otter.canal.filter.aviater.RegexFunction.call(RegexFunction.java:24) at Script_1660631633539_0.execute0(Unknown Source) at com.googlecode.aviator.ClassExpression.execute(ClassExpression.java:53) ... 11 more Caused by: java.lang.RuntimeException: java.lang.NoSuchMethodException: shade.core.com.google.common.collect.MapMaker.softValues() at shade.core.com.google.common.collect.MapMakerHelper.softValues(MapMakerHelper.java:34) at com.alibaba.otter.canal.filter.PatternUtils.(PatternUtils.java:43) ... 14 more Caused by: java.lang.NoSuchMethodException: shade.core.com.google.common.collect.MapMaker.softValues() at java.lang.Class.getDeclaredMethod(Class.java:2130) at shade.core.com.google.common.collect.MapMakerHelper.softValues(MapMakerHelper.java:30) ... 15 more ]

How to reproduce

image

Anything else

No response

Version

1.12_release

Are you willing to submit PR?

  • [ ] Yes I am willing to submit a PR!

Code of Conduct

yqwoe avatar Aug 16 '22 06:08 yqwoe