Release Notes ============= 6.16.3_arenadata24 ------------------ Features and Improvements ~~~~~~~~~~~~~~~~~~~~~~~~~ * Sync with upstream 6.16.3 * [6X backport] Detect POLLHUP/POLLRDHUP while running queries * adcc-extension: Retrieve and send error text * ADB Bundle: Define adjustable parameters for ADCC * ADCC Release 3.0.3: * New UI Backend Server * Query Details and Monitoring: canceling and terminate * Query Details: Locks and Blocks * Support displaying information for the ADCC agent * Query plan details are truncated * Support LDAP authentication Fixes ~~~~~ * ERROR: header checksum does not match * [6X] Restrict execution for multilevel correlated queries * adcc-extension: view with security barrier 6.16.2_arenadata21 ------------------ Features and Improvements ~~~~~~~~~~~~~~~~~~~~~~~~~ * Sync with upstream 6.16.2 * PXF: remove tuple count check for jdbc INSERT * [6X Backport] Shrink to zero relation's segment files on truncate and delete * ADCC: Add jvm arguments for logging Fixes ~~~~~ * Fixed gpbackup failure when foreign tables are present in a backuping database: gpbackup tries to acquire lock on foreign table .. important:: For installing or upgrading to 6.16.2_arenadata21 use ADCM version 2021.05.26.12 or higher 6.16.1_arenadata20 ------------------ Features and Improvements ~~~~~~~~~~~~~~~~~~~~~~~~~ * Sync with upstream 6.16.1 * ADCC Release 2.1.1 * [6X Backport] ORCA fails with SIGSEGV on queries to view under table with dropped columns * [6X backport] elog function ignore multibyte encoding when truncate long messages * ADB Bundle: Set netcat timeout for send metrics to monitoring in Altlinux * Kafka-ADB Connector: Allow user to set custom librdkafka options Fixes ~~~~~ * Fixed when PartitionSelector mechanism doesn't return tuples in case of type mismatch * Fixed adcc-extension: unknown node with id==5 for subplan in values * Fixed adcc-extension: lost locally planed mark for node status messages for query with custom aggregate * Fixed wrong CCNTs for plans dispatched after InitPlans were executed * Removed redundant Gpmon_Incr_Rows_Out() calls from internal sort functions * Fixed invalid variable specified in segment directory path check in ADCM Known Issues and Workarounds ~~~~~ **Issue** `gpbackup` utility of versions 1.20.1-1.20.4 is known to have a bug when foreign tables are present in a backuping database. Backup fails with error SQLSTATE 42809. The fix on the issue is expected in a next ADB release. **Workaround** Replace current `gpbackup` with version 1.20.0 which included in ADB 6.13.0_arenadata12. 6.16.0_arenadata19 ------------------ Features and Improvements ~~~~~~~~~~~~~~~~~~~~~~~~~ * Sync with upstream 6.16.0 * Implement diskquota extension update * Add gp_enable_gpperfmon=on parameter on master and segment server for ADCC 6.15.0_arenadata18 ------------------ Features and Improvements ~~~~~~~~~~~~~~~~~~~~~~~~~ * [6X backport gpdb PR `11625 `_] pg_rewind: avoid removing log files * Add $PXF_CONF and $PXF_HOME env variable on PXF hosts * Kafka-ADB Connector: Implement signal handlers to interrupt consuming * Port ADB to Alt Linux 8.2 Fixes ~~~~~ * Fixed invalid values in `prodataaccess` attribute of `pg_proc` relation after cluster initialization/upgrade * Fixed when Kafka-ADB Connector do not consider partitions empty when a query for their watermark offsets fails on timeout * [6X Backport] ORCA produces incorrect plan for NOT IN clause 6.15.0_arenadata17 ------------------ Features and Improvements ~~~~~~~~~~~~~~~~~~~~~~~~~ * Implement Arenadata Command Center 2.0 Fixes ~~~~~ * Broken URL in ADB bundle service description 6.15.0_arenadata16 ------------------ Features and Improvements ~~~~~~~~~~~~~~~~~~~~~~~~~ * Sync with upstream 6.15.0 * Implement switchover from master to standby via ADCM Fixes ~~~~~ * Kafka-ADB-connector: issue with converting AVRO dates before UNIX epoch to GPDB representation * Kafka-ADB-connector: issue with GPDB representation of AVRO double number that has more than 6 digits after radix point * Kafka-ADB-connector: issue with wrong interpretation for AVRO timestamps that below zero 6.14.1_arenadata14 ------------------ Features and Improvements ~~~~~~~~~~~~~~~~~~~~~~~~~ * Sync with upstream 6.14.1 * Add link to main page in ADCC logo Fixes ~~~~~ * Fix resource group waiting queue corruption * pg_aocsseg inconsistency after column addition rollback * Remove online loading of static resources from the ADCC web interface * Cluster failed after single segment-host lost due to FTS misbehavior * Multiline text in CSV output from gplogfilter is incorrect 6.14.0_arenadata13_b2 --------------------- Features and Improvements ~~~~~~~~~~~~~~~~~~~~~~~~~ * Fixup incorrect links in repos of b1 release 6.14.0_arenadata13 ------------------ Sync only release Features and Improvements ~~~~~~~~~~~~~~~~~~~~~~~~~ * Sync with upstream 6.14.1 6.13.0_arenadata12 ------------------ Features and Improvements ~~~~~~~~~~~~~~~~~~~~~~~~~ * Tkhemali-connector: Avoid intermediate conversion to byte array * Remove obsolete batching options in ADQM Connector (sinse we are using TEXT now) * Sync with upstream 6.13.0 codebase * Bump to latest version of additional components * Reduce noise in logs about gpstate * Support auxilliary relations that belongs to AO table to be income to pgstattupe extension to exactly estimate bloat of these relations Fixes ~~~~~ * GPDB fails after activation developer gucs of PostgreSQL * Orca optimizer builds inefficient query plan * Column-wise statistics target parameter doesn't apply to partitioning tables * Error gpactivatestandby when run it too fast after power off master * Mistake in the parsing of decimal part for time logical types * Scale is applied incorrectly for decimal values what has a length less than precision 6.12.1_arenadata11 ------------------ New Features ~~~~~~~~~~~~ * Sync code base with upstream GPDB 6.12.1 * Add ofset function to Kafka (ADS) connector * Add rest commited function to Kafka (ADS) connector * Implement 'text' format for kafka connector * Provide JVM_OPTS setting for PXF * Support AVRO logical types in Kafka-ADB connector * Switch to new way of postgis installation * Kafka-ADB: Use rd_kafka_query_watermark_offsets to validate partition-offset pairs Fixes ~~~~~ * ADCC disk space usage troubles in case of coredumps * gprestore - ERROR: missing data for column * "The limit of distributed transactions has been reached" error on secondary * WindowFunc with winref 1 assigned to WindowAgg with winref 2 (nodeWindowAgg.c:2264) * Wrong behavior with grouping function * Exclusive lock on any partitioned table locks the pg_partitions view. * Server locks kadb.offsets table