NuoDB Changelog

What's new in NuoDB 2.1.1.5

• Support for Java 1.6 is deprecated. Support for Java 1.6 will be removed in NuoDB Release Java 2.2.
• General Improvements in This Release:
• Data Layer:
• Performance with journaling enabled has been improved. The maximum journal size is now configurable with the TE command line option --journal-max-file-size-bytes.
• The NuoDB Check tool now takes a new flag, --mem, which limits the amount of memory it will consume, specified as megabytes (m) or gigabytes (g). Default is 2gb.
• SQL Layer:
• Significant query optimizer changes will make intersection and union query plans substantially more efficient.
• Bitwise operators |, &, and ^ are now supported.
• LIKE, CONTAINING and STARTING all respect collation now. This is a change of behavior for CONTAINING which used to always be case-insensitive.
• Indexes - Prior to 2.1, indexes on data of type NUMBER, type NUMERIC(p,s) where p >= 20, or DECIMAL(p,s) where p >= 20 were not functioning correctly. This is because, prior to 2.1, we were not able to correctly index numbers that are potentially bigger than an int64. This has been fixed. If you have such indexes in your databas;e, you must drop and recreate these.
• General Improvements in This Release
• Data Layer
• SQL Layer
• Drivers
• Migrator
• Documentation
• Issues Fixed in 2.1.1
• Issues Fixed in 2.1.0
• Improvements & New Features 2.:1.0
• Customer / Partner Sourced 2.1.0
• Drivers:
• There's a full serving of NuoDB PHP PDO Driver improvements and fixes, including:
• Blob fixes
• Logging improvements
• PHP 5.5 support on Linux
• Migrator:
• Parallelization is now available.
• Migrator's multi-threaded loading functionality provides new commands for Load (under Executor Options):
• [--threads (-t)=[threads]] Number of worker threads, default is the number of available processors
• [--parallelizer (-p)=[parallelizer]] Parallelization strategy name
• Data loading optimization was improved, more specifically loading of indexes, which is performed after DDL is applied and data loaded.
• The Migrator has added support for MySQL data types, improved date types, and ENUM.
• The Migrator includes SQL generator fixes too, with generated indexes and check constraints.
• Issues Fixed:
• DB-4704 - automation: ability to define override for archive/journal base dir
• DB-5116 - supporting chaining load balancers
• DB-5117 - remove chorus text from balancer interface
• DB-5782 - Auto Console: help on metrics
• DB-6145 - Auto Console UI: db template hover text cut off
• DB-6303 - Automation Console UI, dashboard: ability to set refresh rate for Metric widgets
• DB-6324 - domain rolling upgrade with managed databases
• DB-6923 - Auto Console UI: list of templates ill-formatted if template has empty "summary" field
• DB-7117 - add balancer tests (junit multi agent/broker plus mock proc)
• DB-7323 - Improve handling of corrupt durable state
• DB-7330 - raft log compaction (snapshotting)
• DB-7589 - get "rest" suite to work with enableAutomation=true
• DB-7813 - RESTful API methods should respond with proper HTTP status codes for error conditions
• DB-7817 - rest API "databases/hosts": use "404 Not Found" not 200
• DB-7838 - test_create_unmanaged_database failure in nightly: 400 != 201
• DB-7962 - Host stat alarm definitions: need to be saved as StableId in order to sustain agent restart
• DB-7999 - Mgr CLI: add timeout options/property to start/shutdown/create managed database
• DB-8022 - Description.singleKeyWrite asserted
• DB-8112 - Investigate reports of slow update in IMPORT/EXPORT scenario
• DB-8151 - Can set maximum lower than minimum for number of TE or SM
• DB-8185 - Manager is missing CLI for list, delete, create/update template
• DB-8197 - Timed out (3 SECONDS) waiting to be ready to start unmanaged process
• DB-8204 - Auto Console UI: there should be stop/shutdown for un-managed databases
• DB-8215 - single host edit dialog missing options drop down
• DB-8226 - Add Host Tag dialog when editing a System-Defined Host Tag
• DB-8232 - Tag requirements and options are destroyed upon template change
• DB-8253 - protect against duplicate stable ID protection (due to cloning an ec2 image that had broker started once)
• DB-8299 - Auto Console UI: create db with custom template doesn't show other options
• DB-8301 - Rest API, start db: allow for waitForStart timeout like we do for Mgt start process
• DB-8358 - EnforcerFailed alarm not broadcasted to all brokers; only reported if Client connects to Leader
• DB-8365 - Nodes are not advertised correctly during broker peering
• DB-8375 - Nuorestsvc service should not fail to start if it connect to broker, use same retry logic
• DB-8376 - Admin Center home page - update link to AWS kit once it's been rev'd for 2.1
• DB-8384 - historical slow query view could be more useful
• DB-8413 - crash in PlatformTransaction::undoTransaction during TE shutdown
• DB-8422 - Metric windows overlap if it takes too long to get the data for display
• DB-8433 - Auto Console UI: doesn't look up an alarm with a untableId:pid entitty
• DB-8447 - License Information needs to be updated
• DB-8455 - Platform/NodeList.cpp:82: void NodeList::validate(): Assertion
• DB-8461 - Diags: rename log files during zip process to preserve the hostname
• DB-8465 - mvn & eclipse support for java reformat, and auto-format
• DB-8477 - Record version isn't backed out during transaction rollback
• DB-8479 - Last write times stored only once
• DB-8485 - Utility for crash safe writing of log, state, and snapshots
• DB-8486 - Encoder to serialize/deserialize snapshots
• DB-8487 - State machines can export/import their state
• DB-8488 - Changes to the Log to support compaction
• DB-8489 - Run compaction when the log exceeds a specified length
• DB-8490 - Send and receive snapshots over the network when a requested index has been compacted
• DB-8491 - Upgrade process for pre-compaction to post-compaction domain
• DB-8495 - gen'd Rest API doc: all example http paths wrong, http://example.com/1/databases/
• DB-8496 - after a refresh/resize, yellow system db icon is slow to show up
• DB-8497 - Auto Console UI: local state isn't stored on per login/user basis
• DB-8499 - auto console UI, yellow db icon "create db" uses login user instead of domain user/pwd to create db
• DB-8500 - Auto Console UI needs to show "database config": variables, options, archives
• DB-8506 - Auto Console UI: create/update database drops db option that has a variable name without def value
• DB-8508 - Default template options JSON is malformed, omits "hostLimit"
• DB-8509 - Automation Console Login confusion on what username and password to use
• DB-8511 - Mgr can't stop a managed db that doesn't have processes
• DB-8513 - SEG FAULT in findInstance from applyObjectAvailable - Support #3800
• DB-8531 - Crash due to inconsistent root index atom
• DB-8539 - Java 6 Deprecation: doc about deprecation in 2.1.1
• DB-8541 - num of unreachable SMs also subtracted from max TE
• DB-8542 - add FINE logging to enforcer getProcessesToStart()
• DB-8551 - bad process spec or unresolved var of next process prevents all other processes to start
• DB-8552 - JUL logging: only simple print class name, not full name w/ pkg
• DB-8555 - incorrect timeout math in java mgmt client ClientSession.callService()
• DB-8567 - Storefront on MacOS doesn't work the first time for me
• DB-8579 - Manager 'show database config' NPE if neither managed nor has processes
• DB-8582 - Database state is dropped during rolling upgrade
• DB-8590 - Support empty log
• DB-8594 - Doc: alt-thread model is now the default; --alt-thread option no longer accepted
• DB-8595 - Don't use "commitIndex" from the log, always use from the state
• DB-8607 - Management CLI not properly formatting output for show template(s)
• DB-8608 - Don't display templates to stdout when output file is specified
• DB-8615 - restsvc uses domain name as domain user if .yml has blank "username"
• DB-8627 - Search doc from Admin Center searches dev center not doc
• DB-8633 - Two brokers, shutdown one with rSoS can leave the raft configuration broken forever
• DB-8640 - template language: tag constraint value should allow a variable with default value
• DB-8647 - Wrong help message is displayed for remove templates
• DB-8655 - Upgrade local on-disk state from 2.1 to current
• DB-8709 - help remove, help create and help update should not list template in nuodbmgr
• DB-8711 - add Manager CLI "monitor alarms" (separate from "monitor domain")
• DB-8723 - Remove use of "crash" terminology in our doc
• DB-8729 - Add 2.1.0 install files for upgrade testing
• DB-8731 - affinityBalancerTag name should be renamed
• DB-8743 - change log level INFO to FINE: com.nuodb.agent.plugin.LocalConfigurationProvider.encodeConfiguration
• DB-8747 - alarm definition changes not advertized to all other brokers in the domain
• DB-8748 - config change event not broadcasted to all brokers
• DB-8764 - Raft crash-safe write util should use a well known tmpfile, not the system temp dir
• DB-8769 - Possible NPE in checkRaft
• DB-8771 - Duplicate alarm definitions are returned by the EventingContainer
• DB-8791 - rolling upgrade will not re-install the latest stock default templates -> add Mgr 'apply defaultTemplates' ?
• DB-8809 - "diagnose domain" should continue if a process can't be accessed, and not fail/abort
• DB-8828 - Whitespace in default.properties is not stripped and leads to errors - Support #3958
• DB-8831 - mvn tests: EnforcerFailedAlarmTest, HostAlarmsTest fail
• DB-8839 - Agent/Diags process "coredump": resource leak with JniProcessCoreCollector
• DB-8842 - Metric Widget disappears from dashboard when it is edited
• DB-8844 - managed db-create: must throw if no host avail for first TE
• DB-8848 - Alarm deleted but it is still being sent
• DB-8857 - Incomplete error message for invalid database option in Automation Console
• DB-8858 - Not all historical slow queries appearing in the GUI
• DB-8868 - Auto Console UI, create db now needs to set timeout > 30s, re user feedback if engine option is bogus
• DB-8869 - Rest API stop db different from Manager shutdown (breaks UI unmanaged db stop)
• DB-8871 - Rest API NotFoundException fixes, and logging re "executing database resource request"
• DB-8872 - stats not displaying in host view (rest API error)
• DB-8891 - No metrics displaying on GUI console - Errors reported in the restsvc log
• DB-8915 - FlightsMulti test bails out early
• DB-8929 - rest api get alarm by id missing
• DB-8939 - raft.logCompactionThreshold should be RaftLogCompactionThreshold
• Issues Fixed in 2.1.0
• DB-800 - JDBC function escape sequence does not work
• DB-1051 - GRANT on ROLEs is not supported
• DB-1070 - Users are not allowed to change their own password
• DB-1086 - Granting permissions via roles does not work
• DB-1668 - conversion to "boolean" is not implemented
• DB-2841 - NuoSQL attempts to hold entire result set in memory, causing Out Of Memory error
• DB-3349 - It is possible to GRANT privileges that cannot be REVOKEd
• DB-3781 - SYSTEM.CONNECTIONS data is not reliable with alternate thread model
• DB-4176 - user creates new role and is automatically assigned that new role and will automatically have all privileges assigned to that new role by any user.
• DB-4180 - ORDER BY does not distinguish between NULLs and empty strings
• DB-4579 - Unique indexes need to calculate distinct key statistics differently from key uniqueness
• DB-4620 - Failure to match LIKE on BLOB - CAST blob_column AS STRING does not work as expected
• DB-4673 - PlatformTransaction::applyCommitAck assertion
• DB-4811 - SECURITY isn't listed as an unreserved keyword
• DB-5202 - don't tell users to use --force
• DB-5209 - create event/alert page to capture events
• DB-5216 - ENUM does not work properly with UNION DISTINCT
• DB-5561 - agent restart can cause enforcer to start 2nd SM before 1st has reconnected to agent
• DB-5728 - Stack trace collection does not work on Ubuntu 11 and above
• DB-5776 - LIMIT N,M does not work correctly
• DB-6160 - Statement clean-up when connection is closed is very slow
• DB-6273 - SEGV in DynamicHashTable::insertHelper
• DB-6314 - Aggregate histograms should have a non-NULL maximum upper bound
• DB-6343 - SEGV in bitmap_set (jemalloc)
• DB-6409 - Socket::setSendTimeout ignores any error
• DB-6426 - Slow SELECT performance on 2.0.4 - Support #3167
• DB-6442 - explorer execute from file option not clear on what it is executing and doesn't return result set in result window
• DB-6474 - alter table add column not null default value will return error if there are columns defined as not null in the table - support #3201
• DB-6540 - If unable to properly set "Transparent Huge Pages", then issue warning in log and halt
• DB-6545 - Transparent Huge pages: Amend documentation with more options, including how to permanently disable
• DB-6548 - Views are not copying along the collation from the base table
• DB-6593 - MBeans should follow pkg name convention: "NuoDB" -> "com.nuodb"
• DB-6681 - upgrade from using datatables.js to backgrid.js to support server/client side paging
• DB-6720 - 2.0.5 SHOW gets error with 2.0.4 db
• DB-6752 - rename table undocumented
• DB-6753 - RENAME TABLE does not properly handle sequences
• DB-6888 - sql-params seems to overwrite write buffer with sql-statements
• DB-6912 - No way to increase the # of histogram index buckets
• DB-6915 - Connection:transaction must be modified under lock
• DB-6939 - cleanup warnings in Rest API annotations
• DB-6944 - loadLastWrites creates an empty catalog directory for system tables
• DB-6945 - Catalog's last writes times are updated during recovery.
• DB-6947 - the SQL EXPLORER is generating DDL for create table incorrectly, adding a DEFAULT keyword
• DB-6953 - Hibernate example instructions and pom are out of date
• DB-6974 - TreeVector::Iterator doesn't efficiently skip non-existant leaves
• DB-6981 - duplicate log messages when laptop hibernates with running engine procs
• DB-7006 - IndexStatistics::finalizeStats assert ASSERT(indexNodeCount >= 0)
• DB-7012 - Rest Svc: catch guava ExecutionException from metrics cache, throw as IOExc
• DB-7036 - SEGV in Engine::logger at Engine/Engine.cpp:880 during all multihost benchmarks
• DB-7038 - SM Crash PlatformRecords::removeFailedRecords Support #3303
• DB-7039 - IndexKey assertion failed 'keyEncoding != NULL'
• DB-7061 - Out of range number causes crash in DynamicKey::boundsExceeded
• DB-7072 - Auto Console UI: new Agent or new Database don't show up in UI unless user refreshes browser
• DB-7076 - failure of enforer to create db and start 1st proc leaves db entry in a unrecoverable state (missing UUID)
• DB-7087 - ASSERT(bucketOffs >= 0 || bucketIdx >= (rootBounds->maxSize - 1));
• DB-7089 - Double->int conversion fails on indexed condition
• DB-7092 - SocketPoller needs to be closier
• DB-7099 - SEGV in ResultSet::next at SQL/ResultSet.cpp:547 during DBT2_10 (or _1)
• DB-7101 - ASSERT((upperBound == NULL || upperBound->compare(keyLength, key, id) > 0) || isIndexSplitting()) in PlatformIndex::broadcastAdd at Platform/PlatformIndex.cpp:2503 during ShoutInsert_6
• DB-7103 - SigarContainerImpl.setLoadLibraryPath grows every agent start
• DB-7104 - system.connections entries are not persisting for queries that are running
• DB-7120 - getIdentiferQuoteString incorrectly returns a space character
• DB-7121 - Lazy cardinality updates and analyze table conspire to lie
• DB-7131 - Unsafe to start Agent while Broker is starting
• DB-7132 - Peak Memory use during sync exceeds --mem by x2.5 - causes OOM Sniper to kill SM
• DB-7157 - SEGV in isLocked at Platform/Sync.h:51
• DB-7159 - Expired license causes broker to not start
• DB-7166 - nuowebservice function stand-alone without failing to get header from rest svc
• DB-7173 - drop table allows you to drop a table if privs have been grants to a user and/or a role
• DB-7208 - Somewhere on SQLListener::executeClientMessage socket exception isn't caught
• DB-7252 - Doc for GRANT is incorrect re. ROLEs
• DB-7272 - SYSTEM.CONNECTIONS shows negative numbers for RUNTIME
• DB-7331 - Fix /console reference paths
• DB-7356 - request to have Agent/Broker "heartbeatPeerTimeout" stop warning after timeout
• DB-7362 - index key encoded binary data (and possibly arbitrary precision data) can contain nulls in the data... they must be escaped
• DB-7363 - need to add quantum size parameter to the nuosql help commands: create sequence and alter sequence
• DB-7374 - Number of valgrind leaks in the platform layer
• DB-7377 - ResultSet leak in FOR SELECT
• DB-7379 - ASSERT(object->getObjectType() == objType || (object->getObjectType() == OBJECT_MASTER_CATALOG && objType == OBJECT_CATALOG));
• DB-7388 - PlatformData has multiple locking issues when accessing descriptors
• DB-7394 - rest svc isn't avail until wars are loaded
• DB-7403 - Auto Console UI: edit widget size hangs in dialog
• DB-7404 - Auto Console UI: reconnect retry doesn't work anymore
• DB-7405 - client connected broker (Baton) can NPE with null address
• DB-7412 - auto console UI: if there's no database, there's no "add database" action
• DB-7413 - compile heavy load dominiated by malloc and free - need a simple stats cache
• DB-7417 - Potential memory leak in RemotePassword.cpp
• DB-7426 - Poleposition/TPCC PlatformIndex validation failure
• DB-7427 - can't load sigar when running agent with -jar NuoAgent/target/nuoagent-2.0-jar-with-dependencies.jar
• DB-7428 - warn if agent -bin-dir doesn't find nuodb exe
• DB-7434 - package installer, windows: restart, quickstart fails to start SM
• DB-7440 - Possible NPE on graceful shutdown
• DB-7444 - PlatformRecord::backoutRecord needs to relock syncPtr after broadcast
• DB-7446 - Managed database creation does not honor tags
• DB-7448 - Tagging a node does not start a TE process as expected
• DB-7457 - Auto Console UI doesn't start up, NPE in ConnectedProcess.queryProcess, querying for slow queries
• DB-7466 - race between sigar reconnect timer and simple restart timer
• DB-7469 - Crash in NBitmap::init
• DB-7492 - RQG caused crash in Transaction::getTransactionId
• DB-7499 - nuodb.exe can hang when not handling error from the broker
• DB-7502 - Peer=CSV needs to get removed, for Brokers
• DB-7507 - default.properties file is world readable
• DB-7510 - Auto Console UI: refresh interval of 1 min is too long
• DB-7519 - agent jvm crash due to sigar, in sigar_disk_usage_get
• DB-7524 - Auto Console UI: uses cpu idle metric for "CPU (total)"
• DB-7539 - PlatformTable::validateContent calls getPtr using shared lock.
• DB-7568 - Crash in CostModel::cardinality
• DB-7571 - Index selection in outer joins doesn't use parameter values
• DB-7587 - "peer=self" fails on restart on centos due to address in use
• DB-7594 - peer=self shutdown restart needs to skip removeSelf
• DB-7596 - No Data Available message - font is too big
• DB-7599 - Window resizing doesn't work
• DB-7607 - The Actions widget can be out of line in the dashboard widgets
• DB-7608 - Syntax problems in the run-nuorestsvc.cmd script on Windows
• DB-7609 - Installing 2.1 over a 2.0x installation does not update the Templates
• DB-7614 - numbers silently losing precision - probably in nconstant
• DB-7622 - Choosing the Domain link can go to different places
• DB-7654 - too large numbers fail on indexed condition with overflow error message... shouldn't
• DB-7670 - default templates should be displayed first followed by custom templates
• DB-7671 - hide pie chart renderer selection
• DB-7676 - flickr when non-grid based list views update
• DB-7682 - rephrase "Welcome to the NuoDB Console" to legacy
• DB-7683 - in list processing of numeric types with different scale than table type is broken
• DB-7705 - remove users widget from #dashboard
• DB-7716 - Auto Console UI: host detail page doesn't show region (only under Tags tab)
• DB-7720 - Broken link in nuodb doc.
• DB-7721 - DUAL is listed under SYSTEM TABLES
• DB-7757 - PlatformIndex::prunePendingInserts ASSERT(elem->object->wasPruned);
• DB-7784 - Question/problem with Quickstart
• DB-7785 - shallow optimization doesn't work when other constants are present in the projection
• DB-7787 - Agent log path is not documented
• DB-7790 - If DSM Resync fails the barrier is stuck until the agent restarts
• DB-7827 - Metrics DAO doesn't reset on host address change
• DB-7834 - Crash in dynamic interval optimization when supplying invalid parameter values
• DB-7855 - Automation console screen not wide enough, doesn't show actions
• DB-7857 - create temp table/drop temp table causes database context to be invalidated
• DB-7868 - SocketPoller hang take 3
• DB-7871 - PlatformRecords::removeFailedRecords !isChairman assertion
• DB-7884 - Agent should log more stuff at startup
• DB-7888 - Delete a host tag in Auto Console
• DB-7892 - Auto Console Cancel/Submit versus Close/Submit
• DB-7912 - SMs with different data can have the same LastWrite
• DB-7916 - Massive IO causes index creation slowness
• DB-7927 - Potential double free in SocketPoller
• DB-7931 - Auto Console UI: edit db to change template; never reflected on db detail page
• DB-7932 - auto console UI: create/edit database 'variables' are wrong; breaks edit from single host to other template
• DB-7934 - Index statistics mismatch.
• DB-7942 - Refreshing browser from Notifications or settings takes you to the main dashboard
• DB-7956 - Auto Console UI: stats alarm breach period should be in min not seconds
• DB-7968 - Possible thread pool leak in EventEnforcer
• DB-7970 - Auto Console UI: stat alarm details: signal time as date; entityId resolved, breach duration in min
• DB-7975 - Auto Console UI: drop down for Stat Alarm metric should match the Metric Widget, e.g. "OS-cpuTotalTimePercent" vs. "CPU"
• DB-7980 - duplicate index errors when site is loaded with high concurrent html POSTs.
• DB-7984 - NodeFailed alarm doesn't include the error message, only host where node failed
• DB-7988 - Cannot use nuodbmgr after broker "SEVERE ... Failed to notify nodeStateChanged event" error
• DB-8002 - Broker from NuoDB v1.1 has no stableId, causes NPE in com.nuodb.agent.service.PeerService.handleConnection
• DB-8036 - Automation cold restart should use the same ArchiveHistory code as mgr capture/restart
• DB-8045 - break up "Description" key/Tag in durable config
• DB-8053 - Hide journal-buffer-size and journal-sleep-interval-ms parameters
• DB-8060 - EC2 demo with 12 hosts shows incorrect number of processes in UI
• DB-8062 - When run without --full, nuochk may stop early walking indexes
• DB-8063 - RH Linux nuoagent lock file name begins with "S98"
• DB-8065 - metric widget aggregation func not leveraged on update
• DB-8069 - alarms & alarms definition update not working
• DB-8077 - selecting metrics outside of dashboard (database list/detail, host list/detail, region list/detail) does not work
• DB-8081 - Process configuration information displayed in GUI is not complete
• DB-8082 - database/region/host detail page re-draw
• DB-8087 - active and historical slow queries only updating with global state
• DB-8093 - active alarms entity id persists after entity not available
• DB-8100 - filter active slow queries
• DB-8101 - fix process detail page badly formatted
• DB-8106 - Storefront stats get out of sync across regions
• DB-8111 - When a syncing SM receives an available for an atom it doesn't have yet it will try to reload it
• DB-8118 - duplicate value in unique index www_comment when bombard posts
• DB-8119 - TE crashes Assertion `sqlContext' failed.
• DB-8123 - Batch update can crash the TE
• DB-8125 - Problem with index encoding of date/times
• DB-8129 - upgrade from 2.0.x to 2.1: need to move aside ./cfg so that --clean-raft is really clean
• DB-8139 - Filter against fullCollection b/c of pagination
• DB-8148 - Only log "disable autostart, peer joined" for the first peer join
• DB-8150 - Connected agents need to be advertised on RaftPeerService ConnectRunnable connections
• DB-8156 - Storefront does not permit the configuration of a non-default rest-api user/password
• DB-8158 - isChairman null assertion
• DB-8159 - Instance can be NULL and the incarnation can be greater than message incarnation in applyObjectAck
• DB-8161 - Index atom GC'd immediately after being returned
• DB-8165 - NoOpEvent DAO not working .. doesn't kick enforcer
• DB-8170 - new archive-history fix ( DB-7912) ignores archive-not-found replies
• DB-8176 - Failover deadlock
• DB-8186 - leak in rest service, reconnect, AlarmMonitor
• DB-8188 - Broker OOM, EventingService.StatsReporter sending stats/alarms to mgmt client(s)
• DB-8189 - core during Database cleanup during shutdown
• DB-8190 - Windows package needs to run mvn clean
• DB-8192 - Auto Console UI: EnforcerFailed alarm details chops of reason string due to quotes
• DB-8214 - range is broken in list & detail views for resources
• DB-8217 - Broker shut down after: invalid entry response: NewNode
• DB-8219 - Rest Svc HostModel.sorted() can NPE if region tag is missing
• DB-8221 - rest api, get processes/hosts: need filterBy hostname
• DB-8228 - nuodbmgr typo, "Missing required paramater"
• DB-8229 - TE and SM Assertions v2.1 build 10 (beta) - Support #3696
• DB-8231 - Hosts view only showing the statistics from one host
• DB-8239 - agent params: add/document --reset-broker-state (undocument --clean-raft)
• DB-8245 - nuodbmgr add database error message
• DB-8254 - Peer vs Node MBean ON naming inconsistency re host/address/port
• DB-8268 - Connections made during peer=self restart that succeed will stay open through the restart
• DB-8281 - Manager shutdown timeout confusion: "shutdown: Local timeout 0 must be longer than remote timeout 120000"
• DB-8282 - Manager shutdown of managed database can't be called twice, "was already stopped"
• DB-8283 - Syncing SM can get request for atom it doesn't have yet
• DB-8285 - diagnose causes crash in TE
• DB-8286 - Rest Svc db shutdown not allowing soft shutdown; not providing params
• DB-8295 - when logging into Automation Console, directed to #error page
• DB-8296 - historical slow query ellapsed time is always "a few seconds"
• DB-8297 - logout of REST API should stop polling of resources
• DB-8303 - Failure to process chairman messages on MasterCatalog
• DB-8310 - nuodbmgr: unknown startup error for THPs (and others)
• DB-8316 - missing finally/close in com.nuodb.ui.TrayMonitor.OnCheckNewVersion.getVersionFromWeb()
• DB-8318 - Change PeerMembership remove semantics to "remove if not last"
• DB-8319 - remove log-everything in the TrayMonitor
• DB-8320 - Encoding on system tables... something seems to be broken
• DB-8324 - automation, SM min/max: known archive location should be first candidate
• DB-8329 - broker stats reporting can cause OOM if slow mgmt client is slow/stuck draining
• DB-8330 - If a database configuration does not have any options specified in the durable config the Options section is not displayed in the GUI
• DB-8334 - duplicate peer on restart, esp w/ "peer" taking precedence over last known state
• DB-8340 - Logging.setLogging() is not thread safe
• DB-8341 - no stacktrace for "initial handling failed: No such database: Storefront "
• DB-8347 - Checking of duplicate indexes - statement wasn't closed
• DB-8349 - SWIFTS Beta database restart fails with error: "Database password failed on entry"
• DB-8350 - "RestAPI: error executing region resource request: null"
• DB-8361 - TE crash in PlatformTransaction::enterOperation
• DB-8363 - Upgrading to v2.1 does not add new flags to the default.properities file.
• DB-8366 - agent peer ping timeout might be false negative; need to revert auto-session-close
• DB-8373 - Raft configuration needs to properly account for altAddresses
• DB-8381 - DatabaseStarted" and "DatabaseStopped" needed to be added to the UI.
• DB-8388 - NPE: null value for attribute: Value (due to alarm def / alarm?)
• DB-8389 - Broker doesn't complain if metric alarm def uses unknown metric
• DB-8396 - SM dies because connecting TE failed authentication.
• DB-8398 - Immediately convert to candidate on raft bootstrap
• DB-8404 - App menu issue on Win8/IE10
• DB-8411 - suppress old console logging when broker isn't avail
• DB-8427 - alarm processing for Node event, incorrect matching on dimension "Host"
• MIG-3 - migrator is not pulling schema qualified reference table name for foreign key DDL
• MIG-8 - migrator is not pulling the correct catalog/schema for sql server
• MIG-16 - migrator not accepting passwords with a comma character.
• MIG-39 - the nuodb-migrator.bat file needs to be updated with the new class path for the bootstrap file, name was changed
• MIG-48 - migrator is not exporting schema DDL for indexes, primary keys and foreign keys only
• MIG-62 - LONG RAW type with code -4 is generated with incorrent length of 0
• MIG-63 - NCLOB migration for Oracle getting errors
• MIG-64 - NVARCHAR2 migration for Oracle getting errors
• MIG-65 - NCHAR migration for Oracle getting errors
• MIG-68 - TIMESTAMP WITH LOCALTIMEZONE migration for Oracle getting errors
• MIG-81 - migrator aborting attempt to load platform28 data due to invalid XML character
• MIG-82 - migrator not migrating the table correct....missing the first several columns.
• MIG-87 - migrator is converting oracle functional index as a column with NULL data type - SUPPPORT #3464
• MIG-88 - MigratorTest.testShoutTVMigration fails with "an index on these columns already exists"
• MIG-94 - SQL Server 12.0.2 Type Mappings to NuoDB 2.1 via Migrator Are Incorrect for Date
• Improvements & New Features 2.1.0
• DB-4262 - integrate OS/Sigar stats with mgr "monitor hosts"
• DB-4323 - Front end needs a Symbol class (distinct from String)
• DB-4326 - register stats in agent as MBean
• DB-4531 - revised automation/admin db bootstrap
• DB-4533 - Ability to generate Rest Svc documentation (internal drop, not 1.0)
• DB-4930 - When running under valgrind atom GC never happens
• DB-5029 - show command should show foreign key constraints
• DB-5035 - DBA-USER should be a super user with all privs. Appears to be just a regular user.
• DB-5098 - User interface screen real estate not optimal
• DB-5115 - clear error message when old versions cause startup failure
• DB-5118 - implement product-quality affinity balancer
• DB-5119 - implement generic tag-based database balancer
• DB-5148 - Agent MBeans, rename ObjectName ... NuoDB:type=Choruses,name=foo
• DB-5388 - SQL - Optimizer road map (part 1)
• DB-5396 - Admin - Complete high-level, low-level design for re-architecture, and start implementation.
• DB-5448 - Manager: show/edit Tags
• DB-5489 - automation / enforcement fixes
• DB-5505 - Agent, Rest: Event Service for alarm definitions, alarms
• DB-5892 - Swifts revised installation behavior (no auto-start, consistent naming, ask to auto-start)
• DB-6071 - event svc: add stats/metrics computing cache
• DB-6227 - Valgrind reports leak in AgentListener::messageReceived
• DB-6272 - ability to create a managed database from an existing archive(s)
• DB-6278 - broker peering: ensure that connecting agent has unique stableId
• DB-6289 - Join plan: Display histograms via a pseudo table.
• DB-6308 - Storefront Demo - does not scale well
• DB-6510 - Domain State Machine
• DB-6547 - Field, Domain should use FieldType to keep track of the attributes of a field
• DB-6599 - remove UPGRADE and RECONNECT commands from the nuosql HELP command list
• DB-6612 - Event Service/Alarms Definition UI Tasks
• DB-6615 - SHOW with no args from non-nuosql client should be have "similarly" to SHOW from nuosql
• DB-6619 - Need introductory text for documentation
• DB-6622 - Rest Svc: alarm cache with simple filter/search/order/paging API
• DB-6659 - remove orange 'create database' button from header and move to under 'Databases' list, 'Actions'
• DB-6676 - need to have ability to manipulate host tags in host detail page
• DB-6706 - flexible grant syntax
• DB-6709 - new integrated console with 5 tabs: homepage, auto console, legacy console, sql expl, storefront
• DB-6740 - nuosql getEffectivePlatformVersion()
• DB-6783 - PHP PDO Driver needs support to take a list of brokers.
• DB-6796 - Add PHP PDO Driver tests to Bamboo plan PHP PDO Driver
• DB-6802 - Add timestamp to nuodbmgr monitor output
• DB-6807 - disable License enforcement
• DB-6853 - automation: process start & host tags, vars, engine options
• DB-6924 - Integrate shared header: QuickStart
• DB-6925 - Integrate shared header: Automation Console
• DB-6926 - Integrate shared header: Legacy Admin Console
• DB-6927 - Integrate shared header: SQL Explorer (includes sidebar work)
• DB-6929 - Auto Console: embed "Explore" actions where appropriate
• DB-6930 - SQL Explorer: handle "Explore" params from Automation Console
• DB-6931 - Package Auto Console as war and update nuowebconsole.jar to automatically load it at /console context
• DB-6932 - System tray: update menu item and link to point to Automation Console
• DB-6985 - Stats reporting: use a subset of the 90+ engine stats to store and aggregate
• DB-7037 - Alarm Roundtrip REST API testing
• DB-7077 - Add more logging around socket() closures on Engine side
• DB-7116 - endless recursion with getVolatileContext() in Statement::finishQueryStats()
• DB-7125 - Document engine stats
• DB-7143 - event service: expose alarms as JMX Notification
• DB-7220 - Raft MS6: tests; peer and shutdown behavior
• DB-7227 - linux installer: print instructions for auto-start, but don't auto-start
• DB-7229 - windows installer: ask user if services should be auto-start (default is not auto-start)
• DB-7230 - rename autoconsole service to restsvc
• DB-7232 - rolling upgrade 2.0 to 2.1 is NOT supported
• DB-7273 - QuickStart has styling issues
• DB-7333 - rephrase : "complete your install and launch the NuoDB Admin Home"
• DB-7445 - API should allow process termination for managed database processes
• DB-7459 - Modify RemConnection to support a list of brokers to connect.
• DB-7543 - rest API: add filter/query param to /api/1/processes
• DB-7644 - Storefront Swifts "fit and finish"
• DB-7747 - UI should not instruction user to run "nuodb --help"
• DB-7781 - ability to have enforcer not trigger on domain events
• DB-7854 - periodically re-connect rest svc to broker to get fresh domain state (stale state protection)
• DB-7899 - Improve hostname/IP auto-detection ability
• DB-7979 - Mgr: add Alarm/Definition CLI
• DB-8040 - max SM requirements should be limited by number of known archives or number of SM procs
• DB-8047 - Refactor code that manipulates RankedTableMap objects into a class of its own
• DB-8127 - add EnforcerFailed alarm
• DB-8138 - add EnforcerFailed alarm to UI
• DB-8166 - remove legacy thread model from the product
• DB-8191 - add Node "Status" to Node MBean
• DB-8216 - Disable statement cache
• DB-8224 - improve Manager CLI interactive mode to avoid/hide HOST/REGION variables
• DB-8266 - if broker's "altAddress" matches its own "peer", then short-curcuit peer=self shutdown/restart
• DB-8274 - StatsCache logging is too verbose
• DB-8278 - Print raft serverlist in order on startup
• DB-8306 - Obsolete process memory details
• MIG-10 - Migrator always uses a fixed file name for all logs - /tmp/nuodb-migrator.log
• MIG-30 - Make Migrator builds run travis acceptance tests with master
• MIG-33 - improve migrator tool documentation
• MIG-38 - add meaning error codes and / or messages for the migrator tool
• MIG-51 - the migration tool needs to have version flag that is meaningful
• MIG-61 - Automated testing of Oracle migration of BFILE type
• MIG-69 - Need automated testing for DB2 DEC and NUM types
• MIG-70 - Need automated testing for DB2 DECFLOAT type
• MIG-71 - Need automated testing for DB2 XML type
• MIG-78 - Migrator Load Function Needs to Support Thread Option
• MIG-83 - Version flag needs to be integrated into product build script
• MIG-84 - Update NuoDB Drivers - CDMT to work with parallel load
• MIG-85 - Weekly tests for parallel load of large databases
• MIG-86 - Update Migrator performance tests to work with parallel load
• MIG-89 - document the parallel load migrator tool version
• MIG-92 - option to migrate a list of tables using a wildcard