sql/tests: TestRandomSyntaxGeneration failed #74271

cockroach-teamcity · 2021-12-24T06:49:44Z

sql/tests.TestRandomSyntaxGeneration failed with artifacts on release-21.2 @ ec9330f86763371c445acdc317088e24cbcbaac3:

Random syntax error:

    rsg_test.go:779: Crash detected: server panic: statement exec timeout

Query:

        DROP GROUP IF EXISTS ident , RETRY , PLACEHOLDER;

Reproduce

To reproduce, try:

make stressrace TESTS=TestRandomSyntaxGeneration PKG=./pkg/sql/tests TESTTIMEOUT=5m STRESSFLAGS='-timeout 5m' 2>&1

Same failure on other branches

sql/tests: TestRandomSyntaxGeneration failed #65210 sql/tests: TestRandomSyntaxGeneration failed [C-test-failure O-robot branch-release-21.1]

Internal log

mjibson marked as alumn{us/a}; resolving to rafiss instead

/cc @cockroachdb/sql-experience rafiss

This test on roachdash | Improve this report!

Jira issue: CRDB-11998

The text was updated successfully, but these errors were encountered:

cockroach-teamcity · 2021-12-28T06:49:44Z

sql/tests.TestRandomSyntaxGeneration failed with artifacts on release-21.2 @ 2c4bb88e5318fe187e1bf6cb134b31bd63f63528:

Random syntax error:

    rsg_test.go:779: Crash detected: server panic: statement exec timeout

Query:

        DROP ROLE IF EXISTS PLACEHOLDER , 'string' , ident , 'string';

Reproduce

To reproduce, try:

make stressrace TESTS=TestRandomSyntaxGeneration PKG=./pkg/sql/tests TESTTIMEOUT=5m STRESSFLAGS='-timeout 5m' 2>&1

Same failure on other branches

sql/tests: TestRandomSyntaxGeneration failed #65210 sql/tests: TestRandomSyntaxGeneration failed [C-test-failure O-robot branch-release-21.1]

Internal log

mjibson marked as alumn{us/a}; resolving to rafiss instead

/cc @cockroachdb/sql-experience rafiss

This test on roachdash | Improve this report!

cockroach-teamcity · 2021-12-31T06:48:26Z

sql/tests.TestRandomSyntaxGeneration failed with artifacts on release-21.2 @ dc72c17f280dc20fa59970209c0e975e4072f91e:

Random syntax error:

    rsg_test.go:779: Crash detected: server panic: statement exec timeout

Query:

        CREATE USER PLACEHOLDER;

Reproduce

To reproduce, try:

make stressrace TESTS=TestRandomSyntaxGeneration PKG=./pkg/sql/tests TESTTIMEOUT=5m STRESSFLAGS='-timeout 5m' 2>&1

Same failure on other branches

sql/tests: TestRandomSyntaxGeneration failed #65210 sql/tests: TestRandomSyntaxGeneration failed [C-test-failure O-robot branch-release-21.1]

Internal log

mjibson marked as alumn{us/a}; resolving to rafiss instead

/cc @cockroachdb/sql-experience rafiss

This test on roachdash | Improve this report!

cockroach-teamcity · 2022-01-08T06:47:58Z

sql/tests.TestRandomSyntaxGeneration failed with artifacts on release-21.2 @ f26513f0b00c95e2e98d5ce3032abd7e65ff0e3d:

Random syntax error:

    rsg_test.go:779: Crash detected: server panic: statement exec timeout

Query:

        DROP GROUP IF EXISTS PRECISION , 'string' , PLACEHOLDER , 'string' , PLACEHOLDER , 'string' , SURVIVE , PLACEHOLDER , PLACEHOLDER;

Reproduce

To reproduce, try:

make stressrace TESTS=TestRandomSyntaxGeneration PKG=./pkg/sql/tests TESTTIMEOUT=5m STRESSFLAGS='-timeout 5m' 2>&1

Same failure on other branches

sql/tests: TestRandomSyntaxGeneration failed #65210 sql/tests: TestRandomSyntaxGeneration failed [C-test-failure O-robot branch-release-21.1]

Internal log

mjibson marked as alumn{us/a}; resolving to rafiss instead

/cc @cockroachdb/sql-experience rafiss

This test on roachdash | Improve this report!

cockroach-teamcity · 2022-01-10T06:47:56Z

sql/tests.TestRandomSyntaxGeneration failed with artifacts on release-21.2 @ 3082c28f2dae9540c4f69ab2ffd6a1d92982b4fe:

Random syntax error:

    rsg_test.go:779: Crash detected: server panic: statement exec timeout

Query:

        DROP USER IF EXISTS 'string' , PLACEHOLDER , PLANS , PLACEHOLDER , PLACEHOLDER;

Reproduce

To reproduce, try:

make stressrace TESTS=TestRandomSyntaxGeneration PKG=./pkg/sql/tests TESTTIMEOUT=5m STRESSFLAGS='-timeout 5m' 2>&1

Same failure on other branches

sql/tests: TestRandomSyntaxGeneration failed #65210 sql/tests: TestRandomSyntaxGeneration failed [C-test-failure O-robot branch-release-21.1]

Internal log

mjibson marked as alumn{us/a}; resolving to rafiss instead

/cc @cockroachdb/sql-experience rafiss

This test on roachdash | Improve this report!

RichardJCai · 2022-01-18T21:54:09Z

    rsg_test.go:204: SELECT 1 executed successfully: probably a slow statement
    rsg_test.go:779: Crash detected: server panic: statement exec timeout
        DROP USER IF EXISTS 'string' , PLACEHOLDER , PLANS , PLACEHOLDER , PLACEHOLDER;
        
        Stack trace:
        timeout: "DROP USER IF EXISTS 'string' , PLACEHOLDER , PLANS , PLACEHOLDER , PLACEHOLDER". currently executing: map[CREATE GROUP IF NOT EXISTS 'string' WITH NOCANCELQUERY:1 CREATE ROLE PLACEHOLDER WITH NOLOGIN:1 CREATE USER IF NOT EXISTS PLACEHOLDER WITH NOCANCELQUERY:1 CREATE USER ISERROR WITH NOCANCELQUERY:1 DROP GROUP IF EXISTS IS , 'string' , PLACEHOLDER , 'string' , 'string' , OUTER , PLACEHOLDER:1 DROP USER IF EXISTS 'string' , PLACEHOLDER , PLANS , PLACEHOLDER , PLACEHOLDER:1 DROP USER INNER:1 REASSIGN OWNED BY STRING , CREATEROLE TO BIGINT:1]

Concurrently executing these commands:

DROP USER IF EXISTS 'string' , PLACEHOLDER , PLANS , PLACEHOLDER , PLACEHOLDER
CREATE GROUP IF NOT EXISTS 'string' WITH NOCANCELQUERY
CREATE ROLE PLACEHOLDER WITH NOLOGIN
CREATE USER IF NOT EXISTS PLACEHOLDER WITH NOCANCELQUERY
CREATE USER ISERROR WITH NOCANCELQUERY
DROP GROUP IF EXISTS IS , 'string' , PLACEHOLDER , 'string' , 'string' , OUTER , PLACEHOLDER
DROP USER IF EXISTS 'string' , PLACEHOLDER , PLANS , PLACEHOLDER , PLACEHOLDER
DROP USER INNER
REASSIGN OWNED BY STRING , CREATEROLE TO BIGINT

We might possibly have a deadlock here? The commands individually shouldn't take long to run.

cockroach-teamcity · 2022-01-19T06:49:41Z

sql/tests.TestRandomSyntaxGeneration failed with artifacts on release-21.2 @ 0655d082b0d98f27e77471fcced8de94cd9327bc:

Random syntax error:

    rsg_test.go:779: Crash detected: server panic: statement exec timeout

Query:

        CREATE GROUP PLACEHOLDER WITH NOCREATEROLE MODIFYCLUSTERSETTING NOVIEWACTIVITY;

Reproduce

To reproduce, try:

make stressrace TESTS=TestRandomSyntaxGeneration PKG=./pkg/sql/tests TESTTIMEOUT=5m STRESSFLAGS='-timeout 5m' 2>&1

Same failure on other branches

sql/tests: TestRandomSyntaxGeneration failed #65210 sql/tests: TestRandomSyntaxGeneration failed [C-test-failure O-robot branch-release-21.1]

Internal log

mjibson marked as alumn{us/a}; resolving to rafiss instead

/cc @cockroachdb/sql-experience rafiss

This test on roachdash | Improve this report!

RichardJCai · 2022-01-20T19:12:51Z

I think we have a genuine deadlock when creating / dropping the same user concurrently
#75236

ajwerner · 2022-01-31T23:42:17Z

This is going to end up being the same thing we've had in the past with leased caches. We'll need to make the request to fetch the cache high priority. 😢 I didn't think about this then. See #46384 and friends.

cockroach-teamcity · 2022-02-02T06:11:23Z

sql/tests.TestRandomSyntaxGeneration failed with artifacts on release-21.2 @ 5afb632f77eee9f09f2adfa2943e1979ec4ebedf:

F220202 06:11:19.263071 292 kv/kvserver/reports/reporter.go:489  [n1,replication-reporter] 1 !	/usr/local/go/src/crypto/tls/conn.go:605 +0x115
F220202 06:11:19.263071 292 kv/kvserver/reports/reporter.go:489  [n1,replication-reporter] 1 !crypto/tls.(*Conn).readRecord(...)
F220202 06:11:19.263071 292 kv/kvserver/reports/reporter.go:489  [n1,replication-reporter] 1 !	/usr/local/go/src/crypto/tls/conn.go:573
F220202 06:11:19.263071 292 kv/kvserver/reports/reporter.go:489  [n1,replication-reporter] 1 !crypto/tls.(*Conn).Read(0xc00a59ae00, 0xc00ce06000, 0x1000, 0x1000, 0x0, 0x0, 0x0)
F220202 06:11:19.263071 292 kv/kvserver/reports/reporter.go:489  [n1,replication-reporter] 1 !	/usr/local/go/src/crypto/tls/conn.go:1276 +0x165
F220202 06:11:19.263071 292 kv/kvserver/reports/reporter.go:489  [n1,replication-reporter] 1 !github.com/cockroachdb/cockroach/pkg/sql/pgwire.(*readTimeoutConn).Read(0xc010df1f80, 0xc00ce06000, 0x1000, 0x1000, 0x0, 0x0, 0x0)
F220202 06:11:19.263071 292 kv/kvserver/reports/reporter.go:489  [n1,replication-reporter] 1 !	/go/src/github.com/cockroachdb/cockroach/pkg/sql/pgwire/conn.go:1739 +0x12a
F220202 06:11:19.263071 292 kv/kvserver/reports/reporter.go:489  [n1,replication-reporter] 1 !bufio.(*Reader).fill(0xc000c64d68)
F220202 06:11:19.263071 292 kv/kvserver/reports/reporter.go:489  [n1,replication-reporter] 1 !	/usr/local/go/src/bufio/bufio.go:101 +0x108
F220202 06:11:19.263071 292 kv/kvserver/reports/reporter.go:489  [n1,replication-reporter] 1 !bufio.(*Reader).ReadByte(0xc000c64d68, 0x1581b340, 0xed98c1784, 0x0)
F220202 06:11:19.263071 292 kv/kvserver/reports/reporter.go:489  [n1,replication-reporter] 1 !	/usr/local/go/src/bufio/bufio.go:253 +0x39
F220202 06:11:19.263071 292 kv/kvserver/reports/reporter.go:489  [n1,replication-reporter] 1 !github.com/cockroachdb/cockroach/pkg/sql/pgwire/pgwirebase.(*ReadBuffer).ReadTypedMsg(0xc000c65538, 0x6acef00, 0xc000c64d68, 0x6ac6b98, 0x93b28a0, 0x0, 0x0)
F220202 06:11:19.263071 292 kv/kvserver/reports/reporter.go:489  [n1,replication-reporter] 1 !	/go/src/github.com/cockroachdb/cockroach/pkg/sql/pgwire/pgwirebase/encoding.go:203 +0x35
F220202 06:11:19.263071 292 kv/kvserver/reports/reporter.go:489  [n1,replication-reporter] 1 !github.com/cockroachdb/cockroach/pkg/sql/pgwire.(*conn).serveImpl.func5(0xc000c64d00, 0xc007d9a830, 0xc012f9f773, 0xc012f9f774, 0x6ade770, 0xc00cd14120, 0xc000c5b100, 0xc00337f360, 0xc012f9f772, 0x0, ...)
F220202 06:11:19.263071 292 kv/kvserver/reports/reporter.go:489  [n1,replication-reporter] 1 !	/go/src/github.com/cockroachdb/cockroach/pkg/sql/pgwire/conn.go:348 +0x71
F220202 06:11:19.263071 292 kv/kvserver/reports/reporter.go:489  [n1,replication-reporter] 1 !github.com/cockroachdb/cockroach/pkg/sql/pgwire.(*conn).serveImpl(0xc000c64d00, 0x6b0ebb0, 0xc0087451d0, 0xc007d9a820, 0xc000c5b100, 0x5400, 0x15000, 0xc001b71900, 0x0, 0x4, ...)
F220202 06:11:19.263071 292 kv/kvserver/reports/reporter.go:489  [n1,replication-reporter] 1 !	/go/src/github.com/cockroachdb/cockroach/pkg/sql/pgwire/conn.go:481 +0x63b
F220202 06:11:19.263071 292 kv/kvserver/reports/reporter.go:489  [n1,replication-reporter] 1 !github.com/cockroachdb/cockroach/pkg/sql/pgwire.(*Server).serveConn(0xc001bfefc0, 0x6b0ebb0, 0xc0087451d0, 0x6b70a78, 0xc00a59ae00, 0xc006faa01e, 0x4, 0x1, 0xc0087451a0, 0x6ac5158, ...)
F220202 06:11:19.263071 292 kv/kvserver/reports/reporter.go:489  [n1,replication-reporter] 1 !	/go/src/github.com/cockroachdb/cockroach/pkg/sql/pgwire/conn.go:160 +0x1d8
F220202 06:11:19.263071 292 kv/kvserver/reports/reporter.go:489  [n1,replication-reporter] 1 !github.com/cockroachdb/cockroach/pkg/sql/pgwire.(*Server).ServeConn(0xc001bfefc0, 0x6b0ebb0, 0xc0087451d0, 0x6b75988, 0xc00a59ae00, 0x6b0eb01, 0x0, 0x0)
F220202 06:11:19.263071 292 kv/kvserver/reports/reporter.go:489  [n1,replication-reporter] 1 !	/go/src/github.com/cockroachdb/cockroach/pkg/sql/pgwire/server.go:706 +0xe65
F220202 06:11:19.263071 292 kv/kvserver/reports/reporter.go:489  [n1,replication-reporter] 1 !github.com/cockroachdb/cockroach/pkg/server.(*SQLServer).startServeSQL.func1.1(0x6b75988, 0xc00a9d9118)
F220202 06:11:19.263071 292 kv/kvserver/reports/reporter.go:489  [n1,replication-reporter] 1 !	/go/src/github.com/cockroachdb/cockroach/pkg/server/server.go:2363 +0xf7
F220202 06:11:19.263071 292 kv/kvserver/reports/reporter.go:489  [n1,replication-reporter] 1 !github.com/cockroachdb/cockroach/pkg/util/netutil.(*Server).ServeWith.func1(0xc000628280, 0x6b0ebb0, 0xc0005e5d10, 0xc000b593a8, 0x6b75988, 0xc00a9d9118, 0xc001d63bc0)
F220202 06:11:19.263071 292 kv/kvserver/reports/reporter.go:489  [n1,replication-reporter] 1 !	/go/src/github.com/cockroachdb/cockroach/pkg/util/netutil/net.go:156 +0xaf
F220202 06:11:19.263071 292 kv/kvserver/reports/reporter.go:489  [n1,replication-reporter] 1 !created by github.com/cockroachdb/cockroach/pkg/util/netutil.(*Server).ServeWith
F220202 06:11:19.263071 292 kv/kvserver/reports/reporter.go:489  [n1,replication-reporter] 1 !	/go/src/github.com/cockroachdb/cockroach/pkg/util/netutil/net.go:153 +0x256
F220202 06:11:19.263071 292 kv/kvserver/reports/reporter.go:489  [n1,replication-reporter] 1 !
F220202 06:11:19.263071 292 kv/kvserver/reports/reporter.go:489  [n1,replication-reporter] 1 !For more context, check log files in: /go/src/github.com/cockroachdb/cockroach/artifacts/logTestRandomSyntaxGeneration523787394
F220202 06:11:19.263071 292 kv/kvserver/reports/reporter.go:489  [n1,replication-reporter] 1 !
F220202 06:11:19.263071 292 kv/kvserver/reports/reporter.go:489  [n1,replication-reporter] 1 !
F220202 06:11:19.263071 292 kv/kvserver/reports/reporter.go:489  [n1,replication-reporter] 1 !****************************************************************************
F220202 06:11:19.263071 292 kv/kvserver/reports/reporter.go:489  [n1,replication-reporter] 1 !
F220202 06:11:19.263071 292 kv/kvserver/reports/reporter.go:489  [n1,replication-reporter] 1 !This node experienced a fatal error (printed above), and as a result the
F220202 06:11:19.263071 292 kv/kvserver/reports/reporter.go:489  [n1,replication-reporter] 1 !process is terminating.
F220202 06:11:19.263071 292 kv/kvserver/reports/reporter.go:489  [n1,replication-reporter] 1 !
F220202 06:11:19.263071 292 kv/kvserver/reports/reporter.go:489  [n1,replication-reporter] 1 !Fatal errors can occur due to faulty hardware (disks, memory, clocks) or a
F220202 06:11:19.263071 292 kv/kvserver/reports/reporter.go:489  [n1,replication-reporter] 1 !problem in CockroachDB. With your help, the support team at Cockroach Labs
F220202 06:11:19.263071 292 kv/kvserver/reports/reporter.go:489  [n1,replication-reporter] 1 !will try to determine the root cause, recommend next steps, and we can
F220202 06:11:19.263071 292 kv/kvserver/reports/reporter.go:489  [n1,replication-reporter] 1 !improve CockroachDB based on your report.
F220202 06:11:19.263071 292 kv/kvserver/reports/reporter.go:489  [n1,replication-reporter] 1 !
F220202 06:11:19.263071 292 kv/kvserver/reports/reporter.go:489  [n1,replication-reporter] 1 !Please submit a crash report by following the instructions here:
F220202 06:11:19.263071 292 kv/kvserver/reports/reporter.go:489  [n1,replication-reporter] 1 !
F220202 06:11:19.263071 292 kv/kvserver/reports/reporter.go:489  [n1,replication-reporter] 1 !    https://github.com/cockroachdb/cockroach/issues/new/choose
F220202 06:11:19.263071 292 kv/kvserver/reports/reporter.go:489  [n1,replication-reporter] 1 !
F220202 06:11:19.263071 292 kv/kvserver/reports/reporter.go:489  [n1,replication-reporter] 1 !If you would rather not post publicly, please contact us directly at:
F220202 06:11:19.263071 292 kv/kvserver/reports/reporter.go:489  [n1,replication-reporter] 1 !
F220202 06:11:19.263071 292 kv/kvserver/reports/reporter.go:489  [n1,replication-reporter] 1 !    [email protected]
F220202 06:11:19.263071 292 kv/kvserver/reports/reporter.go:489  [n1,replication-reporter] 1 !
F220202 06:11:19.263071 292 kv/kvserver/reports/reporter.go:489  [n1,replication-reporter] 1 !The Cockroach Labs team appreciates your feedback.

Reproduce

To reproduce, try:

make stressrace TESTS=TestRandomSyntaxGeneration PKG=./pkg/sql/tests TESTTIMEOUT=5m STRESSFLAGS='-timeout 5m' 2>&1

Same failure on other branches

sql/tests: TestRandomSyntaxGeneration failed [bucket count syntax] #75604 sql/tests: TestRandomSyntaxGeneration failed [bucket count syntax] [C-test-failure O-robot T-sql-schema branch-master]
sql/tests: TestRandomSyntaxGeneration failed #65210 sql/tests: TestRandomSyntaxGeneration failed [C-test-failure O-robot branch-release-21.1]

Internal log

mjibson marked as alumn{us/a}; resolving to rafiss instead

/cc @cockroachdb/sql-experience rafiss

This test on roachdash | Improve this report!

rafiss · 2022-02-02T06:27:40Z

Latest failure:

I220202 06:11:19.263021 292 1@kv/kvserver/reports/reporter.go:489 â‹® [n1,replication-reporter] 2462  the server is terminating due to a fatal error (see the DEV channel for details)
F220202 06:11:19.263071 292 kv/kvserver/reports/reporter.go:489 â‹® [n1,replication-reporter] 2463  default zone config missing unexpectedly

which appears to be another case of #43951

I tried this:

[email protected]:26257/movr> alter range default configure zone discard;
ERROR: cannot remove default zone

So I guess there's another way to remove the default zone config.

cockroach-teamcity · 2022-02-04T06:48:52Z

sql/tests.TestRandomSyntaxGeneration failed with artifacts on release-21.2 @ 9b06fffa0e5ffed8aa92cd0d860380dafe993bd2:

Random syntax error:

    rsg_test.go:779: Crash detected: server panic: statement exec timeout

Query:

        DROP ROLE IF EXISTS PLACEHOLDER , CHARACTER , FAMILY , PLACEHOLDER;

Reproduce

To reproduce, try:

make stressrace TESTS=TestRandomSyntaxGeneration PKG=./pkg/sql/tests TESTTIMEOUT=5m STRESSFLAGS='-timeout 5m' 2>&1

Same failure on other branches

sql/tests: TestRandomSyntaxGeneration failed [bucket count syntax] #75604 sql/tests: TestRandomSyntaxGeneration failed [bucket count syntax] [C-test-failure O-robot T-sql-schema branch-master]
sql/tests: TestRandomSyntaxGeneration failed #65210 sql/tests: TestRandomSyntaxGeneration failed [C-test-failure O-robot branch-release-21.1]

Internal log

mjibson marked as alumn{us/a}; resolving to rafiss instead

/cc @cockroachdb/sql-experience rafiss

This test on roachdash | Improve this report!

cockroach-teamcity · 2022-02-05T07:19:24Z

sql/tests.TestRandomSyntaxGeneration failed with artifacts on release-21.2 @ 0aa40c1edfb9166b169e91eaa19514ba0898e10c:

Random syntax error:

    rsg_test.go:779: Crash detected: server panic: statement exec timeout

Query:

        DROP GROUP IF EXISTS ISERROR , PLACEHOLDER , ident;

Reproduce

To reproduce, try:

make stressrace TESTS=TestRandomSyntaxGeneration PKG=./pkg/sql/tests TESTTIMEOUT=5m STRESSFLAGS='-timeout 5m' 2>&1

Same failure on other branches

sql/tests: TestRandomSyntaxGeneration failed [bucket count syntax] #75604 sql/tests: TestRandomSyntaxGeneration failed [bucket count syntax] [C-test-failure O-robot T-sql-schema branch-master]
sql/tests: TestRandomSyntaxGeneration failed #65210 sql/tests: TestRandomSyntaxGeneration failed [C-test-failure O-robot branch-release-21.1]

Internal log

mjibson marked as alumn{us/a}; resolving to rafiss instead

/cc @cockroachdb/sql-experience rafiss

This test on roachdash | Improve this report!

cockroach-teamcity · 2022-02-10T06:47:17Z

sql/tests.TestRandomSyntaxGeneration failed with artifacts on release-21.2 @ c7d2f46924e8af82a3b2bf175e32adc1d44b06f7:

Random syntax error:

    rsg_test.go:779: Crash detected: server panic: statement exec timeout

Query:

        DROP USER IF EXISTS PLACEHOLDER , 'string' , PLACEHOLDER;

Reproduce

To reproduce, try:

make stressrace TESTS=TestRandomSyntaxGeneration PKG=./pkg/sql/tests TESTTIMEOUT=5m STRESSFLAGS='-timeout 5m' 2>&1

Same failure on other branches

sql/tests: TestRandomSyntaxGeneration failed [bucket count syntax] #75604 sql/tests: TestRandomSyntaxGeneration failed [bucket count syntax] [C-test-failure O-robot T-sql-schema branch-master]
sql/tests: TestRandomSyntaxGeneration failed #65210 sql/tests: TestRandomSyntaxGeneration failed [C-test-failure O-robot branch-release-21.1]

Internal log

mjibson marked as alumn{us/a}; resolving to rafiss instead

/cc @cockroachdb/sql-experience rafiss

This test on roachdash | Improve this report!

cockroach-teamcity · 2022-02-24T06:48:26Z

sql/tests.TestRandomSyntaxGeneration failed with artifacts on release-21.2 @ 7609772f419a5bfe70028f27cb864e8058fdc6cc:

Random syntax error:

    rsg_test.go:779: Crash detected: server panic: statement exec timeout

Query:

        EXPLAIN ANALYSE ALTER USER error;

Reproduce

To reproduce, try:

make stressrace TESTS=TestRandomSyntaxGeneration PKG=./pkg/sql/tests TESTTIMEOUT=5m STRESSFLAGS='-timeout 5m' 2>&1

Same failure on other branches

sql/tests: TestRandomSyntaxGeneration failed [bucket count syntax] #75604 sql/tests: TestRandomSyntaxGeneration failed [bucket count syntax] [C-test-failure O-robot T-sql-schema branch-master]
sql/tests: TestRandomSyntaxGeneration failed #65210 sql/tests: TestRandomSyntaxGeneration failed [C-test-failure O-robot branch-release-21.1]

Internal log

mjibson marked as alumn{us/a}; resolving to rafiss instead

/cc @cockroachdb/sql-experience rafiss

This test on roachdash | Improve this report!

cockroach-teamcity · 2022-03-02T06:47:02Z

sql/tests.TestRandomSyntaxGeneration failed with artifacts on release-21.2 @ 93a02dffaabcca5e453c8d62e9cd0051c123a18b:

Random syntax error:

    rsg_test.go:779: Crash detected: server panic: statement exec timeout

Query:

        DROP USER IF EXISTS INCREMENTAL , VARBIT , PLACEHOLDER , 'string' , PLACEHOLDER;

Reproduce

To reproduce, try:

make stressrace TESTS=TestRandomSyntaxGeneration PKG=./pkg/sql/tests TESTTIMEOUT=5m STRESSFLAGS='-timeout 5m' 2>&1

Same failure on other branches

sql/tests: TestRandomSyntaxGeneration failed [bucket count syntax] #75604 sql/tests: TestRandomSyntaxGeneration failed [bucket count syntax] [C-test-failure O-robot T-sql-schema branch-master]
sql/tests: TestRandomSyntaxGeneration failed #65210 sql/tests: TestRandomSyntaxGeneration failed [C-test-failure O-robot branch-release-21.1]

Internal log

mjibson marked as alumn{us/a}; resolving to rafiss instead

/cc @cockroachdb/sql-experience rafiss

This test on roachdash | Improve this report!

cockroach-teamcity · 2022-03-15T05:47:34Z

sql/tests.TestRandomSyntaxGeneration failed with artifacts on release-21.2 @ c0c90985fe99132ac63e0750957f5b7aacadb8fa:

Random syntax error:

    rsg_test.go:779: Crash detected: server panic: driver: bad connection

Query:

        DROP GROUP IF EXISTS PLACEHOLDER , PLACEHOLDER , 'string' , PLACEHOLDER;

Reproduce

To reproduce, try:

make stressrace TESTS=TestRandomSyntaxGeneration PKG=./pkg/sql/tests TESTTIMEOUT=5m STRESSFLAGS='-timeout 5m' 2>&1

Same failure on other branches

sql/tests: TestRandomSyntaxGeneration failed [bucket count syntax] #75604 sql/tests: TestRandomSyntaxGeneration failed [bucket count syntax] [C-test-failure O-robot T-sql-schema branch-master]
sql/tests: TestRandomSyntaxGeneration failed #65210 sql/tests: TestRandomSyntaxGeneration failed [C-test-failure O-robot branch-release-21.1]

Internal log

mjibson marked as alumn{us/a}; resolving to rafiss instead

/cc @cockroachdb/sql-experience rafiss

This test on roachdash | Improve this report!

cockroach-teamcity · 2022-04-22T05:49:39Z

sql/tests.TestRandomSyntaxGeneration failed with artifacts on release-21.2 @ 11b1a69987f9737844560116787d1e7a125ae935:

Random syntax error:

    rsg_test.go:779: Crash detected: server panic: statement exec timeout

Query:

        ALTER DATABASE ident RENAME TO VARBIT;

Reproduce

To reproduce, try:

make stressrace TESTS=TestRandomSyntaxGeneration PKG=./pkg/sql/tests TESTTIMEOUT=5m STRESSFLAGS='-timeout 5m' 2>&1

Same failure on other branches

sql/tests: TestRandomSyntaxGeneration failed #77893 sql/tests: TestRandomSyntaxGeneration failed [C-test-failure O-robot T-sql-experience branch-release-22.1]
sql/tests: TestRandomSyntaxGeneration failed [bucket count syntax] #75604 sql/tests: TestRandomSyntaxGeneration failed [bucket count syntax] [C-test-failure O-robot T-sql-schema branch-master]
sql/tests: TestRandomSyntaxGeneration failed #65210 sql/tests: TestRandomSyntaxGeneration failed [C-test-failure O-robot branch-release-21.1]

Internal log

mjibson marked as alumn{us/a}; resolving to rafiss instead

/cc @cockroachdb/sql-experience rafiss

This test on roachdash | Improve this report!

cockroach-teamcity · 2022-04-26T05:47:44Z

sql/tests.TestRandomSyntaxGeneration failed with artifacts on release-21.2 @ 39511c6a4d0bbb580b7ff6f5c0e1e77664474efb:

Random syntax error:

    rsg_test.go:779: Crash detected: server panic: statement exec timeout

Query:

        DROP GROUP IF EXISTS FAMILY , PLACEHOLDER , PLACEHOLDER;

Reproduce

To reproduce, try:

make stressrace TESTS=TestRandomSyntaxGeneration PKG=./pkg/sql/tests TESTTIMEOUT=5m STRESSFLAGS='-timeout 5m' 2>&1

Same failure on other branches

sql/tests: TestRandomSyntaxGeneration failed #77893 sql/tests: TestRandomSyntaxGeneration failed [C-test-failure O-robot T-sql-experience branch-release-22.1]
sql/tests: TestRandomSyntaxGeneration failed [bucket count syntax] #75604 sql/tests: TestRandomSyntaxGeneration failed [bucket count syntax] [C-test-failure O-robot T-sql-schema branch-master]
sql/tests: TestRandomSyntaxGeneration failed #65210 sql/tests: TestRandomSyntaxGeneration failed [C-test-failure O-robot branch-release-21.1]

Internal log

mjibson marked as alumn{us/a}; resolving to rafiss instead

/cc @cockroachdb/sql-experience rafiss

This test on roachdash | Improve this report!

cockroach-teamcity · 2022-06-03T05:49:55Z

sql/tests.TestRandomSyntaxGeneration failed with artifacts on release-21.2 @ a29d2c452eab1afecdeef6c5b94852896f134972:

Random syntax error:

    rsg_test.go:779: Crash detected: server panic: statement exec timeout

Query:

        DROP ROLE error;

Reproduce

To reproduce, try:

make stressrace TESTS=TestRandomSyntaxGeneration PKG=./pkg/sql/tests TESTTIMEOUT=5m STRESSFLAGS='-timeout 5m' 2>&1

Same failure on other branches

sql/tests: TestRandomSyntaxGeneration failed #77893 sql/tests: TestRandomSyntaxGeneration failed [C-test-failure O-robot T-sql-experience branch-release-22.1]
sql/tests: TestRandomSyntaxGeneration failed [bucket count syntax] #75604 sql/tests: TestRandomSyntaxGeneration failed [bucket count syntax] [C-test-failure O-robot T-sql-schema branch-master]
sql/tests: TestRandomSyntaxGeneration failed #65210 sql/tests: TestRandomSyntaxGeneration failed [C-test-failure O-robot branch-release-21.1]

Internal log

mjibson marked as alumn{us/a}; resolving to rafiss instead

/cc @cockroachdb/sql-experience rafiss

This test on roachdash | Improve this report!

cockroach-teamcity · 2022-11-04T05:47:27Z

sql/tests.TestRandomSyntaxGeneration failed with artifacts on release-21.2 @ b03609dfb72f36073cd380327d9f716635535a83:

Random syntax error:

    rsg_test.go:839: Crash detected: server panic: statement exec timeout

Query:

        DROP GROUP IF EXISTS PLACEHOLDER , 'string' , OWNER , PLACEHOLDER;

Reproduce

To reproduce, try:

make stressrace TESTS=TestRandomSyntaxGeneration PKG=./pkg/sql/tests TESTTIMEOUT=5m STRESSFLAGS='-timeout 5m' 2>&1

Same failure on other branches

sql/tests: TestRandomSyntaxGeneration failed #89363 sql/tests: TestRandomSyntaxGeneration failed [C-test-failure O-robot T-sql-experience branch-release-22.2.0]
sql/tests: TestRandomSyntaxGeneration failed #89054 sql/tests: TestRandomSyntaxGeneration failed [C-test-failure O-robot T-sql-experience branch-master]
sql/tests: TestRandomSyntaxGeneration failed [DROP OWNED BY timeout] #87572 sql/tests: TestRandomSyntaxGeneration failed [DROP OWNED BY timeout] [C-test-failure O-robot T-sql-schema branch-release-22.2]
sql/tests: TestRandomSyntaxGeneration failed #77893 sql/tests: TestRandomSyntaxGeneration failed [C-test-failure O-robot T-sql-experience branch-release-22.1]
sql/tests: TestRandomSyntaxGeneration failed #65210 sql/tests: TestRandomSyntaxGeneration failed [C-test-failure O-robot branch-release-21.1]

Internal log

mjibson marked as alumn{us/a}; resolving to rafiss instead

/cc @cockroachdb/sql-experience rafiss

This test on roachdash | Improve this report!

cockroach-teamcity added branch-release-21.2 C-test-failure Broken test (automatically or manually discovered). O-robot Originated from a bot. labels Dec 24, 2021

cockroach-teamcity mentioned this issue Jan 5, 2022

sql/tests: TestRandomSyntaxGeneration failed #65210

Closed

RichardJCai mentioned this issue Jan 20, 2022

sql: creating / dropping the same user concurrently can cause a deadlock #75236

Open

cockroach-teamcity mentioned this issue Jan 27, 2022

sql/tests: TestRandomSyntaxGeneration failed [bucket count syntax] #75604

Closed

cockroach-teamcity mentioned this issue Mar 16, 2022

sql/tests: TestRandomSyntaxGeneration failed #77893

Closed

cockroach-teamcity mentioned this issue May 17, 2022

sql/tests: TestRandomSyntaxGeneration failed #81352

Closed

jlinder added sync-me-3 and removed sync-me-3 labels May 24, 2022

cockroach-teamcity mentioned this issue Sep 8, 2022

sql/tests: TestRandomSyntaxGeneration failed [DROP OWNED BY timeout] #87572

Closed

This was referenced Sep 30, 2022

sql/tests: TestRandomSyntaxGeneration failed #89054

Closed

sql/tests: TestRandomSyntaxGeneration failed #89363

Closed

This was referenced Jan 20, 2023

sql/tests: TestRandomSyntaxGeneration failed #95612

Closed

sql/tests: TestRandomSyntaxGeneration failed #95618

Closed

sql/tests: TestRandomSyntaxGeneration failed #95908

Closed

This was referenced Mar 22, 2023

sql/tests: TestRandomSyntaxGeneration failed #99183

Closed

sql/tests: TestRandomSyntaxGeneration failed #99185

Closed

rafiss closed this as completed Apr 6, 2023

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

sql/tests: TestRandomSyntaxGeneration failed #74271

sql/tests: TestRandomSyntaxGeneration failed #74271

cockroach-teamcity commented Dec 24, 2021 •

edited by cockroach-jira-scripts

Loading

cockroach-teamcity commented Dec 28, 2021

cockroach-teamcity commented Dec 31, 2021

cockroach-teamcity commented Jan 8, 2022

cockroach-teamcity commented Jan 10, 2022

RichardJCai commented Jan 18, 2022

cockroach-teamcity commented Jan 19, 2022

RichardJCai commented Jan 20, 2022

ajwerner commented Jan 31, 2022

cockroach-teamcity commented Feb 2, 2022

rafiss commented Feb 2, 2022

cockroach-teamcity commented Feb 4, 2022

cockroach-teamcity commented Feb 5, 2022

cockroach-teamcity commented Feb 10, 2022

cockroach-teamcity commented Feb 24, 2022

cockroach-teamcity commented Mar 2, 2022

cockroach-teamcity commented Mar 15, 2022

cockroach-teamcity commented Apr 22, 2022

cockroach-teamcity commented Apr 26, 2022

cockroach-teamcity commented Jun 3, 2022

cockroach-teamcity commented Nov 4, 2022

sql/tests: TestRandomSyntaxGeneration failed #74271

sql/tests: TestRandomSyntaxGeneration failed #74271

Comments

cockroach-teamcity commented Dec 24, 2021 • edited by cockroach-jira-scripts Loading

cockroach-teamcity commented Dec 28, 2021

cockroach-teamcity commented Dec 31, 2021

cockroach-teamcity commented Jan 8, 2022

cockroach-teamcity commented Jan 10, 2022

RichardJCai commented Jan 18, 2022

cockroach-teamcity commented Jan 19, 2022

RichardJCai commented Jan 20, 2022

ajwerner commented Jan 31, 2022

cockroach-teamcity commented Feb 2, 2022

rafiss commented Feb 2, 2022

cockroach-teamcity commented Feb 4, 2022

cockroach-teamcity commented Feb 5, 2022

cockroach-teamcity commented Feb 10, 2022

cockroach-teamcity commented Feb 24, 2022

cockroach-teamcity commented Mar 2, 2022

cockroach-teamcity commented Mar 15, 2022

cockroach-teamcity commented Apr 22, 2022

cockroach-teamcity commented Apr 26, 2022

cockroach-teamcity commented Jun 3, 2022

cockroach-teamcity commented Nov 4, 2022

cockroach-teamcity commented Dec 24, 2021 •

edited by cockroach-jira-scripts

Loading