You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
select from mon$statements is not responding when other connection is running high load query:
- Start two ISQL instances and connect to same DB
- on #1 connection execute statement:
select count(*) from rdb$triggers,rdb$triggers,rdb$triggers,rdb$triggers,rdb$triggers;
- on #2 connection execute statement: select * from mon$statements;
#2 SQL will not return any results until #1 is running. This makes impossible to identify high load running queries nor any other queries when at least one of HL queries is running.
Submitted by: Saulius Vabalas (svabalas)
select from mon$statements is not responding when other connection is running high load query:
- Start two ISQL instances and connect to same DB
- on #1 connection execute statement:
select count(*) from rdb$triggers,rdb$triggers,rdb$triggers,rdb$triggers,rdb$triggers;
- on #2 connection execute statement: select * from mon$statements;
#2 SQL will not return any results until #1 is running. This makes impossible to identify high load running queries nor any other queries when at least one of HL queries is running.
Commits: 1f1a8c8
The text was updated successfully, but these errors were encountered: