[#MDEV-24359] Spider crashes with SISEGV in spider_bgs

When running multiple repeated SELECT queries in parallel, the server crashes on signal 11. The log is included.

select * from POLOHY where id_obj = $RANDOM and timeunit >= '$TF' and timeunit < '$TT'

CREATE TABLE `POLOHY` (

  `ID_PACK` bigint(20) DEFAULT NULL,

  `ID_OBJ` int(10) unsigned DEFAULT NULL,

  `TIMEEVENT` datetime DEFAULT NULL,

  `TIMEUNIT` datetime DEFAULT NULL,

  `LO` double DEFAULT NULL,

  `LA` double DEFAULT NULL,

  `VE` float DEFAULT NULL,

  `GPS` tinyint(1) DEFAULT NULL,

  `CR` smallint(2) DEFAULT NULL,

  `ARCH` char(1) DEFAULT NULL,

  `ID_ACTION` int(11) DEFAULT NULL,

   ID_UNIQ bigint(20) unsigned AUTO_INCREMENT,

  PRIMARY KEY `idx_idobjtimeunit` (`ID_OBJ`,`TIMEUNIT`, ID_UNIQ),

  KEY `idx_timeevent` (`TIMEEVENT`),

  KEY  idx_uniq (ID_UNIQ)

) ENGINE=spider DEFAULT CHARSET=UTF8 COMMENT='wrapper "mysql", table "POLOHY"'

 PARTITION by HASH(ID_OBJ)

 partition b1 COMMENT='srv "b1"',

 partition b2 COMMENT='srv "b2"',

 partition b3 COMMENT='srv "b3"'

);

Please, let me know if you would need database schema or data in the database, I will try to isolate them.

[mysqld]

spider_bgs_mode = 2

auto_increment_increment = 3

auto_increment_offset = 1

spider_auto_increment_mode = 3

[MDEV-24359] Spider crashes with SISEGV in spider_bgs_mode 2 Created: 2020-12-07 Updated: 2023-05-23
Status:	Open
Project:	MariaDB Server
Component/s:	Storage Engine - Spider
Affects Version/s:	10.3.27
Fix Version/s:	10.3