Interruption of 'heavy query' leads to 0 ms (zero duration) in it`s statistics
in trace log
-------------------------------------------------------------------------------------------
Key: CORE-3845
URL: http://tracker.firebirdsql.org/browse/CORE-3845
Project: Firebird Core
Issue Type: Bug
Components: TRACEMGR
Affects Versions: 2.5.1
Reporter: Pavel Zotov
session #1
=========
C:\1INSTALL\FIREBIRD\Data>isql localhost/3050:C:\1INSTALL\FIREBIRD\Data\T1.fdb
-n
Database: localhost/3050:C:\1INSTALL\FIREBIRD\Data\T1.fdb
SQL>
session #2
=========
C:\1INSTALL\FIREBIRD\Data>isql localhost/3050:C:\1INSTALL\FIREBIRD\Data\T1.fdb
-n
Database: localhost/3050:C:\1INSTALL\FIREBIRD\Data\T1.fdb
SQL> select count(*) from
rdb$fields,rdb$fields,rdb$fields,rdb$fields,rdb$fields,rdb$fields; -- this
query will runs enough time for we can switch to session #1
session #1
=========
SQL> delete from mon$attachments where mon$attachment_id<>current_connection;
commit;
session #2
=========
<< has been immediatelly interrupted >>
Trace:
#####
2012-05-11T23:45:04.1250 (580:0202B970) EXECUTE_STATEMENT_FINISH
C:\1INSTALL\FIREBIRD\DATA\T1.FDB (ATT_7, SYSDBA:NONE, NONE,
TCPv4:127.0.0.1)
C:\1INSTALL\FIREBIRD\FB_2_5\bin\isql.exe:1672
(TRA_16, CONCURRENCY | WAIT | READ_WRITE)
Statement 257:
-------------------------------------------------------------------------------
select count(*) from
rdb$fields,rdb$fields,rdb$fields,rdb$fields,rdb$fields,rdb$fields
0 records fetched
0 ms, 1 read(s), 37969951 fetch(es) -- <<<<<<<<< why 0 ms here ???
<<<<<<<<<<<<<<<<<<<<
Table Natural Index Update Insert
Delete Backout Purge Expunge
***************************************************************************************************************
RDB$FIELDS 18446943
--
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
------------------------------------------------------------------------------
Live Security Virtual Conference
Exclusive live event will cover all the ways today's security and
threat landscape has changed and how IT managers can respond. Discussions
will include endpoint security, mobile security and the latest in malware
threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
