FreeTDS Development Group

[Jerry Grooms <grooms AT uky.edu>]

DB: MS-SQL Server
TDS VERSION = 7.0
OS: HPUX 11.11

I recently updated a DBD::Sybase installation to 0.95 and with
FreeTDS 0.53 ran into the unresolved external cs_ctx_global link
problem.  With suggestions from the list/archives, I upgraded to
FreeTDS 0.60 snapshot (not release!) to fix the problem.

Everything seemed to pretty much work ok until I ran into a
consistent seg fault when calling a stored procedure while passing
args (calling stored procedures without args seemed ok).

I enabled tracing and noticed "ct_res_info() returning a non-sensical
number for columns (transcript 1 below) before turning toes up.

After the required pounding of the forehead, I backed down to FTDS
0.53 and voila, no more problem (transcript 2 below).

I have skimmed through the volume of past list messages and wasn't
sure whether this is a known problem that has been addressed; if so,
accept my apologies for missing it.  

Jerry


------- Start of forwarded message -------  FreeTDS 0.60 snapshot DBD:Sybase 
0.95


    DBI::db=HASH(0x401bf71c) trace level set to 2 in DBI 1.30-nothread
    Note: perl is running without the recommended perl -w option
debug: before do()
    -> do for DBD::Sybase::db (DBI::db=HASH(0x401c33a0)~0x401bf71c 'exec 
pTest 'DX','parm','I',0')
1   -> prepare for DBD::Sybase::db (DBI::db=HASH(0x401bf71c)~INNER 'exec 
pTest 'DX','parm','I',0' undef)
1   <- prepare= DBI::st=HASH(0x401c33d0) at Sybase.pm line 131
    -> execute for DBD::Sybase::st (DBI::st=HASH(0x401c33d0)~0x401c3490)
    syb_st_execute() -> ct_command() OK
    syb_st_execute() -> ct_send() OK
    st_next_result() -> ct_results(12) == 1
    st_next_result() -> ct_results(12) == 1
...repeats
    st_next_result() -> ct_results(4043) == 1
    ct_res_info() returns 19809 columns
Segmentation fault

------- End of forwarded message ------- 

------- Start of forwarded message ------- FreeTDS 0.53  DBD:Sybase 0.95 
(patched)


    DBI::db=HASH(0x80bd93c) trace level set to 3 in DBI 1.20-nothread
debug: before do()
    -> do for DBD::Sybase::db (DBI::db=HASH(0x814344c)~0x80bd93c 'exec pTest 
'DX','parm','I',0')
2   -> prepare for DBD::Sybase::db (DBI::db=HASH(0x80bd93c)~INNER 'exec pTest 
'DX','parm','I',0' undef)
    dbih_setup_handle(DBI::st=HASH(0x8143470)=>DBI::st=HASH(0x80c6a34), 
DBD::Sybase::st, 814347c, Null!)
    dbih_make_com(DBI::db=HASH(0x80bd93c), DBD::Sybase::st, 396)
2   <- prepare= DBI::st=HASH(0x8143470) at Sybase.pm line 131
    -> execute for DBD::Sybase::st (DBI::st=HASH(0x8143470)~0x80c6a34)
    syb_st_execute() -> ct_command() OK
    syb_st_execute() -> ct_send() OK
    st_next_result() -> ct_results(12) == 1
ct_results() final retcode = 15
    st_next_result() -> lasterr = 0, lastsev = 0
    syb_st_execute() -> got CS_CMD_DONE: resetting ACTIVE, moreResults, 
dyn_execed
    <- execute= 1 at Sybase.pm line 132
    -> err in DBD::_::common for DBD::Sybase::st 
(DBI::st=HASH(0x8143470)~0x80c6a34)
    <- err= undef at Sybase.pm line 133
    -> rows for DBD::Sybase::st (DBI::st=HASH(0x8143470)~0x80c6a34)
    <- rows= 1 at Sybase.pm line 134
    -> FETCH for DBD::Sybase::st (DBI::st=HASH(0x80c6a34)~INNER 
'syb_more_results')
    .. FETCH DBI::st=HASH(0x80c6a34) 'syb_more_results' = undef
    <- FETCH= undef at Sybase.pm line 135
    <- do= 1 at simple_mpd.pl line 71
    -> DESTROY for DBD::Sybase::st (DBI::st=HASH(0x80c6a34)~INNER)
    syb_st_destroy: called on 81460e8...
    syb_st_destroy(): freeing imp_sth->statement
    syb_st_destroy(): cmd dropped: 1
    <- DESTROY= undef at simple_mpd.pl line 73
debug: after do()
    -> disconnect for DBD::Sybase::db (DBI::db=HASH(0x814344c)~0x80bd93c)
    syb_db_disconnect() -> ct_close()
    <- disconnect= 1 at simple_mpd.pl line 75
    -> DESTROY for DBD::Sybase::db (DBI::db=HASH(0x80bd93c)~INNER)
    <- DESTROY= undef