Hello,
we had an issue with mariadb 5.5.35 and couldn't reproduce the problem.
OS - Centos 6.
140211 12:43:57 [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: 5.5.35-MariaDB-log
|
key_buffer_size=268435456
|
read_buffer_size=131072
|
max_used_connections=727
|
max_threads=742
|
thread_count=585
|
It is possible that mysqld could use up to
|
key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 24684221 K bytes of memory
|
Hope that's ok; if not, decrease some variables in the equation.
|
|
Thread pointer: 0x0x7fbd83a4d7e0
|
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 = 0x7fa027b6ed58 thread_stack 0x48000
|
(my_addr_resolve failure: fork)
|
/usr/libexec/mysqld(my_print_stacktrace+0x2e) [0x7fbcd586cc5e]
|
/usr/libexec/mysqld(handle_fatal_signal+0x4ac) [0x7fbcd54b551c]
|
/lib64/libpthread.so.0(+0x3578c0f500) [0x7fbcd4be1500]
|
/usr/libexec/mysqld(+0x7660e0) [0x7fbcd57770e0]
|
/usr/libexec/mysqld(+0x76684c) [0x7fbcd577784c]
|
/usr/libexec/mysqld(+0x7533be) [0x7fbcd57643be]
|
/usr/libexec/mysqld(+0x74f5d7) [0x7fbcd57605d7]
|
/usr/libexec/mysqld(+0x751ecf) [0x7fbcd5762ecf]
|
/usr/libexec/mysqld(+0x744c99) [0x7fbcd5755c99]
|
/usr/libexec/mysqld(+0x6f94f7) [0x7fbcd570a4f7]
|
/usr/libexec/mysqld(+0x6c9984) [0x7fbcd56da984]
|
/usr/libexec/mysqld(handler::read_range_next()+0x7a) [0x7fbcd54b6dba]
|
/usr/libexec/mysqld(handler::multi_range_read_next(void**)+0xb2) [0x7fbcd5460182]
|
/usr/libexec/mysqld(Mrr_simple_index_reader::get_next(void**)+0x20) [0x7fbcd5460240]
|
/usr/libexec/mysqld(DsMrr_impl::dsmrr_next(void**)+0x2f) [0x7fbcd54604ff]
|
/usr/libexec/mysqld(QUICK_RANGE_SELECT::get_next()+0x52) [0x7fbcd558a7b2]
|
/usr/libexec/mysqld(QUICK_ROR_INTERSECT_SELECT::get_next()+0x23e) [0x7fbcd558bffe]
|
/usr/libexec/mysqld(+0x597b68) [0x7fbcd55a8b68]
|
/usr/libexec/mysqld(sub_select(JOIN*, st_join_table*, bool)+0x1ee) [0x7fbcd53aa75e]
|
/usr/libexec/mysqld(+0x39ca05) [0x7fbcd53ada05]
|
/usr/libexec/mysqld(JOIN::exec()+0x739) [0x7fbcd53c7639]
|
/usr/libexec/mysqld(mysql_select(THD*, Item***, TABLE_LIST*, unsigned int, List<Item>&, Item*, unsigned int, st_order*, st_order*, Item*, st_order*, unsigned long long, select_result*, st_select_lex_unit*, st_select_lex*)+0x128) [0x7fbcd53c96b8]
|
/usr/libexec/mysqld(handle_select(THD*, LEX*, select_result*, unsigned long)+0x2b3) [0x7fbcd53ca2d3]
|
/usr/libexec/mysqld(+0x36535f) [0x7fbcd537635f]
|
/usr/libexec/mysqld(mysql_execute_command(THD*)+0x30b5) [0x7fbcd537d435]
|
/usr/libexec/mysqld(mysql_parse(THD*, char*, unsigned int, Parser_state*)+0x142) [0x7fbcd53805e2]
|
/usr/libexec/mysqld(dispatch_command(enum_server_command, THD*, char*, unsigned int)+0x175b) [0x7fbcd5381ddb]
|
/usr/libexec/mysqld(do_handle_one_connection(THD*)+0xff) [0x7fbcd543599f]
|
/usr/libexec/mysqld(handle_one_connection+0x51) [0x7fbcd5435ae1]
|
/usr/libexec/mysqld(+0x829ed8) [0x7fbcd583aed8]
|
/lib64/libpthread.so.0(+0x3578c07851) [0x7fbcd4bd9851]
|
/lib64/libc.so.6(clone+0x6d) [0x7fbcd34f994d]
|
|
Trying to get some variables.
|
Some pointers may be invalid and cause the dump to abort.
|
Query (0x7fa174dab928): is an invalid pointer
|
Connection ID (thread ID): 49263308
|
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=off
|
|
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.
|
140211 12:43:58 mysqld_safe Number of processes running now: 0
|
140211 12:43:58 mysqld_safe mysqld restarted
|
- relates to
-
MDEV-5670
Assertion failure in file buf0lru.c line 2355
-
-
Closed
{"report":{"fcp":861.8999996185303,"ttfb":238.80000019073486,"pageVisibility":"visible","entityId":30703,"key":"jira.project.issue.view-issue","isInitial":true,"threshold":1000,"elementTimings":{},"userDeviceMemory":8,"userDeviceProcessors":64,"apdex":1,"journeyId":"bac63285-b610-4dbc-8215-033d04cab603","navigationType":0,"readyForUser":953.8000001907349,"redirectCount":0,"resourceLoadedEnd":1293.8999996185303,"resourceLoadedStart":244.5,"resourceTiming":[{"duration":22.09999942779541,"initiatorType":"link","name":"https://jira.mariadb.org/s/2c21342762a6a02add1c328bed317ffd-CDN/lu2cib/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/css/_super/batch.css","startTime":244.5,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":244.5,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":266.5999994277954,"responseStart":0,"secureConnectionStart":0},{"duration":22.100000381469727,"initiatorType":"link","name":"https://jira.mariadb.org/s/7ebd35e77e471bc30ff0eba799ebc151-CDN/lu2cib/820016/12ta74/494e4c556ecbb29f90a3d3b4f09cb99c/_/download/contextbatch/css/jira.browse.project,project.issue.navigator,jira.view.issue,jira.general,jira.global,atl.general,-_super/batch.css?agile_global_admin_condition=true&jag=true&jira.create.linked.issue=true&slack-enabled=true&whisper-enabled=true","startTime":244.89999961853027,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":244.89999961853027,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":267,"responseStart":0,"secureConnectionStart":0},{"duration":79.30000019073486,"initiatorType":"script","name":"https://jira.mariadb.org/s/0917945aaa57108d00c5076fea35e069-CDN/lu2cib/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/js/_super/batch.js?locale=en","startTime":245,"connectEnd":245,"connectStart":245,"domainLookupEnd":245,"domainLookupStart":245,"fetchStart":245,"redirectEnd":0,"redirectStart":0,"requestStart":245,"responseEnd":324.30000019073486,"responseStart":324.30000019073486,"secureConnectionStart":245},{"duration":199.89999961853027,"initiatorType":"script","name":"https://jira.mariadb.org/s/2d8175ec2fa4c816e8023260bd8c1786-CDN/lu2cib/820016/12ta74/494e4c556ecbb29f90a3d3b4f09cb99c/_/download/contextbatch/js/jira.browse.project,project.issue.navigator,jira.view.issue,jira.general,jira.global,atl.general,-_super/batch.js?agile_global_admin_condition=true&jag=true&jira.create.linked.issue=true&locale=en&slack-enabled=true&whisper-enabled=true","startTime":245.19999980926514,"connectEnd":245.19999980926514,"connectStart":245.19999980926514,"domainLookupEnd":245.19999980926514,"domainLookupStart":245.19999980926514,"fetchStart":245.19999980926514,"redirectEnd":0,"redirectStart":0,"requestStart":245.19999980926514,"responseEnd":445.0999994277954,"responseStart":445.0999994277954,"secureConnectionStart":245.19999980926514},{"duration":204.10000038146973,"initiatorType":"script","name":"https://jira.mariadb.org/s/a9324d6758d385eb45c462685ad88f1d-CDN/lu2cib/820016/12ta74/c92c0caa9a024ae85b0ebdbed7fb4bd7/_/download/contextbatch/js/atl.global,-_super/batch.js?locale=en","startTime":245.39999961853027,"connectEnd":245.39999961853027,"connectStart":245.39999961853027,"domainLookupEnd":245.39999961853027,"domainLookupStart":245.39999961853027,"fetchStart":245.39999961853027,"redirectEnd":0,"redirectStart":0,"requestStart":245.39999961853027,"responseEnd":449.5,"responseStart":449.5,"secureConnectionStart":245.39999961853027},{"duration":204.4000005722046,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2cib/820016/12ta74/1.0/_/download/batch/jira.webresources:calendar-en/jira.webresources:calendar-en.js","startTime":245.5999994277954,"connectEnd":245.5999994277954,"connectStart":245.5999994277954,"domainLookupEnd":245.5999994277954,"domainLookupStart":245.5999994277954,"fetchStart":245.5999994277954,"redirectEnd":0,"redirectStart":0,"requestStart":245.5999994277954,"responseEnd":450,"responseStart":450,"secureConnectionStart":245.5999994277954},{"duration":204.5,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2cib/820016/12ta74/1.0/_/download/batch/jira.webresources:calendar-localisation-moment/jira.webresources:calendar-localisation-moment.js","startTime":245.80000019073486,"connectEnd":245.80000019073486,"connectStart":245.80000019073486,"domainLookupEnd":245.80000019073486,"domainLookupStart":245.80000019073486,"fetchStart":245.80000019073486,"redirectEnd":0,"redirectStart":0,"requestStart":245.80000019073486,"responseEnd":450.30000019073486,"responseStart":450.30000019073486,"secureConnectionStart":245.80000019073486},{"duration":226.19999980926514,"initiatorType":"link","name":"https://jira.mariadb.org/s/b04b06a02d1959df322d9cded3aeecc1-CDN/lu2cib/820016/12ta74/a2ff6aa845ffc9a1d22fe23d9ee791fc/_/download/contextbatch/css/jira.global.look-and-feel,-_super/batch.css","startTime":246,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":246,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":472.19999980926514,"responseStart":0,"secureConnectionStart":0},{"duration":204.60000038146973,"initiatorType":"script","name":"https://jira.mariadb.org/rest/api/1.0/shortcuts/820016/47140b6e0a9bc2e4913da06536125810/shortcuts.js?context=issuenavigation&context=issueaction","startTime":246.19999980926514,"connectEnd":246.19999980926514,"connectStart":246.19999980926514,"domainLookupEnd":246.19999980926514,"domainLookupStart":246.19999980926514,"fetchStart":246.19999980926514,"redirectEnd":0,"redirectStart":0,"requestStart":246.19999980926514,"responseEnd":450.80000019073486,"responseStart":450.80000019073486,"secureConnectionStart":246.19999980926514},{"duration":225.9000005722046,"initiatorType":"link","name":"https://jira.mariadb.org/s/3ac36323ba5e4eb0af2aa7ac7211b4bb-CDN/lu2cib/820016/12ta74/d176f0986478cc64f24226b3d20c140d/_/download/contextbatch/css/com.atlassian.jira.projects.sidebar.init,-_super,-project.issue.navigator,-jira.view.issue/batch.css?jira.create.linked.issue=true","startTime":246.39999961853027,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":246.39999961853027,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":472.30000019073486,"responseStart":0,"secureConnectionStart":0},{"duration":204.89999961853027,"initiatorType":"script","name":"https://jira.mariadb.org/s/5d5e8fe91fbc506585e83ea3b62ccc4b-CDN/lu2cib/820016/12ta74/d176f0986478cc64f24226b3d20c140d/_/download/contextbatch/js/com.atlassian.jira.projects.sidebar.init,-_super,-project.issue.navigator,-jira.view.issue/batch.js?jira.create.linked.issue=true&locale=en","startTime":246.5,"connectEnd":246.5,"connectStart":246.5,"domainLookupEnd":246.5,"domainLookupStart":246.5,"fetchStart":246.5,"redirectEnd":0,"redirectStart":0,"requestStart":246.5,"responseEnd":451.3999996185303,"responseStart":451.3999996185303,"secureConnectionStart":246.5},{"duration":434.30000019073486,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2cib/820016/12ta74/1.0/_/download/batch/jira.webresources:bigpipe-js/jira.webresources:bigpipe-js.js","startTime":255.5999994277954,"connectEnd":255.5999994277954,"connectStart":255.5999994277954,"domainLookupEnd":255.5999994277954,"domainLookupStart":255.5999994277954,"fetchStart":255.5999994277954,"redirectEnd":0,"redirectStart":0,"requestStart":255.5999994277954,"responseEnd":689.8999996185303,"responseStart":689.8999996185303,"secureConnectionStart":255.5999994277954},{"duration":1023,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2cib/820016/12ta74/1.0/_/download/batch/jira.webresources:bigpipe-init/jira.webresources:bigpipe-init.js","startTime":255.69999980926514,"connectEnd":255.69999980926514,"connectStart":255.69999980926514,"domainLookupEnd":255.69999980926514,"domainLookupStart":255.69999980926514,"fetchStart":255.69999980926514,"redirectEnd":0,"redirectStart":0,"requestStart":255.69999980926514,"responseEnd":1278.6999998092651,"responseStart":1278.6999998092651,"secureConnectionStart":255.69999980926514},{"duration":204.20000076293945,"initiatorType":"xmlhttprequest","name":"https://jira.mariadb.org/rest/webResources/1.0/resources","startTime":486.0999994277954,"connectEnd":486.0999994277954,"connectStart":486.0999994277954,"domainLookupEnd":486.0999994277954,"domainLookupStart":486.0999994277954,"fetchStart":486.0999994277954,"redirectEnd":0,"redirectStart":0,"requestStart":486.0999994277954,"responseEnd":690.3000001907349,"responseStart":690.3000001907349,"secureConnectionStart":486.0999994277954},{"duration":539.0999994277954,"initiatorType":"link","name":"https://jira.mariadb.org/s/d5715adaadd168a9002b108b2b039b50-CDN/lu2cib/820016/12ta74/be4b45e9cec53099498fa61c8b7acba4/_/download/contextbatch/css/jira.project.sidebar,-_super,-project.issue.navigator,-jira.general,-jira.browse.project,-jira.view.issue,-jira.global,-atl.general,-com.atlassian.jira.projects.sidebar.init/batch.css?agile_global_admin_condition=true&jag=true&jira.create.linked.issue=true&slack-enabled=true&whisper-enabled=true","startTime":754.8000001907349,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":754.8000001907349,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":1293.8999996185303,"responseStart":0,"secureConnectionStart":0}],"fetchStart":1,"domainLookupStart":1,"domainLookupEnd":1,"connectStart":1,"connectEnd":1,"requestStart":73,"responseStart":239,"responseEnd":252,"domLoading":243,"domInteractive":1302,"domContentLoadedEventStart":1302,"domContentLoadedEventEnd":1345,"domComplete":3266,"loadEventStart":3266,"loadEventEnd":3268,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[{"name":"bigPipe.sidebar-id.start","time":1281.0999994277954},{"name":"bigPipe.sidebar-id.end","time":1282},{"name":"bigPipe.activity-panel-pipe-id.start","time":1282.0999994277954},{"name":"bigPipe.activity-panel-pipe-id.end","time":1284.3000001907349},{"name":"activityTabFullyLoaded","time":1351.1999998092651}],"measures":[],"correlationId":"34c5ca7a720eeb","effectiveType":"4g","downlink":10,"rtt":0,"serverDuration":93,"dbReadsTimeInMs":9,"dbConnsTimeInMs":17,"applicationHash":"9d11dbea5f4be3d4cc21f03a88dd11d8c8687422","experiments":[]}}