Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-14836

Assertion `m_status == DA_ERROR' failed in Diagnostics_area::sql_errno upon query from I_S with LIMIT ROWS EXAMINED

Details

    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

          Activity

            elenst Elena Stepanova created issue -
            elenst Elena Stepanova made changes -
            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
            elenst Elena Stepanova made changes -
            Affects Version/s 10.3 [ 22126 ]
            elenst Elena Stepanova made changes -
            Affects Version/s N/A [ 14700 ]
            elenst Elena Stepanova made changes -
            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
            elenst Elena Stepanova made changes -
            Assignee Elena Stepanova [ elenst ] Sergei Golubchik [ serg ]
            alice Alice Sherepa made changes -
            Status Open [ 1 ] Confirmed [ 10101 ]
            elenst Elena Stepanova made changes -
            Fix Version/s 10.4 [ 22408 ]
            Affects Version/s 10.4 [ 22408 ]
            elenst Elena Stepanova made changes -
            Comment [ Same or one of numerous identical assertion failures on 10.3: https://api.travis-ci.org/v3/job/355459864/log.txt ]
            elenst Elena Stepanova made changes -
            Comment [ Same or one of numerous identical assertion failures on 10.3: https://api.travis-ci.org/v3/job/361918546/log.txt ]
            alice Alice Sherepa made changes -
            Affects Version/s 10.5 [ 23123 ]
            alice Alice Sherepa made changes -
            Fix Version/s 10.5 [ 23123 ]
            alice Alice Sherepa made changes -
            serg Sergei Golubchik made changes -
            Assignee Sergei Golubchik [ serg ] Rucha Deodhar [ rucha174 ]
            rucha174 Rucha Deodhar made changes -
            Status Confirmed [ 10101 ] In Progress [ 3 ]
            elenst Elena Stepanova made changes -
            rucha174 Rucha Deodhar added a comment - Patch: https://github.com/MariaDB/server/commit/0dd0bbe54e11260e67fd17e0280a29a93d22e624
            rucha174 Rucha Deodhar made changes -
            Assignee Rucha Deodhar [ rucha174 ] Sergei Golubchik [ serg ]
            Status In Progress [ 3 ] In Review [ 10002 ]
            serg Sergei Golubchik made changes -
            Assignee Sergei Golubchik [ serg ] Rucha Deodhar [ rucha174 ]
            Status In Review [ 10002 ] Stalled [ 10000 ]
            elenst Elena Stepanova made changes -
            rucha174 Rucha Deodhar added a comment - - edited

            The rows may not be displayed when we have LIMIT ROWS EXAMINED because:
            The rows are counted by the server at the time of insert, read, delete and modify. Since here we first fill the rows of Information_schema tables, limit_rows_examined_cnt is incremented and we reach the limit before any result set rows can be computed.
            If there is any select (and not only in case of INFORMATION_SCHEMA) which internally uses temporary table and LIMIT ROWS EXAMINED is reached when writing into temporary table, then the select doesn't return rows.

            rucha174 Rucha Deodhar added a comment - - edited The rows may not be displayed when we have LIMIT ROWS EXAMINED because: The rows are counted by the server at the time of insert, read, delete and modify. Since here we first fill the rows of Information_schema tables, limit_rows_examined_cnt is incremented and we reach the limit before any result set rows can be computed. If there is any select (and not only in case of INFORMATION_SCHEMA) which internally uses temporary table and LIMIT ROWS EXAMINED is reached when writing into temporary table, then the select doesn't return rows.
            rucha174 Rucha Deodhar made changes -
            Status Stalled [ 10000 ] In Progress [ 3 ]
            rucha174 Rucha Deodhar added a comment - Patch: https://github.com/MariaDB/server/commit/cf72e969094ef8bde3cb88bc0575abd9a7f4a910
            rucha174 Rucha Deodhar made changes -
            Status In Progress [ 3 ] In Review [ 10002 ]
            rucha174 Rucha Deodhar made changes -
            Assignee Rucha Deodhar [ rucha174 ] Sergei Golubchik [ serg ]

            ok to push

            serg Sergei Golubchik added a comment - ok to push
            serg Sergei Golubchik made changes -
            Assignee Sergei Golubchik [ serg ] Rucha Deodhar [ rucha174 ]
            Status In Review [ 10002 ] Stalled [ 10000 ]
            rucha174 Rucha Deodhar made changes -
            issue.field.resolutiondate 2020-08-04 05:31:46.0 2020-08-04 05:31:46.893
            rucha174 Rucha Deodhar made changes -
            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 ]
            dbart Daniel Bartholomew made changes -
            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 ]
            marko Marko Mäkelä made changes -
            ralf.gebhardt Ralf Gebhardt made changes -
            Fix Version/s 10.5.7 [ 25019 ]
            ralf.gebhardt Ralf Gebhardt made changes -
            Fix Version/s 10.5.6 [ 24508 ]
            ralf.gebhardt Ralf Gebhardt made changes -
            Fix Version/s 10.4.16 [ 25020 ]
            ralf.gebhardt Ralf Gebhardt made changes -
            Fix Version/s 10.4.15 [ 24507 ]
            ralf.gebhardt Ralf Gebhardt made changes -
            Fix Version/s 10.3.26 [ 25021 ]
            ralf.gebhardt Ralf Gebhardt made changes -
            Fix Version/s 10.3.25 [ 24506 ]
            ralf.gebhardt Ralf Gebhardt made changes -
            Fix Version/s 10.2.35 [ 25022 ]
            ralf.gebhardt Ralf Gebhardt made changes -
            Fix Version/s 10.2.34 [ 24505 ]
            alice Alice Sherepa made changes -
            serg Sergei Golubchik made changes -
            Workflow MariaDB v3 [ 84686 ] MariaDB v4 [ 153487 ]

            People

              rucha174 Rucha Deodhar
              elenst Elena Stepanova
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

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