Join Firebird!

Join Firebird Foundation to support Firebird SQL development and receive multiple bonuses

Follow Us

Select your media preference

Newsletter

Subscribe to Firebird’s Newsletter to receive the latest news

Developer's Report: Firebird Core Development
December 2009 to February 2010

December 2009

HEAD
  • Fixed bug CORE-2781 : AV in fbtracemgr when command line swithes set wrongly
  • Implement improvement CORE-2767 : Add ability to the trace plugin to configure traced services events on per-service name basis
  • Fixed bug CORE-2670 : FB 2.5 freezes during data pump operations
  • Fixed bug CORE-2783 : AV using recursive query as subquery in SELECT list and ORDER'ing by them
  • Fixed bug CORE-2797 : Problem with default value of SP parameter
  • A couple of ODS changes :
    • abandon page checksums and use page number for validation
    • PIP have now pip_used field to track number of allocated pages
    • two more flag bits per data page is now reserved on pointer page
      • implement dpg_secondary flag
      • swept flag implementation
    • implemented SCN inventory pages to make diffrential backup faster not reading pages which was not changed since previous backup. Corresponding nbackup and validation code changes also done. PAG code refactored a bit.
  • ODS related optimizations
    • make table scan skip secondary data pages
    • propagate record type to the store_big_record to allow record head be stored at the primary record page.
    • a little optimisation of mark_full() - don't call it if not necessary, don't mark PP if its flags already matched to DP flags.
  • GSTAT: More detailed statistics : fragments, big records and blobs info are now available when records analisys is performed.
B2_5_Release
  • Implement improvement CORE-2767 : Add ability to the trace plugin to configure traced services events on per-service name basis Fixed bug CORE-2781 : AV in fbtracemgr when command line swithes set wrongly Fixed bug CORE-2670 : FB 2.5 freezes during data pump operations Fixed bug CORE-2783 : AV using recursive query as subquery in SELECT list and ORDER'ing by them Backport fix for bug CORE-2797 : Problem with default value of SP parameter
B2_1_Release
  • Backport fix for bug CORE-2783 : AV using recursive query as subquery in SELECT list and ORDER'ing by them
January 2010

HEAD
  • Fixed bug CORE-2184 : Bus error on SPARC
  • Fixed bug CORE-2185 : PIP page could be marked after it was really changed
  • Fixed bug when huge memory chunk (more than 2GB) is released
  • Refactoring : extract part of MET_lookup_partner() as independent function MET_scan_partners()
  • Preserve record's flags when gathering record from fragments. Its used in prepare_update() to check if primary record was backed out.
  • Avoid possible deadlock in VIO.
  • Fixed bug CORE-2817 : If stored procedure or trigger contains query with PLAN ORDER it could fail after disconnect of attachment where procedure\trigger executed first time
  • Fixed bug CORE-2820 : Small memory leak in query with PLAN ORDER
  • Fixed bug CORE-2824 : Small memory and handles leak at every connect\disconnect
  • Update documentation
  • Make trusted auth works again.
  • Thread-safe shared page cache implementation is started.
  • Index corruptions reported by users are investigated
B2_5_Release
  • Fixed bug CORE-2184 : Bus error on SPARC
  • Fixed bug CORE-2185 : PIP page could be marked after it was really changed
  • Fixed bug CORE-2817 : If stored procedure or trigger contains query with PLAN ORDER it could fail after disconnect of attachment where procedure\trigger executed first time and bug CORE-2820 : Small memory leak in query with PLAN ORDER
  • Fixed bug CORE-2824 : Small memory and handles leak at every connect\disconnect
  • Update documentation
B2_1_Release
  • Backported fix for bug CORE-2184 : Bus error on SPARC
  • Backported fix for bug CORE-2185 : PIP page could be marked after it was really changed
  • Fixed bug CORE-2820 : Small memory leak in query with PLAN ORDER
B2_0_Release
  • Fixed bug CORE-2820 : Small memory leak in query with PLAN ORDER
  • Backported fix for bug CORE-2698 : Infinite wait in LocksCache::get
  • Fix for bug CORE-2631 : Backport fix for bug CORE-2291 (BUGCHECK 284) into v2.0.6
February 2010

HEAD (V.3.0)
  • Improvement CORE-2821 : Add indication about log size limit for trace API
  • Fixed bug CORE-2837 : Asynchronous query cancellation (via Ctrl+C) not working
  • Fixed bug CORE-2851 : problem with fb_cancel_operation
  • Fixed bug CORE-2852 : Server crash when executing syntactical wrong SQL statement with an active trace session
  • Fixed bug CORE-2586 : Non-NULL key in unique index could be not found when key is removed
  • Fixed bug CORE-2864 : Listener process of Classic Server leak handles.
  • Fixed bug CORE-2879 : Sweep could raise error : page 0 is of wrong type (expected 6, found 1)
B2_5_Release
  • Improvement CORE-2821 : Add indication about log size limit for trace API
  • Fixed bug CORE-2837 : Asynchronous query cancellation (via Ctrl+C) not working
  • Fixed bug CORE-2851 : problem with fb_cancel_operation
  • Fixed bug CORE-2852 : Server crash when executing syntactical wrong SQL statement with an active trace session
  • Fixed bug CORE-2586 : Non-NULL key in unique index could be not found when key is removed
  • Fixed bug CORE-2864 : Listener process of Classic Server leak handles. The code, removed in rev. 1.296, was and is relevant :)
  • Fixed bug CORE-2867 : SuperClassic leaks semaphores on disconnect
  • Fixed bug CORE-2879 : Sweep could raise error : page 0 is of wrong type (expected 6, found 1)
B2_1_Release
  • Backport fix for bug CORE-2586 : Non-NULL key in unique index could be not found when key is removed
  • Backport fix for bug CORE-2879 : Sweep could raise error : page 0 is of wrong type (expected 6, found 1)
B2_0_Release
  • Backport fix for bug CORE-2586 : Non-NULL key in unique index could be not found when key is removed
Vladyslav Khorsun
Dnetpropetrovsk, Ukraine
December 2009 to February 2010

December 2009

HEAD
  • Fixed bug CORE-2781 : AV in fbtracemgr when command line swithes set wrongly
  • Implement improvement CORE-2767 : Add ability to the trace plugin to configure traced services events on per-service name basis
  • Fixed bug CORE-2670 : FB 2.5 freezes during data pump operations
  • Fixed bug CORE-2783 : AV using recursive query as subquery in SELECT list and ORDER'ing by them
  • Fixed bug CORE-2797 : Problem with default value of SP parameter
  • A couple of ODS changes :
    • abandon page checksums and use page number for validation
    • PIP have now pip_used field to track number of allocated pages
    • two more flag bits per data page is now reserved on pointer page
      • implement dpg_secondary flag
      • swept flag implementation
    • implemented SCN inventory pages to make diffrential backup faster not reading pages which was not changed since previous backup. Corresponding nbackup and validation code changes also done. PAG code refactored a bit.
  • ODS related optimizations
    • make table scan skip secondary data pages
    • propagate record type to the store_big_record to allow record head be stored at the primary record page.
    • a little optimisation of mark_full() - don't call it if not necessary, don't mark PP if its flags already matched to DP flags.
  • GSTAT: More detailed statistics : fragments, big records and blobs info are now available when records analisys is performed.
B2_5_Release
  • Implement improvement CORE-2767 : Add ability to the trace plugin to configure traced services events on per-service name basis Fixed bug CORE-2781 : AV in fbtracemgr when command line swithes set wrongly Fixed bug CORE-2670 : FB 2.5 freezes during data pump operations Fixed bug CORE-2783 : AV using recursive query as subquery in SELECT list and ORDER'ing by them Backport fix for bug CORE-2797 : Problem with default value of SP parameter
B2_1_Release
  • Backport fix for bug CORE-2783 : AV using recursive query as subquery in SELECT list and ORDER'ing by them
January 2010

HEAD
  • Fixed bug CORE-2184 : Bus error on SPARC
  • Fixed bug CORE-2185 : PIP page could be marked after it was really changed
  • Fixed bug when huge memory chunk (more than 2GB) is released
  • Refactoring : extract part of MET_lookup_partner() as independent function MET_scan_partners()
  • Preserve record's flags when gathering record from fragments. Its used in prepare_update() to check if primary record was backed out.
  • Avoid possible deadlock in VIO.
  • Fixed bug CORE-2817 : If stored procedure or trigger contains query with PLAN ORDER it could fail after disconnect of attachment where procedure\trigger executed first time
  • Fixed bug CORE-2820 : Small memory leak in query with PLAN ORDER
  • Fixed bug CORE-2824 : Small memory and handles leak at every connect\disconnect
  • Update documentation
  • Make trusted auth works again.
  • Thread-safe shared page cache implementation is started.
  • Index corruptions reported by users are investigated
B2_5_Release
  • Fixed bug CORE-2184 : Bus error on SPARC
  • Fixed bug CORE-2185 : PIP page could be marked after it was really changed
  • Fixed bug CORE-2817 : If stored procedure or trigger contains query with PLAN ORDER it could fail after disconnect of attachment where procedure\trigger executed first time and bug CORE-2820 : Small memory leak in query with PLAN ORDER
  • Fixed bug CORE-2824 : Small memory and handles leak at every connect\disconnect
  • Update documentation
B2_1_Release
  • Backported fix for bug CORE-2184 : Bus error on SPARC
  • Backported fix for bug CORE-2185 : PIP page could be marked after it was really changed
  • Fixed bug CORE-2820 : Small memory leak in query with PLAN ORDER
B2_0_Release
  • Fixed bug CORE-2820 : Small memory leak in query with PLAN ORDER
  • Backported fix for bug CORE-2698 : Infinite wait in LocksCache::get
  • Fix for bug CORE-2631 : Backport fix for bug CORE-2291 (BUGCHECK 284) into v2.0.6
February 2010

HEAD (V.3.0)
  • Improvement CORE-2821 : Add indication about log size limit for trace API
  • Fixed bug CORE-2837 : Asynchronous query cancellation (via Ctrl+C) not working
  • Fixed bug CORE-2851 : problem with fb_cancel_operation
  • Fixed bug CORE-2852 : Server crash when executing syntactical wrong SQL statement with an active trace session
  • Fixed bug CORE-2586 : Non-NULL key in unique index could be not found when key is removed
  • Fixed bug CORE-2864 : Listener process of Classic Server leak handles.
  • Fixed bug CORE-2879 : Sweep could raise error : page 0 is of wrong type (expected 6, found 1)
B2_5_Release
  • Improvement CORE-2821 : Add indication about log size limit for trace API
  • Fixed bug CORE-2837 : Asynchronous query cancellation (via Ctrl+C) not working
  • Fixed bug CORE-2851 : problem with fb_cancel_operation
  • Fixed bug CORE-2852 : Server crash when executing syntactical wrong SQL statement with an active trace session
  • Fixed bug CORE-2586 : Non-NULL key in unique index could be not found when key is removed
  • Fixed bug CORE-2864 : Listener process of Classic Server leak handles. The code, removed in rev. 1.296, was and is relevant :)
  • Fixed bug CORE-2867 : SuperClassic leaks semaphores on disconnect
  • Fixed bug CORE-2879 : Sweep could raise error : page 0 is of wrong type (expected 6, found 1)
B2_1_Release
  • Backport fix for bug CORE-2586 : Non-NULL key in unique index could be not found when key is removed
  • Backport fix for bug CORE-2879 : Sweep could raise error : page 0 is of wrong type (expected 6, found 1)
B2_0_Release
  • Backport fix for bug CORE-2586 : Non-NULL key in unique index could be not found when key is removed
Vladyslav Khorsun
Dnetpropetrovsk, Ukraine