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

Monitoring tables return incomplete information in SC/CS configurations [CORE4176] #4502

Closed
firebird-issue-importer opened this issue Aug 9, 2013 · 5 comments

Comments

@firebird-issue-importer
Copy link

firebird-issue-importer commented Aug 9, 2013

Submitted by: @sim1984

When MON$ tables are queried the first time, only information for the current connection is returned. If some other connection in turn queries MON$ then it gets information for both connections. After that, the first connection also gets full information. And so on.

Simplified test case:

isql #⁠1
SQL> connect 'test';
Database: 'test', User: dimitr

isql #⁠2
SQL> connect 'test';
Database: 'test', User: dimitr

isql #⁠1
SQL> select count(*) from mon$attachments;

   COUNT

============
1

isql #⁠2
SQL> select count(*) from mon$attachments;

   COUNT

============
2

isql #⁠1
SQL> commit;
SQL> select count(*) from mon$attachments;

   COUNT

============
2

Commits: a18788a FirebirdSQL/fbt-repository@26bdd18

====== Test Details ======

Could not reproduce on WI-T3.0.0.30566 Firebird 3.0 Alpha 1.

Window-1:

C:\MIX\firebird\oldfb30a1\isql /3298:C:\MIX\firebird\QA\fbt-repo\tmp\E30A1.FDB
Database: /3298:C:\MIX\firebird\QA\fbt-repo\tmp\E30A1.FDB
SQL> create user u01 password '123'; commit;
SQL> exit;
C:\MIX\firebird\oldfb30a1\isql /3298:C:\MIX\firebird\QA\fbt-repo\tmp\E30A1.FDB -user u01 -pas 123
Database: /3298:C:\MIX\firebird\QA\fbt-repo\tmp\E30A1.FDB, User: u01

Window-2:
C:\MIX\firebird\oldfb30a1\isql /3298:C:\MIX\firebird\QA\fbt-repo\tmp\E30A1.FDB -user u01 -pas 123
Database: /3298:C:\MIX\firebird\QA\fbt-repo\tmp\E30A1.FDB, User: u01

Window-1:
SQL> select count(*) from mon$attachments where mon$user='U01';

            COUNT

=====================
2

@firebird-issue-importer
Copy link
Author

firebird-issue-importer commented Aug 9, 2013

Modified by: @dyemanov

reporter: Dmitry Yemanov [ dimitr ] => Simonov Denis [ sim_84 ]

assignee: Dmitry Yemanov [ dimitr ]

@firebird-issue-importer
Copy link
Author

firebird-issue-importer commented Aug 9, 2013

Modified by: @dyemanov

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

resolution: Fixed [ 1 ]

Fix Version: 3.0 Beta 1 [ 10332 ]

@firebird-issue-importer
Copy link
Author

firebird-issue-importer commented Aug 9, 2013

Modified by: @dyemanov

Fix Version: 3.0 Alpha 2 [ 10560 ]

Fix Version: 3.0 Beta 1 [ 10332 ] =>

@firebird-issue-importer
Copy link
Author

firebird-issue-importer commented Mar 27, 2014

Modified by: @pcisar

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

@firebird-issue-importer
Copy link
Author

firebird-issue-importer commented Jul 10, 2015

Modified by: @pavel-zotov

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

QA Status: Not enough information

Test Details: Could not reproduce on WI-T3.0.0.30566 Firebird 3.0 Alpha 1.

Window-1:

C:\MIX\firebird\oldfb30a1\isql /3298:C:\MIX\firebird\QA\fbt-repo\tmp\E30A1.FDB
Database: /3298:C:\MIX\firebird\QA\fbt-repo\tmp\E30A1.FDB
SQL> create user u01 password '123'; commit;
SQL> exit;
C:\MIX\firebird\oldfb30a1\isql /3298:C:\MIX\firebird\QA\fbt-repo\tmp\E30A1.FDB -user u01 -pas 123
Database: /3298:C:\MIX\firebird\QA\fbt-repo\tmp\E30A1.FDB, User: u01

Window-2:
C:\MIX\firebird\oldfb30a1\isql /3298:C:\MIX\firebird\QA\fbt-repo\tmp\E30A1.FDB -user u01 -pas 123
Database: /3298:C:\MIX\firebird\QA\fbt-repo\tmp\E30A1.FDB, User: u01

Window-1:
SQL> select count(*) from mon$attachments where mon$user='U01';

            COUNT

=====================
2

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