修改列数据类型decimal为int，修改成功，tidb不能查询表了，但mysql可以，请问是这么回事？tidb版本4.0.5
tidb操作
mysql操作
你好
- 请正确选择帖子标签和分类。
- 辛苦看下
时间点在 tidb log 中是否有详细的信息
tail -n 100 tidb_stderr.log
/home/jenkins/agent/workspace/tidb_v4.0.2/go/pkg/mod/google.golang.org/grpc@v1.26.0/internal/transport/http2_client.go:295 +0x16cd
goroutine 367463 [IO wait, 92 minutes]:
internal/poll.runtime_pollWait(0x7f6e74bb3498, 0x72, 0xffffffffffffffff)
/usr/local/go/src/runtime/netpoll.go:184 +0x55
internal/poll.(*pollDesc).wait(0xc00101b598, 0x72, 0x8000, 0x8000, 0xffffffffffffffff)
/usr/local/go/src/internal/poll/fd_poll_runtime.go:87 +0x45
internal/poll.(*pollDesc).waitRead(…)
/usr/local/go/src/internal/poll/fd_poll_runtime.go:92
internal/poll.(*FD).Read(0xc00101b580, 0xc0018b4000, 0x8000, 0x8000, 0x0, 0x0, 0x0)
/usr/local/go/src/internal/poll/fd_unix.go:169 +0x1cf
net.(*netFD).Read(0xc00101b580, 0xc0018b4000, 0x8000, 0x8000, 0x0, 0x800000601, 0x0)
/usr/local/go/src/net/fd_unix.go:202 +0x4f
net.(*conn).Read(0xc0005d4dc0, 0xc0018b4000, 0x8000, 0x8000, 0x0, 0x0, 0x0)
/usr/local/go/src/net/net.go:184 +0x68
bufio.(*Reader).Read(0xc001932120, 0xc0018c8d58, 0x9, 0x9, 0xc001725de0, 0x111ad1a, 0xc0016bef60)
/usr/local/go/src/bufio/bufio.go:226 +0x26a
io.ReadAtLeast(0x36c4a80, 0xc001932120, 0xc0018c8d58, 0x9, 0x9, 0x9, 0x116f8d0, 0xc0016bef60, 0xc001725e18)
/usr/local/go/src/io/io.go:310 +0x87
io.ReadFull(…)
/usr/local/go/src/io/io.go:329
golang.org/x/net/http2.readFrameHeader(0xc0018c8d58, 0x9, 0x9, 0x36c4a80, 0xc001932120, 0x0, 0xc000000000, 0x1000000011225d8, 0xc00161f820)
/home/jenkins/agent/workspace/tidb_v4.0.2/go/pkg/mod/golang.org/x/net@v0.0.0-20200324143707-d3edc9973b7e/http2/frame.go:237 +0x87
golang.org/x/net/http2.(*Framer).ReadFrame(0xc0018c8d20, 0xc00464e540, 0x52103a0, 0x0, 0x0)
/home/jenkins/agent/workspace/tidb_v4.0.2/go/pkg/mod/golang.org/x/net@v0.0.0-20200324143707-d3edc9973b7e/http2/frame.go:492 +0xa1
google.golang.org/grpc/internal/transport.(*http2Client).reader(0xc001cf9500)
/home/jenkins/agent/workspace/tidb_v4.0.2/go/pkg/mod/google.golang.org/grpc@v1.26.0/internal/transport/http2_client.go:1264 +0x183
created by google.golang.org/grpc/internal/transport.newHTTP2Client
/home/jenkins/agent/workspace/tidb_v4.0.2/go/pkg/mod/google.golang.org/grpc@v1.26.0/internal/transport/http2_client.go:300 +0xd23
goroutine 15493195 [semacquire, 2 minutes]:
sync.runtime_Semacquire(0xc0022c2b98)
/usr/local/go/src/runtime/sema.go:56 +0x42
sync.(*WaitGroup).Wait(0xc0022c2b90)
/usr/local/go/src/sync/waitgroup.go:130 +0x64
github.com/pingcap/tidb/executor.(*HashAggExec).waitFinalWorkerAndCloseFinalOutput(0xc000558d00, 0xc0022c2b90)
/home/jenkins/agent/workspace/tidb_v4.0.2/go/src/github.com/pingcap/tidb/executor/aggregate.go:654 +0x2b
created by github.com/pingcap/tidb/executor.(*HashAggExec).prepare4ParallelExec
/home/jenkins/agent/workspace/tidb_v4.0.2/go/src/github.com/pingcap/tidb/executor/aggregate.go:673 +0x250
goroutine 15493201 [select]:
github.com/pingcap/tidb/executor.(*HashJoinExec).getNewJoinResult(0xc001405680, 0x3, 0x120, 0x37394a0)
/home/jenkins/agent/workspace/tidb_v4.0.2/go/src/github.com/pingcap/tidb/executor/join.go:562 +0x11b
github.com/pingcap/tidb/executor.(*HashJoinExec).joinMatchedProbeSideRow2Chunk(0xc001405680, 0x3, 0xcbf29ce484222325, 0xc000c3c230, 0x120, 0xc00143fec0, 0xc003f871e0, 0x1, 0xc003f871e0)
/home/jenkins/agent/workspace/tidb_v4.0.2/go/src/github.com/pingcap/tidb/executor/join.go:545 +0x37e
github.com/pingcap/tidb/executor.(*HashJoinExec).join2Chunk(0xc001405680, 0x3, 0xc000c3c230, 0xc00143fec0, 0xc003f871e0, 0xc000e07600, 0x0, 0x20, 0x1, 0xc000e07618)
/home/jenkins/agent/workspace/tidb_v4.0.2/go/src/github.com/pingcap/tidb/executor/join.go:593 +0x5a7
github.com/pingcap/tidb/executor.(*HashJoinExec).runJoinWorker(0xc001405680, 0x3, 0x522fbd0, 0x0, 0x0)
/home/jenkins/agent/workspace/tidb_v4.0.2/go/src/github.com/pingcap/tidb/executor/join.go:466 +0x584
github.com/pingcap/tidb/executor.(*HashJoinExec).fetchAndProbeHashTable.func2()
/home/jenkins/agent/workspace/tidb_v4.0.2/go/src/github.com/pingcap/tidb/executor/join.go:326 +0x4e
github.com/pingcap/tidb/util.WithRecovery(0xc002005c20, 0xc0005c8a90)
/home/jenkins/agent/workspace/tidb_v4.0.2/go/src/github.com/pingcap/tidb/util/misc.go:95 +0x57
created by github.com/pingcap/tidb/executor.(*HashJoinExec).fetchAndProbeHashTable
/home/jenkins/agent/workspace/tidb_v4.0.2/go/src/github.com/pingcap/tidb/executor/join.go:326 +0x1b3
goroutine 15493203 [semacquire, 2 minutes]:
sync.runtime_Semacquire(0xc001405844)
/usr/local/go/src/runtime/sema.go:56 +0x42
sync.(*WaitGroup).Wait(0xc001405844)
/usr/local/go/src/sync/waitgroup.go:130 +0x64
github.com/pingcap/tidb/executor.(*HashJoinExec).waitJoinWorkersAndCloseResultChan(0xc001405680)
/home/jenkins/agent/workspace/tidb_v4.0.2/go/src/github.com/pingcap/tidb/executor/join.go:415 +0x3d
github.com/pingcap/tidb/util.WithRecovery(0xc0005c8ab0, 0x0)
/home/jenkins/agent/workspace/tidb_v4.0.2/go/src/github.com/pingcap/tidb/util/misc.go:95 +0x57
created by github.com/pingcap/tidb/executor.(*HashJoinExec).fetchAndProbeHashTable
/home/jenkins/agent/workspace/tidb_v4.0.2/go/src/github.com/pingcap/tidb/executor/join.go:328 +0x32a
goroutine 15493193 [select, 2 minutes]:
github.com/pingcap/tidb/executor.(*HashAggFinalWorker).getPartialInput(0xc0021ccb40, 0xc000fb0000, 0xc0017746e8)
/home/jenkins/agent/workspace/tidb_v4.0.2/go/src/github.com/pingcap/tidb/executor/aggregate.go:490 +0xb3
github.com/pingcap/tidb/executor.(*HashAggFinalWorker).consumeIntermData(0xc0021ccb40, 0x375c4a0, 0xc002202100, 0x111b24f, 0xc0010f9b58)
/home/jenkins/agent/workspace/tidb_v4.0.2/go/src/github.com/pingcap/tidb/executor/aggregate.go:510 +0x6a6
github.com/pingcap/tidb/executor.(*HashAggFinalWorker).run(0xc0021ccb40, 0x375c4a0, 0xc002202100, 0xc0022c2b90)
/home/jenkins/agent/workspace/tidb_v4.0.2/go/src/github.com/pingcap/tidb/executor/aggregate.go:586 +0x9e
created by github.com/pingcap/tidb/executor.(*HashAggExec).prepare4ParallelExec
/home/jenkins/agent/workspace/tidb_v4.0.2/go/src/github.com/pingcap/tidb/executor/aggregate.go:671 +0x1ef
goroutine 15493199 [running]:
goroutine running on other thread; stack unavailable
created by github.com/pingcap/tidb/executor.(*HashJoinExec).fetchAndProbeHashTable
/home/jenkins/agent/workspace/tidb_v4.0.2/go/src/github.com/pingcap/tidb/executor/join.go:326 +0x1b3
goroutine 15493200 [select]:
github.com/pingcap/tidb/executor.(*HashJoinExec).getNewJoinResult(0xc001405680, 0x2, 0x11f, 0x37394a0)
/home/jenkins/agent/workspace/tidb_v4.0.2/go/src/github.com/pingcap/tidb/executor/join.go:562 +0x11b
github.com/pingcap/tidb/executor.(*HashJoinExec).joinMatchedProbeSideRow2Chunk(0xc001405680, 0x2, 0xcbf29ce484222325, 0xc000c3c140, 0x11f, 0xc000b95ec0, 0xc003f871c0, 0x1, 0xc003f871c0)
/home/jenkins/agent/workspace/tidb_v4.0.2/go/src/github.com/pingcap/tidb/executor/join.go:545 +0x37e
github.com/pingcap/tidb/executor.(*HashJoinExec).join2Chunk(0xc001405680, 0x2, 0xc000c3c140, 0xc000b95ec0, 0xc003f871c0, 0xc000e07e00, 0x0, 0x20, 0xc001b99a40, 0xc000e07e18)
/home/jenkins/agent/workspace/tidb_v4.0.2/go/src/github.com/pingcap/tidb/executor/join.go:593 +0x5a7
github.com/pingcap/tidb/executor.(*HashJoinExec).runJoinWorker(0xc001405680, 0x2, 0x522fbd0, 0x0, 0x0)
/home/jenkins/agent/workspace/tidb_v4.0.2/go/src/github.com/pingcap/tidb/executor/join.go:466 +0x584
github.com/pingcap/tidb/executor.(*HashJoinExec).fetchAndProbeHashTable.func2()
/home/jenkins/agent/workspace/tidb_v4.0.2/go/src/github.com/pingcap/tidb/executor/join.go:326 +0x4e
github.com/pingcap/tidb/util.WithRecovery(0xc002005bf0, 0xc0005c8a80)
/home/jenkins/agent/workspace/tidb_v4.0.2/go/src/github.com/pingcap/tidb/util/misc.go:95 +0x57
created by github.com/pingcap/tidb/executor.(*HashJoinExec).fetchAndProbeHashTable
/home/jenkins/agent/workspace/tidb_v4.0.2/go/src/github.com/pingcap/tidb/executor/join.go:326 +0x1b3
{“level”:“warn”,“ts”:“2020-08-14T14:58:20.187+0800”,“caller”:“clientv3/retry_interceptor.go:61”,“msg”:“retrying of unary invoker failed”,“target”:“endpoint://client-5a73b926-8514-4d0f-82a2-10e275e1a0c5/10.201.13.21:2379”,“attempt”:0,“error”:“rpc error: code = DeadlineExceeded desc = context deadline exceeded”}
{“level”:“warn”,“ts”:“2020-08-14T15:09:24.746+0800”,“caller”:“clientv3/retry_interceptor.go:61”,“msg”:“retrying of unary invoker failed”,“target”:“endpoint://client-5a73b926-8514-4d0f-82a2-10e275e1a0c5/10.201.13.21:2379”,“attempt”:0,“error”:“rpc error: code = DeadlineExceeded desc = context deadline exceeded”}
- 您好，非常抱歉，v4.0.5 是不支持这样修改的，这里是由于程序导致，后续版本会修复。
- 当前没有通用办法恢复，如果是正式环境必须修复问题，可能需要出 hotfix，如果是测试环境，请避免这样修改数据，多谢。
3.x版本支持这样修改吗？建议不支持这样修改，应该在修改类型是报错，而不是修改类型成功，导致不能查询数据啊
不好意思，请问，我们使用中发现问题，要在哪个类型下提问题？
，是在应用适配栏提问吗？建议新增用户体验或使用问题一栏
已经修改了。可以看下当前帖子标签
目前都不支持，这个问题是应该在修改前提示，会尽快修复，抱歉。