Skip to Content.
Sympa Menu

freetds - AW: AW: [freetds] connect problem to mssql 7.0

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "roland bole" <roland.bole AT gmx.at>
  • To: "'FreeTDS Development Group'" <freetds AT lists.ibiblio.org>
  • Subject: AW: AW: [freetds] connect problem to mssql 7.0
  • Date: Sat, 6 Dec 2003 20:12:41 +0100



...
>
> I freddy77 i did an update.
>
> But my problems are still the same.
>
> Let me give you short discribtion.
>
> I uses persitent connection with php to connect to an mssql 7.0 server
from
> a debian box.
>
> Freetds works perfect for sometimes, but if I do for ca. 5 6 minutes
nothing
> the connection is dead and the dumpfile ist full of the following ....
> ---
> 2003-12-06 07:18:42 leaving tds_process_default_tokens() connection dead
> 2003-12-06 07:18:42 inside tds_process_default_tokens() marker is 0
> ----
>

>>It would be interesting to see some rows before these... What's last
>>command? Perhaps there is some mssql configuration that disconnect too
>>lazy processes??


> After a restart from the apache server it works again, until the next
break.
>
> I use apache 1.3.26 and php 4.3.4
>
> i build freetds: ./configure --enable-msdblib
>
> What can I do, is there any timeout from the mssql server?
>
>
> Please help, I have to solve this problem very quickly.
>
> Roland


freddy77



ok,

Here is one dump short befor the error occurred
-------
2003-12-06 20:00:57 dbdatlen() type = 39
2003-12-06 20:00:57 leaving dbdatlen() returning 11
2003-12-06 20:00:57 inside dbnextrow()
2003-12-06 20:00:57 processing row tokens. marker is fd
2003-12-06 20:00:57 leaving dbnextrow() returning -2
2003-12-06 20:02:04 UNIMPLEMENTED dbsetlogintime()
2003-12-06 20:02:04 UNIMPLEMENTED dbsettime()
2003-12-06 20:02:04 UNIMPLEMENTED dbsetmaxprocs()
Sending packet @ 2003-12-06 20:02:04
0000 01 01 00 18 00 00 01 00 75 00 73 00 65 00 20 00 |........u .s.e. .|
0010 45 00 4c 00 42 00 45 00 |E.L.B.E.|


TDS: Write failed in tds_write_packet
Error: 104 (Connection reset by peer)
2003-12-06 20:02:04 inside tds_process_default_tokens() marker is 0
2003-12-06 20:02:04 leaving tds_process_default_tokens() connection dead
2003-12-06 20:02:04 inside tds_process_default_tokens() marker is 0
2003-12-06 20:02:04 leaving tds_process_default_tokens() connection dead

--------------------

Roland

_______________________________________________
FreeTDS mailing list
FreeTDS AT lists.ibiblio.org
http://lists.ibiblio.org/mailman/listinfo/freetds







Archive powered by MHonArc 2.6.24.

Top of Page