Skip to content

Instantly share code, notes, and snippets.

@dasl-
Created January 22, 2019 20:03
Show Gist options
  • Save dasl-/7b44167257157ad099ab8004a4d4eb4a to your computer and use it in GitHub Desktop.
Save dasl-/7b44167257157ad099ab8004a4d4eb4a to your computer and use it in GitHub Desktop.
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