2448640 - ERROR: Can't get a new log page in dbid X - ASE 16.0 SP02 PL04 | SAP Knowledge Base Article

SAP Knowledge Base Article - Preview

2448640 - ERROR: Can't get a new log page in dbid X - ASE 16.0 SP02 PL04

Symptom

  • Getting the following error in the ASE error log:

ERROR: Can't get a new log page in dbid X (num_left=1, num_in_plc=1, num_in_plc_at_start=1, num_newlogpgs_allocated=0)

  • The following stack is reported in the error log:

kernel  pc: 0x40000000061fe770 pcstkwalk
kernel  pc: 0x40000000061fd5e0 ucstkgentrace
kernel  pc: 0x40000000061f6320 ucbacktrace
kernel  pc: 0x4000000003415df0 $cold_terminate_process
kernel  pc: 0x40000000062a2490 kisignal
kernel  pc: 0x4000000002544850 log__newpage
kernel  pc: 0x4000000002658af0 plcblock__flush
kernel  pc: 0x4000000002664cb0 xls_flush_plcqueue
kernel  pc: 0x4000000002661ce0 plc__flush
kernel  pc: 0x400000000266a0e0 xls_preflush
kernel  pc: 0x4000000002669c40 syslogs_finishlog
kernel  pc: 0x40000000026706e0 finishlog
kernel  pc: 0x4000000002670b20 xact__endxact
kernel  pc: 0x400000000264cfc0 xact__commitxact
kernel  pc: 0x400000000264caa0 xact__commit_local
kernel  pc: 0x400000000264c8e0 xact_commit
kernel  pc: 0x4000000005e3bf30 reorg_new_xact
kernel  pc: 0x4000000005e3fc40 reorg__ptn_fr
kernel  pc: 0x4000000005e39a30 reorg__fr
kernel  pc: 0x4000000005e36a40 reorg_main
kernel  pc: 0x4000000001bfe4c0 $cold_s_execute
kernel  pc: 0x4000000002558f90 sequencer
kernel  pc: 0x40000000027865e0 internal_sql
kernel  pc: 0x4000000001bfae30 $cold_s_execute
kernel  pc: 0x4000000002558f90 sequencer
kernel  pc: 0x400000000282ab00 tdsrecv_language
kernel  pc: 0x400000000254dbe0 conn_hdlr
kernel  end of stack trace, spid 779, kpid 116721168, suid 4

  • Subsequent 1251 error is reported after the stack:

server  Error: 1251, Severity: 26, State: 1
server  An in-use preallocated semaphore cursor was encountered.
server  Error: 1251, Severity: 26, State: 1
server  An in-use preallocated semaphore cursor was encountered.
server  Error while undoing log row in database 'tempdb4'.  Rid pageid = 0; row num = 0.
server  WARNING: spid 779 with suid 4 and curdbid 0 has an active transaction in dbid 13 with xactid (0, 0).


Read more...

Environment

SAP Adaptive Server Enterprise (ASE) 16.0 SP02 PL04

Product

SAP Adaptive Server Enterprise 16.0

Keywords

infected log__newpage plcblock__flush , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Bug Filed

About this page

This 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.