Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

roachtest: tpcdsvec failed #49315

Closed
cockroach-teamcity opened this issue May 20, 2020 · 2 comments · Fixed by #49333
Closed

roachtest: tpcdsvec failed #49315

cockroach-teamcity opened this issue May 20, 2020 · 2 comments · Fixed by #49333
Assignees
Labels
branch-master Failures and bugs on the master branch. C-test-failure Broken test (automatically or manually discovered). O-roachtest O-robot Originated from a bot. release-blocker Indicates a release-blocker. Use with branch-release-2x.x label to denote which branch is blocked.
Milestone

Comments

@cockroach-teamcity
Copy link
Member

(roachtest).tpcdsvec failed on master@8fec3f4c6d136a86f472c975edd36b75e5ab9a8c:

The test failed on branch=master, cloud=gce:
test artifacts and logs in: /home/agent/work/.go/src/github.com/cockroachdb/cockroach/artifacts/tpcdsvec/run_1
	tpcdsvec.go:203,tpcdsvec.go:213,test_runner.go:753: ERROR: internal error: unexpected error from the vectorized engine: runtime error: invalid memory address or nil pointer dereference (SQLSTATE XX000)
		vectorize=OFF:
		
		SELECT
			ss_customer_sk, sum(act_sales) AS sumsales
		FROM
			(
				SELECT
					ss_item_sk,
					ss_ticket_number,
					ss_customer_sk,
					CASE
					WHEN sr_return_quantity IS NOT NULL
					THEN (ss_quantity - sr_return_quantity)
					* ss_sales_price
					ELSE (ss_quantity * ss_sales_price)
					END
						AS act_sales
				FROM
					store_sales
					LEFT JOIN store_returns ON
							sr_item_sk = ss_item_sk
							AND sr_ticket_number = ss_ticket_number,
					reason
				WHERE
					sr_reason_sk = r_reason_sk
					AND r_reason_desc = 'reason 58'
			)
				AS t
		GROUP BY
			ss_customer_sk
		ORDER BY
			sumsales, ss_customer_sk
		LIMIT
			100;
		;
		
		vectorize=ON: [same as previous]

More

Artifacts: /tpcdsvec

See this test on roachdash
powered by pkg/cmd/internal/issues

@cockroach-teamcity cockroach-teamcity added branch-master Failures and bugs on the master branch. C-test-failure Broken test (automatically or manually discovered). O-roachtest O-robot Originated from a bot. release-blocker Indicates a release-blocker. Use with branch-release-2x.x label to denote which branch is blocked. labels May 20, 2020
@cockroach-teamcity cockroach-teamcity added this to the 20.2 milestone May 20, 2020
@asubiotto asubiotto assigned yuzefovich and unassigned andreimatei May 20, 2020
@cockroach-teamcity
Copy link
Member Author

(roachtest).tpcdsvec failed on master@1520ad2ba7c926f8043de8b6e044ab35c2f67b13:

The test failed on branch=master, cloud=gce:
test artifacts and logs in: /home/agent/work/.go/src/github.com/cockroachdb/cockroach/artifacts/tpcdsvec/run_1
	tpcdsvec.go:203,tpcdsvec.go:213,test_runner.go:753: compare vectorize=OFF to vectorize=ON:
		(1) secondary error attachment
		  | ERROR: internal error: unexpected error from the vectorized engine: runtime error: invalid memory address or nil pointer dereference (SQLSTATE XX000)
		  | (1)
		  | Wraps: (2) ERROR: internal error: unexpected error from the vectorized engine: runtime error: invalid memory address or nil pointer dereference (SQLSTATE XX000)
		  | Error types: (1) *fmt.wrapError (2) pgx.PgError
		Wraps: (2)
		Wraps: (3) compare vectorize=OFF to vectorize=ON:
		  |   []interface{}(Inverse(func1, []interface{}{
		  | - 	s"1.91",
		  | + 	s"2.125",
		  |   }))
		Error types: (1) *secondary.withSecondaryError (2) *fmt.wrapError (3) *errors.errorString

More

Artifacts: /tpcdsvec

See this test on roachdash
powered by pkg/cmd/internal/issues

@cockroach-teamcity
Copy link
Member Author

(roachtest).tpcdsvec failed on master@809829bfe7ff27a610fa78f409fae658b9f2d9d9:

The test failed on branch=master, cloud=gce:
test artifacts and logs in: /home/agent/work/.go/src/github.com/cockroachdb/cockroach/artifacts/tpcdsvec/run_1
	tpcdsvec.go:203,tpcdsvec.go:213,test_runner.go:753: compare vectorize=OFF to vectorize=ON:
		(1) secondary error attachment
		  | ERROR: internal error: unexpected error from the vectorized engine: runtime error: invalid memory address or nil pointer dereference (SQLSTATE XX000)
		  | (1)
		  | Wraps: (2) ERROR: internal error: unexpected error from the vectorized engine: runtime error: invalid memory address or nil pointer dereference (SQLSTATE XX000)
		  | Error types: (1) *fmt.wrapError (2) pgx.PgError
		Wraps: (2)
		Wraps: (3) compare vectorize=OFF to vectorize=ON:
		  |   []interface{}(Inverse(func1, []interface{}{
		  | - 	s"1.91",
		  | + 	s"1.3055555555555555556",
		  |   }))
		Error types: (1) *secondary.withSecondaryError (2) *fmt.wrapError (3) *errors.errorString

More

Artifacts: /tpcdsvec

See this test on roachdash
powered by pkg/cmd/internal/issues

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
branch-master Failures and bugs on the master branch. C-test-failure Broken test (automatically or manually discovered). O-roachtest O-robot Originated from a bot. release-blocker Indicates a release-blocker. Use with branch-release-2x.x label to denote which branch is blocked.
Projects
None yet
Development

Successfully merging a pull request may close this issue.

3 participants