source in.sql # in.sql is attached
|
Leads to:
10.8.1 307b2991d61ff6734d858bdb211a88d1c8607a36 (Debug)
|
mysqld: /test/10.8_dbg/wsrep-lib/src/server_state.cpp:1347: void wsrep::server_state::state(wsrep::unique_lock<wsrep::mutex>&, wsrep::server_state::state): Assertion `0' failed.
|
10.8.1 307b2991d61ff6734d858bdb211a88d1c8607a36 (Debug)
|
Core was generated by `/test/GAL_MD070222-mariadb-10.8.1-linux-x86_64-dbg/bin/mysqld --defaults-file=/'.
|
Program terminated with signal SIGABRT, Aborted.
|
#0 __pthread_kill (threadid=<optimized out>, signo=signo@entry=6)
|
at ../sysdeps/unix/sysv/linux/pthread_kill.c:56
|
[Current thread is 1 (Thread 0x147da4f74700 (LWP 305342))]
|
(gdb) bt
|
#0 __pthread_kill (threadid=<optimized out>, signo=signo@entry=6) at ../sysdeps/unix/sysv/linux/pthread_kill.c:56
|
#1 0x0000560b015725ed in my_write_core (sig=sig@entry=6) at /test/10.8_dbg/mysys/stacktrace.c:424
|
#2 0x0000560b00d58ce3 in handle_fatal_signal (sig=6) at /test/10.8_dbg/sql/signal_handler.cc:345
|
#3 <signal handler called>
|
#4 __GI_raise (sig=sig@entry=6) at ../sysdeps/unix/sysv/linux/raise.c:50
|
#5 0x0000147da6829859 in __GI_abort () at abort.c:79
|
#6 0x0000147da6829729 in __assert_fail_base (fmt=0x147da69bf588 "%s%s%s:%u: %s%sAssertion `%s' failed.\n%n", assertion=0x560b018e71e7 "0", file=0x560b01cc4800 "/test/10.8_dbg/wsrep-lib/src/server_state.cpp", line=1347, function=<optimized out>) at assert.c:92
|
#7 0x0000147da683af36 in __GI___assert_fail (assertion=assertion@entry=0x560b018e71e7 "0", file=file@entry=0x560b01cc4800 "/test/10.8_dbg/wsrep-lib/src/server_state.cpp", line=line@entry=1347, function=function@entry=0x560b01cc4f78 "void wsrep::server_state::state(wsrep::unique_lock<wsrep::mutex>&, wsrep::server_state::state)") at assert.c:101
|
#8 0x0000560b016d35bb in wsrep::server_state::state (this=this@entry=0x560b02bdf380, lock=@0x147da4f730e0: {_M_device = 0x560b02bdf668, _M_owns = true}, state=state@entry=wsrep::server_state::s_synced) at /test/10.8_dbg/wsrep-lib/src/server_state.cpp:1347
|
#9 0x0000560b016d6fe3 in wsrep::server_state::on_sync (this=0x560b02bdf380) at /test/10.8_dbg/wsrep-lib/src/server_state.cpp:1081
|
#10 0x0000560b016e78df in (anonymous namespace)::synced_cb (app_ctx=<optimized out>) at /test/10.8_dbg/wsrep-lib/src/wsrep_provider_v26.cpp:530
|
#11 0x0000147da62a4cfb in galera::ReplicatorSMM::process_sync (this=0x560b02c151f0, seqno_l=<optimized out>) at /test/10.4_galera/galera/src/replicator_smm.cpp:3064
|
#12 0x0000147da62d8a42 in galera::GcsActionSource::dispatch (this=0x560b02c22600, recv_ctx=0x147da4f73d10, act=@0x147da4f73710: {seqno_g = 0, seqno_l = 11, buf = 0x147d8c002430, size = 8, type = GCS_ACT_SYNC}, exit_loop=<optimized out>) at /test/10.4_galera/galera/src/gcs_action_source.cpp:143
|
#13 0x0000147da62d8e62 in galera::GcsActionSource::process (this=0x560b02c22600, recv_ctx=0x147da4f73d10, exit_loop=@0x147da4f7391f: false) at /test/10.4_galera/galera/src/gcs_action_source.cpp:186
|
#14 0x0000147da62a37f0 in galera::ReplicatorSMM::async_recv (this=0x560b02c151f0, recv_ctx=0x147da4f73d10) at /test/10.4_galera/galera/src/replicator_smm.cpp:402
|
#15 0x0000147da6277e91 in galera_recv (gh=<optimized out>, recv_ctx=<optimized out>) at /test/10.4_galera/galera/src/wsrep_provider.cpp:263
|
#16 0x0000560b016ea67a in wsrep::wsrep_provider_v26::run_applier (this=<optimized out>, applier_ctx=<optimized out>) at /test/10.8_dbg/wsrep-lib/src/wsrep_provider_v26.cpp:858
|
#17 0x0000560b010d83c3 in wsrep_replication_process (thd=0x147d84000ff8, arg=<optimized out>) at /test/10.8_dbg/sql/wsrep_server_state.h:51
|
#18 0x0000560b010c571d in start_wsrep_THD (arg=arg@entry=0x560b02c65ec0) at /test/10.8_dbg/sql/wsrep_mysqld.h:573
|
#19 0x0000560b010565dd in pfs_spawn_thread (arg=0x560b02c3eb78) at /test/10.8_dbg/storage/perfschema/pfs.cc:2201
|
#20 0x0000147da6d38609 in start_thread (arg=<optimized out>) at pthread_create.c:477
|
#21 0x0000147da6926293 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95
|
Bug confirmed present in:
MariaDB: 10.4.23 (dbg), 10.5.14 (dbg), 10.6.6 (dbg), 10.7.2 (dbg), 10.8.1 (dbg)
Bug (or feature/syntax) confirmed not present in:
MariaDB: 10.2.42 (dbg), 10.2.42 (opt), 10.3.33 (dbg), 10.3.33 (opt), 10.4.23 (opt), 10.5.14 (opt), 10.6.6 (opt), 10.7.2 (opt)
- relates to
-
MDEV-31988
galera_partition test: assertion due to unallowed state transition
-
-
Closed
{"report":{"fcp":940.9000000953674,"ttfb":245,"pageVisibility":"visible","entityId":108065,"key":"jira.project.issue.view-issue","isInitial":true,"threshold":1000,"elementTimings":{},"userDeviceMemory":8,"userDeviceProcessors":64,"apdex":0.5,"journeyId":"234bb9ba-c62d-4d43-a563-644caa564a3a","navigationType":0,"readyForUser":1021.2000002861023,"redirectCount":0,"resourceLoadedEnd":584.6000003814697,"resourceLoadedStart":253.30000019073486,"resourceTiming":[{"duration":5.199999809265137,"initiatorType":"link","name":"https://jira.mariadb.org/s/2c21342762a6a02add1c328bed317ffd-CDN/lu2bsh/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/css/_super/batch.css","startTime":253.30000019073486,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":253.30000019073486,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":258.5,"responseStart":0,"secureConnectionStart":0},{"duration":5,"initiatorType":"link","name":"https://jira.mariadb.org/s/7ebd35e77e471bc30ff0eba799ebc151-CDN/lu2bsh/820016/12ta74/eb142f92e4bd16bd1ef8b08c1b9d5d56/_/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":253.60000038146973,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":253.60000038146973,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":258.6000003814697,"responseStart":0,"secureConnectionStart":0},{"duration":228.90000009536743,"initiatorType":"script","name":"https://jira.mariadb.org/s/c54b129276d75dc2a3460e1d78f37913-CDN/lu2bsh/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/js/_super/batch.js?locale=en","startTime":253.7000002861023,"connectEnd":253.7000002861023,"connectStart":253.7000002861023,"domainLookupEnd":253.7000002861023,"domainLookupStart":253.7000002861023,"fetchStart":253.7000002861023,"redirectEnd":0,"redirectStart":0,"requestStart":261.6000003814697,"responseEnd":482.6000003814697,"responseStart":289.6000003814697,"secureConnectionStart":253.7000002861023},{"duration":51.80000019073486,"initiatorType":"script","name":"https://jira.mariadb.org/s/ffdb17665775c5b4d6f097f3974ee359-CDN/lu2bsh/820016/12ta74/c92c0caa9a024ae85b0ebdbed7fb4bd7/_/download/contextbatch/js/atl.global,-_super/batch.js?locale=en","startTime":253.80000019073486,"connectEnd":253.80000019073486,"connectStart":253.80000019073486,"domainLookupEnd":253.80000019073486,"domainLookupStart":253.80000019073486,"fetchStart":253.80000019073486,"redirectEnd":0,"redirectStart":0,"requestStart":262.7000002861023,"responseEnd":305.6000003814697,"responseStart":301.80000019073486,"secureConnectionStart":253.80000019073486},{"duration":330.80000019073486,"initiatorType":"script","name":"https://jira.mariadb.org/s/f867843cd2fdb209d4d1d4f760f86346-CDN/lu2bsh/820016/12ta74/eb142f92e4bd16bd1ef8b08c1b9d5d56/_/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":253.80000019073486,"connectEnd":253.80000019073486,"connectStart":253.80000019073486,"domainLookupEnd":253.80000019073486,"domainLookupStart":253.80000019073486,"fetchStart":253.80000019073486,"redirectEnd":0,"redirectStart":0,"requestStart":261.80000019073486,"responseEnd":584.6000003814697,"responseStart":282.7000002861023,"secureConnectionStart":253.80000019073486},{"duration":52.10000038146973,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2bsh/820016/12ta74/1.0/_/download/batch/jira.webresources:calendar-en/jira.webresources:calendar-en.js","startTime":254,"connectEnd":254,"connectStart":254,"domainLookupEnd":254,"domainLookupStart":254,"fetchStart":254,"redirectEnd":0,"redirectStart":0,"requestStart":263.80000019073486,"responseEnd":306.1000003814697,"responseStart":303,"secureConnectionStart":254},{"duration":45.59999990463257,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2bsh/820016/12ta74/1.0/_/download/batch/jira.webresources:calendar-localisation-moment/jira.webresources:calendar-localisation-moment.js","startTime":254.10000038146973,"connectEnd":254.10000038146973,"connectStart":254.10000038146973,"domainLookupEnd":254.10000038146973,"domainLookupStart":254.10000038146973,"fetchStart":254.10000038146973,"redirectEnd":0,"redirectStart":0,"requestStart":266.5,"responseEnd":299.7000002861023,"responseStart":291.6000003814697,"secureConnectionStart":254.10000038146973},{"duration":11.5,"initiatorType":"link","name":"https://jira.mariadb.org/s/b04b06a02d1959df322d9cded3aeecc1-CDN/lu2bsh/820016/12ta74/a2ff6aa845ffc9a1d22fe23d9ee791fc/_/download/contextbatch/css/jira.global.look-and-feel,-_super/batch.css","startTime":254.2000002861023,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":254.2000002861023,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":265.7000002861023,"responseStart":0,"secureConnectionStart":0},{"duration":63.09999990463257,"initiatorType":"script","name":"https://jira.mariadb.org/rest/api/1.0/shortcuts/820016/47140b6e0a9bc2e4913da06536125810/shortcuts.js?context=issuenavigation&context=issueaction","startTime":254.30000019073486,"connectEnd":254.30000019073486,"connectStart":254.30000019073486,"domainLookupEnd":254.30000019073486,"domainLookupStart":254.30000019073486,"fetchStart":254.30000019073486,"redirectEnd":0,"redirectStart":0,"requestStart":266.80000019073486,"responseEnd":317.40000009536743,"responseStart":315.5,"secureConnectionStart":254.30000019073486},{"duration":11.700000286102295,"initiatorType":"link","name":"https://jira.mariadb.org/s/3ac36323ba5e4eb0af2aa7ac7211b4bb-CDN/lu2bsh/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":254.40000009536743,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":254.40000009536743,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":266.1000003814697,"responseStart":0,"secureConnectionStart":0},{"duration":52,"initiatorType":"script","name":"https://jira.mariadb.org/s/81b5d7c27af3ebc078cc4a36383678ba-CDN/lu2bsh/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":254.5,"connectEnd":254.5,"connectStart":254.5,"domainLookupEnd":254.5,"domainLookupStart":254.5,"fetchStart":254.5,"redirectEnd":0,"redirectStart":0,"requestStart":268.2000002861023,"responseEnd":306.5,"responseStart":292.90000009536743,"secureConnectionStart":254.5},{"duration":320.40000009536743,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2bsh/820016/12ta74/1.0/_/download/batch/jira.webresources:bigpipe-js/jira.webresources:bigpipe-js.js","startTime":258.40000009536743,"connectEnd":258.40000009536743,"connectStart":258.40000009536743,"domainLookupEnd":258.40000009536743,"domainLookupStart":258.40000009536743,"fetchStart":258.40000009536743,"redirectEnd":0,"redirectStart":0,"requestStart":275.2000002861023,"responseEnd":578.8000001907349,"responseStart":573,"secureConnectionStart":258.40000009536743},{"duration":321.1000003814697,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2bsh/820016/12ta74/1.0/_/download/batch/jira.webresources:bigpipe-init/jira.webresources:bigpipe-init.js","startTime":258.5,"connectEnd":258.5,"connectStart":258.5,"domainLookupEnd":258.5,"domainLookupStart":258.5,"fetchStart":258.5,"redirectEnd":0,"redirectStart":0,"requestStart":278.80000019073486,"responseEnd":579.6000003814697,"responseStart":575.1000003814697,"secureConnectionStart":258.5},{"duration":203.60000038146973,"initiatorType":"xmlhttprequest","name":"https://jira.mariadb.org/rest/webResources/1.0/resources","startTime":688,"connectEnd":688,"connectStart":688,"domainLookupEnd":688,"domainLookupStart":688,"fetchStart":688,"redirectEnd":0,"redirectStart":0,"requestStart":861,"responseEnd":891.6000003814697,"responseStart":889.9000000953674,"secureConnectionStart":688}],"fetchStart":1,"domainLookupStart":58,"domainLookupEnd":82,"connectStart":82,"connectEnd":101,"secureConnectionStart":90,"requestStart":101,"responseStart":245,"responseEnd":258,"domLoading":249,"domInteractive":1085,"domContentLoadedEventStart":1085,"domContentLoadedEventEnd":1122,"domComplete":2314,"loadEventStart":2314,"loadEventEnd":2315,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[{"name":"bigPipe.sidebar-id.start","time":1066.8000001907349},{"name":"bigPipe.sidebar-id.end","time":1067.6000003814697},{"name":"bigPipe.activity-panel-pipe-id.start","time":1067.7000002861023},{"name":"bigPipe.activity-panel-pipe-id.end","time":1068.9000000953674},{"name":"activityTabFullyLoaded","time":1139.6000003814697}],"measures":[],"correlationId":"9370a3418ab1a4","effectiveType":"4g","downlink":10,"rtt":0,"serverDuration":70,"dbReadsTimeInMs":11,"dbConnsTimeInMs":17,"applicationHash":"9d11dbea5f4be3d4cc21f03a88dd11d8c8687422","experiments":[]}}
Another test case found, changing wsrep_cluster_address immediately after setting pc.bootstrap=1 crashes the server
SET GLOBAL wsrep_provider_options='gmcast.isolate=1';
CREATE TABLE t(id int);
SET GLOBAL wsrep_provider_options='pc.bootstrap=1';
SET @@global.wsrep_cluster_address=default;