Error firing database connect trigger

[Александр Редько, отдел ДК и ОРП ФГУП "РАДОН"]

When converting DB from Firebird v. 2.5.9 to v. 5.0.2 I got a problem.

 

DB (DB5.sql) contains a database connection trigger (CONN_BI0). This trigger when fired copies data from MON$ATTACHMENTS table to table CHG_CONN in another DB (LOG_DB5.sql).

 

For Firebird v. 2.5.9 DB all is OK, but not for Firebird v. 5.0.2: when firing trigger I got a message: "Error reading data from the connection" (Error.jpg).

 

firebird.log says:

================================================= 

mycomp    Wed Jul  9 12:26:08 2025

 

     Access violation.

        The code attempted to access a virtual

        address without privilege to do so.

    This exception will cause the Firebird server

    to terminate abnormally.

==================================================

But the same code in execute block (ExecuteBlock.sql) started after connection is made (with suppress data database triggers key on)  is working OK.

 

OS:Windows7x64

 

Alexandr Redko

[Vlad Khorsun]

  Thanks, 

fixed in https://github.com/FirebirdSQL/firebird/issues/8649

Regards,

Vlad