Dbcache flush issue

hcl-bot · August 24, 2009, 9:01am

I having some issue when I send “dbcache flush” to Domino server console.

When I type dbcache flush, my domino console executes the commands and after 1 minute my console does not accept any command like “show server”, “show tasks” …, and I have to wait aprox 40 minutes waiting consoles backs to normality (normality = accepts comands in real time).

Sometimes, console gives to me a message like " No response from server for this command".

I opened a PMR so, they didn´t discover anything. I asked about changing the NSF_Dbcache_MaxEntries but the analyst said that I could have more delay in sending dbcache flush to the console.

I have 2500 users running in a Lotus Domino 8.5 with Language Pack Pt-Br.

I would like to know if someone in this forum having this issue with dbcache too…

My stats about database stuff:

Database.DAFailoverCount = 0

Database.DARefreshServerInfoCount = 0

Database.DAReloadCount = 0

Database.Database.BufferPool.Maximum.Megabytes = 512

Database.Database.BufferPool.MM.Reads = 96

Database.Database.BufferPool.MM.Writes = 47

Database.Database.BufferPool.Peak.Megabytes = 510

Database.Database.BufferPool.PerCentReadsInBuffer = 99.33

Database.DbCache.CurrentEntries = 2003

Database.DbCache.DatabaseLinkEntries = 0

Database.DbCache.HighWaterMark = 2304

Database.DbCache.Hits = 2368339

Database.DbCache.InitialDbOpens = 2768853

Database.DbCache.Lookups = 6028440

Database.DbCache.MaxBucketLength = 6

Database.DbCache.MaxEntries = 1536

Database.DbCache.NumBuckets = 1543

Database.DbCache.NumBucketsUsed = 1094

Database.DbCache.OvercrowdingRejections = 13114

Database.DbCache.Size = 5011

Database.DbOpen.FoundInDbCacheExpanded = 2285436

Database.DbOpen.FoundInDbCacheUnexpanded = 82903

Database.DbOpen.FoundInDBQ.Expanded = 2320363

Database.DbOpen.FoundInDBQ.Unexpanded = 27975057

Database.DbOpen.FoundInDBQ.WithRLock = 27973958

Database.DbOpen.FoundInDBQ.WithWLock = 2321462

Database.DbOpen.FoundLinkInDbCache = 0

Database.DbOpen.InitialDbOpens = 2768853

Database.DbOpen.NameExpansionsNeeded = 5024118

Database.DBUCache.Added = 3481732

Database.DBUCache.AgedOut = 53557

Database.DBUCache.Hits = 3427952

Database.DBUCache.MaxEntries = 2560

Database.DBUCache.SecsInCache.Ave = 7

Database.DBUCache.SecsInCache.Max = 908

Database.DBUCache.SecsInCache.Min = 0

Database.ExtMgrPool.Peak = 65,406

Database.ExtMgrPool.Used = 136

Database.FileIO.MBRead = 1845022

Database.FileIO.MBWritten = 424595

Database.FileIO.TotalReads = 294745647

Database.FileIO.TotalWrites = 64797006

Database.FreeHandleStack.FreeHandleStackHits = 47919936

Database.FreeHandleStack.HandleAllocations = 47967409

Database.FreeHandleStack.MissRate = 0

Database.LDAP.NAMELookupBindFailures = 0

Database.LDAP.NAMELookupBinds = 0

Database.LDAP.NAMELookupBytesReceived = 3496234

Database.LDAP.NAMELookupEntries = 8822

Database.LDAP.NAMELookupFailures = 0

Database.LDAP.NAMELookupTotal = 743

Database.LDAP.NAMELookupTotalLookupTime = 149.958

Database.MonitorPool.Event.Used = 0

Database.MonitorPool.Monitors.Used = 109476

Database.MonitorPool.Size = 41943040

Database.Monitor.Evaluations = 274,484

Database.Monitor.RegisteredDBs = 60

Database.Monitor.Registered.Current = 192

Database.Monitor.Registered.Peak = 216

Database.Monitor.Registered.Total = 16,709

Database.NAMELookupCacheCacheSize = 9,535,512

Database.NAMELookupCacheHashSize = 1,639,656

Database.NAMELookupCacheHits = 2,301,218

Database.NAMELookupCacheLookups = 43,893,494

Database.NAMELookupCacheMaxSize = 16,777,216

Database.NAMELookupCacheMisses = 10,611,090

Database.NAMELookupCacheMisses.ItemMisses = 731,363

Database.NAMELookupCacheNoHitHits = 30,981,186

Database.NAMELookupCachePool.Peak = 16,777,216

Database.NAMELookupCachePool.Used = 15,984,544

Database.NAMELookupCacheResets = 0

Database.NAMELookupCache.ContainerResets = 15

Database.NAMELookupCache.CriticalContainerResets = 15

Database.NAMELookupCache.EligibleContainerResets = 15

Database.NAMELookupMisses = 78,951

Database.NAMELookupTotal = 43349607

Database.NAMELookupTotalLookupTime = 4,741.976

Database.NIFPool.Peak = 6,291,456

Database.NIFPool.Used = 4,127,392

Database.NIF.ViewRead.Optimized = 5248015

Database.NIF.ViewRead.Optimized.Failed.AccessCheck = 64612631

Database.NIF.ViewRead.Optimized.Failed.NavType = 17182672

Database.NIF.ViewRead.Optimized.Failed.NotFlat = 69669628

Database.NIF.ViewRead.Optimized.Failed.TmpColl = 2434

Database.NIF.ViewRead.Total = 76348046

Database.NSFPool.Peak = 31,457,280

Database.NSFPool.Used = 30,286,272

Database.NSF.ClusterHashTable.EntriesWithSameIndex = 0

Database.NSF.ClusterHashTable.FreedEntriesOnCleanup = 0

Database.NSF.ClusterHashTable.HashedEntries = 0

Database.NSF.ClusterHashTable.HashIsFull = 0

Database.NSF.ClusterHashTable.MissedHashHits = 0

Database.NSF.ClusterHashTable.SuccessfullHashHits = 0

Database.NSF.Replicate.NotesMergedBack = 0

Database.NSF.Replicate.NotesReceived = 98134

Database.NSF.Replicate.NotesReopened = 37090

Database.NSF.Replicate.NotesSent = 2067995

Database.NSF.Replicate.SCR.DbOutOfSync = 0

Database.NSF.Replicate.SCR.DeferredEvent = 0

Database.NSF.Replicate.SCR.DeleteMerge = 0

Database.NSF.Replicate.SCR.Deletions = 0

Database.NSF.Replicate.SCR.DestinationResets = 0

Database.NSF.Replicate.SCR.FolderUpdates = 0

Database.NSF.Replicate.SCR.HeaderUpdates = 0

Database.NSF.Replicate.SCR.MaxQueuedMemoryMB = 0

Database.NSF.Replicate.SCR.NoteUpdateFolderMerge = 0

Database.NSF.Replicate.SCR.NoteUpdates = 0

Database.NSF.Replicate.SCR.PastConserveMem = 0

Database.NSF.Replicate.SCR.PastMaxMem = 0

Database.NSF.Replicate.SCR.SrvDbMatch = 0

Database.NSF.Replicate.SCR.SrvDbOpens = 0

Database.NSF.Replicate.SCR.SrvDbUseLRU = 0

Database.NSF.Replicate.SCR.SrvOutOfSync = 0

Database.NSF.Replicate.SCR.SrvSrcSameDb = 0

Database.NSF.Replicate.SCR.SrvTotalOps = 0

Database.NSF.Replicate.SCR.UnreadUpdates = 0

Database.NSF.Replicate.UnreadMarks.ChunkLookups = 0

Database.NSF.Replicate.UnreadMarks.ChunksScanned = 0

Database.NSF.Replicate.UnreadMarks.ChunksSkimmed = 0

Database.NSF.Replicate.UnreadMarks.DroppedFutureEntries = 0

Database.NSF.Replicate.UnreadMarks.DroppedOldEntries = 0

Database.NSF.Replicate.UnreadMarks.FullReplications = 0

Database.NSF.Replicate.UnreadMarks.LocalMaxChunks = 0

Database.NSF.Replicate.UnreadMarks.LocalUnreadOperations = 0

Database.NSF.Replicate.UnreadMarks.MessagesReceived = 0

Database.NSF.Replicate.UnreadMarks.MessagesSent = 0

Database.NSF.Replicate.UnreadMarks.OperationsReceived = 0

Database.NSF.Replicate.UnreadMarks.OperationsSent = 0

Database.NSF.Replicate.UnreadMarks.UsersActive = 0

Database.NSF.Replicate.UnreadMarks.UsersActiveMax = 0

Database.NSF.SignatureCache.Hits = 4789565

Database.NSF.SignatureCache.Tries = 5334633

Database.NSF.UNKS.MemorySaved = -378285533

Database.NSF.UNKS.MemoryUsed = 393216

Database.NSF.UNKS.Shared = 1877581

Database.NSF.UNKS.Total = 30335260

Database.NTOpen.DesignOpens = 56769277

Database.NTOpen.ProfileOpens = 1611509

Database.NTOpen.Total = 143029096

Database.NTUpdate.Adds = 1191226

Database.NTUpdate.Deletes = 1065309

Database.NTUpdate.DesignUpdates = 71909

Database.NTUpdate.ExpiredSoftDeletes = 9196

Database.NTUpdate.ProfileUpdates = 2961

Database.NTUpdate.Updates = 1387918

Database.ObjectContext.PercentReadsInCache = 0.622821076356298

Database.RM.Sys.Logged = Disabled

Database.ViewRegister.Summary.Allocs = 290579

Database.ViewRegister.Summary.CurrentUpdates = 0

Database.ViewRegister.Summary.Frees = 290579

Database.ViewRegister.Summary.NumRegistered = 25

Database.ViewRegister.Summary.OverallDeRegistrations = 15

Database.ViewRegister.Summary.OverallRegistrations = 40

Database.ViewRegister.Summary.PeakQueueUpdates = 5738

Database.ViewRegister.Summary.PeakUpdates = 5859

Database.ViewRegister./notes/data/names.nsf.($ServerAccess).LastGetElement = 08/24/2009 08:56:58 ZW3

Database.ViewRegister./notes/data/names.nsf.($ServerAccess).LastGetNum = 08/24/2009 10:55:38 ZW3

Database.ViewRegister./notes/data/names.nsf.($ServerAccess).LastGetState = 08/24/2009 10:55:38 ZW3

Database.ViewRegister./notes/data/names.nsf.($ServerAccess).LastPutElement = 08/24/2009 08:56:58 ZW3

Database.ViewRegister./notes/data/names.nsf.($ServerAccess).NumElements = 0

Database.ViewRegister./notes/data/names.nsf.($ServerAccess).PeakUpdates = 5738

Database.ViewRegister./notes/data/names.nsf.($ServerAccess).PeakUpdateTime = 08/13/2009 07:41:49 ZW3

Database.ViewRegister./notes/data/names.nsf.($ServerAccess).RefCount = 2

Database.ViewRegister./notes/data/names.nsf.($ServerAccess).State = 3

hcl-bot · August 24, 2009, 12:11pm

Subject: Questions…

What are the soft/hard limits on nofile & nproc?2. Are any semaphore-timeouts occurring after you execute ‘dbcache flush’ while waiting for the Domino Console to become responsive? (i.e. requires notes.ini parameters ‘debug_show_timeout=1’ and/or ‘debug_capture_timeout=1’ to be enabled, requires restart to take-effect)
Are you able to execute Domino Console commands from another workstation’s Lotus Administrator client while the issue is occurring?

hcl-bot · September 10, 2009, 3:56pm

Subject: Evan - Questions

What are the soft/hard limits on nofile & nproc?

I´ve set ulimit -n 20000. I didnt set the soft hard via limits.conf. I set in startup script of domino the line : ulimit -n 20000

Are any semaphore-timeouts occurring after you execute ‘dbcache flush’ while waiting for the Domino Console to become responsive? (i.e. requires notes.ini parameters ‘debug_show_timeout=1’ and/or ‘debug_capture_timeout=1’ to be enabled, requires restart to take-effect)

I´ve set this parameters, once when this happens, I´ve got a 0244 semaphore, but this never happen again. Now always I type dbcache flush my server dont accept any comands in console.

Are you able to execute Domino Console commands from another workstation’s Lotus Administrator client while the issue is occurring?

The error occurs in other Admin Clients too. Evebody have to wait “console” backs to live.

hcl-bot · September 24, 2010, 11:37am

Subject: o/s

Just a question are you running 64bit or 32bit?

hcl-bot · January 6, 2011, 4:29am

Subject: windows fix

You might wanna take a look at this if you have a 64bit os:

http://www-01.ibm.com/support/docview.wss?uid=swg21427348

hcl-bot · August 25, 2009, 7:37am

Subject: I have a question

Why are you issuing the command?

jpaganet@us.ibm.com

hcl-bot · September 10, 2009, 4:10pm

Subject: John Paganeti - Answer

In my company we type dbcache flush on console to take out databases of Domino Server via operating system.

I´m having other problems, can you help me?

http://www-10.lotus.com/ldd/nd85forum.nsf/5f27803bba85d8e285256bf10054620d/3f46a37b69a3c8b58525761c004ea3f2?OpenDocument&Highlight=0,LD_PRELOAD