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.

help tempdb errors

3 posts in Windows NT Last posting was on 2001-03-14 09:56:31.0Z
Jon Posted on 2001-03-13 17:06:12.0Z
Message-ID: <3AAE5384.F01BADE8@alleghany.co.k>
Date: Tue, 13 Mar 2001 17:06:12 +0000
From: Jon <jonathan.meads@alleghany.co.k>
Organization: Alleghany underwrting Ltd
X-Mailer: Mozilla 4.72 [en] (WinNT; I)
X-Accept-Language: en
MIME-Version: 1.0
Subject: help tempdb errors
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Newsgroups: sybase.public.sqlserver.nt
Lines: 34
NNTP-Posting-Host: lolgate.lloyds.uk.ibm.net 195.212.5.4
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.nt:1109
Article PK: 1087710

I'm trying to drop a device used by tempdb. however I'm having a few
problems...

I've dropped all segments from the device
then delete from sysusages where dbid = 2 and vstart = ....
then sp_dropdevice device

then I restarted the server. however the errorlog has the following in
it:

Database 'model' is now online.
00:00000:00001:2001/03/13 16:53:38.50 server Clearing temp db
00:00000:00000:2001/03/13 16:53:40.57 kernel sddone: write error on
virtual disk 4 block 16774656:
00:00000:00000:2001/03/13 16:53:40.57 kernel sddone: Windows NT system
error 112: Not enough space on disk.
00:00000:00001:2001/03/13 16:53:40.81 server Error: 823, Severity: 24,
State: 2
00:00000:00001:2001/03/13 16:53:40.82 server I/O error detected during
wait for BUF pointer = '0x21A4F0A8', MASS pointer = '0x21A4F0A8', (Buf#:
'0'), page ptr = '0x21977800', dbid = '2', Mass virtpage = '83883520',
Buffer page = '0', Mass status = '0x80908', Buffer status = '0x1', size
= '2048', cache (id: 0) = 'default data cache'.
00:00000:00001:2001/03/13 16:53:40.84 server SQL Server's default sort
order is:
00:00000:00001:2001/03/13 16:53:40.84 server 'noaccents_cp850' (ID =
44)

Can anyone spot what I'm doing wrong. Is there another way to get rid of
"unwanted" devices from tempdb.


Thanks
Jonathan


Doug Wittich Posted on 2001-03-13 20:30:45.0Z
Message-ID: <3AAE8375.970C076@stpaul.com>
Date: Tue, 13 Mar 2001 15:30:45 -0500
From: Doug Wittich <doug.wittich@stpaul.com>
X-Mailer: Mozilla 4.76 [en] (WinNT; U)
X-Accept-Language: en
MIME-Version: 1.0
Subject: Re: help tempdb errors
References: <3AAE5384.F01BADE8@alleghany.co.k>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Newsgroups: sybase.public.sqlserver.nt
Lines: 16
NNTP-Posting-Host: portald.stpaul.com 208.201.108.75
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.nt:1105
Article PK: 1087706

Interesting problem. When I do such actions, I run the following:

update sysusages set segmap=7 where dbid = 2 and lstart = 0
delete from sysusages where dbid = 2 and lstart > 0

Then I recycle, then I drop the device and recycle again.

I wonder if with your vstart test you deleted more than you should? Do you
still have the 2 mb slice on the master device?

Doug

> I'm trying to drop a device used by tempdb. however I'm having a few
> problems...
>
> I've dropped all segments from the device
> then delete from sysusages where dbid = 2 and vstart = ....
> then sp_dropdevice device
>


Jon Posted on 2001-03-14 09:56:31.0Z
Message-ID: <3AAF404F.CA45F00E@alleghany.co.k>
Date: Wed, 14 Mar 2001 09:56:31 +0000
From: Jon <jonathan.meads@alleghany.co.k>
Organization: Alleghany underwrting Ltd
X-Mailer: Mozilla 4.72 [en] (WinNT; I)
X-Accept-Language: en
MIME-Version: 1.0
Subject: Re: help tempdb errors
References: <3AAE5384.F01BADE8@alleghany.co.k> <3AAE8375.970C076@stpaul.com>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Newsgroups: sybase.public.sqlserver.nt
Lines: 26
NNTP-Posting-Host: lolgate.lloyds.uk.ibm.net 195.212.5.4
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.nt:1104
Article PK: 1087704

Have dropped the segments for tempdb from master,

have four extra devices for tempdb, one for each segment plus an extra one (
the one I want to get rid of) which has no segments on it.

The strange thing is, I tested it on a test server, setup the devices just like
the server I'm having problems with, and it worked without a problem...

Doug Wittich wrote:

> Interesting problem. When I do such actions, I run the following:
>
> update sysusages set segmap=7 where dbid = 2 and lstart = 0
> delete from sysusages where dbid = 2 and lstart > 0
>
> Then I recycle, then I drop the device and recycle again.
>
> I wonder if with your vstart test you deleted more than you should? Do you
> still have the 2 mb slice on the master device?
>
> Doug
>
> > I'm trying to drop a device used by tempdb. however I'm having a few
> > problems...
> >
> > I've dropped all segments from the device
> > then delete from sysusages where dbid = 2 and vstart = ....
> > then sp_dropdevice device
> >