sql: ANALYZE causes flow:memory budget exceeded error

[mgartner]

Running ANALYZE on large tables can sometimes cause errors like: flow: memory budget exceeded: 10240 bytes requested, 0 currently allocated, 0 bytes in budget.

Full stack trace:

I210723 17:26:35.786147 192731269 jobs/registry.go:1106 ⋮ [n8] CREATE STATS job 678266620850536456: stepping through state reverting with error: ‹flow›: memory budget exceeded: 10240 bytes requested, 0 currently allocated, 0 bytes in budget
(1) attached stack trace
  -- stack trace:
  | github.com/cockroachdb/cockroach/pkg/util/mon.(*BytesMonitor).increaseBudget
  | 	/go/src/github.com/cockroachdb/cockroach/pkg/util/mon/bytes_usage.go:682
  | [...repeated from below...]
Wraps: (2) ‹flow›
Wraps: (3) candidate pg code: 53200
Wraps: (4) attached stack trace
  -- stack trace:
  | github.com/cockroachdb/cockroach/pkg/util/mon.memoryResource.NewBudgetExceededError
  | 	/go/src/github.com/cockroachdb/cockroach/pkg/util/mon/resource.go:37
  | github.com/cockroachdb/cockroach/pkg/util/mon.(*BytesMonitor).increaseBudget
  | 	/go/src/github.com/cockroachdb/cockroach/pkg/util/mon/bytes_usage.go:682
  | github.com/cockroachdb/cockroach/pkg/util/mon.(*BytesMonitor).reserveBytes
  | 	/go/src/github.com/cockroachdb/cockroach/pkg/util/mon/bytes_usage.go:615
  | github.com/cockroachdb/cockroach/pkg/util/mon.(*BoundAccount).Grow
  | 	/go/src/github.com/cockroachdb/cockroach/pkg/util/mon/bytes_usage.go:570
  | github.com/cockroachdb/cockroach/pkg/util/mon.(*BytesMonitor).increaseBudget
  | 	/go/src/github.com/cockroachdb/cockroach/pkg/util/mon/bytes_usage.go:690
  | github.com/cockroachdb/cockroach/pkg/util/mon.(*BytesMonitor).reserveBytes
  | 	/go/src/github.com/cockroachdb/cockroach/pkg/util/mon/bytes_usage.go:615
  | github.com/cockroachdb/cockroach/pkg/util/mon.(*BoundAccount).Grow
  | 	/go/src/github.com/cockroachdb/cockroach/pkg/util/mon/bytes_usage.go:570
  | github.com/cockroachdb/cockroach/pkg/util/mon.(*BytesMonitor).increaseBudget
  | 	/go/src/github.com/cockroachdb/cockroach/pkg/util/mon/bytes_usage.go:690
  | github.com/cockroachdb/cockroach/pkg/util/mon.(*BytesMonitor).reserveBytes
  | 	/go/src/github.com/cockroachdb/cockroach/pkg/util/mon/bytes_usage.go:615
  | github.com/cockroachdb/cockroach/pkg/util/mon.(*BoundAccount).Grow
  | 	/go/src/github.com/cockroachdb/cockroach/pkg/util/mon/bytes_usage.go:570
  | github.com/cockroachdb/cockroach/pkg/util/mon.(*BoundAccount).Resize
  | 	/go/src/github.com/cockroachdb/cockroach/pkg/util/mon/bytes_usage.go:550
  | github.com/cockroachdb/cockroach/pkg/util/mon.(*BoundAccount).ResizeTo
  | 	/go/src/github.com/cockroachdb/cockroach/pkg/util/mon/bytes_usage.go:563
  | github.com/cockroachdb/cockroach/pkg/sql/row.(*txnKVFetcher).fetch
  | 	/go/src/github.com/cockroachdb/cockroach/pkg/sql/row/kv_batch_fetcher.go:345
  | github.com/cockroachdb/cockroach/pkg/sql/row.(*txnKVFetcher).nextBatch
  | 	/go/src/github.com/cockroachdb/cockroach/pkg/sql/row/kv_batch_fetcher.go:454
  | github.com/cockroachdb/cockroach/pkg/sql/row.(*KVFetcher).NextKV
  | 	/go/src/github.com/cockroachdb/cockroach/pkg/sql/row/kv_fetcher.go:118
  | github.com/cockroachdb/cockroach/pkg/sql/row.(*Fetcher).NextKey
  | 	/go/src/github.com/cockroachdb/cockroach/pkg/sql/row/fetcher.go:671
  | github.com/cockroachdb/cockroach/pkg/sql/row.(*Fetcher).StartScanFrom
  | 	/go/src/github.com/cockroachdb/cockroach/pkg/sql/row/fetcher.go:661
  | github.com/cockroachdb/cockroach/pkg/sql/row.(*Fetcher).StartScan
  | 	/go/src/github.com/cockroachdb/cockroach/pkg/sql/row/fetcher.go:553
  | github.com/cockroachdb/cockroach/pkg/sql/rowexec.(*tableReader).Start
  | 	/go/src/github.com/cockroachdb/cockroach/pkg/sql/rowexec/tablereader.go:191
  | github.com/cockroachdb/cockroach/pkg/sql/rowexec.(*samplerProcessor).Run
  | 	/go/src/github.com/cockroachdb/cockroach/pkg/sql/rowexec/sampler.go:221
  | github.com/cockroachdb/cockroach/pkg/sql/flowinfra.(*FlowBase).startInternal.func1
  | 	/go/src/github.com/cockroachdb/cockroach/pkg/sql/flowinfra/flow.go:340
  | runtime.goexit
  | 	/usr/local/go/src/runtime/asm_amd64.s:1357
Wraps: (5) memory budget exceeded: 10240 bytes requested, 0 currently allocated, 0 bytes in budget

Related to #68590

Work-around

Creating statistics with throttling and at a time in the past with AS OF SYSTEM TIME should not produce the error:

CREATE STATISTICS vehicle_stats_1 FROM vehicles WITH OPTIONS THROTTLING 0.9 AS OF SYSTEM TIME '-30s';

gz#9224