Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
10.2(EOL), 10.3(EOL), 10.4(EOL), 10.5
-
None
Description
--source include/have_innodb.inc
|
|
SELECT * FROM INFORMATION_SCHEMA.`COLUMNS` LIMIT ROWS EXAMINED 10; |
10.2 debug 36c01167200 |
mysqld: /data/src/10.2/sql/sql_error.h:728: uint Diagnostics_area::sql_errno() const: Assertion `m_status == DA_ERROR' failed.
|
180413 13:17:52 [ERROR] mysqld got signal 6 ;
|
|
#7 0x00007f5bab788ee2 in __assert_fail () from /lib/x86_64-linux-gnu/libc.so.6
|
#8 0x00005649121e4658 in Diagnostics_area::sql_errno (this=0x7f5b5c005c90) at /data/src/10.2/sql/sql_error.h:728
|
#9 0x0000564912344b06 in fill_schema_table_by_open (thd=0x7f5b5c000b00, is_show_fields_or_keys=false, table=0x7f5b5c14a688, schema_table=0x564913642100 <schema_tables+320>, orig_db_name=0x7f5b5c03ac40, orig_table_name=0x7f5b5c092a48, open_tables_state_backup=0x7f5ba43f37f0, can_deadlock=false) at /data/src/10.2/sql/sql_show.cc:4383
|
#10 0x000056491234626d in get_all_tables (thd=0x7f5b5c000b00, tables=0x7f5b5c0128a8, cond=0x0) at /data/src/10.2/sql/sql_show.cc:5001
|
#11 0x000056491235641e in get_schema_tables_result (join=0x7f5b5c014998, executed_place=PROCESSED_BY_JOIN_EXEC) at /data/src/10.2/sql/sql_show.cc:8350
|
#12 0x00005649122f3d8b in JOIN::exec_inner (this=0x7f5b5c014998) at /data/src/10.2/sql/sql_select.cc:3530
|
#13 0x00005649122f3444 in JOIN::exec (this=0x7f5b5c014998) at /data/src/10.2/sql/sql_select.cc:3361
|
#14 0x00005649122f460f in mysql_select (thd=0x7f5b5c000b00, tables=0x7f5b5c0128a8, wild_num=1, fields=..., conds=0x0, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=2684619520, result=0x7f5b5c014978, unit=0x7f5b5c0046a8, select_lex=0x7f5b5c004de0) at /data/src/10.2/sql/sql_select.cc:3761
|
#15 0x00005649122e8c56 in handle_select (thd=0x7f5b5c000b00, lex=0x7f5b5c0045e0, result=0x7f5b5c014978, setup_tables_done_option=0) at /data/src/10.2/sql/sql_select.cc:376
|
#16 0x00005649122b4a12 in execute_sqlcom_select (thd=0x7f5b5c000b00, all_tables=0x7f5b5c0128a8) at /data/src/10.2/sql/sql_parse.cc:6472
|
#17 0x00005649122aaa99 in mysql_execute_command (thd=0x7f5b5c000b00) at /data/src/10.2/sql/sql_parse.cc:3483
|
#18 0x00005649122b845a in mysql_parse (thd=0x7f5b5c000b00, rawbuf=0x7f5b5c012640 "SELECT * FROM INFORMATION_SCHEMA.`COLUMNS` LIMIT ROWS EXAMINED 10", length=65, parser_state=0x7f5ba43f5200, is_com_multi=false, is_next_command=false) at /data/src/10.2/sql/sql_parse.cc:7918
|
#19 0x00005649122a632b in dispatch_command (command=COM_QUERY, thd=0x7f5b5c000b00, packet=0x7f5b5c008951 "SELECT * FROM INFORMATION_SCHEMA.`COLUMNS` LIMIT ROWS EXAMINED 10", packet_length=65, is_com_multi=false, is_next_command=false) at /data/src/10.2/sql/sql_parse.cc:1820
|
#20 0x00005649122a4c8e in do_command (thd=0x7f5b5c000b00) at /data/src/10.2/sql/sql_parse.cc:1374
|
#21 0x00005649123f3602 in do_handle_one_connection (connect=0x5649152c5e90) at /data/src/10.2/sql/sql_connect.cc:1335
|
#22 0x00005649123f338f in handle_one_connection (arg=0x5649152c5e90) at /data/src/10.2/sql/sql_connect.cc:1241
|
#23 0x000056491281357a in pfs_spawn_thread (arg=0x5649152297d0) at /data/src/10.2/storage/perfschema/pfs.cc:1862
|
#24 0x00007f5bad45f494 in start_thread (arg=0x7f5ba43f6700) at pthread_create.c:333
|
#25 0x00007f5bab84593f in clone () from /lib/x86_64-linux-gnu/libc.so.6
|
Non-debug build produces a number of strange warnings:
10.2 non-debug d18a66147c |
Warnings:
|
Warning 1105
|
Warning 1105
|
Warning 1105
|
...
|
Warning 1105
|
Reproducible on 10.2, 10.3. Not reproducible on 10.1.
Attachments
Issue Links
- causes
-
MDEV-23445 LIMIT ROWS EXAMINED throws error in Debug build only
-
- Closed
-
- relates to
-
MDEV-17729 Assertion `! is_set() || m_can_overwrite_status' failed in Diagnostics_area::set_error_status (LIMIT ROWS EXAMINED)
-
- Closed
-
-
MDEV-22266 Diagnostics_area::sql_errno() const: Assertion `m_status == DA_ERROR' failed on SELECT after setting tmp_disk_table_size.
-
- Closed
-
-
MDEV-19840 Assertion `m_status == DA_ERROR' failed in Diagnostics_area::sql_errno upon SELECT from I_S with concurrent locking
-
- Open
-
-
MDEV-24179 Assertion `m_status == DA_ERROR || m_status == DA_OK || m_status == DA_OK_BULK' failed in Diagnostics_area::message()
-
- Closed
-
Activity
Field | Original Value | New Value |
---|---|---|
Summary | Assertion `m_status == DA_ERROR' failed in Diagnostics_area::sql_errno | [Draft] Assertion `m_status == DA_ERROR' failed in Diagnostics_area::sql_errno |
Affects Version/s | 10.3 [ 22126 ] |
Affects Version/s | N/A [ 14700 ] |
Component/s | Admin statements [ 11400 ] | |
Fix Version/s | 10.2 [ 14601 ] | |
Fix Version/s | 10.3 [ 22126 ] | |
Affects Version/s | 10.2 [ 14601 ] | |
Description |
https://api.travis-ci.org/v3/job/323555912/log.txt
{noformat:title=bb-10.3-temporal a3a15126f260e26b715ae9a790135df1822b74d8} mysqld: /home/travis/src/sql/sql_error.h:1007: uint Diagnostics_area::sql_errno() const: Assertion `m_status == DA_ERROR' failed. 171231 14:58:55 [ERROR] mysqld got signal 6 ; Query (0x7f23fc013a88): INSERT INTO test.t1_is_columns_6979 SELECT TABLE_SCHEMA,TABLE_NAME,COLUMN_NAME,DATA_TYPE,COLUMN_DEFAULT,IS_NULLABLE,CHARACTER_MAXIMUM_LENGTH,CHARACTER_OCTET_LENGTH,NUMERIC_PRECISION,NUMERIC_SCALE,CHARACTER_SET_NAME,COLLATION_NAME,PRIVILEGES,COLUMN_COMMENT FROM information_schema.columns WHERE TABLE_SCHEMA LIKE 'test%' ORDER BY 1,2,3 /* QNO 22264 CON_ID 16 */ LIMIT ROWS EXAMINED 1 /* QNO 22280 CON_ID 16 */ Connection ID (thread ID): 16 Status: ABORT_QUERY {noformat} {noformat} #7 0x00007f2450ea4ec2 in __assert_fail () from /lib/x86_64-linux-gnu/libc.so.6 #8 0x00000000006cf072 in Diagnostics_area::sql_errno (this=0x7f23fc006098) at /home/travis/src/sql/sql_error.h:1007 #9 0x000000000084ba01 in fill_schema_table_by_open (thd=0x7f23fc000c70, mem_root=0x7f24394dd810, is_show_fields_or_keys=false, table=0x7f23fc127378, schema_table=0x1d20f00, orig_db_name=0x7f23fc1a0010, orig_table_name=0x7f23fc1a06d0, open_tables_state_backup=0x7f24394dd7b0, can_deadlock=true) at /home/travis/src/sql/sql_show.cc:4591 #10 0x000000000084d715 in get_all_tables (thd=0x7f23fc000c70, tables=0x7f23fc015570, cond=0x0) at /home/travis/src/sql/sql_show.cc:5287 #11 0x000000000085d188 in get_schema_tables_result (join=0x7f23fc017d30, executed_place=PROCESSED_BY_JOIN_EXEC) at /home/travis/src/sql/sql_show.cc:8660 #12 0x00000000007f7ee4 in JOIN::exec_inner (this=0x7f23fc017d30) at /home/travis/src/sql/sql_select.cc:4015 #13 0x00000000007f744a in JOIN::exec (this=0x7f23fc017d30) at /home/travis/src/sql/sql_select.cc:3846 #14 0x00000000007f888e in mysql_select (thd=0x7f23fc000c70, tables=0x7f23fc015570, wild_num=0, fields=..., conds=0x7f23fc015df8, og_num=3, order=0x7f23fc015fe0, group=0x0, having=0x0, proc_param=0x0, select_options=553782610688, result=0x7f23fc017c88, unit=0x7f23fc004a08, select_lex=0x7f23fc005160) at /home/travis/src/sql/sql_select.cc:4258 #15 0x00000000007eaa4a in handle_select (thd=0x7f23fc000c70, lex=0x7f23fc004940, result=0x7f23fc017c88, setup_tables_done_option=1073741824) at /home/travis/src/sql/sql_select.cc:382 #16 0x00000000007af569 in mysql_execute_command (thd=0x7f23fc000c70) at /home/travis/src/sql/sql_parse.cc:4814 #17 0x00000000007b9737 in mysql_parse (thd=0x7f23fc000c70, rawbuf=0x7f23fc013a88 "INSERT INTO test.t1_is_columns_6979 SELECT TABLE_SCHEMA,TABLE_NAME,COLUMN_NAME,DATA_TYPE,COLUMN_DEFAULT,IS_NULLABLE,CHARACTER_MAXIMUM_LENGTH,CHARACTER_OCTET_LENGTH,NUMERIC_PRECISION,NUMERIC_SCALE,CHAR"..., length=410, parser_state=0x7f24394df470, is_com_multi=false, is_next_command=false) at /home/travis/src/sql/sql_parse.cc:7991 #18 0x00000000007a6c36 in dispatch_command (command=COM_QUERY, thd=0x7f23fc000c70, packet=0x7f23fc135d51 " INSERT INTO test.t1_is_columns_6979 SELECT TABLE_SCHEMA,TABLE_NAME,COLUMN_NAME,DATA_TYPE,COLUMN_DEFAULT,IS_NULLABLE,CHARACTER_MAXIMUM_LENGTH,CHARACTER_OCTET_LENGTH,NUMERIC_PRECISION,NUMERIC_SCALE,CHA"..., packet_length=412, is_com_multi=false, is_next_command=false) at /home/travis/src/sql/sql_parse.cc:1825 #19 0x00000000007a565d in do_command (thd=0x7f23fc000c70) at /home/travis/src/sql/sql_parse.cc:1370 #20 0x000000000090b7cf in do_handle_one_connection (connect=0x4adb530) at /home/travis/src/sql/sql_connect.cc:1420 #21 0x000000000090b551 in handle_one_connection (arg=0x4adb530) at /home/travis/src/sql/sql_connect.cc:1326 #22 0x00007f2451a50e9a in start_thread () from /lib/x86_64-linux-gnu/libpthread.so.0 #23 0x00007f2450f6c2ed in clone () from /lib/x86_64-linux-gnu/libc.so.6 #24 0x0000000000000000 in ?? () {noformat} {noformat:title=experimental 8d1aafbbe8a1290c4930b0ac98ebd556b18be001} perl /home/travis/rqg/runall-new.pl --duration=350 --threads=6 --seed=1514732247 --reporters=Backtrace,ErrorLog,Deadlock --validators=TransformerNoComparator --transformers=ConvertSubqueriesToViews,ConvertTablesToDerived,Count,DisableOptimizations,Distinct,EnableOptimizations,ExecuteAsCTE,ExecuteAsDeleteReturning,ExecuteAsDerived,ExecuteAsExcept,ExecuteAsExecuteImmediate,ExecuteAsInsertSelect,ExecuteAsIntersect,ExecuteAsSelectItem,ExecuteAsUnion,ExecuteAsUpdateDelete,ExecuteAsView,ExecuteAsWhereSubquery,Having,InlineSubqueries,InlineVirtualColumns,LimitRowsExamined,OrderBy,StraightJoin,ExecuteAsPreparedTwice,ExecuteAsTrigger,ExecuteAsSPTwice,ExecuteAsFunctionTwice --redefine=conf/mariadb/general-workarounds.yy --mysqld=--log_output=FILE --mysqld=--log_bin_trust_function_creators=1 --mysqld=--log-bin --mysqld=--max-statement-time=30 --mysqld=--loose-debug_assert_on_not_freed_memory=0 --views --redefine=conf/mariadb/versioning.yy --basedir=/home/travis/server --grammar=conf/replication/replication-ddl_sql.yy --gendata=conf/replication/replication-ddl_data.zz --engine=MyISAM --mysqld=--default-storage-engine=MyISAM --vardir=/home/travis/logs/vardir1_3 {noformat} |
{code:sql}
--source include/have_innodb.inc SELECT * FROM INFORMATION_SCHEMA.`COLUMNS` LIMIT ROWS EXAMINED 10; {code} {noformat:title=10.2 debug 36c01167200} mysqld: /data/src/10.2/sql/sql_error.h:728: uint Diagnostics_area::sql_errno() const: Assertion `m_status == DA_ERROR' failed. 180413 13:17:52 [ERROR] mysqld got signal 6 ; #7 0x00007f5bab788ee2 in __assert_fail () from /lib/x86_64-linux-gnu/libc.so.6 #8 0x00005649121e4658 in Diagnostics_area::sql_errno (this=0x7f5b5c005c90) at /data/src/10.2/sql/sql_error.h:728 #9 0x0000564912344b06 in fill_schema_table_by_open (thd=0x7f5b5c000b00, is_show_fields_or_keys=false, table=0x7f5b5c14a688, schema_table=0x564913642100 <schema_tables+320>, orig_db_name=0x7f5b5c03ac40, orig_table_name=0x7f5b5c092a48, open_tables_state_backup=0x7f5ba43f37f0, can_deadlock=false) at /data/src/10.2/sql/sql_show.cc:4383 #10 0x000056491234626d in get_all_tables (thd=0x7f5b5c000b00, tables=0x7f5b5c0128a8, cond=0x0) at /data/src/10.2/sql/sql_show.cc:5001 #11 0x000056491235641e in get_schema_tables_result (join=0x7f5b5c014998, executed_place=PROCESSED_BY_JOIN_EXEC) at /data/src/10.2/sql/sql_show.cc:8350 #12 0x00005649122f3d8b in JOIN::exec_inner (this=0x7f5b5c014998) at /data/src/10.2/sql/sql_select.cc:3530 #13 0x00005649122f3444 in JOIN::exec (this=0x7f5b5c014998) at /data/src/10.2/sql/sql_select.cc:3361 #14 0x00005649122f460f in mysql_select (thd=0x7f5b5c000b00, tables=0x7f5b5c0128a8, wild_num=1, fields=..., conds=0x0, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=2684619520, result=0x7f5b5c014978, unit=0x7f5b5c0046a8, select_lex=0x7f5b5c004de0) at /data/src/10.2/sql/sql_select.cc:3761 #15 0x00005649122e8c56 in handle_select (thd=0x7f5b5c000b00, lex=0x7f5b5c0045e0, result=0x7f5b5c014978, setup_tables_done_option=0) at /data/src/10.2/sql/sql_select.cc:376 #16 0x00005649122b4a12 in execute_sqlcom_select (thd=0x7f5b5c000b00, all_tables=0x7f5b5c0128a8) at /data/src/10.2/sql/sql_parse.cc:6472 #17 0x00005649122aaa99 in mysql_execute_command (thd=0x7f5b5c000b00) at /data/src/10.2/sql/sql_parse.cc:3483 #18 0x00005649122b845a in mysql_parse (thd=0x7f5b5c000b00, rawbuf=0x7f5b5c012640 "SELECT * FROM INFORMATION_SCHEMA.`COLUMNS` LIMIT ROWS EXAMINED 10", length=65, parser_state=0x7f5ba43f5200, is_com_multi=false, is_next_command=false) at /data/src/10.2/sql/sql_parse.cc:7918 #19 0x00005649122a632b in dispatch_command (command=COM_QUERY, thd=0x7f5b5c000b00, packet=0x7f5b5c008951 "SELECT * FROM INFORMATION_SCHEMA.`COLUMNS` LIMIT ROWS EXAMINED 10", packet_length=65, is_com_multi=false, is_next_command=false) at /data/src/10.2/sql/sql_parse.cc:1820 #20 0x00005649122a4c8e in do_command (thd=0x7f5b5c000b00) at /data/src/10.2/sql/sql_parse.cc:1374 #21 0x00005649123f3602 in do_handle_one_connection (connect=0x5649152c5e90) at /data/src/10.2/sql/sql_connect.cc:1335 #22 0x00005649123f338f in handle_one_connection (arg=0x5649152c5e90) at /data/src/10.2/sql/sql_connect.cc:1241 #23 0x000056491281357a in pfs_spawn_thread (arg=0x5649152297d0) at /data/src/10.2/storage/perfschema/pfs.cc:1862 #24 0x00007f5bad45f494 in start_thread (arg=0x7f5ba43f6700) at pthread_create.c:333 #25 0x00007f5bab84593f in clone () from /lib/x86_64-linux-gnu/libc.so.6 {noformat} Non-debug build produces a number of strange warnings: {noformat:title=10.2 non-debug d18a66147c} Warnings: Warning 1105 Warning 1105 Warning 1105 ... Warning 1105 {noformat} Reproducible on 10.2, 10.3. Not reproducible on 10.1. |
Summary | [Draft] Assertion `m_status == DA_ERROR' failed in Diagnostics_area::sql_errno | Assertion `m_status == DA_ERROR' failed in Diagnostics_area::sql_errno upon query from I_S with LIMIT ROWS EXAMINED |
Assignee | Elena Stepanova [ elenst ] | Sergei Golubchik [ serg ] |
Status | Open [ 1 ] | Confirmed [ 10101 ] |
Fix Version/s | 10.4 [ 22408 ] | |
Affects Version/s | 10.4 [ 22408 ] |
Comment | [ Same or one of numerous identical assertion failures on 10.3: https://api.travis-ci.org/v3/job/355459864/log.txt ] |
Comment | [ Same or one of numerous identical assertion failures on 10.3: https://api.travis-ci.org/v3/job/361918546/log.txt ] |
Affects Version/s | 10.5 [ 23123 ] |
Fix Version/s | 10.5 [ 23123 ] |
Link |
This issue relates to |
Assignee | Sergei Golubchik [ serg ] | Rucha Deodhar [ rucha174 ] |
Status | Confirmed [ 10101 ] | In Progress [ 3 ] |
Link |
This issue relates to |
Assignee | Rucha Deodhar [ rucha174 ] | Sergei Golubchik [ serg ] |
Status | In Progress [ 3 ] | In Review [ 10002 ] |
Assignee | Sergei Golubchik [ serg ] | Rucha Deodhar [ rucha174 ] |
Status | In Review [ 10002 ] | Stalled [ 10000 ] |
Link | This issue relates to MDEV-19840 [ MDEV-19840 ] |
Status | Stalled [ 10000 ] | In Progress [ 3 ] |
Status | In Progress [ 3 ] | In Review [ 10002 ] |
Assignee | Rucha Deodhar [ rucha174 ] | Sergei Golubchik [ serg ] |
Assignee | Sergei Golubchik [ serg ] | Rucha Deodhar [ rucha174 ] |
Status | In Review [ 10002 ] | Stalled [ 10000 ] |
issue.field.resolutiondate | 2020-08-04 05:31:46.0 | 2020-08-04 05:31:46.893 |
Fix Version/s | 10.2.33 [ 24307 ] | |
Fix Version/s | 10.3.24 [ 24306 ] | |
Fix Version/s | 10.4.14 [ 24305 ] | |
Fix Version/s | 10.5.5 [ 24423 ] | |
Fix Version/s | 10.2 [ 14601 ] | |
Fix Version/s | 10.3 [ 22126 ] | |
Fix Version/s | 10.4 [ 22408 ] | |
Fix Version/s | 10.5 [ 23123 ] | |
Resolution | Fixed [ 1 ] | |
Status | Stalled [ 10000 ] | Closed [ 6 ] |
Fix Version/s | 10.2.34 [ 24505 ] | |
Fix Version/s | 10.3.25 [ 24506 ] | |
Fix Version/s | 10.4.15 [ 24507 ] | |
Fix Version/s | 10.5.6 [ 24508 ] | |
Fix Version/s | 10.4.14 [ 24305 ] | |
Fix Version/s | 10.3.24 [ 24306 ] | |
Fix Version/s | 10.2.33 [ 24307 ] | |
Fix Version/s | 10.5.5 [ 24423 ] |
Link |
This issue causes |
Fix Version/s | 10.5.7 [ 25019 ] |
Fix Version/s | 10.5.6 [ 24508 ] |
Fix Version/s | 10.4.16 [ 25020 ] |
Fix Version/s | 10.4.15 [ 24507 ] |
Fix Version/s | 10.3.26 [ 25021 ] |
Fix Version/s | 10.3.25 [ 24506 ] |
Fix Version/s | 10.2.35 [ 25022 ] |
Fix Version/s | 10.2.34 [ 24505 ] |
Link |
This issue relates to |
Workflow | MariaDB v3 [ 84686 ] | MariaDB v4 [ 153487 ] |
Patch: https://github.com/MariaDB/server/commit/0dd0bbe54e11260e67fd17e0280a29a93d22e624