Changes

This section includes fixes which change existing functionality. Fixes which don’t involve changes to functionality are documented in Resolved Issues.

If a change relates to a Zendesk issue, the associated Zendesk reference number is displayed, for example (10118).

Changes in NuoDB 7.0

Removed the following unused SQL system properties

  • AUTOCOMMIT_DDL

  • COMPAT_CARDINALITY_CLAMP

  • DB_TRACE

  • DB_TRACE_MIN_TIME

  • DB_TRACE_PATTERN

  • DB_TRACE_PROCEDURES

  • DB_TRACE_TABLE

  • ENFORCE_TABLE_LOCKS_FOR_DDL

  • INDEX_ENCODING

  • OPT_MAX_SCAN_REOPTIMIZE

  • OPT_REMOVE_INDEXED_PRED

  • OPT_STATS_INDEX

  • ROLLBACK_DEADLOCK_VICTIM

  • SKIP_UNCOMMITTED_INSERTS

  • TRANSACTIONAL_DDL

  • TRANSACTIONAL_LOCKS

  • UDF_CACHE_SIZE

For more information, see SQL System Properties.

Removed the following database options

  • commit

  • journal-single-file

  • max-http-connections

For more information, see Database Options.

Removed the CreatePlatformRecordsTime and ObjectFootprint metrics

For more information, see Metrics Published by Database Processes.

Removed the obsolete queryoptimizer connection property and the optimizer-version database option

For more information, see Connection Properties and Database Options.

Renamed the disable-stats-collection database option to disable-stats-v3-auto-update

For more information, see Database Options.

Renamed the database metrics DiskReadGeneral and DiskWritten to AtomBytesRead and AtomBytesWritten, respectively

For more information, see Metrics Published by Database Processes.

Renamed LEFT HASH SEMI JOIN to LEFT SEMI HASH JOIN

For more information, see Understanding EXPLAIN Command Output.

Renamed certificate-poll-interval-ms to certificate-poll-interval

The value of certificate-poll-interval includes a duration indicator (For example, s for seconds). The default value is 10s.

Creation and execution of Embedded Java is disabled by default to improve security

For more information, see Using the Embedded Java API.

Recursive use of Common Table Expressions (CTEs), which was previously unsupported, is now explicitly blocked with, "Cannot use common table expression 'CTE_name' recursively".

Database processes (TEs and SMs) running in Kubernetes will now automatically attempt to connect to the closest Admin Process (AP) based on their region or Availability Zone (AZ)

This default configuration helps prevent database processes in one AZ from shutting down due to an AP failure in another AZ. To achieve similar behavior in Docker deployments, configure the admin-affinity-label-keys option to define a database process startup hierarchy to nuodocker. For more information, see nuocmd start sm and nuocmd start te.

Log each failed transaction to nuoadmin.log when the number of failed transactions exceeds 5000

Changes in Previous NuoDB 6.0.x Releases

Included the Journal segment number in the log messages and limited the number of logged messages

The log messages now include the Journal segment number for troubleshooting. The details are logged for up to 100 unreapable messages. Beyond this limit, only the number of unreapable messages are reported.