log management server leaves stale sessions on manager

[Scott_Paisley]

We have a TAC case open, but someone here might know

We found an error in our logs on the management server that said we had more than 100 sessions

Looking at the session table, almost all of them are connections from our dedicated log server. It keeps spawining sessions that don't expire.

Any ideas?

psql_client cpm postgres -c "select objid,applicationname,username from worksession where not state='PUBLISHED';"
objid | applicationname | username
--------------------------------------+---------------------------+-------------------
7273b38b-1b6e-428e-b884-c16e90f572b3 | smart_event | smart_event
d298c1b5-0ea7-4566-a082-1e05f6471471 | Remote CPM Server | Remote CPM Server
a5909a80-1f9c-4039-8f32-af8c1245f1ea | Remote CPM Server | Remote CPM Server
81d6bc74-8288-4e84-bd23-831456ba0a3c | Remote CPM Server | Remote CPM Server
64d94607-b1b8-4f60-b618-27e59e4e6d06 | Remote CPM Server | Remote CPM Server
35fbfa99-1d11-4784-bc70-6a34d20600a7 | Remote CPM Server | Remote CPM Server
45be4033-5da7-4d7f-bded-c0331f413e7b | smart_event | smart_event
24b3f607-a512-44f8-b4eb-282e9842a78d | Remote CPM Server | Remote CPM Server
611b5e74-566a-4f41-aeb3-aeb98b0866b1 | Remote CPM Server | Remote CPM Server
b241aa04-5f43-4812-abf2-7bd8284a7519 | Remote CPM Server | Remote CPM Server
b705260a-deca-4f60-bb80-e39047071a48 | Remote CPM Server | Remote CPM Server
bc8b650c-3536-4ee7-ba33-bc6545d24240 | Remote CPM Server | Remote CPM Server
12a8018a-e0b2-459f-8f0c-169bb9d90876 | Remote CPM Server | Remote CPM Server
7a6afbdd-41b9-4ee9-ae3e-1d4de34aa236 | Remote CPM Server | Remote CPM Server
9d144a98-4431-4ca2-84bc-58dfbce438be | Remote CPM Server | Remote CPM Server
32072f67-b894-4018-8852-d460ce55808d | Remote CPM Server | Remote CPM Server
80d8d8cd-4ff7-4eb5-924b-638cc66318fd | Remote CPM Server | Remote CPM Server
84085b5d-d57d-4ea7-8146-b476ba835151 | Remote CPM Server | Remote CPM Server
c831f63c-671d-4247-bc06-98602711aac7 | Remote CPM Server | Remote CPM Server
1e319823-eeb6-4027-a8d3-be59530b4874 | Remote CPM Server | Remote CPM Server
aff4e43a-6b00-4877-a71b-aeb5a9c9555c | Remote CPM Server | Remote CPM Server
eb90fbfd-4540-47d8-91b0-353027be9c97 | Remote CPM Server | Remote CPM Server
ed053819-056a-4749-9f98-64ea7b796c57 | Remote CPM Server | Remote CPM Server
270585e0-e1f1-48fb-b676-6df45296acc5 | Remote CPM Server | Remote CPM Server

[the_rock]

What platform is your dedicated log server? I see couple lines mentioning smart event...if so, have you tried evstop; evstart on it?

[Scott_Paisley]

The log server is an open server running 81.10. Smart Event is on a different box running the same code, but the smartevent logins are not causing the issue

[the_rock]

Gotcha. Have you tried cpstop; cpstart or reboot on the actual log server itself?

[Scott_Paisley]

we did a stop start. No joy. Have not done a physical reboot yet

[the_rock]

10-4. Honestly, if I were you, I would reboot it. If you cant reboot it for now, lets see what TAC suggests next. Not sure in this case there is useful debug you can do, unless there is specific process thats a culprit.

[Henrik_Noerr1]

you found the cause for this? We have 1000+ logins from "Remote CPM Server"

not running SmartEvent, but have dedicated CLMs.

I will follow sk113955 but I suspect they will be back momentarily

[Scott_Paisley]

we have not solved it, although we have reduced it a bit. Our management servers had hostnames that didn't match the object names in smartconsole. We rebuilt the log server and the smartview server and aligned all the names, and number of sessions has reduced.