Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

error 696

4 posts in General Discussion Last posting was on 2012-11-07 23:52:00.0Z
thomas king Posted on 2012-09-03 08:54:52.0Z
Sender: 6ffb.50446dab.1804289383@sybase.com
From: thomas king
Newsgroups: sybase.public.ase.general
Subject: error 696
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <5044705c.708a.1681692777@sybase.com>
MIME-Version: 1.0
Content-Type: multipart/mixed; boundary="-=_forums-1-dub5044705c"
NNTP-Posting-Host: 172.20.134.41
X-Original-NNTP-Posting-Host: 172.20.134.41
Date: 3 Sep 2012 01:54:52 -0700
X-Trace: forums-1-dub 1346662492 172.20.134.41 (3 Sep 2012 01:54:52 -0700)
X-Original-Trace: 3 Sep 2012 01:54:52 -0700, 172.20.134.41
Lines: 283
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:31369
Article PK: 74260

i have been running ASE11.9.2 since 2003,i'm facing this
error(along with error 6103) which could not be solved by a
mere server restart.
pls see the attachment.
same error occured in 2007,and it just disappeared after
about 2 months.
if only you could give me some clue.
thx a lot!

thomas
xptking@hotmail.com

00:00000:00108:2012/09/03 16:17:32.12 server Starting diagnostics for read failure:
00:00000:00108:2012/09/03 16:17:32.12 server Device Information:
Device number = 22
Phyname = e:\cwdata\tempdev.dat
00:00000:00108:2012/09/03 16:17:32.12 server Buffer Information:
Buf addr = 0x766a9ca0, Mass addr = 0x766a9ca0
Buf pageno = 1140120, Mass pageno = 1140120, dbid = 2
00:00000:00108:2012/09/03 16:17:32.12 server
Buf virtpg = 370188696, Mass virtpg = 370188696
Buf stat = 0x1, Mass stat = 0x40001008
Mass keep = 1, Mass awaited = 0
00:00000:00108:2012/09/03 16:17:32.12 server Page Information from first read attempt:
Page read from cache
ppageno = 1140120, pobjid = -7077904, pindid = 0
pnextpg = 1140121, pprevpg = 1140135
plevel = 0, pstat = 0x5
pts_hi = 1, pts_lo = -1362562457
00:00000:00108:2012/09/03 16:17:32.12 server Page Information from second read attempt:
Page read from disk
ppageno = 1140120, pobjid = -7077904, pindid = 0
pnextpg = 1140121, pprevpg = 1140135
plevel = 0, pstat = 0x5
pts_hi = 1, pts_lo = -1362562457
00:00000:00108:2012/09/03 16:17:32.12 server SDES Information:
dbid = 2, objid = -7077905, scur.pageid = 1140120
sstat = 0x10, sstat2 = 0x0
suid = 3, cacheid = 2
00:00000:00108:2012/09/03 16:17:32.12 server PSS Information:
pstat = 0x10000, pcurdb = 5, pspid = 108
p2stat = 0x101000, p3stat = 0x81a
plasterror = 0, preverror = 0, pattention = 0
00:00000:00108:2012/09/03 16:17:32.12 server End diagnostics for read failure:
00:00000:00108:2012/09/03 16:17:32.12 server WARNING: Pss found with open sdes. pspid 108, psuid 489, pcurdb 5, range entry 17, sdesp 0x267df2fc, objid -7077905
00:00000:00108:2012/09/03 16:17:32.12 server Error: 6103, Severity: 17, State: 1
00:00000:00108:2012/09/03 16:17:32.12 server Unable to do cleanup for the killed process; received Msg 696.
00:00000:00108:2012/09/03 16:17:32.15 server Starting diagnostics for read failure:
00:00000:00108:2012/09/03 16:17:32.15 server Device Information:
Device number = 22
Phyname = e:\cwdata\tempdev.dat
00:00000:00108:2012/09/03 16:17:32.15 server Buffer Information:
Buf addr = 0x766a9ca0, Mass addr = 0x766a9ca0
Buf pageno = 1140120, Mass pageno = 1140120, dbid = 2
00:00000:00108:2012/09/03 16:17:32.15 server
Buf virtpg = 370188696, Mass virtpg = 370188696
Buf stat = 0x1, Mass stat = 0x1008
Mass keep = 1, Mass awaited = 0
00:00000:00108:2012/09/03 16:17:32.15 server Page Information from first read attempt:
Page read from disk
ppageno = 1140120, pobjid = -7077904, pindid = 0
pnextpg = 1140121, pprevpg = 1140135
plevel = 0, pstat = 0x5
pts_hi = 1, pts_lo = -1362562457
00:00000:00108:2012/09/03 16:17:32.15 server Page Information from second read attempt:
Page read from disk
ppageno = 1140120, pobjid = -7077904, pindid = 0
pnextpg = 1140121, pprevpg = 1140135
plevel = 0, pstat = 0x5
pts_hi = 1, pts_lo = -1362562457
00:00000:00108:2012/09/03 16:17:32.15 server SDES Information:
dbid = 2, objid = -7077905, scur.pageid = 1140120
sstat = 0x10, sstat2 = 0x0
suid = 3, cacheid = 2
00:00000:00108:2012/09/03 16:17:32.15 server PSS Information:
pstat = 0x10000, pcurdb = 6, pspid = 108
p2stat = 0x101000, p3stat = 0x81a
plasterror = 0, preverror = 0, pattention = 0
00:00000:00108:2012/09/03 16:17:32.15 server End diagnostics for read failure:
00:00000:00108:2012/09/03 16:17:32.15 server WARNING: Pss found with open sdes. pspid 108, psuid 376, pcurdb 6, range entry 17, sdesp 0x267df2fc, objid -7077905
00:00000:00108:2012/09/03 16:17:32.15 server Error: 6103, Severity: 17, State: 1
00:00000:00108:2012/09/03 16:17:32.15 server Unable to do cleanup for the killed process; received Msg 696.
00:00000:00108:2012/09/03 16:17:32.38 server Starting diagnostics for read failure:
00:00000:00108:2012/09/03 16:17:32.38 server Device Information:
Device number = 22
Phyname = e:\cwdata\tempdev.dat
00:00000:00108:2012/09/03 16:17:32.38 server Buffer Information:
Buf addr = 0x766a9ca0, Mass addr = 0x766a9ca0
Buf pageno = 1140120, Mass pageno = 1140120, dbid = 2
00:00000:00108:2012/09/03 16:17:32.38 server
Buf virtpg = 370188696, Mass virtpg = 370188696
Buf stat = 0x1, Mass stat = 0x1008
Mass keep = 1, Mass awaited = 0
00:00000:00108:2012/09/03 16:17:32.38 server Page Information from first read attempt:
Page read from disk
ppageno = 1140120, pobjid = -7077904, pindid = 0
pnextpg = 1140121, pprevpg = 1140135
plevel = 0, pstat = 0x5
pts_hi = 1, pts_lo = -1362562457
00:00000:00108:2012/09/03 16:17:32.38 server Page Information from second read attempt:
Page read from disk
ppageno = 1140120, pobjid = -7077904, pindid = 0
pnextpg = 1140121, pprevpg = 1140135
plevel = 0, pstat = 0x5
pts_hi = 1, pts_lo = -1362562457
00:00000:00108:2012/09/03 16:17:32.38 server SDES Information:
dbid = 2, objid = -7077905, scur.pageid = 1140120
sstat = 0x10, sstat2 = 0x0
suid = 3, cacheid = 2
00:00000:00108:2012/09/03 16:17:32.38 server PSS Information:
pstat = 0x10000, pcurdb = 6, pspid = 108
p2stat = 0x1000, p3stat = 0x81a
plasterror = 0, preverror = 0, pattention = 0
00:00000:00108:2012/09/03 16:17:32.38 server End diagnostics for read failure:
00:00000:00108:2012/09/03 16:17:32.38 server Error: 696, Severity: 21, State: 1
00:00000:00108:2012/09/03 16:17:32.38 server An attempt was made to fetch logical page '1140120' in tempdb from cache 'cachetemp'. Page belongs to object '-7077904' and not to object '-7077905'. Restart of SQL Server will clear the error. Please contact your System Administrator for help.
00:00000:00108:2012/09/03 16:17:32.38 kernel ************************************
00:00000:00108:2012/09/03 16:17:32.38 kernel SQL causing error : SELECT convert ( char ( 1 ) , datepart ( dw , getdate ( ) ) ) , convert ( char ( 2 ) , datepart ( hh , getdate ( ) ) ) from LSXTMC
00:00000:00108:2012/09/03 16:17:32.38 kernel ************************************
00:00000:00108:2012/09/03 16:17:32.38 server SQL Text: SELECT convert ( char ( 1 ) , datepart ( dw , getdate ( ) ) ) , convert ( char ( 2 ) , datepart ( hh , getdate ( ) ) ) from LSXTMC
00:00000:00108:2012/09/03 16:17:32.38 kernel curdb = 6 pstat = 0x10000 lasterror = 696
00:00000:00108:2012/09/03 16:17:32.38 kernel preverror = 0 transtate = 0
00:00000:00108:2012/09/03 16:17:32.38 kernel curcmd = 0 program = grft_FQ
00:00000:00108:2012/09/03 16:17:32.38 kernel pc: 0x8a2977 os_get_cur_stk_desc+ 0x57 (0x253f224, 0x1dab004a, 0x253f224, 0x0)
00:00000:00108:2012/09/03 16:17:32.38 kernel pc: 0x8a2977 os_get_cur_stk_desc+ 0x57 (0x253f224, 0x253f778, 0x270f, 0x2)
00:00000:00108:2012/09/03 16:17:32.38 kernel pc: 0x883514 pcstkwalk+ 0x224 (0x1dab004a, 0x2, 0x270f, 0x0)
00:00000:00108:2012/09/03 16:17:32.38 kernel pc: 0x8830ae ucstkgentrace+ 0x1ce (0x0, 0x1, 0x20da7a34, 0x0)
00:00000:00108:2012/09/03 16:17:32.38 kernel pc: 0x862864 ucbacktrace+ 0x84 (0x0, 0xffffffff, 0x253fb3c, 0x4527a8)
00:00000:00108:2012/09/03 16:17:32.38 kernel pc: 0x405fe6 terminate_process+ 0x566 (0x253fbb4, 0x4523bc, 0x6, 0x60)
00:00000:00108:2012/09/03 16:17:32.38 kernel pc: 0x4527ea close_network+ 0x1a (0x6, 0x60, 0x15, 0x1)
00:00000:00108:2012/09/03 16:17:32.38 kernel pc: 0x4527a8 hdl_default+ 0x48 (0x6, 0x60, 0x15, 0x1)
00:00000:00108:2012/09/03 16:17:32.38 kernel pc: 0x4523bc ex_raise+ 0x13c (0x766a9ca0, 0x20700bbc, 0x1, 0x1)
00:00000:00108:2012/09/03 16:17:32.38 kernel pc: 0x542d6e wrongpage+ 0x31e (0x20700bbc, 0x4, 0x0, 0x0)
00:00000:00108:2012/09/03 16:17:32.38 kernel pc: 0x540482 getpage_with_validation+ 0x232 (0x20700bbc, 0x253fd54, 0x4, 0x0)
00:00000:00108:2012/09/03 16:17:32.38 kernel pc: 0x5419eb getpage_noscan_with_validation+ 0x8b (0x20700bbc, 0x267df28c, 0x1, 0x0)
00:00000:00108:2012/09/03 16:17:32.38 kernel pc: 0x4f8577 pg_objdeall+ 0x137 (0x20700bbc, 0x20da255c, 0x0, 0x20021120)
00:00000:00108:2012/09/03 16:17:32.38 kernel pc: 0x52f60f closetable+ 0x23f (0x6, 0x10, 0xc, 0x0)
00:00000:00108:2012/09/03 16:17:32.38 kernel pc: 0x6511d1 close_range+ 0x2a1 (0x20da255c, 0x0, 0x0, 0x20da255c)
00:00000:00108:2012/09/03 16:17:32.38 kernel pc: 0x63a6ce s_cleanframe+ 0x4e (0x20da255c, 0x0, 0x20da255c, 0x1daa0092)
00:00000:00108:2012/09/03 16:17:32.38 kernel pc: 0x4106d0 clean_process+ 0x80 (0x20da255c, 0x200241b0, 0x1daa0092, 0x20021120)
00:00000:00108:2012/09/03 16:17:32.38 kernel pc: 0x40cc63 conn_hdlr_err_cleanup+ 0x83 (0x17, 0x4000, 0x200241b0, 0x1daa0092)
00:00000:00108:2012/09/03 16:17:32.38 kernel [Handler pc: 0x452660 hdl_backout installed by the following function:-]
00:00000:00108:2012/09/03 16:17:32.38 kernel [Handler pc: 0x5c0c40 ut_handle installed by the following function:-]
00:00000:00108:2012/09/03 16:17:32.38 kernel [Handler pc: 0x5c0c40 ut_handle installed by the following function:-]
00:00000:00108:2012/09/03 16:17:32.38 kernel pc: 0x40f0e4 conn_hdlr+ 0x2024 (0x200241b0, 0x20021120, 0x1daa0092, 0x200241b0)
00:00000:00108:2012/09/03 16:17:32.38 kernel pc: 0x89c1c6 kpntwrapper+ 0x96 (0x89c130, 0x200241b0, 0x0, 0x0)
00:00000:00108:2012/09/03 16:17:32.38 kernel pc: 0x77e6438b KERNEL32.dll (0x0, 0x0, 0x0, 0x0)
00:00000:00108:2012/09/03 16:17:32.38 kernel end of stack trace, spid 108, kpid 497745994, suid 376
00:00000:00108:2012/09/03 16:17:32.38 server Starting diagnostics for read failure:
00:00000:00108:2012/09/03 16:17:32.38 server Device Information:
Device number = 22
Phyname = e:\cwdata\tempdev.dat
00:00000:00108:2012/09/03 16:17:32.38 server Buffer Information:
Buf addr = 0x766a9ca0, Mass addr = 0x766a9ca0
Buf pageno = 1140120, Mass pageno = 1140120, dbid = 2
00:00000:00108:2012/09/03 16:17:32.38 server
Buf virtpg = 370188696, Mass virtpg = 370188696
Buf stat = 0x1, Mass stat = 0x40001008
Mass keep = 1, Mass awaited = 0
00:00000:00108:2012/09/03 16:17:32.38 server Page Information from first read attempt:
Page read from cache
ppageno = 1140120, pobjid = -7077904, pindid = 0
pnextpg = 1140121, pprevpg = 1140135
plevel = 0, pstat = 0x5
pts_hi = 1, pts_lo = -1362562457
00:00000:00108:2012/09/03 16:17:32.38 server Page Information from second read attempt:
Page read from disk
ppageno = 1140120, pobjid = -7077904, pindid = 0
pnextpg = 1140121, pprevpg = 1140135
plevel = 0, pstat = 0x5
pts_hi = 1, pts_lo = -1362562457
00:00000:00108:2012/09/03 16:17:32.38 server SDES Information:
dbid = 2, objid = -7077905, scur.pageid = 1140120
sstat = 0x10, sstat2 = 0x0
suid = 3, cacheid = 2
00:00000:00108:2012/09/03 16:17:32.38 server PSS Information:
pstat = 0x10000, pcurdb = 6, pspid = 108
p2stat = 0x101000, p3stat = 0x81a
plasterror = 696, preverror = 0, pattention = 0
00:00000:00108:2012/09/03 16:17:32.38 server End diagnostics for read failure:
00:00000:00108:2012/09/03 16:17:32.38 server WARNING: Pss found with open sdes. pspid 108, psuid 376, pcurdb 6, range entry 17, sdesp 0x267df2fc, objid -7077905
00:00000:00108:2012/09/03 16:17:32.38 server Error: 6103, Severity: 17, State: 1
00:00000:00108:2012/09/03 16:17:32.38 server Unable to do cleanup for the killed process; received Msg 696.


Jason L. Froebe [TeamSybase] Posted on 2012-09-05 17:25:05.0Z
From: "Jason L. Froebe [TeamSybase]" <jason.froebe@gmail.com>
Organization: TeamSybase
User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:15.0) Gecko/20120827 Thunderbird/15.0
MIME-Version: 1.0
Newsgroups: sybase.public.ase.general
Subject: Re: error 696
References: <5044705c.708a.1681692777@sybase.com>
In-Reply-To: <5044705c.708a.1681692777@sybase.com>
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <50478af1@forums-1-dub>
Date: 5 Sep 2012 10:25:05 -0700
X-Trace: forums-1-dub 1346865905 172.20.134.152 (5 Sep 2012 10:25:05 -0700)
X-Original-Trace: 5 Sep 2012 10:25:05 -0700, vip152.sybase.com
Lines: 20
X-Authenticated-User: TeamSybase
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:31372
Article PK: 74262


On 09/03/2012 03:54 AM, thomas king wrote:
> i have been running ASE11.9.2 since 2003,i'm facing this
> error(along with error 6103) which could not be solved by a
> mere server restart.
> pls see the attachment.
> same error occured in 2007,and it just disappeared after
> about 2 months.
> if only you could give me some clue.
> thx a lot!
>
> thomas
> xptking@hotmail.com
>

Well, since it is what I shall assume is a tempdb device, you should be
able to just restart the Sybase DB server to clear it.

What is the ebf level of your 11.9.2 server? (select @@version)

jason


thomas king Posted on 2012-09-06 02:17:08.0Z
Sender: 58e2.5047e4ed.1804289383@sybase.com
From: thomas king
Newsgroups: sybase.public.ase.general
Subject: Re: error 696
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <504807a4.640b.1681692777@sybase.com>
References: <50478af1@forums-1-dub>
MIME-Version: 1.0
Content-Type: multipart/mixed; boundary="-=_forums-1-dub504807a4"
NNTP-Posting-Host: 172.20.134.41
X-Original-NNTP-Posting-Host: 172.20.134.41
Date: 5 Sep 2012 19:17:08 -0700
X-Trace: forums-1-dub 1346897828 172.20.134.41 (5 Sep 2012 19:17:08 -0700)
X-Original-Trace: 5 Sep 2012 19:17:08 -0700, 172.20.134.41
Lines: 704
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:31374
Article PK: 74263


> On 09/03/2012 03:54 AM, thomas king wrote:
> > i have been running ASE11.9.2 since 2003,i'm facing this
> > error(along with error 6103) which could not be solved
> > by a mere server restart.
> > pls see the attachment.
> > same error occured in 2007,and it just disappeared after
> > about 2 months.
> > if only you could give me some clue.
> > thx a lot!
> >
> > thomas
> > xptking@hotmail.com
> >
>
> Well, since it is what I shall assume is a tempdb device,
> you should be able to just restart the Sybase DB server to
> clear it.
>
> What is the ebf level of your 11.9.2 server? (select
> @@version)
>
> jason

thx a lot.
select @@version result:
Adaptive Server Enterprise/11.9.2/1031/P/NT (IX86)/OS
3.51,4.0/FBU/Fri Aug 14 01:42:41 1998
OS:windows2000 server with SP4
i'm sending some more errorlog to help.errors happends
occasionally but ti seems that the server is still working
all right.
it's a tempdb device,i tried to restart the server several
days ago,but it happened again in 24hrs.

02:00000:00108:2012/09/06 09:00:59.15 server Starting diagnostics for read failure:
02:00000:00108:2012/09/06 09:00:59.15 server Device Information:
Device number = 22
Phyname = e:\cwdata\tempdev.dat
02:00000:00108:2012/09/06 09:00:59.15 server Buffer Information:
Buf addr = 0x76629c80, Mass addr = 0x76629c80
Buf pageno = 1140120, Mass pageno = 1140120, dbid = 2
02:00000:00108:2012/09/06 09:00:59.15 server
Buf virtpg = 370188696, Mass virtpg = 370188696
Buf stat = 0x1, Mass stat = 0x40001008
Mass keep = 1, Mass awaited = 0
02:00000:00108:2012/09/06 09:00:59.15 server Page Information from first read attempt:
Page read from cache
ppageno = 1140120, pobjid = -7077904, pindid = 0
pnextpg = 1140121, pprevpg = 1140135
plevel = 0, pstat = 0x5
pts_hi = 1, pts_lo = -1362562457
02:00000:00108:2012/09/06 09:00:59.15 server Page Information from second read attempt:
Page read from disk
ppageno = 1140120, pobjid = -7077904, pindid = 0
pnextpg = 1140121, pprevpg = 1140135
plevel = 0, pstat = 0x5
pts_hi = 1, pts_lo = -1362562457
02:00000:00108:2012/09/06 09:00:59.15 server SDES Information:
dbid = 2, objid = -7077905, scur.pageid = 1140120
sstat = 0x10, sstat2 = 0x0
suid = 3, cacheid = 2
02:00000:00108:2012/09/06 09:00:59.15 server PSS Information:
pstat = 0x10000, pcurdb = 10, pspid = 108
p2stat = 0x1000, p3stat = 0x81a
plasterror = 2812, preverror = 0, pattention = 0
02:00000:00108:2012/09/06 09:00:59.15 server End diagnostics for read failure:
02:00000:00108:2012/09/06 09:00:59.15 server Error: 696, Severity: 21, State: 1
02:00000:00108:2012/09/06 09:00:59.15 server An attempt was made to fetch logical page '1140120' in tempdb from cache 'cachetemp'. Page belongs to object '-7077904' and not to object '-7077905'. Restart of SQL Server will clear the error. Please contact your System Administrator for help.
02:00000:00108:2012/09/06 09:00:59.15 kernel ************************************
02:00000:00108:2012/09/06 09:00:59.15 kernel SQL causing error : exec Sp_SeRvEr_InFo
02:00000:00108:2012/09/06 09:00:59.15 kernel ************************************
02:00000:00108:2012/09/06 09:00:59.15 server SQL Text: exec Sp_SeRvEr_InFo
02:00000:00108:2012/09/06 09:00:59.15 kernel curdb = 10 pstat = 0x10000 lasterror = 696
02:00000:00108:2012/09/06 09:00:59.15 kernel preverror = 0 transtate = 1
02:00000:00108:2012/09/06 09:00:59.15 kernel curcmd = 224 program = Brio Intelligence - [ü欄ûš·¡
02:00000:00108:2012/09/06 09:00:59.15 kernel pc: 0x8a2977 os_get_cur_stk_desc+ 0x57 (0x3ddef30, 0x2f4a0004, 0x3ddef30, 0x0)
02:00000:00108:2012/09/06 09:00:59.15 kernel pc: 0x8a2977 os_get_cur_stk_desc+ 0x57 (0x3ddef30, 0x3ddf484, 0x270f, 0x2)
02:00000:00108:2012/09/06 09:00:59.15 kernel pc: 0x883514 pcstkwalk+ 0x224 (0x2f4a0004, 0x2, 0x270f, 0x0)
02:00000:00108:2012/09/06 09:00:59.15 kernel pc: 0x8830ae ucstkgentrace+ 0x1ce (0x0, 0x1, 0x15, 0x0)
02:00000:00108:2012/09/06 09:00:59.15 kernel pc: 0x862864 ucbacktrace+ 0x84 (0x0, 0xffffffff, 0x3ddf848, 0x4527a8)
02:00000:00108:2012/09/06 09:00:59.15 kernel pc: 0x405fe6 terminate_process+ 0x566 (0x3ddf8a8, 0x639a02, 0x6, 0x60)
02:00000:00108:2012/09/06 09:00:59.15 kernel pc: 0x4527ea close_network+ 0x1a (0x6, 0x60, 0x15, 0x1)
02:00000:00108:2012/09/06 09:00:59.15 kernel pc: 0x4527a8 hdl_default+ 0x48 (0x6, 0x60, 0x15, 0x1)
02:00000:00108:2012/09/06 09:00:59.15 kernel pc: 0x639a02 s_handle+ 0x162 (0x6, 0x60, 0x15, 0x1)
02:00000:00108:2012/09/06 09:00:59.15 kernel pc: 0x452413 ex_raise+ 0x193 (0x76629c80, 0x20700bbc, 0x1, 0x0)
02:00000:00108:2012/09/06 09:00:59.15 kernel pc: 0x542d6e wrongpage+ 0x31e (0x20700bbc, 0x4, 0x0, 0x0)
02:00000:00108:2012/09/06 09:00:59.15 kernel pc: 0x540482 getpage_with_validation+ 0x232 (0x20700bbc, 0x3ddfac0, 0x4, 0x0)
02:00000:00108:2012/09/06 09:00:59.15 kernel pc: 0x5419eb getpage_noscan_with_validation+ 0x8b (0x20700bbc, 0x267df28c, 0x1, 0x0)
02:00000:00108:2012/09/06 09:00:59.15 kernel pc: 0x4f8577 pg_objdeall+ 0x137 (0x20700bbc, 0x20da255c, 0x0, 0x0)
02:00000:00108:2012/09/06 09:00:59.15 kernel pc: 0x52f60f closetable+ 0x23f (0x6, 0x10, 0xc, 0x0)
02:00000:00108:2012/09/06 09:00:59.15 kernel pc: 0x6511d1 close_range+ 0x2a1 (0x24, 0x4, 0x19, 0x0)
02:00000:00108:2012/09/06 09:00:59.15 kernel pc: 0x63a0e2 s_handle+ 0x842 (0x24, 0x4, 0x19, 0x0)
02:00000:00108:2012/09/06 09:00:59.15 kernel pc: 0x452413 ex_raise+ 0x193 (0x2414c3a0, 0x2414c418, 0x0, 0x0)
02:00000:00108:2012/09/06 09:00:59.15 kernel pc: 0x65a301 execproc+ 0x801 (0x21, 0x20da255c, 0x20da255c, 0x20a79678)
02:00000:00108:2012/09/06 09:00:59.15 kernel pc: 0x65467a s_execute+ 0x213a (0x26ac4000, 0x21, 0x20da9799, 0x20da255c)
02:00000:00108:2012/09/06 09:00:59.15 kernel [Handler pc: 0x6398a0 s_handle installed by the following function:-]
02:00000:00108:2012/09/06 09:00:59.15 kernel pc: 0x63678f sequencer+ 0x15f (0x0, 0x200213c0, 0x2ccd0056, 0x20021120)
02:00000:00108:2012/09/06 09:00:59.15 kernel pc: 0x436d31 tdsrecv_language+ 0xc1 (0x52, 0x4000, 0x200213c0, 0x2ccd0056)
02:00000:00108:2012/09/06 09:00:59.15 kernel [Handler pc: 0x452660 hdl_backout installed by the following function:-]
02:00000:00108:2012/09/06 09:00:59.15 kernel [Handler pc: 0x5c0c40 ut_handle installed by the following function:-]
02:00000:00108:2012/09/06 09:00:59.15 kernel [Handler pc: 0x5c0c40 ut_handle installed by the following function:-]
02:00000:00108:2012/09/06 09:00:59.15 kernel pc: 0x40dc1c conn_hdlr+ 0xb5c (0x200213c0, 0x20021120, 0x2ccd0056, 0x200213c0)
02:00000:00108:2012/09/06 09:00:59.15 kernel pc: 0x89c1c6 kpntwrapper+ 0x96 (0x89c130, 0x200213c0, 0x0, 0x0)
02:00000:00108:2012/09/06 09:00:59.15 kernel pc: 0x77e6438b KERNEL32.dll (0x0, 0x2039b0d0, 0x364fcec, 0x0)
02:00000:00108:2012/09/06 09:00:59.15 kernel pc: 0x77e61608 KERNEL32.dll (0x1, 0x364fe4c, 0x653336, 0x20c24b98)
02:00000:00108:2012/09/06 09:00:59.17 kernel pc: 0x20c29bf4 (can't find module)(0x0, 0x0, 0x0, 0x0)
02:00000:00108:2012/09/06 09:00:59.17 kernel end of stack trace, spid 108, kpid 793378820, suid 13
02:00000:00108:2012/09/06 09:00:59.17 server Starting diagnostics for read failure:
02:00000:00108:2012/09/06 09:00:59.17 server Device Information:
Device number = 22
Phyname = e:\cwdata\tempdev.dat
02:00000:00108:2012/09/06 09:00:59.17 server Buffer Information:
Buf addr = 0x76629c80, Mass addr = 0x76629c80
Buf pageno = 1140120, Mass pageno = 1140120, dbid = 2
02:00000:00108:2012/09/06 09:00:59.17 server
Buf virtpg = 370188696, Mass virtpg = 370188696
Buf stat = 0x1, Mass stat = 0x40001008
Mass keep = 1, Mass awaited = 0
02:00000:00108:2012/09/06 09:00:59.17 server Page Information from first read attempt:
Page read from cache
ppageno = 1140120, pobjid = -7077904, pindid = 0
pnextpg = 1140121, pprevpg = 1140135
plevel = 0, pstat = 0x5
pts_hi = 1, pts_lo = -1362562457
02:00000:00108:2012/09/06 09:00:59.17 server Page Information from second read attempt:
Page read from disk
ppageno = 1140120, pobjid = -7077904, pindid = 0
pnextpg = 1140121, pprevpg = 1140135
plevel = 0, pstat = 0x5
pts_hi = 1, pts_lo = -1362562457
02:00000:00108:2012/09/06 09:00:59.17 server SDES Information:
dbid = 2, objid = -7077905, scur.pageid = 1140120
sstat = 0x10, sstat2 = 0x0
suid = 3, cacheid = 2
02:00000:00108:2012/09/06 09:00:59.17 server PSS Information:
pstat = 0x10000, pcurdb = 10, pspid = 108
p2stat = 0x101000, p3stat = 0x81a
plasterror = 696, preverror = 0, pattention = 0
02:00000:00108:2012/09/06 09:00:59.17 server End diagnostics for read failure:
02:00000:00108:2012/09/06 09:00:59.17 server WARNING: Pss found with open sdes. pspid 108, psuid 13, pcurdb 10, range entry 17, sdesp 0x267df2fc, objid -7077905
02:00000:00108:2012/09/06 09:00:59.17 server Error: 6103, Severity: 17, State: 1
02:00000:00108:2012/09/06 09:00:59.17 server Unable to do cleanup for the killed process; received Msg 696.
02:00000:00108:2012/09/06 09:00:59.25 server Starting diagnostics for read failure:
02:00000:00108:2012/09/06 09:00:59.25 server Device Information:
Device number = 22
Phyname = e:\cwdata\tempdev.dat
02:00000:00108:2012/09/06 09:00:59.25 server Buffer Information:
Buf addr = 0x76629c80, Mass addr = 0x76629c80
Buf pageno = 1140120, Mass pageno = 1140120, dbid = 2
02:00000:00108:2012/09/06 09:00:59.25 server
Buf virtpg = 370188696, Mass virtpg = 370188696
Buf stat = 0x1, Mass stat = 0x40001008
Mass keep = 1, Mass awaited = 0
02:00000:00108:2012/09/06 09:00:59.25 server Page Information from first read attempt:
Page read from cache
ppageno = 1140120, pobjid = -7077904, pindid = 0
pnextpg = 1140121, pprevpg = 1140135
plevel = 0, pstat = 0x5
pts_hi = 1, pts_lo = -1362562457
02:00000:00108:2012/09/06 09:00:59.25 server Page Information from second read attempt:
Page read from disk
ppageno = 1140120, pobjid = -7077904, pindid = 0
pnextpg = 1140121, pprevpg = 1140135
plevel = 0, pstat = 0x5
pts_hi = 1, pts_lo = -1362562457
02:00000:00108:2012/09/06 09:00:59.25 server SDES Information:
dbid = 2, objid = -7077905, scur.pageid = 1140120
sstat = 0x10, sstat2 = 0x0
suid = 3, cacheid = 2
02:00000:00108:2012/09/06 09:00:59.25 server PSS Information:
pstat = 0x10000, pcurdb = 10, pspid = 108
p2stat = 0x1000, p3stat = 0x81a
plasterror = 2812, preverror = 0, pattention = 0
02:00000:00108:2012/09/06 09:00:59.25 server End diagnostics for read failure:
02:00000:00108:2012/09/06 09:00:59.25 server Error: 696, Severity: 21, State: 1
02:00000:00108:2012/09/06 09:00:59.25 server An attempt was made to fetch logical page '1140120' in tempdb from cache 'cachetemp'. Page belongs to object '-7077904' and not to object '-7077905'. Restart of SQL Server will clear the error. Please contact your System Administrator for help.
02:00000:00108:2012/09/06 09:00:59.25 kernel ************************************
02:00000:00108:2012/09/06 09:00:59.25 kernel SQL causing error : exec Sp_SeRvEr_InFo
02:00000:00108:2012/09/06 09:00:59.25 kernel ************************************
02:00000:00108:2012/09/06 09:00:59.25 server SQL Text: exec Sp_SeRvEr_InFo
02:00000:00108:2012/09/06 09:00:59.25 kernel curdb = 10 pstat = 0x10000 lasterror = 696
02:00000:00108:2012/09/06 09:00:59.25 kernel preverror = 0 transtate = 1
02:00000:00108:2012/09/06 09:00:59.25 kernel curcmd = 224 program = Brio Intelligence - [ü欄ûš·¡
02:00000:00108:2012/09/06 09:00:59.25 kernel pc: 0x8a2977 os_get_cur_stk_desc+ 0x57 (0x3ddef30, 0x2f4b0072, 0x3ddef30, 0x0)
02:00000:00108:2012/09/06 09:00:59.25 kernel pc: 0x8a2977 os_get_cur_stk_desc+ 0x57 (0x3ddef30, 0x3ddf484, 0x270f, 0x2)
02:00000:00108:2012/09/06 09:00:59.25 kernel pc: 0x883514 pcstkwalk+ 0x224 (0x2f4b0072, 0x2, 0x270f, 0x0)
02:00000:00108:2012/09/06 09:00:59.25 kernel pc: 0x8830ae ucstkgentrace+ 0x1ce (0x0, 0x1, 0x15, 0x0)
02:00000:00108:2012/09/06 09:00:59.25 kernel pc: 0x862864 ucbacktrace+ 0x84 (0x0, 0xffffffff, 0x3ddf848, 0x4527a8)
02:00000:00108:2012/09/06 09:00:59.25 kernel pc: 0x405fe6 terminate_process+ 0x566 (0x3ddf8a8, 0x639a02, 0x6, 0x60)
02:00000:00108:2012/09/06 09:00:59.25 kernel pc: 0x4527ea close_network+ 0x1a (0x6, 0x60, 0x15, 0x1)
02:00000:00108:2012/09/06 09:00:59.25 kernel pc: 0x4527a8 hdl_default+ 0x48 (0x6, 0x60, 0x15, 0x1)
02:00000:00108:2012/09/06 09:00:59.25 kernel pc: 0x639a02 s_handle+ 0x162 (0x6, 0x60, 0x15, 0x1)
02:00000:00108:2012/09/06 09:00:59.25 kernel pc: 0x452413 ex_raise+ 0x193 (0x76629c80, 0x20700bbc, 0x1, 0x0)
02:00000:00108:2012/09/06 09:00:59.25 kernel pc: 0x542d6e wrongpage+ 0x31e (0x20700bbc, 0x4, 0x0, 0x0)
02:00000:00108:2012/09/06 09:00:59.25 kernel pc: 0x540482 getpage_with_validation+ 0x232 (0x20700bbc, 0x3ddfac0, 0x4, 0x0)
02:00000:00108:2012/09/06 09:00:59.25 kernel pc: 0x5419eb getpage_noscan_with_validation+ 0x8b (0x20700bbc, 0x267df28c, 0x1, 0x0)
02:00000:00108:2012/09/06 09:00:59.25 kernel pc: 0x4f8577 pg_objdeall+ 0x137 (0x20700bbc, 0x20da255c, 0x0, 0x0)
02:00000:00108:2012/09/06 09:00:59.25 kernel pc: 0x52f60f closetable+ 0x23f (0x6, 0x10, 0xc, 0x0)
02:00000:00108:2012/09/06 09:00:59.25 kernel pc: 0x6511d1 close_range+ 0x2a1 (0x24, 0x4, 0x19, 0x0)
02:00000:00108:2012/09/06 09:00:59.25 kernel pc: 0x63a0e2 s_handle+ 0x842 (0x24, 0x4, 0x19, 0x0)
02:00000:00108:2012/09/06 09:00:59.25 kernel pc: 0x452413 ex_raise+ 0x193 (0x26ac43a0, 0x26ac4418, 0x0, 0x0)
02:00000:00108:2012/09/06 09:00:59.25 kernel pc: 0x65a301 execproc+ 0x801 (0x21, 0x20da255c, 0x20da255c, 0x20a79678)
02:00000:00108:2012/09/06 09:00:59.25 kernel pc: 0x65467a s_execute+ 0x213a (0x26a04800, 0x21, 0x20da9799, 0x20da255c)
02:00000:00108:2012/09/06 09:00:59.25 kernel [Handler pc: 0x6398a0 s_handle installed by the following function:-]
02:00000:00108:2012/09/06 09:00:59.25 kernel pc: 0x63678f sequencer+ 0x15f (0x0, 0x20025bf0, 0x2f4a0004, 0x20021120)
02:00000:00108:2012/09/06 09:00:59.25 kernel pc: 0x436d31 tdsrecv_language+ 0xc1 (0x52, 0x4000, 0x20025bf0, 0x2f4a0004)
02:00000:00108:2012/09/06 09:00:59.25 kernel [Handler pc: 0x452660 hdl_backout installed by the following function:-]
02:00000:00108:2012/09/06 09:00:59.25 kernel [Handler pc: 0x5c0c40 ut_handle installed by the following function:-]
02:00000:00108:2012/09/06 09:00:59.25 kernel [Handler pc: 0x5c0c40 ut_handle installed by the following function:-]
02:00000:00108:2012/09/06 09:00:59.25 kernel pc: 0x40dc1c conn_hdlr+ 0xb5c (0x20025bf0, 0x20021120, 0x2f4a0004, 0x20025bf0)
02:00000:00108:2012/09/06 09:00:59.25 kernel pc: 0x89c1c6 kpntwrapper+ 0x96 (0x89c130, 0x20025bf0, 0x0, 0x0)
02:00000:00108:2012/09/06 09:00:59.25 kernel pc: 0x77e6438b KERNEL32.dll (0x2, 0x270f, 0x0, 0x0)
02:00000:00108:2012/09/06 09:00:59.25 kernel pc: 0x77e61608 KERNEL32.dll (0x438b1174, 0x400a908, 0x7740000, 0x8510438b)
02:00000:00108:2012/09/06 09:00:59.25 kernel pc: 0x2f4b0072 (can't find module)(0x0, 0x0, 0x0, 0x0)
02:00000:00108:2012/09/06 09:00:59.25 kernel end of stack trace, spid 108, kpid 793444466, suid 13
02:00000:00108:2012/09/06 09:00:59.25 server Starting diagnostics for read failure:
02:00000:00108:2012/09/06 09:00:59.25 server Device Information:
Device number = 22
Phyname = e:\cwdata\tempdev.dat
02:00000:00108:2012/09/06 09:00:59.25 server Buffer Information:
Buf addr = 0x76629c80, Mass addr = 0x76629c80
Buf pageno = 1140120, Mass pageno = 1140120, dbid = 2
02:00000:00108:2012/09/06 09:00:59.25 server
Buf virtpg = 370188696, Mass virtpg = 370188696
Buf stat = 0x1, Mass stat = 0x40001008
Mass keep = 1, Mass awaited = 0
02:00000:00108:2012/09/06 09:00:59.25 server Page Information from first read attempt:
Page read from cache
ppageno = 1140120, pobjid = -7077904, pindid = 0
pnextpg = 1140121, pprevpg = 1140135
plevel = 0, pstat = 0x5
pts_hi = 1, pts_lo = -1362562457
02:00000:00108:2012/09/06 09:00:59.25 server Page Information from second read attempt:
Page read from disk
ppageno = 1140120, pobjid = -7077904, pindid = 0
pnextpg = 1140121, pprevpg = 1140135
plevel = 0, pstat = 0x5
pts_hi = 1, pts_lo = -1362562457
02:00000:00108:2012/09/06 09:00:59.25 server SDES Information:
dbid = 2, objid = -7077905, scur.pageid = 1140120
sstat = 0x10, sstat2 = 0x0
suid = 3, cacheid = 2
02:00000:00108:2012/09/06 09:00:59.25 server PSS Information:
pstat = 0x10000, pcurdb = 10, pspid = 108
p2stat = 0x101000, p3stat = 0x81a
plasterror = 696, preverror = 0, pattention = 0
02:00000:00108:2012/09/06 09:00:59.25 server End diagnostics for read failure:
02:00000:00108:2012/09/06 09:00:59.25 server WARNING: Pss found with open sdes. pspid 108, psuid 13, pcurdb 10, range entry 17, sdesp 0x267df2fc, objid -7077905
02:00000:00108:2012/09/06 09:00:59.25 server Error: 6103, Severity: 17, State: 1
02:00000:00108:2012/09/06 09:00:59.25 server Unable to do cleanup for the killed process; received Msg 696.
03:00000:00108:2012/09/06 09:09:45.11 server Starting diagnostics for read failure:
03:00000:00108:2012/09/06 09:09:45.11 server Device Information:
Device number = 22
Phyname = e:\cwdata\tempdev.dat
03:00000:00108:2012/09/06 09:09:45.11 server Buffer Information:
Buf addr = 0x76629c80, Mass addr = 0x76629c80
Buf pageno = 1140120, Mass pageno = 1140120, dbid = 2
03:00000:00108:2012/09/06 09:09:45.11 server
Buf virtpg = 370188696, Mass virtpg = 370188696
Buf stat = 0x1, Mass stat = 0x40001008
Mass keep = 1, Mass awaited = 0
03:00000:00108:2012/09/06 09:09:45.11 server Page Information from first read attempt:
Page read from cache
ppageno = 1140120, pobjid = -7077904, pindid = 0
pnextpg = 1140121, pprevpg = 1140135
plevel = 0, pstat = 0x5
pts_hi = 1, pts_lo = -1362562457
03:00000:00108:2012/09/06 09:09:45.11 server Page Information from second read attempt:
Page read from disk
ppageno = 1140120, pobjid = -7077904, pindid = 0
pnextpg = 1140121, pprevpg = 1140135
plevel = 0, pstat = 0x5
pts_hi = 1, pts_lo = -1362562457
03:00000:00108:2012/09/06 09:09:45.11 server SDES Information:
dbid = 2, objid = -7077905, scur.pageid = 1140120
sstat = 0x10, sstat2 = 0x0
suid = 3, cacheid = 2
03:00000:00108:2012/09/06 09:09:45.11 server PSS Information:
pstat = 0x10000, pcurdb = 12, pspid = 108
p2stat = 0x1000, p3stat = 0x81a
plasterror = 2812, preverror = 0, pattention = 0
03:00000:00108:2012/09/06 09:09:45.11 server End diagnostics for read failure:
03:00000:00108:2012/09/06 09:09:45.11 server Error: 696, Severity: 21, State: 1
03:00000:00108:2012/09/06 09:09:45.11 server An attempt was made to fetch logical page '1140120' in tempdb from cache 'cachetemp'. Page belongs to object '-7077904' and not to object '-7077905'. Restart of SQL Server will clear the error. Please contact your System Administrator for help.
03:00000:00108:2012/09/06 09:09:45.11 kernel ************************************
03:00000:00108:2012/09/06 09:09:45.11 kernel SQL causing error : exec Sp_SeRvEr_InFo
03:00000:00108:2012/09/06 09:09:45.11 kernel ************************************
03:00000:00108:2012/09/06 09:09:45.11 server SQL Text: exec Sp_SeRvEr_InFo
03:00000:00108:2012/09/06 09:09:45.11 kernel curdb = 12 pstat = 0x10000 lasterror = 696
03:00000:00108:2012/09/06 09:09:45.11 kernel preverror = 0 transtate = 1
03:00000:00108:2012/09/06 09:09:45.11 kernel curcmd = 224 program = Brio Intelligence - [ü欄ûš·¡
03:00000:00108:2012/09/06 09:09:45.11 kernel pc: 0x8a2977 os_get_cur_stk_desc+ 0x57 (0x3ddef30, 0x2f61005c, 0x3ddef30, 0x0)
03:00000:00108:2012/09/06 09:09:45.11 kernel pc: 0x8a2977 os_get_cur_stk_desc+ 0x57 (0x3ddef30, 0x3ddf484, 0x270f, 0x2)
03:00000:00108:2012/09/06 09:09:45.11 kernel pc: 0x883514 pcstkwalk+ 0x224 (0x2f61005c, 0x2, 0x270f, 0x0)
03:00000:00108:2012/09/06 09:09:45.11 kernel pc: 0x8830ae ucstkgentrace+ 0x1ce (0x0, 0x1, 0x15, 0x0)
03:00000:00108:2012/09/06 09:09:45.11 kernel pc: 0x862864 ucbacktrace+ 0x84 (0x0, 0xffffffff, 0x3ddf848, 0x4527a8)
03:00000:00108:2012/09/06 09:09:45.11 kernel pc: 0x405fe6 terminate_process+ 0x566 (0x3ddf8a8, 0x639a02, 0x6, 0x60)
03:00000:00108:2012/09/06 09:09:45.11 kernel pc: 0x4527ea close_network+ 0x1a (0x6, 0x60, 0x15, 0x1)
03:00000:00108:2012/09/06 09:09:45.11 kernel pc: 0x4527a8 hdl_default+ 0x48 (0x6, 0x60, 0x15, 0x1)
03:00000:00108:2012/09/06 09:09:45.11 kernel pc: 0x639a02 s_handle+ 0x162 (0x6, 0x60, 0x15, 0x1)
03:00000:00108:2012/09/06 09:09:45.11 kernel pc: 0x452413 ex_raise+ 0x193 (0x76629c80, 0x20700bbc, 0x1, 0x0)
03:00000:00108:2012/09/06 09:09:45.11 kernel pc: 0x542d6e wrongpage+ 0x31e (0x20700bbc, 0x4, 0x0, 0x0)
03:00000:00108:2012/09/06 09:09:45.11 kernel pc: 0x540482 getpage_with_validation+ 0x232 (0x20700bbc, 0x3ddfac0, 0x4, 0x0)
03:00000:00108:2012/09/06 09:09:45.11 kernel pc: 0x5419eb getpage_noscan_with_validation+ 0x8b (0x20700bbc, 0x267df28c, 0x1, 0x0)
03:00000:00108:2012/09/06 09:09:45.11 kernel pc: 0x4f8577 pg_objdeall+ 0x137 (0x20700bbc, 0x20da255c, 0x0, 0x0)
03:00000:00108:2012/09/06 09:09:45.11 kernel pc: 0x52f60f closetable+ 0x23f (0x6, 0x10, 0xc, 0x0)
03:00000:00108:2012/09/06 09:09:45.11 kernel pc: 0x6511d1 close_range+ 0x2a1 (0x24, 0x4, 0x19, 0x0)
03:00000:00108:2012/09/06 09:09:45.11 kernel pc: 0x63a0e2 s_handle+ 0x842 (0x24, 0x4, 0x19, 0x0)
03:00000:00108:2012/09/06 09:09:45.11 kernel pc: 0x452413 ex_raise+ 0x193 (0x240e23a0, 0x240e2418, 0x0, 0x0)
03:00000:00108:2012/09/06 09:09:45.11 kernel pc: 0x65a301 execproc+ 0x801 (0x21, 0x20da255c, 0x20da255c, 0x20a79678)
03:00000:00108:2012/09/06 09:09:45.11 kernel pc: 0x65467a s_execute+ 0x213a (0x24120000, 0x21, 0x20da9799, 0x20da255c)
03:00000:00108:2012/09/06 09:09:45.11 kernel [Handler pc: 0x6398a0 s_handle installed by the following function:-]
03:00000:00108:2012/09/06 09:09:45.11 kernel pc: 0x63678f sequencer+ 0x15f (0x0, 0x20024d80, 0x2f4b0072, 0x20021120)
03:00000:00108:2012/09/06 09:09:45.11 kernel pc: 0x436d31 tdsrecv_language+ 0xc1 (0x52, 0x4000, 0x20024d80, 0x2f4b0072)
03:00000:00108:2012/09/06 09:09:45.11 kernel [Handler pc: 0x452660 hdl_backout installed by the following function:-]
03:00000:00108:2012/09/06 09:09:45.11 kernel [Handler pc: 0x5c0c40 ut_handle installed by the following function:-]
03:00000:00108:2012/09/06 09:09:45.11 kernel [Handler pc: 0x5c0c40 ut_handle installed by the following function:-]
03:00000:00108:2012/09/06 09:09:45.11 kernel pc: 0x40dc1c conn_hdlr+ 0xb5c (0x20024d80, 0x20021120, 0x2f4b0072, 0x20024d80)
03:00000:00108:2012/09/06 09:09:45.11 kernel pc: 0x89c1c6 kpntwrapper+ 0x96 (0x89c130, 0x20024d80, 0x0, 0x0)
03:00000:00108:2012/09/06 09:09:45.11 kernel pc: 0x77e6438b KERNEL32.dll (0x2, 0x270f, 0x0, 0x0)
03:00000:00108:2012/09/06 09:09:45.11 kernel pc: 0x77e61608 KERNEL32.dll (0x438b1174, 0x400a908, 0x7740000, 0x8510438b)
03:00000:00108:2012/09/06 09:09:45.13 kernel pc: 0x2f61005c (can't find module)(0x0, 0x0, 0x0, 0x0)
03:00000:00108:2012/09/06 09:09:45.13 kernel end of stack trace, spid 108, kpid 794886236, suid 17
03:00000:00108:2012/09/06 09:09:45.13 server Starting diagnostics for read failure:
03:00000:00108:2012/09/06 09:09:45.13 server Device Information:
Device number = 22
Phyname = e:\cwdata\tempdev.dat
03:00000:00108:2012/09/06 09:09:45.13 server Buffer Information:
Buf addr = 0x76629c80, Mass addr = 0x76629c80
Buf pageno = 1140120, Mass pageno = 1140120, dbid = 2
03:00000:00108:2012/09/06 09:09:45.13 server
Buf virtpg = 370188696, Mass virtpg = 370188696
Buf stat = 0x1, Mass stat = 0x40001008
Mass keep = 1, Mass awaited = 0
03:00000:00108:2012/09/06 09:09:45.13 server Page Information from first read attempt:
Page read from cache
ppageno = 1140120, pobjid = -7077904, pindid = 0
pnextpg = 1140121, pprevpg = 1140135
plevel = 0, pstat = 0x5
pts_hi = 1, pts_lo = -1362562457
03:00000:00108:2012/09/06 09:09:45.15 server Page Information from second read attempt:
Page read from disk
ppageno = 1140120, pobjid = -7077904, pindid = 0
pnextpg = 1140121, pprevpg = 1140135
plevel = 0, pstat = 0x5
pts_hi = 1, pts_lo = -1362562457
03:00000:00108:2012/09/06 09:09:45.15 server SDES Information:
dbid = 2, objid = -7077905, scur.pageid = 1140120
sstat = 0x10, sstat2 = 0x0
suid = 3, cacheid = 2
03:00000:00108:2012/09/06 09:09:45.15 server PSS Information:
pstat = 0x10000, pcurdb = 12, pspid = 108
p2stat = 0x101000, p3stat = 0x81a
plasterror = 696, preverror = 0, pattention = 0
03:00000:00108:2012/09/06 09:09:45.15 server End diagnostics for read failure:
03:00000:00108:2012/09/06 09:09:45.15 server WARNING: Pss found with open sdes. pspid 108, psuid 17, pcurdb 12, range entry 17, sdesp 0x267df2fc, objid -7077905
03:00000:00108:2012/09/06 09:09:45.15 server Error: 6103, Severity: 17, State: 1
03:00000:00108:2012/09/06 09:09:45.15 server Unable to do cleanup for the killed process; received Msg 696.
00:00000:00103:2012/09/06 09:48:12.79 server Starting diagnostics for read failure:
00:00000:00103:2012/09/06 09:48:12.79 server Device Information:
Device number = 22
Phyname = e:\cwdata\tempdev.dat
00:00000:00103:2012/09/06 09:48:12.79 server Buffer Information:
Buf addr = 0x7667e4a0, Mass addr = 0x7667e4a0
Buf pageno = 1379088, Mass pageno = 1379088, dbid = 2
00:00000:00103:2012/09/06 09:48:12.79 server
Buf virtpg = 370427664, Mass virtpg = 370427664
Buf stat = 0x1, Mass stat = 0x40001008
Mass keep = 1, Mass awaited = 0
00:00000:00103:2012/09/06 09:48:12.79 server Page Information from first read attempt:
Page read from cache
ppageno = 1379088, pobjid = -4522000, pindid = 0
pnextpg = 1379089, pprevpg = 1379079
plevel = 0, pstat = 0x101
pts_hi = 1, pts_lo = -257108537
00:00000:00103:2012/09/06 09:48:12.79 server Page Information from second read attempt:
Page read from disk
ppageno = 1379088, pobjid = -4522000, pindid = 0
pnextpg = 1379089, pprevpg = 1379079
plevel = 0, pstat = 0x101
pts_hi = 1, pts_lo = -257108537
00:00000:00103:2012/09/06 09:48:12.79 server SDES Information:
dbid = 2, objid = -6750224, scur.pageid = 1379088
sstat = 0x10, sstat2 = 0x0
suid = 3, cacheid = 2
00:00000:00103:2012/09/06 09:48:12.79 server PSS Information:
pstat = 0x10000, pcurdb = 12, pspid = 103
p2stat = 0x101000, p3stat = 0x81a
plasterror = 0, preverror = 0, pattention = 0
00:00000:00103:2012/09/06 09:48:12.79 server End diagnostics for read failure:
00:00000:00103:2012/09/06 09:48:12.79 server WARNING: Pss found with open sdes. pspid 103, psuid 17, pcurdb 12, range entry 16, sdesp 0x23b1548c, objid -6750224
00:00000:00103:2012/09/06 09:48:12.79 server Error: 6103, Severity: 17, State: 1
00:00000:00103:2012/09/06 09:48:12.79 server Unable to do cleanup for the killed process; received Msg 696.
00:00000:00032:2012/09/06 10:04:13.21 server Diagnostics related to error 803 for spid 32 follow, curcmd=0 (MAINTENANCE TOKEN), xactid=(0,0), plasterror=0, pattention=0, pstat=0x10000, p2stat=0x101000, p3stat=0x81a.
00:00000:00032:2012/09/06 10:04:13.21 server [0] spid=32, dbid=2, objid=-2097169, indid=0, pageno=963992, ts=0001 2936a9f6, cacheid=2, buf=0x765bf120, mbuf=0x765bf120, msize=16384 (16K), mstat=0x4000009
00:00000:00032:2012/09/06 10:04:13.21 server [1] spid=32, dbid=2, objid=-2097169, indid=0, pageno=963992, ts=0001 2936a9f6, cacheid=2, buf=0x765bf120, mbuf=0x765bf120, msize=16384 (16K), mstat=0x4000009
00:00000:00032:2012/09/06 10:04:13.21 server [2] spid=32, dbid=2, objid=-2097169, indid=0, pageno=963992, ts=0001 2936a9f6, cacheid=2, buf=0x765bf120, mbuf=0x765bf120, msize=16384 (16K), mstat=0x4000009
00:00000:00032:2012/09/06 10:04:13.21 server [3] spid=32, dbid=2, objid=-2097169, indid=0, pageno=963992, ts=0001 2936a9f6, cacheid=2, buf=0x765bf120, mbuf=0x765bf120, msize=16384 (16K), mstat=0x4000009
00:00000:00032:2012/09/06 10:04:13.21 server [4] spid=32, dbid=2, objid=-2097169, indid=0, pageno=963992, ts=0001 2936a9f6, cacheid=2, buf=0x765bf120, mbuf=0x765bf120, msize=16384 (16K), mstat=0x4000009
00:00000:00032:2012/09/06 10:04:13.21 server [5] spid=32, dbid=2, objid=-2097169, indid=0, pageno=963992, ts=0001 2936a9f6, cacheid=2, buf=0x765bf120, mbuf=0x765bf120, msize=16384 (16K), mstat=0x4000009
00:00000:00032:2012/09/06 10:04:13.21 server [6] spid=32, dbid=2, objid=-2097169, indid=0, pageno=963992, ts=0001 2936a9f6, cacheid=2, buf=0x765bf120, mbuf=0x765bf120, msize=16384 (16K), mstat=0x4000009
00:00000:00032:2012/09/06 10:04:13.21 server [7] spid=32, dbid=2, objid=-2097169, indid=0, pageno=963992, ts=0001 2936a9f6, cacheid=2, buf=0x765bf120, mbuf=0x765bf120, msize=16384 (16K), mstat=0x4000009
00:00000:00032:2012/09/06 10:04:13.21 server [8] spid=32, dbid=2, objid=-2097169, indid=0, pageno=963992, ts=0001 2936a9f6, cacheid=2, buf=0x765bf120, mbuf=0x765bf120, msize=16384 (16K), mstat=0x4000009
00:00000:00032:2012/09/06 10:04:13.21 server [9] spid=32, dbid=2, objid=-2097169, indid=0, pageno=963992, ts=0001 2936a9f6, cacheid=2, buf=0x765bf120, mbuf=0x765bf120, msize=16384 (16K), mstat=0x4000009
00:00000:00032:2012/09/06 10:04:13.21 server [10] spid=32, dbid=2, objid=-2097169, indid=0, pageno=963992, ts=0001 2936aa07, cacheid=2, buf=0x765ff6a0, mbuf=0x765ff6a0, msize=16384 (16K), mstat=0x4000009
00:00000:00032:2012/09/06 10:04:13.21 server [11] spid=32, dbid=2, objid=-2097169, indid=0, pageno=963992, ts=0001 2936b2a4, cacheid=2, buf=0x7663b000, mbuf=0x7663b000, msize=16384 (16K), mstat=0x4000009
00:00000:00032:2012/09/06 10:04:13.21 server WARNING: Pss found with open sdes. pspid 32, psuid 245, pcurdb 5, range entry 17, sdesp 0x25f34afc, objid -2097169
00:00000:00032:2012/09/06 10:04:13.21 server Error: 6103, Severity: 17, State: 1
00:00000:00032:2012/09/06 10:04:13.21 server Unable to do cleanup for the killed process; received Msg 803.


thomas king Posted on 2012-11-07 23:52:00.0Z
Sender: 2935.509aefd5.1804289383@sybase.com
From: thomas king
Newsgroups: sybase.public.ase.general
Subject: Re: error 696
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <509af420.2a0c.1681692777@sybase.com>
References: <504807a4.640b.1681692777@sybase.com>
MIME-Version: 1.0
Content-Type: text/plain; charset="ISO-8859-1"
Content-Transfer-Encoding: quoted-printable
NNTP-Posting-Host: 172.20.134.41
X-Original-NNTP-Posting-Host: 172.20.134.41
Date: 7 Nov 2012 15:52:00 -0800
X-Trace: forums-1-dub 1352332320 172.20.134.41 (7 Nov 2012 15:52:00 -0800)
X-Original-Trace: 7 Nov 2012 15:52:00 -0800, 172.20.134.41
Lines: 763
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:31480
Article PK: 74369


> > On 09/03/2012 03:54 AM, thomas king wrote:
> > > i have been running ASE11.9.2 since 2003,i'm facing
> > > this error(along with error 6103) which could not be
> > > solved by a mere server restart.
> > > pls see the attachment.
> > > same error occured in 2007,and it just disappeared
> > > after about 2 months.
> > > if only you could give me some clue.
> > > thx a lot!
> > >
> > > thomas
> > > xptking@hotmail.com
> > >
> >
> > Well, since it is what I shall assume is a tempdb device
> > , you should be able to just restart the Sybase DB
> > server to clear it.
> >
> > What is the ebf level of your 11.9.2 server? (select
> > @@version)
> >
> > jason
>
> thx a lot.
> select @@version result:
> Adaptive Server Enterprise/11.9.2/1031/P/NT (IX86)/OS
> 3.51,4.0/FBU/Fri Aug 14 01:42:41 1998
> OS:windows2000 server with SP4
> i'm sending some more errorlog to help.errors happends
> occasionally but ti seems that the server is still working
> all right.
> it's a tempdb device,i tried to restart the server several
> days ago,but it happened again in 24hrs.
>
>
> [recent.txt]
>
> 02:00000:00108:2012/09/06 09:00:59.15 server Starting
> diagnostics for read failure: 02:00000:00108:2012/09/06
> 09:00:59.15 server Device Information:
> Device number = 22
> Phyname = e:\cwdata\tempdev.dat
> 02:00000:00108:2012/09/06 09:00:59.15 server Buffer
> Information:
> Buf addr = 0x76629c80, Mass addr =
> 0x76629c80
> Buf pageno = 1140120, Mass pageno =
> 1140120, dbid = 2 02:00000:00108:2012/09/06 09:00:59.15
> server
> Buf virtpg = 370188696, Mass virtpg =
> 370188696
> Buf stat = 0x1, Mass stat =
0x40001008
> Mass keep = 1, Mass awaited = 0
> 02:00000:00108:2012/09/06 09:00:59.15 server Page
> Information from first read attempt:
> Page read from cache
> ppageno = 1140120, pobjid = -7077904,
> pindid = 0
> pnextpg = 1140121, pprevpg = 1140135
> plevel = 0, pstat = 0x5
> pts_hi = 1, pts_lo = -1362562457
> 02:00000:00108:2012/09/06 09:00:59.15 server Page
> Information from second read attempt:
> Page read from disk
> ppageno = 1140120, pobjid = -7077904,
> pindid = 0
> pnextpg = 1140121, pprevpg = 1140135
> plevel = 0, pstat = 0x5
> pts_hi = 1, pts_lo = -1362562457
> 02:00000:00108:2012/09/06 09:00:59.15 server SDES
> Information:
> dbid = 2, objid = -7077905,
scur.pageid =
> 1140120
> sstat = 0x10, sstat2 = 0x0
> suid = 3, cacheid = 2
> 02:00000:00108:2012/09/06 09:00:59.15 server PSS
> Information:
> pstat = 0x10000, pcurdb = 10, pspid
= 108
> p2stat = 0x1000, p3stat = 0x81a
> plasterror = 2812, preverror = 0,
> pattention = 0 02:00000:00108:2012/09/06 09:00:59.15
> server End diagnostics for read failure:
> 02:00000:00108:2012/09/06 09:00:59.15 server Error: 696,
> Severity: 21, State: 1 02:00000:00108:2012/09/06
> 09:00:59.15 server An attempt was made to fetch logical
> page '1140120' in tempdb from cache 'cachetemp'. Page
> belongs to object '-7077904' and not to object '-7077905'.
> Restart of SQL Server will clear the error. Please contact
> your System Administrator for help.
> 02:00000:00108:2012/09/06 09:00:59.15 kernel
> ************************************
> 02:00000:00108:2012/09/06 09:00:59.15 kernel SQL causing
> error : exec Sp_SeRvEr_InFo 02:00000:00108:2012/09/06
> 09:00:59.15 kernel ************************************
> 02:00000:00108:2012/09/06 09:00:59.15 server SQL Text:
> exec Sp_SeRvEr_InFo 02:00000:00108:2012/09/06 09:00:59.15
> kernel curdb = 10 pstat = 0x10000 lasterror = 696
> 02:00000:00108:2012/09/06 09:00:59.15 kernel preverror
=
> 0 transtate = 1 02:00000:00108:2012/09/06 09:00:59.15
> kernel curcmd = 224 program = Brio Intelligence -
> [ü欄ûš·¡ 02:00000:00108:2012/09/06
09:00:59.15 kernel
> pc: 0x8a2977 os_get_cur_stk_desc+ 0x57 (0x3ddef30,
> 0x2f4a0004, 0x3ddef30, 0x0) 02:00000:00108:2012/09/06
> 09:00:59.15 kernel pc: 0x8a2977 os_get_cur_stk_desc+ 0x57
> (0x3ddef30, 0x3ddf484, 0x270f, 0x2)
> 02:00000:00108:2012/09/06 09:00:59.15 kernel pc: 0x883514
> pcstkwalk+ 0x224 (0x2f4a0004, 0x2, 0x270f, 0x0)
> 02:00000:00108:2012/09/06 09:00:59.15 kernel pc: 0x8830ae
> ucstkgentrace+ 0x1ce (0x0, 0x1, 0x15, 0x0)
> 02:00000:00108:2012/09/06 09:00:59.15 kernel pc: 0x862864
> ucbacktrace+ 0x84 (0x0, 0xffffffff, 0x3ddf848, 0x4527a8)
> 02:00000:00108:2012/09/06 09:00:59.15 kernel pc: 0x405fe6
> terminate_process+ 0x566 (0x3ddf8a8, 0x639a02, 0x6, 0x60)
> 02:00000:00108:2012/09/06 09:00:59.15 kernel pc: 0x4527ea
> close_network+ 0x1a (0x6, 0x60, 0x15, 0x1)
> 02:00000:00108:2012/09/06 09:00:59.15 kernel pc: 0x4527a8
> hdl_default+ 0x48 (0x6, 0x60, 0x15, 0x1)
> 02:00000:00108:2012/09/06 09:00:59.15 kernel pc: 0x639a02
> s_handle+ 0x162 (0x6, 0x60, 0x15, 0x1)
> 02:00000:00108:2012/09/06 09:00:59.15 kernel pc: 0x452413
> ex_raise+ 0x193 (0x76629c80, 0x20700bbc, 0x1, 0x0)
> 02:00000:00108:2012/09/06 09:00:59.15 kernel pc: 0x542d6e
> wrongpage+ 0x31e (0x20700bbc, 0x4, 0x0, 0x0)
> 02:00000:00108:2012/09/06 09:00:59.15 kernel pc: 0x540482
> getpage_with_validation+ 0x232 (0x20700bbc, 0x3ddfac0, 0x4
> , 0x0) 02:00000:00108:2012/09/06 09:00:59.15 kernel pc:
> 0x5419eb getpage_noscan_with_validation+ 0x8b (0x20700bbc,
> 0x267df28c, 0x1, 0x0) 02:00000:00108:2012/09/06
> 09:00:59.15 kernel pc: 0x4f8577 pg_objdeall+ 0x137
> (0x20700bbc, 0x20da255c, 0x0, 0x0)
> 02:00000:00108:2012/09/06 09:00:59.15 kernel pc: 0x52f60f
> closetable+ 0x23f (0x6, 0x10, 0xc, 0x0)
> 02:00000:00108:2012/09/06 09:00:59.15 kernel pc: 0x6511d1
> close_range+ 0x2a1 (0x24, 0x4, 0x19, 0x0)
> 02:00000:00108:2012/09/06 09:00:59.15 kernel pc: 0x63a0e2
> s_handle+ 0x842 (0x24, 0x4, 0x19, 0x0)
> 02:00000:00108:2012/09/06 09:00:59.15 kernel pc: 0x452413
> ex_raise+ 0x193 (0x2414c3a0, 0x2414c418, 0x0, 0x0)
> 02:00000:00108:2012/09/06 09:00:59.15 kernel pc: 0x65a301
> execproc+ 0x801 (0x21, 0x20da255c, 0x20da255c, 0x20a79678)
> 02:00000:00108:2012/09/06 09:00:59.15 kernel pc: 0x65467a
> s_execute+ 0x213a (0x26ac4000, 0x21, 0x20da9799,
> 0x20da255c) 02:00000:00108:2012/09/06 09:00:59.15 kernel
> [Handler pc: 0x6398a0 s_handle installed by the following
> function:-] 02:00000:00108:2012/09/06 09:00:59.15 kernel
> pc: 0x63678f sequencer+ 0x15f (0x0, 0x200213c0, 0x2ccd0056
> , 0x20021120) 02:00000:00108:2012/09/06 09:00:59.15 kernel
> pc: 0x436d31 tdsrecv_language+ 0xc1 (0x52, 0x4000,
> 0x200213c0, 0x2ccd0056) 02:00000:00108:2012/09/06
> 09:00:59.15 kernel [Handler pc: 0x452660 hdl_backout
> installed by the following function:-]
> 02:00000:00108:2012/09/06 09:00:59.15 kernel [Handler pc:
> 0x5c0c40 ut_handle installed by the following function:-]
> 02:00000:00108:2012/09/06 09:00:59.15 kernel [Handler pc:
> 0x5c0c40 ut_handle installed by the following function:-]
> 02:00000:00108:2012/09/06 09:00:59.15 kernel pc: 0x40dc1c
> conn_hdlr+ 0xb5c (0x200213c0, 0x20021120, 0x2ccd0056,
> 0x200213c0) 02:00000:00108:2012/09/06 09:00:59.15 kernel
> pc: 0x89c1c6 kpntwrapper+ 0x96 (0x89c130, 0x200213c0, 0x0,
> 0x0) 02:00000:00108:2012/09/06 09:00:59.15 kernel pc:
> 0x77e6438b KERNEL32.dll (0x0, 0x2039b0d0, 0x364fcec, 0x0)
> 02:00000:00108:2012/09/06 09:00:59.15 kernel pc:
> 0x77e61608 KERNEL32.dll (0x1, 0x364fe4c, 0x653336,
> 0x20c24b98) 02:00000:00108:2012/09/06 09:00:59.17 kernel
> pc: 0x20c29bf4 (can't find module)(0x0, 0x0, 0x0, 0x0)
> 02:00000:00108:2012/09/06 09:00:59.17 kernel end of stack
> trace, spid 108, kpid 793378820, suid 13
> 02:00000:00108:2012/09/06 09:00:59.17 server Starting
> diagnostics for read failure: 02:00000:00108:2012/09/06
> 09:00:59.17 server Device Information:
> Device number = 22
> Phyname = e:\cwdata\tempdev.dat
> 02:00000:00108:2012/09/06 09:00:59.17 server Buffer
> Information:
> Buf addr = 0x76629c80, Mass addr =
> 0x76629c80
> Buf pageno = 1140120, Mass pageno =
> 1140120, dbid = 2 02:00000:00108:2012/09/06 09:00:59.17
> server
> Buf virtpg = 370188696, Mass virtpg =
> 370188696
> Buf stat = 0x1, Mass stat =
0x40001008
> Mass keep = 1, Mass awaited = 0
> 02:00000:00108:2012/09/06 09:00:59.17 server Page
> Information from first read attempt:
> Page read from cache
> ppageno = 1140120, pobjid = -7077904,
> pindid = 0
> pnextpg = 1140121, pprevpg = 1140135
> plevel = 0, pstat = 0x5
> pts_hi = 1, pts_lo = -1362562457
> 02:00000:00108:2012/09/06 09:00:59.17 server Page
> Information from second read attempt:
> Page read from disk
> ppageno = 1140120, pobjid = -7077904,
> pindid = 0
> pnextpg = 1140121, pprevpg = 1140135
> plevel = 0, pstat = 0x5
> pts_hi = 1, pts_lo = -1362562457
> 02:00000:00108:2012/09/06 09:00:59.17 server SDES
> Information:
> dbid = 2, objid = -7077905,
scur.pageid =
> 1140120
> sstat = 0x10, sstat2 = 0x0
> suid = 3, cacheid = 2
> 02:00000:00108:2012/09/06 09:00:59.17 server PSS
> Information:
> pstat = 0x10000, pcurdb = 10, pspid
= 108
> p2stat = 0x101000, p3stat = 0x81a
> plasterror = 696, preverror = 0,
> pattention = 0 02:00000:00108:2012/09/06 09:00:59.17
> server End diagnostics for read failure:
> 02:00000:00108:2012/09/06 09:00:59.17 server WARNING: Pss
> found with open sdes. pspid 108, psuid 13, pcurdb 10,
> range entry 17, sdesp 0x267df2fc, objid -7077905
> 02:00000:00108:2012/09/06 09:00:59.17 server Error: 6103,
> Severity: 17, State: 1 02:00000:00108:2012/09/06
> 09:00:59.17 server Unable to do cleanup for the killed
> process; received Msg 696. 02:00000:00108:2012/09/06
> 09:00:59.25 server Starting diagnostics for read failure:
> 02:00000:00108:2012/09/06 09:00:59.25 server Device
> Information:
> Device number = 22
> Phyname = e:\cwdata\tempdev.dat
> 02:00000:00108:2012/09/06 09:00:59.25 server Buffer
> Information:
> Buf addr = 0x76629c80, Mass addr =
> 0x76629c80
> Buf pageno = 1140120, Mass pageno =
> 1140120, dbid = 2 02:00000:00108:2012/09/06 09:00:59.25
> server
> Buf virtpg = 370188696, Mass virtpg =
> 370188696
> Buf stat = 0x1, Mass stat =
0x40001008
> Mass keep = 1, Mass awaited = 0
> 02:00000:00108:2012/09/06 09:00:59.25 server Page
> Information from first read attempt:
> Page read from cache
> ppageno = 1140120, pobjid = -7077904,
> pindid = 0
> pnextpg = 1140121, pprevpg = 1140135
> plevel = 0, pstat = 0x5
> pts_hi = 1, pts_lo = -1362562457
> 02:00000:00108:2012/09/06 09:00:59.25 server Page
> Information from second read attempt:
> Page read from disk
> ppageno = 1140120, pobjid = -7077904,
> pindid = 0
> pnextpg = 1140121, pprevpg = 1140135
> plevel = 0, pstat = 0x5
> pts_hi = 1, pts_lo = -1362562457
> 02:00000:00108:2012/09/06 09:00:59.25 server SDES
> Information:
> dbid = 2, objid = -7077905,
scur.pageid =
> 1140120
> sstat = 0x10, sstat2 = 0x0
> suid = 3, cacheid = 2
> 02:00000:00108:2012/09/06 09:00:59.25 server PSS
> Information:
> pstat = 0x10000, pcurdb = 10, pspid
= 108
> p2stat = 0x1000, p3stat = 0x81a
> plasterror = 2812, preverror = 0,
> pattention = 0 02:00000:00108:2012/09/06 09:00:59.25
> server End diagnostics for read failure:
> 02:00000:00108:2012/09/06 09:00:59.25 server Error: 696,
> Severity: 21, State: 1 02:00000:00108:2012/09/06
> 09:00:59.25 server An attempt was made to fetch logical
> page '1140120' in tempdb from cache 'cachetemp'. Page
> belongs to object '-7077904' and not to object '-7077905'.
> Restart of SQL Server will clear the error. Please contact
> your System Administrator for help.
> 02:00000:00108:2012/09/06 09:00:59.25 kernel
> ************************************
> 02:00000:00108:2012/09/06 09:00:59.25 kernel SQL causing
> error : exec Sp_SeRvEr_InFo 02:00000:00108:2012/09/06
> 09:00:59.25 kernel ************************************
> 02:00000:00108:2012/09/06 09:00:59.25 server SQL Text:
> exec Sp_SeRvEr_InFo 02:00000:00108:2012/09/06 09:00:59.25
> kernel curdb = 10 pstat = 0x10000 lasterror = 696
> 02:00000:00108:2012/09/06 09:00:59.25 kernel preverror
=
> 0 transtate = 1 02:00000:00108:2012/09/06 09:00:59.25
> kernel curcmd = 224 program = Brio Intelligence -
> [ü欄ûš·¡ 02:00000:00108:2012/09/06
09:00:59.25 kernel
> pc: 0x8a2977 os_get_cur_stk_desc+ 0x57 (0x3ddef30,
> 0x2f4b0072, 0x3ddef30, 0x0) 02:00000:00108:2012/09/06
> 09:00:59.25 kernel pc: 0x8a2977 os_get_cur_stk_desc+ 0x57
> (0x3ddef30, 0x3ddf484, 0x270f, 0x2)
> 02:00000:00108:2012/09/06 09:00:59.25 kernel pc: 0x883514
> pcstkwalk+ 0x224 (0x2f4b0072, 0x2, 0x270f, 0x0)
> 02:00000:00108:2012/09/06 09:00:59.25 kernel pc: 0x8830ae
> ucstkgentrace+ 0x1ce (0x0, 0x1, 0x15, 0x0)
> 02:00000:00108:2012/09/06 09:00:59.25 kernel pc: 0x862864
> ucbacktrace+ 0x84 (0x0, 0xffffffff, 0x3ddf848, 0x4527a8)
> 02:00000:00108:2012/09/06 09:00:59.25 kernel pc: 0x405fe6
> terminate_process+ 0x566 (0x3ddf8a8, 0x639a02, 0x6, 0x60)
> 02:00000:00108:2012/09/06 09:00:59.25 kernel pc: 0x4527ea
> close_network+ 0x1a (0x6, 0x60, 0x15, 0x1)
> 02:00000:00108:2012/09/06 09:00:59.25 kernel pc: 0x4527a8
> hdl_default+ 0x48 (0x6, 0x60, 0x15, 0x1)
> 02:00000:00108:2012/09/06 09:00:59.25 kernel pc: 0x639a02
> s_handle+ 0x162 (0x6, 0x60, 0x15, 0x1)
> 02:00000:00108:2012/09/06 09:00:59.25 kernel pc: 0x452413
> ex_raise+ 0x193 (0x76629c80, 0x20700bbc, 0x1, 0x0)
> 02:00000:00108:2012/09/06 09:00:59.25 kernel pc: 0x542d6e
> wrongpage+ 0x31e (0x20700bbc, 0x4, 0x0, 0x0)
> 02:00000:00108:2012/09/06 09:00:59.25 kernel pc: 0x540482
> getpage_with_validation+ 0x232 (0x20700bbc, 0x3ddfac0, 0x4
> , 0x0) 02:00000:00108:2012/09/06 09:00:59.25 kernel pc:
> 0x5419eb getpage_noscan_with_validation+ 0x8b (0x20700bbc,
> 0x267df28c, 0x1, 0x0) 02:00000:00108:2012/09/06
> 09:00:59.25 kernel pc: 0x4f8577 pg_objdeall+ 0x137
> (0x20700bbc, 0x20da255c, 0x0, 0x0)
> 02:00000:00108:2012/09/06 09:00:59.25 kernel pc: 0x52f60f
> closetable+ 0x23f (0x6, 0x10, 0xc, 0x0)
> 02:00000:00108:2012/09/06 09:00:59.25 kernel pc: 0x6511d1
> close_range+ 0x2a1 (0x24, 0x4, 0x19, 0x0)
> 02:00000:00108:2012/09/06 09:00:59.25 kernel pc: 0x63a0e2
> s_handle+ 0x842 (0x24, 0x4, 0x19, 0x0)
> 02:00000:00108:2012/09/06 09:00:59.25 kernel pc: 0x452413
> ex_raise+ 0x193 (0x26ac43a0, 0x26ac4418, 0x0, 0x0)
> 02:00000:00108:2012/09/06 09:00:59.25 kernel pc: 0x65a301
> execproc+ 0x801 (0x21, 0x20da255c, 0x20da255c, 0x20a79678)
> 02:00000:00108:2012/09/06 09:00:59.25 kernel pc: 0x65467a
> s_execute+ 0x213a (0x26a04800, 0x21, 0x20da9799,
> 0x20da255c) 02:00000:00108:2012/09/06 09:00:59.25 kernel
> [Handler pc: 0x6398a0 s_handle installed by the following
> function:-] 02:00000:00108:2012/09/06 09:00:59.25 kernel
> pc: 0x63678f sequencer+ 0x15f (0x0, 0x20025bf0, 0x2f4a0004
> , 0x20021120) 02:00000:00108:2012/09/06 09:00:59.25 kernel
> pc: 0x436d31 tdsrecv_language+ 0xc1 (0x52, 0x4000,
> 0x20025bf0, 0x2f4a0004) 02:00000:00108:2012/09/06
> 09:00:59.25 kernel [Handler pc: 0x452660 hdl_backout
> installed by the following function:-]
> 02:00000:00108:2012/09/06 09:00:59.25 kernel [Handler pc:
> 0x5c0c40 ut_handle installed by the following function:-]
> 02:00000:00108:2012/09/06 09:00:59.25 kernel [Handler pc:
> 0x5c0c40 ut_handle installed by the following function:-]
> 02:00000:00108:2012/09/06 09:00:59.25 kernel pc: 0x40dc1c
> conn_hdlr+ 0xb5c (0x20025bf0, 0x20021120, 0x2f4a0004,
> 0x20025bf0) 02:00000:00108:2012/09/06 09:00:59.25 kernel
> pc: 0x89c1c6 kpntwrapper+ 0x96 (0x89c130, 0x20025bf0, 0x0,
> 0x0) 02:00000:00108:2012/09/06 09:00:59.25 kernel pc:
> 0x77e6438b KERNEL32.dll (0x2, 0x270f, 0x0, 0x0)
> 02:00000:00108:2012/09/06 09:00:59.25 kernel pc:
> 0x77e61608 KERNEL32.dll (0x438b1174, 0x400a908, 0x7740000,
> 0x8510438b) 02:00000:00108:2012/09/06 09:00:59.25 kernel
> pc: 0x2f4b0072 (can't find module)(0x0, 0x0, 0x0, 0x0)
> 02:00000:00108:2012/09/06 09:00:59.25 kernel end of stack
> trace, spid 108, kpid 793444466, suid 13
> 02:00000:00108:2012/09/06 09:00:59.25 server Starting
> diagnostics for read failure: 02:00000:00108:2012/09/06
> 09:00:59.25 server Device Information:
> Device number = 22
> Phyname = e:\cwdata\tempdev.dat
> 02:00000:00108:2012/09/06 09:00:59.25 server Buffer
> Information:
> Buf addr = 0x76629c80, Mass addr =
> 0x76629c80
> Buf pageno = 1140120, Mass pageno =
> 1140120, dbid = 2 02:00000:00108:2012/09/06 09:00:59.25
> server
> Buf virtpg = 370188696, Mass virtpg =
> 370188696
> Buf stat = 0x1, Mass stat =
0x40001008
> Mass keep = 1, Mass awaited = 0
> 02:00000:00108:2012/09/06 09:00:59.25 server Page
> Information from first read attempt:
> Page read from cache
> ppageno = 1140120, pobjid = -7077904,
> pindid = 0
> pnextpg = 1140121, pprevpg = 1140135
> plevel = 0, pstat = 0x5
> pts_hi = 1, pts_lo = -1362562457
> 02:00000:00108:2012/09/06 09:00:59.25 server Page
> Information from second read attempt:
> Page read from disk
> ppageno = 1140120, pobjid = -7077904,
> pindid = 0
> pnextpg = 1140121, pprevpg = 1140135
> plevel = 0, pstat = 0x5
> pts_hi = 1, pts_lo = -1362562457
> 02:00000:00108:2012/09/06 09:00:59.25 server SDES
> Information:
> dbid = 2, objid = -7077905,
scur.pageid =
> 1140120
> sstat = 0x10, sstat2 = 0x0
> suid = 3, cacheid = 2
> 02:00000:00108:2012/09/06 09:00:59.25 server PSS
> Information:
> pstat = 0x10000, pcurdb = 10, pspid
= 108
> p2stat = 0x101000, p3stat = 0x81a
> plasterror = 696, preverror = 0,
> pattention = 0 02:00000:00108:2012/09/06 09:00:59.25
> server End diagnostics for read failure:
> 02:00000:00108:2012/09/06 09:00:59.25 server WARNING: Pss
> found with open sdes. pspid 108, psuid 13, pcurdb 10,
> range entry 17, sdesp 0x267df2fc, objid -7077905
> 02:00000:00108:2012/09/06 09:00:59.25 server Error: 6103,
> Severity: 17, State: 1 02:00000:00108:2012/09/06
> 09:00:59.25 server Unable to do cleanup for the killed
> process; received Msg 696. 03:00000:00108:2012/09/06
> 09:09:45.11 server Starting diagnostics for read failure:
> 03:00000:00108:2012/09/06 09:09:45.11 server Device
> Information:
> Device number = 22
> Phyname = e:\cwdata\tempdev.dat
> 03:00000:00108:2012/09/06 09:09:45.11 server Buffer
> Information:
> Buf addr = 0x76629c80, Mass addr =
> 0x76629c80
> Buf pageno = 1140120, Mass pageno =
> 1140120, dbid = 2 03:00000:00108:2012/09/06 09:09:45.11
> server
> Buf virtpg = 370188696, Mass virtpg =
> 370188696
> Buf stat = 0x1, Mass stat =
0x40001008
> Mass keep = 1, Mass awaited = 0
> 03:00000:00108:2012/09/06 09:09:45.11 server Page
> Information from first read attempt:
> Page read from cache
> ppageno = 1140120, pobjid = -7077904,
> pindid = 0
> pnextpg = 1140121, pprevpg = 1140135
> plevel = 0, pstat = 0x5
> pts_hi = 1, pts_lo = -1362562457
> 03:00000:00108:2012/09/06 09:09:45.11 server Page
> Information from second read attempt:
> Page read from disk
> ppageno = 1140120, pobjid = -7077904,
> pindid = 0
> pnextpg = 1140121, pprevpg = 1140135
> plevel = 0, pstat = 0x5
> pts_hi = 1, pts_lo = -1362562457
> 03:00000:00108:2012/09/06 09:09:45.11 server SDES
> Information:
> dbid = 2, objid = -7077905,
scur.pageid =
> 1140120
> sstat = 0x10, sstat2 = 0x0
> suid = 3, cacheid = 2
> 03:00000:00108:2012/09/06 09:09:45.11 server PSS
> Information:
> pstat = 0x10000, pcurdb = 12, pspid
= 108
> p2stat = 0x1000, p3stat = 0x81a
> plasterror = 2812, preverror = 0,
> pattention = 0 03:00000:00108:2012/09/06 09:09:45.11
> server End diagnostics for read failure:
> 03:00000:00108:2012/09/06 09:09:45.11 server Error: 696,
> Severity: 21, State: 1 03:00000:00108:2012/09/06
> 09:09:45.11 server An attempt was made to fetch logical
> page '1140120' in tempdb from cache 'cachetemp'. Page
> belongs to object '-7077904' and not to object '-7077905'.
> Restart of SQL Server will clear the error. Please contact
> your System Administrator for help.
> 03:00000:00108:2012/09/06 09:09:45.11 kernel
> ************************************
> 03:00000:00108:2012/09/06 09:09:45.11 kernel SQL causing
> error : exec Sp_SeRvEr_InFo 03:00000:00108:2012/09/06
> 09:09:45.11 kernel ************************************
> 03:00000:00108:2012/09/06 09:09:45.11 server SQL Text:
> exec Sp_SeRvEr_InFo 03:00000:00108:2012/09/06 09:09:45.11
> kernel curdb = 12 pstat = 0x10000 lasterror = 696
> 03:00000:00108:2012/09/06 09:09:45.11 kernel preverror
=
> 0 transtate = 1 03:00000:00108:2012/09/06 09:09:45.11
> kernel curcmd = 224 program = Brio Intelligence -
> [ü欄ûš·¡ 03:00000:00108:2012/09/06
09:09:45.11 kernel
> pc: 0x8a2977 os_get_cur_stk_desc+ 0x57 (0x3ddef30,
> 0x2f61005c, 0x3ddef30, 0x0) 03:00000:00108:2012/09/06
> 09:09:45.11 kernel pc: 0x8a2977 os_get_cur_stk_desc+ 0x57
> (0x3ddef30, 0x3ddf484, 0x270f, 0x2)
> 03:00000:00108:2012/09/06 09:09:45.11 kernel pc: 0x883514
> pcstkwalk+ 0x224 (0x2f61005c, 0x2, 0x270f, 0x0)
> 03:00000:00108:2012/09/06 09:09:45.11 kernel pc: 0x8830ae
> ucstkgentrace+ 0x1ce (0x0, 0x1, 0x15, 0x0)
> 03:00000:00108:2012/09/06 09:09:45.11 kernel pc: 0x862864
> ucbacktrace+ 0x84 (0x0, 0xffffffff, 0x3ddf848, 0x4527a8)
> 03:00000:00108:2012/09/06 09:09:45.11 kernel pc: 0x405fe6
> terminate_process+ 0x566 (0x3ddf8a8, 0x639a02, 0x6, 0x60)
> 03:00000:00108:2012/09/06 09:09:45.11 kernel pc: 0x4527ea
> close_network+ 0x1a (0x6, 0x60, 0x15, 0x1)
> 03:00000:00108:2012/09/06 09:09:45.11 kernel pc: 0x4527a8
> hdl_default+ 0x48 (0x6, 0x60, 0x15, 0x1)
> 03:00000:00108:2012/09/06 09:09:45.11 kernel pc: 0x639a02
> s_handle+ 0x162 (0x6, 0x60, 0x15, 0x1)
> 03:00000:00108:2012/09/06 09:09:45.11 kernel pc: 0x452413
> ex_raise+ 0x193 (0x76629c80, 0x20700bbc, 0x1, 0x0)
> 03:00000:00108:2012/09/06 09:09:45.11 kernel pc: 0x542d6e
> wrongpage+ 0x31e (0x20700bbc, 0x4, 0x0, 0x0)
> 03:00000:00108:2012/09/06 09:09:45.11 kernel pc: 0x540482
> getpage_with_validation+ 0x232 (0x20700bbc, 0x3ddfac0, 0x4
> , 0x0) 03:00000:00108:2012/09/06 09:09:45.11 kernel pc:
> 0x5419eb getpage_noscan_with_validation+ 0x8b (0x20700bbc,
> 0x267df28c, 0x1, 0x0) 03:00000:00108:2012/09/06
> 09:09:45.11 kernel pc: 0x4f8577 pg_objdeall+ 0x137
> (0x20700bbc, 0x20da255c, 0x0, 0x0)
> 03:00000:00108:2012/09/06 09:09:45.11 kernel pc: 0x52f60f
> closetable+ 0x23f (0x6, 0x10, 0xc, 0x0)
> 03:00000:00108:2012/09/06 09:09:45.11 kernel pc: 0x6511d1
> close_range+ 0x2a1 (0x24, 0x4, 0x19, 0x0)
> 03:00000:00108:2012/09/06 09:09:45.11 kernel pc: 0x63a0e2
> s_handle+ 0x842 (0x24, 0x4, 0x19, 0x0)
> 03:00000:00108:2012/09/06 09:09:45.11 kernel pc: 0x452413
> ex_raise+ 0x193 (0x240e23a0, 0x240e2418, 0x0, 0x0)
> 03:00000:00108:2012/09/06 09:09:45.11 kernel pc: 0x65a301
> execproc+ 0x801 (0x21, 0x20da255c, 0x20da255c, 0x20a79678)
> 03:00000:00108:2012/09/06 09:09:45.11 kernel pc: 0x65467a
> s_execute+ 0x213a (0x24120000, 0x21, 0x20da9799,
> 0x20da255c) 03:00000:00108:2012/09/06 09:09:45.11 kernel
> [Handler pc: 0x6398a0 s_handle installed by the following
> function:-] 03:00000:00108:2012/09/06 09:09:45.11 kernel
> pc: 0x63678f sequencer+ 0x15f (0x0, 0x20024d80, 0x2f4b0072
> , 0x20021120) 03:00000:00108:2012/09/06 09:09:45.11 kernel
> pc: 0x436d31 tdsrecv_language+ 0xc1 (0x52, 0x4000,
> 0x20024d80, 0x2f4b0072) 03:00000:00108:2012/09/06
> 09:09:45.11 kernel [Handler pc: 0x452660 hdl_backout
> installed by the following function:-]
> 03:00000:00108:2012/09/06 09:09:45.11 kernel [Handler pc:
> 0x5c0c40 ut_handle installed by the following function:-]
> 03:00000:00108:2012/09/06 09:09:45.11 kernel [Handler pc:
> 0x5c0c40 ut_handle installed by the following function:-]
> 03:00000:00108:2012/09/06 09:09:45.11 kernel pc: 0x40dc1c
> conn_hdlr+ 0xb5c (0x20024d80, 0x20021120, 0x2f4b0072,
> 0x20024d80) 03:00000:00108:2012/09/06 09:09:45.11 kernel
> pc: 0x89c1c6 kpntwrapper+ 0x96 (0x89c130, 0x20024d80, 0x0,
> 0x0) 03:00000:00108:2012/09/06 09:09:45.11 kernel pc:
> 0x77e6438b KERNEL32.dll (0x2, 0x270f, 0x0, 0x0)
> 03:00000:00108:2012/09/06 09:09:45.11 kernel pc:
> 0x77e61608 KERNEL32.dll (0x438b1174, 0x400a908, 0x7740000,
> 0x8510438b) 03:00000:00108:2012/09/06 09:09:45.13 kernel
> pc: 0x2f61005c (can't find module)(0x0, 0x0, 0x0, 0x0)
> 03:00000:00108:2012/09/06 09:09:45.13 kernel end of stack
> trace, spid 108, kpid 794886236, suid 17
> 03:00000:00108:2012/09/06 09:09:45.13 server Starting
> diagnostics for read failure: 03:00000:00108:2012/09/06
> 09:09:45.13 server Device Information:
> Device number = 22
> Phyname = e:\cwdata\tempdev.dat
> 03:00000:00108:2012/09/06 09:09:45.13 server Buffer
> Information:
> Buf addr = 0x76629c80, Mass addr =
> 0x76629c80
> Buf pageno = 1140120, Mass pageno =
> 1140120, dbid = 2 03:00000:00108:2012/09/06 09:09:45.13
> server
> Buf virtpg = 370188696, Mass virtpg =
> 370188696
> Buf stat = 0x1, Mass stat =
0x40001008
> Mass keep = 1, Mass awaited = 0
> 03:00000:00108:2012/09/06 09:09:45.13 server Page
> Information from first read attempt:
> Page read from cache
> ppageno = 1140120, pobjid = -7077904,
> pindid = 0
> pnextpg = 1140121, pprevpg = 1140135
> plevel = 0, pstat = 0x5
> pts_hi = 1, pts_lo = -1362562457
> 03:00000:00108:2012/09/06 09:09:45.15 server Page
> Information from second read attempt:
> Page read from disk
> ppageno = 1140120, pobjid = -7077904,
> pindid = 0
> pnextpg = 1140121, pprevpg = 1140135
> plevel = 0, pstat = 0x5
> pts_hi = 1, pts_lo = -1362562457
> 03:00000:00108:2012/09/06 09:09:45.15 server SDES
> Information:
> dbid = 2, objid = -7077905,
scur.pageid =
> 1140120
> sstat = 0x10, sstat2 = 0x0
> suid = 3, cacheid = 2
> 03:00000:00108:2012/09/06 09:09:45.15 server PSS
> Information:
> pstat = 0x10000, pcurdb = 12, pspid
= 108
> p2stat = 0x101000, p3stat = 0x81a
> plasterror = 696, preverror = 0,
> pattention = 0 03:00000:00108:2012/09/06 09:09:45.15
> server End diagnostics for read failure:
> 03:00000:00108:2012/09/06 09:09:45.15 server WARNING: Pss
> found with open sdes. pspid 108, psuid 17, pcurdb 12,
> range entry 17, sdesp 0x267df2fc, objid -7077905
> 03:00000:00108:2012/09/06 09:09:45.15 server Error: 6103,
> Severity: 17, State: 1 03:00000:00108:2012/09/06
> 09:09:45.15 server Unable to do cleanup for the killed
> process; received Msg 696. 00:00000:00103:2012/09/06
> 09:48:12.79 server Starting diagnostics for read failure:
> 00:00000:00103:2012/09/06 09:48:12.79 server Device
> Information:
> Device number = 22
> Phyname = e:\cwdata\tempdev.dat
> 00:00000:00103:2012/09/06 09:48:12.79 server Buffer
> Information:
> Buf addr = 0x7667e4a0, Mass addr =
> 0x7667e4a0
> Buf pageno = 1379088, Mass pageno =
> 1379088, dbid = 2 00:00000:00103:2012/09/06 09:48:12.79
> server
> Buf virtpg = 370427664, Mass virtpg =
> 370427664
> Buf stat = 0x1, Mass stat =
0x40001008
> Mass keep = 1, Mass awaited = 0
> 00:00000:00103:2012/09/06 09:48:12.79 server Page
> Information from first read attempt:
> Page read from cache
> ppageno = 1379088, pobjid = -4522000,
> pindid = 0
> pnextpg = 1379089, pprevpg = 1379079
> plevel = 0, pstat = 0x101
> pts_hi = 1, pts_lo = -257108537
> 00:00000:00103:2012/09/06 09:48:12.79 server Page
> Information from second read attempt:
> Page read from disk
> ppageno = 1379088, pobjid = -4522000,
> pindid = 0
> pnextpg = 1379089, pprevpg = 1379079
> plevel = 0, pstat = 0x101
> pts_hi = 1, pts_lo = -257108537
> 00:00000:00103:2012/09/06 09:48:12.79 server SDES
> Information:
> dbid = 2, objid = -6750224,
scur.pageid =
> 1379088
> sstat = 0x10, sstat2 = 0x0
> suid = 3, cacheid = 2
> 00:00000:00103:2012/09/06 09:48:12.79 server PSS
> Information:
> pstat = 0x10000, pcurdb = 12, pspid
= 103
> p2stat = 0x101000, p3stat = 0x81a
> plasterror = 0, preverror = 0,
pattention
> = 0 00:00000:00103:2012/09/06 09:48:12.79 server End
> diagnostics for read failure: 00:00000:00103:2012/09/06
> 09:48:12.79 server WARNING: Pss found with open sdes.
> pspid 103, psuid 17, pcurdb 12, range entry 16, sdesp
> 0x23b1548c, objid -6750224 00:00000:00103:2012/09/06
> 09:48:12.79 server Error: 6103, Severity: 17, State: 1
> 00:00000:00103:2012/09/06 09:48:12.79 server Unable to do
> cleanup for the killed process; received Msg 696.
> 00:00000:00032:2012/09/06 10:04:13.21 server Diagnostics
> related to error 803 for spid 32 follow, curcmd=0
> (MAINTENANCE TOKEN), xactid=(0,0), plasterror=0,
> pattention=0, pstat=0x10000, p2stat=0x101000,
> p3stat=0x81a. 00:00000:00032:2012/09/06 10:04:13.21
server
> [0] spid=32, dbid=2, objid=-2097169, indid=0,
> pageno=963992, ts=0001 2936a9f6, cacheid=2,
buf=0x765bf120
> , mbuf=0x765bf120, msize=16384 (16K),
mstat=0x4000009
> 00:00000:00032:2012/09/06 10:04:13.21 server [1]
spid=32,
> dbid=2, objid=-2097169, indid=0, pageno=963992,
ts=0001
> 2936a9f6, cacheid=2, buf=0x765bf120,
mbuf=0x765bf120,
> msize=16384 (16K), mstat=0x4000009
> 00:00000:00032:2012/09/06 10:04:13.21 server [2]
spid=32,
> dbid=2, objid=-2097169, indid=0, pageno=963992,
ts=0001
> 2936a9f6, cacheid=2, buf=0x765bf120,
mbuf=0x765bf120,
> msize=16384 (16K), mstat=0x4000009
> 00:00000:00032:2012/09/06 10:04:13.21 server [3]
spid=32,
> dbid=2, objid=-2097169, indid=0, pageno=963992,
ts=0001
> 2936a9f6, cacheid=2, buf=0x765bf120,
mbuf=0x765bf120,
> msize=16384 (16K), mstat=0x4000009
> 00:00000:00032:2012/09/06 10:04:13.21 server [4]
spid=32,
> dbid=2, objid=-2097169, indid=0, pageno=963992,
ts=0001
> 2936a9f6, cacheid=2, buf=0x765bf120,
mbuf=0x765bf120,
> msize=16384 (16K), mstat=0x4000009
> 00:00000:00032:2012/09/06 10:04:13.21 server [5]
spid=32,
> dbid=2, objid=-2097169, indid=0, pageno=963992,
ts=0001
> 2936a9f6, cacheid=2, buf=0x765bf120,
mbuf=0x765bf120,
> msize=16384 (16K), mstat=0x4000009
> 00:00000:00032:2012/09/06 10:04:13.21 server [6]
spid=32,
> dbid=2, objid=-2097169, indid=0, pageno=963992,
ts=0001
> 2936a9f6, cacheid=2, buf=0x765bf120,
mbuf=0x765bf120,
> msize=16384 (16K), mstat=0x4000009
> 00:00000:00032:2012/09/06 10:04:13.21 server [7]
spid=32,
> dbid=2, objid=-2097169, indid=0, pageno=963992,
ts=0001
> 2936a9f6, cacheid=2, buf=0x765bf120,
mbuf=0x765bf120,
> msize=16384 (16K), mstat=0x4000009
> 00:00000:00032:2012/09/06 10:04:13.21 server [8]
spid=32,
> dbid=2, objid=-2097169, indid=0, pageno=963992,
ts=0001
> 2936a9f6, cacheid=2, buf=0x765bf120,
mbuf=0x765bf120,
> msize=16384 (16K), mstat=0x4000009
> 00:00000:00032:2012/09/06 10:04:13.21 server [9]
spid=32,
> dbid=2, objid=-2097169, indid=0, pageno=963992,
ts=0001
> 2936a9f6, cacheid=2, buf=0x765bf120,
mbuf=0x765bf120,
> msize=16384 (16K), mstat=0x4000009
> 00:00000:00032:2012/09/06 10:04:13.21 server [10]
spid=32
> , dbid=2, objid=-2097169, indid=0, pageno=963992,
ts=0001
> 2936aa07, cacheid=2, buf=0x765ff6a0,
mbuf=0x765ff6a0,
> msize=16384 (16K), mstat=0x4000009
> 00:00000:00032:2012/09/06 10:04:13.21 server [11]
spid=32
> , dbid=2, objid=-2097169, indid=0, pageno=963992,
ts=0001
> 2936b2a4, cacheid=2, buf=0x7663b000,
mbuf=0x7663b000,
> msize=16384 (16K), mstat=0x4000009
> 00:00000:00032:2012/09/06 10:04:13.21 server WARNING: Pss
> found with open sdes. pspid 32, psuid 245, pcurdb 5,
> range entry 17, sdesp 0x25f34afc, objid -2097169
> 00:00000:00032:2012/09/06 10:04:13.21 server Error: 6103,
> Severity: 17, State: 1 00:00000:00032:2012/09/06
> 10:04:13.21 server Unable to do cleanup for the killed
> process; received Msg 803.
> [Attachment: recent.txt]

-------
i restarted the server 1 month ago,and error 696 occurred
in 2 days,it just disappeared for some time(1 day or so),but
it became frequently,and i've found some mistakes in some
tables.