SET @@SESSION.wsrep_causal_reads=ON;
SET SESSION wsrep_on=1;
START TRANSACTION READ WRITE;
Leads to:
10.5.3 98003440c2f8d20164a191ced1b7d92b283bb68f
2020-05-04 3:10:25 0 [Note] /test/MD300420-mariadb-10.5.3-linux-x86_64-opt/bin/mysqld: ready for connections.
Version: '10.5.3-MariaDB' socket: '/test/MD300420-mariadb-10.5.3-linux-x86_64-opt/socket.sock' port: 10419 MariaDB Server
terminate called after throwing an instance of 'wsrep::runtime_error'
what(): provider not loaded
200504 3:10:54 [ERROR] mysqld got signal 6 ;
10.5.3 98003440c2f8d20164a191ced1b7d92b283bb68f
Core was generated by `/test/MD300420-mariadb-10.5.3-linux-x86_64-opt/bin/mysqld --no-defaults --core-'.
Program terminated with signal SIGABRT, Aborted.
#0 __pthread_kill (threadid=<optimized out>, signo=signo@entry=6)
at ../sysdeps/unix/sysv/linux/pthread_kill.c:57
[Current thread is 1 (Thread 0x7fcccb22d700 (LWP 3156879))]
(gdb) bt
#0 __pthread_kill (threadid=<optimized out>, signo=signo@entry=6) at ../sysdeps/unix/sysv/linux/pthread_kill.c:57
#1 0x000055888b4ec707 in my_write_core (sig=sig@entry=6) at /test/10.5_opt/mysys/stacktrace.c:518
#2 0x000055888aeae92a in handle_fatal_signal (sig=6) at /test/10.5_opt/sql/signal_handler.cc:329
#3 <signal handler called>
#4 __GI_raise (sig=sig@entry=6) at ../sysdeps/unix/sysv/linux/raise.c:51
#5 0x00007fccc9971801 in __GI_abort () at abort.c:79
#6 0x00007fccca14c957 in ?? () from /usr/lib/x86_64-linux-gnu/libstdc++.so.6
#7 0x00007fccca152ae6 in ?? () from /usr/lib/x86_64-linux-gnu/libstdc++.so.6
#8 0x00007fccca152b21 in std::terminate() () from /usr/lib/x86_64-linux-gnu/libstdc++.so.6
#9 0x00007fccca152d54 in __cxa_throw () from /usr/lib/x86_64-linux-gnu/libstdc++.so.6
#10 0x000055888b61db2a in wsrep::server_state::provider (this=<optimized out>) at /test/10.5_opt/wsrep-lib/include/wsrep/server_state.hpp:310
#11 wsrep::server_state::causal_read (this=<optimized out>, timeout=timeout@entry=-1) at /test/10.5_opt/wsrep-lib/src/server_state.cpp:838
#12 0x000055888b614a0a in wsrep::client_state::sync_wait (this=this@entry=0x7fcc91c18120, timeout=timeout@entry=-1) at /test/10.5_opt/wsrep-lib/src/client_state.cpp:716
#13 0x000055888b18f93d in wsrep_sync_wait (thd=thd@entry=0x7fcc91c12018, mask=mask@entry=1) at /test/10.5_opt/sql/wsrep_mysqld.cc:1150
#14 0x000055888adb6605 in trans_begin (thd=thd@entry=0x7fcc91c12018, flags=4) at /test/10.5_opt/sql/transaction.cc:187
#15 0x000055888acba165 in mysql_execute_command (thd=thd@entry=0x7fcc91c12018) at /test/10.5_opt/sql/sql_parse.cc:5525
#16 0x000055888acbfecc in mysql_parse (thd=thd@entry=0x7fcc91c12018, rawbuf=<optimized out>, length=28, parser_state=parser_state@entry=0x7fcccb22c4d0, is_com_multi=is_com_multi@entry=false, is_next_command=is_next_command@entry=false) at /test/10.5_opt/sql/sql_parse.cc:7957
#17 0x000055888acb4d00 in dispatch_command (command=command@entry=COM_QUERY, thd=thd@entry=0x7fcc91c12018, packet=packet@entry=0x7fcc91c3a019 "START TRANSACTION READ WRITE", packet_length=packet_length@entry=28, is_com_multi=is_com_multi@entry=false, is_next_command=is_next_command@entry=false) at /test/10.5_opt/sql/sql_parse.cc:1839
#18 0x000055888acb301f in do_command (thd=0x7fcc91c12018) at /test/10.5_opt/sql/sql_parse.cc:1358
#19 0x000055888ada822e in do_handle_one_connection (connect=<optimized out>, connect@entry=0x7fccc8c329b8, put_in_cache=put_in_cache@entry=true) at /test/10.5_opt/sql/sql_connect.cc:1422
#20 0x000055888ada83d4 in handle_one_connection (arg=arg@entry=0x7fccc8c329b8) at /test/10.5_opt/sql/sql_connect.cc:1319
#21 0x000055888b114c9a in pfs_spawn_thread (arg=0x7fccc8c4b018) at /test/10.5_opt/storage/perfschema/pfs.cc:2201
#22 0x00007fccca6546db in start_thread (arg=0x7fcccb22d700) at pthread_create.c:463
#23 0x00007fccc9a5288f in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95
Bug confirmed present in:
MariaDB: 10.4.13 (dbg), 10.4.13 (opt), 10.5.2 (dbg), 10.5.2 (opt), 10.5.3 (dbg), 10.5.3 (opt)
Bug confirmed not present in:
MariaDB: 10.1.45 (dbg), 10.1.45 (opt), 10.2.32 (dbg), 10.2.32 (opt), 10.3.23 (dbg), 10.3.23 (opt)
MySQL: 5.5.62 (dbg), 5.5.62 (opt), 5.6.47 (dbg), 5.6.47 (opt), 5.7.29 (dbg), 5.7.29 (opt), 8.0.19 (dbg), 8.0.19 (opt)
MySQL 10.3.23 (dbg):
10.3.23>SET @@SESSION.wsrep_causal_reads=ON;
Query OK, 0 rows affected, 1 warning (0.000 sec)
10.3.23>SHOW WARNINGS\G
*************************** 1. row ***************************
Level: Warning
Code: 1287
Message: '@@wsrep_causal_reads' is deprecated and will be removed in a future release. Please use '@@wsrep_sync_wait=1' instead
1 row in set (0.000 sec)
10.3.23>SET SESSION wsrep_on=1;
Query OK, 0 rows affected (0.000 sec)
10.3.23>START TRANSACTION READ WRITE;
Query OK, 0 rows affected (0.000 sec)
Roel Van de Paar
made changes -
2020-07-14 09:44
Field
Original Value
New Value
Affects Version/s
10.5.5
[ 24423
]
Roel Van de Paar
made changes -
2020-07-14 09:44
Labels
not-10.1 not-10.2 not-10.3 regression
affects-tests not-10.1 not-10.2 not-10.3 regression
Elena Stepanova
made changes -
2020-07-14 10:20
Affects Version/s
10.5.5
[ 24423
]
Jan Lindström (Inactive)
made changes -
2020-08-19 14:10
Component/s
Galera
[ 10124
]
Component/s
wsrep
[ 11500
]
Fix Version/s
10.4.15
[ 24507
]
Fix Version/s
10.5.6
[ 24508
]
Fix Version/s
10.4
[ 22408
]
Fix Version/s
10.5
[ 23123
]
Resolution
Fixed
[ 1
]
Status
Open
[ 1
]
Closed
[ 6
]
Ralf Gebhardt
made changes -
2020-10-06 18:35
Fix Version/s
10.5.7
[ 25019
]
Ralf Gebhardt
made changes -
2020-10-06 18:38
Fix Version/s
10.5.6
[ 24508
]
Ralf Gebhardt
made changes -
2020-10-06 18:40
Fix Version/s
10.4.16
[ 25020
]
Ralf Gebhardt
made changes -
2020-10-06 18:42
Fix Version/s
10.4.15
[ 24507
]
Sergei Golubchik
made changes -
2021-12-06 21:51
Workflow
MariaDB v3
[ 108172
]
MariaDB v4
[ 157708
]
{"report":{"fcp":1309.0999994277954,"ttfb":323.19999980926514,"pageVisibility":"visible","entityId":86446,"key":"jira.project.issue.view-issue","isInitial":true,"threshold":1000,"elementTimings":{},"userDeviceMemory":8,"userDeviceProcessors":64,"apdex":0.5,"journeyId":"39c351cb-0811-4342-b448-2bab42713cf3","navigationType":0,"readyForUser":1396.0999994277954,"redirectCount":0,"resourceLoadedEnd":1429.1999998092651,"resourceLoadedStart":329.30000019073486,"resourceTiming":[{"duration":413.0999994277954,"initiatorType":"link","name":"https://jira.mariadb.org/s/2c21342762a6a02add1c328bed317ffd-CDN/lu2cib/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/css/_super/batch.css","startTime":329.30000019073486,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":329.30000019073486,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":742.3999996185303,"responseStart":0,"secureConnectionStart":0},{"duration":413.30000019073486,"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":329.5,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":329.5,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":742.8000001907349,"responseStart":0,"secureConnectionStart":0},{"duration":468.19999980926514,"initiatorType":"script","name":"https://jira.mariadb.org/s/0917945aaa57108d00c5076fea35e069-CDN/lu2cib/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/js/_super/batch.js?locale=en","startTime":329.69999980926514,"connectEnd":329.69999980926514,"connectStart":329.69999980926514,"domainLookupEnd":329.69999980926514,"domainLookupStart":329.69999980926514,"fetchStart":329.69999980926514,"redirectEnd":0,"redirectStart":0,"requestStart":329.69999980926514,"responseEnd":797.8999996185303,"responseStart":797.8999996185303,"secureConnectionStart":329.69999980926514},{"duration":524.9000005722046,"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":329.8999996185303,"connectEnd":329.8999996185303,"connectStart":329.8999996185303,"domainLookupEnd":329.8999996185303,"domainLookupStart":329.8999996185303,"fetchStart":329.8999996185303,"redirectEnd":0,"redirectStart":0,"requestStart":329.8999996185303,"responseEnd":854.8000001907349,"responseStart":854.8000001907349,"secureConnectionStart":329.8999996185303},{"duration":528.4000005722046,"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":330.0999994277954,"connectEnd":330.0999994277954,"connectStart":330.0999994277954,"domainLookupEnd":330.0999994277954,"domainLookupStart":330.0999994277954,"fetchStart":330.0999994277954,"redirectEnd":0,"redirectStart":0,"requestStart":330.0999994277954,"responseEnd":858.5,"responseStart":858.5,"secureConnectionStart":330.0999994277954},{"duration":528.6999998092651,"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":330.19999980926514,"connectEnd":330.19999980926514,"connectStart":330.19999980926514,"domainLookupEnd":330.19999980926514,"domainLookupStart":330.19999980926514,"fetchStart":330.19999980926514,"redirectEnd":0,"redirectStart":0,"requestStart":330.19999980926514,"responseEnd":858.8999996185303,"responseStart":858.8999996185303,"secureConnectionStart":330.19999980926514},{"duration":528.9000005722046,"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":330.3999996185303,"connectEnd":330.3999996185303,"connectStart":330.3999996185303,"domainLookupEnd":330.3999996185303,"domainLookupStart":330.3999996185303,"fetchStart":330.3999996185303,"redirectEnd":0,"redirectStart":0,"requestStart":330.3999996185303,"responseEnd":859.3000001907349,"responseStart":859.3000001907349,"secureConnectionStart":330.3999996185303},{"duration":610.6000003814697,"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":330.5999994277954,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":330.5999994277954,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":941.1999998092651,"responseStart":0,"secureConnectionStart":0},{"duration":529,"initiatorType":"script","name":"https://jira.mariadb.org/rest/api/1.0/shortcuts/820016/47140b6e0a9bc2e4913da06536125810/shortcuts.js?context=issuenavigation&context=issueaction","startTime":330.69999980926514,"connectEnd":330.69999980926514,"connectStart":330.69999980926514,"domainLookupEnd":330.69999980926514,"domainLookupStart":330.69999980926514,"fetchStart":330.69999980926514,"redirectEnd":0,"redirectStart":0,"requestStart":330.69999980926514,"responseEnd":859.6999998092651,"responseStart":859.6999998092651,"secureConnectionStart":330.69999980926514},{"duration":610.5,"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":330.8999996185303,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":330.8999996185303,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":941.3999996185303,"responseStart":0,"secureConnectionStart":0},{"duration":529.2000007629395,"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":331.0999994277954,"connectEnd":331.0999994277954,"connectStart":331.0999994277954,"domainLookupEnd":331.0999994277954,"domainLookupStart":331.0999994277954,"fetchStart":331.0999994277954,"redirectEnd":0,"redirectStart":0,"requestStart":331.0999994277954,"responseEnd":860.3000001907349,"responseStart":860.3000001907349,"secureConnectionStart":331.0999994277954},{"duration":693.0999994277954,"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":332,"connectEnd":332,"connectStart":332,"domainLookupEnd":332,"domainLookupStart":332,"fetchStart":332,"redirectEnd":0,"redirectStart":0,"requestStart":332,"responseEnd":1025.0999994277954,"responseStart":1025.0999994277954,"secureConnectionStart":332},{"duration":1018.6000003814697,"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":336.0999994277954,"connectEnd":336.0999994277954,"connectStart":336.0999994277954,"domainLookupEnd":336.0999994277954,"domainLookupStart":336.0999994277954,"fetchStart":336.0999994277954,"redirectEnd":0,"redirectStart":0,"requestStart":336.0999994277954,"responseEnd":1354.6999998092651,"responseStart":1354.6999998092651,"secureConnectionStart":336.0999994277954},{"duration":73.5,"initiatorType":"xmlhttprequest","name":"https://jira.mariadb.org/rest/webResources/1.0/resources","startTime":952.3000001907349,"connectEnd":952.3000001907349,"connectStart":952.3000001907349,"domainLookupEnd":952.3000001907349,"domainLookupStart":952.3000001907349,"fetchStart":952.3000001907349,"redirectEnd":0,"redirectStart":0,"requestStart":952.3000001907349,"responseEnd":1025.8000001907349,"responseStart":1025.8000001907349,"secureConnectionStart":952.3000001907349},{"duration":217.10000038146973,"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":1212.0999994277954,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":1212.0999994277954,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":1429.1999998092651,"responseStart":0,"secureConnectionStart":0},{"duration":247.79999923706055,"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":1213.3000001907349,"connectEnd":1213.3000001907349,"connectStart":1213.3000001907349,"domainLookupEnd":1213.3000001907349,"domainLookupStart":1213.3000001907349,"fetchStart":1213.3000001907349,"redirectEnd":0,"redirectStart":0,"requestStart":1213.3000001907349,"responseEnd":1461.0999994277954,"responseStart":1461.0999994277954,"secureConnectionStart":1213.3000001907349},{"duration":252.89999961853027,"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":1213.6999998092651,"connectEnd":1213.6999998092651,"connectStart":1213.6999998092651,"domainLookupEnd":1213.6999998092651,"domainLookupStart":1213.6999998092651,"fetchStart":1213.6999998092651,"redirectEnd":0,"redirectStart":0,"requestStart":1213.6999998092651,"responseEnd":1466.5999994277954,"responseStart":1466.5999994277954,"secureConnectionStart":1213.6999998092651},{"duration":214.9000005722046,"initiatorType":"script","name":"https://www.google-analytics.com/analytics.js","startTime":1302.5999994277954,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":1302.5999994277954,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":1517.5,"responseStart":0,"secureConnectionStart":0}],"fetchStart":0,"domainLookupStart":0,"domainLookupEnd":0,"connectStart":0,"connectEnd":0,"requestStart":117,"responseStart":323,"responseEnd":328,"domLoading":326,"domInteractive":1461,"domContentLoadedEventStart":1461,"domContentLoadedEventEnd":1508,"domComplete":1856,"loadEventStart":1856,"loadEventEnd":1857,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[{"name":"bigPipe.sidebar-id.start","time":1442.0999994277954},{"name":"bigPipe.sidebar-id.end","time":1442.8999996185303},{"name":"bigPipe.activity-panel-pipe-id.start","time":1443},{"name":"bigPipe.activity-panel-pipe-id.end","time":1446.5},{"name":"activityTabFullyLoaded","time":1538.8000001907349}],"measures":[],"correlationId":"95b03cfb45b789","effectiveType":"4g","downlink":10,"rtt":0,"serverDuration":138,"dbReadsTimeInMs":24,"dbConnsTimeInMs":34,"applicationHash":"9d11dbea5f4be3d4cc21f03a88dd11d8c8687422","experiments":[]}}