sql/tests: SIGSEGV in geos.Snap

[cockroach-teamcity]

sql/tests.TestRandomSyntaxFunctions failed with artifacts on master @ 8765705442d59920da3424d770a76ee50f1eee06:

github.com/cockroachdb/cockroach/pkg/rpc.gatewayRequestRecoveryInterceptor({0x864d150, 0xc008994e40}, {0x75b4820, 0xc0012f4dc0}, 0xc0105d7b80?, 0xc0057b5000)
	pkg/rpc/metrics.go:462 +0x123 fp=0xc00425f5a8 sp=0xc00425f520 pc=0x1ca13a3
google.golang.org/grpc.getChainUnaryHandler.func1.getChainUnaryHandler.1({0x864d150, 0xc008994e40}, {0x75b4820, 0xc0012f4dc0})
	external/org_golang_google_grpc/server.go:1177 +0xa8 fp=0xc00425f610 sp=0xc00425f5a8 pc=0xd47768
github.com/cockroachdb/cockroach/pkg/server.newGRPCServer.NewRequestMetricsInterceptor.func4({0x864d150, 0xc008994e40}, {0x75b4820, 0xc0012f4dc0}, 0xc0105d7b80, 0xc0057b4fc0)
	pkg/rpc/metrics.go:415 +0x2c3 fp=0xc00425f7d8 sp=0xc00425f610 pc=0x598a183
google.golang.org/grpc.getChainUnaryHandler.func1({0x864d150?, 0xc008994e40?}, {0x75b4820?, 0xc0012f4dc0?})
	external/org_golang_google_grpc/server.go:1177 +0x153 fp=0xc00425f850 sp=0xc00425f7d8 pc=0xd47673
github.com/cockroachdb/cockroach/pkg/rpc.NewServerEx.func1.1({0x864d150?, 0xc008994e40?})
	pkg/rpc/context.go:137 +0x36 fp=0xc00425f888 sp=0xc00425f850 pc=0x1c92d96
github.com/cockroachdb/cockroach/pkg/util/stop.(*Stopper).RunTaskWithErr(0xc0124e06c0, {0x864d150, 0xc008994e40}, {0x7743d77, 0x21}, 0xc00425f978)
	pkg/util/stop/stopper.go:349 +0x13c fp=0xc00425f938 sp=0xc00425f888 pc=0x148a5bc
github.com/cockroachdb/cockroach/pkg/rpc.NewServerEx.func1({0x864d150?, 0xc008994e40?}, {0x75b4820?, 0xc0012f4dc0?}, 0xc0105d7b80?, 0xc002a46d68?)
	pkg/rpc/context.go:135 +0x7d fp=0xc00425f9b0 sp=0xc00425f938 pc=0x1c92cdd
google.golang.org/grpc.NewServer.chainUnaryServerInterceptors.chainUnaryInterceptors.func1({0x864d150, 0xc008994e40}, {0x75b4820, 0xc0012f4dc0}, 0xc0105d7b80, 0x70?)
	external/org_golang_google_grpc/server.go:1168 +0x7c fp=0xc00425fa00 sp=0xc00425f9b0 pc=0xd43b3c
github.com/cockroachdb/cockroach/pkg/kv/kvpb._Internal_Batch_Handler({0x75a90c0, 0xc004228a88}, {0x864d150, 0xc008994e40}, 0xc005427030, 0xc005343a40)
	bazel-out/k8-fastbuild/bin/pkg/kv/kvpb/kvpb_go_proto_/github.com/cockroachdb/cockroach/pkg/kv/kvpb/api.pb.go:11716 +0x143 fp=0xc00425fa50 sp=0xc00425fa00 pc=0x129c643
google.golang.org/grpc.(*Server).processUnaryRPC(0xc008ad41e0, {0x86aeb40, 0xc023315040}, 0xc02eae37a0, 0xc0070ef8f0, 0xcba1880, 0x0)
	external/org_golang_google_grpc/server.go:1358 +0xdd3 fp=0xc00425fe30 sp=0xc00425fa50 pc=0xd48593
google.golang.org/grpc.(*Server).handleStream(0xc008ad41e0, {0x86aeb40, 0xc023315040}, 0xc02eae37a0, 0x0)
	external/org_golang_google_grpc/server.go:1735 +0x9cc fp=0xc00425ff50 sp=0xc00425fe30 pc=0xd4d3ec
google.golang.org/grpc.(*Server).serveStreams.func1.1()
	external/org_golang_google_grpc/server.go:970 +0xaf fp=0xc00425ffe0 sp=0xc00425ff50 pc=0xd4610f
runtime.goexit({})
	src/runtime/asm_amd64.s:1700 +0x1 fp=0xc00425ffe8 sp=0xc00425ffe0 pc=0x499ba1
created by google.golang.org/grpc.(*Server).serveStreams.func1 in goroutine 4502224
	external/org_golang_google_grpc/server.go:981 +0x133

rax    0x0
rbx    0x0
rcx    0x0
rdx    0x0
rdi    0x0
rsi    0x0
rbp    0x7f812fc32fa0
rsp    0x7f8132dca180
r8     0x7f817b638f20
r9     0x7f817b638f28
r10    0x239b75410
r11    0xf
r12    0x7f812fc327a0
r13    0xffffffffffffffff
r14    0x0
r15    0xc00d9101c0
rip    0x7f8112db2a1c
rflags 0x10206
cs     0x33
fs     0x0
gs     0x0

Help

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

/cc @cockroachdb/sql-foundations

This test on roachdash | Improve this report!

Jira issue: CRDB-53059

[rafiss]

SIGSEGV: segmentation violation
PC=0x7f8112db2a1c m=5 sigcode=1 addr=0x0
signal arrived during cgo execution

goroutine 4631662 gp=0xc02312cd20 m=5 mp=0xc000101808 [syscall]:
runtime.cgocall(0x6053751, 0xc0124cc818)
	GOROOT/src/runtime/cgocall.go:167 +0x4b fp=0xc0124cc7f0 sp=0xc0124cc7b8 pc=0x48d54b
github.com/cockroachdb/cockroach/pkg/geo/geos._Cfunc_CR_GEOS_Snap(0x7f812c01f000, {0xc024291c40, 0x9}, {0xc024291cc0, 0x9}, 0xbfcce92008f55318, 0xc00d9101c0)
	_cgo_gotypes.go:837 +0x48 fp=0xc0124cc818 sp=0xc0124cc7f0 pc=0x239b0a8
github.com/cockroachdb/cockroach/pkg/geo/geos.Snap.func1(...)
	com_github_cockroachdb_cockroach/pkg/geo/geos/geos.go:1120
github.com/cockroachdb/cockroach/pkg/geo/geos.Snap({0xc024291c40, 0x9, 0x0?}, {0xc024291cc0, 0x9, 0xc0124cca68?}, 0xbfcce92008f55318)
	com_github_cockroachdb_cockroach/pkg/geo/geos/geos.go:1120 +0x159 fp=0xc0124cc8c0 sp=0xc0124cc818 pc=0x23a4219
github.com/cockroachdb/cockroach/pkg/geo/geomfn.Snap({{0x2, {0xc024291c40, 0x9, 0x40}, 0x0, 0x60000002, 0x0}}, {{0x2, {0xc024291cc0, 0x9, ...}, ...}}, ...)
	pkg/geo/geomfn/snap.go:17 +0x97 fp=0xc0124cc968 sp=0xc0124cc8c0 pc=0x23d59b7
github.com/cockroachdb/cockroach/pkg/sql/sem/builtins.init.func634({0xc0123bac60?, 0x864d118?}, 0xc00e8bef00?, {0xc007f851d0, 0x3, 0xd2c0ae0?})
	pkg/sql/sem/builtins/geo_builtins.go:5603 +0x1ba fp=0xc0124cca60 sp=0xc0124cc968 pc=0x28b3d3a
github.com/cockroachdb/cockroach/pkg/sql/sem/eval.(*evaluator).EvalFuncExpr(0xc0123bac60, {0x864d118, 0xc00e8bef00}, 0xc03055cea0)
	pkg/sql/sem/eval/expr.go:504 +0x114 fp=0xc0124ccc98 sp=0xc0124cca60 pc=0x236dff4
github.com/cockroachdb/cockroach/pkg/sql/sem/tree.(*FuncExpr).Eval(...)
	bazel-out/k8-fastbuild/bin/pkg/sql/sem/tree/eval_expr_generated.go:287
github.com/cockroachdb/cockroach/pkg/sql/sem/eval.Expr(...)
	pkg/sql/sem/eval/expr.go:22
github.com/cockroachdb/cockroach/pkg/sql/opt/norm.(*CustomFuncs).FoldFunction(0xc0123bb628, {0xc007f85080, 0x3, 0x30?}, 0xc0124cd1f8)
	pkg/sql/opt/norm/fold_constants_funcs.go:693 +0x428 fp=0xc0124cce60 sp=0xc0124ccc98 pc=0x2d88b08
github.com/cockroachdb/cockroach/pkg/sql/opt/norm.(*Factory).ConstructFunction(0xc0123bb608, {0xc007f85080, 0x3, 0x3}, 0xc0124cd1f8)
	bazel-out/k8-fastbuild/bin/pkg/sql/opt/norm/factory.og.go:21469 +0x145 fp=0xc0124ccef8 sp=0xc0124cce60 pc=0x2e3e4c5
github.com/cockroachdb/cockroach/pkg/sql/opt/optbuilder.(*Builder).buildFunction(0xc00abd28c0, 0xc03055ccf0, 0xc007751c10, 0xc007751d18, 0xc00fa03800, 0x0)

[yuzefovich]

Reproduction:

SELECT st_snap('01010000C0000000000000F87F000000000000F87F000000000000F87F000000000000F87F'::GEOMETRY, '01050000C00700000001020000C006000000FEA64DDAFEA5F54168A3B3BDD018FCC1D52D5C0A562700426D78D4AD3787F84153020747D50AEF41AAC6B786FFC1F0C174241B91113AE0C1E3743115A519D74180072BFB234CF3413444544F16ECCDC19457E8C35AA0F8C128AA5FF177D5F9416AA4436D948CD74180B1D528459FDB41CA3BE9814B67FA418F89BD361712E4C1EC17F54391B7EDC1637A94D2D80AF541991A8D956D2302C290EC5E5DAE27FDC176E40F086B3100C22505DCE10874F441829EF65A77E3F4C18826714661F6FAC101020000C005000000F42AC6D05B19F9C18DF8D8CDCD48C1C1CD899268EB84F5C185A07727DC02F44174E371D7837CC741F48D85F49BF9FDC1AC320D5499E6F0C1DC48A7E6657A02424C87C9D8E81300422FD27CC2495879C1D01BBC423743FD4131AF999FF96CF5C100C10F52A051D2C1149903E9AA33E541AC43F7066D35FDC1E4A86B9A330DFBC1AE2FAF24A713FDC1731BEC18B13CF741482A80D44C83F541C6F035430025DEC101020000C00200000023055D665D32FFC1F81DC4842DA1D94199805F107042EF41A716A2AD6DE6EFC123BB6800AC3CFCC1F3C2C0DA4731D74168426EA35992F44104A44CF38D2702C201020000C0060000005617EDB80CBAE5414EA1196E7D28E441CA38583B0316DA416CDFBF338414D2C175C80955800EF14134A26F7CC1F70142457A61113D1AF2C1A60DD111FE97F041C0021FC33966D741B6CCABBA36D50142E09F602789B7EEC12863CF3ECECBEF4149C96DB45BEB01C21A466451C7EA01425D13E28E06A1EC4181C99CAA0379F4C1AA567E7C8E1EFDC17885F5F7F65CF7418E01A78E82FF00C24E23798AD8E59F418EAE07F5BB7902C2D2B7520427F3F341FFE0A2297FD0E241C211F0D485C1E8C101020000C0020000003633BD7444F201C2B8E1C48DF10DEEC11D4BC6E4002AE5C19B9612967248D14176895BC6CE47F8C1812922E2E495FBC144F19CAE5CD6F94198C716EC465B02C201020000C003000000E5FE91752E99FEC1A75847DBE611FEC18B3FB6F1E924FF411FD3FABF6EAECA41145B6C2C516D0142682845C9B632FEC1E0BBFF397DC5FFC10B314A2CE3CFE8C190134B2A5B71D84146DECEB93F65CBC1FFCC6AA58765FF41C430364D001EF34101020000C002000000FBD5DA249C19F9C1963E2B509F40F4C1F12A86FFD5D9F241401D455C3D49F541C9E7B9CDDC89E6C17C224108A10BFAC1999928F2639DF741565A862988A9FA41'::GEOMETRY, 0.6400437035002648::FLOAT8);
-- PG returns
--                          st_snap                           
--------------------------------------------------------------
-- 0101000080000000000000F87F000000000000F87F000000000000F87F

[yuzefovich]

This is a recent regression with geos bump from 3.11 to 3.12. I'll see whether it reproduces if we bump to 3.13 in #151186.

[cockroach-teamcity]

sql/tests.TestRandomSyntaxFunctions failed with artifacts on master @ 9831be5f895ec7758d43bbec0df76f1e14e78d44:

created by github.com/cockroachdb/cockroach/pkg/util/netutil.(*TCPServer).ServeWith in goroutine 4224398
	pkg/util/netutil/net.go:190 +0x376

goroutine 4859705 gp=0xc0090cbc20 m=nil [sync.Cond.Wait]:
runtime.gopark(0xc00a217690?, 0x566a7a9?, 0x20?, 0x10?, 0xc0054a8800?)
	GOROOT/src/runtime/proc.go:435 +0xce fp=0xc00a217610 sp=0xc00a2175f0 pc=0x490e6e
runtime.goparkunlock(...)
	GOROOT/src/runtime/proc.go:441
sync.runtime_notifyListWait(0xc00fb03410, 0xc)
	GOROOT/src/runtime/sema.go:597 +0x159 fp=0xc00a217660 sp=0xc00a217610 pc=0x492bd9
sync.(*Cond).Wait(0x56610e5?)
	GOROOT/src/sync/cond.go:71 +0x85 fp=0xc00a217698 sp=0xc00a217660 pc=0x4a3ce5
github.com/cockroachdb/cockroach/pkg/sql.(*StmtBuf).CurCmd(0xc019a086f8)
	pkg/sql/conn_io.go:557 +0x9f fp=0xc00a217748 sp=0xc00a217698 pc=0x411d17f
github.com/cockroachdb/cockroach/pkg/sql.(*connExecutor).execCmd(0xc005794008)
	pkg/sql/conn_executor.go:2304 +0xe5 fp=0xc00a217b70 sp=0xc00a217748 pc=0x40dd2a5
github.com/cockroachdb/cockroach/pkg/sql.(*connExecutor).run(0xc005794008, {0x86502f8, 0xc00272a0a0}, 0xfdb6a6?, 0x0?, 0xc0157288f0?)
	pkg/sql/conn_executor.go:2278 +0x1dc fp=0xc00a217c48 sp=0xc00a217b70 pc=0x40dcd7c
github.com/cockroachdb/cockroach/pkg/sql.(*Server).ServeConn(0xc008386820?, {0x86502f8?, 0xc00272a0a0?}, {0xc035ef38c0?}, 0x2?, 0x0?)
	pkg/sql/conn_executor.go:1056 +0xb9 fp=0xc00a217cf8 sp=0xc00a217c48 pc=0x40d7859
github.com/cockroachdb/cockroach/pkg/sql/pgwire.(*conn).processCommands(0xc019a08008, {0x86502f8, 0xc00272a0a0}, {0x0, 0x4, {0x1, {0x7664eb9, 0x3}, {0xc00db530a0, 0xf}, ...}, ...}, ...)
	pkg/sql/pgwire/conn.go:253 +0x4b5 fp=0xc00a217ef8 sp=0xc00a217cf8 pc=0x5664395
github.com/cockroachdb/cockroach/pkg/sql/pgwire.(*Server).serveImpl.func4()
	pkg/sql/pgwire/server.go:1214 +0xec fp=0xc00a217fe0 sp=0xc00a217ef8 pc=0x5679d4c
runtime.goexit({})
	src/runtime/asm_amd64.s:1700 +0x1 fp=0xc00a217fe8 sp=0xc00a217fe0 pc=0x499ba1
created by github.com/cockroachdb/cockroach/pkg/sql/pgwire.(*Server).serveImpl in goroutine 4859632
	pkg/sql/pgwire/server.go:1211 +0x5f2

rax    0x0
rbx    0x0
rcx    0x0
rdx    0x0
rdi    0x0
rsi    0x0
rbp    0x7f50b710b460
rsp    0x7f50babfe180
r8     0x7f5109918db0
r9     0x7f5109918db8
r10    0xd2c1ec0
r11    0x227bc45f0
r12    0x7f50b710b420
r13    0xffffffffffffffff
r14    0x0
r15    0xc0107ecf40
rip    0x7f50a088fa1c
rflags 0x10206
cs     0x33
fs     0x0
gs     0x0

Help

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

This test on roachdash | Improve this report!