Details
-
Bug
-
Status: Open (View Workflow)
-
Major
-
Resolution: Unresolved
-
10.3.27
-
Ubuntu 18.04.04 LTS, Docker (Ubuntu Focal in the container), Spider
Description
Hi,
When running multiple repeated SELECT queries in parallel, the server crashes on signal 11. The log is included.
All the queries look like:
select * from POLOHY where id_obj = $RANDOM and timeunit >= '$TF' and timeunit < '$TT' |
The table POLOHY is spider-partitioned on id_obj:
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"' |
);
|
The backend tables us MyRocks engine.
Please, let me know if you would need database schema or data in the database, I will try to isolate them.
spider.cnf:
[mysqld]
|
spider_bgs_mode = 2
|
auto_increment_increment = 3
|
auto_increment_offset = 1
|
spider_auto_increment_mode = 3
|