Skip to content

ERROR: unexpected NULL detoast result when updating statistics of table with 100M records #535

@michaelkoepf

Description

@michaelkoepf

Hi,

When loading the ClickBench dataset (99,997,497 records) into an OrioleDB table, updating statistics (ANALYZE) fails with the following error.

ERROR: unexpected NULL detoast result

The error does not occur when using a pruned version of the dataset, e.g., when only inserting the first 100K records, updating statistics completes without errors.

System and version details:

  • AWS EC2 c6a.4xlarge
  • Ubuntu 22.04
  • Docker version 27.5.1, build 27.5.1-0ubuntu3~22.04.2
  • OrioleDB beta12-pg17, digest sha256:3304142dbe8de8d5bbaa0e398cca58683ed603add4524c3582debf9c119994f1

Source code to reproduce the issue: ClickHouse/ClickBench#577

--
Best,
Michael

Metadata

Metadata

Assignees

Labels

bugSomething isn't working

Type

No type

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions