Error in Data Export with Dumpling II

Translated
1

Note:
This topic has been translated from a Chinese forum by GPT and might contain errors.

Original topic: dumpling导出数据报错二

| username: jingyesi3401

【TiDB Usage Environment】Production, Testing Environment

【TiDB Version】v5.1.0

【Encountered Problem】Using the new version v6.1.0 dumpling command to export large table data, although the data was eventually exported successfully, there were errors in the export log, and the export speed was relatively slow. Not sure what the issue is, and currently testing by adjusting the following parameters.

  1. Error log as follows:
    nohup.out_produce_param_20220714_1.log (27.1 KB)

  2. Adjusted the following parameter values:
    set global connect_timeout=3600;
    set global net_read_timeout=3600;
    set global net_write_timeout=3600;

2
| username: 啦啦啦啦啦 | Original post link

The first error
[errorVerbose="Error 1146: Table ‘information_schema.placement_policies’ doesn’t exist
sql: select distinct policy_name from
It seems that Dumpling in version 6.1 will query information_schema.placement_policies to determine if a placement policy is used. This dictionary table does not exist in version 5.1.

The second error
[“cannot execute query”] [retryTime=1] [sql=“SELECT id FROM yifu_produce.produce_param TABLESAMPLE REGIONS() ORDER BY id”] [args=null] [error=“sql: SELECT id FROM yifu_produce.produce_param TABLESAMPLE REGIONS() ORDER BY id, args: : invalid connection”]
is very similar to this post, you can refer to it

3
| username: system | Original post link

This topic will be automatically closed 60 days after the last reply. No new replies are allowed.