- branch : bb-10.5-release
galera.galera_FK_duplicate_client_insert 'innodb' w2 [ retry-fail ]
|
Test ended at 2020-09-29 14:21:13
|
|
CURRENT_TEST: galera.galera_FK_duplicate_client_insert
|
mysqltest: At line 101: query 'commit' failed with wrong errno 2013: 'Lost connection to MySQL server during query', instead of 0...
|
|
The result from queries just before the failure was:
|
< snip >
|
connection node_1_u;
|
commit;
|
connection node_1;
|
truncate user_session;
|
set debug_sync = reset;
|
connection node_1_u;
|
begin;
|
update user set j = j + 1 WHERE id > 0;
|
connection node_1_i;
|
set debug_sync='lock_wait_suspend_thread_enter SIGNAL ins_waiting WAIT_FOR cont_ins';
|
insert into user_session(id,fk1,fk2) values (2, 2, 2);
|
connection node_1;
|
set debug_sync='now WAIT_FOR ins_waiting';
|
connection node_2_i;
|
insert into user_session(id,fk1,fk2) values (2, 2, 3);
|
connection node_1;
|
set debug_sync='now SIGNAL cont_ins';
|
connection node_1_i;
|
connection node_1_u;
|
commit;
|
|
More results from queries before failure can be found in /dev/shm/var/2/log/galera_FK_duplicate_client_insert.log
|
|
|
Server [mysqld.1 - pid: 6884, winpid: 6884, exit: 256] failed during test run
|
Server log from this test:
|
----------SERVER LOG START-----------
|
2020-09-29 14:20:57 1 [ERROR] InnoDB: Conflicting lock on table: `test`.`user` index: PRIMARY that has lock
|
RECORD LOCKS space id 35 page no 3 n bits 72 index PRIMARY of table `test`.`user` trx id 369 lock mode S locks rec but not gap
|
Record lock, heap no 3 PHYSICAL RECORD: n_fields 4; compact format; info bits 0
|
0: len 4; hex 80000002; asc ;;
|
1: len 6; hex 000000000000; asc ;;
|
2: len 7; hex 80000000000000; asc ;;
|
3: len 4; hex 80000000; asc ;;
|
|
2020-09-29 14:20:57 1 [ERROR] InnoDB: WSREP state:
|
2020-09-29 14:20:57 1 [ERROR] WSREP: Thread BF trx_id: 372 thread: 1 seqno: 78 client_state: exec client_mode: high priority transaction_mode: replaying applier: 1 toi: 0 local: 0 query: update user set j = j + 1 WHERE id > 0�Bs_
|
2020-09-29 14:20:57 1 [ERROR] WSREP: Thread BF trx_id: 369 thread: 2 seqno: 77 client_state: exec client_mode: high priority transaction_mode: executing applier: 1 toi: 0 local: 0 query: insert into user_session(id,fk1,fk2) values (2, 2, 3)�Bs_
|
2020-09-29 14:20:57 0x7fbbf83b1700 InnoDB: Assertion failure in file /home/buildbot/buildbot/padding_for_CPACK_RPM_BUILD_SOURCE_DIRS_PREFIX/mariadb-10.5.6/storage/innobase/lock/lock0lock.cc line 655
|
{"report":{"fcp":821.8000001907349,"ttfb":200.20000076293945,"pageVisibility":"visible","entityId":92231,"key":"jira.project.issue.view-issue","isInitial":true,"threshold":1000,"elementTimings":{},"userDeviceMemory":8,"userDeviceProcessors":64,"apdex":1,"journeyId":"9ae38a7f-aea1-4813-bf8b-a04bf07d48e5","navigationType":0,"readyForUser":898.7000007629395,"redirectCount":0,"resourceLoadedEnd":930.7000007629395,"resourceLoadedStart":205.10000038146973,"resourceTiming":[{"duration":168.10000038146973,"initiatorType":"link","name":"https://jira.mariadb.org/s/2c21342762a6a02add1c328bed317ffd-CDN/lu2bu7/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/css/_super/batch.css","startTime":205.10000038146973,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":205.10000038146973,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":373.20000076293945,"responseStart":0,"secureConnectionStart":0},{"duration":167.9000005722046,"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":205.30000019073486,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":205.30000019073486,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":373.20000076293945,"responseStart":0,"secureConnectionStart":0},{"duration":177.5,"initiatorType":"script","name":"https://jira.mariadb.org/s/fbf975c0cce4b1abf04784eeae9ba1f4-CDN/lu2bu7/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/js/_super/batch.js?locale=en","startTime":205.4000005722046,"connectEnd":205.4000005722046,"connectStart":205.4000005722046,"domainLookupEnd":205.4000005722046,"domainLookupStart":205.4000005722046,"fetchStart":205.4000005722046,"redirectEnd":0,"redirectStart":0,"requestStart":205.4000005722046,"responseEnd":382.9000005722046,"responseStart":382.9000005722046,"secureConnectionStart":205.4000005722046},{"duration":202.5,"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":205.60000038146973,"connectEnd":205.60000038146973,"connectStart":205.60000038146973,"domainLookupEnd":205.60000038146973,"domainLookupStart":205.60000038146973,"fetchStart":205.60000038146973,"redirectEnd":0,"redirectStart":0,"requestStart":205.60000038146973,"responseEnd":408.1000003814697,"responseStart":408.1000003814697,"secureConnectionStart":205.60000038146973},{"duration":206.0999994277954,"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":205.70000076293945,"connectEnd":205.70000076293945,"connectStart":205.70000076293945,"domainLookupEnd":205.70000076293945,"domainLookupStart":205.70000076293945,"fetchStart":205.70000076293945,"redirectEnd":0,"redirectStart":0,"requestStart":205.70000076293945,"responseEnd":411.80000019073486,"responseStart":411.80000019073486,"secureConnectionStart":205.70000076293945},{"duration":206.89999961853027,"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":205.70000076293945,"connectEnd":205.70000076293945,"connectStart":205.70000076293945,"domainLookupEnd":205.70000076293945,"domainLookupStart":205.70000076293945,"fetchStart":205.70000076293945,"redirectEnd":0,"redirectStart":0,"requestStart":205.70000076293945,"responseEnd":412.6000003814697,"responseStart":412.6000003814697,"secureConnectionStart":205.70000076293945},{"duration":208.0999994277954,"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":205.9000005722046,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":205.9000005722046,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":414,"responseStart":0,"secureConnectionStart":0},{"duration":207.39999961853027,"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":205.9000005722046,"connectEnd":205.9000005722046,"connectStart":205.9000005722046,"domainLookupEnd":205.9000005722046,"domainLookupStart":205.9000005722046,"fetchStart":205.9000005722046,"redirectEnd":0,"redirectStart":0,"requestStart":205.9000005722046,"responseEnd":413.30000019073486,"responseStart":413.30000019073486,"secureConnectionStart":205.9000005722046},{"duration":207.9000005722046,"initiatorType":"script","name":"https://jira.mariadb.org/rest/api/1.0/shortcuts/820016/47140b6e0a9bc2e4913da06536125810/shortcuts.js?context=issuenavigation&context=issueaction","startTime":206,"connectEnd":206,"connectStart":206,"domainLookupEnd":206,"domainLookupStart":206,"fetchStart":206,"redirectEnd":0,"redirectStart":0,"requestStart":206,"responseEnd":413.9000005722046,"responseStart":413.9000005722046,"secureConnectionStart":206},{"duration":208.39999961853027,"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":206.20000076293945,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":206.20000076293945,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":414.6000003814697,"responseStart":0,"secureConnectionStart":0},{"duration":208.5,"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":206.30000019073486,"connectEnd":206.30000019073486,"connectStart":206.30000019073486,"domainLookupEnd":206.30000019073486,"domainLookupStart":206.30000019073486,"fetchStart":206.30000019073486,"redirectEnd":0,"redirectStart":0,"requestStart":206.30000019073486,"responseEnd":414.80000019073486,"responseStart":414.80000019073486,"secureConnectionStart":206.30000019073486},{"duration":352.3999996185303,"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":219.9000005722046,"connectEnd":219.9000005722046,"connectStart":219.9000005722046,"domainLookupEnd":219.9000005722046,"domainLookupStart":219.9000005722046,"fetchStart":219.9000005722046,"redirectEnd":0,"redirectStart":0,"requestStart":219.9000005722046,"responseEnd":572.3000001907349,"responseStart":572.3000001907349,"secureConnectionStart":219.9000005722046},{"duration":710.6000003814697,"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":220.10000038146973,"connectEnd":220.10000038146973,"connectStart":220.10000038146973,"domainLookupEnd":220.10000038146973,"domainLookupStart":220.10000038146973,"fetchStart":220.10000038146973,"redirectEnd":0,"redirectStart":0,"requestStart":220.10000038146973,"responseEnd":930.7000007629395,"responseStart":930.7000007629395,"secureConnectionStart":220.10000038146973},{"duration":317.79999923706055,"initiatorType":"xmlhttprequest","name":"https://jira.mariadb.org/rest/webResources/1.0/resources","startTime":612.2000007629395,"connectEnd":612.2000007629395,"connectStart":612.2000007629395,"domainLookupEnd":612.2000007629395,"domainLookupStart":612.2000007629395,"fetchStart":612.2000007629395,"redirectEnd":0,"redirectStart":0,"requestStart":612.2000007629395,"responseEnd":930,"responseStart":930,"secureConnectionStart":612.2000007629395},{"duration":145.70000076293945,"initiatorType":"script","name":"https://www.google-analytics.com/analytics.js","startTime":786.5,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":786.5,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":932.2000007629395,"responseStart":0,"secureConnectionStart":0}],"fetchStart":0,"domainLookupStart":0,"domainLookupEnd":0,"connectStart":0,"connectEnd":0,"requestStart":38,"responseStart":201,"responseEnd":220,"domLoading":204,"domInteractive":1013,"domContentLoadedEventStart":1013,"domContentLoadedEventEnd":1062,"domComplete":1368,"loadEventStart":1368,"loadEventEnd":1370,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[{"name":"bigPipe.sidebar-id.start","time":992.5},{"name":"bigPipe.sidebar-id.end","time":993.2000007629395},{"name":"bigPipe.activity-panel-pipe-id.start","time":993.3000001907349},{"name":"bigPipe.activity-panel-pipe-id.end","time":995.8000001907349},{"name":"activityTabFullyLoaded","time":1075.9000005722046}],"measures":[],"correlationId":"938aeaab3095d5","effectiveType":"4g","downlink":9.8,"rtt":0,"serverDuration":102,"dbReadsTimeInMs":38,"dbConnsTimeInMs":46,"applicationHash":"9d11dbea5f4be3d4cc21f03a88dd11d8c8687422","experiments":[]}}