select from mon$statements lockup [CORE1561]

[firebird-automations]

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

[firebird-automations]

Commented by: @hvlad

I can't reproduce it - select * from mon$statements worked fine (results shown immediately) and i have ability to kill long running statemetnt

[firebird-automations]

Commented by: Saulius Vabalas (svabalas)

Did You try it on 2.1 Beta 2 or on upcoming RC1? It could be related to CORE1562 Dmitry fixed.

[firebird-automations]

Commented by: @hvlad

I tried it with current HEAD i.e. after beta 2
As for me issue is fixed

[firebird-automations]

Modified by: @dyemanov

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

resolution: Fixed [ 1 ]

Fix Version: 2.1 RC1 [ 10201 ]

assignee: Dmitry Yemanov [ dimitr ]

[firebird-automations]

Modified by: @pcisar

Workflow: jira [ 13374 ] => Firebird [ 14028 ]

[firebird-automations]

Modified by: @pcisar

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

[firebird-automations]

Modified by: @pavel-zotov

QA Status: No test