Type:
Bug
Priority:
Major
Resolution:
Fixed
Affects Version/s:
10.3(EOL) , 10.4(EOL) , 10.5 , 10.6 , 10.7(EOL) , 10.8(EOL) , 10.9(EOL) , 10.10(EOL) , 10.11
The test case is non-deterministic. It fails every time for me, but try to --repeat --force-restart if it doesn't fail for you right away.
--source include/have_innodb.inc
--source include/have_sequence.inc
CREATE TABLE t (f longtext, KEY (f(1024))) ENGINE=InnoDB;
INSERT INTO t SELECT REPEAT( 'a' ,100000) FROM seq_1_to_500;
--connect (con1,localhost,root,,test)
--send
ALTER TABLE t FORCE ;
--connection default
UPDATE t SET f = NULL LIMIT 1;
UPDATE t SET f = REPEAT( 'b' ,1000000) LIMIT 1;
--connection con1
--reap
DROP TABLE t;
--disconnect con1
10.3 01ac7455
==2740416==ERROR: LeakSanitizer: detected memory leaks
Direct leak of 12 byte(s) in 1 object(s) allocated from:
#0 0x7fcf72597e8f in __interceptor_malloc ../../../../src/libsanitizer/asan/asan_malloc_linux.cpp:145
#1 0x555e07787ea8 in rec_copy_prefix_to_buf(unsigned char const*, dict_index_t const*, unsigned long, unsigned char**, unsigned long*) /home/jenkins/workspace/sandbox-elenst/Nightly-Build-CS/src/storage/innobase/rem/rem0rec.cc:2002
#2 0x555e07a9bf07 in btr_pcur_store_position(btr_pcur_t*, mtr_t*) /home/jenkins/workspace/sandbox-elenst/Nightly-Build-CS/src/storage/innobase/btr/btr0pcur.cc:200
#3 0x555e07a90c78 in btr_blob_log_check_t::check() /home/jenkins/workspace/sandbox-elenst/Nightly-Build-CS/src/storage/innobase/btr/btr0cur.cc:7171
#4 0x555e07a899ae in btr_store_big_rec_extern_fields(btr_pcur_t*, unsigned short*, big_rec_t const*, mtr_t*, blob_op) /home/jenkins/workspace/sandbox-elenst/Nightly-Build-CS/src/storage/innobase/btr/btr0cur.cc:7372
#5 0x555e07861d80 in row_log_table_apply_update /home/jenkins/workspace/sandbox-elenst/Nightly-Build-CS/src/storage/innobase/row/row0log.cc:2328
#6 0x555e078647c7 in row_log_table_apply_op /home/jenkins/workspace/sandbox-elenst/Nightly-Build-CS/src/storage/innobase/row/row0log.cc:2671
#7 0x555e07868c05 in row_log_table_apply_ops /home/jenkins/workspace/sandbox-elenst/Nightly-Build-CS/src/storage/innobase/row/row0log.cc:3041
#8 0x555e07869a79 in row_log_table_apply(que_thr_t*, dict_table_t*, TABLE*, ut_stage_alter_t*, dict_table_t*) /home/jenkins/workspace/sandbox-elenst/Nightly-Build-CS/src/storage/innobase/row/row0log.cc:3150
#9 0x555e075a9758 in ha_innobase::inplace_alter_table(TABLE*, Alter_inplace_info*) /home/jenkins/workspace/sandbox-elenst/Nightly-Build-CS/src/storage/innobase/handler/handler0alter.cc:7223
#10 0x555e06a94373 in handler::ha_inplace_alter_table(TABLE*, Alter_inplace_info*) (/mnt8t/bld/10.3-nightly/bin/mysqld+0x12a7373)
#11 0x555e06a77116 in mysql_inplace_alter_table /home/jenkins/workspace/sandbox-elenst/Nightly-Build-CS/src/sql/sql_table.cc:7774
#12 0x555e06a88631 in mysql_alter_table(THD*, st_mysql_const_lex_string const*, st_mysql_const_lex_string const*, HA_CREATE_INFO*, TABLE_LIST*, Alter_info*, unsigned int, st_order*, bool) /home/jenkins/workspace/sandbox-elenst/Nightly-Build-CS/src/sql/sql_table.cc:10159
#13 0x555e06bf1905 in Sql_cmd_alter_table::execute(THD*) /home/jenkins/workspace/sandbox-elenst/Nightly-Build-CS/src/sql/sql_alter.cc:512
#14 0x555e0683d843 in mysql_execute_command(THD*) /home/jenkins/workspace/sandbox-elenst/Nightly-Build-CS/src/sql/sql_parse.cc:6076
#15 0x555e06849675 in mysql_parse(THD*, char*, unsigned int, Parser_state*, bool, bool) /home/jenkins/workspace/sandbox-elenst/Nightly-Build-CS/src/sql/sql_parse.cc:7855
#16 0x555e06820cc3 in dispatch_command(enum_server_command, THD*, char*, unsigned int, bool, bool) /home/jenkins/workspace/sandbox-elenst/Nightly-Build-CS/src/sql/sql_parse.cc:1852
#17 0x555e0681d87b in do_command(THD*) /home/jenkins/workspace/sandbox-elenst/Nightly-Build-CS/src/sql/sql_parse.cc:1398
#18 0x555e06be11ef in do_handle_one_connection(CONNECT*) /home/jenkins/workspace/sandbox-elenst/Nightly-Build-CS/src/sql/sql_connect.cc:1403
#19 0x555e06be0aeb in handle_one_connection /home/jenkins/workspace/sandbox-elenst/Nightly-Build-CS/src/sql/sql_connect.cc:1308
#20 0x555e0818e244 in pfs_spawn_thread /home/jenkins/workspace/sandbox-elenst/Nightly-Build-CS/src/storage/perfschema/pfs.cc:1869
#21 0x7fcf71c91ea6 in start_thread nptl/pthread_create.c:477
SUMMARY: AddressSanitizer: 12 byte(s) leaked in 1 allocation(s).
Reproducible on all of 10.3-10.11 (and EOL-ed 10.2 too).
relates to
MDEV-29600
Memory leak in row_log_table_apply_update(), in UPDATE involving BLOB, during online table rebuild
Closed
mentioned in
Page Failed to load
Page Failed to load
Page Failed to load
Page Failed to load
Page Loading...
Page Loading...
Page Loading...
Page Loading...
Page Loading...
Page Loading...
Page Loading...
Page Loading...
Page Loading...
Page Loading...
Show 10 more links (10 mentioned in)
{"report":{"fcp":1533.4000000953674,"ttfb":668.7000000476837,"pageVisibility":"visible","entityId":116567,"key":"jira.project.issue.view-issue","isInitial":true,"threshold":1000,"elementTimings":{},"userDeviceMemory":8,"userDeviceProcessors":64,"apdex":0.5,"journeyId":"78e53aeb-d39e-4322-be92-15f29112720f","navigationType":0,"readyForUser":1618.9000000953674,"redirectCount":0,"resourceLoadedEnd":1780.9000000953674,"resourceLoadedStart":674.2000000476837,"resourceTiming":[{"duration":315.89999997615814,"initiatorType":"link","name":"https://jira.mariadb.org/s/2c21342762a6a02add1c328bed317ffd-CDN/lu2cib/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/css/_super/batch.css","startTime":674.2000000476837,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":674.2000000476837,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":990.1000000238419,"responseStart":0,"secureConnectionStart":0},{"duration":315.8000000715256,"initiatorType":"link","name":"https://jira.mariadb.org/s/7ebd35e77e471bc30ff0eba799ebc151-CDN/lu2cib/820016/12ta74/2bf333562ca6724060a9d5f1535471f6/_/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":674.5,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":674.5,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":990.3000000715256,"responseStart":0,"secureConnectionStart":0},{"duration":343.39999997615814,"initiatorType":"script","name":"https://jira.mariadb.org/s/0917945aaa57108d00c5076fea35e069-CDN/lu2cib/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/js/_super/batch.js?locale=en","startTime":674.7000000476837,"connectEnd":674.7000000476837,"connectStart":674.7000000476837,"domainLookupEnd":674.7000000476837,"domainLookupStart":674.7000000476837,"fetchStart":674.7000000476837,"redirectEnd":0,"redirectStart":0,"requestStart":674.7000000476837,"responseEnd":1018.1000000238419,"responseStart":1018.1000000238419,"secureConnectionStart":674.7000000476837},{"duration":442.7999999523163,"initiatorType":"script","name":"https://jira.mariadb.org/s/2d8175ec2fa4c816e8023260bd8c1786-CDN/lu2cib/820016/12ta74/2bf333562ca6724060a9d5f1535471f6/_/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":674.9000000953674,"connectEnd":674.9000000953674,"connectStart":674.9000000953674,"domainLookupEnd":674.9000000953674,"domainLookupStart":674.9000000953674,"fetchStart":674.9000000953674,"redirectEnd":0,"redirectStart":0,"requestStart":674.9000000953674,"responseEnd":1117.7000000476837,"responseStart":1117.7000000476837,"secureConnectionStart":674.9000000953674},{"duration":446.90000009536743,"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":675,"connectEnd":675,"connectStart":675,"domainLookupEnd":675,"domainLookupStart":675,"fetchStart":675,"redirectEnd":0,"redirectStart":0,"requestStart":675,"responseEnd":1121.9000000953674,"responseStart":1121.9000000953674,"secureConnectionStart":675},{"duration":447.2999999523163,"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":675.2000000476837,"connectEnd":675.2000000476837,"connectStart":675.2000000476837,"domainLookupEnd":675.2000000476837,"domainLookupStart":675.2000000476837,"fetchStart":675.2000000476837,"redirectEnd":0,"redirectStart":0,"requestStart":675.2000000476837,"responseEnd":1122.5,"responseStart":1122.5,"secureConnectionStart":675.2000000476837},{"duration":447.6999999284744,"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":675.4000000953674,"connectEnd":675.4000000953674,"connectStart":675.4000000953674,"domainLookupEnd":675.4000000953674,"domainLookupStart":675.4000000953674,"fetchStart":675.4000000953674,"redirectEnd":0,"redirectStart":0,"requestStart":675.4000000953674,"responseEnd":1123.1000000238419,"responseStart":1123.1000000238419,"secureConnectionStart":675.4000000953674},{"duration":491.90000009536743,"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":675.5,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":675.5,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":1167.4000000953674,"responseStart":0,"secureConnectionStart":0},{"duration":448.5,"initiatorType":"script","name":"https://jira.mariadb.org/rest/api/1.0/shortcuts/820016/47140b6e0a9bc2e4913da06536125810/shortcuts.js?context=issuenavigation&context=issueaction","startTime":675.7000000476837,"connectEnd":675.7000000476837,"connectStart":675.7000000476837,"domainLookupEnd":675.7000000476837,"domainLookupStart":675.7000000476837,"fetchStart":675.7000000476837,"redirectEnd":0,"redirectStart":0,"requestStart":675.7000000476837,"responseEnd":1124.2000000476837,"responseStart":1124.2000000476837,"secureConnectionStart":675.7000000476837},{"duration":491.7999999523163,"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":675.9000000953674,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":675.9000000953674,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":1167.7000000476837,"responseStart":0,"secureConnectionStart":0},{"duration":449.3000000715256,"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":676.1000000238419,"connectEnd":676.1000000238419,"connectStart":676.1000000238419,"domainLookupEnd":676.1000000238419,"domainLookupStart":676.1000000238419,"fetchStart":676.1000000238419,"redirectEnd":0,"redirectStart":0,"requestStart":676.1000000238419,"responseEnd":1125.4000000953674,"responseStart":1125.4000000953674,"secureConnectionStart":676.1000000238419},{"duration":1093.8000000715256,"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":683.5,"connectEnd":683.5,"connectStart":683.5,"domainLookupEnd":683.5,"domainLookupStart":683.5,"fetchStart":683.5,"redirectEnd":0,"redirectStart":0,"requestStart":683.5,"responseEnd":1777.3000000715256,"responseStart":1777.3000000715256,"secureConnectionStart":683.5},{"duration":1092.1000000238419,"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":686.2000000476837,"connectEnd":686.2000000476837,"connectStart":686.2000000476837,"domainLookupEnd":686.2000000476837,"domainLookupStart":686.2000000476837,"fetchStart":686.2000000476837,"redirectEnd":0,"redirectStart":0,"requestStart":686.2000000476837,"responseEnd":1778.3000000715256,"responseStart":1778.3000000715256,"secureConnectionStart":686.2000000476837},{"duration":144.10000002384186,"initiatorType":"xmlhttprequest","name":"https://jira.mariadb.org/rest/webResources/1.0/resources","startTime":1179.6000000238419,"connectEnd":1179.6000000238419,"connectStart":1179.6000000238419,"domainLookupEnd":1179.6000000238419,"domainLookupStart":1179.6000000238419,"fetchStart":1179.6000000238419,"redirectEnd":0,"redirectStart":0,"requestStart":1179.6000000238419,"responseEnd":1323.7000000476837,"responseStart":1323.7000000476837,"secureConnectionStart":1179.6000000238419},{"duration":337,"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","startTime":1443.9000000953674,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":1443.9000000953674,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":1780.9000000953674,"responseStart":0,"secureConnectionStart":0}],"fetchStart":0,"domainLookupStart":0,"domainLookupEnd":0,"connectStart":0,"connectEnd":0,"requestStart":494,"responseStart":668,"responseEnd":686,"domLoading":672,"domInteractive":1798,"domContentLoadedEventStart":1798,"domContentLoadedEventEnd":1840,"domComplete":3400,"loadEventStart":3400,"loadEventEnd":3402,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[{"name":"bigPipe.sidebar-id.start","time":1781.6000000238419},{"name":"bigPipe.sidebar-id.end","time":1782.4000000953674},{"name":"bigPipe.activity-panel-pipe-id.start","time":1782.4000000953674},{"name":"bigPipe.activity-panel-pipe-id.end","time":1783.5},{"name":"activityTabFullyLoaded","time":1859}],"measures":[],"correlationId":"7b7e5b525d5edf","effectiveType":"4g","downlink":10,"rtt":0,"serverDuration":99,"dbReadsTimeInMs":11,"dbConnsTimeInMs":19,"applicationHash":"9d11dbea5f4be3d4cc21f03a88dd11d8c8687422","experiments":[]}}
Patch is in bb-10.3-
MDEV-29977