Skip to Content
0

[Help] SQLSessionCmd Connection.cc(08190) cancel requested for xxxxxxxx (logical connection id

Jan 20 at 09:04 PM

184

avatar image
Martin Simois

Hi Guys,

In a recently installed a couple of SAP HANA Systems (Version 2.0 SPS02 Rev 23). , when checking trace log its showing a cancel request message repeteadly every 5 seconds and I can figure out what is causing this.

It seems open a connection every 5 seconds and then system itself proceeds to cancel it due its Inactive.

I have read the following notes which explain what it means but I would need to find out the root cause of this messages.

Note 2380176 - FAQ: SAP HANA Database Trace

Note 2092196 - How-To: Terminating Sessions in SAP HANA

Any assistance would be great to get rid of this

Thanks!

[17517]{-1}[-1/-1] 2018-01-20 17:44:19.310433 i SQLSessionCmd    Connection.cc(08190) : cancel requested for 112362 (logical connection id is 112362)
[18258]{-1}[-1/-1] 2018-01-20 17:44:27.300125 i SQLSessionCmd    Connection.cc(08190) : cancel requested for 112367 (logical connection id is 112367)
[18951]{-1}[-1/-1] 2018-01-20 17:44:37.326304 i SQLSessionCmd    Connection.cc(08190) : cancel requested for 112368 (logical connection id is 112368)
[18951]{-1}[-1/-1] 2018-01-20 17:44:37.895108 i SQLSessionCmd    Connection.cc(08190) : cancel requested for 112355 (logical connection id is 112355)
[17519]{-1}[-1/-1] 2018-01-20 17:44:38.896094 i SQLSessionCmd    Connection.cc(08190) : cancel requested for 112356 (logical connection id is 112356)
[17517]{-1}[-1/-1] 2018-01-20 17:44:39.898604 i SQLSessionCmd    Connection.cc(08190) : cancel requested for 112357 (logical connection id is 112357)
[17519]{-1}[-1/-1] 2018-01-20 17:44:42.001021 i SQLSessionCmd    Connection.cc(08190) : cancel requested for 112369 (logical connection id is 112369)
[17517]{-1}[-1/-1] 2018-01-20 17:44:47.335811 i SQLSessionCmd    Connection.cc(08190) : cancel requested for 112370 (logical connection id is 112370)
[8358]{-1}[-1/-1] 2018-01-20 17:44:48.319867 i SQLSessionCmd    Connection.cc(08190) : cancel requested for 112371 (logical connection id is 112371)
[18258]{-1}[-1/-1] 2018-01-20 17:44:49.322908 i SQLSessionCmd    Connection.cc(08190) : cancel requested for 112372 (logical connection id is 112372)
[18951]{-1}[-1/-1] 2018-01-20 17:44:49.341801 i SQLSessionCmd    Connection.cc(08190) : cancel requested for 112373 (logical connection id is 112373)
[17519]{-1}[-1/-1] 2018-01-20 17:44:57.332507 i SQLSessionCmd    Connection.cc(08190) : cancel requested for 112374 (logical connection id is 112374)
[17517]{-1}[-1/-1] 2018-01-20 17:45:07.360225 i SQLSessionCmd    Connection.cc(08190) : cancel requested for 112375 (logical connection id is 112375)
[17519]{-1}[-1/-1] 2018-01-20 17:45:12.036123 i SQLSessionCmd    Connection.cc(08190) : cancel requested for 112379 (logical connection id is 112379)
[17517]{-1}[-1/-1] 2018-01-20 17:45:17.369442 i SQLSessionCmd    Connection.cc(08190) : cancel requested for 112380 (logical connection id is 112380)
[8358]{-1}[-1/-1] 2018-01-20 17:45:18.350600 i SQLSessionCmd    Connection.cc(08190) : cancel requested for 112381 (logical connection id is 112381)
[18258]{-1}[-1/-1] 2018-01-20 17:45:19.353817 i SQLSessionCmd    Connection.cc(08190) : cancel requested for 112382 (logical connection id is 112382)
[18951]{-1}[-1/-1] 2018-01-20 17:45:19.374201 i SQLSessionCmd    Connection.cc(08190) : cancel requested for 112383 (logical connection id is 112383)
[17519]{-1}[-1/-1] 2018-01-20 17:45:27.361734 i SQLSessionCmd    Connection.cc(08190) : cancel requested for 112384 (logical connection id is 112384)
[17517]{-1}[-1/-1] 2018-01-20 17:45:37.388786 i SQLSessionCmd    Connection.cc(08190) : cancel requested for 112385 (logical connection id is 112385)
[8358]{-1}[-1/-1] 2018-01-20 17:45:37.951878 i SQLSessionCmd    Connection.cc(08190) : cancel requested for 112376 (logical connection id is 112376)
[18258]{-1}[-1/-1] 2018-01-20 17:45:38.953965 i SQLSessionCmd    Connection.cc(08190) : cancel requested for 112377 (logical connection id is 112377)
[18951]{-1}[-1/-1] 2018-01-20 17:45:39.956684 i SQLSessionCmd    Connection.cc(08190) : cancel requested for 112378 (logical connection id is 112378)
[17517]{-1}[-1/-1] 2018-01-20 17:45:41.062185 i SQLSessionCmd    Connection.cc(08190) : cancel requested for 112347 (logical connection id is 112347)
[8358]{-1}[-1/-1] 2018-01-20 17:45:41.062371 i SQLSessionCmd    Connection.cc(08190) : cancel requested for 112386 (logical connection id is 112386)
[18258]{-1}[-1/-1] 2018-01-20 17:45:41.062480 i SQLSessionCmd    Connection.cc(08190) : cancel requested for 112387 (logical connection id is 112387)
[17519]{-1}[-1/-1] 2018-01-20 17:45:42.069341 i SQLSessionCmd    Connection.cc(08190) : cancel requested for 112389 (logical connection id is 112389)
[17517]{-1}[-1/-1] 2018-01-20 17:45:47.399501 i SQLSessionCmd    Connection.cc(08190) : cancel requested for 112390 (logical connection id is 112390)
[8358]{-1}[-1/-1] 2018-01-20 17:45:48.378179 i SQLSessionCmd    Connection.cc(08190) : cancel requested for 112391 (logical connection id is 112391)
[18258]{-1}[-1/-1] 2018-01-20 17:45:49.382170 i SQLSessionCmd    Connection.cc(08190) : cancel requested for 112392 (logical connection id is 112392)
[18951]{-1}[-1/-1] 2018-01-20 17:45:49.404123 i SQLSessionCmd    Connection.cc(08190) : cancel requested for 112393 (logical connection id is 112393)
[17519]{-1}[-1/-1] 2018-01-20 17:45:57.390666 i SQLSessionCmd    Connection.cc(08190) : cancel requested for 112394 (logical connection id is 112394)
[17517]{-1}[-1/-1] 2018-01-20 17:46:07.418215 i SQLSessionCmd    Connection.cc(08190) : cancel requested for 112395 (logical connection id is 112395)
[17519]{-1}[-1/-1] 2018-01-20 17:46:12.101038 i SQLSessionCmd    Connection.cc(08190) : cancel requested for 112399 (logical connection id is 112399)
[17517]{-1}[-1/-1] 2018-01-20 17:46:17.427130 i SQLSessionCmd    Connection.cc(08190) : cancel requested for 112400 (logical connection id is 112400)
[8358]{-1}[-1/-1] 2018-01-20 17:46:18.407980 i SQLSessionCmd    Connection.cc(08190) : cancel requested for 112401 (logical connection id is 112401)
2018-01-20-18-17-19.png (46.1 kB)
SAP HANA, platform edition
Answers Answers and Comments
10 |10000 characters needed characters left characters exceeded
▼ Viewable by all users
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Sort by:
avatar image
Maria Sahukar Answered Jan 24 at 11:48 PM
-1

Hi Martin,

I opened a chat session with SAP and they mentioned that if you look closely; the trace has an "i" right before SQLSessionCmd Connection text which means the trace is just information and it is not pointing to an error.

[31258]{-1}[-1/-1] 2018-01-24 15:12:59.841573 i SQLSessionCmd Connection.cc(08190) : cancel requested for 259989 (logical connection id is 259989)

They suggested changing the trace level to error:

alter system alter configuration ('indexserver.ini','SYSTEM') SET ('trace','sqlsessioncmd')='error' with reconfigure

And now we don't see the messages in the indexserver trace anymore.

I hope this is useful.

Share
10 |10000 characters needed characters left characters exceeded
▼ Viewable by all users
avatar image
Maria Sahukar Answered Jan 24 at 11:13 PM
0

Hi Martin,

We just upgraded to rev23 as well and are having the exact same issue. Have you been able to figure out what it is?

Thank you!

Share
10 |10000 characters needed characters left characters exceeded
▼ Viewable by all users