【已解决】Doris1.2.7升级2.0.0 后streamload写入报错

Viewed 79
  • 报错信息
Stream load failed. status: 200 load result: {
    "TxnId": 1560217,
    "Label": "88fe1e9b-caa2-44be-9097-1f22046b0de4",
    "Comment": "",
    "TwoPhaseCommit": "false",
    "Status": "Fail",
    "Message": "[INTERNAL_ERROR]Function now get failed, expr is VectorizedFnCall[now](arguments=,return=DateTime) and return type is DateTime.",
    "NumberTotalRows": 0,
    "NumberLoadedRows": 0,
    "NumberFilteredRows": 0,
    "NumberUnselectedRows": 0,
    "LoadBytes": 1905,
    "LoadTimeMs": 16,
    "BeginTxnTimeMs": 0,
    "StreamLoadPutTimeMs": 4,
    "ReadDataTimeMs": 0,
    "WriteDataTimeMs": 6,
    "CommitAndPublishTimeMs": 0
}


  • ddl
CREATE TABLE `xxxx`
(
    `unique_no`      varchar(96)  NULL COMMENT '原数据唯一键',
    `event_time`     datetime     NULL COMMENT '事件时间',
    `id`             bigint(20)   NULL COMMENT '主键',
    `doc_code`       varchar(144)  NULL COMMENT '模型编码',
    `doc_unique_no`  varchar(64)  NULL COMMENT '业务唯一键',
    `event`          varchar(96)  NULL COMMENT '单据的事件',
    `version`        varchar(96)  NULL COMMENT '事件版本',
    `ack_type`       varchar(96)  NULL COMMENT '确认类型',
    `data_source`    varchar(96)  NULL COMMENT '数据来源系统标识',
    `data`           text         NULL COMMENT '具体数据',
    `data_status`    varchar(96)  NULL COMMENT '数据状态',
    `status_message` varchar(2000) NULL COMMENT '处理状态信息',
    `event_date`     varchar(30)  NULL COMMENT '事件日期(天)',
    `is_test`        tinyint(4)   NULL COMMENT '测试标识 0:非测试 1:测试',
    `deleted`        tinyint(4)   NULL COMMENT '删除标识 0:未删除 1:已删除',
    `create_time`    datetime     NULL COMMENT '创建时间',
    `update_time`    datetime     NULL COMMENT '更新时间',
    `data_version`   bigint(20)  null COMMENT '数据版本',
    `write_time`     datetime     null DEFAULT current_timestamp COMMENT 'doris更新时间'

) ENGINE = OLAP UNIQUE KEY(`unique_no`,`event_time`,`id`)
COMMENT 'xxxx'
DISTRIBUTED BY HASH(`unique_no`) BUCKETS 32
PROPERTIES (
"replication_allocation" = "tag.location.default: 3",
"in_memory" = "false",
"storage_format" = "V2",
 "enable_unique_key_merge_on_write" = "true"
);
  • 错误描述
    版本升级之后 旧表写入报错,都为Function now get failed, expr is VectorizedFnCall[now]...
    其中一个库 重建表之后 正常了,但是另外一个镜像库 的表重建之后依然无法恢复
1 Answers

现在已经没有问题了,应该是当时元数据同步的问题