Google Git
Sign in
skia / buildbot / 6ca8603c26c828c5dc7bc52b4a54b4063b3ac12a
commit6ca8603c26c828c5dc7bc52b4a54b4063b3ac12a[log] [tgz]
authorAlex Sun <sunpeng@google.com>Wed Feb 14 19:09:00 2024 +0000
committerSkCQ <skcq-be@skia-corp.google.com.iam.gserviceaccount.com>Wed Feb 14 20:11:08 2024 +0000
tree8415b987a6edaf8fd4248447fec61282daebf950
parent84c72fbb685c7becfa477feec23d00b005255927 [diff]
Optimize the SQL query to speed up QueryTracesIDOnly.

Issue: the method QueryTracesIDOnly is running too slow to get the traceID and params.

Fix: remove the "order by" clause to speed up the SQL query to query trace ids from the Postings table.

Bug: https://b.corp.google.com/issues/312227681


Change-Id: I59ca9d4be023fb1da6d58dd9d186cf954dea2ce4
Reviewed-on: https://skia-review.googlesource.com/c/buildbot/+/813871
Reviewed-by: Ashwin Verleker <ashwinpv@google.com>
Commit-Queue: Alex Sun <sunpeng@google.com>
2 files changed
tree: 8415b987a6edaf8fd4248447fec61282daebf950
  1. am/
  2. android_ingest/
  3. android_stats/
  4. api/
  5. autoroll/
  6. bash/
  7. bazel/
  8. bisection/
  9. blamer/
  10. bugs-central/
  11. cabe/
  12. cd/
  13. cherrypick-watcher/
  14. cmd/
  15. codereview-watcher/
  16. codesize/
  17. comments/
  18. cq_watcher/
  19. ct/
  20. datahopper/
  21. debugger-app/
  22. demos/
  23. docker/
  24. docker_pushes_watcher/
  25. docs/
  26. docsyserver/
  27. ds/
  28. elements-sk/
  29. email/
  30. external/
  31. fiddlek/
  32. firestore/
  33. get_service_account/
  34. gitsync/
  35. go/
  36. gold-client/
  37. golden/
  38. helloworld/
  39. infra/
  40. infra-sk/
  41. jsdoc/
  42. jsfiddle/
  43. k8s-checker/
  44. k8s-deployer/
  45. kube/
  46. leasing/
  47. licenses/
  48. machine/
  49. make/
  50. modules/
  51. named-fiddles/
  52. new_element/
  53. npm-audit-mirror/
  54. perdiff/
  55. perf/
  56. periodic-trigger/
  57. pinpoint/
  58. proberk/
  59. promk/
  60. puppeteer-tests/
  61. sa-keys-checker/
  62. scrap/
  63. scripts/
  64. shaders/
  65. sk/
  66. skbug/
  67. skcq/
  68. skfe/
  69. skolo/
  70. skottie/
  71. static_server/
  72. status/
  73. task_driver/
  74. task_scheduler/
  75. temporal/
  76. test-service/
  77. tool/
  78. tools/
  79. tree_status/
  80. trybot_updater/
  81. .bazelignore
  82. .bazelrc
  83. .bazelversion
  84. .eslintrc.js
  85. .gitattributes
  86. .gitignore
  87. .mockery.yaml
  88. .npmrc
  89. .prettierignore
  90. .prettierrc.json
  91. .puppeteerrc.js
  92. .vpython
  93. BAZEL_CHEATSHEET.md
  94. BUILD.bazel
  95. build_infra_prod.sh
  96. CDB.md
  97. cipd.ensure
  98. codereview.settings
  99. DATASTORE.md
  100. demopage.sh
  101. DEPS
  102. go.mod
  103. go.sum
  104. go_repositories.bzl
  105. karmatest.sh
  106. launch.md
  107. LICENSE
  108. Makefile
  109. OWNERS
  110. package-lock.json
  111. package.json
  112. pnpm-lock.yaml
  113. PRESUBMIT.py
  114. PRIVACY_POLICY.md
  115. README.md
  116. STYLEGUIDE.md
  117. tools.go
  118. tsconfig.json
  119. whitespace.txt
  120. WORKSPACE
README.md

Skia-Buildbot Repository

This repo contains infrastructure code for Skia.

Getting the Source Code

The main source code repository is a Git repository hosted at https://skia.googlesource.com/buildbot.git. It is possible to check out this repository directly with git clone or via go get.

Using git clone allows you to work in whatever directory you want. You will still need to set GOPATH in order to build some apps (recommended to put this in a cache dir). E.g.:

$ cd ${WORKDIR}
$ git clone https://skia.googlesource.com/buildbot.git
$ export GOPATH=${HOME}/.cache/gopath/$(basename ${WORKDIR})
$ mkdir $GOPATH
$ cd buildbot

Install dependencies

Almost all applications are built with Bazel, and bazelisk is the recommended tool to ensure you have the right version of bazel installed:

go install github.com/bazelbuild/bazelisk@latest
go install github.com/bazelbuild/buildtools/buildifier@latest
go install github.com/kisielk/errcheck@latest
go install golang.org/x/tools/cmd/goimports@latest
go install github.com/mikefarah/yq/v4@latest
go install go.chromium.org/luci/client/cmd/...@latest

Install other dependencies:

sudo apt-get install jq

Build ~everything

bazelisk build --config=mayberemote //...

Test everything

bazelisk test --config=mayberemote //...

Generated Code

To update generated code run the following in any directory:

go generate ./...

Running unit tests

Install Cloud SDK.

Use this command to run the presubmit tests:

./run_unittests --small