mysqld: maria-5.5-galera/sql/sql_base.cc:9451: void tdc_remove_table(THD*, enum_tdc_remove_table_type, const char*, c
|
onst char*, bool): Assertion `0' failed.
|
[ERROR] mysqld got signal 6 ;
|
#6 0x00007f24f0577d4d in __GI___assert_fail (assertion=0xd58a10 "0", file=<optimized out>, line=9451, function=<optimized out>) at assert.c:81
|
#7 0x00000000005c736c in tdc_remove_table (thd=0x3b95dd0, remove_type=TDC_RT_REMOVE_NOT_OWN, db=0x394e8f8 "test", table_name=0x394e8fd "B", has_lock=false) at maria-5.5-galera/sql/sql_base.cc:9451
|
#8 0x00000000005b842c in wait_while_table_is_used (thd=0x3b95dd0, table=0x3993c00, function=HA_EXTRA_FORCE_REOPEN) at maria-5.5-galera/sql/sql_base.cc:2353
|
#9 0x00000000006c548f in mysql_create_or_drop_trigger (thd=0x3b95dd0, tables=0x3ba3b58, create=true) at maria-5.5-galera/sql/sql_trigger.cc:540
|
#10 0x000000000062086d in mysql_execute_command (thd=0x3b95dd0) at maria-5.5-galera/sql/sql_parse.cc:4688
|
#11 0x0000000000625224 in mysql_parse (thd=0x3b95dd0, rawbuf=0x3ba39a8 "CREATE TRIGGER c AFTER INSERT ON `B` FOR EACH ROW BEGIN DELETE FROM `D` LIMIT 1 ; END", length=85, parser_state=0x7f24c1617550) at maria-5.5-galera/sql/sql_parse.cc:6305
|
#12 0x00000000006242ea in wsrep_mysql_parse (thd=0x3b95dd0, rawbuf=0x3ba39a8 "CREATE TRIGGER c AFTER INSERT ON `B` FOR EACH ROW BEGIN DELETE FROM `D` LIMIT 1 ; END", length=85, parser_state=0x7f24c1617550) at maria-5.5-galera/sql/sql_parse.cc:6070
|
#13 0x00000000006167b9 in dispatch_command (command=COM_QUERY, thd=0x3b95dd0, packet=0x3b9b291 "CREATE TRIGGER c AFTER INSERT ON `B` FOR EACH ROW BEGIN DELETE FROM `D` LIMIT 1 ; END", packet_length=85) at maria-5.5-galera/sql/sql_parse.cc:1245
|
#14 0x0000000000615598 in do_command (thd=0x3b95dd0) at maria-5.5-galera/sql/sql_parse.cc:891
|
#15 0x000000000071e143 in do_handle_one_connection (thd_arg=0x3b95dd0) at maria-5.5-galera/sql/sql_connect.cc:1291
|
#16 0x000000000071db1b in handle_one_connection (arg=0x3b95dd0) at maria-5.5-galera/sql/sql_connect.cc:1199
|
#17 0x00007f24f0e7eefc in start_thread (arg=0x7f24c1618700) at pthread_create.c:304
|
#18 0x00007f24f062df4d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:112
|
Trying to get some variables.
|
Some pointers may be invalid and cause the dump to abort.
|
Query (0x3ba39a8): CREATE TRIGGER c AFTER INSERT ON `B` FOR EACH ROW BEGIN DELETE FROM `D` LIMIT 1 ; END
|
Connection ID (thread ID): 9
|
Status: NOT_KILLED
|
I run a single Galera node, server command line:
$HOME/maria-5.5-galera/sql/mysqld --no-defaults --basedir=$HOME/maria-5.5-galera --lc-messages-dir=$HOME/maria-5.5-galera/sql/share/ --core --datadir=$HOME/maria-5.5-galera/data1 --tmpdir=$HOME/maria-5.5-galera/data1/tmp --port=8306 --socket=$HOME/maria-5.5-galera/data1/tmp/node1.sock --wsrep-provider=$HOME/galera/libgalera_smm.so --wsrep-cluster-address=gcomm:// --binlog-format=row --wsrep-sst-method=rsync --log-error=$HOME/maria-5.5-galera/data1/log.err --innodb_autoinc_lock_mode=2 --innodb_locks_unsafe_for_binlog=1
|
RQG grammar (assertion0.yy):
query:
|
binlog_event | binlog_event | binlog_event | binlog_event | binlog_event |
|
binlog_event | binlog_event | binlog_event | binlog_event | binlog_event |
|
binlog_event | binlog_event | binlog_event | binlog_event | binlog_event |
|
binlog_event | binlog_event | binlog_event | binlog_event | binlog_event | trigger ;
|
|
binlog_event:
|
delete | insert | trx | FLUSH LOGS ;
|
|
trx:
|
SAVEPOINT A | ROLLBACK TO SAVEPOINT A | RELEASE SAVEPOINT A | SET AUTOCOMMIT = OFF ;
|
|
insert:
|
INSERT INTO _table ( _field ) VALUES ( NULL ) ;
|
|
delete:
|
DELETE FROM _table LIMIT 1 ;
|
|
trigger:
|
CREATE TRIGGER _letter trigger_time trigger_event ON _table FOR EACH ROW BEGIN procedure_body ; END ;
|
|
trigger_time:
|
BEFORE | AFTER ;
|
|
trigger_event:
|
INSERT | UPDATE ;
|
|
procedure_body:
|
delete | insert ;
|
RQG command line:
perl ./gentest.pl --dsn=dbi:mysql:host=127.0.0.1:port=8306:user=root:database=test --duration=300 --queries=100M --engine=InnoDB --grammar=assertion0.yy --gendata --threads=4
|
Sometimes server crashes with an InnoDB mutex problem before it hits the assertion failure, just try again then.
{"report":{"fcp":822.1000003814697,"ttfb":234.5,"pageVisibility":"visible","entityId":23146,"key":"jira.project.issue.view-issue","isInitial":true,"threshold":1000,"elementTimings":{},"userDeviceMemory":8,"userDeviceProcessors":64,"apdex":1,"journeyId":"a0c0a5f6-34d9-4609-9b9a-ce6dba594830","navigationType":0,"readyForUser":902.5,"redirectCount":0,"resourceLoadedEnd":1339.3000001907349,"resourceLoadedStart":240.60000038146973,"resourceTiming":[{"duration":7.899999618530273,"initiatorType":"link","name":"https://jira.mariadb.org/s/2c21342762a6a02add1c328bed317ffd-CDN/lu2cib/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/css/_super/batch.css","startTime":240.60000038146973,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":240.60000038146973,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":248.5,"responseStart":0,"secureConnectionStart":0},{"duration":13.199999809265137,"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":240.80000019073486,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":240.80000019073486,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":254,"responseStart":0,"secureConnectionStart":0},{"duration":89.89999961853027,"initiatorType":"script","name":"https://jira.mariadb.org/s/0917945aaa57108d00c5076fea35e069-CDN/lu2cib/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/js/_super/batch.js?locale=en","startTime":241,"connectEnd":241,"connectStart":241,"domainLookupEnd":241,"domainLookupStart":241,"fetchStart":241,"redirectEnd":0,"redirectStart":0,"requestStart":241,"responseEnd":330.8999996185303,"responseStart":330.8999996185303,"secureConnectionStart":241},{"duration":134.4000005722046,"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":241.19999980926514,"connectEnd":241.19999980926514,"connectStart":241.19999980926514,"domainLookupEnd":241.19999980926514,"domainLookupStart":241.19999980926514,"fetchStart":241.19999980926514,"redirectEnd":0,"redirectStart":0,"requestStart":241.19999980926514,"responseEnd":375.6000003814697,"responseStart":375.6000003814697,"secureConnectionStart":241.19999980926514},{"duration":138.30000019073486,"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":241.39999961853027,"connectEnd":241.39999961853027,"connectStart":241.39999961853027,"domainLookupEnd":241.39999961853027,"domainLookupStart":241.39999961853027,"fetchStart":241.39999961853027,"redirectEnd":0,"redirectStart":0,"requestStart":241.39999961853027,"responseEnd":379.69999980926514,"responseStart":379.69999980926514,"secureConnectionStart":241.39999961853027},{"duration":138.5999994277954,"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":241.60000038146973,"connectEnd":241.60000038146973,"connectStart":241.60000038146973,"domainLookupEnd":241.60000038146973,"domainLookupStart":241.60000038146973,"fetchStart":241.60000038146973,"redirectEnd":0,"redirectStart":0,"requestStart":241.60000038146973,"responseEnd":380.19999980926514,"responseStart":380.19999980926514,"secureConnectionStart":241.60000038146973},{"duration":139,"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":241.80000019073486,"connectEnd":241.80000019073486,"connectStart":241.80000019073486,"domainLookupEnd":241.80000019073486,"domainLookupStart":241.80000019073486,"fetchStart":241.80000019073486,"redirectEnd":0,"redirectStart":0,"requestStart":241.80000019073486,"responseEnd":380.80000019073486,"responseStart":380.69999980926514,"secureConnectionStart":241.80000019073486},{"duration":240.19999980926514,"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":242,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":242,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":482.19999980926514,"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":242.19999980926514,"connectEnd":242.19999980926514,"connectStart":242.19999980926514,"domainLookupEnd":242.19999980926514,"domainLookupStart":242.19999980926514,"fetchStart":242.19999980926514,"redirectEnd":0,"redirectStart":0,"requestStart":242.19999980926514,"responseEnd":381.19999980926514,"responseStart":381.19999980926514,"secureConnectionStart":242.19999980926514},{"duration":240,"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":242.30000019073486,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":242.30000019073486,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":482.30000019073486,"responseStart":0,"secureConnectionStart":0},{"duration":139.19999980926514,"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":242.5,"connectEnd":242.5,"connectStart":242.5,"domainLookupEnd":242.5,"domainLookupStart":242.5,"fetchStart":242.5,"redirectEnd":0,"redirectStart":0,"requestStart":242.5,"responseEnd":381.69999980926514,"responseStart":381.69999980926514,"secureConnectionStart":242.5},{"duration":867.6000003814697,"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":243.5,"connectEnd":243.5,"connectStart":243.5,"domainLookupEnd":243.5,"domainLookupStart":243.5,"fetchStart":243.5,"redirectEnd":0,"redirectStart":0,"requestStart":243.5,"responseEnd":1111.1000003814697,"responseStart":1111.1000003814697,"secureConnectionStart":243.5},{"duration":1095.6999998092651,"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":243.60000038146973,"connectEnd":243.60000038146973,"connectStart":243.60000038146973,"domainLookupEnd":243.60000038146973,"domainLookupStart":243.60000038146973,"fetchStart":243.60000038146973,"redirectEnd":0,"redirectStart":0,"requestStart":243.60000038146973,"responseEnd":1339.3000001907349,"responseStart":1339.3000001907349,"secureConnectionStart":243.60000038146973},{"duration":610.8999996185303,"initiatorType":"xmlhttprequest","name":"https://jira.mariadb.org/rest/webResources/1.0/resources","startTime":500.80000019073486,"connectEnd":500.80000019073486,"connectStart":500.80000019073486,"domainLookupEnd":500.80000019073486,"domainLookupStart":500.80000019073486,"fetchStart":500.80000019073486,"redirectEnd":0,"redirectStart":0,"requestStart":500.80000019073486,"responseEnd":1111.6999998092651,"responseStart":1111.6999998092651,"secureConnectionStart":500.80000019073486},{"duration":534.6999998092651,"initiatorType":"script","name":"https://www.google-analytics.com/analytics.js","startTime":808.1999998092651,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":808.1999998092651,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":1342.8999996185303,"responseStart":0,"secureConnectionStart":0},{"duration":295.5999994277954,"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":1122.8000001907349,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":1122.8000001907349,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":1418.3999996185303,"responseStart":0,"secureConnectionStart":0},{"duration":289.4000005722046,"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":1123.8999996185303,"connectEnd":1123.8999996185303,"connectStart":1123.8999996185303,"domainLookupEnd":1123.8999996185303,"domainLookupStart":1123.8999996185303,"fetchStart":1123.8999996185303,"redirectEnd":0,"redirectStart":0,"requestStart":1123.8999996185303,"responseEnd":1413.3000001907349,"responseStart":1413.3000001907349,"secureConnectionStart":1123.8999996185303}],"fetchStart":0,"domainLookupStart":0,"domainLookupEnd":0,"connectStart":0,"connectEnd":0,"requestStart":66,"responseStart":234,"responseEnd":238,"domLoading":238,"domInteractive":1367,"domContentLoadedEventStart":1367,"domContentLoadedEventEnd":1418,"domComplete":2985,"loadEventStart":2986,"loadEventEnd":2987,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[{"name":"bigPipe.sidebar-id.start","time":1343.8999996185303},{"name":"bigPipe.sidebar-id.end","time":1345.8999996185303},{"name":"bigPipe.activity-panel-pipe-id.start","time":1346},{"name":"bigPipe.activity-panel-pipe-id.end","time":1348.8000001907349},{"name":"activityTabFullyLoaded","time":1424.8999996185303}],"measures":[],"correlationId":"eef26ec7bea9f2","effectiveType":"4g","downlink":9.9,"rtt":0,"serverDuration":96,"dbReadsTimeInMs":10,"dbConnsTimeInMs":20,"applicationHash":"9d11dbea5f4be3d4cc21f03a88dd11d8c8687422","experiments":[]}}