Symptom
- A create index command fails
- With a sequence of errors in the errorlog including: 3478, 11068, 6103 and 3300
Error: 3478, Severity: 21, State: 1
During undo the page timestamp value is less than new timestamp from log. Page #=, object id =,
page timestamp=0007 a5841292. Log new timestamp=0007 a58b3d71. Log record marker = (7359528, 18).
Error: 11068, Severity: 20, State: 1
Transaction was found in the incorrect state of 'Command-attached'. The expected state was 'Done command-attached'.
SQL causing error :
create nonclustered index INDEX1_idx on tempdb_1..TABLE1(COL1 , COL2)
Msg 3300
WARNING: spid 123 with suid 456 and curdbid 10 has an active transaction in dbid 11 with xactid (1532833, 2).
Error: 6103, Severity: 17, State: 1
Unable to do cleanup for the killed process
- The function s_estmt_loopend appears in the stack trace for error 11068
Read more...
Environment
SAP Adaptive Server Enterprise (ASE) 15.7 & 16.0
Product
Keywords
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 for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.
SAP Knowledge Base Article - Preview