Skip to content

unable to allocate memory from operating system #8844

@carlosreyes210177

Description

@carlosreyes210177

I'm not sure if this is a bug or a configuration issue. Perhaps someone has already resolved it. We have a server with the following specifications: a 12th generation i5 processor, 24 GB of RAM, and a 1 TB NVMe hard drive. The server is powered on for 24 hours and restarts at 2:30 AM.

We have 19 instances of 64-bit 5. 0.3 Firebird running, as we have several applications and over 90 clients connecting to them.

During the day, we have to restart the server because it displays the following message:

Database: C:\PROGRAM FILES\FIREBIRD\FIREBIRD_5_0 _FERRETERIA_LUIS\SECURITY5.FDB

Allocated 3501 page buffers of 51200 requested

Authentication error

Unable to allocate memory from operating system
Why is it that if we don't restart, we can no longer access the database?
Is this a configuration problem or a bug?

in the files of:
databases.conf
security.db = $(dir_secDb)/security5.fdb
{
RemoteAccess = false
DefaultDbCachePages = 256
}

Live Databases:

POSDB.1 = C:\Server\DataBases\Default\POSDB.UST
{
DefaultDBCachePages = 786432
LockMemSize = 30M
TempCacheLimit =3277M
}

firebird.conf
#Configuration for Firebird 5 (vanilla) SuperServer (64 bit)

ServerMode = Super
DefaultDbCachePages = 50K # pages (SuperServer) - increase pages in databases.conf, not here

LockMemSize = 20M # bytes (SuperServer)
LockHashSlots = 40099 # slots

MaxUnflushedWrites = -1 # default for posix (non-Windows)
MaxUnflushedWriteTime = -1 # default for posix (non-Windows)
ParallelWorkers = 1 # default parallel threads
MaxParallelWorkers = 64 # parallel threads for sweep, backup, restore
MaxStatementCacheSize=4M
OuterJoinConversion = true
OptimizeForFirstRows = false
UseFileSystemCache = true
TempCacheLimit = 256M
RemoteServicePort = 3050
InlineSortThreshold = 16384 # use REFETCH plan for big sortings

ExtConnPoolSize = 64 # external connections pool size
ExtConnPoolLifeTime = 3600 # seconds

#set DataTypeCompatibility according to Migration Guide https://ib-aid.com/download/docs/fb5migrationguide.html
#DataTypeCompatibility =
#WireCryptPlugin = ChaCha64, ChaCha, Arc4
WireCrypt = Enabled
#WireCompression = false
#RemoteAuxPort = 0
#authentication plugin setup
#Recommendation - use SELECT * FROM SEC$USERS
#to check that you have users for all plugins
AuthServer = Srp256, Legacy_Auth
UserManager = Srp, Legacy_UserManager

#MaxIdentifierByteLength = 252
#MaxIdentifierCharLength = 63
#DefaultTimeZone =
#SnapshotsMemSize = 64K # bytes
#TipCacheBlockSize = 4M # bytes

IpcName = FIREBIRD

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions