Please note that before doing this multi-stream option on mxs_adapter, I had previously streamed table t2 directly using command line option like this:
Dipti Joshi (Inactive)
added a comment - Please note that before doing this multi-stream option on mxs_adapter, I had previously streamed table t2 directly using command line option like this:
mxs_adapter -c /etc/Columnstore.xml -u cdcuser -p cdc -h 127.0 . 0.1 -P 4001 -r 2 -d -n -z test t2
MariaDB-AX part [root@pm1 ~]# mcsadmin getsystems
getsystemstatus Mon Nov 26 16:24:22 2018
System columnstore-1
System and Module statuses
Component Status Last Status Change
------------ -------------------------- ------------------------
System ACTIVE Mon Nov 26 16:23:33 2018
Module um1 ACTIVE Mon Nov 26 16:23:31 2018
Module pm1 ACTIVE Mon Nov 26 16:23:14 2018
Module pm2 ACTIVE Mon Nov 26 16:23:21 2018
Zdravelina Sokolovska (Inactive)
added a comment - checked with mxs_adapter and mcsapi v1.2.2-1 installed on max-scale server with v2.3.1-1 ,
crash was not recreated but it's received
[root@localhost ~] # mxs_adapter -c Columnstore.xml -u root -p 1 -h 127.0.0.1 -P 4001 -r 2 -d -n -z -f tbls
2018-11-26 14:47:15 [main] Started thread 0x17e7220
2018-11-26 14:47:15 [main] Started thread 0x17e70a0
2018-11-26 14:47:15 [main] Started 2 threads
2018-11-26 14:47:15 [AAA.bbb] Requesting data for table: AAA.bbb
2018-11-26 14:47:15 [AAA.bbb] MaxScale connection could not be created: Failed to connect: Connection refused
2018-11-26 14:47:15 [AAA.aaa] Requesting data for table: AAA.aaa
2018-11-26 14:47:15 [AAA.aaa] MaxScale connection could not be created: Failed to connect: Connection refused
MariaDB-TX part
-------
max-scale server && mxs_adapter && mcsapi
---------
MariaDB-AX part
the crash was not recreated but
MariaDB-TX part seen from MAX-Scale
[root@localhost ~] # maxctrl list servers
┌─────────┬────────────┬──────┬─────────────┬─────────────────────────┬──────┐
│ Server │ Address │ Port │ Connections │ State │ GTID │
├─────────┼────────────┼──────┼─────────────┼─────────────────────────┼──────┤
│ server1 │ 172.20.3.4 │ 3306 │ 0 │ Master, Synced, Running │ │
├─────────┼────────────┼──────┼─────────────┼─────────────────────────┼──────┤
│ server2 │ 172.20.3.5 │ 3306 │ 0 │ Slave, Synced, Running │ │
└─────────┴────────────┴──────┴─────────────┴─────────────────────────┴──────┘
MariaDB-AX part
[root@pm1 ~] # mcsadmin getsystems
getsystemstatus Mon Nov 26 16:24:22 2018
System columnstore-1
System and Module statuses
Component Status Last Status Change
------------ -------------------------- ------------------------
System ACTIVE Mon Nov 26 16:23:33 2018
Module um1 ACTIVE Mon Nov 26 16:23:31 2018
Module pm1 ACTIVE Mon Nov 26 16:23:14 2018
Module pm2 ACTIVE Mon Nov 26 16:23:21 2018
CDC user that you are using is not defined in MaxScale and source database
OR
The port 4001 on MaxScale server is not accepting connection.
Please provide maxscale.cnf from your MaxScale winstone
Dipti Joshi (Inactive)
added a comment - This indicates that either
CDC user that you are using is not defined in MaxScale and source database
OR
The port 4001 on MaxScale server is not accepting connection.
Please provide maxscale.cnf from your MaxScale winstone
dshjoshi
CDC user was added and the source database is accessible by the CDC user . but now it fails with Error "MaxScale responded with an error: ERR NO-FILE File 'AAA.aaa.000001.avro' not found.' / attached the maxscale.cnf
2018-12-10 18:33:00 [main] Started thread 0xea6450
2018-12-10 18:33:00 [main] Started 1 threads
2018-12-10 18:33:00 [AAA.aaa] Requesting data for table: AAA.aaa
2018-12-10 18:33:00 [AAA.aaa] MaxScale connection could not be created: MaxScale responded with an error: ERR NO-FILE File 'AAA.aaa.000001.avro' not found.
Zdravelina Sokolovska (Inactive)
added a comment - - edited dshjoshi
CDC user was added and the source database is accessible by the CDC user . but now it fails with Error "MaxScale responded with an error: ERR NO-FILE File 'AAA.aaa.000001.avro' not found.' / attached the maxscale.cnf
maxctrl call command cdc add_user avro-router cdcuser cdcpassword
OK
mysql -h 127.0.0.1 -u cdcuser -pcdcpassword -P 3307
Welcome to the MariaDB monitor. Commands end with ; or \g.
Your MariaDB connection id is 7
Server version: 10.3.10-MariaDB
Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
source DB is accessible:
MariaDB [(none)]> connect AAA ;
Connection id: 8
Current database: AAA
mxs_adapter -c /usr/local/mariadb/columnstore/etc/Columnstore.xml -u cdcuser -p cdcpassword -h 127.0.0.1 -P 4001 -r 2 -d -n -z AAA aaa
2018-12-10 18:33:00 [main] Started thread 0xea6450
2018-12-10 18:33:00 [main] Started 1 threads
2018-12-10 18:33:00 [AAA.aaa] Requesting data for table: AAA.aaa
2018-12-10 18:33:00 [AAA.aaa] MaxScale connection could not be created: MaxScale responded with an error: ERR NO-FILE File 'AAA.aaa.000001.avro' not found.
2018-12-20 19:30:35 [testA.t4] Continuing from GTID: 0-1-209:1
2018-12-20 19:30:35 [testA.t5] MaxScale connection could not be created: MaxScale responded with an error: ERR NO-FILE File 'testA.t5.000001.avro' not found.
Please note that before doing this multi-stream option on mxs_adapter, I had previously streamed table t2 directly using command line option like this: