Skip to content

Instantly share code, notes, and snippets.

@dasl-

dasl-/gist:6acded8bf72dfbe88b522dbfbda8af4e

Created January 22, 2019 18:05
Show Gist options
  • Save dasl-/6acded8bf72dfbe88b522dbfbda8af4e to your computer and use it in GitHub Desktop.
Save dasl-/6acded8bf72dfbe88b522dbfbda8af4e to your computer and use it in GitHub Desktop.
Download ZIP
Raw
gistfile1.txt
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 18:01:38.102421 142 syslogger.go:122] can't connect to syslog
W0122 18:01:38.277900 142 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 18:02:29.209106 3354 main.go:60] W0122 18:02:29.136748 reparent.go:181] master-elect tablet test-0000000100 is not the shard master, proceeding anyway as -force was used
W0122 18:02:29.248094 3354 main.go:60] W0122 18:02:29.143472 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 18:03:20.856011 6579 main.go:60] W0122 18:03:20.854543 reparent.go:181] master-elect tablet test-0000000200 is not the shard master, proceeding anyway as -force was used
W0122 18:03:20.865927 6579 main.go:60] W0122 18:03:20.854738 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 18:04:10.506141 9819 main.go:60] W0122 18:04:10.502233 reparent.go:181] master-elect tablet test-0000000300 is not the shard master, proceeding anyway as -force was used
W0122 18:04:10.507290 9819 main.go:60] W0122 18:04:10.502376 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
.9899
ERROR: logging before flag.Parse: E0122 18:04:14.615135 9917 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 18:04:15.557300 9938 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 18:04:16.092790 9949 syslogger.go:122] can't connect to syslog
W0122 18:04:16.120437 9949 vtctl.go:80] cannot connect to syslog: Unix syslog delivery error
+
+
ERROR: logging before flag.Parse: E0122 18:04:16.645871 9960 syslogger.go:122] can't connect to syslog
W0122 18:04:16.675677 9960 vtctl.go:80] cannot connect to syslog: Unix syslog delivery error
+
+
ERROR: logging before flag.Parse: E0122 18:04:16.762122 9971 syslogger.go:122] can't connect to syslog
W0122 18:04:16.780691 9971 vtctl.go:80] cannot connect to syslog: Unix syslog delivery error
+
+
ERROR: logging before flag.Parse: E0122 18:04:16.921107 9983 syslogger.go:122] can't connect to syslog
W0122 18:04:16.941774 9983 vtctl.go:80] cannot connect to syslog: Unix syslog delivery error
+
+
ERROR: logging before flag.Parse: E0122 18:04:17.113722 9994 syslogger.go:122] can't connect to syslog
W0122 18:04:17.147897 9994 vtctl.go:80] cannot connect to syslog: Unix syslog delivery error
+
+
ERROR: logging before flag.Parse: E0122 18:04:17.242591 10005 syslogger.go:122] can't connect to syslog
W0122 18:04:17.275837 10005 vtctl.go:80] cannot connect to syslog: Unix syslog delivery error
+
+
ERROR: logging before flag.Parse: E0122 18:04:17.423419 10016 syslogger.go:122] can't connect to syslog
W0122 18:04:17.453015 10016 vtctl.go:80] cannot connect to syslog: Unix syslog delivery error
+
+
ERROR: logging before flag.Parse: E0122 18:04:17.592910 10028 syslogger.go:122] can't connect to syslog
W0122 18:04:17.598088 10028 vtctl.go:80] cannot connect to syslog: Unix syslog delivery error
+
+
ERROR: logging before flag.Parse: E0122 18:04:17.687802 10040 syslogger.go:122] can't connect to syslog
W0122 18:04:17.723006 10040 vtctl.go:80] cannot connect to syslog: Unix syslog delivery error
+
+
ERROR: logging before flag.Parse: E0122 18:04:17.863647 10052 syslogger.go:122] can't connect to syslog
W0122 18:04:17.894017 10052 vtctl.go:80] cannot connect to syslog: Unix syslog delivery error
+
+
ERROR: logging before flag.Parse: E0122 18:04:18.028470 10064 syslogger.go:122] can't connect to syslog
W0122 18:04:18.050748 10064 vtctl.go:80] cannot connect to syslog: Unix syslog delivery error
+
+
ERROR: logging before flag.Parse: E0122 18:04:18.178631 10075 syslogger.go:122] can't connect to syslog
W0122 18:04:18.231228 10075 vtctl.go:80] cannot connect to syslog: Unix syslog delivery error
+
+
ERROR: logging before flag.Parse: E0122 18:04:18.428021 10086 syslogger.go:122] can't connect to syslog
W0122 18:04:18.444702 10086 vtctl.go:80] cannot connect to syslog: Unix syslog delivery error
+
+
ERROR: logging before flag.Parse: E0122 18:04:18.533378 10099 syslogger.go:122] can't connect to syslog
W0122 18:04:18.552398 10099 vtctl.go:80] cannot connect to syslog: Unix syslog delivery error
+
+
ERROR: logging before flag.Parse: E0122 18:04:18.670087 10111 syslogger.go:122] can't connect to syslog
W0122 18:04:18.686363 10111 vtctl.go:80] cannot connect to syslog: Unix syslog delivery error
+
+
ERROR: logging before flag.Parse: E0122 18:04:18.757466 10123 syslogger.go:122] can't connect to syslog
W0122 18:04:18.772338 10123 vtctl.go:80] cannot connect to syslog: Unix syslog delivery error
+
+
shops_index data:
ERROR: logging before flag.Parse: E0122 18:04:18.853982 10135 syslogger.go:122] can't connect to syslog
W0122 18:04:18.867360 10135 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 18:04:18.933617 10148 syslogger.go:122] can't connect to syslog
W0122 18:04:18.938398 10148 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 18:04:19.030186 10164 syslogger.go:122] can't connect to syslog
W0122 18:04:19.045586 10164 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 18:04:19.147464 10176 syslogger.go:122] can't connect to syslog
W0122 18:04:19.163174 10176 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 |
+---------+---------+
API server listening at: [::]:40000
INFO[0000] attaching to pid 9899 layer=debugger
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment