FreeTDS Development Group

["Glenn, Chris" <Glenn AT addsys.com>]

Here is my 'tsql' command;
-----------------------------------------------------
/usr/local/bin/tsql -Usa -Psysadm
locale is "C"
locale charset is "ANSI_X3.4-1968"
1> select db_name()
2> go
Segmentation fault (core dumped)
-----------------------------------------------------


Here is the full log;
-----------------------------------------------------
util.c:292:Starting log file for FreeTDS 0.65.dev.20061129
        on 2006-11-29 15:03:24 with debug flags 0x4fff.
iconv.c:195:names for ISO-8859-1: ISO-8859-1
iconv.c:195:names for UTF-8: UTF-8
iconv.c:195:names for UCS-2LE: UCS-2LE
iconv.c:195:names for UCS-2BE: UCS-2BE
iconv.c:361:iconv to convert client-side data to the "ANSI_X3.4-1968"
character set
iconv.c:514:tds_iconv_info_init: converting "US-ASCII"->"UCS-2LE"
iconv.c:514:tds_iconv_info_init: converting "ISO-8859-1"->"UCS-2LE"
net.c:185:Connecting to 10.3.2.40 port 1433 (TDS version 7.0)
net.c:240:connect(2) failed: 0x73, "Operation now in progress"
net.c:242:Contents of sockaddr_in
0000 02 00 05 99 0a 03 02 28-00 00 00 00 00 00 00 00 |.......( ........|

net.c:243: sockaddr_in: sin_family = 2
                        sin_port = 9905
                        sin_addr.s_addr = 2802030a
                        (param ip_addr) = '10.3.2.40'
write.c:134:tds_put_string converting 8 bytes of "addlinux"
write.c:162:tds_put_string wrote 16 bytes
write.c:134:tds_put_string converting 2 bytes of "sa"
write.c:162:tds_put_string wrote 4 bytes
write.c:134:tds_put_string converting 4 bytes of "TSQL"
write.c:162:tds_put_string wrote 8 bytes
write.c:134:tds_put_string converting 6 bytes of "vmware"
write.c:162:tds_put_string wrote 12 bytes
write.c:134:tds_put_string converting 11 bytes of "TDS-Library"
write.c:162:tds_put_string wrote 22 bytes
write.c:134:tds_put_string converting 10 bytes of "us_english"
write.c:162:tds_put_string wrote 20 bytes
write.c:162:tds_put_string wrote 0 bytes
login.c:791:quietly sending TDS 7.0 login packet
token.c:312:tds_process_login_tokens()
net.c:499:Received header
0000 04 01 01 98 00 35 01 00-                        |.....5..|

net.c:579:Received packet
0000 e3 1b 00 01 06 6d 00 61-00 73 00 74 00 65 00 72 |.....m.a .s.t.e.r|
0010 00 06 6d 00 61 00 73 00-74 00 65 00 72 00 ab 62 |..m.a.s. t.e.r..b|
0020 00 45 16 00 00 02 00 25-00 43 00 68 00 61 00 6e |.E.....% .C.h.a.n|
0030 00 67 00 65 00 64 00 20-00 64 00 61 00 74 00 61 |.g.e.d.  .d.a.t.a|
0040 00 62 00 61 00 73 00 65-00 20 00 63 00 6f 00 6e |.b.a.s.e . .c.o.n|
0050 00 74 00 65 00 78 00 74-00 20 00 74 00 6f 00 20 |.t.e.x.t . .t.o. |
0060 00 27 00 6d 00 61 00 73-00 74 00 65 00 72 00 27 |.'.m.a.s .t.e.r.'|
0070 00 2e 00 06 56 00 4d 00-57 00 41 00 52 00 45 00 |....V.M. W.A.R.E.|
0080 00 01 00 e3 17 00 02 0a-75 00 73 00 5f 00 65 00 |........ u.s._.e.|
0090 6e 00 67 00 6c 00 69 00-73 00 68 00 00 ab 66 00 |n.g.l.i. s.h...f.|
00a0 47 16 00 00 01 00 27 00-43 00 68 00 61 00 6e 00 |G.....'. C.h.a.n.|
00b0 67 00 65 00 64 00 20 00-6c 00 61 00 6e 00 67 00 |g.e.d. . l.a.n.g.|
00c0 75 00 61 00 67 00 65 00-20 00 73 00 65 00 74 00 |u.a.g.e.  .s.e.t.|
00d0 74 00 69 00 6e 00 67 00-20 00 74 00 6f 00 20 00 |t.i.n.g.  .t.o. .|
00e0 75 00 73 00 5f 00 65 00-6e 00 67 00 6c 00 69 00 |u.s._.e. n.g.l.i.|
00f0 73 00 68 00 2e 00 06 56-00 4d 00 57 00 41 00 52 |s.h....V .M.W.A.R|
0100 00 45 00 00 01 00 e3 0f-00 03 05 69 00 73 00 6f |.E...... ...i.s.o|
0110 00 5f 00 31 00 01 00 00-e3 0b 00 05 04 31 00 30 |._.1.... .....1.0|
0120 00 33 00 33 00 00 e3 0f-00 06 06 31 00 39 00 36 |.3.3.... ...1.9.6|
0130 00 36 00 30 00 39 00 00-ad 36 00 01 07 00 00 00 |.6.0.9.. .6......|
0140 16 4d 00 69 00 63 00 72-00 6f 00 73 00 6f 00 66 |.M.i.c.r .o.s.o.f|
0150 00 74 00 20 00 53 00 51-00 4c 00 20 00 53 00 65 |.t. .S.Q .L. .S.e|
0160 00 72 00 76 00 65 00 72-00 00 00 00 00 09 00 05 |.r.v.e.r ........|
0170 77 e3 13 00 04 04 34 00-30 00 39 00 36 00 04 34 |w.....4. 0.9.6..4|
0180 00 30 00 39 00 36 00 fd-00 00 00 00 00 00 00 00 |.0.9.6.. ........|

token.c:316:looking for login token, got  e3(ENVCHANGE)
token.c:107:tds_process_default_tokens() marker is e3(ENVCHANGE)
read.c:179:tds_get_string: reading 12 from wire to give 6 to client.
read.c:179:tds_get_string: reading 12 from wire to give 6 to client.
token.c:316:looking for login token, got  ab(INFO)
token.c:107:tds_process_default_tokens() marker is ab(INFO)
token.c:2408:tds_process_msg() reading message from server
read.c:179:tds_get_string: reading 74 from wire to give 37 to client.
read.c:179:tds_get_string: reading 12 from wire to give 6 to client.
token.c:2473:tds_process_msg() calling client msg handler
token.c:2486:tds_process_msg() returning TDS_SUCCEED
token.c:316:looking for login token, got  e3(ENVCHANGE)
token.c:107:tds_process_default_tokens() marker is e3(ENVCHANGE)
read.c:179:tds_get_string: reading 20 from wire to give 10 to client.
token.c:316:looking for login token, got  ab(INFO)
token.c:107:tds_process_default_tokens() marker is ab(INFO)
token.c:2408:tds_process_msg() reading message from server
read.c:179:tds_get_string: reading 78 from wire to give 39 to client.
read.c:179:tds_get_string: reading 12 from wire to give 6 to client.
token.c:2473:tds_process_msg() calling client msg handler
token.c:2486:tds_process_msg() returning TDS_SUCCEED
token.c:316:looking for login token, got  e3(ENVCHANGE)
token.c:107:tds_process_default_tokens() marker is e3(ENVCHANGE)
read.c:179:tds_get_string: reading 10 from wire to give 5 to client.
read.c:179:tds_get_string: reading 2 from wire to give 1 to client.
iconv.c:514:tds_iconv_info_init: converting "US-ASCII"->"ISO-8859-1"
token.c:316:looking for login token, got  e3(ENVCHANGE)
token.c:107:tds_process_default_tokens() marker is e3(ENVCHANGE)
read.c:179:tds_get_string: reading 8 from wire to give 4 to client.
token.c:316:looking for login token, got  e3(ENVCHANGE)
token.c:107:tds_process_default_tokens() marker is e3(ENVCHANGE)
read.c:179:tds_get_string: reading 12 from wire to give 6 to client.
token.c:316:looking for login token, got  ad(LOGINACK)
read.c:179:tds_get_string: reading 44 from wire to give 22 to client.
token.c:316:looking for login token, got  e3(ENVCHANGE)
token.c:107:tds_process_default_tokens() marker is e3(ENVCHANGE)
read.c:179:tds_get_string: reading 8 from wire to give 4 to client.
read.c:179:tds_get_string: reading 8 from wire to give 4 to client.
token.c:2296:increasing block size from 4096 to 4096
token.c:316:looking for login token, got  fd(DONE)
token.c:107:tds_process_default_tokens() marker is fd(DONE)
token.c:2112:tds_process_end: more_results = 0
                was_cancelled = 0
                error = 0
                done_count_valid = 0
token.c:2128:tds_process_end() state set to TDS_IDLE
util.c:120:Changing query state from IDLE to IDLE
token.c:389:leaving tds_process_login_tokens() returning 1
util.c:120:Changing query state from IDLE to QUERYING
mem.c:565:tds_free_all_results()
write.c:134:tds_put_string converting 19 bytes of "set textsize 64512 "
write.c:162:tds_put_string wrote 38 bytes
util.c:120:Changing query state from QUERYING to PENDING
net.c:724:Sending packet
0000 01 01 00 2e 00 00 00 00-73 00 65 00 74 00 20 00 |........ s.e.t. .|
0010 74 00 65 00 78 00 74 00-73 00 69 00 7a 00 65 00 |t.e.x.t. s.i.z.e.|
0020 20 00 36 00 34 00 35 00-31 00 32 00 20 00       | .6.4.5. 1.2. .|

token.c:519:tds_process_tokens(0x8962228, 0xbfffb424, 0xbfffb428, 0x100)
util.c:120:Changing query state from PENDING to READING
net.c:499:Received header
0000 04 01 00 11 00 35 01 00-                        |.....5..|

net.c:579:Received packet
0000 fd 00 00 be 00 00 00 00-00                      |........ .|

token.c:534:processing result tokens.  marker is  fd(DONE)
token.c:2112:tds_process_end: more_results = 0
                was_cancelled = 0
                error = 0
                done_count_valid = 0
token.c:2128:tds_process_end() state set to TDS_IDLE
util.c:120:Changing query state from READING to IDLE
util.c:120:Changing query state from IDLE to PENDING
token.c:519:tds_process_tokens(0x8962228, 0xbfffb424, 0xbfffb428, 0x100)
token.c:522:tds_process_tokens() state is COMPLETED
-----------------------------------------------------



-----Original Message-----
From: freetds-bounces AT lists.ibiblio.org
[mailto:freetds-bounces AT lists.ibiblio.org] On Behalf Of Lowden, James K
Sent: Wednesday, November 29, 2006 3:01 PM
To: FreeTDS Development Group
Subject: [freetds] snapshot dumps core on RHEL ES release 3

[subject was: IssueconnectingtoSQLServerfromLinuxHostwithnewerversions
ofFreeTDS...]
> From: Glenn, Chris
> Sent: Wednesday, November 29, 2006 2:04 PM
> 
> The new version appears to work correctly.  That is, it connects
> without any error messages.  BUT, when attempting to execute any
> sql commands, it core dumps.

OK!  That's progress.  Let's see what's still broken.  

> If you notice in the log file below, the connect is reporting a
> failure, but it continues on.
...
> ---------------------------------------------------
> net.c:185:Connecting to 10.3.2.40 port 1433 (TDS version 7.0)
> net.c:240:connect(2) failed: 0x73, "Operation now in progress"


I will clean up the message.  It's not really a failure; that return
code is expected on a non-blocking socket.  


> net.c:242:Contents of sockaddr_in
> 0000 02 00 05 99 0a 03 02 28-00 00 00 00 00 00 00 00 |.......(
........|
> 
> net.c:243: sockaddr_in: sin_family = 2
>                         sin_port = 9905
>                         sin_addr.s_addr = 2802030a
>                         (param ip_addr) = '10.3.2.40'
> write.c:134:tds_put_string converting 8 bytes of "addlinux"
> write.c:162:tds_put_string wrote 16 bytes
> write.c:134:tds_put_string converting 2 bytes of "sa"
> write.c:162:tds_put_string wrote 4 bytes
> write.c:134:tds_put_string converting 4 bytes of "TSQL"
> write.c:162:tds_put_string wrote 8 bytes
> ...
> ---------------------------------------------------

Unfortunately it seems you trimmed off the interesting part.  :-(  Post
the whole log if you would.  It may tell us something.  

The other thing you might do is run tsql under gdb and show us the
backtrace.  

One more thing.  I changed tsql recently and that could be the problem.
Please try your query with bsqldb, too.  (You can use ldd(1) to make
sure it's using the right library.) 

Thanks.  I'm hoping your system is some kind of canary that will help us
find errors.  

--jkl

-----------------------------------------
The information contained in this transmission may be privileged and
confidential and is intended only for the use of the person(s) named
above. If you are not the intended recipient, or an employee or agent
responsible
for delivering this message to the intended recipient, any review,
dissemination,
distribution or duplication of this communication is strictly
prohibited. If you are
not the intended recipient, please contact the sender immediately by
reply e-mail
and destroy all copies of the original message. Please note that we do
not accept
account orders and/or instructions by e-mail, and therefore will not be
responsible
for carrying out such orders and/or instructions.  If you, as the
intended recipient
of this message, the purpose of which is to inform and update our
clients, prospects
and consultants of developments relating to our services and products,
would not
like to receive further e-mail correspondence from the sender, please
"reply" to the
sender indicating your wishes.  In the U.S.: 1345 Avenue of the
Americas, New York,
NY 10105.
_______________________________________________
FreeTDS mailing list
FreeTDS AT lists.ibiblio.org
http://lists.ibiblio.org/mailman/listinfo/freetds