Trace flag 208, followed by server hang 
Author Message
 Trace flag 208, followed by server hang

After rebooting a hung server, I checked the previous error log. At the
end of the log were several DBCC TRACEON 208 messages from various
SPIDs, spread out over a few hours. I can't find this flag documented
anywhere.

About 20 minutes after the last 208 flag, a string of these appear,
associated with several different SPIDs: "getindex: bp not special,
ipageno = 0, bpageno = 0x18, stat 0/0".

That's when the server stopped responding, and had to be restarted.

Unfortunately, I have no idea who the SPIDs belonged to, so I have no
idea what they might have been trying to do. They were most likely
client applications connecting via ODBC from Win95 or WinNT 4.0
machines, over our LAN.

One of these client applications (which may or may not have been one of
the suspect SPIDs, and which was running on a WinNT 4.0 machine and
connecting via ODBC over the LAN) got this message when it was doing a
simple SELECT * from a table: "stored procedure '#odbc#tlcore4e97984'
not found". There's no stored procedure in our database that even
resembles that string, so that's also a mystery.

Any idea what might have caused the crash?

I'm running MS SQL Server 6.50.258.

Brian Proulx



Tue, 10 Apr 2001 03:00:00 GMT
 Trace flag 208, followed by server hang

Brian,

 The 208 is a red herring as below.  On the hang you should try
applying SP4.

 Q.  What does dbcc traceon(208) mean in SQL Server?  I see it in SQL's
errorlogs, but I'm not issuing it.
(v1.0   12.10.1998)

A.  This traceflag is set by some applications as they rely on SQL
6.0's quoted identifier behaviour for object names.  For differences
introduced with 6.5 to this behaviour look at the "What's New" section
in the 6.5 books-online.

 Neil Pike MVP/MCSE
 Protech Computing Ltd
 (Please post ALL replies to the newsgroup only unless indicated
otherwise)



Wed, 11 Apr 2001 03:00:00 GMT
 Trace flag 208, followed by server hang
Neil,

Thank you for your help. Do you think the issuance of the 208 flag was
related to my later errors and server hang?

Also, could you tell me where I can find the FAQ you quoted?

Brian

Quote:

> Brian,

>  The 208 is a red herring as below.  On the hang you should try
> applying SP4.

>  Q.  What does dbcc traceon(208) mean in SQL Server?  I see it in SQL's
> errorlogs, but I'm not issuing it.
> (v1.0   12.10.1998)

> A.  This traceflag is set by some applications as they rely on SQL
> 6.0's quoted identifier behaviour for object names.  For differences
> introduced with 6.5 to this behaviour look at the "What's New" section
> in the 6.5 books-online.

>  Neil Pike MVP/MCSE
>  Protech Computing Ltd
>  (Please post ALL replies to the newsgroup only unless indicated
> otherwise)



Wed, 11 Apr 2001 03:00:00 GMT
 Trace flag 208, followed by server hang
Brian,

Quote:
> Thank you for your help. Do you think the issuance of the 208 flag was
> related to my later errors and server hang?

 I shouldn't think it was related

Quote:
> Also, could you tell me where I can find the FAQ you quoted?

 Q.      Where is the SQL Server FAQ?  Or other useful SQL information.
(v1.2   25.10.1998)

A.  Contrary to appearance this message isn't strictly speaking a faq entry
- just something the author has done to save some time answering common
questions on the newsgroups.  There isn't one all encompassing FAQ like
there is for some non-MS newsgroups, but there are several places for good
info :-

The Microsoft "official" faq is at
http://support.microsoft.com/support/sql/content/faq/default.asp.  Plenty
more SQL articles, bug reports etc. can be found by searching the MS
Knowledgebase at www.microsoft.com/support.  An off-line copy of the
knowledgebase as well as hundreds of articles, white-papers, resource-kits,
service packs etc. can be found on the Technet CD.  If you don't subscribe
to Technet then do so NOW as it is the single most important source of
knowledge for support staff responsible for Microsoft technologies.

This authors personal texts, as well as plenty of other good info, can be
found at :-

    http://www.swynk.com/friends/hotek/articles/sqlserverfaq.asp
    and
    www.ntfaq.com

 Neil Pike MVP/MCSE
 Protech Computing Ltd
 (Please post ALL replies to the newsgroup only unless indicated otherwise)



Thu, 12 Apr 2001 02:00:00 GMT
 
 [ 4 post ] 

 Relevant Pages 

1. Undoc'ed trace flags (208 specifically)

2. Trace Flag 208

3. Trace flag 208

4. Trace Flag 208

5. Trace Flag 208

6. TRace Flag 208

7. Trace Flag 208

8. DBCC TRACEON flag 208

9. trace 208

10. Trace flag for log in/out tracing

11. sql server 7.0 and divide by zero trace flag

12. ODBC SQL Server driver error #208


 
Powered by phpBB® Forum Software