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":708.2999997138977,"ttfb":168.69999980926514,"pageVisibility":"visible","entityId":108065,"key":"jira.project.issue.view-issue","isInitial":true,"threshold":1000,"elementTimings":{},"userDeviceMemory":8,"userDeviceProcessors":64,"apdex":1,"journeyId":"6f6f627d-af1d-4622-b22a-9eaf55805a18","navigationType":0,"readyForUser":831.5,"redirectCount":0,"resourceLoadedEnd":719.5999999046326,"resourceLoadedStart":174.59999990463257,"resourceTiming":[{"duration":7.400000095367432,"initiatorType":"link","name":"https://jira.mariadb.org/s/2c21342762a6a02add1c328bed317ffd-CDN/lu2cib/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/css/_super/batch.css","startTime":174.59999990463257,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":174.59999990463257,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":182,"responseStart":0,"secureConnectionStart":0},{"duration":7.400000095367432,"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":174.89999961853027,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":174.89999961853027,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":182.2999997138977,"responseStart":0,"secureConnectionStart":0},{"duration":59.5,"initiatorType":"script","name":"https://jira.mariadb.org/s/0917945aaa57108d00c5076fea35e069-CDN/lu2cib/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/js/_super/batch.js?locale=en","startTime":175.09999990463257,"connectEnd":175.09999990463257,"connectStart":175.09999990463257,"domainLookupEnd":175.09999990463257,"domainLookupStart":175.09999990463257,"fetchStart":175.09999990463257,"redirectEnd":0,"redirectStart":0,"requestStart":175.09999990463257,"responseEnd":234.59999990463257,"responseStart":234.59999990463257,"secureConnectionStart":175.09999990463257},{"duration":134.59999990463257,"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":175.2999997138977,"connectEnd":175.2999997138977,"connectStart":175.2999997138977,"domainLookupEnd":175.2999997138977,"domainLookupStart":175.2999997138977,"fetchStart":175.2999997138977,"redirectEnd":0,"redirectStart":0,"requestStart":175.2999997138977,"responseEnd":309.8999996185303,"responseStart":309.7999997138977,"secureConnectionStart":175.2999997138977},{"duration":138.5,"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":175.39999961853027,"connectEnd":175.39999961853027,"connectStart":175.39999961853027,"domainLookupEnd":175.39999961853027,"domainLookupStart":175.39999961853027,"fetchStart":175.39999961853027,"redirectEnd":0,"redirectStart":0,"requestStart":175.39999961853027,"responseEnd":313.8999996185303,"responseStart":313.8999996185303,"secureConnectionStart":175.39999961853027},{"duration":138.69999980926514,"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":175.59999990463257,"connectEnd":175.59999990463257,"connectStart":175.59999990463257,"domainLookupEnd":175.59999990463257,"domainLookupStart":175.59999990463257,"fetchStart":175.59999990463257,"redirectEnd":0,"redirectStart":0,"requestStart":175.59999990463257,"responseEnd":314.2999997138977,"responseStart":314.2999997138977,"secureConnectionStart":175.59999990463257},{"duration":138.80000019073486,"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":175.7999997138977,"connectEnd":175.7999997138977,"connectStart":175.7999997138977,"domainLookupEnd":175.7999997138977,"domainLookupStart":175.7999997138977,"fetchStart":175.7999997138977,"redirectEnd":0,"redirectStart":0,"requestStart":175.7999997138977,"responseEnd":314.59999990463257,"responseStart":314.59999990463257,"secureConnectionStart":175.7999997138977},{"duration":201,"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":176,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":176,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":377,"responseStart":0,"secureConnectionStart":0},{"duration":139,"initiatorType":"script","name":"https://jira.mariadb.org/rest/api/1.0/shortcuts/820016/47140b6e0a9bc2e4913da06536125810/shortcuts.js?context=issuenavigation&context=issueaction","startTime":176.09999990463257,"connectEnd":176.09999990463257,"connectStart":176.09999990463257,"domainLookupEnd":176.09999990463257,"domainLookupStart":176.09999990463257,"fetchStart":176.09999990463257,"redirectEnd":0,"redirectStart":0,"requestStart":176.09999990463257,"responseEnd":315.09999990463257,"responseStart":315.09999990463257,"secureConnectionStart":176.09999990463257},{"duration":200.90000009536743,"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":176.2999997138977,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":176.2999997138977,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":377.19999980926514,"responseStart":0,"secureConnectionStart":0},{"duration":139.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":176.5,"connectEnd":176.5,"connectStart":176.5,"domainLookupEnd":176.5,"domainLookupStart":176.5,"fetchStart":176.5,"redirectEnd":0,"redirectStart":0,"requestStart":176.5,"responseEnd":315.59999990463257,"responseStart":315.59999990463257,"secureConnectionStart":176.5},{"duration":279.40000009536743,"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":177.2999997138977,"connectEnd":177.2999997138977,"connectStart":177.2999997138977,"domainLookupEnd":177.2999997138977,"domainLookupStart":177.2999997138977,"fetchStart":177.2999997138977,"redirectEnd":0,"redirectStart":0,"requestStart":177.2999997138977,"responseEnd":456.69999980926514,"responseStart":456.69999980926514,"secureConnectionStart":177.2999997138977},{"duration":521.5,"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":177.39999961853027,"connectEnd":177.39999961853027,"connectStart":177.39999961853027,"domainLookupEnd":177.39999961853027,"domainLookupStart":177.39999961853027,"fetchStart":177.39999961853027,"redirectEnd":0,"redirectStart":0,"requestStart":177.39999961853027,"responseEnd":698.8999996185303,"responseStart":698.8999996185303,"secureConnectionStart":177.39999961853027},{"duration":134.80000019073486,"initiatorType":"xmlhttprequest","name":"https://jira.mariadb.org/rest/webResources/1.0/resources","startTime":388.7999997138977,"connectEnd":388.7999997138977,"connectStart":388.7999997138977,"domainLookupEnd":388.7999997138977,"domainLookupStart":388.7999997138977,"fetchStart":388.7999997138977,"redirectEnd":0,"redirectStart":0,"requestStart":388.7999997138977,"responseEnd":523.5999999046326,"responseStart":523.5999999046326,"secureConnectionStart":388.7999997138977},{"duration":51.59999990463257,"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":662.6999998092651,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":662.6999998092651,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":714.2999997138977,"responseStart":0,"secureConnectionStart":0},{"duration":50.90000009536743,"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","startTime":663.6999998092651,"connectEnd":663.6999998092651,"connectStart":663.6999998092651,"domainLookupEnd":663.6999998092651,"domainLookupStart":663.6999998092651,"fetchStart":663.6999998092651,"redirectEnd":0,"redirectStart":0,"requestStart":663.6999998092651,"responseEnd":714.5999999046326,"responseStart":714.5999999046326,"secureConnectionStart":663.6999998092651},{"duration":55.59999990463257,"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","startTime":664,"connectEnd":664,"connectStart":664,"domainLookupEnd":664,"domainLookupStart":664,"fetchStart":664,"redirectEnd":0,"redirectStart":0,"requestStart":664,"responseEnd":719.5999999046326,"responseStart":719.5999999046326,"secureConnectionStart":664},{"duration":170,"initiatorType":"script","name":"https://www.google-analytics.com/analytics.js","startTime":702.2999997138977,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":702.2999997138977,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":872.2999997138977,"responseStart":0,"secureConnectionStart":0}],"fetchStart":0,"domainLookupStart":0,"domainLookupEnd":0,"connectStart":0,"connectEnd":0,"requestStart":7,"responseStart":168,"responseEnd":173,"domLoading":172,"domInteractive":905,"domContentLoadedEventStart":905,"domContentLoadedEventEnd":948,"domComplete":1156,"loadEventStart":1156,"loadEventEnd":1157,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[{"name":"bigPipe.sidebar-id.start","time":874.0999999046326},{"name":"bigPipe.sidebar-id.end","time":874.7999997138977},{"name":"bigPipe.activity-panel-pipe-id.start","time":874.8999996185303},{"name":"bigPipe.activity-panel-pipe-id.end","time":875.8999996185303},{"name":"activityTabFullyLoaded","time":965}],"measures":[],"correlationId":"3470b490eef798","effectiveType":"4g","downlink":9.2,"rtt":0,"serverDuration":96,"dbReadsTimeInMs":11,"dbConnsTimeInMs":18,"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;