Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
10.0.15
-
None
-
wheezy x86_64
Description
Was running mysqlanalyze --skip-write-binlog --all-databases
Ran though a lot of tables without error.
....
|
...
|
..
|
|
|
oq_dev_eventum.eventum_search_profile Engine-independent statistics collected
|
status : OK
|
oq_dev_eventum.eventum_status Engine-independent statistics collected
|
status : OK
|
oq_dev_eventum.eventum_subscription Engine-independent statistics collected
|
status : OK
|
oq_dev_eventum.eventum_subscription_type Engine-independent statistics collected
|
status : OK
|
oq_dev_eventum.eventum_support_email Engine-independent statistics collected
|
status : OK
|
mysqlanalyze: Got error: 2013: Lost connection to MySQL server during query when executing 'ANALYZE NO_WRITE_TO_BINLOG TABLE ... '
|
Settings where:
| use_stat_tables | COMPLEMENTARY |
|
Dec 23 03:23:25 catinthehat mysqld: Server version: 10.0.15-MariaDB-1~wheezy-log
|
Dec 23 03:23:25 catinthehat mysqld: key_buffer_size=8388608
|
Dec 23 03:23:25 catinthehat mysqld: read_buffer_size=1048576
|
Dec 23 03:23:25 catinthehat mysqld: max_used_connections=4
|
Dec 23 03:23:25 catinthehat mysqld: max_threads=102
|
Dec 23 03:23:25 catinthehat mysqld: thread_count=4
|
Dec 23 03:23:25 catinthehat mysqld: It is possible that mysqld could use up to
|
Dec 23 03:23:25 catinthehat mysqld: key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 140842 K bytes of memory
|
Dec 23 03:23:25 catinthehat mysqld: Hope that's ok; if not, decrease some variables in the equation.
|
Dec 23 03:23:25 catinthehat mysqld:
|
Dec 23 03:23:25 catinthehat mysqld: Thread pointer: 0x0x7f53f3936008
|
Dec 23 03:23:25 catinthehat mysqld: Attempting backtrace. You can use the following information to find out
|
Dec 23 03:23:25 catinthehat mysqld: where mysqld died. If you see no messages after this, something went
|
Dec 23 03:23:25 catinthehat mysqld: terribly wrong...
|
Dec 23 03:23:25 catinthehat mysqld: stack_bottom = 0x7f5425c73e30 thread_stack 0x48000
|
Dec 23 03:23:25 catinthehat mysqld: /usr/sbin/mysqld(my_print_stacktrace+0x2b)[0x7f5428926b9b]
|
Dec 23 03:23:25 catinthehat mysqld: /usr/sbin/mysqld(handle_fatal_signal+0x422)[0x7f54284b6e92]
|
Dec 23 03:23:25 catinthehat mysqld: /lib/x86_64-linux-gnu/libpthread.so.0(+0xf8d0)[0x7f5427b078d0]
|
Dec 23 03:23:25 catinthehat mysqld: /usr/sbin/mysqld(_Z27update_statistics_for_tableP3THDP5TABLE+0x360)[0x7f54283c8850]
|
Dec 23 03:23:25 catinthehat mysqld: /usr/sbin/mysqld(+0x4f693e)[0x7f542842e93e]
|
Dec 23 03:23:25 catinthehat mysqld: /usr/sbin/mysqld(_ZN21Sql_cmd_analyze_table7executeEP3THD+0xd9)[0x7f5428430079]
|
Dec 23 03:23:25 catinthehat mysqld: /usr/sbin/mysqld(_Z21mysql_execute_commandP3THD+0x1968)[0x7f542835a7f8]
|
Dec 23 03:23:25 catinthehat mysqld: /usr/sbin/mysqld(+0x4275ba)[0x7f542835f5ba]
|
Dec 23 03:23:25 catinthehat mysqld: /usr/sbin/mysqld(_Z16dispatch_command19enum_server_commandP3THDPcj+0x14df)[0x7f5428360b7f]
|
Dec 23 03:23:25 catinthehat mysqld: /usr/sbin/mysqld(_Z24do_handle_one_connectionP3THD+0x47b)[0x7f542842273b]
|
Dec 23 03:23:25 catinthehat mysqld: /usr/sbin/mysqld(handle_one_connection+0x47)[0x7f5428422817]
|
Dec 23 03:23:25 catinthehat mysqld: /usr/sbin/mysqld(+0x6f5d5d)[0x7f542862dd5d]
|
Dec 23 03:23:25 catinthehat mysqld: /lib/x86_64-linux-gnu/libpthread.so.0(+0x80a4)[0x7f5427b000a4]
|
Dec 23 03:23:25 catinthehat mysqld: /lib/x86_64-linux-gnu/libc.so.6(clone+0x6d)[0x7f5426178ccd]
|
Dec 23 03:23:25 catinthehat mysqld:
|
Dec 23 03:23:25 catinthehat mysqld: Trying to get some variables.
|
Dec 23 03:23:25 catinthehat mysqld: Some pointers may be invalid and cause the dump to abort.
|
Dec 23 03:23:25 catinthehat mysqld: Query (0x7f540a4c8020): is an invalid pointer
|
Dec 23 03:23:25 catinthehat mysqld: Connection ID (thread ID): 13
|
Dec 23 03:23:25 catinthehat mysqld: Status: NOT_KILLED
|
mysqlcheck --skip-write-binlog --all-databases
|
..
|
(all OK)
|
select * from mysql.table_stats
|
| oq_dev_eventum | eventum_round_robin_user | 0 |
|
| oq_dev_eventum | eventum_search_profile | 27 |
|
| oq_dev_eventum | eventum_status | 10 |
|
| oq_dev_eventum | eventum_subscription | 1052 |
|
| oq_dev_eventum | eventum_subscription_type | 4003 |
|
| oq_dev_eventum | eventum_support_email | 4535 |
|
| oq_dev_eventum | eventum_support_email_body | 4534 |
|
| logsleads | clflog | 0 |
|
|
|
|
|
|
|
MariaDB [mysql]> show tables in oq_dev_eventum like 'eventum_%';
|
...
|
| eventum_support_email |
|
| eventum_support_email_body |
|
| eventum_time_tracking |
|
| eventum_time_tracking_category |
|
| eventum_user |
|
+--------------------------------------+
|
69 rows in set (0.00 sec)
|
After restart with:
| use_stat_tables | NEVER |
|
|
|
mysqlanalyze --skip-write-binlog --all-databases
|
...
|
oq_eventum.eventum_status OK
|
oq_eventum.eventum_subscription OK
|
oq_eventum.eventum_subscription_type OK
|
oq_eventum.eventum_support_email OK
|
oq_eventum.eventum_support_email_body Table is already up to date
|
oq_eventum.eventum_time_tracking Table is already up to date
|
oq_eventum.eventum_time_tracking_category OK
|
oq_eventum.eventum_user OK
|
oq_eventum.oq_customer_contacts OK
|
oq_eventum.oq_customers OK
|
oq_ourdelta.wp_QuoteRotator OK
|
oq_ourdelta.wp_commentmeta OK
|
oq_ourdelta.wp_comments OK
|
oq_ourdelta.wp_links OK
|
...
|
This is repeatable on this table:
MariaDB [(none)]> set sql_log_bin=0;
|
Query OK, 0 rows affected (0.00 sec)
|
|
|
MariaDB [(none)]> analyze local table oq_dev_eventum.eventum_support_email_body;
|
+-------------------------------------------+---------+----------+-----------------------------+
|
| Table | Op | Msg_type | Msg_text |
|
+-------------------------------------------+---------+----------+-----------------------------+
|
| oq_dev_eventum.eventum_support_email_body | analyze | status | Table is already up to date |
|
+-------------------------------------------+---------+----------+-----------------------------+
|
1 row in set (0.00 sec)
|
|
|
MariaDB [(none)]> set global use_stat_tables=COMPLEMENTARY;
|
Query OK, 0 rows affected (0.00 sec)
|
|
|
MariaDB [(none)]> analyze local table oq_dev_eventum.eventum_support_email_body;
|
+-------------------------------------------+---------+----------+-----------------------------+
|
| Table | Op | Msg_type | Msg_text |
|
+-------------------------------------------+---------+----------+-----------------------------+
|
| oq_dev_eventum.eventum_support_email_body | analyze | status | Table is already up to date |
|
+-------------------------------------------+---------+----------+-----------------------------+
|
1 row in set (0.00 sec)
|
|
|
MariaDB [(none)]> analyze local table oq_dev_eventum.eventum_support_email_body PERSISTENT FOR ALL;
|
ERROR 2013 (HY000): Lost connection to MySQL server during query
|
| eventum_support_email_body | CREATE TABLE `eventum_support_email_body` (
|
`seb_sup_id` int(11) unsigned NOT NULL,
|
`seb_body` longtext NOT NULL,
|
`seb_full_email` longtext NOT NULL,
|
PRIMARY KEY (`seb_sup_id`),
|
FULLTEXT KEY `ft_support_email` (`seb_body`)
|
) ENGINE=MyISAM DEFAULT CHARSET=utf8 |
|
|
|
MariaDB [(none)]> select count(*) from oq_dev_eventum.eventum_support_email_body;
|
+----------+
|
| count(*) |
|
+----------+
|
| 4534 |
|
|
|
|
|
MariaDB [(none)]> select length(seb_body) as b from oq_dev_eventum.eventum_support_email_body order by b desc limit 1;
|
+-------+
|
| b |
|
+-------+
|
| 44175 |
|
|
|
MariaDB [(none)]> select length(seb_full_email) as b from oq_dev_eventum.eventum_support_email_body order by b desc limit 1;
|
+---------+
|
| b |
|
+---------+
|
| 8937583 |
|
Running with use_stat_tables=NEVER didn't cause a crash.
If you can repeat this without a copy of oq_dev_eventum.eventum_support_email_body that would be good. If you can't I'll see what I can do.
Attachments
Issue Links
- relates to
-
-
- Closed
-
Activity
use_stat_tables = COMPLEMENTARY
histogram_size=255 was set at runtime however I could repeat it with the default histogram_size=0.
Thanks, I'll try to reproduce with your configs (had no luck with default settings).
There is, however, one confusing detail which makes me think I might be missing an important step.
In your steps to reproduce, you do the following, all in the same session:
- run ANALYZE;
- SET GLOBAL use_stat_tables = COMPLEMENTARY (I assume it was NEVER before?)
- run ANALYZE;
- run ANALYZE .. PERSISTENT FOR ALL => crash.
And you also said that with use_stat_tables=NEVER there is no crash.
But the thing is, if you set the GLOBAL value of use_stat_tables, it does not (should not, at least) have any effect on the current connection. And from the 2nd ANALYZE, we see that it's so indeed – there is nothing about statistics collection; there would have been if statistics was already activated.
Note: It seems that this description https://mariadb.com/kb/en/mariadb/documentation/optimization-and-tuning/query-optimizations/statistics-for-optimizing-queries/engine-independent-table-statistics/ is outdated or wrongly phrased; in fact, simple ANALYZE TABLE already collects statistics if use_stat_tables is anything but NEVER; and ANALYZE TABLE ... PERSISTENT collects statistics even if use_stat_tables is NEVER.
Are you absolutely sure about the point regarding use_stat_tables=NEVER preventing the crash?
Sorry there was a new session created after the set global. I did the same mistake here but it does that the default use_stats_tables doesn't crash with ANALYZE TABLE and with it set in a session it does.
The following was running on a trunk developed server running
/home/dan/software_projects/mariadb-trunk/sql/mysqld --defaults-group-suffix=.2 --defaults-file=/home/dan/software_projects/mariadb-trunk/mysql-test/var/my.cnf
|
MariaDB [t1]> analyze table eventum_support_email_body;
|
+-------------------------------+---------+----------+-----------------------------+
|
| Table | Op | Msg_type | Msg_text |
|
+-------------------------------+---------+----------+-----------------------------+
|
| t1.eventum_support_email_body | analyze | status | Table is already up to date |
|
+-------------------------------+---------+----------+-----------------------------+
|
1 row in set (0.00 sec)
|
|
|
MariaDB [t1]> SET GLOBAL use_stat_tables = COMPLEMENTARY;
|
Query OK, 0 rows affected (0.00 sec)
|
|
|
MariaDB [t1]> analyze table eventum_support_email_body;
|
+-------------------------------+---------+----------+-----------------------------+
|
| Table | Op | Msg_type | Msg_text |
|
+-------------------------------+---------+----------+-----------------------------+
|
| t1.eventum_support_email_body | analyze | status | Table is already up to date |
|
+-------------------------------+---------+----------+-----------------------------+
|
1 row in set (0.00 sec)
|
|
|
MariaDB [t1]> SET use_stat_tables = COMPLEMENTARY;
|
Query OK, 0 rows affected (0.00 sec)
|
|
|
MariaDB [t1]> analyze table eventum_support_email_body;
|
ERROR 2013 (HY000): Lost connection to MySQL server during query
|
MariaDB [t1]> SET use_stat_tables = COMPLEMENTARY;
|
ERROR 2006 (HY000): MySQL server has gone away
|
No connection. Trying to reconnect...
|
Connection id: 2
|
Current database: t1
|
|
|
Query OK, 0 rows affected (0.05 sec)
|
|
|
MariaDB [t1]> analyze table eventum_support_email_body;
|
gdb caught the process at this point which is the attached bt.txt
Documentation edits are my fault. I'll test and revert.
Server running from mysql-test directory;
mysql-test $ /home/dan/software_projects/mariadb-trunk/sql/mysqld --defaults-group-suffix=.2 --defaults-file=/home/dan/software_projects/mariadb-trunk/mysql-test/var/my.cnf
|
|
|
141226 13:05:52 [Warning] You need to use --log-bin to make --log-slave-updates work.
|
141226 13:05:52 [Note] InnoDB: Using mutexes to ref count buffer pool pages
|
141226 13:05:52 [Note] InnoDB: The InnoDB memory heap is disabled
|
141226 13:05:52 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
|
141226 13:05:52 [Note] InnoDB: Memory barrier is not used
|
141226 13:05:52 [Note] InnoDB: Compressed tables use zlib 1.2.8
|
141226 13:05:52 [Note] InnoDB: Using Linux native AIO
|
141226 13:05:52 [Note] InnoDB: Using CPU crc32 instructions
|
141226 13:05:52 [Note] InnoDB: Initializing buffer pool, size = 8.0M
|
141226 13:05:52 [Note] InnoDB: Completed initialization of buffer pool
|
141226 13:05:52 [Note] InnoDB: Highest supported file format is Barracuda.
|
141226 13:05:52 [Note] InnoDB: 128 rollback segment(s) are active.
|
141226 13:05:52 [Note] InnoDB: Waiting for purge to start
|
141226 13:05:52 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.21-70.0 started; log sequence number 1937518
|
141226 13:05:52 [Note] Plugin 'XTRADB_READ_VIEW' is disabled.
|
141226 13:05:52 [Note] Plugin 'XTRADB_INTERNAL_HASH_TABLES' is disabled.
|
141226 13:05:52 [Note] Plugin 'XTRADB_RSEG' is disabled.
|
141226 13:05:52 [Note] Plugin 'INNODB_TRX' is disabled.
|
141226 13:05:52 [Note] Plugin 'INNODB_LOCK_WAITS' is disabled.
|
141226 13:05:52 [Note] Plugin 'INNODB_CMP_RESET' is disabled.
|
141226 13:05:52 [Note] Plugin 'INNODB_CMPMEM' is disabled.
|
141226 13:05:52 [Note] Plugin 'INNODB_CMPMEM_RESET' is disabled.
|
141226 13:05:52 [Note] Plugin 'INNODB_CMP_PER_INDEX_RESET' is disabled.
|
141226 13:05:52 [Note] Plugin 'INNODB_BUFFER_PAGE' is disabled.
|
141226 13:05:52 [Note] Plugin 'INNODB_BUFFER_PAGE_LRU' is disabled.
|
141226 13:05:52 [Note] Plugin 'INNODB_BUFFER_POOL_STATS' is disabled.
|
141226 13:05:52 [Note] Plugin 'INNODB_METRICS' is disabled.
|
141226 13:05:52 [Note] Plugin 'INNODB_FT_DEFAULT_STOPWORD' is disabled.
|
141226 13:05:52 [Note] Plugin 'INNODB_FT_DELETED' is disabled.
|
141226 13:05:52 [Note] Plugin 'INNODB_FT_BEING_DELETED' is disabled.
|
141226 13:05:52 [Note] Plugin 'INNODB_FT_CONFIG' is disabled.
|
141226 13:05:52 [Note] Plugin 'INNODB_FT_INDEX_CACHE' is disabled.
|
141226 13:05:52 [Note] Plugin 'INNODB_FT_INDEX_TABLE' is disabled.
|
141226 13:05:52 [Note] Plugin 'INNODB_SYS_TABLES' is disabled.
|
141226 13:05:52 [Note] Plugin 'INNODB_SYS_TABLESTATS' is disabled.
|
141226 13:05:52 [Note] Plugin 'INNODB_SYS_INDEXES' is disabled.
|
141226 13:05:52 [Note] Plugin 'INNODB_SYS_COLUMNS' is disabled.
|
141226 13:05:52 [Note] Plugin 'INNODB_SYS_FIELDS' is disabled.
|
141226 13:05:52 [Note] Plugin 'INNODB_SYS_FOREIGN' is disabled.
|
141226 13:05:52 [Note] Plugin 'INNODB_SYS_FOREIGN_COLS' is disabled.
|
141226 13:05:52 [Note] Plugin 'INNODB_SYS_TABLESPACES' is disabled.
|
141226 13:05:52 [Note] Plugin 'INNODB_SYS_DATAFILES' is disabled.
|
141226 13:05:52 [Note] Plugin 'INNODB_CHANGED_PAGES' is disabled.
|
141226 13:05:52 [Note] Plugin 'partition' is disabled.
|
141226 13:05:52 [Warning] /home/dan/software_projects/mariadb-trunk/sql/mysqld: unknown variable 'loose-feedback-user-info=mysql-test'
|
141226 13:05:52 [Note] Server socket created on IP: '::'.
|
141226 13:05:52 [Note] Event Scheduler: Loaded 0 events
|
141226 13:05:52 [Note] /home/dan/software_projects/mariadb-trunk/sql/mysqld: ready for connections.
|
Version: '10.0.16-MariaDB-log' socket: '/home/dan/software_projects/mariadb-trunk/mysql-test/var/tmp/mysqld.2.sock' port: 16001 Source distribution
|
|
|
141226 13:06:52 [ERROR] mysqld got signal 11 ;
|
This could be because you hit a bug. It is also possible that this binary
|
or one of the libraries it was linked against is corrupt, improperly built,
|
or misconfigured. This error can also be caused by malfunctioning hardware.
|
|
|
To report this bug, see http://kb.askmonty.org/en/reporting-bugs
|
|
|
We will try our best to scrape up some info that will hopefully help
|
diagnose the problem, but since we have already crashed,
|
something is definitely wrong and this may fail.
|
|
|
Server version: 10.0.16-MariaDB-log
|
key_buffer_size=1048576
|
read_buffer_size=131072
|
max_used_connections=1
|
max_threads=153
|
thread_count=1
|
It is possible that mysqld could use up to
|
key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 62921 K bytes of memory
|
Hope that's ok; if not, decrease some variables in the equation.
|
|
|
Thread pointer: 0x0x7f5d7bfea008
|
Attempting backtrace. You can use the following information to find out
|
where mysqld died. If you see no messages after this, something went
|
terribly wrong...
|
stack_bottom = 0x7f5d85b01d38 thread_stack 0x48000
|
mysys/stacktrace.c:247(my_print_stacktrace)[0xaa4889]
|
sql/signal_handler.cc:153(handle_fatal_signal)[0x6e19a8]
|
/lib64/libpthread.so.0[0x391120f6d0]
|
sql/sql_statistics.cc:2628(update_statistics_for_table(THD*, TABLE*))[0x612f80]
|
sql/sql_admin.cc:739(mysql_admin_table)[0x66c1b3]
|
sql/sql_admin.cc:1150(Sql_cmd_analyze_table::execute(THD*))[0x66c67c]
|
sql/sql_parse.cc:5078(mysql_execute_command(THD*))[0x5b085d]
|
sql/sql_parse.cc:6407(mysql_parse(THD*, char*, unsigned int, Parser_state*))[0x5b6d88]
|
sql/sql_parse.cc:1301(dispatch_command(enum_server_command, THD*, char*, unsigned int))[0x5b89b7]
|
sql/sql_connect.cc:1375(do_handle_one_connection(THD*))[0x660874]
|
sql/sql_connect.cc:1291(handle_one_connection)[0x6608d8]
|
perfschema/pfs.cc:1863(pfs_spawn_thread)[0x9bdc44]
|
/lib64/libpthread.so.0[0x3911207ee5]
|
/lib64/libc.so.6(clone+0x6d)[0x3910af4b8d]
|
|
|
Trying to get some variables.
|
Some pointers may be invalid and cause the dump to abort.
|
Query (0x7f5d7341e020): analyze table test
|
Connection ID (thread ID): 2
|
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
|
|
|
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.
|
$ mysql -S /home/dan/software_projects/mariadb-trunk/mysql-test/var/tmp/mysqld.2.sock
|
Welcome to the MariaDB monitor. Commands end with ; or \g.
|
Your MariaDB connection id is 3
|
Server version: 10.0.16-MariaDB-log Source distribution
|
|
|
Copyright (c) 2000, 2014, Oracle, SkySQL Ab and others.
|
|
|
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
|
|
|
MariaDB [(none)]> use t1;
|
|
|
Database changed
|
MariaDB [t1]> source /tmp/mdev-7362.sql
|
..
|
Query OK, 1 row affected (0.00 sec)
|
|
|
MariaDB [t1]> set use_stat_tables='COMPLEMENTARY'
|
-> ;
|
Query OK, 0 rows affected (0.00 sec)
|
|
|
MariaDB [t1]> analyze table test;
|
ERROR 2013 (HY000): Lost connection to MySQL server during query
|
second seg fault after restarting the server
#0 free_field_buffers_larger_than (table=table@entry=0x7fe3a406a208, size=size@entry=65536) at /home/dan/software_projects/mariadb-trunk/sql/table.cc:3026
|
#1 0x00000000005736cf in close_thread_table (thd=thd@entry=0x7fe3acbea008, table_ptr=table_ptr@entry=0x7fe3acbea0c8) at /home/dan/software_projects/mariadb-trunk/sql/sql_base.cc:1045
|
#2 0x00000000005738a3 in close_open_tables (thd=<optimized out>) at /home/dan/software_projects/mariadb-trunk/sql/sql_base.cc:779
|
#3 close_thread_tables (thd=thd@entry=0x7fe3acbea008) at /home/dan/software_projects/mariadb-trunk/sql/sql_base.cc:1003
|
#4 0x000000000066b3ff in mysql_admin_table (thd=thd@entry=0x7fe3acbea008, tables=tables@entry=0x7fe3a401f0f0, check_opt=check_opt@entry=0x7fe3acbeea00,
|
operator_name=operator_name@entry=0xafd50f "analyze", lock_type=lock_type@entry=TL_READ_NO_INSERT, open_for_modify=open_for_modify@entry=true,
|
repair_table_use_frm=repair_table_use_frm@entry=false, extra_open_options=extra_open_options@entry=0, prepare_func=prepare_func@entry=0x0, operator_func=<optimized out>,
|
view_operator_func=view_operator_func@entry=0x0) at /home/dan/software_projects/mariadb-trunk/sql/sql_admin.cc:1024
|
#5 0x000000000066c67c in Sql_cmd_analyze_table::execute (this=<optimized out>, thd=0x7fe3acbea008) at /home/dan/software_projects/mariadb-trunk/sql/sql_admin.cc:1148
|
#6 0x00000000005b085d in mysql_execute_command (thd=thd@entry=0x7fe3acbea008) at /home/dan/software_projects/mariadb-trunk/sql/sql_parse.cc:5078
|
#7 0x00000000005b6d88 in mysql_parse (thd=0x7fe3acbea008, rawbuf=<optimized out>, length=18, parser_state=0x7fe3b669a5b0)
|
at /home/dan/software_projects/mariadb-trunk/sql/sql_parse.cc:6407
|
#8 0x00000000005b89b7 in dispatch_command (command=COM_QUERY, thd=0x7fe3acbea008, packet=<optimized out>, packet_length=<optimized out>)
|
at /home/dan/software_projects/mariadb-trunk/sql/sql_parse.cc:1299
|
#9 0x00000000005b945b in do_command (thd=<optimized out>) at /home/dan/software_projects/mariadb-trunk/sql/sql_parse.cc:996
|
#10 0x0000000000660874 in do_handle_one_connection (thd_arg=thd_arg@entry=0x7fe3acbea008) at /home/dan/software_projects/mariadb-trunk/sql/sql_connect.cc:1375
|
#11 0x00000000006608d8 in handle_one_connection (arg=arg@entry=0x7fe3acbea008) at /home/dan/software_projects/mariadb-trunk/sql/sql_connect.cc:1289
|
#12 0x00000000009bdc44 in pfs_spawn_thread (arg=0x7fe3b5c2f208) at /home/dan/software_projects/mariadb-trunk/storage/perfschema/pfs.cc:1860
|
#13 0x0000003911207ee5 in start_thread (arg=0x7fe3b669b700) at pthread_create.c:309
|
#14 0x0000003910af4b8d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:111
|
Here is a shorter test case on which I'm getting the same crash as in the initial description right now, but it seems it can be volatile – different stack traces on the same test case. Below I'll give more examples of stack traces that I'm getting with variations of the test case. I hope all of them, and MDEV-7380, have the same root cause.
Stack traces are from debug 10.0 revno 4545
CREATE TABLE t1 (a longtext, FULLTEXT KEY (`a`)) ENGINE=MyISAM; |
insert into t1 values (unhex('3E0D0A4141414142334E7A6143317963324541414141424977414141674541726D')); |
analyze table t1 persistent for all; |
#3 <signal handler called>
|
#4 0x0000000000712d89 in update_statistics_for_table (thd=0x7f45aeb2f070, table=0x7f45ac09e470) at 10.0/sql/sql_statistics.cc:2628
|
#5 0x00000000007a4f75 in mysql_admin_table(THD *, TABLE_LIST *, HA_CHECK_OPT *, const char *, thr_lock_type, bool, bool, uint, int (*)(THD *, TABLE_LIST *, HA_CHECK_OPT *), struct {...}, int (*)(THD *, TABLE_LIST *)) (thd=0x7f45aeb2f070, tables=0x7f45ac014180, check_opt=0x7f45aeb33ba0, operator_name=0xf4ac87 "analyze", lock_type=TL_READ_NO_INSERT, open_for_modify=true, repair_table_use_frm=false, extra_open_options=0, prepare_func=0, operator_func=(int (handler::*)(handler * const, THD *, HA_CHECK_OPT *)) 0x8712d4 <handler::ha_analyze(THD*, st_ha_check_opt*)>, view_operator_func=0) at 10.0/sql/sql_admin.cc:738
|
#6 0x00000000007a6565 in Sql_cmd_analyze_table::execute (this=0x7f45ac014760, thd=0x7f45aeb2f070) at 10.0/sql/sql_admin.cc:1148
|
#7 0x0000000000682928 in mysql_execute_command (thd=0x7f45aeb2f070) at 10.0/sql/sql_parse.cc:5078
|
#8 0x00000000006859bd in mysql_parse (thd=0x7f45aeb2f070, rawbuf=0x7f45ac014088 "analyze table t1 persistent for all", length=35, parser_state=0x7f45b5ed9610) at 10.0/sql/sql_parse.cc:6407
|
#9 0x00000000006787b2 in dispatch_command (command=COM_QUERY, thd=0x7f45aeb2f070, packet=0x7f45afbf6071 "", packet_length=35) at 10.0/sql/sql_parse.cc:1299
|
#10 0x0000000000677b57 in do_command (thd=0x7f45aeb2f070) at 10.0/sql/sql_parse.cc:996
|
#11 0x0000000000794877 in do_handle_one_connection (thd_arg=0x7f45aeb2f070) at 10.0/sql/sql_connect.cc:1375
|
#12 0x00000000007945ca in handle_one_connection (arg=0x7f45aeb2f070) at 10.0/sql/sql_connect.cc:1289
|
#13 0x0000000000ccda5e in pfs_spawn_thread (arg=0x7f45adf67bf0) at 10.0/storage/perfschema/pfs.cc:1860
|
#14 0x00007f45b5ac6b50 in start_thread (arg=<optimized out>) at pthread_create.c:304
|
#15 0x00007f45b3d7d20d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:112
|
CREATE TABLE t1 (a longtext, FULLTEXT KEY (`a`)) ENGINE=MyISAM; |
insert into t1 values (unhex('3E0D0A4141414142334E7A614331796332454141414142497741414167454172')); |
analyze table t1 persistent for all; |
#6 0x00007fc9552186f1 in *__GI___assert_fail (assertion=0xf1acaa "bit < (map)->n_bits", file=<optimized out>, line=130, function=0xf1bca0 "uint bitmap_is_set(const MY_BITMAP*, uint)") at assert.c:81
|
#7 0x0000000000711237 in bitmap_is_set (map=0x7fc94d49e580, bit=42405) at 10.0/include/my_bitmap.h:130
|
#8 0x0000000000712dab in update_statistics_for_table (thd=0x7fc94ff2f070, table=0x7fc94d49e470) at 10.0/sql/sql_statistics.cc:2628
|
#9 0x00000000007a4f75 in mysql_admin_table(THD *, TABLE_LIST *, HA_CHECK_OPT *, const char *, thr_lock_type, bool, bool, uint, int (*)(THD *, TABLE_LIST *, HA_CHECK_OPT *), struct {...}, int (*)(THD *, TABLE_LIST *)) (thd=0x7fc94ff2f070, tables=0x7fc94d414180, check_opt=0x7fc94ff33ba0, operator_name=0xf4ac87 "analyze", lock_type=TL_READ_NO_INSERT, open_for_modify=true, repair_table_use_frm=false, extra_open_options=0, prepare_func=0, operator_func=(int (handler::*)(handler * const, THD *, HA_CHECK_OPT *)) 0x8712d4 <handler::ha_analyze(THD*, st_ha_check_opt*)>, view_operator_func=0) at 10.0/sql/sql_admin.cc:738
|
#10 0x00000000007a6565 in Sql_cmd_analyze_table::execute (this=0x7fc94d414760, thd=0x7fc94ff2f070) at 10.0/sql/sql_admin.cc:1148
|
#11 0x0000000000682928 in mysql_execute_command (thd=0x7fc94ff2f070) at 10.0/sql/sql_parse.cc:5078
|
#12 0x00000000006859bd in mysql_parse (thd=0x7fc94ff2f070, rawbuf=0x7fc94d414088 "analyze table t1 persistent for all", length=35, parser_state=0x7fc957425610) at 10.0/sql/sql_parse.cc:6407
|
#13 0x00000000006787b2 in dispatch_command (command=COM_QUERY, thd=0x7fc94ff2f070, packet=0x7fc950ff6071 "", packet_length=35) at 10.0/sql/sql_parse.cc:1299
|
#14 0x0000000000677b57 in do_command (thd=0x7fc94ff2f070) at 10.0/sql/sql_parse.cc:996
|
#15 0x0000000000794877 in do_handle_one_connection (thd_arg=0x7fc94ff2f070) at 10.0/sql/sql_connect.cc:1375
|
#16 0x00000000007945ca in handle_one_connection (arg=0x7fc94ff2f070) at 10.0/sql/sql_connect.cc:1289
|
#17 0x0000000000ccda5e in pfs_spawn_thread (arg=0x7fc94f367bf0) at 10.0/storage/perfschema/pfs.cc:1860
|
#18 0x00007fc957012b50 in start_thread (arg=<optimized out>) at pthread_create.c:304
|
#19 0x00007fc9552c920d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:112
|
CREATE TABLE t1 (a longtext, FULLTEXT KEY (`a`)) ENGINE=MyISAM; |
insert into t1 values (unhex('3E0D0A4141414142334E7A6143317963324541414141424977414141674541')); |
analyze table t1 persistent for all; |
#3 <signal handler called>
|
#4 __strlen_sse2 () at ../sysdeps/x86_64/multiarch/../strlen.S:32
|
#5 0x0000000000716bc3 in Column_stat::set_key_fields (this=0x7f3cd8a16020, col=0x7f3cd07f4145) at 10.0/sql/sql_statistics.cc:841
|
#6 0x0000000000712df9 in update_statistics_for_table (thd=0x7f3cd132f070, table=0x7f3cce89e470) at 10.0/sql/sql_statistics.cc:2631
|
#7 0x00000000007a4f75 in mysql_admin_table(THD *, TABLE_LIST *, HA_CHECK_OPT *, const char *, thr_lock_type, bool, bool, uint, int (*)(THD *, TABLE_LIST *, HA_CHECK_OPT *), struct {...}, int (*)(THD *, TABLE_LIST *)) (thd=0x7f3cd132f070, tables=0x7f3cce814180, check_opt=0x7f3cd1333ba0, operator_name=0xf4ac87 "analyze", lock_type=TL_READ_NO_INSERT, open_for_modify=true, repair_table_use_frm=false, extra_open_options=0, prepare_func=0, operator_func=(int (handler::*)(handler * const, THD *, HA_CHECK_OPT *)) 0x8712d4 <handler::ha_analyze(THD*, st_ha_check_opt*)>, view_operator_func=0) at 10.0/sql/sql_admin.cc:738
|
#8 0x00000000007a6565 in Sql_cmd_analyze_table::execute (this=0x7f3cce814760, thd=0x7f3cd132f070) at 10.0/sql/sql_admin.cc:1148
|
#9 0x0000000000682928 in mysql_execute_command (thd=0x7f3cd132f070) at 10.0/sql/sql_parse.cc:5078
|
#10 0x00000000006859bd in mysql_parse (thd=0x7f3cd132f070, rawbuf=0x7f3cce814088 "analyze table t1 persistent for all", length=35, parser_state=0x7f3cd8a18610) at 10.0/sql/sql_parse.cc:6407
|
#11 0x00000000006787b2 in dispatch_command (command=COM_QUERY, thd=0x7f3cd132f070, packet=0x7f3cd23f6071 "", packet_length=35) at 10.0/sql/sql_parse.cc:1299
|
#12 0x0000000000677b57 in do_command (thd=0x7f3cd132f070) at 10.0/sql/sql_parse.cc:996
|
#13 0x0000000000794877 in do_handle_one_connection (thd_arg=0x7f3cd132f070) at 10.0/sql/sql_connect.cc:1375
|
#14 0x00000000007945ca in handle_one_connection (arg=0x7f3cd132f070) at 10.0/sql/sql_connect.cc:1289
|
#15 0x0000000000ccda5e in pfs_spawn_thread (arg=0x7f3cd0767bf0) at 10.0/storage/perfschema/pfs.cc:1860
|
#16 0x00007f3cd8605b50 in start_thread (arg=<optimized out>) at pthread_create.c:304
|
#17 0x00007f3cd68bc20d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:112
|
Could you please attach your cnf file(s) – or maybe it is already attached to some other bug that you reported?