有没有使用tidb的大佬，tidb 断电挂掉无法启动，有啥好的配置参数吗

开发调优
,
1

tidb 断电挂掉无法启动

tidb docker单机版，总是遇到断电文件丢失无法启动。
panic: runtime error: invalid memory address or nil pointer dereference

mysql确从来没遇到过，tidb有什么参数可以启动恢复日志数据吗。
已经有好几个环境的tidb这样挂掉启动不了了
1 个赞
2

为什么服务器会断电呢，UPS呢

3

有更多的日志吗

4

公司的服务器所在地方总停电，没有ups

5
{"log":"[2024/10/24 03:42:35.509 +00:00] [INFO] [coprocessor.go:852] [\"[TIME_COP_PROCESS] resp_time:1.163118691s txnStartTS:453441315984900096 region_id:219874 store_addr:store1 kv_process_ms:1163 kv_wait_ms:0 kv_read_ms:0\"] [conn=2199023255977]\n","stream":"stdout","time":"2024-10-24T03:42:35.509485738Z"} {"log":"[2024/10/24 03:42:36.056 +00:00] [INFO] [coprocessor.go:852] [\"[TIME_COP_PROCESS] resp_time:1.14643809s txnStartTS:453441315984900096 region_id:222762 store_addr:store1 kv_process_ms:1146 kv_wait_ms:0 kv_read_ms:0\"] [conn=2199023255977]\n","stream":"stdout","time":"2024-10-24T03:42:36.056981136Z"} {"log":"[2024/10/24 03:42:36.482 +00:00] [INFO] [coprocessor.go:852] [\"[TIME_COP_PROCESS] resp_time:1.135190559s txnStartTS:453441315984900096 region_id:225652 store_addr:store1 kv_process_ms:1135 kv_wait_ms:0 kv_read_ms:0\"] [conn=2199023255977]\n","stream":"stdout","time":"2024-10-24T03:42:36.482548586Z"} {"log":"[2024/10/24 03:42:36.523 +00:00] [INFO] [coprocessor.go:852] [\"[TIME_COP_PROCESS] resp_time:1.064827523s txnStartTS:453441315984900096 region_id:231424 store_addr:store1 kv_process_ms:1064 kv_wait_ms:0 kv_read_ms:0\"] [conn=2199023255977]\n","stream":"stdout","time":"2024-10-24T03:42:36.524361611Z"} {"log":"[2024/10/24 03:42:36.532 +00:00] [INFO] [coprocessor.go:852] [\"[TIME_COP_PROCESS] resp_time:1.136857055s txnStartTS:453441315984900096 region_id:228538 store_addr:store1 kv_process_ms:1136 kv_wait_ms:0 kv_read_ms:0\"] [conn=2199023255977]\n","stream":"stdout","time":"2024-10-24T03:42:36.532994869Z"} {"log":"[2024/10/24 03:42:36.628 +00:00] [INFO] [coprocessor.go:852] [\"[TIME_COP_PROCESS] resp_time:1.1187041s txnStartTS:453441315984900096 region_id:234314 store_addr:store1 kv_process_ms:1118 kv_wait_ms:0 kv_read_ms:0\"] [conn=2199023255977]\n","stream":"stdout","time":"2024-10-24T03:42:36.628519035Z"} {"log":"[2024/10/24 03:42:37.231 +00:00] [INFO] [coprocessor.go:852] [\"[TIME_COP_PROCESS] resp_time:1.174919679s txnStartTS:453441315984900096 region_id:237194 store_addr:store1 kv_process_ms:1174 kv_wait_ms:0 kv_read_ms:0\"] [conn=2199023255977]\n","stream":"stdout","time":"2024-10-24T03:42:37.232198643Z"} {"log":"[2024/10/24 03:42:37.427 +00:00] [INFO] [coprocessor.go:852] [\"[TIME_COP_PROCESS] resp_time:799.23475ms txnStartTS:453441315984900096 region_id:248754 store_addr:store1 kv_process_ms:799 kv_wait_ms:0 kv_read_ms:0\"] [conn=2199023255977]\n","stream":"stdout","time":"2024-10-24T03:42:37.428122466Z"} {"log":"[2024/10/24 03:42:37.671 +00:00] [INFO] [coprocessor.go:852] [\"[TIME_COP_PROCESS] resp_time:1.188465585s txnStartTS:453441315984900096 region_id:240086 store_addr:store1 kv_process_ms:1188 kv_wait_ms:0 kv_read_ms:0\"] [conn=2199023255977]\n","stream":"stdout","time":"2024-10-24T03:42:37.67132072Z"} {"log":"[2024/10/24 03:42:37.679 +00:00] [INFO] [coprocessor.go:852] [\"[TIME_COP_PROCESS] resp_time:1.147008402s txnStartTS:453441315984900096 region_id:245868 store_addr:store1 kv_process_ms:1146 kv_wait_ms:0 kv_read_ms:0\"] [conn=2199023255977]\n","stream":"stdout","time":"2024-10-24T03:42:37.679977558Z"} {"log":"[2024/10/24 03:42:37.688 +00:00] [INFO] [coprocessor.go:852] [\"[TIME_COP_PROCESS] resp_time:1.164115296s txnStartTS:453441315984900096 region_id:242974 store_addr:store1 kv_process_ms:1164 kv_wait_ms:0 kv_read_ms:0\"] [conn=2199023255977]\n","stream":"stdout","time":"2024-10-24T03:42:37.688603529Z"} {"log":"[2024/10/24 03:42:37.896 +00:00] [INFO] [coprocessor.go:852] [\"[TIME_COP_PROCESS] resp_time:635.026639ms txnStartTS:453441315984900096 region_id:257397 store_addr:store1 kv_process_ms:634 kv_wait_ms:0 kv_read_ms:0\"] [conn=2199023255977]\n","stream":"stdout","time":"2024-10-24T03:42:37.896521462Z"} {"log":"[2024/10/24 03:42:38.307 +00:00] [INFO] [coprocessor.go:852] [\"[TIME_COP_PROCESS] resp_time:878.812159ms txnStartTS:453441315984900096 region_id:257403 store_addr:store1 kv_process_ms:878 kv_wait_ms:0 kv_read_ms:0\"] [conn=2199023255977]\n","stream":"stdout","time":"2024-10-24T03:42:38.307261096Z"} {"log":"[2024/10/24 03:42:38.785 +00:00] [INFO] [coprocessor.go:852] [\"[TIME_COP_PROCESS] resp_time:1.114489723s txnStartTS:453441315984900096 region_id:257421 store_addr:store1 kv_process_ms:1114 kv_wait_ms:0 kv_read_ms:0\"] [conn=2199023255977]\n","stream":"stdout","time":"2024-10-24T03:42:38.786113864Z"} {"log":"[2024/10/24 03:42:38.788 +00:00] [INFO] [coprocessor.go:852] [\"[TIME_COP_PROCESS] resp_time:1.108265739s txnStartTS:453441315984900096 region_id:257425 store_addr:store1 kv_process_ms:1108 kv_wait_ms:0 kv_read_ms:0\"] [conn=2199023255977]\n","stream":"stdout","time":"2024-10-24T03:42:38.788540137Z"} {"log":"[2024/10/24 03:42:38.846 +00:00] [INFO] [coprocessor.go:852] [\"[TIME_COP_PROCESS] resp_time:1.15809532s txnStartTS:453441315984900096 region_id:257435 store_addr:store1 kv_process_ms:1158 kv_wait_ms:0 kv_read_ms:0\"] [conn=2199023255977]\n","stream":"stdout","time":"2024-10-24T03:42:38.847074241Z"} {"log":"[2024/10/24 03:42:39.016 +00:00] [INFO] [coprocessor.go:852] [\"[TIME_COP_PROCESS] resp_time:1.119701708s txnStartTS:453441315984900096 region_id:257443 store_addr:store1 kv_process_ms:1119 kv_wait_ms:0 kv_read_ms:0\"] [conn=2199023255977]\n","stream":"stdout","time":"2024-10-24T03:42:39.0166095Z"} {"log":"[2024/10/24 03:42:39.167 +00:00] [INFO] [coprocessor.go:852] [\"[TIME_COP_PROCESS] resp_time:319.559626ms txnStartTS:453441315984900096 region_id:280924 store_addr:store1 kv_process_ms:319 kv_wait_ms:0 kv_read_ms:0\"] [conn=2199023255977]\n","stream":"stdout","time":"2024-10-24T03:42:39.168010165Z"} {"log":"[2024/10/24 03:42:39.392 +00:00] [INFO] [coprocessor.go:852] [\"[TIME_COP_PROCESS] resp_time:603.631336ms txnStartTS:453441315984900096 region_id:262267 store_addr:store1 kv_process_ms:603 kv_wait_ms:0 kv_read_ms:0\"] [conn=2199023255977]\n","stream":"stdout","time":"2024-10-24T03:42:39.39256877Z"} {"log":"[2024/10/24 03:42:39.435 +00:00] [INFO] [coprocessor.go:852] [\"[TIME_COP_PROCESS] resp_time:1.127767401s txnStartTS:453441315984900096 region_id:257453 store_addr:store1 kv_process_ms:1127 kv_wait_ms:0 kv_read_ms:0\"] [conn=2199023255977]\n","stream":"stdout","time":"2024-10-24T03:42:39.435289495Z"} {"log":"[2024/10/24 03:42:39.897 +00:00] [INFO] [coprocessor.go:852] [\"[TIME_COP_PROCESS] resp_time:1.111395129s txnStartTS:453441315984900096 region_id:259373 store_addr:store1 kv_process_ms:1111 kv_wait_ms:0 kv_read_ms:0\"] [conn=2199023255977]\n","stream":"stdout","time":"2024-10-24T03:42:39.897801357Z"} {"log":"[2024/10/24 03:42:39.910 +00:00] [INFO] [session.go:3314] [\"CRUCIAL OPERATION\"] [conn=2199023255981] [schemaVersion=141462] [cur_db=device_monitor] [sql=\"truncate table py_point_prediction_temp\"] [user=root@%]\n","stream":"stdout","time":"2024-10-24T03:42:39.910712853Z"} {"log":"[2024/10/24 03:42:39.911 +00:00] [INFO] [ddl_worker.go:339] [\"[ddl] add DDL jobs\"] [\"batch count\"=1] [jobs=\"ID:282140, Type:truncate table, State:queueing, SchemaState:none, SchemaID:69, TableID:282137, RowCount:0, ArgLen:1, start time: 2024-10-24 03:42:39.911 +0000 UTC, Err:\u003cnil\u003e, ErrCount:0, SnapshotVersion:0; \"]\n","stream":"stdout","time":"2024-10-24T03:42:39.912055643Z"} {"log":"[2024/10/24 03:42:39.911 +00:00] [INFO] [ddl.go:632] [\"[ddl] start DDL job\"] [job=\"ID:282140, Type:truncate table, State:queueing, SchemaState:none, SchemaID:69, TableID:282137, RowCount:0, ArgLen:1, start time: 2024-10-24 03:42:39.911 +0000 UTC, Err:\u003cnil\u003e, ErrCount:0, SnapshotVersion:0\"] [query=\"truncate table py_point_prediction_temp\"]\n","stream":"stdout","time":"2024-10-24T03:42:39.912083427Z"} {"log":"[2024/10/24 03:42:39.912 +00:00] [INFO] [ddl_worker.go:819] [\"[ddl] run DDL job\"] [worker=\"worker 1, tp general\"] [job=\"ID:282140, Type:truncate table, State:queueing, SchemaState:none, SchemaID:69, TableID:282137, RowCount:0, ArgLen:0, start time: 2024-10-24 03:42:39.911 +0000 UTC, Err:\u003cnil\u003e, ErrCount:0, SnapshotVersion:0\"]\n","stream":"stdout","time":"2024-10-24T03:42:39.912284037Z"} {"log":"[2024/10/24 03:42:39.914 +00:00] [INFO] [domain.go:150] [\"diff load InfoSchema success\"] [currentSchemaVersion=141462] [neededSchemaVersion=141463] [\"start time\"=432.558µs] [phyTblIDs=\"[282137,282139]\"] [actionTypes=\"[2048,2048]\"]\n","stream":"stdout","time":"2024-10-24T03:42:39.914417836Z"} {"log":"[2024/10/24 03:42:39.916 +00:00] [INFO] [ddl_worker.go:1027] [\"[ddl] wait latest schema version changed\"] [worker=\"worker 1, tp general\"] [ver=141463] [\"take time\"=2.374771ms] [job=\"ID:282140, Type:truncate table, State:done, SchemaState:public, SchemaID:69, TableID:282137, RowCount:0, ArgLen:2, start time: 2024-10-24 03:42:39.911 +0000 UTC, Err:\u003cnil\u003e, ErrCount:0, SnapshotVersion:0\"]\n","stream":"stdout","time":"2024-10-24T03:42:39.916278414Z"} {"log":"[2024/10/24 03:42:39.916 +00:00] [INFO] [delete_range.go:448] [\"[ddl] insert into delete-range table\"] [jobID=282140] [elementID=1] [comment=\"table ID is 282137\"]\n","stream":"stdout","time":"2024-10-24T03:42:39.916736712Z"} {"log":"[2024/10/24 03:42:39.917 +00:00] [INFO] [delete_range.go:105] [\"[ddl] add job into delete-range table\"] [jobID=282140] [jobType=\"truncate table\"]\n","stream":"stdout","time":"2024-10-24T03:42:39.917797675Z"} {"log":"[2024/10/24 03:42:39.918 +00:00] [INFO] [ddl_worker.go:475] [\"[ddl] finish DDL job\"] [worker=\"worker 1, tp general\"] [job=\"ID:282140, Type:truncate table, State:synced, SchemaState:public, SchemaID:69, TableID:282137, RowCount:0, ArgLen:2, start time: 2024-10-24 03:42:39.911 +0000 UTC, Err:\u003cnil\u003e, ErrCount:0, SnapshotVersion:0\"]\n","stream":"stdout","time":"2024-10-24T03:42:39.91823265Z"} {"log":"[2024/10/24 03:42:39.919 +00:00] [INFO] [ddl.go:698] [\"[ddl] DDL job is finished\"] [jobID=282140]\n","stream":"stdout","time":"2024-10-24T03:42:39.919298557Z"} {"log":"[2024/10/24 03:42:39.919 +00:00] [INFO] [callback.go:107] [\"performing DDL change, must reload\"]\n","stream":"stdout","time":"2024-10-24T03:42:39.919315974Z"} {"log":"[2024/10/24 03:42:39.919 +00:00] [INFO] [split_region.go:85] [\"split batch regions request\"] [\"split key count\"=1] [\"batch count\"=1] [\"first batch, region ID\"=282742] [\"first split key\"=748000000000044e1b]\n","stream":"stdout","time":"2024-10-24T03:42:39.919699924Z"} {"log":"[2024/10/24 03:42:39.919 +00:00] [INFO] [split_region.go:186] [\"batch split regions complete\"] [\"batch region ID\"=282742] [\"first at\"=748000000000044e1b] [\"first new region left\"=\"{Id:282742 StartKey:748000000000044eff1900000000000000f8 EndKey:748000000000044eff1b00000000000000f8 RegionEpoch:{ConfVer:1 Version:2} Peers:[id:282743 store_id:1 ] EncryptionMeta:\u003cnil\u003e}\"] [\"new region count\"=1]\n","stream":"stdout","time":"2024-10-24T03:42:39.919997766Z"} {"log":"[2024/10/24 03:42:39.919 +00:00] [INFO] [split_region.go:235] [\"split regions complete\"] [\"region count\"=1] [\"region IDs\"=\"[282742]\"]\n","stream":"stdout","time":"2024-10-24T03:42:39.920017636Z"} {"log":"[2024/10/24 03:42:39.944 +00:00] [INFO] [delete_range.go:225] [\"[ddl] delRange emulator complete task\"] [jobID=282140] [elementID=1] [startKey=748000000000044e19] [endKey=748000000000044e1a]\n","stream":"stdout","time":"2024-10-24T03:42:39.944403951Z"} {"log":"[2024/10/24 03:42:43.063 +00:00] [INFO] [coprocessor.go:852] [\"[TIME_COP_PROCESS] resp_time:1.529257637s txnStartTS:453441319477968896 region_id:520 store_addr:store1 kv_process_ms:1529 kv_wait_ms:0 kv_read_ms:0\"] [conn=2199023255955]\n","stream":"stdout","time":"2024-10-24T03:42:43.063867154Z"} {"log":"[2024/10/24 03:42:45.944 +00:00] [INFO] [coprocessor.go:852] [\"[TIME_COP_PROCESS] resp_time:4.334127272s txnStartTS:453441312150257664 region_id:38 store_addr:store1 kv_process_ms:4324 kv_wait_ms:0 kv_read_ms:0\"]\n","stream":"stdout","time":"2024-10-24T03:42:45.944365204Z"} {"log":"panic: runtime error: invalid memory address or nil pointer dereference\n","stream":"stderr","time":"2024-10-24T03:42:46.16843788Z"} {"log":"[signal SIGSEGV: segmentation violation code=0x1 addr=0x58 pc=0x34df04e]\n","stream":"stderr","time":"2024-10-24T03:42:46.168476742Z"} {"log":"\n","stream":"stderr","time":"2024-10-24T03:42:46.168482466Z"} {"log":"goroutine 61399 [running]:\n","stream":"stderr","time":"2024-10-24T03:42:46.168486333Z"} {"log":"github.com/pingcap/badger/table/sstable.(*Table).HasOverlap(0xc0013d6f00, {{0xc006123e18?, 0x40?, 0x200?}, 0xc029be9a80?}, {{0xc006123e30?, 0x80?, 0xc016d6ac00?}, 0xc01e432200?}, 0x0)\n","stream":"stderr","time":"2024-10-24T03:42:46.168490344Z"} {"log":"\u0009/go/pkg/mod/github.com/pingcap/[email protected]/table/sstable/table.go:577 +0x10e\n","stream":"stderr","time":"2024-10-24T03:42:46.168495148Z"} {"log":"github.com/pingcap/badger.(*IteratorOptions).OverlapTable(0x3ad1560?, {0x4326f90?, 0xc0013d6f00?})\n","stream":"stderr","time":"2024-10-24T03:42:46.168499331Z"} {"log":"\u0009/go/pkg/mod/github.com/pingcap/[email protected]/iterator.go:215 +0x70\n","stream":"stderr","time":"2024-10-24T03:42:46.168503585Z"} {"log":"github.com/pingcap/badger.(*IteratorOptions).OverlapTables(0xc029be9d18, {0xc0023adfc0, 0xe5, 0x9004})\n","stream":"stderr","time":"2024-10-24T03:42:46.168507312Z"} {"log":"\u0009/go/pkg/mod/github.com/pingcap/[email protected]/iterator.go:240 +0x266\n","stream":"stderr","time":"2024-10-24T03:42:46.168516956Z"} {"log":"github.com/pingcap/badger.(*levelHandler).appendIterators(0xc000b6e380, {0xc002c39100, 0x3, 0x4}, 0xc029be9d18)\n","stream":"stderr","time":"2024-10-24T03:42:46.168521236Z"} {"log":"\u0009/go/pkg/mod/github.com/pingcap/[email protected]/level_handler.go:409 +0x165\n","stream":"stderr","time":"2024-10-24T03:42:46.168525003Z"} {"log":"github.com/pingcap/badger.(*levelsController).appendIterators(...)\n","stream":"stderr","time":"2024-10-24T03:42:46.168529781Z"} {"log":"\u0009/go/pkg/mod/github.com/pingcap/[email protected]/levels.go:769\n","stream":"stderr","time":"2024-10-24T03:42:46.168533499Z"} {"log":"github.com/pingcap/badger.(*Txn).NewIterator(0xc007d4cab0, {0x0, 0x0, {{0xc006123e18, 0x9, 0x12}, 0xffffffffffffffff}, {{0xc006123e30, 0x9, 0x12}, ...}, ...})\n","stream":"stderr","time":"2024-10-24T03:42:46.168569463Z"} {"log":"\u0009/go/pkg/mod/github.com/pingcap/[email protected]/iterator.go:289 +0x2e9\n","stream":"stderr","time":"2024-10-24T03:42:46.168603754Z"} {"log":"github.com/pingcap/tidb/store/mockstore/unistore/tikv/dbreader.NewIterator(0xc028f88148?, 0x50?, {0xc006123e18?, 0xc02f7a9ae0?, 0x10000c019921b40?}, {0xc006123e30?, 0xc02718f1e0?, 0xc020be0720?})\n","stream":"stderr","time":"2024-10-24T03:42:46.168647217Z"} {"log":"\u0009/home/jenkins/agent/workspace/build-common/go/src/github.com/pingcap/tidb/store/mockstore/unistore/tikv/dbreader/db_reader.go:62 +0xd8\n","stream":"stderr","time":"2024-10-24T03:42:46.168653256Z"} {"log":"github.com/pingcap/tidb/store/mockstore/unistore/tikv/dbreader.(*DBReader).GetIter(...)\n","stream":"stderr","time":"2024-10-24T03:42:46.168667167Z"} {"log":"\u0009/home/jenkins/agent/workspace/build-common/go/src/github.com/pingcap/tidb/store/mockstore/unistore/tikv/dbreader/db_reader.go:130\n","stream":"stderr","time":"2024-10-24T03:42:46.168680067Z"} {"log":"github.com/pingcap/tidb/store/mockstore/unistore/tikv/dbreader.(*DBReader).Scan(0xc031b8ac00, {0xc016d5b4b8, 0x13, 0x13}, {0xc016d5b4d0, 0x14, 0x14}, 0x7fffffffffffffff, 0x64af27891340000, {0x42fc998, ...})\n","stream":"stderr","time":"2024-10-24T03:42:46.168708485Z"} {"log":"\u0009/home/jenkins/agent/workspace/build-common/go/src/github.com/pingcap/tidb/store/mockstore/unistore/tikv/dbreader/db_reader.go:217 +0x12a\n","stream":"stderr","time":"2024-10-24T03:42:46.168722821Z"} {"log":"github.com/pingcap/tidb/store/mockstore/unistore/cophandler.(*tableScanExec).open.func1()\n","stream":"stderr","time":"2024-10-24T03:42:46.168748917Z"} {"log":"\u0009/home/jenkins/agent/workspace/build-common/go/src/github.com/pingcap/tidb/store/mockstore/unistore/cophandler/mpp_exec.go:186 +0x326\n","stream":"stderr","time":"2024-10-24T03:42:46.168754266Z"} {"log":"github.com/pingcap/tidb/util.(*WaitGroupWrapper).Run.func1()\n","stream":"stderr","time":"2024-10-24T03:42:46.168763434Z"} {"log":"\u0009/home/jenkins/agent/workspace/build-common/go/src/github.com/pingcap/tidb/util/wait_group_wrapper.go:33 +0x5a\n","stream":"stderr","time":"2024-10-24T03:42:46.168767447Z"} {"log":"created by github.com/pingcap/tidb/util.(*WaitGroupWrapper).Run\n","stream":"stderr","time":"2024-10-24T03:42:46.168776237Z"} {"log":"\u0009/home/jenkins/agent/workspace/build-common/go/src/github.com/pingcap/tidb/util/wait_group_wrapper.go:31 +0x85\n","stream":"stderr","time":"2024-10-24T03:42:46.168785277Z"} {"log":"[2024/10/24 06:57:08.779 +00:00] [INFO] [cpuprofile.go:115] [\"parallel cpu profiler started\"]\n","stream":"stdout","time":"2024-10-24T06:57:08.780186381Z"} {"log":"[2024/10/24 06:57:08.780 +00:00] [INFO] [printer.go:34] [\"Welcome to TiDB.\"] [\"Release Version\"=v6.1.6-20230629-7c8392e] [Edition=Enterprise] [\"Git Commit Hash\"=7c8392ee21e0c0320bd591720061f6cfc11759bc] [\"Git Branch\"=heads/refs/tags/v6.1.6-20230629-7c8392e] [\"UTC Build Time\"=\"2023-06-29 03:12:54\"] [GoVersion=go1.19.10] [\"Race Enabled\"=false] [\"Check Table Before Drop\"=false] [\"TiKV Min Version\"=v3.0.0-60965b006877ca7234adaced7890d7b029ed1306]\n","stream":"stdout","time":"2024-10-24T06:57:08.780533153Z"} {"log":"[2024/10/24 06:57:08.781 +00:00] [INFO] [printer.go:48] [\"loaded config\"] [config=\"{\\\"host\\\":\\\"0.0.0.0\\\",\\\"advertise-address\\\":\\\"10.15.153.2\\\",\\\"port\\\":4000,\\\"cors\\\":\\\"\\\",\\\"store\\\":\\\"unistore\\\",\\\"path\\\":\\\"/tmp/tidb\\\",\\\"socket\\\":\\\"/tmp/tidb-4000.sock\\\",\\\"lease\\\":\\\"45s\\\",\\\"run-ddl\\\":true,\\\"split-table\\\":true,\\\"token-limit\\\":1000,\\\"oom-use-tmp-storage\\\":true,\\\"tmp-storage-path\\\":\\\"/tmp/0_tidb/MC4wLjAuMDo0MDAwLzAuMC4wLjA6MTAwODA=/tmp-storage\\\",\\\"tmp-storage-quota\\\":-1,\\\"server-version\\\":\\\"\\\",\\\"version-comment\\\":\\\"\\\",\\\"tidb-edition\\\":\\\"\\\",\\\"tidb-release-version\\\":\\\"\\\",\\\"log\\\":{\\\"level\\\":\\\"info\\\",\\\"format\\\":\\\"text\\\",\\\"disable-timestamp\\\":null,\\\"enable-timestamp\\\":null,\\\"disable-error-stack\\\":null,\\\"enable-error-stack\\\":null,\\\"file\\\":{\\\"filename\\\":\\\"\\\",\\\"max-size\\\":300,\\\"max-days\\\":0,\\\"max-backups\\\":0},\\\"enable-slow-log\\\":true,\\\"slow-query-file\\\":\\\"tidb-slow.log\\\",\\\"slow-threshold\\\":300,\\\"expensive-threshold\\\":10000,\\\"record-plan-in-slow-log\\\":1,\\\"query-log-max-len\\\":4096},\\\"instance\\\":{\\\"tidb_general_log\\\":false,\\\"tidb_pprof_sql_cpu\\\":false,\\\"ddl_slow_threshold\\\":300,\\\"tidb_expensive_query_time_threshold\\\":60,\\\"tidb_enable_slow_log\\\":true,\\\"tidb_slow_log_threshold\\\":300,\\\"tidb_record_plan_in_slow_log\\\":1,\\\"tidb_check_mb4_value_in_utf8\\\":true,\\\"tidb_force_priority\\\":\\\"NO_PRIORITY\\\",\\\"tidb_memory_usage_alarm_ratio\\\":0.8,\\\"tidb_enable_collect_execution_info\\\":true,\\\"plugin_dir\\\":\\\"/data/deploy/plugin\\\",\\\"plugin_load\\\":\\\"\\\"},\\\"security\\\":{\\\"skip-grant-table\\\":false,\\\"ssl-ca\\\":\\\"\\\",\\\"ssl-cert\\\":\\\"\\\",\\\"ssl-key\\\":\\\"\\\",\\\"cluster-ssl-ca\\\":\\\"\\\",\\\"cluster-ssl-cert\\\":\\\"\\\",\\\"cluster-ssl-key\\\":\\\"\\\",\\\"cluster-verify-cn\\\":null,\\\"spilled-file-encryption-method\\\":\\\"plaintext\\\",\\\"enable-sem\\\":false,\\\"auto-tls\\\":false,\\\"tls-version\\\":\\\"\\\",\\\"rsa-key-size\\\":4096,\\\"secure-bootstrap\\\":false},\\\"status\\\":{\\\"status-host\\\":\\\"0.0.0.0\\\",\\\"metrics-addr\\\":\\\"\\\",\\\"status-port\\\":10080,\\\"metrics-interval\\\":15,\\\"report-status\\\":true,\\\"record-db-qps\\\":false,\\\"grpc-keepalive-time\\\":10,\\\"grpc-keepalive-timeout\\\":3,\\\"grpc-concurrent-streams\\\":1024,\\\"grpc-initial-window-size\\\":2097152,\\\"grpc-max-send-msg-size\\\":2147483647},\\\"performance\\\":{\\\"max-procs\\\":0,\\\"max-memory\\\":0,\\\"server-memory-quota\\\":0,\\\"memory-usage-alarm-ratio\\\":0.8,\\\"stats-lease\\\":\\\"3s\\\",\\\"stmt-count-limit\\\":5000,\\\"feedback-probability\\\":0,\\\"query-feedback-limit\\\":512,\\\"pseudo-estimate-ratio\\\":0.8,\\\"force-priority\\\":\\\"NO_PRIORITY\\\",\\\"bind-info-lease\\\":\\\"3s\\\",\\\"txn-entry-size-limit\\\":6291456,\\\"txn-total-size-limit\\\":104857600,\\\"tcp-keep-alive\\\":true,\\\"tcp-no-delay\\\":true,\\\"cross-join\\\":true,\\\"distinct-agg-push-down\\\":false,\\\"projection-push-down\\\":false,\\\"max-txn-ttl\\\":3600000,\\\"index-usage-sync-lease\\\":\\\"0s\\\",\\\"plan-replayer-gc-lease\\\":\\\"10m\\\",\\\"gogc\\\":100,\\\"enforce-mpp\\\":false,\\\"stats-load-concurrency\\\":5,\\\"stats-load-queue-size\\\":1000,\\\"enable-stats-cache-mem-quota\\\":false,\\\"committer-concurrency\\\":128,\\\"run-auto-analyze\\\":true},\\\"prepared-plan-cache\\\":{\\\"enabled\\\":true,\\\"capacity\\\":100,\\\"memory-guard-ratio\\\":0.1},\\\"opentracing\\\":{\\\"enable\\\":false,\\\"rpc-metrics\\\":false,\\\"sampler\\\":{\\\"type\\\":\\\"const\\\",\\\"param\\\":1,\\\"sampling-server-url\\\":\\\"\\\",\\\"max-operations\\\":0,\\\"sampling-refresh-interval\\\":0},\\\"reporter\\\":{\\\"queue-size\\\":0,\\\"buffer-flush-interval\\\":0,\\\"log-spans\\\":false,\\\"local-agent-host-port\\\":\\\"\\\"}},\\\"proxy-protocol\\\":{\\\"networks\\\":\\\"\\\",\\\"header-timeout\\\":5},\\\"pd-client\\\":{\\\"pd-server-timeout\\\":3},\\\"tikv-client\\\":{\\\"grpc-connection-count\\\":4,\\\"grpc-keepalive-time\\\":10,\\\"grpc-keepalive-timeout\\\":3,\\\"grpc-compression-type\\\":\\\"none\\\",\\\"commit-timeout\\\":\\\"41s\\\",\\\"async-commit\\\":{\\\"keys-limit\\\":256,\\\"total-key-size-limit\\\":4096,\\\"safe-window\\\":2000000000,\\\"allowed-clock-drift\\\":500000000},\\\"max-batch-size\\\":128,\\\"overload-threshold\\\":200,\\\"max-batch-wait-time\\\":0,\\\"batch-wait-size\\\":8,\\\"enable-chunk-rpc\\\":true,\\\"region-cache-ttl\\\":600,\\\"store-limit\\\":0,\\\"store-liveness-timeout\\\":\\\"1s\\\",\\\"copr-cache\\\":{\\\"capacity-mb\\\":1000},\\\"ttl-refreshed-txn-size\\\":33554432,\\\"resolve-lock-lite-threshold\\\":16},\\\"binlog\\\":{\\\"enable\\\":false,\\\"ignore-error\\\":false,\\\"write-timeout\\\":\\\"15s\\\",\\\"binlog-socket\\\":\\\"\\\",\\\"strategy\\\":\\\"range\\\"},\\\"compatible-kill-query\\\":false,\\\"plugin\\\":{\\\"dir\\\":\\\"/data/deploy/plugin\\\",\\\"load\\\":\\\"\\\"},\\\"pessimistic-txn\\\":{\\\"max-retry-count\\\":256,\\\"deadlock-history-capacity\\\":10,\\\"deadlock-history-collect-retryable\\\":false,\\\"pessimistic-auto-commit\\\":false},\\\"check-mb4-value-in-utf8\\\":true,\\\"max-index-length\\\":3072,\\\"index-limit\\\":64,\\\"table-column-count-limit\\\":1017,\\\"graceful-wait-before-shutdown\\\":0,\\\"alter-primary-key\\\":false,\\\"treat-old-version-utf8-as-utf8mb4\\\":true,\\\"enable-table-lock\\\":false,\\\"delay-clean-table-lock\\\":0,\\\"split-region-max-num\\\":1000,\\\"top-sql\\\":{\\\"receiver-address\\\":\\\"\\\"},\\\"repair-mode\\\":false,\\\"repair-table-list\\\":[],\\\"isolation-read\\\":{\\\"engines\\\":[\\\"tikv\\\",\\\"tiflash\\\",\\\"tidb\\\"]},\\\"max-server-connections\\\":0,\\\"new_collations_enabled_on_first_bootstrap\\\":true,\\\"experimental\\\":{\\\"allow-expression-index\\\":false},\\\"enable-collect-execution-info\\\":true,\\\"skip-register-to-dashboard\\\":false,\\\"enable-telemetry\\\":false,\\\"labels\\\":{},\\\"enable-global-index\\\":false,\\\"deprecate-integer-display-length\\\":false,\\\"enable-enum-length-limit\\\":true,\\\"stores-refresh-interval\\\":60,\\\"enable-tcp4-only\\\":false,\\\"enable-forwarding\\\":false,\\\"max-ballast-object-size\\\":0,\\\"ballast-object-size\\\":0,\\\"enable-global-kill\\\":true,\\\"enable-batch-dml\\\":false,\\\"mem-quota-query\\\":1073741824,\\\"oom-action\\\":\\\"cancel\\\"}\"]\n","stream":"stdout","time":"2024-10-24T06:57:08.781288093Z"} {"log":"[2024/10/24 06:57:08.781 +00:00] [INFO] [main.go:343] [\"disable Prometheus push client\"]\n","stream":"stdout","time":"2024-10-24T06:57:08.781375011Z"} {"log":"[2024/10/24 06:57:08.781 +00:00] [INFO] [store.go:75] [\"new store\"] [path=unistore:///tmp/tidb]\n","stream":"stdout","time":"2024-10-24T06:57:08.781381545Z"} {"log":"[2024/10/24 06:57:08.781 +00:00] [INFO] [systime_mon.go:26] [\"start system time monitor\"]\n","stream":"stdout","time":"2024-10-24T06:57:08.781471135Z"} {"log":"[2024/10/24 06:57:20.018 +00:00] [INFO] [db.go:143] [\"replay wal\"] [\"first key\"=7480000000000063d35f72802386f0e148bb97(453441075590987776)]\n","stream":"stdout","time":"2024-10-24T06:57:20.018819638Z"} {"log":"[2024/10/24 06:57:20.648 +00:00] [INFO] [store.go:81] [\"new store with retry success\"]\n","stream":"stdout","time":"2024-10-24T06:57:20.648499758Z"} {"log":"[2024/10/24 06:57:20.649 +00:00] [INFO] [tidb.go:75] [\"new domain\"] [store=95c1de5e-c8f9-4539-a85d-fef80d1de85d] [\"ddl lease\"=45s] [\"stats lease\"=3s] [\"index usage sync lease\"=0s]\n","stream":"stdout","time":"2024-10-24T06:57:20.649176763Z"} {"log":"[2024/10/24 06:57:20.746 +00:00] [INFO] [domain.go:176] [\"full load InfoSchema success\"] [currentSchemaVersion=0] [neededSchemaVersion=141463] [\"start time\"=93.558311ms]\n","stream":"stdout","time":"2024-10-24T06:57:20.746915425Z"} {"log":"[2024/10/24 06:57:20.746 +00:00] [INFO] [domain.go:437] [\"full load and reset schema validator\"]\n","stream":"stdout","time":"2024-10-24T06:57:20.747033499Z"} {"log":"[2024/10/24 06:57:20.746 +00:00] [INFO] [ddl.go:382] [\"[ddl] start DDL\"] [ID=9cccf4ce-76f8-4fa0-80da-1fb9d22b667f] [runWorker=true]\n","stream":"stdout","time":"2024-10-24T06:57:20.747044615Z"} {"log":"[2024/10/24 06:57:20.747 +00:00] [INFO] [ddl.go:371] [\"[ddl] start delRangeManager OK\"] [\"is a emulator\"=true]\n","stream":"stdout","time":"2024-10-24T06:57:20.7475389Z"} {"log":"[2024/10/24 06:57:20.747 +00:00] [INFO] [delete_range.go:140] [\"[ddl] start delRange emulator\"]\n","stream":"stdout","time":"2024-10-24T06:57:20.747647439Z"} {"log":"[2024/10/24 06:57:20.747 +00:00] [INFO] [ddl_worker.go:165] [\"[ddl] start DDL worker\"] [worker=\"worker 2, tp add index\"]\n","stream":"stdout","time":"2024-10-24T06:57:20.747692706Z"} {"log":"[2024/10/24 06:57:20.747 +00:00] [INFO] [ddl_worker.go:165] [\"[ddl] start DDL worker\"] [worker=\"worker 1, tp general\"]\n","stream":"stdout","time":"2024-10-24T06:57:20.747744435Z"} {"log":"[2024/10/24 06:57:22.265 +00:00] [WARN] [sysvar_cache.go:52] [\"sysvar cache is empty, triggering rebuild\"]\n","stream":"stdout","time":"2024-10-24T06:57:22.266075559Z"} {"log":"[2024/10/24 06:57:22.277 +00:00] [WARN] [misc.go:448] [\"Automatic TLS Certificate creation is disabled\"] []\n","stream":"stdout","time":"2024-10-24T06:57:22.277171762Z"} {"log":"[2024/10/24 06:57:22.277 +00:00] [INFO] [server.go:253] [\"server is running MySQL protocol\"] [addr=0.0.0.0:4000]\n","stream":"stdout","time":"2024-10-24T06:57:22.277375719Z"} {"log":"[2024/10/24 06:57:22.277 +00:00] [INFO] [server.go:267] [\"server is running MySQL protocol\"] [socket=/tmp/tidb-4000.sock]\n","stream":"stdout","time":"2024-10-24T06:57:22.277733041Z"} {"log":"[2024/10/24 06:57:22.277 +00:00] [INFO] [http_status.go:87] [\"for status and metrics report\"] [\"listening on addr\"=0.0.0.0:10080]\n","stream":"stdout","time":"2024-10-24T06:57:22.27776018Z"} {"log":"[2024/10/24 06:57:22.278 +00:00] [INFO] [cpu.go:84] [\"sql cpu collector started\"]\n","stream":"stdout","time":"2024-10-24T06:57:22.278294527Z"} {"log":"[2024/10/24 06:57:22.835 +00:00] [INFO] [coprocessor.go:852] [\"[TIME_COP_PROCESS] resp_time:518.006965ms txnStartTS:453444381514661888 region_id:22 store_addr:store1 kv_process_ms:517 kv_wait_ms:0 kv_read_ms:0\"]\n","stream":"stdout","time":"2024-10-24T06:57:22.835766829Z"} {"log":"[2024/10/24 06:57:24.261 +00:00] [INFO] [info.go:982] [SetTiFlashGroupConfig]\n","stream":"stdout","time":"2024-10-24T06:57:24.262213573Z"} {"log":"[2024/10/24 06:57:30.004 +00:00] [WARN] [2pc.go:1843] [\"schemaLeaseChecker is not set for this transaction\"] [sessionID=2199023255955] [startTS=453444383540248576] [checkTS=453444383540248577]\n","stream":"stdout","time":"2024-10-24T06:57:30.005230917Z"} {"log":"[2024/10/24 06:57:35.952 +00:00] [INFO] [coprocessor.go:852] [\"[TIME_COP_PROCESS] resp_time:2.449017643s txnStartTS:453444384457490432 region_id:520 store_addr:store1 kv_process_ms:2448 kv_wait_ms:0 kv_read_ms:0\"] [conn=2199023255955]\n","stream":"stdout","time":"2024-10-24T06:57:35.953413347Z"} {"log":"[2024/10/24 06:57:47.546 +00:00] [INFO] [coprocessor.go:852] [\"[TIME_COP_PROCESS] resp_time:1.59161855s txnStartTS:453444387721445376 region_id:520 store_addr:store1 kv_process_ms:1591 kv_wait_ms:0 kv_read_ms:0\"] [conn=2199023255955]\n","stream":"stdout","time":"2024-10-24T06:57:47.54675236Z"} {"log":"[2024/10/24 06:57:48.001 +00:00] [INFO] [coprocessor.go:852] [\"[TIME_COP_PROCESS] resp_time:532.203366ms txnStartTS:453444387733241856 region_id:282721 store_addr:store1 kv_process_ms:532 kv_wait_ms:0 kv_read_ms:0\"] [conn=2199023255977]\n","stream":"stdout","time":"2024-10-24T06:57:48.002258994Z"} {"log":"[2024/10/24 06:57:48.653 +00:00] [INFO] [coprocessor.go:852] [\"[TIME_COP_PROCESS] resp_time:1.131428926s txnStartTS:453444387733241856 region_id:156062 store_addr:store1 kv_process_ms:1131 kv_wait_ms:0 kv_read_ms:0\"] [conn=2199023255977]\n","stream":"stdout","time":"2024-10-24T06:57:48.653598128Z"} {"log":"[2024/10/24 06:57:48.664 +00:00] [INFO] [coprocessor.go:852] [\"[TIME_COP_PROCESS] resp_time:1.12014775s txnStartTS:453444387733241856 region_id:161840 store_addr:store1 kv_process_ms:1120 kv_wait_ms:0 kv_read_ms:0\"] [conn=2199023255977]\n","stream":"stdout","time":"2024-10-24T06:57:48.664754012Z"} {"log":"[2024/10/24 06:57:48.675 +00:00] [INFO] [coprocessor.go:852] [\"[TIME_COP_PROCESS] resp_time:1.148937486s txnStartTS:453444387733241856 region_id:158946 store_addr:store1 kv_process_ms:1148 kv_wait_ms:0 kv_read_ms:0\"] [conn=2199023255977]\n","stream":"stdout","time":"2024-10-24T06:57:48.67561608Z"} {"log":"[2024/10/24 06:57:48.676 +00:00] [INFO] [coprocessor.go:852] [\"[TIME_COP_PROCESS] resp_time:1.162363345s txnStartTS:453444387733241856 region_id:153174 store_addr:store1 kv_process_ms:1162 kv_wait_ms:0 kv_read_ms:0\"] [conn=2199023255977]\n","stream":"stdout","time":"2024-10-24T06:57:48.676806015Z"} {"log":"[2024/10/24 06:57:49.174 +00:00] [INFO] [coprocessor.go:852] [\"[TIME_COP_PROCESS] resp_time:1.172479416s txnStartTS:453444387733241856 region_id:164722 store_addr:store1 kv_process_ms:1172 kv_wait_ms:0 kv_read_ms:0\"] [conn=2199023255977]\n","stream":"stdout","time":"2024-10-24T06:57:49.175149155Z"} {"log":"[2024/10/24 06:57:49.734 +00:00] [INFO] [coprocessor.go:852] [\"[TIME_COP_PROCESS] resp_time:1.081265149s txnStartTS:453444387733241856 region_id:167854 store_addr:store1 kv_process_ms:1081 kv_wait_ms:0 kv_read_ms:0\"] [conn=2199023255977]\n","stream":"stdout","time":"2024-10-24T06:57:49.735354736Z"} {"log":"[2024/10/24 06:57:49.777 +00:00] [INFO] [coprocessor.go:852] [\"[TIME_COP_PROCESS] resp_time:1.112109378s txnStartTS:453444387733241856 region_id:170748 store_addr:store1 kv_process_ms:1112 kv_wait_ms:0 kv_read_ms:0\"] [conn=2199023255977]\n","stream":"stdout","time":"2024-10-24T06:57:49.777371584Z"} {"log":"[2024/10/24 06:57:49.782 +00:00] [INFO] [coprocessor.go:852] [\"[TIME_COP_PROCESS] resp_time:1.105843371s txnStartTS:453444387733241856 region_id:176546 store_addr:store1 kv_process_ms:1105 kv_wait_ms:0 kv_read_ms:0\"] [conn=2199023255977]\n","stream":"stdout","time":"2024-10-24T06:57:49.782914727Z"} {"log":"[2024/10/24 06:57:49.788 +00:00] [INFO] [coprocessor.go:852] [\"[TIME_COP_PROCESS] resp_time:1.112367862s txnStartTS:453444387733241856 region_id:173662 store_addr:store1 kv_process_ms:1112 kv_wait_ms:0 kv_read_ms:0\"] [conn=2199023255977]\n","stream":"stdout","time":"2024-10-24T06:57:49.78821819Z"} {"log":"[2024/10/24 06:57:50.379 +00:00] [INFO] [coprocessor.go:852] [\"[TIME_COP_PROCESS] resp_time:1.204512683s txnStartTS:453444387733241856 region_id:179434 store_addr:store1 kv_process_ms:1204 kv_wait_ms:0 kv_read_ms:0\"] [conn=2199023255977]\n","stream":"stdout","time":"2024-10-24T06:57:50.380328604Z"} {"log":"[2024/10/24 06:57:50.396 +00:00] [INFO] [coprocessor.go:852] [\"[TIME_COP_PROCESS] resp_time:313.890413ms txnStartTS:453444388803313664 region_id:280924 store_addr:store1 kv_process_ms:313 kv_wait_ms:0 kv_read_ms:0\"] [conn=2199023255983]\n","stream":"stdout","time":"2024-10-24T06:57:50.396862211Z"} {"log":"[2024/10/24 06:57:50.565 +00:00] [INFO] [coprocessor.go:852] [\"[TIME_COP_PROCESS] resp_time:443.202289ms txnStartTS:453444388808032256 region_id:144 store_addr:store1 kv_process_ms:443 kv_wait_ms:0 kv_read_ms:0\"] [conn=2199023255981]\n","stream":"stdout","time":"2024-10-24T06:57:50.566210658Z"} {"log":"[2024/10/24 06:57:50.948 +00:00] [INFO] [coprocessor.go:852] [\"[TIME_COP_PROCESS] resp_time:1.212684731s txnStartTS:453444387733241856 region_id:182326 store_addr:store1 kv_process_ms:1212 kv_wait_ms:0 kv_read_ms:0\"] [conn=2199023255977]\n","stream":"stdout","time":"2024-10-24T06:57:50.948325573Z"} {"log":"[2024/10/24 06:57:50.977 +00:00] [INFO] [coprocessor.go:852] [\"[TIME_COP_PROCESS] resp_time:1.200076731s txnStartTS:453444387733241856 region_id:185214 store_addr:store1 kv_process_ms:1199 kv_wait_ms:0 kv_read_ms:0\"] [conn=2199023255977]\n","stream":"stdout","time":"2024-10-24T06:57:50.977784141Z"} {"log":"[2024/10/24 06:57:50.997 +00:00] [INFO] [coprocessor.go:852] [\"[TIME_COP_PROCESS] resp_time:1.208888668s txnStartTS:453444387733241856 region_id:190990 store_addr:store1 kv_process_ms:1208 kv_wait_ms:0 kv_read_ms:0\"] [conn=2199023255977]\n","stream":"stdout","time":"2024-10-24T06:57:50.997525131Z"} {"log":"[2024/10/24 06:57:51.006 +00:00] [INFO] [coprocessor.go:852] [\"[TIME_COP_PROCESS] resp_time:1.223835771s txnStartTS:453444387733241856 region_id:188098 store_addr:store1 kv_process_ms:1223 kv_wait_ms:0 kv_read_ms:0\"] [conn=2199023255977]\n","stream":"stdout","time":"2024-10-24T06:57:51.007061871Z"} {"log":"[2024/10/24 06:57:51.624 +00:00] [INFO] [coprocessor.go:852] [\"[TIME_COP_PROCESS] resp_time:1.243549709s txnStartTS:453444387733241856 region_id:193880 store_addr:store1 kv_process_ms:1243 kv_wait_ms:0 kv_read_ms:0\"] [conn=2199023255977]\n","stream":"stdout","time":"2024-10-24T06:57:51.624329375Z"} {"log":"[2024/10/24 06:57:52.111 +00:00] [INFO] [coprocessor.go:852] [\"[TIME_COP_PROCESS] resp_time:1.13376834s txnStartTS:453444387733241856 region_id:199654 store_addr:store1 kv_process_ms:1133 kv_wait_ms:0 kv_read_ms:0\"] [conn=2199023255977]\n","stream":"stdout","time":"2024-10-24T06:57:52.112005514Z"} {"log":"[2024/10/24 06:57:52.139 +00:00] [INFO] [coprocessor.go:852] [\"[TIME_COP_PROCESS] resp_time:1.190833344s txnStartTS:453444387733241856 region_id:196762 store_addr:store1 kv_process_ms:1190 kv_wait_ms:0 kv_read_ms:0\"] [conn=2199023255977]\n","stream":"stdout","time":"2024-10-24T06:57:52.139623694Z"} {"log":"[2024/10/24 06:57:52.173 +00:00] [INFO] [coprocessor.go:852] [\"[TIME_COP_PROCESS] resp_time:1.175776296s txnStartTS:453444387733241856 region_id:202544 store_addr:store1 kv_process_ms:1175 kv_wait_ms:0 kv_read_ms:0\"] [conn=2199023255977]\n","stream":"stdout","time":"2024-10-24T06:57:52.174123193Z"} {"log":"[2024/10/24 06:57:52.198 +00:00] [INFO] [coprocessor.go:852] [\"[TIME_COP_PROCESS] resp_time:1.191689605s txnStartTS:453444387733241856 region_id:205432 store_addr:store1 kv_process_ms:1191 kv_wait_ms:0 kv_read_ms:0\"] [conn=2199023255977]\n","stream":"stdout","time":"2024-10-24T06:57:52.199196978Z"} {"log":"[2024/10/24 06:57:52.760 +00:00] [INFO] [coprocessor.go:852] [\"[TIME_COP_PROCESS] resp_time:1.13583442s txnStartTS:453444387733241856 region_id:208316 store_addr:store1 kv_process_ms:1135 kv_wait_ms:0 kv_read_ms:0\"] [conn=2199023255977]\n","stream":"stdout","time":"2024-10-24T06:57:52.760744701Z"} {"log":"[2024/10/24 06:57:53.246 +00:00] [INFO] [coprocessor.go:852] [\"[TIME_COP_PROCESS] resp_time:1.133914882s txnStartTS:453444387733241856 region_id:211208 store_addr:store1 kv_process_ms:1133 kv_wait_ms:0 kv_read_ms:0\"] [conn=2199023255977]\n","stream":"stdout","time":"2024-10-24T06:57:53.246647859Z"} {"log":"[2024/10/24 06:57:53.255 +00:00] [INFO] [coprocessor.go:852] [\"[TIME_COP_PROCESS] resp_time:1.082043178s txnStartTS:453444387733241856 region_id:216984 store_addr:store1 kv_process_ms:1081 kv_wait_ms:0 kv_read_ms:0\"] [conn=2199023255977]\n","stream":"stdout","time":"2024-10-24T06:57:53.256529837Z"} {"log":"[2024/10/24 06:57:53.267 +00:00] [INFO] [coprocessor.go:852] [\"[TIME_COP_PROCESS] resp_time:1.127807904s txnStartTS:453444387733241856 region_id:214096 store_addr:store1 kv_process_ms:1127 kv_wait_ms:0 kv_read_ms:0\"] [conn=2199023255977]\n","stream":"stdout","time":"2024-10-24T06:57:53.269080424Z"} {"log":"[2024/10/24 06:57:53.358 +00:00] [INFO] [coprocessor.go:852] [\"[TIME_COP_PROCESS] resp_time:1.158749378s txnStartTS:453444387733241856 region_id:219874 store_addr:store1 kv_process_ms:1158 kv_wait_ms:0 kv_read_ms:0\"] [conn=2199023255977]\n","stream":"stdout","time":"2024-10-24T06:57:53.358396518Z"} {"log":"[2024/10/24 06:57:53.919 +00:00] [INFO] [coprocessor.go:852] [\"[TIME_COP_PROCESS] resp_time:4.87583872s txnStartTS:453444381514661888 region_id:38 store_addr:store1 kv_process_ms:4862 kv_wait_ms:0 kv_read_ms:0\"]\n","stream":"stdout","time":"2024-10-24T06:57:53.919867108Z"} {"log":"[2024/10/24 06:57:53.925 +00:00] [INFO] [coprocessor.go:852] [\"[TIME_COP_PROCESS] resp_time:1.1647216s txnStartTS:453444387733241856 region_id:222762 store_addr:store1 kv_process_ms:1164 kv_wait_ms:0 kv_read_ms:0\"] [conn=2199023255977]\n","stream":"stdout","time":"2024-10-24T06:57:53.925663118Z"} {"log":"panic: runtime error: invalid memory address or nil pointer dereference\n","stream":"stderr","time":"2024-10-24T06:57:54.142157779Z"} {"log":"[signal SIGSEGV: segmentation violation code=0x1 addr=0x58 pc=0x34df04e]\n","stream":"stderr","time":"2024-10-24T06:57:54.14220628Z"} {"log":"\n","stream":"stderr","time":"2024-10-24T06:57:54.142212656Z"} {"log":"goroutine 73382 [running]:\n","stream":"stderr","time":"2024-10-24T06:57:54.142216554Z"} {"log":"github.com/pingcap/badger/table/sstable.(*Table).HasOverlap(0xc004bfbb00, {{0xc005fe76e0?, 0x80?, 0x400?}, 0xc01f661a80?}, {{0xc005fe76f8?, 0x80?, 0xc0323fc800?}, 0xc0323fe000?}, 0x0)\n","stream":"stderr","time":"2024-10-24T06:57:54.142220498Z"} {"log":"\u0009/go/pkg/mod/github.com/pingcap/[email protected]/table/sstable/table.go:577 +0x10e\n","stream":"stderr","time":"2024-10-24T06:57:54.142224709Z"} {"log":"github.com/pingcap/badger.(*IteratorOptions).OverlapTable(0x3ad1560?, {0x4326f90?, 0xc004bfbb00?})\n","stream":"stderr","time":"2024-10-24T06:57:54.142233805Z"} {"log":"\u0009/go/pkg/mod/github.com/pingcap/[email protected]/iterator.go:215 +0x70\n","stream":"stderr","time":"2024-10-24T06:57:54.142237723Z"} {"log":"github.com/pingcap/badger.(*IteratorOptions).OverlapTables(0xc01f661d18, {0xc0070c5fc0, 0xe5, 0x9004})\n","stream":"stderr","time":"2024-10-24T06:57:54.142241622Z"} {"log":"\u0009/go/pkg/mod/github.com/pingcap/[email protected]/iterator.go:240 +0x266\n","stream":"stderr","time":"2024-10-24T06:57:54.142245623Z"} {"log":"github.com/pingcap/badger.(*levelHandler).appendIterators(0xc00090f110, {0xc02028c3c0, 0x3, 0x4}, 0xc01f661d18)\n","stream":"stderr","time":"2024-10-24T06:57:54.142249438Z"} {"log":"\u0009/go/pkg/mod/github.com/pingcap/[email protected]/level_handler.go:409 +0x165\n","stream":"stderr","time":"2024-10-24T06:57:54.142262607Z"} {"log":"github.com/pingcap/badger.(*levelsController).appendIterators(...)\n","stream":"stderr","time":"2024-10-24T06:57:54.142267081Z"} {"log":"\u0009/go/pkg/mod/github.com/pingcap/[email protected]/levels.go:769\n","stream":"stderr","time":"2024-10-24T06:57:54.142270984Z"} {"log":"github.com/pingcap/badger.(*Txn).NewIterator(0xc030ca6bd0, {0x0, 0x0, {{0xc005fe76e0, 0x9, 0x12}, 0xffffffffffffffff}, {{0xc005fe76f8, 0x9, 0x12}, ...}, ...})\n","stream":"stderr","time":"2024-10-24T06:57:54.142274822Z"} {"log":"\u0009/go/pkg/mod/github.com/pingcap/[email protected]/iterator.go:289 +0x2e9\n","stream":"stderr","time":"2024-10-24T06:57:54.142278793Z"} {"log":"github.com/pingcap/tidb/store/mockstore/unistore/tikv/dbreader.NewIterator(0xc01f661f78?, 0xc0?, {0xc005fe76e0?, 0xc01f661ec8?, 0x2?}, {0xc005fe76f8?, 0x1000138387c00?, 0x0?})\n","stream":"stderr","time":"2024-10-24T06:57:54.142282736Z"} {"log":"\u0009/home/jenkins/agent/workspace/build-common/go/src/github.com/pingcap/tidb/store/mockstore/unistore/tikv/dbreader/db_reader.go:62 +0xd8\n","stream":"stderr","time":"2024-10-24T06:57:54.142288436Z"} {"log":"github.com/pingcap/tidb/store/mockstore/unistore/tikv/dbreader.(*DBReader).GetIter(...)\n","stream":"stderr","time":"2024-10-24T06:57:54.142295838Z"} {"log":"\u0009/home/jenkins/agent/workspace/build-common/go/src/github.com/pingcap/tidb/store/mockstore/unistore/tikv/dbreader/db_reader.go:130\n","stream":"stderr","time":"2024-10-24T06:57:54.142300293Z"} {"log":"github.com/pingcap/tidb/store/mockstore/unistore/tikv/dbreader.(*DBReader).Scan(0xc0323ccc60, {0xc0323ec1f8, 0x13, 0x13}, {0xc0323ec210, 0x14, 0x14}, 0x7fffffffffffffff, 0x64af54335940000, {0x42fc998, ...})\n","stream":"stderr","time":"2024-10-24T06:57:54.14230522Z"} {"log":"\u0009/home/jenkins/agent/workspace/build-common/go/src/github.com/pingcap/tidb/store/mockstore/unistore/tikv/dbreader/db_reader.go:217 +0x12a\n","stream":"stderr","time":"2024-10-24T06:57:54.142309505Z"} {"log":"github.com/pingcap/tidb/store/mockstore/unistore/cophandler.(*tableScanExec).open.func1()\n","stream":"stderr","time":"2024-10-24T06:57:54.142313429Z"} {"log":"\u0009/home/jenkins/agent/workspace/build-common/go/src/github.com/pingcap/tidb/store/mockstore/unistore/cophandler/mpp_exec.go:186 +0x326\n","stream":"stderr","time":"2024-10-24T06:57:54.142317512Z"} {"log":"github.com/pingcap/tidb/util.(*WaitGroupWrapper).Run.func1()\n","stream":"stderr","time":"2024-10-24T06:57:54.142321915Z"} {"log":"\u0009/home/jenkins/agent/workspace/build-common/go/src/github.com/pingcap/tidb/util/wait_group_wrapper.go:33 +0x5a\n","stream":"stderr","time":"2024-10-24T06:57:54.142325713Z"} {"log":"created by github.com/pingcap/tidb/util.(*WaitGroupWrapper).Run\n","stream":"stderr","time":"2024-10-24T06:57:54.142329703Z"} {"log":"\u0009/home/jenkins/agent/workspace/build-common/go/src/github.com/pingcap/tidb/util/wait_group_wrapper.go:31 +0x85\n","stream":"stderr","time":"2024-10-24T06:57:54.142334057Z"}
6

感谢大佬。 几次断电，好几个环境的tidb都启动不了了。 高斯数据库也断电丢失了文件，但是有安全模式可以启动，丢失文件的库会打不开。tidb是完全启动不了，不知道是否也有其他模式

7

发他们论坛问问，一般数据库都不能直接断电的，mysql直接断电也有概率损坏无法启动。建议弄个ups应急一下起码得关闭系统再断电。