
|
If you were logged in you would be able to see more operations.
|
|
|
|
Environment:
|
Windows XP, firebird 2.5 SS, Delphi + UIB components
|
|
| Planning Status: |
Unspecified
|
|
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
|
|
Description
|
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 |
Show » |
|