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-issue-importer opened this issue May 11, 2012 · 6 comments

Comments

@firebird-issue-importer

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-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented May 12, 2012

Modified by: @hvlad

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

Version: 2.5.0 [ 10221 ]

assignee: Vlad Khorsun [ hvlad ]

@firebird-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented May 12, 2012

Commented by: @hvlad

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

@firebird-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented May 12, 2012

Modified by: @hvlad

Component: Engine [ 10000 ]

Component: TRACEMGR [ 10140 ] =>

@firebird-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented May 12, 2012

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-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented Apr 23, 2013

Modified by: @pcisar

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

@firebird-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented Jan 18, 2016

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
Linked pull requests

Successfully merging a pull request may close this issue.

None yet
2 participants