[MDEV-21270] MariaDB crash on information_schema with -A option Created: 2019-12-10  Updated: 2019-12-10  Resolved: 2019-12-10

Status: Closed
Project: MariaDB Server
Component/s: Information Schema
Affects Version/s: 10.2.24
Fix Version/s: N/A

Type: Bug Priority: Major
Reporter: Sukan Assignee: Unassigned
Resolution: Duplicate Votes: 0
Labels: None
Environment:

CentOS Linux release 7.5.1804 (Core)


Issue Links:
Duplicate
duplicates MDEV-19490 show tables fails when selecting the ... Closed

 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


Generated at Thu Feb 08 09:05:52 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.