When I use .sh test from https://bugs.launchpad.net/percona-xtrabackup/+bug/1399471 and ignore_builtin_innodb
plugin_load_add=ha_innodb
in my.cnf - I get reliable crash :
InnoDB: Apply batch completed
|
2017-02-08 09:34:38 7f4f19145780 InnoDB: Assertion failure in thread 139977699907456 in file pars0pars.cc line 865
|
InnoDB: Failing assertion: sym_node->table != NULL
|
InnoDB: We intentionally generate a memory trap.
|
InnoDB: Submit a detailed bug report to http://bugs.mysql.com.
|
InnoDB: If you get repeated assertion failures or crashes, even
|
InnoDB: immediately after the mysqld startup, there may be
|
InnoDB: corruption in the InnoDB tablespace. Please refer to
|
InnoDB: http://dev.mysql.com/doc/refman/5.6/en/forcing-innodb-recovery.html
|
InnoDB: about forcing recovery.
|
170208 9:34:38 [ERROR] mysqld got signal 6 ;
|
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.21-MariaDB
|
key_buffer_size=0
|
read_buffer_size=131072
|
max_used_connections=0
|
max_threads=1
|
thread_count=0
|
It is possible that mysqld could use up to
|
key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 5297 K bytes of memory
|
Hope that's ok; if not, decrease some variables in the equation.
|
|
Thread pointer: 0x0x0
|
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
|
/farm/m0-bb-10.1-wlad-xtrabackup/build/extra/xtrabackup//xtrabackup(my_print_stacktrace+0x29)[0x55b98f6df519]
|
/farm/m0-bb-10.1-wlad-xtrabackup/build/extra/xtrabackup//xtrabackup(handle_fatal_signal+0x2f5)[0x55b98f2c9395]
|
/lib/x86_64-linux-gnu/libpthread.so.0(+0x11390)[0x7f4f18d23390]
|
/lib/x86_64-linux-gnu/libc.so.6(gsignal+0x38)[0x7f4f171b7428]
|
/lib/x86_64-linux-gnu/libc.so.6(abort+0x16a)[0x7f4f171b902a]
|
mysys/stacktrace.c:268(my_print_stacktrace)[0x55b98f612ca6]
|
pars/pars0pars.cc:1282(pars_update_statement(upd_node_t*, sym_node_t*, void*))[0x55b98f614536]
|
xtradb/pars0grm.y:443(yyparse())[0x55b98f6a9bdb]
|
pars/pars0pars.cc:2247(pars_sql(pars_info_t*, char const*))[0x55b98f615be0]
|
que/que0que.cc:1260(que_eval_sql(pars_info_t*, char const*, unsigned long, trx_t*))[0x55b98f619163]
|
row/row0mysql.cc:4957(row_drop_table_for_mysql(char const*, trx_t*, bool, unsigned long, bool))[0x55b98f63e9c9]
|
row/row0mysql.cc:5211(row_mysql_drop_temp_tables())[0x55b98f6402b5]
|
log/log0recv.cc:3611(recv_recovery_rollback_active())[0x55b98f5efb3e]
|
srv/srv0start.cc:2715(innobase_start_or_create_for_mysql())[0x55b98f66a37c]
|
xtrabackup/xtrabackup.cc:1847(innodb_init())[0x55b98f08263a]
|
xtrabackup/xtrabackup.cc:6369(xtrabackup_prepare_func)[0x55b98f08edce]
|
/lib/x86_64-linux-gnu/libc.so.6(__libc_start_main+0xf0)[0x7f4f171a2830]
|
/farm/m0-bb-10.1-wlad-xtrabackup/build/extra/xtrabackup//xtrabackup(_start+0x29)[0x55b98f0a2959]
|
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.
|
inc/common.sh: line 102: 2296 Aborted "$@"
|
I couldn't reproduce the same with manual testing nor with 'identical' mtr tests (which i run with "-mysqld=ignore_builtin_innodb --mysqld=-plugin_load_add=ha_innodb" ) like below:
START TRANSACTION;
|
CREATE TEMPORARY TABLE t(id INT) ENGINE=InnoDB;
|
let $targetdir=$MYSQLTEST_VARDIR/tmp/backup;
|
exec $XTRABACKUP --defaults-file=$MYSQLTEST_VARDIR/my.cnf --backup --target-dir=$targetdir;
|
exec $XTRABACKUP --defaults-file=$MYSQLTEST_VARDIR/my.cnf --prepare --target-dir=$targetdir;
|
Thus I am still filing this bug to let developer review if XtraDB patches from https://bugs.launchpad.net/percona-xtrabackup/+bug/1399471 should be applied to ha_innodb as well.
{"report":{"fcp":1080.1999998092651,"ttfb":246.19999980926514,"pageVisibility":"visible","entityId":60168,"key":"jira.project.issue.view-issue","isInitial":true,"threshold":1000,"elementTimings":{},"userDeviceMemory":8,"userDeviceProcessors":32,"apdex":0.5,"journeyId":"71f3b2da-7c7f-4371-bdbc-321a03eed43a","navigationType":0,"readyForUser":1194.5,"redirectCount":0,"resourceLoadedEnd":1105.5999999046326,"resourceLoadedStart":342.2999997138977,"resourceTiming":[{"duration":23.200000286102295,"initiatorType":"link","name":"https://jira.mariadb.org/s/2c21342762a6a02add1c328bed317ffd-CDN/lu2cib/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/css/_super/batch.css","startTime":342.2999997138977,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":342.2999997138977,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":365.5,"responseStart":0,"secureConnectionStart":0},{"duration":23.199999809265137,"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":342.59999990463257,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":342.59999990463257,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":365.7999997138977,"responseStart":0,"secureConnectionStart":0},{"duration":97.5,"initiatorType":"script","name":"https://jira.mariadb.org/s/0917945aaa57108d00c5076fea35e069-CDN/lu2cib/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/js/_super/batch.js?locale=en","startTime":342.7999997138977,"connectEnd":342.7999997138977,"connectStart":342.7999997138977,"domainLookupEnd":342.7999997138977,"domainLookupStart":342.7999997138977,"fetchStart":342.7999997138977,"redirectEnd":0,"redirectStart":0,"requestStart":342.7999997138977,"responseEnd":440.2999997138977,"responseStart":440.19999980926514,"secureConnectionStart":342.7999997138977},{"duration":199.19999980926514,"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":343,"connectEnd":343,"connectStart":343,"domainLookupEnd":343,"domainLookupStart":343,"fetchStart":343,"redirectEnd":0,"redirectStart":0,"requestStart":343,"responseEnd":542.1999998092651,"responseStart":542.1999998092651,"secureConnectionStart":343},{"duration":254.69999980926514,"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":343.09999990463257,"connectEnd":343.09999990463257,"connectStart":343.09999990463257,"domainLookupEnd":343.09999990463257,"domainLookupStart":343.09999990463257,"fetchStart":343.09999990463257,"redirectEnd":0,"redirectStart":0,"requestStart":343.09999990463257,"responseEnd":597.7999997138977,"responseStart":597.7999997138977,"secureConnectionStart":343.09999990463257},{"duration":254.80000019073486,"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":343.2999997138977,"connectEnd":343.2999997138977,"connectStart":343.2999997138977,"domainLookupEnd":343.2999997138977,"domainLookupStart":343.2999997138977,"fetchStart":343.2999997138977,"redirectEnd":0,"redirectStart":0,"requestStart":343.2999997138977,"responseEnd":598.0999999046326,"responseStart":598.0999999046326,"secureConnectionStart":343.2999997138977},{"duration":255.59999990463257,"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":343.5,"connectEnd":343.5,"connectStart":343.5,"domainLookupEnd":343.5,"domainLookupStart":343.5,"fetchStart":343.5,"redirectEnd":0,"redirectStart":0,"requestStart":343.5,"responseEnd":599.0999999046326,"responseStart":599.0999999046326,"secureConnectionStart":343.5},{"duration":290,"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":343.69999980926514,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":343.69999980926514,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":633.6999998092651,"responseStart":0,"secureConnectionStart":0},{"duration":256.1000003814697,"initiatorType":"script","name":"https://jira.mariadb.org/rest/api/1.0/shortcuts/820016/47140b6e0a9bc2e4913da06536125810/shortcuts.js?context=issuenavigation&context=issueaction","startTime":343.7999997138977,"connectEnd":343.7999997138977,"connectStart":343.7999997138977,"domainLookupEnd":343.7999997138977,"domainLookupStart":343.7999997138977,"fetchStart":343.7999997138977,"redirectEnd":0,"redirectStart":0,"requestStart":343.7999997138977,"responseEnd":599.9000000953674,"responseStart":599.9000000953674,"secureConnectionStart":343.7999997138977},{"duration":290.09999990463257,"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":343.90000009536743,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":343.90000009536743,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":634,"responseStart":0,"secureConnectionStart":0},{"duration":278.09999990463257,"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":344.5,"connectEnd":344.5,"connectStart":344.5,"domainLookupEnd":344.5,"domainLookupStart":344.5,"fetchStart":344.5,"redirectEnd":0,"redirectStart":0,"requestStart":344.5,"responseEnd":622.5999999046326,"responseStart":622.5999999046326,"secureConnectionStart":344.5},{"duration":320.09999990463257,"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":345.59999990463257,"connectEnd":345.59999990463257,"connectStart":345.59999990463257,"domainLookupEnd":345.59999990463257,"domainLookupStart":345.59999990463257,"fetchStart":345.59999990463257,"redirectEnd":0,"redirectStart":0,"requestStart":345.59999990463257,"responseEnd":665.6999998092651,"responseStart":665.6999998092651,"secureConnectionStart":345.59999990463257},{"duration":413.59999990463257,"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":345.69999980926514,"connectEnd":345.69999980926514,"connectStart":345.69999980926514,"domainLookupEnd":345.69999980926514,"domainLookupStart":345.69999980926514,"fetchStart":345.69999980926514,"redirectEnd":0,"redirectStart":0,"requestStart":345.69999980926514,"responseEnd":759.2999997138977,"responseStart":759.2999997138977,"secureConnectionStart":345.69999980926514},{"duration":84.59999990463257,"initiatorType":"xmlhttprequest","name":"https://jira.mariadb.org/rest/webResources/1.0/resources","startTime":706.6999998092651,"connectEnd":706.6999998092651,"connectStart":706.6999998092651,"domainLookupEnd":706.6999998092651,"domainLookupStart":706.6999998092651,"fetchStart":706.6999998092651,"redirectEnd":0,"redirectStart":0,"requestStart":706.6999998092651,"responseEnd":791.2999997138977,"responseStart":791.2999997138977,"secureConnectionStart":706.6999998092651},{"duration":140.80000019073486,"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":964.7999997138977,"connectEnd":964.7999997138977,"connectStart":964.7999997138977,"domainLookupEnd":964.7999997138977,"domainLookupStart":964.7999997138977,"fetchStart":964.7999997138977,"redirectEnd":0,"redirectStart":0,"requestStart":964.7999997138977,"responseEnd":1105.5999999046326,"responseStart":1105.5999999046326,"secureConnectionStart":964.7999997138977},{"duration":209,"initiatorType":"script","name":"https://www.google-analytics.com/analytics.js","startTime":1055.5999999046326,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":1055.5999999046326,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":1264.5999999046326,"responseStart":0,"secureConnectionStart":0},{"duration":132.09999990463257,"initiatorType":"iframe","name":"https://jira.mariadb.org/plugins/servlet/gadgets/ifr?container=atlassian&mid=0&country=&lang=en&view=issuetab&view-params=%7B%22writable%22%3A%22false%22%7D&st=atlassian%3Azng6iScYsqvPrB2Fx8j26lnROeEklpC4UNnLn8mqkKvWhFKueiSB0YJkalRobyeLJ4R8YB0PCaWMbAHorApTs3Xi3NInAthwyAUX9UylOrJ1H4%2FcN%2BVZjcihJvb%2B8wN%2FBdjYR2vl7GP1sIAvIKU4i6JyXiWiGHJGgjR4FfOvoxmHSERElz8dah0UlZp0I6non5VmRyN3q07nUWRZHXKI4py%2BeQbOf5QrBQfMiKtCdvzYg56eT7E5Biu%2FfAcbSDVLXgWjkw%3D%3D&up_isConfigured=true&up_isReallyConfigured=true&up_title=Activity+Stream&up_titleRequired=false&up_numofentries=20&up_refresh=false&up_maxProviderLabelCharacters=50&up_rules=%7B%22providers%22%3A%5B%7B%22provider%22%3A%22streams%22%2C%22rules%22%3A%5B%7B%22provider%22%3A%22streams%22%2C%22rule%22%3A%22issue-key%22%2C%22type%22%3A%22string%22%2C%22value%22%3A%22MDEV-12023%22%2C%22operator%22%3A%22is%22%7D%2C%7B%22provider%22%3A%22streams%22%2C%22rule%22%3A%22key%22%2C%22type%22%3A%22select%22%2C%22value%22%3A%5B%22MDEV%22%5D%2C%22operator%22%3A%22is%22%7D%5D%7D%5D%7D&up_renderingContext=view-issue&up_keys=&up_itemKeys=&up_username=&url=https%3A%2F%2Fjira.mariadb.org%2Frest%2Fgadgets%2F1.0%2Fg%2Fcom.atlassian.streams.streams-jira-plugin%2Fgadgets%2Factivitystream-gadget.xml&libs=auth-refresh#rpctoken=1101881436","startTime":1269.5999999046326,"connectEnd":1269.5999999046326,"connectStart":1269.5999999046326,"domainLookupEnd":1269.5999999046326,"domainLookupStart":1269.5999999046326,"fetchStart":1269.5999999046326,"redirectEnd":0,"redirectStart":0,"requestStart":1367,"responseEnd":1401.6999998092651,"responseStart":1399,"secureConnectionStart":1269.5999999046326},{"duration":44.40000009536743,"initiatorType":"xmlhttprequest","name":"https://jira.mariadb.org/rest/webResources/1.0/resources","startTime":1324,"connectEnd":1324,"connectStart":1324,"domainLookupEnd":1324,"domainLookupStart":1324,"fetchStart":1324,"redirectEnd":0,"redirectStart":0,"requestStart":1324,"responseEnd":1368.4000000953674,"responseStart":1368.4000000953674,"secureConnectionStart":1324}],"fetchStart":0,"domainLookupStart":0,"domainLookupEnd":0,"connectStart":0,"connectEnd":0,"requestStart":3,"responseStart":246,"responseEnd":336,"domLoading":339,"domInteractive":1325,"domContentLoadedEventStart":1325,"domContentLoadedEventEnd":1406,"domComplete":1760,"loadEventStart":1760,"loadEventEnd":1760,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[{"name":"bigPipe.sidebar-id.start","time":1266.4000000953674},{"name":"bigPipe.sidebar-id.end","time":1267.1999998092651},{"name":"bigPipe.activity-panel-pipe-id.start","time":1267.2999997138977},{"name":"bigPipe.activity-panel-pipe-id.end","time":1269.7999997138977},{"name":"activityTabFullyLoaded","time":1411.7999997138977}],"measures":[],"correlationId":"4c7e49d490bedc","effectiveType":"4g","downlink":9.3,"rtt":0,"serverDuration":171,"dbReadsTimeInMs":14,"dbConnsTimeInMs":23,"applicationHash":"9d11dbea5f4be3d4cc21f03a88dd11d8c8687422","experiments":[]}}