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-automations opened this issue Aug 9, 2013 · 5 comments

Comments

@firebird-automations
Copy link
Collaborator

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-automations
Copy link
Collaborator Author

Modified by: @dyemanov

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

assignee: Dmitry Yemanov [ dimitr ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @dyemanov

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

resolution: Fixed [ 1 ]

Fix Version: 3.0 Beta 1 [ 10332 ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @dyemanov

Fix Version: 3.0 Alpha 2 [ 10560 ]

Fix Version: 3.0 Beta 1 [ 10332 ] =>

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