Release Notes - Sequoia - Version Sequoia 3.0 beta3 - HTML format

Bug

• [SEQUOIA-1] - LANG variable breaks error messages of XML parser
• [SEQUOIA-7] - No encoding forced on java source files in eclipse project
• [SEQUOIA-10] - xercesImpl.jar not in lib/
• [SEQUOIA-82] - commons.jar package depends on controller.core
• [SEQUOIA-93] - SSL in sequoia-driver.jar depends on package common.net (=> class not found?)
• [SEQUOIA-96] - shutdown mode 3 in CLI console is lying !
• [SEQUOIA-193] - Bug in the schema refresh for RAIDb-0
• [SEQUOIA-262] - preparedStatement("INSERT|UPDATE|...").getMetaData() fails
• [SEQUOIA-283] - Gathering Schema For Backend Is Slow
• [SEQUOIA-296] - Schema Refresh On Multiple Procedures With Same Name
• [SEQUOIA-341] - cursorname transparency issues
• [SEQUOIA-353] - Function Call That Returns View Rowtype Causes Schema Refresh
• [SEQUOIA-357] - SELECT ... FOR UPDATE parser does not update write locked tables
• [SEQUOIA-383] - weird behaviour of illegal PreparedStatement.executeUpdate("some request");
• [SEQUOIA-416] - "delete dump" Command Does Not Remove Associated Checkpoint(s)
• [SEQUOIA-419] - "purge log" Command Does Not Remove Associated Checkpoint(s)
• [SEQUOIA-442] - Out of sync database schema is kept in the request manager when all backends are disabled
• [SEQUOIA-468] - RequestManager - Cache option issue in request manager for granularity column and columnUnique
• [SEQUOIA-522] - Restore connection state does not properly handle failure after commit/rollback
• [SEQUOIA-608] - Create table statement parsing does not lock tables referenced in foreign key constraints
• [SEQUOIA-673] - There is a problem in Sequoia JDBC driver with boolean type for MySQL 5.0.16
• [SEQUOIA-744] - incorrect check on enabled backends while performing a backup of a backend
• [SEQUOIA-772] - Transactions are sometimes rolled back after they have failed over to a new controller
• [SEQUOIA-777] - Shutdown can cause (harmless) NPE in VdbWorkerThread
• [SEQUOIA-824] - Cannot safely shutdown controller after other controller fails (open transactions remain)
• [SEQUOIA-859] - Instructions on how to change the vdb user password are incorrect
• [SEQUOIA-864] - Complete sequoia deadlock when trying to perfom a backup via the sequoia console. ... still waiting for 0 pending transactions to complete ...
• [SEQUOIA-886] - Improved console feedback for save configuration and restore log
• [SEQUOIA-889] - RecoveryLog.resetRecoveryLog() does not correctly clear the last log ID after clearing the log contents
• [SEQUOIA-890] - Shutdown checkpoints are duplicated with single controller configuratoin
• [SEQUOIA-891] - Backing up and Restoring MySQL Tables with autoincrement columns
• [SEQUOIA-897] - java.sql.SQLException: Unable to get checkpoint from the recovery log (Checkpoint does not exist in recovery log)
• [SEQUOIA-905] - Transaction begin not logged in recovery log in single controller configuration
• [SEQUOIA-907] - escapeProcessing is not taken into account on database backend Statement / preparedStatement / CallableStatement
• [SEQUOIA-908] - SQL Server bracketed identifiers support
• [SEQUOIA-909] - Sequoia does not support INSERT INTO table DEFAULT VALUES syntax
• [SEQUOIA-913] - MySQL Backuper does not handle autoincrement in tables that have quoted name "`"
• [SEQUOIA-927] - Bug in demo-distributed-raidb1.bat
• [SEQUOIA-932] - Streamed ResultSets can be leaked in the controller

Improvement

• [SEQUOIA-50] - adding some kind of "Run Command" feature
• [SEQUOIA-51] - Unable to get a "view" of a virtual database without being connected to all its controllers
• [SEQUOIA-52] - replace EOL by semicolon as the command terminator
• [SEQUOIA-106] - Optimize memory use for byte arrays, blobs and encoders
• [SEQUOIA-121] - Mark non-externalized String
• [SEQUOIA-126] - DeadlockDetectionThread (and others) included in driver jar
• [SEQUOIA-127] - common.protocol.Field depends on MetadataCache
• [SEQUOIA-143] - Blocking commands make difficult to script the console
• [SEQUOIA-147] - Octopus backuper list of databases to generate metadata for should be tunable
• [SEQUOIA-161] - don't throw NotImplementedException but some other SQLException on forbidden conversions
• [SEQUOIA-275] - Support for end-to-end batch updates
• [SEQUOIA-300] - i18n cleanup
• [SEQUOIA-366] - get rid of InetAddress.getLocalHost()
• [SEQUOIA-444] - Error log is missing information about requests that fail to execute that is critical for diagnosing/debugging
• [SEQUOIA-506] - break dependency on TCP timeouts
• [SEQUOIA-556] - Backup command should ask to be launched with force flag when only one backend is available
• [SEQUOIA-587] - Flag requests that have side effects that cannot be rollbacked
• [SEQUOIA-651] - Upgrade to Octopus 3.6.1
• [SEQUOIA-670] - Do not force schema refresh on all CREATE requests
• [SEQUOIA-783] - Enable debug and expert commands from the admin module of the CLI console
• [SEQUOIA-788] - Transparent user management
• [SEQUOIA-792] - add state to the "show backend" command
• [SEQUOIA-828] - BLOB handling in HSQL-based recovery logs
• [SEQUOIA-837] - Make macro list configurable per DB types
• [SEQUOIA-839] - Allow a shutdown in force mode to override an ongoing shutdown in safe mode
• [SEQUOIA-860] - console -q should not exist on error if -e flag is not passed
• [SEQUOIA-868] - changed default jmx service url to make it compatible with Java5
• [SEQUOIA-885] - Fetching schema is too slow on PostgreSQL when there are too many tables
• [SEQUOIA-887] - Disable JLine in non-interactive mode of the text console
• [SEQUOIA-893] - when using the console, first query seems to be slow
• [SEQUOIA-899] - Allow dumping the recovery log from the tail
• [SEQUOIA-904] - Improve recovery-log tolerance to connection timeouts or transient db connectivity errors

New Feature

• [SEQUOIA-205] - A possiblity to restart the controller inside or together with it's JVM
• [SEQUOIA-278] - Add support for Statement.cancel
• [SEQUOIA-450] - Add virtual database schema dump feature
• [SEQUOIA-659] - Add optional "VACUUM ANALYZE" parameter to PostgreSQL backupers after restore
• [SEQUOIA-699] - Make Appia the default group-communication package
• [SEQUOIA-838] - Add console commands to show/kill persistent connections
• [SEQUOIA-882] - Do you clean recovery log of a vdb when automatic resync is failing
• [SEQUOIA-888] - Add support for network detection partition and basic reconciliation
• [SEQUOIA-895] - Add an abort transaction command to the console
• [SEQUOIA-903] - Add a dump connections and a close connection commands (persistent connections only)

Task

• [SEQUOIA-328] - jmx cleanup
• [SEQUOIA-455] - Automatic protocol specs generator: implement taglets & update javadoc of Commands

The text area below allows the project release notes to be edited and copied to another document.