Skip to content

Instantly share code, notes, and snippets.

View systay's full-sized avatar

Andrés Taylor systay

View GitHub Profile

Other

Component: Build/CI

  • 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
[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
> rake (fails)
/usr/local/opt/mysql@5.7/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
> 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
✘ systay@Andress-MacBook-Pro  ~/dev/vitess   format  go test -timeout 30s ./go/test/endtoend/recovery/shardedrecovery -run \^TestUnShardedRecoveryAfterSharding\$
panic: test timed out after 30s
goroutine 155 [running]:
testing.(*M).startAlarm.func1()
/usr/local/go/src/testing/testing.go:1377 +0xdf
created by time.goFunc
/usr/local/go/src/time/sleep.go:168 +0x44
goroutine 1 [chan receive]:
<html>
<head>
<title>Vitess Scatter Query Statistics</title>
<style>
table, th, td {
border: 1px solid black;
}
</style>
</head>
<body>
@systay
systay / example.sql
Last active November 7, 2019 13:27
last insert id deep dive
-- This file will try to show how LAST_INSERT_ID() works.
-- LAST_INSERT_ID is a bit confusing, because it is a few different things tied up into one.
-- First of all, it is state that the mysql server keeps per client-session.
-- Whenever you INSERT a row into a table that uses an auto-incrementing column, this state will be
-- updated with the new id. Remember that this is per session and not per table or database.
-- You will not see new auto-incrementing values when other connections insert new data.
-- Secondly, as a function call without any arguments, it will evaluate to said state.
-- This can be a little bit misleading. If you do SELECT last_insert_id() FROM table, you might be fooled
-- into thinking that you are showing the last inserted id from `table`, but you would be wrong.
go/cmd/vtctl/vtctl.go:79:17: syslogger.Info(startMsg)
go/cmd/vtgateclienttest/services/echo.go:145:11: callback(echoQueryResult(map[string]interface{}{
go/cmd/vtgateclienttest/services/echo.go:269:11: callback(echoQueryResult(map[string]interface{}{
go/cmd/vtgateclienttest/services/echo.go:285:11: callback(echoQueryResult(map[string]interface{}{
go/cmd/vtgateclienttest/services/echo.go:301:11: callback(echoQueryResult(map[string]interface{}{
go/cmd/vtgateclienttest/services/echo.go:317:11: callback(echoQueryResult(map[string]interface{}{
go/cmd/vtgateclienttest/services/echo.go:390:11: callback(&querypb.StreamEvent{
go/cmd/vttablet/healthz.go:39:12: rw.Write(okMessage)
go/cmd/vttestserver/main.go:205:24: defer cluster.TearDown()
go/cmd/vttlstest/vttlstest.go:60:16: subFlags.Parse(args)
Information:java: Errors occurred while compiling module 'testing-support'
Information:javac 8 was used to compile java sources
Information:2019-05-15 17:10 - Build completed with 1 error and 270 warnings in 56 s 125 ms
Error:java: Compilation failed: internal java compiler error
Warning:Output path /Users/antaylor/Development/java/.pants.d/gen/protoc/9c44cc2743fa/connectedusers.connectedusers-protos.src.main.proto.proto/current/com/squareup/protos/connectedusers/.pants-idea-generated/generated_tests intersects with a source root. Only files that were created by build will be cleaned.
Warning:Output path /Users/antaylor/Development/java/.pants.d/gen/protoc/9c44cc2743fa/ratelimiter.api.src.main.proto.proto/current/com/squareup/protos/ratelimiter/api/.pants-idea-generated/generated intersects with a source root. Only files that were created by build will be cleaned.
Warning:Output path /Users/antaylor/Development/java/.pants.d/gen/protoc/9c44cc2743fa/.pants.d.deferred-sources.deferred-sources.external-protos.jo