-
10.2.2-1, 10.2.2-2, 10.2.2-3, 5.5.51 & 10.2.2, 10.1.17-1
10.2 at commit 848d211c5c4df00b819cd84d7530cf7d29bb0524
build.log is the general build steps.
mtr.log is the exact from these gdb traces:
gdb /build/build/sql/mysqld /dev/shm/var_auto_hNUV/log/rpl.rpl_semi_sync_event-innodb_plugin,mix/mysqld.1/data/core
|
|
[Thread debugging using libthread_db enabled]
|
Using host libthread_db library "/lib/powerpc64le-linux-gnu/libthread_db.so.1".
|
Core was generated by `/build/build/sql/mysqld --defaults-group-suffix=.1 --defaults-file=/build/build'.
|
Program terminated with signal SIGABRT, Aborted.
|
#0 0x00003fff7dfc2e4c in __pthread_kill (threadid=<optimized out>, signo=<optimized out>) at ../sysdeps/unix/sysv/linux/pthread_kill.c:58
|
58 ../sysdeps/unix/sysv/linux/pthread_kill.c: No such file or directory.
|
[Current thread is 1 (Thread 0x3fff6d3fefb0 (LWP 26338))]
|
(gdb) bt
|
#0 0x00003fff7dfc2e4c in __pthread_kill (threadid=<optimized out>, signo=<optimized out>) at ../sysdeps/unix/sysv/linux/pthread_kill.c:58
|
#1 0x000000003b7a3664 in my_write_core (sig=<optimized out>) at /source/mysys/stacktrace.c:456
|
#2 0x000000003b0bc71c in handle_fatal_signal (sig=<optimized out>) at /source/sql/signal_handler.cc:272
|
#3 <signal handler called>
|
#4 0x00003fff7da4f27c in __GI_raise (sig=<optimized out>) at ../sysdeps/unix/sysv/linux/raise.c:54
|
#5 0x00003fff7da518f4 in __GI_abort () at abort.c:89
|
#6 0x00003fff762b6bac in mutex_exit_func (mutex=0x3fff763f54b8 <sync_thread_mutex>) at /source/storage/innobase/include/sync0sync.ic:160
|
#7 pfs_mutex_exit_func (mutex=0x3fff763f54b8 <sync_thread_mutex>) at /source/storage/innobase/include/sync0sync.ic:314
|
#8 sync_thread_reset_level (latch=0x3fff7cff7680) at /source/storage/innobase/sync/sync0sync.cc:1388
|
#9 0x00003fff761f5960 in mutex_exit_func (mutex=<optimized out>) at /source/storage/innobase/include/sync0sync.ic:165
|
#10 pfs_mutex_exit_func (mutex=<optimized out>) at /source/storage/innobase/include/sync0sync.ic:314
|
#11 que_run_threads_low (thr=0x3fff7ce59ac0) at /source/storage/innobase/que/que0que.cc:1164
|
#12 que_run_threads (thr=0x3fff7ce59ac0) at /source/storage/innobase/que/que0que.cc:1182
|
#13 0x00003fff762c44a8 in trx_purge (n_purge_threads=<optimized out>, batch_size=300, truncate=<optimized out>)
|
at /source/storage/innobase/trx/trx0purge.cc:1246
|
#14 0x00003fff762a5a28 in srv_do_purge (n_total_purged=<synthetic pointer>, n_threads=1) at /source/storage/innobase/srv/srv0srv.cc:2803
|
#15 srv_purge_coordinator_thread (arg=<optimized out>) at /source/storage/innobase/srv/srv0srv.cc:2978
|
#16 0x00003fff7dfb84a0 in start_thread (arg=0x3fff6d3fefb0) at pthread_create.c:335
|
#17 0x00003fff7db37e74 in clone () at ../sysdeps/unix/sysv/linux/powerpc/powerpc64/clone.S:96
|
rpl.rpl_gtid_crash-innodb_plugin,mix/mysqld.2/data/core
|
|
[Thread debugging using libthread_db enabled]
|
Using host libthread_db library "/lib/powerpc64le-linux-gnu/libthread_db.so.1".
|
Core was generated by `/build/build/sql/mysqld --defaults-group-suffix=.2 --defaults-file=/build/build'.
|
Program terminated with signal SIGABRT, Aborted.
|
#0 0x00003fffac312e4c in __pthread_kill (threadid=<optimized out>,
|
signo=<optimized out>) at ../sysdeps/unix/sysv/linux/pthread_kill.c:58
|
58 ../sysdeps/unix/sysv/linux/pthread_kill.c: No such file or directory.
|
[Current thread is 1 (Thread 0x3fff9f38efb0 (LWP 25472))]
|
(gdb) bt
|
#0 0x00003fffac312e4c in __pthread_kill (threadid=<optimized out>,
|
signo=<optimized out>) at ../sysdeps/unix/sysv/linux/pthread_kill.c:58
|
#1 0x0000000045dc3664 in my_write_core (sig=<optimized out>)
|
at /source/mysys/stacktrace.c:456
|
#2 0x00000000456dc71c in handle_fatal_signal (sig=<optimized out>)
|
at /source/sql/signal_handler.cc:272
|
#3 <signal handler called>
|
#4 0x00003fffabd9f27c in __GI_raise (sig=<optimized out>)
|
at ../sysdeps/unix/sysv/linux/raise.c:54
|
#5 0x00003fffabda18f4 in __GI_abort () at abort.c:89
|
#6 0x00003fffa46b6214 in mutex_exit_func (
|
mutex=0x3fffa47f54b8 <sync_thread_mutex>)
|
at /source/storage/innobase/include/sync0sync.ic:160
|
#7 pfs_mutex_exit_func (mutex=0x3fffa47f54b8 <sync_thread_mutex>)
|
at /source/storage/innobase/include/sync0sync.ic:314
|
#8 sync_thread_add_level (latch=0x3fffab314078, level=140, relock=0)
|
at /source/storage/innobase/sync/sync0sync.cc:1336
|
#9 0x00003fffa46b6284 in mutex_set_debug_info (mutex=0x3fffab314078,
|
file_name=0x3fffa4711838 "/source/storage/innobase/buf/buf0dblwr.cc",
|
line=712) at /source/storage/innobase/sync/sync0sync.cc:639
|
#10 0x00003fffa4430818 in mutex_enter_func (line=712,
|
file_name=0x3fffa4711838 "/source/storage/innobase/buf/buf0dblwr.cc",
|
mutex=0x3fffab314078) at /source/storage/innobase/include/sync0sync.ic:215
|
---Type <return> to continue, or q <return> to quit---
|
#11 pfs_mutex_enter_func (line=712,
|
file_name=0x3fffa4711838 "/source/storage/innobase/buf/buf0dblwr.cc",
|
mutex=0x3fffab314078) at /source/storage/innobase/include/sync0sync.ic:251
|
#12 buf_dblwr_update (bpage=<optimized out>, flush_type=<optimized out>)
|
at /source/storage/innobase/buf/buf0dblwr.cc:712
|
#13 0x00003fffa4443880 in buf_flush_write_complete (bpage=0x3fffa1bb2668)
|
at /source/storage/innobase/buf/buf0flu.cc:695
|
#14 0x00003fffa4429144 in buf_page_io_complete (bpage=0x3fffa1bb2668,
|
evict=<optimized out>) at /source/storage/innobase/buf/buf0buf.cc:4769
|
#15 0x00003fffa44b6c1c in fil_aio_wait (segment=5)
|
at /source/storage/innobase/fil/fil0fil.cc:6059
|
#16 0x00003fffa46a826c in io_handler_thread (arg=<optimized out>)
|
at /source/storage/innobase/srv/srv0start.cc:515
|
#17 0x00003fffac3084a0 in start_thread (arg=0x3fff9f38efb0)
|
at pthread_create.c:335
|
#18 0x00003fffabe87e74 in clone ()
|
at ../sysdeps/unix/sysv/linux/powerpc/powerpc64/clone.S:96
|
This seems to be quite repeatable.
- relates to
-
MDEV-7026
Race in InnoDB/XtraDB mutex implementation can stall or hang the server
-
-
Closed
Elena Stepanova
made changes -
| Field |
Original Value |
New Value |
|
Assignee
|
|
Jan Lindström
[ jplindst
]
|
Jan Lindström (Inactive)
made changes -
|
Assignee
|
Jan Lindström
[ jplindst
]
|
Vicentiu Ciorbaru
[ cvicentiu
]
|
Jan Lindström (Inactive)
made changes -
|
Fix Version/s
|
|
5.5
[ 15800
]
|
|
Fix Version/s
|
|
10.0
[ 16000
]
|
|
Fix Version/s
|
|
10.1
[ 16100
]
|
Daniel Black
made changes -
|
Affects Version/s
|
|
10.0.27
[ 22017
]
|
|
Affects Version/s
|
|
10.1.16
[ 22019
]
|
Rasmus Johansson (Inactive)
made changes -
|
Sprint
|
10.2.2-1, 10.2.2-2
[ 79, 82
]
|
10.2.2-1, 10.2.2-2, 10.2.2-3
[ 79, 82, 83
]
|
Vicențiu Ciorbaru
made changes -
|
Assignee
|
Vicentiu Ciorbaru
[ cvicentiu
]
|
Sergey Vojtovich
[ svoj
]
|
|
Status
|
In Progress
[ 3
]
|
In Review
[ 10002
]
|
Sergey Vojtovich
made changes -
|
Assignee
|
Sergey Vojtovich
[ svoj
]
|
Vicentiu Ciorbaru
[ cvicentiu
]
|
|
Status
|
In Review
[ 10002
]
|
Stalled
[ 10000
]
|
Rasmus Johansson (Inactive)
made changes -
|
Sprint
|
10.2.2-1, 10.2.2-2, 10.2.2-3
[ 79, 82, 83
]
|
10.2.2-1, 10.2.2-2, 10.2.2-3, 5.51 & 10.2
[ 79, 82, 83, 85
]
|
Rasmus Johansson (Inactive)
made changes -
|
Sprint
|
10.2.2-1, 10.2.2-2, 10.2.2-3, 5.5.51 & 10.2.2
[ 79, 82, 83, 85
]
|
10.2.2-1, 10.2.2-2, 10.2.2-3, 5.5.51 & 10.2.2, 10.1.17-1
[ 79, 82, 83, 85, 87
]
|
Vicențiu Ciorbaru
made changes -
|
Fix Version/s
|
|
10.2.2
[ 22013
]
|
|
Fix Version/s
|
|
10.1.18
[ 22110
]
|
|
Fix Version/s
|
|
10.0.27
[ 22017
]
|
|
Fix Version/s
|
|
5.5.51
[ 22015
]
|
|
Fix Version/s
|
10.2
[ 14601
]
|
|
|
Fix Version/s
|
5.5
[ 15800
]
|
|
|
Fix Version/s
|
10.0
[ 16000
]
|
|
|
Fix Version/s
|
10.1
[ 16100
]
|
|
|
Resolution
|
|
Fixed
[ 1
]
|
|
Status
|
Stalled
[ 10000
]
|
Closed
[ 6
]
|
Sergei Golubchik
made changes -
|
Workflow
|
MariaDB v3
[ 76357
]
|
MariaDB v4
[ 150591
]
|
{"report":{"fcp":1903,"ttfb":328.7000000476837,"pageVisibility":"visible","entityId":57356,"key":"jira.project.issue.view-issue","isInitial":true,"threshold":1000,"elementTimings":{},"userDeviceMemory":8,"userDeviceProcessors":32,"apdex":0.5,"journeyId":"afa47fe8-b708-4db3-be0d-addf19bff1cd","navigationType":0,"readyForUser":2038.2000000476837,"redirectCount":0,"resourceLoadedEnd":2201.5,"resourceLoadedStart":340,"resourceTiming":[{"duration":840.1000001430511,"initiatorType":"link","name":"https://jira.mariadb.org/s/2c21342762a6a02add1c328bed317ffd-CDN/lu2cib/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/css/_super/batch.css","startTime":340,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":340,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":1180.1000001430511,"responseStart":0,"secureConnectionStart":0},{"duration":840.2000000476837,"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":340.2000000476837,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":340.2000000476837,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":1180.4000000953674,"responseStart":0,"secureConnectionStart":0},{"duration":852.8999998569489,"initiatorType":"script","name":"https://jira.mariadb.org/s/0917945aaa57108d00c5076fea35e069-CDN/lu2cib/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/js/_super/batch.js?locale=en","startTime":340.40000009536743,"connectEnd":340.40000009536743,"connectStart":340.40000009536743,"domainLookupEnd":340.40000009536743,"domainLookupStart":340.40000009536743,"fetchStart":340.40000009536743,"redirectEnd":0,"redirectStart":0,"requestStart":340.40000009536743,"responseEnd":1193.2999999523163,"responseStart":1193.2999999523163,"secureConnectionStart":340.40000009536743},{"duration":947.8999998569489,"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":340.60000014305115,"connectEnd":340.60000014305115,"connectStart":340.60000014305115,"domainLookupEnd":340.60000014305115,"domainLookupStart":340.60000014305115,"fetchStart":340.60000014305115,"redirectEnd":0,"redirectStart":0,"requestStart":340.60000014305115,"responseEnd":1288.5,"responseStart":1288.5,"secureConnectionStart":340.60000014305115},{"duration":951.6000001430511,"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":340.7999999523163,"connectEnd":340.7999999523163,"connectStart":340.7999999523163,"domainLookupEnd":340.7999999523163,"domainLookupStart":340.7999999523163,"fetchStart":340.7999999523163,"redirectEnd":0,"redirectStart":0,"requestStart":340.7999999523163,"responseEnd":1292.4000000953674,"responseStart":1292.4000000953674,"secureConnectionStart":340.7999999523163},{"duration":952,"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":341.10000014305115,"connectEnd":341.10000014305115,"connectStart":341.10000014305115,"domainLookupEnd":341.10000014305115,"domainLookupStart":341.10000014305115,"fetchStart":341.10000014305115,"redirectEnd":0,"redirectStart":0,"requestStart":341.10000014305115,"responseEnd":1293.1000001430511,"responseStart":1293.1000001430511,"secureConnectionStart":341.10000014305115},{"duration":952.7000000476837,"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":341.2000000476837,"connectEnd":341.2000000476837,"connectStart":341.2000000476837,"domainLookupEnd":341.2000000476837,"domainLookupStart":341.2000000476837,"fetchStart":341.2000000476837,"redirectEnd":0,"redirectStart":0,"requestStart":341.2000000476837,"responseEnd":1293.9000000953674,"responseStart":1293.9000000953674,"secureConnectionStart":341.2000000476837},{"duration":1108.1000001430511,"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":341.2999999523163,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":341.2999999523163,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":1449.4000000953674,"responseStart":0,"secureConnectionStart":0},{"duration":953.4000000953674,"initiatorType":"script","name":"https://jira.mariadb.org/rest/api/1.0/shortcuts/820016/47140b6e0a9bc2e4913da06536125810/shortcuts.js?context=issuenavigation&context=issueaction","startTime":341.5,"connectEnd":341.5,"connectStart":341.5,"domainLookupEnd":341.5,"domainLookupStart":341.5,"fetchStart":341.5,"redirectEnd":0,"redirectStart":0,"requestStart":341.5,"responseEnd":1294.9000000953674,"responseStart":1294.9000000953674,"secureConnectionStart":341.5},{"duration":1107.9000000953674,"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":341.7000000476837,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":341.7000000476837,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":1449.6000001430511,"responseStart":0,"secureConnectionStart":0},{"duration":954.2000000476837,"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":341.7999999523163,"connectEnd":341.7999999523163,"connectStart":341.7999999523163,"domainLookupEnd":341.7999999523163,"domainLookupStart":341.7999999523163,"fetchStart":341.7999999523163,"redirectEnd":0,"redirectStart":0,"requestStart":341.7999999523163,"responseEnd":1296,"responseStart":1296,"secureConnectionStart":341.7999999523163},{"duration":1858.4000000953674,"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":342.7000000476837,"connectEnd":342.7000000476837,"connectStart":342.7000000476837,"domainLookupEnd":342.7000000476837,"domainLookupStart":342.7000000476837,"fetchStart":342.7000000476837,"redirectEnd":0,"redirectStart":0,"requestStart":342.7000000476837,"responseEnd":2201.100000143051,"responseStart":2201.100000143051,"secureConnectionStart":342.7000000476837},{"duration":1858.7000000476837,"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":342.7999999523163,"connectEnd":342.7999999523163,"connectStart":342.7999999523163,"domainLookupEnd":342.7999999523163,"domainLookupStart":342.7999999523163,"fetchStart":342.7999999523163,"redirectEnd":0,"redirectStart":0,"requestStart":342.7999999523163,"responseEnd":2201.5,"responseStart":2201.5,"secureConnectionStart":342.7999999523163},{"duration":118,"initiatorType":"xmlhttprequest","name":"https://jira.mariadb.org/rest/webResources/1.0/resources","startTime":1471.1000001430511,"connectEnd":1471.1000001430511,"connectStart":1471.1000001430511,"domainLookupEnd":1471.1000001430511,"domainLookupStart":1471.1000001430511,"fetchStart":1471.1000001430511,"redirectEnd":0,"redirectStart":0,"requestStart":1471.1000001430511,"responseEnd":1589.1000001430511,"responseStart":1589.1000001430511,"secureConnectionStart":1471.1000001430511}],"fetchStart":0,"domainLookupStart":0,"domainLookupEnd":0,"connectStart":0,"connectEnd":0,"requestStart":48,"responseStart":329,"responseEnd":335,"domLoading":337,"domInteractive":2244,"domContentLoadedEventStart":2244,"domContentLoadedEventEnd":2329,"domComplete":3394,"loadEventStart":3394,"loadEventEnd":3395,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[{"name":"bigPipe.sidebar-id.start","time":2207.100000143051},{"name":"bigPipe.sidebar-id.end","time":2208},{"name":"bigPipe.activity-panel-pipe-id.start","time":2208.100000143051},{"name":"bigPipe.activity-panel-pipe-id.end","time":2213.600000143051},{"name":"activityTabFullyLoaded","time":2349.7000000476837}],"measures":[],"correlationId":"e94cfbc287ffc2","effectiveType":"4g","downlink":9.1,"rtt":0,"serverDuration":177,"dbReadsTimeInMs":28,"dbConnsTimeInMs":38,"applicationHash":"9d11dbea5f4be3d4cc21f03a88dd11d8c8687422","experiments":[]}}
