所有的运行状态都是正常的,就是不做复制工作,日志报错Caused by: java.util.concurrent.ExecutionException: com.alibaba.otter.node.etl.load.exception.LoadException: com.alibaba.otter.node.etl.load.exception.LoadException: com.alibaba.otter.node.etl.load.exception.LoadException: java.lang.ClassCastException

9nvpjoqh  于 2022-10-25  发布在  Java
关注(0)|答案(2)|浏览(167)

大家好: 源和目标的表结构一样:

gz5pxeao

gz5pxeao1#

CREATE TABLE author_117 (
id int(11) NOT NULL AUTO_INCREMENT COMMENT 'ID',
user_name varchar(20) NOT NULL COMMENT 'xx',
password varchar(32) NOT NULL DEFAULT '' xxx',
name varchar(50) NOT NULL COMMENT 'xxx',
nickname varchar(30) NOT NULL COMMENT 'xxx',
pen_name varchar(50) NOT NULL COMMENT 'xxx',
email varchar(50) NOT NULL COMMENT 'xxx',
address varchar(255) NOT NULL COMMENT 'xxx',
qq varchar(15) DEFAULT NULL COMMENT 'xx',
msn varchar(50) DEFAULT NULL COMMENT 'msn',
certificate_type binary(2) NOT NULL COMMENT 'xxx',
certificate_no varchar(32) NOT NULL COMMENT 'xxx',
phone varchar(15) DEFAULT NULL COMMENT 'xxxx',
about mediumtext COMMENT 'xxx',
bank_account varchar(30) DEFAULT NULL COMMENT 'xx',
bank_address varchar(200) DEFAULT NULL COMMENT 'ddd',
bank_user varchar(50) DEFAULT NULL COMMENT 'dds',
status varchar(32) NOT NULL COMMENT 'sss',
province varchar(100) NOT NULL COMMENT 'sss',
county varchar(100) NOT NULL COMMENT 'sss',
register_date date NOT NULL DEFAULT '0000-00-00' COMMENT 'ssss',
wap_userid int(11) DEFAULT NULL COMMENT 'sss',
is_modify int(11) DEFAULT '1' COMMENT 'sss',
bank_type varchar(50) DEFAULT '' COMMENT 'sss',
last_id int(11) DEFAULT '-1' COMMENT 'sss',
platform varchar(32) NOT NULL DEFAULT 'web' COMMENT 'sss',
PRIMARY KEY ( id ),
UNIQUE KEY u_author_un ( user_name ),
UNIQUE KEY u_author_nn ( nickname ),
KEY inx_is_modify ( is_modify ),
KEY inx_last_id ( last_id )
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8

pid:2 nid:1 exception:setl:com.alibaba.otter.node.etl.load.exception.LoadException: java.util.concurrent.ExecutionException: com.alibaba.otter.node.etl.load.exception.LoadException: com.alibaba.otter.node.etl.load.exception.LoadException: com.alibaba.otter.node.etl.load.exception.LoadException: java.lang.ClassCastException
  • PairId: 12 , TableId: 8 , EventType : I , Time : 1592903846000
  • Consistency : , Mode :

---Pks
EventColumn[index=0,columnType=4,columnName=id,columnValue=52281,isNull=false,isKey=true,isUpdate=true]
---oldPks

---Columns
EventColumn[index=1,columnType=12,columnName=user_name,columnValue=td162593276,isNull=false,isKey=false,isUpdate=true]
EventColumn[index=2,columnType=12,columnName=password,columnValue=bd7e55748951edebbdd315595bfd95bc,isNull=false,isKey=false,isUpdate=true]
EventColumn[index=3,columnType=12,columnName=name,columnValue=胡生,isNull=false,isKey=false,isUpdate=true]
EventColumn[index=4,columnType=12,columnName=nickname,columnValue=td162593276,isNull=false,isKey=false,isUpdate=true]
EventColumn[index=5,columnType=12,columnName=pen_name,columnValue=月始,isNull=false,isKey=false,isUpdate=true]
EventColumn[index=6,columnType=12,columnName=email,columnValue=,isNull=false,isKey=false,isUpdate=true]
EventColumn[index=7,columnType=12,columnName=address,columnValue=,isNull=false,isKey=false,isUpdate=true]
EventColumn[index=8,columnType=12,columnName=qq,columnValue=293203333,isNull=false,isKey=false,isUpdate=true]
EventColumn[index=9,columnType=12,columnName=msn,columnValue=,isNull=true,isKey=false,isUpdate=true]
EventColumn[index=10,columnType=2004,columnName=certificate_type,columnValue=,isNull=false,isKey=false,isUpdate=true]
EventColumn[index=11,columnType=12,columnName=certificate_no,columnValue=,isNull=false,isKey=false,isUpdate=true]
EventColumn[index=12,columnType=12,columnName=phone,columnValue=1588888888,isNull=false,isKey=false,isUpdate=true]
EventColumn[index=13,columnType=-4,columnName=about,columnValue=,isNull=true,isKey=false,isUpdate=true]
EventColumn[index=14,columnType=12,columnName=bank_account,columnValue=,isNull=true,isKey=false,isUpdate=true]
EventColumn[index=15,columnType=12,columnName=bank_address,columnValue=,isNull=true,isKey=false,isUpdate=true]
EventColumn[index=16,columnType=12,columnName=bank_user,columnValue=,isNull=true,isKey=false,isUpdate=true]
EventColumn[index=17,columnType=12,columnName=status,columnValue=,isNull=false,isKey=false,isUpdate=true]
EventColumn[index=18,columnType=12,columnName=province,columnValue=,isNull=false,isKey=false,isUpdate=true]
EventColumn[index=19,columnType=12,columnName=county,columnValue=,isNull=false,isKey=false,isUpdate=true]
EventColumn[index=20,columnType=91,columnName=register_date,columnValue=2020-06-23,isNull=false,isKey=false,isUpdate=true]
EventColumn[index=21,columnType=4,columnName=wap_userid,columnValue=161641469,isNull=false,isKey=false,isUpdate=true]
EventColumn[index=22,columnType=4,columnName=is_modify,columnValue=1,isNull=false,isKey=false,isUpdate=true]
EventColumn[index=23,columnType=12,columnName=bank_type,columnValue=,isNull=false,isKey=false,isUpdate=true]
EventColumn[index=24,columnType=4,columnName=last_id,columnValue=-1,isNull=false,isKey=false,isUpdate=true]
EventColumn[index=25,columnType=12,columnName=platform,columnValue=web,isNull=false,isKey=false,isUpdate=true]
---Sql
insert into original_author . author_117 ( user_name , password , name , nickname , pen_name , email , address , qq , msn , certificate_type , certificate_no , phone , about , bank_account , bank_address , bank_user , status , province , county , register_date , wap_userid , is_modify , bank_type , last_id , platform , id ) values (? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ?) on duplicate key update user_name =values( user_name ) , password =values( password ) , name =values( name ) , nickname =values( nickname ) , pen_name =values( pen_name ) , email =values( email ) , address =values( address ) , qq =values( qq ) , msn =values( msn ) , certificate_type =values( certificate_type ) , certificate_no =values( certificate_no ) , phone =values( phone ) , about =values( about ) , bank_account =values( bank_account ) , bank_address =values( bank_address ) , bank_user =values( bank_user ) , status =values( status ) , province =values( province ) , county =values( county ) , register_date =values( register_date ) , wap_userid =values( wap_userid ) , is_modify =values( is_modify ) , bank_type =values( bank_type ) , last_id =values( last_id ) , platform =values( platform ) , id =values( id )

Caused by: java.util.concurrent.ExecutionException: com.alibaba.otter.node.etl.load.exception.LoadException: com.alibaba.otter.node.etl.load.exception.LoadException: com.alibaba.otter.node.etl.load.exception.LoadException: java.lang.ClassCastException
mm9b1k5b

mm9b1k5b2#

老报错,复制就停止了,但是显示还在复制中。

相关问题