Skip to content

Instantly share code, notes, and snippets.

@systay
Created May 27, 2021 14:50
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save systay/25db565920e26576d53dff2e22ed66e4 to your computer and use it in GitHub Desktop.
Save systay/25db565920e26576d53dff2e22ed66e4 to your computer and use it in GitHub Desktop.
75 keyspaces
=== RUN TestSetup
I0527 16:50:36.508552 69364 engine.go:390] schema engine created [t1_last_insert_id], altered [], dropped []
I0527 16:50:36.549396 69364 engine.go:390] schema engine created [t1_last_insert_id], altered [], dropped []
I0527 16:50:36.609755 69364 engine.go:390] schema engine created [t1_last_insert_id], altered [], dropped []
I0527 16:50:36.669720 69364 engine.go:390] schema engine created [t1_last_insert_id], altered [], dropped []
I0527 16:50:36.745183 69364 engine.go:390] schema engine created [t1_last_insert_id], altered [], dropped []
I0527 16:50:36.819824 69364 engine.go:390] schema engine created [t1_last_insert_id], altered [], dropped []
I0527 16:50:36.897181 69364 engine.go:390] schema engine created [t1_last_insert_id], altered [], dropped []
I0527 16:50:36.963496 69364 engine.go:390] schema engine created [t1_last_insert_id], altered [], dropped []
I0527 16:50:37.008792 69364 engine.go:390] schema engine created [t1_last_insert_id], altered [], dropped []
I0527 16:50:37.066611 69364 engine.go:390] schema engine created [t1_last_insert_id], altered [], dropped []
I0527 16:50:37.123507 69364 engine.go:390] schema engine created [t1_last_insert_id], altered [], dropped []
I0527 16:50:37.176124 69364 engine.go:390] schema engine created [t1_last_insert_id], altered [], dropped []
I0527 16:50:37.232237 69364 engine.go:390] schema engine created [t1_last_insert_id], altered [], dropped []
I0527 16:50:37.291779 69364 engine.go:390] schema engine created [t1_last_insert_id], altered [], dropped []
I0527 16:50:37.351725 69364 engine.go:390] schema engine created [t1_last_insert_id], altered [], dropped []
I0527 16:50:37.392274 69364 engine.go:390] schema engine created [t1_last_insert_id], altered [], dropped []
I0527 16:50:37.465877 69364 engine.go:390] schema engine created [t1_last_insert_id], altered [], dropped []
I0527 16:50:37.521559 69364 engine.go:390] schema engine created [t1_last_insert_id], altered [], dropped []
I0527 16:50:37.592810 69364 engine.go:390] schema engine created [t1_last_insert_id], altered [], dropped []
I0527 16:50:37.641474 69364 engine.go:390] schema engine created [t1_last_insert_id], altered [], dropped []
I0527 16:50:37.688890 69364 engine.go:390] schema engine created [t1_last_insert_id], altered [], dropped []
I0527 16:50:37.766925 69364 engine.go:390] schema engine created [t1_last_insert_id], altered [], dropped []
I0527 16:50:37.850548 69364 engine.go:390] schema engine created [t1_last_insert_id], altered [], dropped []
I0527 16:50:37.916081 69364 engine.go:390] schema engine created [t1_last_insert_id], altered [], dropped []
I0527 16:50:37.976585 69364 engine.go:390] schema engine created [t1_last_insert_id], altered [], dropped []
I0527 16:50:38.040995 69364 engine.go:390] schema engine created [t1_last_insert_id], altered [], dropped []
I0527 16:50:38.108992 69364 engine.go:390] schema engine created [t1_last_insert_id], altered [], dropped []
I0527 16:50:38.184114 69364 engine.go:390] schema engine created [t1_last_insert_id], altered [], dropped []
I0527 16:50:38.234660 69364 engine.go:390] schema engine created [t1_last_insert_id], altered [], dropped []
I0527 16:50:38.292392 69364 engine.go:390] schema engine created [t1_last_insert_id], altered [], dropped []
I0527 16:50:38.347274 69364 engine.go:390] schema engine created [t1_last_insert_id], altered [], dropped []
I0527 16:50:38.401665 69364 engine.go:390] schema engine created [t1_last_insert_id], altered [], dropped []
I0527 16:50:38.412160 69364 tablegc.go:231] TableGC: transition into primary
I0527 16:50:38.439844 69364 tablegc.go:231] TableGC: transition into primary
I0527 16:50:38.466141 69364 tablegc.go:231] TableGC: transition into primary
I0527 16:50:38.484518 69364 tablegc.go:231] TableGC: transition into primary
I0527 16:50:38.507560 69364 engine.go:390] schema engine created [t1_last_insert_id], altered [], dropped []
I0527 16:50:38.508593 69364 tablegc.go:231] TableGC: transition into primary
I0527 16:50:38.526368 69364 tablegc.go:231] TableGC: transition into primary
I0527 16:50:38.544077 69364 tablegc.go:231] TableGC: transition into primary
I0527 16:50:38.570183 69364 tablegc.go:231] TableGC: transition into primary
I0527 16:50:38.576274 69364 engine.go:390] schema engine created [t1_last_insert_id], altered [], dropped []
I0527 16:50:38.588730 69364 tablegc.go:231] TableGC: transition into primary
I0527 16:50:38.613028 69364 tablegc.go:231] TableGC: transition into primary
I0527 16:50:38.635203 69364 tablegc.go:231] TableGC: transition into primary
I0527 16:50:38.665514 69364 engine.go:390] schema engine created [t1_last_insert_id], altered [], dropped []
I0527 16:50:38.668870 69364 tablegc.go:231] TableGC: transition into primary
I0527 16:50:38.700250 69364 tablegc.go:231] TableGC: transition into primary
I0527 16:50:38.733477 69364 tablegc.go:231] TableGC: transition into primary
I0527 16:50:38.747310 69364 engine.go:390] schema engine created [t1_last_insert_id], altered [], dropped []
I0527 16:50:38.757663 69364 tablegc.go:231] TableGC: transition into primary
I0527 16:50:38.778490 69364 tablegc.go:231] TableGC: transition into primary
I0527 16:50:38.786529 69364 engine.go:390] schema engine created [t1_last_insert_id], altered [], dropped []
I0527 16:50:38.799080 69364 tablegc.go:231] TableGC: transition into primary
I0527 16:50:38.825424 69364 engine.go:390] schema engine created [t1_last_insert_id], altered [], dropped []
I0527 16:50:38.825434 69364 tablegc.go:231] TableGC: transition into primary
I0527 16:50:38.853762 69364 tablegc.go:231] TableGC: transition into primary
I0527 16:50:38.866526 69364 engine.go:390] schema engine created [t1_last_insert_id], altered [], dropped []
I0527 16:50:38.894101 69364 tablegc.go:231] TableGC: transition into primary
I0527 16:50:38.905890 69364 engine.go:390] schema engine created [t1_last_insert_id], altered [], dropped []
I0527 16:50:38.930222 69364 tablegc.go:231] TableGC: transition into primary
I0527 16:50:38.950810 69364 engine.go:390] schema engine created [t1_last_insert_id], altered [], dropped []
I0527 16:50:38.971948 69364 tablegc.go:231] TableGC: transition into primary
I0527 16:50:38.995100 69364 engine.go:390] schema engine created [t1_last_insert_id], altered [], dropped []
I0527 16:50:39.003868 69364 tablegc.go:231] TableGC: transition into primary
I0527 16:50:39.030838 69364 tablegc.go:231] TableGC: transition into primary
I0527 16:50:39.033192 69364 engine.go:390] schema engine created [t1_last_insert_id], altered [], dropped []
I0527 16:50:39.059245 69364 tablegc.go:231] TableGC: transition into primary
I0527 16:50:39.086991 69364 engine.go:390] schema engine created [t1_last_insert_id], altered [], dropped []
I0527 16:50:39.094065 69364 tablegc.go:231] TableGC: transition into primary
I0527 16:50:39.126921 69364 engine.go:390] schema engine created [t1_last_insert_id], altered [], dropped []
I0527 16:50:39.128058 69364 tablegc.go:231] TableGC: transition into primary
I0527 16:50:39.153309 69364 tablegc.go:231] TableGC: transition into primary
I0527 16:50:39.167590 69364 engine.go:390] schema engine created [t1_last_insert_id], altered [], dropped []
I0527 16:50:39.177272 69364 tablegc.go:231] TableGC: transition into primary
I0527 16:50:39.201912 69364 tablegc.go:231] TableGC: transition into primary
I0527 16:50:39.205361 69364 engine.go:390] schema engine created [t1_last_insert_id], altered [], dropped []
I0527 16:50:39.228898 69364 tablegc.go:231] TableGC: transition into primary
I0527 16:50:39.257160 69364 engine.go:390] schema engine created [t1_last_insert_id], altered [], dropped []
I0527 16:50:39.259623 69364 tablegc.go:231] TableGC: transition into primary
I0527 16:50:39.293151 69364 tablegc.go:231] TableGC: transition into primary
I0527 16:50:39.297225 69364 engine.go:390] schema engine created [t1_last_insert_id], altered [], dropped []
I0527 16:50:39.322726 69364 tablegc.go:231] TableGC: transition into primary
I0527 16:50:39.349645 69364 tablegc.go:231] TableGC: transition into primary
I0527 16:50:39.377360 69364 engine.go:390] schema engine created [t1_last_insert_id], altered [], dropped []
I0527 16:50:39.385417 69364 tablegc.go:231] TableGC: transition into primary
I0527 16:50:39.421619 69364 engine.go:390] schema engine created [t1_last_insert_id], altered [], dropped []
I0527 16:50:39.437078 69364 tablegc.go:231] TableGC: transition into primary
I0527 16:50:39.465438 69364 engine.go:390] schema engine created [t1_last_insert_id], altered [], dropped []
I0527 16:50:39.473852 69364 tablegc.go:231] TableGC: transition into primary
I0527 16:50:39.506069 69364 engine.go:390] schema engine created [t1_last_insert_id], altered [], dropped []
I0527 16:50:39.516430 69364 tablegc.go:231] TableGC: transition into primary
I0527 16:50:39.546710 69364 engine.go:390] schema engine created [t1_last_insert_id], altered [], dropped []
I0527 16:50:39.562072 69364 tablegc.go:231] TableGC: transition into primary
I0527 16:50:39.585345 69364 engine.go:390] schema engine created [t1_last_insert_id], altered [], dropped []
I0527 16:50:39.591992 69364 tablegc.go:231] TableGC: transition into primary
I0527 16:50:39.623027 69364 engine.go:390] schema engine created [t1_last_insert_id], altered [], dropped []
I0527 16:50:39.625281 69364 tablegc.go:231] TableGC: transition into primary
I0527 16:50:39.659072 69364 tablegc.go:231] TableGC: transition into primary
I0527 16:50:39.664541 69364 engine.go:390] schema engine created [t1_last_insert_id], altered [], dropped []
I0527 16:50:39.703154 69364 tablegc.go:231] TableGC: transition into primary
I0527 16:50:39.707046 69364 engine.go:390] schema engine created [t1_last_insert_id], altered [], dropped []
I0527 16:50:39.745383 69364 engine.go:390] schema engine created [t1_last_insert_id], altered [], dropped []
I0527 16:50:39.745908 69364 tablegc.go:231] TableGC: transition into primary
I0527 16:50:39.782836 69364 engine.go:390] schema engine created [t1_last_insert_id], altered [], dropped []
I0527 16:50:39.783912 69364 tablegc.go:231] TableGC: transition into primary
I0527 16:50:39.817913 69364 tablegc.go:231] TableGC: transition into primary
I0527 16:50:39.821928 69364 engine.go:390] schema engine created [t1_last_insert_id], altered [], dropped []
I0527 16:50:39.852341 69364 tablegc.go:231] TableGC: transition into primary
I0527 16:50:39.869702 69364 engine.go:390] schema engine created [t1_last_insert_id], altered [], dropped []
I0527 16:50:39.887353 69364 tablegc.go:231] TableGC: transition into primary
I0527 16:50:39.916917 69364 engine.go:390] schema engine created [t1_last_insert_id], altered [], dropped []
I0527 16:50:39.928755 69364 tablegc.go:231] TableGC: transition into primary
I0527 16:50:39.960307 69364 engine.go:390] schema engine created [t1_last_insert_id], altered [], dropped []
I0527 16:50:39.973905 69364 tablegc.go:231] TableGC: transition into primary
I0527 16:50:40.002092 69364 engine.go:390] schema engine created [t1_last_insert_id], altered [], dropped []
I0527 16:50:40.015167 69364 tablegc.go:231] TableGC: transition into primary
I0527 16:50:40.041917 69364 engine.go:390] schema engine created [t1_last_insert_id], altered [], dropped []
I0527 16:50:40.050682 69364 tablegc.go:231] TableGC: transition into primary
I0527 16:50:40.079217 69364 engine.go:390] schema engine created [t1_last_insert_id], altered [], dropped []
I0527 16:50:40.089995 69364 tablegc.go:231] TableGC: transition into primary
E0527 16:50:40.110781 69364 query_executor.go:469] failed to reload schema initial packet read failed: EOF (errno 2013) (sqlstate HY000)
I0527 16:50:40.111039 69364 tablegc.go:191] TableGC: closing
I0527 16:50:40.111062 69364 engine.go:102] Messager: closed
I0527 16:50:40.111078 69364 tx_engine.go:333] No grace period specified: performing normal wait.
I0527 16:50:40.111098 69364 tx_engine.go:204] TxEngine: closed
I0527 16:50:40.111103 69364 state_manager.go:504] Killing all OLAP queries.
E0527 16:50:40.111367 69364 tabletserver.go:1368] Code: INTERNAL
internal error: unexpected: conn pool is closed (CallerID: userData1)
: Sql: "insert into t1_last_insert_id(id1) values (:vtg1)", BindVars: {vtg1: "type:INT64 value:\"67\""}
I0527 16:50:40.111410 69364 query_engine.go:284] Query Engine: closed
I0527 16:50:40.111431 69364 engine.go:179] VStreamer: closed
I0527 16:50:40.111440 69364 repltracker.go:122] Replication Tracker: closed
I0527 16:50:40.111518 69364 engine.go:240] Schema Engine: closed
I0527 16:50:40.111534 69364 state_manager.go:563] TabletServer transition: MASTER: Serving, May 27, 2021 at 16:50:35 (CEST) -> MASTER: Not connected to mysql, May 27, 2021 at 16:50:35 (CEST) for tablet :ks68/-
E0527 16:50:40.111544 69364 state_manager.go:278] Cannot connect to MySQL, shutting down query service: initial packet read failed: EOF (errno 2013) (sqlstate HY000)
I0527 16:50:40.111605 69364 tablet_health_check.go:111] HealthCheckUpdate(Serving State): tablet: test-202 () serving true => false for ks68/- (MASTER) reason: healthCheck update
I0527 16:50:40.111627 69364 asm_amd64.s:1374] HealthCheckUpdate(Serving State): test-0000000202, tablet: test-202 () serving => false for ks68/- (MASTER) reason: healthCheck update
E0527 16:50:40.111780 69364 vtgate.go:468] Execute: Code: INTERNAL
vttablet: rpc error: code = Internal desc = internal error: unexpected: conn pool is closed (CallerID: userData1)
target: ks68.-.master, request: map[BindVariables:map[vtg1:type:INT64 value:"67"] Session:autocommit:true options:{included_fields:ALL workload:OLTP transaction_isolation:AUTOCOMMIT} row_count:-1 DDLStrategy:"direct" SessionUUID:"e55e2cf2-befa-11eb-a92d-faffc22ca9d8" enable_system_settings:true Sql:insert into ks68.t1_last_insert_id(id1) values(67)]
main_test.go:97:
Error Trace: main_test.go:97
main_test.go:77
Error: Received unexpected error:
target: ks68.-.master: vttablet: rpc error: code = Internal desc = internal error: unexpected: conn pool is closed (CallerID: userData1) (errno 1815) (sqlstate HY000) during query: insert into ks68.t1_last_insert_id(id1) values(67)
Test: TestSetup
E0527 16:50:40.117471 69364 tabletserver.go:1368] initial packet read failed: EOF (errno 2013) (sqlstate HY000) (CallerID: userData1): Sql: "create table t1_last_insert_id (\n\tid1 int\n)", BindVars: {}
main_test.go:92:
Error Trace: main_test.go:92
main_test.go:77
Error: Received unexpected error:
target: ks69.-.master: vttablet: rpc error: code = Canceled desc = initial packet read failed: EOF (errno 2013) (sqlstate HY000) (CallerID: userData1): Sql: "create table t1_last_insert_id (\n\tid1 int\n)", BindVars: {} (errno 2013) (sqlstate HY000) during query: create table ks69.t1_last_insert_id(id1 int)
Test: TestSetup
I0527 16:50:40.139684 69364 tablegc.go:231] TableGC: transition into primary
I0527 16:50:40.182018 69364 tablegc.go:231] TableGC: transition into primary
I0527 16:50:40.189024 69364 engine.go:390] schema engine created [t1_last_insert_id], altered [], dropped []
E0527 16:50:40.225745 69364 query_executor.go:469] failed to reload schema initial packet read failed: EOF (errno 2013) (sqlstate HY000)
I0527 16:50:40.225932 69364 tablegc.go:191] TableGC: closing
I0527 16:50:40.225947 69364 engine.go:102] Messager: closed
I0527 16:50:40.225961 69364 tx_engine.go:333] No grace period specified: performing normal wait.
I0527 16:50:40.226061 69364 tx_engine.go:204] TxEngine: closed
I0527 16:50:40.226067 69364 state_manager.go:504] Killing all OLAP queries.
E0527 16:50:40.226121 69364 tabletserver.go:1368] Code: UNKNOWN
resource pool is closed (CallerID: userData1)
: Sql: "insert into t1_last_insert_id(id1) values (:vtg1)", BindVars: {vtg1: "type:INT64 value:\"70\""}
main_test.go:97:
Error Trace: main_test.go:97
main_test.go:77
Error: Received unexpected error:
target: ks71.-.master: vttablet: rpc error: code = Unknown desc = resource pool is closed (CallerID: userData1) (errno 1105) (sqlstate HY000) during query: insert into ks71.t1_last_insert_id(id1) values(70)
Test: TestSetup
I0527 16:50:40.226394 69364 query_engine.go:284] Query Engine: closed
I0527 16:50:40.226402 69364 engine.go:179] VStreamer: closed
I0527 16:50:40.226406 69364 repltracker.go:122] Replication Tracker: closed
I0527 16:50:40.226471 69364 engine.go:240] Schema Engine: closed
I0527 16:50:40.226485 69364 state_manager.go:563] TabletServer transition: MASTER: Serving, May 27, 2021 at 16:50:35 (CEST) -> MASTER: Not connected to mysql, May 27, 2021 at 16:50:35 (CEST) for tablet :ks71/-
E0527 16:50:40.226492 69364 state_manager.go:278] Cannot connect to MySQL, shutting down query service: initial packet read failed: EOF (errno 2013) (sqlstate HY000)
I0527 16:50:40.226522 69364 tablet_health_check.go:111] HealthCheckUpdate(Serving State): tablet: test-211 () serving true => false for ks71/- (MASTER) reason: healthCheck update
I0527 16:50:40.226535 69364 asm_amd64.s:1374] HealthCheckUpdate(Serving State): test-0000000211, tablet: test-211 () serving => false for ks71/- (MASTER) reason: healthCheck update
I0527 16:50:40.228101 69364 tablegc.go:231] TableGC: transition into primary
E0527 16:50:40.231272 69364 tabletserver.go:1368] initial packet read failed: EOF (errno 2013) (sqlstate HY000) (CallerID: userData1): Sql: "create table t1_last_insert_id (\n\tid1 int\n)", BindVars: {}
main_test.go:92:
Error Trace: main_test.go:92
main_test.go:77
Error: Received unexpected error:
target: ks72.-.master: vttablet: rpc error: code = Canceled desc = initial packet read failed: EOF (errno 2013) (sqlstate HY000) (CallerID: userData1): Sql: "create table t1_last_insert_id (\n\tid1 int\n)", BindVars: {} (errno 2013) (sqlstate HY000) during query: create table ks72.t1_last_insert_id(id1 int)
Test: TestSetup
I0527 16:50:40.267551 69364 tablegc.go:231] TableGC: transition into primary
I0527 16:50:40.268634 69364 engine.go:390] schema engine created [t1_last_insert_id], altered [], dropped []
I0527 16:50:40.308377 69364 tablegc.go:231] TableGC: transition into primary
E0527 16:50:40.309096 69364 query_executor.go:469] failed to reload schema initial packet read failed: EOF (errno 2013) (sqlstate HY000)
I0527 16:50:40.309574 69364 tablegc.go:191] TableGC: closing
I0527 16:50:40.309600 69364 engine.go:102] Messager: closed
I0527 16:50:40.309635 69364 tx_engine.go:333] No grace period specified: performing normal wait.
I0527 16:50:40.314305 69364 tx_engine.go:204] TxEngine: closed
I0527 16:50:40.314350 69364 state_manager.go:504] Killing all OLAP queries.
E0527 16:50:40.314467 69364 tabletserver.go:1368] initial packet read failed: EOF (errno 2013) (sqlstate HY000) (CallerID: userData1): Sql: "insert into t1_last_insert_id(id1) values (:vtg1)", BindVars: {vtg1: "type:INT64 value:\"73\""}
main_test.go:97:
Error Trace: main_test.go:97
main_test.go:77
Error: Received unexpected error:
target: ks74.-.master: vttablet: rpc error: code = Canceled desc = initial packet read failed: EOF (errno 2013) (sqlstate HY000) (CallerID: userData1): Sql: "insert into t1_last_insert_id(id1) values (:vtg1)", BindVars: {vtg1: "type:INT64 value:\"73\""} (errno 2013) (sqlstate HY000) during query: insert into ks74.t1_last_insert_id(id1) values(73)
Test: TestSetup
I0527 16:50:40.315153 69364 query_engine.go:284] Query Engine: closed
I0527 16:50:40.315164 69364 engine.go:179] VStreamer: closed
I0527 16:50:40.315168 69364 repltracker.go:122] Replication Tracker: closed
I0527 16:50:40.315349 69364 engine.go:240] Schema Engine: closed
I0527 16:50:40.315371 69364 state_manager.go:563] TabletServer transition: MASTER: Serving, May 27, 2021 at 16:50:36 (CEST) -> MASTER: Not connected to mysql, May 27, 2021 at 16:50:36 (CEST) for tablet :ks74/-
E0527 16:50:40.315386 69364 state_manager.go:278] Cannot connect to MySQL, shutting down query service: initial packet read failed: EOF (errno 2013) (sqlstate HY000)
I0527 16:50:40.315444 69364 asm_amd64.s:1374] HealthCheckUpdate(Serving State): test-0000000220, tablet: test-220 () serving => false for ks74/- (MASTER) reason: healthCheck update
I0527 16:50:40.315447 69364 tablet_health_check.go:111] HealthCheckUpdate(Serving State): tablet: test-220 () serving true => false for ks74/- (MASTER) reason: healthCheck update
I0527 16:50:40.356115 69364 tablegc.go:231] TableGC: transition into primary
I0527 16:50:40.370350 69364 engine.go:390] schema engine created [t1_last_insert_id], altered [], dropped []
--- FAIL: TestSetup (3.96s)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment