FreeTDS Development Group

["ZIGLIO, Frediano, VF-IT" <Frediano.Ziglio AT vodafone.com>]

> 
> Hello, iam using dblib to work with stored procedures and i 
> get seg fault while running dbrpcparam-dbsqlsend-dbsqlok and 
> so. Logs show that info :
> 

Hi,
  sorry for late reply. It seems you are callng a
"Telviso_ValidaSaldoTarjetaAni" procedure that require 6 parameters. 

> 17:46:40.178147 dbsqlok() marker is e3
> 17:46:40.178158 processing result tokens.  marker is  e3(ENVCHANGE)
> 17:46:40.178168 tds_process_default_tokens() marker is e3(ENVCHANGE)
> 17:46:40.178177 tds_get_string: reading 20 from wire to give 
> 10 to client.
> 17:46:40.178190 tds_get_string: reading 20 from wire to give 
> 10 to client.
> 17:46:40.178202 processing result tokens.  marker is  ab(INFO)
> 17:46:40.178211 tds_process_default_tokens() marker is ab(INFO)
> 17:46:40.178222 tds_get_string: reading 82 from wire to give 
> 41 to client.
> 17:46:40.178233 tds_get_string: reading 12 from wire to give 
> 6 to client.
> 17:46:40.178245 processing result tokens.  marker is  e3(ENVCHANGE)
> 17:46:40.178263 tds_process_default_tokens() marker is e3(ENVCHANGE)
> 17:46:40.178277 processing result tokens.  marker is  fd(DONE)
> 17:46:40.178286 tds_process_end: more_results = 0
>                 was_cancelled = 0
>                 error = 0
>                 done_count_valid = 0
> 17:46:40.178295 tds_process_end() state set to TDS_IDLE
> 17:46:40.178304 dbsqlok() end status was success
> 17:46:40.178315 dbresults()
> 17:46:40.178327 tds_process_row_tokens() state is COMPLETED
> 17:46:40.178399 dbrpcinit() added rpcname 
> "Telviso_ValidaSaldoTarjetaAni"
> 17:46:40.178450 dbrpcparam() added parameter "@devuelve"
> 17:46:40.178461 dbrpcparam() added parameter "@tarjeta"
> 17:46:40.178471 dbrpcparam() added parameter "@ani"
> 17:46:40.178481 dbrpcparam() added parameter "@estado"
> 17:46:40.178490 dbrpcparam() added parameter "@saldo"
> 17:46:40.178498 dbrpcparam() added parameter "@cliente"

Here are 6 parameters.

> 17:46:40.178507 dbrpcsend()
> 17:46:40.178519 parm_info_alloc(): parameter null-ness = 0
> 17:46:40.178531 param_row_alloc, size = 4, offset = 4, row_size = 8
> 17:46:40.178541 param_row_alloc(): doing data from value
> 17:46:40.178549 param_row_alloc(): setting parameter #0 to NULL
> 17:46:40.178558 setting column 0 NULL bit

1

> 17:46:40.178567 parm_info_alloc(): parameter null-ness = 0
> 17:46:40.178580 param_row_alloc, size = 80, offset = 8, row_size = 88
> 17:46:40.178590 param_row_alloc(): doing data from value
> 17:46:40.178598 param_row_alloc(): copying 80 bytes of data 
> to parameter #1

2

> 17:46:40.178608 parm_info_alloc(): parameter null-ness = 0
> 17:46:40.178619 param_row_alloc, size = 80, offset = 88, 
> row_size = 168
> 17:46:40.178628 param_row_alloc(): doing data from value
> 17:46:40.178636 param_row_alloc(): copying 80 bytes of data 
> to parameter #2

3

> 17:46:40.178651 parm_info_alloc(): parameter null-ness = 0
> 17:46:40.178665 param_row_alloc, size = 4, offset = 168, 
> row_size = 172
> 17:46:40.178675 param_row_alloc(): doing data from value
> 17:46:40.178683 param_row_alloc(): copying 4 bytes of data to 
> parameter #3

4

> 17:46:40.178693 parm_info_alloc(): parameter null-ness = 0
> 17:46:40.178703 param_row_alloc, size = 8, offset = 172, 
> row_size = 180
> 17:46:40.178713 param_row_alloc(): doing data from value
> 17:46:40.178721 param_row_alloc(): copying 8 bytes of data to 
> parameter #4

5

> 17:46:40.178730 parm_info_alloc(): parameter null-ness = 0
> 17:46:40.178741 param_row_alloc, size = 4, offset = 180, 
> row_size = 184
> 17:46:40.178751 param_row_alloc(): doing data from value
> 17:46:40.178759 param_row_alloc(): copying 4 bytes of data to 
> parameter #5

6 (last)

> 17:46:40.178768 tds_free_all_results()
> 17:46:40.178779 tds_put_data_info putting param_name
> 17:46:40.178790 tds_put_data_info putting status
> 17:46:40.178799 tds_put_data: is_null = 1, colsize = 4
> 17:46:40.178808 tds_put_data: null param
> 

It could be a problem with nulls. Which FreeTDS version are you using?
Could you try to repeat test with first parameter only? Or just post
first two dbrpcparam calls.

> 
> Anyone can tell me what means and what is wrong if it is the 
> case?...thanks

bye
  freddy77