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.