Trace shows info only after 2nd (repeated) .sql run (FB must be restarted
before this)
--------------------------------------------------------------------------------------
Key: CORE-5476
URL: http://tracker.firebirdsql.org/browse/CORE-5476
Project: Firebird Core
Issue Type: Bug
Components: TRACEMGR
Affects Versions: 4.0 Alpha 1
Reporter: Pavel Zotov
1. Create following trace config:
===
database = %[\\/]security4.fdb
{
enabled = false
}
database = #((%[\\/](e40).fdb)|(e40))
{
enabled = true
time_threshold = 0
include_filter = "%(select x from test where x = ?)%"
exclude_filter = "%(execute block)%"
log_statement_finish = true
}
===
2. ::: NB ::: RESTART Firebird instance.
3. Create .sql:
===
recreate table test(x int);
insert into test(x) values( 123 );
commit;
set term ^;
execute block as
declare n int = 3;
declare c int;
begin
while( n > 0 ) do
begin
execute statement ( 'select x from test where x = ? rows 1' ) ( 123 )
into c;
n = n - 1;
end
end^
set term ;^
quit;
===
4. Run trace session
C:\MIX\firebird\fb40\fbtracemgr -sta -c 1runtrace.conf -se
localhost/3400:service_mgr
-- and wait until 1st message will appear there:
===
Trace session ID 1 started
===
5. Run .sql:
C:\MIX\firebird\fb40\isql localhost/3400:e40 -i test.sql
You will see in the trace window only this two lines (and nothing more):
===
2017-02-03T09:18:20.7650 (176:00CF25C8) TRACE_INIT
SESSION_1
===
6. Run .sql again . You will see in the trace window all info that was expected
on previous step:
===
2017-02-03T09:19:10.8430 (176:00CF3820) TRACE_INIT
SESSION_1
2017-02-03T09:19:10.9210 (176:00CF3820) EXECUTE_STATEMENT_FINISH
e40 (ATT_99, SYSDBA:NONE, NONE, TCPv4:127.0.0.1/1166)
C:\MIX\firebird\fb40\isql.exe:1424
(TRA_237, CONCURRENCY | WAIT | READ_WRITE)
Statement 109:
-----------------------------------------------------------------
select x from test where x = ? rows 1
param0 = integer, "123"
1 records fetched
0 ms, 2 fetch(es)
===
PS.
Checked on WI-T4.0.0.519 (01-feb-2017), 32 bit, SuperServer.
It seems that only 4.0 is affected: no such problem on WI-V3.0.2.32677
(31-jan-2017).
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, SlashDot.org! http://sdm.link/slashdot
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
