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
.
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.