This is the multi-page printable view of this section. Click here to print.
List of unresolved issues for this Vertica release version.
List of resolved bugs and fixes for all hotfixes in this Vertica release version.
Describes the new features introduced in this Vertica release, and provides references to detailed information in the documentation set.
Details all deprecated and removed functionality for this Vertica release version.
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.
Updated 04/01/2025
| Issue Key | Component | Description |
|---|---|---|
| VER-97978 | Installation Program | When upgrading from release 24.1.0-6 to 24.3.0-4, Vertica doesn't remove the libssl* and libcrypto* files from /opt/vertica/lib. |
| VER-93373 | Client Drivers - JDBC | The JDBC driver returns the octal values when retrieving the ARRAY (VARBINARY) data. |
| VER-78310 | Client Drivers - JDBC |
JDBC complex types return NULL arrays as empty arrays. For example, when executing this SQL statement: The array column the server returns will be: Because of the null values in the string literal, it should return this value: 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. |
Updated 07/03/2025
| Issue Key | Application Module | Description |
|---|---|---|
| 4860219 | UI - Management Console | An issue where N2 series machines were not visible in the MC provisioning tool for GCP's us-east4-c region, despite being available in the GCP console and documented as supported, has been resolved. Users can now provision N2 series machines via MC in the specified region. |
Updated 06/14/2025
| Issue Key | Application Module | Description |
|---|---|---|
| 4811711 | Data load / COPY | In specific scenarios involving large JSON files with escape characters in string fields, the parsed string value could be missing a few characters. This issue has been resolved. |
| 4815847 | Client Drivers - VSQL | From Vertica 9.3, file names with special characters are in the UTF-8 format. If there are issues loading files with special characters in their names, ensure that the encoding, code page, and locale settings are configured to support UTF-8. |
Updated 05/22/2025
| Issue Key | Application Module | Description |
|---|---|---|
| 4534858 | Catalog Engine, Tuple Mover | A performance degradation that occurred after upgrading from 12.0.4 to 24.3.x and 24.4.0-0 has been resolved. |
| 4535429 | License | Table error_messages used to frequently contain warning message entries with a description similar to: "Skipping node information due to: Unknown node_id". This message did not indicate a real problem and thus has been removed. |
| 4634967 | Kafka Integration | There was a keystone configuration issue where the Kafka scheduler could not be created on Vertica 25.1 systems, regardless of whether they were running in FIPS mode or not. This issue has been resolved. |
| 4753286 | Third Party Tools Integration | Issues identified in the node_management_agent and vcluster components of Vertica have been resolved. |
| 4753290 | Admin Tools |
The following security vulnerabilities in the Python packages bundled with Vertica 25.2.0-1 have been resolved:
|
| 4771895, 4771898, 4772161 | UI - Management Console, Security | Security vulnerabilities within a component library using the Spring framework have been remedied. |
Updated 04/11/2025
| Issue Key | Application Module | Description |
|---|---|---|
| 4336550 | Complex Types | An issue was fixed, where Vertica was unable to load Parquet files with two-level encoded arrays, resulting in the error "Source has unsupported ARRAY type at X." This enhancement enables Vertica to properly process Parquet files with this array structure, improving compatibility with external data sources. |
| 4338772 | Scrutinize | An issue existed where Scrutinize wasn't collecting OS release information across various Linux distributions, including Debian, Ubuntu, Amazon Linux and SUSE Linux Enterprise. This issue has been resolved. |
| 4344794 | UDX | Creating user-defined extensions (UDX) in Python with the DEPENDS clause when the dependent libraries are present in Azure blob storage or Google cloud storage fails. This issue is now resolved. The value of maxNest is increased to 15 from a default value of 2. |
| 4346275 | Optimizer | An issue was discovered where, under some conditions, queries to tables with partitions that include attributes in non-table order could error on statistic lookup. This issue has been resolved. |
| 4346342 | License | An issue was causing inaccurate database size estimations due to cache invalidation issues after node subscriptions changed (node restarts or failures), primarily affecting sample caching for license auditing. This issue has been resolved. |
| 4347675 | Scrutinize | An issue was found, where 'save-system-table-as-parquet' option in Scrutinize corrupts directory names for exported system tables. This issue has been resolved by correcting the directory renaming logic, ensuring that the original directory names are preserved during the export process. Users can now reliably load the exported Parquet files without encountering directory name corruption. |
| 4347993 | Backup/DR | The backup process has been updated to correctly handle scenarios where one or more Vertica nodes are down. Previously, backups could fail if a node was unreachable, even when specifying the '--nodes' option. This fix ensures that the backup process only attempts to connect to active nodes, resolving the issue. |
| 4348000 | Execution Engine | The Vertica query parser now properly handles the use of PARTITION ROW and PARTITION LEFT JOIN in queries. Instead of returning internal errors, Vertica now rejects the syntax with an appropriate error message, similarly to how it handles other unsupported partition options like PARTITION AUTO, PARTITION BEST, and PARTITION NODES. This fix ensures that users receive clear and informative error messages when attempting to use unsupported partition options. |
| 4348485 | Scrutinize, Vcluster | System table data retrieved using vcluster scrutinize now has column headers in the retrieved files. This enhancement ensures compatibility with database loading processes and tools like the grasp loader, which rely on these headers to identify columns. |
| 4348547 | Directed Query | Directed query search could fail to match queries in cases where the predicate included constant-to-constant operations {{CONST op CONST. }}. This issue has been resolved, ensuring reliable query matching. |
| 4348750 | Optimizer | Historically, the statistics histogram would be invalidated if the row count was updated without fully reanalyzing the columns; this invalidation no longer happens. |
| 4348821 | Installation Program | An issue where installing Vertica on Amazon 2023 Linux fails and an error message is displayed has been resolved. |
| 4349067 | Database Designer Core, Refresh | Fixed a bug that caused some refreshes to fail when the ancient history mark (AHM) was updated in the background. The refresh process now has priority in cases where AHM and Refresh conflict, ensuring successful completion. |
| 4349129 | UI - Management Console | The 'DBD upload file permission error' has been resolved. Users can now successfully upload query files in the DBD tab, or via MC > New design > Manual, without encountering a 'Permission denied' error. This fix ensures that superusers, and all users, can upload files without permission restrictions. |
| 4349189 | Backup/DR | The garbage collection process was failing to clear unreferenced objects due to a 'file not found' error during the rebuild of the backup manifest. This issue has been resolved. |
| 4349838 | Optimizer | Queries utilizing WITH statements, used on multiple query levels with different target lists on each level, would sometimes return an error. The issue has been resolved. |
| 4350031 | Data load / COPY | We have extended our Parquet parser to support the legacy LIST structures. |
| 4350074 | Machine Learning | A fix has been implemented to address an issue encountered when importing XGBoost models in PMML format. Specifically, an error was triggered during the import process, resulting in a 'VIAssert' failure. This issue has been resolved to ensure successful PMML model imports. |
| 4350099 | UI - Management Console | An issue with a potential cross-site scripting vulnerability has been resolved. |
| 4350134 | Admin Tools | Admintools was unable to stop a node on Debian. The issue was due to changes in the 'ps' command utility in Debian 12's procps package, and has now been resolved. |
| 4350653 | Admin Tools, Backup/DR, S3 | IMDSv2 support for config setup at db start has been added. |
| 4391327 | Optimizer | A fix has been implemented to address an issue where the UNION operation was dropping TIMESTAMP precision. |
| 4391353, 4391363, 4391364, 4391366 | DDL - Table | Upgrading or migrating from v23.4 (or older) to v24.1 (or newer) invalidates the reference_schema_id field in the system table vs_view_tables (sets it to 0). This issue has been resolved. |
| 4392283 | Complex Types | When running an EXPLODE or UNNEST function in a locale with collation other than binary, Vertica would throw an error due to an improperly formatted OVER clause, even when the skip_partitioning parameter is set to true. This has been resolved; now, Vertica accepts the skip_partitioning parameter regardless of the current locale's collation. |
| 4393179 | Catalog Engine | A fix has been implemented to address reported slowness of ETL jobs due to locks when taking new sequences, impacting performance. |
| 4393180 | Execution Engine | Fixed an issue where executing ANALYZE_STATISTICS(' ') with a space as an argument would cause the node to go down. |
| 4403837 | Security | There was an issue where S3 bucket credentials were not masked when using the SHOW CURRENT command, potentially exposing sensitive information. This issue has been resolved, ensuring that credentials are now properly hidden, maintaining data security. |
| 4403814 | Catalog Engine | A node crash caused by GCLX being held by Manage Epochs: Advance AHM has been resolved. |
| 4405841 | Backup/DR | An issue where the REPLICATE function fails in an EON mode setup when a node in a subcluster goes down during the replication process has been resolved. This fix ensures that the REPLICATE function is more resilient to node failures in subclusters during EON mode operations. |
| 4446899 | EON | The UsePeerToPeerDataTransfer parameter can now be set at the subcluster level in Vertica. This enhancement allows users to reduce overhead from Peer-to-Peer (P2P) data transfer without disabling the feature at the database level, providing more granular control over performance optimization. |
| 4521827 | Third Party Tools Integration | |
| 4527291 | Security |
The rsync connection for Linux file systems has been upgraded from version 3.2.7 to version 3.4.0 to fix these security vulnerabilities:
|