This is the changelog for Berkeley DB 12c Release 1 (library version 12.1.6.1).
Fixed some compiler warnings in db_conv.c. [#25086]
Fixed some null pointer crashes in the Tcl layer. [#26331]
Improved stability with several changes that prevent crashes when running db_verify against corrupt files. [#27088]
Increased the number of instances in which failchk can successfully clean the environment without requiring full recovery after a thread crashes while using Berkeley DB. [#25087]
Improved db_verify's handling of corrupted database files. [#25239]
Fixed configure bug which prevented shared library support on FreeBSD 10. [#25251]
Added PRAGMA statistics, which prints out statistics about the database and its environment. [#25550]
Added PRAGMA statistics_files, which redirects output from the statistics PRAGMA to a file. [#25550]
Internal Berkeley DB messages are now redirected to the same file where internal Berkeley DB error messages are redirected. [#25568]
Fixed a bug that could cause a client undergoing internal initialization to fail to request all the necessary logs for a correct recovery. The major symptom of this bug was that some client database files were left with empty pages that would later cause log sequence errors or other failures. [#25624]
Fixed a blob files related crash in db_verify. [#25920]
When opening a database handle which was created outside of an environment, if the current working directory contains a DB_CONFIG file it will no longer be processed. [#26319]
Fixed a bug where opening or renaming a compressed in-memory database may fail with the error "BDB1565 DB->set_bt_compress: method not permitted after handle's open method". [#22055][#22056]
Fixed a crash when joining compressed databases. [#22058]
Fixed a bug where a join cursor may miss the first matching pair when the database is compressed. [#22062]
Fixed two potential lock leaks in database compaction. [#23725]
Fixed a bug that can cause a DB_PAGE_NOTFOUND error during btree compaction. [#23853]
Fixed a bug where setting DatabaseEnvironmentConfig.Register had no effect. [#24094]
Improved the configure scripts for Mac OS X. [#24139]
The JDBC jar file (sqlite.jar) is now installed in the "lib" directory instead of "jar" on *nix systems. [#24139]
Fixed a bug in BDB SQL where adding a replication site immediately after opening the master environment could cause the add site operation to hang. Also fixed a bug that caused BDB SQL to lose its encryption settings when turning replication on or off on an existing environment. [#24327]
Enhanced the vote comparison routine used to select a new master. [#24433]
Fixed a crash which could occur when maximum count of lockers is reached. [#24470]
Fixed a potential memory error when executing a SQL query. [#24471]
One single transaction is now used to manage blob handles for tables that contain blobs. [#24549]
Fixed a bug that may cause an environment panic when the number of lock table partitions is too large. [#24554]
Fixed a bug where MultipleRecnoDataEntry did not encode record-number-data pairs correctly with append(). [#24555]
Fixed a bug that may cause DBcursor->put to crash when DB_AFTER is set. [#24572]
Fixed a bug where Database.setConfig() may incorrectly throw an exception. [#24585]
Fixed a bug that caused mixed-version replication live upgrades from releases prior to 6.0 to fail with an EEXIST error when in-memory databases are present. [#24597]
Corrected error paths which could cause a spurious panic when attempting to unlock a mutex that was not locked. [#24606]
When an attempt to flush a file from the memory pool fails, add an error message that includes the file name. It is likely that the file was removed or altered outside of the control of Berkeley DB. [#24606]
Removed a potential race condition when three or more threads attempt to split adjacent pages in a btree. [#24733]
Added additional page verifications into db_verify to prevent possible SEGV errors when verifying extremely corrupted database files. [#24754]
Fixed a bug where DB_ENV->open() would fail when DB_ENV->set_memory_max() was called on a 32-bit system. [#24783]
Fixed a bug where an application might hang because it could not obtain a TAS lock when running Linux on the SPARC architecture. [#24805]
Fixed a bug that may cause a crash when working with sequences. [#24826]
Fixed a crash when closing a connection to a database with sequences. [#24827]
BLOB files and encryption can now be enabled together. Note that only the data stored in the database will be encrypted; the data in the BLOB files will remain unencrypted. [#24849]
Fixed a bug that may cause a segmentation fault when multiple database handles are opened on the same database in the same transaction. [#24857]
Fixed the error "BDB0232 Error opening blob file" when using the SQL API with PRAGMA large_record_opt enabled. [#24895]
Added a new utility program db_convert. [#25086]
A 'salvage' (db_dump -r) no longer hangs on a corrupt database which contains a loop in an overflow item's chain of pages. [#18550]
Remove +u1 compiler flag from the HP-UX build and fixed related alignment issue. [#23739]
Fixed DB_RUNRECOVERY errors caused by pthreads-based mutexes. [#23965]
Allow the failchk process to call __env_refresh when necessary. [#24194] ` DB->open() now detects invalid pagesizes sooner, avoiding a potential floating point exception when a purported database file has a pagesize of 0. Added a pre-verify step to the db_dump utility. [#24217]
Fixed a bug that can cause DBcursor->get to return incorrect data when DB_GET_BOTH_RANGE flag is used. [#24220.1]
Added support for Java 8. [#24220.2]
Aborting a transaction no longer panics if a deadlock error occurs while freeing up the transaction's cursors. [#24223]
Fixed a crash which could occur when multiple BDB SQL processes repeatedly open a database file. [#24230]
Fixed a bug where db_printlog improperly handled a "No such file or directory" error condition. [#24265]
Fixed a bug that could cause a master crash in the following cases: an unencrypted client attempts to join an encrypted replication group, or an encrypted client attempts to join an unencrypted replication group. [#24288]
Fixed a bug that can cause a crash when DB_ENV->memp_stat() is called. [#24298]
Added support for arm64. [#24312]
Reduced the minimum hash table size. [#24314].
Fixed a bug where file names were not displayed correctly when a file failed to open during backup. [#24340]
Enabled cross compiling the JDBC driver. [#24347]
Fixed a crash when writing to a SQL BLOB while txn_bulk is enabled. [#24351]
DB->open() now detects invalid bt_minkey better, avoiding a potential floating point excetpion. [#24398]
Removed EnvironmentConfig.setTxnNotDurable() and Environment.getTxnNotDurable() from the Java API. This flag cannot be set on environments. [#24416]
Fixed a bug that was preventing PRAGMA cache_size from changing the size of the cache. [#24206]
Fixed a recovery bug that could cause files to end up in the wrong directory when using logs created in 5.3 or earlier. [#24169]
Creating a table in SQL will no longer fail if the database connection was opened without the SQLITE_OPEN_CREATE flag. [#24115]
Fixed a bug where an error message was not displayed back to the user correctly when sequence creation failed. [#24103]
Fixed a bug where BDB was not handling tables with multiple BLOB columns when using the SQL API. [#24092]
SQL sequence names are now case insensitive except when surrounded by quotation marks. [#23964]
Avoid incrementing the statistic DB_LOG_STAT.st_scount ("Total log file flushes") when DB_LOG_NOSYNC is in effect. [#23945]
Fixed a bug that may lead to crash when opening multiple environments in a multi-threaded program. [#23913]
Improved the way we mark a password as consumed. [#23876]
Fixed the error "BDB2074 No space available in latch table" for configurations using plain pthreads mutexes and DB_ENV->set_thread_count(). Susceptible configurations include the definition of HAVE_MUTEX_PTHREADS in db_config.h but do not define HAVE_MUTEX_HYBRID. [#23831]
Fixed a crash when MVCC and snapshot isolation are used and the system is under heavy load. [#23815]
Fixed a problem with closing a panicked environment, in which an infinite loop was possible. [#23814]
Removed Java 5 targets from Windows builds and javadoc production. [#23811]
Support for client-to-client replication of BLOB data during internal initialization has been disabled. [#23748]
Fixed a bug that may cause self-deadlock during database compaction. [#23725]
Fixed a bug in the recovery of a truncated hash database. [#23772]
Fixed a sqlite3odbc bug which may return an out-of-memory error when calling SQLGetData() on empty long columns. [#22777]
Enabling BLOB support and master leases will no longer result in unexpected DB_REP_LEASE_EXPIRED errors. [#23275]
Fixed a race condition when BLOB support is enabled with replication where message handling could fail with an ENOENT error. [#23275]
Existing SQL databases will have to be reindexed after upgrading to this release. No actions are required for non-SQL databases. Check the upgrade documentation for more details. [#23469]
Fixed a known bug in SQL where ORDER BY could return results out of order if an index is used to answer the query. [#23469]
Fixed a bug that causes a crash when opening a corrupted environment with encryption and DB_REGISTER. [#23643]
Fixed a bug that causes a crash when opening a corrupted environment with DB_FAILCHK using a BDB compiled with DIAGNOSTIC defined. [#23643]
Fixed a bug where closing a panicked environment raised an access violation and crashed the program. [#23679]
Fixed a bug where db_verify did not verify multiple files correctly. [#23692]
Fixed a bug that causes a site joining a replication group to hang or to only partially complete the internal steps necessary to join the replication group. [#23750]
Demonstrated in a sample app how to use thread-specific structures to associate a DB_EVENT_REP_PERM_FAILED event with the transaction that caused it. [#17686]
Replication Manager Preferred Master is a new option for 2-site replication groups. One site is the preferred master, which assumes the master role as much of the time as its availability permits. A preferred master replication group guarantees that transactions committed on the preferred master site will never be rolled back while also providing client failover. [#20230]
A new flag DB_FORCESYNCENV is provided for DB_ENV->close(), which forces flushing the memory mapped regions before unmapping them. [#21176]
A new API is provided to limit the Replication Manager incoming queue based on the amount of heap memory it uses. [#21481]
BLOB support is now available for environments configured for replication. [#22359]
A new version of DB_ENV->failchk() helps supports multi-process environments which use DB_REGISTER rather than a monitoring process. It is turned on with --enable-failchk_broadcast. [#22419]
Added support for Visual Studio 2012. [#22477]
CPU time needed for database backups is now reduced. [#22967]
Added BDB utilities for the Android platform. [#23079]
Added --enable-error_history support. This diagnostic tool prints a stack trace when a panic occurs. [#23119]
The new log configuration option DB_LOG_NOSYNC has been added to avoid flushing the transaction log in order to stabilize storage. This can be useful when durability across system crashes is unnecessary and all the transactions in the environment specify either the DB_TXN_NOSYNC or DB_TXN_WRITE_NOSYNC flag. This configuration setting may be made by DB_ENV->log_set_config() or a DB_CONFIG line "db_log_nosync [on|off]". [#23191]
Fixed a problem with DB_LOCKDOWN which would cause an mlock error ENOMEM on some operating systems. [#21379]
DB_ENV->close() now detaches from the environment's mmap and shared memory regions even when a panic error (DB_RUNRECOVERY) has been returned. DB_ENV->open(DB_REGISTER) detects whether a panic has occurred in the environment. If so it returns DB_RUNRECOVERY. Prior to this, the panic state was not detected, which might have caused a hang. [#22805]
Ensure that the size of memory mapped backing files are a multiple of the system pagesize. Previously the files were aligned up to 8KB boundaries, which was not adequate for systems with a 64KB pagesize. [#23290]
Improved the sizing of the environment region to better match the needs of thread tracking as specified by DB_ENV->set_thread_count(). [#24314]
Include a new field in the per-thread statistics output: the number of locked mutexes. [#25690]
Fixed a bug that left behind obsolete queue extents. [#21988]
Fixed a bug that occurred if the range keys did not fit within one database page during database partition opening. [#22280]
Corrected a buffer mutex deadlock involving off-page duplicate sets and less than full transactional isolation levels. [#22532]
Fixed a byte swapping bug that could corrupt the header of heap database pages. [#23318]
Make flag checking in sequence stat print API consistent with the other stat print APIs. [#22513]
Fixed a bug that was preventing old log files from being removed while using the SQL API. [#22521]
Updated SQL API build to be compatible with SQLite 3.8.3.1. [#23178]
Updated ADO.NET API to be compatible with System.Data.SQLite 1.0.91.0. [#23446]
Exposed flag DB_SET_MUTEX_FAILCHK_TIMEOUT in Tcl API. [#23163]
Added msgfile and msgfile_close in the Tcl API. [#31881].
Exposed DB->set_msgfile(), DB_ENV->set_msgfile() and all xxx_stat_print() in Java API.[#22691]
Exposed flags DB_REPMGR_CONF_PREFMAS_MASTER and DB_REPMGR_CONF_PREFMAS_CLIENT in Java API. [#23163]
Exposed new flag DB_LOG_NOSYNC in Java API. [#23191]
Updated DPL changes from BDB JE. [#23251]
Exposed new flag DB_EVENT_REP_INQUEUE_FULL in Java API. [#23280]
Fixed a bug that partition directories could not be set correctly via Java API. [#23410]
The class LockDetectMode has been removed. It was duplicating functionality provided in other classes and not being used. [#21248]
Exposed DB_STAT_ALLOC in PrintLockingSystemStats(), PrintLoggingSystemStats(), PrintMPoolSystemStats(), PrintMutexSystemStats(), PrintStats() and PrintTransactionSystemStats(). [#22513]
Exposed DB->set_msgcall(), DB->set_msgfile(), DB_ENV->set_msgcall() and DB_ENV->set_msgfile() to C# API. [#22799]
Exposed flags DB_REPMGR_CONF_PREFMAS_MASTER and DB_REPMGR_CONF_PREFMAS_CLIENT in C# API. [#23163]
Exposed new flag DB_LOG_NOSYNC in C# API. [#23191]
Exposed new flag DB_EVENT_REP_INQUEUE_FULL in C# API. [#23280]
Changed definition of all structs to make SWIG 2.0.12 can generate code successfully. [#23295]
Fixed a bug that db_stl library could not build using gcc-4.7 or later versions. [#22615]
Fixed a bug where, after some rare multiple-site failure scenarios including transaction rollbacks, Replication Manager could have incorrectly determined that new transactions fulfilled the acknowledgement policy. [#16624]
Acknowledgements are counted more precisely when an unelectable client is first joining the replication group and also when a master has been set to be unelectable. [#20825]
If there is already a replication process running, do not require a flag value when calling DB_ENV->repmgr_start() to start a subordinate process. [#20980]
Fixed a bug that a site could not rejoin the replication group on Windows after being removed from the group. [#22460]
When a removed site rejoins a two-site replication group with DB_REPMGR_CONF_2SITE_STRICT turned off, defer its election so that the rejoining site does not prematurely elect itself master with only its own vote when the other site is already master. [#22683]
Fixed a bug where a Replication Manager subordinate process could fail its automatic takeover as the replication process because it is unnecessarily waiting for acknowledgements from other sites before the connections to these sites are properly established. [#22998]
Fixed a bug where a client synchronization could get stuck because certain error paths were failing to release an internal lockout. [#23169]
Fixed a bug where replication group-aware log archiving might have unnecessarily kept log files after certain connection sequences between sites. [#23420]
Avoid incrementing the statistic DB_LOG_STAT.st_scount ("Total log file flushes") when DB_LOG_NOSYNC is in effect. [#23945]
Removed an environment handle mutex which was no longer needed. [#23099]
Removed the last source files of the defunct fcntl mutex implementation. [#23119]
Fix a race condition which might allow DB_ENV->failchk() to hang after it had freed a locker ID. [#24194]
Fixed a bug that ex_rep_base could not quit gracefully after receiving 'exit' command. [#16871]
Extended the ex_rep_mgr Replication Manager sample application to demonstrate the use of a thread-specific structure to associate a DB_EVENT_REP_PERM_FAILED event with its originating transaction. [#17686]
Parameter "-module" is removed from task libsqilte_jni in JDBC makefile. So libsqlite_jni library could be built in '.dylib' format on Mac OS X. [#22937]
Additional information about the cause of an error may now be displayed by configuring with --enable-error_history. [#23119]
Add one public error code 'DB_META_CHKSUM_FAIL'. [#23304]
Added build support on latest MinGW. [#23332]
A configuration warning 'Ignoring --with-cryptography flag value' is added for the non-crypto package. [#23333]
Parameter LIBSQLSO_LIBS is added to the task libsqlso_target to workaround a linking issue with the gcc 4.8.1 distributed by Ubuntu. [#23372]
Extended the Mac OS X section in the chapter 7 of the installation guide. [#23388]
Fixed PHP module to consistently use the ZEND_REGISTER_RESOURCE macro, preventing a build failure with PHP 5.5. Updated INSTALL file to note the changed location of sample output. [#23391]
Fixed a few typos in the JDBC/ODBC sections of the Windows/Unix installation guide. [#23404]
Fixed a byte swapping bug with log file operations on blob files. [#22215]
Fixed test failures on QNX with small mutex regions. [#22310]
Database containing BLOBS are now portable between machines of opposite endianness. [#22455]
Added a -D option to display output for db_dump and db_printlog. This value takes priority over DB_ENV->set_data_len() if that was called to set the length. [#22485]
Updates to PHP API to handle functional changes in PHP 5.4. [#22549]
Fixed heap databases so they can work on both big and little endian machines. [#22929]
Restructure the blob delete code to improve performance. [#22935]
Properly clean up blob meta database after aborting the creation of its parent database. [#23000]
Fixed memory alignment issues with the DB_MPOOL stats. [#23150]
Fixed a byte swapping bug with heap blob log records. [#23319]
Fixed two race condition bugs with DB_ENV->failchk(). [#23347]
Fixed memory alignment issue on Solaris. [#23571]
Fixed a bug that using Visual Studio 2010 and JDK 1.5 could generate corrupted jar files. [#23574]
Fixed a bug that specifying --with-cryptography=yes did not build the jdbc library correctly. [#23606]
The DB_AUTO_COMMIT flag is present in the DB_SEQUENCE APIs for Java and C#. This flg is no longer meaningful for these APIs and will be deprecated in the next release.
[#23469] (Fixed in 12.1.6.1.20 -- see above.) The SQL ORDER BY command on the primary key of a table can in rare cases return the results out of order if an index search is used in executing the query. For example: Create a single column table. Insert two rows with identical values. A query on the row id and the column will produce results in a different order depending on whether an index is used.