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 [email protected] #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
