ADB Control releases
4.2.1
Date: 27.04.2023
Arenadata DB Command Center (ADBCC) is renamed to Arenadata DB Control (ADB Control) |
Added the ability to export metrics to an external database for a long-term storage |
Added the CSRF (Cross-Site Request Forgery) protection support |
Added a forced password change at the first user authentication in the system |
Added the temporary blocking of the user account after several failed authentication attempts |
Added calculation of total monitoring metrics. For active commands and transactions, |
Added pagination for the Job monitoring page |
Fixed checking the name of the user that is being created. Only latin characters, numbers, and special characters in the user name are available |
Fixed: no pop-up window when receiving an error |
Fixed: a query could become "frozen" in the unknown status after 14-16 seconds |
Decreased the log level in gpadcc |
4.1.0
Date: 15.02.2023
Using ADBCC along with gpperfmon within the same ADB cluster is now supported |
LDAP search in several OUs during ADBCC authentication is now available |
Added the ability to sort by almost all columns on the Command online/Command history and Transaction online/Transaction history pages |
Added the ability to show all available filters on the Command online/Command history and Transaction online/Transaction history pages |
Added the ability to edit the |
Added a pop-up window with information about the application of the resource group settings |
On the detailed transaction page in the table of commands belonging to the transaction, renamed the Workload column to Resource group |
Added the ability to specify the sorting direction on the Resource groups page |
Fixed breadcrumbs that are shown when viewing resource groups. Instead of cluster and group IDs, resource group names are now displayed |
Sometimes the cpu skew metric obtained negative values |
The statistics calculation for an interval of more than an hour |
The calculation for the Total queue duration column on the Resource groups page |
Removed the ability to enter negative values for the Batch size and Expire duration settings on the Configuration page for a job policy |
The pagination error on the User page |
The calculation for the number of commands in the |
The search for a command in the text when there is a newline character in the query text |
4.0.0
Date: 06.12.2022
Added a new user interface for ADBCC |
Added a new module for ADB binary backups management — Arenadata DB Backup Manager (ADBM) |
Added a new module responsible for performing scheduled tasks — adcc-scheduler |
Added a functionality for monitoring resource groups:
|
All datetime metrics are now stored in UTC |
For clusters being removed from the ADBCC configuration, uncompleted commands and transactions are not updated |
The |
The calculation of |
The calculation of the node execution time for a command in PLAN & PROGRESS |
The calculation of system metrics with negative values |
3.7.0
Date: 20.10.2022
Added new performance metrics for commands and transactions: |
Added the ability to repeatedly change a resource group for a transaction |
Removed the ability to stop execution of a separate command by canceling or terminating it |
Renamed the Workload column to Resource Group on the Monitoring and History data pages for commands and transactions, as well as for detailed pages |
Removed the ability to change a resource group for a command on the Monitor Command page |
For commands and transactions, rows are now sorted by the Status column value |
Excluded the large bold font style for system metrics on detailed pages of commands and transactions |
Corrected the data sorting on the Audit page based on numbers, symbols, letters |
It was impossible to enter data using the keyboard into the Start Time filter on the Monitor/Transaction pages |
The error with appearance of multiple filters by cluster and by database, if a filter by database was being added from the filter list |
Fixed the mapping of memory dimension from MiB to Mb |
Fixed calculating the number of tuples affected by the request without updating the page |
Included the Planchecker database objects into migration |
3.6.0
Date: 30.08.2022
Added a new column Planner |
Added the ability to filter commands by a planner |
Added the ability to cancel a transaction on the Detailed transaction page |
Added a button to reset and delete all previously applied filters on the Monitor and History command pages |
Added the ability to reassign queries to another resource group |
Added a configuration for a Planchecker address |
Changed the display of the |
The ADB unavailability error in case of the |
Fixed an actual tuples count for commands |
Fixed the incorrect display of the command status on the Detailed transaction page if the transaction was cancelled |
Added a Planchecker image to the ADBCC service (docker-compose) in the ADB bundle |
3.5.1
Date: 21.07.2022
Processing of NodeStatusMetric messages is supported |
Added transaction pages: Transactions monitoring, Transactions history, page with detailed information about the transaction and a list of requests made within this transaction |
Added the ability to filter data by schema and relation on the Query history page |
Added a link to Transactions history in order to navigate to queries from the Audit page |
Added a link to the parent transaction in the Command details tab |
The SQL statement groups DDL, DML, DCL, and TCL are now displayed on the Monitor and History pages |
Added Spill and Spill Skew columns to the customization table on the Monitor/Command and History/Command pages |
A non-blocking socket is now used to communicate with an agent |
Long values of the Query ID column overlapped the next column with data on the History/Command page |
The incorrect sorting according to the schema with a heavy load on the Relation audit page |
When a user moved from the statistics to the list of commands on the Relation audit page, the command was being duplicated |
The missing tooltip for the Reset button |
The |
Empty values were at the end of the list when the data was being sorted |
The queuedTime field displayed different values on the Monitor page and the Command details page |
The cache did not work properly, and the data was obtained directly from the database |
After the Cluster name column was added, the cluster value was not displayed in the table on the Monitor/Command and History/Command pages |
The |
The bug with sorting on the Monitor and History pages when all the records became hidden |
3.4.0
Date: 11.04.2022
Integrated the Avg cluster query metrics |
Implemented compression for huge queries |
Added a configuration for Registry Service to configure the addresses of backend servers |
The actual statistics from |
The Plan&Progress and Text panels are hidden now if the content is empty |
ADBCC exceeded the limit of connections to ADB |
Fixed the relation name display for a Dynamic Seq Scan node |
The color-coding for plan node statuses was broken |
The login error with cyrillic passwords |
Migrated the adcc-extension to the adbcc repository |
3.3.0
Date: 17.02.2022
Data audit support |
Background jobs history |
Support for virtual process memory in system metrics of commands |
Service load ratio support |
Changed the sort order for metrics with |
Reworked top menu |
Bumped log4j2 dependencies |
New system endpoints |
3.2.2
Date: 12.11.2021
Multi-clusters |
New system metrics: |
Adding columns dynamically to the History and Monitoring pages |
Information about background processes on the system status information page |
Actualization for hanging queries |
adcc-extension: database and username are now shown in a plan message |
adcc-extension: lock polling is now disabled to avoid sending huge locks snapshots to agents |
Using a ClickHouse database for saving draft system metrics |
3.1.0
Date: 17.08.2021
Time-based Retention Policy |
Fine-grained access to multiple databases for Advanced users |
Extended information on errors |
Column search filters and sorting on the Query Monitor and History pages |
Information on ADBCC/ADB versions and documentation |
Scaling of the plan modal window |
UI updates |