[MDEV-27675] Index corruption / assertion failure in rtr_page_get_father_node_ptr with spatial key - Jira

Details

Type: Bug
Status: Confirmed (View Workflow)
Priority: Major
Resolution: Unresolved
Affects Version/s: 10.3(EOL), 10.4(EOL), 10.5, 10.6, 10.7(EOL), 10.8(EOL), 10.9(EOL), 10.10(EOL)
Fix Version/s: 10.5, 10.6, 10.11
Component/s: GIS, Storage Engine - InnoDB
Labels:
None

Description

--source include/have_innodb.inc

CREATE TABLE t (a TIME, b INT, c VARCHAR(2500), d MULTIPOLYGON NOT NULL, PRIMARY KEY (b,c,a), SPATIAL(d)) ENGINE=InnoDB;

INSERT INTO t (b,d,a,c) VALUES

(6,MULTIPOLYGONFromText('MULTIPOLYGON(((0.12 0.53,0.23 0.92,0.12 0.53)))'),'04:09:11','id'),

(2,MULTIPOLYGONFromText('MULTIPOLYGON(((0.09 0.71,0.92 0.49,0.09 0.71)))'),'22:10:53',REPEAT('s',853)),

(8,MULTIPOLYGONFromText('MULTIPOLYGON(((0.62 0.71,0.62 0.71)))'),'11:40:55',''),

(2,MULTIPOLYGONFromText('MULTIPOLYGON(((0.00 0.06,0.40 0.39,0.61 0.20,0.69 0.91,0.13 0.45,0.71 0.49,0.81 0.52,0.08 0.02,0.00 0.06)))'),'08:07:32','j'),

(5,MULTIPOLYGONFromText('MULTIPOLYGON(((0.05 0.20,0.45 0.96,0.59 0.46,0.26 0.12,0.45 0.68,0.41 0.10,0.05 0.20)))'),'00:22:08','b'),

(8,MULTIPOLYGONFromText('MULTIPOLYGON(((0.30 0.09,0.42 0.27,0.96 0.83,0.81 0.89,0.42 0.16,0.89 0.64,0.30 0.09)))'),'00:00:00','j'),

(6,MULTIPOLYGONFromText('MULTIPOLYGON(((0.62 0.42,0.12 0.70,0.07 0.24,0.10 0.07,0.92 0.29,0.20 0.52,0.62 0.42)))'),'10:10:27','f'),

(0,MULTIPOLYGONFromText('MULTIPOLYGON(((0.74 0.96,0.80 0.93,0.61 0.40,0.23 0.49,0.79 0.96,0.67 0.30,0.67 0.25,0.74 0.96)))'),'10:58:11','a'),

(6,MULTIPOLYGONFromText('MULTIPOLYGON(((0.18 0.56,0.03 0.48,0.89 0.30,0.79 0.85,0.40 0.92,0.47 0.34,0.38 0.48,0.18 0.56)))'),'04:56:05','j'),

(6,MULTIPOLYGONFromText('MULTIPOLYGON(((0.60 0.23,0.03 0.43,0.33 0.94,0.20 0.37,0.60 0.23)))'),'00:00:00','ko'),

(1,MULTIPOLYGONFromText('MULTIPOLYGON(((0.94 0.33,0.16 0.47,0.94 0.33)))'),'18:15:15','o'),

(3,MULTIPOLYGONFromText('MULTIPOLYGON(((0.78 0.81,0.71 0.29,0.03 0.85,0.54 0.16,0.23 0.20,0.86 0.77,0.41 0.96,0.85 0.67,0.78 0.81)))'),'04:23:23','bs'),

(1,MULTIPOLYGONFromText('MULTIPOLYGON(((0.70 0.92,0.61 0.64,0.05 0.75,0.60 1.00,0.47 0.14,0.70 0.92)))'),'00:00:00','z'),

(1,MULTIPOLYGONFromText('MULTIPOLYGON(((0.03 0.78,0.83 0.08,0.18 0.49,0.02 0.88,0.62 0.46,0.25 0.53,0.03 0.78)))'),'19:59:49',''),

(2,MULTIPOLYGONFromText('MULTIPOLYGON(((0.12 0.22,0.73 0.35,0.08 0.39,0.23 0.31,0.84 0.19,0.46 0.77,0.63 0.69,0.12 0.22)))'),'00:00:00','oaz'),

(0,MULTIPOLYGONFromText('MULTIPOLYGON(((0.50 0.49,0.48 0.69,0.25 0.87,0.85 0.62,0.96 0.28,0.07 0.70,0.45 0.79,0.87 0.36,0.50 0.49)))'),'06:40:53','a'),

(2,MULTIPOLYGONFromText('MULTIPOLYGON(((0.72 0.93,0.03 0.94,0.77 0.06,0.29 0.76,0.82 0.68,0.16 0.59,0.15 0.73,0.72 0.93)))'),'05:36:36','cj'),

(9,MULTIPOLYGONFromText('MULTIPOLYGON(((0.02 0.67,0.05 0.90,0.68 0.02,0.02 0.67)))'),'01:10:16',REPEAT('r',149)),

(3,MULTIPOLYGONFromText('MULTIPOLYGON(((0.61 0.40,0.77 0.06,0.61 0.40)),((0.43 0.52,0.77 0.27,0.31 0.49,0.43 0.52)))'),'04:59:31','ihb'),

(4,MULTIPOLYGONFromText('MULTIPOLYGON(((0.37 0.98,0.88 0.84,0.18 0.47,0.15 0.77,0.82 0.92,0.66 0.55,0.60 0.02,0.17 0.09,0.37 0.98)))'),'15:14:40','h'),

(8,MULTIPOLYGONFromText('MULTIPOLYGON(((0.89 0.55,0.85 0.85,0.68 0.24,0.20 0.42,0.67 0.36,0.35 0.25,0.48 0.20,0.89 0.55)))'),'13:06:50','i'),

(0,MULTIPOLYGONFromText('MULTIPOLYGON(((0.67 0.40,0.63 0.18,0.80 0.66,0.65 0.47,0.66 0.56,0.64 0.97,0.00 0.92,0.66 0.18,0.67 0.40)))'),'00:00:00','q'),

(6,MULTIPOLYGONFromText('MULTIPOLYGON(((0.89 0.31,0.33 0.68,0.75 0.35,0.40 0.57,0.94 0.91,0.88 0.23,0.89 0.31)))'),'13:40:47','kh'),

(0,MULTIPOLYGONFromText('MULTIPOLYGON(((0.99 0.12,0.73 0.75,0.46 0.85,0.55 0.92,0.12 0.44,0.22 0.13,0.11 0.61,0.99 0.12)))'),'17:02:07','hbtgc'),

(7,MULTIPOLYGONFromText('MULTIPOLYGON(((0.72 0.06,0.31 0.98,0.95 0.02,0.84 0.77,0.46 0.09,0.63 0.92,0.35 0.90,0.72 0.06)))'),'06:01:34',REPEAT('t',71)),

(6,MULTIPOLYGONFromText('MULTIPOLYGON(((0.18 0.27,0.28 0.15,0.18 0.27)),((0.22 0.55,0.22 0.55)),((0.28 0.70,0.28 0.70)))'),'15:13:58','g'),

(7,MULTIPOLYGONFromText('MULTIPOLYGON(((0.72 0.28,0.62 0.71,0.04 1.00,0.12 0.57,0.72 0.28)))'),'00:00:00','c'),

(5,MULTIPOLYGONFromText('MULTIPOLYGON(((0.70 0.04,0.62 0.29,0.42 0.82,0.90 0.87,0.79 0.69,0.59 0.99,0.24 0.24,0.69 0.96,0.70 0.04)))'),'00:00:00',REPEAT('q',885)),

(2,MULTIPOLYGONFromText('MULTIPOLYGON(((0.23 0.87,0.51 0.65,0.70 0.97,0.44 0.14,0.25 0.83,0.23 0.87)))'),'12:01:05','oy'),

(5,MULTIPOLYGONFromText('MULTIPOLYGON(((0.99 0.78,0.78 0.99,0.76 0.51,0.25 0.31,0.13 0.86,0.16 0.11,0.45 0.94,0.23 0.98,0.99 0.78)))'),'22:51:24',REPEAT('k',1684)),

(8,MULTIPOLYGONFromText('MULTIPOLYGON(((0.85 0.35,0.03 0.75,0.18 0.31,0.84 0.36,0.92 0.72,0.52 0.93,0.65 0.10,0.55 0.80,0.85 0.35)))'),'09:37:28','ylsmiix'),

(7,MULTIPOLYGONFromText('MULTIPOLYGON(((0.72 0.00,0.83 0.45,0.32 0.62,0.36 0.40,0.19 0.95,0.50 0.38,0.30 0.76,0.72 0.00)))'),'23:13:15','ojouw'),

(4,MULTIPOLYGONFromText('MULTIPOLYGON(((0.98 0.02,0.01 0.23,0.27 0.11,0.98 0.02)),((0.44 0.54,0.44 0.54)),((0.86 0.97,0.86 0.97)))'),'11:54:22','ou'),

(5,MULTIPOLYGONFromText('MULTIPOLYGON(((0.13 0.07,0.29 0.09,0.53 0.79,0.85 0.66,0.64 0.17,0.22 0.18,0.35 0.39,0.30 0.28,0.13 0.07)))'),'07:13:41','u'),

(2,MULTIPOLYGONFromText('MULTIPOLYGON(((0.26 0.03,0.24 0.93,0.15 0.48,0.26 0.03)),((0.73 0.46,0.35 0.63,0.73 0.46)))'),'22:43:02','sax'),

(4,MULTIPOLYGONFromText('MULTIPOLYGON(((0.23 0.35,0.35 0.82,0.23 0.35)),((0.29 0.61,0.82 0.54,0.29 0.61)))'),'06:00:05','xmet'),

(1,MULTIPOLYGONFromText('MULTIPOLYGON(((0.65 0.67,0.65 0.67)))'),'22:49:46',REPEAT('e',276)),

(9,MULTIPOLYGONFromText('MULTIPOLYGON(((0.43 0.44,0.64 0.76,0.92 0.59,0.73 0.23,0.43 0.44)))'),'21:47:02','ty'),

(3,MULTIPOLYGONFromText('MULTIPOLYGON(((0.84 0.27,0.19 0.67,0.84 0.27)),((0.55 0.13,0.39 0.64,0.21 0.70,0.18 0.45,0.55 0.13)))'),'19:30:59','yq'),

(4,MULTIPOLYGONFromText('MULTIPOLYGON(((0.61 0.79,0.83 0.16,0.63 0.80,0.78 0.28,0.88 0.66,0.61 0.79)))'),'23:16:39','hcsv'),

(1,MULTIPOLYGONFromText('MULTIPOLYGON(((0.82 0.24,0.31 0.52,0.61 0.67,0.99 0.90,0.05 0.73,0.52 0.18,0.71 0.87,0.82 0.24)))'),'18:46:23','csvhlr'),

(1,MULTIPOLYGONFromText('MULTIPOLYGON(((0.09 0.21,0.37 0.57,0.81 0.75,0.61 0.16,0.48 0.17,0.29 0.28,0.72 0.46,0.09 0.21)))'),'00:00:00','b'),

(9,MULTIPOLYGONFromText('MULTIPOLYGON(((0.06 0.25,0.52 0.23,0.02 0.05,0.06 0.25)),((0.70 0.52,0.44 0.46,0.95 0.47,0.70 0.52)))'),'17:36:48','wd'),

(6,MULTIPOLYGONFromText('MULTIPOLYGON(((0.81 0.28,0.19 0.17,0.81 0.28)))'),'19:40:55','dg'),

(2,MULTIPOLYGONFromText('MULTIPOLYGON(((0.80 0.66,0.81 0.12,0.83 0.31,0.52 0.29,0.08 0.04,0.80 0.66)))'),'00:00:00','qtqkyyhkayeoopxmexd'),

(4,MULTIPOLYGONFromText('MULTIPOLYGON(((0.95 0.08,0.95 0.08)),((0.09 0.31,0.09 0.31)),((0.38 0.75,0.30 0.04,0.38 0.75)))'),'20:49:57','tqk'),

(1,MULTIPOLYGONFromText('MULTIPOLYGON(((0.56 0.73,0.87 0.11,0.37 0.86,0.48 0.05,0.82 0.55,0.25 0.06,0.19 0.85,0.10 0.75,0.56 0.73)))'),'09:31:14',REPEAT('q',925)),

(9,MULTIPOLYGONFromText('MULTIPOLYGON(((0.06 0.67,0.41 0.51,0.03 0.83,0.40 0.20,0.16 0.87,0.16 0.07,0.29 0.52,0.06 0.67)))'),'08:01:47','yhk'),

(5,MULTIPOLYGONFromText('MULTIPOLYGON(((0.16 0.14,0.16 0.14)),((0.97 0.69,0.45 0.32,0.45 0.38,0.97 0.69)))'),'00:00:00','k'),

(2,MULTIPOLYGONFromText('MULTIPOLYGON(((0.70 0.00,0.70 0.00)),((0.88 0.53,0.90 0.16,0.88 0.53)))'),'15:02:37','b'),

(2,MULTIPOLYGONFromText('MULTIPOLYGON(((0.48 0.06,0.45 0.05,0.03 0.12,0.27 0.80,0.22 0.75,0.53 0.55,0.48 0.06)))'),'19:24:01',''),

(0,MULTIPOLYGONFromText('MULTIPOLYGON(((0.32 0.76,0.17 0.43,0.32 0.76)),((0.40 0.79,0.40 0.79)),((0.42 0.34,0.42 0.34)))'),'20:34:08','o'),

(3,MULTIPOLYGONFromText('MULTIPOLYGON(((0.44 0.08,0.02 0.74,0.26 0.21,0.75 0.42,0.91 0.32,0.24 0.65,0.67 0.50,0.44 0.08)))'),'05:28:20','pxme'),

(9,MULTIPOLYGONFromText('MULTIPOLYGON(((0.86 0.13,0.21 0.34,0.00 0.87,0.76 0.23,0.69 0.73,0.13 0.63,0.86 0.13)))'),'08:35:14','m'),

(7,MULTIPOLYGONFromText('MULTIPOLYGON(((0.84 0.11,0.63 0.13,0.51 0.81,0.58 0.25,0.53 0.29,0.53 0.42,0.84 0.11)))'),'08:04:13','mex'),

(7,MULTIPOLYGONFromText('MULTIPOLYGON(((0.27 0.84,0.65 0.26,0.75 0.44,0.29 0.52,0.27 0.84)))'),'00:00:00',REPEAT('e',504)),

(4,MULTIPOLYGONFromText('MULTIPOLYGON(((0.71 0.84,0.77 0.27,0.45 0.71,0.91 0.01,0.84 0.35,0.71 0.84)))'),'19:43:55','i'),

(8,MULTIPOLYGONFromText('MULTIPOLYGON(((0.12 0.36,0.02 0.47,0.57 0.76,0.15 0.54,0.12 0.36)))'),'07:46:44','b'),

(9,MULTIPOLYGONFromText('MULTIPOLYGON(((0.77 0.80,0.25 0.69,0.34 0.68,0.77 0.80)))'),'23:40:21',''),

(7,MULTIPOLYGONFromText('MULTIPOLYGON(((0.57 0.30,0.58 0.81,0.57 0.30)))'),'04:52:52',''),

(3,MULTIPOLYGONFromText('MULTIPOLYGON(((0.42 0.99,0.42 0.99)))'),'17:02:28','nh'),

(6,MULTIPOLYGONFromText('MULTIPOLYGON(((0.40 0.50,0.97 0.34,0.60 0.75,0.26 0.74,0.40 0.50)))'),'00:00:00','hwi'),

(3,MULTIPOLYGONFromText('MULTIPOLYGON(((0.30 0.67,0.13 0.43,0.16 0.64,0.04 0.72,0.95 0.87,0.83 0.24,0.17 0.82,0.30 0.67)))'),'06:33:52','id'),

(0,MULTIPOLYGONFromText('MULTIPOLYGON(((0.68 0.75,0.92 0.90,0.68 0.75)),((0.58 0.03,0.41 0.09,0.62 0.05,0.58 0.03)))'),'14:48:58','toy'),

(0,MULTIPOLYGONFromText('MULTIPOLYGON(((0.95 0.50,0.61 0.35,0.78 0.07,0.67 0.43,0.50 0.70,0.48 0.98,0.95 0.50)))'),'22:47:31','yhawdptl'),

(0,MULTIPOLYGONFromText('MULTIPOLYGON(((0.59 0.06,0.12 0.94,0.05 0.90,0.99 0.22,0.13 0.55,0.59 0.06)))'),'09:06:47','gs'),

(2,MULTIPOLYGONFromText('MULTIPOLYGON(((0.33 0.90,0.54 0.11,0.05 0.04,0.59 0.66,0.33 0.90)))'),'13:37:26','bplb'),

(0,MULTIPOLYGONFromText('MULTIPOLYGON(((0.50 0.52,0.23 0.54,0.80 0.14,0.88 0.70,0.13 0.67,0.68 0.66,0.50 0.52)))'),'19:39:25','b'),

(1,MULTIPOLYGONFromText('MULTIPOLYGON(((0.07 0.99,0.11 0.79,0.07 0.99)),((0.50 0.22,0.77 0.58,0.50 0.22)))'),'17:36:33','p'),

(5,MULTIPOLYGONFromText('MULTIPOLYGON(((0.21 0.75,0.21 0.75)))'),'00:00:00','l'),

(8,MULTIPOLYGONFromText('MULTIPOLYGON(((0.99 0.89,0.25 0.77,0.99 0.89)))'),'16:22:48','rwkqhip'),

(3,MULTIPOLYGONFromText('MULTIPOLYGON(((0.01 0.10,0.01 0.20,0.01 0.10)),((0.83 0.75,0.29 0.21,0.83 0.75)))'),'06:39:00','n'),

(4,MULTIPOLYGONFromText('MULTIPOLYGON(((0.12 0.03,0.51 0.05,0.27 0.77,0.74 0.06,0.12 0.03)))'),'09:59:54','q'),

(9,MULTIPOLYGONFromText('MULTIPOLYGON(((0.89 0.94,0.54 0.92,0.37 0.71,0.89 0.94)))'),'00:00:00','hipd'),

(5,MULTIPOLYGONFromText('MULTIPOLYGON(((0.50 0.48,0.07 0.31,0.19 0.23,0.51 0.74,0.50 0.48)))'),'06:30:09','ipdec'),

(7,MULTIPOLYGONFromText('MULTIPOLYGON(((0.79 0.42,0.61 0.98,0.13 0.85,0.52 0.16,0.79 0.42)))'),'06:52:44','pde'),

(2,MULTIPOLYGONFromText('MULTIPOLYGON(((0.78 0.29,0.42 0.20,0.88 0.86,0.99 0.81,0.78 0.29)))'),'21:44:33',REPEAT('e',1432)),

(7,MULTIPOLYGONFromText('MULTIPOLYGON(((0.61 0.16,0.62 0.19,0.61 0.16)),((0.62 0.94,0.65 0.53,0.15 0.25,0.71 0.41,0.62 0.94)),((0.67 0.63,0.86 0.60,0.67 0.63)))'),'00:47:46','cyhr'),

(2,MULTIPOLYGONFromText('MULTIPOLYGON(((0.39 0.89,0.25 0.77,0.22 0.21,0.51 0.19,0.71 0.51,0.39 0.89)))'),'17:10:24','n'),

(1,MULTIPOLYGONFromText('MULTIPOLYGON(((0.29 0.36,0.29 0.36)))'),'00:00:00','y'),

(9,MULTIPOLYGONFromText('MULTIPOLYGON(((0.05 0.94,0.93 0.37,0.22 0.07,0.73 0.75,0.99 0.35,0.05 0.94)))'),'00:00:00','r'),

(5,MULTIPOLYGONFromText('MULTIPOLYGON(((0.33 0.37,0.06 0.59,0.34 0.82,0.73 0.86,0.18 0.78,0.99 0.03,0.33 0.37)))'),'00:00:00','w'),

(1,MULTIPOLYGONFromText('MULTIPOLYGON(((0.60 0.54,0.25 0.31,0.60 0.54)))'),'00:00:00',REPEAT('g',74)),

(9,MULTIPOLYGONFromText('MULTIPOLYGON(((0.80 0.34,0.09 0.74,0.47 0.96,0.55 0.19,0.80 0.34)))'),'16:56:16',REPEAT('s',214)),

(1,MULTIPOLYGONFromText('MULTIPOLYGON(((0.76 0.26,0.16 0.85,0.91 0.75,0.64 0.83,0.47 0.02,0.92 0.58,0.76 0.26)))'),'00:00:00',REPEAT('h',223)),

(1,MULTIPOLYGONFromText('MULTIPOLYGON(((0.11 0.64,0.41 0.64,0.64 0.64,0.11 0.64)))'),'18:13:48','l'),

(1,MULTIPOLYGONFromText('MULTIPOLYGON(((0.66 1.00,0.21 0.96,0.52 0.44,0.94 0.06,0.80 0.39,0.33 0.57,0.30 0.89,0.66 1.00)))'),'14:15:05','hj'),

(2,MULTIPOLYGONFromText('MULTIPOLYGON(((0.20 0.66,0.71 0.41,0.32 0.94,0.30 0.66,0.50 0.49,0.60 0.67,0.20 0.66)))'),'13:12:03','axcs'),

(7,MULTIPOLYGONFromText('MULTIPOLYGON(((0.02 0.69,0.80 0.21,0.09 0.23,0.45 0.66,0.10 0.72,0.02 0.69)))'),'21:42:05','cs'),

(0,MULTIPOLYGONFromText('MULTIPOLYGON(((0.87 0.14,0.54 0.83,0.87 0.42,0.36 0.58,0.87 0.14)))'),'20:45:48','f'),

(8,MULTIPOLYGONFromText('MULTIPOLYGON(((0.73 0.57,0.36 0.41,0.86 0.33,0.76 0.49,0.44 0.83,0.73 0.57)))'),'11:40:10','icq'),

(8,MULTIPOLYGONFromText('MULTIPOLYGON(((0.28 0.98,0.05 0.26,0.09 0.59,1.00 0.17,0.55 0.68,0.12 0.04,0.28 0.98)))'),'05:02:35',REPEAT('z',783)),

(8,MULTIPOLYGONFromText('MULTIPOLYGON(((0.05 0.89,0.05 0.89)))'),'12:11:42','z'),

(1,MULTIPOLYGONFromText('MULTIPOLYGON(((0.79 0.83,0.12 0.49,0.54 0.63,0.79 0.83)))'),'01:07:28',REPEAT('x',1412)),

(0,MULTIPOLYGONFromText('MULTIPOLYGON(((0.50 0.55,0.13 0.19,0.72 0.06,0.50 0.55)),((0.73 0.92,0.02 0.48,0.73 0.92)))'),'10:00:57',REPEAT('u',2500));

# Cleanup

DROP TABLE t;

10.2 non-debug 8d9b1aa0
2022-01-29 2:18:54 139704478893824 [ERROR] [FATAL] InnoDB: Corruption of index `d` of table `test`.`t` parent page 7 child page 8; child COMPACT RECORD(info_bits=0, 4 fields):
<...>
#6 0x000055b446211d6d in ib::fatal::~fatal (this=<optimized out>, __in_chrg=<optimized out>) at /data/src/10.2/storage/innobase/ut/ut0ut.cc:649
#7 0x000055b44623405f in rtr_page_get_father_node_ptr (offsets=0x7f0f2c0ad598, heap=<optimized out>, sea_cur=<optimized out>, cursor=<optimized out>, mtr=<optimized out>) at /data/src/10.2/storage/innobase/include/ut0ut.h:408
#8 0x000055b44684c5a2 in rtr_adjust_upper_level (direction=111, mtr=0x7f0f7bd65150, direction=111, new_mbr=0x7f0f7bd64190, mbr=0x7f0f7bd64170, new_block=0x7f0f8007f360, block=0x7f0f8007f080, flags=0, sea_cur=0x7f0f7bd644c0) at /data/src/10.2/storage/innobase/gis/gis0rtree.cc:676
#9 rtr_page_split_and_insert (flags=<optimized out>, cursor=<optimized out>, offsets=<optimized out>, heap=<optimized out>, tuple=<optimized out>, n_ext=<optimized out>, mtr=<optimized out>) at /data/src/10.2/storage/innobase/gis/gis0rtree.cc:1254
#10 0x000055b446789e5b in btr_cur_pessimistic_insert (flags=flags@entry=0, cursor=cursor@entry=0x7f0f7bd644c0, offsets=offsets@entry=0x7f0f7bd64450, heap=0x7f0f7bd64448, entry=0x7f0f2c0ae9f8, rec=0x7f0f7bd64470, big_rec=0x7f0f7bd64560, n_ext=<optimized out>, thr=0x7f0f2c17a4d0, mtr=0x7f0f7bd65150) at /data/src/10.2/storage/innobase/btr/btr0cur.cc:3456
#11 0x000055b4466e4939 in row_ins_sec_index_entry_low (flags=<optimized out>, mode=<optimized out>, index=0x7f0f2c0a31f8, offsets_heap=<optimized out>, heap=<optimized out>, entry=<optimized out>, trx_id=<optimized out>, thr=<optimized out>) at /data/src/10.2/storage/innobase/row/row0ins.cc:3063
#12 0x000055b4466e7ca6 in row_ins_sec_index_entry (index=0x7f0f2c0a31f8, entry=0x7f0f2c0ae9f8, thr=0x7f0f2c17a4d0) at /data/src/10.2/storage/innobase/row/row0ins.cc:3228
#13 0x000055b4466e9e97 in row_ins_index_entry (thr=0x7f0f2c17a4d0, entry=<optimized out>, index=<optimized out>) at /data/src/10.2/storage/innobase/row/row0ins.cc:3261
#14 row_ins_index_entry_step (thr=0x7f0f2c17a4d0, node=<optimized out>) at /data/src/10.2/storage/innobase/row/row0ins.cc:3410
#15 row_ins (thr=<optimized out>, node=<optimized out>) at /data/src/10.2/storage/innobase/row/row0ins.cc:3547
#16 row_ins_step (thr=thr@entry=0x7f0f2c17a4d0) at /data/src/10.2/storage/innobase/row/row0ins.cc:3671
#17 0x000055b4466fa00e in row_insert_for_mysql (mysql_rec=<optimized out>, prebuilt=0x7f0f2c06e5f8) at /data/src/10.2/storage/innobase/row/row0mysql.cc:1408
#18 0x000055b44664bbbc in ha_innobase::write_row (this=0x7f0f2c1766e0, record=0x7f0f2c02e4c0 "\200\240\071") at /data/src/10.2/storage/innobase/handler/ha_innodb.cc:8285
#19 0x000055b4464ab9c2 in handler::ha_write_row (this=0x7f0f2c1766e0, buf=0x7f0f2c02e4c0 "\200\240\071") at /data/src/10.2/sql/handler.cc:6118
#20 0x000055b4462d16e5 in write_record (thd=thd@entry=0x7f0f2c000c48, table=table@entry=0x7f0f2c175b48, info=info@entry=0x7f0f7bd65c90) at /data/src/10.2/sql/sql_insert.cc:1951
#21 0x000055b4462db280 in mysql_insert (thd=thd@entry=0x7f0f2c000c48, table_list=<optimized out>, fields=..., values_list=..., update_fields=..., update_values=..., duplic=DUP_ERROR, ignore=<optimized out>) at /data/src/10.2/sql/sql_insert.cc:1066
#22 0x000055b4462f0f11 in mysql_execute_command (thd=<optimized out>) at /data/src/10.2/sql/sql_parse.cc:4217
#23 0x000055b4462f77db in mysql_parse (thd=thd@entry=0x7f0f2c000c48, rawbuf=<optimized out>, length=<optimized out>, parser_state=parser_state@entry=0x7f0f7bd675a0, is_com_multi=is_com_multi@entry=false, is_next_command=is_next_command@entry=false) at /data/src/10.2/sql/sql_parse.cc:7793
#24 0x000055b4462fa9bd in dispatch_command (command=COM_QUERY, thd=0x7f0f2c000c48, packet=<optimized out>, packet_length=<optimized out>, is_com_multi=<optimized out>, is_next_command=<optimized out>) at /data/src/10.2/sql/sql_class.h:182
#25 0x000055b4462fbc89 in do_command (thd=0x7f0f2c000c48) at /data/src/10.2/sql/sql_parse.cc:1381
#26 0x000055b4463d5846 in do_handle_one_connection (connect=connect@entry=0x55b448cd3098) at /data/src/10.2/sql/sql_connect.cc:1336
#27 0x000055b4463d59bb in handle_one_connection (arg=arg@entry=0x55b448cd3098) at /data/src/10.2/sql/sql_connect.cc:1241
#28 0x000055b446961fc2 in pfs_spawn_thread (arg=0x55b449165128) at /data/src/10.2/storage/perfschema/pfs.cc:1869
#29 0x00007f0f85df3ea7 in start_thread (arg=<optimized out>) at pthread_create.c:477
#30 0x00007f0f85a10def in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95

10.2 debug 8d9b1aa0
mysqld: /data/src/10.2/storage/innobase/gis/gis0sea.cc:784: void rtr_get_father_node(dict_index_t, ulint, const dtuple_t, btr_cur_t, btr_cur_t, ulint, mtr_t*): Assertion `ret && btr_cur->low_match == n_fields' failed.
220129 2:20:21 [ERROR] mysqld got signal 6 ;

#7 0x00007fb603815662 in __GI___assert_fail (assertion=0x55b4b7117740 "ret && btr_cur->low_match == n_fields", file=0x55b4b71170e8 "/data/src/10.2/storage/innobase/gis/gis0sea.cc", line=784, function=0x55b4b71175d0 "void rtr_get_father_node(dict_index_t, ulint, const dtuple_t, btr_cur_t, btr_cur_t, ulint, mtr_t*)") at assert.c:101
#8 0x000055b4b6c4277a in rtr_get_father_node (index=0x7fb5a80377e0, level=1, tuple=0x7fb5a808cce0, sea_cur=0x0, btr_cur=0x7fb5fdc78db0, page_no=7, mtr=0x7fb5fdc79d00) at /data/src/10.2/storage/innobase/gis/gis0sea.cc:784
#9 0x000055b4b6c42aa5 in rtr_page_get_father_node_ptr (offsets=0x7fb5a808ccc0, heap=0x7fb5a808cc40, sea_cur=0x0, cursor=0x7fb5fdc78db0, mtr=0x7fb5fdc79d00) at /data/src/10.2/storage/innobase/gis/gis0sea.cc:851
#10 0x000055b4b6c42eb4 in rtr_page_get_father_block (offsets=0x0, heap=0x7fb5a808cc40, index=0x7fb5a80377e0, block=0x7fb5fdf53480, mtr=0x7fb5fdc79d00, sea_cur=0x7fb5fdc792b0, cursor=0x7fb5fdc78db0) at /data/src/10.2/storage/innobase/gis/gis0sea.cc:920
#11 0x000055b4b6c39c0b in rtr_adjust_upper_level (sea_cur=0x7fb5fdc792b0, flags=0, block=0x7fb5fdf53480, new_block=0x7fb5fdf53a60, mbr=0x7fb5fdc78fe0, new_mbr=0x7fb5fdc79000, direction=111, mtr=0x7fb5fdc79d00) at /data/src/10.2/storage/innobase/gis/gis0rtree.cc:676
#12 0x000055b4b6c3b670 in rtr_page_split_and_insert (flags=0, cursor=0x7fb5fdc792b0, offsets=0x7fb5fdc79258, heap=0x7fb5fdc79230, tuple=0x7fb5a8036a88, n_ext=0, mtr=0x7fb5fdc79d00) at /data/src/10.2/storage/innobase/gis/gis0rtree.cc:1254
#13 0x000055b4b6b0748b in btr_root_raise_and_insert (flags=0, cursor=0x7fb5fdc792b0, offsets=0x7fb5fdc79258, heap=0x7fb5fdc79230, tuple=0x7fb5a8036a88, n_ext=0, mtr=0x7fb5fdc79d00) at /data/src/10.2/storage/innobase/btr/btr0btr.cc:2021
#14 0x000055b4b6b2961c in btr_cur_pessimistic_insert (flags=0, cursor=0x7fb5fdc792b0, offsets=0x7fb5fdc79258, heap=0x7fb5fdc79230, entry=0x7fb5a8036a88, rec=0x7fb5fdc79260, big_rec=0x7fb5fdc79268, n_ext=0, thr=0x7fb5a809fd98, mtr=0x7fb5fdc79d00) at /data/src/10.2/storage/innobase/btr/btr0cur.cc:3456
#15 0x000055b4b6a1459a in row_ins_sec_index_entry_low (flags=0, mode=33, index=0x7fb5a80377e0, offsets_heap=0x7fb5a8087950, heap=0x7fb5a8087de0, entry=0x7fb5a8036a88, trx_id=0, thr=0x7fb5a809fd98) at /data/src/10.2/storage/innobase/row/row0ins.cc:3063
#16 0x000055b4b6a14bc1 in row_ins_sec_index_entry (index=0x7fb5a80377e0, entry=0x7fb5a8036a88, thr=0x7fb5a809fd98) at /data/src/10.2/storage/innobase/row/row0ins.cc:3228
#17 0x000055b4b6a14cbb in row_ins_index_entry (index=0x7fb5a80377e0, entry=0x7fb5a8036a88, thr=0x7fb5a809fd98) at /data/src/10.2/storage/innobase/row/row0ins.cc:3261
#18 0x000055b4b6a151c4 in row_ins_index_entry_step (node=0x7fb5a8162ba0, thr=0x7fb5a809fd98) at /data/src/10.2/storage/innobase/row/row0ins.cc:3410
#19 0x000055b4b6a15596 in row_ins (node=0x7fb5a8162ba0, thr=0x7fb5a809fd98) at /data/src/10.2/storage/innobase/row/row0ins.cc:3547
#20 0x000055b4b6a1595f in row_ins_step (thr=0x7fb5a809fd98) at /data/src/10.2/storage/innobase/row/row0ins.cc:3671
#21 0x000055b4b6a336b0 in row_insert_for_mysql (mysql_rec=0x7fb5a8034a98 "\200\240\071", prebuilt=0x7fb5a81625e0) at /data/src/10.2/storage/innobase/row/row0mysql.cc:1408
#22 0x000055b4b68f868b in ha_innobase::write_row (this=0x7fb5a80ac9f8, record=0x7fb5a8034a98 "\200\240\071") at /data/src/10.2/storage/innobase/handler/ha_innodb.cc:8285
#23 0x000055b4b6705695 in handler::ha_write_row (this=0x7fb5a80ac9f8, buf=0x7fb5a8034a98 "\200\240\071") at /data/src/10.2/sql/handler.cc:6118
#24 0x000055b4b64579d2 in write_record (thd=0x7fb5a8000d90, table=0x7fb5a8039600, info=0x7fb5fdc7a930) at /data/src/10.2/sql/sql_insert.cc:1951
#25 0x000055b4b6455439 in mysql_insert (thd=0x7fb5a8000d90, table_list=0x7fb5a818ef80, fields=..., values_list=..., update_fields=..., update_values=..., duplic=DUP_ERROR, ignore=false) at /data/src/10.2/sql/sql_insert.cc:1066
#26 0x000055b4b647c0ae in mysql_execute_command (thd=0x7fb5a8000d90) at /data/src/10.2/sql/sql_parse.cc:4217
#27 0x000055b4b64874f0 in mysql_parse (thd=0x7fb5a8000d90, rawbuf=0x7fb5a8012708 "INSERT INTO t (b,d,a,c) VALUES\n(6,MULTIPOLYGONFromText('MULTIPOLYGON(((0.12 0.53,0.23 0.92,0.12 0.53)))'),'04:09:11','id'),\n(2,MULTIPOLYGONFromText('MULTIPOLYGON(((0.09 0.71,0.92 0.49,0.09 0.71)))'),'"..., length=12201, parser_state=0x7fb5fdc7b5e0, is_com_multi=false, is_next_command=false) at /data/src/10.2/sql/sql_parse.cc:7793
#28 0x000055b4b6475893 in dispatch_command (command=COM_QUERY, thd=0x7fb5a8000d90, packet=0x7fb5a8008b61 "INSERT INTO t (b,d,a,c) VALUES\n(6,MULTIPOLYGONFromText('MULTIPOLYGON(((0.12 0.53,0.23 0.92,0.12 0.53)))'),'04:09:11','id'),\n(2,MULTIPOLYGONFromText('MULTIPOLYGON(((0.09 0.71,0.92 0.49,0.09 0.71)))'),'"..., packet_length=12201, is_com_multi=false, is_next_command=false) at /data/src/10.2/sql/sql_parse.cc:1827
#29 0x000055b4b64743ac in do_command (thd=0x7fb5a8000d90) at /data/src/10.2/sql/sql_parse.cc:1381
#30 0x000055b4b65cc190 in do_handle_one_connection (connect=0x55b4ba619a80) at /data/src/10.2/sql/sql_connect.cc:1336
#31 0x000055b4b65cbf04 in handle_one_connection (arg=0x55b4ba619a80) at /data/src/10.2/sql/sql_connect.cc:1241
#32 0x000055b4b6dd4819 in pfs_spawn_thread (arg=0x55b4ba603ef0) at /data/src/10.2/storage/perfschema/pfs.cc:1869
#33 0x00007fb603cd9ea7 in start_thread (arg=<optimized out>) at pthread_create.c:477
#34 0x00007fb6038dedef in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95

Reproducible on 10.2-10.8, debug and non-debug as above.

Attachments

Issue Links

relates to

MDEV-28569 Server crash, fatal error or assertion failures somewhere in btr_cur_compress_if_useful

Stalled

MDEV-36195 MariaDB 10.6.18/11.4.4 signal 11 on include/rem0rec.h:605

Open

Activity

Ascending order - Click to sort in descending order

Elena Stepanova added a comment - 2022-07-28 22:46

10.6+ fails on a different assertion (same test case):

10.6 30914389
mariadbd: /data/src/10.6/storage/innobase/include/rem0rec.h:625: ulint rec_offs_n_fields(const rec_offs*): Assertion `offsets' failed.
220729 1:44:24 [ERROR] mysqld got signal 6 ;

#6 0x00007f1563d9840f in __assert_fail_base (fmt=0x7f1563f01128 "%s%s%s:%u: %s%sAssertion `%s' failed.\n%n", assertion=0x5574b435d3af "offsets", file=0x5574b435d348 "/data/src/10.6/storage/innobase/include/rem0rec.h", line=625, function=<optimized out>) at assert.c:92
#7 0x00007f1563da7662 in __GI___assert_fail (assertion=0x5574b435d3af "offsets", file=0x5574b435d348 "/data/src/10.6/storage/innobase/include/rem0rec.h", line=625, function=0x5574b435d408 "ulint rec_offs_n_fields(const rec_offs*)") at assert.c:101
#8 0x00005574b3ae92dc in rec_offs_n_fields (offsets=0x0) at /data/src/10.6/storage/innobase/include/rem0rec.h:625
#9 0x00005574b3bf3868 in rec_offs_validate (rec=0x0, index=0x0, offsets=0x0) at /data/src/10.6/storage/innobase/rem/rem0rec.cc:519
#10 0x00005574b3b51144 in rec_offs_comp (offsets=0x0) at /data/src/10.6/storage/innobase/include/rem0rec.h:709
#11 0x00005574b3e54c51 in rtr_update_mbr_field (cursor=0x7f155d132e80, offsets=0x0, cursor2=0x0, child_page=0x7f155d8b0000 "", mbr=0x7f155d1330a0, new_rec=0x0, mtr=0x7f155d133750) at /data/src/10.6/storage/innobase/gis/gis0rtree.cc:226
#12 0x00005574b3e562b9 in rtr_adjust_upper_level (sea_cur=0x7f155d133450, flags=0, block=0x7f155d3dc8a0, new_block=0x7f155d3dcb10, mbr=0x7f155d1330a0, new_mbr=0x7f155d1330c0, mtr=0x7f155d133750) at /data/src/10.6/storage/innobase/gis/gis0rtree.cc:588
#13 0x00005574b3e57fc8 in rtr_page_split_and_insert (flags=0, cursor=0x7f155d133450, offsets=0x7f155d1333f8, heap=0x7f155d1333d0, tuple=0x7f150c1ad640, n_ext=0, mtr=0x7f155d133750, err=0x7f155d13334c) at /data/src/10.6/storage/innobase/gis/gis0rtree.cc:1147
#14 0x00005574b3d1824e in btr_page_split_and_insert (flags=0, cursor=0x7f155d133450, offsets=0x7f155d1333f8, heap=0x7f155d1333d0, tuple=0x7f150c1ad640, n_ext=0, mtr=0x7f155d133750, err=0x7f155d13334c) at /data/src/10.6/storage/innobase/btr/btr0btr.cc:2794
#15 0x00005574b3d15ead in btr_root_raise_and_insert (flags=0, cursor=0x7f155d133450, offsets=0x7f155d1333f8, heap=0x7f155d1333d0, tuple=0x7f150c1ad640, n_ext=0, mtr=0x7f155d133750, err=0x7f155d13334c) at /data/src/10.6/storage/innobase/btr/btr0btr.cc:1973
#16 0x00005574b3d41f68 in btr_cur_pessimistic_insert (flags=0, cursor=0x7f155d133450, offsets=0x7f155d1333f8, heap=0x7f155d1333d0, entry=0x7f150c1ad640, rec=0x7f155d133400, big_rec=0x7f155d133408, n_ext=0, thr=0x7f150cb15338, mtr=0x7f155d133750) at /data/src/10.6/storage/innobase/btr/btr0cur.cc:3670
#17 0x00005574b3c2c607 in row_ins_sec_index_entry_low (flags=0, mode=10, index=0x7f150c0fbdd8, offsets_heap=0x7f150cb1be58, heap=0x7f150cb1c2f8, entry=0x7f150c1ad640, trx_id=0, thr=0x7f150cb15338) at /data/src/10.6/storage/innobase/row/row0ins.cc:3051
#18 0x00005574b3c2cd92 in row_ins_sec_index_entry (index=0x7f150c0fbdd8, entry=0x7f150c1ad640, thr=0x7f150cb15338, check_foreign=true) at /data/src/10.6/storage/innobase/row/row0ins.cc:3241
#19 0x00005574b3c2cf1f in row_ins_index_entry (index=0x7f150c0fbdd8, entry=0x7f150c1ad640, thr=0x7f150cb15338) at /data/src/10.6/storage/innobase/row/row0ins.cc:3275
#20 0x00005574b3c2d7d0 in row_ins_index_entry_step (node=0x7f150c1b0980, thr=0x7f150cb15338) at /data/src/10.6/storage/innobase/row/row0ins.cc:3441
#21 0x00005574b3c2dd06 in row_ins (node=0x7f150c1b0980, thr=0x7f150cb15338) at /data/src/10.6/storage/innobase/row/row0ins.cc:3587
#22 0x00005574b3c2e5b2 in row_ins_step (thr=0x7f150cb15338) at /data/src/10.6/storage/innobase/row/row0ins.cc:3727
#23 0x00005574b3c4f91c in row_insert_for_mysql (mysql_rec=0x7f150c1fed60 "\200\240\071", prebuilt=0x7f150c1b03c8, ins_mode=ROW_INS_NORMAL) at /data/src/10.6/storage/innobase/row/row0mysql.cc:1313
#24 0x00005574b3a8ef23 in ha_innobase::write_row (this=0x7f150c235ed0, record=0x7f150c1fed60 "\200\240\071") at /data/src/10.6/storage/innobase/handler/ha_innodb.cc:7935
#25 0x00005574b368c141 in handler::ha_write_row (this=0x7f150c235ed0, buf=0x7f150c1fed60 "\200\240\071") at /data/src/10.6/sql/handler.cc:7549
#26 0x00005574b329547a in write_record (thd=0x7f150c000db8, table=0x7f150c0fb828, info=0x7f155d134b50, sink=0x0) at /data/src/10.6/sql/sql_insert.cc:2156
#27 0x00005574b329211c in mysql_insert (thd=0x7f150c000db8, table_list=0x7f150c228ad8, fields=..., values_list=..., update_fields=..., update_values=..., duplic=DUP_ERROR, ignore=false, result=0x0) at /data/src/10.6/sql/sql_insert.cc:1128
#28 0x00005574b32e6390 in mysql_execute_command (thd=0x7f150c000db8, is_called_from_prepared_stmt=false) at /data/src/10.6/sql/sql_parse.cc:4565
#29 0x00005574b32f1d16 in mysql_parse (thd=0x7f150c000db8, rawbuf=0x7f150c0155c0 "INSERT INTO t (b,d,a,c) VALUES\n(6,MULTIPOLYGONFromText('MULTIPOLYGON(((0.12 0.53,0.23 0.92,0.12 0.53)))'),'04:09:11','id'),\n(2,MULTIPOLYGONFromText('MULTIPOLYGON(((0.09 0.71,0.92 0.49,0.09 0.71)))'),'"..., length=12201, parser_state=0x7f155d1353c0) at /data/src/10.6/sql/sql_parse.cc:8030
#30 0x00005574b32de379 in dispatch_command (command=COM_QUERY, thd=0x7f150c000db8, packet=0x7f150c00b879 "INSERT INTO t (b,d,a,c) VALUES\n(6,MULTIPOLYGONFromText('MULTIPOLYGON(((0.12 0.53,0.23 0.92,0.12 0.53)))'),'04:09:11','id'),\n(2,MULTIPOLYGONFromText('MULTIPOLYGON(((0.09 0.71,0.92 0.49,0.09 0.71)))'),'"..., packet_length=12201, blocking=true) at /data/src/10.6/sql/sql_parse.cc:1896
#31 0x00005574b32dcd74 in do_command (thd=0x7f150c000db8, blocking=true) at /data/src/10.6/sql/sql_parse.cc:1409
#32 0x00005574b3496ee2 in do_handle_one_connection (connect=0x5574b6ac8c98, put_in_cache=true) at /data/src/10.6/sql/sql_connect.cc:1418
#33 0x00005574b3496b81 in handle_one_connection (arg=0x5574b6bbbb98) at /data/src/10.6/sql/sql_connect.cc:1312
#34 0x00005574b39b3758 in pfs_spawn_thread (arg=0x5574b6ac8808) at /data/src/10.6/storage/perfschema/pfs.cc:2201
#35 0x00007f1564273ea7 in start_thread (arg=<optimized out>) at pthread_create.c:477
#36 0x00007f1563e70def in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95

10.6 30914389 non-debug
#2 0x000055deedf868d0 in handle_fatal_signal (sig=11) at /data/src/10.6/sql/signal_handler.cc:355
#3 <signal handler called>
#4 0x000055deee458409 in rec_get_info_bits (comp=<optimized out>, rec=<optimized out>) at /data/src/10.6/storage/innobase/include/rem0rec.inl:511
#5 rtr_update_mbr_field (cursor=cursor@entry=0x7efcd0761fb0, offsets=0x0, cursor2=cursor2@entry=0x0, child_page=0x7efcd0ed8000 "", mbr=mbr@entry=0x7efcd0761f30, new_rec=new_rec@entry=0x0, mtr=0x7efcd0762b00) at /data/src/10.6/storage/innobase/gis/gis0rtree.cc:226
#6 0x000055deee45aab1 in rtr_adjust_upper_level (mtr=0x7efcd0762b00, new_mbr=0x7efcd0761f50, mbr=0x7efcd0761f30, new_block=0x7efcd0a08120, block=0x7efcd0a07f40, flags=0, sea_cur=0x7efcd0762590) at /data/src/10.6/storage/innobase/gis/gis0rtree.cc:588
#7 rtr_page_split_and_insert (flags=0, cursor=<optimized out>, offsets=0x7efcd0762528, heap=0x7efcd0762518, tuple=0x7efc6c125260, n_ext=0, mtr=0x7efcd0762b00, err=0x7efcd0762430) at /data/src/10.6/storage/innobase/gis/gis0rtree.cc:1147
#8 0x000055deee3b40fd in btr_root_raise_and_insert (flags=flags@entry=0, cursor=cursor@entry=0x7efcd0762590, offsets=offsets@entry=0x7efcd0762528, heap=heap@entry=0x7efcd0762518, tuple=tuple@entry=0x7efc6c125260, n_ext=<optimized out>, mtr=<optimized out>, err=<optimized out>) at /data/src/10.6/storage/innobase/btr/btr0btr.cc:1973
#9 0x000055deee3c83fc in btr_cur_pessimistic_insert (flags=0, cursor=0x7efcd0762590, offsets=0x7efcd0762528, heap=0x7efcd0762518, entry=entry@entry=0x7efc6c125260, rec=0x7efcd0762540, big_rec=0x7efcd0762630, n_ext=<optimized out>, thr=0x7efc6c062680, mtr=0x7efcd0762b00) at /data/src/10.6/storage/innobase/btr/btr0cur.cc:3670
#10 0x000055deee3403b9 in row_ins_sec_index_entry_low (flags=<optimized out>, mode=<optimized out>, index=0x7efc6c0f9700, offsets_heap=<optimized out>, heap=<optimized out>, entry=0x7efc6c125260, trx_id=<optimized out>, thr=<optimized out>) at /data/src/10.6/storage/innobase/row/row0ins.cc:3051
#11 0x000055deee343064 in row_ins_sec_index_entry (index=0x7efc6c0f9700, entry=0x7efc6c125260, thr=0x7efc6c062680, check_foreign=<optimized out>) at /data/src/10.6/storage/innobase/row/row0ins.cc:3241
#12 0x000055deee3433c2 in row_ins_index_entry (thr=0x7efc6c062680, entry=<optimized out>, index=<optimized out>) at /data/src/10.6/storage/innobase/row/row0ins.cc:3275
#13 row_ins_index_entry_step (thr=0x7efc6c062680, node=0x7efc6c119818) at /data/src/10.6/storage/innobase/row/row0ins.cc:3441
#14 row_ins (thr=0x7efc6c062680, node=0x7efc6c119818) at /data/src/10.6/storage/innobase/row/row0ins.cc:3587
#15 row_ins_step (thr=thr@entry=0x7efc6c062680) at /data/src/10.6/storage/innobase/row/row0ins.cc:3727
#16 0x000055deee353c09 in row_insert_for_mysql (mysql_rec=<optimized out>, prebuilt=0x7efc6c119270, ins_mode=ROW_INS_NORMAL) at /data/src/10.6/storage/innobase/row/row0mysql.cc:1313
#17 0x000055deee2a4ce6 in ha_innobase::write_row (this=0x7efc6c195e30, record=0x7efc6c0fafb0 "\200\240\071") at /data/src/10.6/storage/innobase/handler/ha_innodb.cc:7935
#18 0x000055deedf9426f in handler::ha_write_row (this=0x7efc6c195e30, buf=0x7efc6c0fafb0 "\200\240\071") at /data/src/10.6/sql/handler.cc:7549
#19 0x000055deedd1a67d in write_record (thd=thd@entry=0x7efc6c000c58, table=table@entry=0x7efc6c195a08, info=info@entry=0x7efcd0763ce0, sink=sink@entry=0x0) at /data/src/10.6/sql/sql_insert.cc:2156
#20 0x000055deedd24114 in mysql_insert (thd=thd@entry=0x7efc6c000c58, table_list=<optimized out>, fields=..., values_list=..., update_fields=..., update_values=..., duplic=DUP_ERROR, ignore=false, result=0x0) at /data/src/10.6/sql/sql_insert.cc:1128
#21 0x000055deedd57654 in mysql_execute_command (thd=0x7efc6c000c58, is_called_from_prepared_stmt=<optimized out>) at /data/src/10.6/sql/sql_parse.cc:4565
#22 0x000055deedd5bdb7 in mysql_parse (thd=0x7efc6c000c58, rawbuf=<optimized out>, length=<optimized out>, parser_state=<optimized out>) at /data/src/10.6/sql/sql_parse.cc:8030
#23 0x000055deedd5e67d in dispatch_command (command=COM_QUERY, thd=0x7efc6c000c58, packet=<optimized out>, packet_length=<optimized out>, blocking=<optimized out>) at /data/src/10.6/sql/sql_class.h:234
#24 0x000055deedd60332 in do_command (thd=0x7efc6c000c58, blocking=blocking@entry=true) at /data/src/10.6/sql/sql_parse.cc:1409
#25 0x000055deede6b12f in do_handle_one_connection (connect=<optimized out>, put_in_cache=true) at /data/src/10.6/sql/sql_connect.cc:1418
#26 0x000055deede6b47d in handle_one_connection (arg=arg@entry=0x55def02c0988) at /data/src/10.6/sql/sql_connect.cc:1312
#27 0x000055deee1ecf42 in pfs_spawn_thread (arg=0x55def02762e8) at /data/src/10.6/storage/perfschema/pfs.cc:2201
#28 0x00007efcd78a1ea7 in start_thread (arg=<optimized out>) at pthread_create.c:477
#29 0x00007efcd74b8def in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95

Elena Stepanova added a comment - 2022-07-28 22:46 10.6+ fails on a different assertion (same test case): 10.6 30914389 mariadbd: /data/src/10.6/storage/innobase/include/rem0rec.h:625: ulint rec_offs_n_fields(const rec_offs*): Assertion `offsets' failed. 220729 1:44:24 [ERROR] mysqld got signal 6 ; #6 0x00007f1563d9840f in __assert_fail_base (fmt=0x7f1563f01128 "%s%s%s:%u: %s%sAssertion `%s' failed.\n%n", assertion=0x5574b435d3af "offsets", file=0x5574b435d348 "/data/src/10.6/storage/innobase/include/rem0rec.h", line=625, function=<optimized out>) at assert.c:92 #7 0x00007f1563da7662 in __GI___assert_fail (assertion=0x5574b435d3af "offsets", file=0x5574b435d348 "/data/src/10.6/storage/innobase/include/rem0rec.h", line=625, function=0x5574b435d408 "ulint rec_offs_n_fields(const rec_offs*)") at assert.c:101 #8 0x00005574b3ae92dc in rec_offs_n_fields (offsets=0x0) at /data/src/10.6/storage/innobase/include/rem0rec.h:625 #9 0x00005574b3bf3868 in rec_offs_validate (rec=0x0, index=0x0, offsets=0x0) at /data/src/10.6/storage/innobase/rem/rem0rec.cc:519 #10 0x00005574b3b51144 in rec_offs_comp (offsets=0x0) at /data/src/10.6/storage/innobase/include/rem0rec.h:709 #11 0x00005574b3e54c51 in rtr_update_mbr_field (cursor=0x7f155d132e80, offsets=0x0, cursor2=0x0, child_page=0x7f155d8b0000 "", mbr=0x7f155d1330a0, new_rec=0x0, mtr=0x7f155d133750) at /data/src/10.6/storage/innobase/gis/gis0rtree.cc:226 #12 0x00005574b3e562b9 in rtr_adjust_upper_level (sea_cur=0x7f155d133450, flags=0, block=0x7f155d3dc8a0, new_block=0x7f155d3dcb10, mbr=0x7f155d1330a0, new_mbr=0x7f155d1330c0, mtr=0x7f155d133750) at /data/src/10.6/storage/innobase/gis/gis0rtree.cc:588 #13 0x00005574b3e57fc8 in rtr_page_split_and_insert (flags=0, cursor=0x7f155d133450, offsets=0x7f155d1333f8, heap=0x7f155d1333d0, tuple=0x7f150c1ad640, n_ext=0, mtr=0x7f155d133750, err=0x7f155d13334c) at /data/src/10.6/storage/innobase/gis/gis0rtree.cc:1147 #14 0x00005574b3d1824e in btr_page_split_and_insert (flags=0, cursor=0x7f155d133450, offsets=0x7f155d1333f8, heap=0x7f155d1333d0, tuple=0x7f150c1ad640, n_ext=0, mtr=0x7f155d133750, err=0x7f155d13334c) at /data/src/10.6/storage/innobase/btr/btr0btr.cc:2794 #15 0x00005574b3d15ead in btr_root_raise_and_insert (flags=0, cursor=0x7f155d133450, offsets=0x7f155d1333f8, heap=0x7f155d1333d0, tuple=0x7f150c1ad640, n_ext=0, mtr=0x7f155d133750, err=0x7f155d13334c) at /data/src/10.6/storage/innobase/btr/btr0btr.cc:1973 #16 0x00005574b3d41f68 in btr_cur_pessimistic_insert (flags=0, cursor=0x7f155d133450, offsets=0x7f155d1333f8, heap=0x7f155d1333d0, entry=0x7f150c1ad640, rec=0x7f155d133400, big_rec=0x7f155d133408, n_ext=0, thr=0x7f150cb15338, mtr=0x7f155d133750) at /data/src/10.6/storage/innobase/btr/btr0cur.cc:3670 #17 0x00005574b3c2c607 in row_ins_sec_index_entry_low (flags=0, mode=10, index=0x7f150c0fbdd8, offsets_heap=0x7f150cb1be58, heap=0x7f150cb1c2f8, entry=0x7f150c1ad640, trx_id=0, thr=0x7f150cb15338) at /data/src/10.6/storage/innobase/row/row0ins.cc:3051 #18 0x00005574b3c2cd92 in row_ins_sec_index_entry (index=0x7f150c0fbdd8, entry=0x7f150c1ad640, thr=0x7f150cb15338, check_foreign=true) at /data/src/10.6/storage/innobase/row/row0ins.cc:3241 #19 0x00005574b3c2cf1f in row_ins_index_entry (index=0x7f150c0fbdd8, entry=0x7f150c1ad640, thr=0x7f150cb15338) at /data/src/10.6/storage/innobase/row/row0ins.cc:3275 #20 0x00005574b3c2d7d0 in row_ins_index_entry_step (node=0x7f150c1b0980, thr=0x7f150cb15338) at /data/src/10.6/storage/innobase/row/row0ins.cc:3441 #21 0x00005574b3c2dd06 in row_ins (node=0x7f150c1b0980, thr=0x7f150cb15338) at /data/src/10.6/storage/innobase/row/row0ins.cc:3587 #22 0x00005574b3c2e5b2 in row_ins_step (thr=0x7f150cb15338) at /data/src/10.6/storage/innobase/row/row0ins.cc:3727 #23 0x00005574b3c4f91c in row_insert_for_mysql (mysql_rec=0x7f150c1fed60 "\200\240\071", prebuilt=0x7f150c1b03c8, ins_mode=ROW_INS_NORMAL) at /data/src/10.6/storage/innobase/row/row0mysql.cc:1313 #24 0x00005574b3a8ef23 in ha_innobase::write_row (this=0x7f150c235ed0, record=0x7f150c1fed60 "\200\240\071") at /data/src/10.6/storage/innobase/handler/ha_innodb.cc:7935 #25 0x00005574b368c141 in handler::ha_write_row (this=0x7f150c235ed0, buf=0x7f150c1fed60 "\200\240\071") at /data/src/10.6/sql/handler.cc:7549 #26 0x00005574b329547a in write_record (thd=0x7f150c000db8, table=0x7f150c0fb828, info=0x7f155d134b50, sink=0x0) at /data/src/10.6/sql/sql_insert.cc:2156 #27 0x00005574b329211c in mysql_insert (thd=0x7f150c000db8, table_list=0x7f150c228ad8, fields=..., values_list=..., update_fields=..., update_values=..., duplic=DUP_ERROR, ignore=false, result=0x0) at /data/src/10.6/sql/sql_insert.cc:1128 #28 0x00005574b32e6390 in mysql_execute_command (thd=0x7f150c000db8, is_called_from_prepared_stmt=false) at /data/src/10.6/sql/sql_parse.cc:4565 #29 0x00005574b32f1d16 in mysql_parse (thd=0x7f150c000db8, rawbuf=0x7f150c0155c0 "INSERT INTO t (b,d,a,c) VALUES\n(6,MULTIPOLYGONFromText('MULTIPOLYGON(((0.12 0.53,0.23 0.92,0.12 0.53)))'),'04:09:11','id'),\n(2,MULTIPOLYGONFromText('MULTIPOLYGON(((0.09 0.71,0.92 0.49,0.09 0.71)))'),'"..., length=12201, parser_state=0x7f155d1353c0) at /data/src/10.6/sql/sql_parse.cc:8030 #30 0x00005574b32de379 in dispatch_command (command=COM_QUERY, thd=0x7f150c000db8, packet=0x7f150c00b879 "INSERT INTO t (b,d,a,c) VALUES\n(6,MULTIPOLYGONFromText('MULTIPOLYGON(((0.12 0.53,0.23 0.92,0.12 0.53)))'),'04:09:11','id'),\n(2,MULTIPOLYGONFromText('MULTIPOLYGON(((0.09 0.71,0.92 0.49,0.09 0.71)))'),'"..., packet_length=12201, blocking=true) at /data/src/10.6/sql/sql_parse.cc:1896 #31 0x00005574b32dcd74 in do_command (thd=0x7f150c000db8, blocking=true) at /data/src/10.6/sql/sql_parse.cc:1409 #32 0x00005574b3496ee2 in do_handle_one_connection (connect=0x5574b6ac8c98, put_in_cache=true) at /data/src/10.6/sql/sql_connect.cc:1418 #33 0x00005574b3496b81 in handle_one_connection (arg=0x5574b6bbbb98) at /data/src/10.6/sql/sql_connect.cc:1312 #34 0x00005574b39b3758 in pfs_spawn_thread (arg=0x5574b6ac8808) at /data/src/10.6/storage/perfschema/pfs.cc:2201 #35 0x00007f1564273ea7 in start_thread (arg=<optimized out>) at pthread_create.c:477 #36 0x00007f1563e70def in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95 10.6 30914389 non-debug #2 0x000055deedf868d0 in handle_fatal_signal (sig=11) at /data/src/10.6/sql/signal_handler.cc:355 #3 <signal handler called> #4 0x000055deee458409 in rec_get_info_bits (comp=<optimized out>, rec=<optimized out>) at /data/src/10.6/storage/innobase/include/rem0rec.inl:511 #5 rtr_update_mbr_field (cursor=cursor@entry=0x7efcd0761fb0, offsets=0x0, cursor2=cursor2@entry=0x0, child_page=0x7efcd0ed8000 "", mbr=mbr@entry=0x7efcd0761f30, new_rec=new_rec@entry=0x0, mtr=0x7efcd0762b00) at /data/src/10.6/storage/innobase/gis/gis0rtree.cc:226 #6 0x000055deee45aab1 in rtr_adjust_upper_level (mtr=0x7efcd0762b00, new_mbr=0x7efcd0761f50, mbr=0x7efcd0761f30, new_block=0x7efcd0a08120, block=0x7efcd0a07f40, flags=0, sea_cur=0x7efcd0762590) at /data/src/10.6/storage/innobase/gis/gis0rtree.cc:588 #7 rtr_page_split_and_insert (flags=0, cursor=<optimized out>, offsets=0x7efcd0762528, heap=0x7efcd0762518, tuple=0x7efc6c125260, n_ext=0, mtr=0x7efcd0762b00, err=0x7efcd0762430) at /data/src/10.6/storage/innobase/gis/gis0rtree.cc:1147 #8 0x000055deee3b40fd in btr_root_raise_and_insert (flags=flags@entry=0, cursor=cursor@entry=0x7efcd0762590, offsets=offsets@entry=0x7efcd0762528, heap=heap@entry=0x7efcd0762518, tuple=tuple@entry=0x7efc6c125260, n_ext=<optimized out>, mtr=<optimized out>, err=<optimized out>) at /data/src/10.6/storage/innobase/btr/btr0btr.cc:1973 #9 0x000055deee3c83fc in btr_cur_pessimistic_insert (flags=0, cursor=0x7efcd0762590, offsets=0x7efcd0762528, heap=0x7efcd0762518, entry=entry@entry=0x7efc6c125260, rec=0x7efcd0762540, big_rec=0x7efcd0762630, n_ext=<optimized out>, thr=0x7efc6c062680, mtr=0x7efcd0762b00) at /data/src/10.6/storage/innobase/btr/btr0cur.cc:3670 #10 0x000055deee3403b9 in row_ins_sec_index_entry_low (flags=<optimized out>, mode=<optimized out>, index=0x7efc6c0f9700, offsets_heap=<optimized out>, heap=<optimized out>, entry=0x7efc6c125260, trx_id=<optimized out>, thr=<optimized out>) at /data/src/10.6/storage/innobase/row/row0ins.cc:3051 #11 0x000055deee343064 in row_ins_sec_index_entry (index=0x7efc6c0f9700, entry=0x7efc6c125260, thr=0x7efc6c062680, check_foreign=<optimized out>) at /data/src/10.6/storage/innobase/row/row0ins.cc:3241 #12 0x000055deee3433c2 in row_ins_index_entry (thr=0x7efc6c062680, entry=<optimized out>, index=<optimized out>) at /data/src/10.6/storage/innobase/row/row0ins.cc:3275 #13 row_ins_index_entry_step (thr=0x7efc6c062680, node=0x7efc6c119818) at /data/src/10.6/storage/innobase/row/row0ins.cc:3441 #14 row_ins (thr=0x7efc6c062680, node=0x7efc6c119818) at /data/src/10.6/storage/innobase/row/row0ins.cc:3587 #15 row_ins_step (thr=thr@entry=0x7efc6c062680) at /data/src/10.6/storage/innobase/row/row0ins.cc:3727 #16 0x000055deee353c09 in row_insert_for_mysql (mysql_rec=<optimized out>, prebuilt=0x7efc6c119270, ins_mode=ROW_INS_NORMAL) at /data/src/10.6/storage/innobase/row/row0mysql.cc:1313 #17 0x000055deee2a4ce6 in ha_innobase::write_row (this=0x7efc6c195e30, record=0x7efc6c0fafb0 "\200\240\071") at /data/src/10.6/storage/innobase/handler/ha_innodb.cc:7935 #18 0x000055deedf9426f in handler::ha_write_row (this=0x7efc6c195e30, buf=0x7efc6c0fafb0 "\200\240\071") at /data/src/10.6/sql/handler.cc:7549 #19 0x000055deedd1a67d in write_record (thd=thd@entry=0x7efc6c000c58, table=table@entry=0x7efc6c195a08, info=info@entry=0x7efcd0763ce0, sink=sink@entry=0x0) at /data/src/10.6/sql/sql_insert.cc:2156 #20 0x000055deedd24114 in mysql_insert (thd=thd@entry=0x7efc6c000c58, table_list=<optimized out>, fields=..., values_list=..., update_fields=..., update_values=..., duplic=DUP_ERROR, ignore=false, result=0x0) at /data/src/10.6/sql/sql_insert.cc:1128 #21 0x000055deedd57654 in mysql_execute_command (thd=0x7efc6c000c58, is_called_from_prepared_stmt=<optimized out>) at /data/src/10.6/sql/sql_parse.cc:4565 #22 0x000055deedd5bdb7 in mysql_parse (thd=0x7efc6c000c58, rawbuf=<optimized out>, length=<optimized out>, parser_state=<optimized out>) at /data/src/10.6/sql/sql_parse.cc:8030 #23 0x000055deedd5e67d in dispatch_command (command=COM_QUERY, thd=0x7efc6c000c58, packet=<optimized out>, packet_length=<optimized out>, blocking=<optimized out>) at /data/src/10.6/sql/sql_class.h:234 #24 0x000055deedd60332 in do_command (thd=0x7efc6c000c58, blocking=blocking@entry=true) at /data/src/10.6/sql/sql_parse.cc:1409 #25 0x000055deede6b12f in do_handle_one_connection (connect=<optimized out>, put_in_cache=true) at /data/src/10.6/sql/sql_connect.cc:1418 #26 0x000055deede6b47d in handle_one_connection (arg=arg@entry=0x55def02c0988) at /data/src/10.6/sql/sql_connect.cc:1312 #27 0x000055deee1ecf42 in pfs_spawn_thread (arg=0x55def02762e8) at /data/src/10.6/storage/perfschema/pfs.cc:2201 #28 0x00007efcd78a1ea7 in start_thread (arg=<optimized out>) at pthread_create.c:477 #29 0x00007efcd74b8def in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95

Marko Mäkelä added a comment - 2025-02-28 05:32

MariaDB Server 10.6 and later fail differently, because ~~MDEV-13542~~ refactored some of the code. Several callers of the SPATIAL INDEX related function rtr_page_get_father_block() fail to check for a nullptr return value, which would indicate corruption.

Marko Mäkelä added a comment - 2025-02-28 05:32 MariaDB Server 10.6 and later fail differently, because MDEV-13542 refactored some of the code. Several callers of the SPATIAL INDEX related function rtr_page_get_father_block() fail to check for a nullptr return value, which would indicate corruption.

People

Assignee:: Marko Mäkelä

Reporter:: Elena Stepanova

Votes:: 0 Vote for this issue

Watchers:: 3 Start watching this issue

Dates

Created:: 2022-01-29 00:21

Updated:: 2025-02-28 05:42

Git Integration

Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.