Issue Details (XML | Word | Printable)

Key: CORE-3219
Type: Bug Bug
Status: Closed Closed
Resolution: Fixed
Priority: Critical Critical
Assignee: Vlad Khorsun
Reporter: Henri Gourvest
Votes: 0
Watchers: 0
Operations

If you were logged in you would be able to see more operations.
Firebird Core

trace manager crash server with DSQL_unprepare

Created: 08/Nov/10 11:56 AM   Updated: 04/Feb/11 01:16 PM
Component/s: Engine
Affects Version/s: 2.5.0
Fix Version/s: 2.5.1, 3.0 Alpha 1

Time Tracking:
Not Specified

Environment: Windows XP, firebird 2.5 SS, Delphi + UIB components

Planning Status: Unspecified


 Description  « Hide
Trace manager crashes the server while preparing an previously unprepared statement using DSQL_unprepare option.

the conf file:
=========

<database %[\\/]employee.fdb>
enabled true
 include_filter %(SELECT|INSERT|UPDATE|DELETE)%
 log_statement_prepare true
 log_statement_free true
 log_statement_start true
 log_statement_finish true
 log_connections true
 log_transactions true
</database>

in UIB
=====

  with TUIBQuery.Create(UIBTransaction1) do
  try
    SQL.Text := 'SELECT * FROM COUNTRY;';
    Open(False);
    // ...
    Close(etmStayIn); // FreeStatement(DSQL_unprepare)

    SQL.Text := 'SELECT * FROM CUSTOMER;';
    // it crashes while repreparing the statement using the same statement handle
    Open(False); // Prepare(unprepared statement handle)
    // ...
    Close(etmCommit);
  finally
    Free;
  end;

in firebird.log
==========

PCHENRI (Client) Mon Nov 08 12:32:09 2010
"C:\Program Files\Firebird\Firebird_2_5\bin\fbserver.exe": terminated abnormally (4294967295)

the firebird trace manager console
===========================

C:\Program Files\Firebird\Firebird_2_5\bin>fbtracemgr.exe -SE service_mgr -START
 -NAME test -CONFIG ..\fbtrace.conf -user SYSDBA -password masterkey
Trace session ID 1 started
2010-11-08T12:53:06.7810 (2564:014BE01C) TRACE_INIT
        SESSION_1 test


2010-11-08T12:53:06.7810 (2564:014BE01C) ATTACH_DATABASE
        C:\PROGRAM FILES\FIREBIRD\FIREBIRD_2_5\EXAMPLES\EMPBUILD\EMPLOYEE.FDB (A
TT_49, SYSDBA:NONE, WIN1252, XNET:PCHENRI)
        C:\Documents and Settings\henri\Mes documents\RAD Studio\Projets\Project
92.exe:2680

2010-11-08T12:53:06.7810 (2564:014BE01C) START_TRANSACTION
        C:\PROGRAM FILES\FIREBIRD\FIREBIRD_2_5\EXAMPLES\EMPBUILD\EMPLOYEE.FDB (A
TT_49, SYSDBA:NONE, WIN1252, XNET:PCHENRI)
        C:\Documents and Settings\henri\Mes documents\RAD Studio\Projets\Project
92.exe:2680
                (TRA_199, CONCURRENCY | WAIT | READ_WRITE)

2010-11-08T12:53:08.1400 (2564:014BE01C) PREPARE_STATEMENT
        C:\PROGRAM FILES\FIREBIRD\FIREBIRD_2_5\EXAMPLES\EMPBUILD\EMPLOYEE.FDB (A
TT_49, SYSDBA:NONE, WIN1252, XNET:PCHENRI)
        C:\Documents and Settings\henri\Mes documents\RAD Studio\Projets\Project
92.exe:2680
                (TRA_199, CONCURRENCY | WAIT | READ_WRITE)

Statement 155:
-------------------------------------------------------------------------------
SELECT * FROM COUNTRY;

      5 ms

2010-11-08T12:53:08.1400 (2564:014BE01C) EXECUTE_STATEMENT_START
        C:\PROGRAM FILES\FIREBIRD\FIREBIRD_2_5\EXAMPLES\EMPBUILD\EMPLOYEE.FDB (A
TT_49, SYSDBA:NONE, WIN1252, XNET:PCHENRI)
        C:\Documents and Settings\henri\Mes documents\RAD Studio\Projets\Project
92.exe:2680
                (TRA_199, CONCURRENCY | WAIT | READ_WRITE)

Statement 155:
-------------------------------------------------------------------------------
SELECT * FROM COUNTRY;


2010-11-08T12:53:08.9680 (2564:014BE01C) CLOSE_CURSOR
        C:\PROGRAM FILES\FIREBIRD\FIREBIRD_2_5\EXAMPLES\EMPBUILD\EMPLOYEE.FDB (A
TT_49, SYSDBA:NONE, WIN1252, XNET:PCHENRI)
        C:\Documents and Settings\henri\Mes documents\RAD Studio\Projets\Project
92.exe:2680

Statement 155:
-------------------------------------------------------------------------------
SELECT * FROM COUNTRY;


2010-11-08T12:53:10.7810 (2564:014BE01C) FREE_STATEMENT
        C:\PROGRAM FILES\FIREBIRD\FIREBIRD_2_5\EXAMPLES\EMPBUILD\EMPLOYEE.FDB (A
TT_49, SYSDBA:NONE, WIN1252, XNET:PCHENRI)
        C:\Documents and Settings\henri\Mes documents\RAD Studio\Projets\Project
92.exe:2680

Statement 155:
-------------------------------------------------------------------------------
SELECT * FROM COUNTRY;


connection lost to database

 All   Comments   Work Log   Change History   Version Control   Subversion Commits      Sort Order: Ascending order - Click to sort in descending order
Vlad Khorsun added a comment - 19/Nov/10 02:38 PM
Fix is committed, please confirm it using next snapshot build.