Created
January 22, 2019 20:03
-
-
Save dasl-/7b44167257157ad099ab8004a4d4eb4a to your computer and use it in GitHub Desktop.
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
vitess@localhost:/vt/src/vitess.io/vitess$ /vitess-scripts/init.sh | |
enter zk2 env | |
Starting zk servers... | |
Waiting for zk servers to be ready... | |
Started zk servers. | |
ERROR: logging before flag.Parse: E0122 19:58:44.471464 144 syslogger.go:122] can't connect to syslog | |
W0122 19:58:44.576227 144 vtctl.go:80] cannot connect to syslog: Unix syslog delivery error | |
Configured zk servers. | |
enter zk2 env | |
Starting vtctld... | |
Access vtctld web UI at http://localhost:15000 | |
Send commands with: vtctlclient -server localhost:15999 ... | |
enter zk2 env | |
Starting MySQL for tablet test-0000000100... | |
Starting MySQL for tablet test-0000000101... | |
Starting vttablet for test-0000000100... | |
Access tablet test-0000000100 at http://localhost:15100/debug/status | |
Starting vttablet for test-0000000101... | |
Access tablet test-0000000101 at http://localhost:15101/debug/status | |
W0122 19:59:36.440459 3335 main.go:60] W0122 19:59:36.438219 reparent.go:181] master-elect tablet test-0000000100 is not the shard master, proceeding anyway as -force was used | |
W0122 19:59:36.448126 3335 main.go:60] W0122 19:59:36.438648 reparent.go:187] master-elect tablet test-0000000100 is not a master in the shard, proceeding anyway as -force was used | |
enter zk2 env | |
Starting MySQL for tablet test-0000000200... | |
Starting MySQL for tablet test-0000000201... | |
Starting vttablet for test-0000000200... | |
Access tablet test-0000000200 at http://localhost:15200/debug/status | |
Starting vttablet for test-0000000201... | |
Access tablet test-0000000201 at http://localhost:15201/debug/status | |
W0122 20:00:27.227387 6561 main.go:60] W0122 20:00:27.225669 reparent.go:181] master-elect tablet test-0000000200 is not the shard master, proceeding anyway as -force was used | |
W0122 20:00:27.237031 6561 main.go:60] W0122 20:00:27.225785 reparent.go:187] master-elect tablet test-0000000200 is not a master in the shard, proceeding anyway as -force was used | |
enter zk2 env | |
Starting MySQL for tablet test-0000000300... | |
Starting MySQL for tablet test-0000000301... | |
Starting vttablet for test-0000000300... | |
Access tablet test-0000000300 at http://localhost:15300/debug/status | |
Starting vttablet for test-0000000301... | |
Access tablet test-0000000301 at http://localhost:15301/debug/status | |
W0122 20:01:27.172491 9794 main.go:60] W0122 20:01:27.161876 reparent.go:181] master-elect tablet test-0000000300 is not the shard master, proceeding anyway as -force was used | |
W0122 20:01:27.176517 9794 main.go:60] W0122 20:01:27.161973 reparent.go:187] master-elect tablet test-0000000300 is not a master in the shard, proceeding anyway as -force was used | |
New VSchema object: | |
{ | |
"tables": { | |
"shops_index": { | |
} | |
} | |
} | |
If this is not what you expected, check the input data (as JSON parsing will skip unexpected fields). | |
New VSchema object: | |
{ | |
"sharded": true, | |
"vindexes": { | |
"shop_id_shop_shard_idx": { | |
"type": "lookup_hash_unique", | |
"params": { | |
"from": "shop_id", | |
"table": "shops_index", | |
"to": "shop_shard" | |
} | |
} | |
}, | |
"tables": { | |
"shop_data": { | |
"columnVindexes": [ | |
{ | |
"column": "shop_id", | |
"name": "shop_id_shop_shard_idx" | |
} | |
] | |
} | |
} | |
} | |
If this is not what you expected, check the input data (as JSON parsing will skip unexpected fields). | |
enter zk2 env | |
Access vtgate at http://localhost:15001/debug/status | |
.cat: /vt/vtdataroot/tmp/vtgate.pid: No such file or directory | |
.9875 | |
ERROR: logging before flag.Parse: E0122 20:01:30.936270 9895 syslogger.go:122] can't connect to syslog | |
---------------------------------------------------------------------- | |
INSERT INTO shops_index (shop_id, shop_shard) VALUES(123, 100) | |
1 index_test/-: begin | |
1 index_test/-: insert into shops_index(shop_id, shop_shard) values (123, 100) | |
1 index_test/-: commit | |
---------------------------------------------------------------------- | |
ERROR: logging before flag.Parse: E0122 20:01:31.481027 9916 syslogger.go:122] can't connect to syslog | |
---------------------------------------------------------------------- | |
INSERT INTO shop_data (shop_id, name) VALUES(123, 'my_shop') | |
1 index_test/-: begin | |
1 index_test/-: select shop_shard from shops_index where shop_id = 123 limit 10001 | |
2 shard_test/-80: begin | |
2 shard_test/-80: insert into shop_data(shop_id, name) values (123, 'my_shop') /* vtgate:: keyspace_id:166b40b44aba4bd6 */ | |
3 index_test/-: commit | |
4 shard_test/-80: commit | |
---------------------------------------------------------------------- | |
ERROR: logging before flag.Parse: E0122 20:01:31.690869 9927 syslogger.go:122] can't connect to syslog | |
W0122 20:01:31.730328 9927 vtctl.go:80] cannot connect to syslog: Unix syslog delivery error | |
+ | |
+ | |
ERROR: logging before flag.Parse: E0122 20:01:31.995687 9937 syslogger.go:122] can't connect to syslog | |
W0122 20:01:32.004273 9937 vtctl.go:80] cannot connect to syslog: Unix syslog delivery error | |
+ | |
+ | |
ERROR: logging before flag.Parse: E0122 20:01:32.084499 9946 syslogger.go:122] can't connect to syslog | |
W0122 20:01:32.094707 9946 vtctl.go:80] cannot connect to syslog: Unix syslog delivery error | |
+ | |
+ | |
ERROR: logging before flag.Parse: E0122 20:01:32.154793 9957 syslogger.go:122] can't connect to syslog | |
W0122 20:01:32.161724 9957 vtctl.go:80] cannot connect to syslog: Unix syslog delivery error | |
+ | |
+ | |
ERROR: logging before flag.Parse: E0122 20:01:32.283599 9968 syslogger.go:122] can't connect to syslog | |
W0122 20:01:32.299551 9968 vtctl.go:80] cannot connect to syslog: Unix syslog delivery error | |
+ | |
+ | |
ERROR: logging before flag.Parse: E0122 20:01:32.361132 9979 syslogger.go:122] can't connect to syslog | |
W0122 20:01:32.379339 9979 vtctl.go:80] cannot connect to syslog: Unix syslog delivery error | |
+ | |
+ | |
ERROR: logging before flag.Parse: E0122 20:01:32.435460 9990 syslogger.go:122] can't connect to syslog | |
W0122 20:01:32.442507 9990 vtctl.go:80] cannot connect to syslog: Unix syslog delivery error | |
+ | |
+ | |
ERROR: logging before flag.Parse: E0122 20:01:32.502313 10001 syslogger.go:122] can't connect to syslog | |
W0122 20:01:32.528490 10001 vtctl.go:80] cannot connect to syslog: Unix syslog delivery error | |
+ | |
+ | |
ERROR: logging before flag.Parse: E0122 20:01:32.611356 10012 syslogger.go:122] can't connect to syslog | |
W0122 20:01:32.626888 10012 vtctl.go:80] cannot connect to syslog: Unix syslog delivery error | |
+ | |
+ | |
ERROR: logging before flag.Parse: E0122 20:01:32.725673 10024 syslogger.go:122] can't connect to syslog | |
W0122 20:01:32.740749 10024 vtctl.go:80] cannot connect to syslog: Unix syslog delivery error | |
+ | |
+ | |
ERROR: logging before flag.Parse: E0122 20:01:32.847728 10035 syslogger.go:122] can't connect to syslog | |
W0122 20:01:32.854338 10035 vtctl.go:80] cannot connect to syslog: Unix syslog delivery error | |
+ | |
+ | |
ERROR: logging before flag.Parse: E0122 20:01:32.904547 10045 syslogger.go:122] can't connect to syslog | |
W0122 20:01:32.920841 10045 vtctl.go:80] cannot connect to syslog: Unix syslog delivery error | |
+ | |
+ | |
ERROR: logging before flag.Parse: E0122 20:01:33.169957 10057 syslogger.go:122] can't connect to syslog | |
W0122 20:01:33.183142 10057 vtctl.go:80] cannot connect to syslog: Unix syslog delivery error | |
+ | |
+ | |
ERROR: logging before flag.Parse: E0122 20:01:33.379021 10068 syslogger.go:122] can't connect to syslog | |
W0122 20:01:33.415738 10068 vtctl.go:80] cannot connect to syslog: Unix syslog delivery error | |
+ | |
+ | |
ERROR: logging before flag.Parse: E0122 20:01:33.638127 10080 syslogger.go:122] can't connect to syslog | |
W0122 20:01:33.645563 10080 vtctl.go:80] cannot connect to syslog: Unix syslog delivery error | |
+ | |
+ | |
ERROR: logging before flag.Parse: E0122 20:01:33.770388 10092 syslogger.go:122] can't connect to syslog | |
W0122 20:01:33.806373 10092 vtctl.go:80] cannot connect to syslog: Unix syslog delivery error | |
+ | |
+ | |
shops_index data: | |
ERROR: logging before flag.Parse: E0122 20:01:34.119284 10104 syslogger.go:122] can't connect to syslog | |
W0122 20:01:34.376040 10104 vtctl.go:80] cannot connect to syslog: Unix syslog delivery error | |
+---------+------------+ | |
| shop_id | shop_shard | | |
+---------+------------+ | |
| 1 | 1 | | |
| 2 | 2 | | |
| 3 | 3 | | |
| 4 | 4 | | |
| 5 | 5 | | |
| 6 | 6 | | |
| 7 | 7 | | |
| 8 | 8 | | |
+---------+------------+ | |
shop_data data: | |
ERROR: logging before flag.Parse: E0122 20:01:34.503081 10116 syslogger.go:122] can't connect to syslog | |
W0122 20:01:34.519482 10116 vtctl.go:80] cannot connect to syslog: Unix syslog delivery error | |
+---------+---------+ | |
| shop_id | name | | |
+---------+---------+ | |
| 1 | my_shop | | |
| 2 | my_shop | | |
| 3 | my_shop | | |
| 5 | my_shop | | |
| 4 | my_shop | | |
| 6 | my_shop | | |
| 7 | my_shop | | |
| 8 | my_shop | | |
+---------+---------+ | |
shop_data shard -80 data: | |
ERROR: logging before flag.Parse: E0122 20:01:34.591342 10128 syslogger.go:122] can't connect to syslog | |
W0122 20:01:34.620526 10128 vtctl.go:80] cannot connect to syslog: Unix syslog delivery error | |
+---------+---------+ | |
| shop_id | name | | |
+---------+---------+ | |
| 1 | my_shop | | |
| 2 | my_shop | | |
| 3 | my_shop | | |
| 5 | my_shop | | |
+---------+---------+ | |
shop_data shard 80- data: | |
ERROR: logging before flag.Parse: E0122 20:01:34.730064 10138 syslogger.go:122] can't connect to syslog | |
W0122 20:01:34.785162 10138 vtctl.go:80] cannot connect to syslog: Unix syslog delivery error | |
+---------+---------+ | |
| shop_id | name | | |
+---------+---------+ | |
| 4 | my_shop | | |
| 6 | my_shop | | |
| 7 | my_shop | | |
| 8 | my_shop | | |
+---------+---------+ | |
Type 'help' for list of commands. | |
(dlv) |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment