tidb panic in the recoverable goroutine

[wjhuang2016]

Bug Report

Please answer these questions before submitting your issue. Thanks!

1. Minimal reproduce step (Required)

log1.sql.zip
source log1.sql

2. What did you expect to see? (Required)

No panic

3. What did you see instead (Required)

Panic:

[misc.go:90] ["panic in the recoverable goroutine"] [r={}] ["stack trace"="github.com/pingcap/tidb/util.WithRecovery.func1
\t/Users/pingcap/workspace/build-darwin-amd64-4.0/go/src/github.com/pingcap/tidb/util/misc.go:92
runtime.gopanic
\t/usr/local/go/src/runtime/panic.go:679
runtime.goPanicIndex
\t/usr/local/go/src/runtime/panic.go:75
github.com/pingcap/tidb/util/chunk.(*Column).AppendInt64
\t/Users/pingcap/workspace/build-darwin-amd64-4.0/go/src/github.com/pingcap/tidb/util/chunk/column.go:209
github.com/pingcap/tidb/util/chunk.(*Chunk).AppendInt64
\t/Users/pingcap/workspace/build-darwin-amd64-4.0/go/src/github.com/pingcap/tidb/util/chunk/chunk.go:557
github.com/pingcap/tidb/executor/aggfuncs.(*percentileOriginal4Int).AppendFinalResult2Chunk
\t/Users/pingcap/workspace/build-darwin-amd64-4.0/go/src/github.com/pingcap/tidb/executor/aggfuncs/func_percentile.go:175
github.com/pingcap/tidb/executor.(*StreamAggExec).appendResult2Chunk
\t/Users/pingcap/workspace/build-darwin-amd64-4.0/go/src/github.com/pingcap/tidb/executor/aggregate.go:1240
github.com/pingcap/tidb/executor.(*StreamAggExec).consumeCurGroupRowsAndFetchChild
\t/Users/pingcap/workspace/build-darwin-amd64-4.0/go/src/github.com/pingcap/tidb/executor/aggregate.go:1223
github.com/pingcap/tidb/executor.(*StreamAggExec).consumeOneGroup
\t/Users/pingcap/workspace/build-darwin-amd64-4.0/go/src/github.com/pingcap/tidb/executor/aggregate.go:1160
github.com/pingcap/tidb/executor.(*StreamAggExec).Next
\t/Users/pingcap/workspace/build-darwin-amd64-4.0/go/src/github.com/pingcap/tidb/executor/aggregate.go:1130
github.com/pingcap/tidb/executor.Next
\t/Users/pingcap/workspace/build-darwin-amd64-4.0/go/src/github.com/pingcap/tidb/executor/executor.go:277
github.com/pingcap/tidb/executor.(*HashJoinExec).fetchBuildSideRows
\t/Users/pingcap/workspace/build-darwin-amd64-4.0/go/src/github.com/pingcap/tidb/executor/join.go:268
github.com/pingcap/tidb/executor.(*HashJoinExec).fetchAndBuildHashTable.func2
\t/Users/pingcap/workspace/build-darwin-amd64-4.0/go/src/github.com/pingcap/tidb/executor/join.go:702
github.com/pingcap/tidb/util.WithRecovery
\t/Users/pingcap/workspace/build-darwin-amd64-4.0/go/src/github.com/pingcap/tidb/util/misc.go:95"]

4. What is your TiDB version? (Required)

master

[XuHuaiyu]

sql:

( select /*+ agg_to_cop()  */ stddev_samp(col_10) aggCol from (select   * from tbl_2 where col_11 in ( 'UoLUPjgedxNYDOGKZF' , 6397.408929775499 ) and col_13 = 27759662761445699 and col_14 in ( 'OPToeHrxpwgy' , 36342469627411305 ) and col_10 = 'myPELTsFqCKH' or col_11 = 'yKJqyuZCRV' and col_13 in ( 6017.9392684487975 , 4189.347985112102 ) and col_14 in ( 97782252058152581 , 109284996915894662 , 44682028518839864 ) and col_10 in ( 'rKiUqGpc' , 'oPGdzE' , 'hVDtKxivdzb' , 'qMn' , 'rKiUqGpc' , 'rKiUqGpc' , 'kLiAFCgEOJpWqfd' , 'SqjCVTNPngvPgsK' , 'PtdNPlFVycso' ) or col_12 = 15583136 and col_13 = 5914.874867854531 order by col_11,col_13,col_14,col_10  ) ordered_tbl  ) except ( select /*+ agg_to_cop() stream_agg() */ approx_percentile(col_14, 60) aggCol from (select   * from tbl_2 where col_14 in ( 35790107400437263 , 56149669338048791 , 29685105514069236 ) or col_11 > 'fcheHSKd' order by col_11,col_13,col_14,col_10  ) ordered_tbl );

[lzmhhh123]

function approx_percentile panic.

[ti-srebot]

Please edit this comment or add a new comment to complete the following information

Not a bug

1. Remove the 'type/bug' label
2. Add notes to indicate why it is not a bug

Duplicate bug

1. Add the 'type/duplicate' label
2. Add the link to the original bug

Bug

Note: Make Sure that 'component', and 'severity' labels are added
Example for how to fill out the template: #20100

1. Root Cause Analysis (RCA) (optional)

2. Symptom (optional)

3. All Trigger Conditions (optional)

4. Workaround (optional)

5. Affected versions

6. Fixed versions