Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-27675

Index corruption / assertion failure in rtr_page_get_father_node_ptr with spatial key

    XMLWordPrintable

Details

    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

          Activity

            People

              marko Marko Mäkelä
              elenst Elena Stepanova
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:

                Git Integration

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