Type:
Bug
Priority:
Critical
Resolution:
Fixed
Affects Version/s:
5.3.12 , 5.5.40 , 10.0.12 , 10.0.14 , 10.1.0
i create user 'test'@'192.168.26.172' ,and MariaDB on 192.168.26.171,when i use user 'root'@'localhost' login DB ,and issue command kill user 'test'@'192.168.26.172 ,the DB crashed \ T.T /
MariaDB [(none)]> show processlist;
+ ----+------+----------------------+------+---------+------+-------+------------------+----------+
| Id | User | Host | db | Command | Time | State | Info | Progress |
+ ----+------+----------------------+------+---------+------+-------+------------------+----------+
| 3 | root | localhost | NULL | Query | 0 | init | show processlist | 0.000 |
| 4 | test | localhost | NULL | Sleep | 20 | | NULL | 0.000 |
| 5 | test | 192.168.26.172:14061 | NULL | Sleep | 14 | | NULL | 0.000 |
+ ----+------+----------------------+------+---------+------+-------+------------------+----------+
3 rows in set (0.00 sec)
MariaDB [(none)]> kill user 'test' @ '192.168.26.172' ;
ERROR 2013 (HY000): Lost connection to MySQL server during query
MariaDB [(none)]> show processlist;
ERROR 2006 (HY000): MySQL server has gone away
No connection . Trying to reconnect...
Connection id: 3
Current database : *** NONE ***
+ ----+------+-----------+------+---------+------+-------+------------------+----------+
| Id | User | Host | db | Command | Time | State | Info | Progress |
+ ----+------+-----------+------+---------+------+-------+------------------+----------+
| 3 | root | localhost | NULL | Query | 0 | init | show processlist | 0.000 |
+ ----+------+-----------+------+---------+------+-------+------------------+----------+
1 row in set (0.00 sec)
Version: '10.0.12-MariaDB-log' socket: '/tmp/mysql99.sock' port: 3306 MariaDB Server
141020 14:33:12 [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.12-MariaDB-log
key_buffer_size=134217728
read_buffer_size=131072
max_used_connections=3
max_threads=153
thread_count=3
It is possible that mysqld could use up to
key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 467144 K bytes of memory
Hope that's ok; if not, decrease some variables in the equation.
Thread pointer: 0x0x7feb7b7f5008
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 = 0x7feb94db4d10 thread_stack 0x48000
/usr/sbin/mysqld(my_print_stacktrace+0x2b)[0xb6c14b]
/usr/sbin/mysqld(handle_fatal_signal+0x398)[0x7255f8]
/lib64/libpthread.so.0[0x377d60f500]
/lib64/libc.so.6[0x377d327a96]
/usr/sbin/mysqld(_Z21mysql_execute_commandP3THD+0x599f)[0x5d4d5f]
/usr/sbin/mysqld[0x5d5b12]
/usr/sbin/mysqld(_Z16dispatch_command19enum_server_commandP3THDPcj+0x1b20)[0x5d7cd0]
/usr/sbin/mysqld(_Z24do_handle_one_connectionP3THD+0x453)[0x6950e3]
/usr/sbin/mysqld(handle_one_connection+0x42)[0x6951b2]
/lib64/libpthread.so.0[0x377d607851]
/lib64/libc.so.6(clone+0x6d)[0x377d2e890d]
Trying to get some variables.
Some pointers may be invalid and cause the dump to abort.
Query (0x7feb6a81e020): is an invalid pointer
Connection ID (thread ID): 3
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.
141020 14:33:12 mysqld_safe Number of processes running now: 0
141020 14:33:12 mysqld_safe mysqld restarted
141020 14:33:12 [Note] InnoDB: Using mutexes to ref count buffer pool pages
141020 14:33:12 [Note] InnoDB: The InnoDB memory heap is disabled
141020 14:33:12 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
141020 14:33:12 [Note] InnoDB: Compressed tables use zlib 1.2.3
141020 14:33:12 [Note] InnoDB: Using Linux native AIO
141020 14:33:12 [Note] InnoDB: Using CPU crc32 instructions
2014-10-20 14:33:12 7fad0089d840 InnoDB: Warning: io_setup() failed with EAGAIN. Will make 5 attempts before giving up.
InnoDB: Warning: io_setup() attempt 1 failed.
InnoDB: Warning: io_setup() attempt 2 failed.
InnoDB: Warning: io_setup() attempt 3 failed.
InnoDB: Warning: io_setup() attempt 4 failed.
InnoDB: Warning: io_setup() attempt 5 failed.
2014-10-20 14:33:14 7fad0089d840 InnoDB: Error: io_setup() failed with EAGAIN after 5 attempts.
InnoDB: You can disable Linux Native AIO by setting innodb_use_native_aio = 0 in my.cnf
InnoDB: Warning: Linux Native AIO disabled because os_aio_linux_create_io_ctx() failed. To get rid of this warning you can try increasing system fs.aio-max-nr to 1048576 or larger or setting innodb_use_native_aio = 0 in my.cnf
141020 14:33:14 [Note] InnoDB: Initializing buffer pool, size = 128.0M
141020 14:33:14 [Note] InnoDB: Completed initialization of buffer pool
141020 14:33:14 [Note] InnoDB: Highest supported file format is Barracuda.
141020 14:33:14 [Note] InnoDB: The log sequence numbers 1616727 and 1616727 in ibdata files do not match the log sequence number 1244040091 in the ib_logfiles!
141020 14:33:14 [Note] InnoDB: Database was not shutdown normally!
141020 14:33:14 [Note] InnoDB: Starting crash recovery.
141020 14:33:14 [Note] InnoDB: Reading tablespace information from the .ibd files...
141020 14:33:14 [Note] InnoDB: Restoring possible half-written data pages
141020 14:33:14 [Note] InnoDB: from the doublewrite buffer...
InnoDB: Last MySQL binlog file position 0 316868674, file name /var/lib/mysql/99/sm_99db-bin.000016
141020 14:33:14 [Note] InnoDB: 128 rollback segment(s) are active.
141020 14:33:14 [Note] InnoDB: Waiting for purge to start
141020 14:33:14 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.17-65.0 started; log sequence number 1244040091
141020 14:33:14 [Note] Plugin 'FEEDBACK' is disabled.
141020 14:33:14 [Note] Recovering after a crash using /var/lib/mysql/99/sm_99db-bin
141020 14:33:14 [Note] Starting crash recovery...
141020 14:33:14 [Note] Crash recovery finished.
141020 14:33:14 [Note] Server socket created on IP: '0.0.0.0'.
141020 14:33:14 [Warning] 'user' entry 'root@hzih171' ignored in --skip-name-resolve mode.
{"report":{"fcp":1339.4000000953674,"ttfb":400.09999990463257,"pageVisibility":"visible","entityId":46300,"key":"jira.project.issue.view-issue","isInitial":true,"threshold":1000,"elementTimings":{},"userDeviceMemory":8,"userDeviceProcessors":64,"apdex":0.5,"journeyId":"85259f43-e3dd-4f33-9dfa-6a9a07e26173","navigationType":0,"readyForUser":1506.1999998092651,"redirectCount":0,"resourceLoadedEnd":1551.2999997138977,"resourceLoadedStart":405.69999980926514,"resourceTiming":[{"duration":336,"initiatorType":"link","name":"https://jira.mariadb.org/s/2c21342762a6a02add1c328bed317ffd-CDN/lu2cib/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/css/_super/batch.css","startTime":405.69999980926514,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":405.69999980926514,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":741.6999998092651,"responseStart":0,"secureConnectionStart":0},{"duration":336.19999980926514,"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":405.90000009536743,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":405.90000009536743,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":742.0999999046326,"responseStart":0,"secureConnectionStart":0},{"duration":363,"initiatorType":"script","name":"https://jira.mariadb.org/s/0917945aaa57108d00c5076fea35e069-CDN/lu2cib/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/js/_super/batch.js?locale=en","startTime":406.09999990463257,"connectEnd":406.09999990463257,"connectStart":406.09999990463257,"domainLookupEnd":406.09999990463257,"domainLookupStart":406.09999990463257,"fetchStart":406.09999990463257,"redirectEnd":0,"redirectStart":0,"requestStart":406.09999990463257,"responseEnd":769.0999999046326,"responseStart":769.0999999046326,"secureConnectionStart":406.09999990463257},{"duration":417.40000009536743,"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":406.2999997138977,"connectEnd":406.2999997138977,"connectStart":406.2999997138977,"domainLookupEnd":406.2999997138977,"domainLookupStart":406.2999997138977,"fetchStart":406.2999997138977,"redirectEnd":0,"redirectStart":0,"requestStart":406.2999997138977,"responseEnd":823.6999998092651,"responseStart":823.6999998092651,"secureConnectionStart":406.2999997138977},{"duration":423.40000009536743,"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":406.5,"connectEnd":406.5,"connectStart":406.5,"domainLookupEnd":406.5,"domainLookupStart":406.5,"fetchStart":406.5,"redirectEnd":0,"redirectStart":0,"requestStart":406.5,"responseEnd":829.9000000953674,"responseStart":829.9000000953674,"secureConnectionStart":406.5},{"duration":424.59999990463257,"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":406.69999980926514,"connectEnd":406.69999980926514,"connectStart":406.69999980926514,"domainLookupEnd":406.69999980926514,"domainLookupStart":406.69999980926514,"fetchStart":406.69999980926514,"redirectEnd":0,"redirectStart":0,"requestStart":406.69999980926514,"responseEnd":831.2999997138977,"responseStart":831.1999998092651,"secureConnectionStart":406.69999980926514},{"duration":425.19999980926514,"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":407,"connectEnd":407,"connectStart":407,"domainLookupEnd":407,"domainLookupStart":407,"fetchStart":407,"redirectEnd":0,"redirectStart":0,"requestStart":407,"responseEnd":832.1999998092651,"responseStart":832.1999998092651,"secureConnectionStart":407},{"duration":528.8000001907349,"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":407.09999990463257,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":407.09999990463257,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":935.9000000953674,"responseStart":0,"secureConnectionStart":0},{"duration":426,"initiatorType":"script","name":"https://jira.mariadb.org/rest/api/1.0/shortcuts/820016/47140b6e0a9bc2e4913da06536125810/shortcuts.js?context=issuenavigation&context=issueaction","startTime":407.2999997138977,"connectEnd":407.2999997138977,"connectStart":407.2999997138977,"domainLookupEnd":407.2999997138977,"domainLookupStart":407.2999997138977,"fetchStart":407.2999997138977,"redirectEnd":0,"redirectStart":0,"requestStart":407.2999997138977,"responseEnd":833.2999997138977,"responseStart":833.2999997138977,"secureConnectionStart":407.2999997138977},{"duration":528.7999997138977,"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":407.40000009536743,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":407.40000009536743,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":936.1999998092651,"responseStart":0,"secureConnectionStart":0},{"duration":426.40000009536743,"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":407.59999990463257,"connectEnd":407.59999990463257,"connectStart":407.59999990463257,"domainLookupEnd":407.59999990463257,"domainLookupStart":407.59999990463257,"fetchStart":407.59999990463257,"redirectEnd":0,"redirectStart":0,"requestStart":407.59999990463257,"responseEnd":834,"responseStart":834,"secureConnectionStart":407.59999990463257},{"duration":756,"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":416.5,"connectEnd":416.5,"connectStart":416.5,"domainLookupEnd":416.5,"domainLookupStart":416.5,"fetchStart":416.5,"redirectEnd":0,"redirectStart":0,"requestStart":416.5,"responseEnd":1172.5,"responseStart":1172.5,"secureConnectionStart":416.5},{"duration":1094.1999998092651,"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":416.59999990463257,"connectEnd":416.59999990463257,"connectStart":416.59999990463257,"domainLookupEnd":416.59999990463257,"domainLookupStart":416.59999990463257,"fetchStart":416.59999990463257,"redirectEnd":0,"redirectStart":0,"requestStart":416.59999990463257,"responseEnd":1510.7999997138977,"responseStart":1510.7999997138977,"secureConnectionStart":416.59999990463257},{"duration":206.7000002861023,"initiatorType":"xmlhttprequest","name":"https://jira.mariadb.org/rest/webResources/1.0/resources","startTime":974.6999998092651,"connectEnd":974.6999998092651,"connectStart":974.6999998092651,"domainLookupEnd":974.6999998092651,"domainLookupStart":974.6999998092651,"fetchStart":974.6999998092651,"redirectEnd":0,"redirectStart":0,"requestStart":974.6999998092651,"responseEnd":1181.4000000953674,"responseStart":1181.4000000953674,"secureConnectionStart":974.6999998092651},{"duration":283,"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":1268.2999997138977,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":1268.2999997138977,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":1551.2999997138977,"responseStart":0,"secureConnectionStart":0},{"duration":242,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2cib/820016/12ta74/e65b778d185daf5aee24936755b43da6/_/download/contextbatch/js/browser-metrics-plugin.contrib,-_super,-project.issue.navigator,-jira.view.issue,-atl.general/batch.js?agile_global_admin_condition=true&jag=true&jira.create.linked.issue=true&slack-enabled=true&whisper-enabled=true","startTime":1269.7999997138977,"connectEnd":1269.7999997138977,"connectStart":1269.7999997138977,"domainLookupEnd":1269.7999997138977,"domainLookupStart":1269.7999997138977,"fetchStart":1269.7999997138977,"redirectEnd":0,"redirectStart":0,"requestStart":1269.7999997138977,"responseEnd":1511.7999997138977,"responseStart":1511.7999997138977,"secureConnectionStart":1269.7999997138977},{"duration":279.30000019073486,"initiatorType":"script","name":"https://jira.mariadb.org/s/097ae97cb8fbec7d6ea4bbb1f26955b9-CDN/lu2cib/820016/12ta74/be4b45e9cec53099498fa61c8b7acba4/_/download/contextbatch/js/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.js?agile_global_admin_condition=true&jag=true&jira.create.linked.issue=true&locale=en&slack-enabled=true&whisper-enabled=true","startTime":1270.1999998092651,"connectEnd":1270.1999998092651,"connectStart":1270.1999998092651,"domainLookupEnd":1270.1999998092651,"domainLookupStart":1270.1999998092651,"fetchStart":1270.1999998092651,"redirectEnd":0,"redirectStart":0,"requestStart":1270.1999998092651,"responseEnd":1549.5,"responseStart":1549.5,"secureConnectionStart":1270.1999998092651},{"duration":282.09999990463257,"initiatorType":"script","name":"https://www.google-analytics.com/analytics.js","startTime":1331.4000000953674,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":1331.4000000953674,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":1613.5,"responseStart":0,"secureConnectionStart":0}],"fetchStart":0,"domainLookupStart":0,"domainLookupEnd":0,"connectStart":0,"connectEnd":0,"requestStart":231,"responseStart":400,"responseEnd":415,"domLoading":403,"domInteractive":1632,"domContentLoadedEventStart":1632,"domContentLoadedEventEnd":1686,"domComplete":3497,"loadEventStart":3497,"loadEventEnd":3499,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[{"name":"bigPipe.sidebar-id.start","time":1614.4000000953674},{"name":"bigPipe.sidebar-id.end","time":1615.1999998092651},{"name":"bigPipe.activity-panel-pipe-id.start","time":1615.2999997138977},{"name":"bigPipe.activity-panel-pipe-id.end","time":1618},{"name":"activityTabFullyLoaded","time":1700.9000000953674}],"measures":[],"correlationId":"f4ddbd84643a61","effectiveType":"4g","downlink":10,"rtt":0,"serverDuration":94,"dbReadsTimeInMs":10,"dbConnsTimeInMs":19,"applicationHash":"9d11dbea5f4be3d4cc21f03a88dd11d8c8687422","experiments":[]}}