Gateway - Database Logging errors with maxRequestQueueSize being breached

maxRequestQueueSize is the maximum number of queries to the database that a gateway will buffer, before writing a dump file. This setting can be adjusted to anywhere from 1-10,000; the default value is at 4000.

If you encounter this type of error, you will most likely see entries similar to the one below on your Gateway logfile:

ERROR: DatabaseLogging maxRequestQueueSize [4001/4000] has breached, dumping data to file 'file://./database/database.1453595297.1014075536.dat'.

As the message implies, this is pointing to the Database Logging’s maxRequestQueueSize setting; once this buffer has been breached, the gateway will no longer be able to log the data onto the database and instead store it locally to a data dump file, which it will then attempt to reinsert onto the database at a later time. If you consistently encounter this error, you should adjust this setting’s value in the Database Logging, Advanced section of your Gateway Setup. Geneos - Gateway - Database Logging errors with maxRequestQueueSize being breachedYou can gradually adjust this setting or increase the value by a factor of 2, essentially doubling the value from 4000 to 8000 is acceptable.