[freetds] Data-conversion resulted in overflow on image column

John Gilmore-Baldwin jbaldwin at theolympian.com
Wed Apr 5 18:55:46 EDT 2006


Bill,

Below the rest of the log information I think you were looking for. If you
need more, let me know.

I see a "convert failed for 11" message in the log info.

I seem to recall using DBD::Sybase and freetds to pull bigger chunks of blob
data out of a database before (well over a megabyte, I think).

All I really need to do is write the field out to a file. So perhaps there's
another way to do that I'm not thinking of.

Thanks for responding,
John



23:47:24.450184 swapping coltype 34
23:47:24.450218 inside ct_fetch()process_row_tokens returned 1
23:47:24.450246 _ct_bind_data()
23:47:24.450271 _ct_bind_data(): column_type: 34 column_len: 64512
23:47:24.450297 _ct_get_server_type(16)
23:47:24.450323 _ct_get_client_type(type 34, user 0, size 64512)
23:47:24.450350 cs_convert()
23:47:24.450375 _ct_get_server_type(11)
23:47:24.450399 _ct_get_server_type(16)
23:47:24.450424 cs_convert() srctype = 34 (64512) desttype = 35 (64512)
23:47:24.450451 cs_convert() calling tds_convert
23:47:24.452384 cs_convert() tds_convert returned 129024
23:47:24.453389 cs_convert() returning  0
23:47:24.453472 cs_convert-result = 1
23:47:24.453501 
  convert failed for 11
23:47:24.453529 ct_fetch()
23:47:24.453557 ct_results()
23:47:24.453584 processing result tokens.  marker is  fd(DONE)
23:47:24.453614 tds_process_end: more_results = 0
        was_cancelled = 0
        error = 0
        done_count_valid = 1
23:47:24.453641 tds_process_end() state set to TDS_IDLE
23:47:24.453665                 rows_affected = 1
23:47:24.453690 ct_results() process_result_tokens returned 1 (type 4052)
23:47:24.453716 ct_results() results state = 2
23:47:24.453742 ct_res_info()
23:47:24.453766 ct_res_info(): Number of rows is 1
23:47:24.453791 ct_results()
23:47:24.453815 tds_process_result_tokens() state is COMPLETED
23:47:24.453839 ct_results() process_result_tokens returned 2 (type 4052)
23:47:24.454005 ct_cmd_drop()
23:47:24.454126 ct_fetch()
23:47:24.454163 ct_results()
23:47:24.454190 processing result tokens.  marker is  fd(DONE)
23:47:24.454217 tds_process_end: more_results = 0
        was_cancelled = 0
        error = 0
        done_count_valid = 1
23:47:24.454588 tds_process_end() state set to TDS_IDLE
23:47:24.454632                 rows_affected = 1
23:47:24.454716 ct_results() process_result_tokens returned 1 (type 4052)
23:47:24.454747 ct_results() results state = 2
23:47:24.454773 ct_res_info()
23:47:24.454798 ct_res_info(): Number of rows is 1
23:47:24.454918 ct_results()
23:47:24.454953 tds_process_result_tokens() state is COMPLETED
23:47:24.454978 ct_results() process_result_tokens returned 2 (type 4052)
23:47:24.455113 ct_cmd_drop()
23:47:24.455714 ct_cmd_alloc()
23:47:24.455786 ct_command()
23:47:24.455819 ct_send()
23:47:24.455847 tds_free_all_results()



On 4/5/06 2:14 AM, "Thompson, Bill D (London)" <bill_d_thompson at ml.com>
wrote:

> Hi,
> 
> There should be some more log file after this...
> after the dump of the header and data received...
> 
> There would be two possibilities I would think.
> 
> 1) we have a bug, as yet unidentified.
> 2) the calling program (perl/DBD::Sybase) hasn't allocated enough space to
> receive the data (64k)
> 
> Naturally I'm assuming the latter...
> 
> Bill
> 
> 



More information about the FreeTDS mailing list