freetds AT lists.ibiblio.org
Subject: FreeTDS Development Group
List archive
- From: Frediano Ziglio <freddyz77 AT tin.it>
- To: TDS Development Group <freetds AT franklin.oit.unc.edu>
- Subject: RE: Problem with Sybase
- Date: 25 Oct 2002 22:49:05 +0200
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.
1>
After some time disappear... I have this error mainly with test 0014
(dblib) but I don't know why... This problem never raise before...
freddy77
-
Problem with Sybase,
Frediano Ziglio, 10/24/2002
- <Possible follow-up(s)>
- RE: Problem with Sybase, Castellano, Nicholas, 10/24/2002
- Re: Problem with Sybase, Michael Peppler, 10/24/2002
- RE: Problem with Sybase, ZIGLIO Frediano, 10/25/2002
- RE: Problem with Sybase, Lowden, James K, 10/25/2002
- RE: Problem with Sybase, Michael Peppler, 10/25/2002
- RE: Problem with Sybase, Lowden, James K, 10/25/2002
- RE: Problem with Sybase, Frediano Ziglio, 10/25/2002
- RE: Problem with Sybase, Michael Peppler, 10/25/2002
- RE: Problem with Sybase, Frediano Ziglio, 10/25/2002
- RE: Problem with Sybase, Frediano Ziglio, 10/25/2002
- RE: Problem with Sybase, Michael Peppler, 10/25/2002
- RE: Problem with Sybase, Thompson, Bill D (London), 10/25/2002
- RE: Problem with Sybase, Lowden, James K, 10/25/2002
- RE: Problem with Sybase, Frediano Ziglio, 10/26/2002
- RE: Problem with Sybase, Frediano Ziglio, 10/26/2002
Archive powered by MHonArc 2.6.24.