Release Notes¶
6.18.0_arenadata29¶
Fixes¶
- Fixed when accessing from AO table Index returns the wrong result
- kafka-fdw: fixed garbage in output at least for format text
- gpbackup: fixed when it handles empty tables set for an incremental data backup properly
- gpbackup: fixed when it hangs forever when interrupted
- ADCC Release 3.2.4:
- Added message size check
- Fixed re-sending of incorrect messages
- Added settings
maxMessageKbSize
to agent.properties - Fixed getting system metrics from clickhouse
6.18.0_arenadata28¶
Features and Improvements¶
- Sync with upstream 6.18.0
- gpbackup: added explicit order of tables by
pg_class.relpages
during gpbackup - PXF: added support for partitioning query for Sybase
- ADCC Release 3.2.2:
- adcc-extension: added database and username to plan message
- adcc-extension: disabling lock polling to avoid sending huge locks snapshots to agents
- Added support for multi clusters
- Added system metrics: CPU, RAM, IO
- Added actualization for hanging queries
- Added Clickhouse Database for saving draft system metrics
- Added dynamically adding columns to history and monitoring forms
- Added information about background processes on the system status information page
Fixes¶
- Fixed unexpected SIGSEGV error on Reindex operation
- madlib on ppc64le arch included into build
- Fixed when gpbackup may dump partitioned table’s data twice
- Fixed
Not enough memory reserved for the statement
when calling the function multiple times for CTE SELECT statement in PL/pgSQL function on table with lot of partitions
6.17.5_arenadata26¶
Features and Improvements¶
- Sync with upstream 6.17.5
- ADB Bundle: added Delete action for Monitoring Clients
- ADB Bundle: added Ready to upgrade status for bundle upgrade
Fixes¶
- Fixed low CPU performance on Power with new added CGLAGS build options
6.17.2_arenadata26¶
Features and Improvements¶
- Sync with upstream 6.17.2
- Sync with pxf release-5.16.3
- Sync with gpbackup 1.21.0 release
- Sync with gpbackup-s3-plugin 1.7.0 release
- Added build for Power8 LE platform (ppc64le arch)
- ADCC Release 3.1.3
Known Issues and Workarounds¶
Issue
madlib on Power8 (ppc64le arch) breaks gpdb build
Workaround
No workaround. madlib is not included into Power8 (ppc64le arch) build.
6.17.1_arenadata25¶
Features and Improvements¶
- Sync with upstream 6.17.1
- Implement ZSTD compression support for gpbackup
- adcc-extension: send schema name in Node message
- ADB Bundle: external database connection for ADCC Database
- ADCC Release 3.1.0:
- Time-based Retention Policy
- Fine-grained access to multiple databases for Advanced users
- Show extended information about error in ADCC
- Add info on ADCC/ADB versions and docs from ADCC web interface
- Add scaling to plan modal window
- Add column search filters and sorting for ADCC pages Query Monitor/History
- ADCC UI updates
Fixes¶
- Security Patch for cve-2020-25695 (sandbox escape)
- kafka-fdw: fixed when segments fails after SELECT operation from KafkaToADB external table with batch size more than
40000 - <msg_count> * 40
bytes - Fixed when Postgres optimizer produces bad plan for replicated table with index
- adcc-extension: fixed when expected segment distributed transaction context was ‘Segment Prepared’
- adcc-extension: fixed when there is no possibility to differ QueryStatus for slices that executed on master
- [Power] fixed bogus compiller error during pg_upgrade compilation
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
Known Issues and Workarounds¶
Issue
kafka-fdw of versions 0.11-0.12 (they were ported since 6.15.0_arenadata17) is known to have a bug when batch size exceeds 40000 - <msg_count> * 40
bytes. SELECT operation from KafkaToADB external causes SEGFAULT. The fix on the issue is expected in a next ADB release.
Workaround
Do not use batch size larger than 40000 - <msg_count> * 40
bytes if you read more that one message (when reading just one message no any limits exist).
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.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