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

pkg/ccl/testccl/sqlccl/sqlccl_test: TestTenantTempTableCleanup failed #85657

Closed
cockroach-teamcity opened this issue Aug 5, 2022 · 25 comments · Fixed by #86288
Closed

pkg/ccl/testccl/sqlccl/sqlccl_test: TestTenantTempTableCleanup failed #85657

cockroach-teamcity opened this issue Aug 5, 2022 · 25 comments · Fixed by #86288
Labels
branch-master Failures and bugs on the master branch. C-test-failure Broken test (automatically or manually discovered). O-robot Originated from a bot.
Milestone

Comments

@cockroach-teamcity
Copy link
Member

cockroach-teamcity commented Aug 5, 2022

pkg/ccl/testccl/sqlccl/sqlccl_test.TestTenantTempTableCleanup failed with artifacts on master @ d687b14e513a49f94e1862c78a7685b78f4fbad9:

=== RUN   TestTenantTempTableCleanup
    temp_table_clean_test.go:145: query 'SELECT table_name FROM [SHOW TABLES]': expected:
        temp_table
        
        got:
        temp_table
        temp_table2
        
--- FAIL: TestTenantTempTableCleanup (21.76s)

Parameters: TAGS=bazel,gss,deadlock

Help

See also: How To Investigate a Go Test Failure (internal)

This test on roachdash | Improve this report!

Jira issue: CRDB-18362

@cockroach-teamcity cockroach-teamcity added branch-master Failures and bugs on the master branch. C-test-failure Broken test (automatically or manually discovered). O-robot Originated from a bot. labels Aug 5, 2022
@cockroach-teamcity cockroach-teamcity added this to the 22.2 milestone Aug 5, 2022
@cockroach-teamcity
Copy link
Member Author

pkg/ccl/testccl/sqlccl/sqlccl_test.TestTenantTempTableCleanup failed with artifacts on master @ d687b14e513a49f94e1862c78a7685b78f4fbad9:

=== RUN   TestTenantTempTableCleanup
    temp_table_clean_test.go:145: query 'SELECT table_name FROM [SHOW TABLES]': expected:
        temp_table
        
        got:
        temp_table
        temp_table2
        
--- FAIL: TestTenantTempTableCleanup (37.43s)

Parameters: TAGS=bazel,gss

Help

See also: How To Investigate a Go Test Failure (internal)

This test on roachdash | Improve this report!

@cockroach-teamcity
Copy link
Member Author

pkg/ccl/testccl/sqlccl/sqlccl_test.TestTenantTempTableCleanup failed with artifacts on master @ db95c2484a9f15c2de01466af0aae19c8ab57618:

=== RUN   TestTenantTempTableCleanup
    temp_table_clean_test.go:145: query 'SELECT table_name FROM [SHOW TABLES]': expected:
        temp_table
        
        got:
        temp_table
        temp_table2
        
--- FAIL: TestTenantTempTableCleanup (22.30s)

Parameters: TAGS=bazel,gss,deadlock

Help

See also: How To Investigate a Go Test Failure (internal)

This test on roachdash | Improve this report!

@cockroach-teamcity
Copy link
Member Author

pkg/ccl/testccl/sqlccl/sqlccl_test.TestTenantTempTableCleanup failed with artifacts on master @ db95c2484a9f15c2de01466af0aae19c8ab57618:

=== RUN   TestTenantTempTableCleanup
    temp_table_clean_test.go:145: query 'SELECT table_name FROM [SHOW TABLES]': expected:
        temp_table
        
        got:
        temp_table
        temp_table2
        
--- FAIL: TestTenantTempTableCleanup (34.89s)

Parameters: TAGS=bazel,gss

Help

See also: How To Investigate a Go Test Failure (internal)

This test on roachdash | Improve this report!

@cockroach-teamcity
Copy link
Member Author

pkg/ccl/testccl/sqlccl/sqlccl_test.TestTenantTempTableCleanup failed with artifacts on master @ a7c91f06d8ee0fa2096bcd626f689009024947bb:

=== RUN   TestTenantTempTableCleanup
    temp_table_clean_test.go:145: query 'SELECT table_name FROM [SHOW TABLES]': expected:
        temp_table
        
        got:
        temp_table
        temp_table2
        
--- FAIL: TestTenantTempTableCleanup (21.65s)

Parameters: TAGS=bazel,gss,deadlock

Help

See also: How To Investigate a Go Test Failure (internal)

This test on roachdash | Improve this report!

@cockroach-teamcity
Copy link
Member Author

pkg/ccl/testccl/sqlccl/sqlccl_test.TestTenantTempTableCleanup failed with artifacts on master @ a7c91f06d8ee0fa2096bcd626f689009024947bb:

=== RUN   TestTenantTempTableCleanup
    temp_table_clean_test.go:145: query 'SELECT table_name FROM [SHOW TABLES]': expected:
        temp_table
        
        got:
        temp_table
        temp_table2
        
--- FAIL: TestTenantTempTableCleanup (37.84s)

Parameters: TAGS=bazel,gss

Help

See also: How To Investigate a Go Test Failure (internal)

This test on roachdash | Improve this report!

@cockroach-teamcity
Copy link
Member Author

pkg/ccl/testccl/sqlccl/sqlccl_test.TestTenantTempTableCleanup failed with artifacts on master @ ce8bfd4811e789bdd4cf31640722517a5cf46237:

=== RUN   TestTenantTempTableCleanup
    temp_table_clean_test.go:145: query 'SELECT table_name FROM [SHOW TABLES]': expected:
        temp_table
        
        got:
        temp_table
        temp_table2
        
--- FAIL: TestTenantTempTableCleanup (23.08s)

Parameters: TAGS=bazel,gss,deadlock

Help

See also: How To Investigate a Go Test Failure (internal)

This test on roachdash | Improve this report!

@cockroach-teamcity
Copy link
Member Author

pkg/ccl/testccl/sqlccl/sqlccl_test.TestTenantTempTableCleanup failed with artifacts on master @ ce8bfd4811e789bdd4cf31640722517a5cf46237:

=== RUN   TestTenantTempTableCleanup
    temp_table_clean_test.go:145: query 'SELECT table_name FROM [SHOW TABLES]': expected:
        temp_table
        
        got:
        temp_table
        temp_table2
        
--- FAIL: TestTenantTempTableCleanup (36.51s)

Parameters: TAGS=bazel,gss

Help

See also: How To Investigate a Go Test Failure (internal)

This test on roachdash | Improve this report!

@cockroach-teamcity
Copy link
Member Author

pkg/ccl/testccl/sqlccl/sqlccl_test.TestTenantTempTableCleanup failed with artifacts on master @ 283035ce93c023431846a0b6d4e2f38a5bb88142:

=== RUN   TestTenantTempTableCleanup
    temp_table_clean_test.go:145: query 'SELECT table_name FROM [SHOW TABLES]': expected:
        temp_table
        
        got:
        temp_table
        temp_table2
        
--- FAIL: TestTenantTempTableCleanup (21.85s)

Parameters: TAGS=bazel,gss,deadlock

Help

See also: How To Investigate a Go Test Failure (internal)

This test on roachdash | Improve this report!

@cockroach-teamcity
Copy link
Member Author

pkg/ccl/testccl/sqlccl/sqlccl_test.TestTenantTempTableCleanup failed with artifacts on master @ 283035ce93c023431846a0b6d4e2f38a5bb88142:

=== RUN   TestTenantTempTableCleanup
    temp_table_clean_test.go:145: query 'SELECT table_name FROM [SHOW TABLES]': expected:
        temp_table
        
        got:
        temp_table
        temp_table2
        
--- FAIL: TestTenantTempTableCleanup (37.74s)

Parameters: TAGS=bazel,gss

Help

See also: How To Investigate a Go Test Failure (internal)

This test on roachdash | Improve this report!

@cockroach-teamcity
Copy link
Member Author

pkg/ccl/testccl/sqlccl/sqlccl_test.TestTenantTempTableCleanup failed with artifacts on master @ 6c24f3564e213371bbe800e9646386cdefeb1546:

=== RUN   TestTenantTempTableCleanup
    temp_table_clean_test.go:145: query 'SELECT table_name FROM [SHOW TABLES]': expected:
        temp_table
        
        got:
        temp_table
        temp_table2
        
--- FAIL: TestTenantTempTableCleanup (22.19s)

Parameters: TAGS=bazel,gss,deadlock

Help

See also: How To Investigate a Go Test Failure (internal)

This test on roachdash | Improve this report!

@cockroach-teamcity
Copy link
Member Author

pkg/ccl/testccl/sqlccl/sqlccl_test.TestTenantTempTableCleanup failed with artifacts on master @ 6c24f3564e213371bbe800e9646386cdefeb1546:

=== RUN   TestTenantTempTableCleanup
    temp_table_clean_test.go:145: query 'SELECT table_name FROM [SHOW TABLES]': expected:
        temp_table
        
        got:
        temp_table
        temp_table2
        
--- FAIL: TestTenantTempTableCleanup (36.19s)

Parameters: TAGS=bazel,gss

Help

See also: How To Investigate a Go Test Failure (internal)

This test on roachdash | Improve this report!

@cockroach-teamcity
Copy link
Member Author

pkg/ccl/testccl/sqlccl/sqlccl_test.TestTenantTempTableCleanup failed with artifacts on master @ d266989c4d30e6fbdc3fd6ac7458e7a651b87131:

=== RUN   TestTenantTempTableCleanup
    temp_table_clean_test.go:145: query 'SELECT table_name FROM [SHOW TABLES]': expected:
        temp_table
        
        got:
        temp_table
        temp_table2
        
--- FAIL: TestTenantTempTableCleanup (34.95s)

Parameters: TAGS=bazel,gss

Help

See also: How To Investigate a Go Test Failure (internal)

This test on roachdash | Improve this report!

@cockroach-teamcity
Copy link
Member Author

pkg/ccl/testccl/sqlccl/sqlccl_test.TestTenantTempTableCleanup failed with artifacts on master @ d266989c4d30e6fbdc3fd6ac7458e7a651b87131:

=== RUN   TestTenantTempTableCleanup
    temp_table_clean_test.go:145: query 'SELECT table_name FROM [SHOW TABLES]': expected:
        temp_table
        
        got:
        temp_table
        temp_table2
        
--- FAIL: TestTenantTempTableCleanup (24.26s)

Parameters: TAGS=bazel,gss,deadlock

Help

See also: How To Investigate a Go Test Failure (internal)

This test on roachdash | Improve this report!

@cockroach-teamcity
Copy link
Member Author

pkg/ccl/testccl/sqlccl/sqlccl_test.TestTenantTempTableCleanup failed with artifacts on master @ 773f7d4445ce3e0e806b7a182adba70a0f270f19:

=== RUN   TestTenantTempTableCleanup
    temp_table_clean_test.go:145: query 'SELECT table_name FROM [SHOW TABLES]': expected:
        temp_table
        
        got:
        temp_table
        temp_table2
        
--- FAIL: TestTenantTempTableCleanup (37.75s)

Parameters: TAGS=bazel,gss

Help

See also: How To Investigate a Go Test Failure (internal)

This test on roachdash | Improve this report!

@cockroach-teamcity
Copy link
Member Author

pkg/ccl/testccl/sqlccl/sqlccl_test.TestTenantTempTableCleanup failed with artifacts on master @ 773f7d4445ce3e0e806b7a182adba70a0f270f19:

=== RUN   TestTenantTempTableCleanup
    temp_table_clean_test.go:145: query 'SELECT table_name FROM [SHOW TABLES]': expected:
        temp_table
        
        got:
        temp_table
        temp_table2
        
--- FAIL: TestTenantTempTableCleanup (22.64s)

Parameters: TAGS=bazel,gss,deadlock

Help

See also: How To Investigate a Go Test Failure (internal)

This test on roachdash | Improve this report!

@cockroach-teamcity
Copy link
Member Author

pkg/ccl/testccl/sqlccl/sqlccl_test.TestTenantTempTableCleanup failed with artifacts on master @ 0dd438d3dc0b42543890455945a7a6b42811def1:

=== RUN   TestTenantTempTableCleanup
    temp_table_clean_test.go:145: query 'SELECT table_name FROM [SHOW TABLES]': expected:
        temp_table
        
        got:
        temp_table
        temp_table2
        
--- FAIL: TestTenantTempTableCleanup (21.39s)

Parameters: TAGS=bazel,gss,deadlock

Help

See also: How To Investigate a Go Test Failure (internal)

This test on roachdash | Improve this report!

@cockroach-teamcity
Copy link
Member Author

pkg/ccl/testccl/sqlccl/sqlccl_test.TestTenantTempTableCleanup failed with artifacts on master @ 0dd438d3dc0b42543890455945a7a6b42811def1:

=== RUN   TestTenantTempTableCleanup
    temp_table_clean_test.go:145: query 'SELECT table_name FROM [SHOW TABLES]': expected:
        temp_table
        
        got:
        temp_table
        temp_table2
        
--- FAIL: TestTenantTempTableCleanup (36.92s)

Parameters: TAGS=bazel,gss

Help

See also: How To Investigate a Go Test Failure (internal)

This test on roachdash | Improve this report!

@cockroach-teamcity
Copy link
Member Author

pkg/ccl/testccl/sqlccl/sqlccl_test.TestTenantTempTableCleanup failed with artifacts on master @ d25cb57ccd9bc643ce9058ebd2057cab36b69ad5:

=== RUN   TestTenantTempTableCleanup
    temp_table_clean_test.go:145: query 'SELECT table_name FROM [SHOW TABLES]': expected:
        temp_table
        
        got:
        temp_table
        temp_table2
        
--- FAIL: TestTenantTempTableCleanup (22.37s)

Parameters: TAGS=bazel,gss,deadlock

Help

See also: How To Investigate a Go Test Failure (internal)

This test on roachdash | Improve this report!

@cockroach-teamcity
Copy link
Member Author

pkg/ccl/testccl/sqlccl/sqlccl_test.TestTenantTempTableCleanup failed with artifacts on master @ d25cb57ccd9bc643ce9058ebd2057cab36b69ad5:

=== RUN   TestTenantTempTableCleanup
    temp_table_clean_test.go:145: query 'SELECT table_name FROM [SHOW TABLES]': expected:
        temp_table
        
        got:
        temp_table
        temp_table2
        
--- FAIL: TestTenantTempTableCleanup (38.28s)

Parameters: TAGS=bazel,gss

Help

See also: How To Investigate a Go Test Failure (internal)

This test on roachdash | Improve this report!

@cockroach-teamcity
Copy link
Member Author

pkg/ccl/testccl/sqlccl/sqlccl_test.TestTenantTempTableCleanup failed with artifacts on master @ 6b7f0058325de8b8b321a08137d462c418c3047f:

=== RUN   TestTenantTempTableCleanup
    temp_table_clean_test.go:145: query 'SELECT table_name FROM [SHOW TABLES]': expected:
        temp_table
        
        got:
        temp_table
        temp_table2
        
--- FAIL: TestTenantTempTableCleanup (22.01s)

Parameters: TAGS=bazel,gss,deadlock

Help

See also: How To Investigate a Go Test Failure (internal)

This test on roachdash | Improve this report!

@cockroach-teamcity
Copy link
Member Author

pkg/ccl/testccl/sqlccl/sqlccl_test.TestTenantTempTableCleanup failed with artifacts on master @ 6b7f0058325de8b8b321a08137d462c418c3047f:

=== RUN   TestTenantTempTableCleanup
    temp_table_clean_test.go:145: query 'SELECT table_name FROM [SHOW TABLES]': expected:
        temp_table
        
        got:
        temp_table
        temp_table2
        
--- FAIL: TestTenantTempTableCleanup (38.49s)

Parameters: TAGS=bazel,gss

Help

See also: How To Investigate a Go Test Failure (internal)

This test on roachdash | Improve this report!

@cockroach-teamcity
Copy link
Member Author

pkg/ccl/testccl/sqlccl/sqlccl_test.TestTenantTempTableCleanup failed with artifacts on master @ f4042d47fa8062a612c38d4696eb6bee9cee7c21:

=== RUN   TestTenantTempTableCleanup
    temp_table_clean_test.go:145: query 'SELECT table_name FROM [SHOW TABLES]': expected:
        temp_table
        
        got:
        temp_table
        temp_table2
        
--- FAIL: TestTenantTempTableCleanup (20.97s)

Parameters: TAGS=bazel,gss,deadlock

Help

See also: How To Investigate a Go Test Failure (internal)

This test on roachdash | Improve this report!

@cockroach-teamcity
Copy link
Member Author

pkg/ccl/testccl/sqlccl/sqlccl_test.TestTenantTempTableCleanup failed with artifacts on master @ f4042d47fa8062a612c38d4696eb6bee9cee7c21:

=== RUN   TestTenantTempTableCleanup
    temp_table_clean_test.go:145: query 'SELECT table_name FROM [SHOW TABLES]': expected:
        temp_table
        
        got:
        temp_table
        temp_table2
        
--- FAIL: TestTenantTempTableCleanup (38.58s)

Parameters: TAGS=bazel,gss

Help

See also: How To Investigate a Go Test Failure (internal)

This test on roachdash | Improve this report!

@cockroach-teamcity
Copy link
Member Author

pkg/ccl/testccl/sqlccl/sqlccl_test.TestTenantTempTableCleanup failed with artifacts on master @ b173a16715e71e94115820374da1eb350b3b459d:

=== RUN   TestTenantTempTableCleanup
    temp_table_clean_test.go:145: query 'SELECT table_name FROM [SHOW TABLES]': expected:
        temp_table
        
        got:
        temp_table
        temp_table2
        
--- FAIL: TestTenantTempTableCleanup (35.72s)

Parameters: TAGS=bazel,gss

Help

See also: How To Investigate a Go Test Failure (internal)

This test on roachdash | Improve this report!

@cockroach-teamcity
Copy link
Member Author

pkg/ccl/testccl/sqlccl/sqlccl_test.TestTenantTempTableCleanup failed with artifacts on master @ b173a16715e71e94115820374da1eb350b3b459d:

=== RUN   TestTenantTempTableCleanup
    temp_table_clean_test.go:145: query 'SELECT table_name FROM [SHOW TABLES]': expected:
        temp_table
        
        got:
        temp_table
        temp_table2
        
--- FAIL: TestTenantTempTableCleanup (22.30s)

Parameters: TAGS=bazel,gss,deadlock

Help

See also: How To Investigate a Go Test Failure (internal)

This test on roachdash | Improve this report!

craig bot pushed a commit that referenced this issue Aug 17, 2022
84999: sql: Secondary Region Followup r=e-mbrown a=e-mbrown

Resolves #68358

For 22.2 we've decided that secondary and super regions should have
minimal interaction. Secondary regions are tied to the primary region,
both wither have to be outside of inside of a super region. In the case
of multiple super regions, the primary and secondary region must be within
the same super region.

Release note (sql change): Secondary regions, like the primary regions can
either be set inside or outside of a super region. In order to move a
secondary region `alter_primary_region_super_region_override` must be enabled
and the primary region moved.

Release justification: Low-risk update to new functionality

86165: sql: Move SplitTable into TestCluster r=rafiss a=ecwall

refs #85800

Move this function to make it accessible by the TTL (and other) tests.

Release note: None

Release justification: Test refactor for TTL.

86212: sql: avoid running lint tests under race/deadlock/stress r=erikgrinaker,srosenberg a=knz

Release justification: changes to test-only code

Release note: None

86264: ui/cluster-ui: add context to inform ui if on cockroach cloud r=xinhaoz a=xinhaoz

Closes #86245

This commit introduces a context `CockroachCloudCountext` that
signifies whether or not the app is within cockroach cloud or
not. This allows us to enable/disable certain features depending
on the platform without plumbing any values. The default context
value is true in order to not set the context explicitly for
cloud components and within the managed-service repo. The
context is provided as false for the db-console app.

This commit also disables the `Time Spent Waiting` column
in active execution tables for CC, since that feature is not yet
available.

Release justification: bug fix, low risk update to existing
functionality
Release note (ui change): The `time spent waiting` columns for
active execution tables has been  hidden on CC

86282: docker: fix the test r=rail a=ZhouXing19

fixes #82747 

We now update the path of the fsnotify binary to mount on the docker.

Release justification: bug fix
Release note: none

86288: testccl/sqlccl: deflake TestTenantTempTableCleanup r=ajwerner a=ajwerner

Fixes #85657

I don't know why we miss this, I guess it has something to do
with not detecting the session is dead on time. A retry works just
fine.

Release justification: testing only change

Release note: None

86302: streamingccl: skip flaky multinode tests r=samiskin a=samiskin

skip these multinode tests until we figure out the nightly flakes.  
Wasn't able to reproduce locally even after 1.5h of stress running 
so I don't know how long it'll  take to figure out.

Both of them fail on the same error which is just creating the
scattered table.  It looks like one of the nodes just dies and
there are other errors related to not being able to connect to it.

Failures: #86287 and #86206

Release justification: test-only changes
Release note: None

Co-authored-by: e-mbrown <ebsonari@gmail.com>
Co-authored-by: Evan Wall <wall@cockroachlabs.com>
Co-authored-by: Raphael 'kena' Poss <knz@thaumogen.net>
Co-authored-by: Xin Hao Zhang <xzhang@cockroachlabs.com>
Co-authored-by: Jane Xing <zhouxing@uchicago.edu>
Co-authored-by: Andrew Werner <ajwerner@cockroachlabs.com>
Co-authored-by: Shiranka Miskin <shiranka.miskin@gmail.com>
@craig craig bot closed this as completed in 14aaaab Aug 17, 2022
xinhaoz pushed a commit to xinhaoz/cockroach that referenced this issue Aug 18, 2022
Fixes cockroachdb#85657

I don't know why we miss this, I guess it has something to do
with not detecting the session is dead on time. A retry works just
fine.

Release justification: testing only change

Release note: None
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-robot Originated from a bot.
Projects
None yet
Development

Successfully merging a pull request may close this issue.

1 participant