chunjun
chunjun copied to clipboard
[Bug] binlog-x => mysql-x 异常
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.
How to reproduce
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
- [X] I agree to follow this project's Code of Conduct