Firebird: Developer's Report: Firebird Core Development

June to September 2018

Make ALTER SESSION RESET throws isc_ses_reset_err when active transaction(s) present in current connection.
CORE-5832 : Implement way to reset user session environment to its initial (default) state
Fixed bug CORE-5843 : Wrong handling of failures of TRANSACTION START trigger
Another fix for bug CORE-5436 : [FB3 SC] Server hangs (under load test)
Reworked fix for bug CORE-5843 : Wrong handling of failures of TRANSACTION START trigger.
More strict fix for bug CORE-5436 : [FB3 SC] Server hangs (under load test)
Initial implementation of external connections pool
Fixed crash when broken external connection is deleted.
Fixed bug when idle external connection is about to put into idle list again.
Introduced new system privilege MODIFY_EXT_CONN_POOL to manage pool properties.
Update the documentation.
Fixed bug CORE-5847 : "Malformed string" instead of key value in PK violation error message
Add sha2 into Windows builds (vc10, vc12 and vc14)
Fixed crash when no object for grant\revoke operation.
Prevent AV when thread detaches and no modules was loaded
Fixed bug CORE-5863 : Classic process crashes when client disconnected.

Another fix for bug CORE-5436 : [FB3 SC] Server hangs (under load test)
Backport fix for bug CORE-5843 : Wrong handling of failures of TRANSACTION START trigger
More strict fix for bug CORE-5436 : [FB3 SC] Server hangs (under load test)
Fixed bug CORE-5847 : "Malformed string" instead of key value in PK violation error message
Add sha2 into Windows builds (vc10, vc12 and vc14)
Fixed crash when no object for grant\revoke operation.
Prevent AV when thread detaches and no modules was loaded
Fixed bug CORE-5863 : Classic process crashes when client disconnected.

Backport fix for bug CORE-5847 : "Malformed string" instead of key value in PK violation error message

Fixed bug CORE-5863 : Classic process crashes when client disconnected
Fixed potential crash in wnet\xnet code (see fix for CORE-5863).
Partial fix for bug CORE-5869 : Sweep can't move OIT value over 2^32, when Next already greater than 2^32 (4'294'967'296)
Fixed bug CORE-5870 : ISQL's "show database" command works wrong with 64-bit numbers
Fixed bug CORE-5872 : Database validation reports false errors "Record XXX has bad transaction" and\or "Record XXX is wrong length" when record transaction number is greater than 2^32
Fixed assertion when run test bugs.core_0805 in Classic mode
Fixed memory corruption found when run test bugs.5674 in Classic mode using debug build.
Fixed crash when run test bugs.core_5329 in Classic mode using debug build.
Correct condition when mapped file of monitoring data should be removed.
Fixed bug CORE-5844 : Firebird freeze for new connections
Merge pull request #105 from red-soft-ru/read_consistency
Restore old pre-committed logic when working with GTT's in RCRO transactions.

Fixed bug CORE-5863 : Classic process crashes when client disconnected
Fixed bug CORE-5869 : Sweep can't move OIT value over 2^32, when Next already greater than 2^32 (4'294'967'296)
Fixed bug CORE-5870 : ISQL's "show database" command works wrong with 64-bit numbers
Fixed bug CORE-5872 : Database validation reports false errors "Record XXX has bad transaction" and\or "Record XXX is wrong length" when record transaction number is greater than 2^32
Fixed memory corruption found when run test bugs.5674 in Classic mode using debug build.
Correct condition when mapped file of monitoring data should be removed.
Fixed bug CORE-5844 : Firebird freeze for new connections

Added missed record into RDB$TYPES
Update MSVC builds
Let trace plugin know about read consistency transactions
Avoid double delete of ThreadSync object
Fix incorrect reference counting for EventManager object.
Forward-ported: Avoid race condition (with AV) when YEvents object references is released concurrently.
Avoid race condition in cancel_operation() when client connection breaks immediately after op_detach.
Avoid crash due to executing already unloaded code (in attachmentShutdownThread).
Fixed bug CORE-5902 : Add Firebird Event fails with error "While isc_que_events - Failed to establish a secondary connection for event processing."
Fixed bug CORE-5898 : ROLE not passed in EXECUTE STATEMENT ... ON EXTERNAL
Merge pull request #167 from red-soft-ru/fix_mon: Restored accidentally deleted field MON$RECORD_IMGC
Add intermediate GC to the VIO_writelock
Request while running in autonomous read-committed read consistency transaction should start own snapshot.
Fixed crash when not fully initialized attachment killed by DBA.

Clear events of dead process, not our own
Avoid double delete of ThreadSync object
Fix incorrect reference counting for EventManager object.
Avoid race condition (with AV) when YEvents object references is released concurrently
Avoid race condition in cancel_operation() when client connection breaks immediately after op_detach.
Avoid crash due to executing already unloaded code (in attachmentShutdownThread).
Fixed bug CORE-5902 : Add Firebird Event fails with error "While isc_que_events - Failed to establish a secondary connection for event processing."
Fixed bug CORE-5898 : ROLE not passed in EXECUTE STATEMENT ... ON EXTERNAL
Fixed crash when not fully initialized attachment killed by DBA.
Unify memory allocation in verb_post.

MSVC15 (VS 2017) build
Fixed VS 2017 Appveyor build
Implement sub-task CORE-5913 : Add context variables with compression and encryption status of current connection
Rename MON$CONNECTION_COMPRESSED and MON$CONNECTION_ENCRYPTED to MON$WIRE_COMPRESSED and MON$WIRE_ENCRYPTED
to be inline with config settings (WireCompression and WireCrypt) and context variables (WIRE_COMPRESSED and WIRE_ENCRYPTED)
Fixed bug CORE-5911 : Connection could hung after no activity for 60 seconds
Additional fix for bug CORE-5436 : [FB3 SC] Server hangs (under load test)
Fixed bug with GTT in read-only transactions found by fbtcs test ISC_ER43_TRAN
Improvement CORE-5921 : Provide information about Global Commit Number, Commit Number of currently used database snapshot (if any)
and Commit Numbers assigned to the committed transactions.
Update documentation
Fixed bugcheck "Incorrect snapshot deallocation - too few slots", see CORE-5930

Fixed bug CORE-5911 : Connection could hung after no activity for 60 seconds
Additional fix for bug CORE-5436 : [FB3 SC] Server hangs (under load test)
Implement sub-task CORE-5913 : Add context variables with compression and encryption status of current connection

This should fix bug CORE-5910 : Server crash after kill in EDS manager destructor

Vladyslav Khorsun

Dnetpropetrovsk, Ukraine