Issue Details (XML | Word | Printable)

Key: CORE-3845
Type: Bug Bug
Status: Closed Closed
Resolution: Fixed
Priority: Minor Minor
Assignee: Vlad Khorsun
Reporter: Pavel Zotov
Votes: 0
Watchers: 1
Operations

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

Interruption of 'heavy query' leads to 0 ms (zero duration) in it`s statistics in trace log

Created: 11/May/12 07:42 PM   Updated: 23/Apr/13 01:53 PM
Component/s: Engine
Affects Version/s: 2.5.0, 2.5.1
Fix Version/s: 2.5.2, 3.0 Alpha 1

Time Tracking:
Not Specified

Planning Status: Unspecified


 Description  « Hide
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


 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 - 12/May/12 09:18 AM
The bug is in the engine itself, not in the utility