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

ColumnStore engine is not available after community server installation

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Open (View Workflow)
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: 1.5.5
    • Fix Version/s: None
    • Component/s: installation
    • Labels:
      None

      Description

      Build tested: 1.5.5-1 (hasty BB, build #34250)

      Tested on Centos 7

      When installing the engine package, I encountered the following error:

      checking for engine columnstore...
      columnstore doesn't exist
      There was an error installing MariaDB ColumnStore engine plugin. Continue to install the engine though. \
      Please resolve the issues and run necessary scripts manually.
      Populating the engine initial system catalog.

      The columnstore engine is not available in the server, even after I restarted the server.

      MariaDB [(none)]> show engines;
      ----------------------------------------------------------------------------------------------------------------------------------------------------+

      Engine Support Comment Transactions XA Savepoints

      ----------------------------------------------------------------------------------------------------------------------------------------------------+

      CSV YES Stores tables as CSV files NO NO NO
      MRG_MyISAM YES Collection of identical MyISAM tables NO NO NO
      MEMORY YES Hash based, stored in memory, useful for temporary tables NO NO NO
      Aria YES Crash-safe tables with MyISAM heritage. Used for internal temporary tables and privilege tables NO NO NO
      MyISAM YES Non-transactional engine with good performance and small data footprint NO NO NO
      SEQUENCE YES Generated tables filled with sequential values YES NO YES
      InnoDB DEFAULT Supports transactions, row-level locking, foreign keys and encryption for tables YES YES YES
      PERFORMANCE_SCHEMA YES Performance Schema NO NO NO

      ----------------------------------------------------------------------------------------------------------------------------------------------------+
      8 rows in set (0.001 sec)

      There is no err log files in the /var/lib/mysql directory

      Process status of both mariadb and mariadb-columnstore:

      [centos7:root~]# systemctl status mariadb
      ● mariadb.service - MariaDB 10.5.5 database server
      Loaded: loaded (/usr/lib/systemd/system/mariadb.service; disabled; vendor preset: disabled)
      Drop-In: /etc/systemd/system/mariadb.service.d
      └─migrated-from-my.cnf-settings.conf
      Active: active (running) since Fri 2020-07-24 19:06:51 UTC; 11min ago
      Docs: man:mariadbd(8)
      https://mariadb.com/kb/en/library/systemd/
      Process: 13388 ExecStartPost=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS)
      Process: 13346 ExecStartPre=/bin/sh -c [ ! -e /usr/bin/galera_recovery ] && VAR= || VAR=`cd /usr/bin/..; /usr/bin/galera_recovery`; [ $? -eq 0 ] && systemctl set-environment _WSREP_START_POSITION=$VAR || exit 1 (code=exited, status=0/SUCCESS)
      Process: 13344 ExecStartPre=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS)
      Main PID: 13372 (mariadbd)
      Status: "Taking your SQL requests now..."
      CGroup: /system.slice/mariadb.service
      └─13372 /usr/sbin/mariadbd

      Jul 24 19:06:51 localhost.localdomain mariadbd[13372]: 2020-07-24 19:06:51 0 [Note] InnoDB: 10.5.5 started; log sequence number 56462; transaction id 49
      Jul 24 19:06:51 localhost.localdomain mariadbd[13372]: 2020-07-24 19:06:51 0 [Note] Plugin 'FEEDBACK' is disabled.
      Jul 24 19:06:51 localhost.localdomain mariadbd[13372]: 2020-07-24 19:06:51 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
      Jul 24 19:06:51 localhost.localdomain mariadbd[13372]: 2020-07-24 19:06:51 0 [Note] InnoDB: Buffer pool(s) load completed at 200724 19:06:51
      Jul 24 19:06:51 localhost.localdomain mariadbd[13372]: 2020-07-24 19:06:51 0 [Note] Server socket created on IP: '::'.
      Jul 24 19:06:51 localhost.localdomain mariadbd[13372]: 2020-07-24 19:06:51 0 [Note] Reading of all Master_info entries succeeded
      Jul 24 19:06:51 localhost.localdomain mariadbd[13372]: 2020-07-24 19:06:51 0 [Note] Added new Master_info '' to hash table
      Jul 24 19:06:51 localhost.localdomain mariadbd[13372]: 2020-07-24 19:06:51 0 [Note] /usr/sbin/mariadbd: ready for connections.
      Jul 24 19:06:51 localhost.localdomain mariadbd[13372]: Version: '10.5.5-MariaDB' socket: '/var/lib/mysql/mysql.sock' port: 3306 MariaDB Server
      Jul 24 19:06:51 localhost.localdomain systemd[1]: Started MariaDB 10.5.5 database server.
      Hint: Some lines were ellipsized, use -l to show in full.
      [centos7:root~]#
      [centos7:root~]# systemctl status mariadb-columnstore
      ● mariadb-columnstore.service - mariadb-columnstore
      Loaded: loaded (/usr/lib/systemd/system/mariadb-columnstore.service; enabled; vendor preset: disabled)
      Active: active (exited) since Fri 2020-07-24 19:04:37 UTC; 13min ago
      Main PID: 12978 (code=exited, status=0/SUCCESS)
      CGroup: /system.slice/mariadb-columnstore.service

      Jul 24 19:04:31 localhost.localdomain systemd[1]: Starting mariadb-columnstore...
      Jul 24 19:04:37 localhost.localdomain systemd[1]: Started mariadb-columnstore.

        Attachments

          Activity

            People

            Assignee:
            Unassigned
            Reporter:
            dleeyh Daniel Lee
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Dates

              Created:
              Updated: