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.