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

[yqwoe]

Search before asking

• 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

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

• I agree to follow this project's Code of Conduct