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

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>