Skip to Content.
Sympa Menu

freetds - [freetds] php query not terminating (?)

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Guillaume Luszack <guillaume.luszack AT inrp.fr>
  • To: freetds AT lists.ibiblio.org
  • Subject: [freetds] php query not terminating (?)
  • Date: Fri, 01 Dec 2006 10:32:56 +0100

Hello,

I have installed Freetds 0.64 on PHP-5.0.4 and Apache 2. It seems to be
installed correctly
since I can connect to the MSSQL server and select a database.

I have the following script :
<?php
$ms_id =mssql_connect("server","user","pw");
mssql_select_db("database", $ms_id);
$sqlldap = "select dn, uid from meta_annuaire;";
$resldap = mssql_query($sqlldap);
mssql_close($ms_id);
?>

In the Freetds logfile I can see that I have the "received packet" with the
data from my query.
I also have the following lines (shortened here) : dbsqlok, dbresults,
tds_free_all_results,
processing TDS7 result, then 2 * adjust_character_column_size and
tds7_get_data_info

So I would say that everything seems to be ok till here. But then I have this
:

09:56:37.572354 14259 (token.c:526):processing result tokens. marker is
d1(ROW)
09:56:37.572374 14259 (util.c:119):Changing query state from READING to
PENDING
09:56:37.572393 14259 (dblib.c:1196):dbresults() process_result_tokens returned result_type = 4040 retcode = 1
09:56:37.572417 14259 (dblib.c:1433):dbnextrow()
09:56:37.572437 14259 (dblib.c:1447):dbnextrow() dbresults_state = 2
09:56:37.572457 14259 (util.c:119):Changing query state from PENDING to
READING
09:56:37.572476 14259 (token.c:526):processing result tokens. marker is
d1(ROW)
09:56:37.572496 14259 (token.c:1863):tds_get_data: column 0, type 39, varint
size 2
09:56:37.572516 14259 (token.c:1920):processing row. column size is 33
09:56:37.572564 14259 (token.c:1863):tds_get_data: column 1, type 39, varint
size 2
09:56:37.572585 14259 (token.c:1920):processing row. column size is 5
09:56:37.572606 14259 (util.c:119):Changing query state from READING to
PENDING
09:56:37.572628 14259 (dblib.c:1509):leaving dbnextrow() returning -1
09:56:37.572656 14259 (dblib.c:2480):dbdatlen() type = 39
09:56:37.572676 14259 (dblib.c:2486):leaving dbdatlen() returning 33
09:56:37.572705 14259 (dblib.c:2480):dbdatlen() type = 39
09:56:37.572724 14259 (dblib.c:2486):leaving dbdatlen() returning 33
09:56:37.572746 14259 (dblib.c:2480):dbdatlen() type = 39
09:56:37.572765 14259 (dblib.c:2486):leaving dbdatlen() returning 5
09:56:37.572784 14259 (dblib.c:2480):dbdatlen() type = 39
09:56:37.572803 14259 (dblib.c:2486):leaving dbdatlen() returning 5
09:56:37.572822 14259 (dblib.c:1433):dbnextrow()
09:56:37.572841 14259 (dblib.c:1447):dbnextrow() dbresults_state = 2
09:56:37.572862 14259 (util.c:119):Changing query state from PENDING to
READING
09:56:37.572881 14259 (token.c:526):processing result tokens. marker is
d1(ROW)
09:56:37.572900 14259 (token.c:1863):tds_get_data: column 0, type 39, varint
size 2
09:56:37.572920 14259 (token.c:1920):processing row. column size is 34
09:56:37.572941 14259 (token.c:1863):tds_get_data: column 1, type 39, varint
size 2
09:56:37.572961 14259 (token.c:1920):processing row. column size is 6
09:56:37.572983 14259 (util.c:119):Changing query state from READING to
PENDING
09:56:37.573004 14259 (dblib.c:1509):leaving dbnextrow() returning -1
09:56:37.573025 14259 (dblib.c:2480):dbdatlen() type = 39
09:56:37.573044 14259 (dblib.c:2486):leaving dbdatlen() returning 34
09:56:37.573063 14259 (dblib.c:2480):dbdatlen() type = 39
09:56:37.573082 14259 (dblib.c:2486):leaving dbdatlen() returning 34
09:56:37.573102 14259 (dblib.c:2480):dbdatlen() type = 39
09:56:37.573121 14259 (dblib.c:2486):leaving dbdatlen() returning 6
09:56:37.573140 14259 (dblib.c:2480):dbdatlen() type = 39
09:56:37.573159 14259 (dblib.c:2486):leaving dbdatlen() returning 6
09:56:37.573179 14259 (dblib.c:1433):dbnextrow()
[09:56:37.573198 14259 (dblib.c:1447):dbnextrow() dbresults_state = 2
09:56:37.573217 14259 (dblib.c:1509):leaving dbnextrow() returning -3
09:56:37.573237 14259 (dblib.c:2480):dbdatlen() type = 39
09:56:37.573257 14259 (dblib.c:2486):leaving dbdatlen() returning 34
09:56:37.573276 14259 (dblib.c:2480):dbdatlen() type = 39
09:56:37.573295 14259 (dblib.c:2486):leaving dbdatlen() returning 34
09:56:37.573315 14259 (dblib.c:2480):dbdatlen() type = 39
09:56:37.573334 14259 (dblib.c:2486):leaving dbdatlen() returning 6
09:56:37.573354 14259 (dblib.c:2480):dbdatlen() type = 39
09:56:37.573373 14259 (dblib.c:2486):leaving dbdatlen() returning 6
09:56:37.573411 14259 (dblib.c:1433):dbnextrow()]

which seems to work fine at first but the lines between [...] repeat
themselves endlessly.

Does anybody have an idea about the cause / solution for this ??

Thanks a lot !
G.


--
Guillaume LUSZACK
Service Commun Informatique de l'INRP
+33 (4) 72 76 61 50

begin:vcard
fn:Guillaume Luszack
n:Luszack;Guillaume
org:INRP;Service Informatique Commun
adr;quoted-printable:;;all=C3=A9e de Fontenay;Lyon;;69007;France
email;internet:guillaume.luszack AT inrp.fr
title:Admin SI
tel;work:0472766150
x-mozilla-html:FALSE
url:http://www.inrp.fr
version:2.1
end:vcard



  • [freetds] php query not terminating (?), Guillaume Luszack, 12/01/2006

Archive powered by MHonArc 2.6.24.

Top of Page