[MDEV-17963] Assertion `field_pos < field_count' failed in Protocol_text::store, Assertion `field_handlers == 0 || field_pos < field_count' - Jira

Details

Type: Bug
Status: Closed (View Workflow)
Priority: Critical
Resolution: Fixed
Affects Version/s: 10.1(EOL), 10.2(EOL), 10.3(EOL), 10.4(EOL)
Fix Version/s: 10.2.26, 10.1.41, 10.3.17, 10.4.7, 10.5.0
Component/s: Optimizer
Labels:
None

Description

CREATE TABLE t1 (ct time);

INSERT INTO t1 VALUES ('16:11:28');

DELIMITER @@@;

CREATE FUNCTION f1 () RETURNS varchar(100)

BEGIN

DECLARE xxx varchar(100);

ANALYZE SELECT sum(ct) FROM t1 INTO xxx ;

RETURN xxx;

END@@@

DELIMITER ;@@@

--error 2000

SELECT f1();

--error 0

SELECT f1();

10.2 0d7cf06af5c952f4beaf2
mysqld: /10.2/src/sql/protocol.cc:1119: virtual bool Protocol_text::store(const char, size_t, CHARSET_INFO): Assertion `field_pos < field_count' failed.

stdlib/abort.c:91(__GI_abort)[0x7fb4930ff02a]
assert/assert.c:92(__assert_fail_base)[0x7fb4930f5bd7]
/lib/x86_64-linux-gnu/libc.so.6(+0x2dc82)[0x7fb4930f5c82]
sql/protocol.cc:1120(Protocol_text::store(char const, unsigned long, charset_info_st const))[0x55d546f3a851]
sql/item.cc:6864(Item::send(Protocol, String))[0x55d547719f29]
sql/protocol.cc:979(Protocol::send_result_set_row(List<Item>*))[0x55d546f39adc]
sql/sql_class.cc:2708(select_send::send_data(List<Item>&))[0x55d5470536f0]
sql/sql_select.cc:3495(JOIN::exec_inner())[0x55d5471a59f7]
sql/sql_select.cc:3417(JOIN::exec())[0x55d5471a4874]
sql/sql_select.cc:3818(mysql_select(THD, TABLE_LIST, unsigned int, List<Item>&, Item, unsigned int, st_order, st_order, Item, st_order, unsigned long long, select_result, st_select_lex_unit, st_select_lex))[0x55d5471a7bc1]
sql/sql_select.cc:376(handle_select(THD, LEX, select_result*, unsigned long))[0x55d5471873dd]
sql/sql_parse.cc:6479(execute_sqlcom_select(THD, TABLE_LIST))[0x55d54710df28]
sql/sql_parse.cc:3485(mysql_execute_command(THD*))[0x55d5470faf21]
sql/sql_parse.cc:8013(mysql_parse(THD, char, unsigned int, Parser_state*, bool, bool))[0x55d54711668d]
sql/sql_parse.cc:1826(dispatch_command(enum_server_command, THD, char, unsigned int, bool, bool))[0x55d5470f1b74]
sql/sql_parse.cc:1378(do_command(THD*))[0x55d5470eed28]
sql/sql_connect.cc:1335(do_handle_one_connection(CONNECT*))[0x55d547414be4]
sql/sql_connect.cc:1242(handle_one_connection)[0x55d5474145ec]
/lib/x86_64-linux-gnu/libpthread.so.0(+0x76ba)[0x7fb493d3a6ba]
x86_64/clone.S:111(clone)[0x7fb4931cf41d]

Attachments

Issue Links

is duplicated by

MDEV-19971 Assertion `field_handlers == 0 || field_pos < field_count' failed in Protocol_text::store

Closed

relates to

MDEV-7023 Error 2027: Malformed packet and assertion `field_types == 0 || field_types[field_pos] == MYSQL_TYPE_INT24 || field_types[field_pos] == MYSQL_TYPE_LONG' failure in Protocol_text::store_long

Closed

Activity

Ascending order - Click to sort in descending order

Alice Sherepa created issue - 2018-12-10 12:39

Alice Sherepa made changes - 2018-12-10 16:01

Field	Original Value	New Value
Description	{noformat} mysqld: /git/10.4/sql/protocol.cc:1120: virtual bool Protocol_text::store(const char, size_t, CHARSET_INFO): Assertion `field_types == 0 \|\| field_pos < field_count' failed. 181210 13:29:59 [ERROR] mysqld got signal 6 ; Server version: 10.4.1-MariaDB-debug-log stdlib/abort.c:91(__GI_abort)[0x7f8a270a402a] assert/assert.c:92(__assert_fail_base)[0x7f8a2709abd7] /lib/x86_64-linux-gnu/libc.so.6(+0x2dc82)[0x7f8a2709ac82] sql/protocol.cc:1121(Protocol_text::store(char const, unsigned long, charset_info_st const))[0x560e77bcb0bb] sql/sql_type.cc:6417(Type_handler::Item_send_str(Item, Protocol, st_value) const)[0x560e782a751e] sql/sql_type.h:4338(Type_handler_string_result::Item_send(Item, Protocol, st_value) const)[0x560e782b9542] /git/10.4/sql/mysqld(+0xe4dd10)[0x560e77bd6d10] sql/item.h:1014(Item::send(Protocol, st_value))[0x560e77bca02e] sql/protocol.cc:986(Protocol::send_result_set_row(List<Item>))[0x560e77d35e2e] sql/sql_class.cc:2949(select_send::send_data(List<Item>&))[0x560e77ed48f8] sql/sql_select.cc:3967(JOIN::exec_inner())[0x560e77ed37e4] sql/sql_select.cc:3889(JOIN::exec())[0x560e77ed6c13] sql/sql_select.cc:4295(mysql_select(THD, TABLE_LIST, unsigned int, List<Item>&, Item, unsigned int, st_order, st_order, Item, st_order, unsigned long long, select_result, st_select_lex_unit, st_select_lex))[0x560e77eb0eae] sql/sql_select.cc:385(handle_select(THD, LEX, select_result, unsigned long))[0x560e77e36e90] sql/sql_parse.cc:6566(execute_sqlcom_select(THD, TABLE_LIST))[0x560e77e255c3] sql/sql_parse.cc:3775(mysql_execute_command(THD))[0x560e77e3f444] sql/sql_parse.cc:8103(mysql_parse(THD, char, unsigned int, Parser_state, bool, bool))[0x560e77e1a266] sql/sql_parse.cc:1852(dispatch_command(enum_server_command, THD, char, unsigned int, bool, bool))[0x560e77e173fe] sql/sql_parse.cc:1395(do_command(THD))[0x560e7816e4db] sql/sql_connect.cc:1402(do_handle_one_connection(CONNECT))[0x560e7816deb8] /lib/x86_64-linux-gnu/libpthread.so.0(+0x76ba)[0x7f8a27cdf6ba] x86_64/clone.S:111(clone)[0x7f8a2717441d] {noformat}	{code:sql} CREATE TABLE t1 (ct time); INSERT INTO t1 VALUES ('16:11:28'); DELIMITER @@@; CREATE FUNCTION f1 () RETURNS varchar(100) BEGIN DECLARE xxx varchar(100); ANALYZE SELECT sum(ct) FROM t1 INTO xxx ; RETURN xxx; END@@@ DELIMITER ;@@@ --error 2000 SELECT f1(); --error 0 SELECT f1(); {code} {noformat:title=10.2 0d7cf06af5c952f4beaf2} mysqld: /10.2/src/sql/protocol.cc:1119: virtual bool Protocol_text::store(const char, size_t, CHARSET_INFO): Assertion `field_pos < field_count' failed. 181210 16:57:49 [ERROR] mysqld got signal 6 ; Server version: 10.2.20-MariaDB-debug stdlib/abort.c:91(__GI_abort)[0x7fb4930ff02a] assert/assert.c:92(__assert_fail_base)[0x7fb4930f5bd7] /lib/x86_64-linux-gnu/libc.so.6(+0x2dc82)[0x7fb4930f5c82] sql/protocol.cc:1120(Protocol_text::store(char const, unsigned long, charset_info_st const))[0x55d546f3a851] sql/item.cc:6864(Item::send(Protocol, String))[0x55d547719f29] sql/protocol.cc:979(Protocol::send_result_set_row(List<Item>))[0x55d546f39adc] sql/sql_class.cc:2708(select_send::send_data(List<Item>&))[0x55d5470536f0] sql/sql_select.cc:3495(JOIN::exec_inner())[0x55d5471a59f7] sql/sql_select.cc:3417(JOIN::exec())[0x55d5471a4874] sql/sql_select.cc:3818(mysql_select(THD, TABLE_LIST, unsigned int, List<Item>&, Item, unsigned int, st_order, st_order, Item, st_order, unsigned long long, select_result, st_select_lex_unit, st_select_lex))[0x55d5471a7bc1] sql/sql_select.cc:376(handle_select(THD, LEX, select_result, unsigned long))[0x55d5471873dd] sql/sql_parse.cc:6479(execute_sqlcom_select(THD, TABLE_LIST))[0x55d54710df28] sql/sql_parse.cc:3485(mysql_execute_command(THD))[0x55d5470faf21] sql/sql_parse.cc:8013(mysql_parse(THD, char, unsigned int, Parser_state, bool, bool))[0x55d54711668d] sql/sql_parse.cc:1826(dispatch_command(enum_server_command, THD, char, unsigned int, bool, bool))[0x55d5470f1b74] sql/sql_parse.cc:1378(do_command(THD))[0x55d5470eed28] sql/sql_connect.cc:1335(do_handle_one_connection(CONNECT))[0x55d547414be4] sql/sql_connect.cc:1242(handle_one_connection)[0x55d5474145ec] /lib/x86_64-linux-gnu/libpthread.so.0(+0x76ba)[0x7fb493d3a6ba] x86_64/clone.S:111(clone)[0x7fb4931cf41d] {noformat}

Alice Sherepa made changes - 2018-12-10 16:01

Description

{code:sql}
CREATE TABLE t1 (ct time);
INSERT INTO t1 VALUES ('16:11:28');

DELIMITER @@@;
CREATE FUNCTION f1 () RETURNS varchar(100)
BEGIN
DECLARE xxx varchar(100);
ANALYZE SELECT sum(ct) FROM t1 INTO xxx ;
RETURN xxx;
END@@@

DELIMITER ;@@@
--error 2000
SELECT f1();
--error 0
SELECT f1();
{code}

{noformat:title=10.2 0d7cf06af5c952f4beaf2}
mysqld: /10.2/src/sql/protocol.cc:1119: virtual bool Protocol_text::store(const char*, size_t, CHARSET_INFO*): Assertion `field_pos < field_count' failed.
181210 16:57:49 [ERROR] mysqld got signal 6 ;

Server version: 10.2.20-MariaDB-debug

stdlib/abort.c:91(__GI_abort)[0x7fb4930ff02a]
assert/assert.c:92(__assert_fail_base)[0x7fb4930f5bd7]
/lib/x86_64-linux-gnu/libc.so.6(+0x2dc82)[0x7fb4930f5c82]
sql/protocol.cc:1120(Protocol_text::store(char const*, unsigned long, charset_info_st const*))[0x55d546f3a851]
sql/item.cc:6864(Item::send(Protocol*, String*))[0x55d547719f29]
sql/protocol.cc:979(Protocol::send_result_set_row(List<Item>*))[0x55d546f39adc]
sql/sql_class.cc:2708(select_send::send_data(List<Item>&))[0x55d5470536f0]
sql/sql_select.cc:3495(JOIN::exec_inner())[0x55d5471a59f7]
sql/sql_select.cc:3417(JOIN::exec())[0x55d5471a4874]
sql/sql_select.cc:3818(mysql_select(THD*, TABLE_LIST*, unsigned int, List<Item>&, Item*, unsigned int, st_order*, st_order*, Item*, st_order*, unsigned long long, select_result*, st_select_lex_unit*, st_select_lex*))[0x55d5471a7bc1]
sql/sql_select.cc:376(handle_select(THD*, LEX*, select_result*, unsigned long))[0x55d5471873dd]
sql/sql_parse.cc:6479(execute_sqlcom_select(THD*, TABLE_LIST*))[0x55d54710df28]
sql/sql_parse.cc:3485(mysql_execute_command(THD*))[0x55d5470faf21]
sql/sql_parse.cc:8013(mysql_parse(THD*, char*, unsigned int, Parser_state*, bool, bool))[0x55d54711668d]
sql/sql_parse.cc:1826(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool, bool))[0x55d5470f1b74]
sql/sql_parse.cc:1378(do_command(THD*))[0x55d5470eed28]
sql/sql_connect.cc:1335(do_handle_one_connection(CONNECT*))[0x55d547414be4]
sql/sql_connect.cc:1242(handle_one_connection)[0x55d5474145ec]
/lib/x86_64-linux-gnu/libpthread.so.0(+0x76ba)[0x7fb493d3a6ba]
x86_64/clone.S:111(clone)[0x7fb4931cf41d]
{noformat}

{code:sql}
CREATE TABLE t1 (ct time);
INSERT INTO t1 VALUES ('16:11:28');

DELIMITER @@@;
CREATE FUNCTION f1 () RETURNS varchar(100)
BEGIN
DECLARE xxx varchar(100);
ANALYZE SELECT sum(ct) FROM t1 INTO xxx ;
RETURN xxx;
END@@@

DELIMITER ;@@@
--error 2000
SELECT f1();
--error 0
SELECT f1();
{code}

{noformat:title=10.2 0d7cf06af5c952f4beaf2}
mysqld: /10.2/src/sql/protocol.cc:1119: virtual bool Protocol_text::store(const char*, size_t, CHARSET_INFO*): Assertion `field_pos < field_count' failed.

stdlib/abort.c:91(__GI_abort)[0x7fb4930ff02a]
assert/assert.c:92(__assert_fail_base)[0x7fb4930f5bd7]
/lib/x86_64-linux-gnu/libc.so.6(+0x2dc82)[0x7fb4930f5c82]
sql/protocol.cc:1120(Protocol_text::store(char const*, unsigned long, charset_info_st const*))[0x55d546f3a851]
sql/item.cc:6864(Item::send(Protocol*, String*))[0x55d547719f29]
sql/protocol.cc:979(Protocol::send_result_set_row(List<Item>*))[0x55d546f39adc]
sql/sql_class.cc:2708(select_send::send_data(List<Item>&))[0x55d5470536f0]
sql/sql_select.cc:3495(JOIN::exec_inner())[0x55d5471a59f7]
sql/sql_select.cc:3417(JOIN::exec())[0x55d5471a4874]
sql/sql_select.cc:3818(mysql_select(THD*, TABLE_LIST*, unsigned int, List<Item>&, Item*, unsigned int, st_order*, st_order*, Item*, st_order*, unsigned long long, select_result*, st_select_lex_unit*, st_select_lex*))[0x55d5471a7bc1]
sql/sql_select.cc:376(handle_select(THD*, LEX*, select_result*, unsigned long))[0x55d5471873dd]
sql/sql_parse.cc:6479(execute_sqlcom_select(THD*, TABLE_LIST*))[0x55d54710df28]
sql/sql_parse.cc:3485(mysql_execute_command(THD*))[0x55d5470faf21]
sql/sql_parse.cc:8013(mysql_parse(THD*, char*, unsigned int, Parser_state*, bool, bool))[0x55d54711668d]
sql/sql_parse.cc:1826(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool, bool))[0x55d5470f1b74]
sql/sql_parse.cc:1378(do_command(THD*))[0x55d5470eed28]
sql/sql_connect.cc:1335(do_handle_one_connection(CONNECT*))[0x55d547414be4]
sql/sql_connect.cc:1242(handle_one_connection)[0x55d5474145ec]
/lib/x86_64-linux-gnu/libpthread.so.0(+0x76ba)[0x7fb493d3a6ba]
x86_64/clone.S:111(clone)[0x7fb4931cf41d]
{noformat}

Alice Sherepa made changes - 2018-12-10 16:02

Affects Version/s		10.1 [ 16100 ]
Affects Version/s		10.2 [ 14601 ]
Affects Version/s		10.3 [ 22126 ]

Alice Sherepa made changes - 2018-12-10 16:12

Fix Version/s		10.1 [ 16100 ]
Fix Version/s		10.2 [ 14601 ]
Fix Version/s		10.3 [ 22126 ]
Fix Version/s		10.4 [ 22408 ]

Alice Sherepa made changes - 2018-12-10 16:12

Status

Open [ 1 ]

Confirmed [ 10101 ]

Alice Sherepa made changes - 2018-12-10 16:12

Assignee

Alice Sherepa [ alice ]

Sergei Petrunia [ psergey ]

Alice Sherepa made changes - 2018-12-10 17:49

Summary

[draft] Assertion `field_types == 0 || field_pos < field_count' failed in Protocol_text::store

Assertion `field_types == 0 || field_pos < field_count' failed in Protocol_text::store

Alice Sherepa made changes - 2019-07-05 15:59

Summary

Assertion `field_types == 0 || field_pos < field_count' failed in Protocol_text::store

Assertion `field_pos < field_count' failed in Protocol_text::store

Alice Sherepa made changes - 2019-07-05 16:00

Link

This issue is duplicated by ~~MDEV-19971~~ [ ~~MDEV-19971~~ ]

Alice Sherepa made changes - 2019-07-05 16:02

Summary

Assertion `field_pos < field_count' failed in Protocol_text::store

Assertion `field_pos < field_count' failed in Protocol_text::store, Assertion `field_handlers == 0 || field_pos < field_count'

Sergei Golubchik made changes - 2019-07-05 16:16

Priority

Major [ 3 ]

Critical [ 2 ]

Sergei Golubchik made changes - 2019-07-05 16:16

Assignee

Sergei Petrunia [ psergey ]

Varun Gupta [ varun ]

Varun Gupta (Inactive) made changes - 2019-07-08 05:22

Link

This issue relates to ~~MDEV-7023~~ [ ~~MDEV-7023~~ ]

Varun Gupta (Inactive) made changes - 2019-07-08 05:23

Status

Confirmed [ 10101 ]

In Progress [ 3 ]

Varun Gupta (Inactive) made changes - 2019-07-08 06:11

Assignee	Varun Gupta [ varun ]	Sergei Petrunia [ psergey ]
Status	In Progress [ 3 ]	In Review [ 10002 ]

Varun Gupta (Inactive) made changes - 2019-07-09 04:56

Assignee

Sergei Petrunia [ psergey ]

Varun Gupta [ varun ]

Varun Gupta (Inactive) made changes - 2019-07-09 04:56

Component/s		Optimizer [ 10200 ]
Fix Version/s		10.1.41 [ 23406 ]
Fix Version/s		10.2.26 [ 23409 ]
Fix Version/s		10.3.17 [ 23411 ]
Fix Version/s		10.5.0 [ 23709 ]
Fix Version/s		10.4.7 [ 23720 ]
Fix Version/s	10.2 [ 14601 ]
Fix Version/s	10.1 [ 16100 ]
Fix Version/s	10.3 [ 22126 ]
Fix Version/s	10.4 [ 22408 ]
Resolution		Fixed [ 1 ]
Status	In Review [ 10002 ]	Closed [ 6 ]

Sergei Golubchik made changes - 2021-12-06 21:48

Workflow

MariaDB v3 [ 91144 ]

MariaDB v4 [ 155343 ]

People

Assignee:: Varun Gupta (Inactive)

Reporter:: Alice Sherepa

Votes:: 0 Vote for this issue

Watchers:: 4 Start watching this issue

Dates

Created:: 2018-12-10 12:39

Updated:: 2019-07-09 04:57

Resolved:: 2019-07-09 04:56

Git Integration

Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.

MariaDB Server

Details

Description

Attachments

Issue Links

Activity

People

Dates

Git Integration