| Subject | Random operating system directive MapViewOfFile failed messages |
|---|---|
| Author | |
| Post date | 2019-06-06T18:20:55Z |
Hi there,
We started seeing this error from client applications two days ago. They appear randomly during the day.
"operating system directive MapViewOfFile failed"
We have to close the client application with Windows task manager and restart it, most of the time this silences the error for a while.
In firebird.log in the server, there is no mention of MapViewOfFile, however, the log is full of messages like this:
MYHOSTNAME Thu Jun 06 12:57:32 2019
INET/inet_error: read errno = 10054
MYHOSTNAME Thu Jun 06 12:57:32 2019
Unable to complete network request to host "MYHOSTNAME".
Error reading data from the connection.
Environment details:
- Windows Server 2012 Standard
- 64 GB of RAM
- Firebird 2.5.8 64-bit Classic
- 290 Firebird SQL Server processes running during the day
- 22 GB database size
- nbackup runs every hour (incremental backups)
Below I am posting firebird.conf file from the server.
Thanks for any insight on how to solve this, please.
-Eduardo Alvarez
#
# Firebird configuration file for Firebird 2.5 64-bit Classic
# Optimized by IBSurgeon (www.ibsurgeon.com).
#
# This is an optimized configuration for Firebird 2.5 Classic 64-bit, it can be used
# instead of standard firebird.conf from 2.5 distribution - copy it to Firebird folder,
# rename it to firebird.conf, then restart Firebird
# (all users should be disconnected before restart!). Keep old config as a backup!
#
# If you need configuration file, optimized for your specific environment
# to get the best possible performance, or if your performance problem
# still persists after configuration changes, contact us:
# http://www.ibsurgeon.com/en/firebird-interbase-performance-optimization-service/
# or via email support@...
#RootDirectory =
#DatabaseAccess = Full
#ExternalFileAccess = None
#UdfAccess = Restrict UDF
#TempDirectories =
#LegacyHash = 1
#Authentication = native
#AuditTraceConfigFile =
#MaxUserTraceLogSize = 10
DefaultDbCachePages = 384
#DatabaseGrowthIncrement = 134217728
#FileSystemCacheThreshold = 65536
#FileSystemCacheSize = 0
#RemoteFileOpenAbility = 0
TempBlockSize = 2048576
TempCacheLimit = 77108864
#CompleteBooleanEvaluation = 0
#DeadlockTimeout = 10
#MaxUnflushedWrites = 100
#MaxUnflushedWriteTime = 5
#BugcheckAbort = 0
#OldColumnNaming = 0
#OldSetClauseSemantics = 0
#RelaxedAliasChecking = 0
#ConnectionTimeout = 180
#DummyPacketInterval = 0
#RemoteServiceName = gds_db
#RemoteServicePort = 3050
#RemoteAuxPort = 0
#TcpRemoteBufferSize = 8192
#TcpNoNagle = 1
#RemoteBindAddress =
LockMemSize = 7048576
#LockGrantOrder = 1
#LockAcquireSpins = 0
LockHashSlots = 30011
#EventMemSize = 65536
#CpuAffinityMask = 1
#UsePriorityScheduler = 1
#PrioritySwitchDelay = 100
#PriorityBoost = 5
#GCPolicy = combined
#GuardianOption = 1
#ProcessPriorityLevel = 0
#IpcName = FIREBIRD
#RemotePipeName = interbas
#Redirection = 0