Version 5.4.2

Released on 2023-08-11.


If you are upgrading a cluster, you must be running CrateDB 4.0.2 or higher before you upgrade to 5.4.2.

We recommend that you upgrade to the latest 5.3 release before moving to 5.4.2.

A rolling upgrade from 5.3.x to 5.4.2 is supported. Before upgrading, you should back up your data.


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

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

Table of Contents

See the Version 5.4.0 release notes for a full list of changes in the 5.4 series.

Known Issues

  • Version 5.0.0 introduced a regression which can cause some JOIN queries to return no results when the query optimizer re-orders the joined tables. As a workaround, users should apply the following session settings before running such queries to prevent the query optimizer from re-ordering them and therefore produce the correct results:

    On CrateDB >= 5.4.0:

    SET optimizer_reorder_hash_join = false
    SET optimizer_reorder_nested_loop_join = false

    On CrateDB < 5.4.0 (this will disable the hash-join algorithm which may lead to poor performance):

    SET enable_hashjoin = false


  • Fixed an issue that led to serialization errors on a rolling upgrade to 5.4.1 if the cluster contained user defined views.