Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
1.2.5, 1.4.0
-
CentOS 7
-
2019-06
Description
Bulk writes through mcsapi are still possible after setting ColumnStore into read only mode through "mcsadmin suspenddatabasewrites".
How to reproduce:
...
|
Starting MariaDB ColumnStore Database Platform Starting, please wait ........ DONE
|
|
|
System Catalog Successfull Created
|
|
|
MariaDB ColumnStore Install Successfully Completed, System is Active
|
|
|
Enter the following command to define MariaDB ColumnStore Alias Commands
|
|
|
. /etc/profile.d/columnstoreAlias.sh
|
|
|
Enter 'mcsmysql' to access the MariaDB ColumnStore SQL console
|
Enter 'mcsadmin' to access the MariaDB ColumnStore Admin console
|
|
|
NOTE: The MariaDB ColumnStore Alias Commands are in /etc/profile.d/columnstoreAlias.sh
|
|
|
[root@centos7 ~]# . /etc/profile.d/columnstoreAlias.sh
|
[root@centos7 ~]# mcsmysql test -e "CREATE TABLE tmp1 (i int) engine=columnstore;"
|
[root@centos7 ~]# mcsadmin suspenddatabasewrites
|
suspenddatabasewrites Mon Oct 28 10:10:45 2019
|
|
|
This command suspends the DDL/DML writes to the MariaDB ColumnStore Database
|
Do you want to proceed: (y or n) [n]: y
|
|
|
Suspend MariaDB Columnstore Database Writes Request successfully completed
|
[root@centos7 ~]# mcsadmin getsysteminfo
|
getsysteminfo Mon Oct 28 10:10:57 2019
|
|
|
System columnstore-1
|
|
|
System and Module statuses
|
|
|
Component Status Last Status Change
|
------------ -------------------------- ------------------------
|
System ACTIVE WRITE SUSPENDED Mon Oct 28 10:09:47 2019
|
|
|
Module pm1 ACTIVE Mon Oct 28 10:09:39 2019
|
|
|
|
|
MariaDB ColumnStore Process statuses
|
|
|
Process Module Status Last Status Change Process ID
|
------------------ ------ --------------- ------------------------ ----------
|
ProcessMonitor pm1 ACTIVE Mon Oct 28 10:09:05 2019 13725
|
ProcessManager pm1 ACTIVE Mon Oct 28 10:09:11 2019 13981
|
DBRMControllerNode pm1 ACTIVE Mon Oct 28 10:09:18 2019 14401
|
ServerMonitor pm1 ACTIVE Mon Oct 28 10:09:21 2019 14420
|
DBRMWorkerNode pm1 ACTIVE Mon Oct 28 10:09:21 2019 14476
|
PrimProc pm1 ACTIVE Mon Oct 28 10:09:24 2019 14509
|
ExeMgr pm1 ACTIVE Mon Oct 28 10:09:29 2019 14841
|
WriteEngineServer pm1 WRITE_SUSPEND Mon Oct 28 10:09:33 2019 14910
|
DDLProc pm1 WRITE_SUSPEND Mon Oct 28 10:09:37 2019 14983
|
DMLProc pm1 WRITE_SUSPEND Mon Oct 28 10:09:46 2019 15053
|
mysqld pm1 ACTIVE Mon Oct 28 10:09:27 2019 14329
|
|
|
Active Alarm Counts: Critical = 0, Major = 0, Minor = 0, Warning = 0, Info = 0
|
[root@centos7 ~]# python3
|
Python 3.6.8 (default, Aug 7 2019, 17:28:10)
|
[GCC 4.8.5 20150623 (Red Hat 4.8.5-39)] on linux
|
Type "help", "copyright", "credits" or "license" for more information.
|
>>> import pymcsapi
|
>>> d = pymcsapi.ColumnStoreDriver()
|
>>> b = d.createBulkInsert("test", "tmp1", 0, 0)
|
>>> b.setColumn(0, 42)
|
[<pymcsapi.ColumnStoreBulkInsert; proxy of <Swig Object of type 'mcsapi::ColumnStoreBulkInsert *' at 0x7f066611be40> >, 0]
|
>>> b.writeRow()
|
<pymcsapi.ColumnStoreBulkInsert; proxy of <Swig Object of type 'mcsapi::ColumnStoreBulkInsert *' at 0x7f066611be10> >
|
>>> b.commit()
|
>>> exit()
|
[root@centos7 ~]# mcsmysql test -e "SELECT * FROM tmp1;"
|
+------+
|
| i |
|
+------+
|
| 42 |
|
+------+
|
[root@centos7 ~]# mcsadmin getsysteminfo
|
getsysteminfo Mon Oct 28 10:13:14 2019
|
|
|
System columnstore-1
|
|
|
System and Module statuses
|
|
|
Component Status Last Status Change
|
------------ -------------------------- ------------------------
|
System ACTIVE WRITE SUSPENDED Mon Oct 28 10:09:47 2019
|
|
|
Module pm1 ACTIVE Mon Oct 28 10:09:39 2019
|
|
|
|
|
MariaDB ColumnStore Process statuses
|
|
|
Process Module Status Last Status Change Process ID
|
------------------ ------ --------------- ------------------------ ----------
|
ProcessMonitor pm1 ACTIVE Mon Oct 28 10:09:05 2019 13725
|
ProcessManager pm1 ACTIVE Mon Oct 28 10:09:11 2019 13981
|
DBRMControllerNode pm1 ACTIVE Mon Oct 28 10:09:18 2019 14401
|
ServerMonitor pm1 ACTIVE Mon Oct 28 10:09:21 2019 14420
|
DBRMWorkerNode pm1 ACTIVE Mon Oct 28 10:09:21 2019 14476
|
PrimProc pm1 ACTIVE Mon Oct 28 10:09:24 2019 14509
|
ExeMgr pm1 ACTIVE Mon Oct 28 10:09:29 2019 14841
|
WriteEngineServer pm1 WRITE_SUSPEND Mon Oct 28 10:09:33 2019 14910
|
DDLProc pm1 WRITE_SUSPEND Mon Oct 28 10:09:37 2019 14983
|
DMLProc pm1 WRITE_SUSPEND Mon Oct 28 10:09:46 2019 15053
|
mysqld pm1 ACTIVE Mon Oct 28 10:09:27 2019 14329
|
|
|
Active Alarm Counts: Critical = 0, Major = 0, Minor = 0, Warning = 0, Info = 0
|
[root@centos7 ~]#
|