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

增量不同步的小概率事件 #28

Closed
wangfujungit opened this issue Aug 25, 2016 · 1 comment
Closed

增量不同步的小概率事件 #28

wangfujungit opened this issue Aug 25, 2016 · 1 comment

Comments

@wangfujungit
Copy link

  1. 全量操作完以后,继续操作业务,业务代码操作MYBATIS 把 源数据库表USER_UET_CODE_INFO的某字段 VALUE 改变了,YUGONG 重起 ,发现目标数据库对应数据并没有更新,没有日志报错.这个情况概率很低.
    不知道YUGONG 重起前 MLOG$_USER_UET_CODE_INFO 是否有对应的记录 ,重起前忘记查看 MLOG$_USER_UET_CODE_INFO 是否有对应的日志

我想不是事务的问题,如果是事务出错回滚, 通过查询锁表SQL应该会发现有锁表发生,如果有锁表发生 操作的源表时 会出现"假死"状态.
我在群中咨询,有其他朋友也遇到过类似的问题

@wangfujungit
Copy link
Author

通过打印日志,YUGONG 在多线程情况下有问题
我有一种常景经常出现
public class UserUetCodeInfoDataTranslator extends BackTableDataTranslator implements DataTranslator {
。。。
logger.error(infor);
if (ignore) {
record.removeColumnByName("PASSWORD");
}
//ignore==false 保持不变

打印日志经常出现:
com.taobao.yugong.controller.YuGongInstance - retry 1 ,something error happened.
caused by com.taobao.yugong.exception.YuGongException:
miss columns[PASSWORD] and failed Record Data :
OracleIncrementRecord[rowId=ColumnValue [column=ColumnMeta[name=ROWID,type=-8],
value=oracle.sql.ROWID@4a6d0e95],discardType=NONE,opType=U,
schemaName=uetest,tableName=T_LOGIN_ACCOUNT,primaryKeys=[ColumnValue [column=ColumnMeta[name=F_ID,type=-5], value=25300]],
columns=[ColumnValue [column=ColumnMeta[name=LOGIN_STATUS,type=1], value=1],
ColumnValue [column=ColumnMeta[name=LAST_LOAG_TIME,type=93], value=2016-08-26 10:03:00.0],
ColumnValue [column=ColumnMeta[name=UET_CODE,type=1], value=113785],
ColumnValue [column=ColumnMeta[name=LAST_LOGIN_IP,type=12], value=null],
ColumnValue [column=ColumnMeta[name=LAST_LOGIN_DEVICE_ID,type=12], value=null]]]

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

No branches or pull requests

1 participant