Giter VIP home page Giter VIP logo

Comments (2)

cockroach-teamcity avatar cockroach-teamcity commented on July 24, 2024

roachtest.unoptimized-query-oracle/disable-rules=half/rand-tables failed with artifacts on master @ e0068814dfcb4f975a53b79b5546b5fb85c0f927:

(query_comparison_util.go:389).runOneRoundQueryComparison: . 1905 statements run: expected unoptimized and optimized results to be equal
  []string{
  	... // 26 identical elements
  	"Q,NULL,0000-01-01 08:20:00 +0000 UTC",
  	"X,NULL,0000-01-01 08:20:00 +0000 UTC",
+ 	"[,NULL,0000-01-01 08:20:00 +0000 UTC",
  	``\,NULL,0000-01-01 08:20:00 +0000 UTC``,
  	"],NULL,0000-01-01 08:20:00 +0000 UTC",
+ 	"_,NULL,0000-01-01 08:20:00 +0000 UTC",
+ 	"a,NULL,0000-01-01 08:20:00 +0000 UTC",
+ 	"b,NULL,0000-01-01 08:20:00 +0000 UTC",
+ 	"c,NULL,0000-01-01 08:20:00 +0000 UTC",
+ 	"d,NULL,0000-01-01 08:20:00 +0000 UTC",
+ 	"e,NULL,0000-01-01 08:20:00 +0000 UTC",
+ 	"g,NULL,0000-01-01 08:20:00 +0000 UTC",
+ 	"p,NULL,0000-01-01 08:20:00 +0000 UTC",
  	"q,NULL,0000-01-01 08:20:00 +0000 UTC",
+ 	"u,NULL,0000-01-01 08:20:00 +0000 UTC",
+ 	"v,NULL,0000-01-01 08:20:00 +0000 UTC",
+ 	"x,NULL,0000-01-01 08:20:00 +0000 UTC",
+ 	"\x7f,NULL,0000-01-01 08:20:00 +0000 UTC",
+ 	"À,NULL,0000-01-01 08:20:00 +0000 UTC",
  	"à,NULL,0000-01-01 08:20:00 +0000 UTC",
+ 	"á,NULL,0000-01-01 08:20:00 +0000 UTC",
+ 	"�,NULL,0000-01-01 08:20:00 +0000 UTC",
  }
sql: SELECT
	tab_1172.col3_0 AS col_3511, NULL AS col_3512, '08:20:00':::TIME AS col_3513
FROM
	defaultdb.public."ta%qb%plE%q_3"@[0] AS tab_1172
ORDER BY
	tab_1172.col3_7 DESC NULLS LAST,
	tab_1172.col3_4 ASC NULLS FIRST,
	col_3511 NULLS LAST,
	tab_1172.col3_0 DESC NULLS LAST,
	col_3512 NULLS LAST,
	tab_1172.col3_3 ASC NULLS FIRST,
	tab_1172.tableoid DESC NULLS FIRST,
	col_3513 ASC,
	tab_1172.col3_9 ASC NULLS LAST,
	tab_1172.crdb_internal_mvcc_timestamp DESC NULLS FIRST,
	tab_1172."col 3_5" NULLS FIRST,
	tab_1172.col3_8 NULLS LAST,
	tab_1172.col3_10 NULLS LAST,
	tab_1172.col3_6 DESC NULLS FIRST,
	tab_1172.col3_2 DESC NULLS LAST,
	tab_1172.col̲3_1 DESC NULLS FIRST
LIMIT
	32:::INT8
test artifacts and logs in: /artifacts/unoptimized-query-oracle/disable-rules=half/rand-tables/run_1

Parameters:

  • ROACHTEST_arch=amd64
  • ROACHTEST_cloud=gce
  • ROACHTEST_coverageBuild=false
  • ROACHTEST_cpu=4
  • ROACHTEST_encrypted=false
  • ROACHTEST_fs=ext4
  • ROACHTEST_localSSD=true
  • ROACHTEST_metamorphicBuild=false
  • ROACHTEST_ssd=0
Help

See: roachtest README

See: How To Investigate (internal)

See: Grafana

Same failure on other branches

  • #122752 roachtest: unoptimized-query-oracle/disable-rules=half/rand-tables failed [C-test-failure O-roachtest O-robot T-sql-queries branch-release-23.1 release-blocker]
  • #122751 roachtest: unoptimized-query-oracle/disable-rules=half/rand-tables failed [C-test-failure O-roachtest O-robot O-rsg T-sql-queries branch-release-23.2 release-blocker]

This test on roachdash | Improve this report!

from cockroach.

rytaft avatar rytaft commented on July 24, 2024

Dup of #122748

from cockroach.

Related Issues (20)

Recommend Projects

  • React photo React

    A declarative, efficient, and flexible JavaScript library for building user interfaces.

  • Vue.js photo Vue.js

    🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.

  • Typescript photo Typescript

    TypeScript is a superset of JavaScript that compiles to clean JavaScript output.

  • TensorFlow photo TensorFlow

    An Open Source Machine Learning Framework for Everyone

  • Django photo Django

    The Web framework for perfectionists with deadlines.

  • D3 photo D3

    Bring data to life with SVG, Canvas and HTML. 📊📈🎉

Recommend Topics

  • javascript

    JavaScript (JS) is a lightweight interpreted programming language with first-class functions.

  • web

    Some thing interesting about web. New door for the world.

  • server

    A server is a program made to process requests and deliver data to clients.

  • Machine learning

    Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.

  • Game

    Some thing interesting about game, make everyone happy.

Recommend Org

  • Facebook photo Facebook

    We are working to build community through open source technology. NB: members must have two-factor auth.

  • Microsoft photo Microsoft

    Open source projects and samples from Microsoft.

  • Google photo Google

    Google ❤️ Open Source for everyone.

  • D3 photo D3

    Data-Driven Documents codes.