- Github Actions CI Builds: convert matrix strategy for unit and cluster tests to individual tests #7258
- Descriptive names for CI checks #7289
- Testing upgrade path from / downgrade path to v8.0.0 #7294
- Backport: Testing version upgrade/downgrade path from/to 8.0 #7323
- [vtctld] vtctldclient command pkg #7321
- Add mysqlctl to docker images #7326
- update java build versions to vitess 10.0.0 #7383
- CI: check run analysis to post JSON from file #7386
Andrés Taylor systay
systay
/ gist:ea20696e4701f07714669ccd1b38ecd8
Created
October 4, 2021 13:07
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
| --- FAIL: TestMultipleUpdatesFromDifferentShards/3 (0.04s) | |
| uptate_controller_test.go:170: | |
| Error Trace: uptate_controller_test.go:170 | |
| Error: Not equal: | |
| expected: 2 | |
| actual : 1 | |
| Test: TestMultipleUpdatesFromDifferentShards/3 | |
| Messages: signal required | |
| uptate_controller_test.go:172: | |
| Error Trace: uptate_controller_test.go:172 |
systay
/ Vitess optimizing
Last active
August 27, 2021 08:46
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
| Traditional query optimizing is mostly about two things: in which order and from where to access data, and how to then combine it so it answers the query that the user wrote. | |
| You have problably seen the tree shapes execution plans that are produced from query planning. I'll use an example from the MySQL docs: | |
| mysql> EXPLAIN FORMAT=TREE | |
| -> SELECT * | |
| -> FROM t1 | |
| -> JOIN t2 | |
| -> ON (t1.c1 = t2.c1 AND t1.c2 < t2.c2) | |
| -> JOIN t3 |
systay
/ gist:10a47e8f9595734887b58bb872f8d359
Created
August 26, 2021 05:26
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
| "select id2 from user uu where id in (select id from user where id = uu.id and user.col in (select col from (select col, id, user_id from user_extra where user_id = 5) uu where uu.user_id = uu.id))" | |
| "unsupported: cross-shard correlated subquery" | |
| { | |
| "QueryType": "SELECT", | |
| "Original": "select id2 from user uu where id in (select id from user where id = uu.id and user.col in (select col from (select col, id, user_id from user_extra where user_id = 5) uu where uu.user_id = uu.id))", | |
| "Instructions": { | |
| "OperatorType": "Subquery", | |
| "Variant": "PulloutIn", | |
| "Inputs": [ | |
| { |
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
| 2021-06-18T05:20:15.8665971Z ##[section]Starting: Request a runner to run this job | |
| 2021-06-18T05:20:15.8930680Z Can't find any online and idle self-hosted runner in current repository that matches the required labels: 'ubuntu-18.04' | |
| 2021-06-18T05:20:15.9163032Z Can't find any online and idle self-hosted runner in current repository's organization account that matches the required labels: 'ubuntu-18.04' | |
| 2021-06-18T05:20:15.9737770Z Found online and idle hosted runner in current repository's organization account that matches the required labels: 'ubuntu-18.04' | |
| 2021-06-18T05:20:16.0681670Z ##[section]Finishing: Request a runner to run this job | |
| 2021-06-18T05:20:21.9347717Z Current runner version: '2.278.0' | |
| 2021-06-18T05:20:21.9375285Z ##[group]Operating System | |
| 2021-06-18T05:20:21.9376160Z Ubuntu | |
| 2021-06-18T05:20:21.9376616Z 18.04.5 | |
| 2021-06-18T05:20:21.9377051Z LTS |
systay
/ gist:01a3a9849eb65cb4da6a36900a19f006
Last active
June 9, 2021 07:21
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
| This release complies with VEP-3 which removes the upgrade order requirement. Components can be upgraded in any order. It is recommended that the upgrade order should still be followed if possible, except to canary test the new version of VTGate before upgrading the rest of the components. | |
| ## Incompatible Changes | |
| The following PRs made changes to behaviors that clients might rely on. They should be reviewed carefully so that client code can be changed in concert with a Vitess release deployment. | |
| * The update to golang 1.15 (#7204) might break systems that use TLS certificates with a common name. A fix is documented here (https://github.com/golang/go/issues/40748#issuecomment-673612108) | |
| Vitess 9.0 is not compatible with the previous release of the Vitess Kubernetes Operator (2.2.0). A new version of the Operator (2.3.0) is available that is compatible. | |
| ## Bugs Fixed |
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
| === 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 [] |
systay
/ releasenotes.md
Last active
April 22, 2021 17:58
systay
/ gist:833e1f16336f60b019b5c4004bdbbcea
Last active
December 2, 2020 14:57
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
| [pre *sqlparser.Union] | |
| [post *sqlparser.Union] [pre *sqlparser.Select] [pre *sqlparser.Limit] [pre sqlparser.OrderBy] [pre *sqlparser.UnionSelect] | |
| [post *sqlparser.Union] [pre *sqlparser.Select] [pre *sqlparser.Limit] [pre sqlparser.OrderBy] [post *sqlparser.UnionSelect] [pre *sqlparser.Select] | |
| [post *sqlparser.Union] [pre *sqlparser.Select] [pre *sqlparser.Limit] [pre sqlparser.OrderBy] [post *sqlparser.UnionSelect] [post *sqlparser.Select] [pre sqlparser.Comments] [pre sqlparser.TableExprs] [pre sqlparser.GroupBy] [pre *sqlparser.Where] [pre *sqlparser.SelectInto] [pre *sqlparser.Limit] [pre sqlparser.OrderBy] [pre sqlparser.SelectExprs] [pre *sqlparser.Where] | |
| [post *sqlparser.Union] [pre *sqlparser.Select] [pre *sqlparser.Limit] [pre sqlparser.OrderBy] [post *sqlparser.UnionSelect] [post *sqlparser.Select] [pre sqlparser.Comments] [pre sqlparser.TableExprs] [pre sqlparser.GroupBy] [pre *sqlparser.Where] [pre *sqlparser.SelectInto] [pre *sqlparser.Limit] [pre sqlparser.OrderBy] [pre sqlparser.SelectExpr |
systay
/ rails query log
Created
July 28, 2020 12:36
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
| > rake (fails) | |
| /usr/local/opt/[email protected]/bin/mysqld, Version: 5.7.29-log (Homebrew). started with: | |
| Tcp port: 0 Unix socket: (null) | |
| Time Id Command Argument | |
| 2020-07-28T12:16:07.003406Z 2 Connect root@localhost on using Socket | |
| 2020-07-28T12:16:07.003677Z 2 Query select @@version_comment limit 1 | |
| 2020-07-28T12:16:17.379892Z 2 Query select 42 | |
| 2020-07-28T12:16:19.373406Z 2 Quit |
systay
/ gist:a7c696984b1366004b28457092abad98
Created
July 16, 2020 08:50
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
| > git bisect run ~/bisect.sh | |
| running /Users/systay/bisect.sh | |
| ok vitess.io/vitess/go/vt/sqlparser (cached) | |
| Bisecting: 396 revisions left to test after this (roughly 9 steps) | |
| [5ea4b4d3dd843bd97ba9021d7bd4456bb34a4b52] tm revamp: update state more aggressively | |
| running /Users/systay/bisect.sh | |
| --- FAIL: TestBisect (0.00s) | |
| bisect_test.go:27: | |
| Error Trace: bisect_test.go:27 |