Version 4.0.5

Released on 2019/09/19.


Please consult the Upgrade Notes before upgrading from CrateDB 3.x or earlier. Before upgrading to 4.0.5 you should be running a CrateDB cluster that is at least on 3.0.7.

We recommend that you upgrade to the latest 3.3 release before moving to 4.0.5.

If you want to perform a rolling upgrade, your current CrateDB version number must be at least Version 4.0.2. Any upgrade from a version prior to this will require a full restart upgrade.

When restarting, CrateDB will migrate indexes to a newer format. Depending on the amount of data, this may delay node start-up time.


Tables that were created prior CrateDB 3.x will not function with 4.x and must be recreated before moving to 4.x.x.

You can recreate tables using COPY TO and COPY FROM or by inserting the data into a new table.

Before upgrading, you should back up your data.

Table of Contents

See the Version 4.0.0 release notes for a full list of changes in the 4.0 series.


  • Improved the help section of the Admin UI including the Spanish translations.

  • Fixed an issue in the Admin UI to no longer display all columns as being generated columns in the table/column view section.

  • Fixed an issue introduced in CrateDB 4.0 resulting in dysfunctional disk-based allocation thresholds.

  • Fixed an issue resulting in pg_catalog.pg_attribute.attnum and information_schema.columns.ordinal_position being NULL on tables created with CrateDB < 4.0.

  • Fixed an issue resulting in NULL values when the ORDER BY symbol is a child of an ignored object column.

  • Fixed the Tables need to be recreated cluster check to list partitioned tables only once instead of once per partition.

  • Fixed the ssl.resource_poll_interval setting processing and documentation.