Uploaded image for project: 'MariaDB ColumnStore'
  1. MariaDB ColumnStore
  2. MCOL-3576

bulk writes still possible after mcsadmin suspenddatabasewrites

    XMLWordPrintable

    Details

    • Sprint:
      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 ~]#
      

        Attachments

          Activity

            People

            Assignee:
            dleeyh Daniel Lee
            Reporter:
            jens.rowekamp Jens Röwekamp
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved: