Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Duplicate
-
10.2.24
-
None
-
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
- duplicates
-
MDEV-19490 show tables fails when selecting the information_schema database
- Closed