[MDEV-16068] [Draft] Server crashed in alloc_histograms_for_table_share Created: 2018-05-01  Updated: 2018-07-11  Resolved: 2018-07-11

Status: Closed
Project: MariaDB Server
Component/s: Optimizer, Server
Affects Version/s: 10.0, 10.3
Fix Version/s: N/A

Type: Bug Priority: Major
Reporter: Elena Stepanova Assignee: Elena Stepanova
Resolution: Duplicate Votes: 0
Labels: None

Issue Links:
Duplicate
is duplicated by MDEV-16507 SIGSEGV when use_stat_tables = prefer... Closed

 Description   

http://buildbot.askmonty.org/buildbot/builders/qa-win-debug/builds/1428/steps/crash_tests/logs/stdio

10.0 d6dbe8e2071bf9fdc21b5530abce88ff01b40e25

Version: '10.0.35-MariaDB-debug'  socket: ''  port: 11500  Source distribution
180428  9:16:52 [ERROR] mysqld got exception 0xc0000005 ;
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 https://mariadb.com/kb/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.35-MariaDB-debug
key_buffer_size=1048576
read_buffer_size=131072
max_used_connections=7
max_threads=501
thread_count=7
It is possible that mysqld could use up to 
key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 196107 K  bytes of memory
Hope that's ok; if not, decrease some variables in the equation.
 
Thread pointer: 0xe7a5148478
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...
ntdll.dll!RtlLockHeap()
ntdll.dll!RtlEnterCriticalSection()
mysqld.exe!inline_mysql_mutex_lock()[mysql_thread.h:693]
mysqld.exe!alloc_histograms_for_table_share()[sql_statistics.cc:2253]
mysqld.exe!read_histograms_for_table()[sql_statistics.cc:3029]
mysqld.exe!read_statistics_for_tables_if_needed()[sql_statistics.cc:3111]
mysqld.exe!open_and_lock_tables()[sql_base.cc:5247]
mysqld.exe!open_and_lock_tables()[sql_base.h:491]
mysqld.exe!mysql_execute_command()[sql_parse.cc:3515]
mysqld.exe!mysql_parse()[sql_parse.cc:6573]
mysqld.exe!dispatch_command()[sql_parse.cc:1298]
mysqld.exe!do_command()[sql_parse.cc:999]
mysqld.exe!threadpool_process_request()[threadpool_common.cc:271]
mysqld.exe!io_completion_callback()[threadpool_win.cc:568]
KERNEL32.DLL!VirtualUnlock()
ntdll.dll!RtlGetActiveActivationContext()
ntdll.dll!RtlFreeUnicodeString()
KERNEL32.DLL!BaseThreadInitThunk()
ntdll.dll!RtlUserThreadStart()
 
Trying to get some variables.
Some pointers may be invalid and cause the dump to abort.
Query (0xe7a2698a50): INSERT INTO table11 SELECT * FROM table11 LIMIT 0 /* QNO 2002 CON_ID 11

windows 59febe381aaf

E:\buildbot\rqg/runall.pl --no-mask --seed=1524899240 --threads=5 --duration=400 --queries=100M --reporters=QueryTimeout,Backtrace,ErrorLog,Deadlock,Shutdown --redefine=conf/mariadb/redefine_random_keys.yy --redefine=conf/mariadb/redefine_set_session_vars.yy --validators=TransformerNoComparator --transformers=ConvertSubqueriesToViews,DisableOptimizations,EnableOptimizations,ExecuteAsCTE,ExecuteAsInsertSelect,ExecuteAsPreparedOnce,ExecuteAsSelectItem,ExecuteAsUnion,ExecuteAsUpdateDelete,ExecuteAsView,NullIf,OrderBy,StraightJoin,ExecuteAsExecuteImmediate --store-binaries --grammar=conf/optimizer/updateable_views.yy --mysqld=--default-storage-engine=MyISAM --mysqld=--init-file=E:/buildbot/rqg/conf/optimizer/updateable_views.init --mtr-build-thread=150 --basedir1=D:\qa-win-debug\install --vardir1=E:\buildbot\vardirs\qa-win-debug\10.0-1428\optim-crash-tests/current1_1



 Comments   
Comment by Alice Sherepa [ 2018-05-14 ]

on 10.3

180514 13:07:47 [ERROR] mysqld got signal 11 ;
Server version: 10.3.7-MariaDB-debug-log
key_buffer_size=134217728
read_buffer_size=131072
max_used_connections=2
max_threads=153
thread_count=10
Thread pointer: 0x7f6b88000a98
 
stack_bottom = 0x7f6bfc934ec0 thread_stack 0x49000
/home/alice/git/10.3/sql/mysqld(my_print_stacktrace+0x40)[0x55733adbf931]
/home/alice/git/10.3/sql/mysqld(handle_fatal_signal+0x3e1)[0x55733a5ae5b8]
/lib/x86_64-linux-gnu/libpthread.so.0(+0x11390)[0x7f6bfe538390]
sql/sql_statistics.cc:2403(alloc_histograms_for_table_share(THD*, TABLE_SHARE*, bool))[0x55733a36f5d5]
sql/sql_statistics.cc:3166(read_histograms_for_table(THD*, TABLE*, TABLE_LIST*))[0x55733a370e2a]
sql/sql_statistics.cc:3248(read_statistics_for_tables_if_needed(THD*, TABLE_LIST*))[0x55733a37126a]
sql/sql_base.cc:4938(open_and_lock_tables(THD*, DDL_options_st const&, TABLE_LIST*, bool, unsigned int, Prelocking_strategy*))[0x55733a22ab47]
sql/sql_base.h:491(open_and_lock_tables(THD*, TABLE_LIST*, bool, unsigned int))[0x55733a1eaa28]
sql/sql_insert.cc:766(mysql_insert(THD*, TABLE_LIST*, List<Item>&, List<List<Item> >&, List<Item>&, List<Item>&, enum_duplicates, bool))[0x55733a277605]
sql/sql_parse.cc:4723(mysql_execute_command(THD*))[0x55733a2b91e2]
sql/sql_parse.cc:8003(mysql_parse(THD*, char*, unsigned int, Parser_state*, bool, bool))[0x55733a2c3d47]
sql/sql_parse.cc:1848(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool, bool))[0x55733a2b0feb]
sql/sql_parse.cc:1391(do_command(THD*))[0x55733a2afa08]
sql/sql_connect.cc:1402(do_handle_one_connection(CONNECT*))[0x55733a419b19]
sql/sql_connect.cc:1309(handle_one_connection)[0x55733a41986a]
/lib/x86_64-linux-gnu/libpthread.so.0(+0x76ba)[0x7f6bfe52e6ba]
x86_64/clone.S:111(clone)[0x7f6bfd9c341d]

Comment by Elena Stepanova [ 2018-07-11 ]

It appears to be a duplicate of recently fixed MDEV-16507.

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