Product updates

Get the latest updates on features, fixes and improvements.

689 results

  • Jul 26, 2024

    Improved

    Aiven for Apache Kafka® Connect

    Aiven JDBC connectors updated to version 6.10.0

    Aiven’s JDBC source and sink connectors for Apache Kafka® have been upgraded to version 6.10.0. This version introduces several significant improvements and bug fixes. The most notable changes are:

    Enhancements:

    • Exactly once delivery support (KIP-618): Ensures messages are delivered exactly once.
    • Tombstone handling: Enables row delete functionality, allowing the connector to handle tombstone messages effectively.
    • Primary key (PK) mode validation: Adds validation for PK mode against PK fields to ensure data integrity and correctness.

    Bug fixes:

    • Source task shutdown correction: Improved shutdown logic for source tasks to avoid memory leaks.

    For more information, see release notes and documentation.

  • Jul 24, 2024

    TimescaleDB extension 2.15.3 for Aiven for PostgreSQL® released

    TimescaleDB extension version 2.15.3 is now available for Aiven for PostgreSQL®. It introduces new bug fixes on top of release 2.15.2. Upgrade to 2.15.3 at your earliest convenience to make sure you use the most robust and secure version available.

    Refer to the TimescaleDB release notes for 2.15.3 to check all the changes introduced in this release, including deprecation announcements and operational instructions.

    Bug fixes

    • #7061: Fix the handling of multiple unique indexes in a compressed INSERT.
    • #7080: Fix the corresponding equivalence member not found error.
    • #7088: Fix the leaks in the DML functions.
    • #7035: Fix the error when acquiring a tuple lock on the OSM chunks on the replica.
    • #7091: Fix the ORDER BY/GROUP BY expression not found in targetlist error on PG16.
  • Jul 22, 2024

    New

    Aiven Console

    User provisioning with Okta

    Aiven now supports user provisioning from Okta using SCIM, streamlining user management and enhancing security. SCIM lets you sync users and groups between Okta and the Aiven platform. This centralization of user management can reduce errors, save time, and improve compliance.

    To get started, set up Okta as an identity provider for your organization and configure SCIM user provisioning.

  • Jul 22, 2024

    Standalone SQL query optimizer

    The SQL query optimizer is now available from the Tools menu. Use it to get AI-powered optimization suggestions for PostgreSQL and MySQL.

  • Jul 18, 2024

    TimescaleDB extension 2.15.2 for Aiven for PostgreSQL® released

    TimescaleDB extension version 2.15.2 is now available for Aiven for PostgreSQL®. It introduces new features, performance improvements, and bug fixes on top of release 2.14.2. Upgrade to 2.15.2 at your earliest convenience to make sure you use the most robust and secure version available.

    Refer to the TimescaleDB release notes for 2.15.2 to check all the changes introduced in this release, including deprecation announcements and operational instructions.

    Key new features

    • Continuous Aggregate now supports time_bucket with origin and/or offset.
    • For hypertable compression:
      • Recommend optimized defaults for segment by and order by when configuring compression through analysis of table configuration and statistics.
      • Add planner support to check more kinds of WHERE conditions before decompression.
        This reduces the number of rows that have to be decompressed.
      • You can now use minmax sparse indexes when you compress columns with btree indexes.
      • Vectorize filters in the WHERE clause that contain text equality operators and LIKE expressions.

    More new features

    • #6382 Support for time_bucket with origin and offset in CAggs
    • #6696 Improve the defaults for compression segment_by and order_by
    • #6705 Add sparse minmax indexes for compressed columns that have uncompressed btree indexes
    • #6754 Allow DROP CONSTRAINT on compressed hypertables
    • #6767 Add metadata table _timestaledb_internal.bgw_job_stat_history for tracking job execution history
    • #6798 Prevent the usage of the deprecated time_bucket_ng in the CAgg definition
    • #6810 Add telemetry for access methods
    • #6811 Remove the no longer relevant timescaledb.allow_install_without_preload GUC
    • #6837 Add migration path for CAggs using time_bucket_ng
    • #6865 Update the watermark when truncating a CAgg

    Deprecation announcements

    Bug fixes

    • #6975 Fix sort pushdown for partially compressed chunks.
    • #6976 Fix removal of metadata function and update script.
    • #6978 Fix segfault in compress_chunk with a primary space partition.
    • #6993 Disallow hash partitioning on primary column.
    • #6617 Fix error in show_chunks
    • #6621 Remove metadata when dropping chunks
    • #6677 Fix snapshot usage in CAgg invalidation scanner
    • #6698 Define meaning of 0 retries for jobs as no retries
    • #6717 Fix handling of compressed tables with primary or unique index in COPY path
    • #6726 Fix constify cagg_watermark using window function when querying a CAgg
    • #6729 Fix NULL start value handling in CAgg refresh
    • #6732 Fix CAgg migration with custom timezone / date format settings
    • #6752 Remove custom autovacuum setting from compressed chunks
    • #6770 Fix plantime chunk exclusion for OSM chunk
    • #6789 Fix deletes with subqueries and compression
    • #6796 Fix a crash involving a view on a hypertable
    • #6797 Fix foreign key constraint handling on compressed hypertables
    • #6816 Fix handling of chunks with no constraints
    • #6820 Fix a crash when the ts_hypertable_insert_blocker was called directly
    • #6849 Use non-orderby compressed metadata in compressed DML
    • #6867 Clean up compression settings when deleting compressed CAgg
    • #6869 Fix compressed DML with constraints of form value OP column
    • #6870 Fix bool expression pushdown for queries on compressed chunks
  • Jul 18, 2024

    Follower fetching in Aiven for Apache Kafka®

    Aiven for Apache Kafka now supports follower fetching. Consumers can fetch data from the nearest replica instead of the leader, optimizing data fetching and improving performance.
    For details, see the Follower fetching documentation.

  • Jul 12, 2024

    New

    Aiven for ClickHouse®

    SQL UDFs are now supported in Aiven for ClickHouse®

    Aiven for ClickHouse allows you to create and use SQL user defined functions (UDFs) to speed up your queries and optimize your application performance. SQL UDFs are automatically replicated to all nodes in the cluster and contained in backups. UDF types other than SQL UDFs, such as executable UDFs, are not supported in Aiven for ClickHouse.

    To learn how to create and use SQL UDFs in Aiven for ClickHouse, see the documentation.

  • Jul 8, 2024

    Aiven for Apache Kafka® version 3.6.2

    Aiven for Apache Kafka® has been updated to version 3.6.2, ensuring a smoother upgrade process. With this update, you no longer need to disable transaction.partition.verification.enable before upgrading. If you are on a version earlier than 3.6.0, upgrade directly to 3.6.2.

    For assistance, contact the Aiven support team.

  • Jul 5, 2024

    Karapace has been upgraded to version 3.15.0

    This version includes new features and bug fixes, enhancing overall functionality and performance. Key changes in this release include:

    Features:

    • Prometheus metrics and instrumentation: Added support for Prometheus metrics and instrumentation, enhancing observability and monitoring.

    Bug fixes:

    • ClientError handling: Implemented handling for aiohttp.ClientError with a 503 response status, improving error handling.
    • TimeoutError handling: Added handling for asyncio.TimeoutError, to ensure smoother operation under timeout conditions.
    • Invalid version handling: Fixed the issue where an invalid version error was raised for schema version 0. Schema versions greater than or equal to 0 are allowed, enhancing compatibility.

    For a complete list of fixes and detailed information, see the Karapace release notes.