Used FB config: |
---|
# GENERATED AUTO 30/11/2023 8:23:26.77, DO NOT EDIT. See H:\QA\rundaily-2023\qa_rundaily.bat for details.
# # Parameters from https://github.com/FirebirdSQL/firebird-qa.git, file: '/configs/hq40_all.conf': # # 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_MACHINE\SOFTWARE\Microsoft\Windows\Windows Error Reporting\LocalDumps\firebird.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_MACHINE\Software\Microsoft\Windows\Windows Error Reporting\ # parameter: 'DontShowUI', type: DWORD, value: 2 # BugCheckAbort = 1 # See parameter 'PORT_FOR_LISTENING' in QA_rundaily.conf: # RemoteServicePort = 33337 FileSystemCacheThreshold = 99999K # Added 13.04.2019: start implementing tests for verifying DB encryption tasks # Encryption demo plugin was supplied by IBSurgeon, see # WireCrypt = Enabled MaxUnflushedWrites = -1 MaxUnflushedWriteTime = -1 ExternalFileAccess = Full # See parameter 'TEMP_DIR' in QA_rundaily.conf: # TempDirectories = H:\QA\temp\qa2023.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 KeyHolderPlugin = fbSampleKeyHolder # # Parameters from https://github.com/FirebirdSQL/firebird-qa.git, file: '/configs/hq40_ss.conf': # # Parameters specific to HQbird 4.x SuperServer: ################################################ ServerMode = Super # Increased 11.04.2021 after discuss with dimitr # See mailbox [email protected], 11-apr-2021. # DefaultDBCachePages = 100K # Reduced 06.12.2022 otherwise dumps will have # too big size and will be rotated too frequent. # Discussed with Alex # See mailbox [email protected], 16-nov-2022 # DefaultDBCachePages = 10K # Common for all connections in SS: # # Increased 11.04.2021 after discuss with dimitr # See e-mail [email protected], 11-apr-2021. # TempCacheLimit = 1G # Parameters for tests which must use XNET/WNET # connection protocols (rather than INET one): IpcName = xnet_hq4x_ss RemotePipeName = wnet_hq4x_ss |
Unified diff: |
---
+++ @@ -1,4 +1,4 @@ -# GENERATED AUTO 30/12/2023 8:25:22.53, DO NOT EDIT. See H:\QA\rundaily-2023\qa_rundaily.bat for details. +# GENERATED AUTO 30/11/2023 8:23:26.77, DO NOT EDIT. See H:\QA\rundaily-2023\qa_rundaily.bat for details. # # Parameters from https://github.com/FirebirdSQL/firebird-qa.git, file: '/configs/hq40_all.conf': # @@ -20,59 +20,44 @@ # See parameter 'PORT_FOR_LISTENING' in QA_rundaily.conf: # RemoteServicePort = 33337 - UseFileSystemCache = true - InlineSortThreshold = 1000 - # Valid values: [0...1000]. If set to zero, pool is disabled. Default: 0. - # Actual value was taken from H:\QA\rundaily-2023\qa_rundaily.conf: - # - ExtConnPoolSize = 10 - # Set the time before destroyng inactive external connection, seconds. Valid values: [1...86400]. Default: 7200 seconds. - # Actual value was taken from H:\QA\rundaily-2023\qa_rundaily.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 # WireCrypt = Enabled - KeyHolderPlugin = fbSampleKeyHolder MaxUnflushedWrites = -1 MaxUnflushedWriteTime = -1 ExternalFileAccess = Full # See parameter 'TEMP_DIR' in QA_rundaily.conf: # TempDirectories = H:\QA\temp\qa2023.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 - StatementTimeout = 7200 - ConnectionIdleTimeout = 0 - ClearGTTAtRetaining = 0 - ClientBatchBuffer = 131072 - SnapshotsMemSize = 64K - TipCacheBlockSize = 4M - # HQbird specific: - # + 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 - SortDataStorageThreshold = 4096 - TempSpaceLogThreshold = 0 - HQbirdVersionString = 1 - MinDbCachePages = 0 - MaxDbCachePages = 0 + KeyHolderPlugin = fbSampleKeyHolder # # Parameters from https://github.com/FirebirdSQL/firebird-qa.git, file: '/configs/hq40_ss.conf': # |