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 01/16/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 04/01/2025
| Issue Key | Application Module | Description |
|---|---|---|
| 4522089 | Third Party Tools Integration |
We have upgraded the rsync connection for Linux file systems from version 3.2.7 to version 3.4.0 to fix these security vulnerabilities:
|
| 4523911 | EON | The UsePeerToPeerDataTransfer knob can now be enforced at the node level. |
| 4535433 | 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, so it was removed. |
| 4536639 | Database Designer Core, Refresh | An issue that was blocking the ability to run historical queries at epochs prior to the Ancient History Mark, while running the Refresh command, has been resolved. |
Updated 03/24/2025
| Issue Key | Application Module | Description |
|---|---|---|
| 4404831 | Backup/DR | An issue occurred where if a Vertica node was down, vbr would fail. This issue has been resolved. Now, the backup location points to the same host as the Vertica node. |
| 4444326 | License | Depending on the number of nodes in the cluster, a license expiration NOTICE message was appearing repeatedly. Now, the server reports this NOTICE message a limited number of times. |
| 4449031 | Admin Tools, Backup/DR | Added IMDSv2 support for config setup at db start. |
| 4491417 | Kafka Integration | An issue that was causing nodes to crash after upgrade in librdkafka has been resolved. |
Updated 03/14/2025
| Issue Key | Application Module | Description |
|---|---|---|
| 4350656 | Installation Program | Installing Vertica on Amazon 2023 Linux fails and an error message is displayed. |
| 4392278 | 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. |
| 4393188 | Directed Query | Directed query search could fail to match in cases where the predicate included {{CONST op CONST. }}. This issue has been resolved. |
| 4403815 | Scrutinize, Vcluster | System table data from vcluster scrutinize now has column headers in the retrieved files. |
Updated 01/16/2025
| Issue Key | Component | Description |
|---|---|---|
| VER-87686 | Client Drivers - JDBC | executeLargeUpdate returns an incorrect row count. This is caused by a bug in Simba SDK. Upgrade to the latest upgrade of Simba SDK to resolve this issue. |
| VER-90265 | Kafka Integration | Running the vkconfig shutdown command with the "-conf" option would sometimes erroneously shutdown all running vkconfig instances and not just the ones started with the specified configuration. This issue is now fixed. |
| VER-93594 | Optimizer | An issue occurred, where a join spill was happening when processing the optimized delete part of the plan, which disallows Filter/Filter join distribution. Since the join inner was too large to fit in memory, an error was returned with a hint to retry with Filter/Filter enabled, even though it was already enabled in the session. This issue has been resolved; to address this, when the EnableFilterFilter hint is encountered when it's already enabled, we check if it's an optimized delete plan and in that case retry with optimized delete disabled, allowing the optimizer to choose a Filter/Filter join distribution. |
| VER-93700 | DDL | An issue occurred where the CREATE TABLE syntax using INCLUDING PROJECTIONS creates new pin policies. The CREATE TABLE syntax has been changed to allow user excludes storage policies when running CREATE TABLE ... LIKE to copy the table structure from existing table. |
| VER-93842 | Logging | Old trace profile (.prof) files were not deleted filling up the disk space. A new functionality was added to the do_logrotate() meta function and LogRotateTask Timer serivce that deletes an existing profile if it is older than the max_age (7 days by default). |
| VER-94182 | UI - Management Console | Security Enhancement: Both /opt/vconsole/temp and /opt/vconsole/tempkc directories created by MC have had their permissions change to 750 (drwxr-x---). |
| VER-94621 | UI - Management Console | In MC v11.0, the Query Profile page was working without any issues. MC v12.0 was localized and all labels were translated. However, the Query Profile page was not localized by oversight. This issue has been resolved. |
| 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-95698 | Data load / COPY | Fixed a bug that may cause errors when loading more than 8k files at once using EXECUTE DATA LOADER. |
| VER-95699 | Data load / COPY | Performance improvement: Loading a small amount of files using EXECUTE DATA LOADER WITH FILES when the folder contains a large amount of files should be much faster now, especially when the source location is an object store. |
| VER-95880 | EON | To avoid potential FNF or leaked files, an issue was fixed by scanning all storages in the snapshot to restore/replicate, and removing the storages from tombstone and the reaper queue, while keeping others untouched in tombstone/reaper queue. |
| VER-95925 | Data load / COPY | Previously, when querying certain ORC/Parquet files in a certain way, a hang would occur. This issue has been resolved. |
| VER-96299 | 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-96309 | Data load / COPY | Previously, expanding wild cards as part of COPY command failed on systems with certain versions of GLIBC. This issue has now been fixed. |
| VER-96377 | Admin Tools, Installation Program, Installation: Server RPM/Deb | urllib3 version is now upgraded from 1.26.18 to 1.26.19 |
| VER-96445 | Security | Clients not sending packets during initialization of TLS connections will no longer cause CPU usage to spike. |
| VER-96459 | Backup/DR | If we point the --communal-storage-location at the root of a bucket, and without a trailing slash, the show-restore-points does not automatically add the trailing slash when handling the path. We fixed this issue by canonicalize the path when we get it from the show-restore-points command. |
| VER-96609 | Execution Engine | In some cases, FCSVParser used to core dump when loading multiple files with glob patterns. The issue was resolved. |
| VER-96728 | Installation Program | nofile check does not work when installing Vertica on Ubuntu 18.04. This essue has been fixed. We are setting the nofile value via python module resource if the value is less than the recommended value. |
| VER-97123 | Optimizer | The view referenced in the UPDATE's target list had its subquery pruned during query rewrite, which misaligned a predicate reference to it and caused it to return a null value. This issue has been resolved; now, subquery targets are not pruned from the top-level UPDATE query's target list, instead only pruning FROM subqueries. |
| VER-97203 | HTTP | HSTS header was missing from the HTTPS Server. After the fix, Vertica Embedded HTTPS service enforces HSTS header. |
| VER-97299 | Client Drivers - VSQL | There was an issue that was preventing disabling or enabling of subcluster interior load balancing from taking effect immediately because an internal cache was not being cleared. Using ALTER DATABASE to set the EnableInteriorLoadBalancing parameter would have no impact on the result of the DESCRIBE_LOAD_BALANCE_DECISION function, which in turn would not change load balancing behavior of clients. This problem has been resolved. |
| VER-97476 | Procedural Languages | On Eon mode as of 24.3, stored procedures triggered by the scheduler could not see the current subscriptions, leading to failures for certain procedures. This has been resolved; now, scheduled stored procedures can see the subscriptions. |
| VER-97680 | Execution Engine | Previously, the priority field was not persisting in the catalog. When the database was restarted, the default value of 0 would be applied to every rule. Now, the priority field is accounted for and persists. |
| VER-97700 | License | In some cases, automated database size audits used to run at a different time of the day from the one specified by GET_AUDIT_TIME. The issue has been resolved. |
| VER-97819 | DDL | The knobs for Health Watchdog were not available. The knobs added for the watchdog metrics are now guided and documented. |
| VER-98563 | 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 fixed. |