[MDEV-9538] Server crashes in check_show_access on SHOW STATISTICS Created: 2016-02-09  Updated: 2016-02-23  Resolved: 2016-02-23

Status: Closed
Project: MariaDB Server
Component/s: Admin statements
Affects Version/s: 10.1
Fix Version/s: 10.1.12

Type: Bug Priority: Major
Reporter: Elena Stepanova Assignee: Sergei Golubchik
Resolution: Fixed Votes: 0
Labels: None

Issue Links:
Relates
relates to MDEV-9539 Server crashes in make_columns_old_fo... Closed
relates to MDEV-9540 SHOW SPATIAL_REF_SYS and SHOW SYSTEM_... Closed
Sprint: 10.1.12

 Description   

Reported on behalf of Daniel Dettlaff

SHOW STATISTICS;

Stack trace from 10.1 commit 7b14ba63f22e6c98c1982dae8847035ad1b8e155

3  <signal handler called>
#4  0x000055ce08da12c1 in check_show_access (thd=0x7fbd8645f270, table=0x7fbda8833d78) at /src/10.1/sql/sql_parse.cc:6366
#5  0x000055ce08da14bd in check_table_access (thd=0x7fbd8645f270, requirements=1, tables=0x7fbda8833d78, any_combination_of_privileges_will_do=false, number=4294967295, no_errors=false) at /src/10.1/sql/sql_parse.cc:6473
#6  0x000055ce08d9619f in mysql_execute_command (thd=0x7fbd8645f270) at /src/10.1/sql/sql_parse.cc:2957
#7  0x000055ce08da377a in mysql_parse (thd=0x7fbd8645f270, rawbuf=0x7fbda8832ec8 "show statistics", length=15, parser_state=0x7fbdabe3e630) at /src/10.1/sql/sql_parse.cc:7303
#8  0x000055ce08d92474 in dispatch_command (command=COM_QUERY, thd=0x7fbd8645f270, packet=0x7fbd8647eaf1 "show statistics", packet_length=15) at /src/10.1/sql/sql_parse.cc:1488
#9  0x000055ce08d911a6 in do_command (thd=0x7fbd8645f270) at /src/10.1/sql/sql_parse.cc:1109
#10 0x000055ce08ec6798 in do_handle_one_connection (thd_arg=0x7fbd8645f270) at /src/10.1/sql/sql_connect.cc:1349
#11 0x000055ce08ec64fc in handle_one_connection (arg=0x7fbd8645f270) at /src/10.1/sql/sql_connect.cc:1261
#12 0x00007fbdabad60a4 in start_thread () from /lib64/libpthread.so.0
#13 0x00007fbda9c4404d in clone () from /lib64/libc.so.6



 Comments   
Comment by Elena Stepanova [ 2016-02-09 ]

These are all entries that I could find in I_S.TABLES and I_S.ALL_PLUGINS. Most of them return sytax error, two crash (MDEV-9538, MDEV-9539), two cause problems (MDEV-9540).

--disable_abort_on_error
 
SHOW ALL_PLUGINS;
SHOW APPLICABLE_ROLES;
SHOW CHANGED_PAGE_BITMAPS;
SHOW CHARACTER_SETS;
SHOW CLIENT_STATISTICS;
SHOW COLLATIONS;
SHOW COLLATION_CHARACTER_SET_APPLICABILITY;
SHOW COLUMNS;
SHOW COLUMN_PRIVILEGES;
SHOW ENABLED_ROLES;
SHOW ENGINES;
SHOW EVENTS;
SHOW FEEDBACK;
SHOW FILES;
echo # Crashes: SHOW GEOMETRY_COLUMNS;
SHOW GLOBAL_STATUS;
SHOW GLOBAL_VARIABLES;
SHOW INDEX_STATISTICS;
SHOW INNODB_BUFFER_PAGE;
SHOW INNODB_BUFFER_PAGE_LRU;
SHOW INNODB_BUFFER_POOL_STATS;
SHOW INNODB_CHANGED_PAGES;
SHOW INNODB_CMP;
SHOW INNODB_CMPMEM;
SHOW INNODB_CMPMEM_RESET;
SHOW INNODB_CMP_PER_INDEX;
SHOW INNODB_CMP_PER_INDEX_RESET;
SHOW INNODB_CMP_RESET;
SHOW INNODB_FT_BEING_DELETED;
SHOW INNODB_FT_CONFIG;
SHOW INNODB_FT_DEFAULT_STOPWORD;
SHOW INNODB_FT_DELETED;
SHOW INNODB_FT_INDEX_CACHE;
SHOW INNODB_FT_INDEX_TABLE;
SHOW INNODB_LOCKS;
SHOW INNODB_LOCK_WAITS;
SHOW INNODB_METRICS;
SHOW INNODB_MUTEXES;
SHOW INNODB_SYS_COLUMNS;
SHOW INNODB_SYS_DATAFILES;
SHOW INNODB_SYS_FIELDS;
SHOW INNODB_SYS_FOREIGN;
SHOW INNODB_SYS_FOREIGN_COLS;
SHOW INNODB_SYS_INDEXES;
SHOW INNODB_SYS_SEMAPHORE_WAITS;
SHOW INNODB_SYS_TABLES;
SHOW INNODB_SYS_TABLESPACES;
SHOW INNODB_SYS_TABLESTATS;
SHOW INNODB_TABLESPACES_ENCRYPTION;
SHOW INNODB_TABLESPACES_SCRUBBING;
SHOW INNODB_TRX;
SHOW KEY_CACHES;
SHOW KEY_COLUMN_USAGE;
SHOW LOCALES;
SHOW METADATA_LOCK_INFO;
SHOW Mroonga_stats;
SHOW PARAMETERS;
SHOW PARTITIONS;
SHOW PLUGINS;
SHOW PROCESSLIST;
SHOW PROFILING;
SHOW QUERY_CACHE_INFO;
SHOW QUERY_RESPONSE_TIME;
SHOW REFERENTIAL_CONSTRAINTS;
SHOW ROUTINES;
SHOW SCHEMATA;
SHOW SCHEMA_PRIVILEGES;
SHOW SESSION_STATUS;
SHOW SESSION_VARIABLES;
echo # Misbehaves: SHOW SPATIAL_REF_SYS;
SHOW SPIDER_ALLOC_MEM;
echo # Crashes: SHOW STATISTICS;
echo # Misbehaves: SHOW SYSTEM_VARIABLES;
SHOW TABLES;
SHOW TABLESPACES;
SHOW TABLE_CONSTRAINTS;
SHOW TABLE_PRIVILEGES;
SHOW TABLE_STATISTICS;
SHOW TokuDB_file_map;
SHOW TokuDB_fractal_tree_block_map;
SHOW TokuDB_fractal_tree_info;
SHOW TokuDB_locks;
SHOW TokuDB_lock_waits;
SHOW TokuDB_trx;
SHOW TRIGGERS;
SHOW USER_PRIVILEGES;
SHOW USER_STATISTICS;
SHOW VIEWS;
SHOW WSREP_MEMBERSHIP;
SHOW WSREP_STATUS;
SHOW XTRADB_INTERNAL_HASH_TABLES;
SHOW XTRADB_READ_VIEW;
SHOW XTRADB_RSEG;
 
FLUSH ALL_PLUGINS;
FLUSH APPLICABLE_ROLES;
FLUSH CHANGED_PAGE_BITMAPS;
FLUSH CHARACTER_SETS;
FLUSH CLIENT_STATISTICS;
FLUSH COLLATIONS;
FLUSH COLLATION_CHARACTER_SET_APPLICABILITY;
FLUSH COLUMNS;
FLUSH COLUMN_PRIVILEGES;
FLUSH ENABLED_ROLES;
FLUSH ENGINES;
FLUSH EVENTS;
FLUSH FEEDBACK;
FLUSH FILES;
FLUSH GEOMETRY_COLUMNS;
FLUSH GLOBAL_STATUS;
FLUSH GLOBAL_VARIABLES;
FLUSH INDEX_STATISTICS;
FLUSH INNODB_BUFFER_PAGE;
FLUSH INNODB_BUFFER_PAGE_LRU;
FLUSH INNODB_BUFFER_POOL_STATS;
FLUSH INNODB_CHANGED_PAGES;
FLUSH INNODB_CMP;
FLUSH INNODB_CMPMEM;
FLUSH INNODB_CMPMEM_RESET;
FLUSH INNODB_CMP_PER_INDEX;
FLUSH INNODB_CMP_PER_INDEX_RESET;
FLUSH INNODB_CMP_RESET;
FLUSH INNODB_FT_BEING_DELETED;
FLUSH INNODB_FT_CONFIG;
FLUSH INNODB_FT_DEFAULT_STOPWORD;
FLUSH INNODB_FT_DELETED;
FLUSH INNODB_FT_INDEX_CACHE;
FLUSH INNODB_FT_INDEX_TABLE;
FLUSH INNODB_LOCKS;
FLUSH INNODB_LOCK_WAITS;
FLUSH INNODB_METRICS;
FLUSH INNODB_MUTEXES;
FLUSH INNODB_SYS_COLUMNS;
FLUSH INNODB_SYS_DATAFILES;
FLUSH INNODB_SYS_FIELDS;
FLUSH INNODB_SYS_FOREIGN;
FLUSH INNODB_SYS_FOREIGN_COLS;
FLUSH INNODB_SYS_INDEXES;
FLUSH INNODB_SYS_SEMAPHORE_WAITS;
FLUSH INNODB_SYS_TABLES;
FLUSH INNODB_SYS_TABLESPACES;
FLUSH INNODB_SYS_TABLESTATS;
FLUSH INNODB_TABLESPACES_ENCRYPTION;
FLUSH INNODB_TABLESPACES_SCRUBBING;
FLUSH INNODB_TRX;
FLUSH KEY_CACHES;
FLUSH KEY_COLUMN_USAGE;
FLUSH LOCALES;
FLUSH METADATA_LOCK_INFO;
FLUSH Mroonga_stats;
FLUSH PARAMETERS;
FLUSH PARTITIONS;
FLUSH PLUGINS;
FLUSH PROCESSLIST;
FLUSH PROFILING;
FLUSH QUERY_CACHE_INFO;
FLUSH QUERY_RESPONSE_TIME;
FLUSH REFERENTIAL_CONSTRAINTS;
FLUSH ROUTINES;
FLUSH SCHEMATA;
FLUSH SCHEMA_PRIVILEGES;
FLUSH SESSION_STATUS;
FLUSH SESSION_VARIABLES;
FLUSH SPATIAL_REF_SYS;
FLUSH SPIDER_ALLOC_MEM;
FLUSH STATISTICS;
FLUSH SYSTEM_VARIABLES;
FLUSH TABLES;
FLUSH TABLESPACES;
FLUSH TABLE_CONSTRAINTS;
FLUSH TABLE_PRIVILEGES;
FLUSH TABLE_STATISTICS;
FLUSH TokuDB_file_map;
FLUSH TokuDB_fractal_tree_block_map;
FLUSH TokuDB_fractal_tree_info;
FLUSH TokuDB_locks;
FLUSH TokuDB_lock_waits;
FLUSH TokuDB_trx;
FLUSH TRIGGERS;
FLUSH USER_PRIVILEGES;
FLUSH USER_STATISTICS;
FLUSH VIEWS;
FLUSH WSREP_MEMBERSHIP;
FLUSH WSREP_STATUS;
FLUSH XTRADB_INTERNAL_HASH_TABLES;
FLUSH XTRADB_READ_VIEW;
FLUSH XTRADB_RSEG;

Generated at Thu Feb 08 07:35:25 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.