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":837.7999999523163,"ttfb":136.69999992847443,"pageVisibility":"visible","entityId":23146,"key":"jira.project.issue.view-issue","isInitial":true,"threshold":1000,"elementTimings":{},"userDeviceMemory":8,"userDeviceProcessors":64,"apdex":1,"journeyId":"14982384-6764-4e48-8658-caed82575603","navigationType":0,"readyForUser":899.2999999523163,"redirectCount":0,"resourceLoadedEnd":1127.7999999523163,"resourceLoadedStart":142.5,"resourceTiming":[{"duration":275.5,"initiatorType":"link","name":"https://jira.mariadb.org/s/2c21342762a6a02add1c328bed317ffd-CDN/lu2bu7/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/css/_super/batch.css","startTime":142.5,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":142.5,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":418,"responseStart":0,"secureConnectionStart":0},{"duration":275.2000000476837,"initiatorType":"link","name":"https://jira.mariadb.org/s/7ebd35e77e471bc30ff0eba799ebc151-CDN/lu2bu7/820016/12ta74/8679b4946efa1a0bb029a3a22206fb5d/_/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":142.79999995231628,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":142.79999995231628,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":418,"responseStart":0,"secureConnectionStart":0},{"duration":284.6999999284744,"initiatorType":"script","name":"https://jira.mariadb.org/s/fbf975c0cce4b1abf04784eeae9ba1f4-CDN/lu2bu7/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/js/_super/batch.js?locale=en","startTime":142.89999997615814,"connectEnd":142.89999997615814,"connectStart":142.89999997615814,"domainLookupEnd":142.89999997615814,"domainLookupStart":142.89999997615814,"fetchStart":142.89999997615814,"redirectEnd":0,"redirectStart":0,"requestStart":142.89999997615814,"responseEnd":427.59999990463257,"responseStart":427.59999990463257,"secureConnectionStart":142.89999997615814},{"duration":310.3000000715256,"initiatorType":"script","name":"https://jira.mariadb.org/s/099b33461394b8015fc36c0a4b96e19f-CDN/lu2bu7/820016/12ta74/8679b4946efa1a0bb029a3a22206fb5d/_/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":143.09999990463257,"connectEnd":143.09999990463257,"connectStart":143.09999990463257,"domainLookupEnd":143.09999990463257,"domainLookupStart":143.09999990463257,"fetchStart":143.09999990463257,"redirectEnd":0,"redirectStart":0,"requestStart":143.09999990463257,"responseEnd":453.39999997615814,"responseStart":453.39999997615814,"secureConnectionStart":143.09999990463257},{"duration":313.8000000715256,"initiatorType":"script","name":"https://jira.mariadb.org/s/94c15bff32baef80f4096a08aceae8bc-CDN/lu2bu7/820016/12ta74/c92c0caa9a024ae85b0ebdbed7fb4bd7/_/download/contextbatch/js/atl.global,-_super/batch.js?locale=en","startTime":143.19999992847443,"connectEnd":143.19999992847443,"connectStart":143.19999992847443,"domainLookupEnd":143.19999992847443,"domainLookupStart":143.19999992847443,"fetchStart":143.19999992847443,"redirectEnd":0,"redirectStart":0,"requestStart":143.19999992847443,"responseEnd":457,"responseStart":457,"secureConnectionStart":143.19999992847443},{"duration":314.3000000715256,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2bu7/820016/12ta74/1.0/_/download/batch/jira.webresources:calendar-en/jira.webresources:calendar-en.js","startTime":143.19999992847443,"connectEnd":143.19999992847443,"connectStart":143.19999992847443,"domainLookupEnd":143.19999992847443,"domainLookupStart":143.19999992847443,"fetchStart":143.19999992847443,"redirectEnd":0,"redirectStart":0,"requestStart":143.19999992847443,"responseEnd":457.5,"responseStart":457.5,"secureConnectionStart":143.19999992847443},{"duration":314.60000002384186,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2bu7/820016/12ta74/1.0/_/download/batch/jira.webresources:calendar-localisation-moment/jira.webresources:calendar-localisation-moment.js","startTime":143.29999995231628,"connectEnd":143.29999995231628,"connectStart":143.29999995231628,"domainLookupEnd":143.29999995231628,"domainLookupStart":143.29999995231628,"fetchStart":143.29999995231628,"redirectEnd":0,"redirectStart":0,"requestStart":143.29999995231628,"responseEnd":457.89999997615814,"responseStart":457.89999997615814,"secureConnectionStart":143.29999995231628},{"duration":315.2999999523163,"initiatorType":"link","name":"https://jira.mariadb.org/s/b04b06a02d1959df322d9cded3aeecc1-CDN/lu2bu7/820016/12ta74/a2ff6aa845ffc9a1d22fe23d9ee791fc/_/download/contextbatch/css/jira.global.look-and-feel,-_super/batch.css","startTime":143.39999997615814,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":143.39999997615814,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":458.6999999284744,"responseStart":0,"secureConnectionStart":0},{"duration":315.1999999284744,"initiatorType":"script","name":"https://jira.mariadb.org/rest/api/1.0/shortcuts/820016/47140b6e0a9bc2e4913da06536125810/shortcuts.js?context=issuenavigation&context=issueaction","startTime":143.5,"connectEnd":143.5,"connectStart":143.5,"domainLookupEnd":143.5,"domainLookupStart":143.5,"fetchStart":143.5,"redirectEnd":0,"redirectStart":0,"requestStart":143.5,"responseEnd":458.6999999284744,"responseStart":458.6999999284744,"secureConnectionStart":143.5},{"duration":315.90000009536743,"initiatorType":"link","name":"https://jira.mariadb.org/s/3ac36323ba5e4eb0af2aa7ac7211b4bb-CDN/lu2bu7/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":143.59999990463257,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":143.59999990463257,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":459.5,"responseStart":0,"secureConnectionStart":0},{"duration":315.7999999523163,"initiatorType":"script","name":"https://jira.mariadb.org/s/3339d87fa2538a859872f2df449bf8d0-CDN/lu2bu7/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":143.79999995231628,"connectEnd":143.79999995231628,"connectStart":143.79999995231628,"domainLookupEnd":143.79999995231628,"domainLookupStart":143.79999995231628,"fetchStart":143.79999995231628,"redirectEnd":0,"redirectStart":0,"requestStart":143.79999995231628,"responseEnd":459.59999990463257,"responseStart":459.59999990463257,"secureConnectionStart":143.79999995231628},{"duration":590.5,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2bu7/820016/12ta74/1.0/_/download/batch/jira.webresources:bigpipe-js/jira.webresources:bigpipe-js.js","startTime":144.29999995231628,"connectEnd":144.29999995231628,"connectStart":144.29999995231628,"domainLookupEnd":144.29999995231628,"domainLookupStart":144.29999995231628,"fetchStart":144.29999995231628,"redirectEnd":0,"redirectStart":0,"requestStart":144.29999995231628,"responseEnd":734.7999999523163,"responseStart":734.7999999523163,"secureConnectionStart":144.29999995231628},{"duration":978.7999999523163,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2bu7/820016/12ta74/1.0/_/download/batch/jira.webresources:bigpipe-init/jira.webresources:bigpipe-init.js","startTime":149,"connectEnd":149,"connectStart":149,"domainLookupEnd":149,"domainLookupStart":149,"fetchStart":149,"redirectEnd":0,"redirectStart":0,"requestStart":149,"responseEnd":1127.7999999523163,"responseStart":1127.7999999523163,"secureConnectionStart":149},{"duration":322.8000000715256,"initiatorType":"xmlhttprequest","name":"https://jira.mariadb.org/rest/webResources/1.0/resources","startTime":642.0999999046326,"connectEnd":642.0999999046326,"connectStart":642.0999999046326,"domainLookupEnd":642.0999999046326,"domainLookupStart":642.0999999046326,"fetchStart":642.0999999046326,"redirectEnd":0,"redirectStart":0,"requestStart":642.0999999046326,"responseEnd":964.8999999761581,"responseStart":964.8999999761581,"secureConnectionStart":642.0999999046326}],"fetchStart":0,"domainLookupStart":0,"domainLookupEnd":0,"connectStart":0,"connectEnd":0,"requestStart":4,"responseStart":136,"responseEnd":142,"domLoading":140,"domInteractive":1144,"domContentLoadedEventStart":1144,"domContentLoadedEventEnd":1180,"domComplete":2108,"loadEventStart":2108,"loadEventEnd":2110,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[{"name":"bigPipe.sidebar-id.start","time":1132},{"name":"bigPipe.sidebar-id.end","time":1132.8999999761581},{"name":"bigPipe.activity-panel-pipe-id.start","time":1133},{"name":"bigPipe.activity-panel-pipe-id.end","time":1135.2999999523163},{"name":"activityTabFullyLoaded","time":1187.2999999523163}],"measures":[],"correlationId":"c74469b110315f","effectiveType":"4g","downlink":10,"rtt":0,"serverDuration":71,"dbReadsTimeInMs":15,"dbConnsTimeInMs":22,"applicationHash":"9d11dbea5f4be3d4cc21f03a88dd11d8c8687422","experiments":[]}}