http://askmonty.org/buildbot/builders/kvm-deb-jessie-x86/builds/1864
sys_vars.log_slow_admin_statements_func 'xtradb' w1 [ fail ]
|
Test ended at 2017-03-01 12:17:44
|
|
CURRENT_TEST: sys_vars.log_slow_admin_statements_func
|
mysqltest: At line 50: query 'DROP TABLE log_slow_admin_statements' failed: 2013: Lost connection to MySQL server during query
|
|
The result from queries just before the failure was:
|
< snip >
|
CREATE PROCEDURE add_rows()
|
BEGIN
|
DECLARE count INT;
|
SET count = 1;
|
INSERT INTO log_slow_admin_statements(j) values (REPEAT('A', 255));
|
WHILE count <= 15 DO
|
INSERT INTO log_slow_admin_statements(j) SELECT j FROM log_slow_admin_statements;
|
SET count = count + 1;
|
END WHILE;
|
END
|
$
|
CALL add_rows();
|
OPTIMIZE TABLE log_slow_admin_statements;
|
Table Op Msg_type Msg_text
|
test.log_slow_admin_statements optimize note Table does not support optimize, doing recreate + analyze instead
|
test.log_slow_admin_statements optimize status OK
|
CHECK TABLE log_slow_admin_statements EXTENDED;
|
Table Op Msg_type Msg_text
|
test.log_slow_admin_statements check status OK
|
DROP TABLE log_slow_admin_statements;
|
|
More results from queries before failure can be found in /dev/shm/var/1/log/log_slow_admin_statements_func.log
|
|
|
Server [mysqld.1 - pid: 20449, winpid: 20449, exit: 256] failed during test run
|
Server log from this test:
|
----------SERVER LOG START-----------
|
2017-03-01 12:17:38 3054567232 [Note] InnoDB: Online DDL : Start
|
2017-03-01 12:17:38 3054567232 [Note] InnoDB: Online DDL : Start reading clustered index of the table and create temporary files
|
2017-03-01 12:17:38 3054567232 [Note] InnoDB: Online DDL : End of reading clustered index of the table and create temporary files
|
2017-03-01 12:17:38 3054567232 [Note] InnoDB: Online DDL : Completed
|
2017-03-01 12:17:42 3054567232 [Note] InnoDB: Online DDL : Start
|
2017-03-01 12:17:42 3054567232 [Note] InnoDB: Online DDL : Start reading clustered index of the table and create temporary files
|
2017-03-01 12:17:42 3054567232 [Note] InnoDB: Online DDL : End of reading clustered index of the table and create temporary files
|
2017-03-01 12:17:42 3054567232 [Note] InnoDB: Online DDL : Start merge-sorting index `PRIMARY` (1 / 1), estimated cost : 20.0000
|
2017-03-01 12:17:42 3054567232 [Note] InnoDB: Online DDL : merge-sorting has estimated 9 runs
|
2017-03-01 12:17:42 3054567232 [Note] InnoDB: Online DDL : End of merge-sorting index `PRIMARY` (1 / 1)
|
2017-03-01 12:17:42 3054567232 [Note] InnoDB: Online DDL : Start building index `PRIMARY` (1 / 1), estimated cost : 30.0000
|
2017-03-01 12:17:43 3054567232 [Note] InnoDB: Online DDL : End of building index `PRIMARY` (1 / 1)
|
2017-03-01 12:17:43 3054567232 [Note] InnoDB: Online DDL : Completed
|
170301 12:17:43 [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 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.1.22-MariaDB-1~jessie
|
key_buffer_size=1048576
|
read_buffer_size=131072
|
max_used_connections=3
|
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 = 61771 K bytes of memory
|
Hope that's ok; if not, decrease some variables in the equation.
|
|
Thread pointer: 0x0
|
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 = 0x0 thread_stack 0x48400
|
/usr/sbin/mysqld(my_print_stacktrace+0x28)[0xb72c6b88]
|
/usr/sbin/mysqld(handle_fatal_signal+0x2f7)[0xb6dde9a7]
|
linux-gate.so.1(__kernel_sigreturn+0x0)[0xb69a2d18]
|
/usr/sbin/mysqld(+0x7c7eb7)[0xb718deb7]
|
/usr/sbin/mysqld(+0x7cd108)[0xb7193108]
|
/usr/sbin/mysqld(+0x8236e3)[0xb71e96e3]
|
/usr/sbin/mysqld(+0x758e64)[0xb711ee64]
|
/lib/i386-linux-gnu/i686/cmov/libpthread.so.0(+0x6ecb)[0xb6983ecb]
|
/lib/i386-linux-gnu/i686/cmov/libc.so.6(clone+0x5e)[0xb642fd0e]
|
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.
|
Writing a core file
|
----------SERVER LOG END-------------
|
|
|
- saving '/dev/shm/var/1/log/sys_vars.log_slow_admin_statements_func-xtradb/' to '/dev/shm/var/log/sys_vars.log_slow_admin_statements_func-xtradb/'
|
|
Retrying test sys_vars.log_slow_admin_statements_func, attempt(2/3)...
|
|
worker[1] > Restart - not started
|
{"report":{"fcp":877.0999999046326,"ttfb":132,"pageVisibility":"visible","entityId":60530,"key":"jira.project.issue.view-issue","isInitial":true,"threshold":1000,"elementTimings":{},"userDeviceMemory":8,"userDeviceProcessors":64,"apdex":1,"journeyId":"71620b81-fd25-4dcd-8a68-239026071ba3","navigationType":0,"readyForUser":950.0999999046326,"redirectCount":0,"resourceLoadedEnd":1160.5,"resourceLoadedStart":137.70000004768372,"resourceTiming":[{"duration":305.09999990463257,"initiatorType":"link","name":"https://jira.mariadb.org/s/2c21342762a6a02add1c328bed317ffd-CDN/lu2bu7/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/css/_super/batch.css","startTime":137.70000004768372,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":137.70000004768372,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":442.7999999523163,"responseStart":0,"secureConnectionStart":0},{"duration":304.90000009536743,"initiatorType":"link","name":"https://jira.mariadb.org/s/7ebd35e77e471bc30ff0eba799ebc151-CDN/lu2bu7/820016/12ta74/8679b4946efa1a0bb029a3a22206fb5d/_/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","startTime":138,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":138,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":442.90000009536743,"responseStart":0,"secureConnectionStart":0},{"duration":315.2999999523163,"initiatorType":"script","name":"https://jira.mariadb.org/s/fbf975c0cce4b1abf04784eeae9ba1f4-CDN/lu2bu7/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/js/_super/batch.js?locale=en","startTime":138,"connectEnd":138,"connectStart":138,"domainLookupEnd":138,"domainLookupStart":138,"fetchStart":138,"redirectEnd":0,"redirectStart":0,"requestStart":138,"responseEnd":453.2999999523163,"responseStart":453.2999999523163,"secureConnectionStart":138},{"duration":340.2000000476837,"initiatorType":"script","name":"https://jira.mariadb.org/s/099b33461394b8015fc36c0a4b96e19f-CDN/lu2bu7/820016/12ta74/8679b4946efa1a0bb029a3a22206fb5d/_/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","startTime":138.09999990463257,"connectEnd":138.09999990463257,"connectStart":138.09999990463257,"domainLookupEnd":138.09999990463257,"domainLookupStart":138.09999990463257,"fetchStart":138.09999990463257,"redirectEnd":0,"redirectStart":0,"requestStart":138.09999990463257,"responseEnd":478.2999999523163,"responseStart":478.2999999523163,"secureConnectionStart":138.09999990463257},{"duration":343.7000000476837,"initiatorType":"script","name":"https://jira.mariadb.org/s/94c15bff32baef80f4096a08aceae8bc-CDN/lu2bu7/820016/12ta74/c92c0caa9a024ae85b0ebdbed7fb4bd7/_/download/contextbatch/js/atl.global,-_super/batch.js?locale=en","startTime":138.29999995231628,"connectEnd":138.29999995231628,"connectStart":138.29999995231628,"domainLookupEnd":138.29999995231628,"domainLookupStart":138.29999995231628,"fetchStart":138.29999995231628,"redirectEnd":0,"redirectStart":0,"requestStart":138.29999995231628,"responseEnd":482,"responseStart":482,"secureConnectionStart":138.29999995231628},{"duration":344,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2bu7/820016/12ta74/1.0/_/download/batch/jira.webresources:calendar-en/jira.webresources:calendar-en.js","startTime":138.40000009536743,"connectEnd":138.40000009536743,"connectStart":138.40000009536743,"domainLookupEnd":138.40000009536743,"domainLookupStart":138.40000009536743,"fetchStart":138.40000009536743,"redirectEnd":0,"redirectStart":0,"requestStart":138.40000009536743,"responseEnd":482.40000009536743,"responseStart":482.40000009536743,"secureConnectionStart":138.40000009536743},{"duration":344.2000000476837,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2bu7/820016/12ta74/1.0/_/download/batch/jira.webresources:calendar-localisation-moment/jira.webresources:calendar-localisation-moment.js","startTime":138.5,"connectEnd":138.5,"connectStart":138.5,"domainLookupEnd":138.5,"domainLookupStart":138.5,"fetchStart":138.5,"redirectEnd":0,"redirectStart":0,"requestStart":138.5,"responseEnd":482.7000000476837,"responseStart":482.7000000476837,"secureConnectionStart":138.5},{"duration":344.7000000476837,"initiatorType":"link","name":"https://jira.mariadb.org/s/b04b06a02d1959df322d9cded3aeecc1-CDN/lu2bu7/820016/12ta74/a2ff6aa845ffc9a1d22fe23d9ee791fc/_/download/contextbatch/css/jira.global.look-and-feel,-_super/batch.css","startTime":138.59999990463257,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":138.59999990463257,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":483.2999999523163,"responseStart":0,"secureConnectionStart":0},{"duration":344.2999999523163,"initiatorType":"script","name":"https://jira.mariadb.org/rest/api/1.0/shortcuts/820016/47140b6e0a9bc2e4913da06536125810/shortcuts.js?context=issuenavigation&context=issueaction","startTime":138.79999995231628,"connectEnd":138.79999995231628,"connectStart":138.79999995231628,"domainLookupEnd":138.79999995231628,"domainLookupStart":138.79999995231628,"fetchStart":138.79999995231628,"redirectEnd":0,"redirectStart":0,"requestStart":138.79999995231628,"responseEnd":483.09999990463257,"responseStart":483.09999990463257,"secureConnectionStart":138.79999995231628},{"duration":344.7999999523163,"initiatorType":"link","name":"https://jira.mariadb.org/s/3ac36323ba5e4eb0af2aa7ac7211b4bb-CDN/lu2bu7/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":138.90000009536743,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":138.90000009536743,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":483.7000000476837,"responseStart":0,"secureConnectionStart":0},{"duration":344.60000014305115,"initiatorType":"script","name":"https://jira.mariadb.org/s/3339d87fa2538a859872f2df449bf8d0-CDN/lu2bu7/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":139.09999990463257,"connectEnd":139.09999990463257,"connectStart":139.09999990463257,"domainLookupEnd":139.09999990463257,"domainLookupStart":139.09999990463257,"fetchStart":139.09999990463257,"redirectEnd":0,"redirectStart":0,"requestStart":139.09999990463257,"responseEnd":483.7000000476837,"responseStart":483.59999990463257,"secureConnectionStart":139.09999990463257},{"duration":1019.7999999523163,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2bu7/820016/12ta74/1.0/_/download/batch/jira.webresources:bigpipe-js/jira.webresources:bigpipe-js.js","startTime":140,"connectEnd":140,"connectStart":140,"domainLookupEnd":140,"domainLookupStart":140,"fetchStart":140,"redirectEnd":0,"redirectStart":0,"requestStart":140,"responseEnd":1159.7999999523163,"responseStart":1159.7000000476837,"secureConnectionStart":140},{"duration":1020.5,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2bu7/820016/12ta74/1.0/_/download/batch/jira.webresources:bigpipe-init/jira.webresources:bigpipe-init.js","startTime":140,"connectEnd":140,"connectStart":140,"domainLookupEnd":140,"domainLookupStart":140,"fetchStart":140,"redirectEnd":0,"redirectStart":0,"requestStart":140,"responseEnd":1160.5,"responseStart":1160.5,"secureConnectionStart":140},{"duration":339.59999990463257,"initiatorType":"xmlhttprequest","name":"https://jira.mariadb.org/rest/webResources/1.0/resources","startTime":682.4000000953674,"connectEnd":682.4000000953674,"connectStart":682.4000000953674,"domainLookupEnd":682.4000000953674,"domainLookupStart":682.4000000953674,"fetchStart":682.4000000953674,"redirectEnd":0,"redirectStart":0,"requestStart":682.4000000953674,"responseEnd":1022,"responseStart":1022,"secureConnectionStart":682.4000000953674},{"duration":342.5,"initiatorType":"script","name":"https://www.google-analytics.com/analytics.js","startTime":856.2999999523163,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":856.2999999523163,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":1198.7999999523163,"responseStart":0,"secureConnectionStart":0}],"fetchStart":0,"domainLookupStart":0,"domainLookupEnd":0,"connectStart":0,"connectEnd":0,"requestStart":2,"responseStart":132,"responseEnd":133,"domLoading":135,"domInteractive":1177,"domContentLoadedEventStart":1177,"domContentLoadedEventEnd":1213,"domComplete":2013,"loadEventStart":2013,"loadEventEnd":2014,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[{"name":"bigPipe.sidebar-id.start","time":1166.2000000476837},{"name":"bigPipe.sidebar-id.end","time":1167.0999999046326},{"name":"bigPipe.activity-panel-pipe-id.start","time":1167.2000000476837},{"name":"bigPipe.activity-panel-pipe-id.end","time":1169.5},{"name":"activityTabFullyLoaded","time":1224.7000000476837}],"measures":[],"correlationId":"499baf26cd3444","effectiveType":"4g","downlink":10,"rtt":0,"serverDuration":67,"dbReadsTimeInMs":11,"dbConnsTimeInMs":18,"applicationHash":"9d11dbea5f4be3d4cc21f03a88dd11d8c8687422","experiments":[]}}