Used FB config:
# Common parameters for all HQbird 4.x ServerMode. # ################################################## # Parameter BugCheckAbort must be 1 to allow dumps be saved when FB crashes. # Crashes will be intercepted by WER if registry has following key and parameters: # HKEY_LOCAL_MACHINESOFTWAREMicrosoftWindowsWindows Error ReportingLocalDumpsfirebird.exe# Parameter 'DumpType', type: DWORD, value: 2 # Parameter 'DumpFolder', type: EXPAND_SZ, value: directory for storing dumps # Parameter 'DumpCount', type: DWORD, value: at least 3. # # Also, following must present in the registry to disable any pop-up window when program crashes: # key: HKEY_LOCAL_MACHINESoftwareMicrosoftWindowsWindows Error Reporting# parameter: 'DontShowUI', type: DWORD, value: 2 # BugCheckAbort = 1 # See parameter 'PORT_FOR_LISTENING' in QA_rundaily.conf: # RemoteServicePort = 3358 FileSystemCacheThreshold = 99999K # Added 13.04.2019: start implementing tests for verifying DB encryption tasks # Encryption demo plugin was supplied by IBSurgeon, see !ENCRYPTION_PLUGIN_FOLDER! # WireCrypt = Enabled MaxUnflushedWrites = -1 MaxUnflushedWriteTime = -1 ExternalFileAccess = Full # See parameter 'TEMP_DIR' in QA_rundaily.conf: # TempDirectories = /var/tmp # 16.01.2020 temply restored previous settings: # Reason: strong performance degradation. # Sent reports to dimitr et al // mailbox: [email protected] # AuthServer = Legacy_Auth, Srp, Srp256, Win_Sspi # UserManager = Legacy_UserManager, Srp # AuthClient = Legacy_Auth, Srp, Srp256, Win_Sspi # 05-jan-2020. Its preferred AuthClient to start with 'Srp' rather than 'LegacyAuth' otherwise # strange delay required at least for 10-11 seconds, see comments in core_6208.fbt # Parameter AuthClient must start with 'Srp', NOT 'Srp256' - see also core_6208.fbt # 03-feb-2020 RESTORED because CORE-6237 was fixed. AuthClient = Srp, Srp256, Win_Sspi, Legacy_Auth AuthServer = Srp, Srp256, Win_Sspi, Legacy_Auth UserManager = Srp, Legacy_UserManager SortDataStorageThreshold = 4096 TempSpaceLogThreshold = 0 ExtConnPoolLifeTime = 10 ExtConnPoolSize = 10 HQbirdVersionString = 1 LegacyDatabaseFileId = true ClearGTTAtRetaining = 1 ParallelWorkers = 1 MaxParallelWorkers = 2 DSQLCacheSize = 0 MaxTempBlobs = 1000 BlobTempSpace = 1 LeftJoinConversion = false # COMMENTED out by /opt/distr/venv/qa-rundaily/qa_rundaily.sh because of use another value: KeyHolderPlugin = fbSampleKeyHolder # Parameters specific to HQbird 4.x Classic ########################################### ServerMode = Classic DefaultDBCachePages = 2048 TempCacheLimit = 128K # Parameters for tests which must use XNET/WNET # connection protocols (rather than INET one): IpcName = xnet_hq4x_cs RemotePipeName = wnet_hq4x_cs # Name of example plugin which makes 'pseudo-ecnryption' must be: # for FB 3.x/HQ 3.x: CryptKeyHolder_example # for FB 4.x: fbSampleKeyHolder KeyHolderPlugin = fbSampleKeyHolder
Unified diff:
--- +++ @@ -17,34 +17,12 @@ # RemoteServicePort = 3358 - UseFileSystemCache = true - - InlineSortThreshold = 1000 - - # Valid values: [0...1000]. If set to zero, pool is disabled. Default: 0. - # Actual value was taken from %~dpn0.conf: - # - ExtConnPoolSize = 10 - - # Set the time before destroyng inactive external connection, seconds. Valid values: [1...86400]. Default: 7200 seconds. - # Actual value was taken from %~dpn0.conf: - # - ExtConnPoolLifeTime = 10 - - # 05-sep-2019, FB 4.x+: intentionally change ReadConsistency with NON-DEFAULT value in order to have ability - # to use BOTH isolation levels for transactions that are to be started in READ COMMITTED mode: - # 1. READ COMMITTED READ CONSISTENCY - # 2. READ COMMITTED [NO] RECORD_VERSION - # See test for CORE-5953, "Statement level read consistency in read-committed transactions": - # we test there result for BOTH modes of RC isolation level. - # - ReadConsistency = 0 + FileSystemCacheThreshold = 99999K # Added 13.04.2019: start implementing tests for verifying DB encryption tasks # Encryption demo plugin was supplied by IBSurgeon, see !ENCRYPTION_PLUGIN_FOLDER! # WireCrypt = Enabled - # COMMENTED out by /opt/distr/venv/qa-rundaily/qa_rundaily.sh because of use another value: KeyHolderPlugin = fbSampleKeyHolder MaxUnflushedWrites = -1 MaxUnflushedWriteTime = -1 @@ -55,35 +33,42 @@ # TempDirectories = /var/tmp - AuthServer = Srp, Win_Sspi, Legacy_Auth + # 16.01.2020 temply restored previous settings: + # Reason: strong performance degradation. + # Sent reports to dimitr et al // mailbox: [email protected] + # AuthServer = Legacy_Auth, Srp, Srp256, Win_Sspi + # UserManager = Legacy_UserManager, Srp + # AuthClient = Legacy_Auth, Srp, Srp256, Win_Sspi + + # 05-jan-2020. Its preferred AuthClient to start with 'Srp' rather than 'LegacyAuth' otherwise + # strange delay required at least for 10-11 seconds, see comments in core_6208.fbt + # Parameter AuthClient must start with 'Srp', NOT 'Srp256' - see also core_6208.fbt + # 03-feb-2020 RESTORED because CORE-6237 was fixed. + + AuthClient = Srp, Srp256, Win_Sspi, Legacy_Auth + AuthServer = Srp, Srp256, Win_Sspi, Legacy_Auth UserManager = Srp, Legacy_UserManager - MaxIdentifierByteLength = 252 - MaxIdentifierCharLength = 63 - WireCryptPlugin = ChaCha, Arc4 + SortDataStorageThreshold = 4096 + TempSpaceLogThreshold = 0 - StatementTimeout = 7200 + ExtConnPoolLifeTime = 10 + ExtConnPoolSize = 10 - ConnectionIdleTimeout = 0 - ClearGTTAtRetaining = 0 - ClientBatchBuffer = 131072 - SnapshotsMemSize = 64K - TipCacheBlockSize = 4M + HQbirdVersionString = 1 - # HQbird specific: - # + LegacyDatabaseFileId = true + ClearGTTAtRetaining = 1 + ParallelWorkers = 1 MaxParallelWorkers = 2 + DSQLCacheSize = 0 MaxTempBlobs = 1000 BlobTempSpace = 1 LeftJoinConversion = false - SortDataStorageThreshold = 4096 - TempSpaceLogThreshold = 0 - HQbirdVersionString = 1 - MinDbCachePages = 0 - MaxDbCachePages = 0 + # COMMENTED out by /opt/distr/venv/qa-rundaily/qa_rundaily.sh because of use another value: KeyHolderPlugin = fbSampleKeyHolder # Parameters specific to HQbird 4.x Classic ###########################################