Skip to Content.
Sympa Menu

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

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: John Gilmore-Baldwin <jbaldwin AT theolympian.com>
  • To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
  • Subject: Re: [freetds] Data-conversion resulted in overflow on image column
  • Date: Wed, 05 Apr 2006 14:55:46 -0800

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
>
>





Archive powered by MHonArc 2.6.24.

Top of Page