Used config: /opt/scripts/qa-rundaily/unpacked-snapshot.tmp/firebird.conf, size: 4001, LUPD: 20210928_080449
# Common parameters for all 5.x ServerMode values.
#
##################################################

# 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 = 3341

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

# Explicitly allow usage of UDF. Its default value in FB 4.x is *NONE*.
# Some tests need to create/use/drop UDFs from fbudf.dll:
#
UdfAccess = Restrict UDF


# 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/scripts/qa-rundaily/qa_rundaily.sh because of use another value: KeyHolderPlugin = KeyHolder
# 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

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


MaxIdentifierByteLength = 252
MaxIdentifierCharLength = 63
WireCryptPlugin = ChaCha, Arc4
StatementTimeout = 0
ConnectionIdleTimeout = 0
ClearGTTAtRetaining = 0
ClientBatchBuffer = 131072
SnapshotsMemSize = 64K
TipCacheBlockSize = 4M
# Parameters specific to 5.x SuperServer
########################################

ServerMode = Super

# Common for all connections in SS:
#
# Increased 11.04.2021 after discuss with dimitr
# See e-mail [email protected], 11-apr-2021.
DefaultDBCachePages = 100K

# 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_fb5x_ss
RemotePipeName = wnet_fb5x_ss
Unified diff:
---
+++
@@ -50,7 +50,7 @@

# Encryption demo plugin was supplied by IBSurgeon, see !ENCRYPTION_PLUGIN_FOLDER!

#

WireCrypt = Enabled
-
# COMMENTED out by /opt/scripts/qa-rundaily/fbt-repo/qa_rundaily.sh because of use another value: KeyHolderPlugin = KeyHolder
+
# COMMENTED out by /opt/scripts/qa-rundaily/qa_rundaily.sh because of use another value: KeyHolderPlugin = KeyHolder

# Name of example plugin which makes 'pseudo-ecnryption' must be:

# for FB 3.x/HQ 3.x: CryptKeyHolder_example

# for FB 4.x: fbSampleKeyHolder
Used in previous run: /opt/scripts/qa-rundaily/unpacked-snapshot.tmp/firebird.conf, size: 4010, LUPD: 20210926_163026
# Common parameters for all 5.x ServerMode values.
#
##################################################

# 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 = 3341

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

# Explicitly allow usage of UDF. Its default value in FB 4.x is *NONE*.
# Some tests need to create/use/drop UDFs from fbudf.dll:
#
UdfAccess = Restrict UDF


# 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/scripts/qa-rundaily/fbt-repo/qa_rundaily.sh because of use another value: KeyHolderPlugin = KeyHolder
# 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

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


MaxIdentifierByteLength = 252
MaxIdentifierCharLength = 63
WireCryptPlugin = ChaCha, Arc4
StatementTimeout = 0
ConnectionIdleTimeout = 0
ClearGTTAtRetaining = 0
ClientBatchBuffer = 131072
SnapshotsMemSize = 64K
TipCacheBlockSize = 4M
# Parameters specific to 5.x SuperServer
########################################

ServerMode = Super

# Common for all connections in SS:
#
# Increased 11.04.2021 after discuss with dimitr
# See e-mail [email protected], 11-apr-2021.
DefaultDBCachePages = 100K

# 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_fb5x_ss
RemotePipeName = wnet_fb5x_ss