Server hangs in some periods and it is necessary to restart ASE. This always occurs after these messages:
00:0012:00000:00573:2021/02/01 19:12:12.88 server Update of syslogins failed
00:0003:00000:02933:2021/02/01 19:12:13.63 server Update of syslogins failed
00:0005:00000:00799:2021/02/01 19:13:11.32 server Update of syslogins failed
In the memory dump, the most of blocking is on "syslogins" and all blocker processes are waiting for object to be returned to pool and sleeping:
11 1111 111111111111 conn_hdlr sleeping on event:c000000xxxxxx000 Address not found: c000000xxxxxx000
wait for object to be returned to pool setdataok
The stack trace for blocker processes have these functions in the stack trace:
There are also other processes that are not accessing "syslogins" table but with the same scenario.
SAP ASE 16.0 SP03 PL02
hang hung stuck restart kdfblkio_mempool kpsuspend upsleepgeneric uboallocw blkioCreate blkioCreateRequest Update of syslogins failed disk i/o structures wait for object to be returned to pool event 157 , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Problem
About this pageThis is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).
Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.