$ mysql-test/mtr --port-base=8000 partition_locking
|
Logging: /home/dan/repos/mariadb-server-10.2/mysql-test/mysql-test-run.pl --port-base=8000 partition_locking
|
vardir: /home/dan/repos/build-mariadb-server-10.2/mysql-test/var
|
Checking leftover processes...
|
Removing old var directory...
|
Creating var directory '/home/dan/repos/build-mariadb-server-10.2/mysql-test/var'...
|
Checking supported features...
|
MariaDB Version 10.2.38-MariaDB
|
- SSL connections supported
|
- binaries built with wsrep patch
|
Collecting tests...
|
Installing system database...
|
|
==============================================================================
|
|
TEST RESULT TIME (ms) or COMMENT
|
--------------------------------------------------------------------------
|
|
worker[1] Using MTR_BUILD_THREAD -200, with reserved ports 6000..6019
|
set @start_read_only= @@global.read_only;
|
set @start_autocommit= @@global.autocommit;
|
set @@global.autocommit= 0;
|
CREATE USER test@localhost;
|
grant CREATE, SELECT, UPDATE on *.* to test@localhost;
|
CREATE USER test2@localhost;
|
grant CREATE, SELECT, UPDATE on *.* to test2@localhost;
|
connection default;
|
CREATE TABLE t1 (
|
a char(2) NOT NULL,
|
b char(2) NOT NULL,
|
c int(10) unsigned NOT NULL,
|
d varchar(255) DEFAULT NULL,
|
e varchar(1000) DEFAULT NULL,
|
PRIMARY KEY (a, b, c),
|
KEY (a),
|
KEY (a, b)
|
) charset latin1 PARTITION BY KEY (a) PARTITIONS 20;
|
INSERT INTO t1 (a, b, c, d, e) VALUES
|
('07', '03', 343, '1', '07_03_343'),
|
('01', '04', 343, '2', '01_04_343'),
|
('01', '06', 343, '3', '01_06_343'),
|
('01', '07', 343, '4', '01_07_343'),
|
('01', '08', 343, '5', '01_08_343'),
|
('01', '09', 343, '6', '01_09_343'),
|
('03', '03', 343, '7', '03_03_343'),
|
('03', '06', 343, '8', '03_06_343'),
|
('03', '07', 343, '9', '03_07_343'),
|
('04', '03', 343, '10', '04_03_343'),
|
('04', '06', 343, '11', '04_06_343'),
|
('05', '03', 343, '12', '05_03_343'),
|
('11', '03', 343, '13', '11_03_343'),
|
('11', '04', 343, '14', '11_04_343')
|
;
|
CREATE TABLE t2 (a int, name VARCHAR(50), purchased DATE)
|
PARTITION BY RANGE (a)
|
(PARTITION p0 VALUES LESS THAN (3),
|
PARTITION p1 VALUES LESS THAN (7),
|
PARTITION p2 VALUES LESS THAN (9),
|
PARTITION p3 VALUES LESS THAN (11));
|
INSERT INTO t2 VALUES
|
(1, 'desk organiser', '2003-10-15'),
|
(2, 'CD player', '1993-11-05'),
|
(3, 'TV set', '1996-03-10'),
|
(4, 'bookcase', '1982-01-10'),
|
(5, 'exercise bike', '2004-05-09'),
|
(6, 'sofa', '1987-06-05'),
|
(7, 'popcorn maker', '2001-11-22'),
|
(8, 'acquarium', '1992-08-04'),
|
(9, 'study desk', '1984-09-16'),
|
(10, 'lava lamp', '1998-12-25');
|
CREATE TABLE t3 SELECT * FROM t1;
|
ALTER TABLE t3 ADD PRIMARY KEY (d);
|
ALTER TABLE t3 ADD KEY (a);
|
ALTER TABLE t3 ADD KEY (a, b);
|
ANALYZE TABLE t3;
|
Table Op Msg_type Msg_text
|
test.t3 analyze status OK
|
########################################################################
|
connect con1,localhost,test,,test;
|
BEGIN;
|
SELECT d,a,b,c FROM t1 partition (p0);
|
d a b c
|
SELECT d,a,b,c FROM t1 partition (p1);
|
d a b c
|
7 03 03 343
|
8 03 06 343
|
9 03 07 343
|
SELECT d,a,b,c FROM t1 partition (p2);
|
d a b c
|
SELECT d,a,b,c FROM t1 partition (p3);
|
d a b c
|
SELECT d,a,b,c FROM t1 partition (p4);
|
d a b c
|
SELECT d,a,b,c FROM t1 partition (p5);
|
d a b c
|
SELECT d,a,b,c FROM t1 partition (p6);
|
d a b c
|
SELECT d,a,b,c FROM t1 partition (p7);
|
d a b c
|
SELECT d,a,b,c FROM t1 partition (p8);
|
d a b c
|
SELECT d,a,b,c FROM t1 partition (p9);
|
d a b c
|
2 01 04 343
|
3 01 06 343
|
4 01 07 343
|
5 01 08 343
|
6 01 09 343
|
10 04 03 343
|
11 04 06 343
|
12 05 03 343
|
SELECT d,a,b,c FROM t1 partition (p10);
|
d a b c
|
SELECT d,a,b,c FROM t1 partition (p11);
|
d a b c
|
13 11 03 343
|
14 11 04 343
|
SELECT d,a,b,c FROM t1 partition (p12);
|
d a b c
|
SELECT d,a,b,c FROM t1 partition (p13);
|
d a b c
|
SELECT d,a,b,c FROM t1 partition (p14);
|
d a b c
|
SELECT d,a,b,c FROM t1 partition (p15);
|
d a b c
|
SELECT d,a,b,c FROM t1 partition (p16);
|
d a b c
|
SELECT d,a,b,c FROM t1 partition (p17);
|
d a b c
|
1 07 03 343
|
SELECT d,a,b,c FROM t1 partition (p18);
|
d a b c
|
SELECT d,a,b,c FROM t1 partition (p19);
|
d a b c
|
SELECT * FROM t1 WHERE a='01' FOR UPDATE ;
|
a b c d e
|
01 04 343 2 01_04_343
|
01 06 343 3 01_06_343
|
01 07 343 4 01_07_343
|
01 08 343 5 01_08_343
|
01 09 343 6 01_09_343
|
SELECT * FROM t3 FORCE INDEX(a) WHERE a='01' FOR UPDATE ;
|
a b c d e
|
01 04 343 2 01_04_343
|
01 06 343 3 01_06_343
|
01 07 343 4 01_07_343
|
01 08 343 5 01_08_343
|
01 09 343 6 01_09_343
|
connect con2,localhost,test,,test;
|
BEGIN;
|
SET SESSION innodb_lock_wait_timeout=1;
|
#
|
# SHARE ...
|
SELECT * FROM t1 LOCK IN SHARE MODE;
|
main.partition_locking 'innodb' [ fail ]
|
Test ended at 2021-03-25 16:59:50
|
|
CURRENT_TEST: main.partition_locking
|
mysqltest: At line 103: query 'SELECT * FROM t1 LOCK IN SHARE MODE' succeeded - should have failed with errno 1205...
|
Test largely based off https://github.com/mysql/mysql-server/blob/8.0/mysql-test/t/locking_part.test
Transition |
Time In Source Status |
Execution Times |
Open |
|
Closed |
|
3d 22h 44m
|
1
|
{"report":{"fcp":828.1999998092651,"ttfb":218.5,"pageVisibility":"visible","entityId":98255,"key":"jira.project.issue.view-issue","isInitial":true,"threshold":1000,"elementTimings":{},"userDeviceMemory":8,"userDeviceProcessors":64,"apdex":1,"journeyId":"bbf19f9f-db3f-4c43-bb6b-79d5da122c03","navigationType":0,"readyForUser":928.6999998092651,"redirectCount":0,"resourceLoadedEnd":872.6999998092651,"resourceLoadedStart":225,"resourceTiming":[{"duration":74.19999980926514,"initiatorType":"link","name":"https://jira.mariadb.org/s/2c21342762a6a02add1c328bed317ffd-CDN/lu2bsh/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/css/_super/batch.css","startTime":225,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":225,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":299.19999980926514,"responseStart":0,"secureConnectionStart":0},{"duration":74.80000019073486,"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":225.19999980926514,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":225.19999980926514,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":300,"responseStart":0,"secureConnectionStart":0},{"duration":134.19999980926514,"initiatorType":"script","name":"https://jira.mariadb.org/s/c54b129276d75dc2a3460e1d78f37913-CDN/lu2bsh/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/js/_super/batch.js?locale=en","startTime":225.40000009536743,"connectEnd":225.40000009536743,"connectStart":225.40000009536743,"domainLookupEnd":225.40000009536743,"domainLookupStart":225.40000009536743,"fetchStart":225.40000009536743,"redirectEnd":0,"redirectStart":0,"requestStart":225.40000009536743,"responseEnd":359.59999990463257,"responseStart":359.59999990463257,"secureConnectionStart":225.40000009536743},{"duration":197.09999990463257,"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":225.5,"connectEnd":225.5,"connectStart":225.5,"domainLookupEnd":225.5,"domainLookupStart":225.5,"fetchStart":225.5,"redirectEnd":0,"redirectStart":0,"requestStart":225.5,"responseEnd":422.59999990463257,"responseStart":422.59999990463257,"secureConnectionStart":225.5},{"duration":202,"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":225.59999990463257,"connectEnd":225.59999990463257,"connectStart":225.59999990463257,"domainLookupEnd":225.59999990463257,"domainLookupStart":225.59999990463257,"fetchStart":225.59999990463257,"redirectEnd":0,"redirectStart":0,"requestStart":225.59999990463257,"responseEnd":427.59999990463257,"responseStart":427.59999990463257,"secureConnectionStart":225.59999990463257},{"duration":203.59999990463257,"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":225.69999980926514,"connectEnd":225.69999980926514,"connectStart":225.69999980926514,"domainLookupEnd":225.69999980926514,"domainLookupStart":225.69999980926514,"fetchStart":225.69999980926514,"redirectEnd":0,"redirectStart":0,"requestStart":225.69999980926514,"responseEnd":429.2999997138977,"responseStart":429.2999997138977,"secureConnectionStart":225.69999980926514},{"duration":205.10000038146973,"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":225.7999997138977,"connectEnd":225.7999997138977,"connectStart":225.7999997138977,"domainLookupEnd":225.7999997138977,"domainLookupStart":225.7999997138977,"fetchStart":225.7999997138977,"redirectEnd":0,"redirectStart":0,"requestStart":225.7999997138977,"responseEnd":430.90000009536743,"responseStart":430.90000009536743,"secureConnectionStart":225.7999997138977},{"duration":207.09999990463257,"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":225.90000009536743,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":225.90000009536743,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":433,"responseStart":0,"secureConnectionStart":0},{"duration":206.59999990463257,"initiatorType":"script","name":"https://jira.mariadb.org/rest/api/1.0/shortcuts/820016/47140b6e0a9bc2e4913da06536125810/shortcuts.js?context=issuenavigation&context=issueaction","startTime":226,"connectEnd":226,"connectStart":226,"domainLookupEnd":226,"domainLookupStart":226,"fetchStart":226,"redirectEnd":0,"redirectStart":0,"requestStart":226,"responseEnd":432.59999990463257,"responseStart":432.5,"secureConnectionStart":226},{"duration":207.80000019073486,"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":226.09999990463257,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":226.09999990463257,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":433.90000009536743,"responseStart":0,"secureConnectionStart":0},{"duration":208,"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":226.09999990463257,"connectEnd":226.09999990463257,"connectStart":226.09999990463257,"domainLookupEnd":226.09999990463257,"domainLookupStart":226.09999990463257,"fetchStart":226.09999990463257,"redirectEnd":0,"redirectStart":0,"requestStart":226.09999990463257,"responseEnd":434.09999990463257,"responseStart":434.09999990463257,"secureConnectionStart":226.09999990463257},{"duration":393.80000019073486,"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":231.7999997138977,"connectEnd":231.7999997138977,"connectStart":231.7999997138977,"domainLookupEnd":231.7999997138977,"domainLookupStart":231.7999997138977,"fetchStart":231.7999997138977,"redirectEnd":0,"redirectStart":0,"requestStart":231.7999997138977,"responseEnd":625.5999999046326,"responseStart":625.5999999046326,"secureConnectionStart":231.7999997138977},{"duration":640.7999997138977,"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":231.90000009536743,"connectEnd":231.90000009536743,"connectStart":231.90000009536743,"domainLookupEnd":231.90000009536743,"domainLookupStart":231.90000009536743,"fetchStart":231.90000009536743,"redirectEnd":0,"redirectStart":0,"requestStart":231.90000009536743,"responseEnd":872.6999998092651,"responseStart":872.6999998092651,"secureConnectionStart":231.90000009536743},{"duration":225,"initiatorType":"xmlhttprequest","name":"https://jira.mariadb.org/rest/webResources/1.0/resources","startTime":576.5999999046326,"connectEnd":576.5999999046326,"connectStart":576.5999999046326,"domainLookupEnd":576.5999999046326,"domainLookupStart":576.5999999046326,"fetchStart":576.5999999046326,"redirectEnd":0,"redirectStart":0,"requestStart":576.5999999046326,"responseEnd":801.5999999046326,"responseStart":801.5,"secureConnectionStart":576.5999999046326}],"fetchStart":0,"domainLookupStart":0,"domainLookupEnd":0,"connectStart":0,"connectEnd":0,"requestStart":72,"responseStart":219,"responseEnd":231,"domLoading":222,"domInteractive":999,"domContentLoadedEventStart":999,"domContentLoadedEventEnd":1041,"domComplete":1364,"loadEventStart":1364,"loadEventEnd":1364,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[{"name":"bigPipe.sidebar-id.start","time":985.1999998092651},{"name":"bigPipe.sidebar-id.end","time":986},{"name":"bigPipe.activity-panel-pipe-id.start","time":986.1999998092651},{"name":"bigPipe.activity-panel-pipe-id.end","time":986.9000000953674},{"name":"activityTabFullyLoaded","time":1056.6999998092651}],"measures":[],"correlationId":"9e5de79477dce6","effectiveType":"4g","downlink":9.4,"rtt":0,"serverDuration":72,"dbReadsTimeInMs":12,"dbConnsTimeInMs":19,"applicationHash":"9d11dbea5f4be3d4cc21f03a88dd11d8c8687422","experiments":[]}}