问题日志:

[STAT] 2023-11-06 15:33:13: REAL CONSUME THD begin consume data from kafka...
[STAT] 2023-11-06 15:33:15: REAL CONSUME THD begin consume data from kafka...
[LV0] 2023-11-06 15:33:16: get full table list...
[STAT] 2023-11-06 15:33:17: REAL CONSUME THD begin consume data from kafka...
[LV0] 2023-11-06 15:33:19: get full table list...
[STAT] 2023-11-06 15:33:19: REAL CONSUME THD consume data ok, 1 messages, 2 s.
[STAT] 2023-11-06 15:33:19: REAL CONSUME THD total 1 messages, start loading...
[STAT] 2023-11-06 15:33:19: LOAD THD[1] loading REAL message 0, table[odsm_l1_msch.bsas] topic[10020.1213.r] offset[84978] length[35460]...
[LV0] LOAD THD[1]: load mode.
[LV0] LOAD THD[1]: 2023-11-06 15:33:19: table[odsm_l1_msch.bsas] bsd data time[2023-11-06 15:33:09], delay 10 s.
error at file[load_process.c] line[183], ZCBUS-60000: bsdata cols[82] != dict cols[84]
error at file[msg_load_db.c] line[1550], ZCBUS-60000: bsdata cols[82] != dict cols[84]
[ERR] LOAD THD[1], ZCBUS-60000: bsdata cols[82] != dict cols[84], retry normal mode
[LV0] 2023-11-06 15:33:19: connect to pg host=132.252.36.68 port=18801 user=odsm_l1_m password=tgh(Pus26Uxd dbname=mss_odsmdb...
[STAT] 2023-11-06 15:33:19: REAL CONSUME THD begin consume data from kafka...
[INF] Postgresql version: 12.4.
[INF] PostgreSQL 12.4 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 4.8.5 20150623 (Red Hat 4.8.5-39), 64-bit, TelePG
[LV0] normal mode.
[LV0] LOAD THD[1]: 2023-11-06 15:33:19: table[odsm_l1_msch.bsas] bsd data time[2023-11-06 15:33:09], delay 10 s.
[STAT] 2023-11-06 15:33:19: LOAD THD[1] load REAL message 0 ok, length[35460] time[0 s]
     TABLE[odsm_l1_msch.bsas] INSERT[20] UPDATE[0] DELETE[0] DDL[0]
[STAT] 2023-11-06 15:33:20: REAL CONSUME THD consume data ok, 0 messages, 1 s.
[LV0] 2023-11-06 15:33:20: update table information in database...
[STAT] 2023-11-06 15:33:20: REAL CONSUME THD load complete, total 1 messages, 0 errors.
            Data: 0.03 M
          INSERT: 20
          UPDATE: 0
          DELETE: 0
             DDL: 0
    Consume time: 1 s
       Load time: 0 s
      Total time: 1 s
           Speed: 0.03 M/s

描述:

源端和目标字典不一样造成。
目标表多了两列,copy方式转为绑定变量方式进行数据加载

问题处理办法:

  • 忽略
文档更新时间: 2023-11-05 21:58   作者:阿力