Details
-
Bug
-
Status: Closed (View Workflow)
-
Critical
-
Resolution: Won't Do
-
1.2.3
-
None
-
um1-pm1/ centOS7
Description
ExeMgr stops processing queries with set infinidb_vtable_mode 2
the problem was observed after passing queries in infinidb_vtable_mode=2
several queries was killed and it was received ERROR ExeMgr has caught an exception.
then although switching back explicitly to infinidb_vtable_mode=1 all queries send to columnsrore hangs.
ERROR: ExeMgr has caught an exception. ExeMgr: error projecting rows for tableOID: 100; rowCnt: 8192; prevTotRowCnt: 662040; InetStreamSocket::write error: Broken pipe -- write from InetStreamSocket: sd: 56 inet: 172.20.2.206 port: 33034
|
|
MariaDB [(none)]> select count(*) from foo1_1.item ;
|
|
|
query hangs //table item contains 18000 row only
|
[root@um1 mariadb]# mcsadmin getsystemi
|
|
|
WARNING: running on non Parent OAM Module, can't make configuration changes in this session.
|
Access Console from 'pm1' if you need to make changes.
|
|
|
getsysteminfo Thu Feb 28 15:36:32 2019
|
|
|
System columnstore-1
|
|
|
System and Module statuses
|
|
|
Component Status Last Status Change
|
------------ -------------------------- ------------------------
|
System ACTIVE Mon Feb 25 17:28:07 2019
|
|
|
Module um1 ACTIVE Mon Feb 25 17:28:03 2019
|
Module pm1 ACTIVE Mon Feb 25 17:27:53 2019
|
|
|
Active Parent OAM Performance Module is 'pm1'
|
MariaDB ColumnStore Replication Feature is enabled
|
MariaDB ColumnStore set for Distributed Install
|
|
|
|
|
MariaDB ColumnStore Process statuses
|
|
|
Process Module Status Last Status Change Process ID
|
------------------ ------ --------------- ------------------------ ----------
|
ProcessMonitor um1 ACTIVE Mon Feb 25 01:36:49 2019 7941
|
ServerMonitor um1 ACTIVE Mon Feb 25 17:27:51 2019 27573
|
DBRMWorkerNode um1 ACTIVE Mon Feb 25 17:27:52 2019 27605
|
ExeMgr um1 ACTIVE Mon Feb 25 17:27:56 2019 27652
|
DDLProc um1 ACTIVE Mon Feb 25 17:28:00 2019 27700
|
DMLProc um1 ACTIVE Mon Feb 25 17:28:04 2019 27713
|
mysqld um1 ACTIVE Mon Feb 25 17:27:48 2019 27497
|
|
|
ProcessMonitor pm1 ACTIVE Mon Feb 25 01:36:31 2019 7874
|
ProcessManager pm1 ACTIVE Mon Feb 25 01:36:38 2019 7974
|
DBRMControllerNode pm1 ACTIVE Mon Feb 25 17:27:47 2019 17901
|
ServerMonitor pm1 ACTIVE Mon Feb 25 17:27:49 2019 17919
|
DBRMWorkerNode pm1 ACTIVE Mon Feb 25 17:27:49 2019 17951
|
PrimProc pm1 ACTIVE Mon Feb 25 17:27:53 2019 18050
|
WriteEngineServer pm1 ACTIVE Mon Feb 25 17:27:54 2019 18075
|
|
|
Active Alarm Counts: Critical = 2, Major = 1, Minor = 0, Warning = 0, Info = 0
|
|
MariaDB [(none)]> show processlist ;
|
+-----+-------------+-----------+--------------------+---------+-------+--------------------------+------------------------------------------------------------------------------------------------------+----------+
|
| Id | User | Host | db | Command | Time | State | Info | Progress |
|
+-----+-------------+-----------+--------------------+---------+-------+--------------------------+------------------------------------------------------------------------------------------------------+----------+
|
| 1 | system user | | NULL | Daemon | NULL | InnoDB purge coordinator | NULL | 0.000 |
|
| 2 | system user | | NULL | Daemon | NULL | InnoDB purge worker | NULL | 0.000 |
|
| 4 | system user | | NULL | Daemon | NULL | InnoDB purge worker | NULL | 0.000 |
|
| 3 | system user | | NULL | Daemon | NULL | InnoDB purge worker | NULL | 0.000 |
|
| 5 | system user | | NULL | Daemon | NULL | InnoDB shutdown handler | NULL | 0.000 |
|
| 197 | root | localhost | information_schema | Sleep | 15324 | | NULL | 0.000 |
|
| 246 | root | um1:43888 | tpcds_1 | Killed | 10859 | Sending data | with v1 as( select i_category, i_brand, s_store_name, s_company_name, d_year, d_moy | 0.000 |
|
| 254 | root | um1:57134 | tpcds_1 | Killed | 7058 | Executing | create temporary table infinidb_vtable.$vtable_254 engine = aria as select sum(ss_quantity) from st | 0.000 |
|
| 259 | root | um1:37260 | tpcds_1 | Killed | 4639 | Executing | create temporary table infinidb_vtable.$vtable_259 engine = aria as select channel, item, TRIM(TRAIL | 0.000 |
|
| 263 | root | um1:39574 | tpcds_1 | Killed | 3984 | Executing | create temporary table infinidb_vtable.$vtable_263 engine = aria as select s_store_name ,s_co | 0.000 |
|
| 269 | root | um1:39962 | NULL | Killed | 3879 | Executing | create temporary table infinidb_vtable.$vtable_269 engine = aria as select count(*) from tpcds_1.ca | 0.000 |
|
| 270 | root | localhost | NULL | Killed | 3468 | Executing | create temporary table infinidb_vtable.$vtable_270 engine = aria as select count(*) from tpcds_1.cal | 0.000 |
|
| 278 | root | um1:40880 | tpcds_1 | Killed | 3621 | Executing | create temporary table infinidb_vtable.$vtable_278 engine = aria as select dt.d_year ,item.i_bran | 0.000 |
|
| 284 | root | um1:41210 | NULL | Killed | 3529 | Executing | create temporary table infinidb_vtable.$vtable_284 engine = aria as select count(*) from tpcds_1.ca | 0.000 |
|
| 289 | root | localhost | NULL | Killed | 3387 | Executing | create temporary table infinidb_vtable.$vtable_289 engine = aria as select count(*) from tpcds_1.ite | 0.000 |
|
| 293 | root | localhost | NULL | Killed | 2731 | Executing | create temporary table infinidb_vtable.$vtable_293 engine = aria as select count(*) from tpcds_1.ite | 0.000 |
|
| 296 | root | localhost | NULL | Query | 2681 | Executing | create temporary table infinidb_vtable.$vtable_296 engine = aria as select count(*) from foo1_1.item | 0.000 |
|
| 297 | root | localhost | NULL | Query | 0 | Init | show processlist | 0.000 |
|
+-----+-------------+-----------+--------------------+---------+-------+--------------------------+------------------------------------------------------------------------------------------------------+----------+
|
18 rows in set (0.000 sec)
|
|
|
|
Attachments
Issue Links
- relates to
-
-
- Closed
-