SingleStore Managed Service

Maintenance Release Changelog

2021/07/26 Version 7.3.14
  • Updated memsqlctl to establish an SSL connection to the node if a CA certificate is set explicitly. SingleStore now falls back to an SSL connection via the host's default certificates if the target user requires SSL.

  • Fixed an issue where the exporter process was not being cleaned up when memsqld is shut down.

  • Fixed an issue where modifying the case of a column via ALTER TABLE could cause a pipeline using that table to crash.

  • Fixed an issue where DDL forwarding could crash when DROP USER is run.

2021/07/12 Version 7.3.13
  • Properly set keep alive and timeouts on the persistent leaf-to-master aggregator connection that is used to communicate replication link status. This fixes an issue with REBALANCE commands that failed with synchronization timeouts.

  • Fixed a synchronization bottleneck, improving the ability of the pipeline scheduler to run many pipelines in parallel.

  • Improved the performance of pipeline and database DDL actions when a database has many pipelines running.

  • Fixed a blocking issue that could occur when several pipelines are being background scheduled simultaneously.

  • Fixed an issue where incorrect results could be returned when using INSERT_ALL to insert into a temporary table.

  • Fixed an issue that disabled a compilation optimization for selected queries. Disabling this optimization made certain queries slower.

  • Fixed an issue that could cause the internal statistics tracked by workload management to become incorrect after a "too many queued" query error has been hit.

  • Fixed an issue with CTE predicate pushdown where predicates were incorrectly split across HAVING and WHERE commands.

2021/06/21 Version 7.3.12
  • Fixed a rare race condition that could cause sync replication to get stuck.

  • Added a new system variable optimizer_disable_subselect_to_join. Setting this to ON disables the optimizer rewrite that converts subselect to joins automatically.

    Disabling this rewrite may cause queries to fail if they require the rewrite to run.

  • Fixed an issue where a crash could occur when data_conversion_compatibility_level is set to a value other than 6.0 and a computed column is set to an invalid value via an UPDATE statement.

  • Fixed an issue where a crash could occur when leaf_failover_fanout is set to load_balanced mode and REMOVE LEAF is run on larger clusters.

  • Fixed an issue where a crash could occur when running UPDATE on a query with a scalar subselect in a SET clause after ALTER TABLE.

  • Fixed an issue where in some rare cases PROFILE queries could cause a crash.

  • Fixed an issue where ROWSTORE_PROGRESS could exceed 100% in mv_backup_status.

2021/06/01 Version 7.3.11
  • Added a new system variable auditlog_retention_period which controls the retention period (in days) of audit log files on disk. The default is 0 which means files remain on disk indefinitely.

  • ADMIN_ONLY audit log level now audits DDL statements only. Previously it would audit other non-DDL statements, which could cause bloat in the audit logs in ADMIN_ONLY mode.

  • Fixed an issue where a crash could occur during concurrent columnstore DELETEs while escalating from row level locking to table level locking.

  • Fixed an issue in universal storage unique keys where hash collisions with null values could produce incorrect results.

  • Fixed an issue where incorrect results could be returned when using UNION ALL and SELECT ... INTO S3.

2021-05-24 Version 7.3.10
  • Optimized partition placements when rebalancing partitions in load_balanced mode.

  • Fixed a permissions error where the stated required permission was incorrect.

  • Fixed reader quota errors that could be encountered by DELETE queries with limits that run distributed joins on derived tables.

  • Fixed an issue where CREATE GLOBAL TEMPORARY TABLE LIKE ... would create a normal user table instead of a global temporary table.

  • Fixed an issue with DATETIME equality testing when updating columnstore tables.

2021-05-03 Version 7.3.9
  • Added support for temporary stored procedures. For more information, see CREATE TEMPORARY PROCEDURE.

  • Added support for bloom filters on right joins using columnstore indexes and segment elimination. Previously, bloom filters were only supported on inner joins.

2021-04-19 Version 7.3.8
  • Added a new engine variable, backup_max_threads, which controls the number of concurrent threads used to run backups on leaves. By default, each backup uses one thread per partition.

  • Fixed an issue where queries filtering on the the transaction_state column of information_schema.PROCESSLIST or information_schema.MV_PROCESSLIST could return the wrong results.

  • Fixed a wrong results issue that could occur during online upgrade to version 7.3.

  • Fixed a crash that could occur when using a table reference like `table_name.*` inside TO_JSON

  • Fixed a bug on the websocket proxy where a connection could hang on the client after being killed on the server.

2021-04-01 Version 7.3.7
2021-03-15 Version 7.3.6
  • Running DDL inside of stored procedures from child aggregators is now properly supported.

  • Fixed a crash that previously occurred in cases where SHOW CLUSTER STATUS was run while a leaf node was unresponsive.

  • Fixed an issue that caused incorrect tracing to the error log when SHOW WORKLOAD MANAGEMENT STATUS was executed.

  • Fixed an issue with the system variable redundancy_level being incorrectly set on leaf nodes, which previously caused errors when CHECK BLOB CHECKSUM WITH REPAIR was run.

  • Monitoring clusters are now supported via SSL.

  • Fixed an issue that previously caused an incorrect error when running LOAD DATA from inside a stored procedure.

2021-03-08 Version 7.3.5
  • REBALANCE ALL DATABASES and REBALANCE PARTITIONS FULL now fully rebalance redundancy 1 clusters.

  • Added support for connecting to Avro Confluent Schema Registry, by specifying SSL configuration settings in CREATE PIPELINE.

  • Fixed an issue with automatic histograms on clusters that were upgraded with the variable cardinality_estimation_level set to 6.0.

2021-03-01 Version 7.3.4
  • Fixed an issue that occurred when running ALTER or TRUNCATE against a table that included ON DUPLICATE KEY UPDATE in its CREATE PIPELINE statement.

  • Fixed an issue that caused read actions on columnstore JSON objects to result in an error (Error reading from parquet: Column not found in schema) in cases where trailing whitespaces were present in the JSON key names stored for a given table.

  • Improved the optimizer’s cost estimates for hash joins when one of the tables in a given join has an index matching the join condition.

  • When inserting into a columnstore table, columns not needed to deal with a duplicate key are no longer decompressed.

  • Fixed a crash that occurred when an aggregate function was used in an unsupported context inside a stored procedure.

  • Added a new engine variable optimizer_empty_tables_limit, which sets a threshold for the number of empty tables that must be present in a query before the optimizer falls back to being rule based, instead of cost based.

  • When running memsql_exporter, the password for the monitoring user is no longer exposed in the ps output.

  • Allowed memsqlctl to establish a secure connection when a node is configured for SSL using either the engine variable ssl_ca, or the host system’s trusted certificates for verification.

  • Increased TasksMax to 128000 for memsql.service in order to prevent errors and/or unexpected node behavior. Previously, this setting was often exceeded, causing systemd to limit the ability of memsqld to fork processes.

  • Fixed an issue that caused auto-rebalance operations occuring when leaf_failover_fanout is set to load_balanced not to fully rebalance the cluster.

2021-01-19 Version 7.3.3
  • Fixed a timeout error that occurred when running REBALANCE PARTITIONS on databases with large columnstore tables.

  • Improved the speed of server shutdown and of recovery for databases with large numbers of tables. This improvement is evident at 1,000 tables or more, and increases significantly after 10,000 tables.

  • Fixed an issue that caused RESTORE commands to fail in cases where a database contained a large number of reference tables.

  • Fixed an issue that caused DROP TEMPORARY TABLE IF NOT EXISTS to incorrectly return an error in cases where the table didn’t exist.

  • Fixed a crash caused by a check on the maximum number of partitions allowed on a leaf node. Now, an error message is surfaced when this is exceeded.

  • Fixed issue that caused an error (Transaction rolled back mid-query) to occur when running cross-database queries in multi-statement transactions.

  • Reduced blocks on UPDATE and DELETE commands via background merger.

  • Added a new variable, default_columnstore_table_lock_threshold, which sets a threshold for the number of rows that are locked when updating rows in a columnstore table before a table lock is acquired.

2020-12-15 Version 7.3
  • Initial GA release of SingleStore DB 7.3.2