Error 1105: should ensure all columns have the same length #16147

breezewish · 2020-04-08T03:00:57Z

Bug Report

Please answer these questions before submitting your issue. Thanks!

1. What did you do?

This issue is discovered by random test:

https://internal.pingcap.net/idc-jenkins/blue/organizations/jenkins/tikv_ghpr_integration-copr-test/detail/tikv_ghpr_integration-copr-test/2377/pipeline/

This SQL sometimes fail due to a memory problem:

SELECT LEAST( '2012-02-21', 0, '2000-11-19 07:53:12.013663' ) AS field1, COALESCE( `col_datetime`, `col_enum`, ( ( GREATEST( '2016-05-25 18:03:50.043233', ( COALESCE( `col_blob` ) ) ) ) >= '2021-09-07' ), NULL, '14:58:30.040393' ) AS field2 FROM `table20_int_autoinc` WHERE INTERVAL( `col_float_unsigned`, `col_int`, '03:50:55.005501', ( `col_decimal_unsigned` > `col_int_key` ), '1992-04-12 12:04:33.033564' ) ORDER BY field1, field2 LIMIT 7 /* QNO 959 CON_ID 196 */ ;

In the test above, it fails when running with mocktikv.

You can see test data in https://github.com/tikv/copr-test/tree/master/push-down-test/prepare

2. What did you expect to see?

[2020-04-07T12:57:13.995Z] field1	field2
[2020-04-07T12:57:13.995Z] 0	0000-00-00 00:00:00
[2020-04-07T12:57:13.995Z] 0	0000-00-00 00:00:00
[2020-04-07T12:57:13.995Z] 0	0000-00-00 00:00:00
[2020-04-07T12:57:13.995Z] 0	0000-00-00 00:00:00
[2020-04-07T12:57:13.995Z] 0	0000-00-00 00:00:00
[2020-04-07T12:57:13.995Z] 0	0000-00-00 00:00:00
[2020-04-07T12:57:13.995Z] 0	0000-00-00 00:00:00

3. What did you see instead?

Error 1105: should ensure all columns have the same length

4. What version of TiDB are you using? (`tidb-server -V` or run `select tidb_version();` on TiDB)

master

The text was updated successfully, but these errors were encountered:

XuHuaiyu · 2020-04-09T06:06:12Z

a similar problem with tidb error log

[2020-04-08T15:00:14.368Z] 2020/04/08 23:00:14 2020/04/08 22:59:45 Test fail: Outputs are not matching.

[2020-04-08T15:00:14.368Z] Test case: sql/randgen-topn/3_compare_2.sql

[2020-04-08T15:00:14.368Z] Statement: #957 -  SELECT LEAST( '2012-02-21', 0, '2000-11-19 07:53:12.013663' ) AS field1, COALESCE( `col_datetime`, `col_enum`, ( ( GREATEST( '2016-05-25 18:03:50.043233', ( COALESCE( `col_blob` ) ) ) ) >= '2021-09-07' ), NULL, '14:58:30.040393' ) AS field2 FROM `table20_int_autoinc` WHERE INTERVAL( `col_float_unsigned`, `col_int`, '03:50:55.005501', ( `col_decimal_unsigned` > `col_int_key` ), '1992-04-12 12:04:33.033564' ) ORDER BY field1, field2 LIMIT 7 /* QNO 959 CON_ID 196 */ ;

[2020-04-08T15:00:14.368Z] NoPushDown Output: 

[2020-04-08T15:00:14.368Z] field1	field2

[2020-04-08T15:00:14.368Z] 0	0000-00-00 00:00:00

[2020-04-08T15:00:14.368Z] 0	0000-00-00 00:00:00

[2020-04-08T15:00:14.368Z] 0	0000-00-00 00:00:00

[2020-04-08T15:00:14.368Z] 0	0000-00-00 00:00:00

[2020-04-08T15:00:14.368Z] 0	0000-00-00 00:00:00

[2020-04-08T15:00:14.368Z] 0	0000-00-00 00:00:00

[2020-04-08T15:00:14.368Z] 0	0000-00-00 00:00:00

[2020-04-08T15:00:14.368Z] 

[2020-04-08T15:00:14.368Z] 

[2020-04-08T15:00:14.368Z] WithPushDown Output: 

[2020-04-08T15:00:14.368Z] Error 1105: should ensure all columns have the same length

err="should ensure all columns have the same length
github.com/pingcap/tidb/executor.(*recordSet).Next.func1
	/home/jenkins/agent/workspace/tidb_ghpr_integration_copr_test/tidb/executor/adapter.go:122
runtime.gopanic
	/usr/local/go/src/runtime/panic.go:679
github.com/pingcap/tidb/util/chunk.(*Column).MergeNulls
	/home/jenkins/agent/workspace/tidb_ghpr_integration_copr_test/tidb/util/chunk/column.go:706
github.com/pingcap/tidb/expression.(*builtinArithmeticIntDivideDecimalSig).vecEvalInt
	/home/jenkins/agent/workspace/tidb_ghpr_integration_copr_test/tidb/expression/builtin_arithmetic_vec.go:688
github.com/pingcap/tidb/expression.(*ScalarFunction).VecEvalInt
	/home/jenkins/agent/workspace/tidb_ghpr_integration_copr_test/tidb/expression/scalar_function.go:51
github.com/pingcap/tidb/expression.(*builtinArithmeticModIntSig).vecEvalInt
	/home/jenkins/agent/workspace/tidb_ghpr_integration_copr_test/tidb/expression/builtin_arithmetic_vec.go:125
github.com/pingcap/tidb/expression.(*ScalarFunction).VecEvalInt
	/home/jenkins/agent/workspace/tidb_ghpr_integration_copr_test/tidb/expression/scalar_function.go:51
github.com/pingcap/tidb/expression.(*builtinCastIntAsRealSig).vecEvalReal
	/home/jenkins/agent/workspace/tidb_ghpr_integration_copr_test/tidb/expression/builtin_cast_vec.go:94
github.com/pingcap/tidb/expression.(*ScalarFunction).VecEvalReal
	/home/jenkins/agent/workspace/tidb_ghpr_integration_copr_test/tidb/expression/scalar_function.go:56
github.com/pingcap/tidb/expression.(*builtinArithmeticModRealSig).vecEvalReal
	/home/jenkins/agent/workspace/tidb_ghpr_integration_copr_test/tidb/expression/builtin_arithmetic_vec.go:515
github.com/pingcap/tidb/expression.(*ScalarFunction).VecEvalReal
	/home/jenkins/agent/workspace/tidb_ghpr_integration_copr_test/tidb/expression/scalar_function.go:56
github.com/pingcap/tidb/expression.evalOneVec
	/home/jenkins/agent/workspace/tidb_ghpr_integration_copr_test/tidb/expression/chunk_executor.go:145
github.com/pingcap/tidb/expression.(*defaultEvaluator).run
	/home/jenkins/agent/workspace/tidb_ghpr_integration_copr_test/tidb/expression/evaluator.go:51
github.com/pingcap/tidb/expression.(*EvaluatorSuite).Run
	/home/jenkins/agent/workspace/tidb_ghpr_integration_copr_test/tidb/expression/evaluator.go:123
github.com/pingcap/tidb/executor.(*ProjectionExec).unParallelExecute
	/home/jenkins/agent/workspace/tidb_ghpr_integration_copr_test/tidb/executor/projection.go:193
github.com/pingcap/tidb/executor.(*ProjectionExec).Next
	/home/jenkins/agent/workspace/tidb_ghpr_integration_copr_test/tidb/executor/projection.go:171
github.com/pingcap/tidb/executor.Next
	/home/jenkins/agent/workspace/tidb_ghpr_integration_copr_test/tidb/executor/executor.go:217
github.com/pingcap/tidb/executor.(*recordSet).Next
	/home/jenkins/agent/workspace/tidb_ghpr_integration_copr_test/tidb/executor/adapter.go:126
github.com/pingcap/tidb/server.(*tidbResultSet).Next
	/home/jenkins/agent/workspace/tidb_ghpr_integration_copr_test/tidb/server/driver_tidb.go:386
github.com/pingcap/tidb/server.(*clientConn).writeChunks
	/home/jenkins/agent/workspace/tidb_ghpr_integration_copr_test/tidb/server/conn.go:1396
github.com/pingcap/tidb/server.(*clientConn).writeResultset
	/home/jenkins/agent/workspace/tidb_ghpr_integration_copr_test/tidb/server/conn.go:1362
github.com/pingcap/tidb/server.(*clientConn).handleQuery
	/home/jenkins/agent/workspace/tidb_ghpr_integration_copr_test/tidb/server/conn.go:1270
github.com/pingcap/tidb/server.(*clientConn).dispatch
	/home/jenkins/agent/workspace/tidb_ghpr_integration_copr_test/tidb/server/conn.go:897
github.com/pingcap/tidb/server.(*clientConn).Run
	/home/jenkins/agent/workspace/tidb_ghpr_integration_copr_test/tidb/server/conn.go:711
github.com/pingcap/tidb/server.(*Server).onConn
	/home/jenkins/agent/workspace/tidb_ghpr_integration_copr_test/tidb/server/server.go:415
runtime.goexit
	/usr/local/go/src/runtime/asm_amd64.s:1357"

SunRunAway · 2020-06-30T07:56:15Z

@XuHuaiyu Ping~

XuHuaiyu · 2020-08-03T09:41:42Z

func (b *builtinArithmeticIntDivideDecimalSig) vecEvalInt(input *chunk.Chunk, result *chunk.Column) error {
	...
	for i, arg := range b.args {
		...
		if terror.ErrorEqual(err, types.ErrTruncated) {
			err = nil
		}
		...
	}

	...
	result.MergeNulls(buf[0], buf[1])

If the child of builtinArithmeticIntDivideDecimalSig return an ErrTruncated error, it's possible that buf[0].length != buf[1].length and thus get the error.

SunRunAway · 2020-08-26T08:43:58Z

Another occurrence from https://internal.pingcap.net/idc-jenkins/blue/organizations/jenkins/tikv_ghpr_integration-copr-test/detail/tikv_ghpr_integration-copr-test/3553/pipeline/ of tikv/tikv#8466

[2020-08-25T11:01:21.325Z] Statement: #1567 -  SELECT STRCMP( ( `col_double_key` <=> `col_tinyint_unsigned_key` ), ( COALESCE( `col_varchar_1_key`, 613896924205940736, ( `col_int_key` > ( ( LEAST( `col_blob`, `col_enum` ) ) <=> ( `col_double_unsigned` NOT IN ( -2619124658292654080, ( '1997-05-24' LIKE ( ( ( 'asrpqaqrasisjngjaugvywtekbvahezvxxcihhakdstkwxudygixivxzpetimpnsumistumumeopraadbqujmpiqbhfjafgerliznrpxgpdlhkodjpmewmgfzgpxfikdodqftyppixekgmpyuospgksueegnafoeajdcsopomtithdxzndswkzgtbulphegfzttopmpwnlt' BETWEEN ( 31571 != '17:51:34.012966' ) AND `col_bigint_unsigned_key` ) != '1979-07-23' ) != 0 ) ), `col_decimal_unsigned`, '2033-02-16 17:01:01.015415', ( GREATEST( `col_binary_8_key`, '2030-01-13 10:57:36.017758', `col_tinyint` ) ) ) ) ) ), '1993-07-10 21:03:03.021372', '2034-06-16' ) ) ) AS field1 FROM `table10_int_autoinc` WHERE `col_bigint_key` <> ( `col_varbinary_32_key` <> '1982-01-20 00:37:32.057740' ) ORDER BY field1 LIMIT 1 /* QNO 1569 CON_ID 196 */ ;

[2020-08-25T11:01:21.325Z] NoPushDown Output: 

[2020-08-25T11:01:21.325Z] field1

[2020-08-25T11:01:21.325Z] -1

[2020-08-25T11:01:21.325Z] 

[2020-08-25T11:01:21.325Z] 

[2020-08-25T11:01:21.325Z] WithPushDown Output: 

[2020-08-25T11:01:21.325Z] Error 1105: should ensure all columns have the same length

[2020-08-25T11:01:21.325Z] 

[2020-08-25T11:01:21.325Z] 

[2020-08-25T11:01:21.325Z] NoPushDown Plan: 

[2020-08-25T11:01:21.325Z] id	estRows	task	access object	operator info

[2020-08-25T11:01:21.325Z] Projection_7	1.00	root		strcmp(cast(nulleq(push_down_test_db.table10_int_autoinc.col_double_key, cast(push_down_test_db.table10_int_autoinc.col_tinyint_unsigned_key, double UNSIGNED BINARY)), var_string(20)), coalesce(push_down_test_db.table10_int_autoinc.col_varchar_1_key, 613896924205940736, cast(gt(push_down_test_db.table10_int_autoinc.col_int_key, nulleq(cast(least(push_down_test_db.table10_int_autoinc.col_blob, push_down_test_db.table10_int_autoinc.col_enum), double BINARY), cast(not(in(push_down_test_db.table10_int_autoinc.col_double_unsigned, -2.619124658292654e+18, cast(like(1997-05-24, cast(ne(ne(and(0, le(0, push_down_test_db.table10_int_autoinc.col_bigint_unsigned_key)), 1979), 0), var_string(20)), 92), double BINARY), cast(push_down_test_db.table10_int_autoinc.col_decimal_unsigned, double UNSIGNED BINARY), 2033, greatest(cast(push_down_test_db.table10_int_autoinc.col_binary_8_key, double BINARY), 2030, cast(push_down_test_db.table10_int_autoinc.col_tinyint, double BINARY)))), double BINARY))), var_string(20)), 1993-07-10 21:03:03.021372, 2034-06-16))->Column#62

[2020-08-25T11:01:21.325Z] └─Projection_17	1.00	root		push_down_test_db.table10_int_autoinc.col_binary_8_key, push_down_test_db.table10_int_autoinc.col_bigint_key, push_down_test_db.table10_int_autoinc.col_tinyint_unsigned_key, push_down_test_db.table10_int_autoinc.col_varchar_1_key, push_down_test_db.table10_int_autoinc.col_double_unsigned, push_down_test_db.table10_int_autoinc.col_blob, push_down_test_db.table10_int_autoinc.col_decimal_unsigned, push_down_test_db.table10_int_autoinc.col_int_key, push_down_test_db.table10_int_autoinc.col_bigint_unsigned_key, push_down_test_db.table10_int_autoinc.col_varbinary_32_key, push_down_test_db.table10_int_autoinc.col_double_key, push_down_test_db.table10_int_autoinc.col_enum, push_down_test_db.table10_int_autoinc.col_tinyint

[2020-08-25T11:01:21.325Z]   └─TopN_8	1.00	root		Column#63, offset:0, count:1

[2020-08-25T11:01:21.325Z]     └─Projection_18	8000.00	root		push_down_test_db.table10_int_autoinc.col_binary_8_key, push_down_test_db.table10_int_autoinc.col_bigint_key, push_down_test_db.table10_int_autoinc.col_tinyint_unsigned_key, push_down_test_db.table10_int_autoinc.col_varchar_1_key, push_down_test_db.table10_int_autoinc.col_double_unsigned, push_down_test_db.table10_int_autoinc.col_blob, push_down_test_db.table10_int_autoinc.col_decimal_unsigned, push_down_test_db.table10_int_autoinc.col_int_key, push_down_test_db.table10_int_autoinc.col_bigint_unsigned_key, push_down_test_db.table10_int_autoinc.col_varbinary_32_key, push_down_test_db.table10_int_autoinc.col_double_key, push_down_test_db.table10_int_autoinc.col_enum, push_down_test_db.table10_int_autoinc.col_tinyint, strcmp(cast(nulleq(push_down_test_db.table10_int_autoinc.col_double_key, cast(push_down_test_db.table10_int_autoinc.col_tinyint_unsigned_key, double UNSIGNED BINARY)), var_string(20)), coalesce(push_down_test_db.table10_int_autoinc.col_varchar_1_key, 613896924205940736, cast(gt(push_down_test_db.table10_int_autoinc.col_int_key, nulleq(cast(least(push_down_test_db.table10_int_autoinc.col_blob, push_down_test_db.table10_int_autoinc.col_enum), double BINARY), cast(not(in(push_down_test_db.table10_int_autoinc.col_double_unsigned, -2.619124658292654e+18, cast(like(1997-05-24, cast(ne(ne(and(0, le(0, push_down_test_db.table10_int_autoinc.col_bigint_unsigned_key)), 1979), 0), var_string(20)), 92), double BINARY), cast(push_down_test_db.table10_int_autoinc.col_decimal_unsigned, double UNSIGNED BINARY), 2033, greatest(cast(push_down_test_db.table10_int_autoinc.col_binary_8_key, double BINARY), 2030, cast(push_down_test_db.table10_int_autoinc.col_tinyint, double BINARY)))), double BINARY))), var_string(20)), 1993-07-10 21:03:03.021372, 2034-06-16))->Column#63

[2020-08-25T11:01:21.325Z]       └─TableReader_13	8000.00	root		data:Selection_12

[2020-08-25T11:01:21.325Z]         └─Selection_12	8000.00	cop[tikv]		ne(push_down_test_db.table10_int_autoinc.col_bigint_key, ne(push_down_test_db.table10_int_autoinc.col_varbinary_32_key, "1982-01-20 00:37:32.057740"))

[2020-08-25T11:01:21.325Z]           └─TableFullScan_11	10000.00	cop[tikv]	table:table10_int_autoinc	keep order:false, stats:pseudo

[2020-08-25T11:01:21.325Z] 

[2020-08-25T11:01:21.325Z] 

[2020-08-25T11:01:21.325Z] WithPushDown Plan: 

[2020-08-25T11:01:21.325Z] id	estRows	task	access object	operator info

[2020-08-25T11:01:21.325Z] Projection_7	1.00	root		strcmp(cast(nulleq(push_down_test_db.table10_int_autoinc.col_double_key, cast(push_down_test_db.table10_int_autoinc.col_tinyint_unsigned_key, double UNSIGNED BINARY)), var_string(20)), coalesce(push_down_test_db.table10_int_autoinc.col_varchar_1_key, 613896924205940736, cast(gt(push_down_test_db.table10_int_autoinc.col_int_key, nulleq(cast(least(push_down_test_db.table10_int_autoinc.col_blob, push_down_test_db.table10_int_autoinc.col_enum), double BINARY), cast(not(in(push_down_test_db.table10_int_autoinc.col_double_unsigned, -2.619124658292654e+18, cast(like(1997-05-24, cast(ne(ne(and(0, le(0, push_down_test_db.table10_int_autoinc.col_bigint_unsigned_key)), 1979), 0), var_string(20)), 92), double BINARY), cast(push_down_test_db.table10_int_autoinc.col_decimal_unsigned, double UNSIGNED BINARY), 2033, greatest(cast(push_down_test_db.table10_int_autoinc.col_binary_8_key, double BINARY), 2030, cast(push_down_test_db.table10_int_autoinc.col_tinyint, double BINARY)))), double BINARY))), var_string(20)), 1993-07-10 21:03:03.021372, 2034-06-16))->Column#62

[2020-08-25T11:01:21.325Z] └─Projection_17	1.00	root		push_down_test_db.table10_int_autoinc.col_binary_8_key, push_down_test_db.table10_int_autoinc.col_bigint_key, push_down_test_db.table10_int_autoinc.col_tinyint_unsigned_key, push_down_test_db.table10_int_autoinc.col_varchar_1_key, push_down_test_db.table10_int_autoinc.col_double_unsigned, push_down_test_db.table10_int_autoinc.col_blob, push_down_test_db.table10_int_autoinc.col_decimal_unsigned, push_down_test_db.table10_int_autoinc.col_int_key, push_down_test_db.table10_int_autoinc.col_bigint_unsigned_key, push_down_test_db.table10_int_autoinc.col_varbinary_32_key, push_down_test_db.table10_int_autoinc.col_double_key, push_down_test_db.table10_int_autoinc.col_enum, push_down_test_db.table10_int_autoinc.col_tinyint

[2020-08-25T11:01:21.325Z]   └─TopN_8	1.00	root		Column#63, offset:0, count:1

[2020-08-25T11:01:21.325Z]     └─Projection_18	8000.00	root		push_down_test_db.table10_int_autoinc.col_binary_8_key, push_down_test_db.table10_int_autoinc.col_bigint_key, push_down_test_db.table10_int_autoinc.col_tinyint_unsigned_key, push_down_test_db.table10_int_autoinc.col_varchar_1_key, push_down_test_db.table10_int_autoinc.col_double_unsigned, push_down_test_db.table10_int_autoinc.col_blob, push_down_test_db.table10_int_autoinc.col_decimal_unsigned, push_down_test_db.table10_int_autoinc.col_int_key, push_down_test_db.table10_int_autoinc.col_bigint_unsigned_key, push_down_test_db.table10_int_autoinc.col_varbinary_32_key, push_down_test_db.table10_int_autoinc.col_double_key, push_down_test_db.table10_int_autoinc.col_enum, push_down_test_db.table10_int_autoinc.col_tinyint, strcmp(cast(nulleq(push_down_test_db.table10_int_autoinc.col_double_key, cast(push_down_test_db.table10_int_autoinc.col_tinyint_unsigned_key, double UNSIGNED BINARY)), var_string(20)), coalesce(push_down_test_db.table10_int_autoinc.col_varchar_1_key, 613896924205940736, cast(gt(push_down_test_db.table10_int_autoinc.col_int_key, nulleq(cast(least(push_down_test_db.table10_int_autoinc.col_blob, push_down_test_db.table10_int_autoinc.col_enum), double BINARY), cast(not(in(push_down_test_db.table10_int_autoinc.col_double_unsigned, -2.619124658292654e+18, cast(like(1997-05-24, cast(ne(ne(and(0, le(0, push_down_test_db.table10_int_autoinc.col_bigint_unsigned_key)), 1979), 0), var_string(20)), 92), double BINARY), cast(push_down_test_db.table10_int_autoinc.col_decimal_unsigned, double UNSIGNED BINARY), 2033, greatest(cast(push_down_test_db.table10_int_autoinc.col_binary_8_key, double BINARY), 2030, cast(push_down_test_db.table10_int_autoinc.col_tinyint, double BINARY)))), double BINARY))), var_string(20)), 1993-07-10 21:03:03.021372, 2034-06-16))->Column#63

[2020-08-25T11:01:21.326Z]       └─TableReader_13	8000.00	root		data:Selection_12

[2020-08-25T11:01:21.326Z]         └─Selection_12	8000.00	cop[tikv]		ne(push_down_test_db.table10_int_autoinc.col_bigint_key, ne(push_down_test_db.table10_int_autoinc.col_varbinary_32_key, "1982-01-20 00:37:32.057740"))

[2020-08-25T11:01:21.326Z]           └─TableFullScan_11	10000.00	cop[tikv]	table:table10_int_autoinc	keep order:false, stats:pseudo

[2020-08-25T11:01:21.326Z] 

[2020-08-25T11:01:21.326Z] 

[2020-08-25T11:01:21.326Z] 

[2020-08-25T11:01:21.326Z] 2020/08/25 19:01:21 Test summary: non-matching queries: 1, success queries: 2045, skipped queries: 952

[2020-08-25T11:01:21.326Z] 2020/08/25 19:01:21 Test summary(sql/randgen-topn/3_compare_2.sql): Test case FAIL

[2020-08-25T11:01:21.326Z] 

[2020-08-25T11:01:21.582Z] + Test finished

[2020-08-25T11:01:21.582Z]   - /home/jenkins/agent/workspace/tikv_ghpr_integration-copr-test/copr-test/push-down-test/build/push_down_test_bin exit code is 2

[2020-08-25T11:01:21.582Z] make: *** [push-down-test] Error 2

qw4990 · 2020-08-27T07:20:04Z

I can't reproduce this case. We should print the stack information when it occurs.

breezewish · 2020-08-27T07:22:55Z

@qw4990 The stackinfo is available in https://internal.pingcap.net/idc-jenkins/blue/organizations/jenkins/tikv_ghpr_integration-copr-test/detail/tikv_ghpr_integration-copr-test/3553/pipeline/

[2020-08-25T11:01:27.545Z] [2020/08/25 19:01:05.073 +08:00] [ERROR] [projection.go:447] ["projection executor panicked"] [error="should ensure all columns have the same length"] [stack="goroutine 219120 [running]:\ngithub.com/pingcap/tidb/util.GetStack(...)\n\t/home/jenkins/agent/workspace/tikv_ghpr_integration-copr-test/tidb/util/misc.go:76\ngithub.com/pingcap/tidb/executor.recoveryProjection(0xc00091d280, 0x3105ae0, 0x3b07460)\n\t/home/jenkins/agent/workspace/tikv_ghpr_integration-copr-test/tidb/executor/projection.go:446 +0x90\ngithub.com/pingcap/tidb/executor.(*projectionWorker).run.func1(0xc003fa1f88, 0xc004386140)\n\t/home/jenkins/agent/workspace/tikv_ghpr_integration-copr-test/tidb/executor/projection.go:414 +0x70\npanic(0x3105ae0, 0x3b07460)\n\t/usr/local/go/src/runtime/panic.go:679 +0x1b2\ngithub.com/pingcap/tidb/util/chunk.(*Column).MergeNulls(0xc003f4bc70, 0xc003fa14c8, 0x1, 0x1)\n\t/home/jenkins/agent/workspace/tikv_ghpr_integration-copr-test/tidb/util/chunk/column.go:706 +0xde\ngithub.com/pingcap/tidb/expression.(*builtinCastStringAsRealSig).vecEvalReal(0xc00136ad10, 0xc0027dc460, 0xc003f4bc70, 0x0, 0x0)\n\t/home/jenkins/agent/workspace/tikv_ghpr_integration-copr-test/tidb/expression/builtin_cast_vec.go:1558 +0x201\ngithub.com/pingcap/tidb/expression.(*ScalarFunction).VecEvalReal(0xc005fe8230, 0x3be6c80, 0xc001142ff0, 0xc0027dc460, 0xc003f4bc70, 0x0, 0x1bf5a01)\n\t/home/jenkins/agent/workspace/tikv_ghpr_integration-copr-test/tidb/expression/scalar_function.go:56 +0x4b\ngithub.com/pingcap/tidb/expression.(*builtinNullEQRealSig).vecEvalInt(0xc00136ac60, 0xc0027dc460, 0xc003f4bc00, 0x0, 0x0)\n\t/home/jenkins/agent/workspace/tikv_ghpr_integration-copr-test/tidb/expression/builtin_compare_vec_generated.go:1519 +0x145\ngithub.com/pingcap/tidb/expression.(*ScalarFunction).VecEvalInt(0xc005fe8b40, 0x3be6c80, 0xc001142ff0, 0xc0027dc460, 0xc003f4bc00, 0x0, 0x0)\n\t/home/jenkins/agent/workspace/tikv_ghpr_integration-copr-test/tidb/expression/scalar_function.go:51 +0x4b\ngithub.com/pingcap/tidb/expression.(*builtinGTIntSig).vecEvalInt(0xc00136abb0, 0xc0027dc460, 0xc003f4bb20, 0x0, 0x0)\n\t/home/jenkins/agent/workspace/tikv_ghpr_integration-copr-test/tidb/expression/builtin_compare_vec.go:369 +0x240\ngithub.com/pingcap/tidb/expression.(*ScalarFunction).VecEvalInt(0xc005fe8be0, 0x3be6c80, 0xc001142ff0, 0xc0027dc460, 0xc003f4bb20, 0x0, 0x8)\n\t/home/jenkins/agent/workspace/tikv_ghpr_integration-copr-test/tidb/expression/scalar_function.go:51 +0x4b\ngithub.com/pingcap/tidb/expression.(*builtinCastIntAsStringSig).vecEvalString(0xc00136ab00, 0xc0027dc460, 0xc003f4bab0, 0x0, 0x0)\n\t/home/jenkins/agent/workspace/tikv_ghpr_integration-copr-test/tidb/expression/builtin_cast_vec.go:630 +0x145\ngithub.com/pingcap/tidb/expression.(*ScalarFunction).VecEvalString(0xc005fe8c30, 0x3be6c80, 0xc001142ff0, 0xc0027dc460, 0xc003f4bab0, 0x0, 0x0)\n\t/home/jenkins/agent/workspace/tikv_ghpr_integration-copr-test/tidb/expression/scalar_function.go:61 +0x4b\ngithub.com/pingcap/tidb/expression.(*builtinCoalesceStringSig).vecEvalString(0xc00136aa50, 0xc0027dc460, 0xc003f4b960, 0x0, 0x0)\n\t/home/jenkins/agent/workspace/tikv_ghpr_integration-copr-test/tidb/expression/builtin_compare_vec_generated.go:1859 +0x189\ngithub.com/pingcap/tidb/expression.(*ScalarFunction).VecEvalString(0xc005fe8c80, 0x3be6c80, 0xc001142ff0, 0xc0027dc460, 0xc003f4b960, 0x0, 0x0)\n\t/home/jenkins/agent/workspace/tikv_ghpr_integration-copr-test/tidb/expression/scalar_function.go:61 +0x4b\ngithub.com/pingcap/tidb/expression.(*builtinStrcmpSig).vecEvalInt(0xc00136a790, 0xc0027dc460, 0xc003274c40, 0x0, 0x0)\n\t/home/jenkins/agent/workspace/tikv_ghpr_integration-copr-test/tidb/expression/builtin_string_vec.go:1177 +0x243\ngithub.com/pingcap/tidb/expression.(*ScalarFunction).VecEvalInt(0xc005fe8cd0, 0x3be6c80, 0xc001142ff0, 0xc0027dc460, 0xc003274c40, 0x1244df6, 0xc004c8a980)\n\t/home/jenkins/agent/workspace/tikv_ghpr_integration-copr-test/tidb/expression/scalar_function.go:51 +0x4b\ngithub.com/pingcap/tidb/expression.evalOneVec(0x3be6c80, 0xc001142ff0, 0x3c17e40, 0xc005fe8cd0, 0xc0027dc460, 0xc0027dc4b0, 0xd, 0xc002c83ee8, 0x2b69713)\n\t/home/jenkins/agent/workspace/tikv_ghpr_integration-copr-test/tidb/expression/chunk_executor.go:123 +0x459\ngithub.com/pingcap/tidb/expression.(*defaultEvaluator).run(0xc004d96ec0, 0"]
[2020-08-25T11:01:27.545Z] [2020/08/25 19:01:05.073 +08:00] [ERROR] [projection.go:447] ["projection executor panicked"] [error="should ensure all columns have the same length"] [stack="goroutine 219117 [running]:\ngithub.com/pingcap/tidb/util.GetStack(...)\n\t/home/jenkins/agent/workspace/tikv_ghpr_integration-copr-test/tidb/util/misc.go:76\ngithub.com/pingcap/tidb/executor.recoveryProjection(0xc0045c0b90, 0x3105ae0, 0x3b07460)\n\t/home/jenkins/agent/workspace/tikv_ghpr_integration-copr-test/tidb/executor/projection.go:446 +0x90\ngithub.com/pingcap/tidb/executor.(*projectionWorker).run.func1(0xc0006d7f88, 0xc004d97140)\n\t/home/jenkins/agent/workspace/tikv_ghpr_integration-copr-test/tidb/executor/projection.go:414 +0x70\npanic(0x3105ae0, 0x3b07460)\n\t/usr/local/go/src/runtime/panic.go:679 +0x1b2\ngithub.com/pingcap/tidb/util/chunk.(*Column).MergeNulls(0xc003f4bc70, 0xc0006d74c8, 0x1, 0x1)\n\t/home/jenkins/agent/workspace/tikv_ghpr_integration-copr-test/tidb/util/chunk/column.go:706 +0xde\ngithub.com/pingcap/tidb/expression.(*builtinCastStringAsRealSig).vecEvalReal(0xc00136ad10, 0xc00a5b97c0, 0xc003f4bc70, 0x0, 0x0)\n\t/home/jenkins/agent/workspace/tikv_ghpr_integration-copr-test/tidb/expression/builtin_cast_vec.go:1558 +0x201\ngithub.com/pingcap/tidb/expression.(*ScalarFunction).VecEvalReal(0xc005fe8230, 0x3be6c80, 0xc001142ff0, 0xc00a5b97c0, 0xc003f4bc70, 0x0, 0x1bf5a01)\n\t/home/jenkins/agent/workspace/tikv_ghpr_integration-copr-test/tidb/expression/scalar_function.go:56 +0x4b\ngithub.com/pingcap/tidb/expression.(*builtinNullEQRealSig).vecEvalInt(0xc00136ac60, 0xc00a5b97c0, 0xc003f4bb90, 0x0, 0x0)\n\t/home/jenkins/agent/workspace/tikv_ghpr_integration-copr-test/tidb/expression/builtin_compare_vec_generated.go:1519 +0x145\ngithub.com/pingcap/tidb/expression.(*ScalarFunction).VecEvalInt(0xc005fe8b40, 0x3be6c80, 0xc001142ff0, 0xc00a5b97c0, 0xc003f4bb90, 0x0, 0x0)\n\t/home/jenkins/agent/workspace/tikv_ghpr_integration-copr-test/tidb/expression/scalar_function.go:51 +0x4b\ngithub.com/pingcap/tidb/expression.(*builtinGTIntSig).vecEvalInt(0xc00136abb0, 0xc00a5b97c0, 0xc003f4bb20, 0x0, 0x0)\n\t/home/jenkins/agent/workspace/tikv_ghpr_integration-copr-test/tidb/expression/builtin_compare_vec.go:369 +0x240\ngithub.com/pingcap/tidb/expression.(*ScalarFunction).VecEvalInt(0xc005fe8be0, 0x3be6c80, 0xc001142ff0, 0xc00a5b97c0, 0xc003f4bb20, 0x0, 0x8)\n\t/home/jenkins/agent/workspace/tikv_ghpr_integration-copr-test/tidb/expression/scalar_function.go:51 +0x4b\ngithub.com/pingcap/tidb/expression.(*builtinCastIntAsStringSig).vecEvalString(0xc00136ab00, 0xc00a5b97c0, 0xc003f4bab0, 0x0, 0x0)\n\t/home/jenkins/agent/workspace/tikv_ghpr_integration-copr-test/tidb/expression/builtin_cast_vec.go:630 +0x145\ngithub.com/pingcap/tidb/expression.(*ScalarFunction).VecEvalString(0xc005fe8c30, 0x3be6c80, 0xc001142ff0, 0xc00a5b97c0, 0xc003f4bab0, 0x0, 0x0)\n\t/home/jenkins/agent/workspace/tikv_ghpr_integration-copr-test/tidb/expression/scalar_function.go:61 +0x4b\ngithub.com/pingcap/tidb/expression.(*builtinCoalesceStringSig).vecEvalString(0xc00136aa50, 0xc00a5b97c0, 0xc00348a150, 0x0, 0x0)\n\t/home/jenkins/agent/workspace/tikv_ghpr_integration-copr-test/tidb/expression/builtin_compare_vec_generated.go:1859 +0x189\ngithub.com/pingcap/tidb/expression.(*ScalarFunction).VecEvalString(0xc005fe8c80, 0x3be6c80, 0xc001142ff0, 0xc00a5b97c0, 0xc00348a150, 0x0, 0x0)\n\t/home/jenkins/agent/workspace/tikv_ghpr_integration-copr-test/tidb/expression/scalar_function.go:61 +0x4b\ngithub.com/pingcap/tidb/expression.(*builtinStrcmpSig).vecEvalInt(0xc00136a790, 0xc00a5b97c0, 0xc00782dd50, 0x0, 0x0)\n\t/home/jenkins/agent/workspace/tikv_ghpr_integration-copr-test/tidb/expression/builtin_string_vec.go:1177 +0x243\ngithub.com/pingcap/tidb/expression.(*ScalarFunction).VecEvalInt(0xc005fe8cd0, 0x3be6c80, 0xc001142ff0, 0xc00a5b97c0, 0xc00782dd50, 0xc00046cca8, 0x1ec2960)\n\t/home/jenkins/agent/workspace/tikv_ghpr_integration-copr-test/tidb/expression/scalar_function.go:51 +0x4b\ngithub.com/pingcap/tidb/expression.evalOneVec(0x3be6c80, 0xc001142ff0, 0x3c17e40, 0xc005fe8cd0, 0xc00a5b97c0, 0xc00a5b9810, 0xd, 0xc00046cee8, 0x2b69713)\n\t/home/jenkins/agent/workspace/tikv_ghpr_integration-copr-test/tidb/expression/chunk_executor.go:123 +0x459\ngithub.com/pingcap/tidb/expression.(*defaultEvaluator).run(0xc004d96ec0, 0"]
[2020-08-25T11:01:27.546Z] [2020/08/25 19:01:05.074 +08:00] [ERROR] [conn.go:744] ["command dispatched failed"] [conn=38] [connInfo="id:38, addr:127.0.0.1:18736 status:10, collation:utf8_general_ci, user:root"] [command=Query] [status="inTxn:0, autocommit:1"] [sql=" SELECT STRCMP( ( `col_double_key` <=> `col_tinyint_unsigned_key` ), ( COALESCE( `col_varchar_1_key`, 613896924205940736, ( `col_int_key` > ( ( LEAST( `col_blob`, `col_enum` ) ) <=> ( `col_double_unsigned` NOT IN ( -2619124658292654080, ( '1997-05-24' LIKE ( ( ( 'asrpqaqrasisjngjaugvywtekbvahezvxxcihhakdstkwxudygixivxzpetimpnsumistumumeopraadbqujmpiqbhfjafgerliznrpxgpdlhkodjpmewmgfzgpxfikdodqftyppixekgmpyuospgksueegnafoeajdcsopomtithdxzndswkzgtbulphegfzttopmpwnlt' BETWEEN ( 31571 != '17:51:34.012966' ) AND `col_bigint_unsigned_key` ) != '1979-07-23' ) != 0 ) ), `col_decimal_unsigned`, '2033-02-16 17:01:01.015415', ( GREATEST( `col_binary_8_key`, '2030-01-13 10:57:36.017758', `col_tinyint` ) ) ) ) ) ), '1993-07-10 21:03:03.021372', '2034-06-16' ) ) ) AS field1 FROM `table10_int_autoinc` WHERE `col_bigint_key` <> ( `col_varbinary_32_key` <> '1982-01-20 00:37:32.057740' ) ORDER BY field1 LIMIT 1 /* QNO 1569 CON_ID 196 */ ;"] [txn_mode=PESSIMISTIC] [err="should ensure all columns have the same length\ngithub.com/pingcap/tidb/executor.recoveryProjection\n\t/home/jenkins/agent/workspace/tikv_ghpr_integration-copr-test/tidb/executor/projection.go:444\ngithub.com/pingcap/tidb/executor.(*projectionWorker).run.func1\n\t/home/jenkins/agent/workspace/tikv_ghpr_integration-copr-test/tidb/executor/projection.go:414\nruntime.gopanic\n\t/usr/local/go/src/runtime/panic.go:679\ngithub.com/pingcap/tidb/util/chunk.(*Column).MergeNulls\n\t/home/jenkins/agent/workspace/tikv_ghpr_integration-copr-test/tidb/util/chunk/column.go:706\ngithub.com/pingcap/tidb/expression.(*builtinCastStringAsRealSig).vecEvalReal\n\t/home/jenkins/agent/workspace/tikv_ghpr_integration-copr-test/tidb/expression/builtin_cast_vec.go:1558\ngithub.com/pingcap/tidb/expression.(*ScalarFunction).VecEvalReal\n\t/home/jenkins/agent/workspace/tikv_ghpr_integration-copr-test/tidb/expression/scalar_function.go:56\ngithub.com/pingcap/tidb/expression.(*builtinNullEQRealSig).vecEvalInt\n\t/home/jenkins/agent/workspace/tikv_ghpr_integration-copr-test/tidb/expression/builtin_compare_vec_generated.go:1519\ngithub.com/pingcap/tidb/expression.(*ScalarFunction).VecEvalInt\n\t/home/jenkins/agent/workspace/tikv_ghpr_integration-copr-test/tidb/expression/scalar_function.go:51\ngithub.com/pingcap/tidb/expression.(*builtinGTIntSig).vecEvalInt\n\t/home/jenkins/agent/workspace/tikv_ghpr_integration-copr-test/tidb/expression/builtin_compare_vec.go:369\ngithub.com/pingcap/tidb/expression.(*ScalarFunction).VecEvalInt\n\t/home/jenkins/agent/workspace/tikv_ghpr_integration-copr-test/tidb/expression/scalar_function.go:51\ngithub.com/pingcap/tidb/expression.(*builtinCastIntAsStringSig).vecEvalString\n\t/home/jenkins/agent/workspace/tikv_ghpr_integration-copr-test/tidb/expression/builtin_cast_vec.go:630\ngithub.com/pingcap/tidb/expression.(*ScalarFunction).VecEvalString\n\t/home/jenkins/agent/workspace/tikv_ghpr_integration-copr-test/tidb/expression/scalar_function.go:61\ngithub.com/pingcap/tidb/expression.(*builtinCoalesceStringSig).vecEvalString\n\t/home/jenkins/agent/workspace/tikv_ghpr_integration-copr-test/tidb/expression/builtin_compare_vec_generated.go:1859\ngithub.com/pingcap/tidb/expression.(*ScalarFunction).VecEvalString\n\t/home/jenkins/agent/workspace/tikv_ghpr_integration-copr-test/tidb/expression/scalar_function.go:61\ngithub.com/pingcap/tidb/expression.(*builtinStrcmpSig).vecEvalInt\n\t/home/jenkins/agent/workspace/tikv_ghpr_integration-copr-test/tidb/expression/builtin_string_vec.go:1177\ngithub.com/pingcap/tidb/expression.(*ScalarFunction).VecEvalInt\n\t/home/jenkins/agent/workspace/tikv_ghpr_integration-copr-test/tidb/expression/scalar_function.go:51\ngithub.com/pingcap/tidb/expression.evalOneVec\n\t/home/jenkins/agent/workspace/tikv_ghpr_integration-copr-test/tidb/expression/chunk_executor.go:123\ngithub.com/pingcap/tidb/expression.(*defaultEvaluator).run\n\t/home/jenkins/agent/workspace/tikv_ghpr_integration-copr-test/tidb/expression/evaluator.go:51\ngithub.com/pingcap/tidb/expression.(*EvaluatorSuite).Run\n\t/home/jenkins/agent/workspace/tikv_ghpr_integration-copr-test/tidb/expression/evaluator.go:123\ngithub.com/pingcap/tidb/executor.(*projectionWorker).run\n\t/home/jenkins/agent/workspace/tikv_ghpr_integration-copr-test/tidb/executor/projection.go:430\nruntime.goexit\n\t/usr/local/go/src/runtime/asm_amd64.s:1357"]

breezewish added the type/bug The issue is confirmed as a bug. label Apr 8, 2020

zz-jason added the component/expression label Apr 14, 2020

zz-jason assigned XuHuaiyu Apr 14, 2020

SunRunAway added the component/test label Apr 17, 2020

SunRunAway added this to the v4.0.2 milestone Jun 1, 2020

zz-jason modified the milestones: v4.0.2, v4.0.3 Jun 19, 2020

winoros modified the milestones: v4.0.3, v4.0.4 Jul 14, 2020

imtbkcat modified the milestones: v4.0.4, v4.0.5 Jul 28, 2020

imtbkcat modified the milestones: v4.0.5, v4.0.6 Aug 4, 2020

XuHuaiyu mentioned this issue Aug 4, 2020

expression: check ErrTruncate/Overflow for CastRealAsDecimalSig #18961

Merged

XuHuaiyu modified the milestones: v4.0.6, v4.0.5 Aug 4, 2020

XuHuaiyu closed this as completed in #18961 Aug 4, 2020

ti-srebot mentioned this issue Aug 4, 2020

expression: check ErrTruncate/Overflow for CastRealAsDecimalSig (#18961) #18967

Merged

sre-bot added the severity/minor label Aug 10, 2020

SunRunAway reopened this Aug 26, 2020

qw4990 mentioned this issue Sep 3, 2020

expression: fix unmatched column lengths errors caused by builtinGreatestStringSig and builtinLeastStringSig #19754

Merged

qw4990 closed this as completed in #19754 Sep 3, 2020

ti-srebot mentioned this issue Sep 3, 2020

expression: fix unmatched column lengths errors ca ... (#19754) #19758

Merged

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

Error 1105: should ensure all columns have the same length #16147

Error 1105: should ensure all columns have the same length #16147

breezewish commented Apr 8, 2020

XuHuaiyu commented Apr 9, 2020

SunRunAway commented Jun 30, 2020

XuHuaiyu commented Aug 3, 2020

SunRunAway commented Aug 26, 2020

qw4990 commented Aug 27, 2020

breezewish commented Aug 27, 2020 •

edited

Loading

Error 1105: should ensure all columns have the same length #16147

Error 1105: should ensure all columns have the same length #16147

Comments

breezewish commented Apr 8, 2020

Bug Report

1. What did you do?

2. What did you expect to see?

3. What did you see instead?

4. What version of TiDB are you using? (tidb-server -V or run select tidb_version(); on TiDB)

XuHuaiyu commented Apr 9, 2020

SunRunAway commented Jun 30, 2020

XuHuaiyu commented Aug 3, 2020

SunRunAway commented Aug 26, 2020

qw4990 commented Aug 27, 2020

breezewish commented Aug 27, 2020 • edited Loading

4. What version of TiDB are you using? (`tidb-server -V` or run `select tidb_version();` on TiDB)

breezewish commented Aug 27, 2020 •

edited

Loading