roachtest/sqlsmith: no bytes in account to release with a default aggregate function

[cockroach-teamcity]

roachtest.sqlsmith/setup=rand-tables/setting=no-ddl failed with artifacts on master @ 3b16435371a43d603d193a1e2b480a23fba3f07a:

test artifacts and logs in: /artifacts/sqlsmith/setup=rand-tables/setting=no-ddl/run_1
	sqlsmith.go:305,sqlsmith.go:327,test_runner.go:897: ping node 1: dial tcp 34.75.78.194:26257: connect: connection refused
		HINT: node likely crashed, check logs in artifacts > logs/1.unredacted
		previous sql:
		INSERT
		INTO
			defaultdb.public.table2 AS tab_53842 (col2_0, col2_1, col2_2, col2_3, col2_4, col2_5, col2_6, col2_8, col2_9)
		SELECT
			3218126443:::OID AS col_110633,
			covar_samp(0.005654874555729494:::FLOAT8::INT8, (-0.735878121616462):::FLOAT8::DECIMAL)::FLOAT8 AS col_110634,
			(
				SELECT
					B'0011000000010101001011001' AS col_110635
				FROM
					defaultdb.public.table1@[0] AS tab_53844
				ORDER BY
					tab_53844.col1_12 ASC
				LIMIT
					1:::INT8
			)
				AS col_110636,
			'2003-01-14 07:45:34.000217+00:00':::TIMESTAMPTZ AS col_110637,
			corr(1.404890010825183:::FLOAT8::DECIMAL, NULL::INT8)::FLOAT8 AS col_110638,
			B'100101011100010110101001010101000' AS col_110639,
			bool_or(false::BOOL)::BOOL AS col_110640,
			NULL AS col_110641,
			e'\x1e\x06\x1e\x1f287':::STRING:::NAME AS col_110642
		FROM
			defaultdb.public.table5@[0] AS tab_53843
		GROUP BY
			tab_53843.col5_1
		LIMIT
			50:::INT8;ping node 1: dial tcp 34.75.78.194:26257: connect: connection refused
		HINT: node likely crashed, check logs in artifacts > logs/1.unredacted

Parameters: ROACHTEST_cloud=gce , ROACHTEST_cpu=4 , ROACHTEST_ssd=0

Help

See: roachtest README

See: How To Investigate (internal)

/cc @cockroachdb/sql-queries

This test on roachdash | Improve this report!

Jira issue: CRDB-19098

[yuzefovich]

* ERROR: a SQL panic has occurred while executing the following statement:
* INSERT INTO defaultdb.public.table2 AS tab_53842(col2_0, col2_1, col2_2, col2_3, col2_4, col2_5, col2_6, col2_8, col2_9) SELECT 3218126443:::OID AS col_110633, covar_samp(0.005654874555729494::INT8, -0.735878121616462::DECIMAL)::FLOAT8 AS col_110634, (SELECT B'0011000000010101001011001' AS col_110635 FROM defaultdb.public.table1@[0] AS tab_53844 ORDER BY tab_53844.col1_12 ASC LIMIT 1:::INT8) AS col_110636, '2003-01-14 07:45:34.000217+00:00':::TIMESTAMPTZ AS col_110637, corr(1.404890010825183::DECIMAL, NULL::INT8)::FLOAT8 AS col_110638, B'100101011100010110101001010101000' AS col_110639, bool_or(false)::BOOL AS col_110640, NULL AS col_110641, e'\x1e\x06\x1e\x1f287':::STRING:::NAME AS col_110642 FROM defaultdb.public.table5@[0] AS tab_53843 GROUP BY tab_53843.col5_1 LIMIT 50:::INT8
*
*
* ERROR: a panic has occurred!
* flow: no bytes in account to release, current 0, free 1376
* (1) attached stack trace
*   -- stack trace:
*   | github.com/cockroachdb/cockroach/pkg/sql.(*Server).ServeConn.func1
*   | 	github.com/cockroachdb/cockroach/pkg/sql/conn_executor.go:822
*   | runtime.gopanic
*   | 	GOROOT/src/runtime/panic.go:838
*   | github.com/cockroachdb/cockroach/pkg/sql/colexecerror.CatchVectorizedRuntimeError.func1
*   | 	github.com/cockroachdb/cockroach/pkg/sql/colexecerror/error.go:58
*   | runtime.gopanic
*   | 	GOROOT/src/runtime/panic.go:838
*   | github.com/cockroachdb/cockroach/pkg/util/log/logcrash.ReportOrPanic
*   | 	github.com/cockroachdb/cockroach/pkg/util/log/logcrash/crash_reporting.go:378
*   | github.com/cockroachdb/cockroach/pkg/util/mon.(*BoundAccount).Shrink
*   | 	github.com/cockroachdb/cockroach/pkg/util/mon/bytes_usage.go:730
*   | github.com/cockroachdb/cockroach/pkg/sql/sem/builtins.(*singleDatumAggregateBase).close
*   | 	github.com/cockroachdb/cockroach/pkg/sql/sem/builtins/aggregate_builtins.go:1350
*   | github.com/cockroachdb/cockroach/pkg/sql/sem/builtins.(*regressionAccumulatorDecimalBase).Close
*   | 	github.com/cockroachdb/cockroach/pkg/sql/sem/builtins/aggregate_builtins.go:2052
*   | github.com/cockroachdb/cockroach/pkg/sql/colexec/colexecagg.(*defaultOrderedAggAlloc).Close
*   | 	github.com/cockroachdb/cockroach/bazel-out/k8-opt/bin/pkg/sql/colexec/colexecagg/ordered_default_agg.eg.go:243
*   | github.com/cockroachdb/cockroach/pkg/sql/colexecop.Closers.Close
*   | 	github.com/cockroachdb/cockroach/pkg/sql/colexecop/operator.go:190
*   | github.com/cockroachdb/cockroach/pkg/sql/colexec.(*orderedAggregator).Close
*   | 	github.com/cockroachdb/cockroach/pkg/sql/colexec/ordered_aggregator.go:402
*   | github.com/cockroachdb/cockroach/pkg/sql/colexecop.Closers.CloseAndLogOnErr.func1
...

Seems possible #86962 is to blame.