Hi,
I was checking the issue for several days with no idea where the error external engine SYSTEM not found comes from.
It is raised on executing the following comand:
select rdb$time_zone_util.database_version()
from rdb$database
The database size is ~40GB and converted from Firebird 2.5 to Firebird 4.0.2 (super server). There are some changed parameters in firebird.conf:
DatabaseAccess = Full
RemoteAccess = true
UdfAccess = Restrict C:\Program Files\Firebird\Firebird_4_0_2\UDF
DataTypeCompatibility = 2.5
ReadConsistency = 0
AuthServer = Srp, Win_Sspi 'mixed autentication required
AuthClient = Srp, Win_Sspi
UserManager = Srp
RemoteServicePort = 3050
WireCompression = true
RelaxedAliasChecking = 1
TempDirectories = D:\FB_CACHE
ServerMode = Super
DefaultDbCachePages = 30K
WireCrypt = Disabled
and in databases.conf for production database (server has 256GB of memory working with >50 connections):
PROD = D:\DB\PROD.FDB
{
DefaultDbCachePages = 2M
}
Installation was made from zip kit.
Strange thing is, that after restarting firebird the statement does work. After some hours or maybe after day shift it doesn't work anymore. And more confusing is the fact that executing the same query in a database copy on the same server doesn't raise the error. But after a few minutes it was raised again in database copy. There is no entry in firebird.log.
Here is a compare of configurations deviating from default configuration:
RDB$CONFIG_NAME;RDB$CONFIG_VALUE;RDB$CONFIG_DEFAULT
DefaultDbCachePages;2097152;2048
RemoteServicePort;3050;0
DatabaseAccess;Full;Full
UdfAccess;Restrict C:\Program Files\Firebird\Firebird_4_0_2\UDF;None
TempDirectories;D:\FB_CACHE;
RelaxedAliasChecking;true;false
AuthServer;Srp, Win_Sspi;Srp256
AuthClient;Srp, Win_Sspi;Srp256, Srp, Win_Sspi, Legacy_Auth
UserManager;Srp;Srp
ServerMode;Super;Super
WireCrypt;Disabled;Required
RemoteAccess;true;true
WireCompression;true;false
ReadConsistency;false;true
DataTypeCompatibility;2.5;
Some help woukd be great. Thanks.
Hi,
I was checking the issue for several days with no idea where the error
external engine SYSTEM not foundcomes from.It is raised on executing the following comand:
The database size is ~40GB and converted from Firebird 2.5 to Firebird 4.0.2 (super server). There are some changed parameters in firebird.conf:
and in databases.conf for production database (server has 256GB of memory working with >50 connections):
Installation was made from zip kit.
Strange thing is, that after restarting firebird the statement does work. After some hours or maybe after day shift it doesn't work anymore. And more confusing is the fact that executing the same query in a database copy on the same server doesn't raise the error. But after a few minutes it was raised again in database copy. There is no entry in firebird.log.
Here is a compare of configurations deviating from default configuration:
Some help woukd be great. Thanks.