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

MariaDB crash on information_schema with -A option

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Duplicate
    • Affects Version/s: 10.2.24
    • Fix Version/s: N/A
    • Component/s: Information Schema
    • Labels:
      None
    • Environment:
      CentOS Linux release 7.5.1804 (Core)

      Description

      When logging MariaDB with -A option, querying information_schema resulting in crash.

       mysql -uxxxx -p -S/tmp/galera_102.sock --port=3307 
      Enter password: 
      Welcome to the MariaDB monitor.  Commands end with ; or \g.
      Your MariaDB connection id is 14
      Server version: 10.2.24-MariaDB-log MariaDB Server
       
      Copyright (c) 2000, 2017, Oracle, MariaDB Corporation Ab and others.
       
      Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
       
      MariaDB [(none)]> 
      MariaDB [(none)]> 
      MariaDB [(none)]> \s
      --------------
      mysql  Ver 15.1 Distrib 10.2.12-MariaDB, for Linux (x86_64) using readline 5.1
       
      Connection id:		14
      Current database:	
      Current user:		xxxx@localhost
      SSL:			Not in use
      Current pager:		stdout
      Using outfile:		''
      Using delimiter:	;
      Server:			MariaDB
      Server version:		10.2.24-MariaDB-log MariaDB Server
      Protocol version:	10
      Connection:		Localhost via UNIX socket
      Server characterset:	latin1
      Db     characterset:	latin1
      Client characterset:	latin1
      Conn.  characterset:	latin1
      UNIX socket:		/tmp/galera_102.sock
      Uptime:			54 sec
       
      Threads: 13  Questions: 4512  Slow queries: 0  Opens: 71  Flush tables: 1  Open tables: 65  Queries per second avg: 83.555
      --------------
       
      MariaDB [(none)]> 
      MariaDB [(none)]> 
      MariaDB [(none)]> 
      MariaDB [(none)]> 
      MariaDB [(none)]> use information_schema
      Reading table information for completion of table and column names
      You can turn off this feature to get a quicker startup with -A
       
      show taDatabase changed
      MariaDB [information_schema]> show tables;
      ERROR 2006 (HY000): MySQL server has gone away
      No connection. Trying to reconnect...
      ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/galera_102.sock' (111)
      ERROR: Can't connect to the server
       
      unknown [information_schema]> 
      

      Logging MariaDB with -A , doesn't crash.

      Error:

      /usr/local/mariadb_102/bin/mysqld(_Z17find_schema_tableP3THDPKcPb+0x50)[0x655cf0]
      /usr/local/mariadb_102/bin/mysqld(_Z11open_tablesP3THDRK14DDL_options_stPP10TABLE_LISTPjPP19Sroutine_hash_entryjP19Prelocking_strategy+0x73b)[0x5a24eb]
      /usr/local/mariadb_102/bin/mysqld(_Z30open_normal_and_derived_tablesP3THDP10TABLE_LISTjj+0x6e)[0x5a322e]
      /usr/local/mariadb_102/bin/mysqld(_Z18mysqld_list_fieldsP3THDP10TABLE_LISTPKc+0x34)[0x65ed34]
      /usr/local/mariadb_102/bin/mysqld(_Z16dispatch_command19enum_server_commandP3THDPcjbb+0x2d26)[0x5fb0f6]
      ibuf/ibuf0ibuf.cc:1471(ibuf_dummy_index_free)[0x5fb465]
      /usr/local/mariadb_102/bin/mysqld(_Z24do_handle_one_connectionP7CONNECT+0x235)[0x6e3a55]
      /usr/local/mariadb_102/bin/mysqld(handle_one_connection+0x3f)[0x6e3c1f]
      pthread_create.c:0(start_thread)[0x7fe258bb6e25]
      /lib64/libc.so.6(clone+0x6d)[0x7fe257a92bad]
       
      Trying to get some variables.
      Some pointers may be invalid and cause the dump to abort.
      Query (0x7fde0400f920): 
      Connection ID (thread ID): 14
      Status: NOT_KILLED
       
      Optimizer switch: index_merge=on,index_merge_union=on,index_merge_sort_union=on,index_merge_intersection=on,index_merge_sort_intersection=off,engine_condition_pushdown=off,index_condition_pushdown=on,derived_merge=on,derived_with_keys=on,firstmatch=on,loosescan=on,materialization=on,in_to_exists=on,semijoin=on,partial_match_rowid_merge=on,partial_match_table_scan=on,subquery_cache=on,mrr=off,mrr_cost_based=off,mrr_sort_keys=off,outer_join_with_cache=on,semijoin_with_cache=on,join_cache_incremental=on,join_cache_hashed=on,join_cache_bka=on,optimize_join_buffer_size=off,table_elimination=on,extended_keys=on,exists_to_in=on,orderby_uses_equalities=on,condition_pushdown_for_derived=on
       
      The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains
      information that should help you find out what is causing the crash.
      Writing a core file...
      Working directory at /binlogs/galeradata_102
      Resource Limits:
      Limit                     Soft Limit           Hard Limit           Units     
      Max cpu time              unlimited            unlimited            seconds   
      Max file size             unlimited            unlimited            bytes     
      Max data size             unlimited            unlimited            bytes     
      Max stack size            8388608              unlimited            bytes     
      Max core file size        unlimited            unlimited            bytes     
      Max resident set          unlimited            unlimited            bytes     
      Max processes             210944               210944               processes 
      Max open files            430536               430536               files     
      Max locked memory         65536                65536                bytes     
      Max address space         unlimited            unlimited            bytes     
      Max file locks            unlimited            unlimited            locks     
      Max pending signals       1030115              1030115              signals   
      Max msgqueue size         819200               819200               bytes     
      Max nice priority         0                    0                    
      Max realtime priority     0                    0                    
      Max realtime timeout      unlimited            unlimited            us        
      Core pattern: |/usr/libexec/abrt-hook-ccpp %s %c %p %u %g %t e %P %I %h
      

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              Unassigned
              Reporter:
              Sukan Sukan
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: