"SET FMTONLY ON select .." locks table
Yavuz Gökırmak <[email protected]>
| Newsgroups | gmane.comp.db.tds.freetds |
|---|---|
| Message-ID | <CAE+4NLbzyWdeLBoZg25ieefafYU=PU8VRZXx9j2oNLTQ0z7odg@mail.gmail.com> |
Hi all, I am using freetds to do bulk load from linux to mssql, it is interesting that we get some problem during "SET FMTONLY ON.." query, it is just getting table columns but somehow it gets the table lock and blocks other bulk load operations.. do you have any idea, is it possible to disable this "set fmtonly" query and give table column names manually instead.. regards. dblib.c:1369:dbsqlexec(0xaba400) dblib.c:6862:dbsqlsend(0xaba400) mem.c:615:tds_free_all_results() util.c:156:Changed query state from IDLE to QUERYING write.c:139:tds_put_string converting 73 bytes of "SET FMTONLY ON select * from clickstream.dbo.clicks_t SET FMTONLY OFF" write.c:167:tds_put_string wrote 146 bytes util.c:156:Changed query state from QUERYING to PENDING net.c:743:Sending packet 0000 01 01 00 9a 00 00 01 00-53 00 45 00 54 00 20 00 |........ S.E.T. .| 0010 46 00 4d 00 54 00 4f 00-4e 00 4c 00 59 00 20 00 |F.M.T.O. N.L.Y. .| 0020 4f 00 4e 00 20 00 73 00-65 00 6c 00 65 00 63 00 |O.N. .s. e.l.e.c.| 0030 74 00 20 00 2a 00 20 00-66 00 72 00 6f 00 6d 00 |t. .*. . f.r.o.m.| 0040 20 00 65 00 76 00 61 00-6d 00 63 00 6c 00 69 00 | .......... ..c.l.i.| 0050 63 00 6b 00 73 00 74 00-72 00 65 00 61 00 6d 00 |c.k.s.t. r.e.a.m.| 0060 2e 00 64 00 62 00 6f 00-2e 00 63 00 6c 00 69 00 |..d.b.o. ..c.l.i.| 0070 63 00 6b 00 73 00 5f 00-74 00 20 00 53 00 45 00 |c.k.s._. t. .S.E.| 0080 54 00 20 00 46 00 4d 00-54 00 4f 00 4e 00 4c 00 |T. .F.M. T.O.N.L.| 0090 59 00 20 00 4f 00 46 00-46 00 |Y. .O.F. F.| dblib.c:4639:dbsqlok(0xaba400) dblib.c:4669:dbsqlok() not done, calling tds_process_tokens() token.c:540:tds_process_tokens(0xabaee0, 0x7ffff1375b30, 0x7ffff1375b34, 0x6914) util.c:156:Changed query state from PENDING to READING -- Yavuz Gökırmak Co-Founder & Chief Data Architect Infoowl Software Solutions & Consultancy [email protected] +90 530 420 00 59 www.infoowl.net _______________________________________________ FreeTDS mailing list [email protected] http://lists.ibiblio.org/mailman/listinfo/freetds