Skip to content

SHOW ALL ROUTINE LOAD FOR example_db.o_suborder_load02; #5423

@listenLearning

Description

@listenLearning

I use kafka to import data into doris, the information is as follows
+-------+-------------------+---------------------+-----------+---------+----------------------------+------------+---------+----------------+----------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+-------------------------------------------------------------------------------------------------------------------+------------------------------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+---------------------+----------------------+--------------+----------+
| Id | Name | CreateTime | PauseTime | EndTime | DbName | TableName | State | DataSourceType | CurrentTaskNum | JobProperties | DataSourceProperties | CustomProperties | Statistic | Progress | ReasonOfStateChanged | ErrorLogUrls | OtherMsg |
+-------+-------------------+---------------------+-----------+---------+----------------------------+------------+---------+----------------+----------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+-------------------------------------------------------------------------------------------------------------------+------------------------------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+---------------------+----------------------+--------------+----------+
| 10163 | o_suborder_load02 | 2021-02-25 13:52:35 | NULL | NULL | default_cluster:example_db | o_suborder | RUNNING | KAFKA | 1 | {"partitions":"","columnToColumnExpr":"sub_order_no,old_sub_order_no,order_no,sub_order_status,delivery_order_no,supplier_id,settle_status,sku_count,goods_count,goods_amount,money_off_amount,freight_fee_amount,redpacket_pay_amount,wallet_pay_amount,currency_pay_amount,pay_type_at_delivery,recv_confirm_time,lack_goods,complete_time,theory_volume,order_classify,first_delivery,create_time,update_time,pay_time,distribute_time,etl_insert_time,etl_update_time","maxBatchIntervalS":"20","whereExpr":"","dataFormat":"json","timezone":"Asia/Shanghai","mergeType":"APPEND","format":"json","json_root":"$.data","maxBatchSizeBytes":"209715200","exec_mem_limit":"2147483648","strict_mode":"false","jsonpaths":"["$.sub_order_no","$.old_sub_order_no","$.order_no","$.sub_order_status","$.delivery_order_no","$.supplier_id","$.settle_status","$.sku_count","$.goods_count","$.goods_amount","$.money_off_amount","$.freight_fee_amount","$.redpacket_pay_amount","$.wallet_pay_amount","$.currency_pay_amount","$.pay_type_at_delivery","$.recv_confirm_time","$.lack_goods","$.complete_time","$.theory_volume","$.order_classify","$.first_delivery","$.create_time","$.update_time","$.pay_time","$.distribute_time","$.etl_insert_time","$.etl_update_time"\n]","deleteCondition":"*","desireTaskConcurrentNum":"3","maxErrorNum":"0","strip_outer_array":"true","currentTaskConcurrentNum":"1","execMemLimit":"2147483648","maxBatchRows":"300000"} | {"topic":"mysql-155-binlog-ods_ppy_op_o_suborder","currentKafkaPartitions":"0","brokerList":"172.12.31.155:9092"} | {"group.id":"suborder_0101"} | {"receivedBytes":0,"errorRows":0,"committedTaskNum":0,"loadedRows":0,"loadRowsRate":0,"abortedTaskNum":0,"totalRows":0,"unselectedRows":0,"receivedBytesRate":0,"taskExecuteTimeMs":1} | {"0":"OFFSET_ZERO"} | | | |
+-------+-------------------+---------------------+-----------+---------+----------------------------+------------+---------+----------------+----------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+-------------------------------------------------------------------------------------------------------------------+------------------------------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+---------------------+----------------------+--------------+----------+
But when I went to query, I found that be was all down, and then I went to check the log of be and saw the following message. After I stopped the import task, this error kept appearing. What caused this?
image

Metadata

Metadata

Assignees

No one assigned

    Labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions