Skip to Content.
Sympa Menu

freetds - Re: Unknown marker: 0!!

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: richard AT iguana.co.nz
  • To: TDS Development Group <freetds AT franklin.oit.unc.edu>
  • Subject: Re: Unknown marker: 0!!
  • Date: Tue, 14 Dec 1999 12:33:45 +1300 (NZDT)


> Hi,
>
> I checked some stuff into CVS, can you test it and see if it clears this
> up?
>
> Brian

Hey guys, experienced this issue recently too, grabbed latest copy off
cvs, didn't fix it, but we think we've found the problem. Our max_conn in
SQL 7 was too low, and we were maxing out the connections. We've fixed
that and will monitor the progress.

Richard.


> > I installed the 0.5pre1. I recompiled my program, and I still have that
> > problem. Have you ever tryed to stop the MSSQL 7 while freetds was
> > sending
> > commands through DB-Lib???
> > By setting dberrhandle I got the following:
> >
> > CLICKD.TCP: MAINDB: insert into click_stream values
> > (10000021,73601234,'1999-12-08 18:10:31','x.x.x.x')
> > Msg 6002, Level 0, State 1
> > SHUTDOWN is in progress. Log off.
> > CLICKD.TCP: MAINDB: insert into click_stream values
> > (10000016,73601234,'1999-12-08 18:10:33','x.x.x.x')
> > Unknown marker: 0!!
> > Unknown marker: 0!!
> > Unknown marker: 0!!
> > Unknown marker: 0!!
> >
> > Now I'm really desperate!!!
> >
> > > > > > > >Which version of freetds are you running? I fixed a similar
> > >problem
> > > > > > > >recently which should be in freetds 0.50pre1
> > > > > > > >
> > > > > > > >Brian
> > > > > > > >
> > > > > > > >On Tue, 7 Dec 1999, Vanderlei Silva wrote:
> > > > > > > >
> > > > > > > > > Hi folks,
> > > > > > > > > I have a program that uses freeTDS 4.2/DB-Lib to make
> > > > > > > > > inserts
> > >in a
> > > > > > > > > SQL-Server 7. Everything works fine until I someone stops
> > > > > > > > > the
> > > > >server.
> > > > > > > >When
> > > > > > > > > this occurs, my program start sending the following message:
> > > > > > > > > Unknown marker: 0!!
> > > > > > > > > Unknown marker: 0!!
> > > > > > > > > Unknown marker: 0!!
> > > > > > > > > In a loop, and keep there forever.
> > > > > > > > > The only place I could imagine the error was been generated
> > > > > > > > > in
> > >my
> > > > >code
> > > > > > > >is
> > > > > > > > > the following:
> > > > > > > > > .
> > > > > > > > > .
> > > > > > > > > .
> > > > > > > > > dbcmd(dbproc, query_buf);
> > > > > > > > > dbsqlexec(dbproc);
> > > > > > > > > while ((result_code = dbresults(dbproc)) !=
> > > > >NO_MORE_RESULTS) {
> > > > > > > > > if (result_code != SUCCEED) {
> > > > > > > > > dbcancel(dbproc);
> > > > > > > > > break;
> > > > > > > > > }
> > > > > > > > > }
> > > > > > > > > if ((result_code != SUCCEED) &&
> > > > > > > > > (result_code != NO_MORE_RESULTS)) {
> > > > > > > > > dbcancel(dbproc);
> > > > > > > > > backupDBWrite_log(d);
> > > > > > > > > mainDBOK = 0;
> > > > > > > > > mainDBRecheckCount = 100;
> > > > > > > > > }
> > > > > > > > > .
> > > > > > > > > .
> > > > > > > > > .
> > > > > > > > >
> > > > > > > > > But, seems to be right for me. I have no clue in how to
> > > > > > > > > detect
> > >the
> > > > > > > > > connection was lost. I do have a backup database strategy
> > > > >implemented,
> > > > > > > >using
> > > > > > > > > mySQL, but it will only work if I manage to detect the
> > > > > > > > > error.
> > > > > > > > > Any help will be apreciated.
> > > > > > > > > Thanks,
> > > > > > > > >
> > > > > > > > > Vanderlei
> > > > > > > > >
> > > > > > > > >
> > > > > > > > > ______________________________________________________
> > > > > > > > > Get Your Private, Free Email at http://www.hotmail.com
> > > > > > > > >
> > > > > > > > > ---
> > > > > > > > > You are currently subscribed to freetds as: camber AT ais.org
> > > > > > > > > To unsubscribe, forward this message to
> > > > > > > >$subst('Email.Unsub')
> > > > > > > > >
> > > > > > > > >
> > > > > > > >
> > > > > > > >
> > > > > > > >---
> > > > > > > >You are currently subscribed to freetds as:
> > >vandersilva AT hotmail.com
> > > > > > > >To unsubscribe, forward this message to
> > > > > > > >$subst('Email.Unsub')
> > > > > > > >
> > > > > > > >
> > > > > > >
> > > > > > > ______________________________________________________
> > > > > > > Get Your Private, Free Email at http://www.hotmail.com
> > > > > > >
> > > > > > > ---
> > > > > > > You are currently subscribed to freetds as: camber AT ais.org
> > > > > > > To unsubscribe, forward this message to
> > > > >$subst('Email.Unsub')
> > > > > > >
> > > > > > >
> > > > > >
> > > > > >
> > > > > > ---
> > > > > > You are currently subscribed to freetds as: camber AT ais.org
> > > > > > To unsubscribe, forward this message to
> > > > >$subst('Email.Unsub')
> > > > > >
> > > > > >
> > > > >
> > > > >
> > > > >---
> > > > >You are currently subscribed to freetds as: vandersilva AT hotmail.com
> > > > >To unsubscribe, forward this message to
> > > > >$subst('Email.Unsub')
> > > > >
> > > >
> > > > ______________________________________________________
> > > > Get Your Private, Free Email at http://www.hotmail.com
> > > >
> > > > ---
> > > > You are currently subscribed to freetds as: camber AT ais.org
> > > > To unsubscribe, forward this message to
> > >$subst('Email.Unsub')
> > > >
> > > >
> > >
> > >
> > >---
> > >You are currently subscribed to freetds as: vandersilva AT hotmail.com
> > >To unsubscribe, forward this message to
> > >$subst('Email.Unsub')
> > >
> > >
> >
> > ______________________________________________________
> > Get Your Private, Free Email at http://www.hotmail.com
> >
> > ---
> > You are currently subscribed to freetds as: camber AT ais.org
> > To unsubscribe, forward this message to $subst('Email.Unsub')
> >
> >
>
>
> ---
> You are currently subscribed to freetds as: richard AT iguana.co.nz
> To unsubscribe, forward this message to $subst('Email.Unsub')
>





Archive powered by MHonArc 2.6.24.

Top of Page