FreeTDS Development Group

[Michael Peppler <mpeppler AT peppler.org>]

On Fri, 2002-10-25 at 13:49, Frediano Ziglio wrote:
> Il ven, 2002-10-25 alle 22:13, Michael Peppler ha scritto:
> > On Fri, 2002-10-25 at 12:23, Frediano Ziglio wrote:
> > > Il ven, 2002-10-25 alle 17:38, Lowden, James K ha scritto:
> > > > > From: ZIGLIO Frediano [mailto:Frediano.Ziglio AT vodafoneomnitel.it]
> > > > > Sent: October 25, 2002 4:16 AM
> > > > > 
> > > > > I tried with command
> > > > > 
> > > > > 1> dump tran tempdb to 'output.txt'
> > > > > 
> > > > > But it reply with strange error...
> > > > 
> > > > Frediano, 
> > > > 
> > > > I think "dump tran with no_log" is your friend.  That's the old 
> > > > syntax and
> > > > should still work.  
> > > > 
> > > 
> > > I tried with "dump tran tempdb with no_log" but I got still
> > > 
> > > The transaction log in database tempdb is almost full.  Your transaction
> > > is being suspended until space is made available in the log.
> > 
> > Right - again this means that you have an open transaction that prevents
> > Sybase from truncating the log. You can check this by doing:
> > 
> > select * from master..syslogshold
> > 
> > Michael
> 
> It give 
> 1> select * from master..syslogshold
> 2> go
> Msg 1703, Level 10, State 2, Server , Line 1
> Failed to allocate disk space for a work table in database 'tempdb'. 
> You may be able to free up space by using the DUMP TRANsaction command,
> or you may want to extend the size of the database by using the ALTER
> DATABASE command.

Ah - yes, sorry. If you run out of space in tempdb almost all commands
get stuck because they use tempdb in some form :-(

> After some time disappear... I have this error mainly with test 0014
> (dblib) but I don't know why... This problem never raise before...

I don't know what test 0014 does - I'll try to download the source to
see what could be causing it...

Michael
-- 
Michael Peppler / mpeppler AT peppler.org / http://www.mbay.net/~mpeppler
mpeppler AT zetatools.com / ZetaTools, Inc / http://www.zetatools.com
ZetaTools: Call perl functions as Sybase stored procedures!

Attachment: signature.asc
Description: This is a digitally signed message part