Homepage › Clovertech Forums › Cloverleaf › thread / process slow to start
- This topic has 13 replies, 4 voices, and was last updated 4 years, 5 months ago by Jim Kosloskey.
-
CreatorTopic
-
April 22, 2020 at 4:35 pm #116480StewartParticipant
What would cause slowness in the thread / process starting?
-
CreatorTopic
-
AuthorReplies
-
-
April 22, 2020 at 4:37 pm #116481Jim KosloskeyParticipant
One thing – but not the only thing – is a Recovery DB which has a lot of Active messages in it.
email: jim.kosloskey@jim-kosloskey.com 29+ years Cloverleaf, 59 years IT - old fart.
-
April 22, 2020 at 4:47 pm #116482Paul BishopParticipant
A couple of things could be the database files have grown large or there are a lot of queued messages on the thread.
You can use the db init command (hcidbinit) to re-initialize the database files – BE VERY CAREFUL WITH THIS COMMAND – it will wipe out all queued messages in the recovery and error databases for that site. When I need to issue this command, I do the following steps:
- do a setsite command if you are doing this from a text session
- shut down all incoming threads in the site
- wait for all the messages to clear out. The alternative to this is to use the hcidbdump command to offload all the messages, but this is cumbersome if there are a lot of messages and/or threads since they need to be offloaded by each destination and state.
- once all messages have cleared out, shut down all other threads and processes for that site.
- Stop the Lock Manager and Monitor Daemon for that site
- Issue the db init command (hcidbinit). I use the “-ACf” flags with it – look in help for explanations.
- Start the Lock Manager and Monitor Daemons up
- Start up your processes and threads.
Paul Bishop
Carle Foundation Hospital
Urbana, IL -
April 23, 2020 at 8:19 am #116490StewartParticipant
The process had 830k messages in the recovery DB. This is a test system so I exported and cleared them out. There are no messages in the recovery or error DB’s. However, I’m still seeing slowness in the process coming up.
-
April 23, 2020 at 9:08 am #116492Paul BishopParticipant
By clearing them out, do you mean you just deleted them or did you do the database initialization? If you didn’t do the initialization, the database file is still at the same size it was with the 830K messages and will take a while to load up even if it is empty.
Paul Bishop
Carle Foundation Hospital
Urbana, IL -
April 23, 2020 at 9:25 am #116493StewartParticipant
Deleted. I did the dbinit and the processes are starting up as expected now. Thank you for the help. Since the DB’s size won’t change when the messages are deleted, is it recommended to reinitialize the DB’s when they grow this large?
-
April 23, 2020 at 9:45 am #116494StewartParticipant
Is there anyway to limit the size of the DB or to prevent this from happening?
-
April 23, 2020 at 11:24 am #116506Rob AbbottKeymaster
Limit the size of the DB? No. If we did that then data could potentially be lost.
If you are really worried about space and speed, you can turn off recovery DB in your test environment if you don’t need to worry about persisting the messages when you stop and start things. This is a setting on each thread’s properties.
Note that the database file size will reach a “high water mark”, that is if messages are deleted from the database, the space will be re-used as new messages are added.
Another thing you can do to shrink the size of the database non-destructively is run the following commands (lock manager, all processes need to be shut down first)
hcidbinit -i -C -f
dbdefrag rlog
Rob Abbott
Cloverleaf Emeritus -
April 23, 2020 at 1:28 pm #116517Jim KosloskeyParticipant
Is this a Test environment or the Production Environment?
Are the Test and Prod Environment on different servers?
email: jim.kosloskey@jim-kosloskey.com 29+ years Cloverleaf, 59 years IT - old fart.
-
April 23, 2020 at 2:24 pm #116519StewartParticipant
Future PROD environment. Our current LIVE / PROD (6.1) cloverleaf resides on the same server. I am working on moving over to this new server (19.1.1). I’ve moved a few things over and am using it for non-critical interfaces and some testing until 19.1.2 has came out at which time, LIVE and PROD will then be on 2 separate servers.
-
April 23, 2020 at 3:38 pm #116520Jim KosloskeyParticipant
If I understand correctly there are 2 Cloverleaf versions on the same server.
Could it be the server is not properly sized for the workload? Don’t forget about I/O.
I think you have some detective work to do.
email: jim.kosloskey@jim-kosloskey.com 29+ years Cloverleaf, 59 years IT - old fart.
-
April 23, 2020 at 3:40 pm #116521StewartParticipant
Only 1 version on each server.
server1: current prod/test [6.1] (future test)
server2: future prod [19.1.1]
-
April 23, 2020 at 3:40 pm #116522StewartParticipant
This is occurring on server2 and have seen it on server1 as well.
-
April 23, 2020 at 3:45 pm #116523Jim KosloskeyParticipant
Consider over committed processes or sites if platform is properly sized. But make sure the platform is properly sized for the workload.
It is also possible Tcl code used at thread startup is less than efficient.
email: jim.kosloskey@jim-kosloskey.com 29+ years Cloverleaf, 59 years IT - old fart.
-
-
AuthorReplies
- You must be logged in to reply to this topic.