EmailJob: working on snapshot_ID

[Former Member]

Hi

I have been monitoring my Production HANA system and see that there are 450 + Blocked threads and if I look at the threads, I see mostly the following threads. How do we kill these threads and are these are legitimate threads

EmailJob: working on snapshot_ID:

Mahesh Shetty

[former_member183326]

Hello

Have you trued using "ALTER SYSTEM CANCEL SESSION" for these?

In relation to the "working on snapshot_ID" - the reason for this is the E-mail processing, may be blocked by MailSenderCallback semaphore waits, see SAP Note 1999998 for more details.

You can find more on this and other threads at:

2114710 - FAQ: SAP HANA Threads and Thread Samples

This should answer you question I hope.

[Former Member]

Michael

Thanks for your reply

Its an issue with statistics server in Rev 82. It is fixed in Rev 83 and above. The solution was to restart statistics server which cleared all blocked threads.

Mahesh Shetty

[former_member183326]

Hello Mahesh,

Ok, glad to hear the problem is now solved.

I would recommend to embed your stats server or upgrade to Rev 102.04 so you will not receive these errors again.

Michael