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

columnstore-docker-cluster: custom cross engine join user not able to connect

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 5.4.1
    • Component/s: Docker
    • Labels:
    • Environment:
      mariadb/skysql-enterprise-columnstore-handoff:sky-5.4.1-RC2 - c19bae56760e

      Description

      If custom credentials for the cross engine join user are provided, we are getting warning messages in `mariadb-error.log` that the access for the cross engine join user was denied.

      It seems like that the password with special characters isn't injected correctly into `Columnstore.xml`.

      How to reproduce:

      jens@ubuntu18:~/columnstore-docker-cluster$ cat .env
      # S3 Variables
      ASYNC_CONN=0
      ANALYTICS_ONLY=0
      USE_S3_STORAGE=0
      S3_BUCKET=
      S3_ENDPOINT=
      S3_REGION=
      S3_ACCESS_KEY_ID=
      S3_SECRET_ACCESS_KEY=
       
      # Host Variables
      PM1=mcs1
      PM2=mcs2
      PM3=mcs3
      MX1=mx1
       
      # Credentials
      CMAPI_KEY=
      ADMIN_USER=
      ADMIN_PASS=
      ADMIN_HOST=
      CEJ_USER=skysql_cej
      CEJ_PASS=h1&9I2i==N4=.iWh=E!wE.7ZNiT-?rf2
      CEJ_HOST=
      MAX_USER=
      MAX_PASS=
      MAX_HOST=
      REP_USER=
      REP_PASS=
      REP_HOST=
      

      jens@ubuntu18:~/columnstore-docker-cluster$ docker-compose up -d
      Creating network "columnstore-docker-cluster_default" with the default driver
      Creating volume "columnstore-docker-cluster_data1" with default driver
      Creating volume "columnstore-docker-cluster_data2" with default driver
      Creating volume "columnstore-docker-cluster_data3" with default driver
      Creating volume "columnstore-docker-cluster_storagemanager" with default driver
      Creating mcs3 ... done
      Creating mcs2 ... done
      Creating mcs1 ... done
      Creating mx1  ... done
      

      jens@ubuntu18:~/columnstore-docker-cluster$ docker exec -it mcs1 demo
      Adding PM1 to cluster ... done
      Adding PM2 to cluster ... done
      Adding PM3 to cluster ... done
      Validating ... done
      Adding PM1 to MaxScale ... done
      Adding PM2 to MaxScale ... done
      Adding PM3 to MaxScale ... done
      Adding service ... done
      Adding listener ... done
      Adding monitor ... done
      

      jens@ubuntu18:~/columnstore-docker-cluster$ docker exec -it mcs1 cat /var/log/mariadb/columnstore/mariadb-error.log
      2020-09-23 10:25:14 0 [Warning] Plugin 'Columnstore' is of maturity level gamma while the server is stable
      2020-09-23 10:25:14 0 [Warning] Plugin 'COLUMNSTORE_COLUMNS' is of maturity level gamma while the server is stable
      2020-09-23 10:25:14 0 [Warning] Plugin 'COLUMNSTORE_TABLES' is of maturity level gamma while the server is stable
      2020-09-23 10:25:14 0 [Warning] Plugin 'COLUMNSTORE_FILES' is of maturity level gamma while the server is stable
      2020-09-23 10:25:14 0 [Warning] Plugin 'COLUMNSTORE_EXTENTS' is of maturity level gamma while the server is stable
      200923 10:25:14 Columnstore: Started; Version: 1.5.4-1
      2020-09-23 10:25:14 0 [Note] mariadbd: Aria engine: starting recovery
      recovered pages: 0% 10% 20% 30% 43% 53% 88% 99% 100% (0.0 seconds); tables to flush: 2 1 0
       (0.0 seconds);
      2020-09-23 10:25:14 0 [Note] mariadbd: Aria engine: recovery done
      2020-09-23 10:25:14 0 [Note] InnoDB: Using Linux native AIO
      2020-09-23 10:25:14 0 [Note] InnoDB: Uses event mutexes
      2020-09-23 10:25:14 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
      2020-09-23 10:25:14 0 [Note] InnoDB: Number of pools: 1
      2020-09-23 10:25:14 0 [Note] InnoDB: Using SSE4.2 crc32 instructions
      2020-09-23 10:25:14 0 [Note] mariadbd: O_TMPFILE is not supported on /tmp (disabling future attempts)
      2020-09-23 10:25:14 0 [Note] InnoDB: Initializing buffer pool, total size = 134217728, chunk size = 134217728
      2020-09-23 10:25:14 0 [Note] InnoDB: Completed initialization of buffer pool
      2020-09-23 10:25:14 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
      2020-09-23 10:25:14 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=56438
      2020-09-23 10:25:14 0 [Note] InnoDB: 128 rollback segments are active.
      2020-09-23 10:25:14 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
      2020-09-23 10:25:14 0 [Note] InnoDB: Creating shared tablespace for temporary tables
      2020-09-23 10:25:14 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
      2020-09-23 10:25:14 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
      2020-09-23 10:25:14 0 [Note] InnoDB: 10.5.5 started; log sequence number 56450; transaction id 49
      2020-09-23 10:25:14 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
      2020-09-23 10:25:14 0 [Note] Plugin 'FEEDBACK' is disabled.
      2020-09-23 10:25:14 server_audit: MariaDB Audit Plugin version 2.0.2 STARTED.
      2020-09-23 10:25:14 server_audit: Query cache is enabled with the TABLE events. Some table reads can be veiled.
      2020-09-23 10:25:14 0 [Note] InnoDB: Buffer pool(s) load completed at 200923 10:25:14
      2020-09-23 10:25:14 0 [Note] Server socket created on IP: '::'.
      2020-09-23 10:25:14 0 [Note] Reading of all Master_info entries succeeded
      2020-09-23 10:25:14 0 [Note] Added new Master_info '' to hash table
      2020-09-23 10:25:14 0 [Note] /usr/sbin/mariadbd: ready for connections.
      Version: '10.5.5-3-MariaDB-enterprise-log'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  MariaDB Enterprise Server
      2020-09-23 10:25:15 0 [Note] /usr/sbin/mariadbd (initiated by: unknown): Normal shutdown
      2020-09-23 10:25:15 0 [Note] Event Scheduler: Purging the queue. 0 events
      2020-09-23 10:25:15 0 [Note] InnoDB: FTS optimize thread exiting.
      2020-09-23 10:25:15 server_audit: STOPPED
      2020-09-23 10:25:15 0 [Note] InnoDB: Starting shutdown...
      2020-09-23 10:25:15 0 [Note] InnoDB: Dumping buffer pool(s) to /var/lib/mysql/ib_buffer_pool
      2020-09-23 10:25:15 0 [Note] InnoDB: Buffer pool(s) dump completed at 200923 10:25:15
      2020-09-23 10:25:16 0 [Note] InnoDB: Shutdown completed; log sequence number 56474; transaction id 50
      2020-09-23 10:25:16 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
      2020-09-23 10:25:16 0 [Note] /usr/sbin/mariadbd: Shutdown complete
       
      2020-09-23 10:25:47 0 [Warning] Plugin 'Columnstore' is of maturity level gamma while the server is stable
      2020-09-23 10:25:47 0 [Warning] Plugin 'COLUMNSTORE_COLUMNS' is of maturity level gamma while the server is stable
      2020-09-23 10:25:47 0 [Warning] Plugin 'COLUMNSTORE_TABLES' is of maturity level gamma while the server is stable
      2020-09-23 10:25:47 0 [Warning] Plugin 'COLUMNSTORE_FILES' is of maturity level gamma while the server is stable
      2020-09-23 10:25:47 0 [Warning] Plugin 'COLUMNSTORE_EXTENTS' is of maturity level gamma while the server is stable
      200923 10:25:47 Columnstore: Started; Version: 1.5.4-1
      2020-09-23 10:25:47 0 [Note] InnoDB: Using Linux native AIO
      2020-09-23 10:25:47 0 [Note] InnoDB: Uses event mutexes
      2020-09-23 10:25:47 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
      2020-09-23 10:25:47 0 [Note] InnoDB: Number of pools: 1
      2020-09-23 10:25:47 0 [Note] InnoDB: Using SSE4.2 crc32 instructions
      2020-09-23 10:25:47 0 [Note] mariadbd: O_TMPFILE is not supported on /tmp (disabling future attempts)
      2020-09-23 10:25:47 0 [Note] InnoDB: Initializing buffer pool, total size = 134217728, chunk size = 134217728
      2020-09-23 10:25:47 0 [Note] InnoDB: Completed initialization of buffer pool
      2020-09-23 10:25:47 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
      2020-09-23 10:25:47 0 [Note] InnoDB: 128 rollback segments are active.
      2020-09-23 10:25:47 0 [Note] InnoDB: Creating shared tablespace for temporary tables
      2020-09-23 10:25:47 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
      2020-09-23 10:25:47 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
      2020-09-23 10:25:47 0 [Note] InnoDB: 10.5.5 started; log sequence number 56474; transaction id 49
      2020-09-23 10:25:47 0 [Note] Plugin 'FEEDBACK' is disabled.
      2020-09-23 10:25:47 server_audit: MariaDB Audit Plugin version 2.0.2 STARTED.
      2020-09-23 10:25:47 server_audit: Query cache is enabled with the TABLE events. Some table reads can be veiled.
      2020-09-23 10:25:47 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
      2020-09-23 10:25:47 0 [Note] InnoDB: Buffer pool(s) load completed at 200923 10:25:47
      2020-09-23 10:25:47 0 [Note] Server socket created on IP: '::'.
      2020-09-23 10:25:47 0 [Note] Reading of all Master_info entries succeeded
      2020-09-23 10:25:47 0 [Note] Added new Master_info '' to hash table
      2020-09-23 10:25:47 0 [Note] /usr/sbin/mariadbd: ready for connections.
      Version: '10.5.5-3-MariaDB-enterprise-log'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  MariaDB Enterprise Server
      2020-09-23 10:25:48 5 [Note] Start binlog_dump to slave_server(3), pos(, 4), using_gtid(1), gtid('')
      2020-09-23 10:25:49 6 [Note] Start binlog_dump to slave_server(2), pos(, 4), using_gtid(1), gtid('')
      2020-09-23 10:26:24 7 [Warning] Access denied for user 'skysql_cej'@'mcs1' (using password: YES)
      2020-09-23 10:26:25 8 [Warning] Access denied for user 'skysql_cej'@'mcs1' (using password: YES)
      2020-09-23 10:26:26 9 [Warning] Access denied for user 'skysql_cej'@'mcs1' (using password: YES)
      2020-09-23 10:26:27 10 [Warning] Access denied for user 'skysql_cej'@'mcs1' (using password: YES)
      2020-09-23 10:26:28 11 [Warning] Access denied for user 'skysql_cej'@'mcs1' (using password: YES)
      2020-09-23 10:26:29 12 [Warning] Access denied for user 'skysql_cej'@'mcs1' (using password: YES)
      2020-09-23 10:26:30 13 [Warning] Access denied for user 'skysql_cej'@'mcs1' (using password: YES)
      2020-09-23 10:26:31 14 [Warning] Access denied for user 'skysql_cej'@'mcs1' (using password: YES)
      2020-09-23 10:26:32 15 [Warning] Access denied for user 'skysql_cej'@'mcs1' (using password: YES)
      2020-09-23 10:26:33 16 [Warning] Access denied for user 'skysql_cej'@'mcs1' (using password: YES)
      2020-09-23 10:26:34 17 [Warning] Access denied for user 'skysql_cej'@'mcs1' (using password: YES)
      2020-09-23 10:26:35 18 [Warning] Access denied for user 'skysql_cej'@'mcs1' (using password: YES)
      2020-09-23 10:26:36 19 [Warning] Access denied for user 'skysql_cej'@'mcs1' (using password: YES)
      2020-09-23 10:26:37 20 [Warning] Access denied for user 'skysql_cej'@'mcs1' (using password: YES)
      2020-09-23 10:26:38 21 [Warning] Access denied for user 'skysql_cej'@'mcs1' (using password: YES)
      2020-09-23 10:26:39 22 [Warning] Access denied for user 'skysql_cej'@'mcs1' (using password: YES)
      2020-09-23 10:26:40 23 [Warning] Access denied for user 'skysql_cej'@'mcs1' (using password: YES)
      2020-09-23 10:26:41 24 [Warning] Access denied for user 'skysql_cej'@'mcs1' (using password: YES)
      2020-09-23 10:26:42 25 [Warning] Access denied for user 'skysql_cej'@'mcs1' (using password: YES)
      2020-09-23 10:26:43 26 [Warning] Access denied for user 'skysql_cej'@'mcs1' (using password: YES)
      2020-09-23 10:26:44 27 [Warning] Access denied for user 'skysql_cej'@'mcs1' (using password: YES)
      2020-09-23 10:26:45 28 [Warning] Access denied for user 'skysql_cej'@'mcs1' (using password: YES)
      2020-09-23 10:26:46 29 [Warning] Access denied for user 'skysql_cej'@'mcs1' (using password: YES)
      2020-09-23 10:26:47 30 [Warning] Access denied for user 'skysql_cej'@'mcs1' (using password: YES)
      2020-09-23 10:26:48 31 [Warning] Access denied for user 'skysql_cej'@'mcs1' (using password: YES)
      2020-09-23 10:26:49 32 [Warning] Access denied for user 'skysql_cej'@'mcs1' (using password: YES)
      2020-09-23 10:26:50 33 [Warning] Access denied for user 'skysql_cej'@'mcs1' (using password: YES)
      2020-09-23 10:26:51 34 [Warning] Access denied for user 'skysql_cej'@'mcs1' (using password: YES)
      2020-09-23 10:26:52 35 [Warning] Access denied for user 'skysql_cej'@'mcs1' (using password: YES)
      2020-09-23 10:26:53 36 [Warning] Access denied for user 'skysql_cej'@'mcs1' (using password: YES)
      2020-09-23 10:26:54 37 [Warning] Access denied for user 'skysql_cej'@'mcs1' (using password: YES)
      2020-09-23 10:26:55 38 [Warning] Access denied for user 'skysql_cej'@'mcs1' (using password: YES)
      2020-09-23 10:26:56 39 [Warning] Access denied for user 'skysql_cej'@'mcs1' (using password: YES)
      2020-09-23 10:26:57 40 [Warning] Access denied for user 'skysql_cej'@'mcs1' (using password: YES)
      2020-09-23 10:26:58 41 [Warning] Access denied for user 'skysql_cej'@'mcs1' (using password: YES)
      2020-09-23 10:26:59 42 [Warning] Access denied for user 'skysql_cej'@'mcs1' (using password: YES)
      2020-09-23 10:27:00 43 [Warning] Access denied for user 'skysql_cej'@'mcs1' (using password: YES)
      2020-09-23 10:27:01 44 [Warning] Access denied for user 'skysql_cej'@'mcs1' (using password: YES)
      2020-09-23 10:27:02 45 [Warning] Access denied for user 'skysql_cej'@'mcs1' (using password: YES)
      2020-09-23 10:27:03 46 [Warning] Access denied for user 'skysql_cej'@'mcs1' (using password: YES)
      2020-09-23 10:27:04 47 [Warning] Access denied for user 'skysql_cej'@'mcs1' (using password: YES)
      2020-09-23 10:27:05 48 [Warning] Access denied for user 'skysql_cej'@'mcs1' (using password: YES)
      2020-09-23 10:27:06 49 [Warning] Access denied for user 'skysql_cej'@'mcs1' (using password: YES)
      2020-09-23 10:27:07 50 [Warning] Access denied for user 'skysql_cej'@'mcs1' (using password: YES)
      2020-09-23 10:27:08 51 [Warning] Access denied for user 'skysql_cej'@'mcs1' (using password: YES)
      2020-09-23 10:27:09 52 [Warning] Access denied for user 'skysql_cej'@'mcs1' (using password: YES)
      2020-09-23 10:27:10 53 [Warning] Access denied for user 'skysql_cej'@'mcs1' (using password: YES)
      2020-09-23 10:27:11 54 [Warning] Access denied for user 'skysql_cej'@'mcs1' (using password: YES)
      2020-09-23 10:27:12 55 [Warning] Access denied for user 'skysql_cej'@'mcs1' (using password: YES)
      2020-09-23 10:27:13 56 [Warning] Access denied for user 'skysql_cej'@'mcs1' (using password: YES)
      2020-09-23 10:27:14 57 [Warning] Access denied for user 'skysql_cej'@'mcs1' (using password: YES)
      2020-09-23 10:27:15 58 [Warning] Access denied for user 'skysql_cej'@'mcs1' (using password: YES)
      2020-09-23 10:27:16 59 [Warning] Access denied for user 'skysql_cej'@'mcs1' (using password: YES)
      2020-09-23 10:27:17 60 [Warning] Access denied for user 'skysql_cej'@'mcs1' (using password: YES)
      2020-09-23 10:27:18 61 [Warning] Access denied for user 'skysql_cej'@'mcs1' (using password: YES)
      2020-09-23 10:27:19 62 [Warning] Access denied for user 'skysql_cej'@'mcs1' (using password: YES)
      2020-09-23 10:27:20 63 [Warning] Access denied for user 'skysql_cej'@'mcs1' (using password: YES)
      2020-09-23 10:27:21 64 [Warning] Access denied for user 'skysql_cej'@'mcs1' (using password: YES)
      2020-09-23 10:27:22 65 [Warning] Access denied for user 'skysql_cej'@'mcs1' (using password: YES)
      2020-09-23 10:27:23 66 [Warning] Access denied for user 'skysql_cej'@'mcs1' (using password: YES)
      2020-09-23 10:27:35 67 [Warning] Access denied for user 'skysql_cej'@'mcs1' (using password: YES)
      2020-09-23 10:27:36 68 [Warning] Access denied for user 'skysql_cej'@'mcs1' (using password: YES)
      2020-09-23 10:27:37 69 [Warning] Access denied for user 'skysql_cej'@'mcs1' (using password: YES)
      2020-09-23 10:27:38 70 [Warning] Access denied for user 'skysql_cej'@'mcs1' (using password: YES)
      2020-09-23 10:27:39 71 [Warning] Access denied for user 'skysql_cej'@'mcs1' (using password: YES)
      2020-09-23 10:27:40 72 [Warning] Access denied for user 'skysql_cej'@'mcs1' (using password: YES)
      2020-09-23 10:27:41 73 [Warning] Access denied for user 'skysql_cej'@'mcs1' (using password: YES)
      2020-09-23 10:27:42 74 [Warning] Access denied for user 'skysql_cej'@'mcs1' (using password: YES)
      2020-09-23 10:27:43 75 [Warning] Access denied for user 'skysql_cej'@'mcs1' (using password: YES)
      2020-09-23 10:27:44 76 [Warning] Access denied for user 'skysql_cej'@'mcs1' (using password: YES)
      2020-09-23 10:27:45 77 [Warning] Access denied for user 'skysql_cej'@'mcs1' (using password: YES)
      2020-09-23 10:27:46 78 [Warning] Access denied for user 'skysql_cej'@'mcs1' (using password: YES)
      2020-09-23 10:27:47 79 [Warning] Access denied for user 'skysql_cej'@'mcs1' (using password: YES)
      2020-09-23 10:27:48 80 [Warning] Access denied for user 'skysql_cej'@'mcs1' (using password: YES)
      2020-09-23 10:27:49 81 [Warning] Access denied for user 'skysql_cej'@'mcs1' (using password: YES)
      2020-09-23 10:27:50 82 [Warning] Access denied for user 'skysql_cej'@'mcs1' (using password: YES)
      2020-09-23 10:27:51 83 [Warning] Access denied for user 'skysql_cej'@'mcs1' (using password: YES)
      2020-09-23 10:27:52 84 [Warning] Access denied for user 'skysql_cej'@'mcs1' (using password: YES)
      2020-09-23 10:27:53 85 [Warning] Access denied for user 'skysql_cej'@'mcs1' (using password: YES)
      2020-09-23 10:27:54 86 [Warning] Access denied for user 'skysql_cej'@'mcs1' (using password: YES)
      2020-09-23 10:27:55 87 [Warning] Access denied for user 'skysql_cej'@'mcs1' (using password: YES)
      2020-09-23 10:27:56 88 [Warning] Access denied for user 'skysql_cej'@'mcs1' (using password: YES)
      2020-09-23 10:27:57 89 [Warning] Access denied for user 'skysql_cej'@'mcs1' (using password: YES)
      2020-09-23 10:27:58 90 [Warning] Access denied for user 'skysql_cej'@'mcs1' (using password: YES)
      2020-09-23 10:27:59 91 [Warning] Access denied for user 'skysql_cej'@'mcs1' (using password: YES)
      2020-09-23 10:28:00 92 [Warning] Access denied for user 'skysql_cej'@'mcs1' (using password: YES)
      2020-09-23 10:28:01 93 [Warning] Access denied for user 'skysql_cej'@'mcs1' (using password: YES)
      2020-09-23 10:28:02 94 [Warning] Access denied for user 'skysql_cej'@'mcs1' (using password: YES)
      2020-09-23 10:28:03 95 [Warning] Access denied for user 'skysql_cej'@'mcs1' (using password: YES)
      2020-09-23 10:28:04 96 [Warning] Access denied for user 'skysql_cej'@'mcs1' (using password: YES)
      2020-09-23 10:28:06 97 [Warning] Access denied for user 'skysql_cej'@'mcs1' (using password: YES)
      2020-09-23 10:28:07 98 [Warning] Access denied for user 'skysql_cej'@'mcs1' (using password: YES)
      2020-09-23 10:28:08 99 [Warning] Access denied for user 'skysql_cej'@'mcs1' (using password: YES)
      2020-09-23 10:28:09 100 [Warning] Access denied for user 'skysql_cej'@'mcs1' (using password: YES)
      2020-09-23 10:28:10 101 [Warning] Access denied for user 'skysql_cej'@'mcs1' (using password: YES)
      2020-09-23 10:28:11 102 [Warning] Access denied for user 'skysql_cej'@'mcs1' (using password: YES)
      2020-09-23 10:28:12 103 [Warning] Access denied for user 'skysql_cej'@'mcs1' (using password: YES)
      2020-09-23 10:28:13 104 [Warning] Access denied for user 'skysql_cej'@'mcs1' (using password: YES)
      2020-09-23 10:28:14 105 [Warning] Access denied for user 'skysql_cej'@'mcs1' (using password: YES)
      2020-09-23 10:28:15 106 [Warning] Access denied for user 'skysql_cej'@'mcs1' (using password: YES)
      2020-09-23 10:28:16 107 [Warning] Access denied for user 'skysql_cej'@'mcs1' (using password: YES)
      2020-09-23 10:28:17 108 [Warning] Access denied for user 'skysql_cej'@'mcs1' (using password: YES)
      2020-09-23 10:28:18 109 [Warning] Access denied for user 'skysql_cej'@'mcs1' (using password: YES)
      2020-09-23 10:28:19 110 [Warning] Access denied for user 'skysql_cej'@'mcs1' (using password: YES)
      2020-09-23 10:28:20 111 [Warning] Access denied for user 'skysql_cej'@'mcs1' (using password: YES)
      2020-09-23 10:28:21 112 [Warning] Access denied for user 'skysql_cej'@'mcs1' (using password: YES)
      2020-09-23 10:28:22 113 [Warning] Access denied for user 'skysql_cej'@'mcs1' (using password: YES)
      2020-09-23 10:28:23 114 [Warning] Access denied for user 'skysql_cej'@'mcs1' (using password: YES)
      2020-09-23 10:28:24 115 [Warning] Access denied for user 'skysql_cej'@'mcs1' (using password: YES)
      2020-09-23 10:28:25 116 [Warning] Access denied for user 'skysql_cej'@'mcs1' (using password: YES)
      2020-09-23 10:28:26 117 [Warning] Access denied for user 'skysql_cej'@'mcs1' (using password: YES)
      2020-09-23 10:28:27 118 [Warning] Access denied for user 'skysql_cej'@'mcs1' (using password: YES)
      2020-09-23 10:28:28 119 [Warning] Access denied for user 'skysql_cej'@'mcs1' (using password: YES)
      2020-09-23 10:28:29 120 [Warning] Access denied for user 'skysql_cej'@'mcs1' (using password: YES)
      2020-09-23 10:28:30 121 [Warning] Access denied for user 'skysql_cej'@'mcs1' (using password: YES)
      2020-09-23 10:28:31 122 [Warning] Access denied for user 'skysql_cej'@'mcs1' (using password: YES)
      2020-09-23 10:28:32 123 [Warning] Access denied for user 'skysql_cej'@'mcs1' (using password: YES)
      2020-09-23 10:28:33 124 [Warning] Access denied for user 'skysql_cej'@'mcs1' (using password: YES)
      2020-09-23 10:28:34 125 [Warning] Access denied for user 'skysql_cej'@'mcs1' (using password: YES)
      2020-09-23 10:28:35 126 [Warning] Access denied for user 'skysql_cej'@'mcs1' (using password: YES)
      

      jens@ubuntu18:~/columnstore-docker-cluster$ docker exec -it mcs1 cat /etc/columnstore/Columnstore.xml
      <?xml version="1.0" ?>
      <Columnstore Version="V1.0.0">
          <!--
              WARNING: Do not make changes to this file unless directed to do so by
              MariaDB service engineers. Incorrect settings can render your system
              unusable and will require a service call to correct.
      -->
          <ExeMgr1>
              <IPAddr>mcs1</IPAddr>
              <Port>8601</Port>
              <Module>unassigned</Module>
          </ExeMgr1>
          <JobProc>
              <IPAddr>0.0.0.0</IPAddr>
              <Port>8602</Port>
          </JobProc>
          <ProcMgr>
              <IPAddr>mcs1</IPAddr>
              <Port>8603</Port>
          </ProcMgr>
          <ProcMgr_Alarm>
              <IPAddr>mcs1</IPAddr>
              <Port>8606</Port>
          </ProcMgr_Alarm>
          <ProcStatusControl>
              <IPAddr>mcs1</IPAddr>
              <Port>8604</Port>
          </ProcStatusControl>
          <ProcStatusControlStandby>
              <IPAddr>0.0.0.0</IPAddr>
              <Port>8605</Port>
          </ProcStatusControlStandby>
          <!-- Disabled
              <ProcHeartbeatControl>
                      <IPAddr>0.0.0.0</IPAddr>
                      <Port>8605</Port>
              </ProcHeartbeatControl>
              -->
          <!-- ProcessMonitor Port: 8800 - 8820 is reserved to support External Modules-->
          <localhost_ProcessMonitor>
              <IPAddr>mcs1</IPAddr>
              <Port>8800</Port>
          </localhost_ProcessMonitor>
          <dm1_ProcessMonitor>
              <IPAddr>0.0.0.0</IPAddr>
              <Port>8800</Port>
          </dm1_ProcessMonitor>
          <um1_ProcessMonitor>
              <IPAddr>0.0.0.0</IPAddr>
              <Port>8800</Port>
          </um1_ProcessMonitor>
          <pm1_ProcessMonitor>
              <IPAddr>mcs1</IPAddr>
              <Port>8800</Port>
          </pm1_ProcessMonitor>
          <dm1_ServerMonitor>
              <IPAddr>0.0.0.0</IPAddr>
              <Port>8622</Port>
          </dm1_ServerMonitor>
          <um1_ServerMonitor>
              <IPAddr>0.0.0.0</IPAddr>
              <Port>8622</Port>
          </um1_ServerMonitor>
          <pm1_ServerMonitor>
              <IPAddr>mcs1</IPAddr>
              <Port>8622</Port>
          </pm1_ServerMonitor>
          <pm1_WriteEngineServer>
              <IPAddr>mcs1</IPAddr>
              <Port>8630</Port>
          </pm1_WriteEngineServer>
          <DDLProc>
              <IPAddr>mcs1</IPAddr>
              <Port>8612</Port>
          </DDLProc>
          <DMLProc>
              <IPAddr>mcs1</IPAddr>
              <Port>8614</Port>
          </DMLProc>
          <BatchInsert>
              <RowsPerBatch>10000</RowsPerBatch>
          </BatchInsert>
          <PrimitiveServers>
              <Count>3</Count>
              <ConnectionsPerPrimProc>2</ConnectionsPerPrimProc>
              <ProcessorThreshold>128</ProcessorThreshold>
              <ProcessorQueueSize>10K</ProcessorQueueSize>
              <!-- minimum of extent size 8192 -->
              <DebugLevel>0</DebugLevel>
              <LBID_Shift>13</LBID_Shift>
              <ColScanBufferSizeBlocks>512</ColScanBufferSizeBlocks>
              <ColScanReadAheadBlocks>512</ColScanReadAheadBlocks>
              <!-- s/b factor of extent size 8192 -->
              <!-- <BPPCount>16</BPPCount> -->
              <!-- Default num cores * 2.  A cap on the number of simultaneous primitives per jobstep -->
              <PrefetchThreshold>1</PrefetchThreshold>
              <PTTrace>0</PTTrace>
              <RotatingDestination>n</RotatingDestination>
              <!-- Iterate thru UM ports; set to 'n' if UM/PM on same server -->
              <!-- <HighPriorityPercentage>60</HighPriorityPercentage> -->
              <!-- <MediumPriorityPercentage>30</MediumPriorityPercentage> -->
              <!-- <LowPriorityPercentage>10</LowPriorityPercentage> -->
              <DirectIO>y</DirectIO>
              <HighPriorityPercentage/>
              <MediumPriorityPercentage/>
              <LowPriorityPercentage/>
          </PrimitiveServers>
          <SystemConfig>
              <SystemName>columnstore-1</SystemName>
              <ParentOAMModuleName>pm1</ParentOAMModuleName>
              <StandbyOAMModuleName>unassigned</StandbyOAMModuleName>
              <PrimaryUMModuleName>pm1</PrimaryUMModuleName>
              <ModuleHeartbeatPeriod>1</ModuleHeartbeatPeriod>
              <ModuleHeartbeatCount>3</ModuleHeartbeatCount>
              <ModuleProcMonWaitCount>12</ModuleProcMonWaitCount>
                      // 2.5 minutes
              <!-- Disabled
                      <ProcessHeartbeatPeriod>-1</ProcessHeartbeatPeriod>
                      -->
              <!-- Warning: Do not change this value once database is built -->
              <DBRootCount>3</DBRootCount>
              <DBRoot1>/var/lib/columnstore/data1</DBRoot1>
              <DBRMRoot>/var/lib/columnstore/data1/systemFiles/dbrm/BRM_saves</DBRMRoot>
              <TableLockSaveFile>/var/lib/columnstore/data1/systemFiles/dbrm/tablelocks</TableLockSaveFile>
              <DBRMTimeOut>15</DBRMTimeOut>
              <!-- in seconds -->
              <DBRMSnapshotInterval>100000</DBRMSnapshotInterval>
              <ExternalCriticalThreshold>90</ExternalCriticalThreshold>
              <ExternalMajorThreshold>80</ExternalMajorThreshold>
              <ExternalMinorThreshold>70</ExternalMinorThreshold>
              <!-- <TempDiskPath>/tmp</TempDiskPath>
                      <WorkingDir>/tmp</WorkingDir>
                      <TempFileDir>/tmp/columnstore_tmp_files</TempFileDir>
                      -->
              <TransactionArchivePeriod>10</TransactionArchivePeriod>
              <NMSIPAddress>0.0.0.0</NMSIPAddress>
              <TempSaveSize>128M</TempSaveSize>
              <!-- default SWSDL max element save size -->
              <WaitPeriod>10</WaitPeriod>
              <!-- in seconds -->
              <ProcessRestartCount>10</ProcessRestartCount>
              <ProcessRestartPeriod>120</ProcessRestartPeriod>
              <SwapAction>restartSystem</SwapAction>
              <!-- OAM command (or 'none') to run when swap space exceeds Major Threshold -->
              <ActivePmFailoverDisabled>n</ActivePmFailoverDisabled>
              <MemoryCheckPercent>95</MemoryCheckPercent>
              <!-- Max real memory to limit growth of buffers to -->
              <DataFileLog>OFF</DataFileLog>
              <!-- enable if you want to limit how much memory may be used for hdfs read/write memory buffers.
                      <hdfsRdwrBufferMaxSize>8G</hdfsRdwrBufferMaxSize>
                      -->
              <hdfsRdwrScratch>/rdwrscratch</hdfsRdwrScratch>
              <!-- Do not set to an hdfs file path -->
              <TempFileDir>/columnstore_tmp_files</TempFileDir>
              <SystemTempFileDir>/tmp/columnstore_tmp_files</SystemTempFileDir>
              <DBRoot2>/var/lib/columnstore/data2</DBRoot2>
              <DBRoot3>/var/lib/columnstore/data3</DBRoot3>
          </SystemConfig>
          <SystemModuleConfig>
              <ModuleType1>dm</ModuleType1>
              <ModuleDesc1>Director Module</ModuleDesc1>
              <RunType1>SIMPLEX</RunType1>
              <ModuleCount1>0</ModuleCount1>
              <ModuleIPAddr1-1-1>0.0.0.0</ModuleIPAddr1-1-1>
              <ModuleHostName1-1-1>unassigned</ModuleHostName1-1-1>
              <ModuleDisableState1-1>ENABLED</ModuleDisableState1-1>
              <ModuleCPUCriticalThreshold1>0</ModuleCPUCriticalThreshold1>
              <ModuleCPUMajorThreshold1>0</ModuleCPUMajorThreshold1>
              <ModuleCPUMinorThreshold1>0</ModuleCPUMinorThreshold1>
              <ModuleCPUMinorClearThreshold1>0</ModuleCPUMinorClearThreshold1>
              <ModuleDiskCriticalThreshold1>90</ModuleDiskCriticalThreshold1>
              <ModuleDiskMajorThreshold1>80</ModuleDiskMajorThreshold1>
              <ModuleDiskMinorThreshold1>70</ModuleDiskMinorThreshold1>
              <ModuleMemCriticalThreshold1>90</ModuleMemCriticalThreshold1>
              <ModuleMemMajorThreshold1>0</ModuleMemMajorThreshold1>
              <ModuleMemMinorThreshold1>0</ModuleMemMinorThreshold1>
              <ModuleSwapCriticalThreshold1>90</ModuleSwapCriticalThreshold1>
              <ModuleSwapMajorThreshold1>80</ModuleSwapMajorThreshold1>
              <ModuleSwapMinorThreshold1>70</ModuleSwapMinorThreshold1>
              <ModuleDiskMonitorFileSystem1-1>/</ModuleDiskMonitorFileSystem1-1>
              <ModuleDBRootCount1-1>unassigned</ModuleDBRootCount1-1>
              <ModuleDBRootID1-1-1>unassigned</ModuleDBRootID1-1-1>
              <ModuleType2>um</ModuleType2>
              <ModuleDesc2>User Module</ModuleDesc2>
              <RunType2>SIMPLEX</RunType2>
              <ModuleCount2>0</ModuleCount2>
              <ModuleIPAddr1-1-2>0.0.0.0</ModuleIPAddr1-1-2>
              <ModuleHostName1-1-2>unassigned</ModuleHostName1-1-2>
              <ModuleDisableState1-2>ENABLED</ModuleDisableState1-2>
              <ModuleCPUCriticalThreshold2>0</ModuleCPUCriticalThreshold2>
              <ModuleCPUMajorThreshold2>0</ModuleCPUMajorThreshold2>
              <ModuleCPUMinorThreshold2>0</ModuleCPUMinorThreshold2>
              <ModuleCPUMinorClearThreshold2>0</ModuleCPUMinorClearThreshold2>
              <ModuleDiskCriticalThreshold2>90</ModuleDiskCriticalThreshold2>
              <ModuleDiskMajorThreshold2>80</ModuleDiskMajorThreshold2>
              <ModuleDiskMinorThreshold2>70</ModuleDiskMinorThreshold2>
              <ModuleMemCriticalThreshold2>90</ModuleMemCriticalThreshold2>
              <ModuleMemMajorThreshold2>0</ModuleMemMajorThreshold2>
              <ModuleMemMinorThreshold2>0</ModuleMemMinorThreshold2>
              <ModuleSwapCriticalThreshold2>90</ModuleSwapCriticalThreshold2>
              <ModuleSwapMajorThreshold2>80</ModuleSwapMajorThreshold2>
              <ModuleSwapMinorThreshold2>70</ModuleSwapMinorThreshold2>
              <ModuleDiskMonitorFileSystem1-2>/</ModuleDiskMonitorFileSystem1-2>
              <ModuleDBRootCount1-2>unassigned</ModuleDBRootCount1-2>
              <ModuleDBRootID1-1-2>unassigned</ModuleDBRootID1-1-2>
              <ModuleType3>pm</ModuleType3>
              <ModuleDesc3>Performance Module</ModuleDesc3>
              <RunType3>SIMPLEX</RunType3>
              <ModuleCount3>3</ModuleCount3>
              <ModuleIPAddr1-1-3>172.18.0.4</ModuleIPAddr1-1-3>
              <ModuleHostName1-1-3>mcs1</ModuleHostName1-1-3>
              <ModuleDisableState1-3>ENABLED</ModuleDisableState1-3>
              <ModuleCPUCriticalThreshold3>0</ModuleCPUCriticalThreshold3>
              <ModuleCPUMajorThreshold3>0</ModuleCPUMajorThreshold3>
              <ModuleCPUMinorThreshold3>0</ModuleCPUMinorThreshold3>
              <ModuleCPUMinorClearThreshold3>0</ModuleCPUMinorClearThreshold3>
              <ModuleDiskCriticalThreshold3>90</ModuleDiskCriticalThreshold3>
              <ModuleDiskMajorThreshold3>80</ModuleDiskMajorThreshold3>
              <ModuleDiskMinorThreshold3>70</ModuleDiskMinorThreshold3>
              <ModuleMemCriticalThreshold3>90</ModuleMemCriticalThreshold3>
              <ModuleMemMajorThreshold3>0</ModuleMemMajorThreshold3>
              <ModuleMemMinorThreshold3>0</ModuleMemMinorThreshold3>
              <ModuleSwapCriticalThreshold3>90</ModuleSwapCriticalThreshold3>
              <ModuleSwapMajorThreshold3>80</ModuleSwapMajorThreshold3>
              <ModuleSwapMinorThreshold3>70</ModuleSwapMinorThreshold3>
              <ModuleDiskMonitorFileSystem1-3>/</ModuleDiskMonitorFileSystem1-3>
              <ModuleDBRootCount1-3>1</ModuleDBRootCount1-3>
              <ModuleIPAddr2-1-3>172.18.0.3</ModuleIPAddr2-1-3>
              <ModuleHostName2-1-3>mcs2</ModuleHostName2-1-3>
              <ModuleDBRootCount2-3>1</ModuleDBRootCount2-3>
              <ModuleIPAddr3-1-3>172.18.0.2</ModuleIPAddr3-1-3>
              <ModuleHostName3-1-3>mcs3</ModuleHostName3-1-3>
              <ModuleDBRootCount3-3>1</ModuleDBRootCount3-3>
              <ModuleDBRootID1-1-3>1</ModuleDBRootID1-1-3>
              <ModuleDBRootID2-1-3>2</ModuleDBRootID2-1-3>
              <ModuleDBRootID3-1-3>3</ModuleDBRootID3-1-3>
          </SystemModuleConfig>
          <SystemExtDeviceConfig>
              <Count>0</Count>
              <Name1>unassigned</Name1>
              <IPAddr1>0.0.0.0</IPAddr1>
              <DisableState1>ENABLED</DisableState1>
          </SystemExtDeviceConfig>
          <SessionManager>
              <MaxConcurrentTransactions>1000</MaxConcurrentTransactions>
              <TxnIDFile>/var/lib/columnstore/data1/systemFiles/dbrm/SMTxnID</TxnIDFile>
          </SessionManager>
          <VersionBuffer>
              <!-- VersionBufferFileSize must be a multiple of 8192.
                      One version buffer file will be put on each DB root. -->
              <VersionBufferFileSize>1GB</VersionBufferFileSize>
          </VersionBuffer>
          <OIDManager>
              <!-- Do not change this file after database built        -->
              <OIDBitmapFile>/var/lib/columnstore/data1/systemFiles/dbrm/oidbitmap</OIDBitmapFile>
              <!-- Do not change this value after database built       -->
              <FirstOID>3000</FirstOID>
          </OIDManager>
          <WriteEngine>
              <BulkRoot>/var/lib/columnstore/data/bulk</BulkRoot>
              <BulkRollbackDir>/var/lib/columnstore/data1/systemFiles/bulkRollback</BulkRollbackDir>
              <MaxFileSystemDiskUsagePct>98</MaxFileSystemDiskUsagePct>
              <CompressedPaddingBlocks>1</CompressedPaddingBlocks>
              <!-- Number of blocks used to pad compressed chunks -->
          </WriteEngine>
          <DBRM_Controller>
              <NumWorkers>3</NumWorkers>
              <IPAddr>mcs1</IPAddr>
              <Port>8616</Port>
          </DBRM_Controller>
          <!-- Worker Port: 8700 - 8720 is reserved to support External Modules-->
          <DBRM_Worker1>
              <IPAddr>mcs1</IPAddr>
              <Port>8700</Port>
              <Module>pm1</Module>
          </DBRM_Worker1>
          <DBBC>
              <!-- The percentage of RAM to use for the disk block cache. Defaults to 70% -->
              <!-- Alternatively, this can be specified in absolute terms using
                   the suffixes 'm' or 'g' to denote size in megabytes or gigabytes.-->
              <!-- <NumBlocksPct>95</NumBlocksPct> -->
              <!-- <NumThreads>16</NumThreads> -->
              <!-- 1-256.  Default is 16. -->
              <NumCaches>1</NumCaches>
              <!-- # of parallel caches to instantiate -->
              <IOMTracing>0</IOMTracing>
              <BRPTracing>0</BRPTracing>
              <ReportFrequency>65536</ReportFrequency>
              <MaxOpenFiles>2K</MaxOpenFiles>
              <DecreaseOpenFilesCount>200</DecreaseOpenFilesCount>
              <FDCacheTrace>0</FDCacheTrace>
              <NumBlocksPct>50</NumBlocksPct>
          </DBBC>
          <Installation>
              <SystemStartupOffline>n</SystemStartupOffline>
              <InitialInstallFlag>y</InitialInstallFlag>
              <SingleServerInstall>y</SingleServerInstall>
              <ServerTypeInstall>2</ServerTypeInstall>
              <PMwithUM>n</PMwithUM>
              <MySQLRep>n</MySQLRep>
              <DBRootStorageType>internal</DBRootStorageType>
              <UMStorageType>internal</UMStorageType>
              <EEPackageType>binary</EEPackageType>
              <SystemLogConfigFile>/etc/rsyslog.d/columnstore.conf</SystemLogConfigFile>
              <Cloud>unassigned</Cloud>
              <AmazonVPCNextPrivateIP>autoassign</AmazonVPCNextPrivateIP>
              <UMInstanceType>unassigned</UMInstanceType>
              <UMSecurityGroup>unassigned</UMSecurityGroup>
              <UMVolumeSize>unassigned</UMVolumeSize>
              <UMVolumeType>gp2</UMVolumeType>
              <UMVolumeIOPS>unassigned</UMVolumeIOPS>
              <PMInstanceType>unassigned</PMInstanceType>
              <PMVolumeSize>unassigned</PMVolumeSize>
              <PMVolumeType>gp2</PMVolumeType>
              <PMVolumeIOPS>unassigned</PMVolumeIOPS>
              <AmazonPMFailover>y</AmazonPMFailover>
              <AmazonAutoTagging>y</AmazonAutoTagging>
              <AmazonElasticIPCount>0</AmazonElasticIPCount>
              <AmazonElasticIPAddr1>unassigned</AmazonElasticIPAddr1>
              <AmazonElasticModule1>unassigned</AmazonElasticModule1>
              <DataRedundancyConfig>n</DataRedundancyConfig>
              <DataRedundancyCopies>0</DataRedundancyCopies>
              <DataRedundancyStorageType>unassigned</DataRedundancyStorageType>
              <CoreFileFlag>n</CoreFileFlag>
              <MySQLPort>3306</MySQLPort>
              <AmazonDeviceName>/dev/xvd</AmazonDeviceName>
              <LockFileDirectory>/var/lock/subsys</LockFileDirectory>
              <ProfileFile>/etc/profile.d/columnstoreAlias.sh</ProfileFile>
              <DataRedundancyNetworkType/>
          </Installation>
          <ExtentMap>
              <!--
                      WARNING: these can only be changed on an empty system. Once any object has been allocated
                      it cannot be changed!. Extent size is 8M rows.
                      -->
              <FilesPerColumnPartition>4</FilesPerColumnPartition>
              <!-- should be multiple of DBRootCount -->
              <ExtentsPerSegmentFile>2</ExtentsPerSegmentFile>
              <BRM_UID>0x0</BRM_UID>
          </ExtentMap>
          <HashJoin>
              <MaxBuckets>128</MaxBuckets>
              <MaxElems>128K</MaxElems>
              <!-- 128 buckets * 128K * 16 = 256 MB -->
              <FifoSizeLargeSide>64</FifoSizeLargeSide>
              <PmMaxMemorySmallSide>1G</PmMaxMemorySmallSide>
              <TotalUmMemory>25%</TotalUmMemory>
              <CPUniqueLimit>100</CPUniqueLimit>
              <AllowDiskBasedJoin>N</AllowDiskBasedJoin>
              <!-- Be careful modifying TempFilePath!  On start, ExeMgr deletes
                              the entire directory and recreates it to make sure no
                              files are left behind.
                      <TempFilePath>/tmp/cs-diskjoin</TempFilePath>  -->
              <TempFileCompression>Y</TempFileCompression>
          </HashJoin>
          <JobList>
              <FlushInterval>16K</FlushInterval>
              <FifoSize>16</FifoSize>
              <RequestSize>1</RequestSize>
              <!-- Number of extents per request, should be
                                less than MaxOutstandingRequests. Otherwise, default value 1 is used. -->
              <!--  ProcessorThreadsPerScan is the number of jobs issued to process
                                each extent.  The default is 16.  MaxOutstandingRequests is the size of
                                the window of work in terms of extents.  A value of 20 means there
                                is 20 extents worth of work for the PMs to process at any given time.
                                ProcessorThreadsPerScan * MaxOutstandingRequests should be at least
                                as many threads are available across all PMs.  -->
              <!-- <ProcessorThreadsPerScan>16</ProcessorThreadsPerScan> -->
              <!-- MaxOutstandingRequests is going to default to the num of cores available
                               across all performance modules * 4 divided by the ProcessorThreadsPerScan,
                               but will be lower bounded by 20 -->
              <!-- <MaxOutstandingRequests>20</MaxOutstandingRequests>  -->
              <ThreadPoolSize>100</ThreadPoolSize>
          </JobList>
          <TupleWSDL>
              <MaxSize>1M</MaxSize>
              <!-- Max size in bytes per bucket -->
              <InitialCapacity>1M</InitialCapacity>
              <!-- Initial capacity per bucket -->
              <MaxBuckets>512</MaxBuckets>
              <!-- Number of buckets -->
          </TupleWSDL>
          <RowAggregation>
              <!-- <RowAggrThreads>4</RowAggrThreads> -->
              <!-- Default value is the number of cores -->
              <!-- <RowAggrBuckets>32</RowAggrBuckets> -->
              <!-- Default value is number of cores * 4 -->
              <!-- <RowAggrRowGroupsPerThread>20</RowAggrRowGroupsPerThread> -->
              <!-- Default value is 20 -->
          </RowAggregation>
          <CrossEngineSupport>
              <Host>mcs1</Host>
              <Port>3306</Port>
              <User>skysql_cej</User>
              <Password>h1&amp;9I2i==N4=.iWh=E!wE.7ZNiT-?rf2</Password>
              <TLSCA/>
              <TLSClientCert/>
              <TLSClientKey/>
          </CrossEngineSupport>
          <QueryStats>
              <Enabled>N</Enabled>
          </QueryStats>
          <UserPriority>
              <Enabled>N</Enabled>
          </UserPriority>
          <NetworkCompression>
              <Enabled>Y</Enabled>
          </NetworkCompression>
          <QueryTele>
              <Host>mcs1</Host>
              <Port>0</Port>
          </QueryTele>
          <StorageManager>
              <MaxSockets>30</MaxSockets>
              <Enabled>N</Enabled>
          </StorageManager>
          <DataRedundancyConfig>
              <DBRoot1PMs/>
          </DataRedundancyConfig>
          <ConfigRevision>1</ConfigRevision>
          <ClusterManager>mcs1</ClusterManager>
          <ClusterName>MyCluster</ClusterName>
          <NextNodeId>4</NextNodeId>
          <NextDBRootId>4</NextDBRootId>
          <DesiredNodes>
              <Node>mcs1</Node>
              <Node>mcs2</Node>
              <Node>mcs3</Node>
          </DesiredNodes>
          <ActiveNodes>
              <Node>mcs1</Node>
              <Node>mcs2</Node>
              <Node>mcs3</Node>
          </ActiveNodes>
          <InactiveNodes/>
          <PrimaryNode>mcs1</PrimaryNode>
          <SharedStorage>yes</SharedStorage>
          <pm2_WriteEngineServer>
              <IPAddr>mcs2</IPAddr>
              <Port>8630</Port>
          </pm2_WriteEngineServer>
          <DBRM_Worker2>
              <Port>8700</Port>
              <IPAddr>mcs2</IPAddr>
          </DBRM_Worker2>
          <PMS1>
              <IPAddr>mcs1</IPAddr>
              <Port>8620</Port>
          </PMS1>
          <PMS2>
              <IPAddr>mcs2</IPAddr>
              <Port>8620</Port>
          </PMS2>
          <PMS3>
              <IPAddr>mcs3</IPAddr>
              <Port>8620</Port>
          </PMS3>
          <PMS4>
              <IPAddr>mcs1</IPAddr>
              <Port>8620</Port>
          </PMS4>
          <PMS5>
              <IPAddr>mcs2</IPAddr>
              <Port>8620</Port>
          </PMS5>
          <PMS6>
              <IPAddr>mcs3</IPAddr>
              <Port>8620</Port>
          </PMS6>
          <pm3_WriteEngineServer>
              <IPAddr>mcs3</IPAddr>
              <Port>8630</Port>
          </pm3_WriteEngineServer>
          <DBRM_Worker3>
              <Port>8700</Port>
              <IPAddr>mcs3</IPAddr>
          </DBRM_Worker3>
      </Columnstore>
      

        Attachments

          Activity

            People

            Assignee:
            toddstoffel Todd Stoffel
            Reporter:
            jens.rowekamp Jens Röwekamp (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved:

                Git Integration