Symptom
- The "create database" command fails with Error 692 in the ASE error log.
- The "dbcc page(dbid, pagenumber, 0, 1, 1, -1)" command does not complete in over 5 minutes.
- Database devices are created on iscsi storage
- Stacktrace looks like this:
kernel Direct i/o enabled for ufs file
kernel Initializing virtual device 3 with dsync 'off'
kernel Virtual device 3 started using asynchronous (with DIRECTIO) i/o.
Initializing device with zeros. kernel Finished initialization.
server Error: 692, Severity: 20, State: 1 Uninitialized logical page 'pagenumber' was read while accessing database , object, index, partition .
server Error: 1251, Severity: 26, State: 1
server An in-use preallocated semaphore cursor was encountered.
kernel SQL causing error : insert into #t1 (dbid) select dbid from master.dbo.sysdatabases where name like @dbname /* ** Now for each dbid in #spdbdesc, build t
kernel Current statement number: 41 Current line number: 211
kernel ************************************
server SQL Text: insert into #t1 (dbid) select dbid from master.dbo.sysdatabases where name like @dbname
Now for each dbid in #t1, build the database status ** description. */
server SQL Text: create table #t1 ( dbid smallint null, dbdesc varchar(777) null )
Initialize #t1 from sysdatabases
pcstkwalk+0x18()
ucstkgentrace+0x23c()
Read more...
Environment
- SAP Adaptive Server Enterprise (ASE) 15.7
- SAP Adaptive Server Enterprise (ASE) 16.0
Product
Keywords
hardware, fault, 605 , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Problem
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.