1 - Known issues

Known issues release notes for 24.4.x.

Vertica makes every attempt to provide you with an up-to-date list of significant known issues in each release. We will update this list as we resolve issues and as we learn of new issues.

24.4.0-0

Updated 10/29/2024

Issue Key Component Description
VER-95684 Kafka Integration, UDX

In earlier releases, providing a value for the "enable_chunker" parameter had a negative impact on system performance.

This issue is now resolved. 

The "enable_chunker" parameter is set to "True" resulting in improved system performance.

VER-78310 Client Drivers - JDBC

JDBC complex types return NULL arrays as empty arrays. For example, when executing this SQL statement:

=> SELECT ARRAY[null,ARRAY[1,2,3],null,ARRAY[4,5],null] as array;

The array column the server returns will be:

[[],[1,2,3],[],[4,5],[]]

Because of the null values in the string literal, it should return this value:

[null,[1,2,3],null,[4,5],null]

This is a work around to a limitation in Simba.

VER-78074 Procedural Languages, UDX Stored procedures that contain DML queries on tables with key constraints do not return a value.
VER-61069 Execution Engine In very rare circumstances, if a Vertica process crashes during shutdown, the remaining processes might hang indefinitely.

2 - Resolved issues

Resolved issues release notes for 24.4.x.

24.4.0-0

Updated 10/29/2024

Issue Key Component Description
VER-60917 Installation Program When installing Vertica on a remote machine, the install would hang if the /etc/motd file contained a password entry. This issue has been fixed.
VER-82831 Installation Program To prevent Vertica from running out of resources, the root user's max PID value default is changed during the Vertica install to 203816.
VER-84267 Optimizer FKPK Joins over projections with derived expressions would put PK input on the Inner side, even when it was much bigger than FK input, which resulted in worse performance in some scenarios. This issue has been resolved.
VER-88686 Client Drivers - JDBC, Execution Engine Batch update statements which run multiple query plans would keep in memory query plans from each statement in the batch until the entire batch completed.  This memory bloat could cause the cluster to crash due to running out of memory.  This issue has been fixed; now the query plan for each statement in the batch is freed upon completion of that statement.
VER-91515 Security install_vertica will no longer prefer the system openssl library to the one shipped with Vertica on non-fips systems. If you would like to use the system openssl library, delete the openssl libraries located at /opt/vertica/lib.
VER-93368 Optimizer Under certain circumstances, partition statistics could be used in place of full table statistics, leading to suboptimal plans. This issue has been resolved.
VER-94478 AMI

The {{install_vertica}} command fails if Transparent Huge Pages (THP) are incorrectly configured. The function that automatically enables THP has been removed. For on-premises installations, follow the steps here [https://docs.vertica.com/24.2.x/en/setup/set-up-on-premises/before-you-install/manually-configured-os-settings/] to manually configure OS settings and disable THP. If THP is not disabled, {{install_vertica}} will return an error.

For installations where THP needs to remain enabled, add the parameter {{--failure-threshold NONE}} when running {{install_vertica}} to bypass this requirement and complete the installation.

VER-94504 Execution Engine An issue that caused a crash while using WITHIN GROUP () function with listagg has been fixed.
VER-95014 Backup/DR VBR no longer requires compat-openssl11 to be installed on RHEL9 systems.
VER-95097 Machine Learning There is a corner case where an orphan blob may remain in a session when the training of an ML model is cancelled. This orphan blob could cause a crash if there was an attempt to train a model with the same name on the same session. This issue has been resolved.
VER-95199 Optimizer Under certain circumstances, partition statistics could be used in place of full table statistics, leading to suboptimal plans. This issue has been resolved.
VER-95497 Execution Engine Due to a bug in the numeric division code, users would get a wrong result when evaluating the mod operator on some numeric values with large precision. This issue has been resolved.
VER-95651 Kubernetes If a database has a corrupted or outdated catalog (where some nodes do not have the latest catalog), it may not revive correctly in Kubernetes. A workaround is available to recreate nodes with an outdated catalog.
VER-95721 Execution Engine An error in expression analysis for REGEXP_SUBSTR would sometimes lead to a crash when that function was in the join condition. This error has been resolved.
VER-95884 Data Export Vertica previously supported numeric precision up to 38 digits when writing to and reading from the Parquet format. This precision limit has now been increased to 153 digits.
VER-95988 Backup/DR Server-based replication with target namespace used to fail due to namespace name case sensitivity. This issue has been resolved.
VER-96152 EON Previously, in certain cases when a cancel occurred during Vertica uploads to the communal storage, the node would crash. This issue has now been fixed.
VER-96243 Catalog Engine Qualified schema names with namespaces have some restrictions, which led to instances of no results being returned. This issue has been resolved. Note: This issue only occurred with displaying the system table.
VER-96866 Security Clients not sending packets during initialization of TLS connections will no longer cause CPU usage to spike.
VER-96876 Node Management Agent When scaling down a cluster in kubernetes, the nodes fail to delete. This issue has been fixed.
VER-97019 Admin Tools, Installation Program, Installation: Server RPM/Deb The urllib3 version is now upgraded from 1.26.18 to 1.26.19.
VER-97022 Optimizer Between v12 and v24, a previous bug fix made it so that null rows passed hash SIP filters. This led to a performance drop on queries that relied on SIPS to filter out nulls early. This has been resolved; now, SIP filters remove null rows again.
VER-97047 Kubernetes If a customer has a database with multiple local storage locations (e.g. multiple DATA paths) that don't have a common path, they cannot revive the database in K8s. This issue has been resolved by removing this limitation in K8s.

3 - New features guide

4 - Deprecated and removed