Resolved issues

Resolved issues release notes for 25.2.x.

25.2.0-5

Updated 12/05/2025

Issue Key	Application Module	Description
4878505	System: Performance	Fix for 100% CPU Utilization with STRPOS Function: We’ve optimized the behavior of the STRPOS function to significantly improve performance in specific scenarios. What changed: Previously, all inputs to STRPOS were converted to UTF-16 to leverage the ICU (International Components for Unicode) library for string comparison. While ICU provides robust support for complex locale-aware comparisons, this conversion introduced overhead—especially for simple use cases. Now, for simple locales with 1-to-1 character mappings (such as en_US, de_DE, and other locales where each character maps directly between UTF-8 and UTF-16 without requiring normalization or multi-codepoint handling), STRPOS uses a UTF-8 based comparison. This avoids the need for conversion to UTF-16 and bypasses the ICU library entirely, resulting in much faster execution.
4970328	Security	Fixed an issue where creating access policies added extra parentheses, causing COPY_TABLE to fail with an access policy mismatch error.
4990343	Execution Engine	An issue occurred where LISTAGG queries did not consistently return NULL when no rows match the search criteria. This bug manifested when using the WITHIN GROUP clause alongside an AND NOT EXISTS subquery within the LISTAGG statement. This issue has been resolved.
5004898	EON	This release addresses an issue where cluster nodes experienced frequent crashes due to out-of-memory (OOM) errors. The problem was observed across primary and secondary subclusters, with RSS memory usage growing constantly, even on idle secondary subclusters. The fix resolves a memory leak that was affecting all hosts, regardless of hardware specifications or operating system.
5011525	Security	New Database Parameter: Introduced a new database parameter, OAuth2JITConflictPolicy, to control OAuth2 JIT login for existing users. MERGE, the default, allows OAuth2 login for existing vertica users and grants them the appropriate auth method. This is identical to the existing behavior. If set to IGNORE then existing users require an OAuth2 client authentication granted to log in with an OAuth2 token, no automatic granting is performed. Users with psuedosuperuser are always treated as if OAuth2JITConflictPolicy is set to IGNORE, ie. they can only use authentication methods that have been explicitly granted.
5040784	Admin Tools	This fix ensures the upgrade process is successful and correctly handles the FlexTableLib library, resolving the fjsonparser incompatibility issue.
5050270	Node Management Agent, Vcluster	Critical security vulnerabilities have been identified and fixed in the Go binaries (vcluster, vcluster_server, and node_management_agent) that shipped with the Vertica database (both RPM and containers).

25.2.0-4

Updated 09/30/2025

Issue Key	Application Module	Description
4773235	License	An issue occurred where license audit compliance status showed an anomaly. This issue has been resolved. The GET_COMPLIANCE_STATUS() function now accurately reflects the overall compliance status, aligning with individual schema audits.
4873509	UI - Management Console	Fixed a defect where Vertica Management Console (MC) did not support SMTP configuration without authentication after Keycloak integration. The original email functionality has been restored to support SMTP configurations that do not require a username and password.
4876454	Optimizer	Fixed an issue where INSERT…SELECT statements would hang when GROUPBY PUSHDOWN was not occurring due to the presence of non-equi joins. The fix ensures that INSERT…SELECT queries with non-equi joins no longer result in indefinite hanging, restoring expected performance.
4893664	Machine Learning	Resolved an issue where the imported TensorFlow model required an unexpected number of input columns (64) instead of the expected 6 (based on tf_model_desc.json and model summary). The model now correctly predicts with the expected number of input features.
4904024	Hadoop, ResourceManager	Resolved an issue where upgrading from Vertica version 12.0.4 to 25.1 resulted in database startup failures due to timeouts. This issue occurred on replicated S3 buckets within a separate cluster running Rocky Linux 8.10. The fix addresses a signal 11 error encountered during the 'Read DataCollector' stage of the startup process, specifically related to refreshing disk space information.
494350	UI - Management Console	This fix addresses security vulnerabilities in Tomcat and Spring Security by upgrading Tomcat to version 10.1.42 and Spring Security to version 6.4.4.
4950424	Data load / COPY	Fixed a node down issue that occurred when the 'CopyFaultTolerantExpressions' parameter was enabled and FILLER was used in conjunction with specific TO_CHAR format strings. This fix prevents unexpected node failures during COPY operations using TO_CHAR with FILLER.
4959200	Cloud - Amazon	Fixed an issue where nodes would experience 'ExpiredToken' errors when reading from Parquet files in S3, leading to catalog truncation lag and requiring node restarts. The issue was caused by the system not properly refreshing AWS IAM role credentials. This fix ensures the system correctly handles token expiration and refreshes credentials as needed, preventing disruption to business operations.

25.2.0-3

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.

25.2.0-2

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.

25.2.0-1

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: Certifi: The Certifi package has been upgraded to version 2024.07.04 or higher to address CVE-2024-39689. WebOb: The WebOb package has been upgraded to version 1.8.8 or above to address CVE-2024-42353. Mercurial: The Pip Mercurial package has been upgraded to address CVE-2023-5752. Idna: The Inda package has been upgraded to version 3.7 to address CVE-2024-3651.
4771895, 4771898, 4772161	UI - Management Console, Security	Security vulnerabilities within a component library using the Spring framework have been remedied.

25.2.0

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: CVE-2024-12084 (https://nvd.nist.gov/vuln/detail/CVE-2024-12085) CVE-2024-12085 (https://nvd.nist.gov/vuln/detail/CVE-2024-12084)