Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

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

Closed
firebird-automations opened this issue May 11, 2012 · 6 comments

Comments

@firebird-automations
Copy link
Collaborator

Submitted by: @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

Commits: 8542319 3a6a7e1

@firebird-automations
Copy link
Collaborator Author

Modified by: @hvlad

priority: Major [ 3 ] => Minor [ 4 ]

Version: 2.5.0 [ 10221 ]

assignee: Vlad Khorsun [ hvlad ]

@firebird-automations
Copy link
Collaborator Author

Commented by: @hvlad

The bug is in the engine itself, not in the utility

@firebird-automations
Copy link
Collaborator Author

Modified by: @hvlad

Component: Engine [ 10000 ]

Component: TRACEMGR [ 10140 ] =>

@firebird-automations
Copy link
Collaborator Author

Modified by: @hvlad

status: Open [ 1 ] => Resolved [ 5 ]

resolution: Fixed [ 1 ]

Fix Version: 2.5.2 [ 10450 ]

Fix Version: 3.0 Alpha 1 [ 10331 ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @pcisar

status: Resolved [ 5 ] => Closed [ 6 ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @pavel-zotov

status: Closed [ 6 ] => Closed [ 6 ]

QA Status: No test

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

2 participants