Db on connect triggers fail to execute some time [CORE4761]

[firebird-issue-importer]

Submitted by: Lauri Zoova (lz)

Database connect trigger is not always not executed.

For example, given such trigger:

CREATE OR ALTER trigger trg_db_connect
active on connect position 0
AS
begin
rdb$set_context('USER_SESSION', 'ACTIVE_LANGUAGE', 'en');
end

The value "en" is sometimes not found after successfully connecting to the database. Typically the issue is observed when multiple attachments to the server (and same database?) are attempted at the same time.

Commits: 7105562 FirebirdSQL/fbt-repository@34898a9

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

Race condition, see comments below.

[firebird-issue-importer]

Modified by: @asfernandes

assignee: Adriano dos Santos Fernandes [ asfernandes ]

[firebird-issue-importer]

Commented by: @hvlad

Reproduced.
The issue is due to race condition in MET_load_db_triggers - while one attachment loads triggers, another one could see it as already loaded empty vector.

[firebird-issue-importer]

Modified by: @hvlad

assignee: Adriano dos Santos Fernandes [ asfernandes ] => Vlad Khorsun [ hvlad ]

[firebird-issue-importer]

Commented by: @hvlad

Only SuperServer v2.5 is affected

[firebird-issue-importer]

Modified by: @hvlad

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

resolution: Fixed [ 1 ]

Fix Version: 2.5.5 [ 10670 ]

[firebird-issue-importer]

Modified by: @pavel-zotov

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

QA Status: Cannot be tested

Test Details: Race condition, see comments below.

[firebird-issue-importer]

Modified by: @pcisar

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