请求地址

/v2/webservice/table/rebuild-table-index

请求方法

Post

请求参数说明

tables

示例

{
    "app_id": 2,
    "tables": [
        {
            "zone_id": 134,
            "table_name": "table_list1",
            "key_fields": [
                {
                    "field_name": "uin1"
                }
            ],
            "shard_num":10
        }
    ],
    "speed_rule_conf_data": [
        {
            "start_hour": 1,
            "end_hour": 7,
            "max_speed": 20000
        },
        {
            "start_hour": 7,
            "end_hour": 1,
            "max_speed": 20000
        }
    ],
    "binglog_sync_speed_data": [
        {
            "start_hour": 1,
            "end_hour": 7,
            "max_speed": 20000
        },
        {
            "start_hour": 7,
            "end_hour": 1,
            "max_speed": 20000
        }
    ]
}

返回参数说明

成功返回 example1

{
    "code": 0,
    "request_id": "ae03a0b0-67f9-44b9-9bdb-509f28cb1658",
    "data": [
        {
            "app_id": 2,
            "zone_id": 134,
            "table_name": "table_list1",
            "table_type": 0,
            "task_id":20201
            "result": 0,
            "msg": "success"
        }
    ]
}

成功返回： 任务提交失败

{
    "code": 0,
    "request_id": "ae03a0b0-67f9-44b9-9bdb-509f28cb1658",
    "data": [
        {
            "app_id": 2,
            "zone_id": 134,
            "table_name": "table_list1",
            "table_type": 0,
            "result": -1,
            "msg": "Center Response: the field is primarykey, expect not primarykey. field name:uin1"
        }
    ]
}

失败返回

{
    "request_id": "dda2cbc5-f5df-4b25-8d98-472a0a5c7d58",
    "code": 102,
    "message": "存在冲突任务",
    "debug_message": [
        {
            "app_id": "table_list1",
            "zone_id": 134,
            "table_name": "table_list1",
            "conflictTrans": [
                {
                    "Id": 13414,
                    "AppId": 2,
                    "ZoneId": 134,
                    "Type": 827,
                    "Status": 2,
                    "Reason": 0,
                    "Num": 0,
                    "IdName": "table_list1",
                    "Data": "",
                    "Memo": "DeleteIndex",
                    "CreateUser": "v_jxlin",
                    "CreateTime": "2022-08-16T03:36:48.000Z",
                    "UpdateTime": "2022-08-16T03:36:49.000Z",
                    "CanRedo": 1,
                    "CanSuspend": 1,
                    "CanRollback": 1,
                    "SetId": 1,
                    "ExtendInfo": "",
                    "MaxConcurrentCount": 10
                },
                {
                    "Id": 13425,
                    "AppId": 2,
                    "ZoneId": 134,
                    "Type": 804,
                    "Status": 2,
                    "Reason": 0,
                    "Num": 1,
                    "IdName": "table_list1",
                    "Data": "uin,uin1,level,count|",
                    "Memo": "CreateIndex",
                    "CreateUser": "v_jxlin",
                    "CreateTime": "2022-08-17T02:48:46.000Z",
                    "UpdateTime": "2022-08-17T02:48:46.000Z",
                    "CanRedo": 1,
                    "CanSuspend": 1,
                    "CanRollback": 1,
                    "SetId": 1,
                    "ExtendInfo": "{\"can_rollback\":true,\"allow_ms_switch\":true,\"syncdb_config\":\"{\\\"Target\\\":2,\\\"DBQueueWriteFlag\\\":1,\\\"DBQueueReadFlag\\\":1,\\\"DBURL\\\":\\\"\\\",\\\"DefaultSyncName\\\":\\\"DefaultSyncName\\\",\\\"MaxBlockNumOfTaskQueue\\\":50,\\\"MaxNodeNumPerBlockOfTaskQueue\\\":30000,\\\"TaskQueueBucketNum\\\":0,\\\"SyncMechNum\\\":1,\\\"SyncMech\\\":[{\\\"Name\\\":\\\"DefaultSyncName\\\",\\\"Interval\\\":0,\\\"FieldCount\\\":0,\\\"FieldList\\\":\\\"\\\"}]}\",\"m_bSynConf\":2,\"syncdb_type\":4,\"write_ulog_mode\":0,\"dbcluster_info\":\"{\\\"AppID\\\":2,\\\"ZoneID\\\":134,\\\"TableName\\\":\\\"table_list1\\\",\\\"TableType\\\":0,\\\"DbSources\\\":{\\\"DbSourceNum\\\":1,\\\"DbSource\\\":[{\\\"DbSourceName\\\":\\\"DbSource\\\",\\\"Ip\\\":\\\"\\\",\\\"Port\\\":-1,\\\"User\\\":\\\"\\\",\\\"Passwd\\\":\\\"\\\",\\\"DbName\\\":\\\"\\\",\\\"ConnPoolSize\\\":10,\\\"CharacterSet\\\":\\\"utf8\\\"}]},\\\"DbTables\\\":{\\\"DbTableNum\\\":1,\\\"DbTable\\\":[{\\\"TablePrefix\\\":\\\"\\\",\\\"SubTableCount\\\":0,\\\"ValueFields\\\":{\\\"FieldNum\\\":0},\\\"KeyFields\\\":{\\\"FieldNum\\\":3,\\\"Field\\\":[{\\\"FieldName\\\":\\\"uin1\\\",\\\"DbFieldName\\\":\\\"\\\"},{\\\"FieldName\\\":\\\"uin\\\",\\\"DbFieldName\\\":\\\"\\\"},{\\\"FieldName\\\":\\\"count\\\",\\\"DbFieldName\\\":\\\"\\\"}]},\\\"Deploy\\\":{\\\"SubTableStorePlaceNum\\\":1,\\\"SubTableStorePlace\\\":[{\\\"SubTableIndexStart\\\":0,\\\"SubTableIndexEnd\\\":0,\\\"DbSourceName\\\":\\\"DbSource\\\"}]}}]},\\\"FieldTypeStmts\\\":{\\\"TableTdrFile\\\":\\\"..\\\/..\\\/cfg\\\/tcapdb_1_2_5_1\\\/203abf9021668504160863607e4e9828.tdr\\\",\\\"TableTdrName\\\":\\\"table_list1\\\",\\\"KeyFieldStmts\\\":{\\\"FieldStmtNum\\\":0},\\\"ValueFieldStmts\\\":{\\\"FieldStmtNum\\\":0},\\\"TableIdlFile\\\":\\\"\\\",\\\"IdlType\\\":1},\\\"RouteKeyFields\\\":{\\\"FieldNum\\\":0},\\\"tdbank_conf\\\":{\\\"bid\\\":\\\"\\\",\\\"tid\\\":\\\"\\\",\\\"db_name\\\":\\\"\\\",\\\"string_encode_manner\\\":0,\\\"msgtype\\\":0,\\\"tdbank_addr\\\":\\\"\\\"},\\\"DBType\\\":4,\\\"IndexInfo\\\":{\\\"ReplicationNum\\\":1,\\\"ShardNum\\\":3},\\\"PluginInfo\\\":{\\\"PluginName\\\":\\\"\\\",\\\"PluginFileID\\\":0,\\\"PluginFilePath\\\":\\\"\\\",\\\"WindowSize\\\":0,\\\"AlarmReceivers\\\":\\\"\\\"},\\\"KafkaInfo\\\":{\\\"Instance\\\":\\\"\\\",\\\"Address\\\":\\\"\\\",\\\"Topic\\\":\\\"\\\",\\\"User\\\":\\\"\\\",\\\"Password\\\":\\\"\\\",\\\"IsVpc\\\":0}}\"}",
                    "MaxConcurrentCount": 10
                },
                {
                    "Id": 13404,
                    "AppId": 2,
                    "ZoneId": 12,
                    "Type": 495,
                    "Status": 5,
                    "Reason": 9,
                    "Num": 0,
                    "IdName": "table_list1",
                    "Data": "",
                    "Memo": "USE_NEW_TCAPDB_STRATEGY",
                    "CreateUser": "v_jxlin",
                    "CreateTime": "2022-08-11T01:50:29.000Z",
                    "UpdateTime": "2022-08-11T01:50:44.000Z",
                    "CanRedo": 1,
                    "CanSuspend": 1,
                    "CanRollback": 1,
                    "SetId": 1,
                    "ExtendInfo": "",
                    "MaxConcurrentCount": 10
                }
            ]
        }
    ]
}