Symptom
- The follow errors are reported in the ASE error log:
Error: 1105, Severity: 17, State: 4
server Can't allocate space for object 'syslogs' in database '<database>' because 'logsegment' segment is full/has no free extents. If you ran out of space in syslogs, dump the transaction log. Otherwise, use ALTER DATABASE to increase the size of the segment.
Error: 940, Severity: 26, State: 11
Dbtable in wrong state for operation: DBTABLE pointer = 0x0x7f41bb09e540, dbid = 27, state = 0x2, status= 0xc, keep = 0, system task keep = 1, name ='<database>'
Error: 6103, Severity: 17, State: 1
Unable to do cleanup for the killed process; received Msg 940.
WARNING: spid 21958 with suid 49428 and curdbid 27 has an active transaction in dbid 27 with xactid (0, 0).
- The following stack is also reported:
pcstkwalk
ucstkgentrace
ucbacktrace
terminate_process
hdl_default
s_handle
exc__raise
exc_raise
dbt_unkeep
xact_end_session
xact__endxact
xact__commitxact
xact__commit_local
xact_commit
s_execute
sequencer
execproc
s_execute
sequencer
tdsrecv_language
hdlr+0xeb8
- The "keep" and "system task keep" is growing reported from continuous 940 errors:
Dbtable in wrong state for operation: DBTABLE pointer = 0x0x7f41bb09e540, dbid = 27, state = 0x2, status= 0xc, keep = 0, system task keep = 1, name = '<database>'.
Dbtable in wrong state for operation: DBTABLE pointer = 0x0x7f41bb09e540, dbid = 27, state = 0x2, status= 0xc, keep = 0, system task keep = 1, name = '<database>'.
Dbtable in wrong state for operation: DBTABLE pointer = 0x0x7f41bb09e540, dbid = 27, state = 0x2, status= 0xc, keep = -1, system task keep = 1, name = '<database>'.
.
.
.
Dbtable in wrong state for operation: DBTABLE pointer = 0x0x7f41bb09e540, dbid = 27, state = 0x2, status= 0xc, keep = -1, system task keep = 37, name = '<database>'.
Dbtable in wrong state for operation: DBTABLE pointer = 0x0x7f41bb09e540, dbid = 27, state = 0x2, status= 0xc, keep = -1, system task keep = 37, name = '<database>'.
Dbtable in wrong state for operation: DBTABLE pointer = 0x0x7f41bb09e540, dbid = 27, state = 0x2, status= 0xc, keep = 0, system task keep = 38, name = '<database>'.
Read more...
Environment
SAP Adaptive Enterprise (ASE) 16.0
Product
Keywords
KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Product Enhancement
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.
SAP Knowledge Base Article - Preview