docs/content/stable/releases/ybdb-releases/end-of-life/v2.3.md
Included here are the release notes for all releases in the v2.2 release series.
Released: September 8, 2020 (2.3.0.0-b176).
docker pull yugabytedb/yugabyte:2.3.0.0-b176
COPY TO statements by creating new memory context for the loop over retrieved rows and resetting it after processing each row. #5205COPY FROM command with OOM fix. Batch sizes can be passed in with ROWS_PER_TRANSACTION in the COPY OPTION syntax. For an example, see Import a large table using smaller transactions #2855 #5453index_backfill_rpc_timeout_ms default from 60000 to 30000 and change backfill_index_timeout_grace_margin_ms default from 50 to 500. #5494CREATE OR REPLACE VIEW. #5071SPLIT INTO without a primary key. #4993UPDATE statement with the RETURNING clause. #5366UPDATE changes partition so its clear what went wrong, fixed yb_pg_foreign_key pg_regress test for semantic merge conflict when updating primary keys and row-level partitioning. #659 #5179 #5310UPDATE statement to change primary key columns. #659TABLEGROUP with the SPLIT clause. For CREATE TABLE, usage is blocked in the grammar. For CREATE INDEX, if NO TABLEGROUP was provided, then presplitting for the index is allowed; otherwise, an error is issued. #5352CREATE TABLE statement. For example, the total number of RPC calls is dropped from 66 to 58 for a simple table like CREATE TABLE t(k INT PRIMARY KEY). #5177\dgr[+] [grpname] to describe tablegroups, \dgrt[+] [grpname] lists all tables/indexes within the specified tablegroup (or within all tablegroups if grpname is not specified), and \d <table_name> is modified to include tablegroup information in the footer, if any. #5088ALTER TABLEGROUP statements to support ALTER TABLEGROUP tablegroup_name RENAME TO ... and ALTER TABLEGROUP tablegroup_name OWNER TO .... Also changes pg_tablegroup entry corresponding to tablegroup_name to properly reflect new grpname and grpowner (if the user has proper permissions or ownership to issue the ALTER TABLEGROUP statement. #5249NO TABLEGROUPS) or select their own tablegroup (TABLEGROUP group_name). #5293ysql_dump, enable serializable-deferrable mode by default. Add new --no-serializable-deferrable flag to disable the default mode. #5128ALTER COLUMN type for variants that don't require on-disk changes. Specifically only allowing ALTER COLUMN type for varch(n) and varbit(n). For example, changing column type from varchar(50) to varchar(255). #4424USING clause in DELETE statement and FROM clause in UPDATE statement. #738 #5262EXPLAIN statement. #2076initdb when index backfill is enabled. #5027skipped and rows_affected_count to 0. #5015DROP INDEX statement invalidates table cache entry for the index table, but should invalidate the table cache entry for the indexed table. #4974yb-admin create_database_snapshot command should not require ysql. prefix for database name. #4991pg_statistic system table lookups and update debugging utilities. #5051WHERE clause in the CREATE INDEX statement, return a Not supported error. #5363release_version for system.peers queries. #5407TRUNCATE operations when ycql_require_drop_privs_for_truncate flag is enabled. When enabled, DROP TABLE permission is required to truncate a table. Default is false. #5443SetPagingState method in statement_params.cc. #5441server_broadcast_addresses flag, provide default port if not specified. #25400 by resetting timestamp to the maximum value when a peer becomes a leader and when the peer loses leadership. #5502rpcz/statements links in yb-tserver Web UI when pgsql_proxy_bind_address and cql_proxy_bind_address are 0.0.0.0. #4963DumpReplayStateToStrings should handle too many WAL entries scenario. Also, log lines only display fields critical for debugging and do not show customer-sensitive information. #5345BOOTSTRAPPING/NOT_STARTED state with its true consensus information instead of marking it as a NON_PARTICIPANT. #4691pg_tablegroup as well as the reltablegroup column of pg_class for that relation).MetaCache::TAbleData::stale is not getting reset back to false. #5245op_id of the last WAL file is less than the committed op_id. #1560CREATE TABLEGROUP and DROP TABLEGROUP flow. #4525yb-admin list_snapshots SHOW_DELETED flag to show deleted snapshots that are still retained in memory. #5332yb_client_admin_operation_timeout_sec for table creation in yb-admin import_snapshot task. #5295enable_collect_cdc_metrics flag and prevent TSAN warnings. #5303result of the operation instead of lhs. #5020load_balancer_max_concurrent_moves_per_table and load_balancer_max_concurrent_moves to improve performance of leader moves. And properly update state for leader stepdowns to prevent check failures. #5021 #5181load_balancer_max_concurrent_moves from 10 to 2. #5461system.partitions table requests. #5225strict_capacity_limit is set when SetCapacity is called to prevent ASAN failures. #5222SEGV in Master UI when registering YB-TServer from Raft. #5501master_ignore_stale_cstate flag is disabled. #5301metric_node_name flag from DEFAULT_NODE_NAME to hostname:port. #4859s3cmd required for encrypted backup and restore flows. #5593YB_HOME_DIR if not set. #5592AreLeadersOnPreferredOnly times out when setting preferred zones in Edit Universe. #5406yb_backup.py script to remove sudo requirement and correctly change user. #5440smtpUsername and smtpPassword from the payload. #5439cron expression must be relative to UTC. Also, add help text indicating when next scheduled job will run. #4709yb_backup.py script and yb-server doesn't have any data directories. #5358BackupAdmin role to authorize users to create backup and restore tasks on universes, but not given other administration privileges. #4694yb_backup.py script to add "round-robin" behavior to thread allocations to better spread loads across nodes in parallel during snapshot upload or download. #4987yb_backup.py script behavior if --keyspace flag is not specified. #5199yb_backup.py script. Explicitly pass the number of threads to concurrently run backup script through UI. The form defaults to the backup script default value of 8 threads if no value is provided. #5283Cannot read property 'displayName' of undefined error. #5267setUniverseKey should handle errors on per-customer basis. #3142Released: September 15, 2020 (2.3.1.0-b15).
docker pull yugabytedb/yugabyte:2.3.1.0-b15
COPY <table> FROM <file> to load data from a large file to a table. #5453CREATE TABLE is 4-5x slower using Docker on Mac than not using Docker. Speeds up table creation by buffering writes to postgres system tables, caching pinned objects, and significantly reducing write RPC calls. #350346f3701 so that 2.3 upgrades can proceed. #5408Admin, ReadOnly, or BackupAdmin) from the UI by an admin. Also, fix stale users list after creation or deletion of a user and disable Save buttons at Customer Profile tabs for ReadOnly users. #5311Released: September 29, 2020 (2.3.2.0-b37).
docker pull yugabytedb/yugabyte:2.3.2.0-b37
pg_stat_statements extension by default. #5750PgStatement objects on hot path after usage to avoid memory consumption. #5374INSERT and UPDATE) on transaction conflicts and avoid surfacing transaction errors to user applications. #4291SELECT_LOCAL, SELECT_LOCAL_TOKENS, and SELECT_PEERS_TOKENS) for caching. #5753ORDER BY columns exist in table, but not in the chosen index, and raise an error. #5690yb_admin. #5368RaftGroupMetadata construction issues found using PVS Studio. #5578rlimit flags to have at-least semantics. Only change the process soft limit if it is smaller than the limit specified by the corresponding flag value. #5715syscatalog. #5708webserver_interface to rpc_bind_address IP/host component. #5320YSQL_USER, YSQL_PASSWORD, and YSQL_DB) and YCQL(YCQL_USER, YCQL_PASSWORD, and YCQL_KEYSPACE). (#5499max_stale_read_time_ms) to 60 seconds. Previously, a follower could return requested data no matter how state the data is. #5590/tablet-servers page) after nodes are removed from the cluster. #4759rpc_bind_addresses. #56340.8.1. #5759curl requests. #5587NOT USED if the node is not in use. #5713Released: October 26, 2020 (2.3.3.0-b106).
docker pull yugabytedb/yugabyte:2.3.3.0-b106
COPY <table> FROM <file> statement. For details, see COPY. Improved memory management should prevent out-of-memory (OOM) issues.COPY OPTION ROWS_PER_TRANSACTION. For an example, see Import a large table using smaller transactions.yugabyte user to belong to other user groups in Linux. (5943)min_num replicas for even distribution of AZs across all regions. (5426)jsonb_path_query). (5408)RaftConsensus tests. (4548, 5912)--ysql_sequence_cache_minval. (6041)yb_backup.py script for YugabyteDB version earlier than v2.1.4. (5810)RegularDB and IntentsDB. (5640)cdc_state table. (5905)AreLeadersOnPreferredOnly. (6081)50. (5811)