sql/tests: TestRandomSyntaxFunctions failed #66514
Description
sql/tests.TestRandomSyntaxFunctions failed with artifacts on release-21.1 @ af2c90b391faa0e0256b96269a0e3c2e29a0ca7b:
/usr/local/go/src/crypto/tls/conn.go:801 +0xf3
crypto/tls.(*Conn).readRecordOrCCS(0xc002728e00, 0x0, 0x0, 0x86b631)
/usr/local/go/src/crypto/tls/conn.go:608 +0x115
crypto/tls.(*Conn).readRecord(...)
/usr/local/go/src/crypto/tls/conn.go:576
crypto/tls.(*Conn).Read(0xc002728e00, 0xc009ab8000, 0x1000, 0x1000, 0x0, 0x0, 0x0)
/usr/local/go/src/crypto/tls/conn.go:1252 +0x15f
github.com/cockroachdb/cockroach/pkg/sql/pgwire.(*readTimeoutConn).Read(0xc0377e7b60, 0xc009ab8000, 0x1000, 0x1000, 0x0, 0x0, 0x0)
/go/src/github.com/cockroachdb/cockroach/pkg/sql/pgwire/conn.go:1680 +0x129
bufio.(*Reader).fill(0xc009073b48)
/usr/local/go/src/bufio/bufio.go:101 +0x105
bufio.(*Reader).ReadByte(0xc009073b48, 0x2282cae2, 0xed85b8377, 0x0)
/usr/local/go/src/bufio/bufio.go:253 +0x39
github.com/cockroachdb/cockroach/pkg/sql/pgwire/pgwirebase.(*ReadBuffer).ReadTypedMsg(0xc009074308, 0x5b57120, 0xc009073b48, 0x5b4cc20, 0x8041068, 0x0, 0x0)
/go/src/github.com/cockroachdb/cockroach/pkg/sql/pgwire/pgwirebase/encoding.go:203 +0x35
github.com/cockroachdb/cockroach/pkg/sql/pgwire.(*conn).serveImpl.func4(0xc009073b00, 0xc0091b46e0, 0xc001720000, 0xc01d8057cd, 0x5b69760, 0xc015f77300, 0xc01d805830, 0xc01d8057cc, 0xc02fd1e100, 0x0, ...)
/go/src/github.com/cockroachdb/cockroach/pkg/sql/pgwire/conn.go:329 +0x71
github.com/cockroachdb/cockroach/pkg/sql/pgwire.(*conn).serveImpl(0xc009073b00, 0x5b9e120, 0xc0161b5110, 0xc0091b46d0, 0xc001720000, 0x5400, 0x15000, 0xc0246ff900, 0x0, 0x4, ...)
/go/src/github.com/cockroachdb/cockroach/pkg/sql/pgwire/conn.go:460 +0x565
github.com/cockroachdb/cockroach/pkg/sql/pgwire.(*Server).serveConn(0xc001a02500, 0x5b9e120, 0xc0161b5110, 0x5c02be0, 0xc002728e00, 0xc009ab4044, 0x4, 0xc0161b50e0, 0x5b4a3e0, 0xc01df3ac30, ...)
/go/src/github.com/cockroachdb/cockroach/pkg/sql/pgwire/conn.go:153 +0x1b8
github.com/cockroachdb/cockroach/pkg/sql/pgwire.(*Server).ServeConn(0xc001a02500, 0x5b9e120, 0xc0161b5110, 0x5c06ae0, 0xc0216ba0e0, 0x5b9e101, 0x0, 0x0)
/go/src/github.com/cockroachdb/cockroach/pkg/sql/pgwire/server.go:674 +0xdd8
github.com/cockroachdb/cockroach/pkg/server.(*SQLServer).startServeSQL.func1.1(0x5c06ae0, 0xc0216ba0e0)
/go/src/github.com/cockroachdb/cockroach/pkg/server/server.go:2096 +0xf7
github.com/cockroachdb/cockroach/pkg/util/netutil.(*Server).ServeWith.func1(0xc006a08200, 0x5b9e120, 0xc00b9345d0, 0xc007d7ce48, 0x5c06ae0, 0xc0216ba0e0, 0xc008a52f30)
/go/src/github.com/cockroachdb/cockroach/pkg/util/netutil/net.go:156 +0xaf
created by github.com/cockroachdb/cockroach/pkg/util/netutil.(*Server).ServeWith
/go/src/github.com/cockroachdb/cockroach/pkg/util/netutil/net.go:153 +0x24a
goroutine 3086091 [select]:
google.golang.org/grpc/internal/transport.(*controlBuffer).get(0xc0181648c0, 0x1, 0x0, 0x0, 0x0, 0x0)
/go/src/github.com/cockroachdb/cockroach/vendor/google.golang.org/grpc/internal/transport/controlbuf.go:395 +0x125
google.golang.org/grpc/internal/transport.(*loopyWriter).run(0xc0139bac00, 0x0, 0x0)
/go/src/github.com/cockroachdb/cockroach/vendor/google.golang.org/grpc/internal/transport/controlbuf.go:513 +0x1d3
google.golang.org/grpc/internal/transport.newHTTP2Client.func3(0xc004c63180)
/go/src/github.com/cockroachdb/cockroach/vendor/google.golang.org/grpc/internal/transport/http2_client.go:346 +0x7b
created by google.golang.org/grpc/internal/transport.newHTTP2Client
/go/src/github.com/cockroachdb/cockroach/vendor/google.golang.org/grpc/internal/transport/http2_client.go:344 +0xefc
rsg_test.go:191: SELECT 1 executed successfully: probably a slow statement
rsg_test.go:760: Crash detected:
SELECT st_buffer('010500000008000000010200000002000000E0008D0506ADED41A07A766D887EB2413CE9A543AA2802C238069D73295BF041010200000002000000EC62245F5089F6418EE6E6AB347A0242F0C5931F3AC4EA41224BAA50E0E7F54101020000000200000040ABD4851D1D0242D4C266CB24F0F3C1F0024A97872DD8C178F4CD6755F7F541010200000002000000F4731B03503E0142DE7E74F6260F0142B422D2D90F8002C284E54C434311F341010200000006000000188E8998AA57E9413839557910BAD0C1C0F707A0D46BA241A0644AE7EC5ACD41B037DFBF7704CCC1F8A3F94B60F6D54120F5F677E9B3EB41F8C7D90076B5F74166F9ED3F9B50E3C182598DA38793F841E645DA9BA1C3FFC1B03ABDB7D0A2F94101020000000200000098F233D6A04DDAC16C5BC3973AA7F341A4537180A0FF01C218E692C97DB5FE41010200000002000000D40E8B36E810E441266651D729A0F7C19C828B1F8119EE412EF53E86243DF7C1010200000002000000686DCBAAAA4FE3419F326A862542FEC12089896EE713D54110DD622C0675F7C1':::GEOMETRY, 3.4028234663852886e+38:::FLOAT8, 32767:::INT8)
Stack trace:
timeout: "SELECT st_buffer('010500000008000000010200000002000000E0008D0506ADED41A07A766D887EB2413CE9A543AA2802C238069D73295BF041010200000002000000EC62245F5089F6418EE6E6AB347A0242F0C5931F3AC4EA41224BAA50E0E7F54101020000000200000040ABD4851D1D0242D4C266CB24F0F3C1F0024A97872DD8C178F4CD6755F7F541010200000002000000F4731B03503E0142DE7E74F6260F0142B422D2D90F8002C284E54C434311F341010200000006000000188E8998AA57E9413839557910BAD0C1C0F707A0D46BA241A0644AE7EC5ACD41B037DFBF7704CCC1F8A3F94B60F6D54120F5F677E9B3EB41F8C7D90076B5F74166F9ED3F9B50E3C182598DA38793F841E645DA9BA1C3FFC1B03ABDB7D0A2F94101020000000200000098F233D6A04DDAC16C5BC3973AA7F341A4537180A0FF01C218E692C97DB5FE41010200000002000000D40E8B36E810E441266651D729A0F7C19C828B1F8119EE412EF53E86243DF7C1010200000002000000686DCBAAAA4FE3419F326A862542FEC12089896EE713D54110DD622C0675F7C1':::GEOMETRY, 3.4028234663852886e+38:::FLOAT8, 32767:::INT8) ". currently executing: map[SELECT st_buffer('010500000008000000010200000002000000E0008D0506ADED41A07A766D887EB2413CE9A543AA2802C238069D73295BF041010200000002000000EC62245F5089F6418EE6E6AB347A0242F0C5931F3AC4EA41224BAA50E0E7F54101020000000200000040ABD4851D1D0242D4C266CB24F0F3C1F0024A97872DD8C178F4CD6755F7F541010200000002000000F4731B03503E0142DE7E74F6260F0142B422D2D90F8002C284E54C434311F341010200000006000000188E8998AA57E9413839557910BAD0C1C0F707A0D46BA241A0644AE7EC5ACD41B037DFBF7704CCC1F8A3F94B60F6D54120F5F677E9B3EB41F8C7D90076B5F74166F9ED3F9B50E3C182598DA38793F841E645DA9BA1C3FFC1B03ABDB7D0A2F94101020000000200000098F233D6A04DDAC16C5BC3973AA7F341A4537180A0FF01C218E692C97DB5FE41010200000002000000D40E8B36E810E441266651D729A0F7C19C828B1F8119EE412EF53E86243DF7C1010200000002000000686DCBAAAA4FE3419F326A862542FEC12089896EE713D54110DD622C0675F7C1':::GEOMETRY, 3.4028234663852886e+38:::FLOAT8, 32767:::INT8) :1]
rsg_test.go:769: 1356454 executions, 765077 successful
rsg_test.go:349: -- test log scope end --
test logs left over in: /go/src/github.com/cockroachdb/cockroach/artifacts/logTestRandomSyntaxFunctions783033217
--- FAIL: TestRandomSyntaxFunctions (320.91s)
Reproduce
To reproduce, try:
make stressrace TESTS=TestRandomSyntaxFunctions PKG=./pkg/sql/tests TESTTIMEOUT=5m STRESSFLAGS='-timeout 5m' 2>&1Same failure on other branches
- sql/tests: TestRandomSyntaxFunctions failed #66305 sql/tests: TestRandomSyntaxFunctions failed [C-test-failure O-robot branch-master]
- sql/tests: TestRandomSyntaxFunctions failed #63943 sql/tests: TestRandomSyntaxFunctions failed [C-test-failure O-robot branch-release-20.2]
Internal log
mjibson marked as alumn{us/a}; resolving to rafiss instead
/cc @rafiss
This test on roachdash | Improve this report!
Jira issue: CRDB-8072